WD-VIP-MG-Updater

-- adds magic gold based on vip level
-- by Black Wolf of blackwolfsden.dyndns-free.com

function World_VIPMGUpdate()

SendWorldMessage("You receive mg per VIP level 1-6 for being online per half hour. Earn VIp levels by Voting. Enjoy your rewards.", 2) -- informs chars when it fires

WorldDBQuery("UPDATE logon.accounts SET `mg`=`mg`+'5' WHERE `wc_box`='1' AND`vip`='1';");

WorldDBQuery("UPDATE logon.accounts SET `mg`=`mg`+'10' WHERE `wc_box`='1' AND `vip`='2';");

WorldDBQuery("UPDATE logon.accounts SET `mg`=`mg`+'15' WHERE `wc_box`='1' AND `vip`='3';");

WorldDBQuery("UPDATE logont.accounts SET `mg`=`mg`+'20' WHERE `wc_box`='1' AND `vip`='4';");

WorldDBQuery("UPDATE logon.accounts SET `mg`=`mg`+'25' WHERE `wc_box`='1' AND `vip`='5';");

WorldDBQuery("UPDATE logon.accounts SET `mg`=`mg`+'30' WHERE `wc_box`='1' AND `vip`='6';");

WorldDBQuery("UPDATE logon.accounts SET `mg`=`mg`+'35' WHERE `wc_box`='1' AND`vip`='7';");

WorldDBQuery("UPDATE logon.accounts SET `mg`=`mg`+'40' WHERE `wc_box`='1' AND `vip`='8';");

WorldDBQuery("UPDATE logon.accounts SET `mg`=`mg`+'45' WHERE `wc_box`='1' AND `vip`='9';");

WorldDBQuery("UPDATE logont.accounts SET `mg`=`mg`+'50' WHERE `wc_box`='1' AND `vip`='10';");

end

RegisterTimedEvent("World_VIPMGUpdate", 1800000, 0)

 -- 60000 = 1 minute