Query to remove all augs

epilz · #1 01-30-2015, 10:17 PM

Has anyone removed ALL augs from their server? I would like one to remove them from mine.

Thanks

**Kingly_Krab** · #2 01-30-2015, 10:37 PM

I would highly recommend making a backup before running this:

Code:

DELETE FROM `items` WHERE `itemtype` = '54';

epilz · #3 01-30-2015, 11:01 PM

this is what I got.

Code:

/* Affected rows: 8,966  Found rows: 0  Warnings: 0  Duration for 1 query: 0.687 sec. */

Bohbo · #4 01-31-2015, 04:35 PM

Quote:

Originally Posted by epilz

this is what I got.

Code:

/* Affected rows: 8,966  Found rows: 0  Warnings: 0  Duration for 1 query: 0.687 sec. */

That means 8966 rows (or augment typed items 54 in this case) got deleted. So they should be totally removed.

epilz · #5 01-31-2015, 08:37 PM

yeah they were removed, no one that has been testing has seen anymore drop

**NatedogEZ** · #6 02-01-2015, 05:01 AM

You might have a ton of lootdrops where the item doesnt exist now btw.. not sure if that is gonna break anything.. but this should show you the lootdrop_entries that do not exist as items.

Code:

SELECT lde.* FROM lootdrop_entries lde 
LEFT JOIN items i ON i.id = lde.item_id
WHERE i.id IS NULL;

epilz · #7 02-01-2015, 12:15 PM

Need to remove those items the query returns?

**NatedogEZ** · #8 02-01-2015, 12:24 PM

Should be safe to.. but you can check a few of the items with #fi and make sure.. (thats what I did recently to my DB)

epilz · #9 02-01-2015, 12:41 PM

yeah, its fine, I just tested