View Single Post
  #46  
Old 07-04-2013, 06:35 PM
Kingly_Krab
Administrator
 
Join Date: May 2013
Location: United States
Posts: 1,589
Default

Here's a query for mass updating a zone. Could use this until it's available on the EOC.
Code:
UPDATE npc_types INNER JOIN spawnentry ON npc_types.id = spawnentry.npcID INNER JOIN spawn2 
ON spawnentry.spawngroupID = spawn2.spawngroupID SET npc_types.stuff = otherstuff WHERE spawn2.zone = 'ZONENAME';
Reply With Quote