Database Editing 101

This guide will walk you through how to edit attributes, statistics, and anything else you'd like using a database editor. This can be used to change player attributes, your coach level and skills, historical data, etc.

Database Editing 101

Want to change your offensive and defensive playstyle midway through your career? Wish you could change someone's stats to max? Using the power of database editing, you can change almost anything you want. Do this at your own risk, editing a database directly can cause serious issues with your save.

Prerequisites

To make edits to your game save, you first need to have something that can open up a DB file. I recommend using something like DB Browser for SQLite. You can find that here[sqlitebrowser.org].

Once installed, navigate to your appdata folder to locate your save. An easy way to access that is by typin in %appdata% into your Windows search bar. The folder should be in Users > USERNAME > AppData > Roaming > football-coach-2022.

If you have multiple saves, you can determine which one you want to edit by looking for the file size that matches what you see when selecting your save.

Editing

Drag the DB file into your DB editor of choice. For this, I'll use DB Browser for SQLite as an example. Below, you'll see an image of what you'll see. I've highlighted a few of the useful tables.



To find a specific coach or player, you can go into either the Player or Coach table to look up their unique ID. Simply type in their name in the filter area.



Using this, you can then go into CoachAtributes, Player Attributes, or wherever else, and use this to find what you'd like to edit. Note that historical information will also be displayed. In this example, you can see the attributes and data for Connor Henson from both the 2022 and 2023 season.



To save your changes, click on Write Changes.

Changing Coach Gameplan

Find your coach within the Coach table.



Replace the cells underneath offenseGamePlanTemplateJson and defenseGamePlanTemplateJson for your coach with any of the following.

Offense

Balanced / Balanced

{"formationsTemplateId":"balanced","categoriesTemplateId":"balanced"}

Balanced / Pass First

{"formationsTemplateId":"balanced","categoriesTemplateId":"pass-first"}

Balanced / Run First

{"formationsTemplateId":"balanced","categoriesTemplateId":"run-first"}

Pro-Style / Balanced

{"formationsTemplateId":"pro-style","categoriesTemplateId":"balanced"}

Pro-Style / Pass First

{"formationsTemplateId":"pro-style","categoriesTemplateId":"pass-first"}

Pro-Style / Run First

{"formationsTemplateId":"pro-style","categoriesTemplateId":"run-first"}

Spread / Balanced

{"formationsTemplateId":"spread","categoriesTemplateId":"balanced"}

Spread / Pass First

{"formationsTemplateId":"spread","categoriesTemplateId":"pass-first"}

Spread / Run-First

{"formationsTemplateId":"spread","categoriesTemplateId":"run-first"}

Defense

3-4 / Aggressive Man

{"formationsTemplateId":"3-4","categoriesTemplateId":"aggressive-man"}

3-4 / Aggressive Zone

{"formationsTemplateId":"3-4","categoriesTemplateId":"aggressive-zone"}

3-4 / Balanced Man

{"formationsTemplateId":"3-4","categoriesTemplateId":"balanced-man"}

3-4 / Balanced Zone

{"formationsTemplateId":"3-4","categoriesTemplateId":"balanced-zone"}

3-4 / Conservative Man

{"formationsTemplateId":"3-4","categoriesTemplateId":"conservative-man"}

3-4 / Conservative Zone

{"formationsTemplateId":"3-4","categoriesTemplateId":"conservative-zone"}

4-3 / Aggressive Man

{"formationsTemplateId":"4-3","categoriesTemplateId":"aggressive-man"}

4-3 / Aggressive Zone

{"formationsTemplateId":"4-3","categoriesTemplateId":"aggressive-zone"}

4-3 / Balanced Man

{"formationsTemplateId":"4-3","categoriesTemplateId":"balanced-man"}

4-3 / Balanced Zone

{"formationsTemplateId":"4-3","categoriesTemplateId":"balanced-zone"}

4-3 / Conservative Man

{"formationsTemplateId":"4-3","categoriesTemplateId":"conservative-man"}

