Core/Commands: Make vehicle_accessory and vehicle_template_accessory reloadable with commands

2 files changed, 6 insertions, 0 deletions

diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql
index e0b20e33b61..1bdfa3c6dbd 100644
--- a/sql/base/world_database.sql
+++ b/sql/base/world_database.sql
@@ -650,6 +650,8 @@ INSERT INTO `command` VALUES
 ('reload spell_target_position',3,'Syntax: .reload spell_target_position\nReload spell_target_position table.'),
 ('reload spell_threats',3,'Syntax: .reload spell_threats\nReload spell_threats table.'),
 ('reload trinity_string',3,'Syntax: .reload trinity_string\nReload trinity_string table.'),
+('reload vehicle_accessory', 3, 'Syntax: .reload vehicle_accessory\n\nReloads GUID-based vehicle accessory definitions from the database.'),
+('reload vehicle_template_accessory', 3, 'Syntax: .reload vehicle_template_accessory\n\nReloads entry-based vehicle accessory definitions from the database.'),
 ('reload waypoint_scripts',3,'Syntax: .reload waypoint_scripts\nReload waypoint_scripts table.'),
 ('repairitems',2,'Syntax: .repairitems\r\n\r\nRepair all selected player''s items.'),
 ('reset',3,'Syntax: .reset $subcommand\nType .reset to see the list of possible subcommands or .help reset $subcommand to see info on subcommands'),
diff --git a/sql/updates/world/2011_03_07_4_world_command.sql b/sql/updates/world/2011_03_07_4_world_command.sql
new file mode 100644
index 00000000000..4e4ed529107
--- /dev/null
+++ b/sql/updates/world/2011_03_07_4_world_command.sql
@@ -0,0 +1,4 @@
+DELETE FROM `command` WHERE `name` IN('reload vehicle_accessory','reload vehicle_template_accessory');
+INSERT INTO `command` (`name`,`security`,`help`) VALUES
+('reload vehicle_accessory', 3, 'Syntax: .reload vehicle_accessory\n\nReloads GUID-based vehicle accessory definitions from the database.'),
+('reload vehicle_template_accessory', 3, 'Syntax: .reload vehicle_template_accessory\n\nReloads entry-based vehicle accessory definitions from the database.');