moonwell-core-vanilla/sql/migrations/20260417132047_world.sql

DROP PROCEDURE IF EXISTS add_migration;
DELIMITER ??
CREATE PROCEDURE `add_migration`()
BEGIN
DECLARE v INT DEFAULT 1;
SET v = (SELECT COUNT(*) FROM `migrations` WHERE `id`='20260417132047');
IF v = 0 THEN
INSERT INTO `migrations` VALUES ('20260417132047');
-- Add your query below.

SET @MOVID=18424;

DELETE FROM creature WHERE guid IN(@MOVID);
INSERT INTO creature(guid, id, map, position_x, position_y, position_z, orientation, spawntimesecsmin, spawntimesecsmax, patch_min, movement_type) VALUES
(@MOVID, '2529', '0', '-473', '1558.0508', '13.524624', '0.64330601692199710000', 600,600, '0', '2');
-- GUID: Full: 0x2051680000C660C000008C000062B526 Creature/0 R5210/S140 Map: 0 (Eastern Kingdoms) Entry: 203139 Low: 6468902
DELETE FROM creature_movement WHERE id=@MOVID;
INSERT INTO `creature_movement` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`waittime`,`wander_distance`,`script_id`) VALUES
(@MOVID, '1', '-473', '1558.0508', '13.524624', '100', '0', '0', 0),
(@MOVID, '2', '-500.6644', '1585.798', '6.9020357', '100', '0', '0', 0),
(@MOVID, '3', '-532.8958', '1596.0282', '12.427815', '100', '0', '0', 0),
(@MOVID, '4', '-556.03516', '1572.5029', '10.0294285', '100', '0', '0', 0),
(@MOVID, '5', '-558.04364', '1561.6035', '11.743525', '100', '180000', '20', 0),
(@MOVID, '6', '-558.04364', '1561.6035', '11.743525', '100', '0', '0', 0),
(@MOVID, '7', '-600.9427', '1554.2798', '9.5067005', '100', '0', '0', 0),
(@MOVID, '8', '-622.7307', '1532.5443', '8.503947', '100', '0', '0', 0),
(@MOVID, '9', '-656.38153', '1541.2762', '7.586202', '100', '0', '0', 0),
(@MOVID, '10', '-661.77625', '1504.4967', '6.914252', '100', '0', '0', 0),
(@MOVID, '11', '-677.72614', '1469.8853', '7.4564323', '100', '0', '0', 0),
(@MOVID, '12', '-688.5089', '1454.284', '8.085931', '100', '0', '0', 0),
(@MOVID, '13', '-701.90753', '1422.7462', '18.019627', '100', '0', '0', 0),
(@MOVID, '14', '-693.0762', '1385.7852', '27.65606', '100', '0', '0', 0),
(@MOVID, '15', '-673.63715', '1357.5747', '35.163174', '100', '180000', '20', 0),
(@MOVID, '16', '-673.628', '1357.61', '35.1483', '100', '0', '0', 0),
(@MOVID, '17', '-660.1053', '1347.7445', '40.327103', '100', '0', '0', 0),
(@MOVID, '18', '-642.05884', '1353.7219', '37.336838', '100', '0', '0', 0),
(@MOVID, '19', '-613.08636', '1347.4244', '38.670486', '100', '0', '0', 0),
(@MOVID, '20', '-580.21985', '1362.6948', '34.067593', '100', '0', '0', 0),
(@MOVID, '21', '-552.3301', '1341.5381', '43.388885', '100', '0', '0', 0),
(@MOVID, '22', '-535.9881', '1304.3522', '51.199306', '100', '0', '0', 0),
(@MOVID, '23', '-516.4323', '1283.505', '53.748093', '100', '0', '0', 0),
(@MOVID, '24', '-482.43665', '1266.9377', '46.372887', '100', '0', '0', 0),
(@MOVID, '25', '-466.4885', '1233.1261', '49.984905', '100', '180000', '20', 0),
(@MOVID, '26', '-466.638', '1233.08', '50.0183', '100', '0', '0', 0),
(@MOVID, '27', '-447.5715', '1257.7725', '43.732544', '100', '0', '0', 0),
(@MOVID, '28', '-418.52008', '1272.2435', '42.2404', '100', '0', '0', 0),
(@MOVID, '29', '-409.4146', '1303.709', '40.407135', '100', '0', '0', 0),
(@MOVID, '30', '-402.42307', '1320.8809', '36.276363', '100', '0', '0', 0),
(@MOVID, '31', '-434.954', '1338.5426', '36.10988', '100', '0', '0', 0),
(@MOVID, '32', '-445.8688', '1363.5131', '37.097183', '100', '0', '0', 0),
(@MOVID, '33', '-444.2958', '1394.7983', '33.252625', '100', '0', '0', 0),
(@MOVID, '34', '-442.64508', '1433.3741', '27.777325', '100', '0', '0', 0),
(@MOVID, '35', '-474.75217', '1447.3195', '23.67008', '100', '0', '0', 0),
(@MOVID, '36', '-502.86035', '1462.4423', '20.325428', '100', '0', '0', 0),
(@MOVID, '37', '-478.02637', '1494.0829', '19.245865', '100', '0', '0', 0),
(@MOVID, '38', '-464.99197', '1534.3695', '17.709898', '100', '0', '0', 0);

DELETE FROM creature WHERE guid=11231; -- one buzzard that is meant to not exist

SET @MOVID=22680;
DELETE FROM creature WHERE guid IN(@MOVID);
INSERT INTO creature(guid, id, map, position_x, position_y, position_z, orientation, spawntimesecsmin, spawntimesecsmax, patch_min, movement_type) VALUES
(@MOVID, '5428', '1', '-7387.1', '-3773.1172', '12.04591', '0.64330601692199710000', 300,300, '0', '2');
-- GUID: Full: 0x2056600020054D000001050000F7F49B Creature/0 R5528/S261 Map: 1 (Kalimdor) Entry: 5428 (Roc) Low: 16250011
DELETE FROM creature_movement WHERE id=@MOVID;
INSERT INTO `creature_movement` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`waittime`,`wander_distance`,`script_id`) VALUES
(@MOVID, '1', '-7387.1', '-3773.1172', '12.04591', '100', '0', '0', 0),
(@MOVID, '2', '-7406.5444', '-3786.1711', '11.423206', '100', '0', '0', 0),
(@MOVID, '3', '-7407.5747', '-3803.3352', '9.708907', '100', '0', '0', 0),
(@MOVID, '4', '-7406.5444', '-3786.1711', '11.423206', '100', '0', '0', 0),
(@MOVID, '5', '-7387.1', '-3773.1172', '12.04591', '100', '0', '0', 0),
(@MOVID, '6', '-7370.269', '-3751.0017', '13.24679', '100', '0', '0', 0),
(@MOVID, '7', '-7361.1157', '-3719.1868', '9.518707', '100', '0', '0', 0),
(@MOVID, '8', '-7348.7944', '-3693.067', '9.761106', '100', '0', '0', 0),
(@MOVID, '9', '-7317.133', '-3672.1238', '9.528673', '100', '0', '0', 0),
(@MOVID, '10', '-7309.9062', '-3650.1306', '11.538431', '100', '0', '0', 0),
(@MOVID, '11', '-7278.7515', '-3640.583', '13.187931', '100', '0', '0', 0),
(@MOVID, '12', '-7250.54', '-3623.284', '13.235052', '100', '0', '0', 0),
(@MOVID, '13', '-7220.8545', '-3588.4766', '11.981008', '100', '0', '0', 0),
(@MOVID, '14', '-7185.065', '-3576.2393', '10.565277', '100', '0', '0', 0),
(@MOVID, '15', '-7220.8545', '-3588.4766', '11.981008', '100', '0', '0', 0),
(@MOVID, '16', '-7250.54', '-3623.284', '13.235052', '100', '0', '0', 0),
(@MOVID, '17', '-7278.6426', '-3640.5566', '13.172449', '100', '0', '0', 0),
(@MOVID, '18', '-7309.9062', '-3650.1306', '11.538431', '100', '0', '0', 0),
(@MOVID, '19', '-7317.133', '-3672.1238', '9.528673', '100', '0', '0', 0),
(@MOVID, '20', '-7348.7944', '-3693.067', '9.761106', '100', '0', '0', 0),
(@MOVID, '21', '-7361.1157', '-3719.1868', '9.518707', '100', '0', '0', 0),
(@MOVID, '22', '-7370.269', '-3751.0017', '13.24679', '100', '0', '0', 0),
(@MOVID, '23', '-7387.1', '-3773.1172', '12.04591', '100', '0', '0', 0),
(@MOVID, '24', '-7406.5444', '-3786.1711', '11.423206', '100', '0', '0', 0),
(@MOVID, '25', '-7407.5747', '-3803.3352', '9.708907', '100', '0', '0', 0),
(@MOVID, '26', '-7406.5444', '-3786.1711', '11.423206', '100', '0', '0', 0);

SET @MOVID=22667;
DELETE FROM creature WHERE guid IN(@MOVID);
INSERT INTO creature(guid, id, map, position_x, position_y, position_z, orientation, spawntimesecsmin, spawntimesecsmax, patch_min, movement_type) VALUES
(@MOVID, '5428', '1', '-7184.2744', '-3311.63', '12.19182', '0.64330601692199710000', 300,300, '0', '2');
-- GUID: Full: 0x2056600020054D000001050001F7F49A Creature/0 R5528/S261 Map: 1 (Kalimdor) Entry: 5428 (Roc) Low: 33027226
DELETE FROM creature_movement WHERE id=@MOVID;
INSERT INTO `creature_movement` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`waittime`,`wander_distance`,`script_id`) VALUES
(@MOVID, '1', '-7184.2744', '-3311.63', '12.19182', '100', '0', '0', 0), -- PathType: None
(@MOVID, '2', '-7211.8105', '-3321.1782', '10.191605', '100', '0', '0', 0),
(@MOVID, '3', '-7226.5327', '-3346.8816', '9.789747', '100', '0', '0', 0),
(@MOVID, '4', '-7208.7085', '-3382.9377', '11.065386', '100', '0', '0', 0),
(@MOVID, '5', '-7178.9663', '-3392.1038', '9.823953', '100', '0', '0', 0),
(@MOVID, '6', '-7150.633', '-3416.7332', '10.020199', '100', '0', '0', 0),
(@MOVID, '7', '-7121.0137', '-3388.6099', '9.412542', '100', '0', '0', 0),
(@MOVID, '8', '-7077.483', '-3408.5852', '9.793778', '100', '0', '0', 0),
(@MOVID, '9', '-7054.3184', '-3398.4714', '10.6434555', '100', '0', '0', 0),
(@MOVID, '10', '-7019.4204', '-3417.0256', '10.772627', '100', '0', '0', 0),
(@MOVID, '11', '-6986.104', '-3377.9016', '10.650049', '100', '0', '0', 0),
(@MOVID, '12', '-6985.291', '-3354.7832', '10.487227', '100', '0', '0', 0),
(@MOVID, '13', '-6990.272', '-3320.4727', '9.591789', '100', '0', '0', 0),
(@MOVID, '14', '-7015.557', '-3307.6372', '10.032867', '100', '0', '0', 0),
(@MOVID, '15', '-7043.686', '-3287.558', '10.240731', '100', '0', '0', 0),
(@MOVID, '16', '-7076.933', '-3281.6892', '10.547073', '100', '0', '0', 0),
(@MOVID, '17', '-7115.6694', '-3274.6428', '10.917534', '100', '0', '0', 0),
(@MOVID, '18', '-7124.549', '-3252.519', '9.43861', '100', '0', '0', 0),
(@MOVID, '19', '-7126.523', '-3215.5051', '10.634663', '100', '0', '0', 0),
(@MOVID, '20', '-7154.304', '-3214.0051', '12.818225', '100', '0', '0', 0),
(@MOVID, '21', '-7180.481', '-3246.141', '9.425887', '100', '0', '0', 0),
(@MOVID, '22', '-7178.461', '-3276.554', '13.005114', '100', '0', '0', 0);

