Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Tirion's Gambit Updates #24274

Open
dr-j opened this issue Mar 8, 2020 · 4 comments
Open

Tirion's Gambit Updates #24274

dr-j opened this issue Mar 8, 2020 · 4 comments
Assignees
@Killyana
Labels
Branch-3.3.5a Comp-Database Feedback-FixOutdatedMissingWIP

Comments

@dr-j
Copy link
Contributor

dr-j commented Mar 8, 2020 •
edited

This is updates for my previous committed script for Tirion's Gambit. This was originally 3 seperate commits thats why some same npcs updated multiple times

  1. Add Alliance texts
  2. Add pauses to waypoints
  3. redid waypoints no more npcs appearing to walk backwards and forwards
  4. added some missing stuff like the 3 chosen zealots that deliver the frozen heart and the frozen heart itself
SET @CGUID := XXXXXX;

UPDATE `creature` SET `equipment_id`='1' WHERE  `guid`IN(74513,74514,74515);

DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+2 AND `id`=32175;
INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`,  `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES
(@CGUID+0, 32175, 571, 0, 0, 1, 1, 0, 0, 6166.502, 2677.593, 573.9974, 1.762783, 120, 0, 0, 0, 0, 0, 0, 0, 0, 14007), -- 32175 (Area: -1 - Difficulty: 0) (possible waypoints or random movement) -- 0xF1307DAF0068CDEF
(@CGUID+1, 32175, 571, 0, 0, 1, 1, 0, 0, 6169.452, 2680.891, 573.9974, 1.972222, 120, 0, 0, 0, 0, 0, 0, 0, 0, 14007), -- 32175 (Area: -1 - Difficulty: 0) (possible waypoints or random movement) -- 0xF1307DAF0068CDED
(@CGUID+2, 32175, 571, 0, 0, 1, 1, 0, 0, 6174.522, 2681.185, 573.9974, 2.234021, 120, 0, 0, 0, 0, 0, 0, 0, 0, 14007); -- 32175 (Area: -1 - Difficulty: 0) (possible waypoints or random movement) -- 0xF1307DAF0068CDEE

DELETE FROM `waypoints` WHERE `entry` BETWEEN @CGUID+0 AND @CGUID+2;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `orientation`, `point_comment`) VALUES 
(@CGUID+0, 1, 6132.78, 2756.154, 573.9141, 0, 'Chosen Zealot'),
(@CGUID+0, 2, 6170.614, 2683.568, 573.9141, 0, 'Chosen Zealot'),
(@CGUID+1, 1, 6133.694, 2758.925, 573.914, 0, 'Chosen Zealot'),
(@CGUID+1, 2, 6134.973, 2693.681, 573.914, 0, 'Chosen Zealot'),
(@CGUID+2, 1, 6136.513, 2758.17, 573.9141, 0, 'Chosen Zealot'),
(@CGUID+2, 2, 6166.714, 2681.898, 573.9141, 0, 'Chosen Zealot');

