DB/Commands: Add some missing entries to commands table.;

Author: svetilo12
Closes issue #5015

--HG--
branch : trunk

2 files changed, 23 insertions, 3 deletions

diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql
index cfcd30f5359..4309a3b3d58 100644
--- a/sql/base/world_database.sql
+++ b/sql/base/world_database.sql
@@ -559,7 +559,13 @@ INSERT INTO `command` VALUES
 ('quest remove',3,'Syntax: .quest remove #quest_id\r\n\r\nSet quest #quest_id state to not completed and not active (and remove from active quest list) for selected player.'),
 ('recall',1,'Syntax: .recall [$playername]\r\n\r\nTeleport $playername or selected player to the place where he has been before last use of a teleportation command. If no $playername is entered and no player is selected, it will teleport you.'),
 ('reload',3,'Syntax: .reload $subcommand\nType .reload to see the list of possible subcommands or .help reload $subcommand to see info on subcommands'),
+('reload access_requirement',3,'Syntax: .reload access_requirement\nReload access_requirement table.'),
+('reload achievement_criteria_data',3,'Syntax: .reload achievement_criteria_data\nReload achievement_criteria_data table.'),
+('reload achievement_reward',3,'Syntax: .reload achievement_reward\nReload achievement_reward table.'),
 ('reload all',3,'Syntax: .reload all\r\n\r\nReload all tables with reload support added and that can be _safe_ reloaded.'),
+('reload all achievement',3,'Syntax: .reload all achievement\r\n\r\nReload achievement_reward, achievement_criteria_data tables.'),
+('reload all area',3,'Syntax: .reload all area\r\n\r\nReload areatrigger_teleport, areatrigger_tavern, game_graveyard_zone tables.'),
+('reload all eventai',3,'Syntax: .reload all eventai\r\n\r\nReload creature_ai_scripts, creature_ai_summons, creature_ai_texts tables.'),
 ('reload all gossips',3,'Syntax: .reload all gossips\nReload gossip_menu, gossip_menu_option, gossip_scripts, npc_gossip, points_of_interest tables.'),
 ('reload all item',3,'Syntax: .reload all item\nReload page_text, item_enchantment_table tables.'),
 ('reload all locales',3,'Syntax: .reload all locales\r\n\r\nReload all `locales_*` tables with reload support added and that can be _safe_ reloaded.'),
@@ -571,6 +577,7 @@ INSERT INTO `command` VALUES
 ('reload areatrigger_involvedrelation',3,'Syntax: .reload areatrigger_involvedrelation\nReload areatrigger_involvedrelation table.'),
 ('reload areatrigger_tavern',3,'Syntax: .reload areatrigger_tavern\nReload areatrigger_tavern table.'),
 ('reload areatrigger_teleport',3,'Syntax: .reload areatrigger_teleport\nReload areatrigger_teleport table.'),
+('reload auctions',3,'Syntax: .reload auctions\nReload dynamic data tables from the database.'),
 ('reload autobroadcast',3,'Syntax: .reload autobroadcast\nReload autobroadcast table.'),
 ('reload command',3,'Syntax: .reload command\nReload command table.'),
 ('reload conditions', 3, 'Reload conditions table.'),
@@ -580,6 +587,8 @@ INSERT INTO `command` VALUES
 ('reload creature_loot_template',3,'Syntax: .reload creature_loot_template\nReload creature_loot_template table.'),
 ('reload creature_onkill_reputation','3','Syntax: .reload creature_onkill_reputation\r\nReload creature_onkill_reputation table.'),
 ('reload creature_questrelation',3,'Syntax: .reload creature_questrelation\nReload creature_questrelation table.'),
+('reload creature_template','3','Syntax: .reload creature_template $entry\r\nReload the specified creature''s template.'),
+('reload creature_text',3,'Syntax: .reload creature_text\r\nReload creature_text table.'),
 ('reload disables',3,'Syntax: .reload disables\r\nReload disables table.'),
 ('reload disenchant_loot_template',3,'Syntax: .reload disenchant_loot_template\nReload disenchant_loot_template table.'),
 ('reload event_scripts',3,'Syntax: .reload event_scripts\nReload event_scripts table.'),
@@ -608,6 +617,8 @@ INSERT INTO `command` VALUES
 ('reload locales_page_text',3,'Syntax: .reload locales_page_text\nReload locales_page_text table.'),
 ('reload locales_points_of_interest',3,'Syntax: .reload locales_points_of_interest\nReload locales_point_of_interest table.'),
 ('reload locales_quest',3,'Syntax: .reload locales_quest\nReload locales_quest table.'),
