vip days not reduce

[crashgb]

Help! not reduce the VIP days.
I occupy the system VIP by Kekox

check my Action/Script/vipmedal.lua

-- 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, 10)
doCreatureSay(cid, "VIP")
doPlayerPopupFYI(cid, "We have added 10 vip days to your account!\nEnjoy it!.")
doRemoveItem(item.uid)
end
return true
end

check my action.xml

<action itemid="5785" event="script" value="vipmedal.lua"/>

check my Globalevents/script/daysremover

--- Script by Kekox
function onTime()
db.executeQuery("UPDATE accounts SET vipdays = vipdays - 1 WHERE vipdays > 0;")
return true
end

and my globalevents.xml

<globalevent name="VipDaysRemover" time="00:01" event="script" value="daysremover.lua"/>

what is the problem?

thanks people!!

 

[Cronox]

You need added this in phpmyadmin / SQL

ALTER TABLE `accounts` ADD
`vipdays` int(11) NOT NULL DEFAULT 0;

and use this:

--- Script by Kekox
function onTime()
      db.executeQuery("UPDATE accounts SET vipdays = vipdays - 1 WHERE vipdays > 0;")
    return TRUE
end

make reload or shutdown and open..

 

[Limos]

Do you get errors and which server do you use?

 

[elking]

Hey Cronox where i add ! this \/

--- Script by Kekox
function onTime()
      db.executeQuery("UPDATE accounts SET vipdays = vipdays - 1 WHERE vipdays > 0;")
    return TRUE
end