diff options
| author | offl <offl@users.noreply.github.com> | 2017-10-29 20:43:22 +0100 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2017-10-29 20:43:22 +0100 |
| commit | a0047e6d2038540b4e7a463f50844130fb78931d (patch) | |
| tree | f49f72a5cfe60afb056ce113a2e2d1dba014793b | |
| parent | bbd79e514f1973a46985caf30cef9157086fc3d9 (diff) | |
DB/Quest greeting: Marshal Dughan
Closes #19756
For 3.3.5 Only
| -rw-r--r-- | sql/updates/world/3.3.5/2017_10_29_11_world_335.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_10_29_11_world_335.sql b/sql/updates/world/3.3.5/2017_10_29_11_world_335.sql new file mode 100644 index 00000000000..66a997418ba --- /dev/null +++ b/sql/updates/world/3.3.5/2017_10_29_11_world_335.sql @@ -0,0 +1,8 @@ +-- +UPDATE `creature_template` SET `npcflag`=2, `gossip_menu_id`=0 WHERE `entry`=240; +DELETE FROM `gossip_menu` WHERE `MenuID`=11611; +DELETE FROM `npc_text` WHERE `ID`=16211; + +DELETE FROM `quest_greeting` WHERE `ID`=240; +INSERT INTO `quest_greeting` (`ID`, `Type`, `GreetEmoteType`, `GreetEmoteDelay`, `Greeting`, `VerifiedBuild`) VALUES +(240, 0, 0, 0, "Ach, it's hard enough keeping order around here without all these new troubles popping up! I hope you have good news, $n...", 0); |