Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Database/World Building

Development::Database/World Building World Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc.

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #6  
Old 06-04-2009, 11:32 AM
Irreverent
The Solo Server
 
Join Date: May 2007
Posts: 416
Default

Considering my databases is one of the most custom out there, I have learned to live with the single-file that CD uses.

What I have done is keep two different files, "Checklists", that I use. One is for code, one is for perl.

I just whipe the tables / file folders, load the quests or tables, then perform the checklist.

so in my database checklist, I have several hundreds of rows of SQL that will modify WHATEVER is in the new database back to where I need it.

For my custom npcs/items I have a different schema, to which in my checklist it has SQL to load those rows into the new database and then alter as nessecary.

That way, its VERY easy for me to keep in sync with ANY reload. I just load the script, hit run...and minutes later I'm running with the cool new db or quests version.

I would reccomend you do the same, because he's busy enough keeping his server running for his rules. If you want to alter it, its really up to oneself to do it. I'd rather not slow down CD so his database gets updated faster...and I can quickly keep in sync.

Plus, if I do something that is EQLive...(like the 85 new fableds I hacked), share it with CD and he'll load it into his database.
__________________
OP of Irreverent Server (The Solo Server)
Our Forums
Reply With Quote
 

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 02:29 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3