ag

case 1: //Warrior
                        {
                        QueryResult result = CharacterDatabase.Query("SELECT name,totalKills FROM characters WHERE class='1' ORDER BY totalKills DESC LIMIT 5");
                    if(!result)
                          return false;

                        Field * fields = NULL;
                        ChatHandler(player->GetSession()).PSendSysMessage(M_Warrior);
                        do
                        {
                        fields = result->Fetch();
                        string name = fields[0].GetString();
                        uint32 totalKills = fields[1].GetUInt32();
                        char msg[250];
                        snprintf(msg, 250, "Name: %s, With Total Kills : %u", name.c_str(), totalKills);
                        ChatHandler(player->GetSession()).PSendSysMessage(msg);
                        }
                        while(result->NextRow());
                        player->SaveToDB();
                        player->PlayerTalkClass->SendCloseGossip();
                        }
                        break;