diff options
| author | durotar <dannytj2000@hotmail.com> | 2011-12-18 23:55:14 +0000 |
|---|---|---|
| committer | Nay <dnpd.dd@gmail.com> | 2011-12-18 23:55:14 +0000 |
| commit | e870b0d15c765a56afff4437c3ca9ebfe462561d (patch) | |
| tree | 81fb123a0c6c0609398c9ffca61817100ca7dc21 | |
| parent | 2438f6eebf253a21a111ae5d6723a4969bd0a7d4 (diff) | |
DB/Gossip: Add conditions to Bom'bay's gossip
Closes #4219
| -rw-r--r-- | sql/updates/world/2011_12_18_07_world_conditions.sql | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/sql/updates/world/2011_12_18_07_world_conditions.sql b/sql/updates/world/2011_12_18_07_world_conditions.sql new file mode 100644 index 00000000000..ef669dd2dbb --- /dev/null +++ b/sql/updates/world/2011_12_18_07_world_conditions.sql @@ -0,0 +1,17 @@ +-- Fix condition for Bom'bay's npc_text, gossip_menu and gossip_menu_option +-- Player must to complete quest 826 'Zalazane' to see gossip_menu_option +DELETE FROM `gossip_menu` WHERE `entry`=3062 AND `text_id` IN (3794,3795); +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES +(3062,3794), -- text before to complete quest 826 +(3062,3795); -- text after to complete quest 826 +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (14,15) AND `SourceGroup`=3062; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(14,3062,3794,0,14,826,0,0,0,'', "Bom'bay - show text 3794 if player does not have quest Zalazane"), +(14,3062,3795,0,8,826,0,0,0,'', "Bom'bay - show text 3795 if player has quest Zalazane rewarded"), +(15,3062,0,0,8,826,0,0,0,'', "Bom'bay - show gossip option 0 if player has quest Zalazane rewarded"), +(15,3062,1,0,8,826,0,0,0,'', "Bom'bay - show gossip option 1 if player has quest Zalazane rewarded"), +(15,3062,2,0,8,826,0,0,0,'', "Bom'bay - show gossip option 2 if player has quest Zalazane rewarded"), +(15,3062,3,0,8,826,0,0,0,'', "Bom'bay - show gossip option 3 if player has quest Zalazane rewarded"), +(15,3062,4,0,8,826,0,0,0,'', "Bom'bay - show gossip option 4 if player has quest Zalazane rewarded"), +(15,3062,5,0,8,826,0,0,0,'', "Bom'bay - show gossip option 5 if player has quest Zalazane rewarded"), +(15,3062,6,0,8,826,0,0,0,'', "Bom'bay - show gossip option 6 if player has quest Zalazane rewarded"); |