Query to scale all NPCs back some

[epilz]

Looking for anyone that has a server that has scaled back mobs difficulty back like 25% or etc. Can this be done with a query? Thanks again!

[demonstar55]

The thing is, that's an extremely complex question and not well defined. 25% less HP? 25% less damage? 25% less intense spells?

[epilz]

Hit points and spells

[epilz]

Sorry I am in the learning phase of this, the community has helped me tons so far.

[dagulus2]

This is basically what I do on my server, but I use a lot more than one query.

Personally replace the information in the depreciated npcspecialattks field with a Template Name. And then run a Query tailored for that type of mob.

A more simpler way would be to base your query on mob_type, as Krugus did at http://www.eqemulator.org/forums/showthread.php?t=28966

[Kayen]

UPDATE npc_types SET HP = HP * 0.75;
UPDATE npc_types SET spellscale = 75;
UPDATE npc_types SET healscale = 75;

That will do exactly what you want. Alter ALL NPC's in database by 25 pct for HP and spells damage / healing.

[epilz]

Thanks for the info. Will try it out today after my db backup

[woton]

Question about spellscale. We have a server pack that includes the dev tools that brings up an npc window with stats. Does the spellscale modify dragon aoe as well? Just checking before I mess something up.

[Mistmaker]

If you use this one you will avoid reducing all the pets. Unless you want them reduced too then run the scaling on all NPC's

UPDATE npc_types SET HP = HP*0.75 WHERE ID > 999;