Moving Spell Merchants

[GRUMPY]

Backup Your database FIRST.
This is just something to look at for anyone who has ever thought about moving the
spell merchants from PoK to another zone. I put this query together which, after you
edit the zonename and "0" in the x,y,z values, will move all regular spell merchants,
song merchants and tome merchants from PoK to whatever zone you specify, (zonename)
WARNING : There is more tedious work to do.
First - Go to the zone where you want to move them. Pick an open spot and find out
#loc for x,y,z Then fill those values into the x,y,z in this query. The only thing this query
will do is move all those NPC's from PoK to one spot that you pick in your chosen
zone and x,y,z specified. Then after you run this query, (do a #repop).
Second: With a GM toon, target each one of the moved NPC's and go stand in a spot
where you want the NPC and type #spawnfix. After another #repop, the NPC will be
in place.
There will be 59 NPC's to do that with <grin> (I did it in -30 minutes). Have fun

UPDATE spawn2 SET zone = zonename WHERE spawngroupID > 34420 AND spawngroupID < 34481;
UPDATE spawn2 SET x = 0 WHERE spawngroupID > 34420 AND spawngroupID < 34481;
UPDATE spawn2 SET y = 0 WHERE spawngroupID > 34420 AND spawngroupID < 34481;
UPDATE spawn2 SET z = 0 WHERE spawngroupID > 34420 AND spawngroupID < 34481;
UPDATE spawn2 SET zone = zonename WHERE spawngroupID > 34404 AND spawngroupID < 34409;
UPDATE spawn2 SET x = 0 WHERE spawngroupID > 34404 AND spawngroupID < 34409;
UPDATE spawn2 SET y = 0 WHERE spawngroupID > 34404 AND spawngroupID < 34409;
UPDATE spawn2 SET z = 0 WHERE spawngroupID > 34404 AND spawngroupID < 34409;
UPDATE spawn2 SET zone = zonename WHERE spawngroupID > 34548 AND spawngroupID < 34552;
UPDATE spawn2 SET x = 0 WHERE spawngroupID > 34548 AND spawngroupID < 34552;
UPDATE spawn2 SET y = 0 WHERE spawngroupID > 34548 AND spawngroupID < 34552;
UPDATE spawn2 SET z = 0 WHERE spawngroupID > 34548 AND spawngroupID < 34552;
UPDATE spawn2 SET zone = zonename WHERE spawngroupID = 34410;
UPDATE spawn2 SET x = 0 WHERE spawngroupID = 34410;
UPDATE spawn2 SET y = 0 WHERE spawngroupID = 34410;
UPDATE spawn2 SET z = 0 WHERE spawngroupID = 34410;
UPDATE spawn2 SET zone = zonename WHERE spawngroupID = 34511;
UPDATE spawn2 SET x = 0 WHERE spawngroupID = 34511;
UPDATE spawn2 SET y = 0 WHERE spawngroupID = 34511;
UPDATE spawn2 SET z = 0 WHERE spawngroupID = 34511;
UPDATE spawn2 SET zone = zonename WHERE spawngroupID = 34512;
UPDATE spawn2 SET x = 0 WHERE spawngroupID = 34512;
UPDATE spawn2 SET y = 0 WHERE spawngroupID = 34512;
UPDATE spawn2 SET z = 0 WHERE spawngroupID = 34512;