From cef249ff2cec86c4059daa744f2f30e0b999f217 Mon Sep 17 00:00:00 2001
From: Spp <none@none>
Date: Tue, 9 Mar 2010 12:58:48 +0100
Subject: Add level restrictions to some commands: say, yell, emote, whisper,
 channel use, trade, auction, mail, tickets By azazel. Closes issue #598

--HG--
branch : trunk
---
 sql/updates/7508_world_trinity_string.sql | 11 +++++++++++
 sql/world.sql                             |  9 +++++++++
 2 files changed, 20 insertions(+)
 create mode 100644 sql/updates/7508_world_trinity_string.sql

(limited to 'sql')

diff --git a/sql/updates/7508_world_trinity_string.sql b/sql/updates/7508_world_trinity_string.sql
new file mode 100644
index 00000000000..f00d526f02c
--- /dev/null
+++ b/sql/updates/7508_world_trinity_string.sql
@@ -0,0 +1,11 @@
+DELETE FROM `trinity_string` WHERE `entry` IN (6604,6605,6606,6607,6608,6609,6610,6611,6612);
+INSERT INTO `trinity_string` (`entry`,`content_default`) VALUES
+(6604, 'You cannot say, yell or emote until you become level %d.'),
+(6605, 'You cannot whisper until you become level %d.'),
+(6606, 'You cannot write to channels until you become level %d.'),
+(6607, 'You cannot use auction until you become level %d.'),
+(6608, 'You cannot write tickets until you become level %d.'),
+(6609, 'You cannot trade until you become level %d.'),
+(6610, 'You cannot trade with characters lower than level %d.'),
+(6611, 'You cannot send mail until you become level %d.'),
+(6612, 'You cannot send mail to characters lower than level %d.');
diff --git a/sql/world.sql b/sql/world.sql
index 2dcb737b40c..666e3069b18 100644
--- a/sql/world.sql
+++ b/sql/world.sql
@@ -14805,6 +14805,15 @@ INSERT INTO `trinity_string` (`entry`,`content_default`,`content_loc1`,`content_
 (5025, 'Type: %u', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
 (5026, 'DisplayID: %u', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
 (5027, 'Name: %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(6604, 'You cannot say, yell or emote until you become level %d.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(6605, 'You cannot whisper until you become level %d.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(6606, 'You cannot write to channels until you become level %d.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(6607, 'You cannot use auction until you become level %d.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(6608, 'You cannot write tickets until you become level %d.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(6609, 'You cannot trade until you become level %d.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(6610, 'You cannot trade with characters lower than level %d.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(6611, 'You cannot send mail until you become level %d.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(6612, 'You cannot send mail to characters lower than level %d.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
 (6613, '|cfff00000[GM Announcement]: %s|r', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
 (6614, 'Notification to GM''s - ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
 (6615, '|cffffff00[|c1f40af20GM Announce by|r |cffff0000%s|cffffff00]:|r %s|r', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
-- 
cgit v1.2.3