View Full Version : Sql Query to change resists
Foins
11-18-2007, 12:29 PM
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
11-18-2007, 01:02 PM
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
11-19-2007, 12:45 PM
many thanks
vBulletin® v3.8.11, Copyright ©2000-2024, vBulletin Solutions Inc.