Worldbuiling FAQs/DOX Should Be Made

[Lurker_005]

A lot of the problems with databases is that the format has changed as new data was incorperated into the emu. That makes older DB's incompatable with the curent emu without some editing. If there is an update.sql included in the release that made the change, you just need to run that on the previous DB to update it. Also be sure to read the docs that come with a given DB, pay attention to when it was released and for what version of the emu. Combining DB's is strictly at your own risk, especially DB's meant for different emu releases.

Regarding docs... The DB structure itself is a great source of info. Most tables are pretty self contained, and the field names tell you what they are for. Loot and spawns are the only thing that is a pain to understand. For those I really think you should just use something like the admin tool. If it isn't up to date, use it on an older version and then use something like the update.sql file to make it compatable with the current version. The Blob data you have to look into the EQEmu source *.h files, but again the names, and comments are very helpful. I highly recomend you learn some SQL commands, and look thru the DB's sql file. Also try using a mySQL front end like "mySQL control center" from the mySQL web site, or the unfortunatly discontinued mySQL-front Both are free, and there are lots of others out there.

Bottom line, the info is there. Just not in a seperate document all by it's self. Besides, placing it in a seperate document causes problems if it isn't kept up to date (or just wrong). Look at the EQEmu readme.html for example. How many times did people post about how to create a database when winmysqladmin.exe no longer had the right click option to create a DB. things just change too fast, it's best to just get the info from the source files and DB structure.

If after reading all that you still want docs, I would sugest you start them yourself based on the files i mentioned above. Just be sure to keep it up to date!!!