diff options
| author | Vincent-Michael <Vincent_Michael@gmx.de> | 2014-05-04 12:10:52 +0200 |
|---|---|---|
| committer | Vincent-Michael <Vincent_Michael@gmx.de> | 2014-05-04 12:12:01 +0200 |
| commit | 49018c4bdbcec5e64413b908ba998bacc2ff708a (patch) | |
| tree | 8fc0bffb4d9f2e3fc5d4d4e529957b4971f06e29 | |
| parent | f16caf49ac0540daf5eb86b17bcd7b1446f77ebd (diff) | |
DB/CreatureTexts: Set some creature_text field BroadcastTextId to 0 because change on cata/mop
| -rw-r--r-- | sql/updates/world/2014_05_04_02_world_creature_text.sql | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/sql/updates/world/2014_05_04_02_world_creature_text.sql b/sql/updates/world/2014_05_04_02_world_creature_text.sql new file mode 100644 index 00000000000..d68bdc4ed1c --- /dev/null +++ b/sql/updates/world/2014_05_04_02_world_creature_text.sql @@ -0,0 +1,16 @@ +UPDATE `creature_text` SET `BroadcastTextId`=0 WHERE `entry`=3977 AND `groupid`=1; +UPDATE `creature_text` SET `BroadcastTextId`=0 WHERE `entry`=11380 AND `groupid`=0; +UPDATE `creature_text` SET `BroadcastTextId`=0 WHERE `entry`=23863 AND `groupid`=2; +UPDATE `creature_text` SET `BroadcastTextId`=0 WHERE `entry`=23863 AND `groupid`=3; +UPDATE `creature_text` SET `BroadcastTextId`=0 WHERE `entry`=23863 AND `groupid`=4; +UPDATE `creature_text` SET `BroadcastTextId`=0 WHERE `entry`=23863 AND `groupid`=5; +UPDATE `creature_text` SET `BroadcastTextId`=0 WHERE `entry`=23863 AND `groupid`=6; +UPDATE `creature_text` SET `BroadcastTextId`=0 WHERE `entry`=23863 AND `groupid`=8; +UPDATE `creature_text` SET `BroadcastTextId`=0 WHERE `entry`=23863 AND `groupid`=8; +UPDATE `creature_text` SET `BroadcastTextId`=0 WHERE `entry`=23863 AND `groupid`=9; +UPDATE `creature_text` SET `BroadcastTextId`=0 WHERE `entry`=29 AND `groupid`=1; +UPDATE `creature_text` SET `BroadcastTextId`=0 WHERE `entry`=22515 AND `groupid`=6; +UPDATE `creature_text` SET `BroadcastTextId`=0 WHERE `entry`=22515 AND `groupid`=7; +UPDATE `creature_text` SET `BroadcastTextId`=0 WHERE `entry`=22515 AND `groupid`=8; +UPDATE `creature_text` SET `BroadcastTextId`=0 WHERE `entry`=22515 AND `groupid`=9; +UPDATE `creature_text` SET `BroadcastTextId`=0 WHERE `entry`=22515 AND `groupid`=10; |