Support PHPmyAdmin, command to add points in SQL

[Stellow]

Hi everbody,
i need some help.. ;x

how can i add premium_points to x player .. eg

add 25 Poiints, in "premium_points" to player "Rhsukem "

in database, SQL

Thanks

 

[_Arthur]

What's your database name/table name?

 

[Jikoe II]

UPDATE `players` SET `premium_points`=25;

^for all players

if you want it for 1 player go to your players folder -->search--> typ at "name" rhsukem then cntrl_f typ points , change 0 to 25


rep me if i helped y

 

[MiPo91]

You can do it this way easily, just change at the end "PLAYER NAME HERE" with the player name you want.

UPDATE accounts LEFT JOIN players ON accounts.ID = players.ID SET accounts.premium_points = 25 WHERE players.name = 'PLAYER NAME HERE'

 

[Stellow]

Thanks you, rep++