void TicketMgr::LoadGMTickets() { // Delete all out of object holder GM_TicketList.clear(); QueryResult_AutoPtr result = CharacterDatabase.Query("SELECT guid, playerGuid, name, message, createtime, map, posX, posY, posZ, timestamp, closed, assignedto, comment, escalated, viewed FROM gm_tickets"); GM_Ticket *ticket; if (!result) { ticketmgr.InitTicketID(); sLog.outString(); sLog.outString(">> GM Tickets table is empty, no tickets were loaded."); return; } // Assign values from SQL to the object holder do { Field *fields = result->Fetch(); ticket = new GM_Ticket; ticket->guid = fields[0].GetUInt64(); ticket->playerGuid = fields[1].GetUInt64(); ticket->name = fields[2].GetString(); ticket->message = fields[3].GetString(); ticket->createtime = fields[4].GetUInt64(); ticket->map = fields[5].GetUInt32(); ticket->pos_x = fields[6].GetFloat(); ticket->pos_y = fields[7].GetFloat(); ticket->pos_z = fields[8].GetFloat(); ticket->timestamp = fields[9].GetUInt64(); ticket->closed = fields[10].GetUInt64(); ticket->assignedToGM = fields[11].GetUInt64(); ticket->comment = fields[12].GetString(); ticket->escalated = fields[13].GetUInt64(); ticket->viewed = fields[14].GetBool(); AddGMTicket(ticket, true); } while (result->NextRow()); sWorld.SendGMText(LANG_COMMAND_TICKETRELOAD, result->GetRowCount()); }
void TicketMgr::LoadGMTickets() { // Delete all out of object holder GM_TicketList.clear(); QueryResult *result = CharacterDatabase.Query( "SELECT `guid`, `playerGuid`, `name`, `message`, `createtime`, `map`, `posX`, `posY`, `posZ`, `timestamp`, `closed`, `assignedto`, `comment` FROM `gm_tickets`" ); GM_Ticket *ticket; if(!result) return; // Assign values from SQL to the object holder do { Field *fields = result->Fetch(); ticket = new GM_Ticket; ticket->guid = fields[0].GetUInt64(); ticket->playerGuid = fields[1].GetUInt64(); ticket->name = fields[2].GetString(); ticket->message = fields[3].GetString(); ticket->createtime = fields[4].GetUInt64(); ticket->map = fields[5].GetUInt32(); ticket->pos_x = fields[6].GetFloat(); ticket->pos_y = fields[7].GetFloat(); ticket->pos_z = fields[8].GetFloat(); ticket->timestamp = fields[9].GetUInt64(); ticket->closed = fields[10].GetUInt64(); ticket->assignedToGM = fields[11].GetUInt64(); ticket->comment = fields[12].GetString(); AddGMTicket(ticket, true); } while( result->NextRow() ); sWorld.SendGMText(LANG_COMMAND_TICKETRELOAD, result->GetRowCount()); delete result; }