mmo-ref/vmangos
1
0
Fork 0
mirror of https://github.com/vmangos/core synced 2026-08-14 16:29:10 -04:00
Code Issues Projects Releases Packages Wiki Activity
vmangos/sql/old_migrations/20180523190341_world.sql
ratkosrb b4cb047c0e
New database release. (#123) 
* Use build to load spells and factions.

* Remove old migrations.

* Some 1.11 issues.

* Use unique pointers to spell entries.
2018-06-08 18:50:24 +03:00

344 lines
26 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`='20180523190341');
IF v=0 THEN
INSERT INTO `migrations` VALUES ('20180523190341');
-- Add your query below.
UPDATE `creature_template` SET `speed_walk`=(3.0 / 2.5), `speed_run`=(12.0 / 7.0) WHERE `entry`=11673;
DELETE a.* FROM `creature_movement` a INNER JOIN `creature` b ON a.`id`=b.`guid` WHERE b.`id`=11673;
DELETE a.* FROM `creature_addon` a INNER JOIN `creature` b ON a.`guid`=b.`guid` WHERE b.`id`=11673;
DELETE FROM `creature` WHERE `id`=11673;
REPLACE INTO `creature` (`guid`, `id`, `map`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecsmin`, `spawntimesecsmax`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`, `spawnFlags`, `visibilitymod`, `patch_min`, `patch_max`) VALUES
('56851', '11673', '409', '0', '0', '1142.960', '-645.029', '-131.800', '1.623160', '1080', '1080', '0', '0', '152352', '0', '0', '2', '1', '0', '0', '10'),
('56852', '11673', '409', '0', '0', '711.9440', '-591.790', '-210.775', '1.419900', '1080', '1080', '0', '0', '152352', '0', '0', '2', '1', '0', '0', '10'),
('56853', '11673', '409', '0', '0', '1039.010', '-817.452', '-152.205', '0.964862', '1080', '1080', '0', '0', '152352', '0', '0', '2', '1', '0', '0', '10'),
('56854', '11673', '409', '0', '0', '813.1620', '-646.358', '-204.589', '0.791964', '1080', '1080', '0', '0', '152352', '0', '0', '2', '1', '0', '0', '10'),
('56855', '11673', '409', '0', '0', '669.2400', '-532.061', '-210.223', '0.215849', '1080', '1080', '0', '0', '152352', '0', '0', '2', '1', '0', '0', '10'),
('56856', '11673', '409', '0', '0', '708.1200', '-604.032', '-209.670', '4.374480', '1080', '1080', '0', '0', '152352', '0', '0', '2', '1', '0', '0', '10'),
('56857', '11673', '409', '0', '0', '729.6020', '-485.480', '-212.510', '4.538390', '1080', '1080', '0', '0', '152352', '0', '0', '2', '1', '0', '0', '10'),
('56858', '11673', '409', '0', '0', '709.8370', '-932.331', '-191.297', '1.980750', '1080', '1080', '0', '0', '152352', '0', '0', '2', '1', '0', '0', '10'),
('56859', '11673', '409', '0', '0', '705.4090', '-1197.96', '-119.933', '2.581690', '1080', '1080', '0', '0', '152352', '0', '0', '2', '1', '0', '0', '10'),
('56860', '11673', '409', '0', '0', '576.6950', '-777.409', '-207.321', '4.422850', '1080', '1080', '0', '0', '152352', '0', '0', '2', '1', '0', '0', '10'),
('56861', '11673', '409', '0', '0', '814.4380', '-973.453', '-208.881', '5.024870', '1080', '1080', '0', '0', '152352', '0', '0', '2', '1', '0', '0', '10'),
('56862', '11673', '409', '0', '0', '607.6860', '-1160.48', '-198.044', '1.193060', '1080', '1080', '0', '0', '152352', '0', '0', '2', '1', '0', '0', '10'),
('56863', '11673', '409', '0', '0', '659.5690', '-1071.07', '-190.902', '6.172250', '1080', '1080', '0', '0', '152352', '0', '0', '2', '1', '0', '0', '10'),
('56864', '11673', '409', '0', '0', '746.8200', '-997.854', '-177.562', '4.278700', '1080', '1080', '0', '0', '152352', '0', '0', '2', '1', '0', '0', '10'),
('56865', '11673', '409', '0', '0', '796.0060', '-639.668', '-204.321', '0.340817', '1080', '1080', '0', '0', '152352', '0', '0', '2', '1', '0', '0', '10');
REPLACE INTO `creature_template_addon` (`entry`, `patch`, `mount`, `bytes1`, `b2_0_sheath`, `b2_1_flags`, `emote`, `moveflags`, `auras`) VALUES
('11673', '0', '0', '0', '1', '16', '0', '0', '18950');
SET @CGUID := 56851;
SET @POINT := 0;
DELETE FROM `creature_movement` WHERE `id`=@CGUID;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `orientation`) VALUES
(@CGUID, @POINT := @POINT + 1, '1144.05', '-662.684', '-131.463', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1160.29', '-696.880', '-132.486', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1129.03', '-721.049', '-139.580', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1118.51', '-712.138', '-144.258', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1104.69', '-722.130', '-146.983', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1090.82', '-731.363', '-149.987', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1070.79', '-717.562', '-153.483', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1080.75', '-681.572', '-159.873', '0', '0', '100'), -- random movement for ~2 mins, not possible in mangos
(@CGUID, @POINT := @POINT + 1, '1080.10', '-708.452', '-154.229', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1084.53', '-731.895', '-151.012', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1093.70', '-748.084', '-149.262', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1110.64', '-738.143', '-146.501', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1115.69', '-716.585', '-144.635', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1148.22', '-713.581', '-132.988', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1161.70', '-694.493', '-132.200', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1149.11', '-669.773', '-130.340', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1142.68', '-647.411', '-131.923', '120000', '0', '100');
SET @CGUID := 56852;
SET @POINT := 0;
DELETE FROM `creature_movement` WHERE `id`=@CGUID;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `orientation`) VALUES
(@CGUID, @POINT := @POINT + 1, '716.295', '-563.171', '-215.212', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '730.720', '-541.204', '-216.521', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '751.735', '-537.168', '-215.009', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '782.822', '-568.612', '-213.240', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '826.469', '-557.417', '-206.120', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '862.763', '-559.335', '-203.825', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '897.309', '-575.203', '-203.762', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '928.274', '-599.925', '-203.494', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '977.000', '-588.052', '-203.566', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1013.35', '-611.711', '-198.822', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1031.78', '-628.694', '-189.868', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1054.58', '-638.426', '-174.019', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1082.93', '-658.826', '-159.595', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1102.02', '-688.026', '-153.032', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1095.61', '-709.971', '-151.273', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1102.02', '-688.026', '-153.032', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1082.93', '-658.826', '-159.595', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1054.58', '-638.426', '-174.019', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1031.78', '-628.694', '-189.868', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1013.35', '-611.711', '-198.822', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '977.000', '-588.052', '-203.566', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '928.274', '-599.925', '-203.494', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '897.309', '-575.203', '-203.762', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '862.763', '-559.335', '-203.825', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '826.469', '-557.417', '-206.120', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '782.822', '-568.612', '-213.240', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '751.735', '-537.168', '-215.009', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '730.720', '-541.204', '-216.521', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '716.295', '-563.171', '-215.212', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '710.911', '-588.955', '-211.350', '0', '0', '100');
SET @CGUID := 56853;
SET @POINT := 0;
DELETE FROM `creature_movement` WHERE `id`=@CGUID;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `orientation`) VALUES
(@CGUID, @POINT := @POINT + 1, '1051.31', '-799.690', '-151.971', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1039.67', '-791.097', '-151.010', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1026.31', '-767.800', '-156.649', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1038.77', '-761.698', '-152.658', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1064.63', '-748.941', '-151.752', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1038.77', '-761.698', '-152.658', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1026.31', '-767.800', '-156.649', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1039.64', '-791.052', '-150.989', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1051.31', '-799.690', '-151.971', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1040.76', '-815.112', '-152.166', '0', '0', '100');
SET @CGUID := 56854;
SET @POINT := 0;
DELETE FROM `creature_movement` WHERE `id`=@CGUID;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `orientation`) VALUES
(@CGUID, @POINT := @POINT + 1, '831.386', '-627.893', '-203.149', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '856.456', '-617.906', '-202.157', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '899.612', '-613.543', '-202.238', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '936.253', '-612.500', '-203.622', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '975.182', '-641.047', '-201.577', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1002.31', '-661.990', '-194.192', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1024.07', '-684.312', '-173.430', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1042.02', '-695.821', '-163.758', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1058.16', '-706.078', '-156.611', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1068.57', '-742.832', '-151.733', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1117.10', '-744.479', '-145.629', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1149.46', '-726.451', '-133.804', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1175.51', '-702.176', '-130.987', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1200.50', '-670.934', '-128.545', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1202.95', '-639.398', '-126.169', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1188.30', '-614.030', '-121.882', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1164.20', '-595.404', '-115.776', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1155.21', '-574.871', '-113.377', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1164.20', '-595.404', '-115.776', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1188.30', '-614.030', '-121.882', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1202.95', '-639.398', '-126.169', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1200.50', '-670.934', '-128.545', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1175.59', '-702.081', '-130.975', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1149.46', '-726.451', '-133.804', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1117.10', '-744.479', '-145.629', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1068.57', '-742.832', '-151.733', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1058.16', '-706.078', '-156.611', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1042.02', '-695.821', '-163.758', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1024.23', '-684.475', '-173.294', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '1002.31', '-661.990', '-194.192', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '975.182', '-641.047', '-201.577', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '936.253', '-612.500', '-203.622', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '899.612', '-613.543', '-202.238', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '856.456', '-617.906', '-202.157', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '831.386', '-627.893', '-203.149', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '816.582', '-641.068', '-203.889', '0', '0', '100');
SET @CGUID := 56855;
SET @POINT := 0;
DELETE FROM `creature_movement` WHERE `id`=@CGUID;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `orientation`) VALUES
(@CGUID, @POINT := @POINT + 1, '695.798', '-526.238', '-214.307', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '706.807', '-515.222', '-215.460', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '708.752', '-494.487', '-213.944', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '706.407', '-474.379', '-211.167', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '708.752', '-494.487', '-213.944', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '706.807', '-515.222', '-215.460', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '695.798', '-526.238', '-214.307', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '671.732', '-532.863', '-210.532', '0', '0', '100');
SET @CGUID := 56856;
SET @POINT := 0;
DELETE FROM `creature_movement` WHERE `id`=@CGUID;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `orientation`) VALUES
(@CGUID, @POINT := @POINT + 1, '694.382', '-643.128', '-209.786', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '691.994', '-667.745', '-209.655', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '712.624', '-699.469', '-209.726', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '672.705', '-770.889', '-209.070', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '696.889', '-727.380', '-209.428', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '672.705', '-770.889', '-209.070', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '712.624', '-699.469', '-209.726', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '691.994', '-667.745', '-209.655', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '694.382', '-643.128', '-209.786', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '706.599', '-608.756', '-209.786', '0', '0', '100');
SET @CGUID := 56857;
SET @POINT := 0;
DELETE FROM `creature_movement` WHERE `id`=@CGUID;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `orientation`) VALUES
(@CGUID, @POINT := @POINT + 1, '723.831', '-518.310', '-217.610', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '706.713', '-535.847', '-216.719', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '685.786', '-543.645', '-211.200', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '667.631', '-538.124', '-209.992', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '685.786', '-543.645', '-211.200', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '706.713', '-535.847', '-216.719', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '723.831', '-518.310', '-217.610', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '728.272', '-487.492', '-212.950', '0', '0', '100');
SET @CGUID := 56858;
SET @POINT := 0;
DELETE FROM `creature_movement` WHERE `id`=@CGUID;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `orientation`) VALUES
(@CGUID, @POINT := @POINT + 1, '693.790', '-895.405', '-199.332', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '676.304', '-859.072', '-207.397', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '660.533', '-846.330', '-208.582', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '676.304', '-859.072', '-207.397', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '693.790', '-895.405', '-199.332', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '709.725', '-933.081', '-191.216', '0', '0', '100');
SET @CGUID := 56859;
SET @POINT := 0;
DELETE FROM `creature_movement` WHERE `id`=@CGUID;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `orientation`) VALUES
(@CGUID, @POINT := @POINT + 1, '687.794', '-1186.92', '-122.332', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '678.912', '-1171.26', '-124.993', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '681.356', '-1157.21', '-129.422', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '688.810', '-1145.38', '-132.649', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '705.075', '-1129.98', '-137.404', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '726.270', '-1123.73', '-140.431', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '751.834', '-1124.25', '-144.358', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '786.123', '-1142.03', '-149.575', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '797.667', '-1151.59', '-151.210', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '809.099', '-1147.87', '-152.479', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '839.597', '-1126.93', '-156.889', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '852.072', '-1110.01', '-164.803', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '866.193', '-1092.76', '-172.849', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '872.731', '-1072.91', '-180.544', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '867.892', '-1050.32', '-187.042', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '862.483', '-1025.39', '-193.773', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '837.978', '-1005.71', '-203.433', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '811.050', '-995.472', '-207.770', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '837.978', '-1005.71', '-203.433', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '862.483', '-1025.39', '-193.773', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '867.892', '-1050.32', '-187.042', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '872.731', '-1072.91', '-180.544', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '866.193', '-1092.76', '-172.849', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '852.072', '-1110.01', '-164.803', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '839.597', '-1126.93', '-156.889', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '809.099', '-1147.87', '-152.479', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '797.667', '-1151.59', '-151.210', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '786.123', '-1142.03', '-149.575', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '751.834', '-1124.25', '-144.358', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '726.270', '-1123.73', '-140.431', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '705.075', '-1129.98', '-137.404', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '688.810', '-1145.38', '-132.649', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '681.356', '-1157.21', '-129.422', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '678.912', '-1171.26', '-124.993', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '687.782', '-1186.92', '-122.332', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '702.477', '-1195.07', '-120.226', '0', '0', '100');
SET @CGUID := 56860;
SET @POINT := 0;
DELETE FROM `creature_movement` WHERE `id`=@CGUID;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `orientation`) VALUES
(@CGUID, @POINT := @POINT + 1, '568.275', '-805.672', '-206.751', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '571.174', '-823.573', '-206.936', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '580.753', '-839.172', '-206.023', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '606.391', '-839.914', '-207.404', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '640.346', '-838.716', '-208.401', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '606.391', '-839.914', '-207.404', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '580.753', '-839.172', '-206.023', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '571.174', '-823.573', '-206.936', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '568.275', '-805.672', '-206.751', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '574.772', '-784.437', '-207.124', '0', '0', '100');
SET @CGUID := 56861;
SET @POINT := 0;
DELETE FROM `creature_movement` WHERE `id`=@CGUID;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `orientation`) VALUES
(@CGUID, @POINT := @POINT + 1, '820.138', '-991.096', '-207.345', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '837.512', '-1001.87', '-203.928', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '875.271', '-1009.17', '-195.795', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '884.141', '-1024.13', '-192.933', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '875.271', '-1009.17', '-195.795', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '837.512', '-1001.87', '-203.928', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '820.138', '-991.096', '-207.135', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '815.059', '-979.847', '-208.618', '0', '0', '100');
SET @CGUID := 56862;
SET @POINT := 0;
DELETE FROM `creature_movement` WHERE `id`=@CGUID;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `orientation`) VALUES
(@CGUID, @POINT := @POINT + 1, '619.315', '-1131.17', '-201.625', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '635.516', '-1094.70', '-196.748', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '637.127', '-1060.91', '-199.242', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '635.516', '-1094.70', '-196.748', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '619.315', '-1131.17', '-201.625', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '610.037', '-1155.73', '-198.829', '0', '0', '100');
SET @CGUID := 56863;
SET @POINT := 0;
DELETE FROM `creature_movement` WHERE `id`=@CGUID;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `orientation`) VALUES
(@CGUID, @POINT := @POINT + 1, '713.138', '-1077.04', '-178.463', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '756.490', '-1086.39', '-165.027', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '791.674', '-1098.38', '-157.489', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '811.462', '-1112.42', '-155.172', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '820.886', '-1133.54', '-153.956', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '807.413', '-1143.59', '-152.211', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '788.381', '-1136.84', '-150.057', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '774.828', '-1122.12', '-148.799', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '753.060', '-1112.58', '-145.972', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '723.394', '-1111.52', '-142.158', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '692.821', '-1125.59', '-137.050', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '670.802', '-1153.98', '-128.281', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '669.009', '-1180.97', '-123.080', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '670.802', '-1153.98', '-128.281', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '692.821', '-1125.59', '-137.050', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '723.394', '-1111.52', '-142.158', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '753.060', '-1112.58', '-145.972', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '774.828', '-1122.12', '-148.799', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '788.381', '-1136.84', '-150.057', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '807.413', '-1143.59', '-152.211', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '820.886', '-1133.54', '-153.956', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '811.462', '-1112.42', '-155.172', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '791.674', '-1098.38', '-157.489', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '756.490', '-1086.39', '-165.027', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '713.138', '-1077.04', '-178.463', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '666.226', '-1071.98', '-188.574', '0', '0', '100');
SET @CGUID := 56864;
SET @POINT := 0;
DELETE FROM `creature_movement` WHERE `id`=@CGUID;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `orientation`) VALUES
(@CGUID, @POINT := @POINT + 1, '733.284', '-1027.08', '-177.554', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '695.602', '-1035.41', '-182.909', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '652.935', '-1047.06', '-195.193', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '695.602', '-1035.41', '-182.909', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '733.284', '-1027.08', '-177.554', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '746.131', '-1006.09', '-177.438', '0', '0', '100');
SET @CGUID := 56865;
SET @POINT := 0;
DELETE FROM `creature_movement` WHERE `id`=@CGUID;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `orientation`) VALUES
(@CGUID, @POINT := @POINT + 1, '819.106', '-631.475', '-202.439', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '842.299', '-620.290', '-203.650', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '863.201', '-606.666', '-201.966', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '880.717', '-589.987', '-203.519', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '891.586', '-563.166', '-204.177', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '880.717', '-589.987', '-203.519', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '863.201', '-606.666', '-201.966', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '842.299', '-620.290', '-203.650', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '819.106', '-631.475', '-202.439', '0', '0', '100'),
(@CGUID, @POINT := @POINT + 1, '801.153', '-637.229', '-203.292', '0', '0', '100');
-- End of migration.
END IF;
END??
delimiter ;
CALL add_migration();
DROP PROCEDURE IF EXISTS add_migration;
Reference in a new issue View git blame Copy permalink