UPDATE `smart_scripts` SET `link`='3' WHERE  `entryorguid`=24042 AND `source_type`=0 AND `id`=1 AND `link`=0;
UPDATE `smart_scripts` SET `action_type`='80', `action_param1`='3223901', `action_param2`='2', `comment`='Highlord Tirion Fordring - On Reached WP5 - Run Script' WHERE  `entryorguid`=32239 AND `source_type`=0 AND `id`=7 AND `link`=8;
UPDATE `smart_scripts` SET `link`='7' WHERE  `entryorguid`=32312 AND `source_type`=0 AND `id`=6 AND `link`=6;
UPDATE `smart_scripts` SET `link`='0', `event_type`='40', `event_param1`='14', `event_param2`='32312', `action_type`='45', `action_param1`='4', `action_param2`='4' WHERE  `entryorguid`=32312 AND `source_type`=0 AND `id`=6 AND `link`=7;
DELETE FROM `smart_scripts` WHERE `entryorguid`=24042 AND `source_type`=0 AND `id`=3;
DELETE FROM `smart_scripts` WHERE `entryorguid`=3223901 AND `source_type`=9;
DELETE FROM `smart_scripts` WHERE `entryorguid`IN(-74513,-74514,-74515) AND `source_type`=0 AND `id`IN(11,12);
DELETE FROM `smart_scripts` WHERE `entryorguid`=3223900 AND `source_type`=9;
DELETE FROM `smart_scripts` WHERE `entryorguid`=32312 AND `source_type`=0 AND `id`IN(11,12,13,14,15,16,17,18);
DELETE FROM `smart_scripts` WHERE `entryorguid`=32184 AND `source_type`=0 AND `id`IN (5,6,7,8,9,10);
DELETE FROM `smart_scripts` WHERE  `entryorguid`=3217500 AND `source_type`=9 AND `id`=0 AND `link`=0;
DELETE FROM `smart_scripts` WHERE  `entryorguid`=3217501 AND `source_type`=9 AND `id`=0 AND `link`=0;
DELETE FROM `smart_scripts` WHERE  `entryorguid`=3217502 AND `source_type`=9 AND `id`=0 AND `link`=0;
DELETE FROM `smart_scripts` WHERE  `entryorguid`=3217503 AND `source_type`=9 AND `id`=0 AND `link`=0;
DELETE FROM `smart_scripts` WHERE  `entryorguid`=3217504 AND `source_type`=9 AND `id`=0 AND `link`=0;
DELETE FROM `smart_scripts` WHERE  `entryorguid`=3217505 AND `source_type`=9 AND `id`=0 AND `link`=0;
DELETE FROM `smart_scripts` WHERE `entryorguid`=32175 AND `source_type`=0;
DELETE FROM `smart_scripts` WHERE `entryorguid`=32309 AND `source_type`=0 AND `id` IN(7,8,9,10);
DELETE FROM `smart_scripts` WHERE `entryorguid`=3231200 AND `source_type`=9;
DELETE FROM `smart_scripts` WHERE `entryorguid` BETWEEN -@CGUID-2 AND -@CGUID-0 AND `source_type`=0;
DELETE FROM `smart_scripts` WHERE `entryorguid` IN(32310,32311) AND `source_type`=0 AND `id` IN(7,8,9,10,11,12,13);
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`, `event_param5`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `cus_target_param1`, `comment`) VALUES 
(24042, 0, 3, 0, 61, 0, 100, 0, 1, 1, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 20, 193794, 0, 0, 0, 0, 0, 0, 0, 0, 'Generic Trigger LAB - On Data Set 1 1 - Despawn Frozen Heart'),
(-74513, 0, 11, 0, 40, 0, 100, 512, 6, 3224100, 0, 0, 0, 54, 60000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Disguised Crusader 1 - On Reached Point 6 - Pause WP'),
(-74513, 0, 12, 0, 38, 0, 100, 512, 9, 9, 0, 0, 0, 65, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Disguised Crusader 1 - On Data Set - Resume WP'),
(-74514, 0, 11, 0, 40, 0, 100, 512, 5, 3224101, 0, 0, 0, 54, 60000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Disguised Crusader 1 - On Reached Point 6 - Pause WP'),
(-74514, 0, 12, 0, 38, 0, 100, 512, 9, 9, 0, 0, 0, 65, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Disguised Crusader 1 - On Data Set - Resume WP'),
(-74515, 0, 11, 0, 40, 0, 100, 512, 5, 3224102, 0, 0, 0, 54, 60000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Disguised Crusader 1 - On Reached Point 6 - Pause WP'),
(-74515, 0, 12, 0, 38, 0, 100, 512, 9, 9, 0, 0, 0, 65, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Disguised Crusader 1 - On Data Set - Resume WP'),
(-@CGUID-0, 0, 0, 1, 11, 0, 100, 0, 0, 0, 0, 0, 0, 11, 16380, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - On Spawn - Cast Greater Invisibility'),
(-@CGUID-0, 0, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 18, 768, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - On Spawn - Set Immune'),
(-@CGUID-0, 0, 2, 3, 38, 0, 100, 0, 4, 4, 0, 0, 0, 28, 16380, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - On Data Set - Remove Greater Invisibility'),
(-@CGUID-0, 0, 3, 4, 61, 0, 100, 0, 4, 4, 0, 0, 0, 19, 768, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - On Data Set - Remove immune'),
(-@CGUID-0, 0, 4, 0, 61, 0, 100, 0, 4, 4, 0, 0, 0, 53, 0, @CGUID+0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - On Data Set - Start WP'),
(-@CGUID-0, 0, 5, 6, 40, 0, 100, 0, 1, @CGUID+0, 0, 0, 0, 54, 5000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - On Reached WP1 - Pause WP'),
(-@CGUID-0, 0, 6, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 5, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - On Reached WP1 - Play Emote 2'),
(-@CGUID-0, 0, 7, 0, 40, 0, 100, 0, 2, @CGUID+0, 0, 0, 0, 41, 5000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - On Reached WP2 - Despawn'),
(-@CGUID-1, 0, 0, 1, 11, 0, 100, 0, 0, 0, 0, 0, 0, 11, 16380, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - On Spawn - Cast Greater Invisibility'),
(-@CGUID-1, 0, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 18, 768, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - On Spawn - Set Immune'),
(-@CGUID-1, 0, 2, 3, 38, 0, 100, 0, 4, 4, 0, 0, 0, 28, 16380, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - On Data Set - Remove Greater Invisibility'),
(-@CGUID-1, 0, 3, 4, 61, 0, 100, 0, 4, 4, 0, 0, 0, 19, 768, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - On Data Set - Remove immune'),
(-@CGUID-1, 0, 4, 0, 61, 0, 100, 0, 4, 4, 0, 0, 0, 53, 0, @CGUID+1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - On Data Set - Start WP'),
(-@CGUID-1, 0, 5, 6, 40, 0, 100, 0, 1, @CGUID+1, 0, 0, 0, 54, 5000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - On Reached WP1 - Pause WP'),
(-@CGUID-1, 0, 6, 8, 61, 0, 100, 0, 0, 0, 0, 0, 0, 5, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - On Reached WP1 - Play Emote 2'),
(-@CGUID-1, 0, 7, 0, 40, 0, 100, 0, 2, @CGUID+1, 0, 0, 0, 41, 5000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - On Reached WP2 - Despawn'),
(-@CGUID-1, 0, 8, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 50, 193794, 300, 1, 0, 0, 0, 8, 0, 0, 0, 0, 6132.542, 2760.763, 573.914, -0.7853968, 0, 'Chosen Zealot - On Reached WP2 - Despawn'),
(-@CGUID-2, 0, 0, 1, 11, 0, 100, 0, 0, 0, 0, 0, 0, 11, 16380, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - On Spawn - Cast Greater Invisibility'),
(-@CGUID-2, 0, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 18, 768, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - On Spawn - Set Immune'),
(-@CGUID-2, 0, 2, 3, 38, 0, 100, 0, 4, 4, 0, 0, 0, 28, 16380, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - On Data Set - Remove Greater Invisibility'),
(-@CGUID-2, 0, 3, 4, 61, 0, 100, 0, 4, 4, 0, 0, 0, 19, 768, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - On Data Set - Remove immune'),
(-@CGUID-2, 0, 4, 0, 61, 0, 100, 0, 4, 4, 0, 0, 0, 53, 0, @CGUID+2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - On Data Set - Start WP'),
(-@CGUID-2, 0, 5, 6, 40, 0, 100, 0, 1, @CGUID+2, 0, 0, 0, 54, 5000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - On Reached WP1 - Pause WP'),
(-@CGUID-2, 0, 6, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 5, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - On Reached WP1 - Play Emote 2'),
(-@CGUID-2, 0, 7, 0, 40, 0, 100, 0, 2, @CGUID+2, 0, 0, 0, 41, 5000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - On Reached WP2 - Despawn'),
(3223900, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 45, 4, 4, 0, 0, 0, 0, 10, @CGUID+0, 32175, 0, 0, 0, 0, 0, 0, 0, 'Highlord Tirion Fordring - Script - Set Data'),
(3223900, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 45, 4, 4, 0, 0, 0, 0, 10, @CGUID+1, 32175, 0, 0, 0, 0, 0, 0, 0, 'Highlord Tirion Fordring - Script - Set Data'),
(3223900, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 45, 4, 4, 0, 0, 0, 0, 10, @CGUID+2, 32175, 0, 0, 0, 0, 0, 0, 0, 'Highlord Tirion Fordring - Script - Set Data'),
(3223900, 9, 3, 0, 0, 0, 100, 0, 15000, 15000, 0, 0, 0, 1, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Tirion Fordring - Script - Say Line 2'),
(3223900, 9, 4, 0, 0, 0, 100, 0, 7000, 7000, 0, 0, 0, 1, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Tirion Fordring - Script - Say Line 3'),
(3223900, 9, 5, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 12, 32184, 8, 0, 0, 0, 0, 8, 0, 0, 0, 0, 6180.31, 2657.65, 573.87, 1.99941, 0, 'Highlord Tirion Fordring - Script - Summon The Lich King'),
(3223900, 9, 6, 0, 0, 0, 100, 0, 7000, 7000, 0, 0, 0, 1, 4, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Tirion Fordring - Script - Say Line 4'),
(32309, 0, 7, 0, 11, 0, 100, 512, 0, 0, 0, 0, 0, 18, 768, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Ebon Knight - On Data Set - Evade'),
(32309, 0, 8, 9, 38, 0, 100, 512, 8, 8, 0, 0, 0, 19, 768, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Ebon Knight - On Data Set - Evade'),
(32309, 0, 9, 10, 61, 0, 100, 512, 8, 8, 0, 0, 0, 8, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Ebon Knight - On Data Set - Evade'),
(32309, 0, 10, 0, 61, 0, 100, 512, 8, 8, 0, 0, 0, 49, 0, 0, 0, 0, 0, 0, 24, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Ebon Knight - On Data Set - Evade'),
(32175, 0, 0, 1, 38, 0, 100, 512, 2, 2, 0, 0, 0, 8, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - On Data Set 2 2 - Set Aggresive'),
(32175, 0, 1, 2, 61, 0, 100, 512, 0, 0, 0, 0, 0, 90, 8, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - On Data Set 2 2 - Set Bytes 1'),
(32175, 0, 2, 3, 61, 0, 100, 512, 0, 0, 0, 0, 0, 17, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - On Data Set 2 2 - Set Emote State None'),
(32175, 0, 3, 0, 61, 0, 100, 512, 0, 0, 0, 0, 0, 24, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - On Data Set 2 2 - Evade'),
(32175, 0, 4, 5, 38, 0, 100, 512, 1, 1, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - On Data Set 1 1 - Set Passive'),
(32175, 0, 5, 6, 61, 0, 100, 512, 0, 0, 0, 0, 0, 17, 27, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - On Data Set 2 2 - Set Emote State - STATE_READYUNARMED'),
(32175, 0, 6, 7, 61, 0, 100, 512, 0, 0, 0, 0, 0, 91, 8, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - On Data Set 2 2 - Set Bytes 1'),
(32175, 0, 7, 9, 61, 0, 100, 512, 0, 0, 0, 0, 0, 69, 0, 0, 0, 0, 0, 0, 19, 32239, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - On Data Set 1 1 - Run Random Script'),
(32175, 0, 8, 0, 38, 0, 100, 512, 3, 3, 0, 0, 0, 8, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - On Data Set 2 2 - Set Aggresive'),
(32175, 0, 9, 0, 61, 0, 100, 512, 0, 0, 0, 0, 0, 22, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - On Data Set 1 1 - Set Phase 2'),
(32175, 0, 10, 11, 1, 2, 100, 512, 25000, 25000, 1000, 1000, 0, 66, 0, 0, 0, 0, 0, 0, 19, 32239, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - OOC (Phase 2) - Set Orientation'),
(32175, 0, 11, 0, 61, 2, 100, 512, 0, 0, 0, 0, 0, 101, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - OOC (Phase 2) - Set Home Position'),
(32175, 0, 12, 0, 1, 2, 100, 512, 5000, 5000, 1000, 1000, 0, 49, 0, 0, 0, 0, 0, 0, 24, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - OOC (Phase 2) - Start Combat'),
(32184, 0, 5, 6, 38, 0, 100, 512, 7, 7, 0, 0, 0, 11, 60536, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Lich King - On Data Set - Cast The Lich Kings Fury'),
(32184, 0, 6, 0, 61, 0, 100, 512, 7, 7, 0, 0, 0, 22, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Lich King - On Data Set - Set Phase 2'),
(32184, 0, 7, 0, 1, 2, 100, 1, 8500, 8500, 0, 0, 0, 11, 34437, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Lich King - OOC (Phase 2) - Cast Teleport'),
(32184, 0, 8, 0, 1, 2, 100, 1,9000, 9000, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Lich King - OOC (Phase 2) - Despawn'),
(32184, 0, 9, 10, 11, 0, 100, 0,0, 0, 0, 0, 0, 102, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Lich King - On Spawn - Turn Hp Regen off'),
(32184, 0, 10, 0, 61, 0, 100, 0,0, 0, 0, 0, 0, 48, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Lich King - On Spawn - Set Active'),
(32310, 0, 7, 0, 38, 2, 100, 512, 4, 4, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Thassarian - On Data Set - Say Line 0'),
(32310, 0, 8, 0, 38, 2, 100, 512, 5, 5, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Thassarian - On Data Set - Say Line 1'),
(32310, 0, 9, 10, 1, 0, 100, 512, 8, 8, 1000, 1000, 0, 8, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Thassarian - OOC - Set Aggresive'),
(32310, 0, 10, 0, 61, 0, 100, 512, 0, 0, 0, 0, 0, 19, 768, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Thassarian - OOC - Attack'),
(32310, 0, 11, 0, 10, 0, 100, 512, 1, 30, 5000, 5000, 0, 22, 2, 0, 0, 0, 0, 0, 24, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Thassarian - OOC LOS - Set Phase 2'),
(32310, 0, 12, 13, 11, 0, 100, 512, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Thassarian - On Spawn - Set Passive'),
(32310, 0, 13, 0, 61, 0, 100, 512, 0, 0, 0, 0, 0, 18, 768, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Thassarian - On Spawn - Set Passive'),
(32311, 0, 7, 0, 38, 2, 100, 512, 4, 4, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Koltira Deathweaver - On Data Set - Say Line 0'),
(32311, 0, 8, 0, 38, 2, 100, 512, 5, 5, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Koltira Deathweaver - On Data Set - Say Line 1'),
(32311, 0, 9, 10,38, 0, 100, 512, 8, 8, 1000, 1000, 0, 8, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Koltira Deathweaver - OOC - Set Aggresive'),
(32311, 0, 10, 0, 61, 0, 100, 512, 0, 0, 0, 0, 0, 19, 768, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Koltira Deathweaver - OOC - Attack'),
(32311, 0, 11, 0, 10, 0, 100, 512, 1, 30, 5000, 5000, 0, 22, 2, 0, 0, 0, 0, 0, 24, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Koltira Deathweaver - OOC LOS - Set Phase 2'),
(32311, 0, 12, 13, 11, 0, 100, 512, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Koltira Deathweaver - On Spawn - Set Passive'),
(32311, 0, 13, 0, 61, 0, 100, 512, 0, 0, 0, 0, 0, 18, 768, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Koltira Deathweaver - On Spawn - Set Passive'),
(32312, 0, 11, 14, 40, 0, 100, 512, 14, 32312, 0, 0, 0, 45, 4, 4, 0, 0, 0, 0, 19, 32310, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Darion Mograine - On Reached WP9 - Set Data 1 1 Thassarian'),
(32312, 0, 12, 13, 11, 0, 100, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Darion Mograine - On Spawn - Set Passive'),
(32312, 0, 13, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 18, 768, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Darion Mograine - On Spawn - Set Passive'),
(32312, 0, 14, 15, 61, 0, 100, 0, 0, 0, 0, 0, 0, 45, 8, 8, 0, 0, 0, 0, 19, 32310, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Darion Mograine - On Spawn - Set Passive'),
(32312, 0, 15, 16, 61, 0, 100, 0, 0, 0, 0, 0, 0, 45, 8, 8, 0, 0, 0, 0, 19, 32311, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Darion Mograine - On Spawn - Set Passive'),
(32312, 0, 16, 17, 61, 0, 100, 0, 0, 0, 0, 0, 0, 45, 8, 8, 0, 0, 0, 0, 9, 32309, 0, 60, 0, 0, 0, 0, 0, 0, 'Highlord Darion Mograine - On Spawn - Set Passive'),
(32312, 0, 17, 18, 61, 0, 100, 0, 0, 0, 0, 0, 0, 8, 2, 8, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Darion Mograine - On Spawn - Set Passive'),
(32312, 0, 18, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 19, 768, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Darion Mograine - On Spawn - Set Passive'),
(3223901, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 54, 20000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Tirion Fordring - Script - Pause WP'),
(3223901, 9, 1, 0, 0, 0, 100, 0, 15000, 15000, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Tirion Fordring - Script - Say Line 1'),
(3223901, 9, 2, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 0, 45, 9, 9, 0, 0, 0, 0, 9, 32241, 0, 50, 0, 0, 0, 0, 0, 0, 'Highlord Tirion Fordring - Script - Set Data'),
(3231200, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 11, 61487, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Darion Mograine - Script - Cast Tirions Gambit Event Credit'),
(3231200, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Darion Mograine - Script - Say Line 0'),
(3231200, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 18, 768, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Darion Mograine - Script - Say Line 0'),
(3231200, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 24, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Darion Mograine - Script - Say Line 0'),
(3231200, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Darion Mograine - Script - Say Line 0'),
(3231200, 9, 5, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 50, 193941, 120, 0, 0, 0, 0, 8, 0, 0, 0, 0, 6133.57, 2757.82, 573.914, 0, 0, 'Highlord Darion Mograine - On Data Set 2 2 - Cast Tirions Gambit Event Credit'),
(3231200, 9, 6, 0, 0, 0, 100, 0, 8000, 8000, 0, 0, 0, 45, 5, 5, 0, 0, 0, 0, 19, 32311, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Darion Mograine - Script - Set Data on Koltira Deathweaver'),
(3231200, 9, 7, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 45, 5, 5, 0, 0, 0, 0, 19, 32310, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Darion Mograine - Script - Set Data on Thassarian'),
(3231200, 9, 8, 0, 0, 0, 100, 0, 8000, 8000, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Darion Mograine - Script - Say Line 1 on Darion Mograine'),
(3231200, 9, 9, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 45, 7, 7, 0, 0, 0, 0, 19, 32184, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Darion Mograine - Script - Set Data on the Lich King'),
(3231200, 9, 10, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 45, 6, 6, 0, 0, 0, 0, 19, 32239, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Darion Mograine - Script - Set Data on Highlord Tirion Fordring'),
(3231200, 9, 11, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 45, 3, 3, 0, 0, 0, 0, 19, 32310, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Darion Mograine - Script - Set Data on Highlord Tirion Fordring'),
(3231200, 9, 12, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 45, 3, 3, 0, 0, 0, 0, 19, 32311, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Darion Mograine - Script - Set Data on Highlord Tirion Fordring'),
(3231200, 9, 13, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 45, 3, 3, 0, 0, 0, 0, 9, 32309, 0, 200, 0, 0, 0, 0, 0, 0, 'Highlord Darion Mograine - Script - Set Data on Highlord Tirion Fordring'),
(3231200, 9, 14, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 45, 4, 4, 0, 0, 0, 0, 9, 32241, 0, 200, 0, 0, 0, 0, 0, 0, 'Highlord Darion Mograine - Script - Set Data on Disguised Crusader'),
(3231200, 9, 15, 0, 0, 0, 100, 0, 7000, 7000, 0, 0, 0, 45, 6, 6, 0, 0, 0, 0, 9, 32241, 0, 200, 0, 0, 0, 0, 0, 0, 'Highlord Darion Mograine - Script - Set Data on Disguised Crusader'),
(3231200, 9, 16, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 201, 60000, 6, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Darion Mograine - Script - Despawn'),
(3231200, 9, 17, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 19, 32184, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Darion Mograine - Script - Despawn');

DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceGroup`=1 AND `SourceEntry`=60536;
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceGroup` =12 AND `SourceEntry` IN(32310,32311) AND `SourceId`=0;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES 
(13, 1, 60536, 0, 0, 31, 0, 3, 32184, 0, 1, 0, 0, '', 'Lich Kings Fury does not hit The Lich King'),
(22, 12, 32310, 0, 0, 31, 0, 4, 0, 0, 0, 0, 0, '', 'Thassarian - Only run SAI if invoker is player'),
(22, 12, 32310, 0, 0, 6, 0, 469, 0, 0, 0, 0, 0, '', 'Thassarian - Only run SAI if Player is Alliance'),
(22, 12, 32311, 0, 0, 31, 0, 4, 0, 0, 0, 0, 0, '', 'Koltira - Only run SAI if invoker is player'),
(22, 12, 32311, 0, 0, 6, 0, 67, 0, 0, 0, 0, 0, '', 'Koltira - Only run SAI if Player is Horde');

DELETE FROM `creature_text` WHERE `CreatureID`=32310;
INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES 
(32310, 0, 0, "I hope you fellows don't mind if we crash this party.  I brought some old friends with me!", 14, 0, 100, 0, 0, 32710, 0, 0, 'Thassarian'),
(32310, 1, 0, "Looks like whatever Tirion did put some hurt on the Lich King.  It's too bad we can't finish him off.... ", 12, 0, 100, 0, 0, 32722, 0, 0, 'Thassarian');

DELETE FROM `smart_scripts` WHERE  `entryorguid`=32175 AND `source_type`=0 AND `id`=9 AND `link`=0;
DELETE FROM `smart_scripts` WHERE  `entryorguid`=32175 AND `source_type`=0 AND `id`=10 AND `link`=11;
DELETE FROM `smart_scripts` WHERE  `entryorguid`=32175 AND `source_type`=0 AND `id`=11 AND `link`=0;
DELETE FROM `smart_scripts` WHERE  `entryorguid`=32175 AND `source_type`=0 AND `id`=12 AND `link`=0;
DELETE FROM `smart_scripts` WHERE  `entryorguid`=32175 AND `source_type`=0 AND `id`=5 AND `link`=6;
DELETE FROM `smart_scripts` WHERE  `entryorguid`=32175 AND `source_type`=0 AND `id`=6 AND `link`=7;
DELETE FROM `smart_scripts` WHERE  `entryorguid`=32175 AND `source_type`=0 AND `id`=7 AND `link`=0;
DELETE FROM `smart_scripts` WHERE `entryorguid`=32239 AND `source_type`=0 AND `id`=17;
UPDATE `smart_scripts` SET `action_type`='53', `action_param1`='1', `action_param2`='3223901', `target_type`='1', `target_param1`='0', `comment`='Highlord Tirion Fordring - On Data Set - Start WP (Heart)' WHERE  `entryorguid`=32239 AND `source_type`=0 AND `id`=12 AND `link`=0;
UPDATE `smart_scripts` SET `event_param1`='1500', `event_param2`='1500' WHERE  `entryorguid`=3218400 AND `source_type`=9 AND `id`=11 AND `link`=0;
UPDATE `smart_scripts` SET `event_param1`='3500', `event_param2`='3500' WHERE  `entryorguid`=3218400 AND `source_type`=9 AND `id`=12 AND `link`=0;
UPDATE `smart_scripts` SET `event_param1`='100', `event_param2`='100' WHERE  `entryorguid`=3218400 AND `source_type`=9 AND `id`=17 AND `link`=0;
UPDATE `smart_scripts` SET `event_param1`='4400', `event_param2`='4400' WHERE  `entryorguid`=3218400 AND `source_type`=9 AND `id`=20 AND `link`=0;
UPDATE `smart_scripts` SET `event_type`='1', `event_phase_mask`='2', `event_flags`='1', `event_param1`='5000', `event_param2`='5000', `comment`='Highlord Darion Mograine - OOC (Phase 2)  - Set Data 1 1 Thassarian' WHERE  `entryorguid`=32312 AND `source_type`=0 AND `id`=11 AND `link`=14;
DELETE FROM `smart_scripts` WHERE `entryorguid`=32312 AND `source_type`=0 AND `id`=19;
UPDATE `smart_scripts` SET `event_type`='1', `event_flags`='1', `event_param1`='7000', `event_param2`='7000' WHERE  `entryorguid`=32312 AND `source_type`=0 AND `id`=9 AND `link`=0;
DELETE FROM `smart_scripts` WHERE `entryorguid`=32239 AND `source_type`=0 AND `id` IN(2,3,4,5,6);

UPDATE`smart_scripts` SET `link`='0', `action_type`='80', `action_param1`='3217500', `action_param2`='2', `target_type`='1', `target_param1`='0', `comment`='Chosen Zealot - On Data Set 1 1 - Run Script' WHERE  `entryorguid`=32175 AND `source_type`=0 AND `id`=4;
DELETE FROM `smart_scripts` WHERE `entryorguid`=32175 AND `source_type`=0 AND `id`IN(5,6,7,9,10);
DELETE FROM `smart_scripts` WHERE `entryorguid`=3217500 AND `source_type`=9;
DELETE FROM `smart_scripts` WHERE `entryorguid`=3223902 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`, `event_param5`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `cus_target_param1`, `comment`) VALUES 
(3223902, 9, 0, 0, 0, 0, 100, 512, 0, 0, 0, 0, 0, 48, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Tirion Fordring - Script 3 - Set Emote State 0'),
(3223902, 9, 1, 0, 0, 0, 100, 512, 2000, 2000, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Tirion Fordring - Script 3 - Say Line 0'),
(3223902, 9, 2, 0, 0, 0, 100, 512, 5000, 5000, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 9, 32241, 0, 200, 0, 0, 0, 0, 0, 0, 'Highlord Tirion Fordring - Script 3 - Set Data Disguised Crusader'),
(3223902, 9, 3, 0, 0, 0, 100, 512, 0, 0, 0, 0, 0, 17, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Tirion Fordring - Script 3 - Set Emote State 0'),
(3223902, 9, 4, 0, 0, 0, 100, 512, 0, 0, 0, 0, 0, 53, 0, 32239, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Tirion Fordring - Script 3 - Start WP'),
(3223902, 9, 5, 0, 0, 0, 100, 512, 0, 0, 0, 0, 0, 91, 35536, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Tirion Fordring - Script 3 - Set Bytes 1'),
(32239, 0, 2, 0, 61, 0, 100, 512, 0, 0, 0, 0, 0, 80, 3223902, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Tirion Fordring - On Gossip Select  - Run Script 3'),
(32312, 0, 19, 0, 40, 0, 100, 512, 3, 32312, 0, 0, 0, 22, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Darion Mograine - On Reached WP - Set Phase 2'),
(32239, 0, 17, 0, 40, 0, 100, 1, 1, 23223901, 0, 0, 0, 11, 60456, 0, 0, 0, 0, 0, 19, 32184, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Tirion Fordring - On Reached point 1 (Heart) - Cast Tirion Smashes Heart'),
(32175, 0, 5, 0, 1, 2, 100, 512, 1000, 1000, 500, 500, 0, 49, 0, 2, 0, 0, 0, 0, 24, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - OOC (Phase 2) - Start Attack'),
(32175, 0, 6, 0, 4, 2, 100, 512, 0, 0, 0, 0, 0, 39, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - On Agro (Phase 2) - Call for Help'),
(32175, 0, 7, 0, 7, 2, 100, 512, 0, 0, 0, 0, 0, 91, 8, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - On Evade (Phase 2) - Set Bytes 1'),
(32175, 0, 9, 0, 1, 2, 100, 512, 2000, 2000, 2000, 2000, 0, 49, 0, 0, 0, 0, 0, 0, 24, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - On Evade (Phase 2) - Set Bytes 1'),
(3217500, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 19, 31239, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - Script - Face Closest Player'),
(3217500, 9, 1, 0, 0, 0, 100, 0, 500, 500, 0, 0, 0, 101, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - Script - Set Home Position'),
(3217500, 9, 2, 0, 0, 0, 100, 0, 500, 500, 0, 0, 0, 114, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 30, 0, 0, 0, 'Chosen Zealot - Script - Move Forward'),
(3217500, 9, 3, 0, 0, 0, 100, 0, 10000, 10000, 0, 0, 0, 101, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - Script - Set Home Position'),
(3217500, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 8, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - Script - Set Emote State'),
(3217500, 9, 5, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 91, 8, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - Script - Set Bytes 1'),
(3217500, 9, 6, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 17, 27, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - Script - Set Aggresive'),
(3217500, 9, 7, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 22, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - Script - Set Phase 2');

UPDATE `smart_scripts` SET `event_param1`='7' WHERE  `entryorguid`=-74515 AND `source_type`=0 AND `id`=11 AND `link`=0;
UPDATE `smart_scripts` SET `event_param1`='6' WHERE  `entryorguid`=-74514 AND `source_type`=0 AND `id`=11 AND `link`=0;
UPDATE `smart_scripts` SET `event_param1`='6' WHERE  `entryorguid`=-74513 AND `source_type`=0 AND `id`=11 AND `link`=0;
UPDATE `smart_scripts` SET `event_param1`='6' WHERE  `entryorguid`=32239 AND `source_type`=0 AND `id`=7 AND `link`=8;
UPDATE `smart_scripts` SET `event_param1`='14' WHERE  `entryorguid`=32239 AND `source_type`=0 AND `id`=9 AND `link`=0;
UPDATE `smart_scripts` SET `event_param1`='3' WHERE  `entryorguid`=32310 AND `source_type`=0 AND `id`=1 AND `link`=2;
UPDATE `smart_scripts` SET `event_param1`='4' WHERE  `entryorguid`=32311 AND `source_type`=0 AND `id`=1 AND `link`=2;
UPDATE `smart_scripts` SET `event_param1`='1' WHERE  `entryorguid`=32312 AND `source_type`=0 AND `id`=1 AND `link`=0;
UPDATE `smart_scripts` SET `event_param1`='3' WHERE  `entryorguid`=32312 AND `source_type`=0 AND `id`=6 AND `link`=0;
UPDATE `smart_scripts` SET `event_param1`='3' WHERE  `entryorguid`=32312 AND `source_type`=0 AND `id`=11 AND `link`=14;
UPDATE `smart_scripts` SET `event_param1`='3' WHERE  `entryorguid`=32312 AND `source_type`=0 AND `id`=2 AND `link`=3;
UPDATE `smart_scripts` SET `event_type`='38' WHERE  `entryorguid`=32310 AND `source_type`=0 AND `id`=9 AND `link`=10;

DELETE FROM `waypoints` WHERE `entry` IN(3224100, 3224101, 3224102,32239,3223901,32310,32311,32312);
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `orientation`, `point_comment`) VALUES 
(3223901, 1, 6132.377, 2760.764, 573.9973, 0, 'Highlord Tirion Fordring (Heart)'),
(32310, 1, 6143.527, 2738.321, 573.9141, 0, 'Thassarian'), 
(32310, 2, 6137.806, 2747.163, 573.9141, 0, 'Thassarian'), 
(32310, 3, 6131.289, 2754.726, 573.9141, 0, 'Thassarian'), 
(32311, 1, 6153.927, 2717.841, 573.9141, 0, 'Koltira Deathweaver'),
(32311, 2, 6151.802, 2721.413, 573.9141, 0, 'Koltira Deathweaver'),
(32311, 3, 6140.471, 2745.233, 573.9141, 0, 'Koltira Deathweaver'),
(32311, 4, 6136.302, 2752.293, 573.9141, 0, 'Koltira Deathweaver'),
(32312, 1, 6154.913, 2715.31, 573.9141, 0, 'Highlord Darion Mograine'),
(32312, 2, 6150.175, 2725.552, 573.9141, 0, 'Highlord Darion Mograine'),
(32312, 3, 6135.03, 2755.885, 573.914, 0, 'Highlord Darion Mograine'),
(32239, 1, 6241.011 , 2653.922 , 570.5411, 0, 'Highlord Tirion Fordring'),
(32239, 2, 6239.011 , 2644.922 , 570.5411, 0, 'Highlord Tirion Fordring'),
(32239, 3, 6224.011 , 2631.422 , 570.5411, 0, 'Highlord Tirion Fordring'),
(32239, 4, 6207.011 , 2627.922 , 570.5411, 0, 'Highlord Tirion Fordring'),
(32239, 5, 6193.261 , 2629.172 , 570.5411, 0, 'Highlord Tirion Fordring'),
(32239, 6, 6188.426 , 2638.499 , 570.2495, 0, 'Highlord Tirion Fordring'), -- Pause
(32239, 7, 6181.6 , 2656.623 , 573.5817, 0, 'Highlord Tirion Fordring'),
(32239, 8, 6174.35 , 2672.123 , 574.3317, 0, 'Highlord Tirion Fordring'),
(32239, 9, 6164.6 , 2692.873 , 574.0817, 0, 'Highlord Tirion Fordring'),
(32239, 10, 6154.6 , 2714.373 , 574.0817, 0, 'Highlord Tirion Fordring'),
(32239, 11, 6146.1 , 2732.873 , 574.0817, 0, 'Highlord Tirion Fordring'),
(32239, 12, 6160.6 , 2743.623 , 574.0817, 0, 'Highlord Tirion Fordring'),
(32239, 13, 6170.1 , 2753.873 , 574.0817, 0, 'Highlord Tirion Fordring'),
(32239, 14, 6165.772 , 2760.747 , 573.914, 0, 'Highlord Tirion Fordring'),
(3224102, 1, 6255.6 , 2654.405 , 570.5411, 0, 'Disguised Crusader 3'),
(3224102, 2, 6249.35 , 2645.405 , 570.5411, 0, 'Disguised Crusader 3'),
(3224102, 3, 6230.1 , 2629.655 , 570.5411, 0, 'Disguised Crusader 3'),
(3224102, 4, 6217.1 , 2622.655 , 570.5411, 0, 'Disguised Crusader 3'),
(3224102, 5, 6205.6 , 2622.405 , 570.5411, 0, 'Disguised Crusader 3'),
(3224102, 6, 6196.85 , 2623.905 , 570.5411, 0, 'Disguised Crusader 3'),
(3224102, 7, 6194.239 , 2628.951 , 570.2495, 0, 'Disguised Crusader 3'), -- Pause
(3224102, 8, 6185.403 , 2647.951 , 572.0817, 0, 'Disguised Crusader 3'),
(3224102, 9, 6178.403 , 2662.951 , 574.8317, 0, 'Disguised Crusader 3'),
(3224102, 10, 6164.403 , 2693.701 , 574.0817, 0, 'Disguised Crusader 3'),
(3224102, 11, 6157.653 , 2708.701 , 574.0817, 0, 'Disguised Crusader 3'),
(3224102, 12, 6148.903 , 2727.201 , 574.0817, 0, 'Disguised Crusader 3'),
(3224102, 13, 6153.403 , 2736.701 , 574.0817, 0, 'Disguised Crusader 3'),
(3224102, 14, 6178.653 , 2749.201 , 574.0817, 0, 'Disguised Crusader 3'),
(3224102, 15, 6170.568 , 2762.95 , 573.914, 0, 'Disguised Crusader 3'),
(3224101, 1, 6237.105,  2639.326,  570.5411, 0, 'Disguised Crusader 2'),
(3224101, 2, 6230.855,  2634.076,  570.5411, 0, 'Disguised Crusader 2'),
(3224101, 3, 6218.105,  2624.826,  570.5411, 0, 'Disguised Crusader 2'),
(3224101, 4, 6198.605,  2617.576,  570.5411, 0, 'Disguised Crusader 2'),
(3224101, 5, 6188.855,  2621.576,  570.5411, 0, 'Disguised Crusader 2'),
(3224101, 6, 6183.26,  2631.216,  570.2495, 0, 'Disguised Crusader 2'), -- Pause
(3224101, 7, 6176.773,  2653.593,  573.8317, 0, 'Disguised Crusader 2'),
(3224101, 8, 6168.773,  2671.843,  574.3317, 0, 'Disguised Crusader 2'),
(3224101, 9, 6159.773, 2691.343,  574.0817, 0, 'Disguised Crusader 2'),
(3224101, 10, 6148.523,  2715.593,  574.0817, 0, 'Disguised Crusader 2'),
(3224101, 11, 6140.773,  2732.093,  574.0817, 0, 'Disguised Crusader 2'),
(3224101, 12, 6159.023,  2742.843,  574.0817, 0, 'Disguised Crusader 2'),
(3224101, 13, 6174.273,  2749.343,  574.0817, 0, 'Disguised Crusader 2'),
(3224101, 14, 6168.286,  2761.969,  573.914, 0, 'Disguised Crusader 2'),
(3224100, 1, 6238.134 , 2664.245 , 570.5411, 0, 'Disguised Crusader 1'),
(3224100, 2, 6238.134 , 2651.495 , 570.5411, 0, 'Disguised Crusader 1'),
(3224100, 3, 6229.384 , 2629.995 , 570.5411, 0, 'Disguised Crusader 1'),
(3224100, 4, 6210.384 , 2622.745 , 570.5411, 0, 'Disguised Crusader 1'),
(3224100, 5, 6200.634 , 2631.995 , 570.5411, 0, 'Disguised Crusader 1'),
(3224100, 6, 6197.816 , 2637.269 , 570.2495, 0, 'Disguised Crusader 1'), -- Pause
(3224100, 7, 6188.065 , 2657.21 , 573.8317, 0, 'Disguised Crusader 1'),
(3224100, 8, 6178.815 , 2677.46 , 574.3317, 0, 'Disguised Crusader 1'),
(3224100, 9, 6171.315 , 2691.71 , 574.0817, 0, 'Disguised Crusader 1'),
(3224100, 10, 6163.565 , 2707.96 , 574.0817, 0, 'Disguised Crusader 1'),
(3224100, 11, 6159.815 , 2715.71 , 574.0817, 0, 'Disguised Crusader 1'),
(3224100, 12, 6151.315 , 2733.71 , 574.0817, 0, 'Disguised Crusader 1'),
(3224100, 13, 6154.565 , 2737.46 , 574.0817, 0, 'Disguised Crusader 1'),
(3224100, 14, 6179.565 , 2751.46 , 574.0817, 0, 'Disguised Crusader 1'),
(3224100, 15, 6173.314 , 2764.15 , 573.914, 0, 'Disguised Crusader 1');

UPDATE `smart_scripts` SET `action_param1`='11', `action_param2`='11' WHERE  `entryorguid`=3223900 AND `source_type`=9 AND `id`IN(0,1,2);
UPDATE `smart_scripts` SET `event_param1`='11', `event_param2`='11' WHERE  `entryorguid` IN(-4000216,-4000215,-4000214) AND `source_type`=0 AND `id`=2 AND `link`=3;
DELETE FROM `smart_scripts` WHERE  `entryorguid`=32175 AND `source_type`=0 AND `id`=9 AND `link`=0;
UPDATE `smart_scripts` SET `action_type`='19', `action_param1`='32312' WHERE  `entryorguid`=32175 AND `source_type`=0 AND `id`=5 AND `link`=0;
DELETE FROM `waypoints` WHERE `entry` =3223901;
DELETE FROM `smart_scripts` WHERE  `entryorguid`=32239 AND `source_type`=0 AND `id`=17 AND `link`=0;
UPDATE `smart_scripts` SET `event_param1`='4000', `event_param2`='4000' WHERE  `entryorguid`=3218400 AND `source_type`=9 AND `id`=11 AND `link`=0;
UPDATE `smart_scripts` SET `event_param1`='1000', `event_param2`='1000' WHERE  `entryorguid`=3218400 AND `source_type`=9 AND `id`=12 AND `link`=0;
UPDATE `smart_scripts` SET `target_y`='25' WHERE  `entryorguid`=3217500 AND `source_type`=9 AND `id`=2 AND `link`=0;
DELETE FROM `smart_scripts` WHERE `entryorguid`=32184 AND `source_type`=0 AND `id` =11;
DELETE FROM `smart_scripts` WHERE `entryorguid`=32239 AND `source_type`=0 AND `id`=12 AND `link`=0;
DELETE FROM `smart_scripts` WHERE `entryorguid`=3223902 AND `source_type`=9 AND `id` IN(6,7);
DELETE FROM `smart_scripts` WHERE `entryorguid`=3217500 AND `source_type`=9;
DELETE FROM `smart_scripts` WHERE  `entryorguid`=3231200 AND `source_type`=9 AND `id`=17 AND `link`=0;
UPDATE `smart_scripts` SET `action_param1`='2000' WHERE  `entryorguid` IN(-74515,-74513,-74514) AND `source_type`=0 AND `id`=6 AND `link`=0;
UPDATE `smart_scripts` SET `action_param1`='8000', `action_param2`='0' WHERE  `entryorguid`=3231200 AND `source_type`=9 AND `id`=16 AND `link`=0;
UPDATE `smart_scripts` SET `event_param1`='0', `event_param2`='0' WHERE  `entryorguid`=3231200 AND `source_type`=9 AND `id`=15 AND `link`=0;
UPDATE `smart_scripts` SET `event_param1`='10000', `event_param2`='10000' WHERE  `entryorguid`=3231200 AND `source_type`=9 AND `id`=9 AND `link`=0;
UPDATE `smart_scripts` SET `link`='11' WHERE  `entryorguid`=32184 AND `source_type`=0 AND `id`=10 AND `link`=0;
UPDATE `smart_scripts` SET `action_param1`='2000' WHERE  `entryorguid`=32310 AND `source_type`=0 AND `id`=5 AND `link`=6;
UPDATE `smart_scripts` SET `action_param1`='2000' WHERE  `entryorguid`=32311 AND `source_type`=0 AND `id`=5 AND `link`=6;
UPDATE `smart_scripts` SET `action_param1`='2000' WHERE  `entryorguid`=32239 AND `source_type`=0 AND `id`=16 AND `link`=0;
UPDATE `smart_scripts` SET `action_param1`='2000' WHERE  `entryorguid`=32309 AND `source_type`=0 AND `id`=5 AND `link`=6;
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`, `event_param5`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `cus_target_param1`, `comment`) VALUES 
(32184, 0, 11, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 42, 99, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Lich King - On Spawn - Set Invincible'),
(32239, 0, 12, 0, 38, 0, 100, 0, 2, 2, 0, 0, 0, 11, 60456, 0, 0, 0, 0, 0, 19, 32184, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Tirion Fordring - On Data Set - Cast Tirion Smashes Heart'),
(3223902, 9, 6, 0, 0, 0, 100, 512, 0, 0, 0, 0, 0, 28, 49414, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Highlord Tirion Fordring - Script 3 - Remove Aura'),
(3223902, 9, 7, 0, 0, 0, 100, 512, 0, 0, 0, 0, 0, 28, 49414, 0, 0, 0, 0, 0, 9, 32241, 0, 100, 0, 0, 0, 0, 0, 0, 'Highlord Tirion Fordring - Script 3 - Remove Aura'),
(3217500, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 19, 31239, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - Script - Face Closest Player'),
(3217500, 9, 1, 0, 0, 0, 100, 0, 500, 500, 0, 0, 0, 101, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - Script - Set Home Position'),
(3217500, 9, 2, 0, 0, 0, 100, 0, 500, 500, 0, 0, 0, 114, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 30, 0, 0, 0, 'Chosen Zealot - Script - Move Forward'),
(3217500, 9, 3, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 0, 29, 15, 0, 0, 0, 0, 0, 19, 32239, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - Script - Move Forward'),
(3217500, 9, 4, 0, 0, 0, 100, 0, 5000, 50000, 0, 0, 0, 101, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - Script - Set Home Position'),
(3217500, 9, 5, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 8, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - Script - Set Emote State'),
(3217500, 9, 6, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 91, 8, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - Script - Set Bytes 1'),
(3217500, 9, 7, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 17, 27, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - Script - Set Aggresive'),
(3217500, 9, 8, 0, 0, 0, 100, 0, 60000, 60000, 0, 0, 0, 22, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Chosen Zealot - Script - Set Phase 2');
@ghost
Copy link

ghost commented Mar 8, 2020

Nice job, thank you for working on this.

@Estarzero Estarzero mentioned this issue Mar 17, 2020
Closed
@Killyana Killyana self-assigned this May 20, 2020
@CraftedRO
Copy link
Contributor

CraftedRO commented Oct 10, 2021 •
edited

@CGUID shoud be replaced with an empty guid or ?
However the quest works fine on tc even without this , the only problems I can track is that the Lich King is attackable and he can also take cc (I even gripped it) and another one is that his health doesn't drop half.
Update : If you don't take portal , all the zealots will kneel while following you as friendly minions (untill the mask buff) and if you remove the buff they attack you :)
WoWScrnShot_101021_130406

@offl
Copy link
Contributor

offl commented Oct 10, 2021

Some of not yet pushed SAI fixes cannot be applied anymore without changes to script
Lot of UPDATE queries to smart_scripts may not safe anymore

@CraftedRO
Copy link
Contributor

CraftedRO commented Oct 11, 2021 •
edited

can we meanwhile add this ? :

UPDATE `creature_template` SET `unit_flags` = 256 WHERE `entry` = 32184;

Now seems more blizzlike
https://youtu.be/-OVz8CXtI6w?t=354

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@Killyana Killyana

Labels
Branch-3.3.5a Comp-Database Feedback-FixOutdatedMissingWIP
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
5 participants
@Aokromes @dr-j @Killyana @offl @CraftedRO