TrinityCore/TrinityCore — Issue #5432: [DB/FIX] Pit of Saron (heroic) - mob equipment and hostility
Author: CDawg
Created: 2012-02-25 23:44:22+00:00
State: open

I noticed that the mobs in PoS heroic, are not equipped, seems the difficulty_entry_1 didn't get the equipment from the original entry.
Also this fixes the hostility (attackable) npcs such as Ymirjar Skycaller and the Wrathbone Laborer. Not sure how the faction changed on the Ymirjar Skycaller as well.
Really odd!!
```
-- Pit of Saron (Heroic) fixes npc equipment and hostility
-- Ymirjar Skycaller (heroic) - fixes hostility and corrects the faction
UPDATE `creature_template` SET `faction_A`=1885, `faction_H`=1885, `unit_flags`=32832, `equipment_id`=2438 WHERE `entry`=37643;
-- Wrathbone Laborer (non heroic) - fix hostility
UPDATE `creature_template` SET `unit_flags`=32768 WHERE `entry`=36830;
-- Wrathbone Laborer (heroic) - fix hostility and adds equipment
UPDATE `creature_template` SET `unit_flags`=32768, `equipment_id`=104 WHERE `entry`=37638;
-- Wrathbone Siegesmith add equipment
UPDATE `creature_template` SET `equipment_id`=122 WHERE `entry`=37639;
-- Fallen Warrior add equipment
UPDATE `creature_template` SET `equipment_id`=2443 WHERE `entry`=37612;
-- Forgemaster Garfrost add equipment
UPDATE `creature_template` SET `equipment_id`=2325 WHERE `entry`=37613;
-- Deathwhisper Necrolyte add equipment
UPDATE `creature_template` SET `equipment_id`=2365 WHERE `entry`=37609;
-- Deathwhisper Shadowcaster - add equipment
UPDATE `creature_template` SET `equipment_id`=2365 WHERE `entry`=38025;
-- Alliance slaves add equipments
UPDATE `creature_template` SET `equipment_id`=254 WHERE `entry`=37645;
UPDATE `creature_template` SET `equipment_id`=254 WHERE `entry`=37646;
UPDATE `creature_template` SET `equipment_id`=254 WHERE `entry`=37647;
UPDATE `creature_template` SET `equipment_id`=254 WHERE `entry`=37648;
-- horde slaves add equipments
UPDATE `creature_template` SET `equipment_id`=254 WHERE `entry`=37649;
UPDATE `creature_template` SET `equipment_id`=254 WHERE `entry`=37650;
UPDATE `creature_template` SET `equipment_id`=254 WHERE `entry`=37651;
UPDATE `creature_template` SET `equipment_id`=254 WHERE `entry`=37652;
```