View Single Post
  #2  
Old 03-10-2012, 04:33 PM
Hateborne
Hill Giant
 
Join Date: May 2010
Posts: 125
Default

The very poorly constructed query I have come across to do this is:
Code:
update loottable set loottable.mincash = 0, loottable.maxcash = 0, loottable.avgcoin = 0 in (select npc_types.loottable_id from npc_types where id in (select spawnentry.npcID from spawnentry inner join spawn2 on spawnentry.spawngroupID = spawn2.spawngroupID where spawn2.zone = 'ruji'));
However, it is a bit large and seems to possibly cause either infinite loop or simply causes too much recursive nonsense to make it a viable command.

Can anyone else suggest something a bit cleaner?

-Hate
Reply With Quote