Trinitycore: Updates for Argent Tournament Horde/Alliance/Tirion Events

Created on 7 Mar 2020  路  12Comments  路  Source: TrinityCore/TrinityCore

  • Change the way these events to make more reliable
  • Implement flying mounts for Varian/Jaina/Thrall/Garrosh so these appear to fly to the tournament grounds (this will however fail if grid is not loaded at time when the npcs spawn for event, initial spawns of npcs and vehicles are in silent vigil (2 diferent close by locations)
    ~~~sql
    SET @CGUID := xxxxxxx;

DELETE FROM creature_summon_groups WHERE summonerId=35501;

UPDATE game_event SET length='10' WHERE eventEntry IN(67,68,69);

DELETE FROM creature WHERE guid BETWEEN @CGUID+0 AND @CGUID+19 AND id IN(35372,35368,35460,35361,35321,35320,35322,35299,35373);
INSERT INTO creature (guid, id, map, zoneId, areaId, spawnMask, phaseMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, wander_distance, currentwaypoint, curhealth, curmana, MovementType, npcflag, unit_flags, dynamicflags, ScriptName, VerifiedBuild) VALUES
(+@CGUID+0, 35372, 571, 0, 0, 1, 1, 0, 1, 8182.991, 661.3733, 584.973, 0, 900, 0, 0, 1, 0, 0, 0, 0, 0, '', 0),
(+@CGUID+1, 35368, 571, 0, 0, 1, 1, 0, 1, 8189.663, 662.0833, 588.7211, 1.570796, 900, 0, 0, 1, 0, 0, 0, 0, 0, '', 0),
(+@CGUID+2, 35460, 571, 0, 0, 1, 1, 0, 1, 8431.85, 783.523, 547.189, 4.80006, 900, 0, 0, 1, 0, 0, 0, 0, 0, '', 0),
(+@CGUID+3, 35460, 571, 0, 0, 1, 1, 0, 1, 8431.82, 786.166, 547.023, 4.75293, 900, 0, 0, 1, 0, 0, 0, 0, 0, '', 0),
(+@CGUID+4, 35460, 571, 0, 0, 1, 1, 0, 1, 8432.08, 788.975, 547.023, 4.72544, 900, 0, 0, 1, 0, 0, 0, 0, 0, '', 0),
(+@CGUID+5, 35460, 571, 0, 0, 1, 1, 0, 1, 8431.93, 792.52, 547.023, 4.73172, 900, 0, 0, 1, 0, 0, 0, 0, 0, '', 0),
(+@CGUID+6, 35361, 571, 0, 0, 1, 1, 0, 1, 8514.48, 1002.04, 547.543, 1.54998, 900, 0, 0, 1, 0, 0, 0, 0, 0, '', 0),
(+@CGUID+7, 35321, 571, 0, 0, 1, 1, 0, 1, 8280.653, 589.4809, 629.1866, 0.8028514, 900, 0, 0, 1, 0, 0, 0, 0, 0, '', 0),
(+@CGUID+8, 35320, 571, 0, 0, 1, 1, 0, 1, 8272.021, 590.3993, 630.7748, 0, 900, 0, 0, 1, 0, 0, 0, 0, 0, '', 0),
(+@CGUID+9, 35322, 571, 0, 0, 1, 1, 0, 1, 8598.43, 782.77, 547.233, 4.03508, 900, 0, 0, 1, 0, 0, 0, 0, 0, '', 0),
(+@CGUID+10, 35322, 571, 0, 0, 1, 1, 0, 1, 8599.85, 786.899, 547.106, 4.03508, 900, 0, 0, 1, 0, 0, 0, 0, 0, '', 0),
(+@CGUID+11, 35322, 571, 0, 0, 1, 1, 0, 1, 8599.95, 789.887, 547.102, 4.03508, 900, 0, 0, 1, 0, 0, 0, 0, 0, '', 0),
(+@CGUID+12, 35322, 571, 0, 0, 1, 1, 0, 1, 8600.09, 792.962, 547.092, 4.03508, 900, 0, 0, 1, 0, 0, 0, 0, 0, '', 0),
(+@CGUID+13, 35361, 571, 0, 0, 1, 1, 0, 1, 8514.87, 999.861, 547.536, 1.56404, 900, 0, 0, 1, 0, 0, 0, 0, 0, '', 0),
(+@CGUID+14, 35361, 571, 0, 0, 1, 1, 0, 1, 8516.17, 857.121, 558.224, 1.62047, 900, 0, 0, 1, 0, 0, 0, 0, 0, '', 0),
(+@CGUID+15, 35373, 571, 0, 0, 1, 1, 0, 0, 8189.473, 662.5625, 588.4474, 1.658063, 900, 0, 0, 1, 0, 0, 0, 0, 0, '', 0),
(+@CGUID+16, 35373, 571, 0, 0, 1, 1, 0, 0, 8182.767, 660.9809, 584.986, 1.62047, 900, 0, 0, 1, 0, 0, 0, 0, 0, '', 0),
(+@CGUID+17, 35299, 571, 0, 0, 1, 1, 0, 0, 8271.837, 590.3577, 630.8472, 0.715585, 900, 0, 0, 1, 0, 0, 0, 0, 0, '', 0),
(+@CGUID+18, 35299, 571, 0, 0, 1, 1, 0, 0, 8280.147, 589.0052, 629.2678, 0.9948376, 900, 0, 0, 1, 0, 0, 0, 0, 0, '', 0);

DELETE FROM game_event_creature WHERE eventEntry IN(67,68,69);
INSERT INTO game_event_creature (eventEntry, guid) VALUES
(68, @CGUID+0),
(68, @CGUID+1),
(68, @CGUID+2),
(68, @CGUID+3),
(68, @CGUID+4),
(68, @CGUID+5),
(68, @CGUID+6),
(68, @CGUID+15),
(68, @CGUID+16),
(69, @CGUID+7),
(69, @CGUID+8),
(69, @CGUID+9),
(69, @CGUID+10),
(69, @CGUID+11),
(69, @CGUID+12),
(69, @CGUID+13),
(69, @CGUID+17),
(69, @CGUID+18),
(67, @CGUID+14);

UPDATE creature_template SET AIName='SmartAI' WHERE entry=35299;
UPDATE creature_template SET minlevel='75', maxlevel='75', AIName='SmartAI' WHERE entry=35373;

DELETE FROM creature_template_movement WHERE CreatureId IN(35299,35373);
INSERT INTO creature_template_movement (CreatureId, Ground, Flight) VALUES
(35299, 1, 1),
(35373, 1, 1);

DELETE FROM smart_scripts WHERE entryorguidIN(-@CGUID-2,-@CGUID-3,-@CGUID-4,-@CGUID-5) AND source_type=0;
DELETE FROM smart_scripts WHERE entryorguidIN(-@CGUID-9,-@CGUID-10,-@CGUID-11,-@CGUID-12) AND source_type=0;
DELETE FROM smart_scripts WHERE entryorguidIN(-@CGUID-15,-@CGUID-16,-@CGUID-17,-@CGUID-18) AND source_type=0;
DELETE FROM smart_scripts WHERE entryorguid=35368 AND source_type=0 AND id=1 AND link=0;
DELETE FROM smart_scripts WHERE entryorguid=35320 AND source_type=0 AND id=5;
DELETE FROM smart_scripts WHERE entryorguid=35321 AND source_type=0 AND idIN(7,8);
DELETE FROM smart_scripts WHERE entryorguid=35372 AND source_type=0 AND id=8;
DELETE FROM smart_scripts WHERE entryorguid=35368 AND source_type=0 AND id=9;
DELETE FROM smart_scripts WHERE entryorguid=35321 AND source_type=0 AND id=6;
DELETE FROM smart_scripts WHERE entryorguid=35361 AND source_type=0 AND id=8;
DELETE FROM smart_scripts WHERE entryorguid=35320 AND source_type=0 AND id=4;
DELETE FROM smart_scripts WHERE entryorguid=35368 AND source_type=0 AND id IN(8,10);
DELETE FROM smart_scripts WHERE entryorguid=35372 AND source_type=0 AND id=7;
DELETE FROM smart_scripts WHERE entryorguid=35372 AND source_type=0 AND id=9;
DELETE FROM smart_scripts WHERE entryorguid=35320 AND source_type=0 AND id=6;
DELETE FROM smart_scripts WHERE entryorguid=35368 AND source_type=0 AND id=1;
DELETE FROM smart_scripts WHERE entryorguid=35372 AND source_type=0 AND id=10;
DELETE FROM smart_scripts WHERE entryorguid=35361 AND source_type=0 AND id IN(9,10);
DELETE FROM smart_scripts WHERE entryorguidIN(35501,35322,35460.35299,35373) AND source_type=0;
DELETE FROM smart_scripts WHERE entryorguidin(3550100,3550101,3550102,3536802) AND source_type=9;

UPDATE smart_scripts SET event_param1='15' WHERE entryorguid=35320 AND source_type=0 AND id=1 AND link=0;
UPDATE smart_scripts SET event_param1='20' WHERE entryorguid=35320 AND source_type=0 AND id=2 AND link=0;
UPDATE smart_scripts SET event_param1='15' WHERE entryorguid=35321 AND source_type=0 AND id=2 AND link=3;
UPDATE smart_scripts SET event_param1='23' WHERE entryorguid=35321 AND source_type=0 AND id=4 AND link=5;
UPDATE smart_scripts SET event_param1='11' WHERE entryorguid=35368 AND source_type=0 AND id=2 AND link=3;
UPDATE smart_scripts SET event_param1='16' WHERE entryorguid=35368 AND source_type=0 AND id=4 AND link=5;
UPDATE smart_scripts SET event_param1='23' WHERE entryorguid=35368 AND source_type=0 AND id=6 AND link=7;
UPDATE smart_scripts SET event_param1='11' WHERE entryorguid=35372 AND source_type=0 AND id=1 AND link=0;
UPDATE smart_scripts SET event_param1='16' WHERE entryorguid=35372 AND source_type=0 AND id=3 AND link=0;
UPDATE smart_scripts SET event_param1='23' WHERE entryorguid=35372 AND source_type=0 AND id=4 AND link=0;
UPDATE smart_scripts SET action_type='11', action_param1='69003', action_param2='0', target_type='1', target_param1='0', target_param3='0', comment='King Varian Wrynn - On Data Set - Cast [DND] Argent Tournament - Event Controller - Alliance' WHERE entryorguid=35321 AND source_type=0 AND id=0 AND link=1;
UPDATE smart_scripts SET link='6' WHERE entryorguid=35320 AND source_type=0 AND id=0;
UPDATE .smart_scripts SET link='10' WHERE entryorguid=35372 AND source_type=0 AND id=0;
UPDATE smart_scripts SET link='1' WHERE entryorguid=35368 AND source_type=0 AND id=0;
uPDATE smart_scripts SET event_type='38', event_param1='7', event_param2='7' WHERE entryorguid=35320 AND source_type=0 AND id=0 AND link=0;
UPDATE smart_scripts SET event_type='38', event_param1='7', event_param2='7' WHERE entryorguid=35321 AND source_type=0 AND id=0 AND link=1;
UPDATE smart_scripts SET event_type='38', event_param1='7', event_param2='7' ,action_param1='3536802' ,target_type='1', target_param1='0',target_param3='0' WHERE entryorguid=35368 AND source_type=0 AND id=0 AND link=1;
UPDATE smart_scripts SET event_type='38', event_param1='7', event_param2='7' WHERE entryorguid=35372 AND source_type=0 AND id=0 AND link=0;
UPDATE smart_scripts SET action_type='80', action_param1='3526802', action_param2='2' WHERE entryorguid=35368 AND source_type=0 AND id=0 AND link=1;

INSERT INTO smart_scripts (entryorguid, source_type, id, link, event_type, event_phase_mask, event_chance, event_flags, event_param1, event_param2, event_param3, event_param4, action_type, action_param1, action_param2, action_param3, action_param4, action_param5, action_param6, target_type, target_param1, target_param2, target_param3, target_x, target_y, target_z, target_o, comment) VALUES
(-@CGUID-18, 0, 0, 1, 27, 0, 100, 512, 0, 0, 0, 0, 60, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Royal Gryphon - On Passenger Boarded - Turn Fly on'),
(-@CGUID-18, 0, 1, 0, 61, 0, 100, 512, 0, 0, 0, 0, 53, 1, 3529900, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Royal Gryphon - On Passenger Boarded - Start WP'),
(-@CGUID-18, 0, 2, 3, 40, 0, 100, 512, 16, 0, 0, 0, 11, 50630, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Royal Gryphon - On reached WP16 - Cast Eject all passengers'),
(-@CGUID-18, 0, 3, 0, 61, 0, 100, 512, 2, 0, 0, 0, 45, 7, 7, 0, 0, 0, 0, 19, 35321, 0, 0, 0, 0, 0, 0, 'Royal Gryphon - On reached WP16 - Set Data'),
(-@CGUID-18, 0, 4, 0, 40, 0, 100, 512, 25, 0, 0, 0, 41, 1000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Royal Gryphon - On reached WP25 - Despawn'),
(-@CGUID-18, 0, 5, 0, 11, 0, 100, 512, 2, 0, 0, 0, 48, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Royal Gryphon - On Spawn - Set Active'),
(-@CGUID-17, 0, 0, 1, 27, 0, 100, 512, 0, 0, 0, 0, 60, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Royal Gryphon - On Passenger Boarded - Turn Fly on'),
(-@CGUID-17, 0, 1, 0, 61, 0, 100, 512, 0, 0, 0, 0, 53, 1, 35299, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Royal Gryphon - On Passenger Boarded - Start WP'),
(-@CGUID-17, 0, 2, 3, 40, 0, 100, 512, 15, 0, 0, 0, 11, 50630, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Royal Gryphon - On reached WP15 - Cast Eject all passengers'),
(-@CGUID-17, 0, 3, 0, 61, 0, 100, 512, 2, 0, 0, 0, 45, 7, 7, 0, 0, 0, 0, 19, 35320, 0, 0, 0, 0, 0, 0, 'Royal Gryphon - On reached WP15 - Set Data'),
(-@CGUID-17, 0, 4, 0, 40, 0, 100, 512, 25, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Royal Gryphon - On reached WP25 - Despawn'),
(-@CGUID-17, 0, 5, 0, 11, 0, 100, 512, 2, 0, 0, 0, 48, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Royal Gryphon - On Spawn - Set Active'),
(-@CGUID-16, 0, 0, 1, 27, 0, 100, 512, 0, 0, 0, 0, 60, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Tournament Windrider - On Passenger Boarded - Turn Fly on'),
(-@CGUID-16, 0, 1, 0, 61, 0, 100, 512, 0, 0, 0, 0, 53, 1, 3537300, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Tournament Windrider - On Passenger Boarded - Start WP'),
(-@CGUID-16, 0, 2, 3, 40, 0, 100, 512, 11, 0, 0, 0, 11, 50630, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Tournament Windrider - On reached WP11 - Cast Eject all passengers'),
(-@CGUID-16, 0, 3, 0, 61, 0, 100, 512, 2, 0, 0, 0, 45, 7, 7, 0, 0, 0, 0, 19, 35372, 0, 0, 0, 0, 0, 0, 'Tournament Windrider - On reached WP11 - Set Data'),
(-@CGUID-16, 0, 4, 0, 40, 0, 100, 512, 19, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Tournament Windrider - On reached WP19 - Despawn'),
(-@CGUID-16, 0, 5, 0, 11, 0, 100, 512, 2, 0, 0, 0, 48, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Tournament Windrider - On Spawn - Set Active'),
(-@CGUID-15, 0, 0, 1, 27, 0, 100, 512, 0, 0, 0, 0, 60, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Tournament Windrider - On Passenger Boarded - Turn Fly on'),
(-@CGUID-15, 0, 1, 0, 61, 0, 100, 512, 0, 0, 0, 0, 53, 1, 35373, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Tournament Windrider - On Passenger Boarded - Start WP'),
(-@CGUID-15, 0, 2, 3, 40, 0, 100, 512, 10, 0, 0, 0, 11, 50630, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Tournament Windrider - On reached WP10 - Cast Eject all passengers'),
(-@CGUID-15, 0, 3, 0, 61, 0, 100, 512, 2, 0, 0, 0, 45, 7, 7, 0, 0, 0, 0, 19, 35368, 0, 0, 0, 0, 0, 0, 'Tournament Windrider - On reached WP10 - Set Data'),
(-@CGUID-15, 0, 4, 0, 40, 0, 100, 512, 19, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Tournament Windrider - On reached WP19 - Despawn'),
(-@CGUID-15, 0, 5, 0, 11, 0, 100, 512, 2, 0, 0, 0, 48, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Tournament Windrider - On Spawn - Set Active'),
(-@CGUID-12, 0, 0, 0, 38, 0, 100, 512, 2, 2, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Stormwind Royal Guard - on Data Set 2 2 - Despawn'),
(-@CGUID-12, 0, 1, 0, 38, 0, 100, 1, 1, 1, 0, 0, 29, 5, 0, 0, 0, 0, 0, 19, 35321, 0, 0, 0, 0, 0, 0, 'Stormwind Royal Guard - OOC - Follow King Varian Wrynn'),
(-@CGUID-11, 0, 0, 0, 38, 0, 100, 512, 2, 2, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Stormwind Royal Guard - on Data Set 2 2 - Despawn'),
(-@CGUID-11, 0, 1, 0, 38, 0, 100, 1, 1, 1, 0, 0, 29, 4, 0, 0, 0, 0, 0, 19, 35321, 0, 0, 0, 0, 0, 0, 'Stormwind Royal Guard - OOC - Follow King Varian Wrynn'),
(-@CGUID-10, 0, 0, 0, 38, 0, 100, 512, 2, 2, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Stormwind Royal Guard - on Data Set 2 2 - Despawn'),
(-@CGUID-10, 0, 1, 0, 38, 0, 100, 1, 1, 1, 0, 0, 29, 3, 0, 0, 0, 0, 0, 19, 35321, 0, 0, 0, 0, 0, 0, 'Stormwind Royal Guard - OOC - Follow King Varian Wrynn'),
(-@CGUID-9, 0, 0, 0, 38, 0, 100, 512, 2, 2, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Stormwind Royal Guard - on Data Set 2 2 - Despawn'),
(-@CGUID-9, 0, 1, 0, 38, 0, 100, 1, 1, 1, 0, 0, 29, 2, 0, 0, 0, 0, 0, 19, 35321, 0, 0, 0, 0, 0, 0, 'Stormwind Royal Guard - OOC - Follow King Varian Wrynn'),
(-@CGUID-5, 0, 0, 0, 38, 0, 100, 512, 2, 2, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Kor Kron Elite - on Data Set 2 2 - Despawn'),
(-@CGUID-5, 0, 1, 0, 38, 0, 100, 1, 1, 1, 0, 0, 29, 5, 0, 0, 0, 0, 0, 19, 35368, 0, 0, 0, 0, 0, 0, 'Kor Kron Elite - OOC - Follow Thrall'),
(-@CGUID-4, 0, 0, 0, 38, 0, 100, 512, 2, 2, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Kor Kron Elite - on Data Set 2 2 - Despawn'),
(-@CGUID-4, 0, 1, 0, 38, 0, 100, 1, 1, 1, 0, 0, 29, 4, 0, 0, 0, 0, 0, 19, 35368, 0, 0, 0, 0, 0, 0, 'Kor Kron Elite - OOC - Follow Thrall'),
(-@CGUID-3, 0, 0, 0, 38, 0, 100, 512, 2, 2, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Kor Kron Elite - on Data Set 2 2 - Despawn'),
(-@CGUID-3, 0, 1, 0, 38, 0, 100, 1, 1, 1, 0, 0, 29, 3, 0, 0, 0, 0, 0, 19, 35368, 0, 0, 0, 0, 0, 0, 'Kor Kron Elite - OOC - Follow Thrall'),
(-@CGUID-2, 0, 0, 0, 38, 0, 100, 512, 2, 2, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Kor Kron Elite - on Data Set 2 2 - Despawn'),
(-@CGUID-2, 0, 1, 0, 38, 0, 100, 1, 1, 1, 0, 0, 29, 2, 0, 0, 0, 0, 0, 19, 35368, 0, 0, 0, 0, 0, 0, 'Kor Kron Elite - OOC - Follow Thrall'),
(35320, 0, 4, 0, 25, 0, 100, 512, 0, 0, 0, 0, 48, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Lady Jaina Proudmoore - On Reset Set Active'),
(35320, 0, 5, 0, 11, 0, 100, 512, 0, 0, 0, 0, 11, 46598, 0, 0, 0, 0, 0, 19, 35299, 0, 0, 0, 0, 0, 0, 'Lady Jaina Proudmoore - On Spawn - Mount '),
(35321, 0, 6, 0, 25, 0, 100, 512, 0, 0, 0, 0, 48, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'King Varian Wrynn - On Reset - Set Active'),
(35321, 0, 7, 0, 11, 0, 100, 512, 0, 0, 0, 0, 11, 46598, 0, 0, 0, 0, 0, 19, 35299, 0, 0, 0, 0, 0, 0, 'King Varian Wrynn - On Spawn - Mount'),
(35321, 0, 8, 0, 40, 0, 100, 512, 6, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 9, 35322, 0, 100, 0, 0, 0, 0, 'King Varian Wrynn - On Reached WP - Set Data'),
(35361, 0, 8, 0, 25, 0, 100, 512, 0, 0, 0, 0, 48, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Highlord Tirion Fordring - On Reset Set Active'),
(35368, 0, 8, 0, 25, 0, 100, 512, 0, 0, 0, 0, 48, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Thrall - On Reset - Set Active'),
(35368, 0, 9, 0, 11, 0, 100, 512, 0, 0, 0, 0, 11, 46598, 0, 0, 0, 0, 0, 19, 35373, 0, 0, 0, 0, 0, 0, 'Thrall - On Spawn - Mount'),
(35368, 0, 10, 0, 40, 0, 100, 512, 6, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 9, 35460, 0, 100, 0, 0, 0, 0, 'Thrall - On Reached WP6 - Set Data'),
(35372, 0, 7, 0, 25, 0, 100, 512, 0, 0, 0, 0, 48, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Garrosh Hellscream - On Reaet - Set Active'),
(35372, 0, 8, 0, 11, 0, 100, 512, 0, 0, 0, 0, 11, 46598, 0, 0, 0, 0, 0, 19, 35373, 0, 0, 0, 0, 0, 0, 'Garrosh Hellscream - On Spawn - Mount'),
(35372, 0, 9, 0, 40, 0, 100, 512, 1, 35372, 0, 0, 54, 2000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Garrosh Hellscream - On Reached WP1 - Pause'),
(35501, 0, 0, 1, 68, 0, 100, 512, 67, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Herald Beluus - On Event Start 67 - Say Line 2'),
(35501, 0, 1, 0, 61, 0, 100, 512, 0, 0, 0, 0, 45, 3, 3, 0, 0, 0, 0, 19, 35361, 0, 0, 0, 0, 0, 0, 'Herald Beluus - On Data Set 3 3 - Set Data 3 3 on Tirion Fordring'),
(35501, 0, 2, 0, 68, 0, 100, 512, 68, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Herald Beluus - On Event Start 68 - Say Line 0'),
(35501, 0, 3, 0, 68, 0, 100, 512, 69, 0, 0, 0, 1, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Herald Beluus - On Event Start 69 - Say Line 1'),
(35501, 0, 5, 0, 25, 0, 100, 512, 0, 0, 0, 0, 48, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Herald Beluus - On Reset - Set Active'),
(3536802, 9, 0, 0, 0, 0, 100, 512, 0, 0, 0, 0, 5, 273, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Thrall - Script 3 - Play Emote OneShotYes'),
(3536802, 9, 1, 0, 0, 0, 100, 512, 2000, 2000, 0, 0, 53, 0, 35368, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Thrall - Script 3 - Start WP'),
(35361, 0, 9, 0, 54, 0, 100, 512, 0, 0, 0, 0, 11, 69096, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Highlord Tirion Fordring - On Just Summoned - Cast 69096 [DND] Argent Tournament - Event Controller Tirion - Horde'),
(35361, 0, 10, 0, 54, 0, 100, 512, 0, 0, 0, 0, 11, 69095, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Highlord Tirion Fordring - On Just Summoned - Cast 69096 [DND] Argent Tournament - Event Controller Tirion - Alliance'),
(35320, 0, 6, 0, 61, 0, 100, 512, 0, 0, 0, 0, 11, 69003, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Lady Jaina Proudmoore - On Data Set - Cast [DND] Argent Tournament - Event Controller - Alliance'),
(35368, 0, 1, 1, 61, 0, 100, 512, 0, 0, 0, 0, 11, 69007, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Thrall - On Data Set - Cast 69007 [DND] Argent Tournament - Event Controller - Horde'),
(35372, 0, 10, 0, 61, 0, 100, 512, 0, 0, 0, 0, 11, 69007, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Garrosh Hellscream - On Data Set - Cast [DND] Argent Tournament - Event Controller - Horde');

DELETE FROM waypoints WHERE entry IN(35373,3537300,35299,3529900,35320,35321,35368,35372);
INSERT INTO waypoints (entry, pointid, position_x, position_y, position_z, orientation, point_comment) VALUES
(35373, 1, 8183.713, 667.4739, 598.4862, 0, 'Thrall'),
(35373, 2, 8183.558, 684.4149, 599.3198, 0, 'Thrall'),
(35373, 3, 8191.257, 702.1684, 605.3474, 0, 'Thrall'),
(35373, 4, 8213.932, 710.3785, 611.9018, 0, 'Thrall'),
(35373, 5, 8245.909, 700.5938, 617.5123, 0, 'Thrall'),
(35373, 6, 8374.998, 624.1146, 603.6246, 0, 'Thrall'),
(35373, 7, 8442.234, 627.6424, 586.9026, 0, 'Thrall'),
(35373, 8, 8460.104, 663.1354, 570.708, 0, 'Thrall'),
(35373, 9, 8434.889, 716.4566, 554.9306, 0, 'Thrall'),
(35373, 10, 8409.114, 744.2797, 547.6277, 0, 'Thrall'),
(35373, 11, 8382.473, 770.2083, 560.1245, 0, 'Thrall'),
(35373, 12, 8389.666, 799.1927, 571.7078, 0, 'Thrall'),
(35373, 13, 8439.088, 844.9531, 577.4577, 0, 'Thrall'),
(35373, 14, 8491.686, 872.4236, 581.8465, 0, 'Thrall'),
(35373, 15, 8573.325, 890.7691, 581.8465, 0, 'Thrall'),
(35373, 16, 8658.294, 896.4809, 581.8465, 0, 'Thrall'),
(35373, 17, 8698.516, 897.493, 562.6515, 0, 'Thrall'),
(35373, 18, 8789.742, 895.7639, 452.625, 0, 'Thrall'),
(35373, 19, 8915.26, 1045.318, 452.625, 0, 'Thrall'),
(3537300, 1, 8183.713, 667.4739, 598.4862, 0, 'Garrosh'),
(3537300, 2, 8183.558, 684.4149, 599.3198, 0, 'Garrosh'),
(3537300, 3, 8191.257, 702.1684, 605.3474, 0, 'Garrosh'),
(3537300, 4, 8213.932, 710.3785, 611.9018, 0, 'Garrosh'),
(3537300, 5, 8245.909, 700.5938, 617.5123, 0, 'Garrosh'),
(3537300, 6, 8307.236, 659.9271, 612.8467, 0, 'Garrosh'),
(3537300, 7, 8374.998, 624.1146, 603.6246, 0, 'Garrosh'),
(3537300, 8, 8442.234, 627.6424, 586.9026, 0, 'Garrosh'),
(3537300, 9, 8460.104, 663.1354, 570.708, 0, 'Garrosh'),
(3537300, 10, 8434.889, 716.4566, 554.9306, 0, 'Garrosh'),
(3537300, 11, 8400.004, 736.375, 548.4319, 0, 'Garrosh'),
(3537300, 12, 8379.755, 758.7761, 560.7277, 0, 'Garrosh'),
(3537300, 13, 8375.762, 816.9583, 575.4495, 0, 'Garrosh'),
(3537300, 14, 8408.011, 979.2396, 583.0051, 0, 'Garrosh'),
(3537300, 15, 8479.79, 1165.729, 583.0051, 0, 'Garrosh'),
(3537300, 16, 8556.944, 1266.283, 583.0051, 0, 'Garrosh'),
(3537300, 17, 8639.218, 1337.319, 555.4777, 0, 'Garrosh'),
(3537300, 18, 8702.511, 1362.293, 538.4221, 0, 'Garrosh'),
(3537300, 19, 8742.067, 1425.563, 484.7003, 0, 'Garrosh'),
(35299, 1, 8271.082, 589.7016, 630.8472, 0, 'Varian'),
(35299, 2, 8271.837, 590.3577, 630.8472, 0, 'Varian'),
(35299, 3, 8281.927, 601.7222, 638.0027, 0, 'Varian'),
(35299, 4, 8300.09, 626.8629, 642.142, 0, 'Varian'),
(35299, 5, 8326.912, 637.3785, 642.9468, 0, 'Varian'),
(35299, 6, 8358.907, 640.3073, 636.2529, 0, 'Varian'),
(35299, 7, 8398.649, 636.0972, 627.6146, 0, 'Varian'),
(35299, 8, 8464.53, 607.0764, 619.2809, 0, 'Varian'),
(35299, 9, 8543.788, 612.4479, 605.2258, 0, 'Varian'),
(35299, 10, 8596.271, 657.0729, 588.1143, 0, 'Varian'),
(35299, 11, 8599.242, 701.5261, 576.7808, 0, 'Varian'),
(35299, 12, 8602.137, 720.434, 569.0308, 0, 'Varian'),
(35299, 13, 8604.012, 738.592, 556.7809, 0, 'Varian'),
(35299, 14, 8608.536, 745.5851, 550.9476, 0, 'Varian'),
(35299, 15, 8613.54, 752.3698, 548.3363, 0, 'Varian'),
(35299, 16, 8615.236, 751.1754, 551.5819, 0, 'Varian'),
(35299, 17, 8632.748, 750.7396, 553.9152, 0, 'Varian'),
(35299, 18, 8664.987, 743.0972, 562.3303, 0, 'Varian'),
(35299, 19, 8687.207, 731.5677, 560.3588, 0, 'Varian'),
(35299, 20, 8713.502, 709.1285, 543.8591, 0, 'Varian'),
(35299, 21, 8718.188, 669.191, 483.5814, 0, 'Varian'),
(35299, 22, 8764.548, 621.434, 446.4983, 0, 'Varian'),
(35299, 23, 8812.659, 654.4861, 427.8871, 0, 'Varian'),
(35299, 24, 8858.637, 950.0243, 427.8871, 0, 'Varian'),
(35299, 25, 8857.169, 1354.833, 427.8871, 0, 'Varian'),
(3529900, 1, 8271.082, 589.7016, 630.8472, 0, 'Jaina'),
(3529900, 2, 8271.837, 590.3577, 630.8472, 0, 'Jaina'),
(3529900, 3, 8281.927, 601.7222, 638.0027, 0, 'Jaina'),
(3529900, 4, 8300.09, 626.8629, 642.142, 0, 'Jaina'),
(3529900, 5, 8326.912, 637.3785, 642.9468, 0, 'Jaina'),
(3529900, 6, 8358.907, 640.3073, 636.2529, 0, 'Jaina'),
(3529900, 7, 8398.649, 636.0972, 627.6146, 0, 'Jaina'),
(3529900, 8, 8464.53, 607.0764, 619.2809, 0, 'Jaina'),
(3529900, 9, 8543.788, 612.4479, 605.2258, 0, 'Jaina'),
(3529900, 10, 8596.271, 657.0729, 588.1143, 0, 'Jaina'),
(3529900, 11, 8599.242, 701.5261, 576.7808, 0, 'Jaina'),
(3529900, 12, 8602.137, 720.434, 569.0308, 0, 'Jaina'),
(3529900, 13, 8604.012, 738.592, 556.7809, 0, 'Jaina'),
(3529900, 14, 8608.536, 745.5851, 550.9476, 0, 'Jaina'),
(3529900, 15, 8613.54, 752.3698, 548.3363, 0, 'Jaina'),
(3529900, 16, 8612.884, 754.2803, 547.6277, 0, 'Jaina'),
(3529900, 17, 8611.935, 740.467, 551.7665, 0, 'Jaina'),
(3529900, 18, 8637.618, 754.1163, 564.4597, 0, 'Jaina'),
(3529900, 19, 8647.946, 763.5712, 567.2928, 0, 'Jaina'),
(3529900, 20, 8664.131, 773.3229, 563.5434, 0, 'Jaina'),
(3529900, 21, 8705.323, 792.2136, 541.0161, 0, 'Jaina'),
(3529900, 22, 8722.38, 827.4722, 506.0163, 0, 'Jaina'),
(3529900, 23, 8739.074, 916.2239, 455.9886, 0, 'Jaina'),
(3529900, 24, 8761.381, 1050.175, 455.9886, 0, 'Jaina'),
(3529900, 25, 8736.964, 1341.703, 455.9886, 0, 'Jaina'),
(35372, 1, 8392.298, 756.2188, 547.4177, 0, 'Garrosh Hellscream'),
(35372, 2, 8378.945, 784.5903, 547.7131, 0, 'Garrosh Hellscream'),
(35372, 3, 8375.174, 805.625, 547.9304, 0, 'Garrosh Hellscream'),
(35372, 4, 8376.443, 839.5347, 548.0427, 0, 'Garrosh Hellscream'),
(35372, 5, 8378.49, 853.536, 548.197, 0, 'Garrosh Hellscream'),
(35372, 6, 8383.74, 860.536, 548.947, 0, 'Garrosh Hellscream'),
(35372, 7, 8387.74, 863.036, 548.197, 0, 'Garrosh Hellscream'),
(35372, 8, 8395.49, 867.579, 547.466, 0, 'Garrosh Hellscream'),
(35372, 9, 8429.67, 868.032, 547.561, 0, 'Garrosh Hellscream'),
(35372, 10, 8456.81, 868.282, 547.547, 0, 'Garrosh Hellscream'),
(35372, 11, 8471.33, 874.792, 547.356, 0, 'Garrosh Hellscream'),
(35372, 12, 8474.35, 965.616, 547.565, 0, 'Garrosh Hellscream'),
(35372, 13, 8474.91, 994.847, 547.569, 0, 'Garrosh Hellscream'),
(35372, 14, 8475.96, 1015.37, 547.403, 0, 'Garrosh Hellscream'),
(35372, 15, 8491.08, 1023.57, 547.686, 0, 'Garrosh Hellscream'),
(35372, 16, 8505.54, 1017.33, 547.487, 0, 'Garrosh Hellscream'),
(35372, 17, 8514.84, 967.886, 547.602, 0, 'Garrosh Hellscream'),
(35372, 18, 8513.31, 908.757, 547.06, 0, 'Garrosh Hellscream'),
(35372, 19, 8515.03, 903.334, 549.404, 0, 'Garrosh Hellscream'),
(35372, 20, 8515.03, 883.334, 558.404, 0, 'Garrosh Hellscream'),
(35372, 21, 8515.25, 883.068, 558.281, 0, 'Garrosh Hellscream'),
(35372, 22, 8515.25, 881.818, 558.281, 0, 'Garrosh Hellscream'),
(35372, 23, 8515.25, 869.818, 558.281, 0, 'Garrosh Hellscream'),
(35368, 1, 8392.298, 756.2188, 547.4177, 0, 'Thrall'),
(35368, 2, 8378.945, 784.5903, 547.7131, 0, 'Thrall'),
(35368, 3, 8375.174, 805.625, 547.9304, 0, 'Thrall'),
(35368, 4, 8376.443, 839.5347, 548.0427, 0, 'Thrall'),
(35368, 5, 8378.62, 857.509, 548.19, 0, 'Thrall'),
(35368, 6, 8383.62, 860.509, 548.94, 0, 'Thrall'),
(35368, 7, 8387.62, 863.009, 548.19, 0, 'Thrall'),
(35368, 8, 8395.59, 867.535, 547.525, 0, 'Thrall'),
(35368, 9, 8429.74, 868.048, 547.556, 0, 'Thrall'),
(35368, 10, 8456.64, 868.286, 547.547, 0, 'Thrall'),
(35368, 11, 8471.31, 879.703, 547.357, 0, 'Thrall'),
(35368, 12, 8474.32, 965.529, 547.566, 0, 'Thrall'),
(35368, 13, 8474.68, 995.049, 547.567, 0, 'Thrall'),
(35368, 14, 8476.17, 1015.25, 547.401, 0, 'Thrall'),
(35368, 15, 8491.05, 1023.52, 547.681, 0, 'Thrall'),
(35368, 16, 8505.44, 1023.33, 547.49, 0, 'Thrall'),
(35368, 17, 8514.71, 967.99, 547.602, 0, 'Thrall'),
(35368, 18, 8513.31, 908.846, 547.059, 0, 'Thrall'),
(35368, 19, 8515, 903.388, 549.379, 0, 'Thrall'),
(35368, 20, 8515, 883.388, 558.379, 0, 'Thrall'),
(35368, 21, 8515.25, 883.105, 558.264, 0, 'Thrall'),
(35368, 22, 8515.25, 881.855, 558.264, 0, 'Thrall'),
(35368, 23, 8515.25, 869.855, 558.264, 0, 'Thrall'),
(35320, 1, 8622.47, 759.405, 547.4177, 0, 'Lady Jaina Proudmoore'),
(35320, 2, 8637.25, 774.7917, 547.6496, 0, 'Lady Jaina Proudmoore'),
(35320, 3, 8644.739, 782.4965, 547.5246, 0, 'Lady Jaina Proudmoore'),
(35320, 4, 8644.862, 805.0521, 547.5709, 0, 'Lady Jaina Proudmoore'),
(35320, 5, 8627.42, 821.719, 547.844, 0, 'Lady Jaina Proudmoore'),
(35320, 6, 8613.42, 837.969, 548.344, 0, 'Lady Jaina Proudmoore'),
(35320, 7, 8608.17, 842.469, 547.844, 0, 'Lady Jaina Proudmoore'),
(35320, 8, 8601.23, 848.749, 547.861, 0, 'Lady Jaina Proudmoore'),
(35320, 9, 8568.59, 876.945, 547.846, 0, 'Lady Jaina Proudmoore'),
(35320, 10, 8568.81, 905.326, 547.844, 0, 'Lady Jaina Proudmoore'),
(35320, 11, 8575.42, 931.524, 547.881, 0, 'Lady Jaina Proudmoore'),
(35320, 12, 8574.33, 978.157, 547.788, 0, 'Lady Jaina Proudmoore'),
(35320, 13, 8573.8, 996.077, 547.706, 0, 'Lady Jaina Proudmoore'),
(35320, 14, 8547.21, 1025.6, 547.668, 0, 'Lady Jaina Proudmoore'),
(35320, 15, 8522.49, 1022.52, 547.48, 0, 'Lady Jaina Proudmoore'),
(35320, 16, 8510.44, 962.671, 547.71, 0, 'Lady Jaina Proudmoore'),
(35320, 17, 8512.93, 908.633, 547.107, 0, 'Lady Jaina Proudmoore'),
(35320, 18, 8509.26, 890.199, 555.392, 0, 'Lady Jaina Proudmoore'),
(35320, 19, 8509.51, 882.949, 558.392, 0, 'Lady Jaina Proudmoore'),
(35320, 20, 8509.76, 866.949, 558.392, 0, 'Lady Jaina Proudmoore'),
(35321, 1, 8623.36, 761.884, 547.4177, 0, 'King Varian Wrynn '),
(35321, 2, 8637.25, 774.7917, 547.6496, 0, 'King Varian Wrynn '),
(35321, 3, 8644.739, 782.4965, 547.5246, 0, 'King Varian Wrynn '),
(35321, 4, 8644.862, 805.0521, 547.5709, 0, 'King Varian Wrynn '),
(35321, 5, 8627.39, 825.621, 547.844, 0, 'King Varian Wrynn '),
(35321, 6, 8613.39, 837.871, 548.344, 0, 'King Varian Wrynn '),
(35321, 7, 8608.14, 842.621, 547.844, 0, 'King Varian Wrynn '),
(35321, 8, 8601.04, 848.538, 547.861, 0, 'King Varian Wrynn '),
(35321, 9, 8568.62, 877.032, 547.845, 0, 'King Varian Wrynn '),
(35321, 10, 8568.8, 905.266, 547.844, 0, 'King Varian Wrynn '),
(35321, 11, 8575.41, 931.527, 547.881, 0, 'King Varian Wrynn '),
(35321, 12, 8574.29, 978.237, 547.79, 0, 'King Varian Wrynn '),
(35321, 13, 8573.76, 996.144, 547.687, 0, 'King Varian Wrynn '),
(35321, 14, 8547.21, 1025.77, 547.668, 0, 'King Varian Wrynn '),
(35321, 15, 8522.59, 1025.52, 547.48, 0, 'King Varian Wrynn '),
(35321, 16, 8515.86, 966.69, 547.798, 0, 'King Varian Wrynn '),
(35321, 17, 8515.84, 933.152, 547.62, 0, 'King Varian Wrynn '),
(35321, 18, 8515.78, 909.503, 547.724, 0, 'King Varian Wrynn '),
(35321, 19, 8515.28, 908.253, 547.724, 0, 'King Varian Wrynn '),
(35321, 20, 8515.28, 907.753, 547.474, 0, 'King Varian Wrynn '),
(35321, 21, 8515.78, 883.253, 558.224, 0, 'King Varian Wrynn '),
(35321, 22, 8515.78, 882.503, 558.224, 0, 'King Varian Wrynn '),
(35321, 23, 8515.86, 874.82, 558.4, 0, 'King Varian Wrynn ');

DELETE FROM conditions WHERE SourceTypeOrReferenceId=22 AND SourceEntry=35361 AND SourceId=0;
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(22, 10, 35361, 0, 0, 12, 1, 68, 0, 0, 0, 0, 0, '', 'Tirion Fordring only run sai if event 68 is active'),
(22, 11, 35361, 0, 0, 12, 1, 69, 0, 0, 0, 0, 0, '', 'Tirion Fordring only run sai if event 69 is active');

Comp-Database Feedback-PatchFix

All 12 comments

Maybe label this as [Comp-Database] [Feedback-PatchFix] ?

Added missing wp to start of alliance event, added tournament event controller auras even though these are dummy

Final update add waypoints for gryphons and windriders to fly off once passengers dropped off
Also found missing waypoints from start of Thralls and Garrosh's paths after leaving vehicle

Nice. Good job.

Implicit spell conditions for the dummy auras so effect #2 hits correct creature this wont have any effect on above script but the spell is used during effect but this does nothing this is just so the correct spell effect hits correct npc even though does nothing
~~~sql
DELETE FROM conditions WHERE SourceTypeOrReferenceId=13 AND SourceGroup=2 AND SourceEntry IN(69003,69007,69095,69096);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(13, 2, 69003, 0, 0, 31, 0, 3, 15214, 0, 0, 0, 0, '', '[DND] Argent Tournament - Event Controller - Alliance Effect #2 Targets Invisible Stalker'),
(13, 2, 69007, 0, 0, 31, 0, 3, 15214, 0, 0, 0, 0, '', '[DND] Argent Tournament - Event Controller - Horde Effect #2 Targets Invisible Stalker'),
(13, 2, 69095, 0, 0, 31, 0, 3, 15214, 0, 0, 0, 0, '', '[DND] Argent Tournament - Event Controller Tirion - Alliance Effect #2 Targets Invisible Stalker'),
(13, 2, 69096, 0, 0, 31, 0, 3, 15214, 0, 0, 0, 0, '', '[DND] Argent Tournament - Event Controller Tirion - Horde Effect #2 Targets Invisible Stalker');

Initial cleaning.
Waypoints must be fixed

``` sql

DELETE FROM creature_summon_groups WHERE summonerId=35501;
UPDATE game_event SET length=10 WHERE eventEntry IN(67,68,69);

DELETE FROM creature WHERE guid IN (79295, 79317, 79318, 79332, 79342, 79350, 79356, 79358, 79389, 85808, 85813, 85821, 85822, 85823, 85824, 85825, 85827, 85828, 85829) AND id IN (35372,35368,35460,35361,35321,35320,35322,35299,35373);
INSERT INTO creature (guid, id, map, zoneId, areaId, spawnMask, phaseMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, wander_distance, currentwaypoint, curhealth, curmana, MovementType, npcflag, unit_flags, dynamicflags, ScriptName, VerifiedBuild) VALUES
(79295, 35372, 571, 0, 0, 1, 1, 0, 1, 8182.991, 661.3733, 584.973, 0, 900, 0, 0, 1, 0, 0, 0, 0, 0, '', 0),
(79317, 35368, 571, 0, 0, 1, 1, 0, 1, 8189.663, 662.0833, 588.7211, 1.570796, 900, 0, 0, 1, 0, 0, 0, 0, 0, '', 0),
(79318, 35460, 571, 0, 0, 1, 1, 0, 1, 8431.85, 783.523, 547.189, 4.80006, 900, 0, 0, 1, 0, 0, 0, 0, 0, '', 0),
(79332, 35460, 571, 0, 0, 1, 1, 0, 1, 8431.82, 786.166, 547.023, 4.75293, 900, 0, 0, 1, 0, 0, 0, 0, 0, '', 0),
(79342, 35460, 571, 0, 0, 1, 1, 0, 1, 8432.08, 788.975, 547.023, 4.72544, 900, 0, 0, 1, 0, 0, 0, 0, 0, '', 0),
(79350, 35460, 571, 0, 0, 1, 1, 0, 1, 8431.93, 792.52, 547.023, 4.73172, 900, 0, 0, 1, 0, 0, 0, 0, 0, '', 0),
(79356, 35361, 571, 0, 0, 1, 1, 0, 1, 8514.48, 1002.04, 547.543, 1.54998, 900, 0, 0, 1, 0, 0, 0, 0, 0, '', 0),
(79358, 35321, 571, 0, 0, 1, 1, 0, 1, 8280.653, 589.4809, 629.1866, 0.8028514, 900, 0, 0, 1, 0, 0, 0, 0, 0, '', 0),
(79389, 35320, 571, 0, 0, 1, 1, 0, 1, 8272.021, 590.3993, 630.7748, 0, 900, 0, 0, 1, 0, 0, 0, 0, 0, '', 0),
(85808, 35322, 571, 0, 0, 1, 1, 0, 1, 8598.43, 782.77, 547.233, 4.03508, 900, 0, 0, 1, 0, 0, 0, 0, 0, '', 0),
(85813, 35322, 571, 0, 0, 1, 1, 0, 1, 8599.85, 786.899, 547.106, 4.03508, 900, 0, 0, 1, 0, 0, 0, 0, 0, '', 0),
(85821, 35322, 571, 0, 0, 1, 1, 0, 1, 8599.95, 789.887, 547.102, 4.03508, 900, 0, 0, 1, 0, 0, 0, 0, 0, '', 0),
(85822, 35322, 571, 0, 0, 1, 1, 0, 1, 8600.09, 792.962, 547.092, 4.03508, 900, 0, 0, 1, 0, 0, 0, 0, 0, '', 0),
(85823, 35361, 571, 0, 0, 1, 1, 0, 1, 8514.87, 999.861, 547.536, 1.56404, 900, 0, 0, 1, 0, 0, 0, 0, 0, '', 0),
(85824, 35361, 571, 0, 0, 1, 1, 0, 1, 8516.17, 857.121, 558.224, 1.62047, 900, 0, 0, 1, 0, 0, 0, 0, 0, '', 0),
(85825, 35373, 571, 0, 0, 1, 1, 0, 0, 8189.473, 662.5625, 588.4474, 1.658063, 900, 0, 0, 1, 0, 0, 0, 0, 0, '', 0),
(85827, 35373, 571, 0, 0, 1, 1, 0, 0, 8182.767, 660.9809, 584.986, 1.62047, 900, 0, 0, 1, 0, 0, 0, 0, 0, '', 0),
(85828, 35299, 571, 0, 0, 1, 1, 0, 0, 8271.837, 590.3577, 630.8472, 0.715585, 900, 0, 0, 1, 0, 0, 0, 0, 0, '', 0),
(85829, 35299, 571, 0, 0, 1, 1, 0, 0, 8280.147, 589.0052, 629.2678, 0.9948376, 900, 0, 0, 1, 0, 0, 0, 0, 0, '', 0);

DELETE FROM game_event_creature WHERE eventEntry IN(67,68,69);
INSERT INTO game_event_creature (eventEntry, guid) VALUES
(68, 79295),
(68, 79317),
(68, 79318),
(68, 79332),
(68, 79342),
(68, 79350),
(68, 79356),
(68, 85825),
(68, 85827),
(69, 79358),
(69, 79389),
(69, 85808),
(69, 85813),
(69, 85821),
(69, 85822),
(69, 85823),
(69, 85828),
(69, 85829),
(67, 85824);

UPDATE creature_template SET AIName='SmartAI' WHERE entry=35299;
UPDATE creature_template SET minlevel=75, maxlevel=75, AIName='SmartAI' WHERE entry=35373;

DELETE FROM creature_template_movement WHERE CreatureId IN(35299,35373);
INSERT INTO creature_template_movement (CreatureId, Ground, Flight) VALUES
(35299, 1, 1),
(35373, 1, 1);

DELETE FROM smart_scripts WHERE entryorguidIN (-85825,-85827,-85828,-85829,-85808,-85813 ,-85821,-85822,-79318,-79332,-79342,-79350,35320,35321,35372,35368,35361,35501,35322,35460,35299,35373) AND source_type=0;
DELETE FROM smart_scripts WHERE entryorguidIN (3550100,3550101,3550102,3536802) AND source_type=9;
INSERT INTO smart_scripts (entryorguid, source_type, id, link, event_type, event_phase_mask, event_chance, event_flags, event_param1, event_param2, event_param3, event_param4, action_type, action_param1, action_param2, action_param3, action_param4, action_param5, action_param6, target_type, target_param1, target_param2, target_param3, target_x, target_y, target_z, target_o, comment) VALUES
(-85829, 0, 0, 1, 27, 0, 100, 512, 0, 0, 0, 0, 60, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Royal Gryphon - On Passenger Boarded - Turn Fly on'),
(-85829, 0, 1, 0, 61, 0, 100, 512, 0, 0, 0, 0, 53, 1, 3529900, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Royal Gryphon - On Passenger Boarded - Start WP'),
(-85829, 0, 2, 3, 40, 0, 100, 512, 16, 0, 0, 0, 11, 50630, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Royal Gryphon - On reached WP16 - Cast Eject all passengers'),
(-85829, 0, 3, 0, 61, 0, 100, 512, 0, 0, 0, 0, 45, 7, 7, 0, 0, 0, 0, 19, 35321, 0, 0, 0, 0, 0, 0, 'Royal Gryphon - On reached WP16 - Set Data'),
(-85829, 0, 4, 0, 40, 0, 100, 512, 25, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Royal Gryphon - On reached WP25 - Despawn'),
(-85829, 0, 5, 0, 11, 0, 100, 512, 0, 0, 0, 0, 48, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Royal Gryphon - On Spawn - Set Active'),

(-85828, 0, 0, 1, 27, 0, 100, 512, 0, 0, 0, 0, 60, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Royal Gryphon - On Passenger Boarded - Turn Fly on'),
(-85828, 0, 1, 0, 61, 0, 100, 512, 0, 0, 0, 0, 53, 1, 35299, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Royal Gryphon - On Passenger Boarded - Start WP'),
(-85828, 0, 2, 3, 40, 0, 100, 512, 15, 0, 0, 0, 11, 50630, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Royal Gryphon - On reached WP15 - Cast Eject all passengers'),
(-85828, 0, 3, 0, 61, 0, 100, 512, 0, 0, 0, 0, 45, 7, 7, 0, 0, 0, 0, 19, 35320, 0, 0, 0, 0, 0, 0, 'Royal Gryphon - On reached WP15 - Set Data'),
(-85828, 0, 4, 0, 40, 0, 100, 512, 25, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Royal Gryphon - On reached WP25 - Despawn'),
(-85828, 0, 5, 0, 11, 0, 100, 512, 0, 0, 0, 0, 48, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Royal Gryphon - On Spawn - Set Active'),

(-85827, 0, 0, 1, 27, 0, 100, 512, 0, 0, 0, 0, 60, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Tournament Windrider - On Passenger Boarded - Turn Fly on'),
(-85827, 0, 1, 0, 61, 0, 100, 512, 0, 0, 0, 0, 53, 1, 3537300, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Tournament Windrider - On Passenger Boarded - Start WP'),
(-85827, 0, 2, 3, 40, 0, 100, 512, 10, 0, 0, 0, 11, 50630, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Tournament Windrider - On reached WP11 - Cast Eject all passengers'),
(-85827, 0, 3, 0, 61, 0, 100, 512, 0, 0, 0, 0, 45, 7, 7, 0, 0, 0, 0, 19, 35372, 0, 0, 0, 0, 0, 0, 'Tournament Windrider - On reached WP11 - Set Data'),
(-85827, 0, 4, 0, 40, 0, 100, 512, 15, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Tournament Windrider - On reached WP19 - Despawn'),
(-85827, 0, 5, 0, 11, 0, 100, 512, 0, 0, 0, 0, 48, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Tournament Windrider - On Spawn - Set Active'),

(-85825, 0, 0, 1, 27, 0, 100, 512, 0, 0, 0, 0, 60, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Tournament Windrider - On Passenger Boarded - Turn Fly on'),
(-85825, 0, 1, 0, 61, 0, 100, 512, 0, 0, 0, 0, 53, 1, 35373, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Tournament Windrider - On Passenger Boarded - Start WP'),
(-85825, 0, 2, 3, 40, 0, 100, 512, 10, 0, 0, 0, 11, 50630, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Tournament Windrider - On reached WP10 - Cast Eject all passengers'),
(-85825, 0, 3, 0, 61, 0, 100, 512, 0, 0, 0, 0, 45, 7, 7, 0, 0, 0, 0, 19, 35368, 0, 0, 0, 0, 0, 0, 'Tournament Windrider - On reached WP10 - Set Data'),
(-85825, 0, 4, 0, 40, 0, 100, 512, 15, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Tournament Windrider - On reached WP19 - Despawn'),
(-85825, 0, 5, 0, 11, 0, 100, 512, 0, 0, 0, 0, 48, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Tournament Windrider - On Spawn - Set Active'),

(-85822, 0, 0, 0, 38, 0, 100, 512, 2, 2, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Stormwind Royal Guard - on Data Set 2 2 - Despawn'),
(-85822, 0, 1, 0, 38, 0, 100, 1, 1, 1, 0, 0, 29, 2, 300, 0, 0, 0, 0, 19, 35321, 0, 0, 0, 0, 0, 0, 'Stormwind Royal Guard - OOC - Follow King Varian Wrynn'),
(-85821, 0, 0, 0, 38, 0, 100, 512, 2, 2, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Stormwind Royal Guard - on Data Set 2 2 - Despawn'),
(-85821, 0, 1, 0, 38, 0, 100, 1, 1, 1, 0, 0, 29, 2, 330, 0, 0, 0, 0, 19, 35321, 0, 0, 0, 0, 0, 0, 'Stormwind Royal Guard - OOC - Follow King Varian Wrynn'),
(-85813, 0, 0, 0, 38, 0, 100, 512, 2, 2, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Stormwind Royal Guard - on Data Set 2 2 - Despawn'),
(-85813, 0, 1, 0, 38, 0, 100, 1, 1, 1, 0, 0, 29, 2, 360, 0, 0, 0, 0, 19, 35321, 0, 0, 0, 0, 0, 0, 'Stormwind Royal Guard - OOC - Follow King Varian Wrynn'),
(-85808, 0, 0, 0, 38, 0, 100, 512, 2, 2, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Stormwind Royal Guard - on Data Set 2 2 - Despawn'),
(-85808, 0, 1, 0, 38, 0, 100, 1, 1, 1, 0, 0, 29, 2, 30, 0, 0, 0, 0, 19, 35321, 0, 0, 0, 0, 0, 0, 'Stormwind Royal Guard - OOC - Follow King Varian Wrynn'),

(-79350, 0, 0, 0, 38, 0, 100, 512, 2, 2, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Kor Kron Elite - on Data Set 2 2 - Despawn'),
(-79350, 0, 1, 0, 38, 0, 100, 1, 1, 1, 0, 0, 29, 1, 45, 0, 0, 0, 0, 19, 35372, 0, 0, 0, 0, 0, 0, 'Kor Kron Elite - OOC - Follow Thrall'),
(-79342, 0, 0, 0, 38, 0, 100, 512, 2, 2, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Kor Kron Elite - on Data Set 2 2 - Despawn'),
(-79342, 0, 1, 0, 38, 0, 100, 1, 1, 1, 0, 0, 29, 1, 315, 0, 0, 0, 0, 19, 35372, 0, 0, 0, 0, 0, 0, 'Kor Kron Elite - OOC - Follow Thrall'),
(-79332, 0, 0, 0, 38, 0, 100, 512, 2, 2, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Kor Kron Elite - on Data Set 2 2 - Despawn'),
(-79332, 0, 1, 0, 38, 0, 100, 1, 1, 1, 0, 0, 29, 1, 45, 0, 0, 0, 0, 19, 35368, 0, 0, 0, 0, 0, 0, 'Kor Kron Elite - OOC - Follow Thrall'),
(-79318, 0, 0, 0, 38, 0, 100, 512, 2, 2, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Kor Kron Elite - on Data Set 2 2 - Despawn'),
(-79318, 0, 1, 0, 38, 0, 100, 1, 1, 1, 0, 0, 29, 1, 315, 0, 0, 0, 0, 19, 35368, 0, 0, 0, 0, 0, 0, 'Kor Kron Elite - OOC - Follow Thrall'),

(35361, 0, 0, 0, 38, 0, 100, 512, 1, 1, 0, 0, 53, 0, 3536101, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Highlord Tirion Fordring - On Data Set 1 1 - Start WP (Path 1)"),
(35361, 0, 1, 0, 38, 0, 100, 512, 2, 2, 0, 0, 53, 0, 3536102, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Highlord Tirion Fordring - On Data Set 2 2 - Start WP (Path 2)"),
(35361, 0, 2, 0, 38, 0, 100, 512, 3, 3, 0, 0, 53, 0, 3536103, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Highlord Tirion Fordring - On Data Set 3 3 - Start WP (Path 3)"),
(35361, 0, 3, 0, 40, 0, 100, 512, 5, 3536101, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Highlord Tirion Fordring - On Reached WP 5 (Path 1) - Despawn"),
(35361, 0, 4, 0, 40, 0, 100, 512, 7, 3536102, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Highlord Tirion Fordring - On Reached WP 7 (Path 2) - Despawn"),
(35361, 0, 5, 0, 40, 0, 100, 512, 53, 3536103, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Highlord Tirion Fordring - On Reached WP 53 (Path 3) - Despawn"),
(35361, 0, 6, 7, 40, 0, 100, 512, 26, 3536103, 0, 0, 54, 76000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Highlord Tirion Fordring - On Reached WP 26 (Path 3) - Pause WP"),
(35361, 0, 7, 0, 61, 0, 100, 512, 0, 0, 0, 0, 80, 3536100, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Highlord Tirion Fordring - On Reached WP 26 (Path 3) - Run Script"),
(35361, 0, 8, 0, 25, 0, 100, 512, 0, 0, 0, 0, 48, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Highlord Tirion Fordring - On Reset Set Active'),
(35361, 0, 9, 0, 54, 0, 100, 512, 0, 0, 0, 0, 11, 69096, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Highlord Tirion Fordring - On Just Summoned - Cast 69096 [DND] Argent Tournament - Event Controller Tirion - Horde'),
(35361, 0, 10, 0, 54, 0, 100, 512, 0, 0, 0, 0, 11, 69095, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Highlord Tirion Fordring - On Just Summoned - Cast 69096 [DND] Argent Tournament - Event Controller Tirion - Alliance'),

(35368, 0, 0, 1, 38, 0, 100, 512, 7, 7, 0, 0, 80, 3536802, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Thrall - Data set - Action list"),
(35368, 0, 1, 0, 61, 0, 100, 512, 0, 0, 0, 0, 11, 69007, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Thrall - On Data Set - Cast 69007 [DND] Argent Tournament - Event Controller - Horde'),
(35368, 0, 2, 3, 40, 0, 100, 512, 11, 35368, 0, 0, 54, 39000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Thrall - On Reached WP11 - Pause WP"),
(35368, 0, 3, 0, 61, 0, 100, 512, 0, 0, 0, 0, 80, 3536800, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Thrall - On Reached WP11 - Run Script 1"),
(35368, 0, 4, 5, 40, 0, 100, 512, 19, 35368, 0, 0, 54, 87000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Thrall - On Reached WP16 - Pause WP"),
(35368, 0, 5, 0, 61, 0, 100, 512, 0, 0, 0, 0, 80, 3536801, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Thrall - On Reached WP16 - Run Script 2"),
(35368, 0, 6, 7, 40, 0, 100, 512, 26, 35368, 0, 0, 45, 2, 2, 0, 0, 0, 0, 9, 35460, 0, 200, 0, 0, 0, 0, "Thrall - On Reached WP23 - Set Data 2 2 on Kor Kron Elite"),
(35368, 0, 7, 0, 61, 0, 100, 512, 0, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Thrall - On Reached WP19 - Despawn"),
(35368, 0, 8, 0, 25, 0, 100, 512, 0, 0, 0, 0, 48, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Thrall - On Reset - Set Active'),
(35368, 0, 9, 0, 11, 0, 100, 512, 0, 0, 0, 0, 11, 46598, 0, 0, 0, 0, 0, 19, 35373, 0, 0, 0, 0, 0, 0, 'Thrall - On Spawn - Mount'),
(35368, 0, 10, 0, 40, 0, 100, 512, 6, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 9, 35460, 0, 100, 0, 0, 0, 0, 'Thrall - On Reached WP6 - Set Data'),

(35372, 0, 0, 1, 38, 0, 100, 512, 7, 7, 0, 0, 53, 0, 35372, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Garrosh Hellscream - On Data set - Start WP"),
(35372, 0, 1, 0, 61, 0, 100, 512, 0, 0, 0, 0, 11, 69007, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Garrosh Hellscream - On Data Set - Cast [DND] Argent Tournament - Event Controller - Horde'),
(35372, 0, 2, 0, 40, 0, 100, 512, 11, 35372, 0, 0, 54, 39000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Garrosh Hellscream - On Reached WP11 - Pause WP"),
(35372, 0, 3, 0, 40, 0, 100, 512, 18, 35372, 0, 0, 54, 95000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Garrosh Hellscream - On Reached WP18 - Pause WP"),
(35372, 0, 4, 0, 40, 0, 100, 512, 25, 35372, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Garrosh Hellscream - On Reached WP22 - Despawn"),
(35372, 0, 5, 0, 38, 0, 100, 512, 1, 1, 0, 0, 66, 0, 0, 0, 0, 0, 0, 19, 35368, 0, 0, 0, 0, 0, 0, "Garrosh Hellscream - On Data Set 1 1 - Face Thrall"),
(35372, 0, 6, 0, 38, 0, 100, 512, 2, 2, 0, 0, 66, 0, 0, 0, 0, 0, 0, 19, 35361, 0, 0, 0, 0, 0, 0, "Garrosh Hellscream - On Data Set 2 2 - Face Tirion"),
(35372, 0, 7, 0, 25, 0, 100, 512, 0, 0, 0, 0, 48, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Garrosh Hellscream - On Reaet - Set Active'),
(35372, 0, 8, 0, 11, 0, 100, 512, 0, 0, 0, 0, 11, 46598, 0, 0, 0, 0, 0, 19, 35373, 0, 0, 0, 0, 0, 0, 'Garrosh Hellscream - On Spawn - Mount'),
(35372, 0, 9, 0, 40, 0, 100, 512, 1, 35372, 0, 0, 54, 3000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Garrosh Hellscream - On Reached WP1 - Pause'),
(35372, 0, 10, 0, 40, 0, 100, 512, 11, 35372, 0, 0, 66, 0, 0, 0, 0, 0, 0, 19, 35368, 0, 0, 0, 0, 0, 0, "Garrosh Hellscream - On Reached WP11 - Set Orientation"),
(35372, 0, 11, 0, 40, 0, 100, 512, 18, 35372, 0, 0, 66, 0, 0, 0, 0, 0, 0, 19, 35361, 0, 0, 0, 0, 0, 0, "Garrosh Hellscream - On Reached WP18 - Set Orientation"),

(35321, 0, 0, 1, 38, 0, 100, 512, 7, 7, 0, 0, 11, 69003, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "King Varian Wrynn - On Data Set - Cast [DND] Argent Tournament - Event Controller - Alliance"),
(35321, 0, 1, 0, 61, 0, 100, 512, 0, 0, 0, 0, 53, 0, 35321, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "King Varian Wrynn - On Just Summoned - Start WP"),
(35321, 0, 2, 3, 40, 0, 100, 512, 15, 35321, 0, 0, 54, 70000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "King Varian Wrynn - On Reached WP11 - Pause WP"),
(35321, 0, 3, 0, 61, 0, 100, 512, 0, 0, 0, 0, 80, 3532100, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "King Varian Wrynn - On Reached WP11 - Run Script 1"),
(35321, 0, 4, 5, 40, 0, 100, 512, 23, 35321, 0, 0, 45, 2, 2, 0, 0, 0, 0, 9, 35322, 0, 200, 0, 0, 0, 0, "King Varian Wrynn - On Reached WP19 - Set Data 2 2 on Stormwind Royal Guard"),
(35321, 0, 5, 0, 61, 0, 100, 512, 0, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "King Varian Wrynn - On Reached WP19 - Despawn"),
(35321, 0, 6, 0, 25, 0, 100, 512, 0, 0, 0, 0, 48, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'King Varian Wrynn - On Reset - Set Active'),
(35321, 0, 7, 0, 11, 0, 100, 512, 0, 0, 0, 0, 11, 46598, 0, 0, 0, 0, 0, 19, 35299, 0, 0, 0, 0, 0, 0, 'King Varian Wrynn - On Spawn - Mount'),
(35321, 0, 8, 0, 40, 0, 100, 512, 6, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 9, 35322, 0, 100, 0, 0, 0, 0, 'King Varian Wrynn - On Reached WP - Set Data'),

(35320, 0, 0, 1, 38, 0, 100, 512, 7, 7, 0, 0, 53, 0, 35320, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Lady Jaina Proudmoore - On Just Summoned - Start WP"),
(35320, 0, 1, 0, 61, 0, 100, 512, 0, 0, 0, 0, 11, 69003, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Lady Jaina Proudmoore - On Data Set - Cast [DND] Argent Tournament - Event Controller - Alliance'),
(35320, 0, 2, 0, 40, 0, 100, 512, 15, 35320, 0, 0, 54, 70000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Lady Jaina Proudmoore - On Reached WP13 - Pause WP"),
(35320, 0, 3, 0, 40, 0, 100, 512, 20, 35320, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Lady Jaina Proudmoore - On Reached WP18 - Despawn"),
(35320, 0, 4, 0, 38, 0, 100, 512, 1, 1, 0, 0, 66, 0, 0, 0, 0, 0, 0, 19, 35361, 0, 0, 0, 0, 0, 0, "Lady Jaina Proudmoore - On Data Set 1 1 - Face Tirion"),
(35320, 0, 5, 0, 25, 0, 100, 512, 0, 0, 0, 0, 48, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Lady Jaina Proudmoore - On Reset Set Active'),
(35320, 0, 6, 0, 11, 0, 100, 512, 0, 0, 0, 0, 11, 46598, 0, 0, 0, 0, 0, 19, 35299, 0, 0, 0, 0, 0, 0, 'Lady Jaina Proudmoore - On Spawn - Mount '),

(35501, 0, 0, 1, 68, 0, 100, 512, 67, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Herald Beluus - On Event Start 67 - Say Line 2'),
(35501, 0, 1, 0, 61, 0, 100, 512, 0, 0, 0, 0, 45, 3, 3, 0, 0, 0, 0, 19, 35361, 0, 0, 0, 0, 0, 0, 'Herald Beluus - On Data Set 3 3 - Set Data 3 3 on Tirion Fordring'),
(35501, 0, 2, 0, 68, 0, 100, 512, 68, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Herald Beluus - On Event Start 68 - Say Line 0'),
(35501, 0, 3, 0, 68, 0, 100, 512, 69, 0, 0, 0, 1, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Herald Beluus - On Event Start 69 - Say Line 1'),
(35501, 0, 4, 0, 25, 0, 100, 512, 0, 0, 0, 0, 48, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Herald Beluus - On Reset - Set Active'),

(3536802, 9, 0, 0, 0, 0, 100, 512, 0, 0, 0, 0, 5, 273, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Thrall - Script 3 - Play Emote OneShotYes'),
(3536802, 9, 1, 0, 0, 0, 100, 512, 2000, 2000, 0, 0, 53, 0, 35368, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Thrall - Script 3 - Start WP');

DELETE FROM waypoints WHERE entry IN(35373,3537300,35299,3529900,35320,35321,35368,35372);
INSERT INTO waypoints (entry, pointid, position_x, position_y, position_z, point_comment) VALUES
(35373, 1, 8183.713, 667.4739, 598.4862, 'Thrall Mount'),
(35373, 2, 8183.558, 684.4149, 599.3198, 'Thrall Mount'),
(35373, 3, 8191.257, 702.1684, 605.3474, 'Thrall Mount'),
(35373, 4, 8213.932, 710.3785, 611.9018, 'Thrall Mount'),
(35373, 5, 8245.909, 700.5938, 617.5123, 'Thrall Mount'),
(35373, 6, 8374.998, 624.1146, 603.6246, 'Thrall Mount'),
(35373, 7, 8442.234, 627.6424, 586.9026, 'Thrall Mount'),
(35373, 8, 8460.104, 663.1354, 570.708, 'Thrall Mount'),
(35373, 9, 8434.889, 716.4566, 554.9306, 'Thrall Mount'),
(35373, 10, 8409.114, 744.2797, 547.6277, 'Thrall Mount'),
(35373, 11, 8382.473, 770.2083, 560.1245, 'Thrall Mount'),
(35373, 12, 8389.666, 799.1927, 571.7078, 'Thrall Mount'),
(35373, 13, 8439.088, 844.9531, 577.4577, 'Thrall Mount'),
(35373, 14, 8491.686, 872.4236, 581.8465, 'Thrall Mount'),
(35373, 15, 8573.325, 890.7691, 581.8465, 'Thrall Mount'),

(3537300, 1, 8172.9345, 669.7943, 598.486, 'Garrosh Mount'),
(3537300, 2, 8171.7036, 688.6830, 599.318, 'Garrosh Mount'),
(3537300, 3, 8187.5004, 716.3367, 605.347, 'Garrosh Mount'),
(3537300, 4, 8212.5048, 724.5236, 611.901, 'Garrosh Mount'),
(3537300, 5, 8245.9091, 714.9298, 617.512, 'Garrosh Mount'),
(3537300, 6, 8374.9980, 640.1936, 603.624, 'Garrosh Mount'),
(3537300, 7, 8437.6337, 642.5957, 586.902, 'Garrosh Mount'),
(3537300, 8, 8447.6757, 662.0590, 570.708, 'Garrosh Mount'),
(3537300, 9, 8428.8730, 710.2484, 554.930, 'Garrosh Mount'),
(3537300, 10, 8405.2333, 738.3201, 547.293, 'Garrosh Mount'),
(3537300, 11, 8400.004, 736.375, 548.4319, 'Garrosh Mount'),
(3537300, 12, 8379.755, 758.7761, 560.7277, 'Garrosh Mount'),
(3537300, 13, 8375.762, 816.9583, 575.4495, 'Garrosh Mount'),
(3537300, 14, 8408.011, 979.2396, 583.0051, 'Garrosh Mount'),
(3537300, 15, 8479.79, 1165.729, 583.0051, 'Garrosh Mount'),

(35299, 1, 8271.082, 589.7016, 630.8472, 'Varian Mount'),
(35299, 2, 8271.837, 590.3577, 630.8472, 'Varian Mount'),
(35299, 3, 8281.927, 601.7222, 638.0027, 'Varian Mount'),
(35299, 4, 8300.09, 626.8629, 642.142, 'Varian Mount'),
(35299, 5, 8326.912, 637.3785, 642.9468, 'Varian Mount'),
(35299, 6, 8358.907, 640.3073, 636.2529, 'Varian Mount'),
(35299, 7, 8398.649, 636.0972, 627.6146, 'Varian Mount'),
(35299, 8, 8464.53, 607.0764, 619.2809, 'Varian Mount'),
(35299, 9, 8543.788, 612.4479, 605.2258, 'Varian Mount'),
(35299, 10, 8596.271, 657.0729, 588.1143, 'Varian Mount'),
(35299, 11, 8599.242, 701.5261, 576.7808, 'Varian Mount'),
(35299, 12, 8602.137, 720.434, 569.0308, 'Varian Mount'),
(35299, 13, 8604.012, 738.592, 556.7809, 'Varian Mount'),
(35299, 14, 8608.536, 745.5851, 550.9476, 'Varian Mount'),
(35299, 15, 8613.54, 752.3698, 548.3363, 'Varian Mount'),
(35299, 16, 8615.236, 751.1754, 551.5819, 'Varian Mount'),
(35299, 17, 8632.748, 750.7396, 553.9152, 'Varian Mount'),
(35299, 18, 8664.987, 743.0972, 562.3303, 'Varian Mount'),
(35299, 19, 8687.207, 731.5677, 560.3588, 'Varian Mount'),
(35299, 20, 8713.502, 709.1285, 543.8591, 'Varian Mount'),
(35299, 21, 8718.188, 669.191, 483.5814, 'Varian Mount'),
(35299, 22, 8764.548, 621.434, 446.4983, 'Varian Mount'),
(35299, 23, 8812.659, 654.4861, 427.8871, 'Varian Mount'),
(35299, 24, 8858.637, 950.0243, 427.8871, 'Varian Mount'),
(35299, 25, 8857.169, 1354.833, 427.8871, 'Varian Mount'),

(3529900, 1, 8271.082, 589.7016, 630.8472, 'Jaina Mount'),
(3529900, 2, 8271.837, 590.3577, 630.8472, 'Jaina Mount'),
(3529900, 3, 8281.927, 601.7222, 638.0027, 'Jaina Mount'),
(3529900, 4, 8300.09, 626.8629, 642.142, 'Jaina Mount'),
(3529900, 5, 8326.912, 637.3785, 642.9468, 'Jaina Mount'),
(3529900, 6, 8358.907, 640.3073, 636.2529, 'Jaina Mount'),
(3529900, 7, 8398.649, 636.0972, 627.6146, 'Jaina Mount'),
(3529900, 8, 8464.53, 607.0764, 619.2809, 'Jaina Mount'),
(3529900, 9, 8543.788, 612.4479, 605.2258, 'Jaina Mount'),
(3529900, 10, 8596.271, 657.0729, 588.1143, 'Jaina Mount'),
(3529900, 11, 8599.242, 701.5261, 576.7808, 'Jaina Mount'),
(3529900, 12, 8602.137, 720.434, 569.0308, 'Jaina Mount'),
(3529900, 13, 8604.012, 738.592, 556.7809, 'Jaina Mount'),
(3529900, 14, 8608.536, 745.5851, 550.9476, 'Jaina Mount'),
(3529900, 15, 8613.54, 752.3698, 548.3363, 'Jaina Mount'),
(3529900, 16, 8612.884, 754.2803, 547.6277, 'Jaina Mount'),
(3529900, 17, 8611.935, 740.467, 551.7665, 'Jaina Mount'),
(3529900, 18, 8637.618, 754.1163, 564.4597, 'Jaina Mount'),
(3529900, 19, 8647.946, 763.5712, 567.2928, 'Jaina Mount'),
(3529900, 20, 8664.131, 773.3229, 563.5434, 'Jaina Mount'),
(3529900, 21, 8705.323, 792.2136, 541.0161, 'Jaina Mount'),
(3529900, 22, 8722.38, 827.4722, 506.0163, 'Jaina Mount'),
(3529900, 23, 8739.074, 916.2239, 455.9886, 'Jaina Mount'),
(3529900, 24, 8761.381, 1050.175, 455.9886, 'Jaina Mount'),
(3529900, 25, 8736.964, 1341.703, 455.9886, 'Jaina Mount'),

(35372, 1, 8398.6298, 760.490, 547.386, 'Garrosh Hellscream'),
(35372, 2, 8383.6435, 784.220, 547.914, 'Garrosh Hellscream'),
(35372, 3, 8377.0156, 805.539, 548.018, 'Garrosh Hellscream'),
(35372, 4, 8376.6708, 840.990, 548.103, 'Garrosh Hellscream'),
(35372, 5, 8378.6201, 857.508, 548.004, 'Garrosh Hellscream'),
(35372, 6, 8383.6201, 860.508, 548.452, 'Garrosh Hellscream'),
(35372, 7, 8387.6201, 863.008, 547.908, 'Garrosh Hellscream'),
(35372, 8, 8396.6357, 865.744, 547.337, 'Garrosh Hellscream'),
(35372, 9, 8428.8574, 864.910, 547.318, 'Garrosh Hellscream'),
(35372, 10, 8456.6396, 866.976, 547.292, 'Garrosh Hellscream'),
(35372, 11, 8474.8427, 877.171, 547.292, 'Garrosh Hellscream'), --
(35372, 12, 8477.6396, 918.722, 547.293, 'Garrosh Hellscream'),
(35372, 13, 8480.2167, 941.642, 547.293, 'Garrosh Hellscream'),
(35372, 14, 8480.7275, 969.141, 547.293, 'Garrosh Hellscream'),
(35372, 15, 8479.6474, 993.006, 547.293, 'Garrosh Hellscream'),
(35372, 16, 8478.0166, 1014.40, 547.293, 'Garrosh Hellscream'),
(35372, 17, 8491.5761, 1022.95, 547.349, 'Garrosh Hellscream'),
(35372, 18, 8505.4404, 1023.33, 547.293, 'Garrosh Hellscream'), --
(35372, 19, 8511.6738, 1006.99, 547.470, 'Garrosh Hellscream'),
(35372, 20, 8510.8486, 975.127, 547.384, 'Garrosh Hellscream'),
(35372, 21, 8510.1572, 949.212, 547.554, 'Garrosh Hellscream'),
(35372, 22, 8510.6884, 911.829, 547.180, 'Garrosh Hellscream'),
(35372, 23, 8510.4580, 890.275, 554.885, 'Garrosh Hellscream'),
(35372, 24, 8512.3242, 871.617, 558.160, 'Garrosh Hellscream'),
(35372, 25, 8510.8789, 836.497, 558.557, 'Garrosh Hellscream'),

(35368, 1, 8392.2978, 756.2188, 547.2927, 'Thrall'),
(35368, 2, 8376.7773, 784.5188, 547.6294, 'Thrall'),
(35368, 3, 8370.5644, 805.7166, 547.8933, 'Thrall'),
(35368, 4, 8370.5205, 839.9608, 547.9965, 'Thrall'),
(35368, 5, 8372.3222, 860.5638, 548.6874, 'Thrall'),
(35368, 6, 8379.5000, 866.8442, 547.9967, 'Thrall'),
(35368, 7, 8383.6826, 869.3227, 548.0985, 'Thrall'),
(35368, 8, 8395.9179, 873.1944, 547.3145, 'Thrall'),
(35368, 9, 8428.8808, 872.2393, 547.4946, 'Thrall'),
(35368, 10, 8454.3750, 874.3332, 547.4978, 'Thrall'),
(35368, 11, 8468.3906, 880.1472, 547.3820, 'Thrall'), --
(35368, 12, 8470.1025, 918.5744, 547.2955, 'Thrall'),
(35368, 13, 8474.9697, 941.8276, 547.2940, 'Thrall'),
(35368, 14, 8475.0439, 969.0522, 547.2931, 'Thrall'),
(35368, 15, 8474.6523, 993.1818, 547.2931, 'Thrall'),
(35368, 16, 8473.4560, 1014.941, 547.2930, 'Thrall'),
(35368, 17, 8489.2929, 1029.449, 547.5503, 'Thrall'),
(35368, 18, 8504.4453, 1031.791, 547.4876, 'Thrall'),
(35368, 19, 8515.6181, 1024.304, 547.3082, 'Thrall'), --
(35368, 20, 8518.4267, 1007.761, 547.4848, 'Thrall'),
(35368, 21, 8517.8417, 974.8256, 547.4591, 'Thrall'),
(35368, 22, 8517.8144, 948.8816, 547.5582, 'Thrall'),
(35368, 23, 8517.8007, 911.8578, 547.1804, 'Thrall'),
(35368, 24, 8518.4384, 890.3071, 554.8779, 'Thrall'),
(35368, 25, 8519.3232, 871.7551, 558.1600, 'Thrall'),
(35368, 26, 8518.8583, 836.5913, 558.5587, 'Thrall'),

(35320, 1, 8622.47, 759.405, 547.4177, 'Lady Jaina Proudmoore'),
(35320, 2, 8637.25, 774.7917, 547.6496, 'Lady Jaina Proudmoore'),
(35320, 3, 8644.739, 782.4965, 547.5246, 'Lady Jaina Proudmoore'),
(35320, 4, 8644.862, 805.0521, 547.5709, 'Lady Jaina Proudmoore'),
(35320, 5, 8627.42, 821.719, 547.844, 'Lady Jaina Proudmoore'),
(35320, 6, 8613.42, 837.969, 548.344, 'Lady Jaina Proudmoore'),
(35320, 7, 8608.17, 842.469, 547.844, 'Lady Jaina Proudmoore'),
(35320, 8, 8601.23, 848.749, 547.861, 'Lady Jaina Proudmoore'),
(35320, 9, 8568.59, 876.945, 547.846, 'Lady Jaina Proudmoore'),
(35320, 10, 8568.81, 905.326, 547.844, 'Lady Jaina Proudmoore'),
(35320, 11, 8575.42, 931.524, 547.881, 'Lady Jaina Proudmoore'),
(35320, 12, 8574.33, 978.157, 547.788, 'Lady Jaina Proudmoore'),
(35320, 13, 8573.8, 996.077, 547.706, 'Lady Jaina Proudmoore'),
(35320, 14, 8547.21, 1025.6, 547.668, 'Lady Jaina Proudmoore'),
(35320, 15, 8522.49, 1022.52, 547.48, 'Lady Jaina Proudmoore'),
(35320, 16, 8510.44, 962.671, 547.71, 'Lady Jaina Proudmoore'),
(35320, 17, 8512.93, 908.633, 547.107, 'Lady Jaina Proudmoore'),
(35320, 18, 8509.26, 890.199, 555.392, 'Lady Jaina Proudmoore'),
(35320, 19, 8509.51, 882.949, 558.392, 'Lady Jaina Proudmoore'),
(35320, 20, 8509.76, 866.949, 558.392, 'Lady Jaina Proudmoore'),
(35321, 1, 8623.36, 761.884, 547.4177, 'King Varian Wrynn '),
(35321, 2, 8637.25, 774.7917, 547.6496, 'King Varian Wrynn '),
(35321, 3, 8644.739, 782.4965, 547.5246, 'King Varian Wrynn '),
(35321, 4, 8644.862, 805.0521, 547.5709, 'King Varian Wrynn '),
(35321, 5, 8627.39, 825.621, 547.844, 'King Varian Wrynn '),
(35321, 6, 8613.39, 837.871, 548.344, 'King Varian Wrynn '),
(35321, 7, 8608.14, 842.621, 547.844, 'King Varian Wrynn '),
(35321, 8, 8601.04, 848.538, 547.861, 'King Varian Wrynn '),
(35321, 9, 8568.62, 877.032, 547.845, 'King Varian Wrynn '),
(35321, 10, 8568.8, 905.266, 547.844, 'King Varian Wrynn '),
(35321, 11, 8575.41, 931.527, 547.881, 'King Varian Wrynn '),
(35321, 12, 8574.29, 978.237, 547.79, 'King Varian Wrynn '),
(35321, 13, 8573.76, 996.144, 547.687, 'King Varian Wrynn '),
(35321, 14, 8547.21, 1025.77, 547.668, 'King Varian Wrynn '),
(35321, 15, 8522.59, 1025.52, 547.48, 'King Varian Wrynn '),
(35321, 16, 8515.86, 966.69, 547.798, 'King Varian Wrynn '),
(35321, 17, 8515.84, 933.152, 547.62, 'King Varian Wrynn '),
(35321, 18, 8515.78, 909.503, 547.724, 'King Varian Wrynn '),
(35321, 19, 8515.28, 908.253, 547.724, 'King Varian Wrynn '),
(35321, 20, 8515.28, 907.753, 547.474, 'King Varian Wrynn '),
(35321, 21, 8515.78, 883.253, 558.224, 'King Varian Wrynn '),
(35321, 22, 8515.78, 882.503, 558.224, 'King Varian Wrynn '),
(35321, 23, 8515.86, 874.82, 558.4, 'King Varian Wrynn ');

DELETE FROM conditions WHERE SourceTypeOrReferenceId=22 AND SourceEntry=35361 AND SourceId=0;
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(22, 10, 35361, 0, 0, 12, 1, 68, 0, 0, 0, 0, 0, '', 'Tirion Fordring only run sai if event 68 is active'),
(22, 11, 35361, 0, 0, 12, 1, 69, 0, 0, 0, 0, 0, '', 'Tirion Fordring only run sai if event 69 is active');

DELETE FROM conditions WHERE SourceTypeOrReferenceId=13 AND SourceGroup=2 AND SourceEntry IN(69003,69007,69095,69096);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(13, 2, 69003, 0, 0, 31, 0, 3, 15214, 0, 0, 0, 0, '', '[DND] Argent Tournament - Event Controller - Alliance Effect #2 Targets Invisible Stalker'),
(13, 2, 69007, 0, 0, 31, 0, 3, 15214, 0, 0, 0, 0, '', '[DND] Argent Tournament - Event Controller - Horde Effect #2 Targets Invisible Stalker'),
(13, 2, 69095, 0, 0, 31, 0, 3, 15214, 0, 0, 0, 0, '', '[DND] Argent Tournament - Event Controller Tirion - Alliance Effect #2 Targets Invisible Stalker'),
(13, 2, 69096, 0, 0, 31, 0, 3, 15214, 0, 0, 0, 0, '', '[DND] Argent Tournament - Event Controller Tirion - Horde Effect #2 Targets Invisible Stalker');

What鈥檚 the issue with waypoints I previously already retook all of these from sniff well think the only npc which still has original wp is tirion

It happen in many spots Thrall/Garrosh or Varian/Jaina end up on top of each other, also guards wp for both faction event is really messy.

The val鈥檏yr is the one where waypoints maybe a bit dodgy as even though from sniff fly around the mountain to the west of argent tournament grounds before coming back and circling ground

Guards don鈥檛 have wp. For most of the path garrosh and thrall follow same wp with points where events happen been different that鈥檚 why I did put a pause in wp so don鈥檛 end up on top of each other much of path between the two npcs is identical

I will try to do some improvements tomorrow.

Horde event updated, only the Alliance to fix.

Was this page helpful?
0 / 5 - 0 ratings