From 8adcd1e93b2499dd70eca5d19cd96bd4beeda11d Mon Sep 17 00:00:00 2001 From: Kudlaty Date: Wed, 10 Jun 2009 23:58:57 +0200 Subject: Fix *nix problem with ( and ) in sql file name --HG-- branch : trunk --- .../3263_world_scripts_#missing_in_full.sql | 14 +++ .../3263_world_scripts_(missing in full).sql | 14 --- sql/updates/3427_world_scripts_#naxx.sql | 113 +++++++++++++++++++++ sql/updates/3427_world_scripts_(naxx).sql | 113 --------------------- sql/updates/3466_world_scripts_#wintergrasp.sql | 19 ++++ sql/updates/3466_world_scripts_(wintergrasp).sql | 19 ---- sql/updates/3467_world_spellclick_#dk.sql | 8 ++ sql/updates/3467_world_spellclick_(dk).sql | 8 -- sql/updates/3592_world_spell_#dk.sql | 8 ++ sql/updates/3592_world_spell_(dk).sql | 8 -- sql/updates/3593_world_spellclick_#dk.sql | 4 + sql/updates/3593_world_spellclick_(dk).sql | 4 - sql/updates/3612_world_spell_#dk.sql | 4 + sql/updates/3612_world_spell_(dk).sql | 4 - sql/updates/3643_world_#wintergrasp.sql | 12 +++ sql/updates/3643_world_(wintergrasp).sql | 12 --- sql/updates/3736_world_spell_#dk.sql | 3 + sql/updates/3736_world_spell_(dk).sql | 3 - sql/updates/3813_world_spell_#dk.sql | 10 ++ sql/updates/3813_world_spell_(dk).sql | 10 -- sql/updates/3856_world_spell_#naxx.sql | 9 ++ sql/updates/3856_world_spell_(naxx).sql | 9 -- sql/updates/3873_world_spell_#dk.sql | 25 +++++ sql/updates/3873_world_spell_(dk).sql | 25 ----- sql/updates/3886_world_script_#nexus.sql | 80 +++++++++++++++ sql/updates/3886_world_script_(nexus).sql | 80 --------------- 26 files changed, 309 insertions(+), 309 deletions(-) create mode 100644 sql/updates/3263_world_scripts_#missing_in_full.sql delete mode 100644 sql/updates/3263_world_scripts_(missing in full).sql create mode 100644 sql/updates/3427_world_scripts_#naxx.sql delete mode 100644 sql/updates/3427_world_scripts_(naxx).sql create mode 100644 sql/updates/3466_world_scripts_#wintergrasp.sql delete mode 100644 sql/updates/3466_world_scripts_(wintergrasp).sql create mode 100644 sql/updates/3467_world_spellclick_#dk.sql delete mode 100644 sql/updates/3467_world_spellclick_(dk).sql create mode 100644 sql/updates/3592_world_spell_#dk.sql delete mode 100644 sql/updates/3592_world_spell_(dk).sql create mode 100644 sql/updates/3593_world_spellclick_#dk.sql delete mode 100644 sql/updates/3593_world_spellclick_(dk).sql create mode 100644 sql/updates/3612_world_spell_#dk.sql delete mode 100644 sql/updates/3612_world_spell_(dk).sql create mode 100644 sql/updates/3643_world_#wintergrasp.sql delete mode 100644 sql/updates/3643_world_(wintergrasp).sql create mode 100644 sql/updates/3736_world_spell_#dk.sql delete mode 100644 sql/updates/3736_world_spell_(dk).sql create mode 100644 sql/updates/3813_world_spell_#dk.sql delete mode 100644 sql/updates/3813_world_spell_(dk).sql create mode 100644 sql/updates/3856_world_spell_#naxx.sql delete mode 100644 sql/updates/3856_world_spell_(naxx).sql create mode 100644 sql/updates/3873_world_spell_#dk.sql delete mode 100644 sql/updates/3873_world_spell_(dk).sql create mode 100644 sql/updates/3886_world_script_#nexus.sql delete mode 100644 sql/updates/3886_world_script_(nexus).sql (limited to 'sql') diff --git a/sql/updates/3263_world_scripts_#missing_in_full.sql b/sql/updates/3263_world_scripts_#missing_in_full.sql new file mode 100644 index 00000000000..942ffd1ccfd --- /dev/null +++ b/sql/updates/3263_world_scripts_#missing_in_full.sql @@ -0,0 +1,14 @@ +UPDATE creature_template SET ScriptName='npc_kingdom_of_dalaran_quests' WHERE entry IN (29169,23729,26673,27158,29158,29161,26471,29155,29159,29160,29162); +UPDATE `creature_template` SET `ScriptName` = 'boss_elder_nadox' WHERE `entry` = 29309; +UPDATE `creature_template` SET `ScriptName` = 'mob_ahnkahar_nerubian' WHERE `entry` in (30176,30178); +UPDATE `instance_template` SET `script`= 'instance_ahnkahet' WHERE `map` = 619; +update creature_template set scriptname = 'mob_parasitic_shadowfiend' where entry = 23498; +UPDATE `creature_template` SET `ScriptName`='npc_aeranas' WHERE `entry`=17085; +UPDATE `gameobject_template` SET `ScriptName`='go_haaleshi_altar' WHERE `entry`=181606; +UPDATE `creature_template` SET `ScriptName`='npc_commander_dawnforge' WHERE `entry`=19831; +UPDATE creature_template SET scriptname = 'boss_kalecgos' WHERE entry = 24850; +UPDATE creature_template SET scriptname = 'boss_sathrovarr' WHERE entry = 24892; +UPDATE creature_template SET scriptname = 'boss_kalec' WHERE entry = 24891; +UPDATE creature_template SET scriptname = 'npc_blackhole' WHERE entry = 25855; +UPDATE creature_template SET scriptname = 'boss_archavon' WHERE entry = 31125; +UPDATE creature_template SET scriptname = 'mob_archavon_warder' WHERE entry = 32353; \ No newline at end of file diff --git a/sql/updates/3263_world_scripts_(missing in full).sql b/sql/updates/3263_world_scripts_(missing in full).sql deleted file mode 100644 index 942ffd1ccfd..00000000000 --- a/sql/updates/3263_world_scripts_(missing in full).sql +++ /dev/null @@ -1,14 +0,0 @@ -UPDATE creature_template SET ScriptName='npc_kingdom_of_dalaran_quests' WHERE entry IN (29169,23729,26673,27158,29158,29161,26471,29155,29159,29160,29162); -UPDATE `creature_template` SET `ScriptName` = 'boss_elder_nadox' WHERE `entry` = 29309; -UPDATE `creature_template` SET `ScriptName` = 'mob_ahnkahar_nerubian' WHERE `entry` in (30176,30178); -UPDATE `instance_template` SET `script`= 'instance_ahnkahet' WHERE `map` = 619; -update creature_template set scriptname = 'mob_parasitic_shadowfiend' where entry = 23498; -UPDATE `creature_template` SET `ScriptName`='npc_aeranas' WHERE `entry`=17085; -UPDATE `gameobject_template` SET `ScriptName`='go_haaleshi_altar' WHERE `entry`=181606; -UPDATE `creature_template` SET `ScriptName`='npc_commander_dawnforge' WHERE `entry`=19831; -UPDATE creature_template SET scriptname = 'boss_kalecgos' WHERE entry = 24850; -UPDATE creature_template SET scriptname = 'boss_sathrovarr' WHERE entry = 24892; -UPDATE creature_template SET scriptname = 'boss_kalec' WHERE entry = 24891; -UPDATE creature_template SET scriptname = 'npc_blackhole' WHERE entry = 25855; -UPDATE creature_template SET scriptname = 'boss_archavon' WHERE entry = 31125; -UPDATE creature_template SET scriptname = 'mob_archavon_warder' WHERE entry = 32353; \ No newline at end of file diff --git a/sql/updates/3427_world_scripts_#naxx.sql b/sql/updates/3427_world_scripts_#naxx.sql new file mode 100644 index 00000000000..bb437c29669 --- /dev/null +++ b/sql/updates/3427_world_scripts_#naxx.sql @@ -0,0 +1,113 @@ +UPDATE `creature_template` SET `ScriptName`='mob_webwrap' WHERE `entry`=16486; +UPDATE `creature_template` SET `ScriptName`='boss_grobbulus' WHERE entry = 15931; +UPDATE `creature_template` SET `ScriptName`='mob_gothik_minion' WHERE entry IN (16124,16125,16126,16127,16148,16149,16150); +UPDATE `creature_template` SET `ScriptName`='boss_four_horsemen' WHERE `entry` IN (16063,16064,16065,30549); + +DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN +(28732,54097,-29865,-55053,-28169,28059,39088,-28059,-39088,28062,39090,28084, +39091,-28084,-39091,28085,39093); +INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES +( 28732,-28798, 1, 'Widow\'s Embrace - Frenzy'), +( 54097,-54100, 1, 'Widow\'s Embrace - Frenzy (H)'), +(-29865, 55594, 0, 'Deathbloom'), +(-55053, 55601, 0, 'Deathbloom (H)'), +(-28169, 28206, 0, 'Mutating Injection - Mutagen Explosion'), +(-28169, 28240, 0, 'Mutating Injection - Poison Cloud'), +( 28059,-28084, 1, 'Positive Charge - Negative Charge'), +(-28059,-29659, 0, 'Positive Charge'), +# ( 28062,-29659, 0, 'Positive Charge'), +( 28084,-28059, 1, 'Negative Charge - Positive Charge'), +(-28084,-29660, 0, 'Negative Charge'), +# ( 28085,-29660, 0, 'Negative Charge'), +( 39088,-39091, 1, 'Positive Charge - Negative Charge'), +(-39088,-29659, 0, 'Positive Charge'), +# ( 39090,-29659, 0, 'Positive Charge'), +( 39091,-39088, 1, 'Negative Charge - Positive Charge'), +(-39091,-39092, 0, 'Negative Charge'); +# ( 39093,-39092, 0, 'Negative Charge'); + +INSERT INTO creature_template (entry, spell1, flags_extra, scriptname) VALUES +(16363, 28158, 128, ''), # Grobbulus Cloud +(29379, 54362, 128, ''), # Grobbulus Cloud (H) +(16697, 28158, 128, ''), # Void Zone +(29379, 54362, 128, '') # Void Zone (H) +ON DUPLICATE KEY UPDATE +spell1 = VALUES(spell1), +flags_extra = VALUES(flags_extra), +scriptname = VALUES(scriptname); + +INSERT INTO creature_template (entry, baseattacktime, spell1, flags_extra, scriptname) VALUES +(16474, 1000, 28547, 128, 'trigger_periodic'), # Blizzard (Sapphiron) +(30000, 1000, 55699, 128, 'trigger_periodic'), # Blizzard (Sapphiron) (H) +(16697, 1000, 28865, 128, 'trigger_periodic') # Void Zone (Lady Blaumeux) +ON DUPLICATE KEY UPDATE +baseattacktime = VALUES(baseattacktime), +spell1 = VALUES(spell1), +flags_extra = VALUES(flags_extra), +scriptname = VALUES(scriptname); + +DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN (29912); +INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `quest_id`, `cast_flags`) VALUES +(29912, 55479, 0, 1); # Obedience Crystal - Force Obedience + +DELETE FROM `spell_script_target` WHERE `entry` IN +(28732,54097,55479, +27892,27893,27928,27929,27935,27936); +INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES +(28732, 1, 15953), # Widow's Embrace +(54097, 1, 15953), # Widow's Embrace +(55479, 1, 16803), # Force Obedience - Death Knight Understudy +# (29105, 1, 16803), # Hopeless - Death Knight Understudy +(27892, 1, 16060), # To Anchor 1 - Gothik +(27893, 1, 16060), # To Anchor 2 - Gothik +(27928, 1, 16060), # To Anchor 1 - Gothik +(27929, 1, 16060), # To Anchor 2 - Gothik +(27935, 1, 16060), # To Anchor 1 - Gothik +(27936, 1, 16060); # To Anchor 2 - Gothik + +INSERT INTO creature_template (entry, spell1, spell2, spell3, spell4, spell5, spell6, spell7, spell8) VALUES +(16573, 15284, 28991, 28969, 34970, 0, 0, 0, 28864), # Crypt Guard +(29256, 15284, 28991, 56098, 34970, 0, 0, 0, 28864), # Crypt Guard (H) +(16506, 54095, 0, 0, 0, 0, 0, 0, 28732), # Naxxramas Worshipper +(29274, 54096, 0, 0, 0, 0, 0, 0, 54097), # Naxxramas Worshipper (H) +(17055, 54121, 0, 0, 0, 0, 0, 0, 0), # Maexxna Spiderling +(29279, 28776, 0, 0, 0, 0, 0, 0, 0), # Maexxna Spiderling (H) +(16486, 28622, 0, 0, 0, 0, 0, 0, 0), # Web Wrap +(30183, 28622, 0, 0, 0, 0, 0, 0, 0), # Web Wrap (H) +(16984, 15496, 0, 0, 0, 0, 0, 0, 0), # Plagued Warrior +(29632, 15496, 0, 0, 0, 0, 0, 0, 0), # Plagued Warrior (H) +(16983, 32736, 30138, 0, 0, 0, 0, 0, 0), # Plagued Champion +(29632, 32736, 54889, 0, 0, 0, 0, 0, 0), # Plagued Champion (H) +(16981, 15496, 54890, 0, 0, 0, 0, 0, 0), # Plagued Guardian +(29632, 15496, 54891, 0, 0, 0, 0, 0, 0), # Plagued Guardian (H) +(16286, 0, 0, 0, 0, 0, 0, 0, 29232), # Spore +(30068, 0, 0, 0, 0, 0, 0, 0, 29232), # Spore (H) +(16290, 28156, 0, 0, 0, 0, 0, 0, 0), # Fallout Slime +(29388, 54367, 0, 0, 0, 0, 0, 0, 0), # Fallout Slime (H) +(16360, 29307, 0, 0, 0, 0, 0, 0, 0), # Zombie Chow +(30303, 29307, 0, 0, 0, 0, 0, 0, 0), # Zombie Chow (H) +(16803, 0, 0, 0, 61696, 29060, 29061, 0, 0), # Death Knight Understudy +(29941, 0, 0, 0, 61696, 29060, 29061, 0, 0), # Death Knight Understudy (H) +(16124, 55604, 0, 0, 0, 0, 0, 0, 27892), # Unrelenting Trainee +(16125, 27825, 0, 0, 0, 0, 0, 0, 27928), # Unrelenting Death Knight +(16126, 27831, 55606, 0, 0, 0, 0, 0, 27935), # Unrelenting Rider +(16127, 27989, 0, 0, 0, 0, 0, 0, 0), # Spectral Trainee +(16148, 56408, 0, 0, 0, 0, 0, 0, 0), # Spectral Death Knight +(16150, 27994, 55648, 55606, 0, 0, 0, 0, 0), # Spectral Rider +(16149, 27993, 0, 0, 0, 0, 0, 0, 0), # Spectral Horse +(29985, 55645, 0, 0, 0, 0, 0, 0, 27892), # Unrelenting Trainee (H) +(29986, 27825, 0, 0, 0, 0, 0, 0, 27928), # Unrelenting Death Knight (H) +(29987, 55638, 55608, 0, 0, 0, 0, 0, 27935), # Unrelenting Rider (H) +(30264, 56407, 0, 0, 0, 0, 0, 0, 0), # Spectral Trainee (H) +(29990, 56408, 0, 0, 0, 0, 0, 0, 0), # Spectral Death Knight (H) +(29988, 55646, 27995, 55608, 0, 0, 0, 0, 0), # Spectral Rider (H) +(29989, 27993, 0, 0, 0, 0, 0, 0, 0) # Spectral Horse (H) +ON DUPLICATE KEY UPDATE +spell1 = VALUES(spell1), +spell2 = VALUES(spell2), +spell3 = VALUES(spell3), +spell4 = VALUES(spell4), +spell5 = VALUES(spell5), +spell6 = VALUES(spell6), +spell7 = VALUES(spell7), +spell8 = VALUES(spell8); \ No newline at end of file diff --git a/sql/updates/3427_world_scripts_(naxx).sql b/sql/updates/3427_world_scripts_(naxx).sql deleted file mode 100644 index bb437c29669..00000000000 --- a/sql/updates/3427_world_scripts_(naxx).sql +++ /dev/null @@ -1,113 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='mob_webwrap' WHERE `entry`=16486; -UPDATE `creature_template` SET `ScriptName`='boss_grobbulus' WHERE entry = 15931; -UPDATE `creature_template` SET `ScriptName`='mob_gothik_minion' WHERE entry IN (16124,16125,16126,16127,16148,16149,16150); -UPDATE `creature_template` SET `ScriptName`='boss_four_horsemen' WHERE `entry` IN (16063,16064,16065,30549); - -DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN -(28732,54097,-29865,-55053,-28169,28059,39088,-28059,-39088,28062,39090,28084, -39091,-28084,-39091,28085,39093); -INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES -( 28732,-28798, 1, 'Widow\'s Embrace - Frenzy'), -( 54097,-54100, 1, 'Widow\'s Embrace - Frenzy (H)'), -(-29865, 55594, 0, 'Deathbloom'), -(-55053, 55601, 0, 'Deathbloom (H)'), -(-28169, 28206, 0, 'Mutating Injection - Mutagen Explosion'), -(-28169, 28240, 0, 'Mutating Injection - Poison Cloud'), -( 28059,-28084, 1, 'Positive Charge - Negative Charge'), -(-28059,-29659, 0, 'Positive Charge'), -# ( 28062,-29659, 0, 'Positive Charge'), -( 28084,-28059, 1, 'Negative Charge - Positive Charge'), -(-28084,-29660, 0, 'Negative Charge'), -# ( 28085,-29660, 0, 'Negative Charge'), -( 39088,-39091, 1, 'Positive Charge - Negative Charge'), -(-39088,-29659, 0, 'Positive Charge'), -# ( 39090,-29659, 0, 'Positive Charge'), -( 39091,-39088, 1, 'Negative Charge - Positive Charge'), -(-39091,-39092, 0, 'Negative Charge'); -# ( 39093,-39092, 0, 'Negative Charge'); - -INSERT INTO creature_template (entry, spell1, flags_extra, scriptname) VALUES -(16363, 28158, 128, ''), # Grobbulus Cloud -(29379, 54362, 128, ''), # Grobbulus Cloud (H) -(16697, 28158, 128, ''), # Void Zone -(29379, 54362, 128, '') # Void Zone (H) -ON DUPLICATE KEY UPDATE -spell1 = VALUES(spell1), -flags_extra = VALUES(flags_extra), -scriptname = VALUES(scriptname); - -INSERT INTO creature_template (entry, baseattacktime, spell1, flags_extra, scriptname) VALUES -(16474, 1000, 28547, 128, 'trigger_periodic'), # Blizzard (Sapphiron) -(30000, 1000, 55699, 128, 'trigger_periodic'), # Blizzard (Sapphiron) (H) -(16697, 1000, 28865, 128, 'trigger_periodic') # Void Zone (Lady Blaumeux) -ON DUPLICATE KEY UPDATE -baseattacktime = VALUES(baseattacktime), -spell1 = VALUES(spell1), -flags_extra = VALUES(flags_extra), -scriptname = VALUES(scriptname); - -DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN (29912); -INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `quest_id`, `cast_flags`) VALUES -(29912, 55479, 0, 1); # Obedience Crystal - Force Obedience - -DELETE FROM `spell_script_target` WHERE `entry` IN -(28732,54097,55479, -27892,27893,27928,27929,27935,27936); -INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES -(28732, 1, 15953), # Widow's Embrace -(54097, 1, 15953), # Widow's Embrace -(55479, 1, 16803), # Force Obedience - Death Knight Understudy -# (29105, 1, 16803), # Hopeless - Death Knight Understudy -(27892, 1, 16060), # To Anchor 1 - Gothik -(27893, 1, 16060), # To Anchor 2 - Gothik -(27928, 1, 16060), # To Anchor 1 - Gothik -(27929, 1, 16060), # To Anchor 2 - Gothik -(27935, 1, 16060), # To Anchor 1 - Gothik -(27936, 1, 16060); # To Anchor 2 - Gothik - -INSERT INTO creature_template (entry, spell1, spell2, spell3, spell4, spell5, spell6, spell7, spell8) VALUES -(16573, 15284, 28991, 28969, 34970, 0, 0, 0, 28864), # Crypt Guard -(29256, 15284, 28991, 56098, 34970, 0, 0, 0, 28864), # Crypt Guard (H) -(16506, 54095, 0, 0, 0, 0, 0, 0, 28732), # Naxxramas Worshipper -(29274, 54096, 0, 0, 0, 0, 0, 0, 54097), # Naxxramas Worshipper (H) -(17055, 54121, 0, 0, 0, 0, 0, 0, 0), # Maexxna Spiderling -(29279, 28776, 0, 0, 0, 0, 0, 0, 0), # Maexxna Spiderling (H) -(16486, 28622, 0, 0, 0, 0, 0, 0, 0), # Web Wrap -(30183, 28622, 0, 0, 0, 0, 0, 0, 0), # Web Wrap (H) -(16984, 15496, 0, 0, 0, 0, 0, 0, 0), # Plagued Warrior -(29632, 15496, 0, 0, 0, 0, 0, 0, 0), # Plagued Warrior (H) -(16983, 32736, 30138, 0, 0, 0, 0, 0, 0), # Plagued Champion -(29632, 32736, 54889, 0, 0, 0, 0, 0, 0), # Plagued Champion (H) -(16981, 15496, 54890, 0, 0, 0, 0, 0, 0), # Plagued Guardian -(29632, 15496, 54891, 0, 0, 0, 0, 0, 0), # Plagued Guardian (H) -(16286, 0, 0, 0, 0, 0, 0, 0, 29232), # Spore -(30068, 0, 0, 0, 0, 0, 0, 0, 29232), # Spore (H) -(16290, 28156, 0, 0, 0, 0, 0, 0, 0), # Fallout Slime -(29388, 54367, 0, 0, 0, 0, 0, 0, 0), # Fallout Slime (H) -(16360, 29307, 0, 0, 0, 0, 0, 0, 0), # Zombie Chow -(30303, 29307, 0, 0, 0, 0, 0, 0, 0), # Zombie Chow (H) -(16803, 0, 0, 0, 61696, 29060, 29061, 0, 0), # Death Knight Understudy -(29941, 0, 0, 0, 61696, 29060, 29061, 0, 0), # Death Knight Understudy (H) -(16124, 55604, 0, 0, 0, 0, 0, 0, 27892), # Unrelenting Trainee -(16125, 27825, 0, 0, 0, 0, 0, 0, 27928), # Unrelenting Death Knight -(16126, 27831, 55606, 0, 0, 0, 0, 0, 27935), # Unrelenting Rider -(16127, 27989, 0, 0, 0, 0, 0, 0, 0), # Spectral Trainee -(16148, 56408, 0, 0, 0, 0, 0, 0, 0), # Spectral Death Knight -(16150, 27994, 55648, 55606, 0, 0, 0, 0, 0), # Spectral Rider -(16149, 27993, 0, 0, 0, 0, 0, 0, 0), # Spectral Horse -(29985, 55645, 0, 0, 0, 0, 0, 0, 27892), # Unrelenting Trainee (H) -(29986, 27825, 0, 0, 0, 0, 0, 0, 27928), # Unrelenting Death Knight (H) -(29987, 55638, 55608, 0, 0, 0, 0, 0, 27935), # Unrelenting Rider (H) -(30264, 56407, 0, 0, 0, 0, 0, 0, 0), # Spectral Trainee (H) -(29990, 56408, 0, 0, 0, 0, 0, 0, 0), # Spectral Death Knight (H) -(29988, 55646, 27995, 55608, 0, 0, 0, 0, 0), # Spectral Rider (H) -(29989, 27993, 0, 0, 0, 0, 0, 0, 0) # Spectral Horse (H) -ON DUPLICATE KEY UPDATE -spell1 = VALUES(spell1), -spell2 = VALUES(spell2), -spell3 = VALUES(spell3), -spell4 = VALUES(spell4), -spell5 = VALUES(spell5), -spell6 = VALUES(spell6), -spell7 = VALUES(spell7), -spell8 = VALUES(spell8); \ No newline at end of file diff --git a/sql/updates/3466_world_scripts_#wintergrasp.sql b/sql/updates/3466_world_scripts_#wintergrasp.sql new file mode 100644 index 00000000000..ac757d126de --- /dev/null +++ b/sql/updates/3466_world_scripts_#wintergrasp.sql @@ -0,0 +1,19 @@ +DELETE FROM `spell_script_target` WHERE entry IN +(56575,56661,56663,56665,56667,56669,61408); +INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES +(56575, 1, 27852), +(56661, 1, 27852), +(56663, 1, 27852), +(56665, 1, 27852), +(56667, 1, 27852), +(56669, 1, 27852), +(61408, 1, 27852); + + +update creature_template set maxhealth = 133525, minhealth = 133525, maxmana = 51360, minmana = 51360, spell1 = 53114, spell2 = 53112, spell3=53110 where entry = 28670; +update creature_template set maxhealth = 30000, minhealth = 30000, speed = 2, spell1=50025, spell2=50989, VehicleId = 36 where entry = 27881; +update creature_template set maxhealth = 50000, minhealth = 50000, speed = 1.6, spell1=50896, spell2=50652, VehicleId = 106 where entry = 28094; +update creature_template set maxhealth = 75000, minhealth = 75000, speed = 1, spell1=51678, VehicleId = 117 where entry IN (28312,32627); +update creature_template set maxhealth = 50000, minhealth = 50000, spell1=51362, VehicleId = 116 where entry IN (28319,32629); + +update creature_template set scriptname = "npc_demolisher_engineerer" where entry in (30400,30499); \ No newline at end of file diff --git a/sql/updates/3466_world_scripts_(wintergrasp).sql b/sql/updates/3466_world_scripts_(wintergrasp).sql deleted file mode 100644 index ac757d126de..00000000000 --- a/sql/updates/3466_world_scripts_(wintergrasp).sql +++ /dev/null @@ -1,19 +0,0 @@ -DELETE FROM `spell_script_target` WHERE entry IN -(56575,56661,56663,56665,56667,56669,61408); -INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES -(56575, 1, 27852), -(56661, 1, 27852), -(56663, 1, 27852), -(56665, 1, 27852), -(56667, 1, 27852), -(56669, 1, 27852), -(61408, 1, 27852); - - -update creature_template set maxhealth = 133525, minhealth = 133525, maxmana = 51360, minmana = 51360, spell1 = 53114, spell2 = 53112, spell3=53110 where entry = 28670; -update creature_template set maxhealth = 30000, minhealth = 30000, speed = 2, spell1=50025, spell2=50989, VehicleId = 36 where entry = 27881; -update creature_template set maxhealth = 50000, minhealth = 50000, speed = 1.6, spell1=50896, spell2=50652, VehicleId = 106 where entry = 28094; -update creature_template set maxhealth = 75000, minhealth = 75000, speed = 1, spell1=51678, VehicleId = 117 where entry IN (28312,32627); -update creature_template set maxhealth = 50000, minhealth = 50000, spell1=51362, VehicleId = 116 where entry IN (28319,32629); - -update creature_template set scriptname = "npc_demolisher_engineerer" where entry in (30400,30499); \ No newline at end of file diff --git a/sql/updates/3467_world_spellclick_#dk.sql b/sql/updates/3467_world_spellclick_#dk.sql new file mode 100644 index 00000000000..52cc8eb4459 --- /dev/null +++ b/sql/updates/3467_world_spellclick_#dk.sql @@ -0,0 +1,8 @@ +ALTER TABLE `npc_spellclick_spells` + ADD COLUMN `quest_status` int(11) UNSIGNED NOT NULL DEFAULT 3 COMMENT 'Quest status: 3 incompleted, 1 completed/rewarded' AFTER `quest_id`; + +DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN ('29501', '29488'); +INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `quest_id`, `quest_status`, `cast_flags`) VALUES +('29488', '54568', '12670', '1', '3'), +('29501', '54575', '12670', '1', '3'); + diff --git a/sql/updates/3467_world_spellclick_(dk).sql b/sql/updates/3467_world_spellclick_(dk).sql deleted file mode 100644 index 52cc8eb4459..00000000000 --- a/sql/updates/3467_world_spellclick_(dk).sql +++ /dev/null @@ -1,8 +0,0 @@ -ALTER TABLE `npc_spellclick_spells` - ADD COLUMN `quest_status` int(11) UNSIGNED NOT NULL DEFAULT 3 COMMENT 'Quest status: 3 incompleted, 1 completed/rewarded' AFTER `quest_id`; - -DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN ('29501', '29488'); -INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `quest_id`, `quest_status`, `cast_flags`) VALUES -('29488', '54568', '12670', '1', '3'), -('29501', '54575', '12670', '1', '3'); - diff --git a/sql/updates/3592_world_spell_#dk.sql b/sql/updates/3592_world_spell_#dk.sql new file mode 100644 index 00000000000..4f7c4e294ac --- /dev/null +++ b/sql/updates/3592_world_spell_#dk.sql @@ -0,0 +1,8 @@ +DELETE FROM `spell_script_target` WHERE entry IN (51859); +INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES +(51859, 1, 28525), -- siphon of archerus +(51859, 1, 28542), +(51859, 1, 28543), +(51859, 1, 28544); +UPDATE `creature_template` SET `spell5`=51890 WHERE `entry`=28511; -- Eye of Acherus flight +UPDATE `creature_template` SET `minlevel`=50,`maxlevel`=52,`minhealth`=2215,`maxhealth`=2317,`faction_A`=2084,`faction_H`=2084,`mindmg`=50,`maxdmg`=50 WHERE `entry`=28528; -- ghoul \ No newline at end of file diff --git a/sql/updates/3592_world_spell_(dk).sql b/sql/updates/3592_world_spell_(dk).sql deleted file mode 100644 index 4f7c4e294ac..00000000000 --- a/sql/updates/3592_world_spell_(dk).sql +++ /dev/null @@ -1,8 +0,0 @@ -DELETE FROM `spell_script_target` WHERE entry IN (51859); -INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES -(51859, 1, 28525), -- siphon of archerus -(51859, 1, 28542), -(51859, 1, 28543), -(51859, 1, 28544); -UPDATE `creature_template` SET `spell5`=51890 WHERE `entry`=28511; -- Eye of Acherus flight -UPDATE `creature_template` SET `minlevel`=50,`maxlevel`=52,`minhealth`=2215,`maxhealth`=2317,`faction_A`=2084,`faction_H`=2084,`mindmg`=50,`maxdmg`=50 WHERE `entry`=28528; -- ghoul \ No newline at end of file diff --git a/sql/updates/3593_world_spellclick_#dk.sql b/sql/updates/3593_world_spellclick_#dk.sql new file mode 100644 index 00000000000..c0550f03c60 --- /dev/null +++ b/sql/updates/3593_world_spellclick_#dk.sql @@ -0,0 +1,4 @@ +DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN ('29501', '29488'); +INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `quest_id`, `quest_status`, `cast_flags`) VALUES +('29488', '54568', '12670', '1', '3'), +('29501', '54575', '12670', '1', '3'); \ No newline at end of file diff --git a/sql/updates/3593_world_spellclick_(dk).sql b/sql/updates/3593_world_spellclick_(dk).sql deleted file mode 100644 index c0550f03c60..00000000000 --- a/sql/updates/3593_world_spellclick_(dk).sql +++ /dev/null @@ -1,4 +0,0 @@ -DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN ('29501', '29488'); -INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `quest_id`, `quest_status`, `cast_flags`) VALUES -('29488', '54568', '12670', '1', '3'), -('29501', '54575', '12670', '1', '3'); \ No newline at end of file diff --git a/sql/updates/3612_world_spell_#dk.sql b/sql/updates/3612_world_spell_#dk.sql new file mode 100644 index 00000000000..62f8a9b8b7a --- /dev/null +++ b/sql/updates/3612_world_spell_#dk.sql @@ -0,0 +1,4 @@ +DELETE FROM `spell_script_target` WHERE entry IN (52124); +INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES +(52124, 1, 28655); +UPDATE `creature_template` SET spell1=52372,spell2=52373,spell3=52374,spell4=52375 WHERE `entry`=28406; \ No newline at end of file diff --git a/sql/updates/3612_world_spell_(dk).sql b/sql/updates/3612_world_spell_(dk).sql deleted file mode 100644 index 62f8a9b8b7a..00000000000 --- a/sql/updates/3612_world_spell_(dk).sql +++ /dev/null @@ -1,4 +0,0 @@ -DELETE FROM `spell_script_target` WHERE entry IN (52124); -INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES -(52124, 1, 28655); -UPDATE `creature_template` SET spell1=52372,spell2=52373,spell3=52374,spell4=52375 WHERE `entry`=28406; \ No newline at end of file diff --git a/sql/updates/3643_world_#wintergrasp.sql b/sql/updates/3643_world_#wintergrasp.sql new file mode 100644 index 00000000000..58137883790 --- /dev/null +++ b/sql/updates/3643_world_#wintergrasp.sql @@ -0,0 +1,12 @@ +DELETE FROM `spell_script_target` WHERE entry IN (54643); +INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES +(54643,1,23472); + +DELETE FROM `game_event` WHERE `entry` IN (50,51); +INSERT INTO `game_event` (`entry`, `description`, `world_event`) VALUES +(50, 'Wintergrasp Alliance Defence', 5), +(51, 'Wintergrasp Horde Defence', 5); + +DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (54643); +INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES +( 54643,-54643, 2, 'Wintergrasp Defender Teleport'); \ No newline at end of file diff --git a/sql/updates/3643_world_(wintergrasp).sql b/sql/updates/3643_world_(wintergrasp).sql deleted file mode 100644 index 58137883790..00000000000 --- a/sql/updates/3643_world_(wintergrasp).sql +++ /dev/null @@ -1,12 +0,0 @@ -DELETE FROM `spell_script_target` WHERE entry IN (54643); -INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES -(54643,1,23472); - -DELETE FROM `game_event` WHERE `entry` IN (50,51); -INSERT INTO `game_event` (`entry`, `description`, `world_event`) VALUES -(50, 'Wintergrasp Alliance Defence', 5), -(51, 'Wintergrasp Horde Defence', 5); - -DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (54643); -INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES -( 54643,-54643, 2, 'Wintergrasp Defender Teleport'); \ No newline at end of file diff --git a/sql/updates/3736_world_spell_#dk.sql b/sql/updates/3736_world_spell_#dk.sql new file mode 100644 index 00000000000..4aa0c6b557c --- /dev/null +++ b/sql/updates/3736_world_spell_#dk.sql @@ -0,0 +1,3 @@ +DELETE FROM spell_area WHERE spell = 52693; +INSERT INTO spell_area (`spell`, `area`, `quest_start`, `quest_start_active`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`) VALUES +(52693, 4298, 12687, 1, 12687, 0, 0, 0, 1); \ No newline at end of file diff --git a/sql/updates/3736_world_spell_(dk).sql b/sql/updates/3736_world_spell_(dk).sql deleted file mode 100644 index 4aa0c6b557c..00000000000 --- a/sql/updates/3736_world_spell_(dk).sql +++ /dev/null @@ -1,3 +0,0 @@ -DELETE FROM spell_area WHERE spell = 52693; -INSERT INTO spell_area (`spell`, `area`, `quest_start`, `quest_start_active`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`) VALUES -(52693, 4298, 12687, 1, 12687, 0, 0, 0, 1); \ No newline at end of file diff --git a/sql/updates/3813_world_spell_#dk.sql b/sql/updates/3813_world_spell_#dk.sql new file mode 100644 index 00000000000..ee12a70afd0 --- /dev/null +++ b/sql/updates/3813_world_spell_#dk.sql @@ -0,0 +1,10 @@ +UPDATE `creature_template` SET `ScriptName`='npc_dkc1_gothik' WHERE `entry`=28658; + +-- gift of harvester +DELETE FROM `spell_script_target` WHERE entry IN +(52479); +INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES +(52479,1,28819), +(52479,1,28822); + +update creature_template set maxhealth = 133525, minhealth = 133525, maxmana = 51360, minmana = 51360, spell1 = 53114, spell2 = 53112, spell3=53110, VehicleId = 156 where entry = 28670; diff --git a/sql/updates/3813_world_spell_(dk).sql b/sql/updates/3813_world_spell_(dk).sql deleted file mode 100644 index ee12a70afd0..00000000000 --- a/sql/updates/3813_world_spell_(dk).sql +++ /dev/null @@ -1,10 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_dkc1_gothik' WHERE `entry`=28658; - --- gift of harvester -DELETE FROM `spell_script_target` WHERE entry IN -(52479); -INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES -(52479,1,28819), -(52479,1,28822); - -update creature_template set maxhealth = 133525, minhealth = 133525, maxmana = 51360, minmana = 51360, spell1 = 53114, spell2 = 53112, spell3=53110, VehicleId = 156 where entry = 28670; diff --git a/sql/updates/3856_world_spell_#naxx.sql b/sql/updates/3856_world_spell_#naxx.sql new file mode 100644 index 00000000000..3b3895b3c4d --- /dev/null +++ b/sql/updates/3856_world_spell_#naxx.sql @@ -0,0 +1,9 @@ +UPDATE `creature_template` SET `minlevel`='80',`maxlevel`='80',`faction_A`='21',`faction_H`='21' WHERE entry IN (16286,30068); + +INSERT INTO creature_template (entry, baseattacktime, spell1, flags_extra, scriptname) VALUES +(16129, 10000, 27812, 128, 'trigger_periodic') # Shadow Fissure (Kel'thezad) +ON DUPLICATE KEY UPDATE +baseattacktime = VALUES(baseattacktime), +spell1 = VALUES(spell1), +flags_extra = VALUES(flags_extra), +scriptname = VALUES(scriptname); diff --git a/sql/updates/3856_world_spell_(naxx).sql b/sql/updates/3856_world_spell_(naxx).sql deleted file mode 100644 index 3b3895b3c4d..00000000000 --- a/sql/updates/3856_world_spell_(naxx).sql +++ /dev/null @@ -1,9 +0,0 @@ -UPDATE `creature_template` SET `minlevel`='80',`maxlevel`='80',`faction_A`='21',`faction_H`='21' WHERE entry IN (16286,30068); - -INSERT INTO creature_template (entry, baseattacktime, spell1, flags_extra, scriptname) VALUES -(16129, 10000, 27812, 128, 'trigger_periodic') # Shadow Fissure (Kel'thezad) -ON DUPLICATE KEY UPDATE -baseattacktime = VALUES(baseattacktime), -spell1 = VALUES(spell1), -flags_extra = VALUES(flags_extra), -scriptname = VALUES(scriptname); diff --git a/sql/updates/3873_world_spell_#dk.sql b/sql/updates/3873_world_spell_#dk.sql new file mode 100644 index 00000000000..09d130a4f6b --- /dev/null +++ b/sql/updates/3873_world_spell_#dk.sql @@ -0,0 +1,25 @@ + +replace into creature_questrelation (id,quest) VALUES (28377,12701); +replace into creature_involvedrelation (id,quest) VALUES (28377,12701); +replace into creature_involvedrelation (id,quest) VALUES (28914,12723); +replace into creature_questrelation (id,quest) VALUES (28914,12724); +replace into creature_involvedrelation (id,quest) VALUES (28914,12724); +replace into creature_questrelation (id,quest) VALUES (28913,12725); +replace into creature_involvedrelation (id,quest) VALUES (28912,12725); +replace into creature_questrelation (id,quest) VALUES (28912,12727); +replace into creature_involvedrelation (id,quest) VALUES (28913,12727); + + +DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN (28833,28887); +INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `quest_id`, `quest_status`, `cast_flags`) VALUES +(28833, 52447, 12701, 3, 3), +(28887, 52447, 12701, 3, 3); + +UPDATE creature_template SET spell1=52435,spell2=52576,spell5=52588,VehicleId=68,speed=0 WHERE entry IN (28833,28887); +UPDATE creature_template SET spell1=52211 WHERE entry=28864; + +DELETE FROM `spell_script_target` WHERE entry IN +(52576); +INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES +(52576,1,28834), +(52576,1,28886); diff --git a/sql/updates/3873_world_spell_(dk).sql b/sql/updates/3873_world_spell_(dk).sql deleted file mode 100644 index 09d130a4f6b..00000000000 --- a/sql/updates/3873_world_spell_(dk).sql +++ /dev/null @@ -1,25 +0,0 @@ - -replace into creature_questrelation (id,quest) VALUES (28377,12701); -replace into creature_involvedrelation (id,quest) VALUES (28377,12701); -replace into creature_involvedrelation (id,quest) VALUES (28914,12723); -replace into creature_questrelation (id,quest) VALUES (28914,12724); -replace into creature_involvedrelation (id,quest) VALUES (28914,12724); -replace into creature_questrelation (id,quest) VALUES (28913,12725); -replace into creature_involvedrelation (id,quest) VALUES (28912,12725); -replace into creature_questrelation (id,quest) VALUES (28912,12727); -replace into creature_involvedrelation (id,quest) VALUES (28913,12727); - - -DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN (28833,28887); -INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `quest_id`, `quest_status`, `cast_flags`) VALUES -(28833, 52447, 12701, 3, 3), -(28887, 52447, 12701, 3, 3); - -UPDATE creature_template SET spell1=52435,spell2=52576,spell5=52588,VehicleId=68,speed=0 WHERE entry IN (28833,28887); -UPDATE creature_template SET spell1=52211 WHERE entry=28864; - -DELETE FROM `spell_script_target` WHERE entry IN -(52576); -INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES -(52576,1,28834), -(52576,1,28886); diff --git a/sql/updates/3886_world_script_#nexus.sql b/sql/updates/3886_world_script_#nexus.sql new file mode 100644 index 00000000000..7495a5f61c1 --- /dev/null +++ b/sql/updates/3886_world_script_#nexus.sql @@ -0,0 +1,80 @@ +-- Grand Magus Telestra +update `creature_template` set `ScriptName`='boss_magus_telestra' where `entry`=26731; + +-- Anomalus +update `creature_template` set `ScriptName`='boss_anomalus' where `entry`=26763; +update `creature_template` set `ScriptName`='mob_chaotic_rift' where `entry`=26918; + +-- Ormorok the Tree-Shaper +update `creature_template` set `ScriptName`='boss_ormorok' where `entry`=26794; +update `creature_template` set `ScriptName`='mob_crystal_spike' where `entry`=27099; +update `creature_template` set `ScriptName`='mob_crystalline_tangler' where `entry`=32665; + +-- Keristrasza +update `creature_template` set `ScriptName`='boss_keristrasza' where `entry`=26723; + +-- Instance script +update `instance_template` set `script`='instance_nexus' where `map`=576; + +UPDATE creature_template set AIName = 'EventAI' where entry in (26796, 26798, 26929, 26928, 26930); +DELETE FROM `creature_ai_scripts` WHERE `creature_id` in (26796, 26798, 26929, 26928, 26930); +INSERT INTO `creature_ai_scripts` VALUES +-- Commander Stoutbeard +( 2679600, 26796, 4, 0, 100, 4, 0, 0, 0, 0, 28, 0, 47543, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Commander Stoutbeard - crystal prison remove'), +( 2679601, 26796, 4, 0, 100, 4, 0, 0, 0, 0, 11, 31403, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Commander Stoutbeard - cast battle shout'), +( 2679602, 26796, 0, 0, 100, 5, 3000, 3000, 11000, 15000, 11, 60067, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Commander Stoutbeard - cast charge'), +( 2679603, 26796, 0, 0, 100, 5, 6000, 8000, 19500, 25000, 11, 38618, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Commander Stoutbeard - cast whirlwind'), +( 2679604, 26796, 0, 0, 100, 5, 13000, 13000, 45000, 55000, 11, 19134, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Commander Stoutbeard - cast Frightening Shout'), +-- Commander Kolurg +( 2679800, 26798, 4, 0, 100, 4, 0, 0, 0, 0, 28, 0, 47543, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Commander Kolurg - crystal prison remove'), +( 2679801, 26798, 4, 0, 100, 4, 0, 0, 0, 0, 11, 31403, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Commander Kolurg - cast battle shout'), +( 2679802, 26798, 0, 0, 100, 5, 3000, 3000, 11000, 15000, 11, 60067, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Commander Kolurg - cast charge'), +( 2679803, 26798, 0, 0, 100, 5, 6000, 8000, 19500, 25000, 11, 38618, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Commander Kolurg - cast whirlwind'), +( 2679804, 26798, 0, 0, 100, 5, 13000, 13000, 45000, 55000, 11, 19134, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Commander Kolurg - cast Frightening Shout'), +-- Grand Magus Telestra Clone (Arcane) +( 2692901, 26929, 0, 0, 100, 7, 6000, 8000, 10000, 12000, 11, 47731, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Grand Magus Telestra arcane - cast pollymorph critter'), +( 2692902, 26929, 0, 0, 100, 7, 15000, 16000, 15000, 16000, 11, 47736, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Grand Magus Telestra arcane - cast time stop'), +-- Grand Magus Telestra Clone (Fire) +( 2692801, 26928, 0, 0, 100, 3, 3000, 3000, 8000, 9000, 11, 47721, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Grand magus Telestra fire - cast fire blast N'), +( 2692802, 26928, 0, 0, 100, 5, 3000, 3000, 8000, 9000, 11, 56939, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Grand magus Telestra fire - cast fire blast H'), +( 2692803, 26928, 0, 0, 100, 3, 9000, 9000, 9500, 11500, 11, 47723, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Grand magus Telestra fire - cast scorge N'), +( 2692804, 26928, 0, 0, 100, 5, 9000, 9000, 9500, 11500, 11, 56938, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Grand magus Telestra fire - cast scorge H'), +-- Grand Magus Telestra Clone (Frost) +( 2693001, 26930, 0, 0, 100, 3, 3000, 3000, 8000, 9000, 11, 47729, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Grand Magus Telestra frost - cast ice bard N'), +( 2693002, 26930, 0, 0, 100, 5, 3000, 3000, 8000, 9000, 11, 56937, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Grand Magus Telestra frost - cast ice bard H'), +( 2693003, 26930, 0, 0, 100, 3, 9000, 9000, 15000, 16000, 11, 47727, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Grand Magus Telestra frost - cast blizzard N'), +( 2693004, 26930, 0, 0, 100, 5, 9000, 9000, 15000, 16000, 11, 56936, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Grand Magus Telestra frost - cast blizzard H'); + +-- Grand Magus Telestra +REPLACE INTO `script_texts` (`entry`, `content_default`, `sound`, `type`, `language`, `emote`, `comment`) VALUES +(-1576000,'You know what they say about curiosity.',13319,1,0,0,'grand magus telestra SAY_AGGRO'), +(-1576001,'Death becomes you!',13324,1,0,0,'grand magus telestra SAY_KILL'), +(-1576002,'Damn the... luck.',13320,1,0,0,'grand magus telestra SAY_DEATH'), +(-1576003,'Now to finish the job!',13323,1,0,0,'grand magus telestra SAY_MERGE'), +(-1576004,'There\'s plenty of me to go around.',13321,1,0,0,'grand magus telestra SAY_SPLIT_1'), +(-1576005,'I\'ll give you more than you can handle.',13322,1,0,0,'grand magus telestra SAY_SPLIT_2'); + +-- Anomalus +REPLACE INTO `script_texts` (`entry`, `content_default`, `sound`, `type`, `language`, `emote`, `comment`) VALUES +(-1576010,'Chaos beckons.',13186,1,0,0,'anomalus SAY_AGGRO'), +(-1576011,'Of course.',13187,1,0,0,'anomalus SAY_DEATH'), +(-1576012,'Reality... unwoven.',13188,1,0,0,'anomalus SAY_RIFT'), +(-1576013,'Indestructible.',13189,1,0,0,'anomalus SAY_SHIELD'); + +-- Ormorok the Tree-Shaper +REPLACE INTO `script_texts` (`entry`, `content_default`, `sound`, `type`, `language`, `emote`, `comment`) VALUES +(-1576020,'Noo!',13328,1,0,0,'ormorok SAY_AGGRO'), +(-1576021,'Aaggh!',13330,1,0,0,'ormorok SAY_DEATH'), +(-1576022,'Back!',13331,1,0,0,'ormorok SAY_REFLECT'), +(-1576023,'Bleed!',13332,1,0,0,'ormorok SAY_CRYSTAL_SPIKES'), +(-1576024,'Aaggh! Kill!',13329,1,0,0,'ormorok SAY_KILL'); + +-- Keristrasza +REPLACE INTO `script_texts` (`entry`, `content_default`, `sound`, `type`, `language`, `emote`, `comment`) VALUES +(-1576040,'Preserve? Why? There\'s no truth in it. No no no... only in the taking! I see that now!',13450,1,0,0,'keristrasza SAY_AGGRO'), +(-1576041,'Now we\'ve come to the truth!',13453,1,0,0,'keristrasza SAY_SLAY'), +(-1576042,'Finish it! FINISH IT! Kill me, or I swear by the Dragonqueen you\'ll never see daylight again!',13452,1,0,0,'keristrasza SAY_ENRAGE'), +(-1576043,'Dragonqueen... Life-Binder... preserve... me.',13454,1,0,0,'keristrasza SAY_DEATH'), +(-1576044,'Stay. Enjoy your final moments.',13451,1,0,0,'keristrasza SAY_CRYSTAL_NOVA'); + + diff --git a/sql/updates/3886_world_script_(nexus).sql b/sql/updates/3886_world_script_(nexus).sql deleted file mode 100644 index 7495a5f61c1..00000000000 --- a/sql/updates/3886_world_script_(nexus).sql +++ /dev/null @@ -1,80 +0,0 @@ --- Grand Magus Telestra -update `creature_template` set `ScriptName`='boss_magus_telestra' where `entry`=26731; - --- Anomalus -update `creature_template` set `ScriptName`='boss_anomalus' where `entry`=26763; -update `creature_template` set `ScriptName`='mob_chaotic_rift' where `entry`=26918; - --- Ormorok the Tree-Shaper -update `creature_template` set `ScriptName`='boss_ormorok' where `entry`=26794; -update `creature_template` set `ScriptName`='mob_crystal_spike' where `entry`=27099; -update `creature_template` set `ScriptName`='mob_crystalline_tangler' where `entry`=32665; - --- Keristrasza -update `creature_template` set `ScriptName`='boss_keristrasza' where `entry`=26723; - --- Instance script -update `instance_template` set `script`='instance_nexus' where `map`=576; - -UPDATE creature_template set AIName = 'EventAI' where entry in (26796, 26798, 26929, 26928, 26930); -DELETE FROM `creature_ai_scripts` WHERE `creature_id` in (26796, 26798, 26929, 26928, 26930); -INSERT INTO `creature_ai_scripts` VALUES --- Commander Stoutbeard -( 2679600, 26796, 4, 0, 100, 4, 0, 0, 0, 0, 28, 0, 47543, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Commander Stoutbeard - crystal prison remove'), -( 2679601, 26796, 4, 0, 100, 4, 0, 0, 0, 0, 11, 31403, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Commander Stoutbeard - cast battle shout'), -( 2679602, 26796, 0, 0, 100, 5, 3000, 3000, 11000, 15000, 11, 60067, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Commander Stoutbeard - cast charge'), -( 2679603, 26796, 0, 0, 100, 5, 6000, 8000, 19500, 25000, 11, 38618, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Commander Stoutbeard - cast whirlwind'), -( 2679604, 26796, 0, 0, 100, 5, 13000, 13000, 45000, 55000, 11, 19134, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Commander Stoutbeard - cast Frightening Shout'), --- Commander Kolurg -( 2679800, 26798, 4, 0, 100, 4, 0, 0, 0, 0, 28, 0, 47543, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Commander Kolurg - crystal prison remove'), -( 2679801, 26798, 4, 0, 100, 4, 0, 0, 0, 0, 11, 31403, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Commander Kolurg - cast battle shout'), -( 2679802, 26798, 0, 0, 100, 5, 3000, 3000, 11000, 15000, 11, 60067, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Commander Kolurg - cast charge'), -( 2679803, 26798, 0, 0, 100, 5, 6000, 8000, 19500, 25000, 11, 38618, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Commander Kolurg - cast whirlwind'), -( 2679804, 26798, 0, 0, 100, 5, 13000, 13000, 45000, 55000, 11, 19134, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Commander Kolurg - cast Frightening Shout'), --- Grand Magus Telestra Clone (Arcane) -( 2692901, 26929, 0, 0, 100, 7, 6000, 8000, 10000, 12000, 11, 47731, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Grand Magus Telestra arcane - cast pollymorph critter'), -( 2692902, 26929, 0, 0, 100, 7, 15000, 16000, 15000, 16000, 11, 47736, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Grand Magus Telestra arcane - cast time stop'), --- Grand Magus Telestra Clone (Fire) -( 2692801, 26928, 0, 0, 100, 3, 3000, 3000, 8000, 9000, 11, 47721, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Grand magus Telestra fire - cast fire blast N'), -( 2692802, 26928, 0, 0, 100, 5, 3000, 3000, 8000, 9000, 11, 56939, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Grand magus Telestra fire - cast fire blast H'), -( 2692803, 26928, 0, 0, 100, 3, 9000, 9000, 9500, 11500, 11, 47723, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Grand magus Telestra fire - cast scorge N'), -( 2692804, 26928, 0, 0, 100, 5, 9000, 9000, 9500, 11500, 11, 56938, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Grand magus Telestra fire - cast scorge H'), --- Grand Magus Telestra Clone (Frost) -( 2693001, 26930, 0, 0, 100, 3, 3000, 3000, 8000, 9000, 11, 47729, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Grand Magus Telestra frost - cast ice bard N'), -( 2693002, 26930, 0, 0, 100, 5, 3000, 3000, 8000, 9000, 11, 56937, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Grand Magus Telestra frost - cast ice bard H'), -( 2693003, 26930, 0, 0, 100, 3, 9000, 9000, 15000, 16000, 11, 47727, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Grand Magus Telestra frost - cast blizzard N'), -( 2693004, 26930, 0, 0, 100, 5, 9000, 9000, 15000, 16000, 11, 56936, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Grand Magus Telestra frost - cast blizzard H'); - --- Grand Magus Telestra -REPLACE INTO `script_texts` (`entry`, `content_default`, `sound`, `type`, `language`, `emote`, `comment`) VALUES -(-1576000,'You know what they say about curiosity.',13319,1,0,0,'grand magus telestra SAY_AGGRO'), -(-1576001,'Death becomes you!',13324,1,0,0,'grand magus telestra SAY_KILL'), -(-1576002,'Damn the... luck.',13320,1,0,0,'grand magus telestra SAY_DEATH'), -(-1576003,'Now to finish the job!',13323,1,0,0,'grand magus telestra SAY_MERGE'), -(-1576004,'There\'s plenty of me to go around.',13321,1,0,0,'grand magus telestra SAY_SPLIT_1'), -(-1576005,'I\'ll give you more than you can handle.',13322,1,0,0,'grand magus telestra SAY_SPLIT_2'); - --- Anomalus -REPLACE INTO `script_texts` (`entry`, `content_default`, `sound`, `type`, `language`, `emote`, `comment`) VALUES -(-1576010,'Chaos beckons.',13186,1,0,0,'anomalus SAY_AGGRO'), -(-1576011,'Of course.',13187,1,0,0,'anomalus SAY_DEATH'), -(-1576012,'Reality... unwoven.',13188,1,0,0,'anomalus SAY_RIFT'), -(-1576013,'Indestructible.',13189,1,0,0,'anomalus SAY_SHIELD'); - --- Ormorok the Tree-Shaper -REPLACE INTO `script_texts` (`entry`, `content_default`, `sound`, `type`, `language`, `emote`, `comment`) VALUES -(-1576020,'Noo!',13328,1,0,0,'ormorok SAY_AGGRO'), -(-1576021,'Aaggh!',13330,1,0,0,'ormorok SAY_DEATH'), -(-1576022,'Back!',13331,1,0,0,'ormorok SAY_REFLECT'), -(-1576023,'Bleed!',13332,1,0,0,'ormorok SAY_CRYSTAL_SPIKES'), -(-1576024,'Aaggh! Kill!',13329,1,0,0,'ormorok SAY_KILL'); - --- Keristrasza -REPLACE INTO `script_texts` (`entry`, `content_default`, `sound`, `type`, `language`, `emote`, `comment`) VALUES -(-1576040,'Preserve? Why? There\'s no truth in it. No no no... only in the taking! I see that now!',13450,1,0,0,'keristrasza SAY_AGGRO'), -(-1576041,'Now we\'ve come to the truth!',13453,1,0,0,'keristrasza SAY_SLAY'), -(-1576042,'Finish it! FINISH IT! Kill me, or I swear by the Dragonqueen you\'ll never see daylight again!',13452,1,0,0,'keristrasza SAY_ENRAGE'), -(-1576043,'Dragonqueen... Life-Binder... preserve... me.',13454,1,0,0,'keristrasza SAY_DEATH'), -(-1576044,'Stay. Enjoy your final moments.',13451,1,0,0,'keristrasza SAY_CRYSTAL_NOVA'); - - -- cgit v1.2.3