arena

#include "ScriptPCH.h"
using namespace std;

class npc_arena_teamTop : public CreatureScript
{
   public:
           npc_arena_teamTop() : CreatureScript("npc_arena_teamTop") { }

           bool OnGossipHello(Player * player, Creature * creature)
           {
                   player->ADD_GOSSIP_ITEM(GOSSIP_ICON_CHAT, "View top 2v2 Arena Teams", GOSSIP_SENDER_MAIN, GOSSIP_ACTION_INFO_DEF+1);
                   player->ADD_GOSSIP_ITEM(GOSSIP_ICON_CHAT, "View top 3v3 Arena Teams", GOSSIP_SENDER_MAIN, GOSSIP_ACTION_INFO_DEF+2);
                   player->ADD_GOSSIP_ITEM(GOSSIP_ICON_CHAT, "View top 5v5 Arena Teams", GOSSIP_SENDER_MAIN, GOSSIP_ACTION_INFO_DEF+3);
                   player->ADD_GOSSIP_ITEM(GOSSIP_ICON_CHAT, "Nevermind", GOSSIP_SENDER_MAIN, GOSSIP_ACTION_INFO_DEF+4);
                   player->SEND_GOSSIP_MENU(1, creature->GetGUID());
                   return true;
           }

           bool OnGossipSelect(Player * player, Creature * creature, uint32 sender, uint32 actions)
           {
                   if(sender == GOSSIP_SENDER_MAIN)
                   {
                           switch(actions)
                           {
                               case GOSSIP_ACTION_INFO_DEF+1:
                                   {
                                           QueryResult result = CharacterDatabase.Query("SELECT name,rating FROM arena_team WHERE type='2' ORDER BY rating DESC LIMIT 10");
                                           if(!result)
                                                   return false;

                                           Field * fields = NULL;
                                           player->MonsterWhisper("|cff4169E1Here are the top 10 2v2 arena teams:|r", player->GetGUID());
                                           do
                                           {
                                                   fields = result->Fetch();
                                                   string arena_name = fields[0].GetString();
                                                   uint32 rating = fields[1].GetUInt32();
                                                   char msg[250];
                                                   snprintf(msg, 250, "Team Name: |cffFFFF00%s|r, Team Rating: %u \n", arena_name.c_str(), rating);
                                                   player->MonsterWhisper(msg, player->GetGUID());
                                           }while(result->NextRow());
                                   }break;

                               case GOSSIP_ACTION_INFO_DEF+2:
                                   {
                                           QueryResult result = CharacterDatabase.Query("SELECT name,rating FROM arena_team WHERE type='3' ORDER BY rating DESC LIMIT 10");
                                           if(!result)
                                                   return false;

                                           Field * fields = NULL;
                                           player->MonsterWhisper("|cff4169E1Here are the top 10 3v3 arena teams:|r", player->GetGUID());
                                           do
                                           {
                                                   fields = result->Fetch();
                                                   string arena_name = fields[0].GetString();
                                                   uint32 rating = fields[1].GetUInt32();
                                                   char msg[250];
                                                   snprintf(msg, 250, "Team Name: |cffFFFF00%s|r, Team Rating: %u \n", arena_name.c_str(), rating);
                                                   player->MonsterWhisper(msg, player->GetGUID());
                                           }while(result->NextRow());
                                   }break;

                                   case GOSSIP_ACTION_INFO_DEF+3:
                                   {
                                           QueryResult result = CharacterDatabase.Query("SELECT name,rating FROM arena_team WHERE type='5' ORDER BY rating DESC LIMIT 10");
                                           if(!result)
                                                   return false;

                                           Field * fields = NULL;
                                           player->MonsterWhisper("|cff4169E1Here are the top 10 5v5 arena teams:|r", player->GetGUID());
                                           do
                                           {
                                                   fields = result->Fetch();
                                                   string arena_name = fields[0].GetString();
                                                   uint32 rating = fields[1].GetUInt32();
                                                   char msg[250];
                                                   snprintf(msg, 250, "Team Name: |cffFFFF00%s|r, Team Rating: %u \n", arena_name.c_str(), rating);
                                                   player->MonsterWhisper(msg, player->GetGUID());
                                           }while(result->NextRow());
                                   }break;

                               case GOSSIP_ACTION_INFO_DEF+4:
                                           {
                                                   player->PlayerTalkClass->SendCloseGossip();
                                           }break;
                           }
                   }

                   return true;
           }
};

void AddSC_npc_arena_setup()
{
        new npc_arena_teamTop;
}