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
  #1  
Old 06-03-2009, 03:58 PM
vales
Discordant
 
Join Date: May 2006
Posts: 458
Default PEQDB inquiry.

Hey, CaveDude.

I was meaning to ask if you could update the PEQDB with additional SQL query updates instead of uploading the whole database. This way, it's much more efficient to keep modifications and is lighter on your resources. We're always updating the whole thing instead of sourcing in only the database updates. Not the updates like Rev610.sql in the updates folder, but rather the actual sql query just for the database like items, mobs, etc.

If you could just post the difference files as far as updates are concerned, then it would be much easier.

The way I've learned to keep database updates in order was to have SQL entries from, for example, Rev10 to Rev20, was to post just the updates for those that already have Rev10 running, but post the sql data relevant up to Rev20.

This way, people can update it manually, source in additional tweaks and stuff without having to source in a completely full database before adding in updates again. Then, you could also have a full Rev20 for download for those that haven't used Rev10 yet. This way, it's much easier to also keep track of errenous files and issue a quickfix without breaking the whole database in the process or sourcing in the whole thing again when updating.

Breaking up the SQL files into categories would be ideal as well. For example, there's already sql entries for characters.sql, load_system.sql, etc. But in a Rev20 folder for example, there would be an item.sql that contained all of the item updates from Rev10 to Rev20, a mobs.sql that contained all of the mob updates, etc. This way, it's easier to pick and choose and also keep track of fixes much, much easier.

If people want to customize their servers without adding in let's say, adventure merchants, then they can immediately pick out what they don't want by commenting it out and then just sourcing in the rest.
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 10:20 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