diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/old/3.3.5a/2011_11_24_00_world_version.sql (renamed from sql/updates/world/2011_11_24_00_world_version.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_25_00_world_quest_template.sql (renamed from sql/updates/world/2011_11_25_00_world_quest_template.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_25_01_world_quest_template.sql (renamed from sql/updates/world/2011_11_25_01_world_quest_template.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_25_02_world_creature.sql (renamed from sql/updates/world/2011_11_25_02_world_creature.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_26_00_world_quest_template.sql (renamed from sql/updates/world/2011_11_26_00_world_quest_template.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_26_01_world_quest_template.sql (renamed from sql/updates/world/2011_11_26_01_world_quest_template.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_26_02_world_spell_group.sql (renamed from sql/updates/world/2011_11_26_02_world_spell_group.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_26_03_world_spell_proc_event.sql (renamed from sql/updates/world/2011_11_26_03_world_spell_proc_event.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_26_04_world_achievement_criteria_data.sql (renamed from sql/updates/world/2011_11_26_04_world_achievement_criteria_data.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_26_04_world_disables.sql (renamed from sql/updates/world/2011_11_26_04_world_disables.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_26_05_world_ulduar_gameobject.sql (renamed from sql/updates/world/2011_11_26_05_world_ulduar_gameobject.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_26_06_world_sai.sql (renamed from sql/updates/world/2011_11_26_06_world_sai.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_27_00_world_creature_template.sql (renamed from sql/updates/world/2011_11_27_00_world_creature_template.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_27_00_world_spell_script.sql (renamed from sql/updates/world/2011_11_27_00_world_spell_script.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_28_00_world_achievement_criteria_data.sql (renamed from sql/updates/world/2011_11_28_00_world_achievement_criteria_data.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_11_29_00_world_spell_script.sql (renamed from sql/updates/world/2011_11_29_00_world_spell_script.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_12_03_00_world_gameobject.sql (renamed from sql/updates/world/2011_12_03_00_world_gameobject.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_12_08_00_world_gossip.sql (renamed from sql/updates/world/2011_12_08_00_world_gossip.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_12_08_00_world_player_factionchange_achievement.sql (renamed from sql/updates/world/2011_12_08_00_world_player_factionchange_achievement.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_12_08_01_world_creature_template_addon.sql (renamed from sql/updates/world/2011_12_08_01_world_creature_template_addon.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_12_10_00_world_spell_proc_event.sql (renamed from sql/updates/world/2011_12_10_00_world_spell_proc_event.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_12_10_01_world_achievement_criteria_data.sql (renamed from sql/updates/world/2011_12_10_01_world_achievement_criteria_data.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_12_12_00_world_spell_bonus_data.sql (renamed from sql/updates/world/2011_12_12_00_world_spell_bonus_data.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_12_13_00_world_misc.sql (renamed from sql/updates/world/2011_12_13_00_world_misc.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_12_13_01_world_achievement_criteria_data.sql (renamed from sql/updates/world/2011_12_13_01_world_achievement_criteria_data.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_12_13_02_world_creature_template_addon.sql (renamed from sql/updates/world/2011_12_13_02_world_creature_template_addon.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_12_14_00_world_command.sql (renamed from sql/updates/world/2011_12_14_00_world_command.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_12_14_01_world_gameobject_template.sql (renamed from sql/updates/world/2011_12_14_01_world_gameobject_template.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_12_16_00_world_creature_template.sql (renamed from sql/updates/world/2011_12_16_00_world_creature_template.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_12_16_00_world_spell_bonus_data.sql (renamed from sql/updates/world/2011_12_16_00_world_spell_bonus_data.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_12_17_00_world_creature.sql (renamed from sql/updates/world/2011_12_17_00_world_creature.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_12_17_00_world_gameobject.sql (renamed from sql/updates/world/2011_12_17_00_world_gameobject.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_12_18_00_world_creature_addon.sql (renamed from sql/updates/world/2011_12_18_00_world_creature_addon.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_12_18_01_world_gossip.sql (renamed from sql/updates/world/2011_12_18_01_world_gossip.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_12_18_02_world_spell_script_names.sql (renamed from sql/updates/world/2011_12_18_02_world_spell_script_names.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_12_18_03_world_trinity_string.sql (renamed from sql/updates/world/2011_12_18_03_world_trinity_string.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_12_18_04_world_misc.sql (renamed from sql/updates/world/2011_12_18_04_world_misc.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_12_18_05_world_misc.sql (renamed from sql/updates/world/2011_12_18_05_world_misc.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_12_18_06_world_sai.sql (renamed from sql/updates/world/2011_12_18_06_world_sai.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_12_18_07_world_conditions.sql (renamed from sql/updates/world/2011_12_18_07_world_conditions.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_12_19_00_world_conditions.sql (renamed from sql/updates/world/2011_12_19_00_world_conditions.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_12_19_01_world_quest_template.sql (renamed from sql/updates/world/2011_12_19_01_world_quest_template.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_12_19_02_world_achievement_criteria_data.sql (renamed from sql/updates/world/2011_12_19_02_world_achievement_criteria_data.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_12_24_00_world_misc.sql (renamed from sql/updates/world/2011_12_24_00_world_misc.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_12_24_00_world_spell_proc_event.sql (renamed from sql/updates/world/2011_12_24_00_world_spell_proc_event.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_12_24_01_world_mail_loot_template.sql (renamed from sql/updates/world/2011_12_24_01_world_mail_loot_template.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_12_25_00_world_areatrigger_scriptnames.sql (renamed from sql/updates/world/2011_12_25_00_world_areatrigger_scriptnames.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_12_25_00_world_gameobject_scriptnames.sql (renamed from sql/updates/world/2011_12_25_00_world_gameobject_scriptnames.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_12_25_00_world_misc.sql (renamed from sql/updates/world/2011_12_25_00_world_misc.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_12_25_00_world_sai.sql (renamed from sql/updates/world/2011_12_25_00_world_sai.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_12_25_00_world_spell_script_names.sql (renamed from sql/updates/world/2011_12_25_00_world_spell_script_names.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_12_25_01_world_areatrigger_scriptnames.sql (renamed from sql/updates/world/2011_12_25_01_world_areatrigger_scriptnames.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_12_25_01_world_misc.sql (renamed from sql/updates/world/2011_12_25_01_world_misc.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_12_25_01_world_sai.sql (renamed from sql/updates/world/2011_12_25_01_world_sai.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_12_25_02_world_areatrigger_scriptnames.sql (renamed from sql/updates/world/2011_12_25_02_world_areatrigger_scriptnames.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_12_25_02_world_misc.sql (renamed from sql/updates/world/2011_12_25_02_world_misc.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_12_25_02_world_sai.sql (renamed from sql/updates/world/2011_12_25_02_world_sai.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_12_25_03_world_misc.sql (renamed from sql/updates/world/2011_12_25_03_world_misc.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_12_25_03_world_sai.sql (renamed from sql/updates/world/2011_12_25_03_world_sai.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_12_26_00_world_sai.sql (renamed from sql/updates/world/2011_12_26_00_world_sai.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_12_26_01_world_sai.sql (renamed from sql/updates/world/2011_12_26_01_world_sai.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_12_26_02_world_sai.sql (renamed from sql/updates/world/2011_12_26_02_world_sai.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_12_26_03_world_sai.sql (renamed from sql/updates/world/2011_12_26_03_world_sai.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_12_26_04_world_sai.sql (renamed from sql/updates/world/2011_12_26_04_world_sai.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_12_26_05_world_sai.sql (renamed from sql/updates/world/2011_12_26_05_world_sai.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_12_26_06_world_sai.sql (renamed from sql/updates/world/2011_12_26_06_world_sai.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_12_26_07_world_sai.sql (renamed from sql/updates/world/2011_12_26_07_world_sai.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_12_26_08_world_sai.sql (renamed from sql/updates/world/2011_12_26_08_world_sai.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_02_00_world_sai.sql (renamed from sql/updates/world/2012_01_02_00_world_sai.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_02_01_world_game_event.sql (renamed from sql/updates/world/2012_01_02_01_world_game_event.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_02_02_world_creature_template.sql (renamed from sql/updates/world/2012_01_02_02_world_creature_template.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_02_03_world_creature_onkill_reputation.sql (renamed from sql/updates/world/2012_01_02_03_world_creature_onkill_reputation.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_03_00_world_gossip_menu.sql (renamed from sql/updates/world/2012_01_03_00_world_gossip_menu.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_03_01_world_quest_template.sql (renamed from sql/updates/world/2012_01_03_01_world_quest_template.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_03_02_world_sai.sql (renamed from sql/updates/world/2012_01_03_02_world_sai.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_03_03_world_creature_template.sql (renamed from sql/updates/world/2012_01_03_03_world_creature_template.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_03_04_world_gameobject_questrelation.sql (renamed from sql/updates/world/2012_01_03_04_world_gameobject_questrelation.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_03_05_world_creature.sql (renamed from sql/updates/world/2012_01_03_05_world_creature.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_03_06_world_sai.sql (renamed from sql/updates/world/2012_01_03_06_world_sai.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_03_07_world_creature.sql (renamed from sql/updates/world/2012_01_03_07_world_creature.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_04_00_characters_character_queststatus_seasonal.sql (renamed from sql/updates/characters/2012_01_04_00_characters_character_queststatus_seasonal.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_04_00_world_gossip_menu.sql (renamed from sql/updates/world/2012_01_04_00_world_gossip_menu.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_04_01_world_game_event_seasonal_questrelation.sql (renamed from sql/updates/world/2012_01_04_01_world_game_event_seasonal_questrelation.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_04_02_world_achievements.sql (renamed from sql/updates/world/2012_01_04_02_world_achievements.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_04_02_world_sai.sql (renamed from sql/updates/world/2012_01_04_02_world_sai.sql) | 6 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_04_03_world_spell_script_names.sql (renamed from sql/updates/world/2012_01_04_03_world_spell_script_names.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_04_04_world_creature.sql (renamed from sql/updates/world/2012_01_04_04_world_creature.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_04_04_world_creature_template.sql (renamed from sql/updates/world/2012_01_04_04_world_creature_template.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_04_05_world_waypoint_data.sql (renamed from sql/updates/world/2012_01_04_05_world_waypoint_data.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_04_06_world_waypoint_data.sql (renamed from sql/updates/world/2012_01_04_06_world_waypoint_data.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_04_07_world_gossip_menu.sql (renamed from sql/updates/world/2012_01_04_07_world_gossip_menu.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_04_08_world_gossip_menu.sql (renamed from sql/updates/world/2012_01_04_08_world_gossip_menu.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_04_09_world_gossip_menu.sql (renamed from sql/updates/world/2012_01_04_09_world_gossip_menu.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_04_10_world_gossip_menu.sql (renamed from sql/updates/world/2012_01_04_10_world_gossip_menu.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_04_11_world_gossip_menu.sql (renamed from sql/updates/world/2012_01_04_11_world_gossip_menu.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_04_12_world_gosip_menu.sql (renamed from sql/updates/world/2012_01_04_12_world_gosip_menu.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_04_13_world_gossip_menu.sql (renamed from sql/updates/world/2012_01_04_13_world_gossip_menu.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_04_14_world_gossip_menu.sql (renamed from sql/updates/world/2012_01_04_14_world_gossip_menu.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_04_15_world_gossip_menu.sql (renamed from sql/updates/world/2012_01_04_15_world_gossip_menu.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_05_00_world_script_texts.sql (renamed from sql/updates/world/2012_01_05_00_world_script_texts.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_05_01_world_gameobject.sql (renamed from sql/updates/world/2012_01_05_01_world_gameobject.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_05_02_world_gameobject_template.sql (renamed from sql/updates/world/2012_01_05_02_world_gameobject_template.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_05_03_world_creature_model_info.sql (renamed from sql/updates/world/2012_01_05_03_world_creature_model_info.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_05_04_world_gameobject.sql (renamed from sql/updates/world/2012_01_05_04_world_gameobject.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_05_05_world_creature.sql (renamed from sql/updates/world/2012_01_05_05_world_creature.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_05_06_world_spell_script_names.sql (renamed from sql/updates/world/2012_01_05_06_world_spel_script_names.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_05_07_world_creature_template.sql (renamed from sql/updates/world/2012_01_05_07_world_creature_template.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_05_08_world_creature_template.sql (renamed from sql/updates/world/2012_01_05_08_world_creature_template.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_05_09_world_waypoint_data.sql (renamed from sql/updates/world/2012_01_05_09_world_waypoint_data.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_05_10_world_creature_template.sql (renamed from sql/updates/world/2012_01_05_10_world_creature_template.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_05_11_world_creature_onkill_reputation.sql (renamed from sql/updates/world/2012_01_05_11_world_creature_onkill_reputation.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_05_12_world_game_event_seasonal_questrelation.sql (renamed from sql/updates/world/2012_01_05_12_world_game_event_seasonal_questrelation.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_05_13_world_creature_transport.sql (renamed from sql/updates/world/2012_01_05_13_world_creature_transport.sql) | 0 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_05_14_world_command.sql | 1 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_05_14_world_creature_template.sql | 9 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_06_00_world_creature_template_addon.sql | 4 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_06_00_world_misc.sql | 189 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_06_01_world_creature_template.sql | 2 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_06_02_world_achievement_criteria_data.sql | 24 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_06_03_world_item_loot_template.sql | 8 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_06_04_world_creature_questrelation.sql | 5 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_06_05_world_creature_template.sql | 2 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_06_06_world_quest_template.sql | 2 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_06_07_world_sai.sql | 23 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_06_08_world_creature_template.sql | 2 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_06_09_world_creature_questrelation.sql | 9 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_06_10_world_creature_template.sql | 2 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_06_11_world_sai.sql | 14 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_06_12_world_sai.sql | 2 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_07_00_world_creature_addon.sql | 2 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_07_01_world_creature_template.sql | 8 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_07_02_world_gameobject_template.sql | 2 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_07_03_world_creature_template.sql | 8 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_07_04_world_creature_loot_template.sql | 29 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_01_07_05_world_creature_loot_template.sql | 4 | ||||
| -rw-r--r-- | sql/updates/world/2012_01_08_00_world_version.sql | 1 |
136 files changed, 355 insertions, 3 deletions
diff --git a/sql/updates/world/2011_11_24_00_world_version.sql b/sql/old/3.3.5a/2011_11_24_00_world_version.sql index ad2396f29e1..ad2396f29e1 100644 --- a/sql/updates/world/2011_11_24_00_world_version.sql +++ b/sql/old/3.3.5a/2011_11_24_00_world_version.sql diff --git a/sql/updates/world/2011_11_25_00_world_quest_template.sql b/sql/old/3.3.5a/2011_11_25_00_world_quest_template.sql index eee92a3761b..eee92a3761b 100644 --- a/sql/updates/world/2011_11_25_00_world_quest_template.sql +++ b/sql/old/3.3.5a/2011_11_25_00_world_quest_template.sql diff --git a/sql/updates/world/2011_11_25_01_world_quest_template.sql b/sql/old/3.3.5a/2011_11_25_01_world_quest_template.sql index f7e4555f093..f7e4555f093 100644 --- a/sql/updates/world/2011_11_25_01_world_quest_template.sql +++ b/sql/old/3.3.5a/2011_11_25_01_world_quest_template.sql diff --git a/sql/updates/world/2011_11_25_02_world_creature.sql b/sql/old/3.3.5a/2011_11_25_02_world_creature.sql index 0b26187f196..0b26187f196 100644 --- a/sql/updates/world/2011_11_25_02_world_creature.sql +++ b/sql/old/3.3.5a/2011_11_25_02_world_creature.sql diff --git a/sql/updates/world/2011_11_26_00_world_quest_template.sql b/sql/old/3.3.5a/2011_11_26_00_world_quest_template.sql index 6a7834e0a76..6a7834e0a76 100644 --- a/sql/updates/world/2011_11_26_00_world_quest_template.sql +++ b/sql/old/3.3.5a/2011_11_26_00_world_quest_template.sql diff --git a/sql/updates/world/2011_11_26_01_world_quest_template.sql b/sql/old/3.3.5a/2011_11_26_01_world_quest_template.sql index 5b08d57860b..5b08d57860b 100644 --- a/sql/updates/world/2011_11_26_01_world_quest_template.sql +++ b/sql/old/3.3.5a/2011_11_26_01_world_quest_template.sql diff --git a/sql/updates/world/2011_11_26_02_world_spell_group.sql b/sql/old/3.3.5a/2011_11_26_02_world_spell_group.sql index 71ad2eaf9fb..71ad2eaf9fb 100644 --- a/sql/updates/world/2011_11_26_02_world_spell_group.sql +++ b/sql/old/3.3.5a/2011_11_26_02_world_spell_group.sql diff --git a/sql/updates/world/2011_11_26_03_world_spell_proc_event.sql b/sql/old/3.3.5a/2011_11_26_03_world_spell_proc_event.sql index 36837be8ab6..36837be8ab6 100644 --- a/sql/updates/world/2011_11_26_03_world_spell_proc_event.sql +++ b/sql/old/3.3.5a/2011_11_26_03_world_spell_proc_event.sql diff --git a/sql/updates/world/2011_11_26_04_world_achievement_criteria_data.sql b/sql/old/3.3.5a/2011_11_26_04_world_achievement_criteria_data.sql index b037bf58349..b037bf58349 100644 --- a/sql/updates/world/2011_11_26_04_world_achievement_criteria_data.sql +++ b/sql/old/3.3.5a/2011_11_26_04_world_achievement_criteria_data.sql diff --git a/sql/updates/world/2011_11_26_04_world_disables.sql b/sql/old/3.3.5a/2011_11_26_04_world_disables.sql index 4722f248656..4722f248656 100644 --- a/sql/updates/world/2011_11_26_04_world_disables.sql +++ b/sql/old/3.3.5a/2011_11_26_04_world_disables.sql diff --git a/sql/updates/world/2011_11_26_05_world_ulduar_gameobject.sql b/sql/old/3.3.5a/2011_11_26_05_world_ulduar_gameobject.sql index 60ba0aefbeb..60ba0aefbeb 100644 --- a/sql/updates/world/2011_11_26_05_world_ulduar_gameobject.sql +++ b/sql/old/3.3.5a/2011_11_26_05_world_ulduar_gameobject.sql diff --git a/sql/updates/world/2011_11_26_06_world_sai.sql b/sql/old/3.3.5a/2011_11_26_06_world_sai.sql index 9396222e8be..9396222e8be 100644 --- a/sql/updates/world/2011_11_26_06_world_sai.sql +++ b/sql/old/3.3.5a/2011_11_26_06_world_sai.sql diff --git a/sql/updates/world/2011_11_27_00_world_creature_template.sql b/sql/old/3.3.5a/2011_11_27_00_world_creature_template.sql index f29586ea142..f29586ea142 100644 --- a/sql/updates/world/2011_11_27_00_world_creature_template.sql +++ b/sql/old/3.3.5a/2011_11_27_00_world_creature_template.sql diff --git a/sql/updates/world/2011_11_27_00_world_spell_script.sql b/sql/old/3.3.5a/2011_11_27_00_world_spell_script.sql index 5411d660c2b..5411d660c2b 100644 --- a/sql/updates/world/2011_11_27_00_world_spell_script.sql +++ b/sql/old/3.3.5a/2011_11_27_00_world_spell_script.sql diff --git a/sql/updates/world/2011_11_28_00_world_achievement_criteria_data.sql b/sql/old/3.3.5a/2011_11_28_00_world_achievement_criteria_data.sql index 9fea807a97c..9fea807a97c 100644 --- a/sql/updates/world/2011_11_28_00_world_achievement_criteria_data.sql +++ b/sql/old/3.3.5a/2011_11_28_00_world_achievement_criteria_data.sql diff --git a/sql/updates/world/2011_11_29_00_world_spell_script.sql b/sql/old/3.3.5a/2011_11_29_00_world_spell_script.sql index ff87ebff788..ff87ebff788 100644 --- a/sql/updates/world/2011_11_29_00_world_spell_script.sql +++ b/sql/old/3.3.5a/2011_11_29_00_world_spell_script.sql diff --git a/sql/updates/world/2011_12_03_00_world_gameobject.sql b/sql/old/3.3.5a/2011_12_03_00_world_gameobject.sql index 5707ee28d12..5707ee28d12 100644 --- a/sql/updates/world/2011_12_03_00_world_gameobject.sql +++ b/sql/old/3.3.5a/2011_12_03_00_world_gameobject.sql diff --git a/sql/updates/world/2011_12_08_00_world_gossip.sql b/sql/old/3.3.5a/2011_12_08_00_world_gossip.sql index f6195d9d66e..f6195d9d66e 100644 --- a/sql/updates/world/2011_12_08_00_world_gossip.sql +++ b/sql/old/3.3.5a/2011_12_08_00_world_gossip.sql diff --git a/sql/updates/world/2011_12_08_00_world_player_factionchange_achievement.sql b/sql/old/3.3.5a/2011_12_08_00_world_player_factionchange_achievement.sql index 7a19fa2cad0..7a19fa2cad0 100644 --- a/sql/updates/world/2011_12_08_00_world_player_factionchange_achievement.sql +++ b/sql/old/3.3.5a/2011_12_08_00_world_player_factionchange_achievement.sql diff --git a/sql/updates/world/2011_12_08_01_world_creature_template_addon.sql b/sql/old/3.3.5a/2011_12_08_01_world_creature_template_addon.sql index e8a464146e0..e8a464146e0 100644 --- a/sql/updates/world/2011_12_08_01_world_creature_template_addon.sql +++ b/sql/old/3.3.5a/2011_12_08_01_world_creature_template_addon.sql diff --git a/sql/updates/world/2011_12_10_00_world_spell_proc_event.sql b/sql/old/3.3.5a/2011_12_10_00_world_spell_proc_event.sql index 957a2e76b70..957a2e76b70 100644 --- a/sql/updates/world/2011_12_10_00_world_spell_proc_event.sql +++ b/sql/old/3.3.5a/2011_12_10_00_world_spell_proc_event.sql diff --git a/sql/updates/world/2011_12_10_01_world_achievement_criteria_data.sql b/sql/old/3.3.5a/2011_12_10_01_world_achievement_criteria_data.sql index 70e4a4fc544..70e4a4fc544 100644 --- a/sql/updates/world/2011_12_10_01_world_achievement_criteria_data.sql +++ b/sql/old/3.3.5a/2011_12_10_01_world_achievement_criteria_data.sql diff --git a/sql/updates/world/2011_12_12_00_world_spell_bonus_data.sql b/sql/old/3.3.5a/2011_12_12_00_world_spell_bonus_data.sql index cb728e70dd9..cb728e70dd9 100644 --- a/sql/updates/world/2011_12_12_00_world_spell_bonus_data.sql +++ b/sql/old/3.3.5a/2011_12_12_00_world_spell_bonus_data.sql diff --git a/sql/updates/world/2011_12_13_00_world_misc.sql b/sql/old/3.3.5a/2011_12_13_00_world_misc.sql index 13958e75761..13958e75761 100644 --- a/sql/updates/world/2011_12_13_00_world_misc.sql +++ b/sql/old/3.3.5a/2011_12_13_00_world_misc.sql diff --git a/sql/updates/world/2011_12_13_01_world_achievement_criteria_data.sql b/sql/old/3.3.5a/2011_12_13_01_world_achievement_criteria_data.sql index 89bbfc7126d..89bbfc7126d 100644 --- a/sql/updates/world/2011_12_13_01_world_achievement_criteria_data.sql +++ b/sql/old/3.3.5a/2011_12_13_01_world_achievement_criteria_data.sql diff --git a/sql/updates/world/2011_12_13_02_world_creature_template_addon.sql b/sql/old/3.3.5a/2011_12_13_02_world_creature_template_addon.sql index f1dc473bdd7..f1dc473bdd7 100644 --- a/sql/updates/world/2011_12_13_02_world_creature_template_addon.sql +++ b/sql/old/3.3.5a/2011_12_13_02_world_creature_template_addon.sql diff --git a/sql/updates/world/2011_12_14_00_world_command.sql b/sql/old/3.3.5a/2011_12_14_00_world_command.sql index e871a82d89d..e871a82d89d 100644 --- a/sql/updates/world/2011_12_14_00_world_command.sql +++ b/sql/old/3.3.5a/2011_12_14_00_world_command.sql diff --git a/sql/updates/world/2011_12_14_01_world_gameobject_template.sql b/sql/old/3.3.5a/2011_12_14_01_world_gameobject_template.sql index 52c04703acc..52c04703acc 100644 --- a/sql/updates/world/2011_12_14_01_world_gameobject_template.sql +++ b/sql/old/3.3.5a/2011_12_14_01_world_gameobject_template.sql diff --git a/sql/updates/world/2011_12_16_00_world_creature_template.sql b/sql/old/3.3.5a/2011_12_16_00_world_creature_template.sql index 3ff9d630c54..3ff9d630c54 100644 --- a/sql/updates/world/2011_12_16_00_world_creature_template.sql +++ b/sql/old/3.3.5a/2011_12_16_00_world_creature_template.sql diff --git a/sql/updates/world/2011_12_16_00_world_spell_bonus_data.sql b/sql/old/3.3.5a/2011_12_16_00_world_spell_bonus_data.sql index 5864b9ac042..5864b9ac042 100644 --- a/sql/updates/world/2011_12_16_00_world_spell_bonus_data.sql +++ b/sql/old/3.3.5a/2011_12_16_00_world_spell_bonus_data.sql diff --git a/sql/updates/world/2011_12_17_00_world_creature.sql b/sql/old/3.3.5a/2011_12_17_00_world_creature.sql index 0126561da01..0126561da01 100644 --- a/sql/updates/world/2011_12_17_00_world_creature.sql +++ b/sql/old/3.3.5a/2011_12_17_00_world_creature.sql diff --git a/sql/updates/world/2011_12_17_00_world_gameobject.sql b/sql/old/3.3.5a/2011_12_17_00_world_gameobject.sql index 98752a1b7ec..98752a1b7ec 100644 --- a/sql/updates/world/2011_12_17_00_world_gameobject.sql +++ b/sql/old/3.3.5a/2011_12_17_00_world_gameobject.sql diff --git a/sql/updates/world/2011_12_18_00_world_creature_addon.sql b/sql/old/3.3.5a/2011_12_18_00_world_creature_addon.sql index 5df7f000b06..5df7f000b06 100644 --- a/sql/updates/world/2011_12_18_00_world_creature_addon.sql +++ b/sql/old/3.3.5a/2011_12_18_00_world_creature_addon.sql diff --git a/sql/updates/world/2011_12_18_01_world_gossip.sql b/sql/old/3.3.5a/2011_12_18_01_world_gossip.sql index eb76ffe4009..eb76ffe4009 100644 --- a/sql/updates/world/2011_12_18_01_world_gossip.sql +++ b/sql/old/3.3.5a/2011_12_18_01_world_gossip.sql diff --git a/sql/updates/world/2011_12_18_02_world_spell_script_names.sql b/sql/old/3.3.5a/2011_12_18_02_world_spell_script_names.sql index c5f9a4376df..c5f9a4376df 100644 --- a/sql/updates/world/2011_12_18_02_world_spell_script_names.sql +++ b/sql/old/3.3.5a/2011_12_18_02_world_spell_script_names.sql diff --git a/sql/updates/world/2011_12_18_03_world_trinity_string.sql b/sql/old/3.3.5a/2011_12_18_03_world_trinity_string.sql index d26cc356cff..d26cc356cff 100644 --- a/sql/updates/world/2011_12_18_03_world_trinity_string.sql +++ b/sql/old/3.3.5a/2011_12_18_03_world_trinity_string.sql diff --git a/sql/updates/world/2011_12_18_04_world_misc.sql b/sql/old/3.3.5a/2011_12_18_04_world_misc.sql index 3404e4f285f..3404e4f285f 100644 --- a/sql/updates/world/2011_12_18_04_world_misc.sql +++ b/sql/old/3.3.5a/2011_12_18_04_world_misc.sql diff --git a/sql/updates/world/2011_12_18_05_world_misc.sql b/sql/old/3.3.5a/2011_12_18_05_world_misc.sql index b8435c4211e..b8435c4211e 100644 --- a/sql/updates/world/2011_12_18_05_world_misc.sql +++ b/sql/old/3.3.5a/2011_12_18_05_world_misc.sql diff --git a/sql/updates/world/2011_12_18_06_world_sai.sql b/sql/old/3.3.5a/2011_12_18_06_world_sai.sql index 2fce176cd0f..2fce176cd0f 100644 --- a/sql/updates/world/2011_12_18_06_world_sai.sql +++ b/sql/old/3.3.5a/2011_12_18_06_world_sai.sql diff --git a/sql/updates/world/2011_12_18_07_world_conditions.sql b/sql/old/3.3.5a/2011_12_18_07_world_conditions.sql index ef669dd2dbb..ef669dd2dbb 100644 --- a/sql/updates/world/2011_12_18_07_world_conditions.sql +++ b/sql/old/3.3.5a/2011_12_18_07_world_conditions.sql diff --git a/sql/updates/world/2011_12_19_00_world_conditions.sql b/sql/old/3.3.5a/2011_12_19_00_world_conditions.sql index a56151a9f8f..a56151a9f8f 100644 --- a/sql/updates/world/2011_12_19_00_world_conditions.sql +++ b/sql/old/3.3.5a/2011_12_19_00_world_conditions.sql diff --git a/sql/updates/world/2011_12_19_01_world_quest_template.sql b/sql/old/3.3.5a/2011_12_19_01_world_quest_template.sql index c04fdddfe97..c04fdddfe97 100644 --- a/sql/updates/world/2011_12_19_01_world_quest_template.sql +++ b/sql/old/3.3.5a/2011_12_19_01_world_quest_template.sql diff --git a/sql/updates/world/2011_12_19_02_world_achievement_criteria_data.sql b/sql/old/3.3.5a/2011_12_19_02_world_achievement_criteria_data.sql index af7b0a9361b..af7b0a9361b 100644 --- a/sql/updates/world/2011_12_19_02_world_achievement_criteria_data.sql +++ b/sql/old/3.3.5a/2011_12_19_02_world_achievement_criteria_data.sql diff --git a/sql/updates/world/2011_12_24_00_world_misc.sql b/sql/old/3.3.5a/2011_12_24_00_world_misc.sql index 5e070d0771e..5e070d0771e 100644 --- a/sql/updates/world/2011_12_24_00_world_misc.sql +++ b/sql/old/3.3.5a/2011_12_24_00_world_misc.sql diff --git a/sql/updates/world/2011_12_24_00_world_spell_proc_event.sql b/sql/old/3.3.5a/2011_12_24_00_world_spell_proc_event.sql index f25fa4c4856..f25fa4c4856 100644 --- a/sql/updates/world/2011_12_24_00_world_spell_proc_event.sql +++ b/sql/old/3.3.5a/2011_12_24_00_world_spell_proc_event.sql diff --git a/sql/updates/world/2011_12_24_01_world_mail_loot_template.sql b/sql/old/3.3.5a/2011_12_24_01_world_mail_loot_template.sql index 2fc05e9cf17..2fc05e9cf17 100644 --- a/sql/updates/world/2011_12_24_01_world_mail_loot_template.sql +++ b/sql/old/3.3.5a/2011_12_24_01_world_mail_loot_template.sql diff --git a/sql/updates/world/2011_12_25_00_world_areatrigger_scriptnames.sql b/sql/old/3.3.5a/2011_12_25_00_world_areatrigger_scriptnames.sql index 2a16394c7fe..2a16394c7fe 100644 --- a/sql/updates/world/2011_12_25_00_world_areatrigger_scriptnames.sql +++ b/sql/old/3.3.5a/2011_12_25_00_world_areatrigger_scriptnames.sql diff --git a/sql/updates/world/2011_12_25_00_world_gameobject_scriptnames.sql b/sql/old/3.3.5a/2011_12_25_00_world_gameobject_scriptnames.sql index c545550e129..c545550e129 100644 --- a/sql/updates/world/2011_12_25_00_world_gameobject_scriptnames.sql +++ b/sql/old/3.3.5a/2011_12_25_00_world_gameobject_scriptnames.sql diff --git a/sql/updates/world/2011_12_25_00_world_misc.sql b/sql/old/3.3.5a/2011_12_25_00_world_misc.sql index 8f1d3c44ceb..8f1d3c44ceb 100644 --- a/sql/updates/world/2011_12_25_00_world_misc.sql +++ b/sql/old/3.3.5a/2011_12_25_00_world_misc.sql diff --git a/sql/updates/world/2011_12_25_00_world_sai.sql b/sql/old/3.3.5a/2011_12_25_00_world_sai.sql index d0f1572d708..d0f1572d708 100644 --- a/sql/updates/world/2011_12_25_00_world_sai.sql +++ b/sql/old/3.3.5a/2011_12_25_00_world_sai.sql diff --git a/sql/updates/world/2011_12_25_00_world_spell_script_names.sql b/sql/old/3.3.5a/2011_12_25_00_world_spell_script_names.sql index dc42056f84c..dc42056f84c 100644 --- a/sql/updates/world/2011_12_25_00_world_spell_script_names.sql +++ b/sql/old/3.3.5a/2011_12_25_00_world_spell_script_names.sql diff --git a/sql/updates/world/2011_12_25_01_world_areatrigger_scriptnames.sql b/sql/old/3.3.5a/2011_12_25_01_world_areatrigger_scriptnames.sql index ebed9976f44..ebed9976f44 100644 --- a/sql/updates/world/2011_12_25_01_world_areatrigger_scriptnames.sql +++ b/sql/old/3.3.5a/2011_12_25_01_world_areatrigger_scriptnames.sql diff --git a/sql/updates/world/2011_12_25_01_world_misc.sql b/sql/old/3.3.5a/2011_12_25_01_world_misc.sql index 9e4d7e6c058..9e4d7e6c058 100644 --- a/sql/updates/world/2011_12_25_01_world_misc.sql +++ b/sql/old/3.3.5a/2011_12_25_01_world_misc.sql diff --git a/sql/updates/world/2011_12_25_01_world_sai.sql b/sql/old/3.3.5a/2011_12_25_01_world_sai.sql index 8ae439ffe67..8ae439ffe67 100644 --- a/sql/updates/world/2011_12_25_01_world_sai.sql +++ b/sql/old/3.3.5a/2011_12_25_01_world_sai.sql diff --git a/sql/updates/world/2011_12_25_02_world_areatrigger_scriptnames.sql b/sql/old/3.3.5a/2011_12_25_02_world_areatrigger_scriptnames.sql index 78a1fbc98c9..78a1fbc98c9 100644 --- a/sql/updates/world/2011_12_25_02_world_areatrigger_scriptnames.sql +++ b/sql/old/3.3.5a/2011_12_25_02_world_areatrigger_scriptnames.sql diff --git a/sql/updates/world/2011_12_25_02_world_misc.sql b/sql/old/3.3.5a/2011_12_25_02_world_misc.sql index ee2fd9c1964..ee2fd9c1964 100644 --- a/sql/updates/world/2011_12_25_02_world_misc.sql +++ b/sql/old/3.3.5a/2011_12_25_02_world_misc.sql diff --git a/sql/updates/world/2011_12_25_02_world_sai.sql b/sql/old/3.3.5a/2011_12_25_02_world_sai.sql index f0d69b04964..f0d69b04964 100644 --- a/sql/updates/world/2011_12_25_02_world_sai.sql +++ b/sql/old/3.3.5a/2011_12_25_02_world_sai.sql diff --git a/sql/updates/world/2011_12_25_03_world_misc.sql b/sql/old/3.3.5a/2011_12_25_03_world_misc.sql index a8967354a3d..a8967354a3d 100644 --- a/sql/updates/world/2011_12_25_03_world_misc.sql +++ b/sql/old/3.3.5a/2011_12_25_03_world_misc.sql diff --git a/sql/updates/world/2011_12_25_03_world_sai.sql b/sql/old/3.3.5a/2011_12_25_03_world_sai.sql index e53c9f72e38..e53c9f72e38 100644 --- a/sql/updates/world/2011_12_25_03_world_sai.sql +++ b/sql/old/3.3.5a/2011_12_25_03_world_sai.sql diff --git a/sql/updates/world/2011_12_26_00_world_sai.sql b/sql/old/3.3.5a/2011_12_26_00_world_sai.sql index 616ced60147..616ced60147 100644 --- a/sql/updates/world/2011_12_26_00_world_sai.sql +++ b/sql/old/3.3.5a/2011_12_26_00_world_sai.sql diff --git a/sql/updates/world/2011_12_26_01_world_sai.sql b/sql/old/3.3.5a/2011_12_26_01_world_sai.sql index 50283820dc8..50283820dc8 100644 --- a/sql/updates/world/2011_12_26_01_world_sai.sql +++ b/sql/old/3.3.5a/2011_12_26_01_world_sai.sql diff --git a/sql/updates/world/2011_12_26_02_world_sai.sql b/sql/old/3.3.5a/2011_12_26_02_world_sai.sql index 6da23e21875..6da23e21875 100644 --- a/sql/updates/world/2011_12_26_02_world_sai.sql +++ b/sql/old/3.3.5a/2011_12_26_02_world_sai.sql diff --git a/sql/updates/world/2011_12_26_03_world_sai.sql b/sql/old/3.3.5a/2011_12_26_03_world_sai.sql index 07333e50a91..07333e50a91 100644 --- a/sql/updates/world/2011_12_26_03_world_sai.sql +++ b/sql/old/3.3.5a/2011_12_26_03_world_sai.sql diff --git a/sql/updates/world/2011_12_26_04_world_sai.sql b/sql/old/3.3.5a/2011_12_26_04_world_sai.sql index c508773c51a..c508773c51a 100644 --- a/sql/updates/world/2011_12_26_04_world_sai.sql +++ b/sql/old/3.3.5a/2011_12_26_04_world_sai.sql diff --git a/sql/updates/world/2011_12_26_05_world_sai.sql b/sql/old/3.3.5a/2011_12_26_05_world_sai.sql index 0155c3ad39b..0155c3ad39b 100644 --- a/sql/updates/world/2011_12_26_05_world_sai.sql +++ b/sql/old/3.3.5a/2011_12_26_05_world_sai.sql diff --git a/sql/updates/world/2011_12_26_06_world_sai.sql b/sql/old/3.3.5a/2011_12_26_06_world_sai.sql index 6335bd9f475..6335bd9f475 100644 --- a/sql/updates/world/2011_12_26_06_world_sai.sql +++ b/sql/old/3.3.5a/2011_12_26_06_world_sai.sql diff --git a/sql/updates/world/2011_12_26_07_world_sai.sql b/sql/old/3.3.5a/2011_12_26_07_world_sai.sql index ffe55b0e5f9..ffe55b0e5f9 100644 --- a/sql/updates/world/2011_12_26_07_world_sai.sql +++ b/sql/old/3.3.5a/2011_12_26_07_world_sai.sql diff --git a/sql/updates/world/2011_12_26_08_world_sai.sql b/sql/old/3.3.5a/2011_12_26_08_world_sai.sql index 6633e97f2b4..6633e97f2b4 100644 --- a/sql/updates/world/2011_12_26_08_world_sai.sql +++ b/sql/old/3.3.5a/2011_12_26_08_world_sai.sql diff --git a/sql/updates/world/2012_01_02_00_world_sai.sql b/sql/old/3.3.5a/2012_01_02_00_world_sai.sql index 3b9abd4c746..3b9abd4c746 100644 --- a/sql/updates/world/2012_01_02_00_world_sai.sql +++ b/sql/old/3.3.5a/2012_01_02_00_world_sai.sql diff --git a/sql/updates/world/2012_01_02_01_world_game_event.sql b/sql/old/3.3.5a/2012_01_02_01_world_game_event.sql index 11267a6b296..11267a6b296 100644 --- a/sql/updates/world/2012_01_02_01_world_game_event.sql +++ b/sql/old/3.3.5a/2012_01_02_01_world_game_event.sql diff --git a/sql/updates/world/2012_01_02_02_world_creature_template.sql b/sql/old/3.3.5a/2012_01_02_02_world_creature_template.sql index ed95c4450fd..ed95c4450fd 100644 --- a/sql/updates/world/2012_01_02_02_world_creature_template.sql +++ b/sql/old/3.3.5a/2012_01_02_02_world_creature_template.sql diff --git a/sql/updates/world/2012_01_02_03_world_creature_onkill_reputation.sql b/sql/old/3.3.5a/2012_01_02_03_world_creature_onkill_reputation.sql index 282fc58dd3b..282fc58dd3b 100644 --- a/sql/updates/world/2012_01_02_03_world_creature_onkill_reputation.sql +++ b/sql/old/3.3.5a/2012_01_02_03_world_creature_onkill_reputation.sql diff --git a/sql/updates/world/2012_01_03_00_world_gossip_menu.sql b/sql/old/3.3.5a/2012_01_03_00_world_gossip_menu.sql index 9e9bba43b1a..9e9bba43b1a 100644 --- a/sql/updates/world/2012_01_03_00_world_gossip_menu.sql +++ b/sql/old/3.3.5a/2012_01_03_00_world_gossip_menu.sql diff --git a/sql/updates/world/2012_01_03_01_world_quest_template.sql b/sql/old/3.3.5a/2012_01_03_01_world_quest_template.sql index f35ea3be65b..f35ea3be65b 100644 --- a/sql/updates/world/2012_01_03_01_world_quest_template.sql +++ b/sql/old/3.3.5a/2012_01_03_01_world_quest_template.sql diff --git a/sql/updates/world/2012_01_03_02_world_sai.sql b/sql/old/3.3.5a/2012_01_03_02_world_sai.sql index 61ae8aab575..61ae8aab575 100644 --- a/sql/updates/world/2012_01_03_02_world_sai.sql +++ b/sql/old/3.3.5a/2012_01_03_02_world_sai.sql diff --git a/sql/updates/world/2012_01_03_03_world_creature_template.sql b/sql/old/3.3.5a/2012_01_03_03_world_creature_template.sql index 29d0e802abe..29d0e802abe 100644 --- a/sql/updates/world/2012_01_03_03_world_creature_template.sql +++ b/sql/old/3.3.5a/2012_01_03_03_world_creature_template.sql diff --git a/sql/updates/world/2012_01_03_04_world_gameobject_questrelation.sql b/sql/old/3.3.5a/2012_01_03_04_world_gameobject_questrelation.sql index 519fa99e2d5..519fa99e2d5 100644 --- a/sql/updates/world/2012_01_03_04_world_gameobject_questrelation.sql +++ b/sql/old/3.3.5a/2012_01_03_04_world_gameobject_questrelation.sql diff --git a/sql/updates/world/2012_01_03_05_world_creature.sql b/sql/old/3.3.5a/2012_01_03_05_world_creature.sql index b30ca2d5ef4..b30ca2d5ef4 100644 --- a/sql/updates/world/2012_01_03_05_world_creature.sql +++ b/sql/old/3.3.5a/2012_01_03_05_world_creature.sql diff --git a/sql/updates/world/2012_01_03_06_world_sai.sql b/sql/old/3.3.5a/2012_01_03_06_world_sai.sql index 858dc3f498d..858dc3f498d 100644 --- a/sql/updates/world/2012_01_03_06_world_sai.sql +++ b/sql/old/3.3.5a/2012_01_03_06_world_sai.sql diff --git a/sql/updates/world/2012_01_03_07_world_creature.sql b/sql/old/3.3.5a/2012_01_03_07_world_creature.sql index 5098901b564..5098901b564 100644 --- a/sql/updates/world/2012_01_03_07_world_creature.sql +++ b/sql/old/3.3.5a/2012_01_03_07_world_creature.sql diff --git a/sql/updates/characters/2012_01_04_00_characters_character_queststatus_seasonal.sql b/sql/old/3.3.5a/2012_01_04_00_characters_character_queststatus_seasonal.sql index f9ae71b65a7..f9ae71b65a7 100644 --- a/sql/updates/characters/2012_01_04_00_characters_character_queststatus_seasonal.sql +++ b/sql/old/3.3.5a/2012_01_04_00_characters_character_queststatus_seasonal.sql diff --git a/sql/updates/world/2012_01_04_00_world_gossip_menu.sql b/sql/old/3.3.5a/2012_01_04_00_world_gossip_menu.sql index cf11ba74eb2..cf11ba74eb2 100644 --- a/sql/updates/world/2012_01_04_00_world_gossip_menu.sql +++ b/sql/old/3.3.5a/2012_01_04_00_world_gossip_menu.sql diff --git a/sql/updates/world/2012_01_04_01_world_game_event_seasonal_questrelation.sql b/sql/old/3.3.5a/2012_01_04_01_world_game_event_seasonal_questrelation.sql index 9746a358e8a..9746a358e8a 100644 --- a/sql/updates/world/2012_01_04_01_world_game_event_seasonal_questrelation.sql +++ b/sql/old/3.3.5a/2012_01_04_01_world_game_event_seasonal_questrelation.sql diff --git a/sql/updates/world/2012_01_04_02_world_achievements.sql b/sql/old/3.3.5a/2012_01_04_02_world_achievements.sql index cbd5efa3cd6..cbd5efa3cd6 100644 --- a/sql/updates/world/2012_01_04_02_world_achievements.sql +++ b/sql/old/3.3.5a/2012_01_04_02_world_achievements.sql diff --git a/sql/updates/world/2012_01_04_02_world_sai.sql b/sql/old/3.3.5a/2012_01_04_02_world_sai.sql index fb59ba8b4e8..70cb3fc9a04 100644 --- a/sql/updates/world/2012_01_04_02_world_sai.sql +++ b/sql/old/3.3.5a/2012_01_04_02_world_sai.sql @@ -141,8 +141,8 @@ INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type SET @ENTRY := @NPC_WILDSPAWN_HELLCALLER; DELETE FROM `creature_ai_scripts` WHERE `creature_id`=@ENTRY; UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY; -UPDATE creature SET `MovementType`=1,`spawndist`=3 WHERE `id`=@ENTRY -;DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +UPDATE creature SET `MovementType`=1,`spawndist`=3 WHERE `id`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; 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,4,0,100,0,0,0,0,0,21,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Wildspawn Hellcaller - On Aggro - Prevent Combat Movement'), (@ENTRY,0,1,2,4,0,100,0,0,0,0,0,11,15228,0,0,0,0,0,2,0,0,0,0,0,0,0,'Wildspawn Hellcaller - On Aggro - Cast Fireball '),(@ENTRY,0,2,0,61,0,100,0,0,0,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Wildspawn Hellcaller - On Aggro - Set Phase 1'),(@ENTRY,0,3,0,9,1,100,0,0,40,2400,3800,11,15228,0,0,0,0,0,2,0,0,0,0,0,0,0,'Wildspawn Hellcaller - Phase 1 - Cast Fireball'), (@ENTRY,0,4,5,3,1,100,0,0,15,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Wildspawn Hellcaller -In Phase 1 - Start Combat Movement'), @@ -174,4 +174,4 @@ INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type (@ENTRY,0,10,0,3,2,100,0,0,30,100,100,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Wildspawn Felsworn - Mana is above 30% (Phase 2) - Set Phase 1'), (@ENTRY,0,11,0,0,0,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'Wildspawn Felsworn - Set Phase 1 when Mana is above 30% (Phase 2)'), (@ENTRY,0,12,0,0,0,100,0,7000,12000,38000,45000,11,22417,1,0,0,0,0,1,0,0,0,0,0,0,0,'Wildspawn Felsworn - In Phase 1 - Cast Shadow Shield'),(@ENTRY,0,13,0,0,1,100,0,11000,17000,23000,30000,11,15654,0,0,0,0,0,2,0,0,0,0,0,0,0,'Wildspawn Felsworn - In Phase 1 - Cast Shadow Word: Pain'),(@ENTRY,0,14,0,0,0,100,0,6000,10000,10000,15000,11,12542,1,0,0,0,0,5,0,0,0,0,0,0,0,'Wildspawn Felsworn - In Combat - Cast Fear (on random target)'), -(@ENTRY,0,15,0,7,0,100,0,0,0,0,0,22,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Wildspawn Felsworn - On Evade - Set Phase to 0');
\ No newline at end of file +(@ENTRY,0,15,0,7,0,100,0,0,0,0,0,22,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Wildspawn Felsworn - On Evade - Set Phase to 0'); diff --git a/sql/updates/world/2012_01_04_03_world_spell_script_names.sql b/sql/old/3.3.5a/2012_01_04_03_world_spell_script_names.sql index f8ae3db6ad3..f8ae3db6ad3 100644 --- a/sql/updates/world/2012_01_04_03_world_spell_script_names.sql +++ b/sql/old/3.3.5a/2012_01_04_03_world_spell_script_names.sql diff --git a/sql/updates/world/2012_01_04_04_world_creature.sql b/sql/old/3.3.5a/2012_01_04_04_world_creature.sql index 58970cd03c7..58970cd03c7 100644 --- a/sql/updates/world/2012_01_04_04_world_creature.sql +++ b/sql/old/3.3.5a/2012_01_04_04_world_creature.sql diff --git a/sql/updates/world/2012_01_04_04_world_creature_template.sql b/sql/old/3.3.5a/2012_01_04_04_world_creature_template.sql index 6131c439fdb..6131c439fdb 100644 --- a/sql/updates/world/2012_01_04_04_world_creature_template.sql +++ b/sql/old/3.3.5a/2012_01_04_04_world_creature_template.sql diff --git a/sql/updates/world/2012_01_04_05_world_waypoint_data.sql b/sql/old/3.3.5a/2012_01_04_05_world_waypoint_data.sql index 2ad787b36ca..2ad787b36ca 100644 --- a/sql/updates/world/2012_01_04_05_world_waypoint_data.sql +++ b/sql/old/3.3.5a/2012_01_04_05_world_waypoint_data.sql diff --git a/sql/updates/world/2012_01_04_06_world_waypoint_data.sql b/sql/old/3.3.5a/2012_01_04_06_world_waypoint_data.sql index c4cefc87c63..c4cefc87c63 100644 --- a/sql/updates/world/2012_01_04_06_world_waypoint_data.sql +++ b/sql/old/3.3.5a/2012_01_04_06_world_waypoint_data.sql diff --git a/sql/updates/world/2012_01_04_07_world_gossip_menu.sql b/sql/old/3.3.5a/2012_01_04_07_world_gossip_menu.sql index 9e9bba43b1a..9e9bba43b1a 100644 --- a/sql/updates/world/2012_01_04_07_world_gossip_menu.sql +++ b/sql/old/3.3.5a/2012_01_04_07_world_gossip_menu.sql diff --git a/sql/updates/world/2012_01_04_08_world_gossip_menu.sql b/sql/old/3.3.5a/2012_01_04_08_world_gossip_menu.sql index 826ca19e99f..826ca19e99f 100644 --- a/sql/updates/world/2012_01_04_08_world_gossip_menu.sql +++ b/sql/old/3.3.5a/2012_01_04_08_world_gossip_menu.sql diff --git a/sql/updates/world/2012_01_04_09_world_gossip_menu.sql b/sql/old/3.3.5a/2012_01_04_09_world_gossip_menu.sql index b95eb723d03..b95eb723d03 100644 --- a/sql/updates/world/2012_01_04_09_world_gossip_menu.sql +++ b/sql/old/3.3.5a/2012_01_04_09_world_gossip_menu.sql diff --git a/sql/updates/world/2012_01_04_10_world_gossip_menu.sql b/sql/old/3.3.5a/2012_01_04_10_world_gossip_menu.sql index b41f74e8050..b41f74e8050 100644 --- a/sql/updates/world/2012_01_04_10_world_gossip_menu.sql +++ b/sql/old/3.3.5a/2012_01_04_10_world_gossip_menu.sql diff --git a/sql/updates/world/2012_01_04_11_world_gossip_menu.sql b/sql/old/3.3.5a/2012_01_04_11_world_gossip_menu.sql index 4356f9c7a0a..4356f9c7a0a 100644 --- a/sql/updates/world/2012_01_04_11_world_gossip_menu.sql +++ b/sql/old/3.3.5a/2012_01_04_11_world_gossip_menu.sql diff --git a/sql/updates/world/2012_01_04_12_world_gosip_menu.sql b/sql/old/3.3.5a/2012_01_04_12_world_gosip_menu.sql index a57dc7bcdba..a57dc7bcdba 100644 --- a/sql/updates/world/2012_01_04_12_world_gosip_menu.sql +++ b/sql/old/3.3.5a/2012_01_04_12_world_gosip_menu.sql diff --git a/sql/updates/world/2012_01_04_13_world_gossip_menu.sql b/sql/old/3.3.5a/2012_01_04_13_world_gossip_menu.sql index 5a102db3f08..5a102db3f08 100644 --- a/sql/updates/world/2012_01_04_13_world_gossip_menu.sql +++ b/sql/old/3.3.5a/2012_01_04_13_world_gossip_menu.sql diff --git a/sql/updates/world/2012_01_04_14_world_gossip_menu.sql b/sql/old/3.3.5a/2012_01_04_14_world_gossip_menu.sql index be28d634899..be28d634899 100644 --- a/sql/updates/world/2012_01_04_14_world_gossip_menu.sql +++ b/sql/old/3.3.5a/2012_01_04_14_world_gossip_menu.sql diff --git a/sql/updates/world/2012_01_04_15_world_gossip_menu.sql b/sql/old/3.3.5a/2012_01_04_15_world_gossip_menu.sql index 38d449640f2..38d449640f2 100644 --- a/sql/updates/world/2012_01_04_15_world_gossip_menu.sql +++ b/sql/old/3.3.5a/2012_01_04_15_world_gossip_menu.sql diff --git a/sql/updates/world/2012_01_05_00_world_script_texts.sql b/sql/old/3.3.5a/2012_01_05_00_world_script_texts.sql index 2fcaaf83e49..2fcaaf83e49 100644 --- a/sql/updates/world/2012_01_05_00_world_script_texts.sql +++ b/sql/old/3.3.5a/2012_01_05_00_world_script_texts.sql diff --git a/sql/updates/world/2012_01_05_01_world_gameobject.sql b/sql/old/3.3.5a/2012_01_05_01_world_gameobject.sql index 15b2f5dc408..15b2f5dc408 100644 --- a/sql/updates/world/2012_01_05_01_world_gameobject.sql +++ b/sql/old/3.3.5a/2012_01_05_01_world_gameobject.sql diff --git a/sql/updates/world/2012_01_05_02_world_gameobject_template.sql b/sql/old/3.3.5a/2012_01_05_02_world_gameobject_template.sql index 022c82d539d..022c82d539d 100644 --- a/sql/updates/world/2012_01_05_02_world_gameobject_template.sql +++ b/sql/old/3.3.5a/2012_01_05_02_world_gameobject_template.sql diff --git a/sql/updates/world/2012_01_05_03_world_creature_model_info.sql b/sql/old/3.3.5a/2012_01_05_03_world_creature_model_info.sql index 8da923db96b..8da923db96b 100644 --- a/sql/updates/world/2012_01_05_03_world_creature_model_info.sql +++ b/sql/old/3.3.5a/2012_01_05_03_world_creature_model_info.sql diff --git a/sql/updates/world/2012_01_05_04_world_gameobject.sql b/sql/old/3.3.5a/2012_01_05_04_world_gameobject.sql index 4090eb0c123..4090eb0c123 100644 --- a/sql/updates/world/2012_01_05_04_world_gameobject.sql +++ b/sql/old/3.3.5a/2012_01_05_04_world_gameobject.sql diff --git a/sql/updates/world/2012_01_05_05_world_creature.sql b/sql/old/3.3.5a/2012_01_05_05_world_creature.sql index b902db64ee6..b902db64ee6 100644 --- a/sql/updates/world/2012_01_05_05_world_creature.sql +++ b/sql/old/3.3.5a/2012_01_05_05_world_creature.sql diff --git a/sql/updates/world/2012_01_05_06_world_spel_script_names.sql b/sql/old/3.3.5a/2012_01_05_06_world_spell_script_names.sql index 1a22c2916bb..1a22c2916bb 100644 --- a/sql/updates/world/2012_01_05_06_world_spel_script_names.sql +++ b/sql/old/3.3.5a/2012_01_05_06_world_spell_script_names.sql diff --git a/sql/updates/world/2012_01_05_07_world_creature_template.sql b/sql/old/3.3.5a/2012_01_05_07_world_creature_template.sql index b3f0c8aeec6..b3f0c8aeec6 100644 --- a/sql/updates/world/2012_01_05_07_world_creature_template.sql +++ b/sql/old/3.3.5a/2012_01_05_07_world_creature_template.sql diff --git a/sql/updates/world/2012_01_05_08_world_creature_template.sql b/sql/old/3.3.5a/2012_01_05_08_world_creature_template.sql index e62617c0914..e62617c0914 100644 --- a/sql/updates/world/2012_01_05_08_world_creature_template.sql +++ b/sql/old/3.3.5a/2012_01_05_08_world_creature_template.sql diff --git a/sql/updates/world/2012_01_05_09_world_waypoint_data.sql b/sql/old/3.3.5a/2012_01_05_09_world_waypoint_data.sql index 6299472a263..6299472a263 100644 --- a/sql/updates/world/2012_01_05_09_world_waypoint_data.sql +++ b/sql/old/3.3.5a/2012_01_05_09_world_waypoint_data.sql diff --git a/sql/updates/world/2012_01_05_10_world_creature_template.sql b/sql/old/3.3.5a/2012_01_05_10_world_creature_template.sql index a3d8d2432b5..a3d8d2432b5 100644 --- a/sql/updates/world/2012_01_05_10_world_creature_template.sql +++ b/sql/old/3.3.5a/2012_01_05_10_world_creature_template.sql diff --git a/sql/updates/world/2012_01_05_11_world_creature_onkill_reputation.sql b/sql/old/3.3.5a/2012_01_05_11_world_creature_onkill_reputation.sql index 047c0453608..047c0453608 100644 --- a/sql/updates/world/2012_01_05_11_world_creature_onkill_reputation.sql +++ b/sql/old/3.3.5a/2012_01_05_11_world_creature_onkill_reputation.sql diff --git a/sql/updates/world/2012_01_05_12_world_game_event_seasonal_questrelation.sql b/sql/old/3.3.5a/2012_01_05_12_world_game_event_seasonal_questrelation.sql index ad6013b0edf..ad6013b0edf 100644 --- a/sql/updates/world/2012_01_05_12_world_game_event_seasonal_questrelation.sql +++ b/sql/old/3.3.5a/2012_01_05_12_world_game_event_seasonal_questrelation.sql diff --git a/sql/updates/world/2012_01_05_13_world_creature_transport.sql b/sql/old/3.3.5a/2012_01_05_13_world_creature_transport.sql index 3acb70a4442..3acb70a4442 100644 --- a/sql/updates/world/2012_01_05_13_world_creature_transport.sql +++ b/sql/old/3.3.5a/2012_01_05_13_world_creature_transport.sql diff --git a/sql/old/3.3.5a/2012_01_05_14_world_command.sql b/sql/old/3.3.5a/2012_01_05_14_world_command.sql new file mode 100644 index 00000000000..d890ab5509c --- /dev/null +++ b/sql/old/3.3.5a/2012_01_05_14_world_command.sql @@ -0,0 +1 @@ +INSERT INTO `command` (`name`, `security`, `help`) VALUES ('reload wp_data', 3, 'Syntax: .reload wp_data will reload waypoint_data table.'); diff --git a/sql/old/3.3.5a/2012_01_05_14_world_creature_template.sql b/sql/old/3.3.5a/2012_01_05_14_world_creature_template.sql new file mode 100644 index 00000000000..331a533812d --- /dev/null +++ b/sql/old/3.3.5a/2012_01_05_14_world_creature_template.sql @@ -0,0 +1,9 @@ +-- Added equipment template, corrected unit_flags and fixed model bounding for The Etymidian +SET @EQUIP := 2477; + +UPDATE `creature_template` SET `unit_flags`=`unit_flags`|8,`equipment_id`=@EQUIP WHERE `entry`=28222; +UPDATE `creature_model_info` SET `bounding_radius`=0.42,`combat_reach`=2.4 WHERE `modelid`=25928; + +DELETE FROM `creature_equip_template` WHERE `entry`=@EQUIP; +INSERT INTO `creature_equip_template` (`entry`,`itemEntry1`,`itemEntry2`,`itemEntry3`) VALUES +(@EQUIP,25316,0,0); diff --git a/sql/old/3.3.5a/2012_01_06_00_world_creature_template_addon.sql b/sql/old/3.3.5a/2012_01_06_00_world_creature_template_addon.sql new file mode 100644 index 00000000000..0ebc498ac03 --- /dev/null +++ b/sql/old/3.3.5a/2012_01_06_00_world_creature_template_addon.sql @@ -0,0 +1,4 @@ +-- Give Sai'kkal Invisibility aura to Sai'kkal +DELETE FROM `creature_template_addon` WHERE `entry`=22932; +INSERT INTO `creature_template_addon` (`entry`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(22932,0,0,0,0,'39680'); diff --git a/sql/old/3.3.5a/2012_01_06_00_world_misc.sql b/sql/old/3.3.5a/2012_01_06_00_world_misc.sql new file mode 100644 index 00000000000..5cc96ef17a8 --- /dev/null +++ b/sql/old/3.3.5a/2012_01_06_00_world_misc.sql @@ -0,0 +1,189 @@ +SET @NPC_SIMON_BUNNY := 22923; +SET @GO_APEXIS_RELIC := 185890; +SET @GO_APEXIS_MONUMENT := 185944; + +SET @SPELL_SIMON_BLUE_VISUAL := 40244; +SET @SPELL_SIMON_GREEN_VISUAL := 40245; +SET @SPELL_SIMON_RED_VISUAL := 40246; +SET @SPELL_SIMON_YELLOW_VISUAL := 40247; + +SET @ITEM_APEXIS_SHARD := 32569; +SET @QUEST_THE_CRYSTALS := 11025; +SET @QUEST_GUARDIAN_MONUMENT := 11059; +SET @GOSSIP_MENU_ID_NORMAL := 8703; +SET @GOSSIP_MENU_ID_LARGE := 8704; + +SET @ID_SPELL_GROUP := 1115; + +UPDATE `creature_template` SET `ScriptName` = 'npc_simon_bunny',`flags_extra` = 130 WHERE `entry` = @NPC_SIMON_BUNNY; +UPDATE `gameobject_template` SET `ScriptName` = 'go_apexis_relic' WHERE `entry` IN (@GO_APEXIS_MONUMENT,@GO_APEXIS_RELIC); +-- Update is done via displayid since there are 28 entries for each color +UPDATE `gameobject_template` SET `flags` = 16,`ScriptName` = 'go_simon_cluster' WHERE `displayId` IN (7364,7365,7366,7367,7369,7371,7373,7375); + +-- Spell stacking rules for Introspection and Apexis reward spells +DELETE FROM `spell_group` WHERE `spell_id` IN (40055,40165,40166,40167,40623,40625,40626); +INSERT INTO `spell_group` (`id`,`spell_id`) VALUES +(@ID_SPELL_GROUP+0,40055), +(@ID_SPELL_GROUP+0,40165), +(@ID_SPELL_GROUP+0,40166), +(@ID_SPELL_GROUP+0,40167), +(@ID_SPELL_GROUP+1,40623), +(@ID_SPELL_GROUP+1,40625), +(@ID_SPELL_GROUP+1,40626); + +DELETE FROM `spell_group_stack_rules` WHERE `group_id` IN (@ID_SPELL_GROUP,@ID_SPELL_GROUP+1); +INSERT INTO `spell_group_stack_rules` (`group_id`,`stack_rule`) VALUES +(@ID_SPELL_GROUP+0,1), +(@ID_SPELL_GROUP+1,1); +-- + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 13 AND `SourceEntry` IN (@SPELL_SIMON_BLUE_VISUAL,@SPELL_SIMON_GREEN_VISUAL,@SPELL_SIMON_RED_VISUAL,@SPELL_SIMON_YELLOW_VISUAL); +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 15 AND `SourceGroup` IN (@GOSSIP_MENU_ID_NORMAL,@GOSSIP_MENU_ID_LARGE); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +-- Apexis Relic gossip option conditions +(15,@GOSSIP_MENU_ID_NORMAL,0,0,8,@QUEST_THE_CRYSTALS ,0,0,0,'','Apexis Relic Gossip Condition - Must have completed quest The Crystals'), +(15,@GOSSIP_MENU_ID_NORMAL,0,0,2,@ITEM_APEXIS_SHARD,1,0,0,'','Apexis Relic Gossip Condition - Must have an Apexis Shard'), +-- Apexis Monument gossip option conditions +(15,@GOSSIP_MENU_ID_LARGE,0,0,9,@QUEST_GUARDIAN_MONUMENT ,0,0,0,'','Apexis Monument Gossip Condition - Must be on quest Guardian of the Monument'), +(15,@GOSSIP_MENU_ID_LARGE,0,0,2,@ITEM_APEXIS_SHARD,35,0,0,'','Apexis Monument Gossip Condition - Must have 35 Apexis Shard'), +-- Visual color spells should target their correspondant cluster color +(13,0,@SPELL_SIMON_BLUE_VISUAL,0,18,0,185604,0,0,'','Simon Game - Blue visual target Large Blue Cluster'), +(13,0,@SPELL_SIMON_BLUE_VISUAL,0,18,0,185609,0,0,'','Simon Game - Blue visual target Blue Cluster'), +(13,0,@SPELL_SIMON_BLUE_VISUAL,0,18,0,185617,0,0,'','Simon Game - Blue visual target Blue Cluster'), +(13,0,@SPELL_SIMON_BLUE_VISUAL,0,18,0,185625,0,0,'','Simon Game - Blue visual target Blue Cluster'), +(13,0,@SPELL_SIMON_BLUE_VISUAL,0,18,0,185637,0,0,'','Simon Game - Blue visual target Blue Cluster'), +(13,0,@SPELL_SIMON_BLUE_VISUAL,0,18,0,185640,0,0,'','Simon Game - Blue visual target Large Blue Cluster'), +(13,0,@SPELL_SIMON_BLUE_VISUAL,0,18,0,185647,0,0,'','Simon Game - Blue visual target Blue Cluster'), +(13,0,@SPELL_SIMON_BLUE_VISUAL,0,18,0,185649,0,0,'','Simon Game - Blue visual target Blue Cluster'), +(13,0,@SPELL_SIMON_BLUE_VISUAL,0,18,0,185652,0,0,'','Simon Game - Blue visual target Blue Cluster'), +(13,0,@SPELL_SIMON_BLUE_VISUAL,0,18,0,185659,0,0,'','Simon Game - Blue visual target Blue Cluster'), +(13,0,@SPELL_SIMON_BLUE_VISUAL,0,18,0,185660,0,0,'','Simon Game - Blue visual target Large Blue Cluster'), +(13,0,@SPELL_SIMON_BLUE_VISUAL,0,18,0,185665,0,0,'','Simon Game - Blue visual target Blue Cluster'), +(13,0,@SPELL_SIMON_BLUE_VISUAL,0,18,0,185669,0,0,'','Simon Game - Blue visual target Blue Cluster'), +(13,0,@SPELL_SIMON_BLUE_VISUAL,0,18,0,185673,0,0,'','Simon Game - Blue visual target Blue Cluster'), +(13,0,@SPELL_SIMON_BLUE_VISUAL,0,18,0,185770,0,0,'','Simon Game - Blue visual target Blue Cluster'), +(13,0,@SPELL_SIMON_BLUE_VISUAL,0,18,0,185772,0,0,'','Simon Game - Blue visual target Blue Cluster'), +(13,0,@SPELL_SIMON_BLUE_VISUAL,0,18,0,185776,0,0,'','Simon Game - Blue visual target Large Blue Cluster'), +(13,0,@SPELL_SIMON_BLUE_VISUAL,0,18,0,185780,0,0,'','Simon Game - Blue visual target Blue Cluster'), +(13,0,@SPELL_SIMON_BLUE_VISUAL,0,18,0,185784,0,0,'','Simon Game - Blue visual target Blue Cluster'), +(13,0,@SPELL_SIMON_BLUE_VISUAL,0,18,0,185791,0,0,'','Simon Game - Blue visual target Blue Cluster'), +(13,0,@SPELL_SIMON_BLUE_VISUAL,0,18,0,185795,0,0,'','Simon Game - Blue visual target Large Blue Cluster'), +(13,0,@SPELL_SIMON_BLUE_VISUAL,0,18,0,185796,0,0,'','Simon Game - Blue visual target Blue Cluster'), +(13,0,@SPELL_SIMON_BLUE_VISUAL,0,18,0,185807,0,0,'','Simon Game - Blue visual target Blue Cluster'), +(13,0,@SPELL_SIMON_BLUE_VISUAL,0,18,0,185808,0,0,'','Simon Game - Blue visual target Blue Cluster'), +(13,0,@SPELL_SIMON_BLUE_VISUAL,0,18,0,185812,0,0,'','Simon Game - Blue visual target Blue Cluster'), +(13,0,@SPELL_SIMON_BLUE_VISUAL,0,18,0,185816,0,0,'','Simon Game - Blue visual target Large Blue Cluster'), +(13,0,@SPELL_SIMON_BLUE_VISUAL,0,18,0,185820,0,0,'','Simon Game - Blue visual target Blue Cluster'), +(13,0,@SPELL_SIMON_BLUE_VISUAL,0,18,0,185824,0,0,'','Simon Game - Blue visual target Blue Cluster'), +(13,0,@SPELL_SIMON_BLUE_VISUAL,0,18,0,185828,0,0,'','Simon Game - Blue visual target Blue Cluster'), +(13,0,@SPELL_SIMON_BLUE_VISUAL,0,18,0,185832,0,0,'','Simon Game - Blue visual target Blue Cluster'), +(13,0,@SPELL_SIMON_BLUE_VISUAL,0,18,0,185836,0,0,'','Simon Game - Blue visual target Blue Cluster'), +(13,0,@SPELL_SIMON_BLUE_VISUAL,0,18,0,185840,0,0,'','Simon Game - Blue visual target Blue Cluster'), +(13,0,@SPELL_SIMON_BLUE_VISUAL,0,18,0,185844,0,0,'','Simon Game - Blue visual target Large Blue Cluster'), +(13,0,@SPELL_SIMON_BLUE_VISUAL,0,18,0,185848,0,0,'','Simon Game - Blue visual target Blue Cluster'), +(13,0,@SPELL_SIMON_BLUE_VISUAL,0,18,0,185853,0,0,'','Simon Game - Blue visual target Blue Cluster'), +(13,0,@SPELL_SIMON_GREEN_VISUAL,0,18,0,185605,0,0,'','Simon Game - Green visual target Large Green Cluster'), +(13,0,@SPELL_SIMON_GREEN_VISUAL,0,18,0,185611,0,0,'','Simon Game - Green visual target Green Cluster'), +(13,0,@SPELL_SIMON_GREEN_VISUAL,0,18,0,185619,0,0,'','Simon Game - Green visual target Green Cluster'), +(13,0,@SPELL_SIMON_GREEN_VISUAL,0,18,0,185627,0,0,'','Simon Game - Green visual target Green Cluster'), +(13,0,@SPELL_SIMON_GREEN_VISUAL,0,18,0,185639,0,0,'','Simon Game - Green visual target Green Cluster'), +(13,0,@SPELL_SIMON_GREEN_VISUAL,0,18,0,185641,0,0,'','Simon Game - Green visual target Large Green Cluster'), +(13,0,@SPELL_SIMON_GREEN_VISUAL,0,18,0,185646,0,0,'','Simon Game - Green visual target Green Cluster'), +(13,0,@SPELL_SIMON_GREEN_VISUAL,0,18,0,185651,0,0,'','Simon Game - Green visual target Green Cluster'), +(13,0,@SPELL_SIMON_GREEN_VISUAL,0,18,0,185654,0,0,'','Simon Game - Green visual target Green Cluster'), +(13,0,@SPELL_SIMON_GREEN_VISUAL,0,18,0,185658,0,0,'','Simon Game - Green visual target Green Cluster'), +(13,0,@SPELL_SIMON_GREEN_VISUAL,0,18,0,185661,0,0,'','Simon Game - Green visual target Large Green Cluster'), +(13,0,@SPELL_SIMON_GREEN_VISUAL,0,18,0,185667,0,0,'','Simon Game - Green visual target Green Cluster'), +(13,0,@SPELL_SIMON_GREEN_VISUAL,0,18,0,185671,0,0,'','Simon Game - Green visual target Green Cluster'), +(13,0,@SPELL_SIMON_GREEN_VISUAL,0,18,0,185675,0,0,'','Simon Game - Green visual target Green Cluster'), +(13,0,@SPELL_SIMON_GREEN_VISUAL,0,18,0,185768,0,0,'','Simon Game - Green visual target Green Cluster'), +(13,0,@SPELL_SIMON_GREEN_VISUAL,0,18,0,185774,0,0,'','Simon Game - Green visual target Green Cluster'), +(13,0,@SPELL_SIMON_GREEN_VISUAL,0,18,0,185777,0,0,'','Simon Game - Green visual target Large Green Cluster'), +(13,0,@SPELL_SIMON_GREEN_VISUAL,0,18,0,185781,0,0,'','Simon Game - Green visual target Green Cluster'), +(13,0,@SPELL_SIMON_GREEN_VISUAL,0,18,0,185786,0,0,'','Simon Game - Green visual target Green Cluster'), +(13,0,@SPELL_SIMON_GREEN_VISUAL,0,18,0,185789,0,0,'','Simon Game - Green visual target Green Cluster'), +(13,0,@SPELL_SIMON_GREEN_VISUAL,0,18,0,185793,0,0,'','Simon Game - Green visual target Large Green Cluster'), +(13,0,@SPELL_SIMON_GREEN_VISUAL,0,18,0,185798,0,0,'','Simon Game - Green visual target Green Cluster'), +(13,0,@SPELL_SIMON_GREEN_VISUAL,0,18,0,185805,0,0,'','Simon Game - Green visual target Green Cluster'), +(13,0,@SPELL_SIMON_GREEN_VISUAL,0,18,0,185810,0,0,'','Simon Game - Green visual target Green Cluster'), +(13,0,@SPELL_SIMON_GREEN_VISUAL,0,18,0,185814,0,0,'','Simon Game - Green visual target Green Cluster'), +(13,0,@SPELL_SIMON_GREEN_VISUAL,0,18,0,185818,0,0,'','Simon Game - Green visual target Large Green Cluster'), +(13,0,@SPELL_SIMON_GREEN_VISUAL,0,18,0,185822,0,0,'','Simon Game - Green visual target Green Cluster'), +(13,0,@SPELL_SIMON_GREEN_VISUAL,0,18,0,185826,0,0,'','Simon Game - Green visual target Green Cluster'), +(13,0,@SPELL_SIMON_GREEN_VISUAL,0,18,0,185830,0,0,'','Simon Game - Green visual target Green Cluster'), +(13,0,@SPELL_SIMON_GREEN_VISUAL,0,18,0,185834,0,0,'','Simon Game - Green visual target Green Cluster'), +(13,0,@SPELL_SIMON_GREEN_VISUAL,0,18,0,185838,0,0,'','Simon Game - Green visual target Green Cluster'), +(13,0,@SPELL_SIMON_GREEN_VISUAL,0,18,0,185842,0,0,'','Simon Game - Green visual target Green Cluster'), +(13,0,@SPELL_SIMON_GREEN_VISUAL,0,18,0,185846,0,0,'','Simon Game - Green visual target Large Green Cluster'), +(13,0,@SPELL_SIMON_GREEN_VISUAL,0,18,0,185850,0,0,'','Simon Game - Green visual target Green Cluster'), +(13,0,@SPELL_SIMON_GREEN_VISUAL,0,18,0,185855,0,0,'','Simon Game - Green visual target Green Cluster'), +(13,0,@SPELL_SIMON_RED_VISUAL,0,18,0,185606,0,0,'','Simon Game - Red visual target Large Red Cluster'), +(13,0,@SPELL_SIMON_RED_VISUAL,0,18,0,185613,0,0,'','Simon Game - Red visual target Red Cluster'), +(13,0,@SPELL_SIMON_RED_VISUAL,0,18,0,185621,0,0,'','Simon Game - Red visual target Red Cluster'), +(13,0,@SPELL_SIMON_RED_VISUAL,0,18,0,185626,0,0,'','Simon Game - Red visual target Red Cluster'), +(13,0,@SPELL_SIMON_RED_VISUAL,0,18,0,185638,0,0,'','Simon Game - Red visual target Red Cluster'), +(13,0,@SPELL_SIMON_RED_VISUAL,0,18,0,185642,0,0,'','Simon Game - Red visual target Large Red Cluster'), +(13,0,@SPELL_SIMON_RED_VISUAL,0,18,0,185645,0,0,'','Simon Game - Red visual target Red Cluster'), +(13,0,@SPELL_SIMON_RED_VISUAL,0,18,0,185650,0,0,'','Simon Game - Red visual target Red Cluster'), +(13,0,@SPELL_SIMON_RED_VISUAL,0,18,0,185655,0,0,'','Simon Game - Red visual target Red Cluster'), +(13,0,@SPELL_SIMON_RED_VISUAL,0,18,0,185657,0,0,'','Simon Game - Red visual target Red Cluster'), +(13,0,@SPELL_SIMON_RED_VISUAL,0,18,0,185662,0,0,'','Simon Game - Red visual target Large Red Cluster'), +(13,0,@SPELL_SIMON_RED_VISUAL,0,18,0,185666,0,0,'','Simon Game - Red visual target Red Cluster'), +(13,0,@SPELL_SIMON_RED_VISUAL,0,18,0,185670,0,0,'','Simon Game - Red visual target Red Cluster'), +(13,0,@SPELL_SIMON_RED_VISUAL,0,18,0,185674,0,0,'','Simon Game - Red visual target Red Cluster'), +(13,0,@SPELL_SIMON_RED_VISUAL,0,18,0,185771,0,0,'','Simon Game - Red visual target Red Cluster'), +(13,0,@SPELL_SIMON_RED_VISUAL,0,18,0,185773,0,0,'','Simon Game - Red visual target Red Cluster'), +(13,0,@SPELL_SIMON_RED_VISUAL,0,18,0,185778,0,0,'','Simon Game - Red visual target Large Red Cluster'), +(13,0,@SPELL_SIMON_RED_VISUAL,0,18,0,185782,0,0,'','Simon Game - Red visual target Red Cluster'), +(13,0,@SPELL_SIMON_RED_VISUAL,0,18,0,185785,0,0,'','Simon Game - Red visual target Red Cluster'), +(13,0,@SPELL_SIMON_RED_VISUAL,0,18,0,185788,0,0,'','Simon Game - Red visual target Red Cluster'), +(13,0,@SPELL_SIMON_RED_VISUAL,0,18,0,185794,0,0,'','Simon Game - Red visual target Large Red Cluster'), +(13,0,@SPELL_SIMON_RED_VISUAL,0,18,0,185797,0,0,'','Simon Game - Red visual target Red Cluster'), +(13,0,@SPELL_SIMON_RED_VISUAL,0,18,0,185804,0,0,'','Simon Game - Red visual target Red Cluster'), +(13,0,@SPELL_SIMON_RED_VISUAL,0,18,0,185809,0,0,'','Simon Game - Red visual target Red Cluster'), +(13,0,@SPELL_SIMON_RED_VISUAL,0,18,0,185815,0,0,'','Simon Game - Red visual target Red Cluster'), +(13,0,@SPELL_SIMON_RED_VISUAL,0,18,0,185817,0,0,'','Simon Game - Red visual target Large Red Cluster'), +(13,0,@SPELL_SIMON_RED_VISUAL,0,18,0,185823,0,0,'','Simon Game - Red visual target Red Cluster'), +(13,0,@SPELL_SIMON_RED_VISUAL,0,18,0,185827,0,0,'','Simon Game - Red visual target Red Cluster'), +(13,0,@SPELL_SIMON_RED_VISUAL,0,18,0,185831,0,0,'','Simon Game - Red visual target Red Cluster'), +(13,0,@SPELL_SIMON_RED_VISUAL,0,18,0,185835,0,0,'','Simon Game - Red visual target Red Cluster'), +(13,0,@SPELL_SIMON_RED_VISUAL,0,18,0,185839,0,0,'','Simon Game - Red visual target Red Cluster'), +(13,0,@SPELL_SIMON_RED_VISUAL,0,18,0,185843,0,0,'','Simon Game - Red visual target Red Cluster'), +(13,0,@SPELL_SIMON_RED_VISUAL,0,18,0,185845,0,0,'','Simon Game - Red visual target Large Red Cluster'), +(13,0,@SPELL_SIMON_RED_VISUAL,0,18,0,185851,0,0,'','Simon Game - Red visual target Red Cluster'), +(13,0,@SPELL_SIMON_RED_VISUAL,0,18,0,185854,0,0,'','Simon Game - Red visual target Red Cluster'), +(13,0,@SPELL_SIMON_YELLOW_VISUAL,0,18,0,185607,0,0,'','Simon Game - Yellow visual target Large Yellow Cluster'), +(13,0,@SPELL_SIMON_YELLOW_VISUAL,0,18,0,185615,0,0,'','Simon Game - Yellow visual target Yellow Cluster'), +(13,0,@SPELL_SIMON_YELLOW_VISUAL,0,18,0,185623,0,0,'','Simon Game - Yellow visual target Yellow Cluster'), +(13,0,@SPELL_SIMON_YELLOW_VISUAL,0,18,0,185624,0,0,'','Simon Game - Yellow visual target Yellow Cluster'), +(13,0,@SPELL_SIMON_YELLOW_VISUAL,0,18,0,185636,0,0,'','Simon Game - Yellow visual target Yellow Cluster'), +(13,0,@SPELL_SIMON_YELLOW_VISUAL,0,18,0,185643,0,0,'','Simon Game - Yellow visual target Large Yellow Cluster'), +(13,0,@SPELL_SIMON_YELLOW_VISUAL,0,18,0,185644,0,0,'','Simon Game - Yellow visual target Yellow Cluster'), +(13,0,@SPELL_SIMON_YELLOW_VISUAL,0,18,0,185648,0,0,'','Simon Game - Yellow visual target Yellow Cluster'), +(13,0,@SPELL_SIMON_YELLOW_VISUAL,0,18,0,185653,0,0,'','Simon Game - Yellow visual target Yellow Cluster'), +(13,0,@SPELL_SIMON_YELLOW_VISUAL,0,18,0,185656,0,0,'','Simon Game - Yellow visual target Yellow Cluster'), +(13,0,@SPELL_SIMON_YELLOW_VISUAL,0,18,0,185663,0,0,'','Simon Game - Yellow visual target Large Yellow Cluster'), +(13,0,@SPELL_SIMON_YELLOW_VISUAL,0,18,0,185664,0,0,'','Simon Game - Yellow visual target Yellow Cluster'), +(13,0,@SPELL_SIMON_YELLOW_VISUAL,0,18,0,185668,0,0,'','Simon Game - Yellow visual target Yellow Cluster'), +(13,0,@SPELL_SIMON_YELLOW_VISUAL,0,18,0,185672,0,0,'','Simon Game - Yellow visual target Yellow Cluster'), +(13,0,@SPELL_SIMON_YELLOW_VISUAL,0,18,0,185769,0,0,'','Simon Game - Yellow visual target Yellow Cluster'), +(13,0,@SPELL_SIMON_YELLOW_VISUAL,0,18,0,185775,0,0,'','Simon Game - Yellow visual target Yellow Cluster'), +(13,0,@SPELL_SIMON_YELLOW_VISUAL,0,18,0,185779,0,0,'','Simon Game - Yellow visual target Large Yellow Cluster'), +(13,0,@SPELL_SIMON_YELLOW_VISUAL,0,18,0,185783,0,0,'','Simon Game - Yellow visual target Yellow Cluster'), +(13,0,@SPELL_SIMON_YELLOW_VISUAL,0,18,0,185787,0,0,'','Simon Game - Yellow visual target Yellow Cluster'), +(13,0,@SPELL_SIMON_YELLOW_VISUAL,0,18,0,185790,0,0,'','Simon Game - Yellow visual target Yellow Cluster'), +(13,0,@SPELL_SIMON_YELLOW_VISUAL,0,18,0,185792,0,0,'','Simon Game - Yellow visual target Large Yellow Cluster'), +(13,0,@SPELL_SIMON_YELLOW_VISUAL,0,18,0,185803,0,0,'','Simon Game - Yellow visual target Yellow Cluster'), +(13,0,@SPELL_SIMON_YELLOW_VISUAL,0,18,0,185806,0,0,'','Simon Game - Yellow visual target Yellow Cluster'), +(13,0,@SPELL_SIMON_YELLOW_VISUAL,0,18,0,185811,0,0,'','Simon Game - Yellow visual target Yellow Cluster'), +(13,0,@SPELL_SIMON_YELLOW_VISUAL,0,18,0,185813,0,0,'','Simon Game - Yellow visual target Yellow Cluster'), +(13,0,@SPELL_SIMON_YELLOW_VISUAL,0,18,0,185819,0,0,'','Simon Game - Yellow visual target Large Yellow Cluster'), +(13,0,@SPELL_SIMON_YELLOW_VISUAL,0,18,0,185821,0,0,'','Simon Game - Yellow visual target Yellow Cluster'), +(13,0,@SPELL_SIMON_YELLOW_VISUAL,0,18,0,185825,0,0,'','Simon Game - Yellow visual target Yellow Cluster'), +(13,0,@SPELL_SIMON_YELLOW_VISUAL,0,18,0,185829,0,0,'','Simon Game - Yellow visual target Yellow Cluster'), +(13,0,@SPELL_SIMON_YELLOW_VISUAL,0,18,0,185833,0,0,'','Simon Game - Yellow visual target Yellow Cluster'), +(13,0,@SPELL_SIMON_YELLOW_VISUAL,0,18,0,185837,0,0,'','Simon Game - Yellow visual target Yellow Cluster'), +(13,0,@SPELL_SIMON_YELLOW_VISUAL,0,18,0,185841,0,0,'','Simon Game - Yellow visual target Yellow Cluster'), +(13,0,@SPELL_SIMON_YELLOW_VISUAL,0,18,0,185847,0,0,'','Simon Game - Yellow visual target Large Yellow Cluster'), +(13,0,@SPELL_SIMON_YELLOW_VISUAL,0,18,0,185849,0,0,'','Simon Game - Yellow visual target Yellow Cluster'), +(13,0,@SPELL_SIMON_YELLOW_VISUAL,0,18,0,185852,0,0,'','Simon Game - Yellow visual target Yellow Cluster');
\ No newline at end of file diff --git a/sql/old/3.3.5a/2012_01_06_01_world_creature_template.sql b/sql/old/3.3.5a/2012_01_06_01_world_creature_template.sql new file mode 100644 index 00000000000..c089209c16f --- /dev/null +++ b/sql/old/3.3.5a/2012_01_06_01_world_creature_template.sql @@ -0,0 +1,2 @@ +-- spell interrupt is loaded from DBC so can be removed from mechanic_immune_mask +UPDATE `creature_template` SET `mechanic_immune_mask`=`mechanic_immune_mask` &~33554432; diff --git a/sql/old/3.3.5a/2012_01_06_02_world_achievement_criteria_data.sql b/sql/old/3.3.5a/2012_01_06_02_world_achievement_criteria_data.sql new file mode 100644 index 00000000000..9e6dddfb949 --- /dev/null +++ b/sql/old/3.3.5a/2012_01_06_02_world_achievement_criteria_data.sql @@ -0,0 +1,24 @@ +DELETE FROM `achievement_criteria_data` WHERE criteria_id IN (5220, 5215, 5218, 5221, 5216, 5219, 5213, 5018, 5217, 5214, 5233, 5235, 5232, 5234, 5238, 5236, 5229, 5237, 5230, 5231); +INSERT INTO `achievement_criteria_data` VALUES +-- Classes +(5220,21, 1,0,''), -- Realm First! Level 80 Warrior +(5215,21, 2,0,''), -- Realm First! Level 80 Paladin +(5218,21, 3,0,''), -- Realm First! Level 80 Hunter +(5221,21, 4,0,''), -- Realm First! Level 80 Rogue +(5216,21, 5,0,''), -- Realm First! Level 80 Priest +(5219,21, 6,0,''), -- Realm First! Level 80 Death Knight +(5213,21, 7,0,''), -- Realm First! Level 80 Shaman +(5018,21, 8,0,''), -- Realm First! Level 80 Mage +(5217,21, 9,0,''), -- Realm First! Level 80 Warlock +(5214,21,11,0,''), -- Realm First! Level 80 Druid +-- Races +(5233,21,0,1,''), -- Realm First! Level 80 Human +(5235,21,0,2,''), -- Realm First! Level 80 Orc +(5232,21,0,3,''), -- Realm First! Level 80 Dwarf +(5234,21,0,4,''), -- Realm First! Level 80 Night Elf +(5238,21,0,5,''), -- Realm First! Level 80 Undead +(5236,21,0,6,''), -- Realm First! Level 80 Tauren +(5229,21,0,7,''), -- Realm First! Level 80 Gnome +(5237,21,0,8,''), -- Realm First! Level 80 Troll +(5230,21,0,10,''), -- Realm First! Level 80 Blood Elf +(5231,21,0,11,''); -- Realm First! Level 80 Draenei diff --git a/sql/old/3.3.5a/2012_01_06_03_world_item_loot_template.sql b/sql/old/3.3.5a/2012_01_06_03_world_item_loot_template.sql new file mode 100644 index 00000000000..e1d6cd94525 --- /dev/null +++ b/sql/old/3.3.5a/2012_01_06_03_world_item_loot_template.sql @@ -0,0 +1,8 @@ +-- Fix Decoy! (8606) quest items drop chance from Narain's Special Kit (21042) +SET @Kit := 21042; +DELETE FROM `item_loot_template` WHERE `entry`= @Kit; +INSERT INTO `item_loot_template` VALUES +(@Kit, 21037, 100, 1, 0, 1, 1), -- Crude Map +(@Kit, 21039, 100, 1, 0, 1, 1), -- Narain's Turban +(@Kit, 21040, 100, 1, 0, 1, 1), -- Narain's Robe +(@Kit, 21041, 100, 1, 0, 1, 1); -- Bag of Gold diff --git a/sql/old/3.3.5a/2012_01_06_04_world_creature_questrelation.sql b/sql/old/3.3.5a/2012_01_06_04_world_creature_questrelation.sql new file mode 100644 index 00000000000..e1dce65f3bc --- /dev/null +++ b/sql/old/3.3.5a/2012_01_06_04_world_creature_questrelation.sql @@ -0,0 +1,5 @@ +-- Fix Captain Vimes questrelation +DELETE FROM `creature_questrelation` WHERE `quest`=1220; +INSERT INTO `creature_questrelation` (`id`,`quest`) VALUES +(4947,1220), +(23951,1220); diff --git a/sql/old/3.3.5a/2012_01_06_05_world_creature_template.sql b/sql/old/3.3.5a/2012_01_06_05_world_creature_template.sql new file mode 100644 index 00000000000..412fab4dab2 --- /dev/null +++ b/sql/old/3.3.5a/2012_01_06_05_world_creature_template.sql @@ -0,0 +1,2 @@ +-- Creatures with EAI flag set but no EAI script +UPDATE `creature_template` SET `AIName` = '' WHERE `entry` IN (29329,29330,29333,29338); diff --git a/sql/old/3.3.5a/2012_01_06_06_world_quest_template.sql b/sql/old/3.3.5a/2012_01_06_06_world_quest_template.sql new file mode 100644 index 00000000000..4f58452d980 --- /dev/null +++ b/sql/old/3.3.5a/2012_01_06_06_world_quest_template.sql @@ -0,0 +1,2 @@ +-- Ogre Heaven fix PrevQuestID +UPDATE `quest_template` SET `PrevQuestID`=11000 WHERE `ID`=11009; diff --git a/sql/old/3.3.5a/2012_01_06_07_world_sai.sql b/sql/old/3.3.5a/2012_01_06_07_world_sai.sql new file mode 100644 index 00000000000..5d322367250 --- /dev/null +++ b/sql/old/3.3.5a/2012_01_06_07_world_sai.sql @@ -0,0 +1,23 @@ +-- Fix Quest 11795, 11887 'Emergency Protocol: Section 8.2, Paragraph C', 'Emergency Supplies' +SET @NPC :=25841; -- Fizzcrank Recon Pilot +SET @Gossip :=21248; + +DELETE FROM `gossip_menu_option` WHERE (`menu_id`=@Gossip AND `id`=1); +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 +(@Gossip,1,0,"Search the body for the pilot's insignia.",1,1,0,0,0,0,''); + +DELETE FROM `conditions` WHERE `SourceGroup`=21248; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(15,@Gossip,0,0,9,11887,0,0,0,'',''), +(15,@Gossip,1,0,9,11795,0,0,0,'',''); + +DELETE FROM `smart_scripts` WHERE `entryorguid`=@NPC AND `source_type`=0; +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 +(@NPC,0,0,0,11,0,100,0,0,0,0,0,82,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Fizzcrank Recon Pilot - On spawn - set gossip flag'), +(@NPC,0,1,2,62,0,100,0,@Gossip,0,0,0,11,46362,2,0,0,0,0,7,0,0,0,0,0,0,0,'Fizzcrank Recon Pilot - On gossip option 0 select - cast spell'), +(@NPC,0,2,3,61,0,100,0,0,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,'Fizzcrank Recon Pilot - close gossip'), +(@NPC,0,3,7,61,0,100,0,0,0,0,0,83,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Fizzcrank Recon Pilot - remove gossip flag'), +(@NPC,0,4,5,62,0,100,0,@Gossip,1,0,0,11,46166,2,0,0,0,0,7,0,0,0,0,0,0,0,'Fizzcrank Recon Pilot - On gossip option 1 select - cast spell'), +(@NPC,0,5,6,61,0,100,0,0,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,'Fizzcrank Recon Pilot - close gossip'), +(@NPC,0,6,7,61,0,100,0,0,0,0,0,83,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Fizzcrank Recon Pilot - remove gossip flag'), +(@NPC,0,7,0,61,0,100,0,0,0,0,0,41,3000,0,0,0,0,0,1,0,0,0,0,0,0,0,'Fizzcrank Recon Pilot - Despawn'); diff --git a/sql/old/3.3.5a/2012_01_06_08_world_creature_template.sql b/sql/old/3.3.5a/2012_01_06_08_world_creature_template.sql new file mode 100644 index 00000000000..d59a5551f14 --- /dev/null +++ b/sql/old/3.3.5a/2012_01_06_08_world_creature_template.sql @@ -0,0 +1,2 @@ +-- Tiger Matriarch Credit have no SAI script +UPDATE `creature_template` SET `AIName`='' WHERE `entry`=40301; diff --git a/sql/old/3.3.5a/2012_01_06_09_world_creature_questrelation.sql b/sql/old/3.3.5a/2012_01_06_09_world_creature_questrelation.sql new file mode 100644 index 00000000000..c2af677f047 --- /dev/null +++ b/sql/old/3.3.5a/2012_01_06_09_world_creature_questrelation.sql @@ -0,0 +1,9 @@ +-- Fix Report to Gryan Stoutmantle creature_questrelation values +DELETE FROM `creature_questrelation` WHERE `quest` = 109; +INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES +(233,109), -- Farmer Saldean +(237,109), -- Farmer Furlbrow +(240,109), -- Marshal Dughan +(261,109), -- Guard Thomas +(294,109), -- Marshal Haggard +(963,109); -- Deputy Rainer diff --git a/sql/old/3.3.5a/2012_01_06_10_world_creature_template.sql b/sql/old/3.3.5a/2012_01_06_10_world_creature_template.sql new file mode 100644 index 00000000000..c121fd7424b --- /dev/null +++ b/sql/old/3.3.5a/2012_01_06_10_world_creature_template.sql @@ -0,0 +1,2 @@ +-- Drowned Guardian & Phylactery Guardian summoned NPC should not give XP +UPDATE `creature_template` SET `flags_extra`=`flags_extra`|64 WHERE `entry` IN (26225,26224); diff --git a/sql/old/3.3.5a/2012_01_06_11_world_sai.sql b/sql/old/3.3.5a/2012_01_06_11_world_sai.sql new file mode 100644 index 00000000000..c785030b93e --- /dev/null +++ b/sql/old/3.3.5a/2012_01_06_11_world_sai.sql @@ -0,0 +1,14 @@ +-- Quest "Torgos!" 10035 (A) - 10036 (H) +-- Converted to SAI +SET @TRACHELA := 21515; +SET @TORGOS := 18707; +DELETE FROM `creature` WHERE `id`=@TORGOS; -- Torgos must to appear only by quest +UPDATE `creature_template` SET `unit_flags`=`unit_flags`&~256 WHERE `entry`=@TORGOS; -- removing OOC +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` IN (@TORGOS,@TRACHELA); +DELETE FROM `creature_ai_scripts` WHERE `creature_id` IN (@TORGOS,@TRACHELA); +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (@TORGOS,@TRACHELA); +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 +(@TRACHELA,0,0,0,0,0,100,0,5000,8000,10000,14000,11,32903,1,0,0,0,0,5,0,0,0,0,0,0,0, 'Trachela - On combat - Cast Fevered Disease'), +(@TORGOS,0,0,0,0,0,100,0,2000,5000,12000,20000,11,32022,1,0,0,0,0,2,0,0,0,0,0,0,0, 'Torgos - On combat - Cast Gut Rip'), +(@TORGOS,0,1,0,0,0,100,0,8000,10000,20000,25000,11,13579,1,0,0,0,0,3,0,0,0,0,0,0,0, 'Torgos - On combat - Cast Gouge'), +(@TORGOS,0,2,0,0,0,100,0,5000,8000,10000,14000,11,32903,1,0,0,0,0,5,0,0,0,0,0,0,0, 'Torgos - On combat - Cast Fevered Disease'); diff --git a/sql/old/3.3.5a/2012_01_06_12_world_sai.sql b/sql/old/3.3.5a/2012_01_06_12_world_sai.sql new file mode 100644 index 00000000000..b9c1319347d --- /dev/null +++ b/sql/old/3.3.5a/2012_01_06_12_world_sai.sql @@ -0,0 +1,2 @@ +UPDATE smart_scripts SET action_param2 = action_param3 WHERE action_type = 80; +UPDATE smart_scripts SET action_param3 = 0 WHERE action_type = 80;
\ No newline at end of file diff --git a/sql/old/3.3.5a/2012_01_07_00_world_creature_addon.sql b/sql/old/3.3.5a/2012_01_07_00_world_creature_addon.sql new file mode 100644 index 00000000000..83e1efbac80 --- /dev/null +++ b/sql/old/3.3.5a/2012_01_07_00_world_creature_addon.sql @@ -0,0 +1,2 @@ +-- A-Me 01 and Un'Goro Thunderer (only one) were emoting to be dead +UPDATE `creature_addon` SET `bytes1`=0 WHERE `guid` IN (24268,24081); diff --git a/sql/old/3.3.5a/2012_01_07_01_world_creature_template.sql b/sql/old/3.3.5a/2012_01_07_01_world_creature_template.sql new file mode 100644 index 00000000000..deba1c596f0 --- /dev/null +++ b/sql/old/3.3.5a/2012_01_07_01_world_creature_template.sql @@ -0,0 +1,8 @@ +-- Template updates for creature 36595 (Unleashed Soul) +UPDATE `creature_template` SET `exp`=2,`minlevel`=80,`maxlevel`=80,`baseattacktime`=2000,`speed_walk`=1.111112,`speed_run`=0.71429 WHERE `entry`=36595; -- Unleashed Soul +-- Model data 14594 (creature 36595 (Unleashed Soul)) +UPDATE `creature_model_info` SET `bounding_radius`=1.1,`combat_reach`=1.65,`gender`=2 WHERE `modelid`=14594; -- Unleashed Soul +-- Addon data for creature 36595 (Unleashed Soul) +DELETE FROM `creature_template_addon` WHERE `entry`=36595; +INSERT INTO `creature_template_addon` (`entry`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(36595,0,0,1,0, NULL); -- Unleashed Soul diff --git a/sql/old/3.3.5a/2012_01_07_02_world_gameobject_template.sql b/sql/old/3.3.5a/2012_01_07_02_world_gameobject_template.sql new file mode 100644 index 00000000000..438a49d969a --- /dev/null +++ b/sql/old/3.3.5a/2012_01_07_02_world_gameobject_template.sql @@ -0,0 +1,2 @@ +-- Fix Stratholme Service Gate Entrance +UPDATE `gameobject_template` SET `data1`=879 WHERE `entry`=175368; diff --git a/sql/old/3.3.5a/2012_01_07_03_world_creature_template.sql b/sql/old/3.3.5a/2012_01_07_03_world_creature_template.sql new file mode 100644 index 00000000000..fdbdfc5a689 --- /dev/null +++ b/sql/old/3.3.5a/2012_01_07_03_world_creature_template.sql @@ -0,0 +1,8 @@ +-- Set standard immunities to The Nexus bosses. +UPDATE `creature_template` SET `mechanic_immune_mask`=`mechanic_immune_mask`|1|2|4|8|16|32|64|256|512|1024|2048|4096|8192|65536|131072|262144|524288|4194304|8388608|67108864|536870912 WHERE `entry` IN +(26731,30510, -- Grand Magus Telestra + 26763,30529, -- Anomalus + 26794,30532, -- Ormorok the Tree-Shaper + 26723,30540, -- Keristrasza + 26796,30398, -- Commander Stoutbeard + 26798,30397); -- Commander Kolurg diff --git a/sql/old/3.3.5a/2012_01_07_04_world_creature_loot_template.sql b/sql/old/3.3.5a/2012_01_07_04_world_creature_loot_template.sql new file mode 100644 index 00000000000..6855308ed82 --- /dev/null +++ b/sql/old/3.3.5a/2012_01_07_04_world_creature_loot_template.sql @@ -0,0 +1,29 @@ +-- Update Narain's Scrying Goggles +SET @Item := 20951; +DELETE FROM `creature_loot_template` WHERE `item`=@Item; +INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES +(11502,@Item,-100,1,0,1,1), -- Ragnaros +(11658,@Item,-100,1,0,1,1), -- Molten Giant +(11659,@Item,-100,1,0,1,1), -- Molten Destroyer +(11661,@Item,-100,1,0,1,1), -- Flamewaker +(11662,@Item,-100,1,0,1,1), -- Flamewaker Priest +(11663,@Item,-100,1,0,1,1), -- Flamewaker Healer +(11664,@Item,-100,1,0,1,1), -- Flamewaker Elite +(11665,@Item,-100,1,0,1,1), -- Lava Annihilator +(11666,@Item,-100,1,0,1,1), -- Firewalker +(11667,@Item,-100,1,0,1,1), -- Flameguard +(11669,@Item,-100,1,0,1,1), -- Flame Imp +(11673,@Item,-100,1,0,1,1), -- Ancient Core Hound +(11982,@Item,-100,1,0,1,1), -- Magmadar +(11988,@Item,-100,1,0,1,1), -- Golemagg the Incinerator +(12056,@Item,-100,1,0,1,1), -- Baron Geddon +(12057,@Item,-100,1,0,1,1), -- Garr +(12076,@Item,-100,1,0,1,1), -- Lava Elemental +(12098,@Item,-100,1,0,1,1), -- Sulfuron Harbinger +(12100,@Item,-100,1,0,1,1), -- Lava Reaver +(12101,@Item,-100,1,0,1,1), -- Lava Surger +(12118,@Item,-100,1,0,1,1), -- Lucifron +(12119,@Item,-100,1,0,1,1), -- Flamewaker Protector +(12231,@Item,-100,1,0,1,1), -- Firelord +(12259,@Item,-100,1,0,1,1), -- Gehennas +(12264,@Item,-100,1,0,1,1); -- Shazzrah diff --git a/sql/old/3.3.5a/2012_01_07_05_world_creature_loot_template.sql b/sql/old/3.3.5a/2012_01_07_05_world_creature_loot_template.sql new file mode 100644 index 00000000000..5ffdb8f6261 --- /dev/null +++ b/sql/old/3.3.5a/2012_01_07_05_world_creature_loot_template.sql @@ -0,0 +1,4 @@ +-- correct id for firelord +DELETE FROM `creature_loot_template` WHERE `entry` IN (12231,11668) AND `item`=20951; +INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES +(11668,20951,-100,1,0,1,1); -- Firelord diff --git a/sql/updates/world/2012_01_08_00_world_version.sql b/sql/updates/world/2012_01_08_00_world_version.sql new file mode 100644 index 00000000000..721fea914f1 --- /dev/null +++ b/sql/updates/world/2012_01_08_00_world_version.sql @@ -0,0 +1 @@ +UPDATE `version` SET `db_version`='TDB 335.11.45' LIMIT 1; |
