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
Code:
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
Code:
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.
Threaded Mode
