EQEmulator Forums - Query to remove all augs

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - Query to remove all augs (https://www.eqemulator.org/forums/showthread.php?t=39291)

epilz

01-30-2015 10:17 PM

Query to remove all augs

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

Thanks

Kingly_Krab

01-30-2015 10:37 PM

I would highly recommend making a backup before running this:

Code:

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

epilz

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

01-31-2015 04:35 PM

Quote:

Originally Posted by epilz (Post 237313)

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

01-31-2015 08:37 PM

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

NatedogEZ

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

02-01-2015 12:15 PM

Need to remove those items the query returns?

NatedogEZ

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

02-01-2015 12:41 PM

yeah, its fine, I just tested

All times are GMT -4. The time now is 11:01 AM.