DB/Scripts: Fix quest Finding the Keymaster

Ref #4661
Closes #2604

2 files changed, 8 insertions, 1 deletions

diff --git a/sql/updates/world/2012_09_10_10_world_gossips.sql b/sql/updates/world/2012_09_10_10_world_gossips.sql
index d12b1a29bc5..042b05dc83a 100644
--- a/sql/updates/world/2012_09_10_10_world_gossips.sql
+++ b/sql/updates/world/2012_09_10_10_world_gossips.sql
@@ -108,4 +108,4 @@ DELETE FROM `conditions` WHERE (`SourceTypeOrReferenceId`=14 AND `SourceGroup`=8
 INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
 (14,8433,10291,0,0,15,0,128,0,0,1,0,'','Show gossip text if player is not a mage'),
 (14,8433,10292,0,0,15,0,128,0,0,0,0,'','Show gossip text if player is a mage'),
-(14,12670,12549,0,0,15,0,256,0,1,0,0,'','Show gossip text if player is not a Warlock');
+(14,12670,12549,0,0,15,0,256,0,0,1,0,'','Show gossip text if player is not a Warlock');
diff --git a/sql/updates/world/2012_09_10_11_world_event_scripts.sql b/sql/updates/world/2012_09_10_11_world_event_scripts.sql
new file mode 100644
index 00000000000..e0b122ede05
--- /dev/null
+++ b/sql/updates/world/2012_09_10_11_world_event_scripts.sql
@@ -0,0 +1,7 @@
+-- Finding the Keymaster by nelegalno
+
+UPDATE `quest_template` SET `SpecialFlags` = 0, `RequiredSpellCast1` = 0 WHERE `ID` = 10256;
+DELETE FROM `event_scripts` WHERE id=12857;
+INSERT INTO `event_scripts` (`id`,`delay`,`command`,`datalong`,`datalong2`,`dataint`,`x`,`y`,`z`,`o`) VALUES
+(12857,0,10,19938,3000000,0,2248.43,2227.97,138.56,2.48121),
+(12857,1,8,19938,1,0,0,0,0,0);