From f151ff7342e528655965942ce764c4c0603931c6 Mon Sep 17 00:00:00 2001 From: nelegalno Date: Tue, 11 Sep 2012 00:52:14 +0100 Subject: DB/Scripts: Fix quest Finding the Keymaster Ref #4661 Closes #2604 --- sql/updates/world/2012_09_10_10_world_gossips.sql | 2 +- sql/updates/world/2012_09_10_11_world_event_scripts.sql | 7 +++++++ 2 files changed, 8 insertions(+), 1 deletion(-) create mode 100644 sql/updates/world/2012_09_10_11_world_event_scripts.sql (limited to 'sql/updates') 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); -- cgit v1.2.3