Reduce elite mobs hp

[DontCareQQ]

Hello,

I set up one server for me and my girl friend - but we want to raid elite monsters with 2 person, is there one way to update ALL elite mobs to have 75% less hp and 75% less damage at once? or is this impossible?

[Ziddy1337]

You can do it manually by updating the figures in the database.

[Sounddead]

I don't think you can anymore (They took those options out of the configs), altough you could do it through your DB. It would just take a while.

[DontCareQQ]

Yeah, over 500 monsters update by hand? aint there a quicker way like a query that selects elite mobs and reduces their hp or something? because doing it 1by1 takes like, weeks..

[Gastricpenguin]

UPDATE creature_proto SET minhealth='MINHP', maxhealth='MAXHP' WHERE rank IN (`creature_names`='1');

You may have to edit and or fix this, as I wrote it off the top of my head.

[DontCareQQ]

UPDATE creature_proto SET minhealth='MINHP', maxhealth='MAXHP' WHERE rank IN (`creature_names`='1');

You may have to edit and or fix this, as I wrote it off the top of my head.

the problem there would be that mobs both lvl 10 and 80 would have the same hp

[Gastricpenguin]

Asking a bit much. I think that's just too many conditions for an SQL query to handle.

[DontCareQQ]

Aaah ok thank you.

[waymirec]

You could do something like the following (based on the NCDB format):

UPDATE `creature_template` AS ct,creature_root AS cr SET `minhealth`=`minhealth` * .25, `maxhealth`=`maxhealth` * .25 WHERE ct.creature_entry=cr.creature_entry AND cr.rank > 0

[DontCareQQ]

You could do something like the following (based on the NCDB format):

UPDATE `creature_template` AS ct,creature_root AS cr SET `minhealth`=`minhealth` * .25, `maxhealth`=`maxhealth` * .25 WHERE ct.creature_entry=cr.creature_entry AND cr.rank > 0

mm that didnt work, i use ncdb 47 and navicat

[latruwski]

here ya go:

75% less Health

Update creature_proto SET minhealth=(minhealth * 0.25) where entry in (select entry from creature_names where rank ='1');
Update creature_proto SET maxhealth=(maxhealth * 0.25) where entry in (select entry from creature_names where rank ='1');

that is for elite only...

for rare elite:

Update creature_proto SET minhealth=(minhealth * 0.25) where entry in (select entry from creature_names where rank ='2');
Update creature_proto SET maxhealth=(maxhealth * 0.25) where entry in (select entry from creature_names where rank ='2');

for world bosses:

Update creature_proto SET minhealth=(minhealth * 0.25) where entry in (select entry from creature_names where rank ='3');
Update creature_proto SET maxhealth=(maxhealth * 0.25) where entry in (select entry from creature_names where rank ='3');

for rare mobs:

Update creature_proto SET minhealth=(minhealth * 0.25) where entry in (select entry from creature_names where rank ='4');
Update creature_proto SET maxhealth=(maxhealth * 0.25) where entry in (select entry from creature_names where rank ='4');

75% less Damage (melee)
For elites only:

Update creature_proto SET mindamage=(mindamage * 0.25) where entry in (select entry from creature_names where rank ='1');
Update creature_proto SET maxdamage=(maxdamage * 0.25) where entry in (select entry from creature_names where rank ='1');

For rare elites:

Update creature_proto SET mindamage=(mindamage * 0.25) where entry in (select entry from creature_names where rank ='2');
Update creature_proto SET maxdamage=(maxdamage * 0.25) where entry in (select entry from creature_names where rank ='2');

For World bosses:

Update creature_proto SET mindamage=(mindamage * 0.25) where entry in (select entry from creature_names where rank ='3');
Update creature_proto SET maxdamage=(maxdamage * 0.25) where entry in (select entry from creature_names where rank ='3');

For rare mobs:

Update creature_proto SET mindamage=(mindamage * 0.25) where entry in (select entry from creature_names where rank ='4');
Update creature_proto SET maxdamage=(maxdamage * 0.25) where entry in (select entry from creature_names where rank ='4');

spells
Spells cant be done in DB... you can only delete spells from the boss in the creature_proto table...

grtz

[waymirec]

mm that didnt work, i use ncdb 47 and navicat

The code I posted above is using the generic NCDB format based off their wiki. You would need to alter it to reflect any changes in your table or field names but other than that it is the easiest way to do what you want in a single query.

[DontCareQQ]

woooo thanks alot for that latru!!!!

[latruwski]

woooo thanks alot for that latru!!!!

no problem, that is what i'm here for ^^