Core/RBAC: Move reload command to RBAC (using individual permissions)

2 files changed, 325 insertions, 0 deletions

diff --git a/sql/updates/auth/2013_09_10_08_auth_misc.sql b/sql/updates/auth/2013_09_10_08_auth_misc.sql
new file mode 100644
index 00000000000..c735009b7da
--- /dev/null
+++ b/sql/updates/auth/2013_09_10_08_auth_misc.sql
@@ -0,0 +1,217 @@
+/* cs_reload.cpp */
+
+SET @id = 607;
+
+-- Add new permissions
+DELETE FROM `rbac_permissions` WHERE `id` BETWEEN @id AND @id+102;
+INSERT INTO `rbac_permissions` (`id`, `name`) VALUES
+(@id+0, 'reload'),
+(@id+1, 'reload access_requirement'),
+(@id+2, 'reload achievement_criteria_data'),
+(@id+3, 'reload achievement_reward'),
+(@id+4, 'reload all'),
+(@id+5, 'reload all achievement'),
+(@id+6, 'reload all area'),
+(@id+7, 'reload all eventai'),
+(@id+8, 'reload all gossips'),
+(@id+9, 'reload all item'),
+(@id+10, 'reload all locales'),
+(@id+11, 'reload all loot'),
+(@id+12, 'reload all npc'),
+(@id+13, 'reload all quest'),
+(@id+14, 'reload all scripts'),
+(@id+15, 'reload all spell'),
+(@id+16, 'reload areatrigger_involvedrelation'),
+(@id+17, 'reload areatrigger_tavern'),
+(@id+18, 'reload areatrigger_teleport'),
+(@id+19, 'reload auctions'),
+(@id+20, 'reload autobroadcast'),
+(@id+21, 'reload command'),
+(@id+22, 'reload conditions'),
+(@id+23, 'reload config'),
+(@id+24, 'reload creature_text'),
+(@id+25, 'reload creature_ai_scripts'),
+(@id+26, 'reload creature_ai_texts'),
+(@id+27, 'reload creature_questender'),
+(@id+28, 'reload creature_linked_respawn'),
+(@id+29, 'reload creature_loot_template'),
+(@id+30, 'reload creature_onkill_reputation'),
+(@id+31, 'reload creature_queststarter'),
+(@id+32, 'reload creature_summon_groups'),
+(@id+33, 'reload creature_template'),
+(@id+34, 'reload disables'),
+(@id+35, 'reload disenchant_loot_template'),
+(@id+36, 'reload event_scripts'),
+(@id+37, 'reload fishing_loot_template'),
+(@id+38, 'reload game_graveyard_zone'),
+(@id+39, 'reload game_tele'),
+(@id+40, 'reload gameobject_questender'),
+(@id+41, 'reload gameobject_loot_template'),
+(@id+42, 'reload gameobject_queststarter'),
+(@id+43, 'reload gm_tickets'),
+(@id+44, 'reload gossip_menu'),
+(@id+45, 'reload gossip_menu_option'),
+(@id+46, 'reload item_enchantment_template'),
+(@id+47, 'reload item_loot_template'),
+(@id+48, 'reload item_set_names'),
+(@id+49, 'reload lfg_dungeon_rewards'),
+(@id+50, 'reload locales_achievement_reward'),
+(@id+51, 'reload locales_creature'),
+(@id+52, 'reload locales_creature_text'),
+(@id+53, 'reload locales_gameobject'),
+(@id+54, 'reload locales_gossip_menu_option'),
+(@id+55, 'reload locales_item'),
+(@id+56, 'reload locales_item_set_name'),
+(@id+57, 'reload locales_npc_text'),
+(@id+58, 'reload locales_page_text'),
+(@id+59, 'reload locales_points_of_interest'),
+(@id+60, 'reload locales_quest'),
+(@id+61, 'reload mail_level_reward'),
+(@id+62, 'reload mail_loot_template'),
+(@id+63, 'reload milling_loot_template'),
+(@id+64, 'reload npc_spellclick_spells'),
+(@id+65, 'reload npc_trainer'),
+(@id+66, 'reload npc_vendor'),
+(@id+67, 'reload page_text'),
+(@id+68, 'reload pickpocketing_loot_template'),
+(@id+69, 'reload points_of_interest'),
+(@id+70, 'reload prospecting_loot_template'),
+(@id+71, 'reload quest_poi'),
+(@id+72, 'reload quest_template'),
+(@id+73, 'reload rbac'),
+(@id+74, 'reload reference_loot_template'),
+(@id+75, 'reload reserved_name'),
+(@id+76, 'reload reputation_reward_rate'),
+(@id+77, 'reload reputation_spillover_template'),
+(@id+78, 'reload skill_discovery_template'),
+(@id+79, 'reload skill_extra_item_template'),
+(@id+80, 'reload skill_fishing_base_level'),
+(@id+81, 'reload skinning_loot_template'),
+(@id+82, 'reload smart_scripts'),
+(@id+83, 'reload spell_required'),
+(@id+84, 'reload spell_area'),
+(@id+85, 'reload spell_bonus_data'),
+(@id+86, 'reload spell_group'),
+(@id+87, 'reload spell_learn_spell'),
+(@id+88, 'reload spell_loot_template'),
+(@id+89, 'reload spell_linked_spell'),
+(@id+90, 'reload spell_pet_auras'),
+(@id+91, 'reload spell_proc_event'),
+(@id+92, 'reload spell_proc'),
+(@id+93, 'reload spell_scripts'),
+(@id+94, 'reload spell_target_position'),
+(@id+95, 'reload spell_threats'),
+(@id+96, 'reload spell_group_stack_rules'),
+(@id+97, 'reload trinity_string'),
+(@id+98, 'reload warden_action'),
+(@id+99, 'reload waypoint_scripts'),
+(@id+100, 'reload waypoint_data'),
+(@id+101, 'reload vehicle_accessory'),
+(@id+102, 'reload vehicle_template_accessory');
+
+-- Add permissions to "corresponding Commands Role"
+DELETE FROM `rbac_role_permissions` WHERE `permissionId` BETWEEN @id AND @id+102;
+INSERT INTO `rbac_role_permissions` (`roleId`, `permissionId`) VALUES
+(4, @id+0),
+(4, @id+1),
+(4, @id+2),
+(4, @id+3),
+(4, @id+4),
+(4, @id+5),
+(4, @id+6),
+(4, @id+7),
+(4, @id+8),
+(4, @id+9),
+(4, @id+10),
+(4, @id+11),
+(4, @id+12),
+(4, @id+13),
+(4, @id+14),
+(4, @id+15),
+(4, @id+16),
+(4, @id+17),
+(4, @id+18),
+(4, @id+19),
+(4, @id+20),
+(4, @id+21),
+(4, @id+22),
+(4, @id+23),
+(4, @id+24),
+(4, @id+25),
+(4, @id+26),
+(4, @id+27),
+(4, @id+28),
+(4, @id+29),
+(4, @id+30),
+(4, @id+31),
+(4, @id+32),
+(4, @id+33),
+(4, @id+34),
+(4, @id+35),
+(4, @id+36),
+(4, @id+37),
+(4, @id+38),
+(4, @id+39),
+(4, @id+40),
+(4, @id+41),
+(4, @id+42),
+(4, @id+43),
+(4, @id+44),
+(4, @id+45),
+(4, @id+46),
+(4, @id+47),
+(4, @id+48),
+(4, @id+49),
+(4, @id+50),
+(4, @id+51),
+(4, @id+52),
+(4, @id+53),
+(4, @id+54),
+(4, @id+55),
+(4, @id+56),
+(4, @id+57),
+(4, @id+58),
+(4, @id+59),
+(4, @id+60),
+(4, @id+61),
+(4, @id+62),
+(4, @id+63),
+(4, @id+64),
+(4, @id+65),
+(4, @id+66),
+(4, @id+67),
+(4, @id+68),
+(4, @id+69),
+(4, @id+70),
+(4, @id+71),
+(4, @id+72),
+(4, @id+73),
+(4, @id+74),
+(4, @id+75),
+(4, @id+76),
+(4, @id+77),
+(4, @id+78),
+(4, @id+79),
+(4, @id+80),
+(4, @id+81),
+(4, @id+82),
+(4, @id+83),
+(4, @id+84),
+(4, @id+85),
+(4, @id+86),
+(4, @id+87),
+(4, @id+88),
+(4, @id+89),
+(4, @id+90),
+(4, @id+91),
+(4, @id+92),
+(4, @id+93),
+(4, @id+94),
+(4, @id+95),
+(4, @id+96),
+(4, @id+97),
+(4, @id+98),
+(4, @id+99),
+(4, @id+100),
+(4, @id+101),
+(4, @id+102);
diff --git a/sql/updates/world/2013_09_10_10_world_command.sql b/sql/updates/world/2013_09_10_10_world_command.sql
new file mode 100644
index 00000000000..4249ff1ad5b
--- /dev/null
+++ b/sql/updates/world/2013_09_10_10_world_command.sql
@@ -0,0 +1,108 @@
+/* cs_npc.cpp */
+
+SET @id = 607;
+
+-- Update command table with new RBAC permissions
+UPDATE `command` SET `permission` = @id+0 WHERE `name` = 'reload';
+UPDATE `command` SET `permission` = @id+1 WHERE `name` = 'reload access_requirement';
+UPDATE `command` SET `permission` = @id+2 WHERE `name` = 'reload achievement_criteria_data';
+UPDATE `command` SET `permission` = @id+3 WHERE `name` = 'reload achievement_reward';
+UPDATE `command` SET `permission` = @id+4 WHERE `name` = 'reload all';
+UPDATE `command` SET `permission` = @id+5 WHERE `name` = 'reload all achievement';
+UPDATE `command` SET `permission` = @id+6 WHERE `name` = 'reload all area';
+UPDATE `command` SET `permission` = @id+7 WHERE `name` = 'reload all eventai';
+UPDATE `command` SET `permission` = @id+8 WHERE `name` = 'reload all gossips';
+UPDATE `command` SET `permission` = @id+9 WHERE `name` = 'reload all item';
+UPDATE `command` SET `permission` = @id+10 WHERE `name` = 'reload all locales';
+UPDATE `command` SET `permission` = @id+11 WHERE `name` = 'reload all loot';
+UPDATE `command` SET `permission` = @id+12 WHERE `name` = 'reload all npc';
+UPDATE `command` SET `permission` = @id+13 WHERE `name` = 'reload all quest';
+UPDATE `command` SET `permission` = @id+14 WHERE `name` = 'reload all scripts';
+UPDATE `command` SET `permission` = @id+15 WHERE `name` = 'reload all spell';
+UPDATE `command` SET `permission` = @id+16 WHERE `name` = 'reload areatrigger_involvedrelation';
+UPDATE `command` SET `permission` = @id+17 WHERE `name` = 'reload areatrigger_tavern';
+UPDATE `command` SET `permission` = @id+18 WHERE `name` = 'reload areatrigger_teleport';
+UPDATE `command` SET `permission` = @id+19 WHERE `name` = 'reload auctions';
+UPDATE `command` SET `permission` = @id+20 WHERE `name` = 'reload autobroadcast';
+UPDATE `command` SET `permission` = @id+21 WHERE `name` = 'reload command';
+UPDATE `command` SET `permission` = @id+22 WHERE `name` = 'reload conditions';
+UPDATE `command` SET `permission` = @id+23 WHERE `name` = 'reload config';
+UPDATE `command` SET `permission` = @id+24 WHERE `name` = 'reload creature_text';
+UPDATE `command` SET `permission` = @id+25 WHERE `name` = 'reload creature_ai_scripts';
+UPDATE `command` SET `permission` = @id+26 WHERE `name` = 'reload creature_ai_texts';
+UPDATE `command` SET `permission` = @id+27 WHERE `name` = 'reload creature_questender';
+UPDATE `command` SET `permission` = @id+28 WHERE `name` = 'reload creature_linked_respawn';
+UPDATE `command` SET `permission` = @id+29 WHERE `name` = 'reload creature_loot_template';
+UPDATE `command` SET `permission` = @id+30 WHERE `name` = 'reload creature_onkill_reputation';
+UPDATE `command` SET `permission` = @id+31 WHERE `name` = 'reload creature_queststarter';
+UPDATE `command` SET `permission` = @id+32 WHERE `name` = 'reload creature_summon_groups';
+UPDATE `command` SET `permission` = @id+33 WHERE `name` = 'reload creature_template';
+UPDATE `command` SET `permission` = @id+34 WHERE `name` = 'reload disables';
+UPDATE `command` SET `permission` = @id+35 WHERE `name` = 'reload disenchant_loot_template';
+UPDATE `command` SET `permission` = @id+36 WHERE `name` = 'reload event_scripts';
+UPDATE `command` SET `permission` = @id+37 WHERE `name` = 'reload fishing_loot_template';
+UPDATE `command` SET `permission` = @id+38 WHERE `name` = 'reload game_graveyard_zone';
+UPDATE `command` SET `permission` = @id+39 WHERE `name` = 'reload game_tele';
+UPDATE `command` SET `permission` = @id+40 WHERE `name` = 'reload gameobject_questender';
+UPDATE `command` SET `permission` = @id+41 WHERE `name` = 'reload gameobject_loot_template';
+UPDATE `command` SET `permission` = @id+42 WHERE `name` = 'reload gameobject_queststarter';
+UPDATE `command` SET `permission` = @id+43 WHERE `name` = 'reload gm_tickets';
+UPDATE `command` SET `permission` = @id+44 WHERE `name` = 'reload gossip_menu';
+UPDATE `command` SET `permission` = @id+45 WHERE `name` = 'reload gossip_menu_option';
+UPDATE `command` SET `permission` = @id+46 WHERE `name` = 'reload item_enchantment_template';
+UPDATE `command` SET `permission` = @id+47 WHERE `name` = 'reload item_loot_template';
+UPDATE `command` SET `permission` = @id+48 WHERE `name` = 'reload item_set_names';
+UPDATE `command` SET `permission` = @id+49 WHERE `name` = 'reload lfg_dungeon_rewards';
+UPDATE `command` SET `permission` = @id+50 WHERE `name` = 'reload locales_achievement_reward';
+UPDATE `command` SET `permission` = @id+51 WHERE `name` = 'reload locales_creature';
+UPDATE `command` SET `permission` = @id+52 WHERE `name` = 'reload locales_creature_text';
+UPDATE `command` SET `permission` = @id+53 WHERE `name` = 'reload locales_gameobject';
+UPDATE `command` SET `permission` = @id+54 WHERE `name` = 'reload locales_gossip_menu_option';
+UPDATE `command` SET `permission` = @id+55 WHERE `name` = 'reload locales_item';
+UPDATE `command` SET `permission` = @id+56 WHERE `name` = 'reload locales_item_set_name';
+UPDATE `command` SET `permission` = @id+57 WHERE `name` = 'reload locales_npc_text';
+UPDATE `command` SET `permission` = @id+58 WHERE `name` = 'reload locales_page_text';
+UPDATE `command` SET `permission` = @id+59 WHERE `name` = 'reload locales_points_of_interest';
+UPDATE `command` SET `permission` = @id+60 WHERE `name` = 'reload locales_quest';
+UPDATE `command` SET `permission` = @id+61 WHERE `name` = 'reload mail_level_reward';
+UPDATE `command` SET `permission` = @id+62 WHERE `name` = 'reload mail_loot_template';
+UPDATE `command` SET `permission` = @id+63 WHERE `name` = 'reload milling_loot_template';
+UPDATE `command` SET `permission` = @id+64 WHERE `name` = 'reload npc_spellclick_spells';
+UPDATE `command` SET `permission` = @id+65 WHERE `name` = 'reload npc_trainer';
+UPDATE `command` SET `permission` = @id+66 WHERE `name` = 'reload npc_vendor';
+UPDATE `command` SET `permission` = @id+67 WHERE `name` = 'reload page_text';
+UPDATE `command` SET `permission` = @id+68 WHERE `name` = 'reload pickpocketing_loot_template';
+UPDATE `command` SET `permission` = @id+69 WHERE `name` = 'reload points_of_interest';
+UPDATE `command` SET `permission` = @id+70 WHERE `name` = 'reload prospecting_loot_template';
+UPDATE `command` SET `permission` = @id+71 WHERE `name` = 'reload quest_poi';
+UPDATE `command` SET `permission` = @id+72 WHERE `name` = 'reload quest_template';
+UPDATE `command` SET `permission` = @id+73 WHERE `name` = 'reload rbac';
+UPDATE `command` SET `permission` = @id+74 WHERE `name` = 'reload reference_loot_template';
+UPDATE `command` SET `permission` = @id+75 WHERE `name` = 'reload reserved_name';
+UPDATE `command` SET `permission` = @id+76 WHERE `name` = 'reload reputation_reward_rate';
+UPDATE `command` SET `permission` = @id+77 WHERE `name` = 'reload reputation_spillover_template';
+UPDATE `command` SET `permission` = @id+78 WHERE `name` = 'reload skill_discovery_template';
+UPDATE `command` SET `permission` = @id+79 WHERE `name` = 'reload skill_extra_item_template';
+UPDATE `command` SET `permission` = @id+80 WHERE `name` = 'reload skill_fishing_base_level';
+UPDATE `command` SET `permission` = @id+81 WHERE `name` = 'reload skinning_loot_template';
+UPDATE `command` SET `permission` = @id+82 WHERE `name` = 'reload smart_scripts';
+UPDATE `command` SET `permission` = @id+83 WHERE `name` = 'reload spell_required';
+UPDATE `command` SET `permission` = @id+84 WHERE `name` = 'reload spell_area';
+UPDATE `command` SET `permission` = @id+85 WHERE `name` = 'reload spell_bonus_data';
+UPDATE `command` SET `permission` = @id+86 WHERE `name` = 'reload spell_group';
+UPDATE `command` SET `permission` = @id+87 WHERE `name` = 'reload spell_learn_spell';
+UPDATE `command` SET `permission` = @id+88 WHERE `name` = 'reload spell_loot_template';
+UPDATE `command` SET `permission` = @id+89 WHERE `name` = 'reload spell_linked_spell';
+UPDATE `command` SET `permission` = @id+90 WHERE `name` = 'reload spell_pet_auras';
+UPDATE `command` SET `permission` = @id+91 WHERE `name` = 'reload spell_proc_event';
+UPDATE `command` SET `permission` = @id+92 WHERE `name` = 'reload spell_proc';
+UPDATE `command` SET `permission` = @id+93 WHERE `name` = 'reload spell_scripts';
+UPDATE `command` SET `permission` = @id+94 WHERE `name` = 'reload spell_target_position';
+UPDATE `command` SET `permission` = @id+95 WHERE `name` = 'reload spell_threats';
+UPDATE `command` SET `permission` = @id+96 WHERE `name` = 'reload spell_group_stack_rules';
+UPDATE `command` SET `permission` = @id+97 WHERE `name` = 'reload trinity_string';
+UPDATE `command` SET `permission` = @id+98 WHERE `name` = 'reload warden_action';
+UPDATE `command` SET `permission` = @id+99 WHERE `name` = 'reload waypoint_scripts';
+UPDATE `command` SET `permission` = @id+100 WHERE `name` = 'reload waypoint_data';
+UPDATE `command` SET `permission` = @id+101 WHERE `name` = 'reload vehicle_accessory';
+UPDATE `command` SET `permission` = @id+102 WHERE `name` = 'reload vehicle_template_accessory';