diff options
Diffstat (limited to 'sql')
230 files changed, 723 insertions, 3 deletions
diff --git a/sql/updates/auth/2014_07_09_00_auth_rbac_permission.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/auth/2014_07_09_00_auth_rbac_permission.sql index 068c9c0a098..068c9c0a098 100644 --- a/sql/updates/auth/2014_07_09_00_auth_rbac_permission.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/auth/2014_07_09_00_auth_rbac_permission.sql diff --git a/sql/updates/world/2014_07_06_00_world_version.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_06_00_world_version.sql index 4fdfda68ded..4fdfda68ded 100644 --- a/sql/updates/world/2014_07_06_00_world_version.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_06_00_world_version.sql diff --git a/sql/updates/world/2014_07_06_01_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_06_01_world_misc.sql index ff7e226bdd9..ff7e226bdd9 100644 --- a/sql/updates/world/2014_07_06_01_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_06_01_world_misc.sql diff --git a/sql/updates/world/2014_07_06_02_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_06_02_world_misc.sql index 7ff6e74d003..7ff6e74d003 100644 --- a/sql/updates/world/2014_07_06_02_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_06_02_world_misc.sql diff --git a/sql/updates/world/2014_07_07_00_world_creature_text.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_07_00_world_creature_text.sql index e553a6fced9..e553a6fced9 100644 --- a/sql/updates/world/2014_07_07_00_world_creature_text.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_07_00_world_creature_text.sql diff --git a/sql/updates/world/2014_07_07_01_world_spell_script_names.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_07_01_world_spell_script_names.sql index 5926d055b0d..5926d055b0d 100644 --- a/sql/updates/world/2014_07_07_01_world_spell_script_names.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_07_01_world_spell_script_names.sql diff --git a/sql/updates/world/2014_07_07_02_world_spell_game_event_creature.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_07_02_world_spell_game_event_creature.sql index c512521337d..c512521337d 100644 --- a/sql/updates/world/2014_07_07_02_world_spell_game_event_creature.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_07_02_world_spell_game_event_creature.sql diff --git a/sql/updates/world/2014_07_07_03_world_spell_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_07_03_world_spell_misc.sql index 8e200267797..8e200267797 100644 --- a/sql/updates/world/2014_07_07_03_world_spell_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_07_03_world_spell_misc.sql diff --git a/sql/updates/world/2014_07_08_00_world_creature_queststarter.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_08_00_world_creature_queststarter.sql index ee9c49139c8..ee9c49139c8 100644 --- a/sql/updates/world/2014_07_08_00_world_creature_queststarter.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_08_00_world_creature_queststarter.sql diff --git a/sql/updates/world/2014_07_08_00_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_08_00_world_misc.sql index 8e989f15b6f..8e989f15b6f 100644 --- a/sql/updates/world/2014_07_08_00_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_08_00_world_misc.sql diff --git a/sql/updates/world/2014_07_08_01_world_quest_template.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_08_01_world_quest_template.sql index f40808b428d..f40808b428d 100644 --- a/sql/updates/world/2014_07_08_01_world_quest_template.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_08_01_world_quest_template.sql diff --git a/sql/updates/world/2014_07_08_02_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_08_02_world_misc.sql index 12b39f2d975..12b39f2d975 100644 --- a/sql/updates/world/2014_07_08_02_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_08_02_world_misc.sql diff --git a/sql/updates/world/2014_07_08_03_world_creature.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_08_03_world_creature.sql index b31f8be34c0..b31f8be34c0 100644 --- a/sql/updates/world/2014_07_08_03_world_creature.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_08_03_world_creature.sql diff --git a/sql/updates/world/2014_07_08_04_world_creature.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_08_04_world_creature.sql index 0b6fa9ec8e4..0b6fa9ec8e4 100644 --- a/sql/updates/world/2014_07_08_04_world_creature.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_08_04_world_creature.sql diff --git a/sql/updates/world/2014_07_08_05_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_08_05_world_misc.sql index ad16a1efc1d..ad16a1efc1d 100644 --- a/sql/updates/world/2014_07_08_05_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_08_05_world_misc.sql diff --git a/sql/updates/world/2014_07_08_06_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_08_06_world_misc.sql index dfbf6381dee..dfbf6381dee 100644 --- a/sql/updates/world/2014_07_08_06_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_08_06_world_misc.sql diff --git a/sql/updates/world/2014_07_08_07_world_quest_template.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_08_07_world_quest_template.sql index 146d8d2d34f..146d8d2d34f 100644 --- a/sql/updates/world/2014_07_08_07_world_quest_template.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_08_07_world_quest_template.sql diff --git a/sql/updates/world/2014_07_08_08_world_quest_template.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_08_08_world_quest_template.sql index 1f40994cefd..1f40994cefd 100644 --- a/sql/updates/world/2014_07_08_08_world_quest_template.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_08_08_world_quest_template.sql diff --git a/sql/updates/world/2014_07_08_09_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_08_09_world_misc.sql index 4600cb80847..4600cb80847 100644 --- a/sql/updates/world/2014_07_08_09_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_08_09_world_misc.sql diff --git a/sql/updates/world/2014_07_08_10_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_08_10_world_misc.sql index 5e055a61b15..5e055a61b15 100644 --- a/sql/updates/world/2014_07_08_10_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_08_10_world_misc.sql diff --git a/sql/updates/world/2014_07_08_11_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_08_11_world_misc.sql index 357d1b6ac94..357d1b6ac94 100644 --- a/sql/updates/world/2014_07_08_11_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_08_11_world_misc.sql diff --git a/sql/updates/world/2014_07_09_00_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_09_00_world_misc.sql index 4fb7fa99dcc..4fb7fa99dcc 100644 --- a/sql/updates/world/2014_07_09_00_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_09_00_world_misc.sql diff --git a/sql/updates/world/2014_07_09_01_world_creature.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_09_01_world_creature.sql index a66cd896383..a66cd896383 100644 --- a/sql/updates/world/2014_07_09_01_world_creature.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_09_01_world_creature.sql diff --git a/sql/updates/world/2014_07_09_02_world_creature_template_addon.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_09_02_world_creature_template_addon.sql index 801eb08e306..801eb08e306 100644 --- a/sql/updates/world/2014_07_09_02_world_creature_template_addon.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_09_02_world_creature_template_addon.sql diff --git a/sql/updates/world/2014_07_09_03_world_command.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_09_03_world_command.sql index 6ffac8a631a..6ffac8a631a 100644 --- a/sql/updates/world/2014_07_09_03_world_command.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_09_03_world_command.sql diff --git a/sql/updates/world/2014_07_09_04_world_quest_template.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_09_04_world_quest_template.sql index d9fb0a988a6..d9fb0a988a6 100644 --- a/sql/updates/world/2014_07_09_04_world_quest_template.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_09_04_world_quest_template.sql diff --git a/sql/updates/world/2014_07_09_05_world_gameobject_template.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_09_05_world_gameobject_template.sql index 497d7a4b42b..497d7a4b42b 100644 --- a/sql/updates/world/2014_07_09_05_world_gameobject_template.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_09_05_world_gameobject_template.sql diff --git a/sql/updates/world/2014_07_09_06_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_09_06_world_misc.sql index add24e16e9b..add24e16e9b 100644 --- a/sql/updates/world/2014_07_09_06_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_09_06_world_misc.sql diff --git a/sql/updates/world/2014_07_09_07_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_09_07_world_misc.sql index b42a34a38d3..b42a34a38d3 100644 --- a/sql/updates/world/2014_07_09_07_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_09_07_world_misc.sql diff --git a/sql/updates/world/2014_07_09_08_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_09_08_world_misc.sql index d82b011bbae..d82b011bbae 100644 --- a/sql/updates/world/2014_07_09_08_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_09_08_world_misc.sql diff --git a/sql/updates/world/2014_07_10_00_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_10_00_world_misc.sql index 9422bfced0a..9422bfced0a 100644 --- a/sql/updates/world/2014_07_10_00_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_10_00_world_misc.sql diff --git a/sql/updates/world/2014_07_10_01_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_10_01_world_misc.sql index 040e3f54909..040e3f54909 100644 --- a/sql/updates/world/2014_07_10_01_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_10_01_world_misc.sql diff --git a/sql/updates/world/2014_07_12_00_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_12_00_world_misc.sql index 18de044cf2e..18de044cf2e 100644 --- a/sql/updates/world/2014_07_12_00_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_12_00_world_misc.sql diff --git a/sql/updates/world/2014_07_12_01_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_12_01_world_misc.sql index 5b641280e22..5b641280e22 100644 --- a/sql/updates/world/2014_07_12_01_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_12_01_world_misc.sql diff --git a/sql/updates/world/2014_07_13_00_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_13_00_world_misc.sql index 3529596d344..3529596d344 100644 --- a/sql/updates/world/2014_07_13_00_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_13_00_world_misc.sql diff --git a/sql/updates/world/2014_07_13_01_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_13_01_world_misc.sql index 66610aedebe..66610aedebe 100644 --- a/sql/updates/world/2014_07_13_01_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_13_01_world_misc.sql diff --git a/sql/updates/world/2014_07_13_02_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_13_02_world_misc.sql index 51dfb365d08..51dfb365d08 100644 --- a/sql/updates/world/2014_07_13_02_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_13_02_world_misc.sql diff --git a/sql/updates/world/2014_07_13_03_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_13_03_world_misc.sql index 94cd1f2bff3..94cd1f2bff3 100644 --- a/sql/updates/world/2014_07_13_03_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_13_03_world_misc.sql diff --git a/sql/updates/world/2014_07_14_00_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_14_00_world_misc.sql index 42613438cce..42613438cce 100644 --- a/sql/updates/world/2014_07_14_00_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_14_00_world_misc.sql diff --git a/sql/updates/world/2014_07_14_01_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_14_01_world_misc.sql index bd18e5d475d..bd18e5d475d 100644 --- a/sql/updates/world/2014_07_14_01_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_14_01_world_misc.sql diff --git a/sql/updates/world/2014_07_15_00_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_15_00_world_misc.sql index a2f7e0278f1..a2f7e0278f1 100644 --- a/sql/updates/world/2014_07_15_00_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_15_00_world_misc.sql diff --git a/sql/updates/world/2014_07_15_01_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_15_01_world_misc.sql index 05e546a33ab..05e546a33ab 100644 --- a/sql/updates/world/2014_07_15_01_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_15_01_world_misc.sql diff --git a/sql/updates/world/2014_07_15_02_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_15_02_world_misc.sql index d176d28e7ad..d176d28e7ad 100644 --- a/sql/updates/world/2014_07_15_02_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_15_02_world_misc.sql diff --git a/sql/updates/world/2014_07_16_00_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_16_00_world_misc.sql index 4fe76dff40b..4fe76dff40b 100644 --- a/sql/updates/world/2014_07_16_00_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_16_00_world_misc.sql diff --git a/sql/updates/world/2014_07_16_01_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_16_01_world_misc.sql index 0c082f37962..0c082f37962 100644 --- a/sql/updates/world/2014_07_16_01_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_16_01_world_misc.sql diff --git a/sql/updates/world/2014_07_16_02_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_16_02_world_misc.sql index ecef34a3964..ecef34a3964 100644 --- a/sql/updates/world/2014_07_16_02_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_16_02_world_misc.sql diff --git a/sql/updates/world/2014_07_16_03_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_16_03_world_misc.sql index 2fb53821427..2fb53821427 100644 --- a/sql/updates/world/2014_07_16_03_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_16_03_world_misc.sql diff --git a/sql/updates/world/2014_07_18_00_world_conditions.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_18_00_world_conditions.sql index 107402a631d..107402a631d 100644 --- a/sql/updates/world/2014_07_18_00_world_conditions.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_18_00_world_conditions.sql diff --git a/sql/updates/world/2014_07_18_01_world_creature.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_18_01_world_creature.sql index 702fbc1aa3a..702fbc1aa3a 100644 --- a/sql/updates/world/2014_07_18_01_world_creature.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_18_01_world_creature.sql diff --git a/sql/updates/world/2014_07_18_02_world_creature_template.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_18_02_world_creature_template.sql index 84280d9d3d5..84280d9d3d5 100644 --- a/sql/updates/world/2014_07_18_02_world_creature_template.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_18_02_world_creature_template.sql diff --git a/sql/updates/world/2014_07_18_03_world_quest_template.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_18_03_world_quest_template.sql index bd286b8430a..bd286b8430a 100644 --- a/sql/updates/world/2014_07_18_03_world_quest_template.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_18_03_world_quest_template.sql diff --git a/sql/updates/world/2014_07_18_04_world_creature_template.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_18_04_world_creature_template.sql index e7f9be10429..e7f9be10429 100644 --- a/sql/updates/world/2014_07_18_04_world_creature_template.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_18_04_world_creature_template.sql diff --git a/sql/updates/world/2014_07_18_05_world_creature_text.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_18_05_world_creature_text.sql index 5e4a59be760..5e4a59be760 100644 --- a/sql/updates/world/2014_07_18_05_world_creature_text.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_18_05_world_creature_text.sql diff --git a/sql/updates/world/2014_07_18_06_world_quest_template.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_18_06_world_quest_template.sql index 0a9231eb19c..0a9231eb19c 100644 --- a/sql/updates/world/2014_07_18_06_world_quest_template.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_18_06_world_quest_template.sql diff --git a/sql/updates/world/2014_07_18_07_world_quest_template.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_18_07_world_quest_template.sql index 7f71a21dfb1..7f71a21dfb1 100644 --- a/sql/updates/world/2014_07_18_07_world_quest_template.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_18_07_world_quest_template.sql diff --git a/sql/updates/world/2014_07_19_00_world_spell_custom_attr.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_19_00_world_spell_custom_attr.sql index fee4f9cc077..fee4f9cc077 100644 --- a/sql/updates/world/2014_07_19_00_world_spell_custom_attr.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_19_00_world_spell_custom_attr.sql diff --git a/sql/updates/world/2014_07_19_01_world_creature_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_19_01_world_creature_misc.sql index 1f8eba3d33c..1f8eba3d33c 100644 --- a/sql/updates/world/2014_07_19_01_world_creature_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_19_01_world_creature_misc.sql diff --git a/sql/updates/world/2014_07_19_02_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_19_02_world_misc.sql index 2dbe9f16bd9..2dbe9f16bd9 100644 --- a/sql/updates/world/2014_07_19_02_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_19_02_world_misc.sql diff --git a/sql/updates/world/2014_07_19_03_world_creature_addon.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_19_03_world_creature_addon.sql index 598e78ce16e..598e78ce16e 100644 --- a/sql/updates/world/2014_07_19_03_world_creature_addon.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_19_03_world_creature_addon.sql diff --git a/sql/updates/world/2014_07_19_04_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_19_04_world_misc.sql index bff4fe8b3c6..bff4fe8b3c6 100644 --- a/sql/updates/world/2014_07_19_04_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_19_04_world_misc.sql diff --git a/sql/updates/world/2014_07_19_05_world_quest_template.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_19_05_world_quest_template.sql index 26c961d5197..26c961d5197 100644 --- a/sql/updates/world/2014_07_19_05_world_quest_template.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_19_05_world_quest_template.sql diff --git a/sql/updates/world/2014_07_19_06_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_19_06_world_misc.sql index 9bffa10fcf7..9bffa10fcf7 100644 --- a/sql/updates/world/2014_07_19_06_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_19_06_world_misc.sql diff --git a/sql/updates/world/2014_07_19_07_world_quest_template.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_19_07_world_quest_template.sql index 81f6bbed322..81f6bbed322 100644 --- a/sql/updates/world/2014_07_19_07_world_quest_template.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_19_07_world_quest_template.sql diff --git a/sql/updates/world/2014_07_19_08_world_page_text.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_19_08_world_page_text.sql index 4ddc7d2be74..4ddc7d2be74 100644 --- a/sql/updates/world/2014_07_19_08_world_page_text.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_19_08_world_page_text.sql diff --git a/sql/updates/world/2014_07_19_09_world_ahn_kahet.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_19_09_world_ahn_kahet.sql index 5b64512f2e8..5b64512f2e8 100644 --- a/sql/updates/world/2014_07_19_09_world_ahn_kahet.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_19_09_world_ahn_kahet.sql diff --git a/sql/updates/world/2014_07_19_10_world_conditions.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_19_10_world_conditions.sql index aafa3edf9f7..aafa3edf9f7 100644 --- a/sql/updates/world/2014_07_19_10_world_conditions.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_19_10_world_conditions.sql diff --git a/sql/updates/world/2014_07_19_11_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_19_11_world_misc.sql index 981d388df06..981d388df06 100644 --- a/sql/updates/world/2014_07_19_11_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_19_11_world_misc.sql diff --git a/sql/updates/world/2014_07_20_00_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_20_00_world_misc.sql index 311b89ad4e3..311b89ad4e3 100644 --- a/sql/updates/world/2014_07_20_00_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_20_00_world_misc.sql diff --git a/sql/updates/world/2014_07_20_01_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_20_01_world_misc.sql index cbc3923d56b..cbc3923d56b 100644 --- a/sql/updates/world/2014_07_20_01_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_20_01_world_misc.sql diff --git a/sql/updates/world/2014_07_20_02_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_20_02_world_misc.sql index 6c201a3ad03..6c201a3ad03 100644 --- a/sql/updates/world/2014_07_20_02_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_20_02_world_misc.sql diff --git a/sql/updates/world/2014_07_20_03_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_20_03_world_misc.sql index f81666d035b..f81666d035b 100644 --- a/sql/updates/world/2014_07_20_03_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_20_03_world_misc.sql diff --git a/sql/updates/world/2014_07_20_04_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_20_04_world_misc.sql index 7c6fb4638f2..7c6fb4638f2 100644 --- a/sql/updates/world/2014_07_20_04_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_20_04_world_misc.sql diff --git a/sql/updates/world/2014_07_20_05_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_20_05_world_misc.sql index b7e95ae645d..b7e95ae645d 100644 --- a/sql/updates/world/2014_07_20_05_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_20_05_world_misc.sql diff --git a/sql/updates/world/2014_07_21_00_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_21_00_world_misc.sql index 4e649dc52d4..4e649dc52d4 100644 --- a/sql/updates/world/2014_07_21_00_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_21_00_world_misc.sql diff --git a/sql/updates/world/2014_07_21_01_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_21_01_world_misc.sql index 46d6e43ab63..46d6e43ab63 100644 --- a/sql/updates/world/2014_07_21_01_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_21_01_world_misc.sql diff --git a/sql/updates/world/2014_07_21_02_world_creature_template.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_21_02_world_creature_template.sql index cb616c84033..cb616c84033 100644 --- a/sql/updates/world/2014_07_21_02_world_creature_template.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_21_02_world_creature_template.sql diff --git a/sql/updates/world/2014_07_21_03_world_creature.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_21_03_world_creature.sql index a5604a4cb0a..a5604a4cb0a 100644 --- a/sql/updates/world/2014_07_21_03_world_creature.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_21_03_world_creature.sql diff --git a/sql/updates/world/2014_07_21_04_world_spell_script_names.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_21_04_world_spell_script_names.sql index c7080adb88e..c7080adb88e 100644 --- a/sql/updates/world/2014_07_21_04_world_spell_script_names.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_21_04_world_spell_script_names.sql diff --git a/sql/updates/world/2014_07_21_05_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_21_05_world_misc.sql index 7b6acc1e80d..7b6acc1e80d 100644 --- a/sql/updates/world/2014_07_21_05_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_21_05_world_misc.sql diff --git a/sql/updates/world/2014_07_21_06_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_21_06_world_misc.sql index 5d66620740d..5d66620740d 100644 --- a/sql/updates/world/2014_07_21_06_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_21_06_world_misc.sql diff --git a/sql/updates/world/2014_07_21_07_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_21_07_world_misc.sql index 7150a21e1ce..7150a21e1ce 100644 --- a/sql/updates/world/2014_07_21_07_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_21_07_world_misc.sql diff --git a/sql/updates/world/2014_07_21_08_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_21_08_world_misc.sql index 08665638fc9..08665638fc9 100644 --- a/sql/updates/world/2014_07_21_08_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_21_08_world_misc.sql diff --git a/sql/updates/world/2014_07_21_09_world_creature_template.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_21_09_world_creature_template.sql index 88770a3f3c4..88770a3f3c4 100644 --- a/sql/updates/world/2014_07_21_09_world_creature_template.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_21_09_world_creature_template.sql diff --git a/sql/updates/world/2014_07_22_00_world_conditions.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_22_00_world_conditions.sql index a13a495f737..a13a495f737 100644 --- a/sql/updates/world/2014_07_22_00_world_conditions.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_22_00_world_conditions.sql diff --git a/sql/updates/world/2014_07_22_01_world_playercreateinfo_skills.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_22_01_world_playercreateinfo_skills.sql index 325d326107b..325d326107b 100644 --- a/sql/updates/world/2014_07_22_01_world_playercreateinfo_skills.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_22_01_world_playercreateinfo_skills.sql diff --git a/sql/updates/world/2014_07_23_00_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_23_00_world_misc.sql index 3cd67bd0106..3cd67bd0106 100644 --- a/sql/updates/world/2014_07_23_00_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_23_00_world_misc.sql diff --git a/sql/updates/world/2014_07_23_01_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_23_01_world_misc.sql index 35d4a26d30c..35d4a26d30c 100644 --- a/sql/updates/world/2014_07_23_01_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_23_01_world_misc.sql diff --git a/sql/updates/world/2014_07_23_02_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_23_02_world_misc.sql index fbbf931bb13..fbbf931bb13 100644 --- a/sql/updates/world/2014_07_23_02_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_23_02_world_misc.sql diff --git a/sql/updates/world/2014_07_23_03_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_23_03_world_misc.sql index 186884503ef..186884503ef 100644 --- a/sql/updates/world/2014_07_23_03_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_23_03_world_misc.sql diff --git a/sql/updates/world/2014_07_23_04_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_23_04_world_misc.sql index bbac752aa31..bbac752aa31 100644 --- a/sql/updates/world/2014_07_23_04_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_23_04_world_misc.sql diff --git a/sql/updates/world/2014_07_23_05_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_23_05_world_misc.sql index a1fa4ebe3a3..a1fa4ebe3a3 100644 --- a/sql/updates/world/2014_07_23_05_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_23_05_world_misc.sql diff --git a/sql/updates/world/2014_07_23_06_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_23_06_world_misc.sql index 66ea2004342..66ea2004342 100644 --- a/sql/updates/world/2014_07_23_06_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_23_06_world_misc.sql diff --git a/sql/updates/world/2014_07_23_07_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_23_07_world_misc.sql index a8916d8d98b..a8916d8d98b 100644 --- a/sql/updates/world/2014_07_23_07_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_23_07_world_misc.sql diff --git a/sql/updates/world/2014_07_23_08_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_23_08_world_misc.sql index 0e218b1f952..0e218b1f952 100644 --- a/sql/updates/world/2014_07_23_08_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_23_08_world_misc.sql diff --git a/sql/updates/world/2014_07_24_00_world_gossip_menu.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_24_00_world_gossip_menu.sql index fee8c2340dc..fee8c2340dc 100644 --- a/sql/updates/world/2014_07_24_00_world_gossip_menu.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_24_00_world_gossip_menu.sql diff --git a/sql/updates/world/2014_07_24_00_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_24_00_world_misc.sql index be4cb4313a8..be4cb4313a8 100644 --- a/sql/updates/world/2014_07_24_00_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_24_00_world_misc.sql diff --git a/sql/updates/world/2014_07_24_00_world_sai.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_24_00_world_sai.sql index 6c34d62591d..6c34d62591d 100644 --- a/sql/updates/world/2014_07_24_00_world_sai.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_24_00_world_sai.sql diff --git a/sql/updates/world/2014_07_24_02_world_gossip.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_24_02_world_gossip.sql index 3200628fe07..3200628fe07 100644 --- a/sql/updates/world/2014_07_24_02_world_gossip.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_24_02_world_gossip.sql diff --git a/sql/updates/world/2014_07_24_03_world_gameobject.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_24_03_world_gameobject.sql index be6bced5dc3..be6bced5dc3 100644 --- a/sql/updates/world/2014_07_24_03_world_gameobject.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_24_03_world_gameobject.sql diff --git a/sql/updates/world/2014_07_24_04_world_spell_script_names.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_24_04_world_spell_script_names.sql index 4a7a1ff648c..4a7a1ff648c 100644 --- a/sql/updates/world/2014_07_24_04_world_spell_script_names.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_24_04_world_spell_script_names.sql diff --git a/sql/updates/world/2014_07_24_05_world_spell_creature.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_24_05_world_spell_creature.sql index 8f21f7f3546..8f21f7f3546 100644 --- a/sql/updates/world/2014_07_24_05_world_spell_creature.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_24_05_world_spell_creature.sql diff --git a/sql/updates/world/2014_07_24_06_world_gossip.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_24_06_world_gossip.sql index b233c3c5888..b233c3c5888 100644 --- a/sql/updates/world/2014_07_24_06_world_gossip.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_24_06_world_gossip.sql diff --git a/sql/updates/world/2014_07_24_07_world_conditions.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_24_07_world_conditions.sql index 4934c1960e6..4934c1960e6 100644 --- a/sql/updates/world/2014_07_24_07_world_conditions.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_24_07_world_conditions.sql diff --git a/sql/updates/world/2014_07_24_08_world_spell_script_names.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_24_08_world_spell_script_names.sql index 16c12b70c5a..16c12b70c5a 100644 --- a/sql/updates/world/2014_07_24_08_world_spell_script_names.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_24_08_world_spell_script_names.sql diff --git a/sql/updates/world/2014_07_24_09_world_sai.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_24_09_world_sai.sql index a34c20ce765..a34c20ce765 100644 --- a/sql/updates/world/2014_07_24_09_world_sai.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_24_09_world_sai.sql diff --git a/sql/updates/world/2014_07_24_10_world_sai.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_24_10_world_sai.sql index ba9eca7e2e8..ba9eca7e2e8 100644 --- a/sql/updates/world/2014_07_24_10_world_sai.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_24_10_world_sai.sql diff --git a/sql/updates/world/2014_07_24_12_world_conditions.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_24_12_world_conditions.sql index b755a43c601..b755a43c601 100644 --- a/sql/updates/world/2014_07_24_12_world_conditions.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_24_12_world_conditions.sql diff --git a/sql/updates/world/2014_07_24_13_world_sai.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_24_13_world_sai.sql index e63eb83831a..e63eb83831a 100644 --- a/sql/updates/world/2014_07_24_13_world_sai.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_24_13_world_sai.sql diff --git a/sql/updates/world/2014_07_24_14_world_sai.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_24_14_world_sai.sql index 3089e1d0f80..3089e1d0f80 100644 --- a/sql/updates/world/2014_07_24_14_world_sai.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_24_14_world_sai.sql diff --git a/sql/updates/world/2014_07_24_15_world_sai.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_24_15_world_sai.sql index f064476e413..f064476e413 100644 --- a/sql/updates/world/2014_07_24_15_world_sai.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_24_15_world_sai.sql diff --git a/sql/updates/world/2014_07_24_16_world_waypoints.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_24_16_world_waypoints.sql index 8aaf55b2136..8aaf55b2136 100644 --- a/sql/updates/world/2014_07_24_16_world_waypoints.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_24_16_world_waypoints.sql diff --git a/sql/updates/world/2014_07_25_00_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_25_00_world_misc.sql index ee2a4bd8fd2..ee2a4bd8fd2 100644 --- a/sql/updates/world/2014_07_25_00_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_25_00_world_misc.sql diff --git a/sql/updates/world/2014_07_25_01_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_25_01_world_misc.sql index 9288c7c9051..9288c7c9051 100644 --- a/sql/updates/world/2014_07_25_01_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_25_01_world_misc.sql diff --git a/sql/updates/world/2014_07_25_02_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_25_02_world_misc.sql index e5124e3a56f..e5124e3a56f 100644 --- a/sql/updates/world/2014_07_25_02_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_25_02_world_misc.sql diff --git a/sql/updates/world/2014_07_25_03_world_waypoint_data.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_25_03_world_waypoint_data.sql index 008248d8395..008248d8395 100644 --- a/sql/updates/world/2014_07_25_03_world_waypoint_data.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_25_03_world_waypoint_data.sql diff --git a/sql/updates/world/2014_07_26_00_world_waypoints.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_26_00_world_waypoints.sql index c012728efc0..c012728efc0 100644 --- a/sql/updates/world/2014_07_26_00_world_waypoints.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_26_00_world_waypoints.sql diff --git a/sql/updates/world/2014_07_26_01_world_creature_formations.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_26_01_world_creature_formations.sql index dc424437dfc..dc424437dfc 100644 --- a/sql/updates/world/2014_07_26_01_world_creature_formations.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_26_01_world_creature_formations.sql diff --git a/sql/updates/world/2014_07_27_00_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_27_00_world_misc.sql index 42f4a82b158..42f4a82b158 100644 --- a/sql/updates/world/2014_07_27_00_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_27_00_world_misc.sql diff --git a/sql/updates/world/2014_07_27_01_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_27_01_world_misc.sql index 359f543ce68..359f543ce68 100644 --- a/sql/updates/world/2014_07_27_01_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_27_01_world_misc.sql diff --git a/sql/updates/world/2014_07_27_02_world_waypoints.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_27_02_world_waypoints.sql index badb3af6078..badb3af6078 100644 --- a/sql/updates/world/2014_07_27_02_world_waypoints.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_27_02_world_waypoints.sql diff --git a/sql/updates/world/2014_07_27_03_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_27_03_world_misc.sql index 6acbe68e67f..6acbe68e67f 100644 --- a/sql/updates/world/2014_07_27_03_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_27_03_world_misc.sql diff --git a/sql/updates/world/2014_07_27_04_world_sai.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_27_04_world_sai.sql index 0c497a02c16..0c497a02c16 100644 --- a/sql/updates/world/2014_07_27_04_world_sai.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_27_04_world_sai.sql diff --git a/sql/updates/world/2014_07_27_05_world_sai.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_27_05_world_sai.sql index 9515e51ff95..9515e51ff95 100644 --- a/sql/updates/world/2014_07_27_05_world_sai.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_27_05_world_sai.sql diff --git a/sql/updates/world/2014_07_28_00_world_creature.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_28_00_world_creature.sql index 9d55e17de71..9d55e17de71 100644 --- a/sql/updates/world/2014_07_28_00_world_creature.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_28_00_world_creature.sql diff --git a/sql/updates/world/2014_07_28_01_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_28_01_world_misc.sql index 70d8b2d69d4..70d8b2d69d4 100644 --- a/sql/updates/world/2014_07_28_01_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_28_01_world_misc.sql diff --git a/sql/updates/world/2014_07_28_02_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_28_02_world_misc.sql index c4a6bdf03fb..c4a6bdf03fb 100644 --- a/sql/updates/world/2014_07_28_02_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_28_02_world_misc.sql diff --git a/sql/updates/world/2014_07_28_03_world_sai.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_28_03_world_sai.sql index f6222f87836..f6222f87836 100644 --- a/sql/updates/world/2014_07_28_03_world_sai.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_28_03_world_sai.sql diff --git a/sql/updates/world/2014_07_28_04_world_waypoints.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_28_04_world_waypoints.sql index a180d6ead20..a180d6ead20 100644 --- a/sql/updates/world/2014_07_28_04_world_waypoints.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_28_04_world_waypoints.sql diff --git a/sql/updates/world/2014_07_28_05_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_28_05_world_misc.sql index e81d7cc1810..e81d7cc1810 100644 --- a/sql/updates/world/2014_07_28_05_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_28_05_world_misc.sql diff --git a/sql/updates/world/2014_07_28_06_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_28_06_world_misc.sql index 2f44bc2a95d..2f44bc2a95d 100644 --- a/sql/updates/world/2014_07_28_06_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_28_06_world_misc.sql diff --git a/sql/updates/world/2014_07_28_07_world_sai.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_28_07_world_sai.sql index 3c067199d6f..3c067199d6f 100644 --- a/sql/updates/world/2014_07_28_07_world_sai.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_28_07_world_sai.sql diff --git a/sql/updates/world/2014_07_28_08_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_28_08_world_misc.sql index f1f13e76eec..f1f13e76eec 100644 --- a/sql/updates/world/2014_07_28_08_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_28_08_world_misc.sql diff --git a/sql/updates/world/2014_07_28_09_world_waypoints.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_28_09_world_waypoints.sql index 083f0d4360d..083f0d4360d 100644 --- a/sql/updates/world/2014_07_28_09_world_waypoints.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_28_09_world_waypoints.sql diff --git a/sql/updates/world/2014_07_28_10_world_waypoints.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_28_10_world_waypoints.sql index 1462e2945ee..1462e2945ee 100644 --- a/sql/updates/world/2014_07_28_10_world_waypoints.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_28_10_world_waypoints.sql diff --git a/sql/updates/world/2014_07_28_11_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_28_11_world_misc.sql index c8319ee63b7..c8319ee63b7 100644 --- a/sql/updates/world/2014_07_28_11_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_28_11_world_misc.sql diff --git a/sql/updates/world/2014_07_28_12_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_28_12_world_misc.sql index 7d391eeca79..7d391eeca79 100644 --- a/sql/updates/world/2014_07_28_12_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_28_12_world_misc.sql diff --git a/sql/updates/world/2014_07_28_13_world_sai.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_28_13_world_sai.sql index dbcc219155d..dbcc219155d 100644 --- a/sql/updates/world/2014_07_28_13_world_sai.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_28_13_world_sai.sql diff --git a/sql/updates/world/2014_07_29_00_335_world_sai.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_29_00_335_world_sai.sql index 2d431886124..2d431886124 100644 --- a/sql/updates/world/2014_07_29_00_335_world_sai.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_29_00_335_world_sai.sql diff --git a/sql/updates/world/2014_07_29_01_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_29_01_world_misc.sql index c5bfb6ba585..c5bfb6ba585 100644 --- a/sql/updates/world/2014_07_29_01_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_29_01_world_misc.sql diff --git a/sql/updates/world/2014_07_29_02_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_29_02_world_misc.sql index 178a278a5df..178a278a5df 100644 --- a/sql/updates/world/2014_07_29_02_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_29_02_world_misc.sql diff --git a/sql/updates/world/2014_07_29_03_world_waypoints.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_29_03_world_waypoints.sql index e68dc55f714..e68dc55f714 100644 --- a/sql/updates/world/2014_07_29_03_world_waypoints.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_29_03_world_waypoints.sql diff --git a/sql/updates/world/2014_07_29_04_world_sai.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_29_04_world_sai.sql index 586be996444..586be996444 100644 --- a/sql/updates/world/2014_07_29_04_world_sai.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_29_04_world_sai.sql diff --git a/sql/updates/world/2014_07_29_05_world_trinity_string.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_29_05_world_trinity_string.sql index 0a35f4ef72c..0a35f4ef72c 100644 --- a/sql/updates/world/2014_07_29_05_world_trinity_string.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_29_05_world_trinity_string.sql diff --git a/sql/updates/world/2014_07_29_06_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_29_06_world_misc.sql index 5fb99f4c57a..5fb99f4c57a 100644 --- a/sql/updates/world/2014_07_29_06_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_29_06_world_misc.sql diff --git a/sql/updates/world/2014_07_29_07_world_sai.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_29_07_world_sai.sql index b8a3d47cbec..b8a3d47cbec 100644 --- a/sql/updates/world/2014_07_29_07_world_sai.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_29_07_world_sai.sql diff --git a/sql/updates/world/2014_07_29_08_world_sai.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_29_08_world_sai.sql index 3246f547e8b..3246f547e8b 100644 --- a/sql/updates/world/2014_07_29_08_world_sai.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_29_08_world_sai.sql diff --git a/sql/updates/world/2014_07_29_09_world_sai.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_29_09_world_sai.sql index ceed8de74de..ceed8de74de 100644 --- a/sql/updates/world/2014_07_29_09_world_sai.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_29_09_world_sai.sql diff --git a/sql/updates/world/2014_07_29_10_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_29_10_world_misc.sql index c2e56002de7..c2e56002de7 100644 --- a/sql/updates/world/2014_07_29_10_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_29_10_world_misc.sql diff --git a/sql/updates/world/2014_07_30_00_world_waypoints.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_30_00_world_waypoints.sql index adb3bf83b04..adb3bf83b04 100644 --- a/sql/updates/world/2014_07_30_00_world_waypoints.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_30_00_world_waypoints.sql diff --git a/sql/updates/world/2014_07_30_01_world_sai.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_30_01_world_sai.sql index e8991ebe772..e8991ebe772 100644 --- a/sql/updates/world/2014_07_30_01_world_sai.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_30_01_world_sai.sql diff --git a/sql/updates/world/2014_07_30_02_world_sai.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_30_02_world_sai.sql index 9cc695e9d19..9cc695e9d19 100644 --- a/sql/updates/world/2014_07_30_02_world_sai.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_30_02_world_sai.sql diff --git a/sql/updates/world/2014_07_30_03_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_30_03_world_misc.sql index 3b6866ad935..3b6866ad935 100644 --- a/sql/updates/world/2014_07_30_03_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_30_03_world_misc.sql diff --git a/sql/updates/world/2014_07_30_04_world_sai.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_30_04_world_sai.sql index 0022886ca5a..0022886ca5a 100644 --- a/sql/updates/world/2014_07_30_04_world_sai.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_30_04_world_sai.sql diff --git a/sql/updates/world/2014_07_30_05_world_waypoints.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_30_05_world_waypoints.sql index 96a2ac74603..96a2ac74603 100644 --- a/sql/updates/world/2014_07_30_05_world_waypoints.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_30_05_world_waypoints.sql diff --git a/sql/updates/world/2014_07_30_06_world_waypoints.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_30_06_world_waypoints.sql index bf6b238de11..bf6b238de11 100644 --- a/sql/updates/world/2014_07_30_06_world_waypoints.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_30_06_world_waypoints.sql diff --git a/sql/updates/world/2014_07_30_07_world_waypoints.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_30_07_world_waypoints.sql index c0a8a2ee413..c0a8a2ee413 100644 --- a/sql/updates/world/2014_07_30_07_world_waypoints.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_30_07_world_waypoints.sql diff --git a/sql/updates/world/2014_07_30_08_world_sai.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_30_08_world_sai.sql index d13e2803b07..d13e2803b07 100644 --- a/sql/updates/world/2014_07_30_08_world_sai.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_30_08_world_sai.sql diff --git a/sql/updates/world/2014_07_30_09_world_sai.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_30_09_world_sai.sql index a1497dea582..a1497dea582 100644 --- a/sql/updates/world/2014_07_30_09_world_sai.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_30_09_world_sai.sql diff --git a/sql/updates/world/2014_07_31_00_world_sai.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_31_00_world_sai.sql index d9bf9c4ab83..d9bf9c4ab83 100644 --- a/sql/updates/world/2014_07_31_00_world_sai.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_31_00_world_sai.sql diff --git a/sql/updates/world/2014_07_31_01_world_sai.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_31_01_world_sai.sql index 7e98b044548..7e98b044548 100644 --- a/sql/updates/world/2014_07_31_01_world_sai.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_31_01_world_sai.sql diff --git a/sql/updates/world/2014_07_31_02_world_sai.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_31_02_world_sai.sql index 7decba90d28..7decba90d28 100644 --- a/sql/updates/world/2014_07_31_02_world_sai.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_31_02_world_sai.sql diff --git a/sql/updates/world/2014_07_31_03_world_sai.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_31_03_world_sai.sql index 08efa81d98f..08efa81d98f 100644 --- a/sql/updates/world/2014_07_31_03_world_sai.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_31_03_world_sai.sql diff --git a/sql/updates/world/2014_07_31_04_world_waypoints.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_31_04_world_waypoints.sql index fef69271978..fef69271978 100644 --- a/sql/updates/world/2014_07_31_04_world_waypoints.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_31_04_world_waypoints.sql diff --git a/sql/updates/world/2014_07_31_05_335_world_sai.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_31_05_335_world_sai.sql index 88c5c78d916..88c5c78d916 100644 --- a/sql/updates/world/2014_07_31_05_335_world_sai.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_07_31_05_335_world_sai.sql diff --git a/sql/updates/world/2014_08_01_00_world_creature_template.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_01_00_world_creature_template.sql index 93d8dbd7399..93d8dbd7399 100644 --- a/sql/updates/world/2014_08_01_00_world_creature_template.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_01_00_world_creature_template.sql diff --git a/sql/updates/world/2014_08_01_01_world_sai.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_01_01_world_sai.sql index 92ce9db75b0..92ce9db75b0 100644 --- a/sql/updates/world/2014_08_01_01_world_sai.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_01_01_world_sai.sql diff --git a/sql/updates/world/2014_08_02_00_world_spell_script_names.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_02_00_world_spell_script_names.sql index 23ed6eabf4d..23ed6eabf4d 100644 --- a/sql/updates/world/2014_08_02_00_world_spell_script_names.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_02_00_world_spell_script_names.sql diff --git a/sql/updates/world/2014_08_02_01_world_sai.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_02_01_world_sai.sql index 7756c136e62..7756c136e62 100644 --- a/sql/updates/world/2014_08_02_01_world_sai.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_02_01_world_sai.sql diff --git a/sql/updates/world/2014_08_03_00_world_sai.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_03_00_world_sai.sql index 2462b8bf1bf..2462b8bf1bf 100644 --- a/sql/updates/world/2014_08_03_00_world_sai.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_03_00_world_sai.sql diff --git a/sql/updates/world/2014_08_03_01_world_immunities.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_03_01_world_immunities.sql index 2468c67dcae..2468c67dcae 100644 --- a/sql/updates/world/2014_08_03_01_world_immunities.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_03_01_world_immunities.sql diff --git a/sql/updates/world/2014_08_03_02_world_sai.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_03_02_world_sai.sql index c6331ebe375..c6331ebe375 100644 --- a/sql/updates/world/2014_08_03_02_world_sai.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_03_02_world_sai.sql diff --git a/sql/updates/world/2014_08_05_00_world_quest_template.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_05_00_world_quest_template.sql index 272a490bf81..272a490bf81 100644 --- a/sql/updates/world/2014_08_05_00_world_quest_template.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_05_00_world_quest_template.sql diff --git a/sql/updates/world/2014_08_05_01_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_05_01_world_misc.sql index e913685da69..e913685da69 100644 --- a/sql/updates/world/2014_08_05_01_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_05_01_world_misc.sql diff --git a/sql/updates/world/2014_08_05_02_world_page_text.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_05_02_world_page_text.sql index 45d48ecc879..45d48ecc879 100644 --- a/sql/updates/world/2014_08_05_02_world_page_text.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_05_02_world_page_text.sql diff --git a/sql/updates/world/2014_08_05_03_world_page_text.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_05_03_world_page_text.sql index 2cacb1d2ad2..2cacb1d2ad2 100644 --- a/sql/updates/world/2014_08_05_03_world_page_text.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_05_03_world_page_text.sql diff --git a/sql/updates/world/2014_08_05_04_world_creature_template.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_05_04_world_creature_template.sql index 2895fb06b9a..2895fb06b9a 100644 --- a/sql/updates/world/2014_08_05_04_world_creature_template.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_05_04_world_creature_template.sql diff --git a/sql/updates/world/2014_08_05_05_world_page_text.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_05_05_world_page_text.sql index 4901f4d108c..4901f4d108c 100644 --- a/sql/updates/world/2014_08_05_05_world_page_text.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_05_05_world_page_text.sql diff --git a/sql/updates/world/2014_08_05_06_world_quest_template.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_05_06_world_quest_template.sql index 0eb91f13842..0eb91f13842 100644 --- a/sql/updates/world/2014_08_05_06_world_quest_template.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_05_06_world_quest_template.sql diff --git a/sql/updates/world/2014_08_06_00_world_gameobject.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_06_00_world_gameobject.sql index 0128071ae65..0128071ae65 100644 --- a/sql/updates/world/2014_08_06_00_world_gameobject.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_06_00_world_gameobject.sql diff --git a/sql/updates/world/2014_08_10_00_world_quest_template.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_10_00_world_quest_template.sql index f77c3927499..f77c3927499 100644 --- a/sql/updates/world/2014_08_10_00_world_quest_template.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_10_00_world_quest_template.sql diff --git a/sql/updates/world/2014_08_10_01_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_10_01_world_misc.sql index c6bd7857d3f..c6bd7857d3f 100644 --- a/sql/updates/world/2014_08_10_01_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_10_01_world_misc.sql diff --git a/sql/updates/world/2014_08_10_02_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_10_02_world_misc.sql index b07b6a3632d..b07b6a3632d 100644 --- a/sql/updates/world/2014_08_10_02_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_10_02_world_misc.sql diff --git a/sql/updates/world/2014_08_11_00_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_11_00_world_misc.sql index 06f80db7758..06f80db7758 100644 --- a/sql/updates/world/2014_08_11_00_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_11_00_world_misc.sql diff --git a/sql/updates/world/2014_08_11_01_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_11_01_world_misc.sql index 8b0a17b016f..8b0a17b016f 100644 --- a/sql/updates/world/2014_08_11_01_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_11_01_world_misc.sql diff --git a/sql/updates/world/2014_08_12_00_world_sai.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_12_00_world_sai.sql index c20c948f2f0..c20c948f2f0 100644 --- a/sql/updates/world/2014_08_12_00_world_sai.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_12_00_world_sai.sql diff --git a/sql/updates/world/2014_08_12_01_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_12_01_world_misc.sql index a1e386b16a0..a1e386b16a0 100644 --- a/sql/updates/world/2014_08_12_01_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_12_01_world_misc.sql diff --git a/sql/updates/world/2014_08_13_00_world_sai.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_13_00_world_sai.sql index e478edd86b3..e478edd86b3 100644 --- a/sql/updates/world/2014_08_13_00_world_sai.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_13_00_world_sai.sql diff --git a/sql/updates/world/2014_08_14_00_world_gameobject.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_14_00_world_gameobject.sql index 0cbe21fb11a..0cbe21fb11a 100644 --- a/sql/updates/world/2014_08_14_00_world_gameobject.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_14_00_world_gameobject.sql diff --git a/sql/updates/world/2014_08_14_01_world_creature_template.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_14_01_world_creature_template.sql index 8889a424b62..8889a424b62 100644 --- a/sql/updates/world/2014_08_14_01_world_creature_template.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_14_01_world_creature_template.sql diff --git a/sql/updates/world/2014_08_14_02_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_14_02_world_misc.sql index e08c6f66c74..e08c6f66c74 100644 --- a/sql/updates/world/2014_08_14_02_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_14_02_world_misc.sql diff --git a/sql/updates/world/2014_08_15_00_world_sai.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_15_00_world_sai.sql index 753866d5a87..753866d5a87 100644 --- a/sql/updates/world/2014_08_15_00_world_sai.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_15_00_world_sai.sql diff --git a/sql/updates/world/2014_08_15_01_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_15_01_world_misc.sql index 5be02998c64..5be02998c64 100644 --- a/sql/updates/world/2014_08_15_01_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_15_01_world_misc.sql diff --git a/sql/updates/world/2014_08_15_02_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_15_02_world_misc.sql index 52c52593ab5..52c52593ab5 100644 --- a/sql/updates/world/2014_08_15_02_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_15_02_world_misc.sql diff --git a/sql/updates/world/2014_08_16_00_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_16_00_world_misc.sql index 4db8b4e7aa1..4db8b4e7aa1 100644 --- a/sql/updates/world/2014_08_16_00_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_16_00_world_misc.sql diff --git a/sql/updates/world/2014_08_18_00_world_ulduar.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_18_00_world_ulduar.sql index bdf0cedb986..bdf0cedb986 100644 --- a/sql/updates/world/2014_08_18_00_world_ulduar.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_18_00_world_ulduar.sql diff --git a/sql/updates/world/2014_08_18_01_world_command.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_18_01_world_command.sql index 0a3b44b1991..0a3b44b1991 100644 --- a/sql/updates/world/2014_08_18_01_world_command.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_18_01_world_command.sql diff --git a/sql/updates/world/2014_08_19_00_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_19_00_world_misc.sql index 49d8f11fbdb..49d8f11fbdb 100644 --- a/sql/updates/world/2014_08_19_00_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_19_00_world_misc.sql diff --git a/sql/updates/world/2014_08_19_01_world_event.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_19_01_world_event.sql index 7b3bdd86059..7b3bdd86059 100644 --- a/sql/updates/world/2014_08_19_01_world_event.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_19_01_world_event.sql diff --git a/sql/updates/world/2014_08_19_02_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_19_02_world_misc.sql index dd50c4ce027..dd50c4ce027 100644 --- a/sql/updates/world/2014_08_19_02_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_19_02_world_misc.sql diff --git a/sql/updates/world/2014_08_20_00_world_sai.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_20_00_world_sai.sql index b1ff32d4b9b..b1ff32d4b9b 100644 --- a/sql/updates/world/2014_08_20_00_world_sai.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_20_00_world_sai.sql diff --git a/sql/updates/world/2014_08_21_00_world_conditions.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_21_00_world_conditions.sql index 6a34d273f20..6a34d273f20 100644 --- a/sql/updates/world/2014_08_21_00_world_conditions.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_21_00_world_conditions.sql diff --git a/sql/updates/world/2014_08_21_01_world_achievement_criteria_data.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_21_01_world_achievement_criteria_data.sql index afa5fc6d1d4..afa5fc6d1d4 100644 --- a/sql/updates/world/2014_08_21_01_world_achievement_criteria_data.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_21_01_world_achievement_criteria_data.sql diff --git a/sql/updates/world/2014_08_21_02_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_21_02_world_misc.sql index 041c9820b04..71d83bffa77 100644 --- a/sql/updates/world/2014_08_21_02_world_misc.sql +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_21_02_world_misc.sql @@ -1,4 +1,4 @@ -SET @CGuid := 29974; +SET @CGuid := 74504; -- These two gossip menus on Injured rainspeaker oracle are not meant to be linked, they are two -- seperate gossips the first one for Just Following Orders to help the injured rainspeaker oracle and start event @@ -42,7 +42,7 @@ INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_end`, `aura_spe UPDATE `creature_template` SET `ainame`='SmartAI', `scriptname`='' WHERE `entry` IN(28217,28325,28327); DELETE FROM `smart_scripts` WHERE `entryorguid` IN(28217,28325,28327) AND `source_type`=0; DELETE FROM `smart_scripts` WHERE `entryorguid` IN(28077) AND `source_type`=0 and `id`>14; -DELETE FROM `smart_scripts` WHERE `entryorguid` IN(28133) AND `source_type`=0 and `id`=4; +DELETE FROM `smart_scripts` WHERE `entryorguid` IN(28113) AND `source_type`=0 and `id`=4; DELETE FROM `smart_scripts` WHERE `entryorguid` IN(2811301) AND `source_type`=9 and `id`>0; UPDATE `smart_scripts` SET `event_param1`=290 WHERE `entryorguid`=28308 AND `source_type`=0 AND `id`=2 AND `link`=3; diff --git a/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_21_03_world_sai.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_21_03_world_sai.sql new file mode 100644 index 00000000000..cfc9aabbc95 --- /dev/null +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_21_03_world_sai.sql @@ -0,0 +1,6 @@ +DELETE FROM `creature` WHERE `id`=5806; + +UPDATE `creature_template` SET `ainame`='SmartAI', `scriptname`='' WHERE `entry` =4057; +DELETE FROM `smart_scripts` WHERE `entryorguid` =4057 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 +(4057, 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 11, 7993, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Son of Cenarius - On Spawn - Cast Summon Treant Ally (Self)'); diff --git a/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_22_00_world_conditions.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_22_00_world_conditions.sql new file mode 100644 index 00000000000..56c3d2641f4 --- /dev/null +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_22_00_world_conditions.sql @@ -0,0 +1,5 @@ +-- +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=14 AND `SourceGroup`=5962; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(14, 5962, 7115, 0, 0, 28, 0, 7722, 0, 0, 0, 0, 0, '', 'Show Gossip Menu - If Quest: What the Flux? is Completed'), +(14, 5962, 7115, 0, 1, 5, 0, 59, 128, 0, 0, 0, 0, '', 'Show Gossip Menu - If player is exalted with Thorium Brotherhood (59)'); diff --git a/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_22_01_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_22_01_world_misc.sql new file mode 100644 index 00000000000..0bb682a3438 --- /dev/null +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_22_01_world_misc.sql @@ -0,0 +1,27 @@ +DELETE FROM `creature_text` WHERE `entry` IN(28092,28033); +INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`, `BroadcastTextID`) VALUES +(28092, 0, 0, 'Omega Rune deployed. Activation successful.', 12, 0, 100, 51, 0, 0, 'The Etymidian',33004), +(28033, 0, 0, 'Finally, we have the parts to repair the Spirit of Gnomeregan.', 12, 0, 100, 1, 0, 0, 'Weslex Quickwrench',29878), +(28033, 1, 0, 'Let''s see, just a tweak here and an adjustment there...', 12, 0, 100, 432, 0, 0, 'Weslex Quickwrench',29879), +(28033, 2, 0, 'And there she is, the Spirit of Gnomeregan!', 12, 0, 100, 25, 0, 0, 'Weslex Quickwrench',29880), +(28033, 3, 0, 'You can use her, but I don''t want to hear any complaints about saw blades in your seat. I had to fix ''er with what we could find.', 12, 0, 100, 1, 0, 0, 'Weslex Quickwrench',29881); + +DELETE FROM `creature_template_addon` WHERE `entry`=28037; +INSERT INTO `creature_template_addon` (`entry`, `mount`, `bytes1`, `bytes2`, `auras`) VALUES +(28037, 0, 0x10000, 0x1, '51114'); -- 28037 - 51114 + +DELETE FROM `spell_area` WHERE `spell`=51116 AND `area` =4284; +INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`, `quest_start_status`, `quest_end_status`) VALUES +(51116,4284, 12523, 0, 0, 0, 2, 1, 64, 11); + +UPDATE `creature_template` SET `ainame`='SmartAI', `scriptname`='' WHERE `entry` IN(28092,28568,28033,28047,27986); +DELETE FROM `smart_scripts` WHERE `entryorguid` IN(28092,28033) AND `source_type`=0; +DELETE FROM `smart_scripts` WHERE `entryorguid` IN(2803300) 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 +(28092, 0, 0, 0, 20, 0, 100, 0, 12547, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'The Etymidian - On Quest Reward (The Activation Rune) - Say'), +(28033, 0, 0, 0, 20, 0, 100, 0, 12523, 0, 0, 0, 80, 2803300, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Weslex Quickwrench - On Quest Reward (Have a Part, Give a Part) - Run script'), + +(2803300, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Weslex Quickwrench - Script - Say Line 1'), +(2803300, 9, 1, 0, 0, 0, 100, 0, 7000, 7000, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Weslex Quickwrench - Script - Say Line 2'), +(2803300, 9, 2, 0, 0, 0, 100, 0, 7000, 7000, 0, 0, 1, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Weslex Quickwrench - Script - Say Line 3'), +(2803300, 9, 3, 0, 0, 0, 100, 0, 7000, 7000, 0, 0, 1, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Weslex Quickwrench - Script - Say Line 4'); diff --git a/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_22_02_world_creature_template.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_22_02_world_creature_template.sql new file mode 100644 index 00000000000..4c0d7cc45e0 --- /dev/null +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_22_02_world_creature_template.sql @@ -0,0 +1,2 @@ +UPDATE `creature_template` SET `InhabitType`=2 WHERE `entry` IN (1224, 2188, 3642, 4830, 5936, 6145, 8236, 15118, 15526, 18284, 21217, 23928, 24285, 24637, 24899, 25204, 25226, 26510, 26511, 26522, 27438, 27617, 28010, 28847, 29392, 29834, 30642, 32664, 33497, 34116); +UPDATE `creature_template` SET `InhabitType`=3 WHERE `entry`=21689; diff --git a/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_22_03_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_22_03_world_misc.sql new file mode 100644 index 00000000000..74823327793 --- /dev/null +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_22_03_world_misc.sql @@ -0,0 +1,24 @@ +SET @CGUID := 29974; + +DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+2; +DELETE FROM `creature_addon` WHERE `guid` IN (118456,118301,118183,117164); +INSERT INTO `creature_addon` (`guid`, `mount`, `bytes1`, `bytes2`, `auras`) VALUES +(@CGUID+0, 0, 0x10000, 0x1, '49415'), -- 27102 - 49415 +(@CGUID+1, 0, 0x10000, 0x101, '49415'), -- 26839 - 49415 +(@CGUID+2, 0, 0x10000, 0x101, '49415'), -- 26839 - 49415 + +(118456, 0, 0x10000, 0x1, '49414'), -- 26863 - 49414 +(118301, 0, 0x10000, 0x101, '49414'), -- 26862 - 49414 +(118183, 0, 0x10000, 0x1, '49414'), -- 26860 - 49414 +(117164, 0, 0x10000, 0x1, '49414'); -- 27102 - 49414 + +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+2; +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES +(@CGUID+0, 27102, 571, 1, 1, 3270.905, -2197.24, 117.4559, 4.101524, 120, 0, 0), -- 27102 (Area: 394) +(@CGUID+1, 26839, 571, 1, 1, 3268.641, -2195.643, 117.4559, 4.34587, 120, 0, 0), -- 26839 (Area: 394) +(@CGUID+2, 26839, 571, 1, 1, 3273.251, -2197.424, 117.4559, 4.066617, 120, 0, 0); -- 26839 (Area: 394) + +DELETE FROM `spell_area` WHERE `spell` IN(49417,49416) AND `area`=4206; +INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`, `quest_start_status`, `quest_end_status`) VALUES +(49417,4206, 12431, 0, 0, 0, 2, 1, 64, 11), +(49416,4206, 0, 12431, 0, 0, 2, 1, 64, 11); diff --git a/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_22_04_world_misc.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_22_04_world_misc.sql new file mode 100644 index 00000000000..318c4eb1f92 --- /dev/null +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_22_04_world_misc.sql @@ -0,0 +1,2 @@ +UPDATE `creature_template` SET `ainame`='', `scriptname`='npc_jungle_punch_target' WHERE `entry` IN(28568,28047,27986); +UPDATE `creature_template` SET `scriptname`='npc_the_etymidian' WHERE `entry` =28033; diff --git a/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_24_00_world_sai_335.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_24_00_world_sai_335.sql new file mode 100644 index 00000000000..3b5ba744da3 --- /dev/null +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_24_00_world_sai_335.sql @@ -0,0 +1,160 @@ +-- Balizar the Umbrage SAI +SET @ENTRY := 3899; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@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,0,0,100,0,1000,2000,10000,15000,11,14868,0,0,0,0,0,2,0,0,0,0,0,0,0,"Balizar the Umbrage - In Combat - Cast 'Curse of Agony'"), +(@ENTRY,0,1,0,0,0,100,0,3000,4000,11000,16000,11,11980,0,0,0,0,0,2,0,0,0,0,0,0,0,"Balizar the Umbrage - In Combat - Cast 'Curse of Weakness'"), +(@ENTRY,0,2,0,0,0,100,0,7000,8000,7000,8000,11,20791,0,0,0,0,0,2,0,0,0,0,0,0,0,"Balizar the Umbrage - In Combat - Cast 'Shadow Bolt'"), +(@ENTRY,0,3,0,54,0,100,0,0,0,0,0,18,768,0,0,0,0,0,1,0,0,0,0,0,0,0,"Balizar the Umbrage - On Just Summoned - Set Unit Flags - Immune to NPC/NPC"), +(@ENTRY,0,4,5,38,0,100,0,1,1,0,0,19,768,0,0,0,0,0,1,0,0,0,0,0,0,0,"Balizar the Umbrage - On Data Set - Remove Unit Flags - Immune to NPC/NPC"), +(@ENTRY,0,5,6,61,0,100,0,0,0,0,0,45,1,1,0,0,0,0,19,3900,0,0,0,0,0,0,"Balizar the Umbrage - On Data Set - Set Data Caedakar the Vicious"), +(@ENTRY,0,6,0,61,0,100,0,0,0,0,0,45,1,1,0,0,0,0,19,3898,0,0,0,0,0,0,"Balizar the Umbrage - On Data Set - Set Data Aligar the Tormentor"); + +-- Dark Strand Forsaken Scout SAI +SET @ENTRY := 3893; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@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,54,0,100,0,0,0,0,0,18,768,0,0,0,0,0,1,0,0,0,0,0,0,0,"Forsaken Scout - On Just Summoned - Set Unit Flags - Immune to NPC/NPC"), +(@ENTRY,0,1,0,38,0,100,0,1,1,0,0,19,768,0,0,0,0,0,1,0,0,0,0,0,0,0,"Forsaken Scout - On Data Set - Remove Unit Flags - Immune to NPC/NPC"); + + +-- Dark Strand Assassin SAI +SET @ENTRY := 3879; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@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,0,0,100,0,0,5000,11000,18000,11,3405,0,0,0,0,0,2,0,0,0,0,0,0,0,"Dark Strand Assassin - IC - Cast Soul Rend"), +(@ENTRY,0,1,0,0,0,100,0,5000,9000,15000,21000,11,11675,64,0,0,0,0,2,0,0,0,0,0,0,0,"Dark Strand Assassin - IC - Cast Drain Soul"), +(@ENTRY,0,2,0,54,0,100,0,0,0,0,0,18,768,0,0,0,0,0,1,0,0,0,0,0,0,0,"Dark Strand Assassin - On Just Summoned - Set Unit Flags - Immune to NPC/NPC"), +(@ENTRY,0,3,0,38,0,100,0,1,1,0,0,19,768,0,0,0,0,0,1,0,0,0,0,0,0,0,"Dark Strand Assassin - On Data Set - Remove Unit Flags - Immune to NPC/NPC"); + +-- Caedakar the Vicious SAI +SET @ENTRY := 3900; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@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,54,0,100,1,0,0,0,0,11,7165,2,0,0,0,0,1,0,0,0,0,0,0,0,"Caedakar the Vicious - On Just Summoned - Cast 'Battle Stance' (No Repeat)"), +(@ENTRY,0,1,0,0,0,100,0,4000,9000,11000,16000,11,9080,0,0,0,0,0,2,0,0,0,0,0,0,0,"Caedakar the Vicious - In Combat - Cast 'Hamstring'"), +(@ENTRY,0,2,0,0,0,100,1,3000,4000,8000,15000,11,25712,0,0,0,0,0,2,0,0,0,0,0,0,0,"Caedakar the Vicious - In Combat - Cast 'Heroic Strike' (No Repeat)"), +(@ENTRY,0,3,0,54,0,100,0,0,0,0,0,18,768,0,0,0,0,0,1,0,0,0,0,0,0,0,"Caedakar the Vicious - On Just Summoned - Set Unit Flags - Immune to NPC/NPC"), +(@ENTRY,0,4,0,38,0,100,0,1,1,0,0,19,768,0,0,0,0,0,1,0,0,0,0,0,0,0,"Caedakar the Vicious - On Data Set - Remove Unit Flags - Immune to NPC/NPC"); + +-- Aligar the Tormentor SAI +SET @ENTRY := 3898; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@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,54,0,100,1,0,0,0,0,11,7165,0,0,0,0,0,1,0,0,0,0,0,0,0,"Aligar the Tormentor - On Just Summoned - Cast 'Battle Stance' (No Repeat)"), +(@ENTRY,0,1,0,0,0,100,0,3000,4000,5000,6000,11,9080,0,0,0,0,0,2,0,0,0,0,0,0,0,"Aligar the Tormentor - In Combat - Cast 'Hamstring'"), +(@ENTRY,0,2,0,0,0,100,1,6000,7000,6000,7000,11,25712,0,0,0,0,0,2,0,0,0,0,0,0,0,"Aligar the Tormentor - In Combat - Cast 'Heroic Strike' (No Repeat)"), +(@ENTRY,0,3,0,54,0,100,0,0,0,0,0,18,768,0,0,0,0,0,1,0,0,0,0,0,0,0,"Aligar the Tormentor - On Just Summoned - Set Unit Flags - Immune to NPC/NPC"), +(@ENTRY,0,4,0,38,0,100,0,1,1,0,0,19,768,0,0,0,0,0,1,0,0,0,0,0,0,0,"Aligar the Tormentor - On Data Set - Remove Unit Flags - Immune to NPC/NPC"); + +UPDATE `creature_template` SET `ScriptName`='',`AIName`="SmartAI" WHERE `entry`=4484; +DELETE FROM `smart_scripts` WHERE `entryorguid`=4484 AND `source_type`=0; +DELETE FROM `smart_scripts` WHERE `entryorguid`=448400 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 +(4484,0,0,1,19,0,100,1,976,0,0,0,64,1,0,0,0,0,0,7,0,0,0,0,0,0,0,'Feero Ironhand - On Quest Accept (Supplies to Aubderdine) - Store Targetlist '), +(4484,0,1,2,61,0,100,1,0,0,0,0,2,774,0,0,0,0,0,1,0,0,0,0,0,0,0,'Feero Ironhand - On Quest Accept (Supplies to Aubderdine) - Set Faction'), +(4484,0,2,3,61,0,100,1,0,0,0,0,19,512,0,0,0,0,0,1,0,0,0,0,0,0,0,'Feero Ironhand - On Quest Accept (Supplies to Aubderdine) - Remove Unit Flags'), +(4484,0,3,0,61,0,100,1,0,0,0,0,1,7,5000,0,0,0,0,1,0,0,0,0,0,0,0,'Feero Ironhand - On Quest Accept (Supplies to Aubderdine) - Say Line 7'), +(4484,0,4,0,7,0,100,0,0,0,0,0,19,512,0,0,0,0,0,1,0,0,0,0,0,0,0,'Feero Ironhand - On Evade - Remove Unit Flags'), +(4484,0,5,6,40,0,100,1,18,4484,0,0,1,0,5000,0,0,0,0,1,0,0,0,0,0,0,0,'Feero Ironhand - On Reached WP18 - Say Line 0'), +(4484,0,6,7,61,0,100,1,0,0,0,0,107,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Feero Ironhand - On Reached WP18 - Summon Summon Group 0'), +(4484,0,7,0,61,0,100,1,0,0,0,0,54,5000,0,0,0,0,0,1,0,0,0,0,0,0,0,'Feero Ironhand - On Reached WP18 - Pause WP (2 Seconds)'), +(4484,0,8,0,40,0,100,1,19,4484,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Feero Ironhand - On Reached WP19 - Say Line 1'), +(4484,0,9,10,40,0,100,1,27,4484,0,0,1,2,5000,0,0,0,0,1,0,0,0,0,0,0,0,'Feero Ironhand - On Reached WP27 - Say'), +(4484,0,10,11,61,0,100,1,0,0,0,0,107,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Feero Ironhand - On Reached 27 - Summon Summon Group 1'), +(4484,0,11,0,61,0,100,1,0,0,0,0,54,5000,0,0,0,0,0,1,0,0,0,0,0,0,0,'Feero Ironhand - On Reached WP27 - Pause WP (5 Seconds)'), +(4484,0,12,0,40,0,100,1,28,4484,0,0,1,3,0,0,0,0,0,1,0,0,0,0,0,0,0,'Feero Ironhand - On Reached WP28 - Say Line 3'), +(4484,0,13,14,40,0,100,1,41,4484,0,0,1,4,5000,0,0,0,0,1,0,0,0,0,0,0,0,'Feero Ironhand - On Reached WP41 - Say Line 4'), +(4484,0,14,15,61,0,100,1,0,0,0,0,107,2,0,0,0,0,0,1,0,0,0,0,0,0,0,'Feero Ironhand - On Reached WP41 - Summon Summon Group 2'), +(4484,0,15,0,61,0,100,1,0,0,0,0,54,10000,0,0,0,0,0,1,0,0,0,0,0,0,0,'Feero Ironhand - On Reached WP41 - Pause WP (10 Seconds)'), +(4484,0,16,17,40,0,100,1,43,4484,0,0,1,6,0,0,0,0,0,1,0,0,0,0,0,0,0,'Feero Ironhand - On Reached WP43 - Say Line 5'), +(4484,0,17,18,61,0,100,1,0,0,0,0,15,976,0,0,0,0,0,12,1,0,0,0,0,0,0,'Feero Ironhand - On Reached 43 - Call Areaexploredoreventhappens'), +(4484,0,18,19,61,0,100,1,0,0,0,0,59,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Feero Ironhand - On Reached 43 - Set Run'), +(4484,0,19,0,61,0,100,1,0,0,0,0,54,5000,0,0,0,0,0,1,0,0,0,0,0,0,0,'Feero Ironhand - On Reached WP43 - Pause WP (5 Seconds)'), +(4484,0,20,0,40,0,100,1,45,4484,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Feero Ironhand - On Reached WP45 - Despawn'), +(4484,0,21,0,6,0,100,1,0,0,0,0,6,976,0,0,0,0,0,12,1,0,0,0,0,0,0,'Feero Ironhand - On Death - Fail Quest'), +(4484,0,22,0,52,0,100,1,2,4484,0,0,45,1,1,0,0,0,0,9,3893,0,100,0,0,0,0,'Feero Ironhand - On Text Over line 2 - Set Data Forsaken Scout'), +(4484,0,23,0,52,0,100,1,4,4484,0,0,1,0,5000,0,0,0,0,19,3899,0,0,0,0,0,0,'Feero Ironhand - On Text Over line 4 - Say Line 0 (Balizar the Umbrage)'), +(4484,0,24,25,52,0,100,1,0,3899,0,0,1,5,5000,0,0,0,0,1,0,0,0,0,0,0,0,'Feero Ironhand - On Text Over line 0 (Balizar the Umbrage) - Say Line 5'), +(4484,0,25,0,61,0,100,1,0,0,0,0,45,1,1,0,0,0,0,19,3899,0,0,0,0,0,0,'Feero Ironhand - On Text Over line 0 (Balizar the Umbrage) - Set Data (Balizar the Umbrage)'), +(4484,0,26,0,52,0,100,1,7,4484,0,0,53,0,4484,0,976,0,1,1,0,0,0,0,0,0,0,'Feero Ironhand - On Text Over Line 7 - Start WP'), +(4484,0,27,0,52,0,100,1,0,4484,0,0,45,1,1,0,0,0,0,9,3879,0,100,0,0,0,0,'Feero Ironhand - On Text Over line 0 - Set Data Dark Strand assasin'); + +DELETE FROM `creature_summon_groups` WHERE `summonerId`=4484; +INSERT INTO `creature_summon_groups` (`summonerId`, `summonerType`, `groupId`, `entry`, `position_x`, `position_y`, `position_z`, `orientation`, `summonType`, `summonTime`) VALUES +(4484, 0, 0, 3879, 3491.09, 214.76, 11.36, 3.30, 1, 30000), +(4484, 0, 0, 3879, 3491.18, 212.28, 11.25, 3.03, 1, 30000), +(4484, 0, 0, 3879, 3490.74, 210.59, 11.32, 3.03, 1, 30000), +(4484, 0, 0, 3879, 3490.46, 208.78, 11.39, 2.93, 1, 30000), +(4484, 0, 1, 3893, 3782.51, 145.57, 8.54, 2.93, 1, 30000), +(4484, 0, 1, 3893, 3778.84, 143.46, 8.41, 2.93, 1, 30000), +(4484, 0, 1, 3893, 3782.26, 149.61, 8.34, 2.93, 1, 30000), +(4484, 0, 2, 3900, 4108.34, 53.69, 26.18, 2.93, 1, 30000), +(4484, 0, 2, 3898, 4114.55, 54.48, 27.21, 2.93, 1, 30000), +(4484, 0, 2, 3899, 4116.81, 50.14, 26.15, 2.93, 1, 30000); + +DELETE FROM `creature_text` WHERE `entry` IN(4484,3899); +INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`, `BroadcastTextID`) VALUES +(4484, 0, 0, 'It looks like we''re in trouble. Look lively, here they come!', 12, 7, 100, 0, 0, 0, 'Feero', 1372), +(4484, 1, 0, 'Assassins from that cult you found... Let''s get moving before someone else finds us out here.', 12, 7, 100, 0, 0, 0, 'Feero', 1294), +(4484, 2, 0, 'Hold! I sense an evil presence... Undead!', 12, 7, 100, 0, 0, 0, 'Feero',1373), +(4484, 3, 0, 'They''re coming out of the woodwork today. Let''s keep moving or we may find more things that want me dead.', 12, 7, 100, 0, 0, 0, 'Feero', 1310), +(4484, 4, 0, 'These three again?', 12, 7, 100, 0, 0, 0, 'Feero',1374), +(4484, 5, 0, 'I''ll finish you off for good this time!', 12, 0, 100, 0, 0, 0, 'Feero', 1499), +(4484, 6, 0, 'Well done! I should be fine on my own from here. Remember to talk to Delgren when you return to Maestra''s Post in Ashenvale.', 12, 7, 100, 0, 0, 0, 'Feero', 1315), +(4484, 7, 0, 'We must move quickly. Auberdine isn''t too far away, but many enemies lurk in the forest.', 12, 7, 100, 0, 0, 0, 'Feero', 1292), +(3899, 0, 0, 'Not quite so sure of yourself without the Purifier, hm?', 12, 0, 100, 0, 0, 0, 'Balizar the Umbrage',1313); + +DELETE FROM `waypoints` WHERE `entry`=4484; +INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES +(4484, 1, 3175.930908, 193.541306, 3.483540, ''), +(4484, 2, 3187.917969, 197.117691, 4.699296, ''), +(4484, 3, 3203.483643, 192.349060, 5.908475 , ''), +(4484, 4, 3219.118408, 182.236420, 6.588406, ''), +(4484, 5, 3229.847412, 191.230438, 7.494555, ''), +(4484, 6, 3225.035156, 199.438843, 7.096720, ''), +(4484, 7, 3227.651855, 210.760071, 8.629334, ''), +(4484, 8, 3232.935303, 223.724869, 10.052238 , ''), +(4484, 9, 3263.071777, 225.984848, 10.645896 , ''), +(4484, 10, 3284.759521, 220.414124, 10.950543, ''), +(4484, 11, 3315.646973, 210.198044, 11.967686, ''), +(4484, 12, 3341.024414, 214.290497, 13.320419, ''), +(4484, 13, 3367.133789, 224.587524, 11.867117, ''), +(4484, 14, 3409.073242, 226.385315, 9.215232, ''), +(4484, 15, 3432.292236, 225.396271, 10.028325, ''), +(4484, 16, 3454.865723, 219.339172, 12.593150, ''), +(4484, 17, 3470.463867, 214.818161, 13.264424, ''), +(4484, 18, 3481.416992, 212.556610, 12.354552, 'say_1'), +(4484, 19, 3500.315674, 210.936295, 10.226085, 'say_death_1'), +(4484, 20, 3532.806641, 215.041473, 8.372272, ''), +(4484, 21, 3565.314209, 217.748749, 5.300299, ''), +(4484, 22, 3601.654297, 217.771378, 1.299005, ''), +(4484, 23, 3638.605713, 212.525879, 1.433142 , ''), +(4484, 24, 3680.757324, 200.308197, 3.385010, ''), +(4484, 25, 3725.670410, 180.395966, 6.314014, ''), +(4484, 26, 3762.346924, 159.685959, 7.388617, ''), +(4484, 27, 3774.541260, 151.170029, 7.799640, 'say_2'), +(4484, 28, 3789.697754, 140.396774, 9.062237, 'say_death_2'), +(4484, 29, 3821.424072, 111.609528, .258650, ''), +(4484, 30, 3850.376465, 84.710922, 13.941991, ''), +(4484, 31, 3875.349121, 60.388409, 14.988914 , ''), +(4484, 32, 3908.238525, 35.209225, 15.332011, ''), +(4484, 33, 3942.200928, 14.888245, 16.969385, ''), +(4484, 34, 3976.427246, -0.073566, 16.968657, ''), +(4484, 35, 4008.343750, -6.628914, 16.464090, ''), +(4484, 36, 4029.483643, -6.640755, 16.549721, ''), +(4484, 37, 4050.055908, 1.488156, 15.746178, ''), +(4484, 38, 4083.412109, 14.085828, 15.851171, ''), +(4484, 39, 4098.462891, 20.032930, 17.252523, ''), +(4484, 40, 4105.861816, 34.792000, 20.284599, ''), +(4484, 41, 4110.536133, 45.538300, 23.154394, 'say_3_A'), +(4484, 42, 4112.863281, 51.454445, 26.165501, 'say_3_B'), +(4484, 43, 4126.177246, 53.689651, 26.399027, 'say_death_3'), +(4484, 44, 4149.127441, 46.833157, 24.660984, ''), +(4484, 45, 4164.439941, 55.935448, 26.793362, 'despawn'); diff --git a/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_24_01_world_sai.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_24_01_world_sai.sql new file mode 100644 index 00000000000..983d54e7b0f --- /dev/null +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_24_01_world_sai.sql @@ -0,0 +1,162 @@ +DELETE FROM `smart_scripts` WHERE `entryorguid`=28503 AND `source_type`=0 AND `id`>4; +DELETE FROM `smart_scripts` WHERE `entryorguid`=2850300 AND `source_type`=9; +DELETE FROM `smart_scripts` WHERE `entryorguid`=-98865 AND `source_type`=0; +UPDATE `creature_template` SET `spell1`=54135, `spell2`=54132, `spell3`=54136 WHERE `entry`=28931; + +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 +(28503, 0, 5, 6, 62, 0, 100, 0, 9731, 0, 0, 0, 64, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Overlord Drakuru - On Gossip Option 0 Selected - Store Target'), +(28503, 0, 6, 7, 61, 0, 100, 0, 0, 0, 0, 0, 85, 52863, 2, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, 'Overlord Drakuru - On Gossip Option 0 Selected - Cast Drakuru Betrayal Teleport'), +(28503, 0, 7, 8, 61, 0, 100, 0, 0, 0, 0, 0, 12, 28998, 1, 600000, 0, 0, 0, 8, 0, 0, 0, 6175.246, -2017.655, 590.9613, 2.984513, 'Overlord Drakuru - On Gossip Option 0 Selected - Summon Drakuru'); + +DELETE FROM `spell_target_position` WHERE `id` IN(52863,57553); +INSERT INTO `spell_target_position` (`id`, `effIndex`, `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`, `VerifiedBuild`) VALUES +(52863, 0, 571, 6161.15, -2015.36, 590.878, 6.196, 0), -- Drakuru Betrayal Teleport +(57553, 0, 571, 5875.43, -1981.37, 234.671, 0, 0); -- Escape Voltarus + +UPDATE `creature_template` SET `faction`=2082,`unit_flags`=256 WHERE `entry`=28998; -- Correct Faction (Not 35) + +DELETE FROM `creature_template_addon` WHERE `entry`=28998; +INSERT INTO `creature_template_addon` (`entry`, `mount`, `bytes1`, `bytes2`, `auras`) VALUES +(28998, 0, 0x0, 0x1, '58837 54104'); -- 28998 - 58837, 54104 + +DELETE FROM `spell_linked_spell` WHERE `spell_trigger`IN(-52010,54089); +INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES +(-52010, '-51966', 0,'On Remove Scourge Disguise Expiring - Also Remove Scourge Disguise'), +(54089, '52010', '1', 'On Hit Drop Disguise - Remove Scourge Disguise'); + +DELETE FROM `creature_text` WHERE `entry` =28998; +DELETE FROM `creature_text` WHERE `entry` =28498 AND `groupid`>6; + +INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`, `BroadcastTextID`) VALUES +(28998, 0, 0, 'Behold, mon! We be creatin'' da greatest Scourge army ever seen!', 12, 0, 100, 396, 0, 14023, 'Overlord Drakuru',29441), +(28998, 1, 0, 'These be da first of many! We shall sweep across Zul''Drak like da wind....', 12, 0, 100, 396, 0, 14024, 'Overlord Drakuru',29442), +(28998, 2, 0, 'What treachery is this?! You be payin'' for this deceit with your life, mon!', 12, 0, 100, 0, 0, 14025, 'Overlord Drakuru',29885), +(28998, 3, 0, 'The Scepter of Domination glows brightly! Use it now!', 41, 0, 100, 0, 0, 0, 'Overlord Drakuru',29886), +(28998, 4, 0, 'How could dis be? Da Lich King said he be havin'' great plans for you, mon...', 14, 0, 100, 0, 0, 14027, 'Overlord Drakuru',29917), +(28998, 4, 1, 'Ya done turned your back on destiny, mon. Now you gunna die!', 14, 0, 100, 0, 0, 14029, 'Overlord Drakuru',29919), +(28998, 4, 2, 'Fool! Ya coulda been havin'' great power, mon!', 14, 0, 100, 0, 0, 14026, 'Overlord Drakuru',29916), +(28998, 4, 3, 'Your betrayal not gunna be slowin'' me down none, mon.', 14, 0, 100, 0, 0, 14030, 'Overlord Drakuru',29920), +(28998, 4, 4, 'I shoulda known not to be trustin'' nobody!', 14, 0, 100, 0, 0, 14028, 'Overlord Drakuru',29918), +(28998, 4, 5, 'I never needed ya, mon. I can crush Zul''Drak without ya!', 14, 0, 100, 0, 0, 14031, 'Overlord Drakuru',29921), +(28998, 5, 0, 'ENOUGH!', 14, 0, 100, 22, 0, 14020, 'Overlord Drakuru',29922), +(28998, 6, 0, 'Dis foolish treachery has cost ya your destiny!', 14, 0, 100, 396, 0, 14021, 'Overlord Drakuru',29923), +(28998, 7, 0, 'Master, dis mortal scum be double-crossin'' us. Dey must be made to suffer!', 12, 0, 100, 396, 0, 14022, 'Overlord Drakuru',29969), +(28998, 8, 0, 'Disguise Failing! Avoid Scourge Contact!', 41, 0, 100, 0, 0, 0, 'Overlord Drakuru',28891), +(28498, 7, 0, 'You have failed me, Drakuru!', 12, 0, 100, 396, 0, 14762, 'The Lich King',29986), +(28498, 8, 0, 'It is you who should suffer. Be content that your death is a quick one....', 12, 0, 100, 397, 0, 14763, 'The Lich King',29982), +(28498, 9, 0, 'As for you...', 12, 0, 100, 397, 0, 14764, 'The Lich King',29983), +(28498, 10, 0, 'I spare your insignificant life as a reward for this amusing betrayal. There may yet be a shred of potential in you.', 12, 0, 100, 396, 0, 14765, 'The Lich King',29984), +(28498, 11, 0, 'Be warned...', 12, 0, 100, 396, 0, 14766, 'The Lich King',29989), +(28498, 12, 0, 'When next we meet I shall require much more to justify your life.', 12, 0, 100, 396, 0, 14767, 'The Lich King',29985); + +UPDATE `smart_scripts` SET `event_param2`=28498 WHERE `entryorguid`=28498 AND `source_type`=0 AND `id` IN(1,3); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceEntry`=28498; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(22, 1, 28498, 0, 0, 23, 1, 4196, 0, 0, 0, 0, 0, '', 'The Lich King - Only Run SAI in Drak Tharon Keep'), +(22, 6, 28498, 0, 0, 23, 1, 4314, 0, 0, 0, 0, 0, '', 'The Lich King - Only Run SAI in Voltarus'); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`IN(54250,54105); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(13, 1, 54250, 0, 0, 31, 0, 3, 28960, 0, 0, 0, 0, '', 'Drakurus Skull Missile targets Totally Generic Bunny'), +(13, 1, 54105, 0, 0, 31, 0, 4, 0, 0, 0, 0, 0, '', 'Blight Fog Targets Player'), +(13, 1, 54105, 0, 1, 31, 0, 3, 28931, 0, 0, 0, 0, '', 'Blight Fog Targets Blightblood Troll'); + +UPDATE `creature_template` SET `ainame`='SmartAI', `scriptname`='' WHERE `entry` IN(28931,28998,28960,29100); +UPDATE `gameobject_template` SET `AIName`='SmartGameObjectAI' WHERE `entry`=202357; + +DELETE FROM `smart_scripts` WHERE `entryorguid` IN(2899800,2899801,2849801,2899802) AND `source_type`=9; +DELETE FROM `smart_scripts` WHERE `entryorguid`IN(28998,28931,28960,29100) AND `source_type`=0; +DELETE FROM `smart_scripts` WHERE `entryorguid`IN(202357) AND `source_type`=1; + +DELETE FROM `smart_scripts` WHERE `entryorguid`=28498 AND `source_type`=0 AND `id`>4; + +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 +(28960, 0, 0, 1, 8, 0, 100, 0, 54250, 0, 0, 0, 11, 54253, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Totally Generic Bunny (JSB) - On Spell hit (Drakurus Skull Missile) - Cast Spawn Drakurus Skull'), +(28960, 0, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 50, 202357, 120, 0, 0, 0, 0, 8, 0, 0, 0, 6185.989, -2029.698, 590.8779, 0, 'Totally Generic Bunny (JSB) - On Spell hit (Drakurus Skull Missile) - Spawn Drakurus Last Wish'), +(28960, 0, 2, 0, 38, 0, 100, 0, 1, 1, 0, 0, 11, 51807, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Totally Generic Bunny (JSB) - On Data Set 1 1 - Cast Athas Portal'), +(28960, 0, 3, 0, 38, 0, 100, 0, 2, 2, 0, 0, 28, 51807, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Totally Generic Bunny (JSB) - On Data Set 2 2 - Remove Aura Athas Portal'), +(29100, 0, 0, 0, 38, 0, 100, 0, 1, 1, 0, 0, 11, 51347, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Totally Generic Bunny x8.0 (JSB) - On Data Set 1 1 - Cast Teleport Visual Only'), +(29100, 0, 1, 0, 38, 0, 100, 0, 2, 2, 0, 0, 11, 53104, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Totally Generic Bunny x8.0 (JSB) - On Data Set 2 2 - Cast Scourge Spotlight'), +(29100, 0, 2, 0, 38, 0, 100, 0, 3, 3, 0, 0, 28, 53104, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Totally Generic Bunny x8.0 (JSB) - On Data Set 3 3 - Remove Aura Scourge Spotlight'), +(202357, 1, 0, 0, 62, 0, 100, 0, 11091, 0, 0, 0, 85, 57553, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Drakurus Last Wish - On Gossip Select - Invoker Cast Escape Voltarus'), +(28998, 0, 0, 0, 54, 0, 100, 1, 0, 0, 0, 0, 80, 2899800, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Overlord Drakuru - On Just Summoned Run Script'), +(28998, 0, 1, 0, 7, 0, 100, 0, 0, 0, 0, 0, 19, 256, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Overlord Drakuru - On Evade - Set Unit Flags'), +(28998, 0, 2, 3, 4, 0, 100, 0, 0, 0, 0, 0, 21, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Overlord Drakuru - On Agro - Disable Combat Movement'), +(28998, 0, 3, 0, 61, 0, 100, 0, 0, 0, 0, 0, 45, 2, 2, 0, 0, 0, 0, 9, 29100, 0, 200, 0, 0, 0, 0, 'Overlord Drakuru - On Agro - Set Data'), +(28998, 0, 4, 0, 9, 0, 100, 0, 10, 100, 3000, 7000, 11, 54113, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Overlord Drakuru - On Range - Cast Shadow Bolt'), +(28998, 0, 5, 0, 0, 0, 100, 0, 5000, 10000, 15000, 35000, 11, 54087, 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 'Overlord Drakuru - IC - Cast Throw Blight Crystal'), +(28998, 0, 6, 0, 0, 0, 100, 0, 15000, 25000, 20000, 35000, 1, 4, 0, 0, 0, 0, 0, 21, 100, 0, 0, 0, 0, 0, 0, 'Overlord Drakuru - IC - Say'), +(28998, 0, 7, 0, 2, 0, 100, 1, 0, 10, 0, 0, 80, 2899801, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Overlord Drakuru - On Less than 10% HP - Run script 2'), +(28998, 0, 8, 0, 38, 0, 100, 0, 1, 1, 0, 0, 80, 2899802, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Overlord Drakuru - On Data Set - Run Script 3'), +(28998, 0, 9, 10, 1, 0, 100, 0, 90000, 90000, 0, 0, 11, 61492, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Overlord Drakuru - OOC - Cast Despawn Blightblood'), +(28998, 0, 10, 11, 61, 0, 100, 0, 0, 0, 0, 0, 45, 3, 3, 0, 0, 0, 0, 9, 29100, 0, 200, 0, 0, 0, 0, 'Overlord Drakuru - OOC - Set Data 3 3 on Totally Generic Bunny (JSB)'), +(28998, 0, 11, 0, 61, 0, 100, 0, 0, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Overlord Drakuru - OOC - Despawn'), +(28998, 0, 12, 0, 6, 0, 100, 0, 0, 0, 0, 0, 41, 2000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Overlord Drakuru - On Death - Despawn after 2 seconds'), +(28931, 0, 0, 0, 38, 0, 100, 0, 1, 1, 0, 0, 19, 256, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Blightblood Troll - On Data Set 1 1 - Set Unit Flags'), +(28931, 0, 1, 0, 7, 0, 100, 0, 0, 0, 0, 0, 19, 256, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Blightblood Troll - On Evade - Set Unit Flags'), +(28931, 0, 2, 0, 8, 0, 100, 0, 61492, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Blightblood Troll - On Spellhit (Despawn Blightblood) - Despawn'), +(28931, 0, 3, 0, 54, 0, 100, 0, 0, 0, 0, 0, 22, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Blightblood Troll - On Spellhit (Despawn Blightblood) - Despawn'), +(28931, 0, 4, 0, 4, 0, 100, 1, 0, 0, 0, 0, 22, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Blightblood Troll - On Agro - Set Phase 2'), +(28931, 0, 5, 0, 8, 0, 100, 1, 53103, 0, 0, 0, 22, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Blightblood Troll - On Spellhit (Charm Blightblood Troll) - Set Phase 2'), +(28931, 0, 6, 0, 0, 2, 100, 1, 0, 0, 0, 0, 45, 3, 3, 0, 0, 0, 0, 19, 29100, 10, 0, 0, 0, 0, 0, 'Blightblood Troll - IC (Phase 2) - Set Data 3 3 on Totally Generic Bunny (JSB)'), +(28931, 0, 7, 0, 1, 2, 100, 1, 0, 0, 0, 0, 45, 3, 3, 0, 0, 0, 0, 19, 29100, 10, 0, 0, 0, 0, 0, 'Blightblood Troll - OOC (Phase 2) - Set Data 3 3 on Totally Generic Bunny (JSB)'), +(28498, 0, 5, 0, 54, 0, 100, 0, 0, 0, 0, 0, 53, 0, 2849800, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'The Lich King - On Just Summoned - Start Waypoint'), +(28498, 0, 6, 0, 40, 0, 100, 0, 4, 2849800, 0, 0, 1, 7, 0, 0, 0, 0, 0, 19, 28998, 0, 0, 0, 0, 0, 0, 'The Lich King - Reached WP4 - Say'), +(28498, 0, 7, 0, 40, 0, 100, 0, 8, 2849800, 0, 0, 80, 2849801, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'The Lich King - Reached WP8 - Run Script'), +(28498, 0, 8, 9, 40, 0, 100, 0, 4, 2849801, 0, 0, 45, 2, 2, 0, 0, 0, 0, 10, 98914, 28960, 0, 0, 0, 0, 0, 'The Lich King - Reached WP4 (Path 2) - Set Data'), +(28498, 0, 9, 0, 61, 0, 100, 0, 0, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'The Lich King - Reached WP4 (Path 2) - Despawn'), +(2899800, 9, 0, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Overlord Drakuru - Script - Say'), +(2899800, 9, 1, 0, 0, 0, 100, 0, 4500, 4500, 0, 0, 45, 1, 1, 0, 0, 0, 0, 9, 29100, 0, 200, 0, 0, 0, 0, 'Overlord Drakuru - Script - Say'), +(2899800, 9, 2, 0, 0, 0, 100, 0, 500, 500, 0, 0, 12, 28931, 1, 600000, 0, 0, 0, 8, 0, 0, 0, 6184.146, -1970.17, 586.8419, 4.590216, 'Overlord Drakuru - Script - Summon Blightblood Troll 1'), +(2899800, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 28931, 1, 600000, 0, 0, 0, 8, 0, 0, 0, 6222.855, -2026.631, 586.8419, 3.001966, 'Overlord Drakuru - Script - Summon Blightblood Troll 2'), +(2899800, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 28931, 1, 600000, 0, 0, 0, 8, 0, 0, 0, 6127.512, -2008.651, 586.8419, 6.161012, 'Overlord Drakuru - Script - Summon Blightblood Troll 3'), +(2899800, 9, 5, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 28931, 1, 600000, 0, 0, 0, 8, 0, 0, 0, 6166.278, -2065.312, 586.8419, 1.448623, 'Overlord Drakuru - Script - Summon Blightblood Troll 4'), +(2899800, 9, 6, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Overlord Drakuru - Script - Say'), +(2899800, 9, 7, 0, 0, 0, 100, 0, 500, 500, 0, 0, 1, 8, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Overlord Drakuru - Script - Say'), +(2899800, 9, 8, 0, 0, 0, 100, 0, 0, 0, 0, 0, 11, 54089, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Overlord Drakuru - Script - Cast Drop Disguise'), +(2899800, 9, 9, 0, 0, 0, 100, 0, 10000, 10000, 0, 0, 1, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Overlord Drakuru - Script - Remove Scourge Disguise from Target'), +(2899800, 9, 10, 0, 0, 0, 100, 0, 0, 0, 0, 0, 19, 256, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Overlord Drakuru - Script - Set Unit Flags'), +(2899800, 9, 11, 0, 0, 0, 100, 0, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 9, 28931, 0, 200, 0, 0, 0, 0, 'Overlord Drakuru - Script - Set Data on Blightblood Troll'), +(2899800, 9, 12, 0, 0, 0, 100, 0, 0, 0, 0, 0, 2, 974, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Overlord Drakuru - Script - Set Faction'), +(2899800, 9, 13, 0, 0, 0, 100, 0, 0, 0, 0, 0, 1, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Overlord Drakuru - Script - Say'), +(2849801, 9, 0, 0, 0, 0, 100, 0, 4000, 4000, 0, 0, 1, 7, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'The Lich King - Script 2 - Say'), +(2849801, 9, 1, 0, 0, 0, 100, 0, 10000, 10000, 0, 0, 1, 8, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'The Lich King - Script 2 - Say'), +(2849801, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 11, 54236, 0, 0, 0, 0, 0, 19, 28998, 0, 0, 0, 0, 0, 0, 'The Lich King - Script 2 - Cast Touch of Death'), +(2849801, 9, 3, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 45, 1, 1, 0, 0, 0, 0, 19, 28998, 0, 0, 0, 0, 0, 0, 'The Lich King - Script 2 - Set Orientation'), +(2849801, 9, 4, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 66, 0, 0, 0, 0, 0, 0, 21, 100, 0, 0, 0, 0, 0, 0, 'The Lich King - Script 2 - Set Orientation'), +(2849801, 9, 5, 0, 0, 0, 100, 0, 0, 0, 0, 0, 1, 9, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'The Lich King - Script 2 - Say'), +(2849801, 9, 6, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 1, 10, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'The Lich King - Script 2 - Say'), +(2849801, 9, 7, 0, 0, 0, 100, 0, 12000, 12000, 0, 0, 1, 11, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'The Lich King - Script 2 - Say'), +(2849801, 9, 8, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 1, 12, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'The Lich King - Script 2 - Say'), +(2849801, 9, 9, 0, 0, 0, 100, 0, 10000, 10000, 0, 0, 53, 0, 2849801, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'The Lich King - Script 2 - Start WP Path 2'), +(2899802, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 11, 54248, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Overlord Drakuru - Script 3 - Cast Drakurus Death'), +(2899802, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 11, 54250, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Overlord Drakuru - Script 3 - Cast Drakurus Skull Missile'), +(2899802, 9, 2, 0, 0, 0, 100, 0, 1500, 1500, 0, 0, 37, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Overlord Drakuru - Script 3 - Die'), +(2899801, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 102, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Overlord Drakuru - Script 2 - Set HP Regen off'), +(2899801, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 22, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Overlord Drakuru - Script 2 - Set Phase 0'), +(2899801, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 2, 2082, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Overlord Drakuru - Script 2 - Set Faction'), +(2899801, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 24, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Overlord Drakuru - Script 2 - Evade'), +(2899801, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 1, 5, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Overlord Drakuru - Script 2 - Say'), +(2899801, 9, 5, 0, 0, 0, 100, 0, 0, 0, 0, 0, 11, 61492, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Overlord Drakuru - Script 2 - Cast Despawn Blightblood'), +(2899801, 9, 6, 0, 0, 0, 100, 0, 0, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 21, 50, 0, 0, 0, 0, 0, 0, 'Overlord Drakuru - Script 2 - Set Orientation'), +(2899801, 9, 7, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 1, 6, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Overlord Drakuru - Script 2 - Say'), +(2899801, 9, 8, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 45, 1, 1, 0, 0, 0, 0, 10, 98914, 28960, 0, 0, 0, 0, 0, 'Overlord Drakuru - Script 2 - Set Data'), +(2899801, 9, 9, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 12, 28498, 1, 90000, 0, 0, 0, 8, 0, 0, 0, 6141.839, -2011.344, 590.3961,6.040418, 'Overlord Drakuru - Script 2 - Spawn The Lich King'), +(2899801, 9, 10, 0, 0, 0, 100, 0, 0, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 19, 28498, 0, 0, 0, 0, 0, 0, 'Overlord Drakuru - Script 2 - Set Orientation'); + +DELETE FROM `waypoints` WHERE `entry` IN(2849800,2849801); + +INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES +(2849800, 1,6139.436, -2010.837, 589.1911, 'The Lich King'), +(2849800, 2,6140.423, -2010.994, 589.1911, 'The Lich King'), +(2849800, 3,6142.035, -2011.393, 590.5623, 'The Lich King'), +(2849800, 4,6143.037, -2011.641, 590.8799, 'The Lich King'), +(2849800, 5,6145.518, -2012.255, 590.8799, 'The Lich King'), +(2849800, 6,6152.936, -2014.092, 590.8787, 'The Lich King'), +(2849800, 7,6164.27, -2016.898, 590.8779, 'The Lich King'), +(2849800, 8,6164.27, -2016.898, 590.8779, 'The Lich King'), +(2849801, 1,6153.504, -2014.085, 591.119, 'The Lich King'), +(2849801, 2,6145.754, -2012.335, 591.119, 'The Lich King'), +(2849801, 3,6143.254, -2011.835, 591.119, 'The Lich King'), +(2849801, 4,6142.254, -2011.585, 590.869, 'The Lich King'); diff --git a/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_24_02_world_spell_linked_spell.sql b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_24_02_world_spell_linked_spell.sql new file mode 100644 index 00000000000..40be60f517f --- /dev/null +++ b/sql/old/3.3.5a/TDB54_to_TDB55_updates/world/2014_08_24_02_world_spell_linked_spell.sql @@ -0,0 +1,4 @@ +DELETE FROM `spell_linked_spell` WHERE `spell_effect` = 41637; +INSERT INTO `spell_linked_spell` VALUES (41635, 41637, 0, 'Prayer of Mending (rank1)'); +INSERT INTO `spell_linked_spell` VALUES (48111, 41637, 0, 'Prayer of Mending (rank3)'); +INSERT INTO `spell_linked_spell` VALUES (48112, 41637, 0, 'Prayer of Mending (rank2)'); diff --git a/sql/updates/world/2014_07_09_00_world_playercreateinfo_cast_spell_434.sql b/sql/old/4.3.4/TDB6_to_TDB7_updates/world/2014_07_09_00_world_playercreateinfo_cast_spell_434.sql index 708a16d8149..708a16d8149 100644 --- a/sql/updates/world/2014_07_09_00_world_playercreateinfo_cast_spell_434.sql +++ b/sql/old/4.3.4/TDB6_to_TDB7_updates/world/2014_07_09_00_world_playercreateinfo_cast_spell_434.sql diff --git a/sql/updates/world/2014_07_09_01_world_playercreateinfo_cast_spell_434.sql b/sql/old/4.3.4/TDB6_to_TDB7_updates/world/2014_07_09_01_world_playercreateinfo_cast_spell_434.sql index 61c240dc0b6..61c240dc0b6 100644 --- a/sql/updates/world/2014_07_09_01_world_playercreateinfo_cast_spell_434.sql +++ b/sql/old/4.3.4/TDB6_to_TDB7_updates/world/2014_07_09_01_world_playercreateinfo_cast_spell_434.sql diff --git a/sql/updates/world/2014_07_10_00_world_creature_434.sql b/sql/old/4.3.4/TDB6_to_TDB7_updates/world/2014_07_10_00_world_creature_434.sql index d38116c7767..4f05583730d 100644 --- a/sql/updates/world/2014_07_10_00_world_creature_434.sql +++ b/sql/old/4.3.4/TDB6_to_TDB7_updates/world/2014_07_10_00_world_creature_434.sql @@ -4,4 +4,4 @@ INSERT INTO `creature_template_addon` (`entry`, `mount`, `bytes1`, `bytes2`, `au DELETE FROM `creature` WHERE `id`=49044; INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `phaseId`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES -(xxxxxxx, 49044, 0, 1, 1, 0, 1700.2, 1703.361, 137.1976, 1.675516, 120, 0, 0); +(999999, 49044, 0, 1, 1, 0, 1700.2, 1703.361, 137.1976, 1.675516, 120, 0, 0); -- temp guid to "fix" travis. diff --git a/sql/updates/world/2014_07_10_01_world_lfg_dungeon_template_434.sql b/sql/old/4.3.4/TDB6_to_TDB7_updates/world/2014_07_10_01_world_lfg_dungeon_template_434.sql index 1e2b7449337..1e2b7449337 100644 --- a/sql/updates/world/2014_07_10_01_world_lfg_dungeon_template_434.sql +++ b/sql/old/4.3.4/TDB6_to_TDB7_updates/world/2014_07_10_01_world_lfg_dungeon_template_434.sql diff --git a/sql/updates/world/2014_07_13_00_world_playercreateinfo_skills_434.sql b/sql/old/4.3.4/TDB6_to_TDB7_updates/world/2014_07_13_00_world_playercreateinfo_skills_434.sql index 8320ccc5959..8320ccc5959 100644 --- a/sql/updates/world/2014_07_13_00_world_playercreateinfo_skills_434.sql +++ b/sql/old/4.3.4/TDB6_to_TDB7_updates/world/2014_07_13_00_world_playercreateinfo_skills_434.sql diff --git a/sql/updates/world/2014_07_24_04_world_pet_levelstats_434.sql b/sql/old/4.3.4/TDB6_to_TDB7_updates/world/2014_07_24_04_world_pet_levelstats_434.sql index dd0102a7a59..dd0102a7a59 100644 --- a/sql/updates/world/2014_07_24_04_world_pet_levelstats_434.sql +++ b/sql/old/4.3.4/TDB6_to_TDB7_updates/world/2014_07_24_04_world_pet_levelstats_434.sql diff --git a/sql/updates/world/2014_08_14_01_world_creature_template_434.sql b/sql/old/4.3.4/TDB6_to_TDB7_updates/world/2014_08_14_01_world_creature_template_434.sql index 9eceee48e9a..9eceee48e9a 100644 --- a/sql/updates/world/2014_08_14_01_world_creature_template_434.sql +++ b/sql/old/4.3.4/TDB6_to_TDB7_updates/world/2014_08_14_01_world_creature_template_434.sql diff --git a/sql/old/4.3.4/TDB6_to_TDB7_updates/world/2014_08_24_00_world_spell_script_names_434.sql b/sql/old/4.3.4/TDB6_to_TDB7_updates/world/2014_08_24_00_world_spell_script_names_434.sql new file mode 100644 index 00000000000..697e07dc6f4 --- /dev/null +++ b/sql/old/4.3.4/TDB6_to_TDB7_updates/world/2014_08_24_00_world_spell_script_names_434.sql @@ -0,0 +1,7 @@ +-- 53600 - Shield of the Righteous +-- Delete old (wotlk) scaling +DELETE FROM `spell_bonus_data` WHERE `entry`=53600; + +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_pal_shield_of_the_righteous'; +INSERT INTO `spell_script_names` VALUES +(53600,'spell_pal_shield_of_the_righteous'); diff --git a/sql/old/4.3.4/TDB6_to_TDB7_updates/world/2014_08_24_01_world_spell_script_names_434.sql b/sql/old/4.3.4/TDB6_to_TDB7_updates/world/2014_08_24_01_world_spell_script_names_434.sql new file mode 100644 index 00000000000..cd7ff43fd89 --- /dev/null +++ b/sql/old/4.3.4/TDB6_to_TDB7_updates/world/2014_08_24_01_world_spell_script_names_434.sql @@ -0,0 +1,2 @@ +DELETE FROM spell_script_names WHERE spell_id = 2098 AND ScriptName = 'spell_rog_serrated_blades'; +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES ('2098', 'spell_rog_serrated_blades'); diff --git a/sql/updates/world/2014_08_24_03_world_version.sql b/sql/updates/world/2014_08_24_03_world_version.sql new file mode 100644 index 00000000000..2531a982b34 --- /dev/null +++ b/sql/updates/world/2014_08_24_03_world_version.sql @@ -0,0 +1 @@ +UPDATE `version` SET `db_version`='TDB 335.55', `cache_id`=55 LIMIT 1; diff --git a/sql/updates/world/2014_08_24_04_world_conditions.sql b/sql/updates/world/2014_08_24_04_world_conditions.sql new file mode 100644 index 00000000000..6f4da23e590 --- /dev/null +++ b/sql/updates/world/2014_08_24_04_world_conditions.sql @@ -0,0 +1,17 @@ +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=9677; +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceEntry`=28217; + +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(15, 9677, 0, 0, 0, 1, 1, 51329, 0, 0, 0, 0, 0, '', 'Injured Rainspeaker Oracle only display gossip if injured rainspeaker oracle has aura Feign Death'), +(15, 9677, 0, 0, 0, 9, 0, 12540, 0, 0, 0, 0, 0, '', 'Injured Rainspeaker Oracle only display gossip if Just following orders taken'), +(15, 9677, 0, 0, 0, 8, 0, 12570, 0, 0, 1, 0, 0, '', 'Injured Rainspeaker Oracle only display gossip if Player does not have Fortunate Misunderstandings rewarded'), +(15, 9677, 0, 0, 0,28, 0, 12570, 0, 0, 1, 0, 0, '', 'Injured Rainspeaker Oracle only display gossip if Player does not have Fortunate Misunderstandings complete'), +(15, 9677, 0, 0, 1, 1, 1, 51329, 0, 0, 0, 0, 0, '', 'Injured Rainspeaker Oracle only display gossip if injured rainspeaker oracle has aura Feign Death'), +(15, 9677, 0, 0, 1, 8, 0, 12540, 0, 0, 0, 0, 0, '', 'Injured Rainspeaker Oracle only display gossip if Just following orders rewarded'), +(15, 9677, 0, 0, 1, 8, 0, 12570, 0, 0, 1, 0, 0, '', 'Injured Rainspeaker Oracle only display gossip if Player does not have Fortunate Misunderstandings rewarded'), +(15, 9677, 0, 0, 1,28, 0, 12570, 0, 0, 1, 0, 0, '', 'Injured Rainspeaker Oracle only display gossip if Player does not have Fortunate Misunderstandings complete'), +(22, 7, 28217, 0, 0, 9, 0, 12540, 0, 0, 0, 0, 0, '', 'Injured Rainspeaker Oracle - Only run SAI if player has Just Following Orders taken'), +(22, 8, 28217, 0, 0, 9, 0, 12570, 0, 0, 0, 0, 0, '', 'Injured Rainspeaker Oracle - Only run SAI if player has Fortunate Misunderstandings Taken'), +(22, 8, 28217, 0, 0, 1, 1, 51329, 0, 0, 1, 0, 0, '', 'Injured Rainspeaker Oracle - Only run SAI if Injured rainspeaker oracle does have aura - feign death'), +(22, 9, 28217, 0, 0, 16, 0, 1101, 0, 0, 0, 0, 0, '', 'Injured Rainspeaker Oracle - Only run SAI if player is Alliance'), +(22, 10, 28217, 0, 0, 16, 0, 690, 0, 0, 0, 0, 0, '', 'Injured Rainspeaker Oracle - Only run SAI if player is Horde'); diff --git a/sql/updates/world/2014_08_25_00_world_item_enchantment_template.sql b/sql/updates/world/2014_08_25_00_world_item_enchantment_template.sql new file mode 100644 index 00000000000..494d324fc0e --- /dev/null +++ b/sql/updates/world/2014_08_25_00_world_item_enchantment_template.sql @@ -0,0 +1,40 @@ +DELETE FROM `item_enchantment_template` WHERE `entry` IN (161,162,163,381,382,383,384,385); +INSERT INTO `item_enchantment_template` (`entry`, `ench`, `chance`) VALUES +(161, 79, 51.35), +(161, 83, 48.65), +(162, 80, 48.65), +(162, 83, 51.35), +(163, 80, 44.6), +(163, 83, 55.4), +(381, 68, 8.1), +(381, 71, 14.5), +(381, 72, 7.7), +(381, 73, 7.3), +(381, 75, 7.7), +(381, 78, 14.9), +(381, 79, 8.8), +(381, 83, 14.3), +(381, 84, 8.2), +(381, 85, 8.5), +(382, 69, 18.7), +(382, 79, 12.5), +(382, 82, 18.8), +(382, 83, 17.4), +(382, 84, 12.8), +(382, 85, 19.8), +(383, 71, 35.5), +(383, 78, 11.5), +(383, 79, 11), +(383, 80, 26.3), +(383, 82, 15.7), +(384, 71, 28.8), +(384, 78, 24.1), +(384, 80, 22.9), +(384, 83, 13.6), +(384, 85, 10.6), +(385, 17, 13.2), +(385, 68, 22.4), +(385, 75, 17.6), +(385, 84, 12.7), +(385, 85, 10.2), +(385, 86, 23.9); diff --git a/sql/updates/world/2014_08_25_01_world_sai.sql b/sql/updates/world/2014_08_25_01_world_sai.sql new file mode 100644 index 00000000000..493a5dbed4b --- /dev/null +++ b/sql/updates/world/2014_08_25_01_world_sai.sql @@ -0,0 +1,180 @@ + +UPDATE `creature_template` SET `ainame`='SmartAI', `scriptname`='' WHERE `entry` IN(28244,28333,28175,28176,28177,28178,28284); +DELETE FROM `smart_scripts` WHERE `entryorguid` IN(28244,28333,28175,28176,28177,28178,28284) AND `source_type`=0; +DELETE FROM `smart_scripts` WHERE `entryorguid` IN(2824400,2817500,2817600,2817700,2817800,2833300,2828400,2828401,2878000) 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 +(28284, 0, 0, 0, 20, 0, 100, 0, 12553, 0, 0, 0, 80, 2828400, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Specialist Cogwheel - On Quest Reward (Skimmer Spinnerets) - Run Script 1'), +(28284, 0, 1, 0, 20, 0, 100, 0, 12583, 0, 0, 0, 80, 2828401, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Specialist Cogwheel - On Quest Reward (Crashed Sprayer) - Run Script 2'), +(28244, 0, 0, 1, 20, 0, 100, 0, 12584, 0, 0, 0, 1, 6, 0, 0, 0, 0, 0, 19, 28178, 0, 0, 0, 0, 0, 0, 'Eitrigg - On Quest Reward (Pure Evil) - Say Line 7 on Avenger Metz'), +(28244, 0, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 53, 0, 28244, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Eitrigg - On Quest Reward (Pure Evil) - Start WP'), +(28244, 0, 2, 3, 40, 0, 100, 0, 1, 28244, 0, 0, 80, 2824400, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Eitrigg - On Reached WP2 - Run Script'), +(28244, 0, 3, 0, 61, 0, 100, 0, 0, 0, 0, 0, 54, 3000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Eitrigg - On Reached WP2 - Pause WP'), +(28244, 0, 4, 0, 40, 0, 100, 0, 3, 28244, 0, 0, 54, 100000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Eitrigg - On Reached WP3 - Pause WP'), +(28244, 0, 5, 0, 40, 0, 100, 0, 4, 28244, 0, 0, 66, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 1.56042, 'Eitrigg - On Reached WP4 - Set Orientation'), +(28175, 0, 0, 1, 38, 0, 100, 0, 1, 1, 0, 0, 66, 0, 0, 0, 0, 0, 0, 19, 28244, 0, 0, 0, 0, 0, 0, 'Crusade Commander Korfax - On Data Set 1 1 - Set Orientation'), +(28175, 0, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Crusade Commander Korfax - On Data Set 1 1 - Say Line 1'), +(28175, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 53, 0, 28175, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Crusade Commander Korfax - On Data Set 1 1 - Start WP'), +(28175, 0, 3, 0, 40, 0, 100, 0, 1, 28175, 0, 0, 80, 2817500, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Crusade Commander Korfax - On Reached WP4 - Run Script'), +(28175, 0, 4, 0, 40, 0, 100, 0, 1, 28175, 0, 0, 54, 18000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Crusade Commander Korfax - On Reached WP3 - Pause WP'), +(28175, 0, 5, 0, 40, 0, 100, 0, 5, 28175, 0, 0, 66, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 1.54325, 'Crusade Commander Korfax - On Reached WP5 - Set Orientation'), +(28176, 0, 0, 0, 38, 0, 100, 0, 1, 1, 0, 0, 80, 2817600, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Rimblat Earthshatter - On Data Set - Run Script'), +(28177, 0, 0, 0, 38, 0, 100, 0, 1, 1, 0, 0, 80, 2817700, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Rayne - On Data Set - Run Script'), +(28178, 0, 0, 0, 38, 0, 100, 0, 1, 1, 0, 0, 80, 2817800, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Avenger Metz - On Data Set - Run Script'), +(28333, 0, 0, 0, 38, 0, 100, 0, 1, 1, 0, 0, 11, 32567, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'ELM General Purpose Bunny (scale x0.25) - On Data Set 1 1 - Cast Green Banish State'), +(28333, 0, 1, 0, 38, 0, 100, 0, 2, 2, 0, 0, 28, 32567, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'ELM General Purpose Bunny (scale x0.25) - On Data Set 2 2 - Remove Green Banish State'), +(28333, 0, 2, 0, 38, 0, 100, 0, 3, 3, 0, 0, 11, 51367, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'ELM General Purpose Bunny (scale x0.25) - On Data Set 3 3 - Cast Pure Evil: Entangling Roots Visual'), +(28333, 0, 3, 4, 38, 0, 100, 0, 4, 4, 0, 0, 28, 51367, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'ELM General Purpose Bunny (scale x0.25) - On Data Set 4 4 - Remove Pure Evil: Entangling Roots Visual'), +(28333, 0, 4, 0, 61, 0, 100, 0, 4, 4, 0, 0, 11, 35487, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'ELM General Purpose Bunny (scale x0.25) - On Data Set 4 4 - Cast Seed of Revitalization Lightning Cloud Visual'), +(28333, 0, 5, 0, 38, 0, 100, 0, 5, 5, 0, 0, 80, 2833300, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'ELM General Purpose Bunny (scale x0.25) - On Data Set 5 5 - Run Script'), +(2878000, 9, 0, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Explosive Charges Bunny - On Script - Say Line 0'), +(2878000, 9, 1, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Explosive Charges Bunny - On Script - Say Line 1'), +(2878000, 9, 2, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 1, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Explosive Charges Bunny - On Script - Say Line 2'), +(2878000, 9, 3, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 1, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Explosive Charges Bunny - On Script - Say Line 3'), +(2878000, 9, 4, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 1, 4, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Explosive Charges Bunny - On Script - Say Line 4'), +(2878000, 9, 5, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 11, 52322, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Explosive Charges Bunny - On Script - Cast \'Detonate Charges\''), +(2878000, 9, 6, 0, 0, 0, 100, 0, 0, 0, 0, 0, 11, 52346, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Explosive Charges Bunny - On Script - Cast \'Kill Credit\''), +(2828400, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0,0, 1, 0, 0, 0, 0, 0, 0, 0, 'Specialist Cogwheel - Script 1 - Say Line 0'), +(2828400, 9, 1, 0, 0, 0, 100, 0, 6000, 6000, 0, 0, 11, 51322, 0, 0, 0, 0,0, 1, 0, 0, 0, 0, 0, 0, 0, 'Specialist Cogwheel - Script 1 - Cast Webbed'), +(2828400, 9, 2, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 1, 1, 0, 0, 0, 0,0, 1, 0, 0, 0, 0, 0, 0, 0, 'Specialist Cogwheel - Script 1 - Say Line 1'), +(2828400, 9, 3, 0, 0, 0, 100, 0, 10000, 10000, 0, 0, 28, 51322, 0, 0, 0, 0,0, 1, 0, 0, 0, 0, 0, 0, 0, 'Specialist Cogwheel - Script 1 - Remove Aura - Webbed'), +(2828401, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 1, 2, 0, 0, 0, 0,0, 1, 0, 0, 0, 0, 0, 0, 0, 'Specialist Cogwheel - Script 2 - Say Line 2'), +(2828401, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 5, 233, 0, 0, 0, 0,0, 1, 0, 0, 0, 0, 0, 0, 0, 'Specialist Cogwheel - Script 2 - Play emote 233'), +(2828401, 9, 2, 0, 0, 0, 100, 0, 7000, 7000, 0, 0, 1, 3, 0, 0, 0, 0,0, 1, 0, 0, 0, 0, 0, 0, 0, 'Specialist Cogwheel - Script 2 - Say Line 3'), +(2833300, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 11, 51394, 0, 0, 0, 0,0, 1, 0, 0, 0, 0, 0, 0, 0, 'ELM General Purpose Bunny (scale x0.25) - Script - Cast Decimate State'), +(2833300, 9, 1, 0, 0, 0, 100, 0, 6000, 6000, 0, 0, 11, 51393, 0, 0,0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'ELM General Purpose Bunny (scale x0.25) - Script - Cast Pure Evil: Saronite Knockback'), +(2833300, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 28, 51394, 0, 0, 0, 0,0, 1, 0, 0, 0, 0, 0, 0, 0, 'ELM General Purpose Bunny (scale x0.25) - Script - Remove Decimate State'), +(2817500, 9, 0, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 1, 1, 0, 0, 0, 0,0, 1, 0, 0, 0, 0, 0, 0, 0, 'Crusade Commander Korfax - Script - Say Line 2'), +(2817500, 9, 1, 0, 0, 0, 100, 0, 6000, 6000, 0, 0, 1, 2, 0, 0, 0, 0,0, 1, 0, 0, 0, 0, 0, 0, 0, 'Crusade Commander Korfax - Script - Say Line 3'), +(2817500, 9, 2, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 11, 51396, 0, 0, 0,0, 0, 19, 28333, 0, 0, 0, 0, 0, 0, 'Crusade Commander Korfax - Script - Cast Pure Evil: Korfaxs Cleave'), +(2817500, 9, 3, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 11, 51396, 0, 0, 0,0, 0, 19, 28333, 0, 0, 0, 0, 0, 0, 'Crusade Commander Korfax - Script - Cast Pure Evil: Korfaxs Cleave'), +(2817500, 9, 4, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 11, 51396, 0, 0, 0,0, 0, 19, 28333, 0, 0, 0, 0, 0, 0, 'Crusade Commander Korfax - Script - Cast Pure Evil: Korfaxs Cleave'), +(2817500, 9, 5, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 1, 3, 0, 0, 0, 0,0, 1, 0, 0, 0, 0, 0, 0, 0, 'Crusade Commander Korfax - Script - Say Line 3'), +(2817600, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 11, 51380, 0, 0, 0, 0,0, 10, 112373, 28333, 0, 0, 0, 0, 0, 'Rimblat Earthshatter - Script - Cast Lightning & Ice Channeling'), +(2817600, 9, 1, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 28, 51380, 0, 0, 0,0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Rimblat Earthshatter - Script - Remove Lightning & Ice Channeling'), +(2817600, 9, 2, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 1, 1, 0, 0, 0, 0,0, 1, 0, 0, 0, 0, 0, 0, 0, 'Rimblat Earthshatter - Script - Say Line'), +(2817700, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 11, 28892, 0, 0, 0, 0,0, 10, 112373, 28333, 0, 0, 0, 0, 0, 'Rayne - Script - Cast Nature Channeling'), +(2817700, 9, 1, 0, 0, 0, 100, 0, 500, 500, 0, 0, 45, 3, 3, 0, 0, 0,0, 10, 112373, 28333, 0, 0, 0, 0, 0, 'Rayne - Script - Set Data 3 3 ELM General Purpose Bunny (scale x0.25)'), +(2817700, 9, 2, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 28, 28892, 0, 0,0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Rayne - Script - Remove Nature Channeling'), +(2817700, 9, 3, 0, 0, 0, 100, 0, 100, 100, 0, 0, 45, 4, 4, 0, 0, 0,0, 10, 112373, 28333, 0, 0, 0, 0, 0, 'Rayne - Script - Set Data 4 4 ELM General Purpose Bunny (scale x0.25)'), +(2817700, 9, 4, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 1, 0, 0, 0, 0, 0,0, 1, 0, 0, 0, 0, 0, 0, 0, 'Rayne - Script - Say Line'), +(2817800, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 1, 3, 0, 0, 0, 0,0, 1, 0, 0, 0, 0, 0, 0, 0, 'Avenger Metz - Script - Say Line 4'), +(2817800, 9, 1, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 66, 0, 0, 0, 0, 0,0, 19, 28333, 0, 0, 0, 0, 0, 0, 'Avenger Metz - Script - Set Orientation'), +(2817800, 9, 2, 0, 0, 0, 100, 0, 500, 500, 0, 0, 11, 51384, 0, 0, 0, 0,0, 19, 28333, 0, 0, 0, 0, 0, 0, 'Avenger Metz - Script - Cast Hammer of Wrath'), +(2817800, 9, 4, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 45, 5, 5, 0, 0, 0,0, 10, 112373, 28333, 0, 0, 0, 0, 0, 'Rayne - Script - Set Data 5 5 ELM General Purpose Bunny (scale x0.25)'), +(2817800, 9, 5, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 1, 4, 0, 0, 0, 0,0, 1, 0, 0, 0, 0, 0, 0, 0, 'Avenger Metz - Script - Say Line 5'), +(2824400, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0,0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Eitrigg - Script - Say Line 1'), +(2824400, 9, 1, 0, 0, 0, 100, 0, 500, 500, 0, 0, 45, 1, 1, 0,0, 0, 0, 10, 112373, 28333, 0, 0, 0, 0, 0, 'Eitrigg - Script - Set Data 1 1 ELM General Purpose Bunny (scale x0.25)'), +(2824400, 9, 2, 0, 0, 0, 100, 0, 6000, 6000, 0, 0, 1, 1, 0, 0,0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Eitrigg - Script - Say Line 2'), +(2824400, 9, 3, 0, 0, 0, 100, 0, 6000, 6000, 0, 0, 45, 1, 1, 0,0, 0, 0, 19, 28175, 0, 0, 0, 0, 0, 0, 'Eitrigg - Script - Set Data 1 1 on Crusade Commander Korfax'), +(2824400, 9, 4, 0, 0, 0, 100, 0, 16000, 16000, 0, 0, 1, 0, 0, 0, 0,0, 0, 19, 28178, 0, 0, 0, 0, 0, 0, 'Eitrigg - Script - Say Line 1 on Avenger Metz'), +(2824400, 9, 5, 0, 0, 0, 100, 0, 17000, 17000, 0, 0, 1, 2, 0, 0, 0,0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Eitrigg - Script - Say Line 3'), +(2824400, 9, 6, 0, 0, 0, 100, 0, 6000, 6000, 0, 0, 1, 0, 0, 0, 0, 0,0, 19, 28176, 0, 0, 0, 0, 0, 0, 'Eitrigg - Script - Say Line on Rimblat Earthshatter'), +(2824400, 9, 7, 0, 0, 0, 100, 0, 6000, 6000, 0, 0, 45, 1, 1, 0, 0, 0,0, 19, 28176, 0, 0, 0, 0, 0, 0, 'Eitrigg - Script - Set Data on Rimblat Earthshatter'), +(2824400, 9, 8, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 45, 1, 1, 0, 0, 0,0, 19, 28177, 0, 0, 0, 0, 0, 0, 'Eitrigg - Script - Set Data on Rayne'), +(2824400, 9, 9, 0, 0, 0, 100, 0, 8000, 8000, 0, 0, 1, 1, 0, 0, 0, 0,0, 19, 28178, 0, 0, 0, 0, 0, 0, 'Eitrigg - Script - Say Line 2 on Avenger Metz'), +(2824400, 9, 10, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 1, 3, 0, 0, 0, 0,0, 1, 0, 0, 0, 0, 0, 0, 0, 'Eitrigg - Script - Say Line 4'), +(2824400, 9, 11, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 1, 2, 0, 0, 0, 0,0, 19, 28178, 0, 0, 0, 0, 0, 0, 'Eitrigg - Script - Say Line 3 on Avenger Metz'), +(2824400, 9, 12, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 1, 4, 0, 0, 0, 0,0, 1, 0, 0, 0, 0, 0, 0, 0, 'Eitrigg - Script - Say Line 5'), +(2824400, 9, 13, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 45, 1, 1, 0, 0, 0,0, 19, 28178, 0, 0, 0, 0, 0, 0, 'Eitrigg - Script - Set Data on Avenger Metz'), +(2824400, 9, 14, 0, 0, 0, 100, 0, 11000, 11000, 0, 0, 1, 4, 0, 0, 0, 0,0, 19, 28175, 0, 0, 0, 0, 0, 0, 'Eitrigg - Script - Say Line 5 on Crusade Commander Korfax'), +(2824400, 9, 15, 0, 0, 0, 100, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0,0, 19, 28177, 0, 0, 0, 0, 0, 0, 'Eitrigg - Script - Say Line 2 on Rayne'), +(2824400, 9, 16, 0, 0, 0, 100, 0, 0, 0, 0, 0, 1, 5, 0, 0, 0, 0,0, 19, 28178, 0, 0, 0, 0, 0, 0, 'Eitrigg - Script - Say Line 6 on Avenger Metz'), +(2824400, 9, 17, 0, 0, 0, 100, 0, 6000, 6000, 0, 0, 1, 5, 0, 0,0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Eitrigg - Script - Say Line 6'), +(2824400, 9, 18, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 1, 6, 0, 0,0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Eitrigg - Script - Say Line 7'), +(2824400, 9, 19, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 1, 7, 0, 0,0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Eitrigg - Script - Say Line 8'), +(2824400, 9, 20, 0, 0, 0, 100, 0, 0, 0, 0, 0, 1, 6, 0, 0, 0, 0,0, 19, 28178, 0, 0, 0, 0, 0, 0, 'Eitrigg - Script - Say Line 6 on Avenger Metz'), +(2824400, 9, 21, 0, 0, 0, 100, 0, 500, 500, 0, 0, 45, 2, 2, 0,0, 0, 0, 10, 112373, 28333, 0, 0, 0, 0, 0, 'Eitrigg - Script - Set Data 2 2 ELM General Purpose Bunny (scale x0.25)'); + +DELETE FROM `creature_text` WHERE `entry` IN(28176,28175,28177,28178,28244,28284,28780,28479,28514,28515,28516,28517); +INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`, `BroadcastTextID`) VALUES +(28479, 0, 0, 'Gods of old, we beseech you. What must we do? How can we save the gods of this land?', 15, 0, 100, 6, 0, 0, 'Witch Doctor Khufu',28431), +(28514, 0, 0, 'But try they must or all will be lost. The Drakkari will be the death of both themselves and their gods!', 12, 0, 100, 0, 0, 473, 'Nalorakk',28435), +(28515, 0, 0, 'The spotted one must be sought. Their fates are entwined.', 12, 0, 100, 0, 0, 9919, 'Jan''alai',28432), +(28516, 0, 0, 'But she is chained. A way must be found to free her.', 12, 0, 100, 0, 0, 12196, 'Akil''zon',28433), +(28517, 0, 0, 'To her altar this mortal must travel. What they must do will not be easy. In the end it may prove impossible.', 12, 0, 100, 0, 0, 643, 'Halazzi',28434), +(28176, 0, 0, 'Let us see if it is truly impervious.', 12, 0, 100, 1, 0, 0, 'Rimblat Earthshatter',27783), +(28176, 1, 0, 'Nothing.', 12, 0, 100, 1, 0, 0, 'Rimblat Earthshatter',27766), +(28175, 0, 0, 'Saronite you say?', 12, 0, 100, 0, 0, 0, 'Crusade Commander Korfax',27779), +(28175, 1, 0, 'Never heard of it. Looks like pure evil.', 12, 0, 100, 6, 0, 0, 'Crusade Commander Korfax',27748), +(28175, 2, 0, 'Let''s see how it holds up to the might of my axe!', 12, 0, 100, 0, 0, 0, 'Crusade Commander Korfax',27749), +(28175, 3, 0, 'What the? My reaper didn''t even scratch it! That''s the toughest ore I''ve ever seen!', 12, 0, 100, 0, 0, 0, 'Crusade Commander Korfax',27750), +(28175, 4, 0, 'Oof!', 12, 0, 100, 0, 0, 9410, 'Crusade Commander Korfax',27788), +(28177, 0, 0, 'By the Goddess. It''s as if Nature can''t touch it!', 12, 0, 100, 5, 0, 0, 'Rayne',27763), +(28177, 1, 0, 'Gah!', 12, 0, 100, 0, 0, 9410, 'Rayne',27786), +(28178, 0, 0, '%s rolls his eyes.', 16, 0, 100, 0, 0, 0, 'Avenger Metz',27784), +(28178, 1, 0, 'No surprise there.', 12, 0, 100, 0, 0, 0, 'Avenger Metz',27769), +(28178, 2, 0, 'What?', 12, 0, 100, 0, 0, 0, 'Avenger Metz',27770), +(28178, 3, 0, 'Fine. Just remember though, the power of the Holy Light isn''t something to be invoked casually, brother.', 12, 0, 100, 1, 0, 0, 'Avenger Metz',27771), +(28178, 4, 0, 'What''s it doing?!', 12, 0, 100, 5, 0, 0, 'Avenger Metz',27772), +(28178, 5, 0, 'Whoa!', 12, 0, 100, 0, 0, 9410, 'Avenger Metz',27787), +(28178, 6, 0, '%s grunts.', 16, 0, 100, 0, 0, 0, 'Avenger Metz',27776), +(28244, 0, 0, 'Now we will see why this ore is so important to the Scourge.', 12, 0, 100, 16, 0, 0, 'Eitrigg',27746), +(28244, 1, 0, 'Korfax, what can you tell from this saronite?', 12, 0, 100, 6, 0, 0, 'Eitrigg',27747), +(28244, 2, 0, 'Rayne, Rimblat, what about the power of nature and the elements?', 12, 0, 100, 6, 0, 0, 'Eitrigg',27759), +(28244, 3, 0, 'Metz?', 12, 0, 100, 6, 0, 0, 'Eitrigg',27767), +(28244, 4, 0, 'You know what.', 12, 0, 100, 25, 0, 0, 'Eitrigg',27768), +(28244, 5, 0, '%s dusts himself off.', 16, 0, 100, 0, 0, 9410, 'Eitrigg',27789), +(28244, 6, 0, 'Clearly this is getting us nowhere. We need to get this saronite to Highlord Fordring for further study.', 12, 0, 100, 1, 0, 0, 'Eitrigg',27774), +(28244, 7, 0, 'Thank you for trying, my friends. We''ll unlock its secrets. Hopefully before it''s too late.', 12, 0, 100, 1, 0, 0, 'Eitrigg',27775), +(28284, 0, 0, 'Oh, these are sticky! I wonder how they shoot the webbing?', 12, 0, 100, 0, 0, 0, 'Specialist Cogwheel',27734), +(28284, 1, 0, 'ACK! Oh no, I webbed myself! It''s sticky. MY HAIR!', 12, 0, 100, 15, 0, 6906, 'Specialist Cogwheel',27735), +(28284, 2, 0, 'Okay! Let me just see if I can fashion these disgusting parts into something useful.', 12, 0, 100, 0, 0, 0, 'Specialist Cogwheel',27736), +(28284, 3, 0, 'Eureka!', 12, 0, 100, 4, 0, 0, 'Specialist Cogwheel',27737), +(28780, 0, 0, 'Explosive Charges will detonate in 5 seconds...', 16, 0, 100, 0, 0, 0, 'Explosive Charges Bunny',28816), +(28780, 1, 0, 'Explosive Charges will detonate in 4 seconds...', 16, 0, 100, 0, 0, 0, 'Explosive Charges Bunny',28817), +(28780, 2, 0, 'Explosive Charges will detonate in 3 seconds...', 16, 0, 100, 0, 0, 0, 'Explosive Charges Bunny',28818), +(28780, 3, 0, 'Explosive Charges will detonate in 2 seconds...', 16, 0, 100, 0, 0, 0, 'Explosive Charges Bunny',28819), +(28780, 4, 0, 'Explosive Charges will detonate in 1 seconds...', 16, 0, 100, 0, 0, 0, 'Explosive Charges Bunny',28820); + +DELETE FROM `waypoints` WHERE `entry` IN(28175,28244); + +INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES +(28175, 1,5448.54, -2645.614, 305.619, 'Crusade Commander Korfax'), +(28175, 2,5448.541, -2644.614, 305.619, 'Crusade Commander Korfax'), +(28175, 3,5448.541, -2643.614, 305.869, 'Crusade Commander Korfax'), +(28175, 4,5448.541, -2642.114, 306.119, 'Crusade Commander Korfax'), +(28175, 5,5448.66, -2639.83, 306.551, 'Crusade Commander Korfax'), +(28244, 1,5450.109, -2642.323, 306.6346, 'Eitrigg'), +(28244, 2,5450.109, -2643.323, 306.1346, 'Eitrigg'), +(28244, 3,5450.109, -2644.573, 305.8846, 'Eitrigg'), +(28244, 4,5450.15, -2639.06, 306.551, 'Eitrigg'); + +DELETE FROM `spell_scripts` WHERE `id`=51862; +INSERT INTO `spell_scripts` (`id`,`effIndex`,`delay`,`command`,`datalong`,`datalong2`,`dataint`,`x`,`y`,`z`,`o`) VALUES +(51862,0,0,15,51861,0,0,0,0,0,0), +(51862,0,0,15,52452,0,0,0,0,0,0), +(51862,0,0,15,52453,0,0,0,0,0,0), +(51862,0,0,15,52454,0,0,0,0,0,0); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry` IN (51861,52452,52453,52454); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(13,1,51861,0,0,31,0,3,23837,98547,0,0,'','Spell Breaking Through Jin''Alai: Summon Akil''zon targets ELM General Purpose Bunny'), +(13,1,52452,0,0,31,0,3,23837,98549,0,0,'','Spell Breaking Through Jin''Alai: Summon Jan''Alai targets ELM General Purpose Bunny'), +(13,1,52453,0,0,31,0,3,23837,98546,0,0,'','Spell Breaking Through Jin''Alai: Summon Halazzi targets ELM General Purpose Bunny'), +(13,1,52454,0,0,31,0,3,23837,98548,0,0,'','Spell Breaking Through Jin''Alai: Summon Nalorakk targets ELM General Purpose Bunny'); + +DELETE FROM `creature_template_addon` WHERE `entry` IN (28514,28515,28516,28517); +INSERT INTO `creature_template_addon` (`entry`,`bytes1`,`bytes2`) VALUES +(28514,0,1), +(28515,0,1), +(28516,33554432,1), +(28517,0,1); + +UPDATE `creature_template` SET `minlevel`=83, `maxlevel`=83, `unit_flags`=512|256 WHERE `entry` IN (28514,28515,28516,28517); +UPDATE `creature_template` SET `AIName`='SmartAI', `ScriptName`='' WHERE `entry` IN(28479,28514,28515,28516,28517); +DELETE FROM `smart_scripts` WHERE `entryorguid` =28479 AND `source_type`=0 AND `id` IN (6,7); +DELETE FROM `smart_scripts` WHERE `entryorguid` IN(28514,28515,28516,28517) AND `source_type`=0; +DELETE FROM `smart_scripts` WHERE `entryorguid` =2847900 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 +(28479, 0, 6, 7, 20, 0, 100, 0, 12627, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Witch Doctor Khufu - On Quest Reward (Breaking Through Jin''Alai) - Say'), +(28479, 0, 7, 0, 61, 0, 100, 0, 0, 0, 0, 0, 80, 2847900, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Witch Doctor Khufu - On Quest Reward (Breaking Through Jin''Alai) - Run Script'), +(28514, 0, 0, 0, 54, 0, 100, 0, 0, 0, 0, 0, 11, 35426, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Nalorakk - On Just Summoned - Cast Arcane Explosion Visual'), +(28515, 0, 0, 0, 54, 0, 100, 0, 0, 0, 0, 0, 11, 35426, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Jan''alai - On Just Summoned - Cast Arcane Explosion Visual'), +(28516, 0, 0, 0, 54, 0, 100, 0, 0, 0, 0, 0, 11, 35426, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Akil''zon - On Just Summoned - Cast Arcane Explosion Visual'), +(28517, 0, 0, 0, 54, 0, 100, 0, 0, 0, 0, 0, 11, 35426, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Halazzi - On Just Summoned - Cast Arcane Explosion Visual'), +(2847900, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 81, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Witch Doctor Khufu - Script - Set NPC Flags'), +(2847900, 9, 5, 0, 0, 0, 100, 0, 10000, 10000, 0, 0, 1, 0, 0, 0, 0, 0, 0, 19, 28515, 0, 0, 0, 0, 0, 0, 'Witch Doctor Khufu - Script - Say Line (Jan alai)'), +(2847900, 9, 6, 0, 0, 0, 100, 0, 10000, 10000, 0, 0, 1, 0, 0, 0, 0, 0, 0, 19, 28516, 0, 0, 0, 0, 0, 0, 'Witch Doctor Khufu - Script - Say Line (Akil zon)'), +(2847900, 9, 7, 0, 0, 0, 100, 0, 10000, 10000, 0, 0, 1, 0, 0, 0, 0, 0, 0, 19, 28517, 0, 0, 0, 0, 0, 0, 'Witch Doctor Khufu - Script - Say Line (Halazzi)'), +(2847900, 9, 8, 0, 0, 0, 100, 0, 10000, 10000, 0, 0, 1, 0, 0, 0, 0, 0, 0, 19, 28514, 0, 0, 0, 0, 0, 0, 'Witch Doctor Khufu - Script - Say Line (Nalorakk)'), +(2847900, 9, 9, 0, 0, 0, 100, 0, 20000, 20000, 0, 0, 81, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Witch Doctor Khufu - Script - Set NPC Flags'); diff --git a/sql/updates/world/2014_08_25_02_world_sai.sql b/sql/updates/world/2014_08_25_02_world_sai.sql new file mode 100644 index 00000000000..2f31e348b53 --- /dev/null +++ b/sql/updates/world/2014_08_25_02_world_sai.sql @@ -0,0 +1,4 @@ +UPDATE `gameobject_template` SET `AIName`='SmartGameObjectAI' WHERE `entry`=190590; +DELETE FROM `smart_scripts` WHERE `entryorguid`=190590 AND `source_type`=1; +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 +(190590,1,0,0,70,0,100,0,2,0,0,0,70,60,0,0,0,0,0,1,0,0,0,0,0,0,0,'Unstable Explosives - On State Changed - Despawn for 60 sec'); diff --git a/sql/updates/world/2014_08_26_00_world_sai.sql b/sql/updates/world/2014_08_26_00_world_sai.sql new file mode 100644 index 00000000000..4c54d91a75b --- /dev/null +++ b/sql/updates/world/2014_08_26_00_world_sai.sql @@ -0,0 +1,4 @@ +UPDATE `smart_scripts` SET `event_flags`=0 WHERE `entryorguid`=5261 AND `source_type`=0 AND `id`=0; +UPDATE `smart_scripts` SET `event_flags`=0 WHERE `entryorguid`=5263 AND `source_type`=0 AND `id`=0; +UPDATE `smart_scripts` SET `event_flags`=0 WHERE `entryorguid`=5269 AND `source_type`=0 AND `id`IN(0,1,2); +UPDATE `smart_scripts` SET `event_flags`=1 WHERE `entryorguid`=5269 AND `source_type`=0 AND `id`IN(3); diff --git a/sql/updates/world/2014_08_26_01_world_spelldifficulty_dbc.sql b/sql/updates/world/2014_08_26_01_world_spelldifficulty_dbc.sql new file mode 100644 index 00000000000..90f327312ce --- /dev/null +++ b/sql/updates/world/2014_08_26_01_world_spelldifficulty_dbc.sql @@ -0,0 +1,52 @@ +DELETE FROM `spelldifficulty_dbc` WHERE `spellid0` IN (68186,28783,28785,28796,28794,28798,28732,29317,29865,29204,29484,28741,28776,54123,41926,56908,56910,28134,28135,28167,63018,63024,65737,64203,64227,57570,57579,57581,33783,56891,56926,34659,34653,30926,52429,52387,36705,48380,50988,51012,51136,58459,58462,58463,58456,58455,58458,58457,60181,60182); +INSERT INTO `spelldifficulty_dbc` (`id`,`spellid0`,`spellid1`) VALUES +(68186,68186,68515), +(28783,28783,56090), +(28785,28785,54021), +(28796,28796,54098), +(28794,28794,54099), +(28798,28798,54100), +(28732,28732,54097), +(29317,29317,56405), +(29865,29865,55053), +(29204,29204,55052), +(29484,29484,54125), +(28741,28741,54122), +(28776,28776,54121), +(54123,54123,54124), +(41926,41926,59192), +(56908,56908,58956), +(56910,56910,58957), +(28134,28134,54529), +(28135,28135,54528), +(28167,28167,54531), +(63018,63018,65121), +(63024,63024,64234), +(65737,65737,64193), +(64203,64203,64235), +(64227,64227,64236), +(57570,57570,59126), +(57579,57579,59127), +(57581,57581,59128), +(33783,33783,39364), +(56891,56891,60032), +(56926,56926,60029), +(34659,34659,39131), +(34653,34653,36920), +(30926,30926,36921), +(52429,52429,59527), +(52387,52387,59528), +(36705,36705,39133), +(48380,48380,59320), +(50988,50988,59870), +(51012,51012,59868), +(51136,51136,59867), +(58459,58459,59256), +(58462,58462,59257), +(58463,58463,59258), +(58456,58456,59248), +(58455,58455,59245), +(58458,58458,59253), +(58457,58457,59251), +(60181,60181,60204), +(60182,60182,60205); diff --git a/sql/updates/world/2014_08_26_02_world_skill_fishing_base_level.sql b/sql/updates/world/2014_08_26_02_world_skill_fishing_base_level.sql new file mode 100644 index 00000000000..a59fecf04d6 --- /dev/null +++ b/sql/updates/world/2014_08_26_02_world_skill_fishing_base_level.sql @@ -0,0 +1,4 @@ +-- Add skill_fishing_base_level -20 to Undercity, based on other capital cities +DELETE FROM `skill_fishing_base_level` WHERE `entry`=1497; +INSERT INTO `skill_fishing_base_level` (`entry`, `skill`) VALUES +(1497, -20); diff --git a/sql/updates/world/2014_08_26_04_world_sai.sql b/sql/updates/world/2014_08_26_04_world_sai.sql new file mode 100644 index 00000000000..6a7a1ba87b7 --- /dev/null +++ b/sql/updates/world/2014_08_26_04_world_sai.sql @@ -0,0 +1,17 @@ +UPDATE `smart_scripts` SET `action_param2`=77 WHERE `entryorguid`=3019000 AND `source_type`=9 AND `id`=2; +UPDATE `smart_scripts` SET `action_param2`=30 WHERE `entryorguid`=2856608 AND `source_type`=9 AND `id`=1; +UPDATE `smart_scripts` SET `action_param2`=20 WHERE `entryorguid`=1814200 AND `source_type`=9 AND `id` IN(0,3,4,5); +UPDATE `smart_scripts` SET `action_param2`=20 WHERE `entryorguid`=1814300 AND `source_type`=9 AND `id` IN(0,1,2,4,5); +UPDATE `smart_scripts` SET `action_param2`=20 WHERE `entryorguid`=1814400 AND `source_type`=9 AND `id` IN(0,2,3,4); +UPDATE `smart_scripts` SET `action_param2`=20 WHERE `entryorguid`=1811000 AND `source_type`=9 AND `id` IN(0,1,2,3,4,5,6); +UPDATE `smart_scripts` SET `action_param2`=60 WHERE `entryorguid`=24170 AND `source_type`=0 AND `id`=0; +UPDATE `smart_scripts` SET `action_param2`=60 WHERE `entryorguid`=177490 AND `source_type`=1 AND `id` IN(0,2); +UPDATE `smart_scripts` SET `action_param2`=42 WHERE `entryorguid`=3327300 AND `source_type`=9 AND `id`=0; +UPDATE `smart_scripts` SET `action_param2`=20 WHERE `entryorguid`=3327300 AND `source_type`=9 AND `id`=5; +UPDATE `smart_scripts` SET `action_param2`=30 WHERE `entryorguid`=3249702 AND `source_type`=9 AND `id`=0; +UPDATE `smart_scripts` SET `action_param2`=30 WHERE `entryorguid` IN(3249700,3249701) AND `source_type`=9 AND `id`=0; +UPDATE `smart_scripts` SET `action_param2`=120 WHERE `entryorguid` IN(2397400,2397401,2397402,2397403) AND `source_type`=9 AND `id`=0; +UPDATE `smart_scripts` SET `action_param2`=30 WHERE `entryorguid`=21926 AND `source_type`=0 AND `id`=0; +UPDATE `smart_scripts` SET `action_param2`=60 WHERE `entryorguid`=3685607 AND `source_type`=9 AND `id`=4; +UPDATE `smart_scripts` SET `action_param2`=4 WHERE `entryorguid`=15951 AND `source_type`=0 AND `id`=0; +UPDATE `smart_scripts` SET `action_param2`=60 WHERE `entryorguid`=20226 AND `source_type`=0 AND `id`=1; |