- 916
- 2015
- 24
- Location
- Barryton Michigan USA
Code:
-- 12663 Reunited
-- 28666 Gorebag
UPDATE `creature_template` SET `speed_walk`=2.4, `speed_run`=0.992063, `AIName`='SmartAI' WHERE `entry`=28666;
DELETE FROM `smart_scripts` WHERE (`entryorguid`=28666 AND `source_type`=0);
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
(28666, 0, 0, 1, 62, 0, 100, 0, 9732, 0, 0, 0, 11, 52194, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, "Gorebag - On Gossip Option 0 Selected - Cast 'Force Cast Summon Gargoyle'"),
(28666, 0, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, "Gorebag - On Gossip Option 0 Selected - Close Gossip");
-- 28669 Flying Fiend
UPDATE `creature_template` SET `speed_walk`=4.4, `speed_run`=1.375, `InhabitType`=4, `AIName`='SmartAI', `vehicleId`=127 WHERE `entry`=28669;
DELETE FROM `smart_scripts` WHERE (`entryorguid`=28669 AND `source_type`=0);
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
(28669, 0, 0, 1, 54, 0, 100, 512, 0, 0, 0, 0, 11, 52191, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Flying Fiend - On Just Summoned - Cast 'Scourge Disguise'"),
(28669, 0, 1, 0, 61, 0, 100, 512, 0, 0, 0, 0, 53, 1, 2866900, 0, 12663, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Flying Fiend - On Just Summoned - Start Waypoint Movement"),
(28669, 0, 2, 0, 40, 0, 100, 512, 62, 2866900, 0, 0, 11, 52220, 2, 0, 0, 0, 0, 23, 0, 0, 0, 0, 0, 0, 0, "Flying Fiend - On Waypoint 62 Reached - Cast 'Kill Credit'"),
(28669, 0, 3, 0, 40, 0, 100, 512, 63, 2866900, 0, 0, 41, 0, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Flying Fiend - On Waypoint 63 Reached - Despawn Self");
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=1;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 1, 6063.74, -2094.86, 431.521, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=2;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 2, 5967.44, -2165.72, 422.854, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=3;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 3, 5865.67, -2174.97, 393.382, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=4;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 4, 5713.34, -2151.65, 373.465, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=5;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 5, 5558.72, -2128.13, 366.132, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=6;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 6, 5451.11, -2151.13, 354.437, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=7;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 7, 5377.81, -2219.12, 359.132, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=8;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 8, 5366.7, -2360.86, 377.715, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=9;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 9, 5435.39, -2533.55, 373.993, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=10;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 10, 5620.23, -2725.16, 344.521, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=11;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 11, 5710.93, -2849.44, 341.965, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=12;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 12, 5793.25, -3015.15, 364.354, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=13;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 13, 5879.36, -3182.92, 393.382, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=14;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 14, 5964.95, -3300, 393.382, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=15;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 15, 6115.4, -3420.54, 450.576, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=16;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 16, 6211.26, -3582.17, 481.242, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=17;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 17, 6279.31, -3777.03, 504.381, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=18;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 18, 6463.99, -3861.05, 546.214, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=19;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 19, 6575.97, -4030.92, 546.214, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=20;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 20, 6743.06, -4188.87, 546.214, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=21;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 21, 6896.73, -4247.42, 577.353, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=22;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 22, 6999.45, -4298.92, 582.935, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=23;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 23, 7100.7, -4416.98, 611.074, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=24;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 24, 7116.47, -4555.86, 660.657, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=25;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 25, 7057.5, -4669.8, 675.657, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=26;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 26, 6947.49, -4771.33, 660.657, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=27;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 27, 6758.4, -4783.88, 626.546, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=28;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 28, 6650.22, -4701.15, 597.241, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=29;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 29, 6627.31, -4597.56, 586.019, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=30;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 30, 6613.61, -4439.71, 592.657, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=31;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 31, 6526.06, -4289.04, 568.102, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=32;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 32, 6401.9, -4215.94, 538.574, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=33;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 33, 6286.81, -4191.78, 518.324, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=34;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 34, 6204.36, -4223.74, 465.074, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=35;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 35, 6134.58, -4239.07, 386.13, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=36;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 36, 5995.45, -4246.94, 428.518, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=37;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 37, 5909.65, -4251.92, 428.518, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=38;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 38, 5792.21, -4212.29, 428.518, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=39;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 39, 5656.49, -4115.37, 428.518, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=40;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 40, 5549.7, -3983.66, 428.518, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=41;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 41, 5495.66, -3853.95, 428.518, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=42;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 42, 5463.38, -3751.72, 428.518, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=43;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 43, 5430.44, -3669.38, 428.518, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=44;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 44, 5348.06, -3559.13, 406.38, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=45;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 45, 5240.04, -3418.71, 381.407, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=46;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 46, 5160.26, -3335.48, 381.407, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=47;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 47, 5044.02, -3214.56, 381.407, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=48;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 48, 4994.62, -3163.26, 381.407, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=49;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 49, 4929.42, -3062.17, 381.407, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=50;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 50, 4874.15, -2945.8, 381.407, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=51;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 51, 4892.92, -2768.81, 381.407, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=52;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 52, 5019.18, -2627.01, 381.407, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=53;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 53, 5067.44, -2519.11, 381.407, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=54;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 54, 5081.71, -2368, 381.407, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=55;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 55, 5152.34, -2120.36, 419.435, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=56;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 56, 5368.51, -1851.12, 422.851, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=57;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 57, 5660.99, -1784.47, 360.546, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=58;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 58, 5851.7, -1800.85, 350.13, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=59;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 59, 6030.71, -1864, 348.157, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=60;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 60, 6103.75, -1910.46, 354.324, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=61;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 61, 6163.79, -1944.53, 374.379, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=62;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 62, 6183.49, -1976.16, 410.129, 'Flying Fiend - Reunited');
DELETE FROM `waypoints` WHERE `entry`=2866900 AND `pointid`=63;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (2866900, 63, 6184.05, -1991.26, 417.323, 'Flying Fiend - Reunited');