mirror of
https://github.com/vmangos/core
synced 2026-08-14 16:29:10 -04:00
6bf7401bd4
* Bring transport code closer to cmangos. * Add missing declaration and check for unloading grid. * Override departure time with db period. * Move pet boarding to movement generator. * Send path progress for elevators too. * Allow boarding mind controlled creatures to transport. * Check target's transport. * Fix Eye of Kilrog. * Remove some not needed changes and fix pet facing. * Remove guid from transport table. * Remove debug printf.
42 lines
1.4 KiB
SQL
42 lines
1.4 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`='20210615223353');
|
|
IF v=0 THEN
|
|
INSERT INTO `migrations` VALUES ('20210615223353');
|
|
-- Add your query below.
|
|
|
|
|
|
-- Ratchet and Booty Bay
|
|
UPDATE `transports` SET `period`=350822 WHERE `entry`=20808 && `guid`=1;
|
|
-- Teldrassil and Auberdine
|
|
UPDATE `transports` SET `period`=316253 WHERE `entry`=176244 && `guid`=2;
|
|
-- Menethil Harbor and Theramore Isle
|
|
UPDATE `transports` SET `period`=329315 WHERE `entry`=176231 && `guid`=3;
|
|
-- Menethil Harbor and Auberdine
|
|
UPDATE `transports` SET `period`=295580 WHERE `entry`=176310 && `guid`=4;
|
|
-- Forgotton Coast and Feathermoon Stronghold
|
|
UPDATE `transports` SET `period`=317044 WHERE `entry`=177233 && `guid`=5;
|
|
-- Orgrimmar and Undercity
|
|
UPDATE `transports` SET `period`=356287 WHERE `entry`=164871 && `guid`=6;
|
|
-- Grom'Gol Base Camp and Orgrimmar
|
|
UPDATE `transports` SET `period`=303466 WHERE `entry`=175080 && `guid`=7;
|
|
-- Grom'Gol Base Camp and Undercity
|
|
UPDATE `transports` SET `period`=335297 WHERE `entry`=176495 && `guid`=8;
|
|
|
|
-- Remove guid from table.
|
|
ALTER TABLE `transports`
|
|
DROP COLUMN `guid`;
|
|
|
|
-- Correct summon range of Eye of Kilrog.
|
|
UPDATE `spell_effect_mod` SET `effectRadiusIndex`=7 WHERE `Id` IN (126, 11403);
|
|
|
|
|
|
-- End of migration.
|
|
END IF;
|
|
END??
|
|
delimiter ;
|
|
CALL add_migration();
|
|
DROP PROCEDURE IF EXISTS add_migration;
|