search

Looking4Group / L4G_Core

Looking4Group Core
http://looking4group.eu
GNU General Public License v2.0
37 stars 69 forks source link

Molten Core - Patrols #2573

Closed Xadras closed 8 years ago

Xadras commented 8 years ago

Originally reported by: Anon X (Bitbucket: Anonx, GitHub: Anonx)

thx @Tobschinski

Xadras commented 8 years ago

Original comment by Anon X (Bitbucket: Anonx, GitHub: Anonx):

U 01.07.16

Xadras commented 8 years ago

Original comment by Anon X (Bitbucket: Anonx, GitHub: Anonx):

#!sql

-- https://bitbucket.org/looking4group_b2tbc/looking4group/issues/2479/molten-core-patrols
--
-- Lava Surger 12101 [-12|+12]
DELETE FROM `creature` WHERE `id`='12101';
INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
('56656', '12101', '409', '1', '0', '0', '1039.557', '-666.4965', '-175.5690', '5.393786', '1680', '0', '0', '0', '0', '0', '2'),
('56657', '12101', '409', '1', '0', '0', '1013.988', '-807.3286', '-148.2019', '5.479007', '1680', '0', '0', '0', '0', '0', '2'),
('56658', '12101', '409', '1', '0', '0', '1056.576', '-861.7056', '-159.4021', '2.829309', '1680', '0', '0', '0', '0', '0', '2'),
('56659', '12101', '409', '1', '0', '0', '956.5746', '-882.7143', '-173.4351', '5.244633', '1680', '0', '0', '0', '0', '0', '2'),
('56660', '12101', '409', '1', '0', '0', '1009.204', '-863.9430', '-164.4548', '4.396853', '1680', '0', '0', '0', '0', '0', '2'),
('56661', '12101', '409', '1', '0', '0', '989.7455', '-625.5197', '-200.8345', '1.059593', '1680', '0', '0', '0', '0', '0', '2'),
('56662', '12101', '409', '1', '0', '0', '805.4228', '-659.1059', '-206.9372', '4.054467', '1680', '0', '0', '0', '0', '0', '2'),
('56664', '12101', '409', '1', '0', '0', '766.6229', '-685.1467', '-212.6748', '4.289903', '1680', '0', '0', '0', '0', '0', '2'),
('56665', '12101', '409', '1', '0', '0', '889.0994', '-822.9662', '-227.2441', '1.828480', '1680', '0', '0', '0', '0', '0', '2'),
('56666', '12101', '409', '1', '0', '0', '691.6334', '-662.5723', '-209.6153', '5.214818', '1680', '0', '0', '0', '0', '0', '2'),
('56740', '12101', '409', '1', '0', '0', '608.5266', '-1192.999', '-195.7372', '0.417171', '1680', '0', '0', '0', '0', '0', '2'),
('56741', '12101', '409', '1', '0', '0', '758.0289', '-1227.535', '-119.5741', '2.510490', '1680', '0', '0', '0', '0', '0', '2');
-- Ancient Core Hound 11673 [-14|+15]
DELETE FROM `creature` WHERE `id`='11673';
INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
('56667', '11673', '409', '1', '0', '0', '1142.959', '-645.0295', '-131.8003', '1.6231560', '1080', '0', '0', '0', '0', '0', '2'),
('56668', '11673', '409', '1', '0', '0', '711.9438', '-591.7904', '-210.7750', '1.4198990', '1080', '0', '0', '0', '0', '0', '2'),
('56669', '11673', '409', '1', '0', '0', '1039.007', '-817.4524', '-152.2047', '0.9648618', '1080', '0', '0', '0', '0', '0', '2'),
('56670', '11673', '409', '1', '0', '0', '813.1617', '-646.3583', '-204.5891', '0.7919637', '1080', '0', '0', '0', '0', '0', '2'),
('56671', '11673', '409', '1', '0', '0', '669.2405', '-532.0613', '-210.2233', '0.2158491', '1080', '0', '0', '0', '0', '0', '2'),
('56672', '11673', '409', '1', '0', '0', '708.1201', '-604.0325', '-209.6696', '4.3744790', '1080', '0', '0', '0', '0', '0', '2'),
('56673', '11673', '409', '1', '0', '0', '729.6019', '-485.4805', '-212.5103', '4.5383950', '1080', '0', '0', '0', '0', '0', '2'),
('56674', '11673', '409', '1', '0', '0', '709.8370', '-932.3306', '-191.2970', '1.9807470', '1080', '0', '0', '0', '0', '0', '2'),
('56675', '11673', '409', '1', '0', '0', '705.4085', '-1197.964', '-119.9327', '2.5816860', '1080', '0', '0', '0', '0', '0', '2'),
('56676', '11673', '409', '1', '0', '0', '576.6952', '-777.4089', '-207.3211', '4.4228480', '1080', '0', '0', '0', '0', '0', '2'),
('56742', '11673', '409', '1', '0', '0', '814.4380', '-973.4529', '-208.8811', '5.0248670', '1080', '0', '0', '0', '0', '0', '2'),
('56743', '11673', '409', '1', '0', '0', '607.6859', '-1160.476', '-198.0445', '1.1930560', '1080', '0', '0', '0', '0', '0', '2'),
('56744', '11673', '409', '1', '0', '0', '659.5686', '-1071.075', '-190.9022', '6.1722460', '1080', '0', '0', '0', '0', '0', '2'),
('56745', '11673', '409', '1', '0', '0', '746.8201', '-997.8535', '-177.5622', '4.2786960', '1080', '0', '0', '0', '0', '0', '2'),
('56746', '11673', '409', '1', '0', '0', '796.0061', '-639.6680', '-204.3206', '0.3408172', '1080', '0', '0', '0', '0', '0', '2');

