Valduran the Stormborn (12984)

gistfile1.sql

SET @VALDURAN := 29368;
# eventai
DELETE FROM `creature_ai_scripts` WHERE `creature_id` = @VALDURAN;
INSERT INTO `creature_ai_scripts` VALUES
(2936801, @VALDURAN, 1, 0, 100, 0, 0, 0, 0, 0, 21, 0, 0, 0, 22, 0, 0, 0, 0, 0, 0, 0, 'Valduran the Stormborn - Prevent Combat Movement and Set Phase to 0 on Spawn'),
(2936802, @VALDURAN, 4, 0, 100, 0, 0, 0, 0, 0, 11, 56326, 1, 0, 23, 1, 0, 0, 0, 0, 0, 0, 'Valduran the Stormborn - Cast Lightning Bolt and Set Phase 1 on Aggro'),
(2936803, @VALDURAN, 9, 13, 100, 1, 0, 40, 3400, 4800, 11, 56326, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Valduran the Stormborn - Cast Lightning Bolt (Phase 1)'),
(2936804, @VALDURAN, 3, 13, 100, 0, 7, 0, 0, 0, 21, 1, 0, 0, 23, 1, 0, 0, 0, 0, 0, 0, 'Valduran the Stormborn - Start Combat Movement and Set Phase 2 when Mana is at 7% (Phase 1)'),
(2936805, @VALDURAN, 9, 13, 100, 0, 35, 80, 0, 0, 21, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Valduran the Stormborn - Start Combat Movement at 35 Yards (Phase 1)'),
(2936806, @VALDURAN, 9, 13, 100, 0, 5, 15, 0, 0, 21, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Valduran the Stormborn - Prevent Combat Movement at 15 Yards (Phase 1)'),
(2936807, @VALDURAN, 9, 13, 100, 0, 0, 5, 0, 0, 21, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Valduran the Stormborn - Start Combat Movement Below 5 Yards (Phase 1)'),
(2936808, @VALDURAN, 3, 11, 100, 1, 100, 15, 100, 100, 23, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Valduran the Stormborn - Set Phase 1 when Mana is above 15% (Phase 2)'),
(2936809, @VALDURAN, 0, 0, 100, 1, 15000, 18000, 29000, 33000, 11, 56322, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Valduran the Stormborn - Spark Frenzy'),
(2936810, @VALDURAN, 0, 0, 100, 1, 3000, 8000, 23000, 26000, 11, 56319, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Valduran the Stormborn - Ball Lightning'),
(2936811, @VALDURAN, 2, 0, 100, 0, 15, 0, 0, 0, 22, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Valduran the Stormborn - Set Phase 3 at 15% HP'),
(2936812, @VALDURAN, 2, 7, 100, 0, 15, 0, 0, 0, 21, 1, 0, 0, 25, 0, 0, 0, 1, -47, 0, 0, 'Valduran the Stormborn - Start Combat Movement and Flee at 15% HP (Phase 3)'),
(2936813, @VALDURAN, 7, 0, 100, 0, 0, 0, 0, 0, 22, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Valduran the Stormborn - Set Phase to 0 on Evade');
# speaking
DELETE FROM `creature_ai_texts` WHERE `entry` IN (-5769, -5768, -5767, -5766, -5765);
INSERT INTO `creature_ai_texts` VALUES 
(-5769,'Well fought! The day is ours, but the war goes on!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,4,'Valduran the Stormborn event'),
(-5768,'We\'ve defeated Valduran and we\'ll fell his colossus.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,25,'Valduran the Stormborn event'),
(-5767,'I am your doom, Valduran!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,2,0,25,'Valduran the Stormborn event'),
(-5766,'No more will your minions assail the creatures of stone and their allies.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,5,'Valduran the Stormborn event'),
(-5765,'At last, the tyranny of the stormforged is at its end!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,25,'Valduran the Stormborn event');
# flags to be attackable & setting ai
UPDATE `creature_template` SET `unit_flags` = 64, `faction_A` = 1965, `faction_H` = 1965, `AIName`='EventAI' WHERE `entry` = @VALDURAN;