4-3 / Conservative Zone

{"formationsTemplateId":"4-3","categoriesTemplateId":"conservative-zone"}

4-4 Split / Aggressive Man

{"formationsTemplateId":"4-4-split","categoriesTemplateId":"aggressive-man"}

4-4 Split / Aggressive Zone

{"formationsTemplateId":"4-4-split","categoriesTemplateId":"aggressive-zone"}

4-4 Split / Balanced Man

{"formationsTemplateId":"4-4-split","categoriesTemplateId":"balanced-man"}

4-4 Split / Balanced Zone

{"formationsTemplateId":"4-4-split","categoriesTemplateId":"balanced-zone"}

4-4 Split / Conservative Man

{"formationsTemplateId":"4-4-split","categoriesTemplateId":"conservative-man"}

4-4 Split / Conservative Zone

{"formationsTemplateId":"4-4-split","categoriesTemplateId":"conservative-zone"}

Nickel / Aggressive Man

{"formationsTemplateId":"nickel","categoriesTemplateId":"aggressive-man"}

Nickel / Aggressive Zone

{"formationsTemplateId":"nickel","categoriesTemplateId":"aggressive-zone"}

Nickel / Balanced Man

{"formationsTemplateId":"nickel","categoriesTemplateId":"balanced-man"}

Nickel / Balanced Zone

{"formationsTemplateId":"nickel","categoriesTemplateId":"balanced-zone"}

Nickel / Conservative Man

{"formationsTemplateId":"nickel","categoriesTemplateId":"conservative-man"}

Nickel / Conservative Zone

{"formationsTemplateId":"nickel","categoriesTemplateId":"conservative-zone"}

Editing Players

Much like coaches, you can also edit a player. Find the ID in the Player table, and then, using this, find the player again in the PlayerAttributes table. You can edit any of the stats present within the game, as well as see the specific numeric value for both your player's durability and potential.

[Bastia]

tip for recruiting

Go to 'Execute SQL' tab and enter this query to find all the Offensive Line recruits sorted by rating. Gems are indicated in the last column. Change the query to match your specific needs. I used the primary stats for OL and divided by the number of stats to arrive at the rating. You can do this for each position by changing the fields in the SELECT line accordingly. No JUCO and C+ or better.

SELECT PRD.playerId, P.firstName, P.lastName, PRD.stars, (PA.strength + PA.runBlocking + PA.passBlocking)/3 AS rating, PA.potential, PA.durability, P.position, P.archetype, PA.speed, PA.strength, PA.runBlocking, PA.passBlocking,
CASE
WHEN PRD.metaJson = '{"gem":true}' THEN 'GEM'
ELSE ''
END AS Gems
FROM PlayerRecruitDetails PRD
JOIN Player P ON PRD.playerId = P.id
JOIN PlayerAttributes PA ON PRD.playerId = PA.playerId
WHERE PRD.year = 2027 AND PRD.position = 'OL' AND PRD.isJuco != 1 AND PA.potential >= 75 AND PA.durability >= 75
ORDER BY rating DESC

[ao694013]

A note on editing player / coach attributes. The game really doesn't like it if you do it outside of the season gains week of the pre-season (I forget the exact name, but basically the screen that shows attribute gains for the off season). If you do it outside of this week, the game will bug out and not let you advance to the next week, even if you revert your changes. I've lost two multi-season coach careers this way before narrowing it down.

[ralf]

You’ll have to look around a bit. The file location may have moved. I’ll take a look later on and confirm the location.

[vmal]

How do you find the db file to edit? I tried the appdata-roaming-football-coach-2022 path but nothing happened.

[ralf]

Make sure that you're dragging the file, not the folder.

[lholm12248]

When I drag the football-coach 2022 folder into the DB for SQL screen I am greeted by the message cannot open invalid format ???? Help ????

[Swisspike]

I appreciate the level of effort here.

Not anything I would use, but someone VERY interested in a exact starting point for college football could recreate the universe..all 7,000 plus players.