-- -------------------------------------------------------------------------------------------------------------------------------
SET @GUID := '56656';
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
('56656', '01', '1046.413', '-674.9515', '-169.5157', '0', '0', '0', '100', '0'),
('56656', '02', '1068.962', '-696.5590', '-157.7810', '0', '0', '0', '100', '0'),
('56656', '03', '1053.966', '-737.0459', '-151.7794', '0', '0', '0', '100', '0'),
('56656', '04', '1059.624', '-760.5685', '-151.5860', '0', '0', '0', '100', '0'),
('56656', '05', '1084.683', '-739.8831', '-150.7728', '0', '0', '0', '100', '0'),
('56656', '06', '1099.292', '-778.5201', '-151.1692', '0', '0', '0', '100', '0'),
('56656', '07', '1125.305', '-739.6833', '-142.7612', '0', '0', '0', '100', '0'),
('56656', '08', '1159.508', '-719.2535', '-133.2384', '0', '0', '0', '100', '0'),
('56656', '09', '1192.168', '-686.1762', '-128.7967', '0', '0', '0', '100', '0'),
('56656', '10', '1211.332', '-653.7628', '-127.9139', '0', '0', '0', '100', '0'),
('56656', '11', '1187.516', '-611.0389', '-121.1588', '0', '0', '0', '100', '0'),
('56656', '12', '1148.847', '-599.9906', '-114.8980', '0', '0', '0', '100', '0'),
('56656', '13', '1187.516', '-611.0389', '-121.1588', '0', '0', '0', '100', '0'),
('56656', '14', '1211.332', '-653.7628', '-127.9139', '0', '0', '0', '100', '0'),
('56656', '15', '1192.168', '-686.1762', '-128.7967', '0', '0', '0', '100', '0'),
('56656', '16', '1159.508', '-719.2535', '-133.2384', '0', '0', '0', '100', '0'),
('56656', '17', '1125.392', '-739.6312', '-142.7302', '0', '0', '0', '100', '0'),
('56656', '18', '1099.292', '-778.5201', '-151.1692', '0', '0', '0', '100', '0'),
('56656', '19', '1084.683', '-739.8831', '-150.7728', '0', '0', '0', '100', '0'),
('56656', '20', '1059.654', '-760.5442', '-151.5920', '0', '0', '0', '100', '0'),
('56656', '21', '1053.966', '-737.0459', '-151.7794', '0', '0', '0', '100', '0'),
('56656', '22', '1068.962', '-696.5590', '-157.7810', '0', '0', '0', '100', '0'),
('56656', '23', '1046.413', '-674.9515', '-169.5157', '0', '0', '0', '100', '0'),
('56656', '24', '1023.840', '-646.4510', '-189.8513', '0', '0', '0', '100', '0');

SET @GUID := '56657';
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
('56657', '01', '1032.143', '-826.1788', '-154.2626', '0', '0', '0', '100', '0'),
('56657', '02', '1055.823', '-833.2653', '-154.4680', '0', '0', '0', '100', '0'),
('56657', '03', '1032.143', '-826.1788', '-154.2626', '0', '0', '0', '100', '0'),
('56657', '04', '1015.666', '-808.7546', '-148.7213', '0', '0', '0', '100', '0');

SET @GUID := '56658';
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
('56658', '01', '1035.173', '-854.7958', '-158.8589', '0', '0', '0', '100', '0'),
('56658', '02', '995.0676', '-853.4235', '-165.4317', '0', '0', '0', '100', '0'),
('56658', '03', '1035.173', '-854.7958', '-158.8589', '0', '0', '0', '100', '0'),
('56658', '04', '1057.385', '-862.5274', '-159.6177', '0', '0', '0', '100', '0');

SET @GUID := '56659';
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
('56659', '01', '966.7530', '-899.8453', '-175.7252', '0', '0', '0', '100', '0'),
('56659', '02', '980.3823', '-904.3610', '-171.1376', '0', '0', '0', '100', '0'),
('56659', '03', '1008.565', '-890.0919', '-165.3463', '0', '0', '0', '100', '0'),
('56659', '04', '1028.491', '-908.0417', '-161.3687', '0', '0', '0', '100', '0'),
('56659', '05', '1041.238', '-888.9818', '-158.3343', '0', '0', '0', '100', '0'),
('56659', '06', '1061.057', '-900.0848', '-159.2599', '0', '0', '0', '100', '0'),
('56659', '07', '1071.243', '-893.1624', '-156.4947', '0', '0', '0', '100', '0'),
('56659', '08', '1061.057', '-900.0848', '-159.2599', '0', '0', '0', '100', '0'),
('56659', '09', '1041.238', '-888.9818', '-158.3343', '0', '0', '0', '100', '0'),
('56659', '10', '1028.491', '-908.0417', '-161.3687', '0', '0', '0', '100', '0'),
('56659', '11', '1008.565', '-890.0919', '-165.3463', '0', '0', '0', '100', '0'),
('56659', '12', '980.3823', '-904.3610', '-171.1376', '0', '0', '0', '100', '0'),
('56659', '13', '966.7530', '-899.8453', '-175.7252', '0', '0', '0', '100', '0'),
('56659', '14', '957.4196', '-885.5380', '-173.7588', '0', '0', '0', '100', '0');

SET @GUID := '56660';
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
('56660', '01', '1001.684', '-886.9771', '-167.0547', '0', '0', '0', '100', '0'),
('56660', '02', '987.0620', '-893.2951', '-169.7379', '0', '0', '0', '100', '0'),
('56660', '03', '962.8450', '-884.6795', '-173.6825', '0', '0', '0', '100', '0'),
('56660', '04', '996.8139', '-897.9012', '-168.1947', '0', '0', '0', '100', '0'),
('56660', '05', '1031.916', '-889.5740', '-160.0134', '0', '0', '0', '100', '0'),
('56660', '06', '1069.734', '-893.8550', '-156.7931', '0', '0', '0', '100', '0'),
('56660', '07', '1031.916', '-889.5740', '-160.0134', '0', '0', '0', '100', '0'),
('56660', '08', '996.8139', '-897.9012', '-168.1947', '0', '0', '0', '100', '0'),
('56660', '09', '962.8450', '-884.6795', '-173.6825', '0', '0', '0', '100', '0'),
('56660', '10', '987.0620', '-893.2951', '-169.7379', '0', '0', '0', '100', '0'),
('56660', '11', '1001.684', '-886.9771', '-167.0547', '0', '0', '0', '100', '0'),
('56660', '12', '1008.282', '-863.9785', '-164.7876', '0', '0', '0', '100', '0');

SET @GUID := '56661';
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
('56661', '01', '998.6928', '-609.5692', '-202.0619', '0', '0', '0', '100', '0'),
('56661', '02', '989.8893', '-595.9269', '-203.2261', '0', '0', '0', '100', '0'),
('56661', '03', '975.5094', '-589.3787', '-203.7810', '0', '0', '0', '100', '0'),
('56661', '04', '958.4057', '-595.7327', '-203.9931', '0', '0', '0', '100', '0'),
('56661', '05', '950.7159', '-608.6719', '-202.8820', '0', '0', '0', '100', '0'),
('56661', '06', '957.0149', '-625.9316', '-203.2590', '0', '0', '0', '100', '0'),
('56661', '07', '980.0177', '-632.2986', '-203.5142', '0', '0', '0', '100', '0'),
('56661', '08', '990.2437', '-625.7770', '-200.7675', '0', '0', '0', '100', '0');

