diff options
| author | durotar <dannytj2000@hotmail.com> | 2011-12-09 12:15:19 +0000 |
|---|---|---|
| committer | Nay <dnpd.dd@gmail.com> | 2011-12-09 12:15:19 +0000 |
| commit | 04862de237d4fb9138c96653d29a5f043254f49e (patch) | |
| tree | 514794cb07a73eba71e8e932024b8da0706dee76 | |
| parent | c87d4a0b64499a6a8564e9c0ed44b2e7ceece569 (diff) | |
DB/Gossips: Correct a duplicated gossip id
(2011_10_23_04_world_sai.sql vs 2011_10_23_07_world_sai.sql)
| -rw-r--r-- | sql/updates/world/2011_12_08_00_world_gossip.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/sql/updates/world/2011_12_08_00_world_gossip.sql b/sql/updates/world/2011_12_08_00_world_gossip.sql new file mode 100644 index 00000000000..f6195d9d66e --- /dev/null +++ b/sql/updates/world/2011_12_08_00_world_gossip.sql @@ -0,0 +1,12 @@ +-- fixing conflict in number of gossip_menu_option.menu_id -- compare 2011_10_23_04_world_sai.sql with 2011_10_23_07_world_sai.sql +SET @ENTRY := 18417; +SET @OLDGOSSIP := 21304; +SET @NEWGOSSIP := 21312; +SET @QUEST_PUPIL := 10646; +-- Fixing smart_scripts +UPDATE `smart_scripts` SET `event_param1`=@NEWGOSSIP WHERE `entryorguid`=@ENTRY AND `source_type`=0 AND `id`=2 AND `action_param1`=@QUEST_PUPIL; +-- Fixing gossip_menu_option +UPDATE `gossip_menu_option` SET `action_menu_id`=@NEWGOSSIP WHERE `menu_id`=@OLDGOSSIP+5; +DELETE FROM `gossip_menu_option` WHERE `menu_id`=@NEWGOSSIP; +INSERT INTO `gossip_menu_option` (`menu_id`,`id`,`option_icon`,`option_text`,`option_id`,`npc_option_npcflag`,`action_menu_id`) VALUES +(@NEWGOSSIP,0,0,"There was something else I wanted to ask you, Altruis.",1,3,@OLDGOSSIP+0); |