diff options
| author | Vox <ndinosaur1213@Live.com> | 2020-11-28 14:21:10 -0500 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2020-11-28 20:21:10 +0100 |
| commit | 73edb247fda420ed91e32dfe7913d487028708e8 (patch) | |
| tree | 8347317ae209c13ec8914e6bedda63413839c7e1 /data | |
| parent | b9d5698fc5693eca6cf824f82d3c110aa8b3a1ec (diff) | |
fix(DB/gossip): remove cataclysm gossip/gossip flag from Anduin Wrynn (#3717)
Anduin Wrynn should not have gossip in wotlk, should just be static NPC, current gossip is from cataclysm quest
Diffstat (limited to 'data')
| -rw-r--r-- | data/sql/updates/pending_db_world/rev_1605586971095091500.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/data/sql/updates/pending_db_world/rev_1605586971095091500.sql b/data/sql/updates/pending_db_world/rev_1605586971095091500.sql new file mode 100644 index 0000000000..5233021273 --- /dev/null +++ b/data/sql/updates/pending_db_world/rev_1605586971095091500.sql @@ -0,0 +1,6 @@ +INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1605586971095091500'); +-- Remove Quest Giver & Gossip flags +UPDATE `creature_template` SET `npcflag` = 0 WHERE (`entry` = 1747); +-- Remove Cataclysm gossip from DB +DELETE FROM `gossip_menu` WHERE (`MenuID` = 11874) AND (`TextID` IN (16642)); + |