1058 lines
60 KiB
SQL
1058 lines
60 KiB
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`='20260520091620');
|
|
IF v = 0 THEN
|
|
INSERT INTO `migrations` VALUES ('20260520091620');
|
|
-- Add your query below.
|
|
|
|
|
|
-- Ironforge Guard (Entry: 5595, Guid: 97) - DISTANCE 75.3335
|
|
UPDATE `creature` SET `position_x`=-4948.85, `position_y`=-1191.17, `position_z`=501.66 WHERE `guid`=97;
|
|
|
|
-- Ironforge Guard (Entry: 5595, Guid: 105) - DISTANCE 40.768
|
|
UPDATE `creature` SET `position_x`=-4973.11, `position_y`=-995.715, `position_z`=501.658 WHERE `guid`=105;
|
|
|
|
-- Ironforge Guard (Entry: 5595, Guid: 121) - DISTANCE 49.4408
|
|
UPDATE `creature` SET `position_x`=-4979.97, `position_y`=-889.479, `position_z`=501.627 WHERE `guid`=121;
|
|
|
|
-- Ironforge Mountaineer (Entry: 727, Guid: 225) - DISTANCE 22.2018
|
|
UPDATE `creature` SET `position_x`=-5711.44, `position_y`=-553.78, `position_z`=398.49 WHERE `guid`=225;
|
|
|
|
-- Bone Chewer (Entry: 210, Guid: 5973) - DISTANCE 38.1588
|
|
UPDATE `creature` SET `position_x`=-10243.5, `position_y`=161.273, `position_z`=0.0465889 WHERE `guid`=5973;
|
|
|
|
-- Skeletal Raider (Entry: 1110, Guid: 5138) - DISTANCE 29.1416
|
|
UPDATE `creature` SET `position_x`=-10426.2, `position_y`=343.543, `position_z`=42.0242 WHERE `guid`=5138;
|
|
|
|
-- Ironforge Guard (Entry: 5595, Guid: 1760) - DISTANCE 78.1083
|
|
UPDATE `creature` SET `position_x`=-4672.09, `position_y`=-983.101, `position_z`=501.658 WHERE `guid`=1760;
|
|
|
|
-- Bimble Longberry (Entry: 7978, Guid: 1768) - DISTANCE 20.3488
|
|
UPDATE `creature` SET `position_x`=-4707.85, `position_y`=-907.012, `position_z`=501.659 WHERE `guid`=1768;
|
|
|
|
-- Watcher Backus (Entry: 840, Guid: 4230) - DISTANCE 192.999
|
|
UPDATE `creature` SET `position_x`=-10330.9, `position_y`=-1122.6, `position_z`=21.8575 WHERE `guid`=4230;
|
|
|
|
-- Watcher Ladimore (Entry: 576, Guid: 4211) - DISTANCE 35.9802
|
|
UPDATE `creature` SET `position_x`=-10581.6, `position_y`=-1172.89, `position_z`=28.4936 WHERE `guid`=4211;
|
|
|
|
-- Leper Gnome (Entry: 1211, Guid: 2418) - DISTANCE 23.2913
|
|
UPDATE `creature` SET `position_x`=-5122.42, `position_y`=450.757, `position_z`=396.876 WHERE `guid`=2418;
|
|
|
|
-- Dreadscorn (Entry: 8304, Guid: 3902) - DISTANCE 29.9231
|
|
UPDATE `creature` SET `position_x`=-11447.9, `position_y`=-2646.15, `position_z`=24.1283 WHERE `guid`=3902;
|
|
|
|
-- Felguard Sentry (Entry: 6011, Guid: 3883) - DISTANCE 31.3489
|
|
UPDATE `creature` SET `position_x`=-11748, `position_y`=-3072.61, `position_z`=12.723 WHERE `guid`=3883;
|
|
|
|
-- Tristane Shadowstone (Entry: 11807, Guid: 3031) - DISTANCE 45.1524
|
|
UPDATE `creature` SET `position_x`=-5367.29, `position_y`=285.647, `position_z`=394.25 WHERE `guid`=3031;
|
|
|
|
-- Bloodsail Raider (Entry: 1561, Guid: 2571) - DISTANCE 39.6011
|
|
UPDATE `creature` SET `position_x`=-14141.8, `position_y`=477.248, `position_z`=3.25545 WHERE `guid`=2571;
|
|
|
|
-- Ironforge Mountaineer (Entry: 727, Guid: 4481) - DISTANCE 432.627
|
|
UPDATE `creature` SET `position_x`=-5508.87, `position_y`=-1966.94, `position_z`=399.491 WHERE `guid`=4481;
|
|
|
|
-- Bloodscalp Berserker (Entry: 597, Guid: 2237) - DISTANCE 42.8179
|
|
UPDATE `creature` SET `position_x`=-11621.5, `position_y`=705.35, `position_z`=42.2621 WHERE `guid`=2237;
|
|
|
|
-- Mosh'Ogg Brute (Entry: 1142, Guid: 2185) - DISTANCE 23.0946
|
|
UPDATE `creature` SET `position_x`=-12526.9, `position_y`=-99.9495, `position_z`=14.6065 WHERE `guid`=2185;
|
|
|
|
-- Mosh'Ogg Brute (Entry: 1142, Guid: 2162) - DISTANCE 22.2186
|
|
UPDATE `creature` SET `position_x`=-12477.3, `position_y`=-129.195, `position_z`=13.7891 WHERE `guid`=2162;
|
|
|
|
-- Mosh'Ogg Brute (Entry: 1142, Guid: 2154) - DISTANCE 49.5728
|
|
UPDATE `creature` SET `position_x`=-12438.5, `position_y`=-135.884, `position_z`=15.6819 WHERE `guid`=2154;
|
|
|
|
-- Bloodscalp Berserker (Entry: 597, Guid: 2111) - DISTANCE 44.8574
|
|
UPDATE `creature` SET `position_x`=-11562.7, `position_y`=730.125, `position_z`=59.5396 WHERE `guid`=2111;
|
|
|
|
-- Crystal Spine Basilisk (Entry: 689, Guid: 2106) - DISTANCE 60.6836
|
|
UPDATE `creature` SET `position_x`=-11886.4, `position_y`=717.058, `position_z`=26.5422 WHERE `guid`=2106;
|
|
|
|
-- Dabyrie Militia (Entry: 2581, Guid: 12045) - DISTANCE 28.9553
|
|
UPDATE `creature` SET `position_x`=-1095.12, `position_y`=-2939.86, `position_z`=44.4017 WHERE `guid`=12045;
|
|
|
|
-- Bloodscalp Berserker (Entry: 597, Guid: 2057) - DISTANCE 36.7792
|
|
UPDATE `creature` SET `position_x`=-11608.8, `position_y`=769.426, `position_z`=40.1039 WHERE `guid`=2057;
|
|
|
|
-- Bloodscalp Scout (Entry: 588, Guid: 1927) - DISTANCE 22.8092
|
|
UPDATE `creature` SET `position_x`=-11648, `position_y`=564.524, `position_z`=49.8145 WHERE `guid`=1927;
|
|
|
|
-- Dabyrie Militia (Entry: 2581, Guid: 11913) - DISTANCE 77.4288
|
|
UPDATE `creature` SET `position_x`=-1014.42, `position_y`=-2918.99, `position_z`=59.6612 WHERE `guid`=11913;
|
|
|
|
-- Dabyrie Militia (Entry: 2581, Guid: 11727) - DISTANCE 56.1831
|
|
UPDATE `creature` SET `position_x`=-1027.88, `position_y`=-2866.24, `position_z`=50.072 WHERE `guid`=11727;
|
|
|
|
-- Refuge Pointe Defender (Entry: 10696, Guid: 11581) - DISTANCE 130.091
|
|
UPDATE `creature` SET `position_x`=-1287.23, `position_y`=-2607.49, `position_z`=60.2273 WHERE `guid`=11581;
|
|
|
|
-- Kurzen Witch Doctor (Entry: 942, Guid: 1618) - DISTANCE 57.4569
|
|
UPDATE `creature` SET `position_x`=-11525.8, `position_y`=-907.2, `position_z`=25.5492 WHERE `guid`=1618;
|
|
|
|
-- Skullsplitter Hunter (Entry: 669, Guid: 1391) - DISTANCE 41.4714
|
|
UPDATE `creature` SET `position_x`=-12992.4, `position_y`=-671.172, `position_z`=52.4459 WHERE `guid`=1391;
|
|
|
|
-- Rorgish Jowl (Entry: 10639, Guid: 32869) - DISTANCE 36.1387
|
|
UPDATE `creature` SET `position_x`=3265.91, `position_y`=-365.72, `position_z`=153.103 WHERE `guid`=32869;
|
|
|
|
-- Menethil Sentry (Entry: 1434, Guid: 9695) - DISTANCE 41.3898
|
|
UPDATE `creature` SET `position_x`=-3602.91, `position_y`=-711.051, `position_z`=6.48002 WHERE `guid`=9695;
|
|
|
|
-- Stone Steward (Entry: 4860, Guid: 28365) - DISTANCE 25.3807
|
|
UPDATE `creature` SET `position_x`=154.882, `position_y`=284.294, `position_z`=-26.582 WHERE `guid`=28365;
|
|
|
|
-- Ancient Core Hound (Entry: 11673, Guid: 56863) - DISTANCE 55.3174
|
|
UPDATE `creature` SET `position_x`=713.138, `position_y`=-1077.04, `position_z`=-178.463 WHERE `guid`=56863;
|
|
|
|
-- Ancient Core Hound (Entry: 11673, Guid: 56862) - DISTANCE 31.7353
|
|
UPDATE `creature` SET `position_x`=619.315, `position_y`=-1131.17, `position_z`=-201.625 WHERE `guid`=56862;
|
|
|
|
-- Mountaineer Droken (Entry: 1280, Guid: 8840) - DISTANCE 45.4408
|
|
UPDATE `creature` SET `position_x`=-5456.04, `position_y`=-2879.35, `position_z`=348.621 WHERE `guid`=8840;
|
|
|
|
-- XT:9 (Entry: 4074, Guid: 32296) - DISTANCE 170.804
|
|
UPDATE `creature` SET `position_x`=1222.28, `position_y`=199.114, `position_z`=5.52599 WHERE `guid`=32296;
|
|
|
|
-- Lord Azrethoc (Entry: 5760, Guid: 29062) - DISTANCE 56.837
|
|
UPDATE `creature` SET `position_x`=-1868.5, `position_y`=1700.33, `position_z`=61.2578 WHERE `guid`=29062;
|
|
|
|
-- Magram Pack Runner (Entry: 4643, Guid: 27115) - DISTANCE 93.1899
|
|
UPDATE `creature` SET `position_x`=-1743.92, `position_y`=1068.43, `position_z`=91.2688 WHERE `guid`=27115;
|
|
|
|
-- Magram Pack Runner (Entry: 4643, Guid: 27114) - DISTANCE 98.9052
|
|
UPDATE `creature` SET `position_x`=-1866.26, `position_y`=1292.67, `position_z`=90.2674 WHERE `guid`=27114;
|
|
|
|
-- Kodo Matriarch (Entry: 2974, Guid: 26213) - DISTANCE 28.8265
|
|
UPDATE `creature` SET `position_x`=-2549.47, `position_y`=-4.26567, `position_z`=5.67873 WHERE `guid`=26213;
|
|
|
|
-- Mountain Cougar (Entry: 2961, Guid: 25765) - DISTANCE 33.1085
|
|
UPDATE `creature` SET `position_x`=-3403.65, `position_y`=-418.469, `position_z`=81.9619 WHERE `guid`=25765;
|
|
|
|
-- Mountain Cougar (Entry: 2961, Guid: 25713) - DISTANCE 35.0383
|
|
UPDATE `creature` SET `position_x`=-3511.66, `position_y`=-794.472, `position_z`=112.127 WHERE `guid`=25713;
|
|
|
|
-- Tarren Mill Deathguard (Entry: 2405, Guid: 15545) - DISTANCE 142.724
|
|
UPDATE `creature` SET `position_x`=-30.9087, `position_y`=-887.165, `position_z`=56.2581 WHERE `guid`=15545;
|
|
|
|
-- Ancient Core Hound (Entry: 11673, Guid: 56860) - DISTANCE 29.4961
|
|
UPDATE `creature` SET `position_x`=568.275, `position_y`=-805.672, `position_z`=-206.751 WHERE `guid`=56860;
|
|
|
|
-- Stone Guardian (Entry: 6560, Guid: 24431) - DISTANCE 45.4613
|
|
UPDATE `creature` SET `position_x`=-6711.66, `position_y`=-1108.71, `position_z`=-272.097 WHERE `guid`=24431;
|
|
|
|
-- Stone Guardian (Entry: 6560, Guid: 24429) - DISTANCE 44.7917
|
|
UPDATE `creature` SET `position_x`=-7838.25, `position_y`=-2077.8, `position_z`=-272.28 WHERE `guid`=24429;
|
|
|
|
-- Zulian Panther (Entry: 11365, Guid: 49320) - DISTANCE 22.2923
|
|
UPDATE `creature` SET `position_x`=-11626.8, `position_y`=-1701.44, `position_z`=38.8236 WHERE `guid`=49320;
|
|
|
|
-- Theradrim Guardian (Entry: 11784, Guid: 55465) - DISTANCE 25.0839
|
|
UPDATE `creature` SET `position_x`=97.5771, `position_y`=-265.692, `position_z`=-108.677 WHERE `guid`=55465;
|
|
|
|
-- Thessala Hydra (Entry: 12207, Guid: 55461) - DISTANCE 49.8242
|
|
UPDATE `creature` SET `position_x`=292.386, `position_y`=-60.9944, `position_z`=-131.01 WHERE `guid`=55461;
|
|
|
|
-- Razzashi Skitterer (Entry: 14880, Guid: 49202) - DISTANCE 26.8787
|
|
UPDATE `creature` SET `position_x`=-12298.4, `position_y`=-1653.58, `position_z`=130.261 WHERE `guid`=49202;
|
|
|
|
-- Starving Buzzard (Entry: 2829, Guid: 7561) - DISTANCE 33.0794
|
|
UPDATE `creature` SET `position_x`=-6371.3, `position_y`=-3594.98, `position_z`=247.97 WHERE `guid`=7561;
|
|
|
|
-- Silithid Hive Drone (Entry: 4133, Guid: 21325) - DISTANCE 54.5318
|
|
UPDATE `creature` SET `position_x`=-6483.78, `position_y`=-3272.34, `position_z`=-112.437 WHERE `guid`=21325;
|
|
|
|
-- Dustbelcher Mystic (Entry: 2907, Guid: 7210) - DISTANCE 29.564
|
|
UPDATE `creature` SET `position_x`=-7135.3, `position_y`=-2398.71, `position_z`=241.667 WHERE `guid`=7210;
|
|
|
|
-- Death's Head Geomancer (Entry: 7335, Guid: 20298) - DISTANCE 45.8734
|
|
UPDATE `creature` SET `position_x`=-4630.09, `position_y`=-2456.71, `position_z`=89.1339 WHERE `guid`=20298;
|
|
|
|
-- Bloodscalp Scout (Entry: 588, Guid: 993) - DISTANCE 22.8785
|
|
UPDATE `creature` SET `position_x`=-11729.1, `position_y`=652.077, `position_z`=49.8425 WHERE `guid`=993;
|
|
|
|
-- Spewed Larva (Entry: 13533, Guid: 54127) - DISTANCE 25.0146
|
|
UPDATE `creature` SET `position_x`=918.644, `position_y`=-355.717, `position_z`=-50.4764 WHERE `guid`=54127;
|
|
|
|
-- Hakkari Oracle (Entry: 11346, Guid: 733) - DISTANCE 26.6932
|
|
UPDATE `creature` SET `position_x`=-11916.5, `position_y`=-1089.93, `position_z`=77.2794 WHERE `guid`=733;
|
|
|
|
-- Dustbelcher Mauler (Entry: 2717, Guid: 6989) - DISTANCE 23.9639
|
|
UPDATE `creature` SET `position_x`=-7135.3, `position_y`=-2398.71, `position_z`=241.667 WHERE `guid`=6989;
|
|
|
|
-- Dustbelcher Wyrmhunter (Entry: 2716, Guid: 6975) - DISTANCE 30.2874
|
|
UPDATE `creature` SET `position_x`=-7141.25, `position_y`=-2395.48, `position_z`=240.516 WHERE `guid`=6975;
|
|
|
|
-- Kreenig Snarlsnout (Entry: 3438, Guid: 14386) - DISTANCE 24.9151
|
|
UPDATE `creature` SET `position_x`=-218.01, `position_y`=-3332.16, `position_z`=91.6676 WHERE `guid`=14386;
|
|
|
|
-- Gurubashi Bat Rider (Entry: 14750, Guid: 49130) - DISTANCE 31.4667
|
|
UPDATE `creature` SET `position_x`=-12274.9, `position_y`=-1414.91, `position_z`=130.601 WHERE `guid`=49130;
|
|
|
|
-- Gazelle (Entry: 4166, Guid: 14020) - DISTANCE 28.0714
|
|
UPDATE `creature` SET `position_x`=657.78, `position_y`=-1987.34, `position_z`=93.8276 WHERE `guid`=14020;
|
|
|
|
-- Dark Iron Slaver (Entry: 5844, Guid: 6767) - DISTANCE 118.425
|
|
UPDATE `creature` SET `position_x`=-6910.41, `position_y`=-1212.58, `position_z`=213.797 WHERE `guid`=6767;
|
|
|
|
-- Mogg (Entry: 14908, Guid: 13964) - DISTANCE 21.0943
|
|
UPDATE `creature` SET `position_x`=1022.24, `position_y`=-2235.11, `position_z`=93.3114 WHERE `guid`=13964;
|
|
|
|
-- Mechano-Flamewalker (Entry: 6226, Guid: 30385) - DISTANCE 35.3364
|
|
UPDATE `creature` SET `position_x`=-872.044, `position_y`=410.955, `position_z`=-316.445 WHERE `guid`=30385;
|
|
|
|
-- Akkrilus (Entry: 3773, Guid: 51883) - DISTANCE 80.2709
|
|
UPDATE `creature` SET `position_x`=2230.63, `position_y`=222.503, `position_z`=134.671 WHERE `guid`=51883;
|
|
|
|
-- Mosh'Ogg Spellcrafter (Entry: 710, Guid: 528) - DISTANCE 20.1655
|
|
UPDATE `creature` SET `position_x`=-12321.5, `position_y`=-1062.25, `position_z`=6.71975 WHERE `guid`=528;
|
|
|
|
-- Peacekeeper Security Suit (Entry: 6230, Guid: 30279) - DISTANCE 42.0477
|
|
UPDATE `creature` SET `position_x`=-626.307, `position_y`=523.558, `position_z`=-273.063 WHERE `guid`=30279;
|
|
|
|
-- Antilus the Soarer (Entry: 5347, Guid: 51840) - DISTANCE 34.2598
|
|
UPDATE `creature` SET `position_x`=-5788.74, `position_y`=1605.72, `position_z`=81.5917 WHERE `guid`=51840;
|
|
|
|
-- Spawn of Hakkar (Entry: 5708, Guid: 33621) - DISTANCE 31.1295
|
|
UPDATE `creature` SET `position_x`=-551.933, `position_y`=46.9841, `position_z`=-148.802 WHERE `guid`=33621;
|
|
|
|
-- Caverndeep Ambusher (Entry: 6207, Guid: 30217) - DISTANCE 31.2228
|
|
UPDATE `creature` SET `position_x`=-482.355, `position_y`=53.012, `position_z`=-156.967 WHERE `guid`=30217;
|
|
|
|
-- Dwarven Farmer (Entry: 12998, Guid: 285020) - DISTANCE 39.4874
|
|
UPDATE `creature` SET `position_x`=-1851.5, `position_y`=-4161.39, `position_z`=8.0422 WHERE `guid`=285020;
|
|
|
|
-- Zandalar Headshrinker (Entry: 14876, Guid: 286) - DISTANCE 25.4088
|
|
UPDATE `creature` SET `position_x`=-11830.9, `position_y`=1257.7, `position_z`=2.03902 WHERE `guid`=286;
|
|
|
|
-- Mobile Alert System (Entry: 7849, Guid: 30144) - DISTANCE 40.3667
|
|
UPDATE `creature` SET `position_x`=-772.734, `position_y`=555.942, `position_z`=-291.118 WHERE `guid`=30144;
|
|
|
|
-- Mobile Alert System (Entry: 7849, Guid: 30143) - DISTANCE 76.6678
|
|
UPDATE `creature` SET `position_x`=-756.561, `position_y`=583.677, `position_z`=-303.783 WHERE `guid`=30143;
|
|
|
|
-- Dark Iron Agent (Entry: 6212, Guid: 30132) - DISTANCE 21.6424
|
|
UPDATE `creature` SET `position_x`=-698.351, `position_y`=559.918, `position_z`=-282.06 WHERE `guid`=30132;
|
|
|
|
-- Lord Sakrasis (Entry: 2541, Guid: 32043) - DISTANCE 40.5221
|
|
UPDATE `creature` SET `position_x`=-13807.7, `position_y`=379.781, `position_z`=94.488 WHERE `guid`=32043;
|
|
|
|
-- Defias Evoker (Entry: 1729, Guid: 79171) - DISTANCE 45.7057
|
|
UPDATE `creature` SET `position_x`=-153.951, `position_y`=-517.067, `position_z`=52.5085 WHERE `guid`=79171;
|
|
|
|
-- Defias Squallshaper (Entry: 1732, Guid: 79310) - DISTANCE 21.1551
|
|
UPDATE `creature` SET `position_x`=-79.8256, `position_y`=-783.363, `position_z`=26.461 WHERE `guid`=79310;
|
|
|
|
-- Cookie (Entry: 645, Guid: 79344) - DISTANCE 43.2908
|
|
UPDATE `creature` SET `position_x`=-109.963, `position_y`=-844.91, `position_z`=16.9348 WHERE `guid`=79344;
|
|
|
|
-- Jenn Langston (Entry: 3626, Guid: 79746) - DISTANCE 89.7191
|
|
UPDATE `creature` SET `position_x`=-8703.23, `position_y`=406.059, `position_z`=99.8461 WHERE `guid`=79746;
|
|
|
|
-- Stormwind City Patroller (Entry: 1976, Guid: 79807) - DISTANCE 86.5301
|
|
UPDATE `creature` SET `position_x`=-8552.45, `position_y`=767.143, `position_z`=96.6512 WHERE `guid`=79807;
|
|
|
|
-- Stormwind City Patroller (Entry: 1976, Guid: 79814) - DISTANCE 139.666
|
|
UPDATE `creature` SET `position_x`=-8698.59, `position_y`=714.268, `position_z`=97.0168 WHERE `guid`=79814;
|
|
|
|
-- Stormwind City Guard (Entry: 68, Guid: 79859) - DISTANCE 70.255
|
|
UPDATE `creature` SET `position_x`=-8950.16, `position_y`=508.631, `position_z`=96.3585 WHERE `guid`=79859;
|
|
|
|
-- Northshire Guard (Entry: 1642, Guid: 79932) - DISTANCE 50.7065
|
|
UPDATE `creature` SET `position_x`=-9045.58, `position_y`=-42.5667, `position_z`=88.3451 WHERE `guid`=79932;
|
|
|
|
-- Northshire Peasant (Entry: 11260, Guid: 80145) - DISTANCE 30.9223
|
|
UPDATE `creature` SET `position_x`=-8902.59, `position_y`=-231.7, `position_z`=80.4142 WHERE `guid`=80145;
|
|
|
|
-- Prowler (Entry: 118, Guid: 81135) - DISTANCE 24.4032
|
|
UPDATE `creature` SET `position_x`=-8964.89, `position_y`=-731.513, `position_z`=74.6737 WHERE `guid`=81135;
|
|
|
|
-- Prowler (Entry: 118, Guid: 81155) - DISTANCE 26.2038
|
|
UPDATE `creature` SET `position_x`=-8926.76, `position_y`=-893.678, `position_z`=71.8135 WHERE `guid`=81155;
|
|
|
|
-- Prowler (Entry: 118, Guid: 81182) - DISTANCE 33.2079
|
|
UPDATE `creature` SET `position_x`=-9775.46, `position_y`=-1105.2, `position_z`=35.8893 WHERE `guid`=81182;
|
|
|
|
-- Prowler (Entry: 118, Guid: 81184) - DISTANCE 20.9959
|
|
UPDATE `creature` SET `position_x`=-9728.65, `position_y`=-1155.06, `position_z`=40.7077 WHERE `guid`=81184;
|
|
|
|
-- Prowler (Entry: 118, Guid: 81231) - DISTANCE 23.4124
|
|
UPDATE `creature` SET `position_x`=-9769.1, `position_y`=-1238.95, `position_z`=42.9905 WHERE `guid`=81231;
|
|
|
|
-- Prowler (Entry: 118, Guid: 81260) - DISTANCE 29.9078
|
|
UPDATE `creature` SET `position_x`=-9414.74, `position_y`=-1167.24, `position_z`=57.3056 WHERE `guid`=81260;
|
|
|
|
-- Prowler (Entry: 118, Guid: 81265) - DISTANCE 33.57
|
|
UPDATE `creature` SET `position_x`=-9361.51, `position_y`=-1194.59, `position_z`=64.5418 WHERE `guid`=81265;
|
|
|
|
-- Prowler (Entry: 118, Guid: 81334) - DISTANCE 23.1154
|
|
UPDATE `creature` SET `position_x`=-8877.08, `position_y`=-1039.29, `position_z`=74.3784 WHERE `guid`=81334;
|
|
|
|
-- Prowler (Entry: 118, Guid: 81351) - DISTANCE 22.1651
|
|
UPDATE `creature` SET `position_x`=-9735.17, `position_y`=-1270.18, `position_z`=51.1113 WHERE `guid`=81351;
|
|
|
|
-- Prowler (Entry: 118, Guid: 81353) - DISTANCE 20.4504
|
|
UPDATE `creature` SET `position_x`=-9838.14, `position_y`=-1200.88, `position_z`=34.7705 WHERE `guid`=81353;
|
|
|
|
-- Prowler (Entry: 118, Guid: 81375) - DISTANCE 20.5838
|
|
UPDATE `creature` SET `position_x`=-9611.71, `position_y`=-1499.37, `position_z`=58.7902 WHERE `guid`=81375;
|
|
|
|
-- Prowler (Entry: 118, Guid: 81395) - DISTANCE 25.732
|
|
UPDATE `creature` SET `position_x`=-9360.01, `position_y`=-1395.05, `position_z`=62.565 WHERE `guid`=81395;
|
|
|
|
-- Prowler (Entry: 118, Guid: 81398) - DISTANCE 37.9295
|
|
UPDATE `creature` SET `position_x`=-9389.21, `position_y`=-1449.72, `position_z`=61.9269 WHERE `guid`=81398;
|
|
|
|
-- Prowler (Entry: 118, Guid: 81399) - DISTANCE 21.5796
|
|
UPDATE `creature` SET `position_x`=-9395.29, `position_y`=-1468.65, `position_z`=61.9998 WHERE `guid`=81399;
|
|
|
|
-- Prowler (Entry: 118, Guid: 81402) - DISTANCE 23.2997
|
|
UPDATE `creature` SET `position_x`=-9521.88, `position_y`=-1515.28, `position_z`=60.9161 WHERE `guid`=81402;
|
|
|
|
-- Gilmorian (Entry: 14447, Guid: 48204) - DISTANCE 55.436
|
|
UPDATE `creature` SET `position_x`=-10567.2, `position_y`=-4384.11, `position_z`=2.47185 WHERE `guid`=48204;
|
|
|
|
-- Darkmoon Faire Carnie (Entry: 14849, Guid: 42598) - DISTANCE 25.3466
|
|
UPDATE `creature` SET `position_x`=-9554.06, `position_y`=89.1628, `position_z`=59.0065 WHERE `guid`=42598;
|
|
|
|
-- Freezing Spirit (Entry: 7353, Guid: 87206) - DISTANCE 60
|
|
UPDATE `creature` SET `position_x`=2392.46, `position_y`=993.458, `position_z`=53.1636 WHERE `guid`=87206;
|
|
|
|
-- Guard Fengus (Entry: 14321, Guid: 84379) - DISTANCE 26.5344
|
|
UPDATE `creature` SET `position_x`=385.594, `position_y`=316.105, `position_z`=11.2214 WHERE `guid`=84379;
|
|
|
|
-- Black Slayer (Entry: 5982, Guid: 1449) - DISTANCE 39.2666
|
|
UPDATE `creature` SET `position_x`=-11153.5, `position_y`=-3322.54, `position_z`=4.864 WHERE `guid`=1449;
|
|
|
|
-- Flesh Hunter (Entry: 15335, Guid: 85885) - DISTANCE 20.0681
|
|
UPDATE `creature` SET `position_x`=-9291.73, `position_y`=1379.82, `position_z`=21.3851 WHERE `guid`=85885;
|
|
|
|
-- Obsidian Destroyer (Entry: 15338, Guid: 87013) - DISTANCE 50.5825
|
|
UPDATE `creature` SET `position_x`=-9080.63, `position_y`=2195.19, `position_z`=21.3868 WHERE `guid`=87013;
|
|
|
|
-- Anubisath Guardian (Entry: 15355, Guid: 87491) - DISTANCE 28.3949
|
|
UPDATE `creature` SET `position_x`=-9199.99, `position_y`=1873.43, `position_z`=85.5563 WHERE `guid`=87491;
|
|
|
|
-- Obsidian Eradicator (Entry: 15262, Guid: 88074) - DISTANCE 40.785
|
|
UPDATE `creature` SET `position_x`=-8183.4, `position_y`=2109.86, `position_z`=129.099 WHERE `guid`=88074;
|
|
|
|
-- Anubisath Defender (Entry: 15277, Guid: 88019) - DISTANCE 88.0365
|
|
UPDATE `creature` SET `position_x`=-8937.76, `position_y`=1457.64, `position_z`=-91.8863 WHERE `guid`=88019;
|
|
|
|
-- Anubisath Defender (Entry: 15277, Guid: 88018) - DISTANCE 92.0482
|
|
UPDATE `creature` SET `position_x`=-8823.84, `position_y`=1504.05, `position_z`=-94.5167 WHERE `guid`=88018;
|
|
|
|
-- Anubisath Defender (Entry: 15277, Guid: 88017) - DISTANCE 79.9417
|
|
UPDATE `creature` SET `position_x`=-8918.98, `position_y`=1364.06, `position_z`=-104.262 WHERE `guid`=88017;
|
|
|
|
-- Anubisath Defender (Entry: 15277, Guid: 88015) - DISTANCE 62.1503
|
|
UPDATE `creature` SET `position_x`=-8760.56, `position_y`=1575.33, `position_z`=-89.3109 WHERE `guid`=88015;
|
|
|
|
-- Princess Huhuran (Entry: 15509, Guid: 88014) - DISTANCE 34.3058
|
|
UPDATE `creature` SET `position_x`=-8519.64, `position_y`=1728.46, `position_z`=-91.7956 WHERE `guid`=88014;
|
|
|
|
-- Vekniss Stinger (Entry: 15235, Guid: 88013) - DISTANCE 86.0023
|
|
UPDATE `creature` SET `position_x`=-8602.48, `position_y`=1352.63, `position_z`=-69.923 WHERE `guid`=88013;
|
|
|
|
-- Vekniss Stinger (Entry: 15235, Guid: 88006) - DISTANCE 51.885
|
|
UPDATE `creature` SET `position_x`=-8639.86, `position_y`=1471.86, `position_z`=-69.1247 WHERE `guid`=88006;
|
|
|
|
-- Vekniss Wasp (Entry: 15236, Guid: 88000) - DISTANCE 22.9751
|
|
UPDATE `creature` SET `position_x`=-8567.34, `position_y`=1401.48, `position_z`=-62.1936 WHERE `guid`=88000;
|
|
|
|
-- Vekniss Stinger (Entry: 15235, Guid: 87997) - DISTANCE 86.6248
|
|
UPDATE `creature` SET `position_x`=-8596.82, `position_y`=1644.91, `position_z`=-89.6377 WHERE `guid`=87997;
|
|
|
|
-- Vekniss Stinger (Entry: 15235, Guid: 87992) - DISTANCE 55.1727
|
|
UPDATE `creature` SET `position_x`=-8594.6, `position_y`=1345.97, `position_z`=-69.8594 WHERE `guid`=87992;
|
|
|
|
-- Vekniss Stinger (Entry: 15235, Guid: 87990) - DISTANCE 102.797
|
|
UPDATE `creature` SET `position_x`=-8616.23, `position_y`=1302.48, `position_z`=-68.8102 WHERE `guid`=87990;
|
|
|
|
-- Vekniss Soldier (Entry: 15229, Guid: 87906) - DISTANCE 87.2078
|
|
UPDATE `creature` SET `position_x`=-8160.64, `position_y`=1669.32, `position_z`=-36.0642 WHERE `guid`=87906;
|
|
|
|
-- Vekniss Soldier (Entry: 15229, Guid: 87904) - DISTANCE 22.1819
|
|
UPDATE `creature` SET `position_x`=-7977.78, `position_y`=1572.38, `position_z`=-61.796 WHERE `guid`=87904;
|
|
|
|
-- Vekniss Soldier (Entry: 15229, Guid: 87903) - DISTANCE 22.7108
|
|
UPDATE `creature` SET `position_x`=-7940.78, `position_y`=1491.18, `position_z`=-64.0933 WHERE `guid`=87903;
|
|
|
|
-- Vekniss Soldier (Entry: 15229, Guid: 87901) - DISTANCE 34.4679
|
|
UPDATE `creature` SET `position_x`=-7955.62, `position_y`=1322.46, `position_z`=-90.46 WHERE `guid`=87901;
|
|
|
|
-- Vekniss Warrior (Entry: 15230, Guid: 302242) - DISTANCE 73.65
|
|
UPDATE `creature` SET `position_x`=-8362.54, `position_y`=1832.81, `position_z`=0.789512 WHERE `guid`=302242;
|
|
|
|
-- Sludge Belcher (Entry: 16029, Guid: 88722) - DISTANCE 83.2196
|
|
UPDATE `creature` SET `position_x`=3048.88, `position_y`=-3242.07, `position_z`=293.346 WHERE `guid`=88722;
|
|
|
|
-- Infectious Skitterer (Entry: 15977, Guid: 302442) - DISTANCE 97.2713
|
|
UPDATE `creature` SET `position_x`=3383.74, `position_y`=-3689.38, `position_z`=259.081 WHERE `guid`=302442;
|
|
|
|
-- Spirit of Maraudos (Entry: 12242, Guid: 54684) - DISTANCE 27.2685
|
|
UPDATE `creature` SET `position_x`=813.251, `position_y`=-485.585, `position_z`=-54.8048 WHERE `guid`=54684;
|
|
|
|
-- Cavern Lurker (Entry: 12223, Guid: 54652) - DISTANCE 26.2264
|
|
UPDATE `creature` SET `position_x`=756.757, `position_y`=-82.4439, `position_z`=-57.3813 WHERE `guid`=54652;
|
|
|
|
-- Scarlet Wizard (Entry: 4300, Guid: 39967) - DISTANCE 27.5701
|
|
UPDATE `creature` SET `position_x`=931.463, `position_y`=1438.92, `position_z`=18.6778 WHERE `guid`=39967;
|
|
|
|
-- Scarlet Myrmidon (Entry: 4295, Guid: 39965) - DISTANCE 58.6424
|
|
UPDATE `creature` SET `position_x`=891.195, `position_y`=1362.07, `position_z`=18.6779 WHERE `guid`=39965;
|
|
|
|
-- Stone Steward (Entry: 4860, Guid: 33512) - DISTANCE 27.8862
|
|
UPDATE `creature` SET `position_x`=64.324, `position_y`=239, `position_z`=-52.198 WHERE `guid`=33512;
|
|
|
|
-- Shrike Bat (Entry: 4861, Guid: 33523) - DISTANCE 49.9611
|
|
UPDATE `creature` SET `position_x`=-94.7018, `position_y`=350.589, `position_z`=-49.0758 WHERE `guid`=33523;
|
|
|
|
-- Heartrazor (Entry: 5934, Guid: 51821) - DISTANCE 41.3457
|
|
UPDATE `creature` SET `position_x`=-5183.81, `position_y`=-1170.22, `position_z`=45.1108 WHERE `guid`=51821;
|
|
|
|
-- Rabid Shadowhide Gnoll (Entry: 434, Guid: 10053) - DISTANCE 87.7752
|
|
UPDATE `creature` SET `position_x`=-9292.01, `position_y`=-3240.25, `position_z`=100.649 WHERE `guid`=10053;
|
|
|
|
-- Redridge Mongrel (Entry: 423, Guid: 16349) - DISTANCE 25.8133
|
|
UPDATE `creature` SET `position_x`=-9515.88, `position_y`=-1927.06, `position_z`=76.0861 WHERE `guid`=16349;
|
|
|
|
-- Stonard Grunt (Entry: 866, Guid: 31849) - DISTANCE 43.1806
|
|
UPDATE `creature` SET `position_x`=-10452.4, `position_y`=-3172.52, `position_z`=20.1837 WHERE `guid`=31849;
|
|
|
|
-- Stonard Grunt (Entry: 866, Guid: 31852) - DISTANCE 28.8528
|
|
UPDATE `creature` SET `position_x`=-10464.4, `position_y`=-3171.79, `position_z`=20.1788 WHERE `guid`=31852;
|
|
|
|
-- Stonard Scout (Entry: 861, Guid: 38775) - DISTANCE 205.705
|
|
UPDATE `creature` SET `position_x`=-10390.5, `position_y`=-2693.75, `position_z`=21.6787 WHERE `guid`=38775;
|
|
|
|
-- Stonard Explorer (Entry: 862, Guid: 38818) - DISTANCE 61.531
|
|
UPDATE `creature` SET `position_x`=-10000.3, `position_y`=-3495.59, `position_z`=23.9655 WHERE `guid`=38818;
|
|
|
|
-- Stonard Scout (Entry: 861, Guid: 38885) - DISTANCE 331.071
|
|
UPDATE `creature` SET `position_x`=-10519.6, `position_y`=-3003.42, `position_z`=21.6777 WHERE `guid`=38885;
|
|
|
|
-- Hooktooth Frenzy (Entry: 11374, Guid: 49726) - DISTANCE 26.1901
|
|
UPDATE `creature` SET `position_x`=-11673, `position_y`=-1622.38, `position_z`=8.63866 WHERE `guid`=49726;
|
|
|
|
-- Tormented Spirit (Entry: 1533, Guid: 49222) - DISTANCE 41.7437
|
|
UPDATE `creature` SET `position_x`=2894.92, `position_y`=1012.92, `position_z`=108.181 WHERE `guid`=49222;
|
|
|
|
-- Scarlet Zealot (Entry: 1537, Guid: 28454) - DISTANCE 61.2224
|
|
UPDATE `creature` SET `position_x`=2509.13, `position_y`=-864.439, `position_z`=54.8237 WHERE `guid`=28454;
|
|
|
|
-- Deathguard Oliver (Entry: 1737, Guid: 28706) - DISTANCE 29.7809
|
|
UPDATE `creature` SET `position_x`=1799.53, `position_y`=1603.17, `position_z`=103.109 WHERE `guid`=28706;
|
|
|
|
-- Deathguard Terrence (Entry: 1738, Guid: 29779) - DISTANCE 83.7968
|
|
UPDATE `creature` SET `position_x`=2050.22, `position_y`=161.417, `position_z`=33.8209 WHERE `guid`=29779;
|
|
|
|
-- Apothecary Katrina (Entry: 5732, Guid: 31872) - DISTANCE 44.9962
|
|
UPDATE `creature` SET `position_x`=1535.91, `position_y`=275.839, `position_z`=-62.1765 WHERE `guid`=31872;
|
|
|
|
-- Sahvan Bloodshadow (Entry: 2314, Guid: 31919) - DISTANCE 53.9059
|
|
UPDATE `creature` SET `position_x`=2287.42, `position_y`=395.81, `position_z`=34.0751 WHERE `guid`=31919;
|
|
|
|
-- Rotting Ancestor (Entry: 1530, Guid: 31933) - DISTANCE 23.0986
|
|
UPDATE `creature` SET `position_x`=2937.72, `position_y`=603.598, `position_z`=92.0832 WHERE `guid`=31933;
|
|
|
|
-- Deathguard Lundmark (Entry: 5725, Guid: 32028) - DISTANCE 110.02
|
|
UPDATE `creature` SET `position_x`=2257.14, `position_y`=494.395, `position_z`=34.1876 WHERE `guid`=32028;
|
|
|
|
-- Scarlet Zealot (Entry: 1537, Guid: 33699) - DISTANCE 40.6983
|
|
UPDATE `creature` SET `position_x`=2490.5, `position_y`=-897.067, `position_z`=59.7591 WHERE `guid`=33699;
|
|
|
|
-- Undercity Guardian (Entry: 5624, Guid: 34103) - DISTANCE 29.8849
|
|
UPDATE `creature` SET `position_x`=1766.93, `position_y`=187.42, `position_z`=-62.177 WHERE `guid`=34103;
|
|
|
|
-- Scarlet Missionary (Entry: 1536, Guid: 37880) - DISTANCE 22.9189
|
|
UPDATE `creature` SET `position_x`=1901.81, `position_y`=901.916, `position_z`=29.3636 WHERE `guid`=37880;
|
|
|
|
-- Vile Fin Minor Oracle (Entry: 1544, Guid: 37899) - DISTANCE 34.8538
|
|
UPDATE `creature` SET `position_x`=2488.02, `position_y`=1718.95, `position_z`=24.1242 WHERE `guid`=37899;
|
|
|
|
-- Apothecary Lycanus (Entry: 5733, Guid: 38093) - DISTANCE 33.2439
|
|
UPDATE `creature` SET `position_x`=1479.41, `position_y`=372.664, `position_z`=-62.1858 WHERE `guid`=38093;
|
|
|
|
-- Susan Tillinghast (Entry: 2802, Guid: 38101) - DISTANCE 105.48
|
|
UPDATE `creature` SET `position_x`=1378.64, `position_y`=55.965, `position_z`=-62.2767 WHERE `guid`=38101;
|
|
|
|
-- Vile Fin Muckdweller (Entry: 1545, Guid: 38276) - DISTANCE 25.5782
|
|
UPDATE `creature` SET `position_x`=3013.64, `position_y`=-330.231, `position_z`=7.41186 WHERE `guid`=38276;
|
|
|
|
-- Hamlin Atkins (Entry: 3547, Guid: 38292) - DISTANCE 60.5605
|
|
UPDATE `creature` SET `position_x`=2310.18, `position_y`=397.315, `position_z`=33.9347 WHERE `guid`=38292;
|
|
|
|
-- Wandering Spirit (Entry: 1532, Guid: 38393) - DISTANCE 32.782
|
|
UPDATE `creature` SET `position_x`=2064.66, `position_y`=-392.215, `position_z`=37.7685 WHERE `guid`=38393;
|
|
|
|
-- Morley Bates (Entry: 4571, Guid: 38421) - DISTANCE 70.0297
|
|
UPDATE `creature` SET `position_x`=1759.66, `position_y`=131.193, `position_z`=-62.297 WHERE `guid`=38421;
|
|
|
|
-- Ressan the Needler (Entry: 10357, Guid: 42141) - DISTANCE 28.8223
|
|
UPDATE `creature` SET `position_x`=1776.26, `position_y`=1086.54, `position_z`=50.2121 WHERE `guid`=42141;
|
|
|
|
-- Fellicent's Shade (Entry: 10358, Guid: 42143) - DISTANCE 91.9406
|
|
UPDATE `creature` SET `position_x`=1998.46, `position_y`=-444.433, `position_z`=34.65 WHERE `guid`=42143;
|
|
|
|
-- Tirisfal Farmer (Entry: 1934, Guid: 42152) - DISTANCE 38.3305
|
|
UPDATE `creature` SET `position_x`=2320.31, `position_y`=1335.49, `position_z`=33.4583 WHERE `guid`=42152;
|
|
|
|
-- Vile Fin Minor Oracle (Entry: 1544, Guid: 43614) - DISTANCE 35.3869
|
|
UPDATE `creature` SET `position_x`=2579.05, `position_y`=1390.08, `position_z`=1.87354 WHERE `guid`=43614;
|
|
|
|
-- Muad (Entry: 1910, Guid: 43909) - DISTANCE 31.506
|
|
UPDATE `creature` SET `position_x`=2531.54, `position_y`=1394.83, `position_z`=3.20068 WHERE `guid`=43909;
|
|
|
|
-- Scarlet Warrior (Entry: 1535, Guid: 44259) - DISTANCE 49.1864
|
|
UPDATE `creature` SET `position_x`=2353.76, `position_y`=1577.24, `position_z`=33.9528 WHERE `guid`=44259;
|
|
|
|
-- Rot Hide Graverobber (Entry: 1941, Guid: 44602) - DISTANCE 35.9481
|
|
UPDATE `creature` SET `position_x`=2553.74, `position_y`=613.883, `position_z`=25.5977 WHERE `guid`=44602;
|
|
|
|
-- Rot Hide Mongrel (Entry: 1675, Guid: 44615) - DISTANCE 106.991
|
|
UPDATE `creature` SET `position_x`=2707.7, `position_y`=386.022, `position_z`=26.4345 WHERE `guid`=44615;
|
|
|
|
-- Rot Hide Mongrel (Entry: 1675, Guid: 44682) - DISTANCE 77.4417
|
|
UPDATE `creature` SET `position_x`=2778.66, `position_y`=436.464, `position_z`=19.1103 WHERE `guid`=44682;
|
|
|
|
-- Scarlet Preserver (Entry: 4280, Guid: 44787) - DISTANCE 62.9511
|
|
UPDATE `creature` SET `position_x`=2938.72, `position_y`=-700.863, `position_z`=148.848 WHERE `guid`=44787;
|
|
|
|
-- Scarlet Preserver (Entry: 4280, Guid: 44904) - DISTANCE 47.6004
|
|
UPDATE `creature` SET `position_x`=2921.4, `position_y`=-666.92, `position_z`=141.957 WHERE `guid`=44904;
|
|
|
|
-- Scarlet Warrior (Entry: 1535, Guid: 44909) - DISTANCE 40.9654
|
|
UPDATE `creature` SET `position_x`=2385.62, `position_y`=1323.61, `position_z`=33.9811 WHERE `guid`=44909;
|
|
|
|
-- Thurman Agamand (Entry: 1656, Guid: 44988) - DISTANCE 61.9114
|
|
UPDATE `creature` SET `position_x`=2878.92, `position_y`=1073.58, `position_z`=109.379 WHERE `guid`=44988;
|
|
|
|
-- Hungering Dead (Entry: 1527, Guid: 45120) - DISTANCE 36.4985
|
|
UPDATE `creature` SET `position_x`=2562.26, `position_y`=-82.1759, `position_z`=28.055 WHERE `guid`=45120;
|
|
|
|
-- Rotting Dead (Entry: 1525, Guid: 45147) - DISTANCE 29.4116
|
|
UPDATE `creature` SET `position_x`=2251.14, `position_y`=642.057, `position_z`=24.8747 WHERE `guid`=45147;
|
|
|
|
-- Rotting Dead (Entry: 1525, Guid: 45178) - DISTANCE 72.5023
|
|
UPDATE `creature` SET `position_x`=2200.64, `position_y`=558.809, `position_z`=31.0019 WHERE `guid`=45178;
|
|
|
|
-- Green Sludge (Entry: 2655, Guid: 92995) - DISTANCE 38.1888
|
|
UPDATE `creature` SET `position_x`=362.092, `position_y`=-3869.86, `position_z`=106.015 WHERE `guid`=92995;
|
|
|
|
-- Vilebranch Headhunter (Entry: 2641, Guid: 93634) - DISTANCE 30.2651
|
|
UPDATE `creature` SET `position_x`=-295.688, `position_y`=-4087.87, `position_z`=152.484 WHERE `guid`=93634;
|
|
|
|
-- Vilebranch Headhunter (Entry: 2641, Guid: 93755) - DISTANCE 26.5515
|
|
UPDATE `creature` SET `position_x`=-345.444, `position_y`=-4114.75, `position_z`=151.954 WHERE `guid`=93755;
|
|
|
|
-- Stone Fury (Entry: 2258, Guid: 63913) - DISTANCE 28.8563
|
|
UPDATE `creature` SET `position_x`=652.451, `position_y`=-1464.72, `position_z`=77.6166 WHERE `guid`=63913;
|
|
|
|
-- Sri'skulk (Entry: 10359, Guid: 86604) - DISTANCE 20.1605
|
|
UPDATE `creature` SET `position_x`=2267.73, `position_y`=-948.026, `position_z`=77.5319 WHERE `guid`=86604;
|
|
|
|
-- Winterfall Shaman (Entry: 7439, Guid: 41029) - DISTANCE 28.2685
|
|
UPDATE `creature` SET `position_x`=6672.99, `position_y`=-5123.82, `position_z`=776.628 WHERE `guid`=41029;
|
|
|
|
-- Winterfall Den Watcher (Entry: 7440, Guid: 41044) - DISTANCE 74.5921
|
|
UPDATE `creature` SET `position_x`=6896.05, `position_y`=-5145.93, `position_z`=698.456 WHERE `guid`=41044;
|
|
|
|
-- High Chief Winterfall (Entry: 10738, Guid: 42315) - DISTANCE 21.3497
|
|
UPDATE `creature` SET `position_x`=6726.22, `position_y`=-5275.99, `position_z`=778.305 WHERE `guid`=42315;
|
|
|
|
-- Twilight Prophet (Entry: 15308, Guid: 300750) - DISTANCE 48.8713
|
|
UPDATE `creature` SET `position_x`=-6884.11, `position_y`=1685.24, `position_z`=4.14966 WHERE `guid`=300750;
|
|
|
|
-- Uruson (Entry: 14428, Guid: 46350) - DISTANCE 48.5908
|
|
UPDATE `creature` SET `position_x`=9816.84, `position_y`=355.442, `position_z`=1308.46 WHERE `guid`=46350;
|
|
|
|
-- Fury Shelda (Entry: 14431, Guid: 46352) - DISTANCE 21.6991
|
|
UPDATE `creature` SET `position_x`=10630.1, `position_y`=2031.82, `position_z`=1331.57 WHERE `guid`=46352;
|
|
|
|
-- Threggil (Entry: 14432, Guid: 46354) - DISTANCE 28.8454
|
|
UPDATE `creature` SET `position_x`=10115.9, `position_y`=1167.52, `position_z`=1314.17 WHERE `guid`=46354;
|
|
|
|
-- Alaindia (Entry: 3562, Guid: 49525) - DISTANCE 71.4446
|
|
UPDATE `creature` SET `position_x`=9745.69, `position_y`=2622.56, `position_z`=1334.35 WHERE `guid`=49525;
|
|
|
|
-- Wandering Forest Walker (Entry: 7584, Guid: 50798) - DISTANCE 32.6003
|
|
UPDATE `creature` SET `position_x`=-4500.91, `position_y`=-310.469, `position_z`=56.3275 WHERE `guid`=50798;
|
|
|
|
-- Wandering Forest Walker (Entry: 7584, Guid: 50799) - DISTANCE 32.3368
|
|
UPDATE `creature` SET `position_x`=-4593.05, `position_y`=1898.65, `position_z`=109.435 WHERE `guid`=50799;
|
|
|
|
-- Wandering Forest Walker (Entry: 7584, Guid: 50801) - DISTANCE 31.8991
|
|
UPDATE `creature` SET `position_x`=-5149.84, `position_y`=686.696, `position_z`=56.017 WHERE `guid`=50801;
|
|
|
|
-- Shatterspear Troll (Entry: 10919, Guid: 85556) - DISTANCE 135.25
|
|
UPDATE `creature` SET `position_x`=7483.99, `position_y`=-1538.9, `position_z`=160.299 WHERE `guid`=85556;
|
|
|
|
-- Eye of Naxxramas (Entry: 10411, Guid: 300837) - DISTANCE 30.0243
|
|
UPDATE `creature` SET `position_x`=3602.92, `position_y`=-3488.06, `position_z`=135.879 WHERE `guid`=300837;
|
|
|
|
-- Gordok Mage-Lord (Entry: 11444, Guid: 201698) - DISTANCE 91.6447
|
|
UPDATE `creature` SET `position_x`=386.408, `position_y`=340.569, `position_z`=2.865 WHERE `guid`=201698;
|
|
|
|
-- Spirestone Enforcer (Entry: 9199, Guid: 300743) - DISTANCE 34.838
|
|
UPDATE `creature` SET `position_x`=-36.8595, `position_y`=-487.712, `position_z`=29.3984 WHERE `guid`=300743;
|
|
|
|
-- Bloodaxe Veteran (Entry: 9583, Guid: 46656) - DISTANCE 26.6868
|
|
UPDATE `creature` SET `position_x`=-53.7135, `position_y`=-469.51, `position_z`=77.8413 WHERE `guid`=46656;
|
|
|
|
-- Warpwood Crusher (Entry: 13021, Guid: 300898) - DISTANCE 31.7512
|
|
UPDATE `creature` SET `position_x`=189.555, `position_y`=-424.202, `position_z`=-79.6913 WHERE `guid`=300898;
|
|
|
|
-- Warpwood Stomper (Entry: 11465, Guid: 300939) - DISTANCE 23.1702
|
|
UPDATE `creature` SET `position_x`=55.6736, `position_y`=-347.474, `position_z`=-4.05314 WHERE `guid`=300939;
|
|
|
|
-- Warlord Gorchuk (Entry: 15700, Guid: 111000) - DISTANCE 21.6113
|
|
UPDATE `creature` SET `position_x`=1580.67, `position_y`=-4203.17, `position_z`=41.6943 WHERE `guid`=111000;
|
|
|
|
-- Flesh Hunter (Entry: 15335, Guid: 301210) - DISTANCE 22.1786
|
|
UPDATE `creature` SET `position_x`=-8957.75, `position_y`=2062.7, `position_z`=21.3864 WHERE `guid`=301210;
|
|
|
|
-- Flesh Hunter (Entry: 15335, Guid: 301212) - DISTANCE 23.6245
|
|
UPDATE `creature` SET `position_x`=-8945.14, `position_y`=2024.45, `position_z`=21.4883 WHERE `guid`=301212;
|
|
|
|
-- Obsidian Destroyer (Entry: 15338, Guid: 301173) - DISTANCE 24.7636
|
|
UPDATE `creature` SET `position_x`=-9089.98, `position_y`=1758.47, `position_z`=21.4012 WHERE `guid`=301173;
|
|
|
|
-- Obsidian Destroyer (Entry: 15338, Guid: 301213) - DISTANCE 24.5767
|
|
UPDATE `creature` SET `position_x`=-8815.17, `position_y`=2174.1, `position_z`=21.3869 WHERE `guid`=301213;
|
|
|
|
-- Qiraji Swarmguard (Entry: 15343, Guid: 301050) - DISTANCE 24.0996
|
|
UPDATE `creature` SET `position_x`=-8704.12, `position_y`=1501.23, `position_z`=31.9074 WHERE `guid`=301050;
|
|
|
|
-- Qiraji Swarmguard (Entry: 15343, Guid: 301049) - DISTANCE 28.1327
|
|
UPDATE `creature` SET `position_x`=-8674.82, `position_y`=1545.76, `position_z`=31.9072 WHERE `guid`=301049;
|
|
|
|
-- Anubisath Guardian (Entry: 15355, Guid: 301167) - DISTANCE 42.8678
|
|
UPDATE `creature` SET `position_x`=-9306.39, `position_y`=1735.94, `position_z`=85.5565 WHERE `guid`=301167;
|
|
|
|
-- Anubisath Guardian (Entry: 15355, Guid: 301162) - DISTANCE 59.6829
|
|
UPDATE `creature` SET `position_x`=-9316.09, `position_y`=2059.03, `position_z`=85.5797 WHERE `guid`=301162;
|
|
|
|
-- Anubisath Guardian (Entry: 15355, Guid: 301163) - DISTANCE 55.9603
|
|
UPDATE `creature` SET `position_x`=-9252.1, `position_y`=1949.63, `position_z`=85.5559 WHERE `guid`=301163;
|
|
|
|
-- Anubisath Guardian (Entry: 15355, Guid: 301164) - DISTANCE 180.825
|
|
UPDATE `creature` SET `position_x`=-9370.13, `position_y`=1967.31, `position_z`=85.5561 WHERE `guid`=301164;
|
|
|
|
-- Anubisath Guardian (Entry: 15355, Guid: 301165) - DISTANCE 127.9
|
|
UPDATE `creature` SET `position_x`=-9522.85, `position_y`=1855.63, `position_z`=85.5569 WHERE `guid`=301165;
|
|
|
|
-- Anubisath Guardian (Entry: 15355, Guid: 301166) - DISTANCE 106.848
|
|
UPDATE `creature` SET `position_x`=-9367.43, `position_y`=1751.65, `position_z`=85.5567 WHERE `guid`=301166;
|
|
|
|
-- Anubisath Guardian (Entry: 15355, Guid: 301161) - DISTANCE 62.3427
|
|
UPDATE `creature` SET `position_x`=-9318.23, `position_y`=1894.67, `position_z`=85.5561 WHERE `guid`=301161;
|
|
|
|
-- Frostwolf Legionnaire (Entry: 12051, Guid: 301559) - DISTANCE 30.1124
|
|
UPDATE `creature` SET `position_x`=-932.92, `position_y`=-391.729, `position_z`=49.0348 WHERE `guid`=301559;
|
|
|
|
-- Dark Iron Ambassador (Entry: 6228, Guid: 300376) - DISTANCE 21.6424
|
|
UPDATE `creature` SET `position_x`=-698.351, `position_y`=559.918, `position_z`=-282.06 WHERE `guid`=300376;
|
|
|
|
-- Princess Tempestria (Entry: 14457, Guid: 301305) - DISTANCE 21.0009
|
|
UPDATE `creature` SET `position_x`=6497.36, `position_y`=-4051.48, `position_z`=658.47 WHERE `guid`=301305;
|
|
|
|
-- Meshlok the Harvester (Entry: 12237, Guid: 301710) - DISTANCE 26.2264
|
|
UPDATE `creature` SET `position_x`=756.757, `position_y`=-82.4439, `position_z`=-57.3813 WHERE `guid`=301710;
|
|
|
|
-- Sand Shark (Entry: 5435, Guid: 3514) - DISTANCE 29.2156
|
|
UPDATE `creature` SET `position_x`=3195.66, `position_y`=1723.26, `position_z`=-48.0417 WHERE `guid`=3514;
|
|
|
|
-- Sand Shark (Entry: 5435, Guid: 3515) - DISTANCE 30.4117
|
|
UPDATE `creature` SET `position_x`=3219.86, `position_y`=1066.66, `position_z`=-48.8948 WHERE `guid`=3515;
|
|
|
|
-- Sand Shark (Entry: 5435, Guid: 3518) - DISTANCE 31.8306
|
|
UPDATE `creature` SET `position_x`=1254.18, `position_y`=-5419.49, `position_z`=-52.4718 WHERE `guid`=3518;
|
|
|
|
-- Sand Shark (Entry: 5435, Guid: 3520) - DISTANCE 23.6292
|
|
UPDATE `creature` SET `position_x`=478.163, `position_y`=-5354.21, `position_z`=-43.7743 WHERE `guid`=3520;
|
|
|
|
-- Sand Shark (Entry: 5435, Guid: 3521) - DISTANCE 29.1417
|
|
UPDATE `creature` SET `position_x`=-348.067, `position_y`=-5577.97, `position_z`=-32.65 WHERE `guid`=3521;
|
|
|
|
-- Sand Shark (Entry: 5435, Guid: 3522) - DISTANCE 32.0907
|
|
UPDATE `creature` SET `position_x`=-608.189, `position_y`=-5817.86, `position_z`=-33.709 WHERE `guid`=3522;
|
|
|
|
-- Sand Shark (Entry: 5435, Guid: 3523) - DISTANCE 30.3414
|
|
UPDATE `creature` SET `position_x`=-1414.72, `position_y`=-5785.94, `position_z`=-18.2885 WHERE `guid`=3523;
|
|
|
|
-- Sand Shark (Entry: 5435, Guid: 3525) - DISTANCE 31.5451
|
|
UPDATE `creature` SET `position_x`=-1142.71, `position_y`=-4322.34, `position_z`=-7.51439 WHERE `guid`=3525;
|
|
|
|
-- Qiraji Scarab (Entry: 15316, Guid: 302348) - DISTANCE 20.1274
|
|
UPDATE `creature` SET `position_x`=-8942.15, `position_y`=1502.37, `position_z`=-92.8114 WHERE `guid`=302348;
|
|
|
|
-- Seasoned Legionnaire (Entry: 13329, Guid: 302070) - DISTANCE 30.1124
|
|
UPDATE `creature` SET `position_x`=-932.92, `position_y`=-391.729, `position_z`=49.0348 WHERE `guid`=302070;
|
|
|
|
-- Veteran Legionnaire (Entry: 13334, Guid: 302096) - DISTANCE 30.1124
|
|
UPDATE `creature` SET `position_x`=-932.92, `position_y`=-391.729, `position_z`=49.0348 WHERE `guid`=302096;
|
|
|
|
-- Champion Legionnaire (Entry: 13425, Guid: 302122) - DISTANCE 30.1124
|
|
UPDATE `creature` SET `position_x`=-932.92, `position_y`=-391.729, `position_z`=49.0348 WHERE `guid`=302122;
|
|
|
|
-- Unholy Axe (Entry: 16194, Guid: 127798) - DISTANCE 22.7451
|
|
UPDATE `creature` SET `position_x`=2711.64, `position_y`=-3157.39, `position_z`=267.522 WHERE `guid`=127798;
|
|
|
|
-- Stoneskin Gargoyle (Entry: 16168, Guid: 88094) - DISTANCE 24.5039
|
|
UPDATE `creature` SET `position_x`=2872.72, `position_y`=-3489.73, `position_z`=297.62 WHERE `guid`=88094;
|
|
|
|
-- Ancient Core Hound (Entry: 11673, Guid: 56864) - DISTANCE 32.2084
|
|
UPDATE `creature` SET `position_x`=733.284, `position_y`=-1027.08, `position_z`=-177.554 WHERE `guid`=56864;
|
|
|
|
-- Stone Steward (Entry: 4860, Guid: 28606) - DISTANCE 25.3807
|
|
UPDATE `creature` SET `position_x`=154.882, `position_y`=284.294, `position_z`=-26.582 WHERE `guid`=28606;
|
|
|
|
-- Stone Steward (Entry: 4860, Guid: 28609) - DISTANCE 27.8862
|
|
UPDATE `creature` SET `position_x`=64.324, `position_y`=239, `position_z`=-52.198 WHERE `guid`=28609;
|
|
|
|
-- Caer Darrow Citizen (Entry: 11277, Guid: 120) - DISTANCE 31.8787
|
|
UPDATE `creature` SET `position_x`=1174.25, `position_y`=-2610.72, `position_z`=72.8297 WHERE `guid`=120;
|
|
|
|
-- Caer Darrow Horseman (Entry: 11281, Guid: 130) - DISTANCE 79.4371
|
|
UPDATE `creature` SET `position_x`=1120.64, `position_y`=-2594.72, `position_z`=59.5809 WHERE `guid`=130;
|
|
|
|
-- Silithid Invader (Entry: 4131, Guid: 21301) - DISTANCE 65.9803
|
|
DELETE FROM `creature_movement` WHERE `id`=21301;
|
|
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `wander_distance`, `script_id`, `path_id`) VALUES
|
|
(21301, 1, -6495.35, -3367.55, -89.0774, 100, 0, 0, 0, 0),
|
|
(21301, 2, -6493.97, -3348.59, -92.5439, 100, 0, 0, 0, 0),
|
|
(21301, 3, -6495.18, -3334.86, -94.153, 100, 0, 0, 0, 0),
|
|
(21301, 4, -6496.86, -3323.53, -96.288, 100, 0, 0, 0, 0),
|
|
(21301, 5, -6504.16, -3314.49, -96.7209, 100, 0, 0, 0, 0),
|
|
(21301, 6, -6496.86, -3323.53, -96.288, 100, 0, 0, 0, 0),
|
|
(21301, 7, -6495.18, -3334.86, -94.153, 100, 0, 0, 0, 0),
|
|
(21301, 8, -6493.97, -3348.59, -92.5439, 100, 0, 0, 0, 0),
|
|
(21301, 9, -6495.35, -3367.55, -89.0774, 100, 0, 0, 0, 0),
|
|
(21301, 10, -6493.24, -3390.72, -81.2351, 100, 0, 0, 0, 0),
|
|
(21301, 11, -6487.62, -3414.51, -73.0746, 100, 0, 0, 0, 0),
|
|
(21301, 12, -6479.16, -3423.18, -70.6095, 100, 0, 0, 0, 0),
|
|
(21301, 13, -6470.08, -3433.21, -69.9093, 100, 0, 0, 0, 0),
|
|
(21301, 14, -6479.16, -3423.18, -70.6095, 100, 0, 0, 0, 0),
|
|
(21301, 15, -6487.62, -3414.51, -73.0746, 100, 0, 0, 0, 0),
|
|
(21301, 16, -6493.24, -3390.72, -81.2351, 100, 0, 0, 0, 0);
|
|
|
|
-- Bael'dun Foreman (Entry: 3375, Guid: 13630) - DISTANCE 22.0757
|
|
DELETE FROM `creature_movement` WHERE `id`=13630;
|
|
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `wander_distance`, `script_id`, `path_id`) VALUES
|
|
(13630, 1, -4127.55, -2205.4, 50.3081, 100, 0, 0, 0, 0),
|
|
(13630, 2, -4135.23, -2193.78, 50.5771, 100, 0, 0, 0, 0),
|
|
(13630, 3, -4127.55, -2205.4, 50.3081, 100, 0, 0, 0, 0),
|
|
(13630, 4, -4123.61, -2212.48, 50.3081, 100, 0, 0, 0, 0),
|
|
(13630, 5, -4122.99, -2223.7, 50.3081, 100, 0, 0, 0, 0),
|
|
(13630, 6, -4125.27, -2232.49, 50.2779, 100, 0, 0, 0, 0),
|
|
(13630, 7, -4133.66, -2234.24, 51.3354, 100, 0, 0, 0, 0),
|
|
(13630, 8, -4137.54, -2229.22, 51.3081, 100, 0, 0, 0, 0),
|
|
(13630, 9, -4140.75, -2227.05, 51.0874, 100, 0, 0, 0, 0),
|
|
(13630, 10, -4155.08, -2233.98, 52.1155, 100, 0, 0, 0, 0),
|
|
(13630, 11, -4165.56, -2233.08, 51.9106, 100, 0, 0, 0, 0),
|
|
(13630, 12, -4155.08, -2233.98, 52.1155, 100, 0, 0, 0, 0),
|
|
(13630, 13, -4140.75, -2227.05, 51.0874, 100, 0, 0, 0, 0),
|
|
(13630, 14, -4137.54, -2229.22, 51.3081, 100, 0, 0, 0, 0),
|
|
(13630, 15, -4133.66, -2234.24, 51.3354, 100, 0, 0, 0, 0),
|
|
(13630, 16, -4125.27, -2232.49, 50.2779, 100, 0, 0, 0, 0),
|
|
(13630, 17, -4122.99, -2223.7, 50.3081, 100, 0, 0, 0, 0),
|
|
(13630, 18, -4123.61, -2212.48, 50.3081, 100, 0, 0, 0, 0);
|
|
|
|
-- Prowler (Entry: 118, Guid: 80878) - DISTANCE 34.6983
|
|
DELETE FROM `creature_movement` WHERE `id`=80878;
|
|
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `wander_distance`, `script_id`, `path_id`) VALUES
|
|
(80878, 1, -9663.99, -1091.1, 42.6487, 3.85509, 0, 0, 0, 0),
|
|
(80878, 2, -9665.92, -1118.42, 40.462, 4.31454, 0, 0, 0, 0),
|
|
(80878, 3, -9688.89, -1137.12, 39.7716, 3.53503, 0, 0, 0, 0),
|
|
(80878, 4, -9721.8, -1129.75, 39.0381, 0.487688, 0, 0, 0, 0),
|
|
(80878, 5, -9710.44, -1109.61, 40.8079, 0.572118, 0, 0, 0, 0),
|
|
(80878, 6, -9689.68, -1084.73, 43.2639, 6.27215, 0, 0, 0, 0);
|
|
|
|
-- Noboru the Cudgel (Entry: 5477, Guid: 43588) - DISTANCE 54.1184
|
|
DELETE FROM `creature_movement_template` WHERE `entry`=5477;
|
|
INSERT INTO `creature_movement_template` (`entry`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `wander_distance`, `script_id`, `path_id`) VALUES
|
|
(5477, 1, -10174.8, -3505.8, 23.7408, 100, 0, 0, 0, 0),
|
|
(5477, 2, -10199.3, -3489.02, 22.8962, 100, 0, 0, 0, 0),
|
|
(5477, 3, -10209, -3470.28, 23.3629, 100, 0, 0, 0, 0),
|
|
(5477, 4, -10218.2, -3447.07, 22.5072, 100, 0, 0, 0, 0),
|
|
(5477, 5, -10217.2, -3422.07, 20.8741, 100, 0, 0, 0, 0),
|
|
(5477, 6, -10212, -3382.25, 23.2532, 100, 0, 0, 0, 0),
|
|
(5477, 7, -10210.8, -3339.04, 24.305, 100, 0, 0, 0, 0),
|
|
(5477, 8, -10208.2, -3308.25, 22.0216, 100, 0, 0, 0, 0),
|
|
(5477, 9, -10212.2, -3288.99, 20.0313, 100, 0, 0, 0, 0),
|
|
(5477, 10, -10179, -3269.54, 22.2975, 100, 0, 0, 0, 0),
|
|
(5477, 11, -10151.5, -3240.29, 20.4441, 100, 0, 0, 0, 0),
|
|
(5477, 12, -10135.2, -3221.29, 22.1103, 100, 0, 0, 0, 0),
|
|
(5477, 13, -10111.2, -3191.96, 20.9952, 100, 0, 0, 0, 0),
|
|
(5477, 14, -10116.9, -3159.72, 23.3619, 100, 0, 0, 0, 0),
|
|
(5477, 15, -10152.5, -3146.05, 20.6287, 100, 0, 0, 0, 0),
|
|
(5477, 16, -10168.9, -3113.72, 22.3261, 100, 0, 0, 0, 0),
|
|
(5477, 17, -10202.7, -3103.91, 24.0405, 100, 0, 0, 0, 0),
|
|
(5477, 18, -10240.6, -3097.67, 21.9894, 100, 0, 0, 0, 0),
|
|
(5477, 19, -10282.7, -3092.74, 23.1742, 100, 0, 0, 0, 0),
|
|
(5477, 20, -10309.5, -3074.63, 23.089, 100, 0, 0, 0, 0),
|
|
(5477, 21, -10332, -3065.28, 23.2697, 100, 0, 0, 0, 0),
|
|
(5477, 22, -10319.3, -3044.58, 22.3082, 100, 0, 0, 0, 0),
|
|
(5477, 23, -10300.3, -3007.03, 21.1229, 100, 0, 0, 0, 0),
|
|
(5477, 24, -10294.1, -2991.93, 22.4369, 100, 0, 0, 0, 0),
|
|
(5477, 25, -10272.6, -2989.19, 22.0135, 100, 0, 0, 0, 0),
|
|
(5477, 26, -10239.6, -2988.48, 22.004, 100, 0, 0, 0, 0),
|
|
(5477, 27, -10219.9, -2974.81, 19.835, 100, 0, 0, 0, 0),
|
|
(5477, 28, -10189.1, -2962.12, 22.0984, 100, 0, 0, 0, 0),
|
|
(5477, 29, -10178.9, -2963.05, 23.438, 100, 0, 0, 0, 0),
|
|
(5477, 30, -10189.1, -2962.12, 22.0984, 100, 0, 0, 0, 0),
|
|
(5477, 31, -10219.9, -2974.81, 19.835, 100, 0, 0, 0, 0),
|
|
(5477, 32, -10239.5, -2988.48, 22.0182, 100, 0, 0, 0, 0),
|
|
(5477, 33, -10272.6, -2989.19, 22.0135, 100, 0, 0, 0, 0),
|
|
(5477, 34, -10294.1, -2991.93, 22.4369, 100, 0, 0, 0, 0),
|
|
(5477, 35, -10300.3, -3007.03, 21.1229, 100, 0, 0, 0, 0),
|
|
(5477, 36, -10319.3, -3044.58, 22.3082, 100, 0, 0, 0, 0),
|
|
(5477, 37, -10332, -3065.28, 23.2697, 100, 0, 0, 0, 0),
|
|
(5477, 38, -10309.5, -3074.63, 23.089, 100, 0, 0, 0, 0),
|
|
(5477, 39, -10282.7, -3092.74, 23.1742, 100, 0, 0, 0, 0),
|
|
(5477, 40, -10240.6, -3097.67, 21.9894, 100, 0, 0, 0, 0),
|
|
(5477, 41, -10202.7, -3103.91, 24.0405, 100, 0, 0, 0, 0),
|
|
(5477, 42, -10168.9, -3113.72, 22.3261, 100, 0, 0, 0, 0),
|
|
(5477, 43, -10152.5, -3146.05, 20.6287, 100, 0, 0, 0, 0),
|
|
(5477, 44, -10116.9, -3159.72, 23.3619, 100, 0, 0, 0, 0),
|
|
(5477, 45, -10111.2, -3191.96, 20.9952, 100, 0, 0, 0, 0),
|
|
(5477, 46, -10135.2, -3221.29, 22.1103, 100, 0, 0, 0, 0),
|
|
(5477, 47, -10151.5, -3240.29, 20.4441, 100, 0, 0, 0, 0),
|
|
(5477, 48, -10179, -3269.54, 22.2975, 100, 0, 0, 0, 0),
|
|
(5477, 49, -10212.2, -3288.99, 20.0313, 100, 0, 0, 0, 0),
|
|
(5477, 50, -10208.2, -3308.25, 22.0216, 100, 0, 0, 0, 0),
|
|
(5477, 51, -10210.8, -3339.04, 24.305, 100, 0, 0, 0, 0),
|
|
(5477, 52, -10212, -3382.25, 23.2532, 100, 0, 0, 0, 0),
|
|
(5477, 53, -10217.2, -3422.07, 20.7496, 100, 0, 0, 0, 0),
|
|
(5477, 54, -10218.3, -3447.07, 22.4278, 100, 0, 0, 0, 0),
|
|
(5477, 55, -10209, -3470.28, 23.3629, 100, 0, 0, 0, 0),
|
|
(5477, 56, -10199.3, -3489.02, 22.8962, 100, 0, 0, 0, 0);
|
|
|
|
-- Ancient Core Hound (Entry: 11673, Guid: 56854) - DISTANCE 25.5012
|
|
DELETE FROM `creature_movement` WHERE `id`=56854;
|
|
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `wander_distance`, `script_id`, `path_id`) VALUES
|
|
(56854, 1, 816.582, -641.068, -203.889, 100, 0, 0, 0, 0),
|
|
(56854, 2, 831.386, -627.893, -203.149, 100, 0, 0, 0, 0),
|
|
(56854, 3, 856.456, -617.906, -202.157, 100, 0, 0, 0, 0),
|
|
(56854, 4, 899.612, -613.543, -202.238, 100, 0, 0, 0, 0),
|
|
(56854, 5, 936.253, -612.5, -203.622, 100, 0, 0, 0, 0),
|
|
(56854, 6, 975.182, -641.047, -201.577, 100, 0, 0, 0, 0),
|
|
(56854, 7, 1002.31, -661.99, -194.192, 100, 0, 0, 0, 0),
|
|
(56854, 8, 1024.07, -684.312, -173.43, 100, 0, 0, 0, 0),
|
|
(56854, 9, 1042.02, -695.821, -163.758, 100, 0, 0, 0, 0),
|
|
(56854, 10, 1058.16, -706.078, -156.611, 100, 0, 0, 0, 0),
|
|
(56854, 11, 1068.57, -742.832, -151.733, 100, 0, 0, 0, 0),
|
|
(56854, 12, 1117.1, -744.479, -145.629, 100, 0, 0, 0, 0),
|
|
(56854, 13, 1149.46, -726.451, -133.804, 100, 0, 0, 0, 0),
|
|
(56854, 14, 1175.51, -702.176, -130.987, 100, 0, 0, 0, 0),
|
|
(56854, 15, 1200.5, -670.934, -128.545, 100, 0, 0, 0, 0),
|
|
(56854, 16, 1202.95, -639.398, -126.169, 100, 0, 0, 0, 0),
|
|
(56854, 17, 1188.3, -614.03, -121.882, 100, 0, 0, 0, 0),
|
|
(56854, 18, 1164.2, -595.404, -115.776, 100, 0, 0, 0, 0),
|
|
(56854, 19, 1155.21, -574.871, -113.377, 100, 0, 0, 0, 0),
|
|
(56854, 20, 1164.2, -595.404, -115.776, 100, 0, 0, 0, 0),
|
|
(56854, 21, 1188.3, -614.03, -121.882, 100, 0, 0, 0, 0),
|
|
(56854, 22, 1202.95, -639.398, -126.169, 100, 0, 0, 0, 0),
|
|
(56854, 23, 1200.5, -670.934, -128.545, 100, 0, 0, 0, 0),
|
|
(56854, 24, 1175.59, -702.081, -130.975, 100, 0, 0, 0, 0),
|
|
(56854, 25, 1149.46, -726.451, -133.804, 100, 0, 0, 0, 0),
|
|
(56854, 26, 1117.1, -744.479, -145.629, 100, 0, 0, 0, 0),
|
|
(56854, 27, 1068.57, -742.832, -151.733, 100, 0, 0, 0, 0),
|
|
(56854, 28, 1058.16, -706.078, -156.611, 100, 0, 0, 0, 0),
|
|
(56854, 29, 1042.02, -695.821, -163.758, 100, 0, 0, 0, 0),
|
|
(56854, 30, 1024.23, -684.475, -173.294, 100, 0, 0, 0, 0),
|
|
(56854, 31, 1002.31, -661.99, -194.192, 100, 0, 0, 0, 0),
|
|
(56854, 32, 975.182, -641.047, -201.577, 100, 0, 0, 0, 0),
|
|
(56854, 33, 936.253, -612.5, -203.622, 100, 0, 0, 0, 0),
|
|
(56854, 34, 899.612, -613.543, -202.238, 100, 0, 0, 0, 0),
|
|
(56854, 35, 856.456, -617.906, -202.157, 100, 0, 0, 0, 0),
|
|
(56854, 36, 831.386, -627.893, -203.149, 100, 0, 0, 0, 0);
|
|
|
|
-- Scarlet Warrior (Entry: 1535, Guid: 44918) - DISTANCE 149.38
|
|
DELETE FROM `creature_movement` WHERE `id`=44918;
|
|
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `wander_distance`, `script_id`, `path_id`) VALUES
|
|
(44918, 1, 2396.71, 1502.94, 33.0567, 100, 0, 0, 0, 0),
|
|
(44918, 2, 2402.5, 1551.13, 31.5294, 100, 0, 0, 0, 0),
|
|
(44918, 3, 2400.64, 1571.11, 31.5122, 100, 0, 0, 0, 0),
|
|
(44918, 4, 2405.7, 1592.94, 33.6022, 100, 0, 0, 0, 0),
|
|
(44918, 5, 2414.73, 1606.38, 33.4056, 100, 0, 0, 0, 0),
|
|
(44918, 6, 2425.73, 1627.86, 35.9604, 100, 0, 0, 0, 0),
|
|
(44918, 7, 2446.01, 1643.89, 33.7287, 100, 13000, 0, 0, 0),
|
|
(44918, 8, 2451.16, 1637.62, 33.512, 100, 0, 0, 0, 0),
|
|
(44918, 9, 2472.88, 1627.81, 33.4458, 100, 0, 0, 0, 0),
|
|
(44918, 10, 2502.6, 1586.71, 34.2942, 100, 0, 0, 0, 0),
|
|
(44918, 11, 2499.41, 1584.27, 34.8709, 100, 0, 0, 0, 0),
|
|
(44918, 12, 2494.74, 1553.71, 34.6261, 100, 0, 0, 0, 0),
|
|
(44918, 13, 2487.4, 1518.04, 33.4613, 100, 0, 0, 0, 0),
|
|
(44918, 14, 2491.3, 1505.02, 36.4851, 100, 15000, 0, 0, 0),
|
|
(44918, 15, 2484.01, 1507.95, 34.5797, 100, 0, 0, 0, 0),
|
|
(44918, 16, 2455.14, 1497.59, 33.7522, 100, 0, 0, 0, 0),
|
|
(44918, 17, 2403.67, 1488.76, 34.2789, 100, 0, 0, 0, 0),
|
|
(44918, 18, 2392.64, 1464.13, 34.1678, 100, 0, 0, 0, 0),
|
|
(44918, 19, 2390.42, 1471.93, 34.4384, 100, 0, 0, 0, 0);
|
|
|
|
-- Scarlet Convert (Entry: 1506, Guid: 44975) - DISTANCE 29.9439
|
|
UPDATE `creature` SET `wander_distance`=5, `movement_type`=1 WHERE `guid`=44975;
|
|
DELETE FROM `creature_movement` WHERE `id`=44975;
|
|
INSERT INTO `creature` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `wander_distance`, `movement_type`, `spawntimesecsmin`, `spawntimesecsmax`) VALUES
|
|
(44653, 1506, 0, 1789.16, 1369.53, 85.7113, 3.59869, 8, 1, 180, 180);
|
|
UPDATE `creature` SET `wander_distance`=0, `movement_type`=2 WHERE `guid`=44515;
|
|
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `wander_distance`, `script_id`) VALUES
|
|
(44515, 1, 1944.528687, 1369.310425, 68.676140, 100.000000, 0, 0.000000, 0),
|
|
(44515, 2, 1954.217773, 1374.520508, 67.546379, 100.000000, 17000, 0.000000, 0),
|
|
(44515, 3, 1939.189209, 1366.704590, 68.061638, 100.000000, 0, 0.000000, 0),
|
|
(44515, 4, 1910.004883, 1335.126953, 78.326431, 100.000000, 0, 0.000000, 0),
|
|
(44515, 5, 1864.503052, 1335.863892, 74.553139, 100.000000, 0, 0.000000, 0),
|
|
(44515, 6, 1826.117188, 1319.148682, 88.945732, 100.000000, 0, 0.000000, 0),
|
|
(44515, 7, 1815.914307, 1330.373047, 87.664047, 100.000000, 0, 0.000000, 0),
|
|
(44515, 8, 1810.360229, 1352.966064, 85.576935, 100.000000, 0, 0.000000, 0),
|
|
(44515, 9, 1788.627930, 1354.599365, 88.504532, 100.000000, 0, 0.000000, 0),
|
|
(44515, 10, 1784.721313, 1351.442627, 89.129410, 100.000000, 0, 0.000000, 0),
|
|
(44515, 11, 1784.721313, 1351.442627, 89.129410, 1.343904, 15000, 0.000000, 0),
|
|
(44515, 12, 1785.008301, 1355.450684, 88.731018, 100.000000, 0, 0.000000, 0),
|
|
(44515, 13, 1777.365723, 1374.054443, 88.243141, 100.000000, 0, 0.000000, 0),
|
|
(44515, 14, 1778.391357, 1383.808472, 91.336678, 100.000000, 0, 0.000000, 0),
|
|
(44515, 15, 1787.051514, 1392.479858, 90.802132, 100.000000, 22000, 0.000000, 0),
|
|
(44515, 16, 1797.514771, 1394.219849, 85.094398, 100.000000, 0, 0.000000, 0),
|
|
(44515, 17, 1835.979614, 1399.418213, 80.089584, 100.000000, 0, 0.000000, 0),
|
|
(44515, 18, 1861.292603, 1405.598511, 81.655617, 100.000000, 300000, 10.000000, 0),
|
|
(44515, 19, 1865.988159, 1394.473999, 80.151260, 100.000000, 0, 0.000000, 0),
|
|
(44515, 20, 1898.799316, 1373.534668, 70.115738, 100.000000, 0, 0.000000, 0);
|
|
|
|
-- Thunder Bluff Reveler (Entry: 15719, Guid: 140068) - DISTANCE 89.1325
|
|
DELETE FROM `creature_movement` WHERE `id`=140068;
|
|
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `wander_distance`, `script_id`, `path_id`) VALUES
|
|
(140068, 1, -1248.53, 62.6843, 127.12, 100, 0, 0, 0, 0),
|
|
(140068, 2, -1255.16, 57.1051, 126.957, 100, 0, 0, 0, 0),
|
|
(140068, 3, -1264.68, 57.7782, 126.971, 100, 0, 0, 0, 0),
|
|
(140068, 4, -1269.16, 60.87, 127.151, 100, 0, 0, 0, 0),
|
|
(140068, 5, -1276.64, 63.7197, 128.29, 100, 0, 0, 0, 0),
|
|
(140068, 6, -1286.8, 62.4132, 128.557, 100, 0, 0, 0, 0),
|
|
(140068, 7, -1303.73, 60.0783, 128.573, 100, 0, 0, 0, 0),
|
|
(140068, 8, -1319.74, 56.2617, 129.036, 100, 0, 0, 0, 0),
|
|
(140068, 9, -1328.44, 50.3823, 129.036, 100, 0, 0, 0, 0),
|
|
(140068, 10, -1332.66, 40.1368, 129.076, 100, 0, 0, 0, 0),
|
|
(140068, 11, -1327.5, 25.6062, 129.253, 100, 0, 0, 0, 0),
|
|
(140068, 12, -1332.66, 40.1368, 129.076, 100, 0, 0, 0, 0),
|
|
(140068, 13, -1328.44, 50.3823, 129.036, 100, 0, 0, 0, 0),
|
|
(140068, 14, -1319.74, 56.2617, 129.036, 100, 0, 0, 0, 0),
|
|
(140068, 15, -1303.73, 60.0783, 128.573, 100, 0, 0, 0, 0),
|
|
(140068, 16, -1286.8, 62.4132, 128.557, 100, 0, 0, 0, 0),
|
|
(140068, 17, -1276.64, 63.7197, 128.29, 100, 0, 0, 0, 0),
|
|
(140068, 18, -1269.17, 60.8769, 127.152, 100, 0, 0, 0, 0),
|
|
(140068, 19, -1264.68, 57.7782, 126.971, 100, 0, 0, 0, 0),
|
|
(140068, 20, -1255.16, 57.1051, 126.957, 100, 0, 0, 0, 0),
|
|
(140068, 21, -1248.53, 62.6843, 127.12, 100, 0, 0, 0, 0),
|
|
(140068, 22, -1242.99, 69.609, 128.003, 100, 0, 0, 0, 0),
|
|
(140068, 23, -1239.16, 74.9042, 129.171, 100, 0, 0, 0, 0),
|
|
(140068, 24, -1230.37, 82.3712, 130.49, 100, 0, 0, 0, 0),
|
|
(140068, 25, -1225.93, 87.7314, 131.294, 100, 0, 0, 0, 0),
|
|
(140068, 26, -1221.77, 91.7981, 132.092, 100, 0, 0, 0, 0),
|
|
(140068, 27, -1213.63, 100.682, 133.778, 100, 0, 0, 0, 0),
|
|
(140068, 28, -1205.57, 111.916, 134.431, 100, 0, 0, 0, 0),
|
|
(140068, 29, -1202.92, 119.533, 134.884, 100, 0, 0, 0, 0),
|
|
(140068, 30, -1192.27, 120.281, 135.206, 100, 0, 0, 0, 0),
|
|
(140068, 31, -1184.28, 120.872, 135.206, 100, 0, 0, 0, 0),
|
|
(140068, 32, -1172.45, 119.396, 135.106, 100, 0, 0, 0, 0),
|
|
(140068, 33, -1184.28, 120.872, 135.207, 100, 0, 0, 0, 0),
|
|
(140068, 34, -1192.27, 120.281, 135.206, 100, 0, 0, 0, 0),
|
|
(140068, 35, -1202.92, 119.533, 134.884, 100, 0, 0, 0, 0),
|
|
(140068, 36, -1205.57, 111.916, 134.43, 100, 0, 0, 0, 0),
|
|
(140068, 37, -1213.63, 100.682, 133.778, 100, 0, 0, 0, 0),
|
|
(140068, 38, -1221.77, 91.7981, 132.092, 100, 0, 0, 0, 0),
|
|
(140068, 39, -1225.93, 87.7314, 131.294, 100, 0, 0, 0, 0),
|
|
(140068, 40, -1230.37, 82.3712, 130.489, 100, 0, 0, 0, 0),
|
|
(140068, 41, -1239.16, 74.9042, 129.171, 100, 0, 0, 0, 0),
|
|
(140068, 42, -1242.99, 69.609, 128.003, 100, 0, 0, 0, 0);
|
|
|
|
-- Jade Ooze (Entry: 2656, Guid: 93068) - DISTANCE 54.7903
|
|
DELETE FROM `creature_movement` WHERE `id`=93068;
|
|
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `wander_distance`, `script_id`, `path_id`) VALUES
|
|
(93068, 1, 374.681, -3774.97, 106.557, 0, 0, 0, 0, 0),
|
|
(93068, 2, 363.041, -3792.43, 111.501, 0, 0, 0, 0, 0),
|
|
(93068, 3, 372.016, -3806.47, 111.995, 0, 0, 0, 0, 0),
|
|
(93068, 4, 381.269, -3822.9, 114.841, 0, 0, 0, 0, 0),
|
|
(93068, 5, 400.852, -3822.61, 118.554, 0, 0, 0, 0, 0),
|
|
(93068, 6, 416.804, -3816.89, 120.355, 0, 0, 0, 0, 0),
|
|
(93068, 7, 439.561, -3795.41, 120.812, 0, 0, 0, 0, 0),
|
|
(93068, 8, 421.674, -3776.19, 122.938, 0, 0, 0, 0, 0),
|
|
(93068, 9, 398.629, -3760.76, 126.066, 0, 0, 0, 0, 0),
|
|
(93068, 10, 384.108, -3758.34, 126.82, 0, 0, 0, 0, 0),
|
|
(93068, 11, 360.804, -3764.61, 126.81, 0, 0, 0, 0, 0),
|
|
(93068, 12, 353.279, -3775.15, 126.799, 0, 0, 0, 0, 0),
|
|
(93068, 13, 337.878, -3781.48, 127.028, 0, 0, 0, 0, 0),
|
|
(93068, 14, 348.228, -3797.66, 127.224, 0, 0, 0, 0, 0),
|
|
(93068, 15, 337.878, -3781.48, 127.028, 0, 0, 0, 0, 0),
|
|
(93068, 16, 353.279, -3775.15, 126.799, 0, 0, 0, 0, 0),
|
|
(93068, 17, 360.804, -3764.61, 126.81, 0, 0, 0, 0, 0),
|
|
(93068, 18, 384.108, -3758.34, 126.82, 0, 0, 0, 0, 0),
|
|
(93068, 19, 398.629, -3760.76, 126.066, 0, 0, 0, 0, 0),
|
|
(93068, 20, 421.674, -3776.19, 122.938, 0, 0, 0, 0, 0),
|
|
(93068, 21, 439.561, -3795.41, 120.812, 0, 0, 0, 0, 0),
|
|
(93068, 22, 416.804, -3816.89, 120.355, 0, 0, 0, 0, 0),
|
|
(93068, 23, 400.852, -3822.61, 118.554, 0, 0, 0, 0, 0),
|
|
(93068, 24, 381.269, -3822.9, 114.841, 0, 0, 0, 0, 0),
|
|
(93068, 25, 372.016, -3806.47, 111.995, 0, 0, 0, 0, 0),
|
|
(93068, 26, 363.041, -3792.43, 111.501, 0, 0, 0, 0, 0);
|
|
|
|
-- Vilebranch Headhunter (Entry: 2641, Guid: 93747) - DISTANCE 32.7668
|
|
DELETE FROM `creature_movement` WHERE `id`=93747;
|
|
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `wander_distance`, `script_id`, `path_id`) VALUES
|
|
(93747, 1, -358.029, -4117, 154.269, 0, 0, 0, 0, 0),
|
|
(93747, 2, -345.444, -4114.75, 151.954, 0, 0, 0, 0, 0),
|
|
(93747, 3, -334.77, -4118.18, 152.151, 0, 0, 0, 0, 0),
|
|
(93747, 4, -333.224, -4134.23, 152.062, 0, 0, 0, 0, 0),
|
|
(93747, 5, -339.837, -4147.75, 152.126, 0, 0, 0, 0, 0),
|
|
(93747, 6, -346.671, -4160.33, 152.126, 0, 0, 0, 0, 0),
|
|
(93747, 7, -345.942, -4177.11, 152.287, 0, 0, 0, 0, 0),
|
|
(93747, 8, -346.245, -4195.28, 152.224, 0, 0, 0, 0, 0),
|
|
(93747, 9, -345.794, -4206.44, 152.19, 0, 0, 0, 0, 0),
|
|
(93747, 10, -341.177, -4208.54, 152.065, 0, 0, 0, 0, 0),
|
|
(93747, 11, -337.748, -4206.13, 152.19, 0, 1000, 0, 0, 0),
|
|
(93747, 12, -341.177, -4208.54, 152.065, 0, 0, 0, 0, 0),
|
|
(93747, 13, -345.794, -4206.44, 152.19, 0, 0, 0, 0, 0),
|
|
(93747, 14, -346.245, -4195.28, 152.224, 0, 0, 0, 0, 0),
|
|
(93747, 15, -345.942, -4177.11, 152.287, 0, 0, 0, 0, 0),
|
|
(93747, 16, -346.671, -4160.33, 152.126, 0, 0, 0, 0, 0),
|
|
(93747, 17, -339.837, -4147.75, 152.126, 0, 0, 0, 0, 0),
|
|
(93747, 18, -333.224, -4134.23, 152.062, 0, 0, 0, 0, 0),
|
|
(93747, 19, -334.77, -4118.18, 152.151, 0, 0, 0, 0, 0),
|
|
(93747, 20, -345.444, -4114.75, 151.954, 0, 0, 0, 0, 0);
|
|
|
|
-- Plague Beast (Entry: 16034, Guid: 88204) - DISTANCE 41.6828
|
|
DELETE FROM `creature_movement` WHERE `id`=88204;
|
|
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `wander_distance`, `script_id`, `path_id`) VALUES
|
|
(88204, 1, 2846.58, -3686.15, 278.529, 100, 0, 0, 0, 0),
|
|
(88204, 2, 2827.88, -3686.89, 275.89, 100, 0, 0, 0, 0),
|
|
(88204, 3, 2846.58, -3686.15, 278.529, 100, 0, 0, 0, 0),
|
|
(88204, 4, 2858.94, -3691.24, 281.145, 100, 0, 0, 0, 0),
|
|
(88204, 5, 2865.73, -3705.73, 284.167, 100, 0, 0, 0, 0),
|
|
(88204, 6, 2882, -3708.83, 285.733, 100, 0, 0, 0, 0),
|
|
(88204, 7, 2894.65, -3698.18, 285.475, 100, 0, 0, 0, 0),
|
|
(88204, 8, 2900.62, -3683.83, 284.001, 100, 0, 0, 0, 0),
|
|
(88204, 9, 2897.48, -3671.88, 280.394, 100, 0, 0, 0, 0),
|
|
(88204, 10, 2884.27, -3662.16, 277.412, 100, 0, 0, 0, 0),
|
|
(88204, 11, 2867.52, -3655.97, 274.442, 100, 0, 0, 0, 0),
|
|
(88204, 12, 2884.27, -3662.16, 277.412, 100, 0, 0, 0, 0),
|
|
(88204, 13, 2897.48, -3671.88, 280.394, 100, 0, 0, 0, 0),
|
|
(88204, 14, 2900.62, -3683.83, 284.001, 100, 0, 0, 0, 0),
|
|
(88204, 15, 2894.85, -3698.01, 285.474, 100, 0, 0, 0, 0),
|
|
(88204, 16, 2882, -3708.83, 285.733, 100, 0, 0, 0, 0),
|
|
(88204, 17, 2865.73, -3705.73, 284.167, 100, 0, 0, 0, 0),
|
|
(88204, 18, 2858.94, -3691.24, 281.145, 100, 0, 0, 0, 0);
|
|
|
|
|
|
-- End of migration.
|
|
END IF;
|
|
END??
|
|
DELIMITER ;
|
|
CALL add_migration();
|
|
DROP PROCEDURE IF EXISTS add_migration;
|