From c76cb0ce7cae42970ac1b0792a9ee4ed33a23386 Mon Sep 17 00:00:00 2001
From: Tartalo <none@none>
Date: Thu, 25 Feb 2010 16:26:03 +0100
Subject: Add new flagged column to access_requirement to set instances
 opened/closed. This way is possible to open a raid on 10man mode while the
 rest of modes are closed (for example). Ingame commands to open/close
 instances coming soon ;)

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

(limited to 'sql')

diff --git a/sql/updates/7432_world_access_requirement.sql b/sql/updates/7432_world_access_requirement.sql
new file mode 100644
index 00000000000..fcaabd1de2f
--- /dev/null
+++ b/sql/updates/7432_world_access_requirement.sql
@@ -0,0 +1 @@
+ALTER TABLE `access_requirement` ADD COLUMN `status` TINYINT UNSIGNED DEFAULT 15 COMMENT 'instance status (open/close)';
diff --git a/sql/updates/7432_world_trinity_string.sql b/sql/updates/7432_world_trinity_string.sql
new file mode 100644
index 00000000000..798cebb91be
--- /dev/null
+++ b/sql/updates/7432_world_trinity_string.sql
@@ -0,0 +1 @@
+INSERT INTO `trinity_string` (`entry`,`content_default`) VALUES (5008,'This instance is closed.');
diff --git a/sql/world.sql b/sql/world.sql
index de34753cf69..8d506e55f65 100644
--- a/sql/world.sql
+++ b/sql/world.sql
@@ -14775,6 +14775,7 @@ INSERT INTO `trinity_string` (`entry`,`content_default`,`content_loc1`,`content_
 (5005, 'Following players are frozen on the server:', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
 (5006, '- %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
 (5007, 'You must be in a raid group to enter this instance.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(5008, 'This instance is closed.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
 (5009, 'Sound %u Played to server', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
 (5010, 'linkGUID: %u, Entry: %u (%s)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
 (5011, 'You can''t teleport self to self!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
-- 
cgit v1.2.3