diff options
| -rw-r--r-- | sql/updates/7548_world_trinity_string.sql | 6 | ||||
| -rw-r--r-- | sql/updates/7551_world_trinity_string.sql | 6 | ||||
| -rw-r--r-- | src/trinitycore/CliRunnable.cpp | 4 |
3 files changed, 8 insertions, 8 deletions
diff --git a/sql/updates/7548_world_trinity_string.sql b/sql/updates/7548_world_trinity_string.sql deleted file mode 100644 index 5d6165f2125..00000000000 --- a/sql/updates/7548_world_trinity_string.sql +++ /dev/null @@ -1,6 +0,0 @@ -DELETE FROM `trinity_string` WHERE `entry` in (1010,1012,1013,1015); -INSERT INTO `trinity_string` (`entry`, `content_default`) VALUES -(1010, '[ Account][ Character][ IP][GMLev][Expansion][Map][Zone]'), -(1012, '=============================================================================='), -(1013, '-[%16s][%12s][%15s][%5d][%9d][%3d][%4d]'), -(1015, '============================== Characters Online =============================');
\ No newline at end of file diff --git a/sql/updates/7551_world_trinity_string.sql b/sql/updates/7551_world_trinity_string.sql new file mode 100644 index 00000000000..3fe54f47dca --- /dev/null +++ b/sql/updates/7551_world_trinity_string.sql @@ -0,0 +1,6 @@ +DELETE FROM `trinity_string` WHERE `entry` in (1010,1012,1013,1015); +INSERT INTO `trinity_string` (`entry`, `content_default`) VALUES +(1010, '-[ Account][ Character][ IP][Map][Zone][Exp][GMLev]-'), +(1012, '-==================================================================-'), +(1013, '-[%16s][%12s][%15s][%3d][%4d][%d][%d]-'), +(1015, '-======================== Characters Online =======================-');
\ No newline at end of file diff --git a/src/trinitycore/CliRunnable.cpp b/src/trinitycore/CliRunnable.cpp index c26302d30cd..f02fbe0849d 100644 --- a/src/trinitycore/CliRunnable.cpp +++ b/src/trinitycore/CliRunnable.cpp @@ -219,7 +219,7 @@ bool ChatHandler::HandleServerExitCommand(const char* /*args*/) bool ChatHandler::HandleAccountOnlineListCommand(const char* /*args*/) { ///- Get the list of accounts ID logged to the realm - QueryResult_AutoPtr resultDB = CharacterDatabase.Query("SELECT name,account,map,zone FROM characters LEFTWHERE online > 0"); + QueryResult_AutoPtr resultDB = CharacterDatabase.Query("SELECT name,account,map,zone FROM characters WHERE online > 0"); if (!resultDB) { SendSysMessage(LANG_ACCOUNT_LIST_EMPTY); @@ -250,7 +250,7 @@ bool ChatHandler::HandleAccountOnlineListCommand(const char* /*args*/) { Field *fieldsLogin = resultLogin->Fetch(); PSendSysMessage(LANG_ACCOUNT_LIST_LINE, - fieldsLogin[0].GetString(),name.c_str(),fieldsLogin[1].GetString(),fieldsLogin[2].GetUInt32(),fieldsLogin[3].GetUInt32(),fieldsDB[2].GetInt32(),fieldsDB[3].GetInt32()); + fieldsLogin[0].GetString(),name.c_str(),fieldsLogin[1].GetString(),fieldsDB[2].GetInt32(),fieldsDB[3].GetInt32(),fieldsLogin[3].GetUInt32(),fieldsLogin[2].GetUInt32()); } else PSendSysMessage(LANG_ACCOUNT_LIST_ERROR,name.c_str()); |