Update Hotfixes to 34963

1 files changed, 100 insertions, 0 deletions

diff --git a/sql/updates/hotfixes/master/2020_07_03_00_hotfixes.sql b/sql/updates/hotfixes/master/2020_07_03_00_hotfixes.sql
new file mode 100644
index 00000000000..ff2aa6a0951
--- /dev/null
+++ b/sql/updates/hotfixes/master/2020_07_03_00_hotfixes.sql
@@ -0,0 +1,100 @@
+UPDATE `spell_interrupts` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `spell_power` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `spell_levels` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `scene_script_text` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `spell_class_options` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `spell_target_restrictions` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `wmo_area_table` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `spell_aura_options` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `scene_script_global_text` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `ui_map_assignment` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `spell_misc` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `spell_name` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `spell_category` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `ui_map` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `spell_effect` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `taxi_path_node` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `summon_properties` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `spell_x_spell_visual` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `spell_scaling` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `spell_visual_kit` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `vehicle_seat` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `transmog_set_item` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `world_state_expression` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `azerite_essence_power` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `scene_script` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `conversation_line` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `creature_display_info` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `hotfix_blob` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `char_start_outfit` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `content_tuning` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `creature_model_data` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `sound_kit` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `item_appearance` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `item_spec_override` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `criteria` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `phase` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `item_bonus_tree_node` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `curve` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `item` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `dungeon_encounter` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `curve_point` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `item_modified_appearance` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `item_bonus` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `hotfix_data` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `item_x_bonus_tree` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `gameobjects` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `holidays` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `mount` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `map_difficulty` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `map` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `item_search_name` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `item_level_selector_quality` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `item_effect` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `item_name_description` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `item_extended_cost` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `scene_script_package` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `spell_casting_requirements` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `item_level_selector` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `item_currency_cost` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `player_condition` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `item_sparse` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `modifier_tree` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `item_level_selector_quality_set` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `world_effect` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `spell_aura_restrictions` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `lfg_dungeons` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `spell_categories` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `spell_cooldowns` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `scenario` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `quest_v2` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `vehicle` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `names_profanity` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `mount_x_display` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `override_spell_data` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `skill_line_ability` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `criteria_tree` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `cfg_regions` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `currency_types` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `battle_pet_species` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `broadcast_text` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `tact_key` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `gameobject_display_info` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `faction` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `spell_item_enchantment` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `azerite_power_set_member` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `anim_kit` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `area_trigger` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `area_group_member` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `battle_pet_species_state` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `taxi_path` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `area_table` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+UPDATE `achievement` SET `VerifiedBuild` = 34963 WHERE `VerifiedBuild` = 34769;
+
+DELETE FROM `spell_misc` WHERE `VerifiedBuild` = 34769 AND `ID` IN (44343);
+INSERT INTO spell_misc (`ID`, `Attributes1`, `Attributes2`, `Attributes3`, `Attributes4`, `Attributes5`, `Attributes6`, `Attributes7`, `Attributes8`, `Attributes9`, `Attributes10`, `Attributes11`, `Attributes12`, `Attributes13`, `Attributes14`, `DifficultyID`, `CastingTimeIndex`, `DurationIndex`, `RangeIndex`, `SchoolMask`, `Speed`, `LaunchDelay`, `MinDuration`, `SpellIconFileDataID`, `ActiveIconFileDataID`, `ContentTuningID`, `SpellID`, `VerifiedBuild`) VALUES 
+(44343, 67108864, 0, 4, 262400, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 135, 1, 0, 0, 0, 132356, 0, 0, 63981, 34963);
+
+DELETE FROM `hotfix_data` WHERE `Id` = 56782 AND `TableHash` = 3322146344 AND `RecordId` = 44343;
+INSERT INTO hotfix_data (`Id`, `TableHash`, `RecordId`, `Deleted`, `VerifiedBuild`) VALUES 
+(56782, 3322146344, 44343, 0, 34963);