Scripts/Commands: Implement commands to set and get boss states during run time

Closes #13186

2 files changed, 18 insertions, 0 deletions

diff --git a/sql/updates/auth/2014_10_18_00_auth.sql b/sql/updates/auth/2014_10_18_00_auth.sql
new file mode 100644
index 00000000000..fbae94a4195
--- /dev/null
+++ b/sql/updates/auth/2014_10_18_00_auth.sql
@@ -0,0 +1,9 @@
+DELETE FROM `rbac_permissions` WHERE `id` IN (795, 796);
+INSERT INTO `rbac_permissions` (`id`, `name`) VALUES
+(795, 'Command: .instance setbossstate'),
+(796, 'Command: .instance getbossstate');
+
+DELETE FROM `rbac_linked_permissions` WHERE `linkedId` IN (795, 796);
+INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES
+(192, 795),
+(192, 796);
diff --git a/sql/updates/world/2014_10_18_02_world.sql b/sql/updates/world/2014_10_18_02_world.sql
new file mode 100644
index 00000000000..564e3dc125b
--- /dev/null
+++ b/sql/updates/world/2014_10_18_02_world.sql
@@ -0,0 +1,9 @@
+DELETE FROM `trinity_string` WHERE `entry` IN (5057, 5058);
+INSERT INTO `trinity_string` (`entry`, `content_default`) VALUES
+(5057, 'Boss id %i state is now set to %i.'),
+(5058, 'Boss id %i state is %i.');
+
+DELETE FROM `command` WHERE `permission` IN (795, 796);
+INSERT INTO `command` (`name`, `permission`, `help`) VALUES
+('instance setbossstate', '795', 'Syntax: .instance setbossstate $bossId $encounterState [$Name]\r\nSets the EncounterState for the given boss id to a new value. EncounterStates range from 0 to 5.\r\nIf no character name is provided, the current map will be used as target.'),
+('instance getbossstate', '796', 'Syntax: .instance getbossstate $bossId [$Name]\r\nGets the current EncounterState for the provided boss id.\r\nIf no character name is provided, the current map will be used as target.');