Defining items by expansion

[Shin Noir]

I have a couple ugly queries you can do to at least see stat giving items with outliers per zone, like..

SELECT i.id, i.NAME, i.classes, i.slots, i.hp, i.mana, s2.zone FROM items i
INNER JOIN lootdrop_entries lde ON lde.item_id = i.id
INNER JOIN lootdrop ld ON ld.id = lde.lootdrop_id
INNER JOIN loottable_entries lte ON lte.lootdrop_id = ld.id
INNER JOIN loottable lt ON lt.id = lte.loottable_id
INNER JOIN npc_types nt ON nt.loottable_id = lt.id
INNER JOIN spawnentry se ON se.npcid = nt.id
INNER JOIN spawn2 s2 ON s2.spawngroupid = se.spawngroupid	
WHERE slots > 0 AND s2.zone = 'ecommons' GROUP BY i.id;

They're really intense queries, but at least gets the obvious ones out.. Heh.

[provocating]

Yep, I have something similar

[provocating]

I have started expanding this further now. I have edited the PEQ editor to allow expansion settings in the npc, spawns, items, loot and it appears to be working. Before if I found an item or npc that was out of era I would just delete the item, now I mark it for the appropriate era. Since we are a progression server I may not necessarily want the item deleted. This will work off the expansion setting in the database. I still have a lot of testing to do, but so far it is
working well.




Ignore the expansion settings I have things set for, I was just changing them and repopping to make sure it was working. I also put some effort to make sure it was not throwing the drop rates off from having to skip items.