--- title: Decoding the Game.db description: Learn how to understand and decode the Game.db file for your Conan Exiles server hosted with Nodecraft! source: "https://nodecraft.com/support/games/conan-exiles/decoding-the-game-db" image: "https://dynamic-assets.nodecraft.com/signedurl/w7vokBAexMnVlnMZ1Q/image.jpg?modifications=W3sibmFtZSI6ImdhbWVfYmciLCJpbWFnZV91cmwiOiJodHRwczovL2Ntcy1hLm5vZGVjcmFmdC5jb20vZi8xMzM5MzIvMjAwMHg1NTAvNjM3ZTM2YWUzMC9jb25hbi1sYW5kaW5nLTEtMi0wLnBuZy9tLyJ9LHsibmFtZSI6ImdhbWVfbG9nbyIsImltYWdlX3VybCI6Imh0dHBzOi8vY21zLWEubm9kZWNyYWZ0LmNvbS9mLzEzMzkzMi81MDB4MTQ3L2JmZGM1MGQ4MzQvbG9nby5wbmcvbS8ifSx7Im5hbWUiOiJjdGFfdGV4dCIsInRleHQiOiJDcmVhdGUgeW91ciBvd24gc2VydmVyISJ9LHsibmFtZSI6InRleHQiLCJ0ZXh0IjoiRGVjb2RpbmcgdGhlIEdhbWUuZGIifV0&s=aa03bb9e67a714d20fe41a600d078b1c63d1162a8ad91dcd5c5b546676c398ea" published: "2018-06-09T19:22:54.074Z" updated: "2019-01-14T21:28:00.000Z" --- # Decoding the Game.db Learn how to understand and decode the Game.db file for your Conan Exiles server hosted with Nodecraft! All save game information for Conan Exiles is saved in a single file, in the form of an SQLite database The database can be opened and viewed with any SQLite compatible reader. The file is normally in /ConanSandbox/Saved, and is titled "game.db". The database contains the following tables: - `account` - `actor\_bounding\_box` - `actor_position` - `buildable_health` - `building_instances` - `buildings` - `character_stats` - `characters` - `destruction_history` - `diplomacy` - `dw_settings` - `events` - `guilds` - `item_inventory` - `item_properties` - `mod_controllers` - `properties` - `purgescores` - `sqlite_sequence` ### Characters: This tables contains all information on players who have created a character on the server. it contains the players Steam ID number, the unique character ID, the character name, level, guild, and other stats. The `ID` field in this table is how ownership of objects and buildings are identified in other tables in the database, and is an easy way to identify which structures, placed items, and thralls belong to an individual player. This information will be useful if you want to copy character information or delete buildings placed by inactive players on your server. ### Account: This table contains the Steam ID of players on the server. Exact purpose unknown. ### Actor\_Position: The coordinates of placed items, crafting stations, and thralls. Doors are listed in this table too, since they can be picked back up and placed back into inventory. This table also lists the position of the very first foundation blocks placed for each new structure. The location, facing, and rotation of all other contiguous blocks attached to the first foundation block are apparently referenced from the starting position of this first block. The `Class` column contains the file name of the element, which uses a mostly easy to read naming convention, such as a furnace being labelled `BP\_PL\_CraftingStation\_Furnace\_C`. This can be used to quickly find specific objects without having to look up the actual object Id's. ### Buildable\_Health: This table contains information on the structural health of every placed item that can be damaged in the game. - Each object has a unique `object\_id` number in the first column. Building blocks that are connected share a single object id number that was assigned when the first foundation block was placed. - The second column `instance\_id` is for each separate building block that the structure contains, starting with the first at zero, and increasing by one for each contiguous block. You will see the `instance\_id` number repeated multiple times for the same single block because of the information contained in the third column `Health\_id`. - `health\_id` column contains a listing for each separate ingredient that was used to craft the block or item, and is required to repair it. If an item has three ingredients, `health\_id` column will have three entries for that single block: 0, 1, and 2. - `template_id` is the master object id of the crafting material used in the construction of the block, such as wood, stone, shaped wood, stonebrick, etc. These are the materials that must be used to repair the item. - `ealth_percentage` (yes, it says `ealth`, not a typo) contains the percentage health of that block, with "1.0" being 100% health. Damaged blocks will show as any number less then 1.0, for example "0.867299616336823". There is a separate `ealth\_percentage` entry for each crafting material in `health\_id`. ### Building\_Instances: - `object\_id` contains unique id's for every structure built in the game. These `object\_id` numbers are shared across other tables such as `buildable\_health`. This table `building\_instances` seems to contain only placed building blocks (foundations, walls, ceilings, etc), while `buildable\_health` contains entries for building blocks, plus other items like campfires, torches, and other placed items. - `instance\_id` works the same way as in `buildable\_health`, the first placed item is zero, and every extra connected block increases the count by one. These entries in the table are in the order they were added to the structure. - `Class` The path name of the file that contains the art elements used in the game. Due to the naming conventions used in the file name, it's quite easy to figure out what each block is; wall, wall with a window (frame), foundation, etc. - `Transform1` and `Transform2` believe these control the position and facing of each block, relative to the very first foundation block that was placed in the structure. - `Building\_Flags` - unknown purpose. Values of 0, 1, or 2 ### Buildings: A list of structures and placed items, and the players that created and own them - `object\_id` should correspond to the same `object_id` field in other tables. - `owner\_id` from the `characters` table. ### Character\_Stats: `Char\_id` contains unique id numbers for players and thralls. By checking the `Characters` table you can see which codes belong to player characters. The remaining id numbers are for any thralls that can be placed in the world, such as fighters, archers, performers, and bearers. Thralls that can only be placed in the thrall slots of crafting stations appear in different tables (we believe these types of thralls are simply handled as inventory objects). - `Stat\_type` - Unknown purpose. Values of 0 or 1. All players/thralls have exactly 8 lines with stat\_type zero, Players have 4 entries with stat\_type 1, Thralls have 7 entries with stat\_type 1, but some will have 2 extra lines for a total of 9. These extra 2 database lines can appear and disappear and might be related to damage to the thrall, or some similar condition. - `Stat_id` - Still determining the meaning of the values, but below are the currently known stats. The values in the column `stat\_id` are not unique, so it necessary to look at the information in both columns `stat\_type` and `stat\_id` together as a pair. ##### Type ID `0` - `1` = Maximum health `0` - `4` = Player level `0` - `10` = thrall level, in the format of 1.0 to 4.0 `0` - `16` = player encumbrance stat `0` - `17` = player strength stat ### Item\_Inventory: - `Item\_id` This is the position of the storage slot associated with a container. - `Owner\_id` unique id for each `container` in the game; players, thralls, crafting stations, chests, etc. - `Inv\_type` 0 = Character's inventory (player or thrall) 1 = Equipped weapons and armor 2 = Items assigned to players's hotbar 3 = Learned crafting recipes (??) 4 = Inventories of containers, such as chests or crafting stations 5 = Unknown Values of 6, 7 and 8 are all linked to player ID, but their exact meaning is unknown - `Template\_id` the master object id for each type of item, that tells the game what it is; stone, putrid meat, medium gauntlets, wooden shield, Steel Pickaxe, etc. - `Data` - Hexadecimal information, which probably contains things like the quantity of items in a stack, durability, decay countdown for perishable items like food, etc.