How to change temple position

[tofik1432]

Hi, I need help with one thing because I'm a newbie in making ots : so how can I change my temple position in SQL ots? because i changed my map so temple position is wrong ;/
plx fast help !! i can give rep

 

[Syntax]

Well make sure the town is configured in mapeditor, then open up
http://localhost/phpmyadmin

Login, goto players table, click browse, find temple pos x,y,z change there.

 

[tofik1432]

i get buged out ;/ when i change

 

[Keiro]

go to ur database.....go to players......press Edit in the one u want to edit the player position.......and search pos x , pos y, and pos z, then chanegd them

 

[tofik1432]

i did that ... then my tibia gets kicked (exits itself)

 

[QuaS]

UPDATE Players SET posx =X, posy =Y, posz =Z;

Change x,y,z to ur temple pos.

 

[Deleted member 49793]

In config.lua set the new player position there. after you do that

try changing it in SQLite manager or MySQL manager, whichever one you have, under players.

 

[tofik1432]

i looked in config.lua but there isn't any line of player pos , temple pos. ;/

quas , where should i do that? in phpmyadmin >> ots >> players ?

 

[Epic]

	-- Account Manager
	accountManager = "yes" -- Yes or No, you choose
	newPlayerChooseVoc = "yes" -- Yes or No you, choose
	newPlayerSpawnPosX = X -- X here	
	newPlayerSpawnPosY = X -- Y here
	newPlayerSpawnPosZ = X -- Z here
	newPlayerTownId = X -- TownID here
	newPlayerLevel = X -- PlayerLevel here
	newPlayerMagicLevel = X -- PlayerMlvl here
	generateAccountNumber = "no"

 

[tofik1432]

epic thx ;p u got rep ;] but i still get buged out ;/

 

[QuaS]

Enter database ant click "SQL", then paste this,

 

[tofik1432]

paste what ? i dont see anything xD


i pasted it , but only my gm got there , when i log on acc manager i get buged out ;/

 

[QuaS]

UPDATE Players SET posx =X, posy =Y, posz =Z;

Change x,y,z to ur temple pos.

...

 

[tofik1432]

i did that , gm logs fine but acc manager ont ;/ bugs out

 

[QuaS]

Update Players Set town_id = 1;

 

[tofik1432]

nope doesnt work ;/ fuck..ing shit ;/

 

[Keiro]

try this

UPDATE players SET world_id = 0 AND town_id = 1 AND posx = 955, posy = 1029, posz =6

change the numbers...for ur temple position ...posx posy and posz

 

[tofik1432]

#1054 - Unknown column 'world_id' in 'field list'

 

[Keiro]

u should have a coulum with that name....on ur players table :O, idk what version u using but hm....then idk :/

 

[tofik1432]

tfs 0.2.4.0 . u what ver. have ?