Core/CreatureTextMgr: Converted chat types to use values found in sniff, without any need for conversions

1 files changed, 7 insertions, 0 deletions

diff --git a/sql/updates/world/2011_05_13_06_world_creature_text.sql b/sql/updates/world/2011_05_13_06_world_creature_text.sql
new file mode 100644
index 00000000000..6a8eca79ade
--- /dev/null
+++ b/sql/updates/world/2011_05_13_06_world_creature_text.sql
@@ -0,0 +1,7 @@
+-- Update creature_text to use proper text values
+UPDATE `creature_text` SET `type`=12 WHERE `type`=0;
+UPDATE `creature_text` SET `type`=14 WHERE `type`=1;
+UPDATE `creature_text` SET `type`=16 WHERE `type`=2;
+UPDATE `creature_text` SET `type`=41 WHERE `type`=3;
+UPDATE `creature_text` SET `type`=15 WHERE `type`=4;
+UPDATE `creature_text` SET `type`=42 WHERE `type`=5;