Yes, the database will undergo structural changes. If you are working on a 3rd party tool and/or worldbuilding, you should read this post.
These changes are still .. changing, but here are the changes I perceive to be on the horizon:
#1: Data inside of character_.profile will change. Character inventory will likely no longer be stored here. The size of this blob field is being reduced from 14,908 bytes to 3,924 bytes.
#2: New field: character_.inventory (blob) will be added. This will likely be a relatively small struct (less than 1000 bytes) with simple pointers to items in the item table.
#3: Item data will undergo changes. The structure itself has shifted around, and a lot of new fields have been added. Wes has already figured out the major changes here and has the struct. I don't yet know how charm type items will be stored.
It would probably be helpful to start from scratch with items, since so much new data has been added. I think someone will be working on converting Lucy items to the new structs (wes?).
As a side note, I believe the 32k item limit will be removed in the 0.4.5 release.
#4: *.cfg files will need to be updated. Even though they are not physically stored in the database, we can treat it as such. We will likely need people to packet collect these for as many zones as possible, including LoY zones. Anyone here have access to plane of time?
#5: Zone table structure should not change, but new zones will need to be added. I've already added Jagged Pine and hateplaneb, but I don't have LoY so I don't know those.
#6: Spawns will change - likely just the npc_types table. Data has shifted around, and new data has been added. For example, the sub titles you see under some NPC's (such as "(Rogue Guildmaster)") have been added.
#7: The doors struct did change, which will mean the doors table will change. This is obviously not a top priority for us at the moment, but it would be nice if someone took on the responsibility of packet collecting door data for as many zones as possible. If you're interested, let me know and I'll check up on pc to see if it does door capturing.
|