Query: Adding an item to every RB

[ketchupyx]

Hi, i would like to add an item in drop from every raid bosses, i tried that query which i'm sure is stupid and completly wrong...

 

 

INSERT INTO droplist VALUES (id, '57', '1', '1', '0', '2000')

SELECT id FROM npc WHERE type = 'L2RaidBoss'

 

and i have the error:

 

 INSERT INTO droplist VALUES (mobId, '57', '1', '2', '0', '2000')

SELECT id FROM npc WHERE type = 'L2RaidBoss'

 

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT id FROM npc WHERE type = 'L2RaidBoss'' at line 2[/i]

 

can someone help me with that query? Thanks alot.(the item is 1 adena used for example purpose)

[ketchupyx]

up :/

[ment2008]

In game > Shift+RB > Drop >Add Item > ID\min\max\1\1000000.

and u add it drop

[ketchupyx]

please someone tell him that if i ask that it's to add 360 drops (rb) with one query and not one by one -_-