aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoroffl <offl@users.noreply.github.com>2020-08-02 21:24:32 +0300
committeroffl <offl@users.noreply.github.com>2020-08-02 21:24:32 +0300
commitfafe10ea87fe3c0ad2d3795142c1fbe217c08ab1 (patch)
tree29ffa37b1f79c62547fc5daa86fecbe44591c3db
parent20f500b013583bd129bd69d90d7874d7dec28654 (diff)
DB/Creature: Fix IC intro texts and TextRange
Closes #25165
-rw-r--r--sql/updates/world/3.3.5/2020_08_02_25_world.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2020_08_02_25_world.sql b/sql/updates/world/3.3.5/2020_08_02_25_world.sql
new file mode 100644
index 00000000000..c9f56fd254d
--- /dev/null
+++ b/sql/updates/world/3.3.5/2020_08_02_25_world.sql
@@ -0,0 +1,5 @@
+-- Fix IC intro texts and TextRange
+-- Highlord Tirion Fordring used broadcast text for his gossip menu; TextRange is wrong at least for type 12
+UPDATE `creature_text` SET `BroadcastTextId` = 37027 WHERE `CreatureID` = 37119 AND `GroupID` = 0 AND `ID` = 0;
+UPDATE `creature_text` SET `TextRange` = 2 WHERE `CreatureID` = 37119;
+UPDATE `creature_text` SET `TextRange` = 2 WHERE `CreatureID` = 37187 AND `GroupID` BETWEEN 15 AND 18;