[Gesior 2012] [TFS 1.2] Buy tibia coins

[undead mage]

Does anyone have a script to buy tibia coins though paypal? As the title says im using gesior 2012 and tfs 1.2. I want that the people will be able to buy tibia coins instead of premium points. Is there already a script or can someone help me make one?

 

[Danger II]

You can use the coins column instead of premium_points one, thats how I did.

 

[undead mage]

You can use the coins column instead of premium_points one, thats how I did.

tried it and it didn''t work :s

 

[Darted450]

I created an new column "premium_points" -!: it worked fine; just make sure it isn't null by default or it won't update.

 

[undead mage]

I created an new column "premium_points" -!: it worked fine; just make sure it isn't null by default or it won't update.

But I don't need premium points that already works I need people to be able to buy tibia coins. Which indeed should be column "coins" thats also what I have in my database but it isn't working.

 

[dartedd450]

But I don't need premium points that already works I need people to be able to buy tibia coins. Which indeed should be column "coins" thats also what I have in my database but it isn't working.

I also have the 'coins' in my database, but nonetheless when I use item id 16101 (30 tibia coin scroll), it adds them to my 'Premium_points' balance which in return seems to add to my in-game TC balance

 

[undead mage]

I also have the 'coins' in my database, but nonetheless when I use item id 16101 (30 tibia coin scroll), it adds them to my 'Premium_points' balance which in return seems to add to my in-game TC balance

try this

local function doPlayerAddCoins(cid, count)
        db.query('UPDATE accounts SET coins = coins+'.. count ..' WHERE id = ' .. getAccountNumberByPlayerName(getCreatureName(cid)))
end

function onUse(cid, item, fromPosition, itemEx, toPosition) 
    doPlayerAddCoins(cid, 30)
    doPlayerSendTextMessage(cid, MESSAGE_EVENT_ADVANCE, "You have recived 30 tibia coins!.")
    doSendMagicEffect(getCreaturePosition(cid), 28)
    doRemoveItem(item.uid,1)
    return true
end

 

[Gado]

any one have idea about this problem in gesior 2012
Fatal error: Call to a member function fetch() on a non-object in /var/www/classes/account.php on line 33

 

[dartedd450]

try this

local function doPlayerAddCoins(cid, count)
        db.query('UPDATE accounts SET coins = coins+'.. count ..' WHERE id = ' .. getAccountNumberByPlayerName(getCreatureName(cid)))
end

function onUse(cid, item, fromPosition, itemEx, toPosition)
    doPlayerAddCoins(cid, 30)
    doPlayerSendTextMessage(cid, MESSAGE_EVENT_ADVANCE, "You have recived 30 tibia coins!.")
    doSendMagicEffect(getCreaturePosition(cid), 28)
    doRemoveItem(item.uid,1)
    return true
end

My server reads "premium_points" as the TibiaCoin balance. Where can I change it? I can't figure out where the TC system is