DB/Conditions: add missing data for CONDITION_SOURCE_TYPE_QUEST_ACCEPT and CONDITION_SOURCE_TYPE_QUEST_SHOW_MARK.

Fixes cases where a quest mark was shown without said quest being actually available.

1 files changed, 96 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2016_10_27_00_world_335.sql b/sql/updates/world/3.3.5/2016_10_27_00_world_335.sql
new file mode 100644
index 00000000000..e68c77975f5
--- /dev/null
+++ b/sql/updates/world/3.3.5/2016_10_27_00_world_335.sql
@@ -0,0 +1,96 @@
+--
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=20 AND `SourceEntry` IN (247, 6146, 8353, 8354, 8355, 8356, 8357, 8358, 8359, 8360, 8870, 8871, 8872, 8873, 8874, 8875, 11360, 11361, 11439, 11440, 11449, 11450, 11585, 11586, 12896, 12897, 13146, 13147, 13160, 13164, 13408, 13409, 24819, 24820, 24821, 24822, 24823, 24825, 24826, 24827, 24828, 24829, 24830, 24831, 24832, 24833, 24834, 24835, 24836, 24837, 24838, 24839, 24840, 24841, 24842, 24843, 24844, 24845, 24846, 24847, 25239, 25240, 25242, 25246, 25247, 25248, 25249);
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(20, 0, 247, 0, 1, 8, 0, 2, 0, 0, 0, 0, 0, "", "Show quest only if Sharptalon's Claw (2) quest is rewarded AND"),
+(20, 0, 247, 0, 1, 8, 0, 23, 0, 0, 0, 0, 0, "", "Show quest only if Ursangous's Paw (23) quest is rewarded AND"),
+(20, 0, 247, 0, 1, 8, 0, 24, 0, 0, 0, 0, 0, "", "Show quest only if Shadumbra's Head (24) quest is rewarded AND"),
+(20, 0, 6146, 0, 1, 8, 0, 6145, 0, 0, 0, 0, 0, "", "Nathanos' Ruse requires quest The Crimson Courier (6145)"),
+(20, 0, 6146, 0, 2, 8, 0, 14350, 0, 0, 0, 0, 0, "", "Nathanos' Ruse requires quest The Crimson Courier (14350)"),
+(20, 0, 8353, 0, 0, 12, 0, 12, 0, 0, 0, 0, 0, "", ""),
+(20, 0, 8354, 0, 0, 12, 0, 12, 0, 0, 0, 0, 0, "", "Quest avialable only during Hallow's End event"),
+(20, 0, 8355, 0, 0, 12, 0, 12, 0, 0, 0, 0, 0, "", ""),
+(20, 0, 8356, 0, 0, 12, 0, 12, 0, 0, 0, 0, 0, "", ""),
+(20, 0, 8357, 0, 0, 12, 0, 12, 0, 0, 0, 0, 0, "", ""),
+(20, 0, 8358, 0, 0, 12, 0, 12, 0, 0, 0, 0, 0, "", ""),
+(20, 0, 8359, 0, 0, 12, 0, 12, 0, 0, 0, 0, 0, "", ""),
+(20, 0, 8360, 0, 0, 12, 0, 12, 0, 0, 0, 0, 0, "", ""),
+(20, 0, 8870, 0, 0, 4, 0, 1537, 0, 0, 0, 0, 0, "", "The Lunar Festival: Ironforge"),
+(20, 0, 8871, 0, 0, 4, 0, 1519, 0, 0, 0, 0, 0, "", "The Lunar Festival: Stormwind"),
+(20, 0, 8872, 0, 0, 4, 0, 1657, 0, 0, 0, 0, 0, "", "The Lunar Festival: Darnassus"),
+(20, 0, 8873, 0, 0, 4, 0, 1637, 0, 0, 0, 0, 0, "", "The Lunar Festival: Orgrimmar"),
+(20, 0, 8874, 0, 0, 4, 0, 1497, 0, 0, 0, 0, 0, "", "The Lunar Festival: Undercity"),
+(20, 0, 8875, 0, 0, 4, 0, 1638, 0, 0, 0, 0, 0, "", "The Lunar Festival: Thunder Bluff"),
+(20, 0, 11360, 0, 0, 23, 0, 87, 0, 0, 0, 0, 0, "", ""),
+(20, 0, 11361, 0, 0, 23, 0, 362, 0, 0, 0, 0, 0, "", ""),
+(20, 0, 11439, 0, 0, 23, 0, 131, 0, 0, 0, 0, 0, "", ""),
+(20, 0, 11440, 0, 0, 23, 0, 3576, 0, 0, 0, 0, 0, "", ""),
+(20, 0, 11449, 0, 0, 23, 0, 159, 0, 0, 0, 0, 0, "", ""),
+(20, 0, 11450, 0, 0, 23, 0, 3665, 0, 0, 0, 0, 0, "", ""),
+(20, 0, 11585, 0, 0, 14, 0, 10172, 0, 0, 0, 0, 0, "", "Accept quest 11585 - Quest 10172 needs to be incomplete"),
+(20, 0, 11586, 0, 0, 8, 0, 10172, 0, 0, 0, 0, 0, "", "Accept quest 11586 - Quest 10172 needs to be rewarded"),
+(20, 0, 12896, 0, 0, 8, 0, 12893, 0, 0, 0, 0, 0, "", "If he cannot be turned - alliance"),
+(20, 0, 12897, 0, 0, 8, 0, 12893, 0, 0, 0, 0, 0, "", "If he cannot be turned - horde"),
+(20, 0, 13146, 0, 0, 8, 0, 13145, 0, 0, 0, 0, 0, "", "Generosity Abounds"),
+(20, 0, 13147, 0, 0, 8, 0, 13145, 0, 0, 0, 0, 0, "", "Matchmaker"),
+(20, 0, 13160, 0, 0, 8, 0, 13145, 0, 0, 0, 0, 0, "", "Stunning View"),
+(20, 0, 13164, 0, 0, 8, 0, 13161, 0, 0, 0, 0, 0, "", "The Fate of Bloodbane"),
+(20, 0, 13164, 0, 0, 8, 0, 13162, 0, 0, 0, 0, 0, "", "The Fate of Bloodbane"),
+(20, 0, 13164, 0, 0, 8, 0, 13163, 0, 0, 0, 0, 0, "", "The Fate of Bloodbane"),
+(20, 0, 13408, 0, 0, 15, 0, 1503, 0, 0, 0, 0, 0, "", "Hellfire Fortifications - Alliance -All classes other than dk"),
+(20, 0, 13409, 0, 0, 15, 0, 1503, 0, 0, 0, 0, 0, "", "Hellfire Fortifications - Horde -All classes other than dk"),
+(20, 0, 24819, 0, 0, 2, 0, 50377, 1, 0, 0, 0, 0, "", "A Change of Heart"),
+(20, 0, 24820, 0, 0, 2, 0, 50376, 1, 0, 0, 0, 0, "", "A Change of Heart"),
+(20, 0, 24821, 0, 0, 2, 0, 50375, 1, 0, 0, 0, 0, "", "A Change of Heart"),
+(20, 0, 24822, 0, 0, 2, 0, 50378, 1, 0, 0, 0, 0, "", "A Change of Heart"),
+(20, 0, 24823, 0, 0, 2, 0, 50384, 1, 0, 0, 0, 0, "", "Path of Destruction 1"),
+(20, 0, 24825, 0, 0, 2, 0, 50378, 1, 0, 0, 0, 0, "", "Path of Wisdom 1"),
+(20, 0, 24826, 0, 0, 2, 0, 50376, 1, 0, 0, 0, 0, "", "Path of Vengeance 1"),
+(20, 0, 24827, 0, 0, 2, 0, 50375, 1, 0, 0, 0, 0, "", "Path of Courage 1"),
+(20, 0, 24828, 0, 0, 2, 0, 50377, 1, 0, 0, 0, 0, "", "Path of Destruction 2"),
+(20, 0, 24829, 0, 0, 2, 0, 50397, 1, 0, 0, 0, 0, "", "Path of Destruction 3"),
+(20, 0, 24830, 0, 0, 2, 0, 50386, 1, 0, 0, 0, 0, "", "Path of Wisdom 2"),
+(20, 0, 24831, 0, 0, 2, 0, 50399, 1, 0, 0, 0, 0, "", "Path of Wisdom 3"),
+(20, 0, 24832, 0, 0, 2, 0, 50387, 1, 0, 0, 0, 0, "", "Path of Vengeance 2"),
+(20, 0, 24833, 0, 0, 2, 0, 50401, 1, 0, 0, 0, 0, "", "Path of Vengeance 3"),
+(20, 0, 24834, 0, 0, 2, 0, 50388, 1, 0, 0, 0, 0, "", "Path of Courage 2"),
+(20, 0, 24835, 0, 0, 2, 0, 50403, 1, 0, 0, 0, 0, "", "Path of Courage 3"),
+(20, 0, 24836, 0, 0, 2, 0, 50384, 1, 0, 0, 0, 0, "", "A Change of Heart"),
+(20, 0, 24837, 0, 0, 2, 0, 50386, 1, 0, 0, 0, 0, "", "A Change of Heart"),
+(20, 0, 24838, 0, 0, 2, 0, 50387, 1, 0, 0, 0, 0, "", "A Change of Heart"),
+(20, 0, 24839, 0, 0, 2, 0, 50388, 1, 0, 0, 0, 0, "", "A Change of Heart"),
+(20, 0, 24840, 0, 0, 2, 0, 50397, 1, 0, 0, 0, 0, "", "A Change of Heart"),
+(20, 0, 24841, 0, 0, 2, 0, 50399, 1, 0, 0, 0, 0, "", "A Change of Heart"),
+(20, 0, 24842, 0, 0, 2, 0, 50401, 1, 0, 0, 0, 0, "", "A Change of Heart"),
+(20, 0, 24843, 0, 0, 2, 0, 50403, 1, 0, 0, 0, 0, "", "A Change of Heart"),
+(20, 0, 24844, 0, 0, 2, 0, 50398, 1, 0, 0, 0, 0, "", "A Change of Heart"),
+(20, 0, 24845, 0, 0, 2, 0, 50400, 1, 0, 0, 0, 0, "", "A Change of Heart"),
+(20, 0, 24846, 0, 0, 2, 0, 50402, 1, 0, 0, 0, 0, "", "A Change of Heart"),
+(20, 0, 24847, 0, 0, 2, 0, 50404, 1, 0, 0, 0, 0, "", "A Change of Heart"),
+(20, 0, 25239, 0, 0, 2, 0, 52569, 1, 0, 0, 0, 0, "", "Path of Might 1"),
+(20, 0, 25240, 0, 0, 2, 0, 52570, 1, 0, 0, 0, 0, "", "Path of Might 2"),
+(20, 0, 25242, 0, 0, 2, 0, 52571, 1, 0, 0, 0, 0, "", "Path of Might 3"),
+(20, 0, 25246, 0, 0, 2, 0, 52572, 1, 0, 0, 0, 0, "", "A Change of Heart"),
+(20, 0, 25247, 0, 0, 2, 0, 52569, 1, 0, 0, 0, 0, "", "A Change of Heart"),
+(20, 0, 25248, 0, 0, 2, 0, 52570, 1, 0, 0, 0, 0, "", "A Change of Heart"),
+(20, 0, 25249, 0, 0, 2, 0, 52571, 1, 0, 0, 0, 0, "", "A Change of Heart");
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=19 AND `SourceEntry` IN (13044, 13068, 13086, 13104, 13105, 13120, 13139, 13224, 13225, 13604, 13817);
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(19, 0, 13044, 0, 0, 8, 0, 13008, 0, 0, 0, 0, 0, "", ""),
+(19, 0, 13044, 0, 0, 8, 0, 13039, 0, 0, 0, 0, 0, "", ""),
+(19, 0, 13044, 0, 0, 8, 0, 13040, 0, 0, 0, 0, 0, "", ""),
+(19, 0, 13068, 0, 0, 8, 0, 13139, 0, 0, 0, 0, 0, "", ""),
+(19, 0, 13086, 0, 0, 8, 0, 13070, 0, 0, 0, 0, 0, "", ""),
+(19, 0, 13104, 0, 0, 8, 0, 13086, 0, 0, 0, 0, 0, "", ""),
+(19, 0, 13104, 0, 1, 15, 0, 1503, 0, 0, 0, 0, 0, "", "Show quest 13104 if player is not a Death Knight"),
+(19, 0, 13105, 0, 0, 8, 0, 13086, 0, 0, 0, 0, 0, "", ""),
+(19, 0, 13105, 0, 1, 15, 0, 32, 0, 0, 0, 0, 0, "", "Show quest 13105 if player is a Death Knight"),
+(19, 0, 13120, 0, 0, 8, 0, 13105, 0, 0, 0, 0, 0, "", ""),
+(19, 0, 13120, 0, 1, 8, 0, 13104, 0, 0, 0, 0, 0, "", ""),
+(19, 0, 13139, 0, 0, 8, 0, 13125, 0, 0, 0, 0, 0, "", ""),
+(19, 0, 13139, 0, 0, 8, 0, 13130, 0, 0, 0, 0, 0, "", ""),
+(19, 0, 13139, 0, 0, 8, 0, 13135, 0, 0, 0, 0, 0, "", ""),
+(19, 0, 13224, 0, 0, 8, 0, 13157, 0, 0, 0, 0, 0, "", ""),
+(19, 0, 13225, 0, 0, 8, 0, 13157, 0, 0, 0, 0, 0, "", ""),
+(19, 0, 13604, 0, 0, 19, 0, 1, 0, 0, 0, 0, 0, "", "Archivum Data Disc quest mark only shown in 10 man"),
+(19, 0, 13817, 0, 0, 19, 0, 2, 0, 0, 0, 0, 0, "", "Heroic: Archivum Data Disc quest mark only shown in 25 man");