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
  #28  
Old 04-12-2004, 01:34 AM
govtcheeze
Hill Giant
 
Join Date: Mar 2004
Location: South Florida
Posts: 247
Default

FOrgot to add, you should consider writing your updates in sql format, ie:

Code:
UPDATE lootdrop_entries set item_id = ##### where lootdrop_id = ##### and item_id = ##### LIMIT 1;
So in the example above, you would write:

Code:
UPDATE lootdrop_entries set item_id = 13073 where lootdrop_id = 118 and item_id = 12694 LIMIT 1;
This is good for 2 reasons, the first is if you re-source an update of mine, you can simply re-source your sql and the changes are done...no need to do the work again. The second and more important feature is you can post these updates for everyone to use
Reply With Quote
 


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 08:54 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