Damage Reduction | Pre MoP |

Blackvision · Feb 27, 2023

This SQL will reduce wrong scaled damage | Pre MoP |

I'll keep updating the thread.
The thread will be cleared whenever a new version release.

Run this in your World database.

SQL:

DEADMINES

UPDATE creature_template set mindmg = 47.5, maxdmg = 62.7, attackpower = 114, dmg_multiplier = 1.7 WHERE entry = 647;

LOST CITY OF TOL'VIR

UPDATE creature_template set mindmg = 530, maxdmg = 713, attackpower = 827, dmg_multiplier = 7.5 WHERE entry = 44977;
UPDATE creature_template set mindmg = 1007, maxdmg = 1354.7, attackpower = 1571, dmg_multiplier = 7.5 WHERE entry = 44922;
UPDATE creature_template set mindmg = 1007, maxdmg = 1354.7, attackpower = 1571, dmg_multiplier = 7.5 WHERE entry = 44924;
UPDATE creature_template set mindmg = 530, maxdmg = 713, attackpower = 827, dmg_multiplier = 7.5 WHERE entry = 44926;
UPDATE creature_template set mindmg = 1007, maxdmg = 1354.7, attackpower = 1571, dmg_multiplier = 7.5 WHERE entry = 44981;
UPDATE creature_template set mindmg = 1007, maxdmg = 1354.7, attackpower = 1571, dmg_multiplier = 7.5 WHERE entry = 51759;
UPDATE creature_template set mindmg = 530, maxdmg = 713, attackpower = 827, dmg_multiplier = 1 WHERE entry = 45096;
UPDATE creature_template set mindmg = 530, maxdmg = 713, attackpower = 827, dmg_multiplier = 7.5 WHERE entry = 44898;
UPDATE creature_template set mindmg = 530, maxdmg = 713, attackpower = 827, dmg_multiplier = 7.5 WHERE entry = 44896;
UPDATE creature_template set mindmg = 530, maxdmg = 713, attackpower = 827, dmg_multiplier = 7.5 WHERE entry = 44897;
UPDATE creature_template set mindmg = 509, maxdmg = 683, attackpower = 805, dmg_multiplier = 1 WHERE entry = 48041;
UPDATE creature_template set mindmg = 530, maxdmg = 713, attackpower = 827, dmg_multiplier = 1 WHERE entry = 44234;

STORMWIND STOCKADES

UPDATE creature_template set mindmg = 34, maxdmg = 46, attackpower = 84, dmg_multiplier = 2.5 WHERE entry = 46379;

18/09/2023

SQL:

Durotar

UPDATE creature_template set mindmg = 11, maxdmg = 15, attackpower = 40, dmg_multiplier = 1 WHERE entry = 55808;

Deadmines

UPDATE creature_template set mindmg = 22, maxdmg = 29, attackpower = 54, dmg_multiplier = 1.7 WHERE entry = 48230;
UPDATE creature_template set mindmg = 22, maxdmg = 29, attackpower = 54, dmg_multiplier = 1.7 WHERE entry = 48262;
UPDATE creature_template set mindmg = 20, maxdmg = 27, attackpower = 48, dmg_multiplier = 1.7 WHERE entry = 48445;
UPDATE creature_template set mindmg = 37, maxdmg = 57, attackpower = 14, dmg_multiplier = 10 WHERE entry = 42655;

Elwynn Forest

UPDATE creature_template set mindmg = 7, maxdmg = 9, attackpower = 34, dmg_multiplier = 1 WHERE entry = 30;
UPDATE creature_template set mindmg = 13, maxdmg = 17, attackpower = 42, dmg_multiplier = 1 WHERE entry = 99;

Westfall

UPDATE creature_template set mindmg = 37, maxdmg = 49, attackpower = 90, dmg_multiplier = 1 WHERE entry = 462;

Stockades

UPDATE creature_template set mindmg = 33, maxdmg = 44, attackpower = 80, dmg_multiplier = 1 WHERE entry = 46382;

