aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorSnapperRy <snapperryen@gmail.com>2016-10-05 18:56:12 +0200
committerGitHub <noreply@github.com>2016-10-05 18:56:12 +0200
commit4450d5b698d4c9a3dc787d2473c0e5005ef03dfb (patch)
tree316e42031847fd68a016e587a09e3f58bd01b2d6
parent5b7078c30ae3dd5e250a55879e3983361b053896 (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.sql18
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.");