diff options
| author | Anubisss <none@none> | 2010-02-21 22:59:50 +0100 |
|---|---|---|
| committer | Anubisss <none@none> | 2010-02-21 22:59:50 +0100 |
| commit | 1c3bbdcce889c4b820a3c54b7cf53c05be5af9a8 (patch) | |
| tree | 62f84f29ce3e6c7a18f86447ff804b2f278ed361 /src/game/PlayerDump.cpp | |
| parent | c46c83109427af5398593cc87582e76e86e84f1d (diff) | |
Minor optimization in PlayerDumpReader::LoadDump().
--HG--
branch : trunk
Diffstat (limited to 'src/game/PlayerDump.cpp')
| -rw-r--r-- | src/game/PlayerDump.cpp | 6 |
1 files changed, 3 insertions, 3 deletions
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 |