506 lines
47 KiB
SQL
506 lines
47 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`='20260624130946');
|
|
IF v = 0 THEN
|
|
INSERT INTO `migrations` VALUES ('20260624130946');
|
|
-- Add your query below.
|
|
|
|
-- Respawn Hillsbrad Sentry
|
|
DELETE FROM `creature` WHERE `guid` IN (15799, 15803, 15804, 15805, 15877, 15879, 15932);
|
|
DELETE FROM `creature_movement` WHERE (`id` = 15799);
|
|
INSERT INTO `creature` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecsmin`, `spawntimesecsmax`, `wander_distance`, `movement_type`) VALUES
|
|
(15799, 2270, 0, -882.15612792968750, 150.7409362792968750, 24.50975990295410156, 1.211206674575805664, 300, 300, 10, 1),
|
|
(15803, 2270, 0, -915.65222167968750, 182.6412811279296875, 22.88502311706542968, 5.522084712982177734, 300, 300, 10, 1),
|
|
(15804, 2270, 0, -885.47808837890625, 183.3384552001953125, 17.04671287536621093, 1.075698971748352050, 300, 300, 10, 1),
|
|
(15805, 2270, 0, -885.62634277343750, 216.5132598876953125, 8.906772613525390625, 3.067313194274902343, 300, 300, 10, 1),
|
|
(15877, 2270, 0, -918.34930419921875, 219.5347442626953125, 10.16066074371337890, 5.276561260223388671, 300, 300, 10, 1),
|
|
(15879, 2270, 0, -863.40008544921875, 237.9899597167968750, 10.75726032257080078, 1.154044151306152343, 300, 300, 10, 1),
|
|
(15932, 2270, 0, -856.62536621093750, 198.5469055175781250, 17.58082389831542968, 1.430808782577514648, 300, 300, 03, 1);
|
|
|
|
-- Respawn Silithid Invader / Silithid Hive Drone
|
|
DELETE FROM `creature` WHERE `id` IN (4131, 4133);
|
|
DELETE FROM `creature_movement` WHERE `id` IN (21301, 21325, 21311);
|
|
INSERT INTO `creature` (`guid`, `id`, `id2`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecsmin`, `spawntimesecsmax`, `wander_distance`, `movement_type`) VALUES
|
|
(21301, 4131, 4133, 1, -6494.23681640625, -3378.718994140625, -85.3411483764648437, 0.0, 300, 300, 5, 1),
|
|
(21314, 4131, 4133, 1, -6483.38818359375, -3227.885498046875, -112.393814086914062, 0.0, 300, 300, 5, 1),
|
|
(21317, 4131, 4133, 1, -6472.31152343750, -3243.752197265625, -113.307891845703125, 0.0, 300, 300, 5, 1),
|
|
(21318, 4131, 4133, 1, -6496.54150390625, -3241.046630859375, -113.372131347656250, 0.0, 300, 300, 5, 1),
|
|
(21323, 4131, 4133, 1, -6463.60888671875, -3299.380371093750, -104.937652587890625, 0.0, 300, 300, 5, 1),
|
|
(21324, 4131, 4133, 1, -6485.84667968750, -3254.186523437500, -113.491607666015625, 0.0, 300, 300, 5, 1),
|
|
(21325, 4131, 4133, 1, -6496.03320312500, -3325.493652343750, -95.8035354614257812, 0.0, 300, 300, 5, 1),
|
|
(21327, 4131, 4133, 1, -6484.36523437500, -3270.504882812500, -112.494155883789062, 0.0, 300, 300, 0, 2),
|
|
(21329, 4133, 0, 1, -6503.67041015625, -3314.777832031250, -96.8370361328125000, 0.0, 300, 300, 0, 2),
|
|
(21330, 4133, 0, 1, -6510.74072265625, -3307.183349609375, -94.5150604248046875, 0.0, 300, 300, 5, 1);
|
|
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `script_id`) VALUES
|
|
(21327, 01, -6483.77978515625, -3272.338867187500, -112.436500549316406, 100, 0, 0),
|
|
(21327, 02, -6477.99951171875, -3289.034667968750, -107.632736206054687, 100, 0, 0),
|
|
(21327, 03, -6467.70166015625, -3297.321777343750, -104.019233703613281, 100, 0, 0),
|
|
(21327, 04, -6465.71386718750, -3309.317138671875, -102.827171325683593, 100, 0, 0),
|
|
(21327, 05, -6478.56103515625, -3320.503173828125, -98.0991210937500000, 100, 0, 0),
|
|
(21327, 06, -6488.79980468750, -3323.882080078125, -94.5476303100585937, 100, 0, 0),
|
|
(21327, 07, -6478.56103515625, -3320.503173828125, -98.0991210937500000, 100, 0, 0),
|
|
(21327, 08, -6465.71386718750, -3309.317138671875, -102.827171325683593, 100, 0, 0),
|
|
(21327, 09, -6467.70166015625, -3297.321777343750, -104.019233703613281, 100, 0, 0),
|
|
(21327, 10, -6477.99951171875, -3289.034667968750, -107.632736206054687, 100, 0, 0),
|
|
(21329, 01, -6504.15771484375, -3314.493896484375, -96.7208633422851562, 100, 0, 0),
|
|
(21329, 02, -6496.85839843750, -3323.532958984375, -96.2880477905273437, 100, 0, 0),
|
|
(21329, 03, -6495.17578125000, -3334.864501953125, -94.1529846191406250, 100, 0, 0),
|
|
(21329, 04, -6493.97314453125, -3348.585693359375, -92.5439071655273437, 100, 0, 0),
|
|
(21329, 05, -6495.34667968750, -3367.548828125000, -89.0774002075195312, 100, 0, 0),
|
|
(21329, 06, -6493.24072265625, -3390.718505859375, -81.2351150512695312, 100, 0, 0),
|
|
(21329, 07, -6487.62353515625, -3414.512451171875, -73.0745925903320312, 100, 0, 0),
|
|
(21329, 08, -6479.15869140625, -3423.182128906250, -70.6095046997070312, 100, 0, 0),
|
|
(21329, 09, -6470.07617187500, -3433.211669921875, -69.9093093872070312, 100, 0, 0),
|
|
(21329, 10, -6479.15869140625, -3423.182128906250, -70.6095046997070312, 100, 0, 0),
|
|
(21329, 11, -6487.62353515625, -3414.512451171875, -73.0745925903320312, 100, 0, 0),
|
|
(21329, 12, -6493.24072265625, -3390.718505859375, -81.2351150512695312, 100, 0, 0),
|
|
(21329, 13, -6495.34667968750, -3367.548828125000, -89.0774002075195312, 100, 0, 0),
|
|
(21329, 14, -6493.97314453125, -3348.585693359375, -92.5439071655273437, 100, 0, 0),
|
|
(21329, 15, -6495.17578125000, -3334.864501953125, -94.1529846191406250, 100, 0, 0),
|
|
(21329, 16, -6496.85839843750, -3323.532958984375, -96.2880477905273437, 100, 0, 0);
|
|
|
|
-- Respawn Skeletal Miner / Undead Excavator / Undead Dynamiter
|
|
SET @CGUID := 12837;
|
|
DELETE FROM `creature_movement` WHERE `id` IN (89571, 89989);
|
|
DELETE FROM `creature` WHERE `id` IN (623, 624, 625);
|
|
INSERT INTO `creature` (`guid`, `id`, `id2`, `id3`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecsmin`, `spawntimesecsmax`, `wander_distance`, `movement_type`) VALUES
|
|
(@CGUID + 00, 623, 624, 625, 0, -11295.8818359375, 1598.3314208984375, 35.89859771728515625, 1.800206303596496582, 600, 970, 2, 1),
|
|
(@CGUID + 01, 623, 624, 625, 0, -11300.8789062500, 1586.1232910156250, 34.99457550048828125, 5.485357761383056640, 600, 970, 2, 1),
|
|
(@CGUID + 02, 623, 624, 625, 0, -11326.1865234375, 1589.6046142578125, 35.35545349121093750, 2.197665691375732421, 600, 970, 2, 1),
|
|
(@CGUID + 03, 623, 624, 625, 0, -11285.1591796875, 1586.8973388671875, 36.70158767700195312, 1.867618560791015625, 600, 970, 2, 1),
|
|
(@CGUID + 04, 623, 624, 625, 0, -11309.3310546875, 1592.3833007812500, 36.42408752441406250, 1.646275043487548828, 600, 970, 2, 1),
|
|
(@CGUID + 05, 623, 624, 625, 0, -11287.9423828125, 1596.9625244140625, 36.28068161010742187, 3.722155809402465820, 600, 970, 2, 1),
|
|
(@CGUID + 06, 623, 624, 625, 0, -11288.2031250000, 1580.6378173828125, 36.45442962646484375, 0.000000000000000000, 600, 970, 2, 1),
|
|
(@CGUID + 07, 623, 624, 625, 0, -11291.7148437500, 1573.1600341796875, 36.50790405273437500, 5.840511322021484375, 600, 970, 2, 1),
|
|
(@CGUID + 08, 623, 624, 625, 0, -11294.7080078125, 1590.6357421875000, 34.32710266113281250, 4.991641521453857421, 600, 970, 2, 1),
|
|
(@CGUID + 09, 623, 624, 625, 0, -11300.3076171875, 1553.1712646484375, 35.25799179077148437, 5.282184600830078125, 600, 970, 2, 1),
|
|
(@CGUID + 10, 623, 624, 625, 0, -11297.3310546875, 1564.0323486328125, 35.97008514404296875, 5.577094554901123046, 600, 970, 2, 1),
|
|
(@CGUID + 11, 623, 624, 625, 0, -11306.2402343750, 1559.9820556640625, 36.64719390869140625, 0.000000000000000000, 600, 970, 2, 1),
|
|
(@CGUID + 12, 623, 624, 625, 0, -11319.8408203125, 1592.2789306640625, 35.82117080688476562, 0.000000000000000000, 600, 970, 2, 1),
|
|
(@CGUID + 13, 623, 624, 625, 0, -11335.7988281250, 1541.8688964843750, 29.22183036804199218, 0.000000000000000000, 600, 970, 2, 1),
|
|
(@CGUID + 14, 623, 624, 625, 0, -11324.4765625000, 1547.1840820312500, 28.52089691162109375, 3.660197019577026367, 600, 970, 2, 1),
|
|
(@CGUID + 15, 623, 624, 625, 0, -11326.6250000000, 1563.4357910156250, 26.33872985839843750, 5.880512714385986328, 600, 970, 2, 1),
|
|
(@CGUID + 16, 623, 624, 625, 0, -11343.2519531250, 1530.9266357421875, 28.52777099609375000, 0.000000000000000000, 600, 970, 2, 1),
|
|
(@CGUID + 17, 623, 624, 625, 0, -11343.2978515625, 1564.1032714843750, 31.94324874877929687, 3.857177734375000000, 600, 970, 2, 1),
|
|
(@CGUID + 18, 623, 624, 625, 0, -11340.8261718750, 1573.5219726562500, 33.53424835205078125, 4.489574432373046875, 600, 970, 2, 1),
|
|
(@CGUID + 19, 623, 624, 625, 0, -11331.6552734375, 1581.0633544921875, 34.40159225463867187, 0.000000000000000000, 600, 970, 2, 1),
|
|
(@CGUID + 20, 623, 624, 625, 0, -11344.4130859375, 1555.6947021484375, 30.96386146545410156, 0.937163352966308593, 600, 970, 2, 1),
|
|
(@CGUID + 21, 623, 624, 625, 0, -11346.3164062500, 1543.1345214843750, 28.76841354370117187, 1.816690683364868164, 600, 970, 2, 1),
|
|
(@CGUID + 22, 623, 624, 625, 0, -11326.7148437500, 1555.2083740234375, 27.06417465209960937, 4.817108631134033203, 600, 970, 2, 1);
|
|
|
|
-- Respawn Webwood Spider / Githyiss the Vile
|
|
SET @CGUID := 17176;
|
|
DELETE FROM `creature` WHERE `id` IN (1986, 1994);
|
|
INSERT INTO `creature` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecsmin`, `spawntimesecsmax`, `wander_distance`, `movement_type`) VALUES
|
|
(@CGUID + 00, 1986, 1, 10718.58007812500, 816.39733886718750, 1327.0068359375000, 3.211405754089355468, 300, 300, 30, 1),
|
|
(@CGUID + 01, 1986, 1, 10722.47656250000, 877.28808593750000, 1328.2606201171875, 5.830454349517822265, 300, 300, 30, 1),
|
|
(@CGUID + 02, 1986, 1, 10681.08593750000, 916.29589843750000, 1322.7342529296875, 0.375913143157958984, 300, 300, 30, 1),
|
|
(@CGUID + 03, 1986, 1, 10666.51855468750, 933.33874511718750, 1322.0034179687500, 2.074608564376831054, 300, 300, 30, 1),
|
|
(@CGUID + 04, 1986, 1, 10731.81933593750, 950.64831542968750, 1333.2170410156250, 2.124099016189575195, 300, 300, 30, 1),
|
|
(@CGUID + 05, 1986, 1, 10715.09082031250, 849.37261962890625, 1325.8514404296875, 2.289318323135375976, 300, 300, 30, 1),
|
|
(@CGUID + 06, 1986, 1, 10681.85742187500, 882.40374755859375, 1320.5513916015625, 3.924531459808349609, 300, 300, 30, 1),
|
|
(@CGUID + 07, 1986, 1, 10704.61718750000, 944.45452880859375, 1328.3015136718750, 5.204211711883544921, 300, 300, 30, 1),
|
|
(@CGUID + 08, 1986, 1, 10753.57421875000, 917.36956787109375, 1338.4082031250000, 3.354250669479370117, 300, 300, 5, 1),
|
|
(@CGUID + 09, 1986, 1, 10768.65820312500, 923.96704101562500, 1338.8343505859375, 4.966780185699462890, 300, 300, 5, 1),
|
|
(@CGUID + 10, 1986, 1, 10735.10058593750, 900.92950439453125, 1332.0488281250000, 4.206243515014648437, 300, 300, 5, 1),
|
|
(@CGUID + 11, 1986, 1, 10786.25976562500, 933.20629882812500, 1337.3990478515625, 4.974691390991210937, 300, 300, 5, 1),
|
|
(@CGUID + 12, 1986, 1, 10802.61328125000, 944.36999511718750, 1336.0028076171875, 0.861814975738525390, 300, 300, 5, 1),
|
|
(@CGUID + 13, 1986, 1, 10833.63574218750, 934.57812500000000, 1335.8376464843750, 1.055991768836975097, 300, 300, 5, 1),
|
|
(@CGUID + 14, 1986, 1, 10823.14062500000, 900.42706298828125, 1335.8253173828125, 0.029533637687563896, 300, 300, 5, 1),
|
|
(@CGUID + 15, 1986, 1, 10835.61523437500, 900.36694335937500, 1334.8229980468750, 6.171617507934570312, 300, 300, 5, 1),
|
|
(@CGUID + 16, 1986, 1, 10840.27734375000, 885.44830322265625, 1333.4893798828125, 0.492046177387237548, 300, 300, 5, 1),
|
|
(@CGUID + 17, 1986, 1, 10866.69140625000, 917.29327392578125, 1331.1962890625000, 0.122693173587322235, 300, 300, 5, 1),
|
|
(@CGUID + 18, 1986, 1, 10893.00390625000, 986.80664062500000, 1337.1378173828125, 6.195337295532226562, 300, 300, 5, 1),
|
|
(@CGUID + 19, 1986, 1, 10864.86230468750, 979.12384033203125, 1336.5565185546875, 1.603378772735595703, 300, 300, 5, 1),
|
|
(@CGUID + 20, 1986, 1, 10868.05664062500, 866.56115722656250, 1326.7774658203125, 4.390202522277832031, 300, 300, 5, 1),
|
|
(@CGUID + 21, 1986, 1, 10858.98925781250, 858.99865722656250, 1328.2800292968750, 2.820507049560546875, 300, 300, 5, 1),
|
|
(@CGUID + 22, 1986, 1, 10882.50390625000, 874.86529541015625, 1325.4072265625000, 0.966396510601043701, 300, 300, 5, 1),
|
|
(@CGUID + 23, 1986, 1, 10899.09375000000, 898.29022216796875, 1323.6564941406250, 1.151917338371276855, 300, 300, 5, 1),
|
|
(@CGUID + 24, 1986, 1, 10889.38378906250, 917.58648681640625, 1326.6378173828125, 3.311156272888183593, 300, 300, 5, 1),
|
|
(@CGUID + 25, 1986, 1, 10922.04394531250, 938.88751220703125, 1322.2385253906250, 3.417912721633911132, 300, 300, 5, 1),
|
|
(@CGUID + 26, 1986, 1, 10941.85937500000, 965.10504150390625, 1327.1232910156250, 5.166174411773681640, 300, 300, 5, 1),
|
|
(@CGUID + 27, 1986, 1, 10934.57617187500, 948.42980957031250, 1321.8919677734375, 0.811628043651580810, 300, 300, 5, 1),
|
|
(@CGUID + 28, 1986, 1, 10843.15820312500, 957.24945068359375, 1335.4874267578125, 4.145748138427734375, 300, 300, 5, 1),
|
|
(@CGUID + 29, 1986, 1, 10897.85351562500, 974.71276855468750, 1337.6535644531250, 2.202968120574951171, 300, 300, 5, 1),
|
|
(@CGUID + 30, 1986, 1, 10911.82617187500, 969.35321044921875, 1338.9345703125000, 6.130199432373046875, 300, 300, 5, 1),
|
|
(@CGUID + 31, 1986, 1, 10916.43457031250, 957.58575439453125, 1339.6990966796875, 2.808463573455810546, 300, 300, 5, 1),
|
|
(@CGUID + 32, 1986, 1, 10979.20019531250, 977.51995849609375, 1335.3133544921875, 5.856158733367919921, 300, 300, 5, 1),
|
|
(@CGUID + 33, 1986, 1, 10990.74023437500, 944.18933105468750, 1336.1696777343750, 3.513284683227539062, 300, 300, 5, 1),
|
|
(@CGUID + 34, 1986, 1, 10963.46875000000, 925.52038574218750, 1340.4235839843750, 0.173187166452407836, 300, 300, 5, 1),
|
|
(@CGUID + 35, 1986, 1, 10973.12304687500, 938.04925537109375, 1337.9687500000000, 1.199934959411621093, 300, 300, 5, 1),
|
|
(@CGUID + 36, 1986, 1, 10942.69531250000, 914.79864501953125, 1339.9248046875000, 4.836705207824707031, 300, 300, 5, 1),
|
|
(@CGUID + 37, 1986, 1, 10948.62304687500, 892.98126220703125, 1337.5388183593750, 0.305056661367416381, 300, 300, 5, 1),
|
|
(@CGUID + 38, 1986, 1, 10931.62695312500, 864.97821044921875, 1332.0297851562500, 0.296750694513320922, 300, 300, 5, 1),
|
|
(@CGUID + 39, 1986, 1, 10949.45214843750, 867.87438964843750, 1333.9869384765625, 0.732970058917999267, 300, 300, 5, 1),
|
|
(@CGUID + 40, 1986, 1, 10915.72656250000, 867.57299804687500, 1329.3432617187500, 6.207247734069824218, 300, 300, 5, 1),
|
|
(@CGUID + 41, 1986, 1, 10899.94628906250, 878.31335449218750, 1329.9327392578125, 0.421981036663055419, 300, 300, 5, 1),
|
|
(@CGUID + 42, 1986, 1, 10908.56347656250, 857.28625488281250, 1328.9635009765625, 4.910270690917968750, 300, 300, 5, 1),
|
|
(@CGUID + 43, 1986, 1, 10952.84863281250, 939.59332275390625, 1340.6506347656250, 4.127363204956054687, 300, 300, 5, 1),
|
|
(@CGUID + 44, 1994, 1, 10938.40234375000, 930.25122070312500, 1340.9490966796875, 3.188395738601684570, 300, 300, 5, 1);
|
|
|
|
-- Respawn Harpies
|
|
SET @CGUID := 12860;
|
|
DELETE FROM `creature` WHERE `id` IN (4100, 4101, 4104);
|
|
DELETE FROM `creature_movement` WHERE `id` IN (21040, 21053, 21100, 21103);
|
|
INSERT INTO `creature` (`guid`, `id`, `id2`, `id3`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecsmin`, `spawntimesecsmax`, `wander_distance`, `movement_type`) VALUES
|
|
(@CGUID + 000, 4100, 4101, 0, 1, -5467.08544921875, -1651.0065917968750, 26.94258689880371093, 2.316157102584838867, 300, 300, 00, 2),
|
|
(@CGUID + 001, 4100, 4101, 0, 1, -5416.70751953125, -1651.8118896484375, -50.7205314636230468, 2.251474618911743164, 300, 300, 45, 1),
|
|
(@CGUID + 002, 4100, 4101, 0, 1, -5349.09179687500, -1650.2734375000000, -53.8759765625000000, 3.484354019165039062, 300, 300, 45, 1),
|
|
(@CGUID + 003, 4100, 4101, 0, 1, -5382.30761718750, -1682.9986572265625, -53.4824943542480468, 1.248679399490356445, 300, 300, 45, 1),
|
|
(@CGUID + 004, 4100, 4101, 0, 1, -5382.42480468750, -1649.1652832031250, -54.4458312988281250, 4.157047271728515625, 300, 300, 45, 1),
|
|
(@CGUID + 005, 4100, 4101, 0, 1, -5416.39404296875, -1681.7926025390625, -51.3021850585937500, 6.118137359619140625, 300, 300, 45, 1),
|
|
(@CGUID + 006, 4100, 4101, 0, 1, -5437.96191406250, -1699.8831787109375, -38.4809875488281250, 1.591293692588806152, 300, 300, 45, 1),
|
|
(@CGUID + 007, 4100, 4101, 0, 1, -5383.07275390625, -1615.7891845703125, -55.2583007812500000, 4.367116928100585937, 300, 300, 45, 1),
|
|
(@CGUID + 008, 4100, 4101, 4104, 1, -5485.42822265625, -1628.8088378906250, 27.63051795959472656, 0.034906584769487380, 300, 300, 00, 2),
|
|
(@CGUID + 009, 4100, 4101, 4104, 1, -5606.99316406250, -1583.2797851562500, 12.50986671447753906, 1.063697814941406250, 300, 300, 00, 2),
|
|
(@CGUID + 010, 4100, 4101, 4104, 1, -5515.55957031250, -1580.3743896484375, 29.19502258300781250, 4.980279922485351562, 300, 300, 00, 2),
|
|
(@CGUID + 011, 4100, 4101, 4104, 1, -5578.64892578125, -1576.3264160156250, 10.53929710388183593, 5.169055938720703125, 300, 300, 05, 1),
|
|
(@CGUID + 012, 4100, 4101, 4104, 1, -5615.49511718750, -1584.2303466796875, 12.57625865936279296, 3.868321895599365234, 300, 300, 05, 1),
|
|
(@CGUID + 013, 4100, 4101, 4104, 1, -5598.57275390625, -1576.6748046875000, 12.28646659851074218, 5.242191314697265625, 300, 300, 05, 1),
|
|
(@CGUID + 014, 4100, 4101, 4104, 1, -5584.75732421875, -1623.6773681640625, 15.54309654235839843, 5.179795265197753906, 300, 300, 05, 1),
|
|
(@CGUID + 015, 4100, 4101, 4104, 1, -5599.30468750000, -1607.2213134765625, 13.56645393371582031, 4.947752952575683593, 300, 300, 05, 1),
|
|
(@CGUID + 016, 4100, 4101, 4104, 1, -5612.57666015625, -1607.9229736328125, 14.62030887603759765, 3.816843509674072265, 300, 300, 05, 1),
|
|
(@CGUID + 017, 4100, 4101, 4104, 1, -5513.06250000000, -1575.7592773437500, 28.57674217224121093, 4.000764846801757812, 300, 300, 05, 1),
|
|
(@CGUID + 018, 4100, 4101, 4104, 1, -5510.72607421875, -1589.2917480468750, 28.07126235961914062, 1.190461039543151855, 300, 300, 05, 1),
|
|
(@CGUID + 019, 4100, 4101, 4104, 1, -5557.96337890625, -1631.9249267578125, 22.06213569641113281, 5.992482662200927734, 300, 300, 05, 1),
|
|
(@CGUID + 020, 4100, 4101, 4104, 1, -5532.98779296875, -1601.9055175781250, 29.33683395385742187, 0.097705513238906860, 300, 300, 05, 1),
|
|
(@CGUID + 021, 4100, 4101, 4104, 1, -5539.39892578125, -1593.1744384765625, 29.02005386352539062, 2.425678253173828125, 300, 300, 05, 1),
|
|
(@CGUID + 022, 4100, 4101, 4104, 1, -5498.43115234375, -1624.7369384765625, 26.83120727539062500, 0.929371237754821777, 300, 300, 05, 1),
|
|
(@CGUID + 023, 4100, 4101, 4104, 1, -5492.40039062500, -1606.8350830078125, 27.64176940917968750, 2.433421373367309570, 300, 300, 05, 1),
|
|
(@CGUID + 024, 4100, 4101, 4104, 1, -5464.86718750000, -1636.3170166015625, 29.18745040893554687, 3.082686901092529296, 300, 300, 05, 1);
|
|
|
|
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `script_id`) VALUES
|
|
(@CGUID + 000, 1, -5467.72314453125, -1650.3156738281250, 27.46588134765625000, 100, 0, 0),
|
|
(@CGUID + 000, 2, -5466.55371093750, -1658.9676513671875, 23.92840385437011718, 100, 0, 0),
|
|
(@CGUID + 000, 3, -5467.97070312500, -1664.8027343750000, 21.43744277954101562, 100, 0, 0),
|
|
(@CGUID + 000, 4, -5470.65966796875, -1675.3095703125000, 15.51346874237060546, 100, 0, 0),
|
|
(@CGUID + 000, 5, -5470.73828125000, -1685.3105468750000, 9.571016311645507812, 100, 0, 0),
|
|
(@CGUID + 000, 6, -5470.86132812500, -1694.0899658203125, 4.298313140869140625, 100, 0, 0),
|
|
(@CGUID + 000, 7, -5468.28027343750, -1696.3398437500000, 1.190879464149475097, 100, 0, 0),
|
|
(@CGUID + 000, 8, -5465.54150390625, -1696.6258544921875, -1.36230051517486572, 100, 0, 0),
|
|
(@CGUID + 000, 9, -5462.47998046875, -1692.8060302734375, -4.24744462966918945, 100, 0, 0),
|
|
(@CGUID + 000, 10, -5457.72509765625, -1685.7762451171875, -9.46290969848632812, 100, 0, 0),
|
|
(@CGUID + 000, 11, -5453.38037109375, -1676.8728027343750, -14.6738204956054687, 100, 0, 0),
|
|
(@CGUID + 000, 12, -5448.44091796875, -1668.5014648437500, -20.1577758789062500, 100, 0, 0),
|
|
(@CGUID + 000, 13, -5441.35644531250, -1659.4566650390625, -26.9077739715576171, 100, 0, 0),
|
|
(@CGUID + 000, 14, -5437.03466796875, -1654.8862304687500, -30.9707298278808593, 100, 0, 0),
|
|
(@CGUID + 000, 15, -5441.35644531250, -1659.4566650390625, -26.9077739715576171, 100, 0, 0),
|
|
(@CGUID + 000, 16, -5448.44091796875, -1668.5014648437500, -20.1577758789062500, 100, 0, 0),
|
|
(@CGUID + 000, 17, -5453.38037109375, -1676.8728027343750, -14.6738204956054687, 100, 0, 0),
|
|
(@CGUID + 000, 18, -5457.72509765625, -1685.7762451171875, -9.46290969848632812, 100, 0, 0),
|
|
(@CGUID + 000, 19, -5462.47998046875, -1692.8060302734375, -4.24744462966918945, 100, 0, 0),
|
|
(@CGUID + 000, 20, -5465.54150390625, -1696.6258544921875, -1.36230051517486572, 100, 0, 0),
|
|
(@CGUID + 000, 21, -5468.28027343750, -1696.3398437500000, 1.190879464149475097, 100, 0, 0),
|
|
(@CGUID + 000, 22, -5470.86132812500, -1694.0899658203125, 4.298313140869140625, 100, 0, 0),
|
|
(@CGUID + 000, 23, -5470.73828125000, -1685.3105468750000, 9.571016311645507812, 100, 0, 0),
|
|
(@CGUID + 000, 24, -5470.65966796875, -1675.3095703125000, 15.51346874237060546, 100, 0, 0),
|
|
(@CGUID + 000, 25, -5467.97070312500, -1664.8027343750000, 21.43744277954101562, 100, 0, 0),
|
|
(@CGUID + 000, 26, -5466.55371093750, -1658.9676513671875, 23.92840385437011718, 100, 0, 0),
|
|
(@CGUID + 008, 1, -5484.05859375000, -1629.8177490234375, 28.04794883728027343, 100, 0, 0),
|
|
(@CGUID + 008, 2, -5491.51416015625, -1628.7612304687500, 27.38097381591796875, 100, 0, 0),
|
|
(@CGUID + 008, 3, -5498.06738281250, -1626.4549560546875, 26.86795616149902343, 100, 0, 0),
|
|
(@CGUID + 008, 4, -5499.20654296875, -1621.5977783203125, 27.80634498596191406, 100, 0, 0),
|
|
(@CGUID + 008, 5, -5498.26757812500, -1617.8590087890625, 28.35617065429687500, 100, 0, 0),
|
|
(@CGUID + 008, 6, -5496.34277343750, -1613.2043457031250, 29.19667053222656250, 100, 0, 0),
|
|
(@CGUID + 008, 7, -5495.56005859375, -1603.8742675781250, 27.83534622192382812, 100, 0, 0),
|
|
(@CGUID + 008, 8, -5499.52832031250, -1598.8344726562500, 28.25476646423339843, 100, 0, 0),
|
|
(@CGUID + 008, 9, -5502.49169921875, -1594.7166748046875, 28.37257003784179687, 100, 0, 0),
|
|
(@CGUID + 008, 10, -5506.98242187500, -1591.5554199218750, 28.26099967956542968, 100, 0, 0),
|
|
(@CGUID + 008, 11, -5502.49169921875, -1594.7166748046875, 28.37257003784179687, 100, 0, 0),
|
|
(@CGUID + 008, 12, -5499.52832031250, -1598.8344726562500, 28.25476646423339843, 100, 0, 0),
|
|
(@CGUID + 008, 13, -5495.56005859375, -1603.8742675781250, 27.83534622192382812, 100, 0, 0),
|
|
(@CGUID + 008, 14, -5496.34277343750, -1613.2043457031250, 29.19667053222656250, 100, 0, 0),
|
|
(@CGUID + 008, 15, -5498.26757812500, -1617.8590087890625, 28.35617065429687500, 100, 0, 0),
|
|
(@CGUID + 008, 16, -5499.20654296875, -1621.5977783203125, 27.80634498596191406, 100, 0, 0),
|
|
(@CGUID + 008, 17, -5498.06738281250, -1626.4549560546875, 26.86795616149902343, 100, 0, 0),
|
|
(@CGUID + 008, 18, -5491.51416015625, -1628.7612304687500, 27.38097381591796875, 100, 0, 0),
|
|
(@CGUID + 009, 1, -5606.65625000000, -1582.6733398437500, 12.50210952758789062, 100, 0, 0),
|
|
(@CGUID + 009, 2, -5608.41357421875, -1588.9626464843750, 13.21165466308593750, 100, 0, 0),
|
|
(@CGUID + 009, 3, -5604.49121093750, -1595.5447998046875, 10.97657012939453125, 100, 0, 0),
|
|
(@CGUID + 009, 4, -5601.57910156250, -1602.7539062500000, 13.02133178710937500, 100, 0, 0),
|
|
(@CGUID + 009, 5, -5596.50097656250, -1609.2404785156250, 13.91601181030273437, 100, 0, 0),
|
|
(@CGUID + 009, 6, -5592.20214843750, -1615.3583984375000, 14.98151111602783203, 100, 0, 0),
|
|
(@CGUID + 009, 7, -5587.00341796875, -1620.8582763671875, 15.11227893829345703, 100, 0, 0),
|
|
(@CGUID + 009, 8, -5581.19189453125, -1625.3519287109375, 16.26929664611816406, 100, 0, 0),
|
|
(@CGUID + 009, 9, -5576.55957031250, -1627.0507812500000, 17.95885658264160156, 100, 0, 0),
|
|
(@CGUID + 009, 10, -5569.80371093750, -1629.8892822265625, 20.11680412292480468, 100, 0, 0),
|
|
(@CGUID + 009, 11, -5576.55957031250, -1627.0507812500000, 17.95885658264160156, 100, 0, 0),
|
|
(@CGUID + 009, 12, -5581.19189453125, -1625.3519287109375, 16.26929664611816406, 100, 0, 0),
|
|
(@CGUID + 009, 13, -5587.00341796875, -1620.8582763671875, 15.11227893829345703, 100, 0, 0),
|
|
(@CGUID + 009, 14, -5592.20214843750, -1615.3583984375000, 14.98151111602783203, 100, 0, 0),
|
|
(@CGUID + 009, 15, -5596.50097656250, -1609.2404785156250, 13.91601181030273437, 100, 0, 0),
|
|
(@CGUID + 009, 16, -5601.57910156250, -1602.7539062500000, 13.02133178710937500, 100, 0, 0),
|
|
(@CGUID + 009, 17, -5604.49121093750, -1595.5447998046875, 10.97657012939453125, 100, 0, 0),
|
|
(@CGUID + 009, 18, -5608.41357421875, -1588.9626464843750, 13.21165466308593750, 100, 0, 0),
|
|
(@CGUID + 010, 1, -5515.47363281250, -1580.4672851562500, 29.24455642700195312, 100, 0, 0),
|
|
(@CGUID + 010, 2, -5514.00195312500, -1586.0496826171875, 28.20516967773437500, 100, 0, 0),
|
|
(@CGUID + 010, 3, -5514.09912109375, -1589.2888183593750, 28.41573715209960937, 100, 0, 0),
|
|
(@CGUID + 010, 4, -5518.25683593750, -1593.3613281250000, 29.48577690124511718, 100, 0, 0),
|
|
(@CGUID + 010, 5, -5525.84228515625, -1596.0346679687500, 30.02995300292968750, 100, 0, 0),
|
|
(@CGUID + 010, 6, -5534.33837890625, -1596.6674804687500, 29.56578063964843750, 100, 0, 0),
|
|
(@CGUID + 010, 7, -5537.77978515625, -1601.5468750000000, 28.36096763610839843, 100, 0, 0),
|
|
(@CGUID + 010, 8, -5539.97021484375, -1606.9886474609375, 26.99191474914550781, 100, 0, 0),
|
|
(@CGUID + 010, 9, -5541.49707031250, -1612.3616943359375, 25.92737960815429687, 100, 0, 0),
|
|
(@CGUID + 010, 10, -5542.80908203125, -1619.9669189453125, 23.99998283386230468, 100, 0, 0),
|
|
(@CGUID + 010, 11, -5545.72119140625, -1625.3647460937500, 23.31828117370605468, 100, 0, 0),
|
|
(@CGUID + 010, 12, -5550.23681640625, -1629.3040771484375, 22.88010406494140625, 100, 0, 0),
|
|
(@CGUID + 010, 13, -5556.14794921875, -1631.1412353515625, 22.22649765014648437, 100, 0, 0),
|
|
(@CGUID + 010, 14, -5562.71777343750, -1631.3007812500000, 21.62122535705566406, 100, 0, 0),
|
|
(@CGUID + 010, 15, -5556.14794921875, -1631.1412353515625, 22.22649765014648437, 100, 0, 0),
|
|
(@CGUID + 010, 16, -5550.23681640625, -1629.3040771484375, 22.88010406494140625, 100, 0, 0),
|
|
(@CGUID + 010, 17, -5545.72119140625, -1625.3647460937500, 23.31828117370605468, 100, 0, 0),
|
|
(@CGUID + 010, 18, -5542.80908203125, -1619.9669189453125, 23.99998283386230468, 100, 0, 0),
|
|
(@CGUID + 010, 19, -5541.49707031250, -1612.3616943359375, 25.92737960815429687, 100, 0, 0),
|
|
(@CGUID + 010, 20, -5539.97021484375, -1606.9886474609375, 26.99191474914550781, 100, 0, 0),
|
|
(@CGUID + 010, 21, -5537.77978515625, -1601.5468750000000, 28.36096763610839843, 100, 0, 0),
|
|
(@CGUID + 010, 22, -5534.33837890625, -1596.6674804687500, 29.56578063964843750, 100, 0, 0),
|
|
(@CGUID + 010, 23, -5525.84228515625, -1596.0346679687500, 30.02995300292968750, 100, 0, 0),
|
|
(@CGUID + 010, 24, -5518.25683593750, -1593.3613281250000, 29.48577690124511718, 100, 0, 0),
|
|
(@CGUID + 010, 25, -5514.09912109375, -1589.2888183593750, 28.41573715209960937, 100, 0, 0),
|
|
(@CGUID + 010, 26, -5514.00195312500, -1586.0496826171875, 28.20516967773437500, 100, 0, 0);
|
|
|
|
-- Dune Smasher
|
|
DELETE FROM `creature` WHERE `guid` IN (23119, 23120, 23121, 23122, 23123, 23124);
|
|
DELETE FROM `creature_movement` WHERE `id` IN (23120);
|
|
SET @CGUID := 23119;
|
|
INSERT INTO `creature` (`guid`, `id`, `id2`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecsmin`, `spawntimesecsmax`, `wander_distance`, `movement_type`) VALUES
|
|
(@CGUID + 000, 5469, 5470, 1, -9584.9501953125, -2782.754394531250, 8.393129348754882812, 5.759324073791503906, 300, 300, 00, 2),
|
|
(@CGUID + 001, 5469, 5470, 1, -9551.3173828125, -2781.870605468750, 7.921374320983886718, 6.265731811523437500, 300, 300, 00, 0),
|
|
(@CGUID + 002, 5469, 5470, 1, -9582.8505859375, -2815.651367187500, 7.921370506286621093, 3.089232683181762695, 300, 300, 00, 0),
|
|
(@CGUID + 003, 5469, 5470, 1, -9614.6972656250, -2783.145019531250, 7.921376705169677734, 0.785398185253143310, 300, 300, 00, 0),
|
|
(@CGUID + 004, 5469, 5470, 1, -9583.4228515625, -2749.131103515625, 8.480147361755371093, 1.797689080238342285, 300, 300, 00, 0),
|
|
(@CGUID + 005, 5469, 5470, 1, -9516.1689453125, -2750.039062500000, 8.793258666992187500, 4.932815074920654296, 300, 300, 00, 0);
|
|
|
|
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `script_id`) VALUES
|
|
(@CGUID + 000, 01, -9562.4169921875, -2758.099609375000, 7.838038921356201171, 100, 0, 0),
|
|
(@CGUID + 000, 02, -9549.7763671875, -2746.834472656250, 7.838038921356201171, 100, 0, 0),
|
|
(@CGUID + 000, 03, -9532.3779296875, -2735.832519531250, 8.650532722473144531, 100, 0, 0),
|
|
(@CGUID + 000, 04, -9514.3769531250, -2736.007812500000, 9.456770896911621093, 100, 0, 0),
|
|
(@CGUID + 000, 05, -9496.5078125000, -2745.606201171875, 11.45958137512207031, 100, 0, 0),
|
|
(@CGUID + 000, 06, -9488.8955078125, -2757.654541015625, 10.92533111572265625, 100, 0, 0),
|
|
(@CGUID + 000, 07, -9487.6523437500, -2767.199462890625, 9.994297027587890625, 100, 0, 0),
|
|
(@CGUID + 000, 08, -9488.9179687500, -2778.013427734375, 9.670425415039062500, 100, 0, 0),
|
|
(@CGUID + 000, 09, -9492.2607421875, -2785.362548828125, 9.762969970703125000, 100, 0, 0),
|
|
(@CGUID + 000, 10, -9498.0234375000, -2794.553955078125, 9.612557411193847656, 100, 0, 0),
|
|
(@CGUID + 000, 11, -9512.8017578125, -2795.988769531250, 8.714428901672363281, 100, 0, 0),
|
|
(@CGUID + 000, 12, -9530.1640625000, -2790.121093750000, 7.877921104431152343, 100, 0, 0),
|
|
(@CGUID + 000, 13, -9550.2285156250, -2765.517089843750, 7.838038921356201171, 100, 0, 0),
|
|
(@CGUID + 000, 14, -9561.6630859375, -2771.760009765625, 8.334819793701171875, 100, 0, 0),
|
|
(@CGUID + 000, 15, -9568.2988281250, -2784.096191406250, 7.838038444519042968, 100, 0, 0),
|
|
(@CGUID + 000, 16, -9568.2919921875, -2793.459472656250, 7.839695930480957031, 100, 0, 0),
|
|
(@CGUID + 000, 17, -9559.3486328125, -2797.778076171875, 8.126653671264648437, 100, 0, 0),
|
|
(@CGUID + 000, 18, -9541.1523437500, -2795.945312500000, 7.890349864959716796, 100, 0, 0),
|
|
(@CGUID + 000, 19, -9537.2871093750, -2792.638916015625, 7.840148448944091796, 100, 0, 0),
|
|
(@CGUID + 000, 20, -9543.3837890625, -2768.145507812500, 7.860080718994140625, 100, 0, 0),
|
|
(@CGUID + 000, 21, -9564.5283203125, -2767.664550781250, 8.427618980407714843, 100, 0, 0),
|
|
(@CGUID + 000, 22, -9573.0576171875, -2779.386718750000, 7.838038921356201171, 100, 0, 0),
|
|
(@CGUID + 000, 23, -9574.7773437500, -2795.566894531250, 7.838038921356201171, 100, 0, 0),
|
|
(@CGUID + 000, 24, -9570.1376953125, -2806.566162109375, 7.931662559509277343, 100, 0, 0),
|
|
(@CGUID + 000, 25, -9571.3798828125, -2818.392089843750, 8.232960700988769531, 100, 0, 0),
|
|
(@CGUID + 000, 26, -9576.5800781250, -2827.663574218750, 8.764989852905273437, 100, 0, 0),
|
|
(@CGUID + 000, 27, -9589.9189453125, -2823.834716796875, 8.341020584106445312, 100, 0, 0),
|
|
(@CGUID + 000, 28, -9604.3593750000, -2816.566406250000, 8.289196014404296875, 100, 0, 0),
|
|
(@CGUID + 000, 29, -9608.1357421875, -2805.692382812500, 7.844256401062011718, 100, 0, 0),
|
|
(@CGUID + 000, 30, -9602.8330078125, -2788.922363281250, 7.838039398193359375, 100, 0, 0),
|
|
(@CGUID + 000, 31, -9583.6210937500, -2783.522216796875, 8.161374092102050781, 100, 0, 0);
|
|
|
|
-- Searing Roc | Living Storm
|
|
DELETE FROM `creature` WHERE `guid` IN (22730, 22735, 23410 , 23411);
|
|
SET @CGUID := 22780;
|
|
INSERT INTO `creature` (`guid`, `id`, `id2`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecsmin`, `spawntimesecsmax`, `wander_distance`, `movement_type`) VALUES
|
|
(@CGUID + 000, 5430, 9397, 1, -9447.3535156250, -2311.487792968750, 13.04445171356201171, 4.885818481445312500, 300, 300, 0, 2),
|
|
(@CGUID + 001, 5430, 9397, 1, -9344.1679687500, -3254.193847656250, 9.951151847839355468, 4.993139743804931640, 300, 300, 0, 2),
|
|
(@CGUID + 002, 5430, 9397, 1, -8547.3281250000, -2521.588623046875, 47.38054275512695312, 1.220149397850036621, 300, 300, 0, 2),
|
|
(@CGUID + 003, 5430, 9397, 1, -9419.0732421875, -2519.353515625000, 13.13672828674316406, 5.936859130859375000, 300, 300, 0, 2),
|
|
(@CGUID + 004, 5430, 9397, 1, -9380.8808593750, -3191.871093750000, 9.565829277038574218, 6.169725894927978515, 300, 300, 0, 2);
|
|
|
|
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `script_id`) VALUES
|
|
(@CGUID + 000, 01, -9432.2910156250, -2286.458984375000, 11.17045021057128906, 100, 0, 0),
|
|
(@CGUID + 000, 02, -9418.4072265625, -2265.040039062500, 10.55861759185791015, 100, 0, 0),
|
|
(@CGUID + 000, 03, -9387.7080078125, -2255.407714843750, 10.89895534515380859, 100, 0, 0),
|
|
(@CGUID + 000, 04, -9355.4130859375, -2249.829345703125, 9.670322418212890625, 100, 0, 0),
|
|
(@CGUID + 000, 05, -9319.6171875000, -2255.700927734375, 9.303171157836914062, 100, 0, 0),
|
|
(@CGUID + 000, 06, -9290.3320312500, -2255.886962890625, 8.147867202758789062, 100, 0, 0),
|
|
(@CGUID + 000, 07, -9269.6289062500, -2230.687500000000, 8.893816947937011718, 100, 0, 0),
|
|
(@CGUID + 000, 08, -9250.2529296875, -2213.952636718750, 8.069734573364257812, 100, 0, 0),
|
|
(@CGUID + 000, 09, -9221.3330078125, -2232.869873046875, 8.454463958740234375, 100, 0, 0),
|
|
(@CGUID + 000, 10, -9182.2695312500, -2258.175048828125, 12.89111995697021484, 100, 0, 0),
|
|
(@CGUID + 000, 11, -9154.7255859375, -2279.561767578125, 11.69612121582031250, 100, 0, 0),
|
|
(@CGUID + 000, 12, -9120.7988281250, -2286.664550781250, 8.724493026733398437, 100, 0, 0),
|
|
(@CGUID + 000, 13, -9101.9384765625, -2323.848876953125, 12.39300251007080078, 100, 0, 0),
|
|
(@CGUID + 000, 14, -9076.5566406250, -2349.373046875000, 14.66810417175292968, 100, 0, 0),
|
|
(@CGUID + 000, 15, -9065.7724609375, -2367.703369140625, 15.07260704040527343, 100, 0, 0),
|
|
(@CGUID + 000, 16, -9050.1660156250, -2412.041015625000, 12.35745525360107421, 100, 0, 0),
|
|
(@CGUID + 000, 17, -9052.1855468750, -2448.200195312500, 11.30616188049316406, 100, 0, 0),
|
|
(@CGUID + 000, 18, -9085.8769531250, -2479.466796875000, 13.07320213317871093, 100, 0, 0),
|
|
(@CGUID + 000, 19, -9108.3710937500, -2450.712158203125, 13.44131183624267578, 100, 0, 0),
|
|
(@CGUID + 000, 20, -9122.2783203125, -2424.206542968750, 12.01519393920898437, 100, 0, 0),
|
|
(@CGUID + 000, 21, -9150.5048828125, -2410.171142578125, 13.99623680114746093, 100, 0, 0),
|
|
(@CGUID + 000, 22, -9190.2480468750, -2421.655029296875, 11.31167221069335937, 100, 0, 0),
|
|
(@CGUID + 000, 23, -9186.6542968750, -2381.810546875000, 14.29308605194091796, 100, 0, 0),
|
|
(@CGUID + 000, 24, -9221.6005859375, -2378.989501953125, 9.194367408752441406, 100, 0, 0),
|
|
(@CGUID + 000, 25, -9249.5996093750, -2379.208984375000, 9.674419403076171875, 100, 0, 0),
|
|
(@CGUID + 000, 26, -9294.3427734375, -2389.738281250000, 9.353342056274414062, 100, 0, 0),
|
|
(@CGUID + 000, 27, -9313.3789062500, -2384.879638671875, 10.63077735900878906, 100, 0, 0),
|
|
(@CGUID + 000, 28, -9315.5126953125, -2350.405761718750, 10.10389709472656250, 100, 0, 0),
|
|
(@CGUID + 000, 29, -9325.8281250000, -2321.473632812500, 13.23990821838378906, 100, 0, 0),
|
|
(@CGUID + 000, 30, -9353.4355468750, -2311.291259765625, 10.61248779296875000, 100, 0, 0),
|
|
(@CGUID + 000, 31, -9385.0595703125, -2295.812500000000, 13.63875579833984375, 100, 0, 0),
|
|
(@CGUID + 000, 32, -9417.5957031250, -2303.720458984375, 10.19332981109619140, 100, 0, 0),
|
|
(@CGUID + 000, 33, -9437.9296875000, -2326.656250000000, 11.71352958679199218, 100, 0, 0),
|
|
(@CGUID + 000, 34, -9451.1806640625, -2328.438232421875, 12.87790870666503906, 100, 0, 0),
|
|
(@CGUID + 000, 35, -9446.8115234375, -2314.581542968750, 12.90997505187988281, 100, 0, 0),
|
|
(@CGUID + 001, 01, -9320.7685546875, -3248.845703125000, 13.20740032196044921, 100, 0, 0),
|
|
(@CGUID + 001, 02, -9283.1308593750, -3232.589843750000, 14.97260475158691406, 100, 0, 0),
|
|
(@CGUID + 001, 03, -9260.1298828125, -3243.360107421875, 19.27468490600585937, 100, 0, 0),
|
|
(@CGUID + 001, 04, -9242.4052734375, -3245.273925781250, 18.20835876464843750, 100, 0, 0),
|
|
(@CGUID + 001, 05, -9215.4375000000, -3240.296142578125, 21.53125572204589843, 100, 0, 0),
|
|
(@CGUID + 001, 06, -9183.9667968750, -3226.774414062500, 27.85487365722656250, 100, 0, 0),
|
|
(@CGUID + 001, 07, -9151.3164062500, -3256.741699218750, 36.13136291503906250, 100, 0, 0),
|
|
(@CGUID + 001, 08, -9147.2412109375, -3283.485107421875, 35.22916793823242187, 100, 0, 0),
|
|
(@CGUID + 001, 09, -9119.9042968750, -3309.420654296875, 36.97422027587890625, 100, 0, 0),
|
|
(@CGUID + 001, 10, -9106.6093750000, -3344.773925781250, 33.84967041015625000, 100, 0, 0),
|
|
(@CGUID + 001, 11, -9080.5605468750, -3354.991455078125, 31.51989364624023437, 100, 0, 0),
|
|
(@CGUID + 001, 12, -9078.4492187500, -3384.667480468750, 29.53237915039062500, 100, 0, 0),
|
|
(@CGUID + 001, 13, -9105.9863281250, -3408.255126953125, 26.99789047241210937, 100, 0, 0),
|
|
(@CGUID + 001, 14, -9120.4482421875, -3443.803466796875, 19.10015869140625000, 100, 0, 0),
|
|
(@CGUID + 001, 15, -9125.4072265625, -3473.292968750000, 16.28382110595703125, 100, 0, 0),
|
|
(@CGUID + 001, 16, -9127.7050781250, -3515.210937500000, 11.99044990539550781, 100, 0, 0),
|
|
(@CGUID + 001, 17, -9151.4980468750, -3509.113281250000, 12.76969051361083984, 100, 0, 0),
|
|
(@CGUID + 001, 18, -9162.5878906250, -3475.293212890625, 17.19145584106445312, 100, 0, 0),
|
|
(@CGUID + 001, 19, -9184.3652343750, -3462.753173828125, 15.22582149505615234, 100, 0, 0),
|
|
(@CGUID + 001, 20, -9225.4746093750, -3460.253173828125, 11.14323425292968750, 100, 0, 0),
|
|
(@CGUID + 001, 21, -9247.8115234375, -3462.593994140625, 9.839579582214355468, 100, 0, 0),
|
|
(@CGUID + 001, 22, -9281.6933593750, -3487.072509765625, 13.07864475250244140, 100, 0, 0),
|
|
(@CGUID + 001, 23, -9302.3359375000, -3520.207031250000, 10.20482254028320312, 100, 0, 0),
|
|
(@CGUID + 001, 24, -9340.5576171875, -3543.768798828125, 10.39544486999511718, 100, 0, 0),
|
|
(@CGUID + 001, 25, -9352.8203125000, -3575.061279296875, 11.25701522827148437, 100, 0, 0),
|
|
(@CGUID + 001, 26, -9381.9130859375, -3588.235595703125, 10.54041385650634765, 100, 0, 0),
|
|
(@CGUID + 001, 27, -9384.9707031250, -3554.053710937500, 12.34381866455078125, 100, 0, 0),
|
|
(@CGUID + 001, 28, -9403.2919921875, -3513.729492187500, 11.61666488647460937, 100, 0, 0),
|
|
(@CGUID + 001, 29, -9414.9306640625, -3478.192626953125, 11.05865764617919921, 100, 0, 0),
|
|
(@CGUID + 001, 30, -9390.1933593750, -3451.469238281250, 9.250702857971191406, 100, 0, 0),
|
|
(@CGUID + 001, 31, -9371.9003906250, -3410.523925781250, 9.409759521484375000, 100, 0, 0),
|
|
(@CGUID + 001, 32, -9355.7158203125, -3391.891113281250, 12.11553478240966796, 100, 0, 0),
|
|
(@CGUID + 001, 33, -9373.3095703125, -3345.792724609375, 10.19577503204345703, 100, 0, 0),
|
|
(@CGUID + 001, 34, -9356.4570312500, -3312.271728515625, 9.987246513366699218, 100, 0, 0),
|
|
(@CGUID + 001, 35, -9345.4101562500, -3283.310302734375, 11.35177135467529296, 100, 0, 0),
|
|
(@CGUID + 001, 36, -9343.3642578125, -3256.980957031250, 9.805130958557128906, 100, 0, 0),
|
|
(@CGUID + 002, 01, -8552.9931640625, -2480.630126953125, 43.58976745605468750, 100, 0, 0),
|
|
(@CGUID + 002, 02, -8554.1386718750, -2452.038330078125, 39.49771118164062500, 100, 0, 0),
|
|
(@CGUID + 002, 03, -8560.8164062500, -2418.295166015625, 35.95244979858398437, 100, 0, 0),
|
|
(@CGUID + 002, 04, -8584.9394531250, -2394.041748046875, 36.06273651123046875, 100, 0, 0),
|
|
(@CGUID + 002, 05, -8602.7001953125, -2365.413330078125, 33.89320373535156250, 100, 0, 0),
|
|
(@CGUID + 002, 06, -8612.2070312500, -2331.177001953125, 28.96505355834960937, 100, 0, 0),
|
|
(@CGUID + 002, 07, -8613.2031250000, -2298.274414062500, 23.00893020629882812, 100, 0, 0),
|
|
(@CGUID + 002, 08, -8596.2255859375, -2272.710205078125, 20.16155433654785156, 100, 0, 0),
|
|
(@CGUID + 002, 09, -8587.1699218750, -2244.272705078125, 17.46678543090820312, 100, 0, 0),
|
|
(@CGUID + 002, 10, -8556.1289062500, -2235.965332031250, 24.50625228881835937, 100, 0, 0),
|
|
(@CGUID + 002, 11, -8519.9658203125, -2241.717041015625, 26.05261611938476562, 100, 0, 0),
|
|
(@CGUID + 002, 12, -8490.1386718750, -2218.689208984375, 25.54828071594238281, 100, 0, 0),
|
|
(@CGUID + 002, 13, -8456.7324218750, -2228.298583984375, 19.90684700012207031, 100, 0, 0),
|
|
(@CGUID + 002, 14, -8417.1601562500, -2237.218750000000, 18.88458251953125000, 100, 0, 0),
|
|
(@CGUID + 002, 15, -8380.1962890625, -2227.798583984375, 15.36701774597167968, 100, 0, 0),
|
|
(@CGUID + 002, 16, -8349.3574218750, -2249.828125000000, 17.69555091857910156, 100, 0, 0),
|
|
(@CGUID + 002, 17, -8343.8095703125, -2287.210205078125, 23.53313064575195312, 100, 0, 0),
|
|
(@CGUID + 002, 18, -8340.6699218750, -2320.668457031250, 25.14926719665527343, 100, 0, 0),
|
|
(@CGUID + 002, 19, -8339.4863281250, -2350.835205078125, 22.57168960571289062, 100, 0, 0),
|
|
(@CGUID + 002, 20, -8355.2656250000, -2382.774414062500, 27.90193176269531250, 100, 0, 0),
|
|
(@CGUID + 002, 21, -8348.7812500000, -2413.644042968750, 31.92746734619140625, 100, 0, 0),
|
|
(@CGUID + 002, 22, -8346.2255859375, -2452.965332031250, 40.40525054931640625, 100, 0, 0),
|
|
(@CGUID + 002, 23, -8344.2607421875, -2486.059082031250, 44.48834991455078125, 100, 0, 0),
|
|
(@CGUID + 002, 24, -8378.2138671875, -2514.703125000000, 43.99817657470703125, 100, 0, 0),
|
|
(@CGUID + 002, 25, -8410.6005859375, -2519.810791015625, 46.89253234863281250, 100, 0, 0),
|
|
(@CGUID + 002, 26, -8416.4794921875, -2544.899414062500, 46.23678588867187500, 100, 0, 0),
|
|
(@CGUID + 002, 27, -8444.4511718750, -2533.020751953125, 49.78962707519531250, 100, 0, 0),
|
|
(@CGUID + 002, 28, -8483.6474609375, -2531.137207031250, 43.50554656982421875, 100, 0, 0),
|
|
(@CGUID + 002, 29, -8508.5957031250, -2526.782958984375, 43.14655685424804687, 100, 0, 0),
|
|
(@CGUID + 002, 30, -8545.7011718750, -2517.154541015625, 46.86783599853515625, 100, 0, 0),
|
|
(@CGUID + 003, 01, -9396.6396484375, -2547.475585937500, 14.51880550384521484, 100, 0, 0),
|
|
(@CGUID + 003, 02, -9380.9238281250, -2583.621582031250, 12.29161071777343750, 100, 0, 0),
|
|
(@CGUID + 003, 03, -9384.1025390625, -2630.790771484375, 13.31372356414794921, 100, 0, 0),
|
|
(@CGUID + 003, 04, -9372.1318359375, -2649.452148437500, 11.96731567382812500, 100, 0, 0),
|
|
(@CGUID + 003, 05, -9342.2001953125, -2655.097656250000, 10.49068737030029296, 100, 0, 0),
|
|
(@CGUID + 003, 06, -9313.8476562500, -2651.707519531250, 9.817366600036621093, 100, 0, 0),
|
|
(@CGUID + 003, 07, -9281.8876953125, -2662.852050781250, 10.97669410705566406, 100, 0, 0),
|
|
(@CGUID + 003, 08, -9284.8427734375, -2699.722656250000, 10.70173645019531250, 100, 0, 0),
|
|
(@CGUID + 003, 09, -9264.0234375000, -2725.310546875000, 12.86223125457763671, 100, 0, 0),
|
|
(@CGUID + 003, 10, -9224.1757812500, -2711.190673828125, 16.59833335876464843, 100, 0, 0),
|
|
(@CGUID + 003, 11, -9190.3007812500, -2711.890625000000, 20.04908370971679687, 100, 0, 0),
|
|
(@CGUID + 003, 12, -9174.6191406250, -2678.359375000000, 17.80528450012207031, 100, 0, 0),
|
|
(@CGUID + 003, 13, -9137.4277343750, -2659.137451171875, 25.92065048217773437, 100, 0, 0),
|
|
(@CGUID + 003, 14, -9115.6816406250, -2656.976318359375, 26.36733055114746093, 100, 0, 0),
|
|
(@CGUID + 003, 15, -9107.6025390625, -2614.376220703125, 23.18203926086425781, 100, 0, 0),
|
|
(@CGUID + 003, 16, -9124.0205078125, -2590.663818359375, 21.52391815185546875, 100, 0, 0),
|
|
(@CGUID + 003, 17, -9152.5000000000, -2584.329589843750, 19.12607192993164062, 100, 0, 0),
|
|
(@CGUID + 003, 18, -9180.4550781250, -2546.749267578125, 12.54204654693603515, 100, 0, 0),
|
|
(@CGUID + 003, 19, -9180.0966796875, -2518.708251953125, 15.00188636779785156, 100, 0, 0),
|
|
(@CGUID + 003, 20, -9188.7626953125, -2486.136230468750, 11.50319480895996093, 100, 0, 0),
|
|
(@CGUID + 003, 21, -9223.4970703125, -2482.448730468750, 10.54748249053955078, 100, 0, 0),
|
|
(@CGUID + 003, 22, -9222.1767578125, -2460.598876953125, 12.18933010101318359, 100, 0, 0),
|
|
(@CGUID + 003, 23, -9250.3505859375, -2443.025390625000, 11.82130336761474609, 100, 0, 0),
|
|
(@CGUID + 003, 24, -9288.9111328125, -2416.033691406250, 8.978369712829589843, 100, 0, 0),
|
|
(@CGUID + 003, 25, -9324.5781250000, -2424.419189453125, 11.48021316528320312, 100, 0, 0),
|
|
(@CGUID + 003, 26, -9353.8789062500, -2444.981201171875, 11.89876651763916015, 100, 0, 0),
|
|
(@CGUID + 003, 27, -9380.1035156250, -2457.328125000000, 13.06135082244873046, 100, 0, 0),
|
|
(@CGUID + 003, 28, -9384.6337890625, -2483.430175781250, 11.29103279113769531, 100, 0, 0),
|
|
(@CGUID + 003, 29, -9406.7187500000, -2495.613525390625, 11.84807395935058593, 100, 0, 0),
|
|
(@CGUID + 003, 30, -9413.5078125000, -2521.359619140625, 13.28790283203125000, 100, 0, 0),
|
|
(@CGUID + 004, 01, -9375.8261718750, -3192.447509765625, 9.814928054809570312, 100, 0, 0),
|
|
(@CGUID + 004, 02, -9354.8906250000, -3207.339355468750, 9.649846076965332031, 100, 0, 0),
|
|
(@CGUID + 004, 03, -9322.0039062500, -3239.536865234375, 13.09112930297851562, 100, 0, 0),
|
|
(@CGUID + 004, 04, -9290.3027343750, -3262.082031250000, 12.98227596282958984, 100, 0, 0),
|
|
(@CGUID + 004, 05, -9283.6455078125, -3281.194091796875, 14.43091201782226562, 100, 0, 0),
|
|
(@CGUID + 004, 06, -9275.9130859375, -3322.461914062500, 14.85074996948242187, 100, 0, 0),
|
|
(@CGUID + 004, 07, -9250.7070312500, -3340.007080078125, 18.72478675842285156, 100, 0, 0),
|
|
(@CGUID + 004, 08, -9228.2851562500, -3366.873046875000, 18.21942329406738281, 100, 0, 0),
|
|
(@CGUID + 004, 09, -9218.2236328125, -3391.592529296875, 16.72125434875488281, 100, 0, 0),
|
|
(@CGUID + 004, 10, -9196.4082031250, -3401.498779296875, 17.78776931762695312, 100, 0, 0),
|
|
(@CGUID + 004, 11, -9172.1376953125, -3421.335205078125, 16.75361633300781250, 100, 0, 0),
|
|
(@CGUID + 004, 12, -9150.8017578125, -3446.058593750000, 16.40876197814941406, 100, 0, 0),
|
|
(@CGUID + 004, 13, -9125.3535156250, -3480.507080078125, 16.14061546325683593, 100, 0, 0),
|
|
(@CGUID + 004, 14, -9113.6787109375, -3522.532470703125, 11.78295612335205078, 100, 0, 0),
|
|
(@CGUID + 004, 15, -9107.5058593750, -3550.616455078125, 10.73529243469238281, 100, 0, 0),
|
|
(@CGUID + 004, 16, -9087.2470703125, -3576.774414062500, 9.771128654479980468, 100, 0, 0),
|
|
(@CGUID + 004, 17, -9081.3798828125, -3613.214111328125, 10.20491504669189453, 100, 0, 0),
|
|
(@CGUID + 004, 18, -9058.0527343750, -3652.335205078125, 9.570553779602050781, 100, 0, 0),
|
|
(@CGUID + 004, 19, -9081.3798828125, -3613.214111328125, 10.20491504669189453, 100, 0, 0),
|
|
(@CGUID + 004, 20, -9087.2470703125, -3576.774414062500, 9.771128654479980468, 100, 0, 0),
|
|
(@CGUID + 004, 21, -9107.5058593750, -3550.616455078125, 10.73529243469238281, 100, 0, 0),
|
|
(@CGUID + 004, 22, -9113.6787109375, -3522.532470703125, 11.78295612335205078, 100, 0, 0),
|
|
(@CGUID + 004, 23, -9125.3535156250, -3480.507080078125, 16.14061546325683593, 100, 0, 0),
|
|
(@CGUID + 004, 24, -9150.8017578125, -3446.058593750000, 16.40876197814941406, 100, 0, 0),
|
|
(@CGUID + 004, 25, -9172.1376953125, -3421.335205078125, 16.75361633300781250, 100, 0, 0),
|
|
(@CGUID + 004, 26, -9196.4082031250, -3401.498779296875, 17.78776931762695312, 100, 0, 0),
|
|
(@CGUID + 004, 27, -9218.2236328125, -3391.592529296875, 16.72125434875488281, 100, 0, 0),
|
|
(@CGUID + 004, 28, -9228.2851562500, -3366.873046875000, 18.21942329406738281, 100, 0, 0),
|
|
(@CGUID + 004, 29, -9250.7070312500, -3340.007080078125, 18.72478675842285156, 100, 0, 0),
|
|
(@CGUID + 004, 30, -9275.9130859375, -3322.461914062500, 14.85074996948242187, 100, 0, 0),
|
|
(@CGUID + 004, 31, -9283.6455078125, -3281.194091796875, 14.43091201782226562, 100, 0, 0),
|
|
(@CGUID + 004, 32, -9290.3027343750, -3262.082031250000, 12.98227596282958984, 100, 0, 0),
|
|
(@CGUID + 004, 33, -9322.0039062500, -3239.536865234375, 13.09112930297851562, 100, 0, 0),
|
|
(@CGUID + 004, 34, -9354.8906250000, -3207.339355468750, 9.649846076965332031, 100, 0, 0);
|
|
|
|
-- Starving Blisterpaw | Roc
|
|
DELETE FROM `creature` WHERE `guid` IN (22382, 22386, 22663, 22664, 22671, 22674, 22675, 22676, 22677, 22678, 22679);
|
|
SET @CGUID := 23077;
|
|
INSERT INTO `creature` (`guid`, `id`, `id2`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecsmin`, `spawntimesecsmax`, `wander_distance`, `movement_type`) VALUES
|
|
(@CGUID + 000, 5425, 5428, 1, -7539.86279296875, -3618.805175781250, 10.60434913635253906, 4.037419319152832031, 300, 300, 5, 1),
|
|
(@CGUID + 001, 5425, 5428, 1, -7511.94628906250, -3616.762207031250, 11.67174720764160156, 0.195046916604042053, 300, 300, 5, 1),
|
|
(@CGUID + 002, 5425, 5428, 1, -7524.02246093750, -3651.031250000000, 9.165461540222167968, 0.946387410163879394, 300, 300, 5, 1),
|
|
(@CGUID + 003, 5425, 5428, 1, -7581.89501953125, -3612.707031250000, 13.36350727081298828, 3.699348688125610351, 300, 300, 5, 1),
|
|
(@CGUID + 004, 5425, 5428, 1, -7557.45166015625, -3628.996582031250, 12.84375000000000000, 3.399337530136108398, 300, 300, 5, 1),
|
|
(@CGUID + 005, 5425, 5428, 1, -7550.18408203125, -3593.723144531250, 14.01746654510498046, 1.356296300888061523, 300, 300, 5, 1),
|
|
(@CGUID + 006, 5425, 5428, 1, -7499.34228515625, -3660.509033203125, 10.03567409515380859, 4.447729110717773437, 300, 300, 5, 1);
|
|
|
|
|
|
-- End of migration.
|
|
END IF;
|
|
END??
|
|
DELIMITER ;
|
|
CALL add_migration();
|
|
DROP PROCEDURE IF EXISTS add_migration;
|