From 61b2ce7856924bcaa4fda4fe124cd2a019493dd3 Mon Sep 17 00:00:00 2001 From: Blaymoira Date: Sun, 11 Jan 2009 19:05:39 +0100 Subject: *Fixed SaveGMTicket - by Machiavelli --HG-- branch : trunk --- src/game/TicketMgr.cpp | 23 ++++++++++++----------- 1 file changed, 12 insertions(+), 11 deletions(-) (limited to 'src') diff --git a/src/game/TicketMgr.cpp b/src/game/TicketMgr.cpp index 7c86cde723b..1e28c2a2ec1 100644 --- a/src/game/TicketMgr.cpp +++ b/src/game/TicketMgr.cpp @@ -169,18 +169,19 @@ void TicketMgr::RemoveGMTicketByPlayer(uint64 playerGuid, uint64 GMguid) void TicketMgr::SaveGMTicket(GM_Ticket* ticket) { + std::string msg = ticket->message; + CharacterDatabase.escape_string(msg); std::stringstream ss; - ss << "REPLACE INTO `gm_tickets` (`guid`, `playerGuid`, `name`, `message`, `timestamp`, `closed`, `assignedto`, `comment`) VALUES(\""; - ss << ticket->guid << "\", \""; - ss << ticket->playerGuid << "\", \""; - ss << ticket->name << "\", \""; - ss << ticket->message << "\", \"" ; - ss << ticket->timestamp << "\", \""; - ss << ticket->closed << "\", \""; - ss << ticket->assignedToGM << "\", \""; - ss << ticket->comment << "\");"; - - CharacterDatabase.BeginTransaction(); + ss << "REPLACE INTO `gm_tickets` (`guid`, `playerGuid`, `name`, `message`, `timestamp`, `closed`, `assignedto`, `comment`) VALUES('"; + ss << ticket->guid << "', '"; + ss << ticket->playerGuid << "', '"; + ss << ticket->name << "', '"; + ss << msg << "', '" ; + ss << ticket->timestamp << "', '"; + ss << ticket->closed << "', '"; + ss << ticket->assignedToGM << "', '"; + ss << ticket->comment << "');"; + CharacterDatabase.BeginTransaction(); CharacterDatabase.Execute(ss.str().c_str()); CharacterDatabase.CommitTransaction(); -- cgit v1.2.3