Daribon
112 lines
5.2 KiB
SQL
112 lines
5.2 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`='20231113041814');
|
|
IF v=0 THEN
|
|
INSERT INTO `migrations` VALUES ('20231113041814');
|
|
-- Add your query below.
|
|
|
|
|
|
-- Pathing for Mirelow Entry: 14424
|
|
SET @NPC := 91113;
|
|
UPDATE `creature` SET `wander_distance`=0,`movement_type`=2,`position_x`=-2752.9434,`position_y`=-1311.9869,`position_z`=6.144358 WHERE `guid`=@NPC;
|
|
DELETE FROM `creature_movement` WHERE `id`=@NPC;
|
|
INSERT INTO `creature_movement` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`waittime`,`wander_distance`,`script_id`) VALUES
|
|
(@NPC,1,-2752.9434,-1311.9869,6.144358,100,0,0,0),
|
|
(@NPC,2,-2779.3325,-1318.1886,6.212498,100,0,0,0),
|
|
(@NPC,3,-2802.5144,-1327.2316,6.2124987,100,0,0,0),
|
|
(@NPC,4,-2841.5269,-1356.3691,6.2124963,100,0,0,0),
|
|
(@NPC,5,-2868.5942,-1383.6816,6.2125034,100,0,0,0),
|
|
(@NPC,6,-2888.584,-1418.0055,6.2125034,100,0,0,0),
|
|
(@NPC,7,-2915.9563,-1455.4119,6.2125106,100,0,0,0),
|
|
(@NPC,8,-2948.1558,-1477.9122,6.2125034,100,0,0,0),
|
|
(@NPC,9,-2979.6265,-1493.0153,6.2125106,100,0,0,0),
|
|
(@NPC,10,-3007.2742,-1519.1643,6.1943064,100,0,0,0),
|
|
(@NPC,11,-3030.377,-1531.1482,1.8713083,100,0,0,0),
|
|
(@NPC,12,-3050.034,-1538.9908,2.2948234,100,0,0,0),
|
|
(@NPC,13,-3068.111,-1529.2074,4.6410594,100,0,0,0),
|
|
(@NPC,14,-3048.722,-1507.4395,2.3030105,100,0,0,0),
|
|
(@NPC,15,-3045.1477,-1488.9481,6.1078167,100,0,0,0),
|
|
(@NPC,16,-3037.5547,-1465.8003,6.2125444,100,0,0,0),
|
|
(@NPC,17,-3013.2668,-1444.2893,6.2125444,100,0,0,0),
|
|
(@NPC,18,-2992.2075,-1423.2106,6.2125444,100,0,0,0),
|
|
(@NPC,19,-2982.6704,-1384.7448,6.2125444,100,0,0,0),
|
|
(@NPC,20,-2976.297,-1355.0217,6.1414337,100,0,0,0),
|
|
(@NPC,21,-2972.429,-1315.0929,6.212561,100,0,0,0),
|
|
(@NPC,22,-2959.098,-1289.4697,6.212534,100,0,0,0),
|
|
(@NPC,23,-2946.3533,-1262.2607,6.212534,100,0,0,0),
|
|
(@NPC,24,-2940.9849,-1235.0204,6.212534,100,0,0,0),
|
|
(@NPC,25,-2927.3582,-1214.3258,6.276264,100,0,0,0),
|
|
(@NPC,26,-2913.8328,-1184.8007,6.2125435,100,0,0,0),
|
|
(@NPC,27,-2913.718,-1156.6484,6.380024,100,0,0,0),
|
|
(@NPC,28,-2906.6707,-1130.346,6.3375435,100,0,0,0),
|
|
(@NPC,29,-2924.4268,-1129.007,6.262104,100,0,0,0),
|
|
(@NPC,30,-2948.263,-1141.3658,6.581269,100,0,0,0),
|
|
(@NPC,31,-2981.483,-1160.7555,6.2125306,100,0,0,0),
|
|
(@NPC,32,-3008.991,-1189.4165,6.3375306,100,0,0,0),
|
|
(@NPC,33,-3033.5713,-1223.1588,3.6263075,100,0,0,0),
|
|
(@NPC,34,-3058.1658,-1243.8303,6.385656,100,0,0,0),
|
|
(@NPC,35,-3084.6208,-1262.775,6.2125497,100,0,0,0),
|
|
(@NPC,36,-3110.9539,-1251.6007,5.657193,100,0,0,0),
|
|
(@NPC,37,-3127.4268,-1279.7166,6.2125597,100,0,0,0),
|
|
(@NPC,38,-3140.0647,-1310.3094,6.2125597,100,0,0,0),
|
|
(@NPC,39,-3129.7153,-1336.1788,6.2125444,100,0,0,0),
|
|
(@NPC,40,-3135.3235,-1368.5166,6.2125444,100,0,0,0),
|
|
(@NPC,41,-3156.5852,-1393.152,6.2125444,100,0,0,0),
|
|
(@NPC,42,-3176.052,-1410.8157,6.2125344,100,0,0,0),
|
|
(@NPC,43,-3184.6921,-1435.9547,6.2125344,100,0,0,0),
|
|
(@NPC,44,-3201.1177,-1461.5942,6.2125344,100,0,0,0),
|
|
(@NPC,45,-3184.6921,-1435.9547,6.2125344,100,0,0,0),
|
|
(@NPC,46,-3176.052,-1410.8157,6.2125344,100,0,0,0),
|
|
(@NPC,47,-3156.5852,-1393.152,6.2125444,100,0,0,0),
|
|
(@NPC,48,-3135.3235,-1368.5166,6.2125444,100,0,0,0),
|
|
(@NPC,49,-3129.7153,-1336.1788,6.2125444,100,0,0,0),
|
|
(@NPC,50,-3140.0647,-1310.3094,6.2125597,100,0,0,0),
|
|
(@NPC,51,-3127.4268,-1279.7166,6.2125597,100,0,0,0),
|
|
(@NPC,52,-3110.9539,-1251.6007,5.657193,100,0,0,0),
|
|
(@NPC,53,-3084.6208,-1262.775,6.2125497,100,0,0,0),
|
|
(@NPC,54,-3058.1658,-1243.8303,6.385656,100,0,0,0),
|
|
(@NPC,55,-3033.5713,-1223.1588,3.6263075,100,0,0,0),
|
|
(@NPC,56,-3008.991,-1189.4165,6.3375306,100,0,0,0),
|
|
(@NPC,57,-2981.483,-1160.7555,6.2125306,100,0,0,0),
|
|
(@NPC,58,-2948.263,-1141.3658,6.581269,100,0,0,0),
|
|
(@NPC,59,-2924.4268,-1129.007,6.262104,100,0,0,0),
|
|
(@NPC,60,-2906.6707,-1130.346,6.3375435,100,0,0,0),
|
|
(@NPC,61,-2913.718,-1156.6484,6.380024,100,0,0,0),
|
|
(@NPC,62,-2913.8281,-1184.6484,6.2125435,100,0,0,0),
|
|
(@NPC,63,-2927.3582,-1214.3258,6.276264,100,0,0,0),
|
|
(@NPC,64,-2940.9849,-1235.0204,6.212534,100,0,0,0),
|
|
(@NPC,65,-2946.3533,-1262.2607,6.212534,100,0,0,0),
|
|
(@NPC,66,-2959.098,-1289.4697,6.212534,100,0,0,0),
|
|
(@NPC,67,-2972.429,-1315.0929,6.212561,100,0,0,0),
|
|
(@NPC,68,-2976.297,-1355.0217,6.1414337,100,0,0,0),
|
|
(@NPC,69,-2982.6704,-1384.7448,6.2125444,100,0,0,0),
|
|
(@NPC,70,-2992.2075,-1423.2106,6.2125444,100,0,0,0),
|
|
(@NPC,71,-3013.2668,-1444.2893,6.2125444,100,0,0,0),
|
|
(@NPC,72,-3037.5547,-1465.8003,6.2125444,100,0,0,0),
|
|
(@NPC,73,-3045.1477,-1488.9481,6.1078167,100,0,0,0),
|
|
(@NPC,74,-3048.722,-1507.4395,2.3030105,100,0,0,0),
|
|
(@NPC,75,-3068.037,-1529.0762,4.6693797,100,0,0,0),
|
|
(@NPC,76,-3050.034,-1538.9908,2.2948234,100,0,0,0),
|
|
(@NPC,77,-3030.377,-1531.1482,1.8713083,100,0,0,0),
|
|
(@NPC,78,-3007.2742,-1519.1643,6.1943064,100,0,0,0),
|
|
(@NPC,79,-2979.6265,-1493.0153,6.2125106,100,0,0,0),
|
|
(@NPC,80,-2948.1558,-1477.9122,6.2125034,100,0,0,0),
|
|
(@NPC,81,-2915.9563,-1455.4119,6.2125106,100,0,0,0),
|
|
(@NPC,82,-2888.584,-1418.0055,6.2125034,100,0,0,0),
|
|
(@NPC,83,-2868.5942,-1383.6816,6.2125034,100,0,0,0),
|
|
(@NPC,84,-2841.5269,-1356.3691,6.2124963,100,0,0,0),
|
|
(@NPC,85,-2802.5144,-1327.2316,6.2124987,100,0,0,0),
|
|
(@NPC,86,-2779.3325,-1318.1886,6.212498,100,0,0,0);
|
|
-- 0x204CB000000E160000000600003E2E9A .go xyz -2752.9434 -1311.9869 6.144358
|
|
|
|
|
|
-- End of migration.
|
|
END IF;
|
|
END??
|
|
delimiter ;
|
|
CALL add_migration();
|
|
DROP PROCEDURE IF EXISTS add_migration;
|