SET @MOVID=22666;
DELETE FROM creature WHERE guid IN(@MOVID);
INSERT INTO creature(guid, id, map, position_x, position_y, position_z, orientation, spawntimesecsmin, spawntimesecsmax, patch_min, movement_type) VALUES
(@MOVID, '5428', '1', '-7025.848', '-2617.3013', '9.18687', '0.64330601692199710000', 300,300, '0', '2');
-- GUID: Full: 0x2056600020054D00000105000077F49C Creature/0 R5528/S261 Map: 1 (Kalimdor) Entry: 5428 (Roc) Low: 7861404
DELETE FROM creature_movement WHERE id=@MOVID;
INSERT INTO `creature_movement` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`waittime`,`wander_distance`,`script_id`) VALUES
(@MOVID, '1', '-7025.848', '-2617.3013', '9.18687', '100', '0', '0', 0),
(@MOVID, '2', '-7046.2026', '-2629.8564', '11.485161', '100', '0', '0', 0),
(@MOVID, '3', '-7081.517', '-2623.7976', '12.057159', '100', '0', '0', 0),
(@MOVID, '4', '-7115.286', '-2624.1785', '9.475137', '100', '0', '0', 0),
(@MOVID, '5', '-7161.3726', '-2623.5164', '8.91308', '100', '0', '0', 0),
(@MOVID, '6', '-7181.1753', '-2648.3855', '11.070356', '100', '0', '0', 0),
(@MOVID, '7', '-7221.9214', '-2657.2302', '9.350472', '100', '0', '0', 0),
(@MOVID, '8', '-7249.3926', '-2653.4805', '12.057508', '100', '0', '0', 0),
(@MOVID, '9', '-7287.0625', '-2654.247', '12.61699', '100', '0', '0', 0),
(@MOVID, '10', '-7315.012', '-2650.2532', '9.428289', '100', '0', '0', 0),
(@MOVID, '11', '-7344.604', '-2623.2935', '8.930923', '100', '0', '0', 0),
(@MOVID, '12', '-7370.4707', '-2649.245', '9.266818', '100', '0', '0', 0),
(@MOVID, '13', '-7385.4497', '-2678.6228', '11.97481', '100', '0', '0', 0),
(@MOVID, '14', '-7386.553', '-2709.8096', '9.981623', '100', '0', '0', 0),
(@MOVID, '15', '-7385.4497', '-2678.6228', '11.97481', '100', '0', '0', 0),
(@MOVID, '16', '-7370.4707', '-2649.245', '9.266818', '100', '0', '0', 0),
(@MOVID, '17', '-7344.604', '-2623.2935', '8.930923', '100', '0', '0', 0),
(@MOVID, '18', '-7315.012', '-2650.2532', '9.428289', '100', '0', '0', 0),
(@MOVID, '19', '-7287.0625', '-2654.247', '12.61699', '100', '0', '0', 0),
(@MOVID, '20', '-7249.3926', '-2653.4805', '12.057508', '100', '0', '0', 0),
(@MOVID, '21', '-7221.9214', '-2657.2302', '9.350472', '100', '0', '0', 0),
(@MOVID, '22', '-7181.1753', '-2648.3855', '11.070356', '100', '0', '0', 0),
(@MOVID, '23', '-7161.3726', '-2623.5164', '8.91308', '100', '0', '0', 0),
(@MOVID, '24', '-7115.286', '-2624.1785', '9.475137', '100', '0', '0', 0),
(@MOVID, '25', '-7081.517', '-2623.7976', '12.057159', '100', '0', '0', 0),
(@MOVID, '26', '-7046.2026', '-2629.8564', '11.485161', '100', '0', '0', 0);

SET @MOVID=22668;
DELETE FROM creature WHERE guid IN(@MOVID);
INSERT INTO creature(guid, id, map, position_x, position_y, position_z, orientation, spawntimesecsmin, spawntimesecsmax, patch_min, movement_type) VALUES
(@MOVID, '5428', '1', '-7081.444', '-4223.8047', '11.842286', '0.64330601692199710000', 300,300, '0', '2');
-- GUID: Full: 0x2056600020054D00000105000077F49A Creature/0 R5528/S261 Map: 1 (Kalimdor) Entry: 5428 (Roc) Low: 7861402
DELETE FROM creature_movement WHERE id=@MOVID;
INSERT INTO `creature_movement` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`waittime`,`wander_distance`,`script_id`) VALUES
(@MOVID, '1', '-7088.835', '-4260.1445', '8.954341', '100', '0', '0', 0),
(@MOVID, '2', '-7081.444', '-4223.8047', '11.842286', '100', '0', '0', 0),
(@MOVID, '3', '-7054.365', '-4207.793', '12.516409', '100', '0', '0', 0),
(@MOVID, '4', '-7044.617', '-4184.8447', '8.998918', '100', '0', '0', 0),
(@MOVID, '5', '-7024.5703', '-4159.1147', '11.400568', '100', '0', '0', 0),
(@MOVID, '6', '-7021.3135', '-4125.2534', '12.537271', '100', '0', '0', 0),
(@MOVID, '7', '-7039.932', '-4095.4019', '8.98558', '100', '0', '0', 0),
(@MOVID, '8', '-7054.0635', '-4056.5222', '10.282743', '100', '0', '0', 0),
(@MOVID, '9', '-7038.6934', '-4030.467', '10.577459', '100', '0', '0', 0),
(@MOVID, '10', '-7046.536', '-3996.7708', '10.088264', '100', '0', '0', 0),
(@MOVID, '11', '-7060.452', '-3967.2864', '11.86426', '100', '0', '0', 0),
(@MOVID, '12', '-7046.536', '-3996.7708', '10.088264', '100', '0', '0', 0),
(@MOVID, '13', '-7038.6934', '-4030.467', '10.577459', '100', '0', '0', 0),
(@MOVID, '14', '-7054.0635', '-4056.5222', '10.282743', '100', '0', '0', 0),
(@MOVID, '15', '-7039.932', '-4095.4019', '8.98558', '100', '0', '0', 0),
(@MOVID, '16', '-7021.3135', '-4125.2534', '12.537271', '100', '0', '0', 0),
(@MOVID, '17', '-7024.5703', '-4159.1147', '11.400568', '100', '0', '0', 0),
(@MOVID, '18', '-7044.617', '-4184.8447', '8.998918', '100', '0', '0', 0),
(@MOVID, '19', '-7054.365', '-4207.793', '12.516409', '100', '0', '0', 0),
(@MOVID, '20', '-7081.444', '-4223.8047', '11.842286', '100', '0', '0', 0);

SET @MOVID=22669;
DELETE FROM creature WHERE guid IN(@MOVID);
INSERT INTO creature(guid, id, map, position_x, position_y, position_z, orientation, spawntimesecsmin, spawntimesecsmax, patch_min, movement_type) VALUES
(@MOVID, '9396', '1', '-7240.4204', '-3682.967', '9.013495', '0.64330601692199710000', 300,300, '0', '2');
-- GUID: Full: 0x2056600020092D00000105000077F49B Creature/0 R5528/S261 Map: 1 (Kalimdor) Entry: 9396 (Ground Pounder) Low: 7861403
DELETE FROM creature_movement WHERE id=@MOVID;
INSERT INTO `creature_movement` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`waittime`,`wander_distance`,`script_id`) VALUES
(@MOVID, '1', '-7240.4204', '-3682.967', '9.013495', '100', '0', '0', 0),
(@MOVID, '2', '-7253.4478', '-3709.692', '8.964279', '100', '0', '0', 0),
(@MOVID, '3', '-7284.546', '-3739.3315', '9.419744', '100', '0', '0', 0),
(@MOVID, '4', '-7319.108', '-3770.0344', '10.171879', '100', '0', '0', 0),
(@MOVID, '5', '-7347.2354', '-3788.4329', '10.725712', '100', '0', '0', 0),
(@MOVID, '6', '-7348.5347', '-3818.0793', '9.935003', '100', '0', '0', 0),
(@MOVID, '7', '-7376.904', '-3823.976', '12.469669', '100', '0', '0', 0),
(@MOVID, '8', '-7409.8647', '-3811.4626', '9.240334', '100', '0', '0', 0),
(@MOVID, '9', '-7416.8457', '-3780.515', '11.746023', '100', '0', '0', 0),
(@MOVID, '10', '-7445.2734', '-3768.5261', '9.833389', '100', '0', '0', 0),
(@MOVID, '11', '-7447.014', '-3718.0747', '11.071255', '100', '0', '0', 0),
(@MOVID, '12', '-7418.5923', '-3707.1116', '10.021309', '100', '0', '0', 0),
(@MOVID, '13', '-7410.1216', '-3685.5234', '9.674198', '100', '0', '0', 0),
(@MOVID, '14', '-7383.596', '-3653.5903', '9.857218', '100', '0', '0', 0),
(@MOVID, '15', '-7359.7725', '-3643.0686', '11.36433', '100', '0', '0', 0),
(@MOVID, '16', '-7355.8926', '-3619.0813', '8.900633', '100', '0', '0', 0),
(@MOVID, '17', '-7344.1406', '-3584.9324', '9.762451', '100', '0', '0', 0),
(@MOVID, '18', '-7315.205', '-3573.7083', '12.024132', '100', '0', '0', 0),
(@MOVID, '19', '-7292.8804', '-3544.4783', '8.8849', '100', '0', '0', 0),
(@MOVID, '20', '-7274.6904', '-3519.0708', '12.376444', '100', '0', '0', 0),
(@MOVID, '21', '-7246.2305', '-3543.013', '13.591355', '100', '0', '0', 0),
(@MOVID, '22', '-7254.1885', '-3579.3176', '9.374146', '100', '0', '0', 0),
(@MOVID, '23', '-7279.906', '-3618.511', '14.409918', '100', '0', '0', 0),
(@MOVID, '24', '-7257.3447', '-3640.0083', '11.586905', '100', '0', '0', 0);

SET @MOVID=3505;
DELETE FROM creature WHERE guid IN(@MOVID);
INSERT INTO creature(guid, id, map, position_x, position_y, position_z, orientation, spawntimesecsmin, spawntimesecsmax, patch_min, movement_type) VALUES
(@MOVID, '9396', '1', '-7235.351', '-3648.573', '12.10585', '0.64330601692199710000', 300,300, '0', '2');
-- GUID: Full: 0x2056600020092D000001050000F7F49B Creature/0 R5528/S261 Map: 1 (Kalimdor) Entry: 9396 (Ground Pounder) Low: 16250011
DELETE FROM creature_movement WHERE id=@MOVID;
INSERT INTO `creature_movement` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`waittime`,`wander_distance`,`script_id`) VALUES
(@MOVID, '1', '-7235.351', '-3648.573', '12.10585', '100', '0', '0', 0),
(@MOVID, '2', '-7211.861', '-3656.9001', '10.38715', '100', '0', '0', 0),
(@MOVID, '3', '-7174.4907', '-3633.52', '11.189922', '100', '0', '0', 0),
(@MOVID, '4', '-7173.748', '-3609.1091', '12.445123', '100', '0', '0', 0),
(@MOVID, '5', '-7145.9688', '-3605.3135', '8.458687', '100', '0', '0', 0),
(@MOVID, '6', '-7111.7417', '-3617.9343', '8.8391905', '100', '0', '0', 0),
(@MOVID, '7', '-7083.653', '-3612.7559', '9.328943', '100', '0', '0', 0),
(@MOVID, '8', '-7048.9663', '-3582.2554', '10.507117', '100', '0', '0', 0),
(@MOVID, '9', '-7025.3345', '-3545.6697', '9.83424', '100', '0', '0', 0),
(@MOVID, '10', '-7029.456', '-3496.0598', '9.048929', '100', '0', '0', 0),
(@MOVID, '11', '-7063.094', '-3493.1284', '9.271378', '100', '0', '0', 0),
(@MOVID, '12', '-7108.8984', '-3508.2527', '10.993937', '100', '0', '0', 0),
(@MOVID, '13', '-7142.903', '-3489.6033', '9.562901', '100', '0', '0', 0),
(@MOVID, '14', '-7156.5034', '-3515.9434', '10.692659', '100', '0', '0', 0),
(@MOVID, '15', '-7180.929', '-3522.4033', '12.284992', '100', '0', '0', 0),
(@MOVID, '16', '-7218.0845', '-3523.847', '10.755602', '100', '0', '0', 0),
(@MOVID, '17', '-7221.0146', '-3553.681', '12.771082', '100', '0', '0', 0),
(@MOVID, '18', '-7230.2812', '-3584.0662', '11.255928', '100', '0', '0', 0),
(@MOVID, '19', '-7250.774', '-3601.6409', '10.412344', '100', '0', '0', 0),
(@MOVID, '20', '-7254.5864', '-3627.5168', '13.308292', '100', '0', '0', 0);

SET @MOVID=3506;
DELETE FROM creature WHERE guid IN(@MOVID);
INSERT INTO creature(guid, id, map, position_x, position_y, position_z, orientation, spawntimesecsmin, spawntimesecsmax, patch_min, movement_type) VALUES
(@MOVID, '9396', '1', '-7225.5503', '-3217.7197', '10.263059', '0.64330601692199710000', 300,300, '0', '2');
-- GUID: Full: 0x2056600020092D00000105000077F49C Creature/0 R5528/S261 Map: 1 (Kalimdor) Entry: 9396 (Ground Pounder) Low: 7861404
DELETE FROM creature_movement WHERE id=@MOVID;
INSERT INTO `creature_movement` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`waittime`,`wander_distance`,`script_id`) VALUES
(@MOVID, '1', '-7225.5503', '-3217.7197', '10.263059', '100', '0', '0', 0),
(@MOVID, '2', '-7215.1797', '-3190.4834', '12.343768', '100', '0', '0', 0),
(@MOVID, '3', '-7186.5957', '-3190.2397', '12.595035', '100', '0', '0', 0),
(@MOVID, '4', '-7150.415', '-3182.0115', '9.541996', '100', '0', '0', 0),
(@MOVID, '5', '-7137.709', '-3159.1047', '10.889271', '100', '0', '0', 0),
(@MOVID, '6', '-7116.2627', '-3143.5618', '8.897779', '100', '0', '0', 0),
(@MOVID, '7', '-7090.1387', '-3115.9531', '12.951361', '100', '0', '0', 0),
(@MOVID, '8', '-7077.7217', '-3089.871', '10.013893', '100', '0', '0', 0),
(@MOVID, '9', '-7055.6777', '-3073.9822', '13.436652', '100', '0', '0', 0),
(@MOVID, '10', '-7048.729', '-3058.256', '12.254861', '100', '0', '0', 0),
(@MOVID, '11', '-7020.4116', '-3041.5745', '10.951464', '100', '0', '0', 0),
(@MOVID, '12', '-7014.745', '-3017.0034', '11.76624', '100', '0', '0', 0),
(@MOVID, '13', '-6986.1143', '-2979.5796', '10.273038', '100', '0', '0', 0),
(@MOVID, '14', '-7014.745', '-3017.0034', '11.76624', '100', '0', '0', 0),
(@MOVID, '15', '-7020.4116', '-3041.5745', '10.951464', '100', '0', '0', 0),
(@MOVID, '16', '-7048.729', '-3058.256', '12.254861', '100', '0', '0', 0),
(@MOVID, '17', '-7055.6777', '-3073.9822', '13.436652', '100', '0', '0', 0),
(@MOVID, '18', '-7077.7217', '-3089.871', '10.013893', '100', '0', '0', 0),
(@MOVID, '19', '-7090.1387', '-3115.9531', '12.951361', '100', '0', '0', 0),
(@MOVID, '20', '-7116.2627', '-3143.5618', '8.897779', '100', '0', '0', 0),
(@MOVID, '21', '-7137.709', '-3159.1047', '10.889271', '100', '0', '0', 0),
(@MOVID, '22', '-7150.415', '-3182.0115', '9.541996', '100', '0', '0', 0),
(@MOVID, '23', '-7186.5957', '-3190.2397', '12.595035', '100', '0', '0', 0),
(@MOVID, '24', '-7215.1797', '-3190.4834', '12.343768', '100', '0', '0', 0);

