aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorShauren <shauren.trinity@gmail.com>2020-12-31 13:01:33 +0100
committerShauren <shauren.trinity@gmail.com>2020-12-31 14:13:29 +0100
commit4ca15ec065289e12ce95962b3afd89445e141a97 (patch)
treed2a7d748d55849b1a27972e364bba7798c13a37b /sql/updates
parentc7b10d3c5fd082faf6c2835239e340babc3dfc76 (diff)
Core/Commands: Add .reload vehicle_template
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/auth/master/2020_12_31_00_auth.sql7
-rw-r--r--sql/updates/world/master/2020_12_31_00_world.sql6
2 files changed, 13 insertions, 0 deletions
diff --git a/sql/updates/auth/master/2020_12_31_00_auth.sql b/sql/updates/auth/master/2020_12_31_00_auth.sql
new file mode 100644
index 00000000000..44d29e41def
--- /dev/null
+++ b/sql/updates/auth/master/2020_12_31_00_auth.sql
@@ -0,0 +1,7 @@
+DELETE FROM `rbac_permissions` WHERE `id`=881;
+INSERT INTO `rbac_permissions` (`id`,`name`) VALUES
+(881, 'Command: reload vehicle_template');
+
+DELETE FROM `rbac_linked_permissions` WHERE `linkedId`=881;
+INSERT INTO `rbac_linked_permissions` (`id`,`linkedId`) VALUES
+(196,881);
diff --git a/sql/updates/world/master/2020_12_31_00_world.sql b/sql/updates/world/master/2020_12_31_00_world.sql
index 15be0e0e2a7..b974c0abba2 100644
--- a/sql/updates/world/master/2020_12_31_00_world.sql
+++ b/sql/updates/world/master/2020_12_31_00_world.sql
@@ -7,3 +7,9 @@ CREATE TABLE `vehicle_template` (
`despawnDelayMs` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`creatureId`)
) ENGINE=MyISAM;
+
+DELETE FROM `command` WHERE `name`='reload vehicle_template';
+INSERT INTO `command` (`name`,`permission`,`help`) VALUES
+('reload vehicle_template', 881, "Syntax: .reload vehicle_template
+
+Reloads vehicle template definitions from the database.");