What's new

Damage Reduction | Pre MoP |

Blackvision

Mythical User
Super Moderator
Gold Supporter
2,308
2015
276
Location
Denmark
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
213123.png
 

nevior

MoP Premium
Verified Member
19
2023
18
Location
US
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

MoP Premium
Verified Member
19
2023
18
Location
US
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.
 

Blackvision

Mythical User
Super Moderator
Gold Supporter
2,308
2015
276
Location
Denmark
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
 

juxdu13

MoP Premium
Verified Member
16
2024
0
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
 
Last edited:
Top