mirror of
https://github.com/vmangos/core
synced 2026-08-14 16:29:10 -04:00
35 lines
1.8 KiB
SQL
35 lines
1.8 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`='20181230142353');
|
|
IF v=0 THEN
|
|
INSERT INTO `migrations` VALUES ('20181230142353');
|
|
-- Add your query below.
|
|
|
|
|
|
-- Fix movement for some creatures
|
|
-- Fix position for some creatures
|
|
-- Add emotes for some creatures
|
|
UPDATE `creature` SET `spawndist` = 0, `MovementType` = 0 WHERE `guid` IN (14096, 14081, 14166, 14174, 14256);
|
|
UPDATE `creature` SET `spawndist` = 3, `MovementType` = 1 WHERE `guid` IN (13605, 13607);
|
|
UPDATE `creature` SET `spawndist` = 5, `MovementType` = 1 WHERE `guid` IN (13820, 15066, 14418, 19791, 13598, 13594, 13614, 13611, 13615, 13627, 13626, 13600);
|
|
UPDATE `creature` SET `spawndist` = 10, `MovementType` = 1 WHERE `guid` IN (51814, 51810, 14033);
|
|
UPDATE `creature` SET `spawndist` = 25, `MovementType` = 1 WHERE `guid` IN (51815, 51816, 15081);
|
|
|
|
UPDATE `creature` SET `position_x` = -912.213, `position_y` = -2217.01, `position_z` = 93.6255, `spawndist` = 10, `MovementType` = 1 WHERE `guid` = 20567;
|
|
UPDATE `creature` SET `position_x` = -107.326, `position_y` = -1851.97, `position_z` = 92.4291, `spawndist` = 8, `MovementType` = 1 WHERE `guid` = 19473;
|
|
UPDATE `creature` SET `position_x` = -53.9019, `position_y` = -1633.82, `position_z` = 91.6667, `orientation` = 4.1112 WHERE `guid` = 20635;
|
|
UPDATE `creature` SET `position_x` = -4062.05, `position_y` = -2173.13, `position_z` = 51.4807, `orientation` = 0.690689 WHERE `guid` = 13610;
|
|
|
|
UPDATE `creature_addon` SET `emote` = 173 WHERE `guid` IN (13610, 13583, 13617);
|
|
UPDATE `creature_addon` SET `bytes1` = 3 WHERE `guid` IN (14200, 14253, 14195, 14215);
|
|
|
|
|
|
-- End of migration.
|
|
END IF;
|
|
END??
|
|
delimiter ;
|
|
CALL add_migration();
|
|
DROP PROCEDURE IF EXISTS add_migration;
|