Item that gives tibia transferable coins

[bolachapanco]

I have this script that when using the item it gives tibia coins, but I would like it to give tibia coins (transferable).
it's possible?

local addCoins = Action()
function addCoins.onUse(player, item, fromPosition, target, toPosition, isHotkey)
local coins = 25
  db.query("UPDATE `accounts` SET `coins` = `coins` + '" .. coins .. "' WHERE `id` = '" .. player:getAccountId() .. "';")
  player:sendTextMessage(MESSAGE_EVENT_ADVANCE, "You received "..coins.." coins")
  item:remove(1)
  return true
end

addCoins:id(22118)
addCoins:register()

 

[Mateus Robeerto]

Do you want to click on the item to add it to your database? Tibia Coins, is that right?

local addCoins = Action()

function addPremiumPoints(player, points)
    local accountId = player:getAccountId()
    db.query("UPDATE `accounts` SET `premium_points` = `premium_points` + " .. points .. " WHERE `id` = " .. accountId .. ";")
end

function addCoins.onUse(player, item, fromPosition, target, toPosition, isHotkey)
    local points = 25
    addPremiumPoints(player, points)
    player:sendTextMessage(MESSAGE_EVENT_ADVANCE, "You received " .. points .. " Tibia Coins")
    item:remove(1)
    return true
end

addCoins:id(22118)
addCoins:register()

I tested it and it worked here, all right.

 

[bolachapanco]

I use the item but it does not return transferable tibia coins

 

[Evil Puncker]

@Mateus Robeerto these are premium points from website system, he wants tibia coins from ingame store

@bolachapanco we need to know which engine you are using in order to help you

 

[bolachapanco]

GitHub - opentibiabr/canary: Canary Server 13.x for OpenTibia community.

Canary Server 13.x for OpenTibia community. . Contribute to opentibiabr/canary development by creating an account on GitHub.

github.com

Releases​

Canary - Version 2.6.1

 

[Mateus Robeerto]

Just change "premium_points" to "coins", it should work. But it was important that you inform the version of your server. Now, you mention Canary, but I don't have that information. Anyway, I think the script I sent should work. Just do the replacement as I mentioned.

 

[bolachapanco]

Coins work but the coin that the item is not transferable, I would like you to give the coin transferable

 

[Mateus Robeerto]

@Mateus Robeerto these are premium points from website system, he wants tibia coins from ingame store

@bolachapanco we need to know which engine you are using in order to help you

Yeah... before he didn't say anything about his mechanism... now he says it was Canary. However, I used this 'Premium Point' and went to test it, I clicked on an item and Tibia Coin appeared ingame. store tfs 1.5

Post automatically merged: Aug 20, 2023

I went to take a look at this Canary and noticed that it has three types of coins: coins, coins_transferable and tournament_coins. I don't know which one makes Tibia Coins appear in the game through your store


Just test to see if it works...

local addCoins = Action()

function addCoinsTransferable(player, coins)
    local accountId = player:getAccountId()
    db.query("UPDATE `accounts` SET `coins_transferable` = `coins_transferable` + " .. coins .. " WHERE `id` = " .. accountId .. ";")
end

function addCoins.onUse(player, item, fromPosition, target, toPosition, isHotkey)
    local coins = 25
    addCoinsTransferable(player, coins)
    player:sendTextMessage(MESSAGE_EVENT_ADVANCE, "You received " .. coins .. " Transferable Coins")
    item:remove(1)
    return true
end

addCoins:id(22118)
addCoins:register()

local addCoins = Action()

function addTournamentCoins(player, coins)
    local accountId = player:getAccountId()
    db.query("UPDATE `accounts` SET `tournament_coins` = `tournament_coins` + " .. coins .. " WHERE `id` = " .. accountId .. ";")
end

function addCoins.onUse(player, item, fromPosition, target, toPosition, isHotkey)
    local coins = 25
    addTournamentCoins(player, coins)
    player:sendTextMessage(MESSAGE_EVENT_ADVANCE, "You received " .. coins .. " Tournament Coins")
    item:remove(1)
    return true
end

addCoins:id(22118)
addCoins:register()

but I'm not sure... actually I don't really understand this canary

 

[bolachapanco]

the script worked great, thanks a lot!

Post automatically merged: Aug 21, 2023

Yeah... before he didn't say anything about his mechanism... now he says it was Canary. However, I used this 'Premium Point' and went to test it, I clicked on an item and Tibia Coin appeared ingame. store tfs 1.5

Post automatically merged: Aug 20, 2023

I went to take a look at this Canary and noticed that it has three types of coins: coins, coins_transferable and tournament_coins. I don't know which one makes Tibia Coins appear in the game through your store


Just test to see if it works...

local addCoins = Action()

function addCoinsTransferable(player, coins)
    local accountId = player:getAccountId()
    db.query("UPDATE `accounts` SET `coins_transferable` = `coins_transferable` + " .. coins .. " WHERE `id` = " .. accountId .. ";")
end

function addCoins.onUse(player, item, fromPosition, target, toPosition, isHotkey)
    local coins = 25
    addCoinsTransferable(player, coins)
    player:sendTextMessage(MESSAGE_EVENT_ADVANCE, "You received " .. coins .. " Transferable Coins")
    item:remove(1)
    return true
end

addCoins:id(22118)
addCoins:register()

local addCoins = Action()

function addTournamentCoins(player, coins)
    local accountId = player:getAccountId()
    db.query("UPDATE `accounts` SET `tournament_coins` = `tournament_coins` + " .. coins .. " WHERE `id` = " .. accountId .. ";")
end

function addCoins.onUse(player, item, fromPosition, target, toPosition, isHotkey)
    local coins = 25
    addTournamentCoins(player, coins)
    player:sendTextMessage(MESSAGE_EVENT_ADVANCE, "You received " .. coins .. " Tournament Coins")
    item:remove(1)
    return true
end

addCoins:id(22118)
addCoins:register()

but I'm not sure... actually I don't really understand this canary