diff options
| author | Meji <alvaro.megias@outlook.com> | 2022-10-09 22:03:04 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2022-10-09 22:03:04 +0200 |
| commit | ba49dbfdcbbbee4d6be39284c6924bf56d7f6586 (patch) | |
| tree | 4831ee1c6bf8d98c75e8b0682e5e957dfb5be8c6 /sql/updates/world | |
| parent | d39923e4f916ae635693ae8c4872802570defd87 (diff) | |
Core/Gossip: Drop OptionNpcFlag from gossip_menu_option (#28254)
Co-authored-by: Shauren <shauren.trinity@gmail.com>
Diffstat (limited to 'sql/updates/world')
| -rw-r--r-- | sql/updates/world/master/2022_10_09_09_world.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_10_09_09_world.sql b/sql/updates/world/master/2022_10_09_09_world.sql new file mode 100644 index 00000000000..c2029a02dd4 --- /dev/null +++ b/sql/updates/world/master/2022_10_09_09_world.sql @@ -0,0 +1,9 @@ +-- Update table `gossip_menu_option` +ALTER TABLE `gossip_menu_option` DROP `OptionNpcFlag`; + +-- Argent Squire | Argent Gruntling +UPDATE `creature_template` SET `npcflag`=1 WHERE `entry` IN (33238, 33239); +UPDATE `gossip_menu_option` SET `OptionNpc`=18 WHERE `MenuID` IN (10317, 10318) AND `OptionID`=2; + +-- OptionNpcFlag inserted in wrong field +UPDATE `gossip_menu_option` SET `ActionMenuID`=0 WHERE `MenuID`=10662 AND `OptionID`=0; |