Windows Wrong tempel posison

[unoxot]

Hello I have make my war server 8.7 to 8.6 and Now its say Wrong tempel posision
I have test to edite town and make land On 50 50 7 but still dont work :S any can help me ?

 

[Hanoger]

If u are using MySQL database, u must edit samples, to hame the position you want (I was doing it yesterday, had same problem).
U choose to edit first voc - Sorcerer Sample - here you have posy, posx, posz - here u edit where u want the players to start, save it.
Do this with all vocations (druid, knight, paladin sample..) and here you go, your problem is fixed

 

[sickem]

try use this:

UPDATE  `DATABASE`.`players` SET  `posx` =  'X',
`posy` =  'Y',
`posz` =  'Z' WHERE  `players`. id;

replace X Y Z with your temple positions, all your chars will have this temple position.
replace database with your db name.
rep+ if helped

 

[Hanoger]

try use this:

UPDATE  `DATABASE`.`players` SET  `posx` =  'X',
`posy` =  'Y',
`posz` =  'Z' WHERE  `players`. id;

replace X Y Z with your temple positions, all your chars will have this temple position.
replace database with your db name.
rep+ if helped

What if his database have name Tibia?

 

[sickem]

then replaces the 'DATABASE' with tibia.

 

[Hanoger]

then replaces the 'DATABASE' with tibia.

Yup, u just edited it

 

[unoxot]

I find it ^^ Ty ty .. But Now My fucking eq go to the floor -.-

 

[Hanoger]

One player made post about it today, check this

 

[a7aa7a]

i Got this Error
#1146 - Table 'database.players' doesn't exist

 

[Ninja]

i Got this Error
#1146 - Table 'database.players' doesn't exist

You must change the DATABASE in that SQL Query to your Database name.

 

[a7aa7a]

Tell Me How :/

 

[tarekwiz]

i have this error and my stop for this fucken error

 

[a7aa7a]

tarekwiz :/
No One Can help me Here :'(

 

[Hanoger]

Use brain, enough?
Let me explain it for you:

UPDATE  `DATABASE`.`players` SET  `posx` =  'X',
`posy` =  'Y',
`posz` =  'Z' WHERE  `players`. id;

So...

UPDATE `DATABASE`

- DATABASE means DATABASE NAME, enough?
X means X position, Y means Y position, Z means Z position, enough?

 

[a7aa7a]

I Gottttttttttttttt Thissssssssssssssss
#1146 - Table 'database.players' doesn't exist

 

[Ninja]

Are you acting stupid or are you for real? You've to change DATABASE name.

Like this for example

[COLOR=#000000][COLOR=#0000BB]UPDATE  [/COLOR][COLOR=#007700]`[/COLOR][COLOR=#DD0000]TEST[/COLOR][COLOR=#007700]`.`[/COLOR][COLOR=#DD0000]players[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000BB]SET  [/COLOR][COLOR=#007700]`[/COLOR][COLOR=#DD0000]posx[/COLOR][COLOR=#007700]` =  [/COLOR][COLOR=#DD0000]'1000'[/COLOR][COLOR=#007700],
`[/COLOR][COLOR=#DD0000]posy[/COLOR][COLOR=#007700]` =  [/COLOR][COLOR=#DD0000]'1000'[/COLOR][COLOR=#007700],
`[/COLOR][COLOR=#DD0000]posz[/COLOR][COLOR=#007700]` =  [/COLOR][COLOR=#DD0000]'7' [/COLOR][COLOR=#0000BB]WHERE  [/COLOR][COLOR=#007700]`[/COLOR][COLOR=#DD0000]players[/COLOR][COLOR=#007700]`. [/COLOR][COLOR=#0000BB]id[/COLOR][COLOR=#007700];  [/COLOR][/COLOR][COLOR=#000000][COLOR=#0000BB]

[/COLOR][/COLOR]

 

[Hanoger]

OMG seriously, you are stupid, I can't understand how a guy cannot understand that what I wrote OMG!

And yes, now write to me you are more stupid than him bla bla bla..

 

[sickem]

How could he run a server :S?

 

[hiperkarma]

Easiest way to solve this problem is to set town_id to 1 of the character.
You must have a town listed in the map tho.

 

[a7aa7a]

Omg ;'(
Anyone can help me with teamviwer