-- This is damage multiplier adjusting formula for elite mobs across the realm
-- Written by SeizerKiller, edited by Invisible to fit Bloodcraft

-- Heroic TBC instances
-- (558 AC ,557,556,555,552,553,554,540,542,543,585,545,546,547,548,560,269) Heroic lowered from 5.9 to 4.6
UPDATE creature_template AS a1
JOIN creature_template AS a2 ON a1.entry=a2.heroic_entry
JOIN creature AS a3 ON a3.id=a2.entry
SET a1.dmg_multiplier = 4.6
WHERE a3.map IN (558,557,556,555,552,553,554,540,542,543,585,545,546,547,548,560,269)
AND a1.rank != '3';

-- Normal TBC instances
-- Normal lowered from 4.6 to 3.5
UPDATE creature_template AS ct
INNER JOIN creature AS c 
ON ct.entry = c.id
SET ct.dmg_multiplier = 3.5 
WHERE ct.entry = c.id 
AND c.map IN (558,557,556,555,552,553,554,540,542,543,585,545,546,547,548,560,269)
AND ct.rank != 3
AND ct.unit_class != 0;

-- Old world elites levels 1-24
UPDATE creature_template AS ct
INNER JOIN creature AS c 
ON ct.entry = c.id
SET ct.dmg_multiplier = 1.7 
WHERE ct.entry = c.id 
AND c.map IN (0, 1)
AND ct.maxlevel < 25
AND ct.rank IN (1, 2)
AND ct.unit_class != 0;

-- Old world elited level 25-60
UPDATE creature_template AS ct
INNER JOIN creature AS c 
ON ct.entry = c.id
SET ct.dmg_multiplier = 2.4 
WHERE ct.entry = c.id 
AND c.map IN (0, 1)
AND ct.minlevel > 25
AND ct.maxlevel < 60
AND ct.rank IN (1, 2)
AND ct.unit_class != 0;

-- Global adjust for Outdoor elites over level 60
UPDATE creature_template AS ct
INNER JOIN creature AS c 
ON ct.entry = c.id
SET ct.dmg_multiplier = 3.5 
WHERE ct.entry = c.id 
AND c.map IN (0, 1, 571, 530)
AND ct.minlevel > 60
AND ct.rank IN (1, 2)
AND ct.unit_class != 0;

-- (33 SFK, 34 Stockades, 36 Deadmines, 43 WC, 47 RFK, 48 BFD, 90 Gnome, 129 RFD, 389 RFC) 1.7
UPDATE creature_template AS ct
INNER JOIN creature AS c 
ON ct.entry = c.id
SET ct.dmg_multiplier = 1.7 
WHERE ct.entry = c.id 
AND c.map IN (33, 34, 36, 43, 47, 48, 90, 129, 389)
AND ct.unit_class != 0;

-- (70 Ulda, 209 ZF, 349 Mara, 109 ST, 189 SM) 2,4
UPDATE creature_template AS ct
INNER JOIN creature AS c 
ON ct.entry = c.id
SET ct.dmg_multiplier = 2.4
WHERE ct.entry = c.id 
AND c.map IN (70, 209, 349, 109, 189)
AND ct.unit_class != 0;

-- (BRD BRS DM STRAT SCHOLO)
UPDATE creature_template AS ct
INNER JOIN creature AS c 
ON ct.entry = c.id
SET ct.dmg_multiplier = 3.5
WHERE ct.entry = c.id 
AND c.map IN (229, 230, 289, 329, 429)
AND ct.unit_class != 0;

-- FROM HERE IT"S INVISIBLE's WORK based on SK's template
-- Live DB values 7.5 normal, heroic 13
-- reducing by 50% normal and 40% heroic. New values 3.7 normal, 7,8 heroic 

-- WRATH HEROIC (UK 574 , Nex 576, DTK 600, AZJOL 601, OLDK 619, GUNDRAK 604,
-- HOL 602, HOS 599, COS 595, VH 608, UP 575, Ocu 578)
UPDATE creature_template AS a1
JOIN creature_template AS a2 ON a1.entry=a2.heroic_entry
JOIN creature AS a3 ON a3.id=a2.entry
SET a1.dmg_multiplier = 7.8
WHERE a3.map IN (574, 576, 600, 601, 619, 604, 602, 599, 595, 608, 575, 578)
AND a1.rank != '3';

-- WRATH Normal (UK 574 , Nex 576, DTK 600, AZJOL 601, OLDK 619, GUNDRAK 604,
-- HOL 602, HOS 599, COS 595, VH 608, UP 575, Ocu 578)
UPDATE creature_template AS ct
INNER JOIN creature AS c 
ON ct.entry = c.id
SET ct.dmg_multiplier = 3.7 
WHERE ct.entry = c.id 
AND c.map IN (574, 576, 600, 601, 619, 604, 602, 599, 595, 608, 575, 578)
AND ct.rank != 3
AND ct.unit_class != 0;

-- WOTLK Raids
-- Naxx 533 , OS 615, The Eye 616, VoA 624, Ulduar 603
-- lowering the multiplier on bosses from 35 to 13 (normal)
-- lowering multiplier on bosses from 70 to 23 (heroic)

UPDATE creature_template AS a1
JOIN creature_template AS a2 ON a1.entry=a2.heroic_entry
JOIN creature AS a3 ON a3.id=a2.entry
SET a1.dmg_multiplier = 23
WHERE a3.map IN (533, 615, 616, 624, 603)
AND a1.rank = 3;

UPDATE creature_template AS ct
INNER JOIN creature AS c 
ON ct.entry = c.id
SET ct.dmg_multiplier = 13 
WHERE ct.entry = c.id 
AND c.map IN (533, 615, 616, 624, 603)
AND ct.rank = 3
AND ct.unit_class != 0;

-- This sets dmg_multipliers for NONELITES to 1 (those in instances too)
UPDATE creature_template SET dmg_multiplier = 1 WHERE rank=0 AND dmg_multiplier>0;