Skip to content

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

Featured Replies

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 by Chakl22

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.

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 by Nightw0lf

Create an account or sign in to comment

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.