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.

Reply
 
Thread Tools Display Modes
  #1  
Old 03-22-2004, 01:02 AM
Wolfman
Fire Beetle
 
Join Date: Mar 2003
Posts: 23
Default

This is a very cool idea. However, I noticed when comparing your tables to allakhazam's that the first item listed on allakhzam's seems to be missing on a majority (didn't check them all) of the entries in the lootdrop_entries table. I don't know if its a problem with your script or something. For example:

Xegony Drops-
Quote:
INSERT into lootdrop_entries values (11399, 16373, 1, 0, '33'); -- Xegony_the_Queen_of_Air gets Elemental Greaves Mold
INSERT into lootdrop_entries values (11399, 16381, 1, 0, '33'); -- Xegony_the_Queen_of_Air gets Elemental Leather Pant Pattern
INSERT into lootdrop_entries values (11399, 16388, 1, 0, '33'); -- Xegony_the_Queen_of_Air gets Elemental Silk Pant Pattern
INSERT into lootdrop_entries values (11399, 13672, 1, 0, '33'); -- Xegony_the_Queen_of_Air gets Exquisite Phoenix Feather Mantle
INSERT into lootdrop_entries values (11399, 26737, 1, 0, '33'); -- Xegony_the_Queen_of_Air gets Exquisite Puresteel Wraps
INSERT into lootdrop_entries values (11399, 10234, 1, 0, '33'); -- Xegony_the_Queen_of_Air gets Simple Ring of Purity
INSERT into lootdrop_entries values (11399, 14747, 1, 0, '33'); -- Xegony_the_Queen_of_Air gets Vest of Phoenix Feathers
INSERT into lootdrop_entries values (11399, 26788, 1, 0, '33'); -- Xegony_the_Queen_of_Air gets Xephyrus, Wand of the Flowing Wind
When Allakhazam lists:
Quote:
Elemental Chain Pant Pattern
Elemental Greaves Mold
Elemental Leather Pant Pattern
Elemental Silk Pant Pattern
Essence of Wind (PoP)
Exquisite Phoenix Feather Mantle
Exquisite Puresteel Wraps
Simple Ring of Purity
Vest of Phoenix Feathers
Xephyrus, Wand of the Flowing Wind
as all the loot.

The table your script created is missing the Elemental Chain Pant Pattern which happens to be first on allakhzam's list. The same thing occured when I checked the Avatars of dust,wind,smoke, and mist. I just wanted to point that out in case you hadn't noticed. And thanks for writing a pretty useful and cool script.
Reply With Quote
Reply


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:07 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