Help Drop

[criss22]

How i can delete all drops from mobs? (incluse raids). i want to remove all drops with 1 click.

Is something from Navicat?

Thx

[wongerlt]

delete from droplist where mobid not in ('1234','4321,'....',....)

[criss22]

Thx but no work..i need exactly command :D

Edited September 23, 2017 by criss22

[wongerlt]

 DELETE FROM `droplist`  WHERE  `mobId` NOT IN ('123','456','789');

123 and 456 and 789 is raid boss id as example, put all ur boss id.

[melron]

delete
	droplist.*
from
	droplist,npc
where
	droplist.mobId = npc.id and npc.type <> "L2RaidBoss"

this one will delete all drops from any NPC except L2RaidBoss type

Edited September 23, 2017 by melron

[criss22]

Thank you " melron".

['Baggos']

But you can not add a custom drop also.. 

It's like the drop xml category of mobs, etc doesn't exist.

So, you have a server without drops. Not even custom mobs with drop. Only Raidboss drop.

I'm wrong?

 

Maybe you need something to skip some drops id? Like Enria, coal, spellbooks etc.. 

Edited September 25, 2017 by 'Baggos'