SET @GUID := '56662';
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
('56662', '01', '800.4368', '-665.5578', '-208.9407', '0', '0', '0', '100', '0'),
('56662', '02', '779.0322', '-680.1849', '-213.9095', '0', '0', '0', '100', '0'),
('56662', '03', '759.9225', '-689.7131', '-212.5623', '0', '0', '0', '100', '0'),
('56662', '04', '753.9745', '-704.1632', '-211.7530', '0', '0', '0', '100', '0'),
('56662', '05', '758.8966', '-684.4725', '-212.3810', '0', '0', '0', '100', '0'),
('56662', '06', '780.8896', '-669.5650', '-211.4591', '0', '0', '0', '100', '0'),
('56662', '07', '791.4582', '-652.9810', '-207.6324', '0', '0', '0', '100', '0'),
('56662', '08', '780.8896', '-669.5650', '-211.4591', '0', '0', '0', '100', '0'),
('56662', '09', '758.8966', '-684.4725', '-212.3810', '0', '0', '0', '100', '0'),
('56662', '10', '753.9745', '-704.1632', '-211.7530', '0', '0', '0', '100', '0'),
('56662', '11', '759.9225', '-689.7131', '-212.5623', '0', '0', '0', '100', '0'),
('56662', '12', '779.0322', '-680.1849', '-213.9095', '0', '0', '0', '100', '0'),
('56662', '13', '800.4368', '-665.5578', '-208.9407', '0', '0', '0', '100', '0'),
('56662', '14', '807.4164', '-656.2690', '-206.1155', '0', '0', '0', '100', '0');

SET @GUID := '56664';
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
('56664', '01', '748.5151', '-725.4263', '-211.9395', '0', '0', '0', '100', '0'),
('56664', '02', '739.7422', '-763.3509', '-218.9724', '0', '0', '0', '100', '0'),
('56664', '03', '737.3899', '-809.9995', '-225.6305', '0', '0', '0', '100', '0'),
('56664', '04', '745.2436', '-850.8501', '-223.6281', '0', '0', '0', '100', '0'),
('56664', '05', '737.3899', '-809.9995', '-225.6305', '0', '0', '0', '100', '0'),
('56664', '06', '739.7422', '-763.3509', '-218.9724', '0', '0', '0', '100', '0'),
('56664', '07', '748.5151', '-725.4263', '-211.9395', '0', '0', '0', '100', '0'),
('56664', '08', '764.8676', '-686.4996', '-212.5972', '0', '0', '0', '100', '0');

SET @GUID := '56665';
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
('56665', '01', '884.0205', '-803.6951', '-226.6926', '0', '0', '0', '100', '0'),
('56665', '02', '865.6118', '-779.7151', '-225.9819', '0', '0', '0', '100', '0'),
('56665', '03', '865.0396', '-765.1099', '-224.7500', '0', '0', '0', '100', '0'),
('56665', '04', '879.3519', '-761.3517', '-224.0491', '0', '0', '0', '100', '0'),
('56665', '05', '895.7159', '-764.4568', '-224.3548', '0', '0', '0', '100', '0'),
('56665', '06', '909.2687', '-788.9470', '-226.9377', '0', '0', '0', '100', '0'),
('56665', '07', '912.3800', '-812.9961', '-227.3731', '0', '0', '0', '100', '0'),
('56665', '08', '917.8469', '-848.5494', '-219.4701', '0', '0', '0', '100', '0'),
('56665', '09', '913.7874', '-875.5369', '-214.2200', '0', '0', '0', '100', '0'),
('56665', '10', '890.5936', '-905.0054', '-222.0683', '0', '0', '0', '100', '0'),
('56665', '11', '860.6026', '-921.1229', '-225.7609', '0', '0', '0', '100', '0'),
('56665', '12', '816.9810', '-920.8954', '-225.8454', '0', '0', '0', '100', '0'),
('56665', '13', '782.6620', '-911.1868', '-222.6471', '0', '0', '0', '100', '0'),
('56665', '14', '816.9766', '-920.8942', '-225.8542', '0', '0', '0', '100', '0'),
('56665', '15', '860.6026', '-921.1229', '-225.7609', '0', '0', '0', '100', '0'),
('56665', '16', '890.5936', '-905.0054', '-222.0683', '0', '0', '0', '100', '0'),
('56665', '17', '913.7874', '-875.5369', '-214.2200', '0', '0', '0', '100', '0'),
('56665', '18', '917.8469', '-848.5494', '-219.4701', '0', '0', '0', '100', '0'),
('56665', '19', '912.3800', '-812.9961', '-227.3731', '0', '0', '0', '100', '0'),
('56665', '20', '909.2687', '-788.9470', '-226.9377', '0', '0', '0', '100', '0'),
('56665', '21', '895.7159', '-764.4568', '-224.3548', '0', '0', '0', '100', '0'),
('56665', '22', '879.3519', '-761.3517', '-224.0491', '0', '0', '0', '100', '0'),
('56665', '23', '865.0396', '-765.1099', '-224.7500', '0', '0', '0', '100', '0'),
('56665', '24', '865.6118', '-779.7151', '-225.9819', '0', '0', '0', '100', '0'),
('56665', '25', '884.0205', '-803.6951', '-226.6926', '0', '0', '0', '100', '0'),
('56665', '26', '889.6862', '-825.1835', '-227.3351', '0', '0', '0', '100', '0');

SET @GUID := '56666';
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
('56666', '01', '708.2625', '-692.8368', '-209.5175', '0', '0', '0', '100', '0'),
('56666', '02', '707.9111', '-711.0708', '-209.5187', '0', '0', '0', '100', '0'),
('56666', '03', '686.1985', '-738.5436', '-209.2948', '0', '0', '0', '100', '0'),
('56666', '04', '681.6021', '-776.7833', '-209.1657', '0', '0', '0', '100', '0'),
('56666', '05', '665.0020', '-813.2372', '-208.7740', '0', '0', '0', '100', '0'),
('56666', '06', '676.7046', '-829.8509', '-208.8353', '0', '0', '0', '100', '0'),
('56666', '07', '679.1953', '-847.3836', '-208.2482', '0', '0', '0', '100', '0'),
('56666', '08', '696.5482', '-855.4606', '-206.0954', '0', '0', '0', '100', '0'),
('56666', '09', '697.0541', '-866.1818', '-204.0854', '0', '0', '0', '100', '0'),
('56666', '10', '710.7119', '-882.6242', '-198.9530', '0', '0', '0', '100', '0'),
('56666', '11', '714.8118', '-907.6405', '-193.7685', '0', '0', '0', '100', '0'),
('56666', '12', '735.3042', '-937.3447', '-188.4066', '0', '0', '0', '100', '0'),
('56666', '13', '714.8118', '-907.6405', '-193.7685', '0', '0', '0', '100', '0'),
('56666', '14', '710.7119', '-882.6242', '-198.9530', '0', '0', '0', '100', '0'),
('56666', '15', '697.0541', '-866.1818', '-204.0854', '0', '0', '0', '100', '0'),
('56666', '16', '679.1953', '-847.3836', '-208.2482', '0', '0', '0', '100', '0'),
('56666', '17', '676.7046', '-829.8509', '-208.8353', '0', '0', '0', '100', '0'),
('56666', '18', '665.0020', '-813.2372', '-208.7740', '0', '0', '0', '100', '0'),
('56666', '19', '681.6021', '-776.7833', '-209.1657', '0', '0', '0', '100', '0'),
('56666', '20', '686.1985', '-738.5436', '-209.2948', '0', '0', '0', '100', '0'),
('56666', '21', '707.9111', '-711.0708', '-209.5187', '0', '0', '0', '100', '0'),
('56666', '22', '708.2624', '-692.8405', '-209.5718', '0', '0', '0', '100', '0'),
('56666', '23', '690.2739', '-662.6287', '-209.6574', '0', '0', '0', '100', '0');

