diff options
| -rw-r--r-- | sql/updates/world/6.x/2016_09_03_01_world.sql | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/sql/updates/world/6.x/2016_09_03_01_world.sql b/sql/updates/world/6.x/2016_09_03_01_world.sql new file mode 100644 index 00000000000..5368a599c0e --- /dev/null +++ b/sql/updates/world/6.x/2016_09_03_01_world.sql @@ -0,0 +1,16 @@ +-- +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2048 WHERE `entry` IN (48270,42347); +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|134217728 WHERE `entry` IN (47774,47775,47776); +UPDATE `creature_template` SET `unit_class`=4 WHERE `entry` IN (49050,49047,49053,49056); +UPDATE `creature_template` SET `faction`=14 WHERE `entry` IN (51101,51102,51103); +UPDATE `creature_template` SET `npcflag`=`npcflag`|16777216 WHERE `entry` IN (51101,51102,51103); +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|134217728 WHERE `entry` IN (51104,51105,51106); +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2048 WHERE `entry` IN (42166,42178,42179,42180); +UPDATE `creature_template` SET `unit_class`=4 WHERE `entry` IN (49051,49048,49054,49057); +UPDATE `creature_template` SET `unit_class`=4 WHERE `entry` IN (49052,49049,49055,49058); + +DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN (51101,51102,51103); +INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `cast_flags`) VALUES +(51101, 41020, 1), +(51102, 41020, 1), +(51103, 41020, 1); |