[devn00b]

Originally Posted by uwill

I searched the forums and it talked about editing lootdrop_entries to disable them, so I searched for defiant gear, found them in items@peq listed at 50005-50631. So I searched lootdrop_entries for 50005 and it's about a page long, I didn't know if this is the way to do it, or if there is a better way for disabling defiant gear from dropping. Thanks.

SELECT le.* FROM items i
INNER JOIN lootdrop_entries le ON i.id = le.item_id
WHERE i.name like "Crude defiant%"


Change the WHERE clause to find the other types and just remove the rows all at once