- 2,308

- 2015

- 276

- Location
- Denmark

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.

18/09/2023

14/01/24

06/03/24

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;
```

Last edited: Mar 28, 2024