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

3 files changed, 3 insertions, 0 deletions

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),