Files
moonwell-core-vanilla/sql/migrations/20250608152632_world.sql

64 lines
5.3 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`='20250608152632');
IF v = 0 THEN
INSERT INTO `migrations` VALUES ('20250608152632');
-- Add your query below.
-- Add missing talisman restoration options for Mages.
DELETE FROM `gossip_menu_option` WHERE `menu_id`=6322;
INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_broadcast_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`, `box_coded`, `box_money`, `box_text`, `box_broadcast_text`, `condition_id`) VALUES
(6322, 0, 0, 'I have lost the talisman and require a new one, Al\'tabim.', 10384, 1, 1, -1, 0, 40113, 0, 0, NULL, 0, 40103),
(6322, 1, 0, 'I have lost the talisman and require a new one, Al\'tabim.', 10384, 1, 1, -1, 0, 40114, 0, 0, NULL, 0, 40108),
(6322, 2, 0, 'I have lost the talisman and require a new one, Al\'tabim.', 10384, 1, 1, -1, 0, 40115, 0, 0, NULL, 0, 40113),
(6322, 3, 0, 'I have lost the talisman and require a new one, Al\'tabim.', 10384, 1, 1, -1, 0, 40116, 0, 0, NULL, 0, 40116),
(6322, 4, 0, 'I have lost the talisman and require a new one, Al\'tabim.', 10384, 1, 1, -1, 0, 40020, 0, 0, NULL, 0, 40067),
(6322, 5, 0, 'I have lost the talisman and require a new one, Al\'tabim.', 10384, 1, 1, -1, 0, 40021, 0, 0, NULL, 0, 40072),
(6322, 6, 0, 'I have lost the talisman and require a new one, Al\'tabim.', 10384, 1, 1, -1, 0, 40022, 0, 0, NULL, 0, 40077),
(6322, 7, 0, 'I have lost the talisman and require a new one, Al\'tabim.', 10384, 1, 1, -1, 0, 40023, 0, 0, NULL, 0, 40080),
(6322, 8, 0, 'I have lost the talisman and require a new one, Al\'tabim.', 10384, 1, 1, -1, 0, 40024, 0, 0, NULL, 0, 40085),
(6322, 9, 0, 'I have lost the talisman and require a new one, Al\'tabim.', 10384, 1, 1, -1, 0, 40025, 0, 0, NULL, 0, 40090),
(6322, 10, 0, 'I have lost the talisman and require a new one, Al\'tabim.', 10384, 1, 1, -1, 0, 40026, 0, 0, NULL, 0, 40095),
(6322, 11, 0, 'I have lost the talisman and require a new one, Al\'tabim.', 10384, 1, 1, -1, 0, 40027, 0, 0, NULL, 0, 40098),
(6322, 12, 0, 'I have lost my Confessor\'s Mantle and require a replacement, Al\'tabim.', 12674, 1, 1, -1, 0, 40062, 0, 0, NULL, 0, 40281),
(6322, 13, 0, 'I no longer possess my Zandalar Confessor\'s Bindings. Can you provide a replacement?', 12675, 1, 1, -1, 0, 40063, 0, 0, NULL, 0, 40284),
(6322, 14, 0, 'Al\'tabim, my Zandalar Confessor\'s Wraps have gone missing. Can you replace them?', 12676, 1, 1, -1, 0, 40064, 0, 0, NULL, 0, 40287),
(6322, 15, 0, 'I have lost my Zandalar Illusionist\'s Robe and need a new one, Al\'tabim.', 12677, 1, 1, -1, 0, 40070, 0, 0, NULL, 0, 40305),
(6322, 16, 0, 'Al\'tabim, I seem to have misplaced my Zandalar Illusionist\'s Mantle. Can you supply me with a replacement?', 12678, 1, 1, -1, 0, 40065, 0, 0, NULL, 0, 40290),
(6322, 17, 0, 'I no longer have my Zandalar Illusionist\'s Wraps and require a new pair.', 12679, 1, 1, -1, 0, 40066, 0, 0, NULL, 0, 40293),
(6322, 18, 0, 'I no longer have my Zandalar Demoniac\'s Robe. Can you provide a replacement?', 12680, 1, 1, -1, 0, 40069, 0, 0, NULL, 0, 40302),
(6322, 19, 0, 'Al\'tabim, I have lost my Zandalar Demoniac\'s Mantle. Can you help?', 12681, 1, 1, -1, 0, 40068, 0, 0, NULL, 0, 40299),
(6322, 20, 0, 'My Zandalar Demoniac\'s Wraps have gone missing. Can you provide me with another set?', 12682, 1, 1, -1, 0, 40067, 0, 0, NULL, 0, 40296);
-- R1
DELETE FROM `gossip_scripts` WHERE `id`=40113;
INSERT INTO `gossip_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
(40113, 0, 0, 15, 24038, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Recover ZG Mage Neck R1');
-- R2
DELETE FROM `gossip_scripts` WHERE `id`=40114;
INSERT INTO `gossip_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
(40114, 0, 0, 15, 24039, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Recover ZG Mage Neck R2');
-- R3
DELETE FROM `gossip_scripts` WHERE `id`=40115;
INSERT INTO `gossip_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
(40115, 0, 0, 15, 24040, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Recover ZG Mage Neck R3');
-- R4
DELETE FROM `gossip_scripts` WHERE `id`=40116;
INSERT INTO `gossip_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
(40116, 0, 0, 15, 24041, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Recover ZG Mage Neck R4');
-- End of migration.
END IF;
END??
DELIMITER ;
CALL add_migration();
DROP PROCEDURE IF EXISTS add_migration;