TrinityCore/TrinityCore — Issue #5457: [DB\REP\FIX] ICC 25 Trash, ICC heroic Bosses
Author: gecko32
Created: 2012-02-27 10:34:34+00:00
State: open

This adds rep to trash in ICC 25 normal and heroic, Also updates reputation gains from heroic ICC bosses

```sql
-- Add rep reward to ICC25 Trash
DELETE FROM `creature_onkill_reputation` WHERE `creature_id` IN (37655,38031,38057,38058,38059,38061,38062,38063,38064,38072,38073,38074,38075,38076,38098,38099,38100,38101,38102,38103,38105,38108,38110,38126,38130,38131,38132,38133,38139,38151,38219,38220,38418,38445,38446,38479,38480,38481);
INSERT INTO `creature_onkill_reputation` (`creature_id`, `RewOnKillRepFaction1`, `RewOnKillRepFaction2`, `MaxStanding1`, `IsTeamAward1`, `RewOnKillRepValue1`, `MaxStanding2`, `IsTeamAward2`, `RewOnKillRepValue2`, `TeamDependent`) VALUES
(37655, 1156, 0, 7, 0, 49, 0, 0, 0, 0), -- Decaying colossus
(38031, 1156, 0, 7, 0, 49, 0, 0, 0, 0), -- Deathbound Ward
(38057, 1156, 0, 7, 0, 15, 0, 0, 0, 0), -- Servant of the throne
(38058, 1156, 0, 7, 0, 15, 0, 0, 0, 0), -- Nerub'ar Broodkeeper
(38059, 1156, 0, 7, 0, 15, 0, 0, 0, 0), -- Ancient Skeletal Soldier
(38061, 1156, 0, 7, 0, 15, 0, 0, 0, 0), -- The Damned
(38062, 1156, 0, 7, 0, 15, 0, 0, 0, 0), -- Plague Scientist
(38063, 1156, 0, 7, 0, 15, 0, 0, 0, 0), -- Vengeful Fleshreaper
(38064, 1156, 0, 7, 0, 150, 0, 0, 0, 0), -- Stinky
(38072, 1156, 0, 7, 0, 15, 0, 0, 0, 0), -- Deathspeacker Attedent
(38073, 1156, 0, 7, 0, 15, 0, 0, 0, 0), -- Deathspeacker Disciple
(38074, 1156, 0, 7, 0, 45, 0, 0, 0, 0), -- Deathspeacker High Preist
(38075, 1156, 0, 7, 0, 15, 0, 0, 0, 0), -- Deathspeacker Servant
(38076, 1156, 0, 7, 0, 15, 0, 0, 0, 0), -- Deathspeacker Zealot
(38098, 1156, 0, 7, 0, 15, 0, 0, 0, 0), -- Darkfallen Advisor
(38099, 1156, 0, 7, 0, 15, 0, 0, 0, 0), -- Darkfallen Archmage
(38100, 1156, 0, 7, 0, 15, 0, 0, 0, 0), -- Darkfallen Blood Knight
(38101, 1156, 0, 7, 0, 15, 0, 0, 0, 0), -- Darkfallen Lieutenant
(38102, 1156, 0, 7, 0, 15, 0, 0, 0, 0), -- Darkfallen Commander
(38103, 1156, 0, 7, 0, 150, 0, 0, 0, 0), -- Precious
(38105, 1156, 0, 7, 0, 2, 0, 0, 0, 0), -- Plagued Zombie
(38108, 1156, 0, 7, 0, 15, 0, 0, 0, 0), -- Blighted Abomination
(38110, 1156, 0, 7, 0, 30, 0, 0, 0, 0), -- Pustulating Horror
(38126, 1156, 0, 7, 0, 15, 0, 0, 0, 0), -- Ymirjar Frostbinder
(38130, 1156, 0, 7, 0, 15, 0, 0, 0, 0), -- Ymirjar Deathbringer
(38131, 1156, 0, 7, 0, 15, 0, 0, 0, 0), -- Ymirjar Huntress
(38132, 1156, 0, 7, 0, 15, 0, 0, 0, 0), -- Ymirjar Battle-Maiden
(38133, 1156, 0, 7, 0, 15, 0, 0, 0, 0), -- Ymirjar Warlord
(38139, 1156, 0, 7, 0, 15, 0, 0, 0, 0), -- Frostwarden Handler
(38151, 1156, 0, 7, 0, 15, 0, 0, 0, 0), -- Frostwing Whelp
(38219, 1156, 0, 7, 0, 150, 0, 0, 0, 0), -- Spinestalker
(38220, 1156, 0, 7, 0, 150, 0, 0, 0, 0), -- Rimefang
(38418, 1156, 0, 7, 0, 49, 0, 0, 0, 0), -- Val'kyr Herald
(38445, 1156, 0, 7, 0, 15, 0, 0, 0, 0), -- Spire Minion
(38446, 1156, 0, 7, 0, 15, 0, 0, 0, 0), -- Frenzied Abomination
(38479, 1156, 0, 7, 0, 15, 0, 0, 0, 0), -- Darkfallen Tactician
(38480, 1156, 0, 7, 0, 15, 0, 0, 0, 0), -- Darkfallen Noble
(38481, 1156, 0, 7, 0, 15, 0, 0, 0, 0); -- Spire Gargoyle

-- update rep for bosses in herioc 10&25
-- Lord Marrowgar, Lady Deathwhisper, Festergut, Rotface, Professor Putricide, Blood-Queen Lana'thel, Sindragosa
UPDATE `creature_onkill_reputation` SET `RewOnKillRepValue1`=500 WHERE `creature_id` IN (37958,37959,38296,38297,37505,37506,38549,38550,38585,38586,38435,38436,38226,38227);
-- Prince Valanar, Prince Keleseth, Prince Taldaram
UPDATE `creature_onkill_reputation` SET `RewOnKillRepValue1`=165 WHERE `creature_id` IN (38784,38785,38769,38770,38771,38772);
```