aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorWyrserth <43747507+Wyrserth@users.noreply.github.com>2019-06-16 19:52:13 +0200
committerGiacomo Pozzoni <giacomopoz@gmail.com>2019-06-16 19:52:13 +0200
commitce3dcdcb1ad1887fb3a531aaea09482c12b5e4f3 (patch)
treeb4095b86f3a385a0e3e7d6ab6fef4c0e38c2ef16 /sql/updates
parent14c2bdc5dac81f5f2b76d78b09c1224dbebcd8bc (diff)
Core/Commands: implement commands to look up a map/item/quest name for a given id (#23416)
* Core/Commands: implement commands to look up a map/item/quest name for a given id. * Add entry to updates table. * Rename 9999_99_99_99_auth.sql to 2019_06_16_00_auth.sql * Add missed change, thanks jackpoz! * Update auth_database.sql
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/auth/3.3.5/2019_06_16_00_auth.sql10
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/auth/3.3.5/2019_06_16_00_auth.sql b/sql/updates/auth/3.3.5/2019_06_16_00_auth.sql
new file mode 100644
index 00000000000..627e4dcab5d
--- /dev/null
+++ b/sql/updates/auth/3.3.5/2019_06_16_00_auth.sql
@@ -0,0 +1,10 @@
+DELETE FROM `rbac_permissions` WHERE `id` IN (875, 876, 877);
+INSERT INTO `rbac_permissions` (`id`, `name`) VALUES
+(875, "Command: lookup map id"),
+(876, "Command: lookup item id"),
+(877, "Command: lookup quest id");
+
+INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES
+(196, 875),
+(196, 876),
+(196, 877);