diff options
| author | Malcrom <malcromdev@gmail.com> | 2012-01-04 10:34:34 +0100 |
|---|---|---|
| committer | ZxBiohazardZx <zxbiohazardzx@gmail.com> | 2012-01-04 10:34:34 +0100 |
| commit | 110432ec679c6097cf56fb6181f052314119b62a (patch) | |
| tree | 8390bee62098691ab676fca2619449ea9c958853 | |
| parent | 16fea505c48978b388e7b6d8a9de5964f753d160 (diff) | |
DB/Gossip: add some missing gossips from sniff
| -rw-r--r-- | sql/updates/world/2012_01_02_02_world_creature_template.sql | 2 | ||||
| -rw-r--r-- | sql/updates/world/2012_01_03_00_world_gossip_menu.sql | 17 |
2 files changed, 18 insertions, 1 deletions
diff --git a/sql/updates/world/2012_01_02_02_world_creature_template.sql b/sql/updates/world/2012_01_02_02_world_creature_template.sql index 1f87f418dec..ed95c4450fd 100644 --- a/sql/updates/world/2012_01_02_02_world_creature_template.sql +++ b/sql/updates/world/2012_01_02_02_world_creature_template.sql @@ -17,5 +17,5 @@ UPDATE `creature_template` SET `flags_extra`= `flags_extra`|64 WHERE `entry` IN 31484, -- Azure Binder 31488, -- Azure Invader 31495, -- Azure Spellbreaker -31498, -- Azure Mage Slayer +31498 -- Azure Mage Slayer ); diff --git a/sql/updates/world/2012_01_03_00_world_gossip_menu.sql b/sql/updates/world/2012_01_03_00_world_gossip_menu.sql new file mode 100644 index 00000000000..9e9bba43b1a --- /dev/null +++ b/sql/updates/world/2012_01_03_00_world_gossip_menu.sql @@ -0,0 +1,17 @@ +-- Gossip Menu insert from sniff +DELETE FROM `gossip_menu` WHERE `entry`=9918 AND `text_id`=13792; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (9918,13792); +DELETE FROM `gossip_menu` WHERE `entry`=9859 AND `text_id`=13650; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (9859,13650); +DELETE FROM `gossip_menu` WHERE `entry`=9857 AND `text_id`=13651; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (9857,13651); +-- Creature Gossip_menu_id Update from sniff +UPDATE `creature_template` SET `gossip_menu_id`=10316 WHERE `entry`=33224; +UPDATE `creature_template` SET `gossip_menu_id`=9918 WHERE `entry`=29430; +UPDATE `creature_template` SET `gossip_menu_id`=9859 WHERE `entry`=29434; +-- Creature Gossip_menu_option Update from sniff +DELETE FROM `gossip_menu_option` WHERE `menu_id` IN (10316,9857,9917) AND `id` IN (0); +INSERT INTO `gossip_menu_option` (`menu_id`,`id`,`option_icon`,`option_text`,`option_id`,`npc_option_npcflag`,`action_menu_id`,`action_poi_id`,`box_coded`,`box_money`,`box_text`) VALUES +(10316,0,0, 'Glad to help, my lady. I''m told you were once the guardian of a fabled sword. Do you know where I might find it?',1,1,10315,0,0,0, ''), +(9857,0,0, 'I''m ready - lets get you out of here.',1,1,0,0,0,0, ''), +(9917,0,0, 'I am ready to head further into Storm Peaks.',1,1,0,0,0,0, ''); |