TalkAction Check ZnoteAAC Points [0.4]

[Amiroslo]

Hello,
I made this script for my OT and I am releasing it for the public.
When you say !points , it checks your premium points in-game, instead of going to the website and logging in.
Simple but useful
Tested on TFS 0.4
I don't believe its hard to change it to any other TFS, but I never took a look on TFS 1.x.
​

New file in talkactions:

znotepoints.lua

function onSay(cid, words, param, channel)


local Info = db.getResult("SELECT `points` FROM `znote_accounts` WHERE `account_id` = " .. getPlayerAccountId(cid) .. " LIMIT 1")
local points = Info:getDataInt("points")

    if isPlayer(cid) then
        doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Your Account has " .. points .. " premium points.")
    end
return TRUE
end

in talkactions.xml

    <talkaction words="!points" event="script" value="znotepoints.lua" />

 

[Wason]

Thank you for sharing your script

 

[president vankk]

Gesior version:

function onSay(cid, words, param, channel)
   local info = db.getResult("SELECT `premium_points` FROM `accounts` WHERE `id` = " .. getPlayerAccountId(cid) .. " LIMIT 1")
   local points = info:getDataInt("premium_points")
   doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "You have " .. points .. " premium points in your account.")
   return TRUE
end

 

[Amiroslo]

Thank you for sharing your script

No problem

Gesior version:

function onSay(cid, words, param, channel)
   local info = db.getResult("SELECT `premium_points` FROM `accounts` WHERE `id` = " .. getPlayerAccountId(cid) .. " LIMIT 1")
   local points = info:getDataInt("premium_points")
   doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "You have " .. points .. " premium points in your account.")
   return TRUE
end

Yep (Y)