TrinityCore/TrinityCore — Issue #5285: Discontinues invasion connected obsolete quests
Author: Trista
Created: 2012-02-17 16:19:35+00:00
State: open

##-- Removing obsolete quest relations tp prevent giving next one that is not completeble

-- Horde
12788 /BES/, 12812 /Orcs/, 12785 /Trolls/, 12786 /Taurens/, 12787 /Undeads/ the npcs required were only available during oppening of Northrend and 1.1.
DELETE FROM `creature_questrelation` WHERE `quest`=12788;
DELETE FROM `creature_involvedrelation` WHERE `quest`=12788;

DELETE FROM `creature_questrelation` WHERE `quest`=12812;
DELETE FROM `creature_involvedrelation` WHERE `quest`=12812;

DELETE FROM `creature_questrelation` WHERE `quest`=12785;
DELETE FROM `creature_involvedrelation` WHERE `quest`=12785;

DELETE FROM `creature_questrelation` WHERE `quest`=12786;
DELETE FROM `creature_involvedrelation` WHERE `quest`=12786;

DELETE FROM `creature_questrelation` WHERE `quest`=12787;
DELETE FROM `creature_involvedrelation` WHERE `quest`=12787;

-- Alliance
12774 /Humans/, 12776 /Draeneis/, 12771 /Dwarfs/, 12809 /Gnomes/, 12773 /Night Elfs/
DELETE FROM `creature_questrelation` WHERE `quest`=12774;
DELETE FROM `creature_involvedrelation` WHERE `quest`=12774;

DELETE FROM `creature_questrelation` WHERE `quest`=12776;
DELETE FROM `creature_involvedrelation` WHERE `quest`=12776;

DELETE FROM `creature_questrelation` WHERE `quest`=12771;
DELETE FROM `creature_involvedrelation` WHERE `quest`=12771;

DELETE FROM `creature_questrelation` WHERE `quest`=12809;
DELETE FROM `creature_involvedrelation` WHERE `quest`=12809;

DELETE FROM `creature_questrelation` WHERE `quest`=12773;
DELETE FROM `creature_involvedrelation` WHERE `quest`=12773;
##