diff options
| author | Wyrserth <43747507+Wyrserth@users.noreply.github.com> | 2019-06-16 19:52:13 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2021-12-11 14:12:54 +0100 |
| commit | ae43820ca0db692d1ff176b216ab641cc4760d49 (patch) | |
| tree | b1ec0f6220496b81c08e5630d3143f8e70c28d66 /sql/updates | |
| parent | 01be9f44af0687f03c34f0221dc285ec22803969 (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
(cherry picked from commit ce3dcdcb1ad1887fb3a531aaea09482c12b5e4f3)
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/auth/master/2019_06_16_00_auth.sql | 10 | ||||
| -rw-r--r-- | sql/updates/world/master/2021_12_11_12_world.sql | 3 |
2 files changed, 13 insertions, 0 deletions
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); diff --git a/sql/updates/world/master/2021_12_11_12_world.sql b/sql/updates/world/master/2021_12_11_12_world.sql new file mode 100644 index 00000000000..811e1f046e5 --- /dev/null +++ b/sql/updates/world/master/2021_12_11_12_world.sql @@ -0,0 +1,3 @@ +DELETE FROM `trinity_string` WHERE `entry`=5088; +INSERT INTO `trinity_string` (`entry`,`content_default`) VALUES +(5088,'[Scenario]'); |