Thread: Expansion items
View Single Post
  #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