• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

premium points tfs 1.x

theduck

Member
Joined
Dec 6, 2018
Messages
246
Reaction score
20
I would like every time the player logs in
appears how many premiun points he has
Code:
local points = db.executeQuery('SELECT `premium_points` FROM `accounts` WHERE `id`=' .. player:getAccountId() ..';')
player:sendTextMessage(MESSAGE_EVENT_ADVANCE,"Your Account has " .. points .. " premium points.")
 
Solution
Lua:
function Player.getPremiumPoints(self)
    local res = db.storeQuery('SELECT `premium_points` FROM `accounts` WHERE id=' .. self:getAccountId() ..';')
    local points = 0
    if res then
        points = result.getNumber(res, 'premium_points')
    end
    result.free(res)
    return points
end

function onThink(interval, lastExecution)
    for _, player in pairs(Game.getPlayers()) do
        local points = player:getPremiumPoints()
        player:sendTextMessage(MESSAGE_EVENT_ADVANCE, string.format('You have %d premium points.', points))
    end
end
Lua:
local res = db.executeQuery('SELECT `premium_points` FROM `accounts` WHERE id=' .. player:getAccountId() ..';')
if res then
    local points = result.getNumber(res, 'premium_points')
    player:sendTextMessage(MESSAGE_EVENT_ADVANCE,"Your Account has " .. points .. " premium points.")
end
result.free(res)
 
Lua:
local res = db.executeQuery('SELECT `premium_points` FROM `accounts` WHERE id=' .. player:getAccountId() ..';')
if res then
    local points = result.getNumber(res, 'premium_points')
    player:sendTextMessage(MESSAGE_EVENT_ADVANCE,"Your Account has " .. points .. " premium points.")
end
result.free(res)
')' expected near '" .. player:getAccountId() .. "'
 
Lua:
function Player.getPremiumPoints(self)
    local res = db.storeQuery('SELECT `premium_points` FROM `accounts` WHERE id=' .. self:getAccountId() ..';')
    local points = 0
    if res then
        points = result.getNumber(res, 'premium_points')
    end
    result.free(res)
    return points
end

function onThink(interval, lastExecution)
    for _, player in pairs(Game.getPlayers()) do
        local points = player:getPremiumPoints()
        player:sendTextMessage(MESSAGE_EVENT_ADVANCE, string.format('You have %d premium points.', points))
    end
end
 
Last edited:
Solution
Lua:
function Player.getPremiumPoints(self)
    local res = db.storeQuery('SELECT `premium_points` FROM `accounts` WHERE id=' .. player:getAccountId() ..';')
    local points = 0
    if res then
        points = result.getNumber(res, 'premium_points')
    end
    result.free(res)
    return points
end

function onThink(interval, lastExecution)
    for _, player in pairs(Game.getPlayers()) do
        local points = player:getPremiumPoints()
        player:sendTextMessage(MESSAGE_EVENT_ADVANCE, string.format('You have %d premium points.', points))
    end
end
attempt to index global 'player' (a nil value)
stack traceback:
 
Back
Top