Add points to everyone online on the server

[Imfreezing]

as the title says,is this possible
Would be grateful if i could get help
Regards Imfreezing

 

[Ninja]

UPDATE `accounts` SET `premium_points` = `premium_points` + 5 WHERE `id` IN (SELECT `account_id` FROM `players` WHERE `online` = 1);

 

[Imfreezing]

UPDATE `accounts` SET `premium_points` = `premium_points` + 5 WHERE `online` = 1

#1054 - Unknown column 'online' in 'where clause'

 

[Ninja]

Sorry about that, I don't know what I were thinking lol

Edited my previous post.

 

[Imfreezing]

Sorry about that, I don't know what I were thinking lol

Edited my previous post.

Thank you sir