diff options
| author | SnapperRy <snapperryen@gmail.com> | 2016-10-05 18:56:12 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2016-10-05 18:56:12 +0200 |
| commit | 4450d5b698d4c9a3dc787d2473c0e5005ef03dfb (patch) | |
| tree | 316e42031847fd68a016e587a09e3f58bd01b2d6 | |
| parent | 5b7078c30ae3dd5e250a55879e3983361b053896 (diff) | |
DB/Creature: fix gossip for some creatures.
Terenthis, Volcor (Darkshore), Denalan (Teldrassil).
| -rw-r--r-- | sql/updates/world/3.3.5/2016_10_05_10_world_335.sql | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2016_10_05_10_world_335.sql b/sql/updates/world/3.3.5/2016_10_05_10_world_335.sql new file mode 100644 index 00000000000..534e8a46145 --- /dev/null +++ b/sql/updates/world/3.3.5/2016_10_05_10_world_335.sql @@ -0,0 +1,18 @@ +-- +UPDATE `creature_template` SET `gossip_menu_id`=3693 WHERE `entry`=3693; +DELETE FROM `gossip_menu` WHERE `entry`=3693; +INSERT INTO `gossip_menu` (`entry`, `text_id`, `VerifiedBuild`) VALUES +(3693, 3334, 0); + +UPDATE `creature_template` SET `gossip_menu_id`=3692 WHERE `entry`=3692; +DELETE FROM `gossip_menu` WHERE `entry`=3692; +INSERT INTO `gossip_menu` (`entry`, `text_id`, `VerifiedBuild`) VALUES +(3692, 3213, 0); + +UPDATE `creature_template` SET `gossip_menu_id`=2080 WHERE `entry`=2080; +DELETE FROM `gossip_menu` WHERE `entry`=2080; +INSERT INTO `gossip_menu` (`entry`, `text_id`, `VerifiedBuild`) VALUES +(2080, 2080, 0); +DELETE FROM `npc_text` WHERE `ID` = 2080; +INSERT INTO `npc_text` (`ID`, `text0_0`) VALUES +(2080, "The creation of Teldrassil was a great achievement, but now the world must shift to regain its balance."); |
