need sql script.

[Laidev]

i need sql script to change droplist of raidbosses, I mean i want to change all raidbosses weapons/armors etc drop chance :) because config rates configuration don't help, raids droping alot of parts and mostly no weapons/armors ;/

 

p.s i can send if u need 200-300adena for help :D

[Matim]

We need more info about what this sql should update etc.

 

you have to use something like:

 

UPDATE 'column_name' WHERE something = something etc...

[Laidev]

i need script which would drop from npc all raidbosses ID.Script would execute in droplist with raidboss id and would change items drop chance of thies raidbosses :)

 

im talking about increasing chance of droping items of all raidbosses :)

[down]

try this...

UPDATE droplist SET chance = x WHERE itemId = x AND mobId IN (SELECT mobId FROM npc WHERE type = 'L2RaidBoss');

[Laidev]

but when u would have to put item id one by one, it would cost a lot of time ;)

[down]

[EDIT]

try those...

UPDATE droplist SET chance = x WHERE mobId IN (SELECT mobId FROM npc WHERE type = 'L2RaidBoss') and itemId IN (SELECT itemId FROM weapon WHERE item_id);

UPDATE droplist SET chance = x WHERE mobId IN (SELECT mobId FROM npc WHERE type = 'L2RaidBoss') and itemId IN (SELECT itemId FROM armor WHERE item_id);

[Laidev]

when excecute ;/

 

 

[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 itemId FROM armor WHERE itemid)' at line 1

[Err] UPDATE droplist SET chance = 700000 WHERE itemId AND mobId IN (SELECT mobId FROM npc WHERE type = 'L2RaidBoss', SELECT itemId FROM armor WHERE itemid);

[Msg] Finished - Unsuccessfully

[down]

W8.. i gotta find out whats wrong

[Commodus]

Leno , your sql file is corrupted.

 

Try to install it manually.

[down]

UPDATE droplist SET chance = x WHERE itemId = x AND mobId IN (SELECT mobId FROM npc WHERE type = 'L2RaidBoss');

use this..

Just add itemId of the wep u wanna increase his chance, it's very hard