Delete Itemloot

[Chuck Norris]

I am trying to delete a lot of item loot but I keep trying to make a SQL. The SQL will work with out a error but It seems like it skips it because I get a dup. entry.


Here is what Im using.

DELETE FROM 'itemloot' WHERE entryid BETWEEN '42000' AND '40155';

Also

DELETE FROM 'itemloot' WHERE index BETWEEN '42000' AND '40155';

They both do not work

[SectorSeven]

ROFL my bagged items
thanks for deleting them mate - get ACDB rev 8 and they work great

[Chuck Norris]

I need to delete them and then insert them again. Also I don't like acdb