Help Droplist

[Edasbeast]

How to remove droplist from monsters in l2jfrozen, but left only adena?

Edited June 26, 2018 by Edasbeast

[melron]

3 hours ago, Edasbeast said:

not working this.

you could search about 1 sql query at google as @SweeTs mentioned.

 

The correct query is 

DELETE FROM droplist WHERE itemid <> 57

probably nightwolf made a mistake and used operators from SELECT command but the thought is the same

 

P.S. this query will delete drops even from raidbosses/grandbosses. in case you want an exception for those types you can edit the query 

Edited June 28, 2018 by melron

[SweeTs]

Execute proper sql query, delete all from spawnlist except adena. 

[Edasbeast]

1 hour ago, SweeTs said:

Execute proper sql query, delete all from spawnlist except adena. 

maybe you know navicat command to remove droplist from monsters?

[SweeTs]

I could give ya rdy query, but what about Google, checking how it works and trying to create it on your own?

Share the result =) 

 

Try here

https://www.w3schools.com/sql/sql_delete.asp

[Solomun]

Depends on what client u are working on. High5 stores droplist in npcs.xml

[Nightw0lf]

DELETE * FROM `items` WHERE `item_id`!='57'

analyzing the query.

delete (everything) from (table name) where item id(column name) is not equal (!=) to adena (57)

 

12 hours ago, Solomun said:

Depends on what client u are working on. High5 stores droplist in npcs.xml

he asks for frozen so its obviusly GoD !

Edited June 28, 2018 by Nightw0lf

[Solomun]

54 minutes ago, Nightw0lf said:

DELETE * FROM `items` WHERE `item_id`!='57'

analyzing the query.

delete (everything) from (table name) where item id is not equal (!=) to adena (57)

 

he asks for frozen so its obviusly GoD !

Oh lul, i didn't notice....My bad

[Edasbeast]

3 hours ago, Nightw0lf said:

DELETE * FROM `items` WHERE `item_id`!='57'

analyzing the query.

delete (everything) from (table name) where item id(column name) is not equal (!=) to adena (57)

 

he asks for frozen so its obviusly GoD !

not working this.

[Nightw0lf]

2 hours ago, Edasbeast said:

not working this.

this is why I analyzed it for, so you can change it according to your database.. its not out of the box I just created it without having any idea what table or what l2jfrozen calls the item id in the database since you dont provide more info about it, it works but you have to be smart to edit it.

 

22 minutes ago, melron said:

you could search about 1 sql query at google as @SweeTs mentioned.

 

The correct query is 

DELETE FROM items WHERE item_id <> 57

probably nightwolf made a mistake and used operators from SELECT command but the thought is the same

I just wake and saw that and replied without having a coffee :)

 

additional conditions for raid bosses

DELETE FROM items WHERE item_id <> 57 AND npc_id <> 2222

OBVIOUSLY where 2222 is the example boss that you want this query to ignore

and where npc_id is your table column that holds the monster id

if you want more (you should) you continue with

AND npc_id <> number AND npc_id <> number AND npc_id <> number AND..

Edited June 28, 2018 by Nightw0lf

[melron]

Ok @Nightwolf now i'm laughing about 5 minutes non-stop. the guy want to delete drops not items at inventory. we are both so blinds

 

 

DELETE FROM droplist WHERE itemid <> 57

 

 

Edited June 28, 2018 by melron

[Nightw0lf]

[SweeTs]

57 minutes ago, melron said:

you could search about 1 sql query at google as @SweeTs mentioned.

Pointless as it's better to wait day or even two to get ready answer. =)