moonwell-core-vanilla/sql/migrations/20260731074614_world.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`='20260731074614');
IF v = 0 THEN
INSERT INTO `migrations` VALUES ('20260731074614');
-- Add your query below.

-- Jadefire Run
DELETE FROM `creature` WHERE `id` IN (7107, 7108, 7111, 10648);
DELETE FROM `creature_movement` WHERE `id` IN (40706);

SET @CGUID := 17221;

INSERT INTO `creature` (`guid`, `id`, `id2`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecsmin`, `wander_distance`, `movement_type`, `spawntimesecsmax`) VALUES
(@CGUID, 7107, 7108, 1, 6597.9893, -937.82446, 473.77335, 0.209439516067504882, 300, 15, 1, 480),
(@CGUID+1, 7107, 7108, 1, 6581.721, -1013.5572, 463.79858, 1.172463178634643554, 300, 15, 1, 480),
(@CGUID+2, 7107, 7108, 1, 6595.478, -964.7803, 472.8459, 3.744056224822998046, 300, 15, 1, 480),
(@CGUID+3, 7107, 7108, 1, 6606.426, -912.1112, 473.53186, 2.259292364120483398, 300, 15, 1, 480),
(@CGUID+4, 7107, 7108, 1, 6500.4424, -850.4374, 472.95465, 4.504848957061767578, 300, 15, 1, 480),
(@CGUID+5, 7107, 7108, 1, 6489.674, -784.32434, 473.6464, 0.226892799139022827, 300, 2, 1, 480),
(@CGUID+6, 7107, 7108, 1, 6553.232, -841.71313, 473.59003, 0.154711350798606872, 300, 1, 1, 480),
(@CGUID+7, 7107, 7108, 1, 6535.845, -834.43854, 474.60547, 4.304278373718261718, 300, 2, 1, 480),
(@CGUID+8, 7107, 7108, 1, 6569.074, -806.16907, 475.7942, 0.657858967781066894, 300, 5, 1, 480),
(@CGUID+9, 7107, 7108, 1, 6479.3735, -793.56195, 473.90875, 4.374718189239501953, 300, 1, 1, 480),
(@CGUID+10, 7107, 7108, 1, 6581.0884, -804.00696, 474.8405, 3.724053382873535156, 300, 1, 1, 480),
(@CGUID+11, 7107, 7108, 1, 6483.8745, -817.1497, 473.94272, 1.133222579956054687, 300, 15, 1, 480),
(@CGUID+12, 7107, 7108, 1, 6516.1167, -814.5349, 474.74985, 2.449142217636108398, 300, 15, 1, 480),
(@CGUID+13, 7107, 7108, 1, 6448.5664, -800.8992, 474.3046, 5.257455348968505859, 300, 15, 1, 480),
(@CGUID+14, 7107, 7108, 1, 6432.1587, -759.84686, 473.15967, 3.224145412445068359, 300, 0, 2, 480),
(@CGUID+15, 7107, 7108, 1, 6414.7876, -782.52045, 471.68338, 4.049969673156738281, 300, 15, 1, 480),
(@CGUID+16, 7107, 7108, 1, 6417.261, -818.1496, 470.33954, 3.518303632736206054, 300, 15, 1, 480),
(@CGUID+17, 7107, 7108, 1, 6383.858, -749.6224, 469.33542, 4.047421932220458984, 300, 15, 1, 480),
(@CGUID+18, 7107, 7108, 1, 6400.7476, -712.16486, 474.86307, 1.413716673851013183, 300, 2, 1, 480),
(@CGUID+19, 7107, 7108, 1, 6373.806, -699.54706, 476.85983, 2.024573326110839843, 300, 15, 1, 480),
(@CGUID+20, 7107, 7108, 1, 6377.0596, -797.05804, 457.78555, 3.528153657913208007, 300, 15, 1, 480),
(@CGUID+21, 7107, 7108, 1, 6410.2524, -725.2984, 473.8544, 4.321902275085449218, 300, 2, 1, 480),
(@CGUID+22, 7107, 7108, 1, 6350.9453, -734.53973, 471.33276, 5.67474365234375, 300, 2, 1, 480),
(@CGUID+23, 7107, 7108, 1, 6351.046, -717.2646, 472.2365, 5.79449319839477539, 300, 2, 1, 480),
(@CGUID+24, 7107, 7108, 1, 6287.962, -598.7009, 466.59583, 2.396016359329223632, 300, 1, 1, 480),
(@CGUID+25, 7107, 7108, 1, 6279.444, -614.3792, 472.5725, 2.256314516067504882, 300, 1, 1, 480),
(@CGUID+26, 7111, 0, 1, 6580.9106, -846.0111, 474.0431, 2.908204555511474609, 300, 2, 1, 480),
(@CGUID+27, 7111, 0, 1, 6546.847, -842.53314, 473.8505, 3.269372463226318359, 300, 2, 1, 480),
(@CGUID+28, 7111, 0, 1, 6479.9087, -786.9245, 474.54443, 3.862565040588378906, 300, 2, 1, 480),
(@CGUID+29, 7111, 0, 1, 6577.2773, -798.1775, 475.03653, 1.438873529434204101, 300, 2, 1, 480),
(@CGUID+30, 7111, 0, 1, 6589.328, -856.6679, 474.59833, 3.874630928039550781, 300, 2, 1, 480),
(@CGUID+31, 7111, 0, 1, 6558.4224, -823.91797, 475.64575, 5.380662918090820312, 300, 2, 1, 480),
(@CGUID+32, 7111, 0, 1, 6409.626, -718.0106, 475.00592, 3.664785385131835937, 300, 2, 1, 480),
(@CGUID+33, 7111, 0, 1, 6342.289, -727.19995, 470.21567, 6.003914833068847656, 300, 2, 1, 480),
(@CGUID+34, 7111, 0, 1, 6302.0747, -757.5039, 468.49915, 5.619960308074951171, 300, 2, 1, 480),
(@CGUID+35, 7111, 0, 1, 6327.2744, -623.5396, 476.49002, 1.379523515701293945, 300, 2, 1, 480),
(@CGUID+36, 7111, 0, 1, 6297.897, -617.827, 471.6025, 2.321287870407104492, 300, 2, 1, 480),
(@CGUID+37, 7111, 0, 1, 6290.3145, -635.4162, 483.368, 5.811946392059326171, 300, 2, 1, 480),
(@CGUID+38, 7111, 0, 1, 6281.056, -651.52264, 489.869, 4.186584949493408203, 300, 2, 1, 480),
(@CGUID+39, 10648, 0, 1, 6279.093, -603.6922, 467.83997, 1.442377448081970214, 720, 0, 0, 960);

INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `script_id`) VALUES
(@CGUID+14, 1, 6431.575, -759.89514, 473.14578, 100, 0, 0),
(@CGUID+14, 2, 6415.6743, -757.93774, 473.14578, 100, 0, 0),
(@CGUID+14, 3, 6399.2617, -760.9202, 470.7167, 100, 0, 0),
(@CGUID+14, 4, 6406.117, -791.04846, 468.84244, 100, 0, 0),
(@CGUID+14, 5, 6424.424, -803.3945, 471.96426, 100, 0, 0),
(@CGUID+14, 6, 6436.6743, -790.0301, 473.39835, 100, 0, 0),
(@CGUID+14, 7, 6466.341, -799.6447, 474.1249, 100, 0, 0),
(@CGUID+14, 8, 6478.2183, -818.8252, 474.33282, 100, 0, 0),
(@CGUID+14, 9, 6496.9536, -828.95374, 473.3863, 100, 0, 0),
(@CGUID+14, 10, 6520.4375, -828.62994, 473.9445, 100, 0, 0),
(@CGUID+14, 11, 6543.6343, -830.434, 474.0695, 100, 0, 0),
(@CGUID+14, 12, 6552.5806, -842.2002, 473.697, 100, 0, 0),
(@CGUID+14, 13, 6571.129, -847.305, 473.45517, 100, 0, 0),
(@CGUID+14, 14, 6583.8125, -830.9744, 474.79904, 100, 0, 0),
(@CGUID+14, 15, 6573.4272, -806.39954, 475.57468, 100, 0, 0),
(@CGUID+14, 16, 6558.5117, -795.7527, 475.39703, 100, 0, 0),
(@CGUID+14, 17, 6529.44, -795.3073, 473.6696, 100, 0, 0),
(@CGUID+14, 18, 6513.4146, -788.9368, 474.66885, 100, 0, 0),
(@CGUID+14, 19, 6490.856, -802.297, 474.06464, 100, 0, 0),
(@CGUID+14, 20, 6469.944, -795.0282, 474.02267, 100, 0, 0),
(@CGUID+14, 21, 6451.1313, -779.17725, 474.14835, 100, 0, 0);

-- End of migration.
END IF;
END??
DELIMITER ;
CALL add_migration();
DROP PROCEDURE IF EXISTS add_migration;