SET @GUID := '56740';
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
('56740', '01', '623.8442', '-1186.210', '-195.8348', '0', '0', '0', '100', '0'),
('56740', '02', '628.4896', '-1171.869', '-194.5435', '0', '0', '0', '100', '0'),
('56740', '03', '628.3709', '-1151.011', '-197.0152', '0', '0', '0', '100', '0'),
('56740', '04', '626.8060', '-1131.724', '-200.8709', '0', '0', '0', '100', '0'),
('56740', '05', '645.6395', '-1106.676', '-196.4797', '0', '0', '0', '100', '0'),
('56740', '06', '667.9337', '-1066.047', '-188.3889', '0', '0', '0', '100', '0'),
('56740', '07', '619.8726', '-1066.640', '-199.7958', '0', '0', '0', '100', '0'),
('56740', '08', '613.3337', '-1099.887', '-198.7582', '0', '0', '0', '100', '0'),
('56740', '09', '591.3667', '-1135.207', '-200.2088', '0', '0', '0', '100', '0'),
('56740', '10', '578.8029', '-1173.733', '-194.7558', '0', '0', '0', '100', '0'),
('56740', '11', '591.5503', '-1192.438', '-195.7943', '0', '0', '0', '100', '0'),
('56740', '12', '608.1950', '-1194.054', '-195.7651', '0', '0', '0', '100', '0');

SET @GUID := '56741';
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
('56741', '01', '736.2715', '-1211.634', '-118.8998', '0', '0', '0', '100', '0'),
('56741', '02', '717.1637', '-1193.438', '-118.9491', '0', '0', '0', '100', '0'),
('56741', '03', '693.4008', '-1186.742', '-120.9137', '0', '0', '0', '100', '0'),
('56741', '04', '666.1591', '-1162.693', '-126.0165', '0', '0', '0', '100', '0'),
('56741', '05', '701.5763', '-1137.426', '-135.6903', '0', '0', '0', '100', '0'),
('56741', '06', '723.3930', '-1106.211', '-143.0938', '0', '0', '0', '100', '0'),
('56741', '07', '757.2313', '-1129.672', '-145.1273', '0', '0', '0', '100', '0'),
('56741', '08', '787.2233', '-1123.192', '-150.5524', '0', '0', '0', '100', '0'),
('56741', '09', '791.8120', '-1152.450', '-150.4214', '0', '0', '0', '100', '0'),
('56741', '10', '809.3260', '-1150.683', '-152.5631', '0', '0', '0', '100', '0'),
('56741', '11', '819.8719', '-1143.500', '-153.6145', '0', '0', '0', '100', '0'),
('56741', '12', '839.0113', '-1128.492', '-156.5452', '0', '0', '0', '100', '0'),
('56741', '13', '855.7172', '-1121.873', '-161.9807', '0', '0', '0', '100', '0'),
('56741', '14', '870.0406', '-1110.407', '-169.6678', '0', '0', '0', '100', '0'),
('56741', '15', '883.1496', '-1090.733', '-176.0342', '0', '0', '0', '100', '0'),
('56741', '16', '891.1622', '-1067.062', '-182.6621', '0', '0', '0', '100', '0'),
('56741', '17', '891.3988', '-1050.081', '-187.1399', '0', '0', '0', '100', '0'),
('56741', '18', '875.8871', '-1014.841', '-194.9043', '0', '0', '0', '100', '0'),
('56741', '19', '864.6398', '-983.1211', '-199.6699', '0', '0', '0', '100', '0'),
('56741', '20', '875.8871', '-1014.841', '-194.9043', '0', '0', '0', '100', '0'),
('56741', '21', '891.3988', '-1050.081', '-187.1399', '0', '0', '0', '100', '0'),
('56741', '22', '891.1622', '-1067.062', '-182.6621', '0', '0', '0', '100', '0'),
('56741', '23', '883.1496', '-1090.733', '-176.0342', '0', '0', '0', '100', '0'),
('56741', '24', '870.0406', '-1110.407', '-169.6678', '0', '0', '0', '100', '0'),
('56741', '25', '855.7172', '-1121.873', '-161.9807', '0', '0', '0', '100', '0'),
('56741', '26', '839.0113', '-1128.492', '-156.5452', '0', '0', '0', '100', '0'),
('56741', '27', '819.8719', '-1143.500', '-153.6145', '0', '0', '0', '100', '0'),
('56741', '28', '809.3260', '-1150.683', '-152.5631', '0', '0', '0', '100', '0'),
('56741', '29', '791.8120', '-1152.450', '-150.4214', '0', '0', '0', '100', '0'),
('56741', '30', '787.2233', '-1123.192', '-150.5524', '0', '0', '0', '100', '0'),
('56741', '31', '757.2313', '-1129.672', '-145.1273', '0', '0', '0', '100', '0'),
('56741', '32', '723.3930', '-1106.211', '-143.0938', '0', '0', '0', '100', '0'),
('56741', '33', '701.5763', '-1137.426', '-135.6903', '0', '0', '0', '100', '0'),
('56741', '34', '666.1591', '-1162.693', '-126.0165', '0', '0', '0', '100', '0'),
('56741', '35', '693.4008', '-1186.742', '-120.9137', '0', '0', '0', '100', '0'),
('56741', '36', '717.1637', '-1193.438', '-118.9491', '0', '0', '0', '100', '0'),
('56741', '37', '736.2715', '-1211.634', '-118.8998', '0', '0', '0', '100', '0'),
('56741', '38', '759.3818', '-1228.879', '-119.2757', '0', '0', '0', '100', '0');

