Thread: Creating SQLite3 databases for game data

If you want to help and have some knowledge about SQL, you could work on this GitHub issue:

https://github.com/Foxtacles/vaultmp/issues/14

We need SQLite3 databases which contain the data for actors and items. Currently we have the complete set of actor data (attached in this post) thanks to Houstin. We need two databases; one for Fallout 3, one for Fallout: New Vegas. They should contain the following tables:

actors (fields: "baseID" [32bit unsigned integer], "name" [string], "dlc" [unique integer identifier])
creatures (fields: "baseID" [32bit unsigned integer], "name" [string], "dlc" [unique integer identifier])
items (we don't have data yet, so no table structure yet)

The data attached consists of C headers (just treat them as text files). Each data set should have a unique ID (see "dlc" field). The main data of the games should have zero in the "dlc" field.

However, there is a problem. The baseIDs of the DLCs have a En prefix (like 0xE0, 0xE1 etc.). This was all correct when we had them build into the vaultmp application. Now, those prefixes need to be zeroed. So you have to replace all 0xEn with 0x00.

So if you have time...this is quite an important task

EDIT:
NeoPhoenix works on it

That would be nice

Do you still need the ID list?

We have all necessary data for actors / creatures. We still need complete base ID / name lists for items, though.

(and cell data)

You will get it.

Fallout 3 items and DLC items

https://www.2shared.com/document/F31T...sfallout3.html

Is this what you want? I can make more ID lists with objects and more..

That looks good! Can you also put the display name (in-game) instead of the form name?

That is a little harder. And not all items got a name.

Originally Posted by Volumed

That is a little harder. And not all items got a name.

Would be nice, though The actor data we currently have also has the in-game names. If an item doesn't have a name, then just use the form name instead