WD PVP reward system

-- idea from Black WOlf
-- Rochet2 of ac-web.org proofread then reworked it to function
-- Thank you Rochet2 for all your help
-- PVP reward system. player gets awarded 3 mg per kill plus a bonus mg count equal to the vip level (1-6) of the victim.

function GrantPvPReward(event, pPlayer, pKilled)
        local Q = WorldDBQuery("SELECT `vip` FROM logon.accounts WHERE `login` = '"..pKilled:GetAccountName().."';")

        local vip = 0

        if(Q)
                 then vip = Q:GetColumn(0):GetLong()
    else

        end

    pPlayer:SendBroadcastMessage("you earned 3+"..vip.." magic gold.")

        WorldDBQuery("UPDATE logon.accounts SET `mg` = `mg` + '3' + "..vip.." WHERE `login` = '"..pPlayer:GetAccountName().."' LIMIT 1; ");

--        WorldDBQuery("UPDATE logon.accounts SET `mg` = `mg` - '3' WHERE `login` = '"..pKilled:GetAccountName().."' LIMIT 1; ");


end





RegisterServerHook(23, "GrantPvPReward")