Azayaka
Allelujah
Administrator
LEVEL 55
41 XP
Hey everyone,
Just dropping by to share a quick tip for those tinkering with WoW Emulation. I'm currently tinkering on a repack that I might share later on. Here's a little something that's been saving me time when hunting for items in dungeons: Knowing the entry range of creatures. Take RFC for example, where most common NPCs fall between 11318 to 11324. By querying these creatures and connecting them to the item_template table, you can easily find out what items they carry.
Here is the result for this query:
I know a lot of people do wow emulation as a hobby and may not have a lot of SQL knowledge so I hope this helps.
Just dropping by to share a quick tip for those tinkering with WoW Emulation. I'm currently tinkering on a repack that I might share later on. Here's a little something that's been saving me time when hunting for items in dungeons: Knowing the entry range of creatures. Take RFC for example, where most common NPCs fall between 11318 to 11324. By querying these creatures and connecting them to the item_template table, you can easily find out what items they carry.
SQL:
SELECT clt.*, it.*
FROM `creature_loot_template` clt
JOIN `item_template` it ON clt.`Item` = it.`entry`
WHERE clt.`entry` BETWEEN 11318 AND 11324
AND it.`Quality` = 0;
#junk is 0, common is 1, uncommon is 2, rare is 3, epic is 4Here is the result for this query:
I know a lot of people do wow emulation as a hobby and may not have a lot of SQL knowledge so I hope this helps.
