[News] Mists of Pandaria Premium Repack 6.1 is out!
What's new

Damage Reduction | Pre MoP |

nevior said:
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.
Click to expand...
Are you using HeidiSQL or Navicat ? :)
 
nevior said:
HeidiSQL is usually my go to, but I'm not versed in SQL really at all. I follow tutorial guides and that's about it. lmao
Click to expand...
Okay.
Mark the world DB, then click on Query, and then just copy everything from the main thread to the empty field just below "Query", after that, just execute it from the "play" icon.

You might want to delete dungeon names
213123.png
 
Blackvision said:
Okay.
Mark the world DB, then click on Query, and then just copy everything from the main thread to the empty field just below "Query", after that, just execute it from the "play" icon.

You might want to delete dungeon names
View attachment 3295
Click to expand...

Thanks, seems to have worked, or at the very least it states that those rows were altered with zero errors or warnings.
 
Quick update -

I haven't tested things much, but a quick run through the Deadmines on a level 17 character and the Oaf Lackeys that used to have like 1hp now have dumb max level health.

You tried fixing them here "UPDATE creature_template set Health_mod = 2408, minlevel = 18, maxlevel = 18 WHERE entry = 48445;" but that just caused them to have this --->
Screenshot 2024-01-19 143921.png


So what would be a valid amount for health_mod to use since 2408 clearly doesn't work here lmao.
 
nevior said:
Quick update -

I haven't tested things much, but a quick run through the Deadmines on a level 17 character and the Oaf Lackeys that used to have like 1hp now have dumb max level health.

You tried fixing them here "UPDATE creature_template set Health_mod = 2408, minlevel = 18, maxlevel = 18 WHERE entry = 48445;" but that just caused them to have this --->View attachment 3296

So what would be a valid amount for health_mod to use since 2408 clearly doesn't work here lmao.
Click to expand...
Okay, strange xD
Tested it before uploading it to Emucoach :)

Let me just remove that one again
 
nevior said:
Quick update -

I haven't tested things much, but a quick run through the Deadmines on a level 17 character and the Oaf Lackeys that used to have like 1hp now have dumb max level health.

You tried fixing them here "UPDATE creature_template set Health_mod = 2408, minlevel = 18, maxlevel = 18 WHERE entry = 48445;" but that just caused them to have this --->View attachment 3296

So what would be a valid amount for health_mod to use since 2408 clearly doesn't work here lmao.
Click to expand...
the only solution !

UPDATE `mop_world`.`creature_template` SET `minlevel` = '18', `maxlevel` = '18' WHERE (`entry` = '48445');
UPDATE `creature_template` SET `Health_mod` = 6.389 WHERE `entry` = 48445;


a+ Jeankévin
 
Last edited:
You must log in or register to reply here.
Back
Top