SET @MOVID=3507;
DELETE FROM creature WHERE guid IN(@MOVID);
INSERT INTO creature(guid, id, map, position_x, position_y, position_z, orientation, spawntimesecsmin, spawntimesecsmax, patch_min, movement_type) VALUES
(@MOVID, '9396', '1', '-7302.482', '-3163.5872', '8.984701', '0.64330601692199710000', 300,300, '0', '2');
-- GUID: Full: 0x2056600020092D00000105000077F499 Creature/0 R5528/S261 Map: 1 (Kalimdor) Entry: 9396 (Ground Pounder) Low: 7861401
DELETE FROM creature_movement WHERE id=@MOVID;
INSERT INTO `creature_movement` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`waittime`,`wander_distance`,`script_id`) VALUES
(@MOVID, '1', '-7302.482', '-3163.5872', '8.984701', '100', '0', '0', 0),
(@MOVID, '2', '-7311.257', '-3141.7483', '10.435476', '100', '0', '0', 0),
(@MOVID, '3', '-7338.0435', '-3129.677', '13.607356', '100', '0', '0', 0),
(@MOVID, '4', '-7360.9253', '-3108.5642', '12.765121', '100', '0', '0', 0),
(@MOVID, '5', '-7378.377', '-3089.7444', '12.544108', '100', '0', '0', 0),
(@MOVID, '6', '-7390.6016', '-3060.8357', '12.062119', '100', '0', '0', 0),
(@MOVID, '7', '-7396.637', '-3018.9993', '10.049528', '100', '0', '0', 0),
(@MOVID, '8', '-7386.8438', '-2984.9036', '9.258846', '100', '0', '0', 0),
(@MOVID, '9', '-7407.561', '-2952.9878', '11.521268', '100', '0', '0', 0),
(@MOVID, '10', '-7388.8223', '-2916.5527', '9.123629', '100', '0', '0', 0),
(@MOVID, '11', '-7388.988', '-2886.9592', '8.795478', '100', '0', '0', 0),
(@MOVID, '12', '-7388.936', '-2855.361', '9.522631', '100', '0', '0', 0),
(@MOVID, '13', '-7356.1025', '-2817.9954', '10.210322', '100', '0', '0', 0),
(@MOVID, '14', '-7346.9785', '-2781.001', '11.907675', '100', '0', '0', 0),
(@MOVID, '15', '-7320.474', '-2783.448', '13.419694', '100', '0', '0', 0),
(@MOVID, '16', '-7346.9785', '-2781.001', '11.907675', '100', '0', '0', 0),
(@MOVID, '17', '-7356.1025', '-2817.9954', '10.210322', '100', '0', '0', 0),
(@MOVID, '18', '-7388.936', '-2855.361', '9.522631', '100', '0', '0', 0),
(@MOVID, '19', '-7388.988', '-2886.9592', '8.795478', '100', '0', '0', 0),
(@MOVID, '20', '-7388.8223', '-2916.5527', '9.123629', '100', '0', '0', 0),
(@MOVID, '21', '-7407.561', '-2952.9878', '11.521268', '100', '0', '0', 0),
(@MOVID, '22', '-7386.8438', '-2984.9036', '9.258846', '100', '0', '0', 0),
(@MOVID, '23', '-7396.637', '-3018.9993', '10.049528', '100', '0', '0', 0),
(@MOVID, '24', '-7390.6016', '-3060.8357', '12.062119', '100', '0', '0', 0),
(@MOVID, '25', '-7378.377', '-3089.7444', '12.544108', '100', '0', '0', 0),
(@MOVID, '26', '-7360.9253', '-3108.5642', '12.765121', '100', '0', '0', 0),
(@MOVID, '27', '-7338.0435', '-3129.677', '13.607356', '100', '0', '0', 0),
(@MOVID, '28', '-7311.257', '-3141.7483', '10.435476', '100', '0', '0', 0);

SET @MOVID=22695;
DELETE FROM creature WHERE guid IN(@MOVID);
INSERT INTO creature(guid, id, map, position_x, position_y, position_z, orientation, spawntimesecsmin, spawntimesecsmax, patch_min, movement_type) VALUES
(@MOVID, '5429', '1', '-7320.441', '-3388.358', '9.758868', '0.64330601692199710000', 300,300, '0', '2');
-- GUID: Full: 0x2056600020054D40000105000177F49A Creature/0 R5528/S261 Map: 1 (Kalimdor) Entry: 5429 (Fire Roc) Low: 24638618
DELETE FROM creature_movement WHERE id=@MOVID;
INSERT INTO `creature_movement` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`waittime`,`wander_distance`,`script_id`) VALUES
(@MOVID, '1', '-7320.441', '-3388.358', '9.758868', '100', '0', '0', 0),
(@MOVID, '2', '-7353.54', '-3423.973', '15.354742', '100', '0', '0', 0),
(@MOVID, '3', '-7391.6606', '-3415.9504', '15.477836', '100', '0', '0', 0),
(@MOVID, '4', '-7411.771', '-3407.497', '12.538029', '100', '0', '0', 0),
(@MOVID, '5', '-7419.4487', '-3383.1072', '12.251552', '100', '0', '0', 0),
(@MOVID, '6', '-7420.3516', '-3342.086', '10.829481', '100', '0', '0', 0),
(@MOVID, '7', '-7447.307', '-3342.2615', '13.415585', '100', '0', '0', 0),
(@MOVID, '8', '-7457.7134', '-3307.2866', '13.519792', '100', '0', '0', 0),
(@MOVID, '9', '-7480.903', '-3275.7283', '13.705877', '100', '0', '0', 0),
(@MOVID, '10', '-7512.5063', '-3239.2527', '24.00164', '100', '0', '0', 0),
(@MOVID, '11', '-7506.762', '-3215.4072', '22.58259', '100', '0', '0', 0),
(@MOVID, '12', '-7514.6816', '-3176.809', '21.612638', '100', '0', '0', 0),
(@MOVID, '13', '-7550.2666', '-3151.8413', '26.774387', '100', '0', '0', 0),
(@MOVID, '14', '-7544.4688', '-3105.727', '16.803328', '100', '0', '0', 0),
(@MOVID, '15', '-7550.4375', '-3074.6306', '14.295293', '100', '0', '0', 0),
(@MOVID, '16', '-7551.849', '-3037.6326', '11.262346', '100', '0', '0', 0),
(@MOVID, '17', '-7535.721', '-3007.8948', '12.105954', '100', '0', '0', 0),
(@MOVID, '18', '-7511.637', '-3004.5496', '9.849523', '100', '0', '0', 0),
(@MOVID, '19', '-7488.127', '-3053.2214', '8.748025', '100', '0', '0', 0),
(@MOVID, '20', '-7481.777', '-3089.0386', '13.650761', '100', '0', '0', 0),
(@MOVID, '21', '-7472.7603', '-3122.591', '14.077951', '100', '0', '0', 0),
(@MOVID, '22', '-7444.099', '-3127.7153', '14.636772', '100', '0', '0', 0),
(@MOVID, '23', '-7413.5806', '-3153.7617', '11.12199', '100', '0', '0', 0),
(@MOVID, '24', '-7416.0522', '-3199.0706', '9.137522', '100', '0', '0', 0),
(@MOVID, '25', '-7414.557', '-3226.445', '11.791044', '100', '0', '0', 0),
(@MOVID, '26', '-7381.932', '-3256.7747', '12.179886', '100', '0', '0', 0),
(@MOVID, '27', '-7352.027', '-3292.9111', '11.499931', '100', '0', '0', 0),
(@MOVID, '28', '-7350.0225', '-3326.0679', '9.786516', '100', '0', '0', 0),
(@MOVID, '29', '-7348.561', '-3366.2917', '9.789282', '100', '0', '0', 0);

SET @MOVID=22687;
DELETE FROM creature WHERE guid IN(@MOVID);
INSERT INTO creature(guid, id, map, position_x, position_y, position_z, orientation, spawntimesecsmin, spawntimesecsmax, patch_min, movement_type) VALUES
(@MOVID, '5429', '1', '-7523.1016', '-2673.9653', '8.876763', '0.64330601692199710000', 300,300, '0', '2');
-- GUID: Full: 0x2056600020054D400001050000F7F49A Creature/0 R5528/S261 Map: 1 (Kalimdor) Entry: 5429 (Fire Roc) Low: 16250010
DELETE FROM creature_movement WHERE id=@MOVID;
INSERT INTO `creature_movement` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`waittime`,`wander_distance`,`script_id`) VALUES
(@MOVID, '1', '-7523.1016', '-2673.9653', '8.876763', '100', '0', '0', 0),
(@MOVID, '2', '-7514.2446', '-2638.7212', '8.882345', '100', '0', '0', 0),
(@MOVID, '3', '-7476.76', '-2624.1348', '8.876764', '100', '0', '0', 0),
(@MOVID, '4', '-7455.3584', '-2653.0996', '9.571935', '100', '0', '0', 0),
(@MOVID, '5', '-7448.17', '-2684.287', '10.396858', '100', '0', '0', 0),
(@MOVID, '6', '-7464.9395', '-2722.3528', '12.986783', '100', '0', '0', 0),
(@MOVID, '7', '-7477.4062', '-2751.5757', '9.966352', '100', '0', '0', 0),
(@MOVID, '8', '-7488.4673', '-2789.1526', '10.216653', '100', '0', '0', 0),
(@MOVID, '9', '-7485.203', '-2813.216', '9.904808', '100', '0', '0', 0),
(@MOVID, '10', '-7490.225', '-2844.4834', '8.795468', '100', '0', '0', 0),
(@MOVID, '11', '-7519.6772', '-2868.9116', '9.140966', '100', '0', '0', 0),
(@MOVID, '12', '-7530.0063', '-2900.8667', '8.795468', '100', '0', '0', 0),
(@MOVID, '13', '-7521.788', '-2933.6663', '10.26196', '100', '0', '0', 0),
(@MOVID, '14', '-7536.137', '-2949.2212', '9.98942', '100', '0', '0', 0),
(@MOVID, '15', '-7577.56', '-2942.3513', '12.729817', '100', '0', '0', 0),
(@MOVID, '16', '-7583.738', '-2907.2517', '10.851227', '100', '0', '0', 0),
(@MOVID, '17', '-7607.329', '-2879.9536', '12.708164', '100', '0', '0', 0),
(@MOVID, '18', '-7617.4565', '-2840.926', '10.813838', '100', '0', '0', 0),
(@MOVID, '19', '-7608.1885', '-2818.3933', '11.564553', '100', '0', '0', 0),
(@MOVID, '20', '-7582.7935', '-2779.428', '12.665738', '100', '0', '0', 0),
(@MOVID, '21', '-7557.7725', '-2751.545', '9.817974', '100', '0', '0', 0),
(@MOVID, '22', '-7528.2534', '-2713.1116', '11.724252', '100', '0', '0', 0);

SET @MOVID=22703;
DELETE FROM creature WHERE guid IN(@MOVID);
INSERT INTO creature(guid, id, map, position_x, position_y, position_z, orientation, spawntimesecsmin, spawntimesecsmax, patch_min, movement_type) VALUES
(@MOVID, '5429', '1', '-7447.894', '-3178.4563', '12.456087', '0.64330601692199710000', 300,300, '0', '2');
-- GUID: Full: 0x2056600020054D40000105000177F49B Creature/0 R5528/S261 Map: 1 (Kalimdor) Entry: 5429 (Fire Roc) Low: 24638619
DELETE FROM creature_movement WHERE id=@MOVID;
INSERT INTO `creature_movement` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`waittime`,`wander_distance`,`script_id`) VALUES
(@MOVID, '1', '-7447.894', '-3178.4563', '12.456087', '100', '0', '0', 0),
(@MOVID, '2', '-7456.144', '-3208.898', '12.181743', '100', '0', '0', 0),
(@MOVID, '3', '-7452.636', '-3245.815', '12.551165', '100', '0', '0', 0),
(@MOVID, '4', '-7481.6055', '-3284.0645', '13.879885', '100', '0', '0', 0),
(@MOVID, '5', '-7489.0894', '-3314.3206', '14.761059', '100', '0', '0', 0),
(@MOVID, '6', '-7485', '-3345.4153', '15.2799', '100', '0', '0', 0),
(@MOVID, '7', '-7481.568', '-3377.1323', '14.966684', '100', '0', '0', 0),
(@MOVID, '8', '-7484.3867', '-3416.0566', '15.810309', '100', '0', '0', 0),
(@MOVID, '9', '-7476.722', '-3441.2808', '14.49609', '100', '0', '0', 0),
(@MOVID, '10', '-7508.8228', '-3449.9363', '22.029915', '100', '0', '0', 0),
(@MOVID, '11', '-7512.026', '-3458.2744', '23.207489', '100', '0', '0', 0),
(@MOVID, '12', '-7520.1006', '-3480.4724', '19.458767', '100', '0', '0', 0),
(@MOVID, '13', '-7540.2524', '-3515.5793', '11.963429', '100', '0', '0', 0),
(@MOVID, '14', '-7542.104', '-3540.0247', '15.902519', '100', '0', '0', 0),
(@MOVID, '15', '-7557.6504', '-3577.7087', '12.509325', '100', '0', '0', 0),
(@MOVID, '16', '-7587.079', '-3586.427', '16.377602', '100', '0', '0', 0),
(@MOVID, '17', '-7607.5176', '-3606.0508', '16.113485', '100', '0', '0', 0),
(@MOVID, '18', '-7611.0557', '-3645.5408', '18.173412', '100', '0', '0', 0),
(@MOVID, '19', '-7615.9556', '-3684.4062', '18.187008', '100', '0', '0', 0),
(@MOVID, '20', '-7617.5522', '-3709.039', '18.701597', '100', '0', '0', 0),
(@MOVID, '21', '-7610.514', '-3741.698', '16.017086', '100', '0', '0', 0),
(@MOVID, '22', '-7627.568', '-3778.9211', '14.764794', '100', '0', '0', 0),
(@MOVID, '23', '-7648.1416', '-3775.2153', '18.672012', '100', '0', '0', 0),
(@MOVID, '24', '-7675.7993', '-3776.981', '24.642513', '100', '0', '0', 0),
(@MOVID, '25', '-7688.2065', '-3815.9236', '19.26257', '100', '0', '0', 0),
(@MOVID, '26', '-7692.593', '-3844.0151', '15.094873', '100', '0', '0', 0),
(@MOVID, '27', '-7684.326', '-3865.4883', '9.553316', '100', '0', '0', 0),
(@MOVID, '28', '-7674.83', '-3890.208', '8.695066', '100', '0', '0', 0),
(@MOVID, '29', '-7657.7397', '-3894.0564', '9.2062845', '100', '0', '0', 0),
(@MOVID, '30', '-7656.5713', '-3931.304', '9.968547', '100', '0', '0', 0),
(@MOVID, '31', '-7688.4854', '-3955.0269', '8.655266', '100', '0', '0', 0),
(@MOVID, '32', '-7714.7935', '-3978.0051', '9.364131', '100', '0', '0', 0),
(@MOVID, '33', '-7688.4854', '-3955.0269', '8.655266', '100', '0', '0', 0),
(@MOVID, '34', '-7656.5713', '-3931.304', '9.968547', '100', '0', '0', 0),
(@MOVID, '35', '-7657.7397', '-3894.0564', '9.2062845', '100', '0', '0', 0),
(@MOVID, '36', '-7674.83', '-3890.208', '8.695066', '100', '0', '0', 0),
(@MOVID, '37', '-7684.326', '-3865.4883', '9.553316', '100', '0', '0', 0),
(@MOVID, '38', '-7692.593', '-3844.0151', '15.094873', '100', '0', '0', 0),
(@MOVID, '39', '-7688.2065', '-3815.9236', '19.26257', '100', '0', '0', 0),
(@MOVID, '40', '-7675.7993', '-3776.981', '24.642513', '100', '0', '0', 0),
(@MOVID, '41', '-7648.1416', '-3775.2153', '18.672012', '100', '0', '0', 0),
(@MOVID, '42', '-7627.568', '-3778.9211', '14.764794', '100', '0', '0', 0),
(@MOVID, '43', '-7610.514', '-3741.698', '16.017086', '100', '0', '0', 0),
(@MOVID, '44', '-7617.5522', '-3709.039', '18.701597', '100', '0', '0', 0),
(@MOVID, '45', '-7615.9556', '-3684.4062', '18.187008', '100', '0', '0', 0),
(@MOVID, '46', '-7611.0557', '-3645.5408', '18.173412', '100', '0', '0', 0),
(@MOVID, '47', '-7607.5176', '-3606.0508', '16.113485', '100', '0', '0', 0),
(@MOVID, '48', '-7587.079', '-3586.427', '16.377602', '100', '0', '0', 0),
(@MOVID, '49', '-7557.6504', '-3577.7087', '12.509325', '100', '0', '0', 0),
(@MOVID, '50', '-7542.104', '-3540.0247', '15.902519', '100', '0', '0', 0),
(@MOVID, '51', '-7540.2524', '-3515.5793', '11.963429', '100', '0', '0', 0),
(@MOVID, '52', '-7520.1006', '-3480.4724', '19.458767', '100', '0', '0', 0),
(@MOVID, '53', '-7512.026', '-3458.2744', '23.207489', '100', '0', '0', 0),
(@MOVID, '54', '-7508.8228', '-3449.9363', '22.029915', '100', '0', '0', 0),
(@MOVID, '55', '-7476.722', '-3441.2808', '14.49609', '100', '0', '0', 0),
(@MOVID, '56', '-7484.3867', '-3416.0566', '15.810309', '100', '0', '0', 0),
(@MOVID, '57', '-7481.568', '-3377.1323', '14.966684', '100', '0', '0', 0),
(@MOVID, '58', '-7485', '-3345.4153', '15.2799', '100', '0', '0', 0),
(@MOVID, '59', '-7489.0894', '-3314.3206', '14.761059', '100', '0', '0', 0),
(@MOVID, '60', '-7481.6055', '-3284.0645', '13.879885', '100', '0', '0', 0),
(@MOVID, '61', '-7452.636', '-3245.815', '12.551165', '100', '0', '0', 0),
(@MOVID, '62', '-7456.144', '-3208.898', '12.181743', '100', '0', '0', 0);

SET @MOVID=22689;
DELETE FROM creature WHERE guid IN(@MOVID);
INSERT INTO creature(guid, id, map, position_x, position_y, position_z, orientation, spawntimesecsmin, spawntimesecsmax, patch_min, movement_type) VALUES
(@MOVID, '5429', '1', '-7710.2456', '-3519.9268', '32.789703', '0.64330601692199710000', 300,300, '0', '2');
-- GUID: Full: 0x2056600020054D400001050000F7F49B Creature/0 R5528/S261 Map: 1 (Kalimdor) Entry: 5429 (Fire Roc) Low: 16250011
DELETE FROM creature_movement WHERE id=@MOVID;
INSERT INTO `creature_movement` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`waittime`,`wander_distance`,`script_id`) VALUES
(@MOVID, '1', '-7710.2456', '-3519.9268', '32.789703', '100', '0', '0', 0),
(@MOVID, '2', '-7706.132', '-3548.0134', '34.835518', '100', '0', '0', 0),
(@MOVID, '3', '-7681.186', '-3554.3396', '26.914434', '100', '0', '0', 0),
(@MOVID, '4', '-7679.616', '-3585.0525', '32.807125', '100', '0', '0', 0),
(@MOVID, '5', '-7684.2744', '-3612.4934', '31.600718', '100', '0', '0', 0),
(@MOVID, '6', '-7713.3647', '-3644.6892', '35.84699', '100', '0', '0', 0),
(@MOVID, '7', '-7687.837', '-3683.4407', '32.256252', '100', '0', '0', 0),
(@MOVID, '8', '-7660.507', '-3709.155', '25.587423', '100', '0', '0', 0),
(@MOVID, '9', '-7620.04', '-3719.3347', '17.941874', '100', '0', '0', 0),
(@MOVID, '10', '-7589.0557', '-3748.3', '11.958143', '100', '0', '0', 0),
(@MOVID, '11', '-7557.7925', '-3735.7896', '10.454496', '100', '0', '0', 0),
(@MOVID, '12', '-7516.368', '-3718.3916', '12.208403', '100', '0', '0', 0),
(@MOVID, '13', '-7488.1816', '-3693.3455', '9.339683', '100', '0', '0', 0),
(@MOVID, '14', '-7477.249', '-3653.0503', '12.728154', '100', '0', '0', 0),
(@MOVID, '15', '-7487.067', '-3614.5256', '11.3737755', '100', '0', '0', 0),
(@MOVID, '16', '-7510.796', '-3585.0225', '9.94825', '100', '0', '0', 0),
(@MOVID, '17', '-7544.795', '-3583.627', '12.568206', '100', '0', '0', 0),
(@MOVID, '18', '-7568.849', '-3604.019', '14.029878', '100', '0', '0', 0),
(@MOVID, '19', '-7602.605', '-3614.911', '15.237872', '100', '0', '0', 0),
(@MOVID, '20', '-7620.744', '-3583.4368', '17.01725', '100', '0', '0', 0),
(@MOVID, '21', '-7606.8716', '-3550.7961', '16.242348', '100', '0', '0', 0),
(@MOVID, '22', '-7581.31', '-3538.9302', '18.745455', '100', '0', '0', 0),
(@MOVID, '23', '-7574.613', '-3511.8096', '17.513485', '100', '0', '0', 0),
(@MOVID, '24', '-7581.8037', '-3467.6467', '24.834633', '100', '0', '0', 0),
(@MOVID, '25', '-7599.106', '-3442.7004', '36.17151', '100', '0', '0', 0),
(@MOVID, '26', '-7637.863', '-3430.5422', '37.586548', '100', '0', '0', 0),
(@MOVID, '27', '-7648.299', '-3460.4084', '29.075321', '100', '0', '0', 0),
(@MOVID, '28', '-7681.2056', '-3446.737', '34.08811', '100', '0', '0', 0),
(@MOVID, '29', '-7710.7935', '-3450.1711', '35.062687', '100', '0', '0', 0),
(@MOVID, '30', '-7712.038', '-3490.9016', '30.47953', '100', '0', '0', 0);

SET @MOVID=22698;
DELETE FROM creature WHERE guid IN(@MOVID);
INSERT INTO creature(guid, id, map, position_x, position_y, position_z, orientation, spawntimesecsmin, spawntimesecsmax, patch_min, movement_type) VALUES
(@MOVID, '5429', '1', '-7817.2725', '-3018.5725', '48.95812', '0.64330601692199710000', 300,300, '0', '2');
-- GUID: Full: 0x2056600020054D40000105000077F49A Creature/0 R5528/S261 Map: 1 (Kalimdor) Entry: 5429 (Fire Roc) Low: 7861402
DELETE FROM creature_movement WHERE id=@MOVID;
INSERT INTO `creature_movement` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`waittime`,`wander_distance`,`script_id`) VALUES
(@MOVID, '1', '-7817.2725', '-3018.5725', '48.95812', '100', '0', '0', 0),
(@MOVID, '2', '-7814.655', '-3049.1282', '52.914764', '100', '0', '0', 0),
(@MOVID, '3', '-7819.0537', '-3072.5366', '56.35314', '100', '0', '0', 0),
(@MOVID, '4', '-7840.9575', '-3105.0808', '67.859665', '100', '0', '0', 0),
(@MOVID, '5', '-7846.397', '-3144.688', '76.12355', '100', '0', '0', 0),
(@MOVID, '6', '-7846.192', '-3183.1523', '78.15393', '100', '0', '0', 0),
(@MOVID, '7', '-7844.9116', '-3223.4744', '75.29675', '100', '0', '0', 0),
(@MOVID, '8', '-7849.5923', '-3256.7354', '69.78202', '100', '0', '0', 0),
(@MOVID, '9', '-7843.593', '-3281.1963', '68.928635', '100', '0', '0', 0),
(@MOVID, '10', '-7846.092', '-3301.041', '66.2171', '100', '0', '0', 0),
(@MOVID, '11', '-7847.717', '-3313.9395', '63.066357', '100', '0', '0', 0),
(@MOVID, '12', '-7837.249', '-3347.4229', '57.902733', '100', '0', '0', 0),
(@MOVID, '13', '-7818.763', '-3378.651', '53.835495', '100', '0', '0', 0),
(@MOVID, '14', '-7818.0938', '-3415.0273', '51.345844', '100', '0', '0', 0),
(@MOVID, '15', '-7817.511', '-3451.9067', '51.298195', '100', '0', '0', 0),
(@MOVID, '16', '-7811.7554', '-3484.0825', '51.92781', '100', '0', '0', 0),
(@MOVID, '17', '-7789.916', '-3511.6858', '48.1305', '100', '0', '0', 0),
(@MOVID, '18', '-7776.8853', '-3546.5776', '47.771877', '100', '0', '0', 0),
(@MOVID, '19', '-7789.916', '-3511.6858', '48.1305', '100', '0', '0', 0),
(@MOVID, '20', '-7811.7554', '-3484.0825', '51.92781', '100', '0', '0', 0),
(@MOVID, '21', '-7817.511', '-3451.9067', '51.298195', '100', '0', '0', 0),
(@MOVID, '22', '-7818.0938', '-3415.0273', '51.345844', '100', '0', '0', 0),
(@MOVID, '23', '-7818.763', '-3378.651', '53.835495', '100', '0', '0', 0),
(@MOVID, '24', '-7837.249', '-3347.4229', '57.902733', '100', '0', '0', 0),
(@MOVID, '25', '-7847.717', '-3313.9395', '63.066357', '100', '0', '0', 0),
(@MOVID, '26', '-7846.092', '-3301.041', '66.2171', '100', '0', '0', 0),
(@MOVID, '27', '-7843.593', '-3281.1963', '68.928635', '100', '0', '0', 0),
(@MOVID, '28', '-7849.5923', '-3256.7354', '69.78202', '100', '0', '0', 0),
(@MOVID, '29', '-7844.9116', '-3223.4744', '75.29675', '100', '0', '0', 0),
(@MOVID, '30', '-7846.192', '-3183.1523', '78.15393', '100', '0', '0', 0),
(@MOVID, '31', '-7846.397', '-3144.688', '76.12355', '100', '0', '0', 0),
(@MOVID, '32', '-7840.9575', '-3105.0808', '67.859665', '100', '0', '0', 0),
(@MOVID, '33', '-7819.0537', '-3072.5366', '56.35314', '100', '0', '0', 0),
(@MOVID, '34', '-7814.655', '-3049.1282', '52.914764', '100', '0', '0', 0);