SET @GUID := '56667';
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
('56667', '01', '1142.684', '-647.4110', '-131.9233', '0', '0', '0', '100', '0'),
('56667', '02', '1142.684', '-647.4110', '-131.9233', '150000', '0', '0', '100', '0'),
('56667', '03', '1144.050', '-662.6844', '-131.4626', '0', '0', '0', '100', '0'),
('56667', '04', '1160.286', '-696.8795', '-132.4863', '0', '0', '0', '100', '0'),
('56667', '05', '1129.031', '-721.0490', '-139.5804', '0', '0', '0', '100', '0'),
('56667', '06', '1118.512', '-712.1383', '-144.2585', '0', '0', '0', '100', '0'),
('56667', '07', '1104.687', '-722.1303', '-146.9832', '0', '0', '0', '100', '0'),
('56667', '08', '1090.824', '-731.3634', '-149.9868', '0', '0', '0', '100', '0'),
('56667', '09', '1070.791', '-717.5623', '-153.4831', '0', '0', '0', '100', '0'),
('56667', '10', '1080.754', '-681.5721', '-159.8726', '150000', '0', '0', '100', '0'),
('56667', '11', '1080.101', '-708.4520', '-154.2289', '0', '0', '0', '100', '0'),
('56667', '12', '1084.528', '-731.8951', '-151.0118', '0', '0', '0', '100', '0'),
('56667', '13', '1093.696', '-748.0836', '-149.2619', '0', '0', '0', '100', '0'),
('56667', '14', '1110.641', '-738.1426', '-146.5005', '0', '0', '0', '100', '0'),
('56667', '15', '1115.694', '-716.5850', '-144.6347', '0', '0', '0', '100', '0'),
('56667', '16', '1148.220', '-713.5815', '-132.9880', '0', '0', '0', '100', '0'),
('56667', '17', '1161.699', '-694.4932', '-132.2003', '0', '0', '0', '100', '0'),
('56667', '18', '1149.113', '-669.7729', '-130.3396', '0', '0', '0', '100', '0');

SET @GUID := '56668';
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
('56668', '01', '716.2954', '-563.1713', '-215.2122', '0', '0', '0', '100', '0'),
('56668', '02', '730.7200', '-541.2038', '-216.5207', '0', '0', '0', '100', '0'),
('56668', '03', '751.7352', '-537.1676', '-215.0087', '0', '0', '0', '100', '0'),
('56668', '04', '782.8221', '-568.6121', '-213.2396', '0', '0', '0', '100', '0'),
('56668', '05', '826.4692', '-557.4173', '-206.1204', '0', '0', '0', '100', '0'),
('56668', '06', '862.7628', '-559.3347', '-203.8248', '0', '0', '0', '100', '0'),
('56668', '07', '897.3094', '-575.2031', '-203.7624', '0', '0', '0', '100', '0'),
('56668', '08', '928.2740', '-599.9254', '-203.4944', '0', '0', '0', '100', '0'),
('56668', '09', '976.9997', '-588.0521', '-203.5660', '0', '0', '0', '100', '0'),
('56668', '10', '1013.348', '-611.7108', '-198.8222', '0', '0', '0', '100', '0'),
('56668', '11', '1031.784', '-628.6943', '-189.8679', '0', '0', '0', '100', '0'),
('56668', '12', '1054.582', '-638.4258', '-174.0191', '0', '0', '0', '100', '0'),
('56668', '13', '1082.930', '-658.8265', '-159.5947', '0', '0', '0', '100', '0'),
('56668', '14', '1102.016', '-688.0265', '-153.0321', '0', '0', '0', '100', '0'),
('56668', '15', '1095.611', '-709.9710', '-151.2729', '0', '0', '0', '100', '0'),
('56668', '16', '1102.016', '-688.0265', '-153.0321', '0', '0', '0', '100', '0'),
('56668', '17', '1082.930', '-658.8265', '-159.5947', '0', '0', '0', '100', '0'),
('56668', '18', '1054.582', '-638.4258', '-174.0191', '0', '0', '0', '100', '0'),
('56668', '19', '1031.784', '-628.6943', '-189.8679', '0', '0', '0', '100', '0'),
('56668', '20', '1013.348', '-611.7108', '-198.8222', '0', '0', '0', '100', '0'),
('56668', '21', '976.9997', '-588.0521', '-203.5660', '0', '0', '0', '100', '0'),
('56668', '22', '928.2740', '-599.9254', '-203.4944', '0', '0', '0', '100', '0'),
('56668', '23', '897.3094', '-575.2031', '-203.7624', '0', '0', '0', '100', '0'),
('56668', '24', '862.7628', '-559.3347', '-203.8248', '0', '0', '0', '100', '0'),
('56668', '25', '826.4692', '-557.4173', '-206.1204', '0', '0', '0', '100', '0'),
('56668', '26', '782.8221', '-568.6121', '-213.2396', '0', '0', '0', '100', '0'),
('56668', '27', '751.7352', '-537.1676', '-215.0087', '0', '0', '0', '100', '0'),
('56668', '28', '730.7200', '-541.2038', '-216.5207', '0', '0', '0', '100', '0'),
('56668', '29', '716.2954', '-563.1713', '-215.2122', '0', '0', '0', '100', '0'),
('56668', '30', '710.9113', '-588.9549', '-211.3497', '0', '0', '0', '100', '0');

SET @GUID := '56669';
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
('56669', '01', '1051.314', '-799.6896', '-151.9713', '0', '0', '0', '100', '0'),
('56669', '02', '1039.667', '-791.0968', '-151.0096', '0', '0', '0', '100', '0'),
('56669', '03', '1026.315', '-767.8003', '-156.6493', '0', '0', '0', '100', '0'),
('56669', '04', '1038.774', '-761.6977', '-152.6580', '0', '0', '0', '100', '0'),
('56669', '05', '1064.627', '-748.9409', '-151.7516', '0', '0', '0', '100', '0'),
('56669', '06', '1038.774', '-761.6977', '-152.6580', '0', '0', '0', '100', '0'),
('56669', '07', '1026.315', '-767.8003', '-156.6493', '0', '0', '0', '100', '0'),
('56669', '08', '1039.641', '-791.0518', '-150.9892', '0', '0', '0', '100', '0'),
('56669', '09', '1026.315', '-767.8003', '-156.6493', '0', '0', '0', '100', '0'),
('56669', '10', '1039.641', '-791.0518', '-150.9892', '0', '0', '0', '100', '0'),
('56669', '11', '1051.314', '-799.6896', '-151.9713', '0', '0', '0', '100', '0'),
('56669', '12', '1040.764', '-815.1115', '-152.1656', '0', '0', '0', '100', '0');

