Trying SQL

[Sven-Hälge]

Hello there!

I am trying to get my SQL working without success!

But this is what i have got from trying login on account manager.

Anybody can help?

(Photo: http://www.ladda-upp.se/bilder/qlkenpxgtbrqbi/ )

 

[narko]

Run this in SQL

ALTER TABLE `accounts` ADD
`vipdays` int(11) NOT NULL DEFAULT 0;

 

[Sven-Hälge]

Thanks that helped!

Maybe you know how i can change temple position?
My SQL doesnt work and cant log in on account manager because it is wrong :/

 

[Limos]

What do you mean with MySQL doesn't work? You can just edit the account manager in the table players and change posx, posy and posz.

 

[kamilcioo]

Thanks that helped!

Maybe you know how i can change temple position?
My SQL doesnt work and cant log in on account manager because it is wrong :/

Enter players in database. Then, choose account manager and change xyz.

 

[narko]

You can just set a valid town_id instead.