diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2016-09-03 02:30:01 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2016-09-03 02:30:01 +0200 |
| commit | a140ba4b7598636e1e90ed0243b58878231e4b3b (patch) | |
| tree | bf9929efcff5e1d8e17feced8af7977ec622a3dc | |
| parent | 128def1e5ee48396c537e741b9377e7007527104 (diff) | |
DB/Misc: Fix startup errors
Cherry pick of https://github.com/TrinityCoreLegacy/TrinityCore/commit/b56d70a9e58fe6ab8c64a641171187d9cb232259 and others
| -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); |