Help Droplist

[Edasbeast]

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

Edited June 26, 2018 by Edasbeast

[melron]

  On 6/28/2018 at 11:19 AM, Edasbeast said:

not working this.

Expand  

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]

  On 6/26/2018 at 12:44 PM, SweeTs said:

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

Expand  

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)

 

  On 6/27/2018 at 8:20 PM, Solomun said:

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

Expand  

he asks for frozen so its obviusly GoD !

Edited June 28, 2018 by Nightw0lf

[Solomun]

  On 6/28/2018 at 7:48 AM, 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 !

Expand  

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

[Edasbeast]

  On 6/28/2018 at 7:48 AM, 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 !

Expand  

not working this.

[Nightw0lf]

  On 6/28/2018 at 11:19 AM, Edasbeast said:

not working this.

Expand  

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.

 

  On 6/28/2018 at 1:38 PM, 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

Expand  

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]

  On 6/28/2018 at 1:38 PM, melron said:

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

Expand  

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