[Lurker_005]

As for fixing the databases if the Z, and X,Y are changed. This can all be done in mysql. Perhaps someone with a little more SQL knowledge than me can verify the update Sql comand samples I posted below. Granted due to some Z locs being fixed by hand and some not, it may be best to do so by zone, or start back with the original Z locs.

WARNING: These are samples, do not use this unles you know what your doing, and why!

A stab at a sample update Z command

Update spawn2 set z=z/10 WHERE zone = 'kael';

At any rate it would be a quick way to verify some gusses as to the Z modifier for the whole zone. Run the query, respawn zone, check the safe spot.

The X Y thing I think would need a temp column, something like this

alter table spawn2 ADD COLUMN xtmp float NOT NULL default '0';
Update spawn2 set xtmp=x;
Update spawn2 set x=y;
Update spawn2 set y=xtmp;
alter table spawn2 DROP COLUMN xtmp;

Edit: These 2 code snipits are tested on kael and will correctly spawn all of kael from the ShowEQ spawn log locs (EQEmu version 0.2.6) The Z is a little off, but they spawn fine.