SET @MOVID=22683;
DELETE FROM creature WHERE guid IN(@MOVID);
INSERT INTO creature(guid, id, map, position_x, position_y, position_z, orientation, spawntimesecsmin, spawntimesecsmax, patch_min, movement_type) VALUES
(@MOVID, '5429', '1', '-8187.9443', '-2764.1194', '28.511421', '0.64330601692199710000', 300,300, '0', '2');
-- GUID: Full: 0x2056600020054D40000105000077F499 Creature/0 R5528/S261 Map: 1 (Kalimdor) Entry: 5429 (Fire Roc) Low: 7861401
DELETE FROM creature_movement WHERE id=@MOVID;
INSERT INTO `creature_movement` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`waittime`,`wander_distance`,`script_id`) VALUES
(@MOVID, '1', '-8187.9443', '-2764.1194', '28.511421', '100', '0', '0', 0),
(@MOVID, '2', '-8188.8926', '-2780.272', '26.821125', '100', '0', '0', 0),
(@MOVID, '3', '-8170.9473', '-2811.517', '31.387812', '100', '0', '0', 0),
(@MOVID, '4', '-8152.0757', '-2825.4941', '33.273617', '100', '0', '0', 0),
(@MOVID, '5', '-8135.54', '-2847.3098', '32.166557', '100', '0', '0', 0),
(@MOVID, '6', '-8121.1704', '-2887.0725', '37.101044', '100', '0', '0', 0),
(@MOVID, '7', '-8116.7134', '-2913.2058', '39.074707', '100', '0', '0', 0),
(@MOVID, '8', '-8089.9707', '-2949.2734', '40.733513', '100', '0', '0', 0),
(@MOVID, '9', '-8056.1035', '-2946.4844', '47.42235', '100', '0', '0', 0),
(@MOVID, '10', '-8025.8926', '-2943.382', '50.762238', '100', '0', '0', 0),
(@MOVID, '11', '-8020.6694', '-2919.1597', '45.146645', '100', '0', '0', 0),
(@MOVID, '12', '-7993.263', '-2927.2007', '40.13385', '100', '0', '0', 0),
(@MOVID, '13', '-7967.8613', '-2948.8008', '43.70286', '100', '0', '0', 0),
(@MOVID, '14', '-7934.52', '-2949.9436', '54.159737', '100', '0', '0', 0),
(@MOVID, '15', '-7903.843', '-2942.7952', '49.08505', '100', '0', '0', 0),
(@MOVID, '16', '-7872.3804', '-2938.5403', '42.084183', '100', '0', '0', 0),
(@MOVID, '17', '-7838.2163', '-2946.6958', '46.543808', '100', '0', '0', 0),
(@MOVID, '18', '-7814.916', '-2951.1907', '45.821167', '100', '0', '0', 0),
(@MOVID, '19', '-7777.184', '-2945.966', '35.683773', '100', '0', '0', 0),
(@MOVID, '20', '-7745.2134', '-2945.8955', '31.730433', '100', '0', '0', 0),
(@MOVID, '21', '-7728.104', '-2919.625', '29.770096', '100', '0', '0', 0),
(@MOVID, '22', '-7726.797', '-2885.4326', '26.259724', '100', '0', '0', 0),
(@MOVID, '23', '-7753.0728', '-2855.9353', '30.514652', '100', '0', '0', 0),
(@MOVID, '24', '-7778.2075', '-2844.8547', '29.48818', '100', '0', '0', 0),
(@MOVID, '25', '-7812.8066', '-2841.6729', '30.540283', '100', '0', '0', 0),
(@MOVID, '26', '-7847.282', '-2829.3176', '33.29411', '100', '0', '0', 0),
(@MOVID, '27', '-7871.4004', '-2815.0996', '31.500122', '100', '0', '0', 0),
(@MOVID, '28', '-7916.693', '-2807.451', '31.104471', '100', '0', '0', 0),
(@MOVID, '29', '-7948.038', '-2815.1028', '32.48902', '100', '0', '0', 0),
(@MOVID, '30', '-7996.739', '-2816.8176', '20.094185', '100', '0', '0', 0),
(@MOVID, '31', '-8037.252', '-2821.6785', '35.34258', '100', '0', '0', 0),
(@MOVID, '32', '-8072.165', '-2809.8943', '32.802616', '100', '0', '0', 0),
(@MOVID, '33', '-8107.252', '-2803.2349', '32.693428', '100', '0', '0', 0),
(@MOVID, '34', '-8130.309', '-2788.558', '32.615738', '100', '0', '0', 0),
(@MOVID, '35', '-8157.809', '-2776.9128', '32.74304', '100', '0', '0', 0);

SET @MOVID=51831;
DELETE FROM creature WHERE guid IN(@MOVID);
INSERT INTO creature(guid, id, map, position_x, position_y, position_z, orientation, spawntimesecsmin, spawntimesecsmax, patch_min, movement_type) VALUES
(@MOVID, '8201', '1', '-9136.704', '-2982.9558', '36.845413', '0.64330601692199710000', 37800,57600, '0', '2');
-- GUID: Full: 0x20566000200802400001050000789699 Creature/0 R5528/S261 Map: 1 (Kalimdor) Entry: 8201 (Omgorn the Lost) Low: 7902873
DELETE FROM creature_movement WHERE id=@MOVID;
INSERT INTO `creature_movement` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`waittime`,`wander_distance`,`script_id`) VALUES
(@MOVID, '1', '-9136.704', '-2982.9558', '36.845413', '100', '0', '0', 0),
(@MOVID, '2', '-9147.607', '-2962.4114', '32.949413', '100', '0', '0', 0),
(@MOVID, '3', '-9172.853', '-2945.134', '25.684156', '100', '0', '0', 0),
(@MOVID, '4', '-9199.34', '-2921.4417', '18.303556', '100', '0', '0', 0),
(@MOVID, '5', '-9232.217', '-2911.1064', '13.819986', '100', '0', '0', 0),
(@MOVID, '6', '-9250.169', '-2911.0686', '14.972033', '100', '0', '0', 0),
(@MOVID, '7', '-9283.299', '-2912.4397', '12.631224', '100', '0', '0', 0),
(@MOVID, '8', '-9299.361', '-2939.837', '9.01022', '100', '0', '0', 0),
(@MOVID, '9', '-9304.352', '-2973.5703', '9.036558', '100', '0', '0', 0),
(@MOVID, '10', '-9293.734', '-3007.9531', '10.964022', '100', '0', '0', 0),
(@MOVID, '11', '-9257.036', '-3016.9565', '16.249674', '100', '0', '0', 0),
(@MOVID, '12', '-9235.923', '-3023.035', '16.43093', '100', '0', '0', 0),
(@MOVID, '13', '-9231.12', '-3041.108', '17.6586', '100', '0', '0', 0),
(@MOVID, '14', '-9213.732', '-3061.2966', '21.56213', '100', '0', '0', 0),
(@MOVID, '15', '-9195.127', '-3079.3625', '27.169727', '100', '0', '0', 0),
(@MOVID, '16', '-9205.267', '-3112.302', '25.27638', '100', '0', '0', 0),
(@MOVID, '17', '-9243.707', '-3122.0674', '17.277197', '100', '0', '0', 0),
(@MOVID, '18', '-9270.854', '-3112.2527', '10.597342', '100', '0', '0', 0),
(@MOVID, '19', '-9293.639', '-3087.3816', '10.47195', '100', '0', '0', 0),
(@MOVID, '20', '-9299.7', '-3050.247', '10.363008', '100', '0', '0', 0),
(@MOVID, '21', '-9293.639', '-3087.3816', '10.47195', '100', '0', '0', 0),
(@MOVID, '22', '-9270.854', '-3112.2527', '10.597342', '100', '0', '0', 0),
(@MOVID, '23', '-9243.707', '-3122.0674', '17.277197', '100', '0', '0', 0),
(@MOVID, '24', '-9205.267', '-3112.302', '25.27638', '100', '0', '0', 0),
(@MOVID, '25', '-9195.127', '-3079.3625', '27.169727', '100', '0', '0', 0),
(@MOVID, '26', '-9213.732', '-3061.2966', '21.56213', '100', '0', '0', 0),
(@MOVID, '27', '-9231.12', '-3041.108', '17.6586', '100', '0', '0', 0),
(@MOVID, '28', '-9235.923', '-3023.035', '16.43093', '100', '0', '0', 0),
(@MOVID, '29', '-9257.036', '-3016.9565', '16.249674', '100', '0', '0', 0),
(@MOVID, '30', '-9293.734', '-3007.9531', '10.964022', '100', '0', '0', 0),
(@MOVID, '31', '-9304.352', '-2973.5703', '9.036558', '100', '0', '0', 0),
(@MOVID, '32', '-9299.361', '-2939.837', '9.01022', '100', '0', '0', 0),
(@MOVID, '33', '-9283.299', '-2912.4397', '12.631224', '100', '0', '0', 0),
(@MOVID, '34', '-9250.169', '-2911.0686', '14.972033', '100', '0', '0', 0),
(@MOVID, '35', '-9232.217', '-2911.1064', '13.819986', '100', '0', '0', 0),
(@MOVID, '36', '-9199.34', '-2921.4417', '18.303556', '100', '0', '0', 0),
(@MOVID, '37', '-9172.853', '-2945.134', '25.684156', '100', '0', '0', 0),
(@MOVID, '38', '-9147.607', '-2962.4114', '32.949413', '100', '0', '0', 0);

