Solved Problem with VIP System TFS 1.0

[Frostie]

This happens after i use vip medal.

 

[Ninja]

Missing the function doAddVipDays.

 

[Frostie]

Missing the function doAddVipDays.

Thats not the problem i added this function to compat.lua

function doAddVipDays(cid, days)
db.executeQuery("UPDATE `accounts` SET `vipdays` = `vipdays` + " .. days .. " WHERE `id` = " .. getPlayerAccountId(cid) .. ";")
end

 

[Ninja]

global.lua

function doAddVipDays(cid, days)
    db.query("UPDATE `accounts` SET `vipdays` = `vipdays` + " .. days .. " WHERE `id` = " .. getPlayerAccountId(cid))
end

compat.lua

function getPlayerAccountId(cid) local p = Player(cid) return p ~= nil and p:getAccountId() or false end

 

[Frostie]

errors in console are gone now but when i use vip medal my tibia client disconnects

 

[Ninja]

Post script?

 

[Frostie]

Post script?

function onUse(cid, item, fromPosition, itemEx, toPosition)
if getPlayerVipDays(cid) > 365 then
doPlayerSendCancel(cid, "You can only have 1 year of vip account or less.")
else
doAddVipDays(cid, 30)
doCreatureSay(cid, "VIP")
doPlayerPopupFYI(cid, "We have added 30 vip days to your account!\nEnjoy it!.")
doRemoveItem(item.uid)
end
return true
end

 

[Ninja]

doCreatureSay(cid, "VIP", TALKTYPE_ORANGE_1)

 

[Frostie]

doCreatureSay(cid, "VIP", TALKTYPE_ORANGE_1)

Worked, Thanks alot!