Sql Query to change resists

[Foins]

Could some SQL GURU please write a query to change all resists for npc's of a given lvl and under.
like change all mobs lvl 50 and under to 50 to each resist for instance

[Derision]

Originally Posted by Foins

Could some SQL GURU please write a query to change all resists for npc's of a given lvl and under.
like change all mobs lvl 50 and under to 50 to each resist for instance

I think this should do what you want:

update npc_types set CR = 50, PR = 50, DR =50 , MR = 50, FR = 50 where level <= 50 ;

Backup your Database before you try it

[Foins]

many thanks