SET @MOVID=23447;
DELETE FROM creature WHERE guid IN(@MOVID);
INSERT INTO creature(guid, id, map, position_x, position_y, position_z, orientation, spawntimesecsmin, spawntimesecsmax, patch_min, movement_type) VALUES
(@MOVID, '8667', '1', '-8553.424', '-4024.0278', '30.197329', '0.64330601692199710000', 300,300, '0', '2');
-- GUID: Full: 0x20566000200876C0000105000077F49A Creature/0 R5528/S261 Map: 1 (Kalimdor) Entry: 8667 (Gusting Vortex) Low: 7861402
DELETE FROM creature_movement WHERE id=@MOVID;
INSERT INTO `creature_movement` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`waittime`,`wander_distance`,`script_id`) VALUES
(@MOVID, '1', '-8553.424', '-4024.0278', '30.197329', '100', '0', '0', 0),
(@MOVID, '2', '-8553.002', '-4056.7517', '23.518234', '100', '0', '0', 0),
(@MOVID, '3', '-8547.497', '-4078.3923', '18.91567', '100', '0', '0', 0),
(@MOVID, '4', '-8521.726', '-4108.3384', '11.142905', '100', '0', '0', 0),
(@MOVID, '5', '-8489.129', '-4128.6157', '10.348596', '100', '0', '0', 0),
(@MOVID, '6', '-8481.277', '-4158.211', '12.416356', '100', '0', '0', 0),
(@MOVID, '7', '-8475.964', '-4194.772', '10.694378', '100', '0', '0', 0),
(@MOVID, '8', '-8455.784', '-4212.812', '10.901602', '100', '0', '0', 0),
(@MOVID, '9', '-8448.149', '-4250.6367', '10.174406', '100', '0', '0', 0),
(@MOVID, '10', '-8415.696', '-4251.4375', '14.778279', '100', '0', '0', 0),
(@MOVID, '11', '-8379.989', '-4250.1196', '13.118899', '100', '0', '0', 0),
(@MOVID, '12', '-8378.889', '-4278.532', '10.370785', '100', '0', '0', 0),
(@MOVID, '13', '-8349.284', '-4297.9185', '9.285025', '100', '0', '0', 0),
(@MOVID, '14', '-8327.817', '-4327.6', '10.911836', '100', '0', '0', 0),
(@MOVID, '15', '-8311.403', '-4361.924', '11.688467', '100', '0', '0', 0),
(@MOVID, '16', '-8318.342', '-4400.5884', '11.914323', '100', '0', '0', 0),
(@MOVID, '17', '-8332.601', '-4439.553', '9.016342', '100', '0', '0', 0),
(@MOVID, '18', '-8361.604', '-4449.5005', '9.836592', '100', '0', '0', 0),
(@MOVID, '19', '-8406.964', '-4461.178', '9.834585', '100', '0', '0', 0),
(@MOVID, '20', '-8443.289', '-4486.531', '9.276581', '100', '0', '0', 0),
(@MOVID, '21', '-8458.952', '-4495.3267', '8.88378', '100', '0', '0', 0),
(@MOVID, '22', '-8493.948', '-4478.538', '9.998079', '100', '0', '0', 0),
(@MOVID, '23', '-8517.967', '-4468.533', '13.164026', '100', '0', '0', 0),
(@MOVID, '24', '-8527.757', '-4447.486', '14.736904', '100', '0', '0', 0),
(@MOVID, '25', '-8545.657', '-4416.257', '12.617278', '100', '0', '0', 0),
(@MOVID, '26', '-8585.323', '-4427.299', '9.25971', '100', '0', '0', 0),
(@MOVID, '27', '-8611.191', '-4449.1553', '12.532532', '100', '0', '0', 0),
(@MOVID, '28', '-8640.351', '-4436.387', '11.860793', '100', '0', '0', 0),
(@MOVID, '29', '-8656.212', '-4398.1475', '12.1402', '100', '0', '0', 0),
(@MOVID, '30', '-8653.29', '-4376.002', '12.494173', '100', '0', '0', 0),
(@MOVID, '31', '-8668.732', '-4344.352', '11.419502', '100', '0', '0', 0),
(@MOVID, '32', '-8655.853', '-4312.98', '10.634197', '100', '0', '0', 0),
(@MOVID, '33', '-8662.712', '-4279.7676', '13.323373', '100', '0', '0', 0),
(@MOVID, '34', '-8673.661', '-4246.573', '17.757214', '100', '0', '0', 0),
(@MOVID, '35', '-8651.134', '-4216.6694', '18.16914', '100', '0', '0', 0),
(@MOVID, '36', '-8622.565', '-4183.9185', '16.451225', '100', '0', '0', 0),
(@MOVID, '37', '-8620.947', '-4147.9883', '18.737629', '100', '0', '0', 0),
(@MOVID, '38', '-8628.015', '-4106.4956', '31.386112', '100', '0', '0', 0),
(@MOVID, '39', '-8632.522', '-4064.7734', '37.462006', '100', '0', '0', 0),
(@MOVID, '40', '-8616.645', '-4048.6814', '37.88913', '100', '0', '0', 0),
(@MOVID, '41', '-8622.81', '-4010.9158', '46.48374', '100', '0', '0', 0),
(@MOVID, '42', '-8619.838', '-3981.7588', '46.233376', '100', '0', '0', 0),
(@MOVID, '43', '-8637.981', '-3954.6667', '47.457264', '100', '0', '0', 0),
(@MOVID, '44', '-8620.903', '-3910.3086', '32.166954', '100', '0', '0', 0),
(@MOVID, '45', '-8615.958', '-3892.0774', '32.39038', '100', '0', '0', 0),
(@MOVID, '46', '-8617.216', '-3856.6692', '32.73487', '100', '0', '0', 0),
(@MOVID, '47', '-8592.155', '-3816.4966', '22.671614', '100', '0', '0', 0),
(@MOVID, '48', '-8553.249', '-3796.7075', '21.709372', '100', '0', '0', 0),
(@MOVID, '49', '-8533.106', '-3814.7825', '20.201035', '100', '0', '0', 0),
(@MOVID, '50', '-8518.175', '-3829.1807', '22.037924', '100', '0', '0', 0),
(@MOVID, '51', '-8485.529', '-3846.1948', '21.870514', '100', '0', '0', 0),
(@MOVID, '52', '-8485.826', '-3886.3499', '24.046253', '100', '0', '0', 0),
(@MOVID, '53', '-8450.843', '-3906.7727', '15.134001', '100', '0', '0', 0),
(@MOVID, '54', '-8454.549', '-3947.6172', '23.124111', '100', '0', '0', 0),
(@MOVID, '55', '-8446.541', '-3992.2024', '17.729174', '100', '0', '0', 0),
(@MOVID, '56', '-8480.092', '-4005.1692', '20.524868', '100', '0', '0', 0),
(@MOVID, '57', '-8518.169', '-4018.5754', '27.013687', '100', '0', '0', 0);

SET @MOVID=22665;
DELETE FROM creature WHERE guid IN(@MOVID);
INSERT INTO creature(guid, id, map, position_x, position_y, position_z, orientation, spawntimesecsmin, spawntimesecsmax, patch_min, movement_type) VALUES
(@MOVID, '8667', '1', '-8408.564', '-4499.17', '12.067069', '0.64330601692199710000', 300,300, '0', '2');
-- GUID: Full: 0x20566000200876C0000105000077F49E Creature/0 R5528/S261 Map: 1 (Kalimdor) Entry: 8667 (Gusting Vortex) Low: 7861406
DELETE FROM creature_movement WHERE id=@MOVID;
INSERT INTO `creature_movement` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`waittime`,`wander_distance`,`script_id`) VALUES
(@MOVID, '1', '-8408.564', '-4499.17', '12.067069', '100', '0', '0', 0),
(@MOVID, '2', '-8425.898', '-4481.1523', '11.114128', '100', '0', '0', 0),
(@MOVID, '3', '-8452.013', '-4458.143', '9.328882', '100', '0', '0', 0),
(@MOVID, '4', '-8480.817', '-4419.5723', '10.231621', '100', '0', '0', 0),
(@MOVID, '5', '-8478.598', '-4385.468', '9.38727', '100', '0', '0', 0),
(@MOVID, '6', '-8515.708', '-4367.2056', '9.375865', '100', '0', '0', 0),
(@MOVID, '7', '-8525.028', '-4347.1084', '9.378782', '100', '0', '0', 0),
(@MOVID, '8', '-8551.485', '-4328.126', '10.234627', '100', '0', '0', 0),
(@MOVID, '9', '-8554', '-4295.5415', '10.459793', '100', '0', '0', 0),
(@MOVID, '10', '-8578.25', '-4274.666', '10.700556', '100', '0', '0', 0),
(@MOVID, '11', '-8584.609', '-4250.7324', '13.139923', '100', '0', '0', 0),
(@MOVID, '12', '-8603.196', '-4224.0625', '13.863788', '100', '0', '0', 0),
(@MOVID, '13', '-8589.15', '-4192.0747', '15.102692', '100', '0', '0', 0),
(@MOVID, '14', '-8587.76', '-4151.219', '15.872026', '100', '0', '0', 0),
(@MOVID, '15', '-8603.712', '-4139.9507', '19.214396', '100', '0', '0', 0),
(@MOVID, '16', '-8603.267', '-4104.592', '26.58325', '100', '0', '0', 0),
(@MOVID, '17', '-8600.157', '-4072.2903', '29.510567', '100', '0', '0', 0),
(@MOVID, '18', '-8592.663', '-4050.8633', '28.506983', '100', '0', '0', 0),
(@MOVID, '19', '-8587.067', '-4018.5183', '32.551056', '100', '0', '0', 0),
(@MOVID, '20', '-8594.65', '-3993.7244', '38.617336', '100', '0', '0', 0),
(@MOVID, '21', '-8601.62', '-3967.8003', '41.661232', '100', '0', '0', 0),
(@MOVID, '22', '-8594.65', '-3993.7244', '38.617336', '100', '0', '0', 0),
(@MOVID, '23', '-8587.067', '-4018.5183', '32.551056', '100', '0', '0', 0),
(@MOVID, '24', '-8592.663', '-4050.8633', '28.506983', '100', '0', '0', 0),
(@MOVID, '25', '-8600.157', '-4072.2903', '29.510567', '100', '0', '0', 0),
(@MOVID, '26', '-8603.267', '-4104.592', '26.58325', '100', '0', '0', 0),
(@MOVID, '27', '-8603.712', '-4139.9507', '19.214396', '100', '0', '0', 0),
(@MOVID, '28', '-8587.76', '-4151.219', '15.872026', '100', '0', '0', 0),
(@MOVID, '29', '-8589.15', '-4192.0747', '15.102692', '100', '0', '0', 0),
(@MOVID, '30', '-8603.196', '-4224.0625', '13.863788', '100', '0', '0', 0),
(@MOVID, '31', '-8584.609', '-4250.7324', '13.139923', '100', '0', '0', 0),
(@MOVID, '32', '-8578.25', '-4274.666', '10.700556', '100', '0', '0', 0),
(@MOVID, '33', '-8554', '-4295.5415', '10.459793', '100', '0', '0', 0),
(@MOVID, '34', '-8551.485', '-4328.126', '10.234627', '100', '0', '0', 0),
(@MOVID, '35', '-8525.028', '-4347.1084', '9.378782', '100', '0', '0', 0),
(@MOVID, '36', '-8515.708', '-4367.2056', '9.375865', '100', '0', '0', 0),
(@MOVID, '37', '-8478.598', '-4385.468', '9.38727', '100', '0', '0', 0),
(@MOVID, '38', '-8480.817', '-4419.5723', '10.231621', '100', '0', '0', 0),
(@MOVID, '39', '-8452.013', '-4458.143', '9.328882', '100', '0', '0', 0),
(@MOVID, '40', '-8425.898', '-4481.1523', '11.114128', '100', '0', '0', 0);

SET @MOVID=22701;
DELETE FROM creature WHERE guid IN(@MOVID);
INSERT INTO creature(guid, id, map, position_x, position_y, position_z, orientation, spawntimesecsmin, spawntimesecsmax, patch_min, movement_type) VALUES
(@MOVID, '8667', '1', '-8013.4756', '-4321.307', '10.384358', '0.64330601692199710000', 300,300, '0', '2');
-- GUID: Full: 0x20566000200876C0000105000077F49D Creature/0 R5528/S261 Map: 1 (Kalimdor) Entry: 8667 (Gusting Vortex) Low: 7861405
DELETE FROM creature_movement WHERE id=@MOVID;
INSERT INTO `creature_movement` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`waittime`,`wander_distance`,`script_id`) VALUES
(@MOVID, '1', '-8013.4756', '-4321.307', '10.384358', '100', '0', '0', 0),
(@MOVID, '2', '-7980.1978', '-4309.4106', '9.151064', '100', '0', '0', 0),
(@MOVID, '3', '-7942.9478', '-4287.4536', '9.503126', '100', '0', '0', 0),
(@MOVID, '4', '-7917.252', '-4279.7925', '10.437316', '100', '0', '0', 0),
(@MOVID, '5', '-7882.5825', '-4280.789', '9.777326', '100', '0', '0', 0),
(@MOVID, '6', '-7857.0923', '-4292.319', '9.725307', '100', '0', '0', 0),
(@MOVID, '7', '-7853.5645', '-4313.0312', '9.502082', '100', '0', '0', 0),
(@MOVID, '8', '-7849.21', '-4352.627', '11.356846', '100', '0', '0', 0),
(@MOVID, '9', '-7818.0376', '-4360.7134', '9.671751', '100', '0', '0', 0),
(@MOVID, '10', '-7783.8047', '-4385.6895', '11.340824', '100', '0', '0', 0),
(@MOVID, '11', '-7817.1104', '-4414.067', '10.057672', '100', '0', '0', 0),
(@MOVID, '12', '-7821.1484', '-4452.838', '11.559703', '100', '0', '0', 0),
(@MOVID, '13', '-7825.2603', '-4489.088', '10.024973', '100', '0', '0', 0),
(@MOVID, '14', '-7816.7134', '-4516.21', '10.597916', '100', '0', '0', 0),
(@MOVID, '15', '-7794.116', '-4552.3926', '10.587145', '100', '0', '0', 0),
(@MOVID, '16', '-7785.8237', '-4591.3276', '10.041538', '100', '0', '0', 0),
(@MOVID, '17', '-7815.52', '-4614.1978', '11.913036', '100', '0', '0', 0),
(@MOVID, '18', '-7830.779', '-4647.924', '9.270299', '100', '0', '0', 0),
(@MOVID, '19', '-7880.5244', '-4646.5596', '9.777163', '100', '0', '0', 0),
(@MOVID, '20', '-7910.6216', '-4618.251', '9.392569', '100', '0', '0', 0),
(@MOVID, '21', '-7910.4556', '-4592.4624', '11.115666', '100', '0', '0', 0),
(@MOVID, '22', '-7941.493', '-4582.1274', '10.549425', '100', '0', '0', 0),
(@MOVID, '23', '-7959.691', '-4552.3364', '10.778545', '100', '0', '0', 0),
(@MOVID, '24', '-7974.868', '-4539.8306', '10.233299', '100', '0', '0', 0),
(@MOVID, '25', '-7984.137', '-4512.09', '10.717123', '100', '0', '0', 0),
(@MOVID, '26', '-7991.8926', '-4478.829', '10.061386', '100', '0', '0', 0),
(@MOVID, '27', '-8013.1294', '-4453.174', '9.496267', '100', '0', '0', 0),
(@MOVID, '28', '-8038.9507', '-4423.119', '11.02028', '100', '0', '0', 0),
(@MOVID, '29', '-8042.04', '-4383.523', '9.1745405', '100', '0', '0', 0),
(@MOVID, '30', '-8037.2266', '-4354.012', '9.244042', '100', '0', '0', 0),
(@MOVID, '31', '-8012.0254', '-4343.8633', '11.13066', '100', '0', '0', 0);

