From 1c3bbdcce889c4b820a3c54b7cf53c05be5af9a8 Mon Sep 17 00:00:00 2001 From: Anubisss Date: Sun, 21 Feb 2010 22:59:50 +0100 Subject: Minor optimization in PlayerDumpReader::LoadDump(). --HG-- branch : trunk --- src/game/PlayerDump.cpp | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'src/game/PlayerDump.cpp') diff --git a/src/game/PlayerDump.cpp b/src/game/PlayerDump.cpp index 26574d6280b..0f5a4c87123 100644 --- a/src/game/PlayerDump.cpp +++ b/src/game/PlayerDump.cpp @@ -421,7 +421,7 @@ DumpReturn PlayerDumpReader::LoadDump(const std::string& file, uint32 account, s bool incHighest = true; if (guid != 0 && guid < objmgr.m_hiCharGuid) { - result = CharacterDatabase.PQuery("SELECT * FROM characters WHERE guid = '%d'", guid); + result = CharacterDatabase.PQuery("SELECT 1 FROM characters WHERE guid = '%d'", guid); if (result) guid = objmgr.m_hiCharGuid; // use first free if exists else incHighest = false; @@ -436,7 +436,7 @@ DumpReturn PlayerDumpReader::LoadDump(const std::string& file, uint32 account, s if (ObjectMgr::CheckPlayerName(name,true) == CHAR_NAME_SUCCESS) { CharacterDatabase.escape_string(name); // for safe, we use name only for sql quearies anyway - result = CharacterDatabase.PQuery("SELECT * FROM characters WHERE name = '%s'", name.c_str()); + result = CharacterDatabase.PQuery("SELECT 1 FROM characters WHERE name = '%s'", name.c_str()); if (result) name = ""; // use the one from the dump } @@ -545,7 +545,7 @@ DumpReturn PlayerDumpReader::LoadDump(const std::string& file, uint32 account, s name = getnth(line, 4); CharacterDatabase.escape_string(name); - result = CharacterDatabase.PQuery("SELECT * FROM characters WHERE name = '%s'", name.c_str()); + result = CharacterDatabase.PQuery("SELECT 1 FROM characters WHERE name = '%s'", name.c_str()); if (result) { if(!changenth(line, 37, "1")) // rename on login: `at_login` field 37 in raw field list -- cgit v1.2.3