c59e50926e
credit cmangos
141 lines
7.9 KiB
SQL
141 lines
7.9 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`='20250802142638');
|
|
IF v = 0 THEN
|
|
INSERT INTO `migrations` VALUES ('20250802142638');
|
|
-- Add your query below.
|
|
|
|
|
|
-- Rok Orhan 7777 correct path (credit cmangos)
|
|
SET @POINT := 0;
|
|
UPDATE `creature` SET `position_x` = -4352.929, `position_y` = 162.05904, `position_z` = 34.11833 WHERE `id` = 7777;
|
|
DELETE FROM `creature_movement` WHERE `id` IN (50148);
|
|
DELETE FROM `creature_movement_template` WHERE `entry` = 7777;
|
|
INSERT INTO `creature_movement_template` (`entry`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `script_id`) VALUES
|
|
(7777,(@POINT := @POINT + 1),-4352.929,162.05904,34.11833,100,1500,0),
|
|
(7777,(@POINT := @POINT + 1),-4353.4795,147.17014,33.70603,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4354.757,136.97896,32.395763,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4359.996,127.70117,30.779827,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4368.82,125.94347,29.559437,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4377.616,135.7857,25.934422,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4382.8135,152.89757,25.018053,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4385.0176,168.07477,25.51953,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4387.2134,178.86247,26.208843,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4389.762,190.3245,25.413338,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4391.971,200.90837,25.413338,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4394.1494,214.4924,25.413334,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4396.48,225.4031,25.413338,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4398.602,235.55305,25.486492,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4401.0044,246.20149,25.487724,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4402.9917,256.96024,25.22795,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4403.375,269.2506,25.239697,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4413.7837,274.77768,25.19027,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4426.998,277.20145,27.51678,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4438.464,284.93213,30.902695,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4447.9897,291.48486,34.02515,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4460.7812,300.58243,38.288265,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4472.895,307.39703,39.42307,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4483.158,310.72943,39.457165,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4497.0605,316.2712,37.881943,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4508.2446,320.63986,36.51437,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4519.1904,324.6919,34.65346,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4522.4204,331.30322,34.185623,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4509.3765,337.18668,38.29937,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4495.6235,337.70724,41.460365,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4483.0234,337.42325,44.24193,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4472.284,336.4077,47.04915,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4463.5156,334.08752,48.847027,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4457.1855,331.09375,50.20791,100,1000,0),
|
|
(7777,(@POINT := @POINT + 1),-4463.5156,334.08752,48.847027,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4472.284,336.4077,47.04915,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4483.0234,337.42325,44.24193,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4495.6235,337.70724,41.460365,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4509.3765,337.18668,38.29937,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4522.4204,331.30322,34.185623,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4519.1904,324.6919,34.65346,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4508.2446,320.63986,36.51437,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4497.0605,316.2712,37.881943,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4483.158,310.72943,39.457165,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4472.895,307.39703,39.42307,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4460.7812,300.58243,38.288265,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4447.9897,291.48486,34.02515,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4438.464,284.93213,30.902695,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4426.998,277.20145,27.51678,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4413.7837,274.77768,25.19027,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4403.375,269.2506,25.239697,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4402.9917,256.96024,25.22795,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4401.0044,246.20149,25.487724,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4398.602,235.55305,25.486492,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4396.48,225.4031,25.413338,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4394.1494,214.4924,25.413334,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4391.971,200.90837,25.413338,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4389.762,190.3245,25.413338,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4387.2134,178.86247,26.208843,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4385.0176,168.07477,25.51953,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4382.8135,152.89757,25.018053,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4377.616,135.7857,25.934422,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4368.82,125.94347,29.559437,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4359.996,127.70117,30.779827,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4354.757,136.97896,32.395763,100,0,0),
|
|
(7777,(@POINT := @POINT + 1),-4353.4795,147.17014,33.70603,100,0,0);
|
|
|
|
-- Sage Korolusk 14373
|
|
UPDATE `creature` SET `position_x` = -4405.425, `position_y` = 273.8598, `position_z` = 25.177431 WHERE `id` = 14373;
|
|
DELETE FROM `creature_movement` WHERE `id` IN (50010);
|
|
DELETE FROM `creature_movement_template` WHERE `entry` = 14373;
|
|
INSERT INTO `creature_movement_template` (`entry`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `script_id`) VALUES
|
|
(14373,1,-4405.425,273.8598,25.177431,100,1500,0),
|
|
(14373,2,-4405.425,273.8598,25.177431,100,0,0),
|
|
(14373,3,-4399.557,240.45909,25.454268,100,0,0),
|
|
(14373,4,-4394.1465,212.48395,25.413332,100,1500,0),
|
|
(14373,5,-4399.557,240.45909,25.454268,100,0,0);
|
|
|
|
-- Camp Mojache Brave 8147
|
|
UPDATE `creature` SET `position_x` = -4365.682, `position_y` = 123.31185, `position_z` = 30.399422 WHERE `guid` = 51412;
|
|
DELETE FROM `creature_movement` WHERE `id` IN (51412);
|
|
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `script_id`) VALUES
|
|
(51412,1,-4365.682,123.31185,30.399422,100,500,0),
|
|
(51412,2,-4375.086,135.00195,26.166523,100,0,0),
|
|
(51412,3,-4381.3623,148.52637,24.90498,100,0,0),
|
|
(51412,4,-4384.0273,167.89383,25.463293,100,0,0),
|
|
(51412,5,-4386.4136,180.08339,26.20016,100,0,0),
|
|
(51412,6,-4389.9995,196.7723,25.445099,100,0,0),
|
|
(51412,7,-4392.167,210.28261,25.413332,100,0,0),
|
|
(51412,8,-4393.4883,220.5235,25.484669,100,0,0),
|
|
(51412,9,-4397.3003,230.25993,25.433254,100,0,0),
|
|
(51412,10,-4398.9517,242.32086,25.413637,100,0,0),
|
|
(51412,11,-4401.9775,254.2779,25.50597,100,0,0),
|
|
(51412,12,-4406.1426,271.4949,25.140732,100,0,0),
|
|
(51412,13,-4417.3223,275.87695,25.69946,100,0,0),
|
|
(51412,14,-4451.9736,292.77335,35.18616,100,0,0),
|
|
(51412,15,-4461.311,301.7609,38.500603,100,500,0),
|
|
(51412,16,-4450.158,292.74887,34.76593,100,0,0),
|
|
(51412,17,-4437.3145,283.2168,30.376562,100,0,0),
|
|
(51412,18,-4426.9087,278.03586,27.720312,100,0,0),
|
|
(51412,19,-4420.414,275.4375,26.295704,100,0,0),
|
|
(51412,20,-4409.132,275.95743,25.073576,100,0,0),
|
|
(51412,21,-4401.287,260.38596,25.328178,100,0,0),
|
|
(51412,22,-4400.8213,252.50739,25.500538,100,0,0),
|
|
(51412,23,-4396.013,229.67746,25.413334,100,0,0),
|
|
(51412,24,-4394.945,219.99626,25.415085,100,0,0),
|
|
(51412,25,-4392.841,210.73839,25.413332,100,0,0),
|
|
(51412,26,-4391.4536,205.62495,25.413332,100,0,0),
|
|
(51412,27,-4390.8633,197.16574,25.413338,100,0,0),
|
|
(51412,28,-4388.677,186.93782,25.590288,100,0,0),
|
|
(51412,29,-4387.3325,178.33919,26.215887,100,0,0),
|
|
(51412,30,-4384.7925,168.1454,25.515898,100,0,0),
|
|
(51412,31,-4382.7935,153.34874,25.022898,100,0,0),
|
|
(51412,32,-4379.453,138.73047,25.443893,100,0,0),
|
|
(51412,33,-4370.53,129.64334,28.285967,100,0,0);
|
|
|
|
|
|
-- End of migration.
|
|
END IF;
|
|
END??
|
|
DELIMITER ;
|
|
CALL add_migration();
|
|
DROP PROCEDURE IF EXISTS add_migration;
|