Solved Premium Points

[LuckyM]

Hello OTLanders,


I've looking for a command, can give all players 15 points..



Rep++

 

[Sublime]

UPDATE `accounts` SET premium_points=premium_points*15;

 

[LuckyM]

Thanks Sublime!

 

[LuckyM]

I need to restart the server?

 

[bolero]

No.

 

[LuckyM]

No.

its dosnt work.. :/ Maybe the script is wrong or something!

 

[Duxi]

In game :

/closeserver or masskick

in SQL:

update `accounts` set `premium_points` = `premium_points` + 15;

and now in game :

/openserver

 

[bolero]

UPDATE accounts SET premium_points = 15

UPDATE `accounts` SET `premium_points` = `premium_points` + 15;

Any Works do not need to restart or shut down the server.

 

[Sublime]

its dosnt work.. :/ Maybe the script is wrong or something!

Do you mean that my query doesn't work ?, or what else are you asking for ?

 

[bolero]

Sublime tu consulta esta mala wn chekeala bn xD

 

[JDB]

He probably doesn't know it's a query, you have to execute it in the database.

 

[Wezc]

That's what i thought JDB You cant write that ingame ;D

 

[LuckyM]

Solved! Thanks Bolero!