[help pls] about raids

[duckforsex]

can someone tell me how can i modify stats to raids. i can go from raid to raid and modify them but isn't there an easy way to do that, like modify them all at once lower theyre stats by x% from DB ??

[takhs7]

u mean lower their hp mp p.attack etc?? no as i know there is not a way.. only 1 by 1.. but there is a way to put same hp mp etc to all raid.. but then all raid will be same :/ so its gonna mess them up...

[Izzy]

hpregen is a standard setting for all raids.. can lower that :)

 

else.. copy fields from DB into excel and make a new setting. then select the colum at the top and move your cursor the right lower corner of that colum. click and drag downwards and all in the line of (for example pdef) will be set the same =]

 

how to select all bosses?

navicat > npc table > filter > mobtype > l2boss

[cs1984]

Well i suppose that the problem is the damege they do cause for they defence there is setting in config. So tell me want to reduce: patk/matk/speed? of all raid bosses or only specific lvl raids?

[duckforsex]

all of them

[cs1984]

Example for half stats: copy this to notepad and save it. Open database and choose import and Browse file.

UPDATE `l2jdb`.`npc` SET patk=(patk/2) WHERE type='L2RaidBoss';
UPDATE `l2jdb`.`npc` SET matk=(matk/2) WHERE type='L2RaidBoss';
UPDATE `l2jdb`.`npc` SET runspd=(runsps/2) WHERE type='L2RaidBoss';

[takhs7]

nice cs1984 ;) seems u know sql system well...