-- Vip medal by Kekox
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
<action itemid="2112" event="script" value="vipmedal.lua"/>
function doAddVipDays(cid, days)
db.executeQuery("UPDATE `accounts` SET `vipdays` = `vipdays` + " .. days .. " WHERE `id` = " .. getPlayerAccountId(cid) .. ";")
end
function doRemoveVipDays(cid, days)
db.executeQuery("UPDATE `accounts` SET `vipdays` = `vipdays` - " .. days .. " WHERE `id` = " .. getPlayerAccountId(cid) .. ";")
end
function doAddVipDays(cid, days)
db.query("UPDATE `accounts` SET `vipdays` = `vipdays` + " .. days .. " WHERE `id` = " .. getPlayerAccountId(cid) .. ";")
end
function doRemoveVipDays(cid, days)
db.query("UPDATE `accounts` SET `vipdays` = `vipdays` - " .. days .. " WHERE `id` = " .. getPlayerAccountId(cid) .. ";")
end
<item id="116" article="a" name="Vip Medal">
<attribute key="description" value="One month of vip if you use it." />
<attribute key="weight" value="3500" />
</item>
<action itemid="116" script="vipmedal.lua"/>
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)
doPlayerPopupFYI(cid, "We have added 30 vip days to your account!\nEnjoy it!.")
doRemoveItem(item.uid)
end
return true
end
function doAddVipDays(cid, days)
db.executeQuery("UPDATE `accounts` SET `vip_time` = `vip_time` + " .. days .. " WHERE `id` = " .. getPlayerAccountId(cid) .. ";")
end
function doRemoveVipDays(cid, days)
db.executeQuery("UPDATE `accounts` SET `vip_time` = `vip_time` - " .. days .. " WHERE `id` = " .. getPlayerAccountId(cid) .. ";")
end
[26/10/2012 07:14:01] data/globalevents/scripts/vipEffect.lua:4: attempt to call global 'getPlayerVipDays' (a nil value)
[26/10/2012 07:14:01] stack traceback:
[26/10/2012 07:14:01] data/globalevents/scripts/vipEffect.lua:4: in function <data/globalevents/scripts/vipEffect.lua:1>
[26/10/2012 07:14:01] [Error - GlobalEvents::think] Couldn't execute event: vipEffect
function doAddVipDays(cid, days)
db.executeQuery("UPDATE `accounts` SET `vipdays` = `vipdays` + " .. days .. " WHERE `id` = " .. getPlayerGUID(cid) .. ";")
end