mob_damage_multipliers

-- 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.6UPDATE creature_template AS a1JOIN creature_template AS a2 ON a1.entry=a2.heroic_entryJOIN creature AS a3 ON a3.id=a2.entrySET a1.dmg_multiplier = 4.6WHERE 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.5UPDATE creature_template AS ctINNER JOIN creature AS c ON ct.entry = c.idSET 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 != 3AND ct.unit_class != 0;-- Old world elites levels 1-24UPDATE creature_template AS ctINNER JOIN creature AS c ON ct.entry = c.idSET ct.dmg_multiplier = 1.7 WHERE ct.entry = c.id AND c.map IN (0, 1)AND ct.maxlevel < 25AND ct.rank IN (1, 2)AND ct.unit_class != 0;-- Old world elited level 25-60UPDATE creature_template AS ctINNER JOIN creature AS c ON ct.entry = c.idSET ct.dmg_multiplier = 2.4 WHERE ct.entry = c.id AND c.map IN (0, 1)AND ct.minlevel > 25AND ct.maxlevel < 60AND ct.rank IN (1, 2)AND ct.unit_class != 0;-- Global adjust for Outdoor elites over level 60UPDATE creature_template AS ctINNER JOIN creature AS c ON ct.entry = c.idSET ct.dmg_multiplier = 3.5 WHERE ct.entry = c.id AND c.map IN (0, 1, 571, 530)AND ct.minlevel > 60AND 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.7UPDATE creature_template AS ctINNER JOIN creature AS c ON ct.entry = c.idSET 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,4UPDATE creature_template AS ctINNER JOIN creature AS c ON ct.entry = c.idSET ct.dmg_multiplier = 2.4WHERE 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 ctINNER JOIN creature AS c ON ct.entry = c.idSET ct.dmg_multiplier = 3.5WHERE 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 a1JOIN creature_template AS a2 ON a1.entry=a2.heroic_entryJOIN creature AS a3 ON a3.id=a2.entrySET a1.dmg_multiplier = 7.8WHERE 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 ctINNER JOIN creature AS c ON ct.entry = c.idSET 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 != 3AND 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 a1JOIN creature_template AS a2 ON a1.entry=a2.heroic_entryJOIN creature AS a3 ON a3.id=a2.entrySET a1.dmg_multiplier = 23WHERE a3.map IN (533, 615, 616, 624, 603)AND a1.rank = 3;UPDATE creature_template AS ctINNER JOIN creature AS c ON ct.entry = c.idSET ct.dmg_multiplier = 13 WHERE ct.entry = c.id AND c.map IN (533, 615, 616, 624, 603)AND ct.rank = 3AND 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;