Quote:
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