NickTyrer
138 lines
11 KiB
SQL
138 lines
11 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`='20260529150333');
|
|
IF v = 0 THEN
|
|
INSERT INTO `migrations` VALUES ('20260529150333');
|
|
-- Add your query below.
|
|
|
|
-- Blasted Lands - Wretched Lost One | Black Slayer
|
|
|
|
DELETE FROM `creature` WHERE `id` IN (5979, 5982);
|
|
DELETE FROM `creature_movement` WHERE `id` IN (3861, 3933, 1449, 3905, 3860);
|
|
|
|
SET @CGUID := 8638;
|
|
|
|
INSERT INTO `creature` (`guid`, `id`, `id2`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecsmin`, `spawntimesecsmax`, `wander_distance`, `movement_type`) VALUES
|
|
(@CGUID + 000, 5982, 0, 0, -11580.8232421875, -3182.214355468750, 7.074623584747314453, 2.548180580139160156, 300, 300, 00, 2),
|
|
(@CGUID + 001, 5982, 0, 0, -11149.6992187500, -3335.627685546875, 7.274872303009033203, 4.885375976562500000, 300, 300, 00, 2),
|
|
(@CGUID + 002, 5982, 0, 0, -11556.2392578125, -3073.159423828125, 7.897656440734863281, 0.294780194759368896, 300, 300, 02, 1),
|
|
(@CGUID + 003, 5982, 0, 0, -11562.3964843750, -3082.123291015625, 6.294155597686767578, 1.998706698417663574, 300, 300, 02, 1),
|
|
(@CGUID + 004, 5982, 0, 0, -11402.5429687500, -3142.259277343750, 13.27161788940429687, 5.188477039337158203, 300, 300, 02, 1),
|
|
(@CGUID + 005, 5982, 0, 0, -11380.7177734375, -3117.438476562500, 3.662009239196777343, 2.623294830322265625, 300, 300, 02, 1),
|
|
(@CGUID + 006, 5982, 0, 0, -11377.2255859375, -3065.978759765625, -4.37762641906738281, 1.279655575752258300, 300, 300, 02, 1),
|
|
(@CGUID + 007, 5982, 0, 0, -11160.4111328125, -3342.360595703125, 4.469780445098876953, 5.916666030883789062, 300, 300, 02, 1),
|
|
(@CGUID + 008, 5982, 0, 0, -10947.1728515625, -2914.352783203125, 8.268877029418945312, 0.467801064252853393, 300, 300, 02, 1),
|
|
(@CGUID + 009, 5982, 0, 0, -10956.4365234375, -2924.397949218750, 10.06605720520019531, 3.755380153656005859, 300, 300, 02, 1),
|
|
(@CGUID + 010, 5982, 0, 0, -10985.1064453125, -2784.475830078125, 2.825718164443969726, 0.999858796596527099, 300, 300, 02, 1),
|
|
(@CGUID + 011, 5979, 5982, 0, -10899.0478515625, -2866.749267578125, 19.75895690917968750, 1.989675283432006835, 300, 300, 00, 2),
|
|
(@CGUID + 012, 5979, 5982, 0, -11000.7958984375, -2886.656738281250, 9.870463371276855468, 4.865927219390869140, 300, 300, 00, 2),
|
|
(@CGUID + 013, 5979, 5982, 0, -11120.5292968750, -2725.100341796875, 11.83318424224853515, 1.482810378074645996, 300, 300, 00, 2);
|
|
|
|
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `script_id`) VALUES
|
|
(@CGUID + 000, 1, -11574.3349609375, -3177.580322265625, 7.077253341674804687, 100, 0, 0),
|
|
(@CGUID + 000, 2, -11555.1542968750, -3191.756103515625, 7.679084777832031250, 100, 0, 0),
|
|
(@CGUID + 000, 3, -11542.2607421875, -3222.371093750000, 7.215793132781982421, 100, 0, 0),
|
|
(@CGUID + 000, 4, -11518.8652343750, -3231.110351562500, 7.395200252532958984, 100, 0, 0),
|
|
(@CGUID + 000, 5, -11494.0839843750, -3236.802001953125, 12.29545688629150390, 100, 0, 0),
|
|
(@CGUID + 000, 6, -11466.1347656250, -3247.759765625000, 17.37906837463378906, 100, 0, 0),
|
|
(@CGUID + 000, 7, -11439.4501953125, -3244.576660156250, 12.09244728088378906, 100, 0, 0),
|
|
(@CGUID + 000, 8, -11416.5820312500, -3261.949218750000, 7.874382019042968750, 100, 0, 0),
|
|
(@CGUID + 000, 9, -11381.1015625000, -3255.145019531250, 5.812380790710449218, 100, 0, 0),
|
|
(@CGUID + 000, 10, -11416.5820312500, -3261.949218750000, 7.874382019042968750, 100, 0, 0),
|
|
(@CGUID + 000, 11, -11439.4501953125, -3244.576660156250, 12.09244728088378906, 100, 0, 0),
|
|
(@CGUID + 000, 12, -11466.1347656250, -3247.759765625000, 17.37906837463378906, 100, 0, 0),
|
|
(@CGUID + 000, 13, -11494.0839843750, -3236.802001953125, 12.29545688629150390, 100, 0, 0),
|
|
(@CGUID + 000, 14, -11518.8652343750, -3231.110351562500, 7.395200252532958984, 100, 0, 0),
|
|
(@CGUID + 000, 15, -11542.2607421875, -3222.371093750000, 7.215793132781982421, 100, 0, 0),
|
|
(@CGUID + 000, 16, -11555.1542968750, -3191.756103515625, 7.679084777832031250, 100, 0, 0),
|
|
(@CGUID + 001, 1, -11149.3251953125, -3337.761474609375, 7.826395034790039062, 100, 0, 0),
|
|
(@CGUID + 001, 2, -11162.9912109375, -3315.411132812500, 4.421508789062500000, 100, 0, 0),
|
|
(@CGUID + 001, 3, -11161.9482421875, -3289.550781250000, 5.246299743652343750, 100, 0, 0),
|
|
(@CGUID + 001, 4, -11178.9287109375, -3260.242675781250, 7.820431232452392578, 100, 0, 0),
|
|
(@CGUID + 001, 5, -11190.8281250000, -3226.915039062500, 8.724966049194335937, 100, 0, 0),
|
|
(@CGUID + 001, 6, -11201.9951171875, -3199.155761718750, 8.099186897277832031, 100, 0, 0),
|
|
(@CGUID + 001, 7, -11219.8847656250, -3165.442626953125, 7.024968147277832031, 100, 0, 0),
|
|
(@CGUID + 001, 8, -11220.6972656250, -3139.443359375000, 5.922429084777832031, 100, 0, 0),
|
|
(@CGUID + 001, 9, -11232.9355468750, -3095.292236328125, 3.815185070037841796, 100, 0, 0),
|
|
(@CGUID + 001, 10, -11235.6533203125, -3072.582031250000, 4.964619159698486328, 100, 0, 0),
|
|
(@CGUID + 001, 11, -11232.9355468750, -3095.292236328125, 3.815185070037841796, 100, 0, 0),
|
|
(@CGUID + 001, 12, -11220.6972656250, -3139.443359375000, 5.922429084777832031, 100, 0, 0),
|
|
(@CGUID + 001, 13, -11219.8847656250, -3165.442626953125, 7.024968147277832031, 100, 0, 0),
|
|
(@CGUID + 001, 14, -11201.9951171875, -3199.155761718750, 8.099186897277832031, 100, 0, 0),
|
|
(@CGUID + 001, 15, -11190.8281250000, -3226.915039062500, 8.724966049194335937, 100, 0, 0),
|
|
(@CGUID + 001, 16, -11178.9287109375, -3260.242675781250, 7.820431232452392578, 100, 0, 0),
|
|
(@CGUID + 001, 17, -11161.9482421875, -3289.550781250000, 5.246299743652343750, 100, 0, 0),
|
|
(@CGUID + 001, 18, -11162.9912109375, -3315.411132812500, 4.421508789062500000, 100, 0, 0),
|
|
(@CGUID + 011, 1, -10912.0634765625, -2877.576660156250, 13.53593921661376953, 100, 0, 0),
|
|
(@CGUID + 011, 2, -10929.9785156250, -2847.772216796875, 11.43566608428955078, 100, 0, 0),
|
|
(@CGUID + 011, 3, -10947.3652343750, -2844.356689453125, 9.882669448852539062, 100, 0, 0),
|
|
(@CGUID + 011, 4, -10965.9287109375, -2826.812011718750, 9.201398849487304687, 100, 0, 0),
|
|
(@CGUID + 011, 5, -10975.4902343750, -2804.781250000000, 5.062310218811035156, 100, 0, 0),
|
|
(@CGUID + 011, 6, -10982.6064453125, -2780.399658203125, 4.808463096618652343, 100, 0, 0),
|
|
(@CGUID + 011, 7, -10992.4462890625, -2757.369628906250, 4.970278739929199218, 100, 0, 0),
|
|
(@CGUID + 011, 8, -11013.1416015625, -2738.141113281250, 5.884078025817871093, 100, 0, 0),
|
|
(@CGUID + 011, 9, -10992.4462890625, -2757.369628906250, 4.970278739929199218, 100, 0, 0),
|
|
(@CGUID + 011, 10, -10982.6064453125, -2780.399658203125, 4.808463096618652343, 100, 0, 0),
|
|
(@CGUID + 011, 11, -10975.4902343750, -2804.781250000000, 5.062310218811035156, 100, 0, 0),
|
|
(@CGUID + 011, 12, -10965.9287109375, -2826.812011718750, 9.201398849487304687, 100, 0, 0),
|
|
(@CGUID + 011, 13, -10947.3652343750, -2844.356689453125, 9.882669448852539062, 100, 0, 0),
|
|
(@CGUID + 011, 14, -10929.9785156250, -2847.772216796875, 11.43566608428955078, 100, 0, 0),
|
|
(@CGUID + 012, 1, -11000.5595703125, -2888.183837890625, 9.753969192504882812, 100, 0, 0),
|
|
(@CGUID + 012, 2, -11012.8964843750, -2868.995361328125, 9.379213333129882812, 100, 0, 0),
|
|
(@CGUID + 012, 3, -11036.5673828125, -2867.507324218750, 9.300695419311523437, 100, 0, 0),
|
|
(@CGUID + 012, 4, -11055.4824218750, -2863.615478515625, 10.51587486267089843, 100, 0, 0),
|
|
(@CGUID + 012, 5, -11071.0439453125, -2871.154052734375, 9.778038024902343750, 100, 0, 0),
|
|
(@CGUID + 012, 6, -11085.7460937500, -2859.619140625000, 11.08268451690673828, 100, 0, 0),
|
|
(@CGUID + 012, 7, -11091.3007812500, -2842.644287109375, 14.94840717315673828, 100, 0, 0),
|
|
(@CGUID + 012, 8, -11090.6416015625, -2823.482421875000, 18.50168228149414062, 100, 0, 0),
|
|
(@CGUID + 012, 9, -11082.8095703125, -2807.870361328125, 11.17746257781982421, 100, 0, 0),
|
|
(@CGUID + 012, 10, -11072.0683593750, -2787.736328125000, 8.234523773193359375, 100, 0, 0),
|
|
(@CGUID + 012, 11, -11091.5703125000, -2774.224121093750, 12.45229721069335937, 100, 0, 0),
|
|
(@CGUID + 012, 12, -11114.7402343750, -2758.976318359375, 17.23969268798828125, 100, 0, 0),
|
|
(@CGUID + 012, 13, -11143.8720703125, -2746.637695312500, 15.22305202484130859, 100, 0, 0),
|
|
(@CGUID + 012, 14, -11170.8535156250, -2733.070312500000, 15.07990074157714843, 100, 0, 0),
|
|
(@CGUID + 012, 15, -11205.1845703125, -2727.850341796875, 14.58436012268066406, 100, 0, 0),
|
|
(@CGUID + 012, 16, -11170.8535156250, -2733.070312500000, 15.07990074157714843, 100, 0, 0),
|
|
(@CGUID + 012, 17, -11143.8720703125, -2746.637695312500, 15.22305202484130859, 100, 0, 0),
|
|
(@CGUID + 012, 18, -11114.7402343750, -2758.976318359375, 17.23969268798828125, 100, 0, 0),
|
|
(@CGUID + 012, 19, -11091.5703125000, -2774.224121093750, 12.45229721069335937, 100, 0, 0),
|
|
(@CGUID + 012, 20, -11072.0683593750, -2787.736328125000, 8.234523773193359375, 100, 0, 0),
|
|
(@CGUID + 012, 21, -11082.8095703125, -2807.870361328125, 11.17746257781982421, 100, 0, 0),
|
|
(@CGUID + 012, 22, -11090.6416015625, -2823.482421875000, 18.50168228149414062, 100, 0, 0),
|
|
(@CGUID + 012, 23, -11091.3007812500, -2842.644287109375, 14.94840717315673828, 100, 0, 0),
|
|
(@CGUID + 012, 24, -11085.7460937500, -2859.619140625000, 11.08268451690673828, 100, 0, 0),
|
|
(@CGUID + 012, 25, -11071.0439453125, -2871.154052734375, 9.778038024902343750, 100, 0, 0),
|
|
(@CGUID + 012, 26, -11055.4824218750, -2863.615478515625, 10.51587486267089843, 100, 0, 0),
|
|
(@CGUID + 012, 27, -11036.5673828125, -2867.507324218750, 9.300695419311523437, 100, 0, 0),
|
|
(@CGUID + 012, 28, -11012.8964843750, -2868.995361328125, 9.379213333129882812, 100, 0, 0),
|
|
(@CGUID + 013, 01, -11119.2158203125, -2710.318359375000, 11.59362411499023437, 100, 0, 0),
|
|
(@CGUID + 013, 02, -11135.3583984375, -2731.691894531250, 13.05368518829345703, 100, 0, 0),
|
|
(@CGUID + 013, 03, -11119.0771484375, -2758.417480468750, 17.58295440673828125, 100, 0, 0),
|
|
(@CGUID + 013, 04, -11093.2714843750, -2770.770507812500, 13.28408432006835937, 100, 0, 0),
|
|
(@CGUID + 013, 05, -11076.7978515625, -2785.354736328125, 8.547023773193359375, 100, 0, 0),
|
|
(@CGUID + 013, 06, -11057.9570312500, -2819.995605468750, 9.316370010375976562, 100, 0, 0),
|
|
(@CGUID + 013, 07, -11036.2314453125, -2838.878173828125, 12.77344322204589843, 100, 0, 0),
|
|
(@CGUID + 013, 08, -11019.7285156250, -2865.339355468750, 9.092391014099121093, 100, 0, 0),
|
|
(@CGUID + 013, 09, -10998.9580078125, -2883.407958984375, 9.747742652893066406, 100, 0, 0),
|
|
(@CGUID + 013, 10, -10975.2773437500, -2876.501220703125, 6.429139137268066406, 100, 0, 0),
|
|
(@CGUID + 013, 11, -10969.7441406250, -2854.104980468750, 5.817299842834472656, 100, 0, 0),
|
|
(@CGUID + 013, 12, -10956.2500000000, -2841.666015625000, 7.778665542602539062, 100, 0, 0),
|
|
(@CGUID + 013, 13, -10968.2998046875, -2830.959716796875, 9.886773109436035156, 100, 0, 0),
|
|
(@CGUID + 013, 14, -10998.9853515625, -2800.093017578125, 5.628228187561035156, 100, 0, 0),
|
|
(@CGUID + 013, 15, -11005.2783203125, -2773.620117187500, 4.317544937133789062, 100, 0, 0),
|
|
(@CGUID + 013, 16, -11008.5371093750, -2744.612792968750, 5.273482322692871093, 100, 0, 0),
|
|
(@CGUID + 013, 17, -11033.3613281250, -2725.946044921875, 8.216245651245117187, 100, 0, 0),
|
|
(@CGUID + 013, 18, -11055.3740234375, -2735.161865234375, 9.889304161071777343, 100, 0, 0),
|
|
(@CGUID + 013, 19, -11075.1787109375, -2743.744873046875, 10.05155372619628906, 100, 0, 0),
|
|
(@CGUID + 013, 20, -11099.5947265625, -2743.920410156250, 15.01981544494628906, 100, 0, 0);
|
|
|
|
-- End of migration.
|
|
END IF;
|
|
END??
|
|
DELIMITER ;
|
|
CALL add_migration();
|
|
DROP PROCEDURE IF EXISTS add_migration;
|