mirror of
https://github.com/vmangos/core
synced 2026-08-14 16:29:10 -04:00
18 lines
1.5 KiB
SQL
18 lines
1.5 KiB
SQL
-- This is a custom patch to enable the Hallow's End event on the Elysium realm.
|
|
-- TO BE USED ONLY ON ELYSIUM REALM. Not needed in others since they are past 1.8.
|
|
|
|
UPDATE `game_event` SET `patch_min`=0 WHERE `entry`=12;
|
|
|
|
-- Quests.
|
|
DELETE FROM `quest_template` WHERE (`Title` LIKE "%DISABLED%") && `patch`=0 && `entry` IN (SELECT `quest` FROM `game_event_quest` WHERE `event`=12);
|
|
UPDATE `quest_template` SET `patch`=0 WHERE `patch`=6 && `entry` IN (SELECT `quest` FROM `game_event_quest` WHERE `event`=12);
|
|
UPDATE `creature_involvedrelation` SET `patch`=0 WHERE `patch`=6 && `quest` IN (SELECT `quest` FROM `game_event_quest` WHERE `event`=12);
|
|
UPDATE `creature_questrelation` SET `patch`=0 WHERE `patch`=6 && `quest` IN (SELECT `quest` FROM `game_event_quest` WHERE `event`=12);
|
|
UPDATE `game_event_quest` SET `patch`=0 WHERE `patch`=6 && `event`=12;
|
|
|
|
-- Creatures.
|
|
UPDATE `creature` SET `patch_min`=0 WHERE `guid` IN (SELECT `guid` FROM `game_event_creature` WHERE `event`=12);
|
|
|
|
-- Items.
|
|
UPDATE `item_template` SET `patch`=0 WHERE `entry` IN (20388, 20389, 20390, 20391, 20392, 20393, 20397, 20398, 20399, 20409, 20410, 20411, 20413, 20414, 20516, 20561, 20562, 20563, 20564, 20565, 20566, 20567, 20568, 20569, 20570, 20571, 20572, 20573, 20574);
|
|
DELETE FROM `forbidden_items` WHERE `entry` IN (20388, 20389, 20390, 20391, 20392, 20393, 20397, 20398, 20399, 20409, 20410, 20411, 20413, 20414, 20516, 20561, 20562, 20563, 20564, 20565, 20566, 20567, 20568, 20569, 20570, 20571, 20572, 20573, 20574);
|