diff options
| author | nelegalno <nelegalno@yopmail.com> | 2013-01-25 11:57:31 +0000 |
|---|---|---|
| committer | Nay <dnpd.dd@gmail.com> | 2013-01-25 11:57:31 +0000 |
| commit | 9ad8ac73a96e1ee4046c6ae6471b59d0151d2bce (patch) | |
| tree | 426f31c0c752c8edef07688e5a4d6023a43f402e | |
| parent | 670f80fa39b7e72d46dd9af293b73be042ae32ae (diff) | |
DB/Texts: Ensure that correct types are used in `creature_text` (42 texts should be corrected)
Closes #9055
| -rw-r--r-- | sql/updates/world/2013_01_25_00_world_creature_text.sql | 8 |
1 files changed, 8 insertions, 0 deletions
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 |