top_10_arena.lua

local NPC_ID = 60002    -- Put your NPC ID here  ( Script will show Top arena teams from 2v2/3v3/5v5 )
 
 local arena = {
        [2] = {"TOP 10 arena 2v2"},
        [3]     = {"TOP 10 arena 3v3"},
        [5] = {"TOP 10 arena 5v5"},    
};
       
 
function onGossipHello(event, plr, unit)
        for k, v in pairs(arena) do
                plr:GossipMenuAddItem(0, v[1], 0, k)
        end
        plr:GossipSendMenu(1, unit)
end
 
function onGossipSelect(event, plr, unit, arg2, intid)
    if (intid > 0) then
        local resultado = CharDBQuery("SELECT name,rating FROM arena_team WHERE type='"..intid.."' ORDER BY rating DESC LIMIT 10")
        if(resultado) then
            repeat
                local puntos = 0
                time = resultado:GetString(0);
                puntos = resultado:GetUInt32(1);
                plr:SendBroadcastMessage("|cFF33CCFFNome do time : |r ".. time .." ,  |cFF33CCFFRating : |r" .. puntos .. "  puntos de arena ")
            until not resultado:NextRow()    
        end
    end
end
--RegisterCreatureGossipEvent(NPC_ID, 1, onGossipHello)
--RegisterCreatureGossipEvent(NPC_ID, 2, onGossipSelect)