I am waiting on George's tool to be resurrected as well..
I came up with this query to still edit stuff based on zone.
Code:
UPDATE npc_types
JOIN spawnentry on spawnentry.npcID = npc_types.id
JOIN spawn2 on spawnentry.spawngroupID = spawn2.spawngroupID
#SET texture = (FLOOR(0 + (RAND() * (4 - 0)))) #sets a random texture BETWEEN 0 AND 4
SET armortint_id = 8
WHERE spawn2.zone like '%mistmoore%' and npc_types.id < 9900000 and race = 6 and armortint_id = 3
Just replace set armortint_id to whatever else you want and edit the where to sit your needs.
Threaded Mode
