- 2,325
- 2015
- 281
- 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.
10/09/25
16/09/25
I'll keep updating the thread.
The thread will be cleared whenever a new version release.
Run this in your World database.
10/09/25
SQL:
Shadowfang Keep
UPDATE creature_template set mindmg = 28, maxdmg = 38, attackpower = 68, dmg_multiplier = 1.7 WHERE entry = 4278;
UPDATE creature_template set mindmg = 27, maxdmg = 37, attackpower = 68, dmg_multiplier = 1.7 WHERE entry = 47135;
UPDATE creature_template set mindmg = 29, maxdmg = 39, attackpower = 70, dmg_multiplier = 1.7 WHERE entry = 3870;
UPDATE creature_template set mindmg = 29, maxdmg = 39, attackpower = 70, dmg_multiplier = 1.7 WHERE entry = 47136;
UPDATE creature_template set mindmg = 29, maxdmg = 39, attackpower = 70, dmg_multiplier = 1.7 WHERE entry = 47146;
UPDATE creature_template set mindmg = 29, maxdmg = 39, attackpower = 70, dmg_multiplier = 1.7 WHERE entry = 47138;
Uldaman
UPDATE creature_template set mindmg = 48, maxdmg = 63, attackpower = 116, dmg_multiplier = 2.4 WHERE entry = 4852;
UPDATE creature_template set mindmg = 51, maxdmg = 68, attackpower = 124, dmg_multiplier = 7.5 WHERE entry = 24830;
UPDATE creature_template set mindmg = 51, maxdmg = 67, attackpower = 124, dmg_multiplier = 2.4 WHERE entry = 7030;
UPDATE creature_template set mindmg = 54, maxdmg = 72, attackpower = 132, dmg_multiplier = 2.4 WHERE entry = 4849;
UPDATE creature_template set mindmg = 54, maxdmg = 72, attackpower = 132, dmg_multiplier = 2.4 WHERE entry = 4855;
UPDATE creature_template set mindmg = 54, maxdmg = 72, attackpower = 132, dmg_multiplier = 2.4 WHERE entry = 7320;
UPDATE creature_template set mindmg = 38, maxdmg = 54, attackpower = 58, dmg_multiplier = 2.4 WHERE entry = 7321;
Scholomance
UPDATE creature_template set mindmg = 62, maxdmg = 82, attackpower = 152, dmg_multiplier = 3.5 WHERE entry = 58633;
Redridge Mountains
UPDATE creature_template set mindmg = 5, maxdmg = 6, attackpower = 24, dmg_multiplier = 4.5 WHERE entry = 43363;
SQL:
Firelands 10N
UPDATE creature_template set mindmg = 4328, maxdmg = 7359, attackpower = 36, dmg_multiplier = 1 WHERE entry = 52447;
UPDATE creature_template set mindmg = 4328, maxdmg = 7359, attackpower = 141, dmg_multiplier = 1.7 WHERE entry = 53631;
UPDATE creature_template set mindmg = 4328, maxdmg = 7359, attackpower = 36, dmg_multiplier = 1.7 WHERE entry = 53765;
UPDATE creature_template set mindmg = 4328, maxdmg = 7359, attackpower = 187, dmg_multiplier = 2 WHERE entry = 53206;
UPDATE creature_template set mindmg = 4328, maxdmg = 7359, attackpower = 187, dmg_multiplier = 2 WHERE entry = 54991;
UPDATE creature_template set mindmg = 9001, maxdmg = 15302, attackpower = 154, dmg_multiplier = 7.5 WHERE entry = 52498;
End Time
UPDATE creature_template set mindmg = 7052, maxdmg = 11989, attackpower = 150, dmg_multiplier = 45 WHERE entry = 54431;
Lost city of Tol Vir
UPDATE creature_template set mindmg = 7052, maxdmg = 11989, attackpower = 150, dmg_multiplier = 7.5 WHERE entry = 45377;
UPDATE creature_template set mindmg = 4328, maxdmg = 7359, attackpower = 1571, dmg_multiplier = 7 WHERE entry = 44924;
UPDATE creature_template set mindmg = 7052, maxdmg = 11989, attackpower = 992, dmg_multiplier = 18 WHERE entry = 43614;
Throne of the Four Winds
UPDATE creature_template set mindmg = 9001, maxdmg = 15302, attackpower = 191, dmg_multiplier = 7.5 WHERE entry = 45871;
UPDATE creature_template set mindmg = 9001, maxdmg = 15302, attackpower = 191, dmg_multiplier = 7.5 WHERE entry = 45870;
Grim Batol
UPDATE creature_template set mindmg = 7052, maxdmg = 11989, attackpower = 150, dmg_multiplier = 7.5 WHERE entry = 39625;
Last edited: