11504 The Dead Rise! Renumbered

[eyerobot]

This is a workaround for Orfus Of Kamagua not showing quests to horde characters. It changes the quest id, And fixes the spell area for Northsea Force Reaction spell.

-- 11504 The Dead Rise! Renumbered

UPDATE `quest_template` SET `Id`='1150400' WHERE  `Id`=11504;
UPDATE `quest_template` SET `PrevQuestId` = 1150400 WHERE `Id` = 11507;

UPDATE `quest_template` SET `NextQuestId` = 1150400, `NextQuestIdChain` = 1150400 WHERE `Id` = 11573;

UPDATE `creature_questrelation` SET `quest`='1150400' WHERE  `id`=23804 AND `quest`=11504;
UPDATE `creature_involvedrelation` SET `quest`='1150400' WHERE  `id`=23804 AND `quest`=11504;

-- 44017 Spell Northsea Force Reaction Spell Area
DELETE FROM `spell_area` WHERE `spell`=44017 AND `quest_start`=11504;
DELETE FROM `spell_area` WHERE `spell`=44017 AND `area`=3992 AND `quest_start`=1150400 AND `quest_start_active`=1 AND `aura_spell`=0 AND `racemask`=0 AND `gender`=2;
INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_start_active`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`, `quest_start_status`, `quest_end_status`) VALUES (44017, 3992, 1150400, 1, 0, 0, 0, 2, 1, 74, 11);

 

[ExO]

Executed to the newest Emucoach 4.3.4 repack, VIP.

Thanks!