Global Item Drop Queries
Ever wonder where to hunt for particular pieces of gear?
These two queries help sort locations and mob types for drop locations of global loot: Query 1 Code:
select zone from spawn2 where spawngroupID Code:
select name from npc_types where loottable_id To use, run Query 1 to find a list of zone 'short' names. Then, enter the desired name into the search criteria of Query 2. The queries can be tailored to look for any item..you just need to adjust the 'items' sub-query to do so. The 'items' search criteria for both queries need to match or you will not receive accurate results. Query 2 groups like-named mobs together..so, you may need to remove that clause and add 'id' to the select criteria if you believe that not all mobs with that name have this item in their global loot drop table. These queries can probably be handled a lot better..but, they worked for what I needed at the time. Note: The more complex the item query is, the longer it will take to finish - especially the zone search one. Example results: Code:
broodlands Code:
an_aberrant |
Very cool. Ty
|
Nice one Uleat. But it's time to scramble those letters around in your name - Ulate.
I could of seriously used this last night, haha |
Oh, doh! Sorry..was too lazy to just use #si and decided to actually see what dropped certain items
|
Quote:
on any loot tables, so I had to do some googling before adding it to a few. |
If you prefer INNER JOINs...
Code:
SELECT `a`.`zone` FROM `spawn2` `a` Code:
SELECT `a`.`name` FROM `npc_types` `a` I saw no difference in query time myself... Note: Global items have changed in the way they are handled and no longer appear in loot tables. (Any remnants will eventually be taken out.) |
All times are GMT -4. The time now is 12:47 PM. |
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.