diff options
| author | Malcrom <malcromdev@gmail.com> | 2013-12-20 01:58:28 -0330 |
|---|---|---|
| committer | Malcrom <malcromdev@gmail.com> | 2013-12-20 01:58:28 -0330 |
| commit | b2724cfeba0f92ae0f9b8e0edcc241c8fafbdd7a (patch) | |
| tree | d2c70ea7f9964ec4716102c32243bfc2261ac446 | |
| parent | 06d42afba09c7048ed42f3e1d923a2a5b6dca93c (diff) | |
DB/Misc: Fix bad data from sniff parser
| -rw-r--r-- | sql/updates/world/2013_12_20_00_world_misc.sql | 3 |
1 files changed, 1 insertions, 2 deletions
diff --git a/sql/updates/world/2013_12_20_00_world_misc.sql b/sql/updates/world/2013_12_20_00_world_misc.sql index f75973db91a..ccbbcb42966 100644 --- a/sql/updates/world/2013_12_20_00_world_misc.sql +++ b/sql/updates/world/2013_12_20_00_world_misc.sql @@ -12,8 +12,7 @@ UPDATE `creature_template` SET `gossip_menu_id`=10662 WHERE `entry` IN (35597,35 UPDATE `creature_template` SET `gossip_menu_id`=10666 WHERE `entry` IN (35596,35598); UPDATE `creature_template` SET `faction_A`=2123, `faction_H`=2123 WHERE `entry` IN (35603,35611,35612); UPDATE `creature_template` SET `baseattacktime`=2000 WHERE `entry` IN (35600,35601,35602,35603,35611,35612); -UPDATE `creature_template` SET `npcflag`=1, `unit_flags`=8040, `flags_extra`=0 WHERE `subname`= 'Wintergrasp Battle-Mage'; -UPDATE `creature_template` SET `unit_flags`=8340 WHERE `entry` IN (35597,35596,32170,32169); +UPDATE `creature_template` SET `npcflag`=1, `unit_flags`=33600, `flags_extra`=0 WHERE `subname`= 'Wintergrasp Battle-Mage'; DELETE FROM `creature_equip_template` WHERE `entry`=35603 AND `id`=2; DELETE FROM `creature_equip_template` WHERE `entry`=35601; INSERT INTO `creature_equip_template` (`entry`,`id`,`itemEntry1`,`itemEntry2`,`itemEntry3`) VALUES (35601,1,30423,0,0); |