Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers

Support::Windows Servers Support forum for Windows EQEMu users.

Reply
 
Thread Tools Display Modes
  #1  
Old 05-25-2012, 07:41 AM
kimura
Hill Giant
 
Join Date: Oct 2011
Posts: 132
Default Expansion items

I know that there is a way to sort zones by expansion field... is there a field im missing for items that can be used to group items by expansion release? Thanks for any input!!
Reply With Quote
  #2  
Old 05-25-2012, 09:51 AM
Secrets's Avatar
Secrets
Demi-God
 
Join Date: May 2007
Location: b
Posts: 1,449
Default

Quote:
Originally Posted by kimura View Post
I know that there is a way to sort zones by expansion field... is there a field im missing for items that can be used to group items by expansion release? Thanks for any input!!
Short answer: No.

Long answer: You can cross reference the items, lootdrop_entries, npc_types, loottable, spawn2, spawngroup, and spawnentry in a query to select all the item IDs that drop in a specific zone. They won't be 'for that era', however, they will only be sorted by items that drop in those specific zones in the database you are running.
Reply With Quote
  #3  
Old 05-25-2012, 10:12 AM
kimura
Hill Giant
 
Join Date: Oct 2011
Posts: 132
Default

Ok, I was afraid of that....

I could use cross reference to figure out what items drop in all zones for expansion 8 for example... etc...

then I would eventually figure out what's left that are in the db, but do not drop, which would be the newer ones....

thanks so much Secrets for the quick response!!!
Reply With Quote
  #4  
Old 05-25-2012, 03:52 PM
c0ncrete's Avatar
c0ncrete
Dragon
 
Join Date: Dec 2009
Posts: 719
Default

if you're just looking for items that are in the database that do not drop, the following query should give you a general idea. please note that it works under the assumption that all related tables (npc_types, spawn2, spawngroup, spawnentry, loottable, loottable_entries, lootdrop, and lootdrop_entries) are without error (meaning no entries with 0 chance/probability or invalid spawn/loot info). it also doesn't take into account items that are only obtainable via quests, tradeskills, or merchants.

Code:
SELECT `id`, `Name` FROM `items` WHERE `id` NOT IN (SELECT DISTINCT `item_id` FROM `lootdrop_entries`);
Reply With Quote
  #5  
Old 05-25-2012, 08:07 PM
kimura
Hill Giant
 
Join Date: Oct 2011
Posts: 132
Default

Sweet, thanks c0ncrete!
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 09:12 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