NickTyrer
42 lines
2.7 KiB
SQL
42 lines
2.7 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`='20260529140143');
|
|
IF v = 0 THEN
|
|
INSERT INTO `migrations` VALUES ('20260529140143');
|
|
-- Add your query below.
|
|
|
|
-- Blasted Lands - Dreadmaul Mauler | Dreadmaul Warlock
|
|
|
|
DELETE FROM `creature` WHERE `id` IN (5977, 5978);
|
|
|
|
SET @CGUID := 12410;
|
|
|
|
INSERT INTO `creature` (`guid`, `id`, `id2`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecsmin`, `spawntimesecsmax`, `wander_distance`, `movement_type`) VALUES
|
|
(@CGUID + 000, 5977, 5978, 0, -11479.8203125000, -2818.189941406250, -0.90990269184112548, 1.610785365104675292, 300, 300, 03, 1),
|
|
(@CGUID + 001, 5977, 5978, 0, -11533.6943359375, -2841.156250000000, 6.263804435729980468, 5.301016330718994140, 300, 300, 03, 1),
|
|
(@CGUID + 002, 5977, 5978, 0, -11526.9277343750, -2861.791259765625, 9.155961990356445312, 3.298672199249267578, 300, 300, 03, 1),
|
|
(@CGUID + 003, 5977, 5978, 0, -11566.8916015625, -2833.851318359375, 5.650344371795654296, 3.838294982910156250, 300, 300, 03, 1),
|
|
(@CGUID + 004, 5977, 5978, 0, -11532.6171875000, -2878.090332031250, 12.77502536773681640, 0.026746388524770736, 300, 300, 03, 1),
|
|
(@CGUID + 005, 5977, 5978, 0, -11552.7841796875, -2855.577392578125, 8.599003791809082031, 3.206304311752319335, 300, 300, 10, 1),
|
|
(@CGUID + 006, 5977, 5978, 0, -11508.3964843750, -2842.130371093750, 4.780386447906494140, 0.505153834819793701, 300, 300, 10, 1),
|
|
(@CGUID + 007, 5977, 5978, 0, -11586.6337890625, -2869.747314453125, 20.45271682739257812, 5.531148433685302734, 300, 300, 10, 1),
|
|
(@CGUID + 008, 5977, 5978, 0, -11516.4433593750, -2906.135986328125, 27.30602836608886718, 5.333575248718261718, 300, 300, 10, 1),
|
|
(@CGUID + 009, 5977, 5978, 0, -11516.1250000000, -2815.768798828125, 1.366598367691040039, 5.849763870239257812, 300, 300, 20, 1),
|
|
(@CGUID + 010, 5977, 5978, 0, -11482.3300781250, -2849.010498046875, 3.200564146041870117, 3.502649307250976562, 300, 300, 20, 1),
|
|
(@CGUID + 011, 5977, 5978, 0, -11550.3212890625, -2816.164550781250, 3.649803161621093750, 2.028545379638671875, 300, 300, 20, 1),
|
|
(@CGUID + 012, 5977, 5978, 0, -11582.8701171875, -2846.829101562500, 6.066722393035888671, 4.324330329895019531, 300, 300, 20, 1),
|
|
(@CGUID + 013, 5977, 5978, 0, -11483.9892578125, -2913.856689453125, 21.81791877746582031, 3.824524641036987304, 300, 300, 20, 1),
|
|
(@CGUID + 014, 5977, 5978, 0, -11580.6533203125, -2817.677734375000, 5.298103332519531250, 0.763527393341064453, 300, 300, 20, 1),
|
|
(@CGUID + 015, 5977, 5978, 0, -11481.9033203125, -2881.925537109375, 8.069242477416992187, 0.505710780620574951, 300, 300, 20, 1);
|
|
|
|
|
|
-- End of migration.
|
|
END IF;
|
|
END??
|
|
DELIMITER ;
|
|
CALL add_migration();
|
|
DROP PROCEDURE IF EXISTS add_migration;
|