sindoring/moonwell-core-vanilla
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
Files
development
moonwell-core-vanilla/sql/migrations/20231223190850_world.sql
T

183 lines
8.9 KiB
SQL
Raw Permalink Blame History

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`='20231223190850');
IF v=0 THEN
INSERT INTO `migrations` VALUES ('20231223190850');
-- Add your query below.
-- Pathing for Murderous Blisterpaw Entry: 8208
SET @NPC := 51825;
UPDATE `creature` SET `wander_distance`=0,`movement_type`=2,`position_x`=-7025.515,`position_y`=-3491.132,`position_z`=9.274621 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,-7025.515,-3491.132,9.274621,100,0,0,0),
(@NPC,2,-7057.585,-3499.684,10.376134,100,0,0,0),
(@NPC,3,-7083.3726,-3521.9758,11.747719,100,0,0,0),
(@NPC,4,-7116.227,-3516.6216,10.375974,100,0,0,0),
(@NPC,5,-7143.2266,-3517.4648,10.078375,100,0,0,0),
(@NPC,6,-7172.1216,-3513.6719,11.342711,100,0,0,0),
(@NPC,7,-7202.048,-3508.731,11.024831,100,0,0,0),
(@NPC,8,-7247.1226,-3513.0464,11.260182,100,0,0,0),
(@NPC,9,-7277.5615,-3524.6765,12.185095,100,0,0,0),
(@NPC,10,-7302.512,-3540.7358,8.5952,100,0,0,0),
(@NPC,11,-7328.6494,-3568.7114,10.502499,100,0,0,0),
(@NPC,12,-7341.257,-3601.2178,9.939367,100,0,0,0),
(@NPC,13,-7362.0376,-3633.9546,11.387863,100,0,0,0),
(@NPC,14,-7383.2837,-3658.7517,10.012263,100,0,0,0),
(@NPC,15,-7396.5024,-3698.1814,9.407527,100,0,0,0),
(@NPC,16,-7405.75,-3719.763,9.256791,100,0,0,0),
(@NPC,17,-7420.3613,-3750.827,12.278984,100,0,0,0),
(@NPC,18,-7414.9087,-3767.6528,12.649624,100,0,0,0),
(@NPC,19,-7396.8125,-3813.4487,10.233704,100,0,0,0),
(@NPC,20,-7385.053,-3851.4045,10.949272,100,0,0,0),
(@NPC,21,-7363.6816,-3878.0642,11.944022,100,0,0,0),
(@NPC,22,-7366.593,-3917.8196,14.590536,100,0,0,0),
(@NPC,23,-7368.6016,-3951.2683,11.180499,100,0,0,0),
(@NPC,24,-7388.428,-3989.5295,9.057527,100,0,0,0),
(@NPC,25,-7419.9297,-4017.759,10.126763,100,0,0,0),
(@NPC,26,-7455.046,-3985.4866,11.490533,100,0,0,0),
(@NPC,27,-7484.066,-3945.0916,10.125787,100,0,0,0),
(@NPC,28,-7518.1597,-3916.549,10.933404,100,0,0,0),
(@NPC,29,-7545.4316,-3950.7153,10.655572,100,0,0,0),
(@NPC,30,-7549.514,-3973.414,12.167756,100,0,0,0),
(@NPC,31,-7550.2954,-4013.2153,12.256833,100,0,0,0),
(@NPC,32,-7552.7324,-4045.1523,11.282222,100,0,0,0),
(@NPC,33,-7549.6675,-4078.2886,11.486598,100,0,0,0),
(@NPC,34,-7547.963,-4113.612,10.832579,100,0,0,0),
(@NPC,35,-7549.6675,-4078.2886,11.486598,100,0,0,0),
(@NPC,36,-7552.731,-4045.2805,11.270747,100,0,0,0),
(@NPC,37,-7550.2954,-4013.2153,12.256833,100,0,0,0),
(@NPC,38,-7549.514,-3973.414,12.167756,100,0,0,0),
(@NPC,39,-7545.4316,-3950.7153,10.655572,100,0,0,0),
(@NPC,40,-7518.1597,-3916.549,10.933404,100,0,0,0),
(@NPC,41,-7484.066,-3945.0916,10.125787,100,0,0,0),
(@NPC,42,-7455.046,-3985.4866,11.490533,100,0,0,0),
(@NPC,43,-7419.9297,-4017.759,10.126763,100,0,0,0),
(@NPC,44,-7388.428,-3989.5295,9.057527,100,0,0,0),
(@NPC,45,-7368.6074,-3951.3164,11.189776,100,0,0,0),
(@NPC,46,-7366.593,-3917.8196,14.590536,100,0,0,0),
(@NPC,47,-7363.6816,-3878.0642,11.944022,100,0,0,0),
(@NPC,48,-7385.053,-3851.4045,10.949272,100,0,0,0),
(@NPC,49,-7396.8125,-3813.4487,10.233704,100,0,0,0),
(@NPC,50,-7414.9087,-3767.6528,12.649624,100,0,0,0),
(@NPC,51,-7420.3613,-3750.827,12.278984,100,0,0,0),
(@NPC,52,-7405.75,-3719.763,9.256791,100,0,0,0),
(@NPC,53,-7396.5024,-3698.1814,9.407527,100,0,0,0),
(@NPC,54,-7383.2837,-3658.7517,10.012263,100,0,0,0),
(@NPC,55,-7362.0376,-3633.9546,11.387863,100,0,0,0),
(@NPC,56,-7341.257,-3601.2178,9.939367,100,0,0,0),
(@NPC,57,-7328.6494,-3568.7114,10.502499,100,0,0,0),
(@NPC,58,-7302.512,-3540.7358,8.5952,100,0,0,0),
(@NPC,59,-7277.5615,-3524.6765,12.185095,100,0,0,0),
(@NPC,60,-7247.1226,-3513.0464,11.260182,100,0,0,0),
(@NPC,61,-7202.048,-3508.731,11.024831,100,0,0,0),
(@NPC,62,-7172.1216,-3513.6719,11.342711,100,0,0,0),
(@NPC,63,-7143.2637,-3517.452,10.110113,100,0,0,0),
(@NPC,64,-7116.227,-3516.6216,10.375974,100,0,0,0),
(@NPC,65,-7083.3726,-3521.9758,11.747719,100,0,0,0),
(@NPC,66,-7057.585,-3499.684,10.376134,100,0,0,0);
-- 0x204CB0002008040000055E000034BDE4 .go xyz -7025.515 -3491.132 9.274621
-- Pathing for Greater Firebird Entry: 8207
SET @NPC := 51827;
UPDATE `creature` SET `wander_distance`=0,`movement_type`=2,`position_x`=-7710.758,`position_y`=-3956.6245,`position_z`=9.728199 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,-7710.758,-3956.6245,9.728199,100,0,0,0),
(@NPC,2,-7715.532,-3928.461,8.749683,100,0,0,0),
(@NPC,3,-7700.7812,-3906.8174,9.525318,100,0,0,0),
(@NPC,4,-7663.8013,-3875.1206,8.839839,100,0,0,0),
(@NPC,5,-7657.634,-3840.8525,10.83584,100,0,0,0),
(@NPC,6,-7671.237,-3821.5408,15.216432,100,0,0,0),
(@NPC,7,-7678.901,-3795.2083,21.681417,100,0,0,0),
(@NPC,8,-7681.229,-3756.9055,24.819561,100,0,0,0),
(@NPC,9,-7673.8613,-3716.5469,29.9973,100,0,0,0),
(@NPC,10,-7673.6987,-3687.2478,28.922815,100,0,0,0),
(@NPC,11,-7656.421,-3656.8772,26.623302,100,0,0,0),
(@NPC,12,-7662.468,-3629.3574,28.541769,100,0,0,0),
(@NPC,13,-7677.4897,-3582.9736,32.306168,100,0,0,0),
(@NPC,14,-7677.9395,-3540.1658,24.65451,100,0,0,0),
(@NPC,15,-7675.5747,-3503.2544,26.522423,100,0,0,0),
(@NPC,16,-7661.9976,-3472.317,26.822615,100,0,0,0),
(@NPC,17,-7631.3594,-3455.7761,29.158308,100,0,0,0),
(@NPC,18,-7600.8604,-3474.5388,23.820978,100,0,0,0),
(@NPC,19,-7556.848,-3491.1558,16.88118,100,0,0,0),
(@NPC,20,-7516.682,-3490.9087,15.407843,100,0,0,0),
(@NPC,21,-7482.791,-3478.7441,14.191426,100,0,0,0),
(@NPC,22,-7448.849,-3445.8245,11.7975445,100,0,0,0),
(@NPC,23,-7413.9087,-3422.8777,11.448396,100,0,0,0),
(@NPC,24,-7384.762,-3389.0525,12.521492,100,0,0,0),
(@NPC,25,-7390.377,-3364.397,9.953996,100,0,0,0),
(@NPC,26,-7417.989,-3343.9648,10.760514,100,0,0,0),
(@NPC,27,-7455.8647,-3346.955,13.619991,100,0,0,0),
(@NPC,28,-7488.782,-3342.5862,15.875005,100,0,0,0),
(@NPC,29,-7525.165,-3314.5938,23.809805,100,0,0,0),
(@NPC,30,-7545.5747,-3282.4626,28.957174,100,0,0,0),
(@NPC,31,-7538.598,-3249.0413,27.585447,100,0,0,0),
(@NPC,32,-7510.407,-3218.524,23.716492,100,0,0,0),
(@NPC,33,-7479.388,-3191.0247,14.460273,100,0,0,0),
(@NPC,34,-7465.8647,-3183.5723,13.781521,100,0,0,0),
(@NPC,35,-7455.6353,-3158.7048,12.994573,100,0,0,0),
(@NPC,36,-7456.4126,-3114.431,13.864947,100,0,0,0),
(@NPC,37,-7490.0244,-3081.6028,13.82893,100,0,0,0),
(@NPC,38,-7517.932,-3068.775,13.160608,100,0,0,0),
(@NPC,39,-7552.173,-3088.9275,16.074425,100,0,0,0),
(@NPC,40,-7580.729,-3117.3545,27.553055,100,0,0,0),
(@NPC,41,-7618.8794,-3141.1875,35.611378,100,0,0,0),
(@NPC,42,-7646.901,-3118.3042,37.350555,100,0,0,0),
(@NPC,43,-7678.538,-3115.4187,44.10227,100,0,0,0),
(@NPC,44,-7646.901,-3118.3042,37.350555,100,0,0,0),
(@NPC,45,-7618.8794,-3141.1875,35.611378,100,0,0,0),
(@NPC,46,-7580.729,-3117.3545,27.553055,100,0,0,0),
(@NPC,47,-7552.173,-3088.9275,16.074425,100,0,0,0),
(@NPC,48,-7517.932,-3068.775,13.160608,100,0,0,0),
(@NPC,49,-7490.0244,-3081.6028,13.82893,100,0,0,0),
(@NPC,50,-7456.4126,-3114.431,13.864947,100,0,0,0),
(@NPC,51,-7455.6353,-3158.7048,12.994573,100,0,0,0),
(@NPC,52,-7465.8647,-3183.5723,13.781521,100,0,0,0),
(@NPC,53,-7479.388,-3191.0247,14.460273,100,0,0,0),
(@NPC,54,-7510.407,-3218.524,23.716492,100,0,0,0),
(@NPC,55,-7538.598,-3249.0413,27.585447,100,0,0,0),
(@NPC,56,-7545.5747,-3282.4626,28.957174,100,0,0,0),
(@NPC,57,-7525.165,-3314.5938,23.809805,100,0,0,0),
(@NPC,58,-7488.782,-3342.5862,15.875005,100,0,0,0),
(@NPC,59,-7455.8647,-3346.955,13.619991,100,0,0,0),
(@NPC,60,-7417.989,-3343.9648,10.760514,100,0,0,0),
(@NPC,61,-7390.377,-3364.397,9.953996,100,0,0,0),
(@NPC,62,-7384.762,-3389.0525,12.521492,100,0,0,0),
(@NPC,63,-7413.9087,-3422.8777,11.448396,100,0,0,0),
(@NPC,64,-7448.849,-3445.8245,11.7975445,100,0,0,0),
(@NPC,65,-7482.721,-3478.6821,14.169454,100,0,0,0),
(@NPC,66,-7516.6113,-3490.8457,15.322148,100,0,0,0),
(@NPC,67,-7556.848,-3491.1558,16.88118,100,0,0,0),
(@NPC,68,-7600.8604,-3474.5388,23.820978,100,0,0,0),
(@NPC,69,-7631.3594,-3455.7761,29.158308,100,0,0,0),
(@NPC,70,-7661.9976,-3472.317,26.822615,100,0,0,0),
(@NPC,71,-7675.5747,-3503.2544,26.522423,100,0,0,0),
(@NPC,72,-7677.9395,-3540.1658,24.65451,100,0,0,0),
(@NPC,73,-7677.4897,-3582.9736,32.306168,100,0,0,0),
(@NPC,74,-7662.468,-3629.3574,28.541769,100,0,0,0),
(@NPC,75,-7656.421,-3656.8772,26.623302,100,0,0,0),
(@NPC,76,-7673.6987,-3687.2478,28.922815,100,0,0,0),
(@NPC,77,-7673.8438,-3716.3994,30.064438,100,0,0,0),
(@NPC,78,-7681.229,-3756.9055,24.819561,100,0,0,0),
(@NPC,79,-7678.901,-3795.2083,21.681417,100,0,0,0),
(@NPC,80,-7671.237,-3821.5408,15.216432,100,0,0,0),
(@NPC,81,-7657.634,-3840.8525,10.83584,100,0,0,0),
(@NPC,82,-7663.8013,-3875.1206,8.839839,100,0,0,0),
(@NPC,83,-7700.7812,-3906.8174,9.525318,100,0,0,0),
(@NPC,84,-7715.532,-3928.461,8.749683,100,0,0,0);
-- 0x204CB000200803C000055E00003CE45F .go xyz -7710.758 -3956.6245 9.728199
-- End of migration.
END IF;
END??
delimiter ;
CALL add_migration();
DROP PROCEDURE IF EXISTS add_migration;
Reference in New Issue View Git Blame Copy Permalink