diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2015-05-23 04:00:28 +0200 |
|---|---|---|
| committer | Aokromes <Aokromes@users.noreply.github.com> | 2015-05-23 04:00:28 +0200 |
| commit | 291fc4d591f828f11268bce9817b28fa7fbef609 (patch) | |
| tree | 206d695d3fd09b0838ae2e67d685f4d6f41d91d4 | |
| parent | b21d3e6298931c79fbb3f2f9062fe95a23d6be6d (diff) | |
DB/Creature: Mountaineer Stormpike
By Killyana, closes #12711
| -rw-r--r-- | sql/updates/world/2015_05_23_02_world.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/updates/world/2015_05_23_02_world.sql b/sql/updates/world/2015_05_23_02_world.sql new file mode 100644 index 00000000000..b00fa1c2d86 --- /dev/null +++ b/sql/updates/world/2015_05_23_02_world.sql @@ -0,0 +1,7 @@ +-- +UPDATE `creature_template` SET `npcflag`=3, `gossip_menu_id`=694 WHERE `entry`=1343; +DELETE FROM `gossip_menu` WHERE `entry`=694; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (694, 1244); +DELETE FROM `npc_text` WHERE `ID`=1244; +INSERT INTO `npc_text` (`ID`, `text0_0`, `text0_1`, `BroadcastTextID0`, `lang0`, `prob0`, `em0_0`, `em0_1`) VALUES +(1244, 'Well, if it isn''t a young, bristling $c, no doubt drawn here by talk of my exploits in fields of battle!$B$BNo time for stories now, for there are great, important deeds that need doing! So if you''re looking for glory, then luck shines on you today...', 'Well, if it isn''t a young, bristling $c, no doubt drawn here by talk of my exploits in fields of battle!$B$BNo time for stories now, for there are great, important deeds that need doing! So if you''re looking for glory, then luck shines on you today...', 0, 0, 1, 0, 0); |