Hiya,

Someone recently mass submitted hundreds of (duplicate) links to my LinksSQL installation. I have now tightened access in db_referers to ensure this doesn't happen again.

My question is this: Is there any way to "mass delete" the hundreds of unvalidated entries without going through them one by one?

I appreciate any input!

Katina

Use the MySQLMan application....

(SQLMONITOR)

DELETE FROM Links
WHERE (isValidate = 'N') AND (Date = NOW());

You might want to SAVE the above query for future use.

BTW: If you don't want to just delete the non-validated links from today, then delete AND (Date = NOW()) from the above SQL statement.

Regards,

Eliot Lee

Hi Eliot,

Worked like a charm! Thanks so much for the help! :)

Katina

You're welcome.

Another way to avoid spamming is to turn authentication ON for end-users to login first to add/modify links.

Regards,

Eliot Lee