aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/auth
diff options
context:
space:
mode:
authorDDuarte <dnpd.dd@gmail.com>2014-10-19 00:18:06 +0100
committerDDuarte <dnpd.dd@gmail.com>2014-10-19 00:18:06 +0100
commit5bf55eacfdf7cfd0036bf51e78a2f04f9b55feb0 (patch)
tree9653ff7011d0b370c1360e09590c09ebec4f7e9a /sql/updates/auth
parente07d3ebe4e6d2d797cb77ba65fb52efbef3462d9 (diff)
parent15a9c6729ee274044b2ba78f8b9ad3c167c94bd1 (diff)
Merge remote-tracking branch 'origin/3.3.5' into 4.3.4
Conflicts: sql/base/auth_database.sql src/server/game/Instances/InstanceScript.h src/server/scripts/Northrend/isle_of_conquest.cpp src/server/shared/Database/Implementation/LoginDatabase.cpp src/server/shared/Database/Implementation/LoginDatabase.h
Diffstat (limited to 'sql/updates/auth')
-rw-r--r--sql/updates/auth/2014_10_18_00_auth.sql9
-rw-r--r--sql/updates/auth/2014_10_18_01_auth.sql23
2 files changed, 32 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/auth/2014_10_18_01_auth.sql b/sql/updates/auth/2014_10_18_01_auth.sql
new file mode 100644
index 00000000000..60808b8a9c9
--- /dev/null
+++ b/sql/updates/auth/2014_10_18_01_auth.sql
@@ -0,0 +1,23 @@
+/* drop then create account_muted table */
+DROP TABLE IF EXISTS `account_muted`;
+
+CREATE TABLE `account_muted` (
+ `guid` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
+ `mutedate` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+ `mutetime` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+ `mutedby` VARCHAR(50) NOT NULL,
+ `mutereason` VARCHAR(255) NOT NULL,
+ PRIMARY KEY (`guid`, `mutedate`)
+)
+COMMENT='mute List' ENGINE=InnoDB;
+
+/* add rbac permissions to new commands */
+DELETE FROM `rbac_permissions` WHERE `id`=632;
+INSERT INTO `rbac_permissions` (`id`,`name`) VALUES
+(632, 'Command: .mutehistory');
+
+/* adds qc to players */
+DELETE FROM `rbac_linked_permissions` WHERE `id`=632;
+INSERT INTO `rbac_linked_permissions` (`id`,`linkedId`) VALUES
+/* add mutehistory to gms */
+(194, 632);