How to add a query for Mob strength

[Maze_EQ]

If anyone could help me, I'd like to make ALL monsters ingame reduced in strength by 75% I am not sure how to do this.

[lerxst2112]

What does "strength" mean? Less hit points? They hit players for less?

[KLS]

I suspect he means the damage they deal, but yeah need clarification.

[Maze_EQ]

What I am looking for is global stats reduction, ac, hp, mana, str, agi etc I was wondering if it could be done in a query, I've searched for hours....can't find nothing like it.

So say you have a kobold warrior

hp:1200
mana:1200
ac:400
Damage=20-50
str:65
agi:65
(etc)

How would you make EVERY mob reduce all this by 75 % ?

hp:300
mana:300
ac:100
damage=5-37
str:17
Agi:17

Basically thats what I'm getting at, and don't know how to word it.

[Maze_EQ]

Sorry for double posting but I seem to have figured it out...

update npc_types set hp = hp - hp*.3

just substitute hp for the required, if this can be deleted or whatnot, thank you.

[werebat]

Actually its just hp = hp*.3 (thats 70% by the way, if you want 75% like you post stated then its hp = hp*.25).

Keep in mind this will also lower the strength of any pets.

[Uleat]

Disregard...

[Uleat]

Hmm...

1 * 1 = 1
1 * 0.7 = 0.7
1 * 0.3 = 0.3

Hmm...


Reduce to 75% of original: hp = hp * .75

Reduce by 75% of original: hp = hp - (hp * 0.75) -or- hp = hp * 0.25

(Always backup your database before playing..with it!)