aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorSpp <none@none>2010-03-12 18:55:41 +0100
committerSpp <none@none>2010-03-12 18:55:41 +0100
commit2cac9671caaa8ed942e7d9ed9026d83d01eb88e9 (patch)
treead5381d01d3c33ae270048ad9bb39f458279fb89 /sql
parentd2a3f9670f303ad3e27d2860762091db37ab2d2e (diff)
Add map and zone to account onlinelist command.
Closes issue 466 --HG-- branch : trunk
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/7548_world_trinity_string.sql6
-rw-r--r--sql/world.sql7
2 files changed, 10 insertions, 3 deletions
diff --git a/sql/updates/7548_world_trinity_string.sql b/sql/updates/7548_world_trinity_string.sql
new file mode 100644
index 00000000000..5d6165f2125
--- /dev/null
+++ b/sql/updates/7548_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][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/world.sql b/sql/world.sql
index 805e76841fb..f4812fa3498 100644
--- a/sql/world.sql
+++ b/sql/world.sql
@@ -14680,11 +14680,12 @@ INSERT INTO `trinity_string` (`entry`,`content_default`,`content_loc1`,`content_
(1007, 'Account %s NOT created (probably sql file format was updated)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1008, 'Account %s NOT created (unknown error)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1009, 'Player %s (Guid: %u) Account %s (Id: %u) deleted.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
-(1010, '| Account | Character | IP | GM | Expansion |', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1010, '[ Account][ Character][ IP][GMLev][Expansion][Map][Zone]', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1011, '|<Error> | %20s |<Error> |<Er>| <Error> |', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
-(1012, '===========================================================================', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
-(1013, '|%15s| %20s | %15s |%4d| %9d |', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1012, '==============================================================================', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1013, '-[%16s][%12s][%15s][%5d][%9d][%3d][%4d]', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1014, 'No online players.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1015, '============================== Characters Online =============================', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1100, 'Account %s (Id: %u) have up to %u expansion allowed now.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1101, 'Message of the day changed to:\r\n%s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1102, 'Message sent to %s: %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),