You need to finish the code.
UPDATE start_zone set startzone = 152 where startzone = XXX
The XXX is where the old start currently is, like if they start in South Qeynos
It would look like
UPDATE start_zone SET start_zone = 152 where start_zone = 1
That will update every class / race combo who start(ed?) in South Q. to be moved to Nexus as start zone...unsure if you need to add more coding to clean up the starting location try it out just change the last digit(s) to the WHERE START_ZONE = 1 is. Good luck hope this helps.
|