From ba51f553fc3a677aa4d8ae846f86f8a560d9982c Mon Sep 17 00:00:00 2001
From: p0wer <none@none>
Date: Wed, 24 Feb 2010 21:30:00 -0600
Subject: Add command for administrators to change channel publicity ingame
 rather than having to manually manipulate the database.

--HG--
branch : trunk
---
 sql/updates/7430_world_command.sql        | 1 +
 sql/updates/7430_world_trinity_string.sql | 1 +
 sql/world.sql                             | 2 ++
 3 files changed, 4 insertions(+)
 create mode 100644 sql/updates/7430_world_command.sql
 create mode 100644 sql/updates/7430_world_trinity_string.sql

(limited to 'sql')

diff --git a/sql/updates/7430_world_command.sql b/sql/updates/7430_world_command.sql
new file mode 100644
index 00000000000..a3898c7f96e
--- /dev/null
+++ b/sql/updates/7430_world_command.sql
@@ -0,0 +1 @@
+INSERT INTO command VALUES ('channel set public', 3, 'Syntax: .channel set public  $channel $public\r\n\r\nChange password-changing ability for a channel. 1 for possible, 0 for GM only.');
\ No newline at end of file
diff --git a/sql/updates/7430_world_trinity_string.sql b/sql/updates/7430_world_trinity_string.sql
new file mode 100644
index 00000000000..96e046590fb
--- /dev/null
+++ b/sql/updates/7430_world_trinity_string.sql
@@ -0,0 +1 @@
+INSERT INTO trinity_string (entry, content_default) VALUES (5023, 'Channel: %s publicity set to: %u');
\ No newline at end of file
diff --git a/sql/world.sql b/sql/world.sql
index 9d9c6cb9cc5..de34753cf69 100644
--- a/sql/world.sql
+++ b/sql/world.sql
@@ -355,6 +355,7 @@ INSERT INTO `command` VALUES
 ('character rename','2','Syntax: .character rename [$name]\r\n\r\nMark selected in game or by $name in command character for rename at next login.'),
 ('character reputation','2','Syntax: .character reputation [$player_name]\r\n\r\nShow reputation information for selected player or player find by $player_name.'),
 ('character titles',2,'Syntax: .character titles [$player_name]\r\n\r\nShow known titles list for selected player or player find by $player_name.'),
+('channel set public', 3, 'Syntax: .channel set public  $channel $public\r\n\r\nChange password-changing ability for a channel. 1 for possible, 0 for GM only.'),
 ('combatstop','2','Syntax: .combatstop [$playername]\r\nStop combat for selected character. If selected non-player then command applied to self. If $playername provided then attempt applied to online player $playername.'),
 ('cometome','3','SYntax: .cometome $parameter\nMake selected creature come to your current location (new position not saved to DB).'),
 ('commands','0','Syntax: .commands\r\n\r\nDisplay a list of available commands for your account level.'),
@@ -14788,6 +14789,7 @@ INSERT INTO `trinity_string` (`entry`,`content_default`,`content_loc1`,`content_
 (5020, 'Phasemask: %u', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
 (5021, 'Armor: %u', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
 (5022, 'Channel password not changed due to channel being marked public. GM Powers required.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(5023, 'Channel: %s publicity set to: %u', 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