diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2015-05-23 04:02:02 +0200 |
|---|---|---|
| committer | DDuarte <dnpd.dd@gmail.com> | 2015-07-03 00:38:25 +0100 |
| commit | dbe47f2c2c5e1b8ba9d7aa0a26c737e02f5b15d0 (patch) | |
| tree | a969bef2078a6691d3553dbebdc594f1cb5ac048 | |
| parent | 81fdc456805ec3a0fd24169119fb98862b34afde (diff) | |
DB/Creature: Marshal Dughan
By Killyana, closes #12615
(cherry picked from commit 82664273cc472e2c88a7883cab895f0fe3212569)
| -rw-r--r-- | sql/updates/world/2015_05_23_03_world.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/updates/world/2015_05_23_03_world.sql b/sql/updates/world/2015_05_23_03_world.sql new file mode 100644 index 00000000000..ace8253bbde --- /dev/null +++ b/sql/updates/world/2015_05_23_03_world.sql @@ -0,0 +1,7 @@ +-- +UPDATE `creature_template` SET `npcflag`=3, `gossip_menu_id`=6159 WHERE `entry`=240; +DELETE FROM `gossip_menu` WHERE `entry`=6159; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (6159, 6157); +DELETE FROM `npc_text` WHERE `ID`=6157; +INSERT INTO `npc_text` (`ID`, `text0_0`, `text0_1`, `BroadcastTextID0`, `lang0`, `prob0`, `em0_0`, `em0_1`) VALUES +(6157, 'Ach, it''s hard enough keeping order around here without all these new troubles popping up! I hope you have good news, $n...', 'Ach, it''s hard enough keeping order around here without all these new troubles popping up! I hope you have good news, $n...', 42172, 0, 1, 5, 5); |