[HELP] SQL script

[Street]

Hi, i need SQL script for add item for all RB.And only to RB 61+

sorry for my english :/

[ServeSATAN]

you can't do that because you must use INSERT comand and this command can't indicate only rbs. you can just replace with adena.

[Street]

Raidboss dont drop Adena..

[ServeSATAN]

Raidboss dont drop Adena..

i just tell you example...

for example all 61+ raidboss have item 9999 in droplist you can use this command

 

UPDATE droplist SET itemId=(youitemid) WHERE itemId=9999 AND mobId IN (SELECT id FROM npc WHERE level >= 61 AND type='L2Raidboss');

[adenaman]

you can't do that because you must use INSERT comand and this command can't indicate only rbs. you can just replace with adena.

 

the rb have the same title "Raid Boss"

[ServeSATAN]

the rb have the same title "Raid Boss"

and what? if you use

INSERT INTO droplist VALUES

you can't indicate only rbs

[Street]

mysql> ;UPDATE droplist SET itemId=(5575) WHERE itemId=9999 AND mobId IN (SELECT id FROM npc WHERE level >= 61 AND type='L2Raidboss');

1065 - Query was empty

Query OK, 0 rows affected

Rows matched: 0  Changed: 0  Warnings: 0

 

0 rows affected :/

[adenaman]

and what? if you use

INSERT INTO droplist VALUES

you can't indicate only rbs

thats true

 

wasnt there some way to copy the table to a file, so you could edit the file and use it in another sql command?

[ServeSATAN]

mysql> ;UPDATE droplist SET itemId=(5575) WHERE itemId=9999 AND mobId IN (SELECT id FROM npc WHERE level >= 61 AND type='L2Raidboss');

1065 - Query was empty

Query OK, 0 rows affected

Rows matched: 0  Changed: 0  Warnings: 0

 

0 rows affected :/

because no rbs upper 61 lvl don't have item 5575 in droplist

[Street]

Ok i use

 

insert into droplist (mobId, itemid, chance, min, max,category) select id, 57, 1000000, 1, 2, 1 from npc where type='L2Raidboss';
UPDATE droplist SET itemId=(10639) WHERE itemId=57 AND mobId IN (SELECT id FROM npc WHERE level >= 61 AND type='L2Raidboss');

 

And working good. THX Leki.

[Justice]

I thing that your problem solved. If you want anything else pm me to unlock it.

 

Locked