WD-VIP Adjuster

-- Created by Black Wolf For The Wolf Den.
-- cross checks the acct vote tally and adjusts acct vip level accordingly.
-- vip level is based on 125 vote count per level
-- this is timer based and should fire every 30 minutes
-- by Black Wolf of blackwolfsden.dyndns-free.com

function World_VIPcheck()

WorldDBQuery("UPDATE logon.accounts SET `vip`='1' WHERE `votes`<'125';");

WorldDBQuery("UPDATE logon.accounts SET `vip`='2' WHERE `votes`>'124' AND `votes`<'250';");

WorldDBQuery("UPDATE logon.accounts SET `vip`='3' WHERE `votes`>'249' AND `votes`<'375';");

WorldDBQuery("UPDATE logon.accounts SET `vip`='4' WHERE `votes`>'374' AND `votes`<'500';");

WorldDBQuery("UPDATE logon.accounts SET `vip`='5' WHERE `votes`>'499' AND `votes`<'625';");

WorldDBQuery("UPDATE logon.accounts SET `vip`='6' WHERE `votes`>'624' AND `votes`<'750';");

WorldDBQuery("UPDATE logon.accounts SET `vip`='7' WHERE `votes`>'749' AND `votes`<'875';");

WorldDBQuery("UPDATE logon.accounts SET `vip`='8' WHERE `votes`>'874' AND `votes`<'1000';");

WorldDBQuery("UPDATE logon.accounts SET `vip`='9' WHERE `votes`>'999' AND `votes`<'1125';");

WorldDBQuery("UPDATE logon.accounts SET `vip`='10' WHERE `votes`>'1124' AND `votes`<'1250';");


end


RegisterTimedEvent("World_VIPcheck", 1800000, 0)

 -- 60000 = 1 minute, it is in miliseconds.