From 7dbb7e5c65e63a8b39e32948a2497888e5b9feab Mon Sep 17 00:00:00 2001 From: offl Date: Mon, 20 Dec 2021 02:30:21 +0200 Subject: DB/Creature: Assign correct broadcast texts in few cases (cherry picked from commit ebd61b5fd36b5bdf74670d447bdbbbcb7dbd9a4d) --- sql/updates/world/master/2022_03_24_14_world_2021_12_20_00_world.sql | 5 +++++ 1 file changed, 5 insertions(+) create mode 100644 sql/updates/world/master/2022_03_24_14_world_2021_12_20_00_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2022_03_24_14_world_2021_12_20_00_world.sql b/sql/updates/world/master/2022_03_24_14_world_2021_12_20_00_world.sql new file mode 100644 index 00000000000..76b1a514033 --- /dev/null +++ b/sql/updates/world/master/2022_03_24_14_world_2021_12_20_00_world.sql @@ -0,0 +1,5 @@ +-- +UPDATE `creature_text` SET `BroadcastTextId` = 485, `Text` = "Help!", `Language` = 7 WHERE `CreatureID` = 467 AND `GroupID` = 3 AND `ID` = 1; +UPDATE `creature_text` SET `BroadcastTextId` = 1254 WHERE `CreatureID` = 3817 AND `GroupID` = 0 AND `ID` = 0; +UPDATE `creature_text` SET `BroadcastTextId` = 1254 WHERE `CreatureID` = 3818 AND `GroupID` = 0 AND `ID` = 0; +UPDATE `creature_text` SET `BroadcastTextId` = 24348 WHERE `CreatureID` = 19173 AND `GroupID` = 6 AND `ID` = 2; -- cgit v1.2.3