EmuDevs - TrinityCore QueryResult (WorldDatabase) Query

/*
 *╔═╦═╦═╦╦╦══╦═╦╗─╔╦══╗
 *║╦╣║║║║║╠╗╗║╦╣╚╦╝║══╣
 *║╩╣║║║║║╠╩╝║╩╬╗║╔╬══║
 *╚═╩╩═╩╩═╩══╩═╝╚═╝╚══╝
 *       EmuDevs - (http://emudevs.com)
*/
class npc_gossip_query : public CreatureScript
{
public:
    npc_gossip_query() : CreatureScript("npc_gossip_query") { }

    bool OnGossipHello(Player* player, Creature* creature)
    {
        player->ADD_GOSSIP_ITEM(GOSSIP_ICON_CHAT, "Query with me", GOSSIP_SENDER_MAIN, GOSSIP_ACTION_INFO_DEF+1);
        return true;
    }

    bool OnGossipSelect(Player* player, Creature* creature, uint32 /* sender */, uint32 actions)
    {
        player->PlayerTalkClass->ClearMenus();
        if (actions == GOSSIP_ACTION_INFO_DEF+1)
        {
            QueryResult result = WorldDatabase.Query("SELECT name,modelid1 FROM creature_template WHERE entry='25'");
            if (!result)
                return false;

            do
            {
                Field* fields = result->Fetch();

                std::string name     = fields[0].GetString();
                uint32 modelid1      = fields[1].GetUInt32();

                ChatHandler(player->GetSession()).PSendSysMessage("CREATURE NAME: %s \n CREATURE MODELID1: %u", name.c_str(), modelid1);
            }while(result->NextRow());
        }
    }
};

void AddSC_query()
{
    new npc_gossip_query;
}