SET @GUID := '56670';
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
('56670', '01', '831.3860', '-627.8932', '-203.1487', '0', '0', '0', '100', '0'),
('56670', '02', '856.4564', '-617.9056', '-202.1571', '0', '0', '0', '100', '0'),
('56670', '03', '899.6118', '-613.5433', '-202.2377', '0', '0', '0', '100', '0'),
('56670', '04', '936.2535', '-612.5002', '-203.6217', '0', '0', '0', '100', '0'),
('56670', '05', '975.1815', '-641.0467', '-201.5775', '0', '0', '0', '100', '0'),
('56670', '06', '1002.311', '-661.9902', '-194.1922', '0', '0', '0', '100', '0'),
('56670', '07', '1024.067', '-684.3118', '-173.4296', '0', '0', '0', '100', '0'),
('56670', '08', '1042.016', '-695.8206', '-163.7581', '0', '0', '0', '100', '0'),
('56670', '09', '1058.163', '-706.0782', '-156.6107', '0', '0', '0', '100', '0'),
('56670', '10', '1068.566', '-742.8318', '-151.7328', '0', '0', '0', '100', '0'),
('56670', '11', '1117.097', '-744.4790', '-145.6289', '0', '0', '0', '100', '0'),
('56670', '12', '1149.458', '-726.4506', '-133.8044', '0', '0', '0', '100', '0'),
('56670', '13', '1175.513', '-702.1757', '-130.9873', '0', '0', '0', '100', '0'),
('56670', '14', '1200.504', '-670.9343', '-128.5453', '0', '0', '0', '100', '0'),
('56670', '15', '1202.953', '-639.3985', '-126.1688', '0', '0', '0', '100', '0'),
('56670', '16', '1188.303', '-614.0296', '-121.8816', '0', '0', '0', '100', '0'),
('56670', '17', '1164.196', '-595.4036', '-115.7764', '0', '0', '0', '100', '0'),
('56670', '18', '1155.213', '-574.8707', '-113.3766', '0', '0', '0', '100', '0'),
('56670', '19', '1164.196', '-595.4036', '-115.7764', '0', '0', '0', '100', '0'),
('56670', '20', '1188.303', '-614.0296', '-121.8816', '0', '0', '0', '100', '0'),
('56670', '21', '1202.953', '-639.3985', '-126.1688', '0', '0', '0', '100', '0'),
('56670', '22', '1200.504', '-670.9343', '-128.5453', '0', '0', '0', '100', '0'),
('56670', '23', '1175.589', '-702.0806', '-130.9749', '0', '0', '0', '100', '0'),
('56670', '24', '1149.458', '-726.4506', '-133.8044', '0', '0', '0', '100', '0'),
('56670', '25', '1117.097', '-744.4790', '-145.6289', '0', '0', '0', '100', '0'),
('56670', '26', '1068.566', '-742.8318', '-151.7328', '0', '0', '0', '100', '0'),
('56670', '27', '1058.163', '-706.0782', '-156.6107', '0', '0', '0', '100', '0'),
('56670', '28', '1042.016', '-695.8206', '-163.7581', '0', '0', '0', '100', '0'),
('56670', '29', '1024.226', '-684.4753', '-173.2943', '0', '0', '0', '100', '0'),
('56670', '30', '1002.311', '-661.9902', '-194.1922', '0', '0', '0', '100', '0'),
('56670', '31', '975.1815', '-641.0467', '-201.5775', '0', '0', '0', '100', '0'),
('56670', '32', '936.2535', '-612.5002', '-203.6217', '0', '0', '0', '100', '0'),
('56670', '33', '899.6118', '-613.5433', '-202.2377', '0', '0', '0', '100', '0'),
('56670', '34', '856.4564', '-617.9056', '-202.1571', '0', '0', '0', '100', '0'),
('56670', '35', '831.3860', '-627.8932', '-203.1487', '0', '0', '0', '100', '0'),
('56670', '36', '816.5816', '-641.0675', '-203.8891', '0', '0', '0', '100', '0');

SET @GUID := '56671';
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
('56671', '01', '695.7981', '-526.2382', '-214.3069', '0', '0', '0', '100', '0'),
('56671', '02', '706.8069', '-515.2225', '-215.4603', '0', '0', '0', '100', '0'),
('56671', '03', '708.7521', '-494.4869', '-213.9441', '0', '0', '0', '100', '0'),
('56671', '04', '706.4074', '-474.3789', '-211.1673', '0', '0', '0', '100', '0'),
('56671', '05', '708.7521', '-494.4869', '-213.9441', '0', '0', '0', '100', '0'),
('56671', '06', '706.8069', '-515.2225', '-215.4603', '0', '0', '0', '100', '0'),
('56671', '07', '695.7981', '-526.2382', '-214.3069', '0', '0', '0', '100', '0'),
('56671', '08', '671.7322', '-532.8630', '-210.5322', '0', '0', '0', '100', '0');

SET @GUID := '56672';
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
('56672', '01', '694.3823', '-643.1285', '-209.7859', '0', '0', '0', '100', '0'),
('56672', '02', '691.9941', '-667.7454', '-209.6549', '0', '0', '0', '100', '0'),
('56672', '03', '712.6238', '-699.4688', '-209.7263', '0', '0', '0', '100', '0'),
('56672', '04', '696.8894', '-727.3798', '-209.4279', '0', '0', '0', '100', '0'),
('56672', '05', '672.7046', '-770.8894', '-209.0702', '0', '0', '0', '100', '0'),
('56672', '06', '696.8894', '-727.3798', '-209.4279', '0', '0', '0', '100', '0'),
('56672', '07', '712.6238', '-699.4688', '-209.7263', '0', '0', '0', '100', '0'),
('56672', '08', '691.9941', '-667.7454', '-209.6549', '0', '0', '0', '100', '0'),
('56672', '09', '694.3823', '-643.1285', '-209.7859', '0', '0', '0', '100', '0'),
('56672', '10', '694.3823', '-643.1285', '-209.7859', '0', '0', '0', '100', '0'),
('56672', '11', '706.5988', '-608.7560', '-209.7862', '0', '0', '0', '100', '0');

SET @GUID := '56673';
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
('56673', '01', '723.8314', '-518.3099', '-217.6104', '0', '0', '0', '100', '0'),
('56673', '02', '706.7125', '-535.8472', '-216.7189', '0', '0', '0', '100', '0'),
('56673', '03', '685.7861', '-543.6451', '-211.2004', '0', '0', '0', '100', '0'),
('56673', '04', '667.6307', '-538.1242', '-209.9916', '0', '0', '0', '100', '0'),
('56673', '05', '685.7861', '-543.6451', '-211.2004', '0', '0', '0', '100', '0'),
('56673', '06', '706.7125', '-535.8472', '-216.7189', '0', '0', '0', '100', '0'),
('56673', '07', '723.8314', '-518.3099', '-217.6104', '0', '0', '0', '100', '0'),
('56673', '08', '728.2719', '-487.4919', '-212.9500', '0', '0', '0', '100', '0');

SET @GUID := '56674';
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
('56674', '01', '693.7902', '-895.4052', '-199.3317', '0', '0', '0', '100', '0'),
('56674', '02', '676.3041', '-859.0721', '-207.3966', '0', '0', '0', '100', '0'),
('56674', '03', '660.5331', '-846.3304', '-208.5820', '0', '0', '0', '100', '0'),
('56674', '04', '676.3041', '-859.0721', '-207.3966', '0', '0', '0', '100', '0'),
('56674', '05', '693.7902', '-895.4052', '-199.3317', '0', '0', '0', '100', '0'),
('56674', '06', '709.7253', '-933.0809', '-191.2163', '0', '0', '0', '100', '0');

