View Single Post
  #13  
Old 07-05-2006, 12:25 PM
sesmar
I built it I will Support it!
 
Join Date: Jun 2005
Location: Michigan
Posts: 214
Default

For pulling loottable info for the mobs of Gunthak maybe this will point you in the right direction.

Also just a warning this query will take some time to run as it hits 7 different and rather large tables.

Code:
SELECT
  spawnentry.npcID,
  npc_types.loottable_id,
  loottable.name,
  loottable_entries.lootdrop_id,
  lootdrop.name,
  lootdrop_entries.item_id
FROM
  spawnentry
  INNER JOIN spawn2
    ON spawn2.spawngroupID = spawnentry.spawngroupID
  INNER JOIN npc_types
    ON npc_types.id = spawnentry.npcID
  INNER JOIN loottable
    ON loottable.id = npc_types.loottable_id
  INNER JOIN  loottable_entries
    ON loottable_entries.loottable_id = loottable.id
  INNER JOIN lootdrop
    ON lootdrop.id = loottable_entries.lootdrop_id
  INNER JOIN  lootdrop_entries
    ON lootdrop_entries.lootdrop_id = lootdrop.id
WHERE
  spawn2.zone='gunthak'
ORDER BY
  spawnentry.npcID,
  npc_types.loottable_id,
  loottable_entries.lootdrop_id,
  lootdrop_entries.item_id
__________________
Reply With Quote