Help!

[scorpionfight]

Hi guys.

I wonder if it is possible to make a function to change a field in the database, for example .. premium_points ..
A function that give premium_points for all players, offline and online.
The problem is that I do not know how to do this, because all commands use (cid), etc. .. I think you get the idea. So if you can help, I really appreciate.

Sorry for bad english and thanks.

 

[scorpionfight]

BUMP;
Anyone?

I found this function in lib, but I dont know how I can use it.. table.insert(players

function getPlayersOnlineEx()
local players = {}
for i, cid in ipairs(getPlayersOnline()) do
table.insert(players, getCreatureName(cid))
end

return players
end

 

[Scarlet Ayleid]

db.executeQuery("UPDATE `accounts` SET `premium_points` = `premium_points` + " .. 5 .. ")

Just add that to the script where you want it to be used and its done

 

[Dantarrix]

And change the number "5" in the code to the premium points you want to add...

 

[scorpionfight]

Thanks.