From ae43820ca0db692d1ff176b216ab641cc4760d49 Mon Sep 17 00:00:00 2001 From: Wyrserth <43747507+Wyrserth@users.noreply.github.com> Date: Sun, 16 Jun 2019 19:52:13 +0200 Subject: 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 (cherry picked from commit ce3dcdcb1ad1887fb3a531aaea09482c12b5e4f3) --- sql/updates/auth/master/2019_06_16_00_auth.sql | 10 ++++++++++ 1 file changed, 10 insertions(+) create mode 100644 sql/updates/auth/master/2019_06_16_00_auth.sql (limited to 'sql/updates/auth') diff --git a/sql/updates/auth/master/2019_06_16_00_auth.sql b/sql/updates/auth/master/2019_06_16_00_auth.sql new file mode 100644 index 00000000000..627e4dcab5d --- /dev/null +++ b/sql/updates/auth/master/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); -- cgit v1.2.3