From 9ad8ac73a96e1ee4046c6ae6471b59d0151d2bce Mon Sep 17 00:00:00 2001 From: nelegalno Date: Fri, 25 Jan 2013 11:57:31 +0000 Subject: DB/Texts: Ensure that correct types are used in `creature_text` (42 texts should be corrected) Closes #9055 --- sql/updates/world/2013_01_25_00_world_creature_text.sql | 8 ++++++++ 1 file changed, 8 insertions(+) create mode 100644 sql/updates/world/2013_01_25_00_world_creature_text.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2013_01_25_00_world_creature_text.sql b/sql/updates/world/2013_01_25_00_world_creature_text.sql new file mode 100644 index 00000000000..25354a70390 --- /dev/null +++ b/sql/updates/world/2013_01_25_00_world_creature_text.sql @@ -0,0 +1,8 @@ +-- Update text's with creature_text.type old format values - some missing texts should be fixed. +-- based on http://collab.kpsn.org/display/tc/Creature+text+tc2#Creaturetexttc2-type +UPDATE `creature_text` SET `type`=12 WHERE `type`=0; -- Say +UPDATE `creature_text` SET `type`=14 WHERE `type`=1; -- Yell +UPDATE `creature_text` SET `type`=16 WHERE `type`=2; -- Emote +UPDATE `creature_text` SET `type`=41 WHERE `type`=3; -- Boss Emote +UPDATE `creature_text` SET `type`=15 WHERE `type`=4; -- Whisper +UPDATE `creature_text` SET `type`=42 WHERE `type`=5; -- Boss Whisper -- cgit v1.2.3