Advertisement
Guest User

1212

a guest
Sep 4th, 2015
50
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C++ 0.79 KB | None | 0 0
  1. case 3:
  2. {
  3.     QueryResult result = CharacterDatabase.Query("SELECT name, money FROM characters ORDER BY money DESC LIMIT 10");
  4.     if (!result)
  5.         return false;
  6.  
  7.     uint32 rank = 1;
  8.  
  9.     do
  10.     {
  11.         Field* fields = result->Fetch();
  12.         std::string name = fields[0].GetString();
  13.         uint32 money     = fields[1].GetUInt32();
  14.  
  15.         std::stringstream buffer;
  16.         buffer << "|TInterface\\icons\\inv_misc_coin_06:20:20:-15:0|t"<< rank++ << " Ник: |cff0033CC" << name << "|r Голд: |cff00CCCC" << money / 10000 << "|r";
  17.         player->ADD_GOSSIP_ITEM(GOSSIP_ICON_BATTLE, buffer.str().c_str(), GOSSIP_SENDER_MAIN, 3);
  18.     } while (result->NextRow());
  19.  
  20.     player->SEND_GOSSIP_MENU(ARENA_GOSSIP_TEAMS, creature->GetGUID());
  21.     player->SaveToDB();
  22. }
  23. break;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement