Core/Scripts: Rewrite Boss Kalecgos (Sunwell Plateau) (#19897)

* Core/Scripts: Rewrite Boss Kalecgos (Sunwell Plateau)

Scripted all spells
Corrected behavior of Spectral Blast and Curse of Boundless Agony
Removed wrong wipe behavior
Fix problem where bosses would be stuck with banish
Added Boundaries
Corrected texts
Removed old hacks
Other minor fixes

1 files changed, 42 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2017_08_08_00_world.sql b/sql/updates/world/3.3.5/2017_08_08_00_world.sql
new file mode 100644
index 00000000000..c436d342a42
--- /dev/null
+++ b/sql/updates/world/3.3.5/2017_08_08_00_world.sql
@@ -0,0 +1,42 @@
+UPDATE `creature_template` SET `unit_flags`=32832 WHERE `entry`=24892;
+UPDATE `creature_template` SET `flags_extra`= `flags_extra` |512 WHERE `entry`=24850;
+UPDATE `creature_template` SET `unit_flags`=32832, `ScriptName`='boss_kalecgos_human' WHERE `entry`=24891;
+UPDATE `gameobject_template` SET `ScriptName`='go_kalecgos_spectral_rift' WHERE `entry`=187055;
+
+DELETE FROM `creature_template_addon` WHERE `entry` IN (24891,24892);
+INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES
+(24891,0,0,0,1,0,44801),
+(24892,0,0,0,1,0,'44800 44801');
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=46733;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
+(13,1,46733,0,1,31,0,3,24892,0,0,0,0,'','Spell Tap Check targets Sathrovarr');
+
+UPDATE `creature_text` SET `Type`=12 WHERE `CreatureID`=24850 AND `GroupID`=2 AND`ID`=0;
+UPDATE `creature_text` SET `TextRange`=2 WHERE `CreatureID` IN(24850,24891,24892);
+UPDATE `creature_text` SET `comment`='kalecgos SAY_OUTRO1' WHERE `CreatureID`=24850 and`GroupID`=2 and`ID`=0;
+UPDATE `creature_text` SET `comment`='kalecgos SAY_GOOD_NEAR_DEATH1' WHERE `CreatureID`=24891 and`GroupID`=1 and`ID`=0;
+DELETE FROM `creature_text` WHERE `CreatureID`=24891 AND `GroupID`=3;
+DELETE FROM `creature_text` WHERE `CreatureID`=24850 AND `GroupID` IN(3,4,6);
+INSERT INTO `creature_text` (`CreatureID`,`GroupID`,`ID`,`Text`,`Type`,`Language`,`Probability`,`Emote`,`Duration`,`Sound`,`BroadcastTextId`,`TextRange`,`comment`) VALUES
+(24891,3,0,'There is no time to waste!',14,0,100,0,0,12435,24993,2,'kalecgos SAY_GOOD_DEATH'),
+(24850,3,0,'Kil\'jaeden must be destroyed!',14,0,100,0,0,12433,25502,2,'SAY_OUTRO_2'),
+(24850,4,0,'Sathrovarr drives Kalecgos into a crazed rage!',41,0,100,0,0,0,24983,2,'kalecgos SAY_ENRAGE'),
+(24850,6,0,'I will purge you!',14,0,100,0,0,0,25497,2,'kalecgos SAY_ARCANE_BUFFET'),
+(24850,6,1,'Your pain has only begun!',14,0,100,0,0,0,25498,2,'kalecgos SAY_ARCANE_BUFFET');
+
+DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (44869,46019,46021,-46021);
+
+DELETE FROM `spell_script_names` WhERE `ScriptName` IN
+('spell_kalecgos_spectral_blast',
+'spell_kalecgos_spectral_realm_trigger',
+'spell_kalecgos_spectral_realm_aura',
+'spell_kalecgos_curse_of_boundless_agony',
+'spell_kalecgos_tap_check');
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
+(44869,'spell_kalecgos_spectral_blast'),
+(44811,'spell_kalecgos_spectral_realm_trigger'),
+(46021,'spell_kalecgos_spectral_realm_aura'),
+(45032,'spell_kalecgos_curse_of_boundless_agony'),
+(45034,'spell_kalecgos_curse_of_boundless_agony'),
+(46732,'spell_kalecgos_tap_check');