diff options
| author | Killyana <morphone1@gmail.com> | 2020-01-03 17:07:14 +0100 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2021-12-19 22:40:46 +0100 |
| commit | 07046d0cf09d38c295765232cfc94cc0538ef3a9 (patch) | |
| tree | 0ffe12ed1a5bec0c73ee4d733ea33e7bf90f9381 | |
| parent | 3f3abe9ad0dac56637b1c135c6eafe4054d55c47 (diff) | |
DB/Gossips: Remove a custom gossip from some Innkeepers
(cherry picked from commit 87e1f7366a6b73475f4ca893d0e7a22651c5c1ad)
| -rw-r--r-- | sql/updates/world/master/2021_12_19_32_world_2020_01_03_02_world.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_12_19_32_world_2020_01_03_02_world.sql b/sql/updates/world/master/2021_12_19_32_world_2020_01_03_02_world.sql new file mode 100644 index 00000000000..e9275e6585c --- /dev/null +++ b/sql/updates/world/master/2021_12_19_32_world_2020_01_03_02_world.sql @@ -0,0 +1,6 @@ +-- +UPDATE `creature_template` SET `gossip_menu_id`=344 WHERE `entry` IN (11106,6746,9501,7737); +DELETE FROM `gossip_menu` WHERE `MenuID` IN (21215) AND `TextID` IN (822); +DELETE FROM `gossip_menu_option` WHERE `MenuID` IN (21215); +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (15) AND `SourceGroup` IN(21215); +UPDATE `smart_scripts` SET `event_param1`=344, `event_param2`=2 WHERE `entryorguid`=6746 AND `source_type`=0 AND `id`=0; |