diff options
| author | Nay <dnpd.dd@gmail.com> | 2011-08-01 01:47:46 +0100 |
|---|---|---|
| committer | Nay <dnpd.dd@gmail.com> | 2011-08-01 01:47:46 +0100 |
| commit | 67ee5a46c35acfe1ab1b6e715c5c56b1cc73e4f7 (patch) | |
| tree | f06d3e1c3568e69eb42680e7f38530b0c152286c | |
| parent | d32b59fee72133c4da7a7bb444d809438f19c697 (diff) | |
SQL: Fix a delete query in previous commit
| -rw-r--r-- | sql/updates/world/2011_08_01_01_world_gossips.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/updates/world/2011_08_01_01_world_gossips.sql b/sql/updates/world/2011_08_01_01_world_gossips.sql index 25447c6d568..dbe2bc92519 100644 --- a/sql/updates/world/2011_08_01_01_world_gossips.sql +++ b/sql/updates/world/2011_08_01_01_world_gossips.sql @@ -24,7 +24,7 @@ INSERT INTO `gossip_menu_option` (`menu_id`,`id`,`option_icon`,`option_text`,`op (@GOSSIP+2,0,0,'What are the components?',1,3,@GOSSIP+3,0,0,0,''); -- Conditions for gossip menu, the 'story' Zanza tells you becomes available when you hit exalted with Zandalar Tribe. -DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=14 AND `SourceGroup` BETWEEN @GOSSIP+0 AND @GOSSIP+3; +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (14,15) AND `SourceGroup` BETWEEN @GOSSIP+0 AND @GOSSIP+3; INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`Comment`) VALUES (14,@GOSSIP+0,7594,0,5,270,3,0,0,"Only show text_id 7594 if player is neutral with Zandalar Tribe (270)"), (14,@GOSSIP+0,7594,1,5,270,4,0,0,"Only show text_id 7594 if player is friendly with Zandalar Tribe (270)"), |