EOC BETA Launch (Developer's Tool) EQEmu Operations Center

[Kingly_Krab]

Here's a query for mass updating a zone. Could use this until it's available on the EOC.

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';