diff options
| author | DDuarte <dnpd.dd@gmail.com> | 2014-10-19 00:18:06 +0100 |
|---|---|---|
| committer | DDuarte <dnpd.dd@gmail.com> | 2014-10-19 00:18:06 +0100 |
| commit | 5bf55eacfdf7cfd0036bf51e78a2f04f9b55feb0 (patch) | |
| tree | 9653ff7011d0b370c1360e09590c09ebec4f7e9a /sql/updates/auth | |
| parent | e07d3ebe4e6d2d797cb77ba65fb52efbef3462d9 (diff) | |
| parent | 15a9c6729ee274044b2ba78f8b9ad3c167c94bd1 (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.sql | 9 | ||||
| -rw-r--r-- | sql/updates/auth/2014_10_18_01_auth.sql | 23 |
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); |
