Query to scale all NPCs back some

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