Fix compile after 7548.

Also reorder the columns of account onlinelist command

--HG--
branch : trunk

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());