WD 3100 kill drop script

-- by Black Wolf of blackwolfsden aka Grumbo of EmuDevs.com aka slp13at420 of ac-web.org
-- custom item drop for creature 3100
-- when npc dies this script will act as auto looting
-- generates a random number between 1 n 25 then applies to variable a
-- adds item 44209 x a
-- adds to mg column in db +3 mg
-- completely reworked to function for individual player or group members by Rochet2 of ac-web.org
local NPCID = 3100

local function reward(player)

        player:AddItem(44209, math.random(1, 25))

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

        player:SendBroadcastMessage("+3 mg earned")
end

local function Mottledboar_Unit_EVENT_ON_DIED(pUnit, event, player)

        if(player:IsInGroup()) then

                for _, v in pairs(player:GetGroupPlayers()) do

                        if(v and v:IsInWorld()) then

                               reward(v)
                       end
                end

        else -- I assume GetGroupPlayers includes the killer also

                reward(player)
         end
 end


RegisterUnitEvent(NPCID, 4, Mottledboar_Unit_EVENT_ON_DIED)