aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorZenoX92 <ZenoX92@users.noreply.github.com>2017-09-06 22:12:58 +0200
committerKillyana <morphone1@gmail.com>2017-09-06 22:12:58 +0200
commit12ea2fdaec8f2b15bcac686e7fab713d13a6c546 (patch)
tree5cd7e3c0e61fa6dfd3aa17c87da39c90c38c2570
parentd8b5e4a99c2f3936a7976a1dad3b78a1e32ae37d (diff)
DB/Creature text: Add missing text to Erich Lohan
Closes #20259
-rw-r--r--sql/updates/world/3.3.5/2017_09_06_08_world.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_09_06_08_world.sql b/sql/updates/world/3.3.5/2017_09_06_08_world.sql
new file mode 100644
index 00000000000..cde8354444e
--- /dev/null
+++ b/sql/updates/world/3.3.5/2017_09_06_08_world.sql
@@ -0,0 +1,4 @@
+-- Erich Lohan
+DELETE FROM `creature_text` WHERE `CreatureID`=3627 AND `GroupID`=0 AND `ID`=7;
+INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES
+(3627,0,7,'Ask me how to get a free drink at the Blue Recluse!',12,7,100,0,0,0,1192,0,'Erich Lohan');