From 228d9803f31acf68cb4333f64fd2919a8e93a9db Mon Sep 17 00:00:00 2001
From: Bezo <BezoCCCP@gmail.com>
Date: Sun, 17 Mar 2013 17:32:24 +0000
Subject: Scripts/Commands: Add .list mail $char/$guid command

Prints a list of mails received by the characters

Closs #9421
---
 sql/updates/world/2013_03_17_03_world_misc.sql | 12 ++++++++++++
 1 file changed, 12 insertions(+)
 create mode 100644 sql/updates/world/2013_03_17_03_world_misc.sql

(limited to 'sql/updates')

diff --git a/sql/updates/world/2013_03_17_03_world_misc.sql b/sql/updates/world/2013_03_17_03_world_misc.sql
new file mode 100644
index 00000000000..17468c626d3
--- /dev/null
+++ b/sql/updates/world/2013_03_17_03_world_misc.sql
@@ -0,0 +1,12 @@
+DELETE FROM `trinity_string` WHERE `entry` IN (1151, 1152, 1153, 1154, 1155, 1156);
+INSERT INTO `trinity_string` (`entry`,`content_default`) VALUES
+(1151, 'Mail List Info: # of mails: %u, Player: %s(%u)'),
+(1152, 'Mail Id: %u Title: \"%s\" Money: %ug%us%uc'),
+(1153, 'Sender: %s(%u), Receiver: %s(%u)'),
+(1154, 'Time deliver: %s, Time expire: %s'),
+(1155, 'Item: %s[Entry:%u Guid:%u Count:%u]'),
+(1156, 'Mail List Info: No mail found for this character.');
+
+DELETE FROM `command` WHERE `name` = 'list mail';
+INSERT INTO `command` (`name`,`security`,`help`) VALUES
+('list mail', 3, 'Syntax: .list mail $character\nList of mails the character received.');
-- 
cgit v1.2.3