Solved how to add shop points with sql command?

[TKO]

how to add shop points with sql command?
the command is
UPDATE `dbname`.`accounts` SET `premium_points` = '1000' WHERE `accounts`.`id` = accountid LIMIT 1 ;

 

[Shadow Ghost]

Don't know what tables u have got in ur database, so I give u example:

UPDATE `[COLOR="DarkOrange"][B]table[/B][/COLOR]` SET `[COLOR="Purple"][B]pointstable[/B][/COLOR]` = `[COLOR="Purple"][B]pointstable[/B][/COLOR]` + amount ;

Go to ur database (example forgottenserver)
table are [accounts,bans,players ect] - search where ur points are saved
pointstable are tables in accounts (like premdays), players (level).
amount is how many point u want add (this query add points to all players), change it to number.

Hope i helped :thumbup:
Regards

 

[nsanee]

here is a useful topic - http://otland.net/f139/phpmyadmin-commands-edit-database-7751/

As for your question

UPDATE  `dbname`.`accounts`  SET  `premium_points`  =  '1000' WHERE  `accounts`.`id`  = accountid LIMIT 1 ;

Just change 'dbname' to the name of your database and 'accountid' to the account ID you want to add points to.

 

[TKO]

THanks guys!