Query to remove all augs

[epilz]

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

Thanks

[Kingly_Krab]

I would highly recommend making a backup before running this: DELETE FROM `items` WHERE `itemtype` = '54';

[epilz]

this is what I got.

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

[Bohbo]

this is what I got.

/* 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]

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

[NatedogEZ]

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.


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

[epilz]

Need to remove those items the query returns?

[NatedogEZ]

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]

yeah, its fine, I just tested