Creating SQLite3 databases for game data

[foxtacles]

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

[NeoPhoenix]

i would do it during weekend

[foxtacles]

That would be nice :)

[Volumed]

Do you still need the ID list?

[foxtacles]

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

(and cell data)

[Volumed]

You will get it.

[Volumed]

Fallout 3 items and DLC items

https://www.2shared.com/document/F31TI3E4/itemsfallout3.html

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

[foxtacles]

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

[Volumed]

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

[foxtacles]

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

Would be nice, though :D 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 :)

[foxtacles]

Thanks to NeoPhoenix we'll soon have complete SQLite DBs containing actor data :)

Volumed: do you have access to the cell data of the games?

[Volumed]

Thanks to NeoPhoenix we'll soon have complete SQLite DBs containing actor data :)

Volumed: do you have access to the cell data of the games?

Yea. I did a lot of modding in my younger days. :-)

[foxtacles]

What we need is information about adjacent cells ('neighbour' cells in-game). So we need a list of cells and their adjacents.