SET @GUID := '56675';
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
('56675', '01', '687.7936', '-1186.922', '-122.3323', '0', '0', '0', '100', '0'),
('56675', '02', '678.9120', '-1171.258', '-124.9925', '0', '0', '0', '100', '0'),
('56675', '03', '681.3560', '-1157.213', '-129.4221', '0', '0', '0', '100', '0'),
('56675', '04', '688.8096', '-1145.377', '-132.6487', '0', '0', '0', '100', '0'),
('56675', '05', '705.0751', '-1129.982', '-137.4043', '0', '0', '0', '100', '0'),
('56675', '06', '726.2703', '-1123.733', '-140.4308', '0', '0', '0', '100', '0'),
('56675', '07', '751.8342', '-1124.252', '-144.3583', '0', '0', '0', '100', '0'),
('56675', '08', '786.1231', '-1142.027', '-149.5751', '0', '0', '0', '100', '0'),
('56675', '09', '797.6674', '-1151.590', '-151.2095', '0', '0', '0', '100', '0'),
('56675', '10', '809.0994', '-1147.870', '-152.4792', '0', '0', '0', '100', '0'),
('56675', '11', '839.5970', '-1126.927', '-156.8890', '0', '0', '0', '100', '0'),
('56675', '12', '852.0717', '-1110.005', '-164.8026', '0', '0', '0', '100', '0'),
('56675', '13', '866.1934', '-1092.763', '-172.8487', '0', '0', '0', '100', '0'),
('56675', '14', '872.7313', '-1072.910', '-180.5435', '0', '0', '0', '100', '0'),
('56675', '15', '867.8922', '-1050.318', '-187.0417', '0', '0', '0', '100', '0'),
('56675', '16', '862.4832', '-1025.388', '-193.7729', '0', '0', '0', '100', '0'),
('56675', '17', '837.9779', '-1005.705', '-203.4326', '0', '0', '0', '100', '0'),
('56675', '18', '811.0497', '-995.4718', '-207.7699', '0', '0', '0', '100', '0'),
('56675', '19', '837.9779', '-1005.705', '-203.4326', '0', '0', '0', '100', '0'),
('56675', '20', '862.4832', '-1025.388', '-193.7729', '0', '0', '0', '100', '0'),
('56675', '21', '867.8922', '-1050.318', '-187.0417', '0', '0', '0', '100', '0'),
('56675', '22', '872.7313', '-1072.910', '-180.5435', '0', '0', '0', '100', '0'),
('56675', '23', '866.1934', '-1092.763', '-172.8487', '0', '0', '0', '100', '0'),
('56675', '24', '852.0717', '-1110.005', '-164.8026', '0', '0', '0', '100', '0'),
('56675', '25', '839.5970', '-1126.927', '-156.8890', '0', '0', '0', '100', '0'),
('56675', '26', '809.0994', '-1147.870', '-152.4792', '0', '0', '0', '100', '0'),
('56675', '27', '797.6674', '-1151.590', '-151.2095', '0', '0', '0', '100', '0'),
('56675', '28', '786.1231', '-1142.027', '-149.5751', '0', '0', '0', '100', '0'),
('56675', '29', '751.8342', '-1124.252', '-144.3583', '0', '0', '0', '100', '0'),
('56675', '30', '726.2703', '-1123.733', '-140.4308', '0', '0', '0', '100', '0'),
('56675', '31', '705.0751', '-1129.982', '-137.4043', '0', '0', '0', '100', '0'),
('56675', '32', '688.8096', '-1145.377', '-132.6487', '0', '0', '0', '100', '0'),
('56675', '33', '681.3560', '-1157.213', '-129.4221', '0', '0', '0', '100', '0'),
('56675', '34', '678.9120', '-1171.258', '-124.9925', '0', '0', '0', '100', '0'),
('56675', '35', '687.7820', '-1186.916', '-122.3317', '0', '0', '0', '100', '0'),
('56675', '36', '702.4774', '-1195.069', '-120.2255', '0', '0', '0', '100', '0');

SET @GUID := '56676';
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
('56676', '01', '568.2750', '-805.6725', '-206.7511', '0', '0', '0', '100', '0'),
('56676', '02', '571.1739', '-823.5732', '-206.9356', '0', '0', '0', '100', '0'),
('56676', '03', '580.7532', '-839.1719', '-206.0227', '0', '0', '0', '100', '0'),
('56676', '04', '606.3914', '-839.9142', '-207.4040', '0', '0', '0', '100', '0'),
('56676', '05', '640.3456', '-838.7157', '-208.4006', '0', '0', '0', '100', '0'),
('56676', '06', '606.3914', '-839.9142', '-207.4040', '0', '0', '0', '100', '0'),
('56676', '07', '580.7532', '-839.1719', '-206.0227', '0', '0', '0', '100', '0'),
('56676', '08', '571.1739', '-823.5732', '-206.9356', '0', '0', '0', '100', '0'),
('56676', '09', '568.2750', '-805.6725', '-206.7511', '0', '0', '0', '100', '0'),
('56676', '10', '574.7719', '-784.4373', '-207.1243', '0', '0', '0', '100', '0');

SET @GUID := '56742';
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
('56742', '01', '820.1378', '-991.0960', '-207.3450', '0', '0', '0', '100', '0'),
('56742', '02', '837.5117', '-1001.866', '-203.9284', '0', '0', '0', '100', '0'),
('56742', '03', '875.2714', '-1009.170', '-195.7951', '0', '0', '0', '100', '0'),
('56742', '04', '884.1406', '-1024.130', '-192.9333', '0', '0', '0', '100', '0'),
('56742', '05', '875.2714', '-1009.170', '-195.7951', '0', '0', '0', '100', '0'),
('56742', '06', '837.5117', '-1001.866', '-203.9284', '0', '0', '0', '100', '0'),
('56742', '07', '820.1378', '-991.0960', '-207.1345', '0', '0', '0', '100', '0'),
('56742', '08', '815.0589', '-979.8468', '-208.6176', '0', '0', '0', '100', '0');

SET @GUID := '56743';
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
('56743', '01', '619.3152', '-1131.169', '-201.6246', '0', '0', '0', '100', '0'),
('56743', '02', '635.5156', '-1094.704', '-196.7484', '0', '0', '0', '100', '0'),
('56743', '03', '637.1269', '-1060.913', '-199.2417', '0', '0', '0', '100', '0'),
('56743', '04', '635.5156', '-1094.704', '-196.7484', '0', '0', '0', '100', '0'),
('56743', '05', '619.3152', '-1131.169', '-201.6246', '0', '0', '0', '100', '0'),
('56743', '06', '610.0372', '-1155.730', '-198.8285', '0', '0', '0', '100', '0');

