diff options
| -rw-r--r-- | sql/updates/hotfixes/master/2020_07_03_00_hotfixes.sql | 100 |
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); |