-- 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 ROUGH DRAFT

function GrantPvPReward(event, pPlayer, pKilled)
    local Q = WorldDBQuery("SELECT `vip` FROM logon.accounts WHERE `login` = '"..pKilled:GetAccountName().."';")
    local vip = 0
    if(Q)
        vip = Q:GetColumn(0):GetLong()
    end
    pPlayer:WorldDBQuery("UPDATE logon.accounts SET `mg` = `mg` + (3 + "..vip..") WHERE `login` = '"..pPlayer:GetAccountName().."' LIMIT 1; ");
    pKilled:WorldDBQuery("UPDATE logon.accounts SET `mg` = `mg` - 3 WHERE `login` = '"..pKilled:GetAccountName().."' LIMIT 1; ");
end

RegisterServerHook(23, "GrantPvPReward")