SET @GUID := '56744';
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
('56744', '01', '713.1385', '-1077.042', '-178.4627', '0', '0', '0', '100', '0'),
('56744', '02', '756.4903', '-1086.385', '-165.0273', '0', '0', '0', '100', '0'),
('56744', '03', '791.6740', '-1098.377', '-157.4893', '0', '0', '0', '100', '0'),
('56744', '04', '811.4623', '-1112.419', '-155.1721', '0', '0', '0', '100', '0'),
('56744', '05', '820.8864', '-1133.536', '-153.9561', '0', '0', '0', '100', '0'),
('56744', '06', '807.4134', '-1143.589', '-152.2109', '0', '0', '0', '100', '0'),
('56744', '07', '788.3813', '-1136.843', '-150.0572', '0', '0', '0', '100', '0'),
('56744', '08', '774.8284', '-1122.117', '-148.7992', '0', '0', '0', '100', '0'),
('56744', '09', '753.0598', '-1112.579', '-145.9724', '0', '0', '0', '100', '0'),
('56744', '10', '723.3937', '-1111.516', '-142.1575', '0', '0', '0', '100', '0'),
('56744', '11', '692.8207', '-1125.591', '-137.0500', '0', '0', '0', '100', '0'),
('56744', '12', '670.8020', '-1153.978', '-128.2815', '0', '0', '0', '100', '0'),
('56744', '13', '669.0090', '-1180.974', '-123.0805', '0', '0', '0', '100', '0'),
('56744', '14', '670.8020', '-1153.978', '-128.2815', '0', '0', '0', '100', '0'),
('56744', '15', '692.8207', '-1125.591', '-137.0500', '0', '0', '0', '100', '0'),
('56744', '16', '723.3937', '-1111.516', '-142.1575', '0', '0', '0', '100', '0'),
('56744', '17', '753.0598', '-1112.579', '-145.9724', '0', '0', '0', '100', '0'),
('56744', '18', '774.8284', '-1122.117', '-148.7992', '0', '0', '0', '100', '0'),
('56744', '19', '788.3813', '-1136.843', '-150.0572', '0', '0', '0', '100', '0'),
('56744', '20', '807.4134', '-1143.589', '-152.2109', '0', '0', '0', '100', '0'),
('56744', '21', '820.8864', '-1133.536', '-153.9561', '0', '0', '0', '100', '0'),
('56744', '22', '811.4623', '-1112.419', '-155.1721', '0', '0', '0', '100', '0'),
('56744', '23', '791.6740', '-1098.377', '-157.4893', '0', '0', '0', '100', '0'),
('56744', '24', '756.4903', '-1086.385', '-165.0273', '0', '0', '0', '100', '0'),
('56744', '25', '713.1385', '-1077.042', '-178.4627', '0', '0', '0', '100', '0'),
('56744', '26', '666.2255', '-1071.984', '-188.5744', '0', '0', '0', '100', '0');

SET @GUID := '56745';
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
('56745', '01', '733.2838', '-1027.083', '-177.5541', '0', '0', '0', '100', '0'),
('56745', '02', '695.6022', '-1035.410', '-182.9091', '0', '0', '0', '100', '0'),
('56745', '03', '652.9347', '-1047.064', '-195.1933', '0', '0', '0', '100', '0'),
('56745', '04', '695.6022', '-1035.410', '-182.9091', '0', '0', '0', '100', '0'),
('56745', '05', '733.2838', '-1027.083', '-177.5541', '0', '0', '0', '100', '0'),
('56745', '06', '746.1315', '-1006.086', '-177.4375', '0', '0', '0', '100', '0');

SET @GUID := '56746';
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
('56746', '01', '819.1058', '-631.4754', '-202.4386', '0', '0', '0', '100', '0'),
('56746', '02', '842.2988', '-620.2899', '-203.6502', '0', '0', '0', '100', '0'),
('56746', '03', '863.2007', '-606.6663', '-201.9657', '0', '0', '0', '100', '0'),
('56746', '04', '880.7169', '-589.9871', '-203.5187', '0', '0', '0', '100', '0'),
('56746', '05', '891.5865', '-563.1656', '-204.1768', '0', '0', '0', '100', '0'),
('56746', '06', '880.7169', '-589.9871', '-203.5187', '0', '0', '0', '100', '0'),
('56746', '07', '863.2007', '-606.6663', '-201.9657', '0', '0', '0', '100', '0'),
('56746', '08', '842.2988', '-620.2899', '-203.6502', '0', '0', '0', '100', '0'),
('56746', '09', '819.1058', '-631.4754', '-202.4386', '0', '0', '0', '100', '0'),
('56746', '10', '801.1528', '-637.2293', '-203.2919', '0', '0', '0', '100', '0');

-- -----------------------------------------------------------------------------------------------------------------------------

-- Lava Annihilator do not patrol through the Molten Core, only Lava Surgers do
UPDATE `creature` SET `MovementType`='1' WHERE `guid`='56789';
DELETE FROM `waypoint_data` WHERE `id`='56789';

-- the following creatures in Molten Core do fire damage with their melee attacks, not physical
-- (Ancient Core Hounds, Firelords, Lava Spawns, Firewalkers, Flameguards, Sons of Flame and Baron Geddon)
UPDATE `creature_template` SET `DmgSchool`='2' WHERE `Entry` IN ('11673', '11666', '11667', '11668', '12056', '12143', '12265');

-- the following creatures in Molten Core do not drop any loot, nor money when killed. You cannot skin them either.
-- (Flame Imp, Core Hound, Lava Spawn, Firesworn, Core Rager, Son of Flame)
UPDATE `creature_template` SET `lootId`='0', `skinloot`='0', `mingold`='0', `maxgold`='0' WHERE `entry` IN ('11669', '11671', '12265', '12099', '11672', '12143');
DELETE FROM `creature_loot_template` WHERE `entry` IN ('11669', '11671', '12265', '12099', '11672', '12143');

-- a go was missing as a template and object
DELETE FROM `gameobject_template` WHERE `entry`='178188';
INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `castBarCaption`, `faction`, `flags`, `size`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `ScriptName`) VALUES
('178188', '6', '410', 'Molten Core Circle BARON', '', '114', '0', '1', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');

DELETE FROM `gameobject` WHERE `guid`='113269';
INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
('113269', '178188', '409', '1', '748.839', '-985.16', '-178.283', '3.14159', '0', '0', '-1', '0', '604800', '255', '1');

UPDATE `gameobject_template` SET `flags`='16', `size`='1.03788' WHERE `entry`='176951'; -- 0 1
UPDATE `gameobject_template` SET `flags`='16', `size`='1.03788' WHERE `entry`='176952';
UPDATE `gameobject_template` SET `flags`='16', `size`='1.03788' WHERE `entry`='176953';
UPDATE `gameobject_template` SET `flags`='16', `size`='1.03788' WHERE `entry`='176954';