Start town placement

[MadMOOK]

I made a new map for my mystic spirit 0.2.14 server and using 1000 1000 7 for town 1. Now I cant log into my server.. Is there something i have to do in phpmyadmin?

 

[zbizu]

you have to set player town_id and position

 

[MadMOOK]

thanks but where do I locate this?

 

[zbizu]

hope you know how to operate sql queries

UPDATE players SET posx="1000", posy="1000", posz="7", town_id="1" WHERE id>0;

or

UPDATE `players` SET `posx`="1000", `posy`="1000", `posz`="7", `town_id`="1" WHERE `id`>0;

 

[MadMOOK]

i execute this?

- - - Updated - - -

ok, so i did that and then in config.lua i changed the starting point... and on map my temple position is 1000 1000 7. i try to logon acc manager it says wrong temple position. and my accounts that i could log on before map change acc/password is wrong lol... i dont get it