Lua Blance preimiun points in game - tfs client 9.1 (!blance)

[marcelao777]

Hi
I need see the balance in game of the premium points !balance

my balance.lua no work

function getAccountPoints(cid)
    local res = db.getResult('select `accounts`.`premium_points` from accounts where name = \''..getPlayerAccount(cid)..'\'')
    if(res:getID() == -1) then
       return false
    end
    local ret = res:getDataInt("premium_points")
    res:free()
    return tonumber(ret)
end
 
function doAccountAddPoints(cid, count)
    return db.executeQuery("UPDATE `accounts` SET `premium_points` = '".. getAccountPoints(cid) + count .."' WHERE `name` ='"..getPlayerAccount(cid).."'")
end
 
function doAccountRemovePoints(cid, count)
    return db.executeQuery("UPDATE `accounts` SET `premium_points` = '".. getAccountPoints(cid) - count .."' WHERE `name` ='"..getPlayerAccount(cid).."'")
end
function onSay(cid, words, param, channel)
	if isPlayer(cid) then
		doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Your Account has ' .. getAccountPoints(cid) .. ' premium points.")
	end
return TRUE
end

help fast please

 

[Gabriel Tibiano]

"fast" ? and u dont even post your balance.lua? ahaha funny,
I want 1 billion dollars, fast too, okay?

 

[marcelao777]

"fast" ? and u dont even post your balance.lua? ahaha funny,
I want 1 billion dollars, fast too, okay?

lol did not you see?

again
my balance.lua

function getAccountPoints(cid)
local res = db.getResult('select `accounts`.`premium_points` from accounts where name = \''..getPlayerAccount(cid)..'\'')
if(res:getID() == -1) then
return false
end
local ret = res:getDataInt("premium_points")
res:free()
return tonumber(ret)
end

function doAccountAddPoints(cid, count)
return db.executeQuery("UPDATE `accounts` SET `premium_points` = '".. getAccountPoints(cid) + count .."' WHERE `name` ='"..getPlayerAccount(cid).."'")
end

function doAccountRemovePoints(cid, count)
return db.executeQuery("UPDATE `accounts` SET `premium_points` = '".. getAccountPoints(cid) - count .."' WHERE `name` ='"..getPlayerAccount(cid).."'")
end
function onSay(cid, words, param, channel)
if isPlayer(cid) then
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Your Account has ' .. getAccountPoints(cid) .. ' premium points.")
end
return TRUE
end

important detail HELP

 

[marcelao777]

I need just show balance of the premium_points in game !balance

function getAccountPoints(cid) 
local res = db.getResult('select `accounts`.`premium_points` from accounts where name = \''..getPlayerAccount(cid)..'\'') 
if(res:getID() == -1) then 
return false 
end 
local ret = res:getDataInt("premium_points") 
res:free() 
return tonumber(ret) 
end
function onSay(cid, words, param, channel) 
if isPlayer(cid) then 
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Your Account has ' .. getAccountPoints(cid) .. ' premium points.") 
end 
return TRUE 
end

 

[marcelao777]

help please i pay !

 

[andy1995]

function getAccountPoints(cid) 
    local res = db.getResult('select `accounts`.`premium_points` from accounts where name = \''..getPlayerAccount(cid)..'\'') 
    if(res:getID() == -1) then 
       return false 
    end 
    local ret = res:getDataInt("premium_points") 
    res:free() 
    return tonumber(ret) 
end 

function onSay(cid, words, param, channel) 
    if isPlayer(cid) then 
        doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, 'Your Account has ' .. getAccountPoints(cid) .. ' premium points.') 
    end 
return TRUE 
end

 

[marcelao777]

dont work :s my tfs 9.31 and 9.44 mystic spirit

 

[andy1995]

any error?

 

[marcelao777]

any error?

Correct error getResult

 

[andy1995]

here you have answer
http://otland.net/f163/forgotten-server-0-3-db-class-0-2-a-26225/

 

[marcelao777]

@andy1995

thank you very much, your tip made ​​the difference valew..

 

[marcelao777]

here you have answer
http://otland.net/f163/forgotten-server-0-3-db-class-0-2-a-26225/

now I need to, draw (! withdraw "x) premium_points and appear in my bag gold ingot 's, and decrease my balance and deposit premium_points (! deposit" x) and the gold ingot disappeared from my bag and increase my balance premium_points, if you can help me I thank