SET @MOVID=23343;
DELETE FROM creature WHERE guid IN(@MOVID);
INSERT INTO creature(guid, id, map, position_x, position_y, position_z, orientation, spawntimesecsmin, spawntimesecsmax, patch_min, movement_type) VALUES
(@MOVID, '7857', '1', '-8085.2056', '-5306.6636', '1.1651042', '0.64330601692199710000', 300,300, '0', '2');
-- GUID: Full: 0x205660002007AC400000220000DCAB26 Creature/0 R5528/S34 Map: 1 (Kalimdor) Entry: 7857 (Southsea Dock Worker) Low: 14461734
DELETE FROM creature_movement WHERE id=@MOVID;
INSERT INTO `creature_movement` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`waittime`,`wander_distance`,`script_id`) VALUES
(@MOVID, '1', '-8085.2056', '-5306.6636', '1.1651042', '100', '0', '0', 0),
(@MOVID, '2', '-8077.3804', '-5322.464', '0.9060955', '100', '0', '0', 0),
(@MOVID, '3', '-8070.725', '-5325.9897', '1.2129083', '100', '0', '0', 0),
(@MOVID, '4', '-8058.157', '-5330.117', '1.2334586', '100', '0', '0', 0),
(@MOVID, '5', '-8049.488', '-5334.3823', '1.4825032', '100', '0', '0', 0),
(@MOVID, '6', '-8039.838', '-5347.16', '1.1127412', '100', '0', '0', 0),
(@MOVID, '7', '-8045.5356', '-5357.7285', '0.5724692', '100', '0', '0', 0),
(@MOVID, '8', '-8039.838', '-5347.16', '1.1127412', '100', '0', '0', 0),
(@MOVID, '9', '-8049.488', '-5334.3823', '1.4825032', '100', '0', '0', 0),
(@MOVID, '10', '-8058.157', '-5330.117', '1.2334586', '100', '0', '0', 0),
(@MOVID, '11', '-8070.725', '-5325.9897', '1.2129083', '100', '0', '0', 0),
(@MOVID, '12', '-8077.3804', '-5322.464', '0.9060955', '100', '0', '0', 0);

SET @MOVID=23366;
DELETE FROM creature WHERE guid IN(@MOVID);
INSERT INTO creature(guid, id, map, position_x, position_y, position_z, orientation, spawntimesecsmin, spawntimesecsmax, patch_min, movement_type) VALUES
(@MOVID, '7857', '1', '-8030.336', '-5360.0845', '0.98315454', '0.64330601692199710000', 300,300, '0', '2');
-- GUID: Full: 0x205660002007AC4000002200005CACA3 Creature/0 R5528/S34 Map: 1 (Kalimdor) Entry: 7857 (Southsea Dock Worker) Low: 6073507
DELETE FROM creature_movement WHERE id=@MOVID;
INSERT INTO `creature_movement` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`waittime`,`wander_distance`,`script_id`) VALUES
(@MOVID, '1', '-8030.336', '-5360.0845', '0.98315454', '100', '0', '0', 0),
(@MOVID, '2', '-8034.028', '-5358.551', '1.0282464', '100', '0', '0', 0),
(@MOVID, '3', '-8037.0806', '-5361.697', '2.9371872', '100', '0', '0', 0),
(@MOVID, '4', '-8041.335', '-5366.0693', '6.232248', '100', '0', '0', 0),
(@MOVID, '5', '-8047.5923', '-5372.3774', '6.3340244', '100', '0', '0', 0),
(@MOVID, '6', '-8054.055', '-5378.308', '12.125554', '100', '0', '0', 0),
(@MOVID, '7', '-8061.193', '-5384.487', '11.934256', '100', '0', '0', 0),
(@MOVID, '8', '-8069.058', '-5392.963', '19.185276', '100', '0', '0', 0),
(@MOVID, '9', '-8071.423', '-5394.4756', '19.659006', '100', '0', '0', 0),
(@MOVID, '10', '-8075.6484', '-5391.1235', '19.956524', '100', '0', '0', 0),
(@MOVID, '11', '-8074.681', '-5388.9326', '19.52932', '100', '0', '0', 0),
(@MOVID, '12', '-8071.6', '-5388.0063', '19.426102', '100', '0', '0', 0),
(@MOVID, '13', '-8068.3413', '-5386.0845', '19.193687', '100', '0', '0', 0),
(@MOVID, '14', '-8063.487', '-5381.1636', '19.064434', '100', '0', '0', 0),
(@MOVID, '15', '-8061.789', '-5378.2046', '19.010715', '100', '0', '0', 0),
(@MOVID, '16', '-8059.221', '-5375.712', '19.013815', '100', '0', '0', 0),
(@MOVID, '17', '-8053.6147', '-5371.1963', '18.7468', '100', '0', '0', 0),
(@MOVID, '18', '-8059.221', '-5375.712', '19.013815', '100', '0', '0', 0),
(@MOVID, '19', '-8061.789', '-5378.2046', '19.010715', '100', '0', '0', 0),
(@MOVID, '20', '-8063.487', '-5381.1636', '19.064434', '100', '0', '0', 0),
(@MOVID, '21', '-8068.3413', '-5386.0845', '19.193687', '100', '0', '0', 0),
(@MOVID, '22', '-8071.6', '-5388.0063', '19.426102', '100', '0', '0', 0),
(@MOVID, '23', '-8074.647', '-5388.8555', '19.528006', '100', '0', '0', 0),
(@MOVID, '24', '-8075.6484', '-5391.1235', '19.956524', '100', '0', '0', 0),
(@MOVID, '25', '-8071.423', '-5394.4756', '19.659006', '100', '0', '0', 0),
(@MOVID, '26', '-8069.058', '-5392.963', '19.185276', '100', '0', '0', 0),
(@MOVID, '27', '-8061.2188', '-5384.5093', '11.9411', '100', '0', '0', 0),
(@MOVID, '28', '-8054.1704', '-5378.4136', '12.088412', '100', '0', '0', 0),
(@MOVID, '29', '-8047.5923', '-5372.3774', '6.3340244', '100', '0', '0', 0),
(@MOVID, '30', '-8041.335', '-5366.0693', '6.232248', '100', '0', '0', 0),
(@MOVID, '31', '-8041.335', '-5366.0693', '6.232248', '100', '0', '0', 0),
(@MOVID, '32', '-8040.521', '-5365.233', '6.276903', '100', '0', '0', 0),
(@MOVID, '33', '-8040.3965', '-5365.105', '6.1678576', '100', '0', '0', 0),
(@MOVID, '34', '-8039.4233', '-5364.1045', '5.1238775', '100', '0', '0', 0),
(@MOVID, '35', '-8037.0806', '-5361.697', '2.9371872', '100', '0', '0', 0),
(@MOVID, '36', '-8034.028', '-5358.551', '1.0282464', '100', '0', '0', 0),
(@MOVID, '37', '-8030.336', '-5360.0845', '0.98315454', '100', '0', '0', 0),
(@MOVID, '38', '-8030.0894', '-5366.617', '0.8991944', '100', '0', '0', 0),
(@MOVID, '39', '-8039.303', '-5374.139', '0.56911075', '100', '0', '0', 0),
(@MOVID, '40', '-8030.0894', '-5366.617', '0.8991944', '100', '0', '0', 0),
(@MOVID, '41', '-8030.336', '-5360.0845', '0.98315454', '100', '0', '0', 0);

SET @MOVID=22706;
DELETE FROM creature WHERE guid IN(@MOVID);
INSERT INTO creature(guid, id, map, position_x, position_y, position_z, orientation, spawntimesecsmin, spawntimesecsmax, patch_min, movement_type) VALUES
(@MOVID, '7856', '1', '-7981.7534', '-5293.6235', '0.59237564', '0.64330601692199710000', 300,300, '0', '2');
-- GUID: Full: 0x205660002007AC0000002200005CA94F Creature/0 R5528/S34 Map: 1 (Kalimdor) Entry: 7856 (Southsea Freebooter) Low: 6072655
DELETE FROM creature_movement WHERE id=@MOVID;
INSERT INTO `creature_movement` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`waittime`,`wander_distance`,`script_id`) VALUES
(@MOVID, '1', '-7981.7534', '-5293.6235', '0.59237564', '100', '0', '0', 0),
(@MOVID, '2', '-7992.1943', '-5270.7744', '0.75339824', '100', '0', '0', 0),
(@MOVID, '3', '-8002.395', '-5244.645', '1.2666011', '100', '0', '0', 0),
(@MOVID, '4', '-8016.994', '-5236.395', '1.0369642', '100', '0', '0', 0),
(@MOVID, '5', '-8037.577', '-5241.312', '0.5785614', '100', '0', '0', 0),
(@MOVID, '6', '-8053.363', '-5221.497', '0.6490236', '100', '0', '0', 0),
(@MOVID, '7', '-8072.4243', '-5209.8306', '0.7383183', '100', '0', '0', 0),
(@MOVID, '8', '-8096.3013', '-5204.5825', '4.9602604', '100', '0', '0', 0),
(@MOVID, '9', '-8107.5537', '-5212.2173', '8.046898', '100', '0', '0', 0),
(@MOVID, '10', '-8109.6084', '-5235.58', '2.4376078', '100', '0', '0', 0),
(@MOVID, '11', '-8100.211', '-5242.0137', '1.0267812', '100', '0', '0', 0),
(@MOVID, '12', '-8094.2646', '-5259.0728', '0.7105526', '100', '0', '0', 0),
(@MOVID, '13', '-8083.829', '-5258.2', '0.6802173', '100', '0', '0', 0),
(@MOVID, '14', '-8072.7466', '-5289.125', '0.57481897', '100', '0', '0', 0),
(@MOVID, '15', '-8083.829', '-5258.2', '0.6802173', '100', '0', '0', 0),
(@MOVID, '16', '-8094.2646', '-5259.0728', '0.7105526', '100', '0', '0', 0),
(@MOVID, '17', '-8100.211', '-5242.0137', '1.0267812', '100', '0', '0', 0),
(@MOVID, '18', '-8109.6084', '-5235.58', '2.4376078', '100', '0', '0', 0),
(@MOVID, '19', '-8107.5537', '-5212.2173', '8.046898', '100', '0', '0', 0),
(@MOVID, '20', '-8096.3013', '-5204.5825', '4.9602604', '100', '0', '0', 0),
(@MOVID, '21', '-8072.4243', '-5209.8306', '0.7383183', '100', '0', '0', 0),
(@MOVID, '22', '-8053.363', '-5221.497', '0.6490236', '100', '0', '0', 0),
(@MOVID, '23', '-8037.577', '-5241.312', '0.5785614', '100', '0', '0', 0),
(@MOVID, '24', '-8016.994', '-5236.395', '1.0369642', '100', '0', '0', 0),
(@MOVID, '25', '-8002.395', '-5244.645', '1.2666011', '100', '0', '0', 0),
(@MOVID, '26', '-7992.1943', '-5270.7744', '0.75339824', '100', '0', '0', 0);

