Daribon
102 lines
5.0 KiB
SQL
102 lines
5.0 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`='20231024182947');
|
|
IF v=0 THEN
|
|
INSERT INTO `migrations` VALUES ('20231024182947');
|
|
-- Add your query below.
|
|
|
|
|
|
-- Pathing for Shadowprey Guardian Entry: 12338
|
|
SET @NPC := 27564;
|
|
UPDATE `creature` SET `wander_distance`=0,`movement_type`=2,`position_x`=-1793.7954,`position_y`=3049.9192,`position_z`=7.7940183 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,-1793.7954,3049.9192,7.7940183,100,0,0,0),
|
|
(@NPC,2,-1781.9744,3060.6672,13.734776,100,0,0,0),
|
|
(@NPC,3,-1770.8019,3070.4211,20.380772,100,0,0,0),
|
|
(@NPC,4,-1761.4573,3076.9875,24.536587,100,0,0,0),
|
|
(@NPC,5,-1750.0232,3082.0205,29.097078,100,0,0,0),
|
|
(@NPC,6,-1742.5325,3085.791,31.805965,100,0,0,0),
|
|
(@NPC,7,-1730.1333,3095.7947,35.005627,100,0,0,0),
|
|
(@NPC,8,-1709.0748,3101.7922,33.356182,100,0,0,0),
|
|
(@NPC,9,-1730.1333,3095.7947,35.005627,100,0,0,0),
|
|
(@NPC,10,-1742.5325,3085.791,31.805965,100,0,0,0),
|
|
(@NPC,11,-1750.0232,3082.0205,29.097078,100,0,0,0),
|
|
(@NPC,12,-1761.4573,3076.9875,24.536587,100,0,0,0),
|
|
(@NPC,13,-1770.8019,3070.4211,20.380772,100,0,0,0),
|
|
(@NPC,14,-1781.9744,3060.6672,13.734776,100,0,0,0);
|
|
-- 0x204CB000200C0C8000007B00029C65F0 .go xyz -1793.7954 3049.9192 7.7940183
|
|
|
|
-- Pathing for Shadowprey Guardian Entry: 12338
|
|
-- https://www.youtube.com/live/qUNgZOGIef4?si=N6HIgvF9KW4x3Z0D&t=7422
|
|
SET @NPC := 27559;
|
|
UPDATE `creature` SET `wander_distance`=0,`movement_type`=2,`position_x`=-1671.0707,`position_y`=3152.94,`position_z`=19.727245 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,-1671.0707,3152.94,19.727245,100,0,0,0),
|
|
(@NPC,2,-1686.7838,3167.599,11.89218,100,0,0,0),
|
|
(@NPC,3,-1702.9758,3177.741,6.649853,100,0,0,0),
|
|
(@NPC,4,-1713.1448,3190.7727,4.48373,100,0,0,0),
|
|
(@NPC,5,-1719.9011,3202.3035,4.3230968,100,0,0,0),
|
|
(@NPC,6,-1713.1448,3190.7727,4.48373,100,0,0,0),
|
|
(@NPC,7,-1702.9758,3177.741,6.649853,100,0,0,0),
|
|
(@NPC,8,-1686.8711,3167.6475,11.991773,100,0,0,0);
|
|
-- 0x204CB000200C0C8000007B00031C65EE .go xyz -1671.0707 3152.94 19.727245
|
|
|
|
-- Pathing for Shadowprey Guardian Entry: 12338
|
|
SET @NPC := 27566;
|
|
UPDATE `creature` SET `wander_distance`=0,`movement_type`=2,`position_x`=-1578.3864,`position_y`=3091.8054,`position_z`=46.560516 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,-1578.3864,3091.8054,46.560516,100,0,0,0),
|
|
(@NPC,2,-1594.1975,3091.3274,43.02964,100,0,0,0),
|
|
(@NPC,3,-1613.2416,3089.007,38.32875,100,0,0,0),
|
|
(@NPC,4,-1624.8228,3089.966,35.175255,100,0,0,0),
|
|
(@NPC,5,-1630.492,3095.426,34.11395,100,0,0,0),
|
|
(@NPC,6,-1627.9872,3100.3762,36.112865,100,0,0,0),
|
|
(@NPC,7,-1622.2477,3109.641,40.69519,100,0,0,0),
|
|
(@NPC,8,-1615.0018,3116.8977,43.88143,100,0,0,0),
|
|
(@NPC,9,-1622.2477,3109.641,40.69519,100,0,0,0),
|
|
(@NPC,10,-1627.9872,3100.3762,36.112865,100,0,0,0),
|
|
(@NPC,11,-1630.492,3095.426,34.11395,100,0,0,0),
|
|
(@NPC,12,-1624.8228,3089.966,35.175255,100,0,0,0),
|
|
(@NPC,13,-1613.2416,3089.007,38.32875,100,0,0,0),
|
|
(@NPC,14,-1594.1975,3091.3274,43.02964,100,0,0,0);
|
|
-- 0x204CB000200C0C8000007B00041C65F0 .go xyz -1578.3864 3091.8054 46.560516
|
|
|
|
-- Pathing for Shadowprey Guardian Entry: 12338
|
|
SET @NPC := 27548;
|
|
UPDATE `creature` SET `wander_distance`=0,`movement_type`=2,`position_x`=-1637.4994,`position_y`=3079.612,`position_z`=31.382957 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,-1637.4994,3079.612,31.382957,100,0,0,0),
|
|
(@NPC,2,-1647.0406,3085.4595,30.7453,100,0,0,0),
|
|
(@NPC,3,-1658.1682,3096.2573,30.497795,100,0,0,0),
|
|
(@NPC,4,-1667.1478,3085.581,30.546133,100,0,0,0),
|
|
(@NPC,5,-1661.9714,3095.1868,30.497746,100,0,0,0),
|
|
(@NPC,6,-1661.0421,3110.0645,30.338806,100,0,0,0),
|
|
(@NPC,7,-1661.8292,3121.5122,28.625042,100,0,0,0),
|
|
(@NPC,8,-1661.3171,3138.1243,25.07384,100,0,0,0),
|
|
(@NPC,9,-1655.7982,3153.535,23.450588,100,0,0,0),
|
|
(@NPC,10,-1650.3647,3169.2913,24.054272,100,0,0,0),
|
|
(@NPC,11,-1655.7982,3153.535,23.450588,100,0,0,0),
|
|
(@NPC,12,-1661.3171,3138.1243,25.07384,100,0,0,0),
|
|
(@NPC,13,-1661.8292,3121.5122,28.625042,100,0,0,0),
|
|
(@NPC,14,-1661.0421,3110.0645,30.338806,100,0,0,0),
|
|
(@NPC,15,-1661.9714,3095.1868,30.497746,100,0,0,0),
|
|
(@NPC,16,-1667.1478,3085.581,30.546133,100,0,0,0),
|
|
(@NPC,17,-1658.1682,3096.2573,30.497795,100,0,0,0),
|
|
(@NPC,18,-1647.0406,3085.4595,30.7453,100,0,0,0);
|
|
-- 0x204CB000200C0C8000007B00061C65F0 .go xyz -1637.4994 3079.612 31.382957
|
|
|
|
|
|
-- End of migration.
|
|
END IF;
|
|
END??
|
|
delimiter ;
|
|
CALL add_migration();
|
|
DROP PROCEDURE IF EXISTS add_migration;
|