[Help]SQL To edit all raid boss drop? [Request]

[Stewie]

As a title say i need to edit all raidboss drop by 1 SQL file, is it possible?

Or if not is there any easy way to do it?

[Stewie]

insert into droplist (mobId, itemid, chance, min, max,category) select id, 4037, 1000000, 1, 1, 52 from npc where type='L2RaidBoss';

 

This will work? :D

[vampir]

hmm i think u will need to make program for that. First select all ids of raid bosses and add them to list

after that

for(int id : raidIds(the list))

insert into droplist (mobId, itemid, chance, min, max,category) values (id, 4037, 1000000, 1, 1, 52);

[Tryskell]

Possible to do only with a mySQL query. L2J itself uses sometimes linked queries.