Request Sql For Delete All Drops From Mobs (Except Raids).

[Chakl22]

Chronicle: Freya
l2jdp - revision="7968"
l2j - revision="4601"

 

I m looking for a SQL script for delete any type of drop from MOBS including ADENA.

Edited November 16, 2014 by Chakl22

[N1nj4Styl3]

UPDATE (TableName) SET (ColumnName) = Null;

 

Used to run this query in my db when I wanted to change the values of a certain column to null. 

 

Idk if this is going to work for you, but give it a shot.

[Nightw0lf]

DELETE FROM tablename WHERE condition>0 AND contition != 'raid';

fix this to fill the table name and contitions(column names)

the fist contition will delete where drops are bigger of 0 and second contition will prevent it on deleting the raid (raid is example you will add the i dont know L2Raid or something)

possible table name = drops

possible first contition = type

possible second contition = monsters

Edited November 17, 2014 by Nightw0lf