diff options
| author | Kinzcool <kerekeszoltan90@freemail.hu> | 2012-07-02 15:38:02 +0100 |
|---|---|---|
| committer | Nay <dnpd.dd@gmail.com> | 2012-07-02 15:39:24 +0100 |
| commit | 798fc2df4016c29441af6666a1b446c57cf81a68 (patch) | |
| tree | 0e339a0ae227dee3a9eb35a3961bc4897fe4879b | |
| parent | 81514542fa442ff40a86cf6a812db7782ba40786 (diff) | |
DB/NPC: Add various missing gossips
Closes #7001
Signed-off-by: Nay <dnpd.dd@gmail.com>
| -rw-r--r-- | sql/updates/world/2012_07_02_03_world_gossip.sql | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/sql/updates/world/2012_07_02_03_world_gossip.sql b/sql/updates/world/2012_07_02_03_world_gossip.sql new file mode 100644 index 00000000000..0c158aa7511 --- /dev/null +++ b/sql/updates/world/2012_07_02_03_world_gossip.sql @@ -0,0 +1,17 @@ +UPDATE `creature_template` SET `gossip_menu_id`=8074 WHERE `entry`=19466; -- Exarch Orelis +UPDATE `creature_template` SET `gossip_menu_id`=8216 WHERE `entry`=20920; -- Magister Theledorn +UPDATE `creature_template` SET `gossip_menu_id`=8661 WHERE `entry`=21112; -- Bossi Pentapiston <Engineering Supplies> + +DELETE FROM `gossip_menu` WHERE (`entry`=8074 AND `text_id`=9980) OR +(`entry`=8216 AND `text_id`=10211) OR +(`entry`=8304 AND `text_id`=10360) OR +(`entry`=8370 AND `text_id`=10444) OR +(`entry`=8385 AND `text_id`=10466) OR +(`entry`=8661 AND `text_id`=10889); +INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES +(8074, 9980), -- 19466 +(8216, 10211), -- 20920 +(8304, 10360), -- 21461 +(8370, 10444), -- 21755 +(8385, 10466), -- 21824 +(8661, 10889); -- 21112 |