+('reload mail_level_reward',3,'Syntax: .reload mail_level_reward\nReload mail_level_reward table.'),
+('reload mail_loot_template',3,'Syntax: .reload mail_loot_template\nReload mail_loot_template table.'),
 ('reload milling_loot_template',3,'Syntax: .reload milling_loot_template\nReload milling_loot_template table.'),
 ('reload npc_gossip',3,'Syntax: .reload npc_gossip\nReload npc_gossip table.'),
 ('reload npc_trainer',3,'Syntax: .reload npc_trainer\nReload npc_trainer table.'),
@@ -617,7 +628,6 @@ INSERT INTO `command` VALUES
 ('reload points_of_interest',3,'Syntax: .reload points_of_interest\nReload points_of_interest table.'),
 ('reload prospecting_loot_template',3,'Syntax: .reload prospecting_loot_template\nReload prospecting_loot_template table.'),
 ('reload quest_end_scripts',3,'Syntax: .reload quest_end_scripts\nReload quest_end_scripts table.'),
-('reload mail_loot_template',3,'Syntax: .reload mail_loot_template\nReload mail_loot_template table.'),
 ('reload quest_poi',3,'Syntax: .reload quest_poi\nReload quest_poi table.'),
 ('reload quest_start_scripts',3,'Syntax: .reload quest_start_scripts\nReload quest_start_scripts table.'),
 ('reload quest_template',3,'Syntax: .reload quest_template\nReload quest_template table.'),
@@ -627,6 +637,7 @@ INSERT INTO `command` VALUES
 ('reload skill_extra_item_template',3,'Syntax: .reload skill_extra_item_template\nReload skill_extra_item_template table.'),
 ('reload skill_fishing_base_level',3,'Syntax: .reload skill_fishing_base_level\nReload skill_fishing_base_level table.'),
 ('reload skinning_loot_template',3,'Syntax: .reload skinning_loot_template\nReload skinning_loot_template table.'),
+('reload smart_scripts',3,'Syntax: .reload smart_scripts\nReload smart_scripts table.'),
 ('reload spell_area',3,'Syntax: .reload spell_area\nReload spell_area table.'),
 ('reload spell_bonus_data',3,'Syntax: .reload spell_bonus_data\nReload spell_bonus_data table.'),
 ('reload spell_group',3,'Syntax: .reload spell_group\nReload spell_group table.'),
@@ -640,10 +651,8 @@ INSERT INTO `command` VALUES
 ('reload spell_scripts',3,'Syntax: .reload spell_scripts\nReload spell_scripts table.'),
 ('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 creature_template','3','Syntax: .reload creature_template $entry\r\nReload the specified creature''s template.'),
 ('reload trinity_string',3,'Syntax: .reload trinity_string\nReload trinity_string table.'),
 ('reload waypoint_scripts',3,'Syntax: .reload waypoint_scripts\nReload waypoint_scripts table.'),
-('reload creature_text',3,'Syntax: .reload creature_text\r\nReload creature_text 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'),
 ('reset achievements',3,'Syntax: .reset achievements [$playername]\r\n\r\nReset achievements data for selected or named (online or offline) character. Achievements for persistance progress data like completed quests/etc re-filled at reset. Achievements for events like kills/casts/etc will lost.'),
diff --git a/sql/updates/10681_world_command.sql b/sql/updates/10681_world_command.sql
new file mode 100644
index 00000000000..b91b64ae152
--- /dev/null
+++ b/sql/updates/10681_world_command.sql
@@ -0,0 +1,11 @@
+DELETE FROM `command` WHERE `name` IN ('reload access_requirement','reload achievement_criteria_data','reload achievement_reward','reload all achievement','reload all area','reload all eventai','reload auctions','reload mail_level_reward','reload smart_scripts');
+INSERT INTO `command` (`name`,`security`,`help`) VALUES
+('reload access_requirement',3,'Syntax: .reload access_requirement\nReload access_requirement table.'),
+('reload achievement_criteria_data',3,'Syntax: .reload achievement_criteria_data\nReload achievement_criteria_data table.'),
+('reload achievement_reward',3,'Syntax: .reload achievement_reward\nReload achievement_reward table.'),
+('reload all achievement',3,'Syntax: .reload all achievement\r\n\r\nReload achievement_reward, achievement_criteria_data tables.'),
+('reload all area',3,'Syntax: .reload all area\r\n\r\nReload areatrigger_teleport, areatrigger_tavern, game_graveyard_zone tables.'),
+('reload all eventai',3,'Syntax: .reload all eventai\r\n\r\nReload creature_ai_scripts, creature_ai_summons, creature_ai_texts tables.'),
+('reload auctions',3,'Syntax: .reload auctions\nReload dynamic data tables from the database.'),
+('reload mail_level_reward',3,'Syntax: .reload mail_level_reward\nReload mail_level_reward table.'),
+('reload smart_scripts',3,'Syntax: .reload smart_scripts\nReload smart_scripts table.');