diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/old/3.3.5a/09521_characters_character_achievement.sql (renamed from sql/old/3.3.5a/09521_character_achievement.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_04_14_00_characters_misc.sql (renamed from sql/old/3.3.5a/2011_04_14_00_characters.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_04_19_00_characters_misc.sql (renamed from sql/old/3.3.5a/2011_04_19_00_characters.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_04_20_05_world_gameobject_template.sql (renamed from sql/old/3.3.5a/2012_04_20_05_gameobject_template.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_07_01_01_world_achievement_criteria_data.sql (renamed from sql/old/3.3.5a/2012_07_01_01_achievement_criteria_data.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_10_09_00_characters_glyphs.sql (renamed from sql/old/3.3.5a/2012_10_09_00_character_glyphs.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_10_17_00_characters_gm_tickets.sql (renamed from sql/old/3.3.5a/2012_10_17_00_character_gm_tickets.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_11_02_00_characters_misc.sql (renamed from sql/old/3.3.5a/2012_11_02_00_character_misc.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_11_18_00_characters_calendar.sql (renamed from sql/old/3.3.5a/2012_11_18_00_character_calendar.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_12_03_00_characters_character_queststatus_monthly.sql (renamed from sql/old/3.3.5a/2012_12_03_00_character_character_queststatus_monthly.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_12_13_00_world_misc.sql (renamed from sql/old/3.3.5a/2012_12_13_00_world.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_12_18_00_characters_worldstates.sql (renamed from sql/old/3.3.5a/2012_12_18_00_character_worldstates.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_01_00_world_item_template_restore.sql (renamed from sql/old/3.3.5a/2013_01_01_00_item_template_restore.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_02_05_world_eye_of_eternity.sql (renamed from sql/old/3.3.5a/2013_01_02_05_eye_of_eternity.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_14_00_world_version.sql (renamed from sql/updates/world/2013_01_14_00_world_version.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_14_01_world_game_event.sql (renamed from sql/updates/world/2013_01_14_01_world_game_event.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_14_02_world_ip2nationcountries.sql (renamed from sql/updates/world/2013_01_14_02_world_ip2nationcountries.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_14_03_world_lefty_loosy_righty_tighty.sql (renamed from sql/updates/world/2013_01_14_03_world_lefty_loosy_righty_tighty.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_15_00_world_creature.sql (renamed from sql/updates/world/2013_01_15_00_world_creature.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_15_01_world_misc.sql (renamed from sql/updates/world/2013_01_15_01_world_misc.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_15_02_world_game_event.sql (renamed from sql/updates/world/2013_01_15_02_world_game_event.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_15_03_world_misc.sql (renamed from sql/updates/world/2013_01_15_03_world_misc.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_15_04_world_game_event.sql (renamed from sql/updates/world/2013_01_15_04_world_game_event.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_15_05_world_creature_addon.sql (renamed from sql/updates/world/2013_01_15_05_world_creature_addon.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_15_06_world_spell_script_names.sql (renamed from sql/updates/world/2013_01_15_06_world_spell_script_names.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_16_00_world_gossip_menu.sql (renamed from sql/updates/world/2013_01_16_00_world_gossip_menu.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_16_01_world_creature_text.sql (renamed from sql/updates/world/2013_01_16_01_world_creature_text.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_17_00_world_creature_template.sql (renamed from sql/updates/world/2013_01_17_00_world_creature_template.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_17_01_world_creature.sql (renamed from sql/updates/world/2013_01_17_01_world_creature.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_18_00_world_misc.sql (renamed from sql/updates/world/2013_01_18_00_world_misc.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_18_01_world_creature_template_addon.sql (renamed from sql/updates/world/2013_01_18_01_world_creature_template_addon.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_18_02_world_creature_template_addon.sql (renamed from sql/updates/world/2013_01_18_02_world_creature_template_addon.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_19_00_world_creature_text.sql (renamed from sql/updates/world/2013_01_19_00_world_creature_text.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_19_01_world_creature_text.sql (renamed from sql/updates/world/2013_01_19_01_world_creature_text.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_19_02_world_conditions.sql (renamed from sql/updates/world/2013_01_19_02_world_conditions.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_19_03_world_creature_text.sql (renamed from sql/updates/world/2013_01_19_03_world_creature_text.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_19_04_world_creature_addon.sql (renamed from sql/updates/world/2013_01_19_04_world_creature_addon.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_19_04_world_creature_text.sql (renamed from sql/updates/world/2013_01_19_04_world_creature_text.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_19_05_world_creature_addon.sql (renamed from sql/updates/world/2013_01_19_05_world_creature_addon.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_19_06_world_misc.sql (renamed from sql/updates/world/2013_01_19_06_world_misc.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_19_06_world_trinity_string.sql (renamed from sql/updates/world/2013_01_19_06_world_trinity_string.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_20_00_world_sai.sql (renamed from sql/updates/world/2013_01_20_00_world_sai.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_20_01_world_creature_text.sql (renamed from sql/updates/world/2013_01_20_01_world_creature_text.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_20_02_world_creature_text.sql (renamed from sql/updates/world/2013_01_20_02_world_creature_text.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_20_03_world_creature_text.sql (renamed from sql/updates/world/2013_01_20_03_world_creature_text.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_20_03_world_spell_script_names.sql (renamed from sql/updates/world/2013_01_20_03_world_spell_script_names.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_20_04_world_creature_text.sql (renamed from sql/updates/world/2013_01_20_04_world_creature_text.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_20_05_world_sai.sql (renamed from sql/updates/world/2013_01_20_05_world_sai.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_20_06_world_creature.sql (renamed from sql/updates/world/2013_01_20_06_world_creature.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_20_07_world_sai.sql (renamed from sql/updates/world/2013_01_20_07_world_sai.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_20_08_world_sai.sql (renamed from sql/updates/world/2013_01_20_08_world_sai.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_20_09_world_spell_dbc.sql (renamed from sql/updates/world/2013_01_20_09_world_spell_dbc.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_21_00_world_misc.sql (renamed from sql/updates/world/2013_01_21_00_world_misc.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_21_01_world_creature_template.sql (renamed from sql/updates/world/2013_01_21_01_world_creature_template.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_21_02_world_sai.sql (renamed from sql/updates/world/2013_01_21_02_world_sai.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_22_00_world_command.sql (renamed from sql/updates/world/2013_01_22_00_world_command.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_22_01_world_sai.sql (renamed from sql/updates/world/2013_01_22_01_world_sai.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_23_00_world_misc.sql (renamed from sql/updates/world/2013_01_23_00_world_misc.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_23_01_world_misc.sql (renamed from sql/updates/world/2013_01_23_01_world_misc.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_23_02_world_spell_script_names.sql (renamed from sql/updates/world/2013_01_23_02_world_spell_script_names.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_24_00_world_sai.sql (renamed from sql/updates/world/2013_01_24_00_world_sai.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_25_00_world_creature_text.sql (renamed from sql/updates/world/2013_01_25_00_world_creature_text.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_25_01_world_creature_classlevelstats.sql (renamed from sql/updates/world/2013_01_25_01_world_creature_classlevelstats.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_25_02_world_smart_scripts.sql (renamed from sql/updates/world/2013_01_25_02_world_smart_scripts.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_26_00_world_misc.sql (renamed from sql/updates/world/2013_01_26_00_world_misc.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_26_01_world_creature_loot_template.sql (renamed from sql/updates/world/2013_01_26_01_world_creature_loot_template.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_26_02_world_reference_loot_template.sql (renamed from sql/updates/world/2013_01_26_02_world_reference_loot_template.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_26_03_world_conditions.sql (renamed from sql/updates/world/2013_01_26_03_world_conditions.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_26_04_world_item_loot_template.sql (renamed from sql/updates/world/2013_01_26_04_world_item_loot_template.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_26_05_world_misc.sql (renamed from sql/updates/world/2013_01_26_05_world_misc.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_26_05_world_misc_pinfo.sql (renamed from sql/updates/world/2013_01_26_05_world_misc_pinfo.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_26_06_world_creature_template.sql (renamed from sql/updates/world/2013_01_26_06_world_creature_template.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_26_07_world_gameobject_template.sql (renamed from sql/updates/world/2013_01_26_07_world_gameobject_template.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_27_00_auth_realmlist.sql (renamed from sql/updates/auth/2013_01_27_00_auth_realmlist.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_27_00_world_creature.sql (renamed from sql/updates/world/2013_01_27_00_world_creature.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_27_01_world_gameobject_template.sql (renamed from sql/updates/world/2013_01_27_01_world_gameobject_template.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_28_00_world_gameobject.sql (renamed from sql/updates/world/2013_01_28_00_world_gameobject.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_29_00_world_gameobject_loot_template.sql (renamed from sql/updates/world/2013_01_29_00_world_gameobject_loot_template.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_29_01_world_achievement_criteria_data.sql (renamed from sql/updates/world/2013_01_29_01_world_achievement_criteria_data.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_01_29_02_world_gameobject_loot_template.sql (renamed from sql/updates/world/2013_01_29_02_world_gameobject_loot_template.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_02_01_00_world_gameobject.sql (renamed from sql/updates/world/2013_02_01_00_world_gameobject.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_02_01_01_world_spell_loot_template.sql (renamed from sql/updates/world/2013_02_01_01_world_spell_loot_template.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_02_01_02_world_spell_script_names.sql (renamed from sql/updates/world/2013_02_01_02_world_spell_script_names.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_02_01_03_world_wdbverified.sql (renamed from sql/updates/world/2013_02_01_03_world_wdbverified.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_02_03_00_world_lfg_entrances.sql (renamed from sql/updates/world/2013_02_03_00_world_lfg_entrances.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_02_04_00_auth_misc.sql (renamed from sql/updates/auth/2013_02_04_00_auth_misc.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_02_04_00_world_misc.sql (renamed from sql/updates/world/2013_02_04_00_world_misc.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_02_04_01_auth_account.sql (renamed from sql/updates/auth/2013_02_04_01_auth_account.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_02_04_01_world_creature_text.sql (renamed from sql/updates/world/2013_02_04_01_world_creature_text.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_02_04_02_world_misc.sql (renamed from sql/updates/world/2013_02_04_02_world_misc.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_02_04_03_world_misc.sql (renamed from sql/updates/world/2013_02_04_03_world_misc.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_02_04_04_world_trinity_string.sql (renamed from sql/updates/world/2013_02_04_04_world_trinity_string.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_02_04_05_world_spell_script_names.sql (renamed from sql/updates/world/2013_02_04_05_world_spell_script_names.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_02_04_06_world_command.sql (renamed from sql/updates/world/2013_02_04_06_world_command.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_02_04_07_world_achievement_criteria_data.sql (renamed from sql/updates/world/2013_02_04_07_world_achievement_criteria_data.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_02_04_08_world_creature_template.sql (renamed from sql/updates/world/2013_02_04_08_world_creature_template.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_02_05_00_auth_account.sql (renamed from sql/updates/auth/2013_02_05_00_auth_account.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_02_05_00_world_disables.sql (renamed from sql/updates/world/2013_02_05_00_world_disables.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_02_05_01_world_item_template.sql (renamed from sql/updates/world/2013_02_05_01_world_item_template.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_02_06_00_world_disables.sql (renamed from sql/updates/world/2013_02_06_00_world_disables.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_02_06_01_world_misc.sql (renamed from sql/updates/world/2013_02_06_01_world_misc.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_02_07_00_auth_account.sql (renamed from sql/updates/auth/2013_02_07_00_auth_account.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_02_07_00_world_areatrigger_teleport.sql (renamed from sql/updates/world/2013_02_07_00_world_areatrigger_teleport.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_02_08_00_auth_account.sql (renamed from sql/updates/auth/2013_02_08_00_auth_account.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_02_09_00_world_gameobject.sql (renamed from sql/updates/world/2013_02_09_00_world_gameobject.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_02_09_01_world_creature_equip_template.sql (renamed from sql/updates/world/2013_02_09_01_world_creature_equip_template.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_02_09_02_world_areatrigger_teleport.sql (renamed from sql/updates/world/2013_02_09_02_world_areatrigger_teleport.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_02_09_03_world_player_factionchange_spells.sql (renamed from sql/updates/world/2013_02_09_03_world_player_factionchange_spells.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_02_10_00_world_areatrigger_teleport.sql (renamed from sql/updates/world/2013_02_10_00_world_areatrigger_teleport.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2013_02_11_00_world_creature_template.sql (renamed from sql/updates/world/2013_02_11_00_world_creature_template.sql) | 0 | ||||
| -rw-r--r-- | sql/updates/world/2013_02_14_00_world_version.sql | 1 | ||||
| -rw-r--r-- | sql/updates/world/2013_02_15_00_world_waypoint_data.sql | 20 | ||||
| -rw-r--r-- | sql/updates/world/2013_02_16_00_world_creature_template.sql | 1 | ||||
| -rw-r--r-- | sql/updates/world/2013_02_16_01_world_spell_target_position.sql | 11 | ||||
| -rw-r--r-- | sql/updates/world/2013_02_16_02_world_creature_text.sql | 8 | ||||
| -rw-r--r-- | sql/updates/world/2013_02_16_03_world_sai.sql | 14 | ||||
| -rw-r--r-- | sql/updates/world/2013_02_16_04_world_creature_loot_template.sql | 6 | ||||
| -rw-r--r-- | sql/updates/world/2013_02_16_05_world_quest_template.sql | 17 | ||||
| -rw-r--r-- | sql/updates/world/2013_02_17_00_world_spell_script_names.sql | 14 | ||||
| -rw-r--r-- | sql/updates/world/2013_02_18_00_world_misc_equip.sql | 73 | ||||
| -rw-r--r-- | sql/updates/world/2013_02_18_01_world_trinity_string.sql | 3 | ||||
| -rw-r--r-- | sql/updates/world/2013_02_18_02_world_misc.sql | 149 | ||||
| -rw-r--r-- | sql/updates/world/2013_02_18_03_world_spell_area.sql | 3 | ||||
| -rw-r--r-- | sql/updates/world/2013_02_19_00_world_creature_template.sql | 46 | ||||
| -rw-r--r-- | sql/updates/world/2013_02_19_01_world_creature_template.sql | 2 | ||||
| -rw-r--r-- | sql/updates/world/2013_02_19_02_world_conditions.sql | 38 | ||||
| -rw-r--r-- | sql/updates/world/2013_02_19_03_world_sai.sql | 28 |
127 files changed, 434 insertions, 0 deletions
diff --git a/sql/old/3.3.5a/09521_character_achievement.sql b/sql/old/3.3.5a/09521_characters_character_achievement.sql index e8262aed4ad..e8262aed4ad 100644 --- a/sql/old/3.3.5a/09521_character_achievement.sql +++ b/sql/old/3.3.5a/09521_characters_character_achievement.sql diff --git a/sql/old/3.3.5a/2011_04_14_00_characters.sql b/sql/old/3.3.5a/2011_04_14_00_characters_misc.sql index ab9bd93419d..ab9bd93419d 100644 --- a/sql/old/3.3.5a/2011_04_14_00_characters.sql +++ b/sql/old/3.3.5a/2011_04_14_00_characters_misc.sql diff --git a/sql/old/3.3.5a/2011_04_19_00_characters.sql b/sql/old/3.3.5a/2011_04_19_00_characters_misc.sql index 96536d67a03..96536d67a03 100644 --- a/sql/old/3.3.5a/2011_04_19_00_characters.sql +++ b/sql/old/3.3.5a/2011_04_19_00_characters_misc.sql diff --git a/sql/old/3.3.5a/2012_04_20_05_gameobject_template.sql b/sql/old/3.3.5a/2012_04_20_05_world_gameobject_template.sql index 24400b16a5c..24400b16a5c 100644 --- a/sql/old/3.3.5a/2012_04_20_05_gameobject_template.sql +++ b/sql/old/3.3.5a/2012_04_20_05_world_gameobject_template.sql diff --git a/sql/old/3.3.5a/2012_07_01_01_achievement_criteria_data.sql b/sql/old/3.3.5a/2012_07_01_01_world_achievement_criteria_data.sql index e1c0529fffe..e1c0529fffe 100644 --- a/sql/old/3.3.5a/2012_07_01_01_achievement_criteria_data.sql +++ b/sql/old/3.3.5a/2012_07_01_01_world_achievement_criteria_data.sql diff --git a/sql/old/3.3.5a/2012_10_09_00_character_glyphs.sql b/sql/old/3.3.5a/2012_10_09_00_characters_glyphs.sql index b90fa7d7682..b90fa7d7682 100644 --- a/sql/old/3.3.5a/2012_10_09_00_character_glyphs.sql +++ b/sql/old/3.3.5a/2012_10_09_00_characters_glyphs.sql diff --git a/sql/old/3.3.5a/2012_10_17_00_character_gm_tickets.sql b/sql/old/3.3.5a/2012_10_17_00_characters_gm_tickets.sql index affb23f836c..affb23f836c 100644 --- a/sql/old/3.3.5a/2012_10_17_00_character_gm_tickets.sql +++ b/sql/old/3.3.5a/2012_10_17_00_characters_gm_tickets.sql diff --git a/sql/old/3.3.5a/2012_11_02_00_character_misc.sql b/sql/old/3.3.5a/2012_11_02_00_characters_misc.sql index 9cbbd423bb8..9cbbd423bb8 100644 --- a/sql/old/3.3.5a/2012_11_02_00_character_misc.sql +++ b/sql/old/3.3.5a/2012_11_02_00_characters_misc.sql diff --git a/sql/old/3.3.5a/2012_11_18_00_character_calendar.sql b/sql/old/3.3.5a/2012_11_18_00_characters_calendar.sql index a3e7c352788..a3e7c352788 100644 --- a/sql/old/3.3.5a/2012_11_18_00_character_calendar.sql +++ b/sql/old/3.3.5a/2012_11_18_00_characters_calendar.sql diff --git a/sql/old/3.3.5a/2012_12_03_00_character_character_queststatus_monthly.sql b/sql/old/3.3.5a/2012_12_03_00_characters_character_queststatus_monthly.sql index 256bb1f7ad6..256bb1f7ad6 100644 --- a/sql/old/3.3.5a/2012_12_03_00_character_character_queststatus_monthly.sql +++ b/sql/old/3.3.5a/2012_12_03_00_characters_character_queststatus_monthly.sql diff --git a/sql/old/3.3.5a/2012_12_13_00_world.sql b/sql/old/3.3.5a/2012_12_13_00_world_misc.sql index ab27796f933..ab27796f933 100644 --- a/sql/old/3.3.5a/2012_12_13_00_world.sql +++ b/sql/old/3.3.5a/2012_12_13_00_world_misc.sql diff --git a/sql/old/3.3.5a/2012_12_18_00_character_worldstates.sql b/sql/old/3.3.5a/2012_12_18_00_characters_worldstates.sql index 98fabde6776..98fabde6776 100644 --- a/sql/old/3.3.5a/2012_12_18_00_character_worldstates.sql +++ b/sql/old/3.3.5a/2012_12_18_00_characters_worldstates.sql diff --git a/sql/old/3.3.5a/2013_01_01_00_item_template_restore.sql b/sql/old/3.3.5a/2013_01_01_00_world_item_template_restore.sql index dc18ff71fe8..dc18ff71fe8 100644 --- a/sql/old/3.3.5a/2013_01_01_00_item_template_restore.sql +++ b/sql/old/3.3.5a/2013_01_01_00_world_item_template_restore.sql diff --git a/sql/old/3.3.5a/2013_01_02_05_eye_of_eternity.sql b/sql/old/3.3.5a/2013_01_02_05_world_eye_of_eternity.sql index 89cc8f08cce..89cc8f08cce 100644 --- a/sql/old/3.3.5a/2013_01_02_05_eye_of_eternity.sql +++ b/sql/old/3.3.5a/2013_01_02_05_world_eye_of_eternity.sql diff --git a/sql/updates/world/2013_01_14_00_world_version.sql b/sql/old/3.3.5a/2013_01_14_00_world_version.sql index 0bc0a89a8a4..0bc0a89a8a4 100644 --- a/sql/updates/world/2013_01_14_00_world_version.sql +++ b/sql/old/3.3.5a/2013_01_14_00_world_version.sql diff --git a/sql/updates/world/2013_01_14_01_world_game_event.sql b/sql/old/3.3.5a/2013_01_14_01_world_game_event.sql index d4d30d54928..d4d30d54928 100644 --- a/sql/updates/world/2013_01_14_01_world_game_event.sql +++ b/sql/old/3.3.5a/2013_01_14_01_world_game_event.sql diff --git a/sql/updates/world/2013_01_14_02_world_ip2nationcountries.sql b/sql/old/3.3.5a/2013_01_14_02_world_ip2nationcountries.sql index fdb96fd895e..fdb96fd895e 100644 --- a/sql/updates/world/2013_01_14_02_world_ip2nationcountries.sql +++ b/sql/old/3.3.5a/2013_01_14_02_world_ip2nationcountries.sql diff --git a/sql/updates/world/2013_01_14_03_world_lefty_loosy_righty_tighty.sql b/sql/old/3.3.5a/2013_01_14_03_world_lefty_loosy_righty_tighty.sql index 5d322ac2dd9..5d322ac2dd9 100644 --- a/sql/updates/world/2013_01_14_03_world_lefty_loosy_righty_tighty.sql +++ b/sql/old/3.3.5a/2013_01_14_03_world_lefty_loosy_righty_tighty.sql diff --git a/sql/updates/world/2013_01_15_00_world_creature.sql b/sql/old/3.3.5a/2013_01_15_00_world_creature.sql index e49918aa0b6..e49918aa0b6 100644 --- a/sql/updates/world/2013_01_15_00_world_creature.sql +++ b/sql/old/3.3.5a/2013_01_15_00_world_creature.sql diff --git a/sql/updates/world/2013_01_15_01_world_misc.sql b/sql/old/3.3.5a/2013_01_15_01_world_misc.sql index 48238e5dacf..48238e5dacf 100644 --- a/sql/updates/world/2013_01_15_01_world_misc.sql +++ b/sql/old/3.3.5a/2013_01_15_01_world_misc.sql diff --git a/sql/updates/world/2013_01_15_02_world_game_event.sql b/sql/old/3.3.5a/2013_01_15_02_world_game_event.sql index 3300c0667ce..3300c0667ce 100644 --- a/sql/updates/world/2013_01_15_02_world_game_event.sql +++ b/sql/old/3.3.5a/2013_01_15_02_world_game_event.sql diff --git a/sql/updates/world/2013_01_15_03_world_misc.sql b/sql/old/3.3.5a/2013_01_15_03_world_misc.sql index 5de9e0ab13a..5de9e0ab13a 100644 --- a/sql/updates/world/2013_01_15_03_world_misc.sql +++ b/sql/old/3.3.5a/2013_01_15_03_world_misc.sql diff --git a/sql/updates/world/2013_01_15_04_world_game_event.sql b/sql/old/3.3.5a/2013_01_15_04_world_game_event.sql index cfbd399e43d..cfbd399e43d 100644 --- a/sql/updates/world/2013_01_15_04_world_game_event.sql +++ b/sql/old/3.3.5a/2013_01_15_04_world_game_event.sql diff --git a/sql/updates/world/2013_01_15_05_world_creature_addon.sql b/sql/old/3.3.5a/2013_01_15_05_world_creature_addon.sql index 94782891ca1..94782891ca1 100644 --- a/sql/updates/world/2013_01_15_05_world_creature_addon.sql +++ b/sql/old/3.3.5a/2013_01_15_05_world_creature_addon.sql diff --git a/sql/updates/world/2013_01_15_06_world_spell_script_names.sql b/sql/old/3.3.5a/2013_01_15_06_world_spell_script_names.sql index 0e327bdc63d..0e327bdc63d 100644 --- a/sql/updates/world/2013_01_15_06_world_spell_script_names.sql +++ b/sql/old/3.3.5a/2013_01_15_06_world_spell_script_names.sql diff --git a/sql/updates/world/2013_01_16_00_world_gossip_menu.sql b/sql/old/3.3.5a/2013_01_16_00_world_gossip_menu.sql index 1b0554931fa..1b0554931fa 100644 --- a/sql/updates/world/2013_01_16_00_world_gossip_menu.sql +++ b/sql/old/3.3.5a/2013_01_16_00_world_gossip_menu.sql diff --git a/sql/updates/world/2013_01_16_01_world_creature_text.sql b/sql/old/3.3.5a/2013_01_16_01_world_creature_text.sql index 69bdd91b886..69bdd91b886 100644 --- a/sql/updates/world/2013_01_16_01_world_creature_text.sql +++ b/sql/old/3.3.5a/2013_01_16_01_world_creature_text.sql diff --git a/sql/updates/world/2013_01_17_00_world_creature_template.sql b/sql/old/3.3.5a/2013_01_17_00_world_creature_template.sql index af602096440..af602096440 100644 --- a/sql/updates/world/2013_01_17_00_world_creature_template.sql +++ b/sql/old/3.3.5a/2013_01_17_00_world_creature_template.sql diff --git a/sql/updates/world/2013_01_17_01_world_creature.sql b/sql/old/3.3.5a/2013_01_17_01_world_creature.sql index 84ded6edcb2..84ded6edcb2 100644 --- a/sql/updates/world/2013_01_17_01_world_creature.sql +++ b/sql/old/3.3.5a/2013_01_17_01_world_creature.sql diff --git a/sql/updates/world/2013_01_18_00_world_misc.sql b/sql/old/3.3.5a/2013_01_18_00_world_misc.sql index e15a13f51a5..e15a13f51a5 100644 --- a/sql/updates/world/2013_01_18_00_world_misc.sql +++ b/sql/old/3.3.5a/2013_01_18_00_world_misc.sql diff --git a/sql/updates/world/2013_01_18_01_world_creature_template_addon.sql b/sql/old/3.3.5a/2013_01_18_01_world_creature_template_addon.sql index e3d6feaeecd..e3d6feaeecd 100644 --- a/sql/updates/world/2013_01_18_01_world_creature_template_addon.sql +++ b/sql/old/3.3.5a/2013_01_18_01_world_creature_template_addon.sql diff --git a/sql/updates/world/2013_01_18_02_world_creature_template_addon.sql b/sql/old/3.3.5a/2013_01_18_02_world_creature_template_addon.sql index 716d59d8724..716d59d8724 100644 --- a/sql/updates/world/2013_01_18_02_world_creature_template_addon.sql +++ b/sql/old/3.3.5a/2013_01_18_02_world_creature_template_addon.sql diff --git a/sql/updates/world/2013_01_19_00_world_creature_text.sql b/sql/old/3.3.5a/2013_01_19_00_world_creature_text.sql index ed52fe13b29..ed52fe13b29 100644 --- a/sql/updates/world/2013_01_19_00_world_creature_text.sql +++ b/sql/old/3.3.5a/2013_01_19_00_world_creature_text.sql diff --git a/sql/updates/world/2013_01_19_01_world_creature_text.sql b/sql/old/3.3.5a/2013_01_19_01_world_creature_text.sql index 4fb6bc55c87..4fb6bc55c87 100644 --- a/sql/updates/world/2013_01_19_01_world_creature_text.sql +++ b/sql/old/3.3.5a/2013_01_19_01_world_creature_text.sql diff --git a/sql/updates/world/2013_01_19_02_world_conditions.sql b/sql/old/3.3.5a/2013_01_19_02_world_conditions.sql index 744029f4fa0..744029f4fa0 100644 --- a/sql/updates/world/2013_01_19_02_world_conditions.sql +++ b/sql/old/3.3.5a/2013_01_19_02_world_conditions.sql diff --git a/sql/updates/world/2013_01_19_03_world_creature_text.sql b/sql/old/3.3.5a/2013_01_19_03_world_creature_text.sql index d9a15f4da7a..d9a15f4da7a 100644 --- a/sql/updates/world/2013_01_19_03_world_creature_text.sql +++ b/sql/old/3.3.5a/2013_01_19_03_world_creature_text.sql diff --git a/sql/updates/world/2013_01_19_04_world_creature_addon.sql b/sql/old/3.3.5a/2013_01_19_04_world_creature_addon.sql index fbe99d8edf2..fbe99d8edf2 100644 --- a/sql/updates/world/2013_01_19_04_world_creature_addon.sql +++ b/sql/old/3.3.5a/2013_01_19_04_world_creature_addon.sql diff --git a/sql/updates/world/2013_01_19_04_world_creature_text.sql b/sql/old/3.3.5a/2013_01_19_04_world_creature_text.sql index c14cf5c149a..c14cf5c149a 100644 --- a/sql/updates/world/2013_01_19_04_world_creature_text.sql +++ b/sql/old/3.3.5a/2013_01_19_04_world_creature_text.sql diff --git a/sql/updates/world/2013_01_19_05_world_creature_addon.sql b/sql/old/3.3.5a/2013_01_19_05_world_creature_addon.sql index 0a384501e36..0a384501e36 100644 --- a/sql/updates/world/2013_01_19_05_world_creature_addon.sql +++ b/sql/old/3.3.5a/2013_01_19_05_world_creature_addon.sql diff --git a/sql/updates/world/2013_01_19_06_world_misc.sql b/sql/old/3.3.5a/2013_01_19_06_world_misc.sql index 55d9777a71c..55d9777a71c 100644 --- a/sql/updates/world/2013_01_19_06_world_misc.sql +++ b/sql/old/3.3.5a/2013_01_19_06_world_misc.sql diff --git a/sql/updates/world/2013_01_19_06_world_trinity_string.sql b/sql/old/3.3.5a/2013_01_19_06_world_trinity_string.sql index 322d43a7720..322d43a7720 100644 --- a/sql/updates/world/2013_01_19_06_world_trinity_string.sql +++ b/sql/old/3.3.5a/2013_01_19_06_world_trinity_string.sql diff --git a/sql/updates/world/2013_01_20_00_world_sai.sql b/sql/old/3.3.5a/2013_01_20_00_world_sai.sql index d4e4bb81c41..d4e4bb81c41 100644 --- a/sql/updates/world/2013_01_20_00_world_sai.sql +++ b/sql/old/3.3.5a/2013_01_20_00_world_sai.sql diff --git a/sql/updates/world/2013_01_20_01_world_creature_text.sql b/sql/old/3.3.5a/2013_01_20_01_world_creature_text.sql index d543b02d9fc..d543b02d9fc 100644 --- a/sql/updates/world/2013_01_20_01_world_creature_text.sql +++ b/sql/old/3.3.5a/2013_01_20_01_world_creature_text.sql diff --git a/sql/updates/world/2013_01_20_02_world_creature_text.sql b/sql/old/3.3.5a/2013_01_20_02_world_creature_text.sql index 25c8c046dfc..25c8c046dfc 100644 --- a/sql/updates/world/2013_01_20_02_world_creature_text.sql +++ b/sql/old/3.3.5a/2013_01_20_02_world_creature_text.sql diff --git a/sql/updates/world/2013_01_20_03_world_creature_text.sql b/sql/old/3.3.5a/2013_01_20_03_world_creature_text.sql index 1ea2c121e1e..1ea2c121e1e 100644 --- a/sql/updates/world/2013_01_20_03_world_creature_text.sql +++ b/sql/old/3.3.5a/2013_01_20_03_world_creature_text.sql diff --git a/sql/updates/world/2013_01_20_03_world_spell_script_names.sql b/sql/old/3.3.5a/2013_01_20_03_world_spell_script_names.sql index 0cd28de0472..0cd28de0472 100644 --- a/sql/updates/world/2013_01_20_03_world_spell_script_names.sql +++ b/sql/old/3.3.5a/2013_01_20_03_world_spell_script_names.sql diff --git a/sql/updates/world/2013_01_20_04_world_creature_text.sql b/sql/old/3.3.5a/2013_01_20_04_world_creature_text.sql index 5c457530f92..5c457530f92 100644 --- a/sql/updates/world/2013_01_20_04_world_creature_text.sql +++ b/sql/old/3.3.5a/2013_01_20_04_world_creature_text.sql diff --git a/sql/updates/world/2013_01_20_05_world_sai.sql b/sql/old/3.3.5a/2013_01_20_05_world_sai.sql index 9539bc546b1..9539bc546b1 100644 --- a/sql/updates/world/2013_01_20_05_world_sai.sql +++ b/sql/old/3.3.5a/2013_01_20_05_world_sai.sql diff --git a/sql/updates/world/2013_01_20_06_world_creature.sql b/sql/old/3.3.5a/2013_01_20_06_world_creature.sql index c00ff11ea4a..c00ff11ea4a 100644 --- a/sql/updates/world/2013_01_20_06_world_creature.sql +++ b/sql/old/3.3.5a/2013_01_20_06_world_creature.sql diff --git a/sql/updates/world/2013_01_20_07_world_sai.sql b/sql/old/3.3.5a/2013_01_20_07_world_sai.sql index f8d001e73db..f8d001e73db 100644 --- a/sql/updates/world/2013_01_20_07_world_sai.sql +++ b/sql/old/3.3.5a/2013_01_20_07_world_sai.sql diff --git a/sql/updates/world/2013_01_20_08_world_sai.sql b/sql/old/3.3.5a/2013_01_20_08_world_sai.sql index 411d69e08d2..411d69e08d2 100644 --- a/sql/updates/world/2013_01_20_08_world_sai.sql +++ b/sql/old/3.3.5a/2013_01_20_08_world_sai.sql diff --git a/sql/updates/world/2013_01_20_09_world_spell_dbc.sql b/sql/old/3.3.5a/2013_01_20_09_world_spell_dbc.sql index d8f466173f3..d8f466173f3 100644 --- a/sql/updates/world/2013_01_20_09_world_spell_dbc.sql +++ b/sql/old/3.3.5a/2013_01_20_09_world_spell_dbc.sql diff --git a/sql/updates/world/2013_01_21_00_world_misc.sql b/sql/old/3.3.5a/2013_01_21_00_world_misc.sql index c023003783e..c023003783e 100644 --- a/sql/updates/world/2013_01_21_00_world_misc.sql +++ b/sql/old/3.3.5a/2013_01_21_00_world_misc.sql diff --git a/sql/updates/world/2013_01_21_01_world_creature_template.sql b/sql/old/3.3.5a/2013_01_21_01_world_creature_template.sql index d5bf4525ff6..d5bf4525ff6 100644 --- a/sql/updates/world/2013_01_21_01_world_creature_template.sql +++ b/sql/old/3.3.5a/2013_01_21_01_world_creature_template.sql diff --git a/sql/updates/world/2013_01_21_02_world_sai.sql b/sql/old/3.3.5a/2013_01_21_02_world_sai.sql index 31070c48718..31070c48718 100644 --- a/sql/updates/world/2013_01_21_02_world_sai.sql +++ b/sql/old/3.3.5a/2013_01_21_02_world_sai.sql diff --git a/sql/updates/world/2013_01_22_00_world_command.sql b/sql/old/3.3.5a/2013_01_22_00_world_command.sql index 6c89951d036..6c89951d036 100644 --- a/sql/updates/world/2013_01_22_00_world_command.sql +++ b/sql/old/3.3.5a/2013_01_22_00_world_command.sql diff --git a/sql/updates/world/2013_01_22_01_world_sai.sql b/sql/old/3.3.5a/2013_01_22_01_world_sai.sql index b41fb25110d..b41fb25110d 100644 --- a/sql/updates/world/2013_01_22_01_world_sai.sql +++ b/sql/old/3.3.5a/2013_01_22_01_world_sai.sql diff --git a/sql/updates/world/2013_01_23_00_world_misc.sql b/sql/old/3.3.5a/2013_01_23_00_world_misc.sql index fb55d90f69b..fb55d90f69b 100644 --- a/sql/updates/world/2013_01_23_00_world_misc.sql +++ b/sql/old/3.3.5a/2013_01_23_00_world_misc.sql diff --git a/sql/updates/world/2013_01_23_01_world_misc.sql b/sql/old/3.3.5a/2013_01_23_01_world_misc.sql index 25042e241dd..25042e241dd 100644 --- a/sql/updates/world/2013_01_23_01_world_misc.sql +++ b/sql/old/3.3.5a/2013_01_23_01_world_misc.sql diff --git a/sql/updates/world/2013_01_23_02_world_spell_script_names.sql b/sql/old/3.3.5a/2013_01_23_02_world_spell_script_names.sql index d56c6ad1c59..d56c6ad1c59 100644 --- a/sql/updates/world/2013_01_23_02_world_spell_script_names.sql +++ b/sql/old/3.3.5a/2013_01_23_02_world_spell_script_names.sql diff --git a/sql/updates/world/2013_01_24_00_world_sai.sql b/sql/old/3.3.5a/2013_01_24_00_world_sai.sql index 516af5a1504..516af5a1504 100644 --- a/sql/updates/world/2013_01_24_00_world_sai.sql +++ b/sql/old/3.3.5a/2013_01_24_00_world_sai.sql diff --git a/sql/updates/world/2013_01_25_00_world_creature_text.sql b/sql/old/3.3.5a/2013_01_25_00_world_creature_text.sql index 25354a70390..25354a70390 100644 --- a/sql/updates/world/2013_01_25_00_world_creature_text.sql +++ b/sql/old/3.3.5a/2013_01_25_00_world_creature_text.sql diff --git a/sql/updates/world/2013_01_25_01_world_creature_classlevelstats.sql b/sql/old/3.3.5a/2013_01_25_01_world_creature_classlevelstats.sql index 5d0a916dfb8..5d0a916dfb8 100644 --- a/sql/updates/world/2013_01_25_01_world_creature_classlevelstats.sql +++ b/sql/old/3.3.5a/2013_01_25_01_world_creature_classlevelstats.sql diff --git a/sql/updates/world/2013_01_25_02_world_smart_scripts.sql b/sql/old/3.3.5a/2013_01_25_02_world_smart_scripts.sql index 69d48686429..69d48686429 100644 --- a/sql/updates/world/2013_01_25_02_world_smart_scripts.sql +++ b/sql/old/3.3.5a/2013_01_25_02_world_smart_scripts.sql diff --git a/sql/updates/world/2013_01_26_00_world_misc.sql b/sql/old/3.3.5a/2013_01_26_00_world_misc.sql index 429d900d765..429d900d765 100644 --- a/sql/updates/world/2013_01_26_00_world_misc.sql +++ b/sql/old/3.3.5a/2013_01_26_00_world_misc.sql diff --git a/sql/updates/world/2013_01_26_01_world_creature_loot_template.sql b/sql/old/3.3.5a/2013_01_26_01_world_creature_loot_template.sql index 5d667b99cb5..5d667b99cb5 100644 --- a/sql/updates/world/2013_01_26_01_world_creature_loot_template.sql +++ b/sql/old/3.3.5a/2013_01_26_01_world_creature_loot_template.sql diff --git a/sql/updates/world/2013_01_26_02_world_reference_loot_template.sql b/sql/old/3.3.5a/2013_01_26_02_world_reference_loot_template.sql index d4e5a9fa622..d4e5a9fa622 100644 --- a/sql/updates/world/2013_01_26_02_world_reference_loot_template.sql +++ b/sql/old/3.3.5a/2013_01_26_02_world_reference_loot_template.sql diff --git a/sql/updates/world/2013_01_26_03_world_conditions.sql b/sql/old/3.3.5a/2013_01_26_03_world_conditions.sql index cc7ab333f4a..cc7ab333f4a 100644 --- a/sql/updates/world/2013_01_26_03_world_conditions.sql +++ b/sql/old/3.3.5a/2013_01_26_03_world_conditions.sql diff --git a/sql/updates/world/2013_01_26_04_world_item_loot_template.sql b/sql/old/3.3.5a/2013_01_26_04_world_item_loot_template.sql index 32cf116167e..32cf116167e 100644 --- a/sql/updates/world/2013_01_26_04_world_item_loot_template.sql +++ b/sql/old/3.3.5a/2013_01_26_04_world_item_loot_template.sql diff --git a/sql/updates/world/2013_01_26_05_world_misc.sql b/sql/old/3.3.5a/2013_01_26_05_world_misc.sql index ff8cf4d1e77..ff8cf4d1e77 100644 --- a/sql/updates/world/2013_01_26_05_world_misc.sql +++ b/sql/old/3.3.5a/2013_01_26_05_world_misc.sql diff --git a/sql/updates/world/2013_01_26_05_world_misc_pinfo.sql b/sql/old/3.3.5a/2013_01_26_05_world_misc_pinfo.sql index 2c0a28066d4..2c0a28066d4 100644 --- a/sql/updates/world/2013_01_26_05_world_misc_pinfo.sql +++ b/sql/old/3.3.5a/2013_01_26_05_world_misc_pinfo.sql diff --git a/sql/updates/world/2013_01_26_06_world_creature_template.sql b/sql/old/3.3.5a/2013_01_26_06_world_creature_template.sql index e54949744f6..e54949744f6 100644 --- a/sql/updates/world/2013_01_26_06_world_creature_template.sql +++ b/sql/old/3.3.5a/2013_01_26_06_world_creature_template.sql diff --git a/sql/updates/world/2013_01_26_07_world_gameobject_template.sql b/sql/old/3.3.5a/2013_01_26_07_world_gameobject_template.sql index c68e48754dc..c68e48754dc 100644 --- a/sql/updates/world/2013_01_26_07_world_gameobject_template.sql +++ b/sql/old/3.3.5a/2013_01_26_07_world_gameobject_template.sql diff --git a/sql/updates/auth/2013_01_27_00_auth_realmlist.sql b/sql/old/3.3.5a/2013_01_27_00_auth_realmlist.sql index 0c3b18448e6..0c3b18448e6 100644 --- a/sql/updates/auth/2013_01_27_00_auth_realmlist.sql +++ b/sql/old/3.3.5a/2013_01_27_00_auth_realmlist.sql diff --git a/sql/updates/world/2013_01_27_00_world_creature.sql b/sql/old/3.3.5a/2013_01_27_00_world_creature.sql index b60f8f60eba..b60f8f60eba 100644 --- a/sql/updates/world/2013_01_27_00_world_creature.sql +++ b/sql/old/3.3.5a/2013_01_27_00_world_creature.sql diff --git a/sql/updates/world/2013_01_27_01_world_gameobject_template.sql b/sql/old/3.3.5a/2013_01_27_01_world_gameobject_template.sql index 49bbf3be56a..49bbf3be56a 100644 --- a/sql/updates/world/2013_01_27_01_world_gameobject_template.sql +++ b/sql/old/3.3.5a/2013_01_27_01_world_gameobject_template.sql diff --git a/sql/updates/world/2013_01_28_00_world_gameobject.sql b/sql/old/3.3.5a/2013_01_28_00_world_gameobject.sql index 3f49d799c62..3f49d799c62 100644 --- a/sql/updates/world/2013_01_28_00_world_gameobject.sql +++ b/sql/old/3.3.5a/2013_01_28_00_world_gameobject.sql diff --git a/sql/updates/world/2013_01_29_00_world_gameobject_loot_template.sql b/sql/old/3.3.5a/2013_01_29_00_world_gameobject_loot_template.sql index 32146fb9ef8..32146fb9ef8 100644 --- a/sql/updates/world/2013_01_29_00_world_gameobject_loot_template.sql +++ b/sql/old/3.3.5a/2013_01_29_00_world_gameobject_loot_template.sql diff --git a/sql/updates/world/2013_01_29_01_world_achievement_criteria_data.sql b/sql/old/3.3.5a/2013_01_29_01_world_achievement_criteria_data.sql index 39627a943cc..39627a943cc 100644 --- a/sql/updates/world/2013_01_29_01_world_achievement_criteria_data.sql +++ b/sql/old/3.3.5a/2013_01_29_01_world_achievement_criteria_data.sql diff --git a/sql/updates/world/2013_01_29_02_world_gameobject_loot_template.sql b/sql/old/3.3.5a/2013_01_29_02_world_gameobject_loot_template.sql index c3f2d0f0fb9..c3f2d0f0fb9 100644 --- a/sql/updates/world/2013_01_29_02_world_gameobject_loot_template.sql +++ b/sql/old/3.3.5a/2013_01_29_02_world_gameobject_loot_template.sql diff --git a/sql/updates/world/2013_02_01_00_world_gameobject.sql b/sql/old/3.3.5a/2013_02_01_00_world_gameobject.sql index 2476d623c5a..2476d623c5a 100644 --- a/sql/updates/world/2013_02_01_00_world_gameobject.sql +++ b/sql/old/3.3.5a/2013_02_01_00_world_gameobject.sql diff --git a/sql/updates/world/2013_02_01_01_world_spell_loot_template.sql b/sql/old/3.3.5a/2013_02_01_01_world_spell_loot_template.sql index 0185f464412..0185f464412 100644 --- a/sql/updates/world/2013_02_01_01_world_spell_loot_template.sql +++ b/sql/old/3.3.5a/2013_02_01_01_world_spell_loot_template.sql diff --git a/sql/updates/world/2013_02_01_02_world_spell_script_names.sql b/sql/old/3.3.5a/2013_02_01_02_world_spell_script_names.sql index 33b7b1fab6e..33b7b1fab6e 100644 --- a/sql/updates/world/2013_02_01_02_world_spell_script_names.sql +++ b/sql/old/3.3.5a/2013_02_01_02_world_spell_script_names.sql diff --git a/sql/updates/world/2013_02_01_03_world_wdbverified.sql b/sql/old/3.3.5a/2013_02_01_03_world_wdbverified.sql index 1f47ff75825..1f47ff75825 100644 --- a/sql/updates/world/2013_02_01_03_world_wdbverified.sql +++ b/sql/old/3.3.5a/2013_02_01_03_world_wdbverified.sql diff --git a/sql/updates/world/2013_02_03_00_world_lfg_entrances.sql b/sql/old/3.3.5a/2013_02_03_00_world_lfg_entrances.sql index e308c001d29..e308c001d29 100644 --- a/sql/updates/world/2013_02_03_00_world_lfg_entrances.sql +++ b/sql/old/3.3.5a/2013_02_03_00_world_lfg_entrances.sql diff --git a/sql/updates/auth/2013_02_04_00_auth_misc.sql b/sql/old/3.3.5a/2013_02_04_00_auth_misc.sql index d8a508e4e7b..d8a508e4e7b 100644 --- a/sql/updates/auth/2013_02_04_00_auth_misc.sql +++ b/sql/old/3.3.5a/2013_02_04_00_auth_misc.sql diff --git a/sql/updates/world/2013_02_04_00_world_misc.sql b/sql/old/3.3.5a/2013_02_04_00_world_misc.sql index ff8021653ab..ff8021653ab 100644 --- a/sql/updates/world/2013_02_04_00_world_misc.sql +++ b/sql/old/3.3.5a/2013_02_04_00_world_misc.sql diff --git a/sql/updates/auth/2013_02_04_01_auth_account.sql b/sql/old/3.3.5a/2013_02_04_01_auth_account.sql index 9af73d41ee3..9af73d41ee3 100644 --- a/sql/updates/auth/2013_02_04_01_auth_account.sql +++ b/sql/old/3.3.5a/2013_02_04_01_auth_account.sql diff --git a/sql/updates/world/2013_02_04_01_world_creature_text.sql b/sql/old/3.3.5a/2013_02_04_01_world_creature_text.sql index c52aa380c49..c52aa380c49 100644 --- a/sql/updates/world/2013_02_04_01_world_creature_text.sql +++ b/sql/old/3.3.5a/2013_02_04_01_world_creature_text.sql diff --git a/sql/updates/world/2013_02_04_02_world_misc.sql b/sql/old/3.3.5a/2013_02_04_02_world_misc.sql index 300d0e31bcb..300d0e31bcb 100644 --- a/sql/updates/world/2013_02_04_02_world_misc.sql +++ b/sql/old/3.3.5a/2013_02_04_02_world_misc.sql diff --git a/sql/updates/world/2013_02_04_03_world_misc.sql b/sql/old/3.3.5a/2013_02_04_03_world_misc.sql index a609d411b6e..a609d411b6e 100644 --- a/sql/updates/world/2013_02_04_03_world_misc.sql +++ b/sql/old/3.3.5a/2013_02_04_03_world_misc.sql diff --git a/sql/updates/world/2013_02_04_04_world_trinity_string.sql b/sql/old/3.3.5a/2013_02_04_04_world_trinity_string.sql index 0a4ec437b28..0a4ec437b28 100644 --- a/sql/updates/world/2013_02_04_04_world_trinity_string.sql +++ b/sql/old/3.3.5a/2013_02_04_04_world_trinity_string.sql diff --git a/sql/updates/world/2013_02_04_05_world_spell_script_names.sql b/sql/old/3.3.5a/2013_02_04_05_world_spell_script_names.sql index 4dd5ee52583..4dd5ee52583 100644 --- a/sql/updates/world/2013_02_04_05_world_spell_script_names.sql +++ b/sql/old/3.3.5a/2013_02_04_05_world_spell_script_names.sql diff --git a/sql/updates/world/2013_02_04_06_world_command.sql b/sql/old/3.3.5a/2013_02_04_06_world_command.sql index fb36c512c4a..fb36c512c4a 100644 --- a/sql/updates/world/2013_02_04_06_world_command.sql +++ b/sql/old/3.3.5a/2013_02_04_06_world_command.sql diff --git a/sql/updates/world/2013_02_04_07_world_achievement_criteria_data.sql b/sql/old/3.3.5a/2013_02_04_07_world_achievement_criteria_data.sql index dc873a02dfd..dc873a02dfd 100644 --- a/sql/updates/world/2013_02_04_07_world_achievement_criteria_data.sql +++ b/sql/old/3.3.5a/2013_02_04_07_world_achievement_criteria_data.sql diff --git a/sql/updates/world/2013_02_04_08_world_creature_template.sql b/sql/old/3.3.5a/2013_02_04_08_world_creature_template.sql index 3dd365366b6..3dd365366b6 100644 --- a/sql/updates/world/2013_02_04_08_world_creature_template.sql +++ b/sql/old/3.3.5a/2013_02_04_08_world_creature_template.sql diff --git a/sql/updates/auth/2013_02_05_00_auth_account.sql b/sql/old/3.3.5a/2013_02_05_00_auth_account.sql index 2f32c5e3e3e..2f32c5e3e3e 100644 --- a/sql/updates/auth/2013_02_05_00_auth_account.sql +++ b/sql/old/3.3.5a/2013_02_05_00_auth_account.sql diff --git a/sql/updates/world/2013_02_05_00_world_disables.sql b/sql/old/3.3.5a/2013_02_05_00_world_disables.sql index b7e9be4e3c7..b7e9be4e3c7 100644 --- a/sql/updates/world/2013_02_05_00_world_disables.sql +++ b/sql/old/3.3.5a/2013_02_05_00_world_disables.sql diff --git a/sql/updates/world/2013_02_05_01_world_item_template.sql b/sql/old/3.3.5a/2013_02_05_01_world_item_template.sql index aea09e60e58..aea09e60e58 100644 --- a/sql/updates/world/2013_02_05_01_world_item_template.sql +++ b/sql/old/3.3.5a/2013_02_05_01_world_item_template.sql diff --git a/sql/updates/world/2013_02_06_00_world_disables.sql b/sql/old/3.3.5a/2013_02_06_00_world_disables.sql index 0785330d7fd..0785330d7fd 100644 --- a/sql/updates/world/2013_02_06_00_world_disables.sql +++ b/sql/old/3.3.5a/2013_02_06_00_world_disables.sql diff --git a/sql/updates/world/2013_02_06_01_world_misc.sql b/sql/old/3.3.5a/2013_02_06_01_world_misc.sql index 1a59c75ff1b..1a59c75ff1b 100644 --- a/sql/updates/world/2013_02_06_01_world_misc.sql +++ b/sql/old/3.3.5a/2013_02_06_01_world_misc.sql diff --git a/sql/updates/auth/2013_02_07_00_auth_account.sql b/sql/old/3.3.5a/2013_02_07_00_auth_account.sql index 03bdf8cdcd5..03bdf8cdcd5 100644 --- a/sql/updates/auth/2013_02_07_00_auth_account.sql +++ b/sql/old/3.3.5a/2013_02_07_00_auth_account.sql diff --git a/sql/updates/world/2013_02_07_00_world_areatrigger_teleport.sql b/sql/old/3.3.5a/2013_02_07_00_world_areatrigger_teleport.sql index 0b6f3e576b4..0b6f3e576b4 100644 --- a/sql/updates/world/2013_02_07_00_world_areatrigger_teleport.sql +++ b/sql/old/3.3.5a/2013_02_07_00_world_areatrigger_teleport.sql diff --git a/sql/updates/auth/2013_02_08_00_auth_account.sql b/sql/old/3.3.5a/2013_02_08_00_auth_account.sql index 49948781444..49948781444 100644 --- a/sql/updates/auth/2013_02_08_00_auth_account.sql +++ b/sql/old/3.3.5a/2013_02_08_00_auth_account.sql diff --git a/sql/updates/world/2013_02_09_00_world_gameobject.sql b/sql/old/3.3.5a/2013_02_09_00_world_gameobject.sql index 386ca974e99..386ca974e99 100644 --- a/sql/updates/world/2013_02_09_00_world_gameobject.sql +++ b/sql/old/3.3.5a/2013_02_09_00_world_gameobject.sql diff --git a/sql/updates/world/2013_02_09_01_world_creature_equip_template.sql b/sql/old/3.3.5a/2013_02_09_01_world_creature_equip_template.sql index fd207746ac1..fd207746ac1 100644 --- a/sql/updates/world/2013_02_09_01_world_creature_equip_template.sql +++ b/sql/old/3.3.5a/2013_02_09_01_world_creature_equip_template.sql diff --git a/sql/updates/world/2013_02_09_02_world_areatrigger_teleport.sql b/sql/old/3.3.5a/2013_02_09_02_world_areatrigger_teleport.sql index 2a0c1682e32..2a0c1682e32 100644 --- a/sql/updates/world/2013_02_09_02_world_areatrigger_teleport.sql +++ b/sql/old/3.3.5a/2013_02_09_02_world_areatrigger_teleport.sql diff --git a/sql/updates/world/2013_02_09_03_world_player_factionchange_spells.sql b/sql/old/3.3.5a/2013_02_09_03_world_player_factionchange_spells.sql index 22f69b11aaa..22f69b11aaa 100644 --- a/sql/updates/world/2013_02_09_03_world_player_factionchange_spells.sql +++ b/sql/old/3.3.5a/2013_02_09_03_world_player_factionchange_spells.sql diff --git a/sql/updates/world/2013_02_10_00_world_areatrigger_teleport.sql b/sql/old/3.3.5a/2013_02_10_00_world_areatrigger_teleport.sql index b5f5c856fe0..b5f5c856fe0 100644 --- a/sql/updates/world/2013_02_10_00_world_areatrigger_teleport.sql +++ b/sql/old/3.3.5a/2013_02_10_00_world_areatrigger_teleport.sql diff --git a/sql/updates/world/2013_02_11_00_world_creature_template.sql b/sql/old/3.3.5a/2013_02_11_00_world_creature_template.sql index dbbc7267780..dbbc7267780 100644 --- a/sql/updates/world/2013_02_11_00_world_creature_template.sql +++ b/sql/old/3.3.5a/2013_02_11_00_world_creature_template.sql diff --git a/sql/updates/world/2013_02_14_00_world_version.sql b/sql/updates/world/2013_02_14_00_world_version.sql new file mode 100644 index 00000000000..b3186b9c4e6 --- /dev/null +++ b/sql/updates/world/2013_02_14_00_world_version.sql @@ -0,0 +1 @@ +UPDATE `version` SET `db_version`='TDB 335.51', `cache_id`=51 LIMIT 1; diff --git a/sql/updates/world/2013_02_15_00_world_waypoint_data.sql b/sql/updates/world/2013_02_15_00_world_waypoint_data.sql new file mode 100644 index 00000000000..8af0531b2f3 --- /dev/null +++ b/sql/updates/world/2013_02_15_00_world_waypoint_data.sql @@ -0,0 +1,20 @@ +SET @NPC_DRAKE := 29709; + +DELETE FROM `waypoint_data` WHERE `id`=@NPC_DRAKE; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES +(@NPC_DRAKE,1,7294.96,-2418.733,823.869,0,0,0,0,100,0), +(@NPC_DRAKE,2,7315.984,-2331.46,826.3972,0,0,0,0,100,0), +(@NPC_DRAKE,3,7271.826,-2271.479,833.5917,0,0,0,0,100,0), +(@NPC_DRAKE,4,7186.253,-2218.475,847.5632,0,0,0,0,100,0), +(@NPC_DRAKE,5,7113.195,-2164.288,850.2301,0,0,0,0,100,0), +(@NPC_DRAKE,6,7078.018,-2063.106,854.7581,0,0,0,0,100,0), +(@NPC_DRAKE,7,7073.221,-1983.382,861.9246,0,0,0,0,100,0), +(@NPC_DRAKE,8,7061.455,-1885.899,865.119,0,0,0,0,100,0), +(@NPC_DRAKE,9,7033.32,-1826.775,876.2578,0,0,0,0,100,0), +(@NPC_DRAKE,10,6999.902,-1784.012,897.4521,0,0,0,0,100,0), +(@NPC_DRAKE,11,6954.913,-1747.043,897.4521,0,0,0,0,100,0), +(@NPC_DRAKE,12,6933.856,-1720.698,882.2022,0,0,0,0,100,0), +(@NPC_DRAKE,13,6932.729,-1687.306,866.1189,0,0,0,0,100,0), +(@NPC_DRAKE,14,6952.458,-1663.802,849.8133,0,0,0,0,100,0), +(@NPC_DRAKE,15,7002.819,-1651.681,831.397,0,0,0,0,100,0), +(@NPC_DRAKE,16,7026.531,-1649.239,828.8406,0,0,0,0,100,0); diff --git a/sql/updates/world/2013_02_16_00_world_creature_template.sql b/sql/updates/world/2013_02_16_00_world_creature_template.sql new file mode 100644 index 00000000000..d8efe46b573 --- /dev/null +++ b/sql/updates/world/2013_02_16_00_world_creature_template.sql @@ -0,0 +1 @@ +UPDATE `creature_template` SET `Armor_mod`=0 WHERE `entry`=29747; diff --git a/sql/updates/world/2013_02_16_01_world_spell_target_position.sql b/sql/updates/world/2013_02_16_01_world_spell_target_position.sql new file mode 100644 index 00000000000..c262ecf450f --- /dev/null +++ b/sql/updates/world/2013_02_16_01_world_spell_target_position.sql @@ -0,0 +1,11 @@ +DELETE FROM `spell_target_position` WHERE `id` IN (64014,64024,64025,64028,64029,64030,64031,64032,65042); +INSERT INTO `spell_target_position` (`id`, `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) VALUES +(64014, 603, -705.9705, -92.55729, 430.8192, 0), +(64024, 603, 2086.224, -24.05382, 422.2889, 0), +(64025, 603, 2518.131, 2569.342, 412.6822, 0), +(64028, 603, 553.243, -12.30903, 410.5428, 0), +(64029, 603, 1859.563, -24.83773, 449.1945, 6.230825), +(64030, 603, 1497.989, -24.16162, 421.6254, 0.03490658), +(64031, 603, 926.2917, -11.44444, 418.9779, 0.01745329), +(64032, 603, 131.1389, -35.36806, 410.187, 0), +(65042, 603, 1855.073, -11.48785, 334.559, 5.532694); diff --git a/sql/updates/world/2013_02_16_02_world_creature_text.sql b/sql/updates/world/2013_02_16_02_world_creature_text.sql new file mode 100644 index 00000000000..d7250b0b49c --- /dev/null +++ b/sql/updates/world/2013_02_16_02_world_creature_text.sql @@ -0,0 +1,8 @@ +-- Lurgglbr +DELETE FROM `creature_text` WHERE `entry`=25208; +INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES +(25208,0,0, 'You can''t hold me against my will! You''ve all been brainwashed!', 12,0,100,0,0,0, 'Lurgglbr'), +(25208,1,0, 'Together we will fight our way out of here. Are you ready?', 12,0,100,0,0,0, 'Lurgglbr'), +(25208,2,0, 'This is far enough. I can make it on my own from here.', 12,0,100,0,0,0, 'Lurgglbr'), +(25208,3,0, 'Thank you for rescuing me, $r. Please tell the king that I am back.', 12,0,100,0,0,0, 'Lurgglbr'); + diff --git a/sql/updates/world/2013_02_16_03_world_sai.sql b/sql/updates/world/2013_02_16_03_world_sai.sql new file mode 100644 index 00000000000..fb89bf4ced0 --- /dev/null +++ b/sql/updates/world/2013_02_16_03_world_sai.sql @@ -0,0 +1,14 @@ +-- quest fix cuergo's gold (q2882) +SET @ENTRY :=7898; +UPDATE `creature_template` SET `AIName`= 'SmartAI', `ScriptName`='' WHERE `entry`=@ENTRY; +DELETE FROM `creature_ai_scripts` WHERE `creature_id`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND`entryorguid`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=9 AND`entryorguid`=@ENTRY*100; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,63,0,100,0,0,0,0,0,80,@ENTRY*100,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Trigger - on respawn - run script'), +(@ENTRY*100,9,0,0,0,0,100,0,0,0,300000,300000,11,11463,0,0,0,0,0,1,0,0,0,0,0,0,0,'Timed Actionscript - spawn pirate1'), +(@ENTRY*100,9,1,0,0,0,100,0,0,0,300000,300000,11,11463,0,0,0,0,0,1,0,0,0,0,0,0,0,'Timed Actionscript - spawn pirate2'), +(@ENTRY*100,9,2,0,0,0,100,0,0,0,300000,300000,11,11485,0,0,0,0,0,1,0,0,0,0,0,0,0,'Timed Actionscript - spawn buccaneer1'), +(@ENTRY*100,9,3,0,0,0,100,0,0,0,300000,300000,11,11485,0,0,0,0,0,1,0,0,0,0,0,0,0,'Timed Actionscript - spawn buccaneer2'), +(@ENTRY*100,9,4,0,0,0,100,0,0,0,300000,300000,11,11487,0,0,0,0,0,1,0,0,0,0,0,0,0,'Timed Actionscript - spawn swashbuckler'), +(@ENTRY*100,9,5,0,0,0,100,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Timed Actionscript - despawn trigger'); diff --git a/sql/updates/world/2013_02_16_04_world_creature_loot_template.sql b/sql/updates/world/2013_02_16_04_world_creature_loot_template.sql new file mode 100644 index 00000000000..6819b7aeb45 --- /dev/null +++ b/sql/updates/world/2013_02_16_04_world_creature_loot_template.sql @@ -0,0 +1,6 @@ +-- Remove Zulian Mudskunk from Zulian Crocolisk's loot template +DELETE FROM `creature_loot_template` WHERE `entry`=15043 and `item`=19975; +-- Add Vicious Oil (Item) into loot template of Vicious Oil (NPC) +DELETE FROM `creature_loot_template` WHERE `entry`=30325 and `item`=42640; +INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values +(30325,42640,-100,1,0,1,1); diff --git a/sql/updates/world/2013_02_16_05_world_quest_template.sql b/sql/updates/world/2013_02_16_05_world_quest_template.sql new file mode 100644 index 00000000000..81a8e38f25d --- /dev/null +++ b/sql/updates/world/2013_02_16_05_world_quest_template.sql @@ -0,0 +1,17 @@ +-- Previous quest should be The Defense of Warsong Hold not To Conquest Hold, But Be Careful! +UPDATE `quest_template` SET `PrevQuestId`=11596 WHERE `Id`=12486; +-- Change grouping so Alliance and Horde quests are no longer in 1 group +UPDATE `quest_template` SET `ExclusiveGroup`=-12222 WHERE `Id` IN(12222,12223); +-- Hellscreams Champion requires some conditions to start the quest +UPDATE `quest_template` SET `ExclusiveGroup`=0,`NextQuestId`=0 WHERE `Id` IN(11652,11705,11722); +UPDATE `quest_template` SET `NextQuestId`=11709 WHERE `Id`=11705; +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (19,20) AND `SourceEntry`=11916; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(20,0,11916,0,0,8,0,11652,0,0,0,0, '', 'Player must have completed The Plains of Nasam before been able to accept Hellscream''s Champion'), +(19,0,11916,0,0,8,0,11652,0,0,0,0, '', 'Player must have completed The Plains of Nasam before been able to accept Hellscream''s Champion'), +(20,0,11916,0,0,8,0,11705,0,0,0,0, '', 'Player must have completed The Foolish Endeavors before been able to accept Hellscream''s Champion'), +(19,0,11916,0,0,8,0,11705,0,0,0,0, '', 'Player must have completed The Foolish Endeavors before been able to accept Hellscream''s Champion'), +(20,0,11916,0,0,8,0,11722,0,0,0,0, '', 'Player must have completed The Trophies of Gammoth before been able to accept Hellscream''s Champion'), +(19,0,11916,0,0,8,0,11722,0,0,0,0, '', 'Player must have completed The Trophies of Gammoth before been able to accept Hellscream''s Champion'); +-- Fix SAI issue for Hugh Glass (wrong npcflag was set) +UPDATE `smart_scripts` SET `action_param1`=643 WHERE `entryorguid`=2648400 AND `source_type`=9 AND `id`=6; diff --git a/sql/updates/world/2013_02_17_00_world_spell_script_names.sql b/sql/updates/world/2013_02_17_00_world_spell_script_names.sql new file mode 100644 index 00000000000..e47b22b1c6b --- /dev/null +++ b/sql/updates/world/2013_02_17_00_world_spell_script_names.sql @@ -0,0 +1,14 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_sindragosa_frost_breath'; +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_item_unsated_craving'; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(69649,'spell_sindragosa_frost_breath'), +(71056,'spell_sindragosa_frost_breath'), +(71057,'spell_sindragosa_frost_breath'), +(71058,'spell_sindragosa_frost_breath'), +(73061,'spell_sindragosa_frost_breath'), +(73062,'spell_sindragosa_frost_breath'), +(73063,'spell_sindragosa_frost_breath'), +(73064,'spell_sindragosa_frost_breath'), +(71168,'spell_item_unsated_craving'); + +DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=71952; diff --git a/sql/updates/world/2013_02_18_00_world_misc_equip.sql b/sql/updates/world/2013_02_18_00_world_misc_equip.sql new file mode 100644 index 00000000000..a5964cd883b --- /dev/null +++ b/sql/updates/world/2013_02_18_00_world_misc_equip.sql @@ -0,0 +1,73 @@ +-- creature_template.equipment_id deleted +-- creature_equip_template.entry == creature_template.entry +-- id field added to creature_equip_template -> PK(entry, id) +-- id field in creature_equip_template starts at 1 +-- creature.equipment_id references id of creature_equip_template +-- creature.equipment_id = 0 means no equipment at all (default 1) +-- creature.equipment_id = -1 means pick a random equipment from creature_equip_template + +-- Diff_entries should use the same template of the normal entry +UPDATE `creature_template` SET `equipment_id` = 0 WHERE `name` LIKE '%(1)' OR `name` LIKE '%(2)' OR `name` LIKE '%(3)' OR `name` LIKE '%(4)'; + +-- Delete unused templates +DROP TABLE IF EXISTS `temp_c_e`; +CREATE TABLE IF NOT EXISTS `temp_c_e` (`entry` mediumint(8)); +ALTER TABLE `temp_c_e` ADD INDEX `ind` (`entry`); +INSERT INTO `temp_c_e` SELECT `equipment_id` FROM `creature_template` WHERE `equipment_id` != 0 UNION + SELECT `equipment_id` FROM `creature` WHERE `equipment_id` != 0 UNION + SELECT `equipment_id` FROM `game_event_model_equip` WHERE `equipment_id` != 0; +DELETE FROM `creature_equip_template` WHERE `entry` NOT IN (SELECT `entry` FROM `temp_c_e`); +DROP TABLE `temp_c_e`; + +-- Create temporary table to hold the values of creature_equip_template with converted entry +DROP TABLE IF EXISTS `creature_equip_template2`; +CREATE TABLE IF NOT EXISTS `creature_equip_template2` ( + `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', + `id` tinyint(3) unsigned NOT NULL DEFAULT '1', + `itemEntry1` mediumint(8) unsigned NOT NULL DEFAULT '0', + `itemEntry2` mediumint(8) unsigned NOT NULL DEFAULT '0', + `itemEntry3` mediumint(8) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`entry`, `id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +INSERT INTO `creature_equip_template2` (`entry`, `id`, `itemEntry1`, `itemEntry2`, `itemEntry3`) + SELECT `creature_template`.`entry`, 1, `itemEntry1`, `itemEntry2`, `itemEntry3` + FROM `creature_template` + JOIN `creature_equip_template` ON `creature_equip_template`.`entry` = `equipment_id` + WHERE `equipment_id` != 0; + +INSERT IGNORE INTO `creature_equip_template2` (`entry`, `id`, `itemEntry1`, `itemEntry2`, `itemEntry3`) + SELECT `id`, 2, `itemEntry1`, `itemEntry2`, `itemEntry3` + FROM `creature` + JOIN `creature_equip_template` ON `creature_equip_template`.`entry` = `equipment_id` + WHERE `equipment_id` != 0; + +DROP TABLE `creature_equip_template`; +RENAME TABLE `creature_equip_template2` TO `creature_equip_template`; + +UPDATE `creature` SET `equipment_id` = 2 WHERE `equipment_id` != 0; +UPDATE `creature` SET `equipment_id` = 1 WHERE `equipment_id` = 0; + +-- From game_event_model_equip +UPDATE `creature` SET `equipment_id` = 1 WHERE `guid` IN (12088, 12093, 12095, 79670, 79675, 79676, 79690, 79792, 79807, 79814); +UPDATE `game_event_model_equip` SET `equipment_id` = 2 WHERE `guid` IN (12088, 12093, 12095, 79670, 79675, 79676, 79690, 79792, 79807, 79814); +DELETE FROM `creature_equip_template` WHERE `entry` IN (1976, 23585, 424) AND `id`=2; +INSERT INTO `creature_equip_template` (`entry`, `id`, `itemEntry1`, `itemEntry2`, `itemEntry3`) VALUES +(1976, 2, 2715, 143, 0), +(23585, 2, 2715, 143, 0), +(424, 2, 2715, 143, 0); + +-- ALTER TABLE `creature_equip_template` CHANGE `entry` `entry` mediumint(8) unsigned NOT NULL; +-- ALTER TABLE `creature_equip_template` ADD `id` tinyint(3) unsigned NOT NULL DEFAULT '1' AFTER `entry`; +-- ALTER TABLE `creature_equip_template` DROP INDEX `PRIMARY`, ADD PRIMARY KEY (`entry`, `id`); +ALTER TABLE `creature_template` DROP `equipment_id`; +ALTER TABLE `creature` CHANGE `equipment_id` `equipment_id` tinyint(3) unsigned NOT NULL DEFAULT '1'; +ALTER TABLE `game_event_model_equip` CHANGE `equipment_id` `equipment_id` tinyint(3) unsigned NOT NULL DEFAULT '1'; + +-- Conversion from SAI +UPDATE `smart_scripts` SET `action_param1` = 1 WHERE `entryorguid` = 2523901 AND `source_type` = 9 AND `id` = 3; +UPDATE `smart_scripts` SET `action_param1` = 0 WHERE `entryorguid` = 2523900 AND `source_type` = 9 AND `id` = 2; +UPDATE `smart_scripts` SET `action_param1` = 2 WHERE `entryorguid` = 32720 AND `source_type` = 0 AND `id` = 0; +DELETE FROM `creature_equip_template` WHERE `entry` = 25239 AND `id`=1; +INSERT INTO `creature_equip_template` (`entry`, `id`, `itemEntry1`, `itemEntry2`, `itemEntry3`) VALUES +(25239, 1, 6829, 0, 0); diff --git a/sql/updates/world/2013_02_18_01_world_trinity_string.sql b/sql/updates/world/2013_02_18_01_world_trinity_string.sql new file mode 100644 index 00000000000..84d28222fe7 --- /dev/null +++ b/sql/updates/world/2013_02_18_01_world_trinity_string.sql @@ -0,0 +1,3 @@ +DELETE FROM `trinity_string` WHERE `entry` = 5036; +INSERT INTO `trinity_string` (`entry`, `content_default`) VALUES +(5036, 'EquipmentId: %u (Original: %u).'); diff --git a/sql/updates/world/2013_02_18_02_world_misc.sql b/sql/updates/world/2013_02_18_02_world_misc.sql new file mode 100644 index 00000000000..8ca97fe3130 --- /dev/null +++ b/sql/updates/world/2013_02_18_02_world_misc.sql @@ -0,0 +1,149 @@ +-- Creature Gossip_menu_option Update from sniff +UPDATE `gossip_menu_option` SET `menu_id`=9528 WHERE `menu_id`=21250; +UPDATE `gossip_menu_option` SET `action_menu_id`=9527 WHERE `action_menu_id`=50423; +UPDATE `gossip_menu_option` SET `action_menu_id`=9521 WHERE `action_menu_id`=50424; +UPDATE `gossip_menu_option` SET `action_menu_id`=9526 WHERE `action_menu_id`=50425; +UPDATE `gossip_menu_option` SET `action_menu_id`=9525 WHERE `action_menu_id`=50426; +UPDATE `gossip_menu_option` SET `action_menu_id`=9681 WHERE `menu_id`=9680; +UPDATE `gossip_menu_option` SET `action_menu_id`=9696 WHERE `menu_id`=9695; +DELETE FROM `gossip_menu_option` WHERE `menu_id` IN (9302,9303,9304,9305,9422,9461,9462,9474,9501,9532,9536,9568,9586,9594,9595,9610,9611,9612,9653,9696) AND `id`=0; +INSERT INTO `gossip_menu_option` (`menu_id`,`id`,`option_icon`,`option_text`,`option_id`,`npc_option_npcflag`,`action_menu_id`,`action_poi_id`,`box_coded`,`box_money`,`box_text`) VALUES +(9302,0,0, 'Worry no more, taunka. The Horde will save and protect you and your people, but first you must swear allegiance to the Warchief by taking the blood oath of the Horde.',1,1,9305,0,0,0, ''), +(9303,0,0, 'For the Horde!\r\n\r\nArm yourself from the crates that surround us and report to Agmar''s Hammer, east of here. Your first trial as a member of the Horde is to survive the journey.\r\n\r\nLok''tar ogar!',1,1,0,0,0,0, ''), +(9304,0,0, 'Then repeat after me: "Lok''tar ogar! Victory or death - it is these words that bind me to the Horde. For they are the most sacred and fundamental of truths to any warrior of the Horde.\r\n\r\nI give my flesh and blood freely to the Warchief. I am the instrument of my Warchief''s desire. I am a weapon of my Warchief''s command.\r\n\r\nFrom this moment until the end of days I live and die - For the Horde!"',1,1,9303,0,0,0, ''), +(9305,0,0, 'Yes, taunka. Retribution is a given right of all members of the Horde.',1,1,9304,0,0,0, ''), +(9422,0,0, 'I seem to have misplaced your Shredder Control Device... might you have another?',1,1,0,0,0,0, ''), +(9461,0,0, 'Greetings High Chief. Would you do me the honor of accepting my invitation to join the Horde as an official member and leader of the Taunka?',1,1,9462,0,0,0, ''), +(9462,0,0, 'It is you who honor me, High Chief. Please read from this scroll. It is the oath of allegiance.',1,1,0,0,0,0, ''), +(9474,0,1, 'Let me browse your goods.',3,128,0,0,0,0, ''), +(9501,0,0, 'Agent Skully, I need you to use the banshee''s magic mirror on me again!',1,1,9538,0,0,0, ''), +(9532,0,0, 'Your eminence, may I have a word in private?',1,1,9536,0,0,0, ''), +(9536,0,0, 'I am ready, your grace. <kiss the ring>',1,1,9535,0,0,0, ''), +(9568,0,0, 'We need to get into the fight. Are you ready?',1,1,9569,0,0,0, ''), +(9586,0,0, 'Why have I been sent back to this particular place and time?',1,1,9594,0,0,0, ''), +(9594,0,0, 'What was this decision?',1,1,9595,0,0,0, ''), +(9595,0,0, 'So how does the Infinite Dragonflight plan to interfere?',1,1,9596,0,0,0, ''), +(9610,0,0, 'What do you think they''re up to?',1,1,9611,0,0,0, ''), +(9611,0,0, 'You want me to do what?',1,1,9612,0,0,0, ''), +(9612,0,0, 'Very well, Chromie.',1,1,9613,0,0,0, ''), +(9653,0,0, 'Yes, my Prince. We are ready.',1,1,0,0,0,0, ''), +(9696,0,0, 'For Lordaeron!',1,1,0,0,0,0, ''); + +UPDATE `gossip_menu` SET `entry`=9350 WHERE `entry`=21238; +UPDATE `gossip_menu` SET `entry`=9136 WHERE `entry`=21243; +UPDATE `gossip_menu` SET `entry`=9151 WHERE `entry`=21244; +UPDATE `gossip_menu` SET `entry`=9474 WHERE `entry`=21245; +UPDATE `gossip_menu` SET `entry`=9528 WHERE `entry`=21250; +UPDATE `gossip_menu` SET `entry`=9527 WHERE `entry`=50423; +UPDATE `gossip_menu` SET `entry`=9521 WHERE `entry`=50424; +UPDATE `gossip_menu` SET `entry`=9526 WHERE `entry`=50425; +UPDATE `gossip_menu` SET `entry`=9525 WHERE `entry`=50426; +-- Gossip Menu insert from sniff +DELETE FROM `gossip_menu` WHERE `entry`=9302 AND `text_id`=12611; +DELETE FROM `gossip_menu` WHERE `entry`=9303 AND `text_id`=12620; +DELETE FROM `gossip_menu` WHERE `entry`=9304 AND `text_id`=12619; +DELETE FROM `gossip_menu` WHERE `entry`=9305 AND `text_id`=12618; +DELETE FROM `gossip_menu` WHERE `entry`=9461 AND `text_id`=12721; +DELETE FROM `gossip_menu` WHERE `entry`=9462 AND `text_id`=12722; +DELETE FROM `gossip_menu` WHERE `entry`=9532 AND `text_id`=12846; +DELETE FROM `gossip_menu` WHERE `entry`=9535 AND `text_id`=12849; +DELETE FROM `gossip_menu` WHERE `entry`=9536 AND `text_id`=12848; +DELETE FROM `gossip_menu` WHERE `entry`=9538 AND `text_id`=12851; +DELETE FROM `gossip_menu` WHERE `entry`=9568 AND `text_id`=12899; +DELETE FROM `gossip_menu` WHERE `entry`=9569 AND `text_id`=12900; +DELETE FROM `gossip_menu` WHERE `entry`=9586 AND `text_id`=13471; +DELETE FROM `gossip_menu` WHERE `entry`=9653 AND `text_id`=13076; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES +(9302,12611), +(9303,12620), +(9304,12619), +(9305,12618), +(9461,12721), +(9462,12722), +(9532,12846), +(9535,12849), +(9536,12848), +(9538,12851), +(9568,12899), +(9569,12900), +(9586,13471), +(9653,13076); + +-- Creature Gossip_menu_id Update from sniff +UPDATE `creature_template` SET `gossip_menu_id`=9136 WHERE `entry`=25197; -- King Mrgl-Mrgl <D.E.H.T.A.> +UPDATE `creature_template` SET `gossip_menu_id`=9151 WHERE `entry`=25326; -- Overlord Bor'gorok +UPDATE `creature_template` SET `gossip_menu_id`=9474 WHERE `entry`=25736; -- Supply Master Taz'ishi <Poison & Reagents> +UPDATE `creature_template` SET `gossip_menu_id`=9302, `npcflag`=`npcflag`|1, `AIName`='SmartAI' WHERE `entry`=26179; -- Taunka''le Refugee +UPDATE `creature_template` SET `gossip_menu_id`=9302, `npcflag`=`npcflag`|1, `AIName`='SmartAI' WHERE `entry`=26184; -- Taunka''le Refugee +UPDATE `creature_template` SET `gossip_menu_id`=9350 WHERE `entry`=26538; -- Nargo Screwbore <Durotar Zeppelin Master> +UPDATE `creature_template` SET `gossip_menu_id`=9461 WHERE `entry`=26810; -- Roanauk Icemist +UPDATE `creature_template` SET `gossip_menu_id`=9821 WHERE `entry`=27056; -- Sentinel Sweetspring <Stable Master> +UPDATE `creature_template` SET `gossip_menu_id`=9532 WHERE `entry`=27245; -- High Abbot Landgren +UPDATE `creature_template` SET `gossip_menu_id`=9528 WHERE `entry`=27425; -- Darrok +UPDATE `creature_template` SET `gossip_menu_id`=9610 WHERE `entry`=27915; -- Chromie +UPDATE `creature_template` SET `gossip_menu_id`=9656 WHERE `entry`=28126; -- Don Carlos + +DELETE FROM `creature_text` WHERE `entry` IN (26179,26184); +INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES +(26179,0,0,'Victory or death! For the Horde!',14,1,100,15,0,0,'Taunka''le Refugee'), +(26184,0,0,'Victory or death! For the Horde!',14,1,100,15,0,0,'Taunka''le Refugee'); + +-- Conditions +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=14 AND `SourceGroup`=9568 AND `SourceEntry`=12899; +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=14 AND `SourceGroup`=9586 AND `SourceEntry`=13471; +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=9302 AND `SourceEntry`=0; +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=9422 AND `SourceEntry`=0; +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=9461 AND `SourceEntry`=0; +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=9501 AND `SourceEntry`=0; +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=9568 AND `SourceEntry`=0; +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=9586 AND `SourceEntry`=0; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(14,9568,12899,0,0,9,0,12372,0,0,0,0,'','Wyrmrest Defender - Show different gossip if player has taken quest Defending Wyrmrest Temple'), +(14,9586,13471,0,0,2,0,37888,1,0,0,0,'','Chromie - Show different gossip if player has item Arcane Disruptor'), +(15,9302,0,0,0,9,0,11983,0,0,0,0,'','Taunka''le Refugee - Show gossip option only if player has taken quest Blood Oath of the Horde'), +(15,9422,0,0,0,9,0,12050,0,0,0,0,'','Xink - Show gossip option only if player has taken quest Lumber Hack'), +(15,9422,0,0,0,2,0,36734,1,0,1,0,'','Xink - Show gossip option only if player has no item Xink''s Shredder Control Device'), +(15,9422,0,0,1,9,0,12052,0,0,0,0,'','Xink - Show gossip option only if player has taken quest Harp on This!'), +(15,9422,0,0,1,2,0,36734,1,0,1,0,'','Xink - Show gossip option only if player has no item Xink''s Shredder Control Device'), +(15,9461,0,0,0,9,0,12140,0,0,0,0,'','Roanauk Icemist - Show gossip option only if player has taken quest All Hail Roanauk!'), +(15,9501,0,0,0,9,0,12274,0,0,0,0,'','Agent Skully - Show gossip option only if player has taken quest A Fall From Grace'), +(15,9501,0,0,0,1,0,48761,0,0,1,0,'','Agent Skully - Show gossip option only if player has no aura Scarlet Raven Priest Image'), +(15,9501,0,0,0,1,0,48763,0,0,1,0,'','Agent Skully - Show gossip option only if player has no aura Scarlet Raven Priest Image'), +(15,9568,0,0,0,9,0,12372,0,0,0,0,'','Wyrmrest Defender - Show gossip option only if player has taken quest Defending Wyrmrest Temple'), +(15,9586,0,0,0,2,0,37888,1,0,1,0,'','Chromie - Show gossip option only if player has no item Arcane Disruptor'); + +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` IN (26660,27350); +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (26179,26184,26660,27350) AND `source_type`=0; +DELETE FROM `smart_scripts` WHERE `entryorguid`=26179*100 AND `source_type`=9; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(26179,0,0,1,62,0,100,0,9303,0,0,0,11,47029,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Taunka''le Refugee - On gossip option select - Spellcast Taunka Sworn In'), +(26179,0,1,2,61,0,100,0,0,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Taunka''le Refugee - On gossip option select - Close gossip'), +(26179,0,2,3,61,0,100,0,0,0,0,0,33,26179,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Taunka''le Refugee - On gossip option select - Quest credit'), +(26179,0,3,4,61,0,100,0,0,0,0,0,83,1,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Taunka''le Refugee - On gossip option select - Remove npcflag gossip'), +(26179,0,4,5,61,0,100,0,0,0,0,0,69,1,0,0,0,0,0,20,188252,20,0,0,0,0,0, 'Taunka''le Refugee - On gossip option select - Move to Recovered Horde Armaments'), +(26179,0,5,6,61,0,100,0,0,0,0,0,69,1,0,0,0,0,0,20,188253,20,0,0,0,0,0, 'Taunka''le Refugee - On gossip option select - Move to Recovered Horde Armaments'), +(26179,0,6,0,61,0,100,0,0,0,0,0,69,1,0,0,0,0,0,20,188254,20,0,0,0,0,0, 'Taunka''le Refugee - On gossip option select - Move to Recovered Horde Armaments'), +(26179,0,7,0,34,0,100,0,0,1,0,0,80,26179*100,2,0,0,0,0,1,0,0,0,0,0,0,0, 'Taunka''le Refugee - On movement inform - Run script'), +(26179,0,8,9,34,0,100,0,0,2,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Taunka''le Refugee - On movement inform - Despawn'), +(26179,0,9,0,61,0,100,0,0,0,0,0,82,1,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Taunka''le Refugee - On gossip option select - Add npcflag gossip'), +(26184,0,0,1,62,0,100,0,9303,0,0,0,11,47029,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Taunka''le Refugee - On gossip option select - Spellcast Taunka Sworn In'), +(26184,0,1,2,61,0,100,0,0,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Taunka''le Refugee - On gossip option select - Close gossip'), +(26184,0,2,3,61,0,100,0,0,0,0,0,33,26179,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Taunka''le Refugee - On gossip option select - Quest credit'), +(26184,0,3,4,61,0,100,0,0,0,0,0,83,1,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Taunka''le Refugee - On gossip option select - Remove npcflag gossip'), +(26184,0,4,5,61,0,100,0,0,0,0,0,69,1,0,0,0,0,0,20,188252,20,0,0,0,0,0, 'Taunka''le Refugee - On gossip option select - Move to Recovered Horde Armaments'), +(26184,0,5,6,61,0,100,0,0,0,0,0,69,1,0,0,0,0,0,20,188253,20,0,0,0,0,0, 'Taunka''le Refugee - On gossip option select - Move to Recovered Horde Armaments'), +(26184,0,6,0,61,0,100,0,0,0,0,0,69,1,0,0,0,0,0,20,188254,20,0,0,0,0,0, 'Taunka''le Refugee - On gossip option select - Move to Recovered Horde Armaments'), +(26184,0,7,0,34,0,100,0,0,1,0,0,80,26179*100,2,0,0,0,0,1,0,0,0,0,0,0,0, 'Taunka''le Refugee - On movement inform - Run script'), +(26184,0,8,9,34,0,100,0,0,2,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Taunka''le Refugee - On movement inform - Despawn'), +(26184,0,9,0,61,0,100,0,0,0,0,0,82,1,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Taunka''le Refugee - On gossip option select - Add npcflag gossip'), +(26660,0,0,1,62,0,100,0,9422,0,0,0,11,52872,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Xink - On gossip option select - Spellcast Forceitem Xink''s Shredder'), +(26660,0,1,0,61,0,100,0,0,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Xink - On gossip option select - Close gossip'), +(27350,0,0,0,62,0,100,0,9501,0,0,0,11,48762,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Agent Skully - On gossip option select - Spellcast A Fall from Grace: Scarlet Raven Priest Image - Master'), + +(26179*100,9,0,0,0,0,100,0,0,0,0,0,66,0,0,0,0,0,0,20,188252,20,0,0,0,0,0, 'Taunka''le Refugee script - Turn to Recovered Horde Armaments'), +(26179*100,9,1,0,0,0,100,0,1100,1100,0,0,5,381,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Taunka''le Refugee script - Play emote'), +(26179*100,9,2,0,0,0,100,0,2500,2500,0,0,5,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Taunka''le Refugee script - Cancel emote'), +(26179*100,9,3,0,0,0,100,0,0,0,0,0,11,47024,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Taunka''le Refugee script - Spellcast Taunka Transform'), +(26179*100,9,4,0,0,0,100,0,2200,2200,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Taunka''le Refugee script - Say line'), +(26179*100,9,5,0,0,0,100,0,0,0,0,0,59,1,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Taunka''le Refugee script - Set run'), +(26179*100,9,6,0,0,0,100,0,4700,4700,0,0,69,2,0,0,0,0,0,8,0,0,0,3680.874,2875.829,91.52616,0, 'Taunka''le Refugee script - Move to position'); diff --git a/sql/updates/world/2013_02_18_03_world_spell_area.sql b/sql/updates/world/2013_02_18_03_world_spell_area.sql new file mode 100644 index 00000000000..28752bdaea7 --- /dev/null +++ b/sql/updates/world/2013_02_18_03_world_spell_area.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_area` WHERE `spell`=68132 AND `area`=4741; +INSERT INTO `spell_area` (`spell`, `area`, `autocast`) VALUES +(68132, 4741, 1); diff --git a/sql/updates/world/2013_02_19_00_world_creature_template.sql b/sql/updates/world/2013_02_19_00_world_creature_template.sql new file mode 100644 index 00000000000..eb1344c8d4b --- /dev/null +++ b/sql/updates/world/2013_02_19_00_world_creature_template.sql @@ -0,0 +1,46 @@ +-- Issue 8590: Damage Boss ICC +-- Lord Marrowgar +UPDATE `creature_template` SET `dmg_multiplier`=55 WHERE `entry`=36612; +UPDATE `creature_template` SET `dmg_multiplier`=85 WHERE `entry`=37957; +UPDATE `creature_template` SET `dmg_multiplier`=75 WHERE `entry`=37958; +UPDATE `creature_template` SET `dmg_multiplier`=110 WHERE `entry`=37959; +-- Lady Deathwhisper +UPDATE `creature_template` SET `dmg_multiplier`=70 WHERE `entry`=36855; +UPDATE `creature_template` SET `dmg_multiplier`=100 WHERE `entry`=38106; +UPDATE `creature_template` SET `dmg_multiplier`=90 WHERE `entry`=38296; +UPDATE `creature_template` SET `dmg_multiplier`=140 WHERE `entry`=38297; +-- Deathbringer Saurfang +UPDATE `creature_template` SET `dmg_multiplier`=60 WHERE `entry`=37813; +UPDATE `creature_template` SET `dmg_multiplier`=90 WHERE `entry`=38402; +UPDATE `creature_template` SET `dmg_multiplier`=85 WHERE `entry`=38582; +UPDATE `creature_template` SET `dmg_multiplier`=120 WHERE `entry`=38583; +-- Festergut +UPDATE `creature_template` SET `dmg_multiplier`=75 WHERE `entry`=36626; +UPDATE `creature_template` SET `dmg_multiplier`=115 WHERE `entry`=37504; +UPDATE `creature_template` SET `dmg_multiplier`=100 WHERE `entry`=37505; +UPDATE `creature_template` SET `dmg_multiplier`=150 WHERE `entry`=37506; +-- Rotface +UPDATE `creature_template` SET `dmg_multiplier`=70 WHERE `entry`=36627; +UPDATE `creature_template` SET `dmg_multiplier`=100 WHERE `entry`=38390; +UPDATE `creature_template` SET `dmg_multiplier`=90 WHERE `entry`=38549; +UPDATE `creature_template` SET `dmg_multiplier`=140 WHERE `entry`=38550; +-- Professor Putricide +UPDATE `creature_template` SET `dmg_multiplier`=60 WHERE `entry`=36678; +UPDATE `creature_template` SET `dmg_multiplier`=90 WHERE `entry`=38431; +UPDATE `creature_template` SET `dmg_multiplier`=80 WHERE `entry`=38585; +UPDATE `creature_template` SET `dmg_multiplier`=120 WHERE `entry`=38586; +-- Blood Prince Council except Keleseth who is a caster +UPDATE `creature_template` SET `dmg_multiplier`=65 WHERE `entry` IN (37970,37973); +UPDATE `creature_template` SET `dmg_multiplier`=95 WHERE `entry` IN (38401,38400); +UPDATE `creature_template` SET `dmg_multiplier`=85 WHERE `entry` IN (38784,38771); +UPDATE `creature_template` SET `dmg_multiplier`=130 WHERE `entry` IN (38785,38772); +-- Blood Queen Lana'thel +UPDATE `creature_template` SET `dmg_multiplier`=60 WHERE `entry`=37955; +UPDATE `creature_template` SET `dmg_multiplier`=90 WHERE `entry`=38434; +UPDATE `creature_template` SET `dmg_multiplier`=80 WHERE `entry`=38435; +UPDATE `creature_template` SET `dmg_multiplier`=120 WHERE `entry`=38436; +-- Sindragosa (and damage for Sindragosa 10 who hits only 1) +UPDATE `creature_template` SET `dmg_multiplier`=60, mindmg=509, maxdmg=683, attackpower=805 WHERE `entry`=36853; +UPDATE `creature_template` SET `dmg_multiplier`=90 WHERE `entry`=38265; +UPDATE `creature_template` SET `dmg_multiplier`=80 WHERE `entry`=38266; +UPDATE `creature_template` SET `dmg_multiplier`=120 WHERE `entry`=38267; diff --git a/sql/updates/world/2013_02_19_01_world_creature_template.sql b/sql/updates/world/2013_02_19_01_world_creature_template.sql new file mode 100644 index 00000000000..ba7c6bf132a --- /dev/null +++ b/sql/updates/world/2013_02_19_01_world_creature_template.sql @@ -0,0 +1,2 @@ +-- Flags 128+2: creature is trigger-NPC (invisible to players only) + creature does not aggro (ignore faction/reputation hostility) +UPDATE `creature_template` SET `flags_extra` = (`flags_extra`|2|128) WHERE `entry` IN (32195,32196,32197,32199); diff --git a/sql/updates/world/2013_02_19_02_world_conditions.sql b/sql/updates/world/2013_02_19_02_world_conditions.sql new file mode 100644 index 00000000000..87c964937ef --- /dev/null +++ b/sql/updates/world/2013_02_19_02_world_conditions.sql @@ -0,0 +1,38 @@ +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=23 AND `SourceGroup`=12944 AND `SourceEntry` IN (20761,17051,17022,17018,17023,19444); +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=23 AND `SourceGroup`=12944 AND `SourceEntry` IN (19219,17017,17025,19330,19448,17059,17060,17049,19206); +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=23 AND `SourceGroup`=12944 AND `SourceEntry` IN (19220,19332,19333,19331,19449,19209,19208,19207,17053,17052); +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=23 AND `SourceGroup`=12944 AND `SourceEntry` IN (19211,19210,19212,20040); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +-- Conditon rep Friendly +(23,12944,20761,0,0,5,0,59,16,0,0,0, '', 'Lokhtos Darkbargainer - Only sell item if Friendly with Thorium Brotherhood'), +(23,12944,17051,0,0,5,0,59,16,0,0,0, '', 'Lokhtos Darkbargainer - Only sell item if Friendly with Thorium Brotherhood'), +(23,12944,17022,0,0,5,0,59,16,0,0,0, '', 'Lokhtos Darkbargainer - Only sell item if Friendly with Thorium Brotherhood'), +(23,12944,17018,0,0,5,0,59,16,0,0,0, '', 'Lokhtos Darkbargainer - Only sell item if Friendly with Thorium Brotherhood'), +(23,12944,17023,0,0,5,0,59,16,0,0,0, '', 'Lokhtos Darkbargainer - Only sell item if Friendly with Thorium Brotherhood'), +(23,12944,19444,0,0,5,0,59,16,0,0,0, '', 'Lokhtos Darkbargainer - Only sell item if Friendly with Thorium Brotherhood'), +-- Conditon rep Honored +(23,12944,19219,0,0,5,0,59,32,0,0,0, '', 'Lokhtos Darkbargainer - Only sell item if Honored with Thorium Brotherhood'), +(23,12944,17017,0,0,5,0,59,32,0,0,0, '', 'Lokhtos Darkbargainer - Only sell item if Honored with Thorium Brotherhood'), +(23,12944,17025,0,0,5,0,59,32,0,0,0, '', 'Lokhtos Darkbargainer - Only sell item if Honored with Thorium Brotherhood'), +(23,12944,19330,0,0,5,0,59,32,0,0,0, '', 'Lokhtos Darkbargainer - Only sell item if Honored with Thorium Brotherhood'), +(23,12944,19448,0,0,5,0,59,32,0,0,0, '', 'Lokhtos Darkbargainer - Only sell item if Honored with Thorium Brotherhood'), +(23,12944,17059,0,0,5,0,59,32,0,0,0, '', 'Lokhtos Darkbargainer - Only sell item if Honored with Thorium Brotherhood'), +(23,12944,17060,0,0,5,0,59,32,0,0,0, '', 'Lokhtos Darkbargainer - Only sell item if Honored with Thorium Brotherhood'), +(23,12944,17049,0,0,5,0,59,32,0,0,0, '', 'Lokhtos Darkbargainer - Only sell item if Honored with Thorium Brotherhood'), +(23,12944,19206,0,0,5,0,59,32,0,0,0, '', 'Lokhtos Darkbargainer - Only sell item if Honored with Thorium Brotherhood'), +-- Conditon rep Revered +(23,12944,19220,0,0,5,0,59,64,0,0,0, '', 'Lokhtos Darkbargainer - Only sell item if Revered with Thorium Brotherhood'), +(23,12944,19332,0,0,5,0,59,64,0,0,0, '', 'Lokhtos Darkbargainer - Only sell item if Revered with Thorium Brotherhood'), +(23,12944,19333,0,0,5,0,59,64,0,0,0, '', 'Lokhtos Darkbargainer - Only sell item if Revered with Thorium Brotherhood'), +(23,12944,19331,0,0,5,0,59,64,0,0,0, '', 'Lokhtos Darkbargainer - Only sell item if Revered with Thorium Brotherhood'), +(23,12944,19449,0,0,5,0,59,64,0,0,0, '', 'Lokhtos Darkbargainer - Only sell item if Revered with Thorium Brotherhood'), +(23,12944,19209,0,0,5,0,59,64,0,0,0, '', 'Lokhtos Darkbargainer - Only sell item if Revered with Thorium Brotherhood'), +(23,12944,19208,0,0,5,0,59,64,0,0,0, '', 'Lokhtos Darkbargainer - Only sell item if Revered with Thorium Brotherhood'), +(23,12944,19207,0,0,5,0,59,64,0,0,0, '', 'Lokhtos Darkbargainer - Only sell item if Revered with Thorium Brotherhood'), +(23,12944,17053,0,0,5,0,59,64,0,0,0, '', 'Lokhtos Darkbargainer - Only sell item if Revered with Thorium Brotherhood'), +(23,12944,17052,0,0,5,0,59,64,0,0,0, '', 'Lokhtos Darkbargainer - Only sell item if Revered with Thorium Brotherhood'), +-- Conditon rep Exalted +(23,12944,19211,0,0,5,0,59,128,0,0,0, '', 'Lokhtos Darkbargainer - Only sell item if Exalted with Thorium Brotherhood'), +(23,12944,19210,0,0,5,0,59,128,0,0,0, '', 'Lokhtos Darkbargainer - Only sell item if Exalted with Thorium Brotherhood'), +(23,12944,19212,0,0,5,0,59,128,0,0,0, '', 'Lokhtos Darkbargainer - Only sell item if Exalted with Thorium Brotherhood'), +(23,12944,20040,0,0,5,0,59,128,0,0,0, '', 'Lokhtos Darkbargainer - Only sell item if Exalted with Thorium Brotherhood'); diff --git a/sql/updates/world/2013_02_19_03_world_sai.sql b/sql/updates/world/2013_02_19_03_world_sai.sql new file mode 100644 index 00000000000..ad2c9beeab1 --- /dev/null +++ b/sql/updates/world/2013_02_19_03_world_sai.sql @@ -0,0 +1,28 @@ +-- Fix quest: Gather the Orbs http://www.wowhead.com/quest=10859 +-- ID indexes +-- Almost all is based on Untaught script, just corrected some stuff with sniff +SET @OrbCollectingTotem := 22333; +SET @LightOrb := 20635; +SET @Script := @LightOrb * 100; +SET @BanishedState := 32566; +SET @ArcaneExplosion := 35426; -- such spells need delay to execute properly, that is why I made actionlist +-- Update templates +UPDATE `creature_template` SET `unit_flags`=unit_flags|0x02000000 WHERE `entry`=@LightOrb; -- sniff +-- Add SAI support for Light Orbs and Totem +DELETE FROM `creature_ai_scripts` WHERE `creature_id`=@LightOrb; +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` IN (@LightOrb,@OrbCollectingTotem); +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (@LightOrb,@OrbCollectingTotem) AND `source_type`=0; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@Script AND `source_type`=9; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@OrbCollectingTotem,0,0,1,54,0,100,0,0,0,0,0,45,0,1,0,0,0,0,19,@LightOrb,20,0,0,0,0,0, 'Orb collecting totem - On spawned - Set Data 0 1'), +(@OrbCollectingTotem,0,1,2,61,0,100,0,0,0,0,0,64,1,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Orb collecting totem - Linked with previous event - Store invoker'), +(@OrbCollectingTotem,0,2,0,61,0,100,0,0,0,0,0,100,1,0,0,0,0,0,19,@LightOrb,20,0,0,0,0,0, 'Orb collecting totem - Linked with previous event - Send stored target list 1'), +(@LightOrb,0,0,0,25,0,100,1,0,0,0,0,11,@BanishedState,0,0,0,0,0,1,0,0,0,0,0,0,0, 'On spawn/reset - Cast Purple Banish State'), +(@LightOrb,0,1,0,38,0,100,0,0,1,30000,30000,69,1,0,0,0,0,0,19,@OrbCollectingTotem,20,0,0,0,0,0, 'Light Orb - On Data Set 0 1 - Move to totem'), +(@LightOrb,0,2,3,34,0,100,1,8,1,0,0,11,@ArcaneExplosion,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Light Orb - On point 1 reached - Cast arcane explosion'), +(@LightOrb,0,3,4,61,0,100,0,0,0,0,0,33,21929,0,0,0,0,0,12,1,0,0,0,0,0,0, 'Light Orb - Linkedw with previous event - Call kill credit'), +(@LightOrb,0,4,0,61,0,100,0,0,0,0,0,80,@Script,2,0,0,0,0,1,0,0,0,0,0,0,0, 'Light Orb - Linkedw with previous event - Start action list to display arcase explosion'), +(@Script,9,0,0,0,0,100,0,0,0,0,0,47,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Light Orb - Action 0 - Set unseen'), +(@Script,9,1,0,0,0,100,0,0,0,0,0,41,100,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Light Orb - Action 1 - Despawn in 100 ms'); +-- Remove deprecated required spell cast that was blocking the credit, on top of that it had some nosense spell that has nothing to do with quest?! +UPDATE `quest_template` SET `requiredspellcast1`=0 WHERE `id`=10859; |
