aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorWyreth <Wyreth@users.noreply.github.com>2017-11-08 18:45:47 +0100
committerKillyana <morphone1@gmail.com>2017-11-08 18:45:47 +0100
commit4ceb200e44bb35727729b9a78b94dba264e2a1ed (patch)
tree0a5b5e9dc46bc81b07d6d60adbc2a48deeddd061
parent6c2b6c28a28be555a2b7ec62ff9036f2a1772c53 (diff)
DB/CreatureText: Some on-low-health texts for Scarlet Peasant are missing
Closes #20808
-rw-r--r--sql/updates/world/3.3.5/2017_11_08_11_world.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_11_08_11_world.sql b/sql/updates/world/3.3.5/2017_11_08_11_world.sql
new file mode 100644
index 00000000000..06c83cd4da5
--- /dev/null
+++ b/sql/updates/world/3.3.5/2017_11_08_11_world.sql
@@ -0,0 +1,6 @@
+--
+DELETE FROM `creature_text` WHERE `CreatureID`=28557 AND `ID` BETWEEN 5 AND 7;
+INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES
+(28557, 0, 5, "Please, no! Spare me!", 12, 0, 100, 0, 0, 0, 29009, 0, "Scarlet Peasant"),
+(28557, 0, 6, "Don't kill me! I only took this job for the benefits!", 12, 0, 100, 0, 0, 0, 29010, 0, "Scarlet Peasant"),
+(28557, 0, 7, "Let me live! I'll do whatever you say!", 12, 0, 100, 0, 0, 0, 29011, 0, "Scarlet Peasant");