Damage Reduction | Pre MoP |

[Blackvision]

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.

Are you using HeidiSQL or Navicat ?

 

[nevior]

Are you using HeidiSQL or Navicat ?

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

 

[Blackvision]

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

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

 

[nevior]

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

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

 

[nevior]

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

So what would be a valid amount for health_mod to use since 2408 clearly doesn't work here lmao.

 

[Blackvision]

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.

Okay, strange xD
Tested it before uploading it to Emucoach

Let me just remove that one again

 

[Blackvision]

main thread updated

 

[juxdu13]

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.

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

 

[Therottenprince]

Is it possible to do this process in-game? (.commands?)

 

[badboy7117]

awesome