Duskwood

UPDATE creature_template set mindmg = 29, maxdmg = 39, attackpower = 70, dmg_multiplier = 1 WHERE entry = 45739;

Stranglethorn

UPDATE creature_template set mindmg = 92, maxdmg = 157, attackpower = 11, dmg_multiplier = 1 WHERE entry = 51663;
UPDATE creature_template set mindmg = 92, maxdmg = 157, attackpower = 11, dmg_multiplier = 1 WHERE entry = 51661;
UPDATE creature_template set mindmg = 29, maxdmg = 39, attackpower = 70, dmg_multiplier = 1 WHERE entry = 51662;

14/01/24

SQL:

Shadowfang Keep

UPDATE creature_template set mindmg = 29, maxdmg = 39, attackpower = 70, dmg_multiplier = 1.7 WHERE entry = 47137;
UPDATE creature_template set mindmg = 27, maxdmg = 37, attackpower = 68, dmg_multiplier = 1.7 WHERE entry = 47143;
UPDATE creature_template set mindmg = 29, maxdmg = 39, attackpower = 70, dmg_multiplier = 1.7 WHERE entry = 3875;

Stratholme
UPDATE creature_template set mindmg = 100, maxdmg = 132, attackpower = 242, dmg_multiplier = 3.5 WHERE entry = 10405;
UPDATE creature_template set mindmg = 2, maxdmg = 2, attackpower = 24, dmg_multiplier = 7.5 WHERE entry = 42975;

Lost City of the Tol'vir
UPDATE creature_template set mindmg = 10000, maxdmg = 20000, attackpower = 105000, dmg_multiplier = 1 WHERE entry = 44577;
UPDATE creature_template set mindmg = 10000, maxdmg = 20000, attackpower = 105000, dmg_multiplier = 1 WHERE entry = 43614;


Utgarde Keep
UPDATE creature_template set mindmg = 307, maxdmg = 438, attackpower = 314, dmg_multiplier = 7.5 WHERE entry = 23954;

Blackrock Caverns
UPDATE creature_template set mindmg = 1035.5, maxdmg = 1373.7, attackpower = 1500, dmg_multiplier = 18 WHERE entry = 39985;
UPDATE creature_template set mindmg = 1019, maxdmg = 1411, attackpower = 2400, dmg_multiplier = 5.9 WHERE entry = 39990;
UPDATE creature_template set mindmg = 865, maxdmg = 3600, attackpower = 2000, dmg_multiplier = 14 WHERE entry = 39665;
UPDATE creature_template set mindmg = 1650, maxdmg = 1856, attackpower = 8000, dmg_multiplier = 15 WHERE entry = 39679;

The Deadmines
UPDATE creature_template set mindmg = 47.5, maxdmg = 62.7, attackpower = 114, dmg_multiplier = 1.7 WHERE entry = 647;
UPDATE creature_template set mindmg = 488, maxdmg = 642, attackpower = 782, dmg_multiplier = 7.5 WHERE entry = 44879;
UPDATE creature_template set mindmg = 43.7, maxdmg = 58.9, attackpower = 106, dmg_multiplier = 1.7 WHERE entry = 47296;
UPDATE creature_template set mindmg = 600, maxdmg = 760, attackpower = 1000, dmg_multiplier = 15 WHERE entry = 49674;

Stockades
UPDATE creature_template set mindmg = 33, maxdmg = 44, attackpower = 80, dmg_multiplier = 1 WHERE entry = 46382;

Uldaman
UPDATE creature_template set mindmg = 51, maxdmg = 68, attackpower = 124, dmg_multiplier = 7.5 WHERE entry = 24830;

06/03/24

SQL:

The Lost Isles
UPDATE creature_template set mindmg = 41, maxdmg = 41, attackpower = 103, dmg_multiplier = 7.5 WHERE entry = 39039;

Blackrock Spire
UPDATE creature_template set mindmg = 98, maxdmg = 130, attackpower = 238, dmg_multiplier = 3.5 WHERE entry = 9219;
UPDATE creature_template set mindmg = 100, maxdmg = 132, attackpower = 242, dmg_multiplier = 3.5 WHERE entry = 9218;

Blasted Lands
UPDATE creature_template set mindmg = 104, maxdmg = 138, attackpower = 252, dmg_multiplier = 4.6 WHERE entry = 7846;

Shadowfang Keep
UPDATE creature_template set mindmg = 20, maxdmg = 28, attackpower = 28, dmg_multiplier = 1.7 WHERE entry = 47231;

Stormwind Stockade
UPDATE creature_template set mindmg = 33, maxdmg = 44, attackpower = 80, dmg_multiplier = 1 WHERE entry = 46382;

The Temple of Atal'Hakkar ( The Sunken Temple )
UPDATE creature_template set mindmg = 65, maxdmg = 91, attackpower = 99, dmg_multiplier = 2.4 WHERE entry = 5273;
UPDATE creature_template set mindmg = 86, maxdmg = 114, attackpower = 210, dmg_multiplier = 2.4 WHERE entry = 5271;
UPDATE creature_template set mindmg = 89, maxdmg = 119, attackpower = 218, dmg_multiplier = 2.4 WHERE entry = 5270;

UPDATE creature_template set mindmg = 530, maxdmg = 713, attackpower = 827, dmg_multiplier = 15 WHERE entry = 48011;

Blackrock Caverns
UPDATE creature_template set mindmg = 865, maxdmg = 3600, attackpower = 1600, dmg_multiplier = 7 WHERE entry = 39665;
UPDATE creature_template set mindmg = 1650, maxdmg = 1856, attackpower = 8000, dmg_multiplier = 15 WHERE entry = 39665;
UPDATE creature_template set mindmg = 1111.5, maxdmg = 1430.7, attackpower = 1200, dmg_multiplier = 16 WHERE entry = 39698;
UPDATE creature_template set mindmg = 650, maxdmg = 856, attackpower = 2000, dmg_multiplier = 15 WHERE entry = 39700;
UPDATE creature_template set mindmg =1250, maxdmg = 1625, attackpower = 64250, dmg_multiplier = 20 WHERE entry = 39705;

Audioplayonline · Feb 28, 2023

I get errors trying to execute this in the database, it's asking for a WHERE claus or something. https://prnt.sc/HScQwUkciY8j
When ignoring that and continue'ing it gives the following error: https://prnt.sc/uecevFgqF17U

any idea?

Hoizmichl · Feb 28, 2023

i have the same error as @Audioplayonline

anaconda7117 · Feb 28, 2023

I tested this also. Getting same errors as well

Blackvision · Feb 28, 2023

Change update to replace into.
My mistake

Audioplayonline · Feb 28, 2023

Blackvision said:
Change update to replace into.
My mistake

Thank you Blackvision!

Blackvision · Feb 28, 2023

Audioplayonline said:
Thank you Blackvision!

Did it work?

Audioplayonline · Feb 28, 2023

Blackvision said:
Did it work?

Yes it did.

anaconda7117 · Feb 28, 2023

This for Mop V4? Now shows column count does not match value count

Blackvision · Feb 28, 2023

anaconda7117 said:
This for Mop V4? Now shows column count does not match value count

Yes, this is for V4

Blackvision · Mar 22, 2023

Main thread updated !

Blackvision · Apr 11, 2023

Main thread updated

DeathWhisper · Apr 11, 2023

ore and how to enter it into the database????

leetdemon · Apr 14, 2023

Thanks for keeping this updated!

Blackvision · Sep 18, 2023

Main thread updated

vextor · Oct 31, 2023

sweet, thanks!

tux38260 · Nov 2, 2023

Thank you

jzundai · Dec 4, 2023

DANKE

Blackvision · Jan 14, 2024

Thread has been updated

nevior · Jan 16, 2024

As someone not as knowledgeable about MySQL, how would I go about doing this? Feels kind of weird that I'm paying for this while still needing to fix it myself.