possible to add Tibia coins via a command

[mimsol]

Hello need some help
i want to add tibia coins via a command
would be nice if someone help

 

[Loney]

Not tested.

talkactions/addcoins.lua

function onSay(cid, words, param)
local t = string.explode(param, ",")
if t[1] ~= nil and t[2] ~= nil then
local result = db.getResult("SELECT `account_id` FROM `players` WHERE `name` = '"..t[1].."';")
db.executeQuery("UPDATE `accounts` SET `coins` = `coins` + "..t[2].." WHERE `id` = '" ..result:getDataString("account_id").. "';")
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, ""..t[1].." has received "..t[2].." Tibia Coins.")
result:free()
else
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Command requires two params.")
end
return TRUE
end

talkactions.xml

<talkaction words="/addcoins" separator=" " script="addcoins.lua" />

Example: /addcoins Loney, 10

 

[mimsol]

Not tested.

talkactions/addcoins.lua

function onSay(cid, words, param)
local t = string.explode(param, ",")
if t[1] ~= nil and t[2] ~= nil then
local result = db.getResult("SELECT `account_id` FROM `players` WHERE `name` = '"..t[1].."';")
db.executeQuery("UPDATE `accounts` SET `coins` = `coins` + "..t[2].." WHERE `id` = '" ..result:getDataString("account_id").. "';")
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, ""..t[1].." has received "..t[2].." Tibia Coins.")
result:free()
else
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Command requires two params.")
end
return TRUE
end

talkactions.xml

<talkaction words="/addcoins" separator=" " script="addcoins.lua" />

Example: /addcoins Loney, 10

Post automatically merged: Aug 30, 2020

sory had no internet for a week

 

[Loney]

Replace

local t = string.explode(param, ",")

for

local t = string.split(param, ",")

OR

local t = param:split(",")

 

[mimsol]

stil not working :d

 

[aqubjukr]

stil not working :d

function onSay(player, words, param)
    local split = param:split(",")
    local target = split[1] and Player(split[1])
    if not target then
        return player:sendCancelMessage("This player does not exist.")
    end

    local givecoins = tonumber(split[2])
    if type(givecoins) ~= 'number' or givecoins > 25000 then
        player:sendCancelMessage("Total Coins (Max: 25000).")
        return false
    end

    local result = db.query('UPDATE accounts SET coins = coins+'.. givecoins ..' WHERE id = ' .. getAccountNumberByPlayerName(target:getName()))

    if result then
        player:sendTextMessage(MESSAGE_INFO_DESCR, "You gave " .. givecoins .. " tibia coins.")
        target:sendTextMessage(MESSAGE_INFO_DESCR, "You received " .. givecoins .. " tibia coins.")
    end
return true
end

 

[Andersen Griep]

@aqubjukr sorry revive this topic, u have this script in revscript ?

 

[Elgenady]

local tibiaCoins = TalkAction("/tc")

function tibiaCoins.onSay(player, words, param)   

    if not player:getGroup():getAccess() or player:getAccountType() < ACCOUNT_TYPE_GOD then
        return true
    end
    local usage = "/tc PLAYER NAME,TC AMOUNT"
    if param == "" then
        player:sendCancelMessage("Command param required. Usage: ".. usage)
        return false
    end

    local split = param:split(",")
    if not split[2] then
        player:sendCancelMessage("Insufficient parameters. Usage: ".. usage)
        return false
    end

    local target = Player(split[1])
    if not target then
        player:sendCancelMessage("A player with that name is not online.")
        return false
    end
    --trim left
    split[2] = split[2]:gsub("^%s*(.-)$", "%1")
    
    player:sendCancelMessage("Added " .. split[2] .. " tibia coins to the character '" .. target:getName() .. "'.")
    target:sendCancelMessage("Received " .. split[2] .. " tibia coins!")
    target:addTibiaCoins(tonumber(split[2]))
    target:getPosition():sendMagicEffect(CONST_ME_HOLYAREA)


end

tibiaCoins:separator(" ")
tibiaCoins:register()

I found this in other forum

 

[Andersen Griep]

local tibiaCoins = TalkAction("/tc")

function tibiaCoins.onSay(player, words, param)  

    if not player:getGroup():getAccess() or player:getAccountType() < ACCOUNT_TYPE_GOD then
        return true
    end
    local usage = "/tc PLAYER NAME,TC AMOUNT"
    if param == "" then
        player:sendCancelMessage("Command param required. Usage: ".. usage)
        return false
    end

    local split = param:split(",")
    if not split[2] then
        player:sendCancelMessage("Insufficient parameters. Usage: ".. usage)
        return false
    end

    local target = Player(split[1])
    if not target then
        player:sendCancelMessage("A player with that name is not online.")
        return false
    end
    --trim left
    split[2] = split[2]:gsub("^%s*(.-)$", "%1")
   
    player:sendCancelMessage("Added " .. split[2] .. " tibia coins to the character '" .. target:getName() .. "'.")
    target:sendCancelMessage("Received " .. split[2] .. " tibia coins!")
    target:addTibiaCoins(tonumber(split[2]))
    target:getPosition():sendMagicEffect(CONST_ME_HOLYAREA)


end

tibiaCoins:separator(" ")
tibiaCoins:register()

I found this in other forum

Thank you <3

 

[kubanczyk892]

and how to use that ?

 

[Xikini]

and how to use that ?

put it into data/scripts as a Lua file.

in-game on a god account use the command /tc Xikini, 45 to give me 45 tibia coins.

 

[kubanczyk892]

thx