I was wondering if their was any way to easily delete a large amount of link submissions(600)without deleting them individually through the admin . I tried searching the forum for the answer using terms "delete submissions" "delete new url" and couldn't seem to find the answer.

You'd need a mysql query like....

DELETE FROM Links WHERE isValidated='No';

Don't quote me on that but I think that should do what you need.

That will delete all links waiting to be validated.

Mods:http://wiredon.net/gt/download.shtml
Installations:http://wiredon.net/gt/

Syntax is correct, just be sure the "Where ... " clause is what you want!

One safe thing to do, is use a "SELECT * FROM Links Where .... " before doing the delete. If the Select shows the links you want deleted, and only the links you want deleted, then you can replace the "SELECT *" with "DELETE" and let it happen. DELETE's are non-recoverable,s o make sure it's what you really mean to do.



PUGDOG® Enterprises, Inc.
FAQ:http://LinkSQL.com/FAQ
Plugins:http://LinkSQL.com/plugin