SET @MOVID=23384;
DELETE FROM creature WHERE guid IN(@MOVID);
INSERT INTO creature(guid, id, map, position_x, position_y, position_z, orientation, spawntimesecsmin, spawntimesecsmax, patch_min, movement_type) VALUES
(@MOVID, '7858', '1', '-8085.905', '-5226.6074', '0.6802192', '0.64330601692199710000', 300,300, '0', '2');
-- GUID: Full: 0x205660002007AC800000220000DC323D Creature/0 R5528/S34 Map: 1 (Kalimdor) Entry: 7858 (Southsea Swashbuckler) Low: 14430781
DELETE FROM creature_movement WHERE id=@MOVID;
INSERT INTO `creature_movement` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`waittime`,`wander_distance`,`script_id`) VALUES
(@MOVID, '1', '-8085.905', '-5226.6074', '0.6802192', '100', '0', '0', 0),
(@MOVID, '2', '-8071.25', '-5222.223', '0.58224404', '100', '0', '0', 0),
(@MOVID, '3', '-8068.548', '-5235.0225', '2.4442408', '100', '0', '0', 0),
(@MOVID, '4', '-8090.981', '-5242.8804', '2.0395436', '100', '0', '0', 0),
(@MOVID, '5', '-8090.0723', '-5250.612', '2.0317628', '100', '0', '0', 0),
(@MOVID, '6', '-8084.066', '-5262.391', '0.68021727', '100', '0', '0', 0),
(@MOVID, '7', '-8074.2563', '-5281.057', '0.57481897', '100', '0', '0', 0),
(@MOVID, '8', '-8074.69', '-5293.612', '0.57481897', '100', '0', '0', 0),
(@MOVID, '9', '-8081.9897', '-5294.3975', '0.57481897', '100', '0', '0', 0),
(@MOVID, '10', '-8094.8335', '-5297.212', '2.2093658', '100', '0', '0', 0),
(@MOVID, '11', '-8102.065', '-5273.696', '1.8690431', '100', '0', '0', 0),
(@MOVID, '12', '-8107.5903', '-5274.4136', '1.8187408', '100', '0', '0', 0),
(@MOVID, '13', '-8114.454', '-5276.4106', '1.6225044', '100', '0', '0', 0),
(@MOVID, '14', '-8106.3813', '-5302.7007', '0.5691102', '100', '0', '0', 0),
(@MOVID, '15', '-8114.454', '-5276.4106', '1.6225044', '100', '0', '0', 0),
(@MOVID, '16', '-8107.5903', '-5274.4136', '1.8187408', '100', '0', '0', 0),
(@MOVID, '17', '-8102.065', '-5273.696', '1.8690431', '100', '0', '0', 0),
(@MOVID, '18', '-8094.8335', '-5297.212', '2.2093658', '100', '0', '0', 0),
(@MOVID, '19', '-8081.9897', '-5294.3975', '0.57481897', '100', '0', '0', 0),
(@MOVID, '20', '-8074.69', '-5293.612', '0.57481897', '100', '0', '0', 0),
(@MOVID, '21', '-8074.2563', '-5281.057', '0.57481897', '100', '0', '0', 0),
(@MOVID, '22', '-8084.066', '-5262.391', '0.68021727', '100', '0', '0', 0),
(@MOVID, '23', '-8090.0723', '-5250.612', '2.0317628', '100', '0', '0', 0),
(@MOVID, '24', '-8090.981', '-5242.8804', '2.0395436', '100', '0', '0', 0),
(@MOVID, '25', '-8068.548', '-5235.0225', '2.4442408', '100', '0', '0', 0),
(@MOVID, '26', '-8071.25', '-5222.223', '0.58224404', '100', '0', '0', 0);

SET @MOVID=22722;
DELETE FROM creature WHERE guid IN(@MOVID);
INSERT INTO creature(guid, id, map, position_x, position_y, position_z, orientation, spawntimesecsmin, spawntimesecsmax, patch_min, movement_type) VALUES
(@MOVID, '7855', '1', '-7850', '-5087.5', '5.516257', '0.64330601692199710000', 300,300, '0', '2');
-- GUID: Full: 0x205660002007ABC000002200005CA58D Creature/0 R5528/S34 Map: 1 (Kalimdor) Entry: 7855 (Southsea Pirate) Low: 6071693
DELETE FROM creature_movement WHERE id=@MOVID;
INSERT INTO `creature_movement` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`waittime`,`wander_distance`,`script_id`) VALUES
(@MOVID, '1', '-7850', '-5087.5', '5.516257', '100', '0', '0', 0),
(@MOVID, '2', '-7847.328', '-5086.914', '5.5957875', '100', '0', '0', 0),
(@MOVID, '3', '-7849.2944', '-5087.6895', '5.545216', '100', '0', '0', 0),
(@MOVID, '4', '-7851.9595', '-5092.0903', '5.885441', '100', '0', '0', 0),
(@MOVID, '5', '-7854.2134', '-5083.144', '5.2429414', '100', '0', '0', 0),
(@MOVID, '6', '-7852.233', '-5084.1167', '5.3550034', '100', '0', '0', 0),
(@MOVID, '7', '-7852.1787', '-5091.8784', '5.8755455', '100', '0', '0', 0),
(@MOVID, '8', '-7856.25', '-5091.666', '6.0271354', '100', '0', '0', 0),
(@MOVID, '9', '-7852.0293', '-5083.901', '5.360723', '100', '0', '0', 0),
(@MOVID, '10', '-7853.038', '-5085.17', '5.366939', '100', '0', '0', 0),
(@MOVID, '11', '-7854.798', '-5081.605', '5.2671604', '100', '0', '0', 0),
(@MOVID, '12', '-7847.346', '-5089.1807', '5.658489', '100', '0', '0', 0),
(@MOVID, '13', '-7847.4087', '-5088.59', '5.6374016', '100', '0', '0', 0),
(@MOVID, '14', '-7848.8994', '-5085.4414', '5.528588', '100', '0', '0', 0),
(@MOVID, '15', '-7848.216', '-5088.328', '5.6024384', '100', '0', '0', 0),
(@MOVID, '16', '-7858.7886', '-5087.582', '5.638543', '100', '0', '0', 0),
(@MOVID, '17', '-7848.3794', '-5089.2837', '5.6371465', '100', '0', '0', 0),
(@MOVID, '18', '-7856.2876', '-5092.219', '6.0937715', '100', '0', '0', 0),
(@MOVID, '19', '-7852.25', '-5091.666', '5.915205', '100', '0', '0', 0),
(@MOVID, '20', '-7850', '-5087.5', '5.556359', '100', '0', '0', 0),
(@MOVID, '21', '-7852.25', '-5091.666', '5.915205', '100', '0', '0', 0),
(@MOVID, '22', '-7856.2876', '-5092.219', '6.0937715', '100', '0', '0', 0),
(@MOVID, '23', '-7848.3794', '-5089.2837', '5.6371465', '100', '0', '0', 0),
(@MOVID, '24', '-7858.7886', '-5087.582', '5.638543', '100', '0', '0', 0),
(@MOVID, '25', '-7848.216', '-5088.328', '5.6024384', '100', '0', '0', 0),
(@MOVID, '26', '-7848.8994', '-5085.4414', '5.528588', '100', '0', '0', 0),
(@MOVID, '27', '-7847.4087', '-5088.59', '5.6374016', '100', '0', '0', 0),
(@MOVID, '28', '-7847.346', '-5089.1807', '5.658489', '100', '0', '0', 0),
(@MOVID, '29', '-7854.798', '-5081.605', '5.2671604', '100', '0', '0', 0),
(@MOVID, '30', '-7853.038', '-5085.17', '5.366939', '100', '0', '0', 0),
(@MOVID, '31', '-7852.0293', '-5083.901', '5.360723', '100', '0', '0', 0),
(@MOVID, '32', '-7856.25', '-5091.666', '6.0271354', '100', '0', '0', 0),
(@MOVID, '33', '-7852.1787', '-5091.8784', '5.8755455', '100', '0', '0', 0),
(@MOVID, '34', '-7852.233', '-5084.1167', '5.3550034', '100', '0', '0', 0),
(@MOVID, '35', '-7854.2134', '-5083.144', '5.2429414', '100', '0', '0', 0),
(@MOVID, '36', '-7851.9595', '-5092.0903', '5.885441', '100', '0', '0', 0),
(@MOVID, '37', '-7849.2944', '-5087.6895', '5.545216', '100', '0', '0', 0),
(@MOVID, '38', '-7847.328', '-5086.914', '5.5957875', '100', '0', '0', 0);

UPDATE `creature` SET `wander_distance`=0 WHERE `movement_type` = 2;

DELETE FROM `creature` WHERE `guid` = 23298;

INSERT INTO `creature_addon` (`guid`, `patch`, `display_id`, `mount_display_id`, `equipment_id`, `stand_state`, `sheath_state`, `emote_state`, `auras`) VALUES
(23369, 0, 0, 0, -1, 0, 1, 234, NULL),
(23358, 0, 0, 0, -1, 0, 1, 234, NULL),
(23362, 0, 0, 0, -1, 0, 1, 234, NULL),
(23354, 0, 0, 0, -1, 0, 1, 234, NULL),
(23349, 0, 0, 0, -1, 0, 1, 234, NULL),
(23363, 0, 0, 0, -1, 0, 1, 234, NULL);

-- Events list for Southsea Dock Worker
DELETE FROM `creature_ai_events` WHERE `creature_id`=7857;
INSERT INTO `creature_ai_events` (`id`, `creature_id`, `condition_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_script`, `action2_script`, `action3_script`, `comment`) VALUES
(785701, 7857, 585, 1, 0, 100, 1, 10000, 30000, 10000, 30000, 785701, 0, 0, 'Southsea Dock Worker - Emote Talk - OOC'),
(785702, 7857, 0, 2, 0, 100, 4, 15, 0, 0, 0, 785702, 0, 0, 'Southsea Dock Worker - Flee at 15% HP');
DELETE FROM `creature_ai_scripts` WHERE `id`=785701;
INSERT INTO `creature_ai_scripts` (`id`, `delay`, `priority`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES
(785701, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Southsea Dock Worker - Emote Talk');
INSERT INTO `conditions` (`condition_entry`, `type`, `value1`, `value2`, `value3`, `value4`, `flags`) VALUES (585, -2, 584, 583, 582, 0, 0);
INSERT INTO `conditions` (`condition_entry`, `type`, `value1`, `value2`, `value3`, `value4`, `flags`) VALUES (584, 52, 23372, 23365, 23357, 23350, 0);
INSERT INTO `conditions` (`condition_entry`, `type`, `value1`, `value2`, `value3`, `value4`, `flags`) VALUES (583, 52, 23371, 23364, 23348, 23351, 0);
INSERT INTO `conditions` (`condition_entry`, `type`, `value1`, `value2`, `value3`, `value4`, `flags`) VALUES (582, 52, 23370, 23353, 23345, 0, 0);

-- Events list for Southsea Swashbuckler
INSERT INTO `creature_ai_events` (`id`, `creature_id`, `condition_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_script`, `action2_script`, `action3_script`, `comment`) VALUES
(785801, 7858, 595, 1, 0, 100, 1, 10000, 30000, 10000, 30000, 785801, 0, 0, 'Southsea Swashbuckler - Emote Talk - OOC');
DELETE FROM `creature_ai_scripts` WHERE `id`=785801;
INSERT INTO `creature_ai_scripts` (`id`, `delay`, `priority`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES
(785801, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Southsea Swashbuckler - Emote Talk');
INSERT INTO `conditions` (`condition_entry`, `type`, `value1`, `value2`, `value3`, `value4`, `flags`) VALUES (595, -2, 594, 593, 592, 591, 0);
INSERT INTO `conditions` (`condition_entry`, `type`, `value1`, `value2`, `value3`, `value4`, `flags`) VALUES (594, 52, 23387, 23396, 23383, 23404, 0);
INSERT INTO `conditions` (`condition_entry`, `type`, `value1`, `value2`, `value3`, `value4`, `flags`) VALUES (593, 52, 23375, 23377, 23397, 23386, 0);
INSERT INTO `conditions` (`condition_entry`, `type`, `value1`, `value2`, `value3`, `value4`, `flags`) VALUES (592, 52, 23380, 23400, 23378, 23381, 0);
INSERT INTO `conditions` (`condition_entry`, `type`, `value1`, `value2`, `value3`, `value4`, `flags`) VALUES (591, 52, 23389, 0, 0, 0, 0);

-- Events list for Southsea Pirate
INSERT INTO `creature_ai_events` (`id`, `creature_id`, `condition_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_script`, `action2_script`, `action3_script`, `comment`) VALUES
(785501, 7855, 621, 1, 0, 100, 1, 10000, 30000, 10000, 30000, 785501, 0, 0, 'Southsea Pirate - Emote Talk - OOC');
DELETE FROM `creature_ai_scripts` WHERE `id`=785501;
INSERT INTO `creature_ai_scripts` (`id`, `delay`, `priority`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES
(785501, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Southsea Pirate - Emote Talk');
INSERT INTO `conditions` (`condition_entry`, `type`, `value1`, `value2`, `value3`, `value4`, `flags`) VALUES (621, -2, 620, 619, 618, 0, 0);
INSERT INTO `conditions` (`condition_entry`, `type`, `value1`, `value2`, `value3`, `value4`, `flags`) VALUES (620, 52, 23302, 23332, 23330, 23299, 0);
INSERT INTO `conditions` (`condition_entry`, `type`, `value1`, `value2`, `value3`, `value4`, `flags`) VALUES (619, 52, 23314, 23334, 23306, 23290, 0);
INSERT INTO `conditions` (`condition_entry`, `type`, `value1`, `value2`, `value3`, `value4`, `flags`) VALUES (618, 52, 23294, 23304, 23313, 23301, 0);

-- Events list for Southsea Freebooter
INSERT INTO `creature_ai_events` (`id`, `creature_id`, `condition_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_script`, `action2_script`, `action3_script`, `comment`) VALUES
(785602, 7856, 621, 1, 0, 100, 1, 10000, 30000, 10000, 30000, 785602, 0, 0, 'Southsea Freebooter - Emote Talk - OOC');
DELETE FROM `creature_ai_scripts` WHERE `id`=785602;
INSERT INTO `creature_ai_scripts` (`id`, `delay`, `priority`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES
(785602, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Southsea Freebooter - Emote Talk');

UPDATE `creature` SET `movement_type` = 1, `wander_distance` = 4 WHERE `guid` IN (23401, 23379, 23307, 23327, 23376, 23403);
DELETE FROM `creature_movement` WHERE `id` IN (23307, 23327);

-- End of migration.
END IF;
END??
DELIMITER ;
CALL add_migration();
DROP PROCEDURE IF EXISTS add_migration;