Daribon
100 lines
4.5 KiB
SQL
100 lines
4.5 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`='20250217213525');
|
|
IF v = 0 THEN
|
|
INSERT INTO `migrations` VALUES ('20250217213525');
|
|
-- Add your query below.
|
|
|
|
|
|
-- Pathing for Putridius Entry: 1850
|
|
SET @NPC := 53783;
|
|
UPDATE `creature` SET `wander_distance`=0,`movement_type`=2,`position_x`=1441.128,`position_y`=-1702.1013,`position_z`=69.14795 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,1441.128,-1702.1013,69.14795,100,0,0,0),
|
|
(@NPC,2,1470.5299,-1703.044,69.55746,100,0,0,0),
|
|
(@NPC,3,1500.077,-1696.2979,69.01784,100,0,0,0),
|
|
(@NPC,4,1517.9703,-1682.0538,68.88672,100,0,0,0),
|
|
(@NPC,5,1530.0493,-1657.652,69.60418,100,0,0,0),
|
|
(@NPC,6,1523.996,-1631.0283,64.68889,100,0,0,0),
|
|
(@NPC,7,1517.0034,-1594.9679,64.310585,100,0,0,0),
|
|
(@NPC,8,1516.2382,-1570.24,64.42085,100,0,0,0),
|
|
(@NPC,9,1531.7671,-1557.3578,65.02641,100,0,0,0),
|
|
(@NPC,10,1558.8406,-1551.4109,63.320652,100,0,0,0),
|
|
(@NPC,11,1559.646,-1534.9214,61.85451,100,0,0,0),
|
|
(@NPC,12,1553.1687,-1519.9006,62.169403,100,0,0,0),
|
|
(@NPC,13,1545.8247,-1511.4066,62.71369,100,0,0,0),
|
|
(@NPC,14,1544.4586,-1498.8903,65.137276,100,0,0,0),
|
|
(@NPC,15,1534.375,-1484.2836,64.65106,100,0,0,0),
|
|
(@NPC,16,1520.0771,-1479.83,69.106026,100,0,0,0),
|
|
(@NPC,17,1511.458,-1469.7716,61.080738,100,0,0,0),
|
|
(@NPC,18,1479.7117,-1459.5708,59.29191,100,0,0,0),
|
|
(@NPC,19,1456.5065,-1457.1132,56.479332,100,0,0,0),
|
|
(@NPC,20,1429.0111,-1452.634,66.1878,100,0,0,0),
|
|
(@NPC,21,1429.4508,-1425.0176,55.820644,100,0,0,0),
|
|
(@NPC,22,1420.9391,-1398.413,55.228134,100,0,0,0),
|
|
(@NPC,23,1421.875,-1386.2952,55.314377,100,0,0,0),
|
|
(@NPC,24,1422.6912,-1372.5125,59.64035,100,0,0,0),
|
|
(@NPC,25,1434.7366,-1362.5603,60.552624,100,0,0,0),
|
|
(@NPC,26,1444.4141,-1351.041,61.38566,100,0,0,0),
|
|
(@NPC,27,1457.4983,-1334.3278,62.28894,100,0,0,0),
|
|
(@NPC,28,1454.2948,-1312.6991,61.71901,100,0,0,0),
|
|
(@NPC,29,1437.9128,-1286.3942,70.84105,100,0,0,0),
|
|
(@NPC,30,1424.3004,-1262.1735,61.161823,100,0,0,0),
|
|
(@NPC,31,1412.2902,-1252.1832,61.898315,100,0,0,0),
|
|
(@NPC,32,1387.0747,-1243.0771,72.22103,100,0,0,0),
|
|
(@NPC,33,1369.0714,-1242.8506,71.8652,100,0,0,0),
|
|
(@NPC,34,1350.8893,-1252.5977,71.24766,100,0,0,0),
|
|
(@NPC,35,1346.791,-1262.6707,70.062614,100,0,0,0),
|
|
(@NPC,36,1333.333,-1272.916,58.249096,100,0,0,0),
|
|
(@NPC,37,1310.7151,-1275.5695,60.36235,100,0,0,0),
|
|
(@NPC,38,1288.2098,-1289.9648,64.02403,100,0,0,0),
|
|
(@NPC,39,1277.3883,-1306.8651,63.59009,100,0,0,0),
|
|
(@NPC,40,1272.7399,-1317.6027,64.377686,100,0,0,0),
|
|
(@NPC,41,1253.158,-1324.8967,65.83177,100,0,0,0),
|
|
(@NPC,42,1242.816,-1346.8357,51.056152,100,0,0,0),
|
|
(@NPC,43,1246.1328,-1365.4425,50.18833,100,0,0,0),
|
|
(@NPC,44,1248.65,-1384.2697,49.752197,100,0,0,0),
|
|
(@NPC,45,1243.1559,-1401.041,56.022312,100,0,0,0),
|
|
(@NPC,46,1238.356,-1425.2643,57.5148,100,0,0,0),
|
|
(@NPC,47,1243.7333,-1447.4899,71.70333,100,0,0,0),
|
|
(@NPC,48,1236.2955,-1462.1661,70.99679,100,0,0,0),
|
|
(@NPC,49,1240.4355,-1480.4974,60.638054,100,0,0,0),
|
|
(@NPC,50,1252.477,-1498.2086,72.046974,100,0,0,0),
|
|
(@NPC,51,1267.6012,-1509.9727,71.85718,100,0,0,0),
|
|
(@NPC,52,1255.6248,-1524.6968,71.20905,100,0,0,0),
|
|
(@NPC,53,1252.1057,-1543.919,71.24235,100,0,0,0),
|
|
(@NPC,54,1255.5504,-1556.6777,59.508686,100,0,0,0),
|
|
(@NPC,55,1271.2576,-1572.5536,59.689045,100,0,0,0),
|
|
(@NPC,56,1282.3066,-1592.8759,72.217705,100,0,0,0),
|
|
(@NPC,57,1286.5552,-1609.4186,70.85879,100,0,0,0),
|
|
(@NPC,58,1298.1696,-1612.142,72.342255,100,0,0,0),
|
|
(@NPC,59,1310.7205,-1623.4746,70.851944,100,0,0,0),
|
|
(@NPC,60,1319.8727,-1626.9453,61.508762,100,0,0,0),
|
|
(@NPC,61,1328.5212,-1622.5651,62.294144,100,0,0,0),
|
|
(@NPC,62,1338.2036,-1624.4087,57.33972,100,0,0,0),
|
|
(@NPC,63,1336.7316,-1637.7057,63.86055,100,0,0,0),
|
|
(@NPC,64,1334.5106,-1649.5819,63.707737,100,0,0,0),
|
|
(@NPC,65,1348.9961,-1658.0078,64.168564,100,0,0,0),
|
|
(@NPC,66,1355.7705,-1663.9082,62.944183,100,0,0,0),
|
|
(@NPC,67,1355.834,-1677.9163,63.194946,100,0,0,0),
|
|
(@NPC,68,1364.1691,-1684.2384,64.93261,100,0,0,0),
|
|
(@NPC,69,1374.4467,-1685.4393,67.063354,100,0,0,0),
|
|
(@NPC,70,1386.7136,-1688.2301,67.173744,100,0,0,0),
|
|
(@NPC,71,1386.0287,-1686.2324,67.20324,100,0,0,0),
|
|
(@NPC,72,1398.3367,-1695.0243,70.02606,100,0,0,0),
|
|
(@NPC,73,1404.9036,-1697.8293,70.11075,100,0,0,0),
|
|
(@NPC,74,1418.483,-1700.078,69.592705,100,0,0,0);
|
|
-- 0x205660000001CE8000001500006039FD .go xyz 1441.128 -1702.1013 69.14795
|
|
|
|
|
|
-- End of migration.
|
|
END IF;
|
|
END??
|
|
DELIMITER ;
|
|
CALL add_migration();
|
|
DROP PROCEDURE IF EXISTS add_migration;
|