118 lines
7.2 KiB
SQL
118 lines
7.2 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`='20250322221418');
|
|
IF v = 0 THEN
|
|
INSERT INTO `migrations` VALUES ('20250322221418');
|
|
-- Add your query below.
|
|
|
|
|
|
-- Allow assigning scripts in areatrigger template.
|
|
ALTER TABLE `areatrigger_template`
|
|
ADD COLUMN `cooldown` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `box_orientation`,
|
|
ADD COLUMN `condition_id` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `cooldown`,
|
|
ADD COLUMN `script_id` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `condition_id`,
|
|
ADD COLUMN `script_name` VARCHAR(64) NOT NULL DEFAULT '' AFTER `script_id`;
|
|
|
|
-- Move scripts from scripted_areatrigger table.
|
|
UPDATE `areatrigger_template` SET `script_name`='at_huldar_miran' WHERE `id`=171;
|
|
UPDATE `areatrigger_template` SET `script_name`='at_twiggy_flathead' WHERE `id`=522;
|
|
UPDATE `areatrigger_template` SET `script_name`='at_zumrah' WHERE `id`=962;
|
|
UPDATE `areatrigger_template` SET `script_name`='at_antusul' WHERE `id`=1447;
|
|
UPDATE `areatrigger_template` SET `script_name`='at_ring_of_law' WHERE `id`=1526;
|
|
UPDATE `areatrigger_template` SET `script_name`='at_sentry_point' WHERE `id`=1667;
|
|
UPDATE `areatrigger_template` SET `script_name`='at_scent_larkorwi' WHERE `id`=1726;
|
|
UPDATE `areatrigger_template` SET `script_name`='at_scent_larkorwi' WHERE `id`=1727;
|
|
UPDATE `areatrigger_template` SET `script_name`='at_scent_larkorwi' WHERE `id`=1728;
|
|
UPDATE `areatrigger_template` SET `script_name`='at_scent_larkorwi' WHERE `id`=1729;
|
|
UPDATE `areatrigger_template` SET `script_name`='at_scent_larkorwi' WHERE `id`=1730;
|
|
UPDATE `areatrigger_template` SET `script_name`='at_scent_larkorwi' WHERE `id`=1731;
|
|
UPDATE `areatrigger_template` SET `script_name`='at_scent_larkorwi' WHERE `id`=1732;
|
|
UPDATE `areatrigger_template` SET `script_name`='at_scent_larkorwi' WHERE `id`=1733;
|
|
UPDATE `areatrigger_template` SET `script_name`='at_scent_larkorwi' WHERE `id`=1734;
|
|
UPDATE `areatrigger_template` SET `script_name`='at_scent_larkorwi' WHERE `id`=1735;
|
|
UPDATE `areatrigger_template` SET `script_name`='at_scent_larkorwi' WHERE `id`=1736;
|
|
UPDATE `areatrigger_template` SET `script_name`='at_scent_larkorwi' WHERE `id`=1737;
|
|
UPDATE `areatrigger_template` SET `script_name`='at_scent_larkorwi' WHERE `id`=1738;
|
|
UPDATE `areatrigger_template` SET `script_name`='at_scent_larkorwi' WHERE `id`=1739;
|
|
UPDATE `areatrigger_template` SET `script_name`='at_scent_larkorwi' WHERE `id`=1740;
|
|
UPDATE `areatrigger_template` SET `script_name`='at_scent_larkorwi' WHERE `id`=1766;
|
|
UPDATE `areatrigger_template` SET `script_name`='at_shadowforge_bridge' WHERE `id`=1786;
|
|
UPDATE `areatrigger_template` SET `script_name`='at_murloc_camp' WHERE `id`=1966;
|
|
UPDATE `areatrigger_template` SET `script_name`='at_blackrock_spire' WHERE `id`=2026;
|
|
UPDATE `areatrigger_template` SET `script_name`='at_blackrock_spire' WHERE `id`=2046;
|
|
UPDATE `areatrigger_template` SET `script_name`='at_ubrs_the_beast' WHERE `id`=2066;
|
|
UPDATE `areatrigger_template` SET `script_name`='at_stormwind_gates' WHERE `id`=2786;
|
|
UPDATE `areatrigger_template` SET `script_name`='at_ravenholdt' WHERE `id`=3066;
|
|
UPDATE `areatrigger_template` SET `script_name`='at_childrens_week_spot' WHERE `id`=3546;
|
|
UPDATE `areatrigger_template` SET `script_name`='at_childrens_week_spot' WHERE `id`=3547;
|
|
UPDATE `areatrigger_template` SET `script_name`='at_childrens_week_spot' WHERE `id`=3548;
|
|
UPDATE `areatrigger_template` SET `script_name`='at_childrens_week_spot' WHERE `id`=3549;
|
|
UPDATE `areatrigger_template` SET `script_name`='at_childrens_week_spot' WHERE `id`=3550;
|
|
UPDATE `areatrigger_template` SET `script_name`='at_childrens_week_spot' WHERE `id`=3552;
|
|
UPDATE `areatrigger_template` SET `script_name`='at_irontree_wood' WHERE `id`=3587;
|
|
UPDATE `areatrigger_template` SET `script_name`='at_enter_vael_room' WHERE `id`=3626;
|
|
UPDATE `areatrigger_template` SET `script_name`='at_dmf_chest_dm' WHERE `id`=3746;
|
|
UPDATE `areatrigger_template` SET `script_name`='at_dmf_chest_wc' WHERE `id`=3766;
|
|
UPDATE `areatrigger_template` SET `script_name`='at_orb_of_command' WHERE `id`=3847;
|
|
UPDATE `areatrigger_template` SET `script_name`='at_shade_of_eranikus' WHERE `id`=4016;
|
|
UPDATE `areatrigger_template` SET `script_name`='at_twilight_grove' WHERE `id`=4017;
|
|
UPDATE `areatrigger_template` SET `script_name`='at_temple_ahnqiraj' WHERE `id`=4033;
|
|
UPDATE `areatrigger_template` SET `script_name`='at_temple_ahnqiraj' WHERE `id`=4034;
|
|
UPDATE `areatrigger_template` SET `script_name`='at_temple_ahnqiraj' WHERE `id`=4036;
|
|
UPDATE `areatrigger_template` SET `script_name`='at_temple_ahnqiraj' WHERE `id`=4047;
|
|
UPDATE `areatrigger_template` SET `script_name`='at_temple_ahnqiraj' WHERE `id`=4052;
|
|
UPDATE `areatrigger_template` SET `script_name`='at_cathedral_entrance' WHERE `id`=4089;
|
|
UPDATE `areatrigger_template` SET `script_name`='at_naxxramas' WHERE `id`=4112;
|
|
UPDATE `areatrigger_template` SET `script_name`='at_naxxramas' WHERE `id`=4113;
|
|
UPDATE `areatrigger_template` SET `script_name`='at_naxxramas' WHERE `id`=4115;
|
|
UPDATE `areatrigger_template` SET `script_name`='at_naxxramas' WHERE `id`=4117;
|
|
UPDATE `areatrigger_template` SET `script_name`='at_naxxramas' WHERE `id`=4156;
|
|
|
|
-- This table is no longer needed.
|
|
DROP TABLE `scripted_areatrigger`;
|
|
|
|
-- Add db scripts table for areatriggers.
|
|
CREATE TABLE IF NOT EXISTS `areatrigger_scripts` (
|
|
`id` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`delay` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`priority` tinyint(3) unsigned NOT NULL DEFAULT '0',
|
|
`command` tinyint(3) unsigned NOT NULL DEFAULT '0',
|
|
`datalong` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`datalong2` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`datalong3` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`datalong4` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`target_param1` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`target_param2` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`target_type` tinyint(3) unsigned NOT NULL DEFAULT '0',
|
|
`data_flags` tinyint(3) unsigned NOT NULL DEFAULT '0',
|
|
`dataint` int(11) NOT NULL DEFAULT '0',
|
|
`dataint2` int(11) NOT NULL DEFAULT '0',
|
|
`dataint3` int(11) NOT NULL DEFAULT '0',
|
|
`dataint4` int(11) NOT NULL DEFAULT '0',
|
|
`x` float NOT NULL DEFAULT '0',
|
|
`y` float NOT NULL DEFAULT '0',
|
|
`z` float NOT NULL DEFAULT '0',
|
|
`o` float NOT NULL DEFAULT '0',
|
|
`condition_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
|
|
`comments` varchar(255) NOT NULL
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
|
|
|
-- Move Aurius greeting script from EventAI to areatrigger.
|
|
DELETE FROM `creature_ai_events` WHERE `id`=1091702;
|
|
DELETE FROM `creature_ai_scripts` WHERE `id`=1091702;
|
|
UPDATE `areatrigger_template` SET `name`='Stratholme, Alonsus Chapel - Near Aurius', `cooldown`=30, `script_id`=2187 WHERE `id`=2187 && `build`=4222;
|
|
DELETE FROM `areatrigger_scripts` WHERE `id`=2187;
|
|
INSERT INTO `areatrigger_scripts` (`id`, `delay`, `priority`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES
|
|
(2187, 0, 0, 39, 1091702, 0, 0, 0, 10917, 30, 10, 18, 100, 0, 0, 0, 0, 0, 0, 0, 0, 'Aurius - Start Script');
|
|
|
|
|
|
-- End of migration.
|
|
END IF;
|
|
END??
|
|
DELIMITER ;
|
|
CALL add_migration();
|
|
DROP PROCEDURE IF EXISTS add_migration;
|