View Single Post
  #3  
Old 03-10-2012, 05:34 PM
Hateborne
Hill Giant
 
Join Date: May 2010
Posts: 125
Thumbs up Solved

Final, working query:
Code:
UPDATE loottable INNER JOIN npc_types ON loottable.id=npc_types.loottable_id INNER JOIN spawnentry ON npc_types.id=spawnentry.npcID INNER JOIN spawn2 ON spawnentry.spawngroupID=spawn2.spawngroupID SET loottable.mincash = 0, loottable.maxcash = 0, loottable.avgcoin = 0 WHERE spawn2.zone = 'ruji';
-Hate
Reply With Quote