[EACH 1HOUR ONLINE] REWARD - PREMIUM POINTS TFS 1.2

[Zak.Tibiam]

hello people would like to know if anyone could help with a script that every 1 hour online in the player wins 1 server premium points on your account.

use tfs 1.2

Thank you

 

[Zak.Tibiam]

@Omni Cloud i need add this tag on creaturescriptS?

<event type="login" name="pontos" event="script" value="pontos.lua"/>

and this

local event = {}
local timeOnline = 60 * 60 * 1000

function addPremiumPoint(cid)
    local player = Player(cid)
    if player then
        db.query("UPDATE `accounts` SET `premium_points` = premium_points + 1 WHERE `id`= " .. player:getGuid() .. " LIMIT 1');")
        player:sendTextMessage(MESSAGE_STATUS_CONSOLE_ORANGE, "You have been online for an hour and have earned 1 premium point.")
        event[cid] = addEvent(addPremiumPoint, timeOnline, cid)
        return
    end
    event[cid] = nil
end

function onLogin(player)
    local cid = player:getId()
    if not event[cid] then
        event[cid] = addEvent(addPremiumPoint, timeOnline, cid)
    end
    return true
end

file .lua? thanks

 

[Zak.Tibiam]

@MatheusMkalo

 

[Nekiro]

Yes, you can add this code to login.lua also.
If you are adding it to other lua remember to register event in login.lua

 

[Zak.Tibiam]

[Error - mysql_real_query] Query: UPDATE `accounts` SET `premium_points` = premium_points + 1 WHERE `id`= 41855 LIMIT 1');
Message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '')' at line 1

 

[Nekiro]

db.query("UPDATE `accounts` SET `premium_points` = `premium_points` + 1 WHERE `id`= " .. player:getGuid() .. " LIMIT 1;")

 

[cavazospedro]

does anyone have this script for 1.3?

 

[Scrollia]

does anyone have this script for 1.3?

Look for @Sarah Wesker script GlobalEvent - System Online Points (https://otland.net/threads/system-online-points.250371/#post-2431010)