Core/Scenes: Implemented scene system

Closes #17858
Closes #17976

3 files changed, 76 insertions, 0 deletions

diff --git a/sql/updates/auth/6.x/2016_09_25_00_auth.sql b/sql/updates/auth/6.x/2016_09_25_00_auth.sql
new file mode 100644
index 00000000000..0720f6b6964
--- /dev/null
+++ b/sql/updates/auth/6.x/2016_09_25_00_auth.sql
@@ -0,0 +1,19 @@
+DELETE FROM `rbac_permissions` WHERE `id` IN (844, 845, 846, 847, 848, 849, 850);
+INSERT INTO `rbac_permissions` (`id`, `name`) VALUES
+(844, 'Command: scene'),
+(845, 'Command: scene debug'),
+(846, 'Command: scene play'),
+(847, 'Command: scene play package'),
+(848, 'Command: scene cancel'),
+(849, 'Command: list scenes'),
+(850, 'Command: reload scenes');
+
+DELETE FROM `rbac_linked_permissions` WHERE `linkedId` IN (844, 845, 846, 847, 848, 849, 850);
+INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES
+(192, 844),
+(192, 845),
+(192, 846),
+(192, 847),
+(192, 848),
+(192, 849),
+(192, 850);
diff --git a/sql/updates/hotfixes/6.x/2016_09_25_00_hotfixes.sql b/sql/updates/hotfixes/6.x/2016_09_25_00_hotfixes.sql
new file mode 100644
index 00000000000..16008ba7501
--- /dev/null
+++ b/sql/updates/hotfixes/6.x/2016_09_25_00_hotfixes.sql
@@ -0,0 +1,24 @@
+--
+-- Table structure for table `scene_script`
+--
+DROP TABLE IF EXISTS `scene_script`;
+CREATE TABLE `scene_script` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `Name` text,
+  `Script` text,
+  `PrevScriptId` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `NextScriptId` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Table structure for table `scene_script_package`
+--
+DROP TABLE IF EXISTS `scene_script_package`;
+CREATE TABLE `scene_script_package` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `Name` text,
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
diff --git a/sql/updates/world/6.x/2016_09_25_00_world.sql b/sql/updates/world/6.x/2016_09_25_00_world.sql
new file mode 100644
index 00000000000..609d0013964
--- /dev/null
+++ b/sql/updates/world/6.x/2016_09_25_00_world.sql
@@ -0,0 +1,33 @@
+DROP TABLE IF EXISTS `scene_template`;
+CREATE TABLE `scene_template` (
+  `SceneId` int(10) unsigned NOT NULL,
+  `Flags` int(10) unsigned NOT NULL DEFAULT '0',
+  `ScriptPackageID` int(10) unsigned NOT NULL DEFAULT '0',
+  `ScriptName` varchar(64) NOT NULL DEFAULT '',
+  PRIMARY KEY (`SceneId`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+DELETE FROM `command` WHERE `name`='debug send playscene';
+DELETE FROM `command` WHERE `name` IN ('scene','scene debug','scene play','scene play package','scene cancel','list scenes','reload scenes');
+INSERT INTO `command` (`name`,`permission`,`help`) VALUES
+('scene', 844, ''),
+('scene debug', 845, 'Syntax: .scene debug\nToggle debug mode for scenes. In debug mode GM will be notified in chat when scenes start/stop/trigger event'),
+('scene play', 846, 'Syntax: .scene play #sceneId\nPlays scene with id for targeted player'),
+('scene play package', 847, 'Syntax: .scene play package #scenePackageId #playbackFlags\nPlays scene with package id and playback flags for targeted player'),
+('scene cancel', 848, 'Syntax: .scene cancel #scenePackageId\nCancels scene with package id for targeted player'),
+('list scenes', 849, 'Syntax: .list scenes\nList of all active scenes for targeted character.'),
+('reload scenes', 850, 'Syntax: .reload scenes\nReload scene_template table.');
+
+DELETE FROM `trinity_string` WHERE `entry` IN (5062, 5063, 5064, 5065, 5066, 5067, 5068, 5069);
+INSERT INTO `trinity_string` (`entry`, `content_default`) VALUES
+(5062, 'Scene debugging turned on.'),
+(5063, 'Scene debugging turned off.'),
+(5064, 'Scene : started (instance : %u - package : %u - flags : %u)'),
+(5065, 'Scene : triggered (instance : %u - event : "%s")'),
+(5066, 'Scene : canceled (instance : %u)'),
+(5067, 'Scene : completed (instance : %u)'),
+(5068, 'Player have %u active(s) scene(s)'),
+(5069, 'ScenePackageId : %u - SceneInstanceId : %u');
+
+DELETE FROM `scene_template` WHERE `SceneId`=1181;
+INSERT INTO `scene_template` (`SceneId`, `Flags`, `ScriptPackageID`, `ScriptName`) VALUES (1181, 16, 1550, "scene_deathwing_simulator");