Expansion items

[kimura]

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!!

[Secrets]

Originally Posted by kimura

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.

[kimura]

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!!!

[c0ncrete]

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.

SELECT `id`, `Name` FROM `items` WHERE `id` NOT IN (SELECT DISTINCT `item_id` FROM `lootdrop_entries`);

[kimura]

Sweet, thanks c0ncrete!