Deleting Spam or Pending Links

[David]

It's bound to happen to most of us...
Your directory gets so many submissions that there is no way you can possibly go through all of them in a sufficient amount of time, and to top it all off, most of the pending links are spam. You've got to get control of your directory! :shock:

The following SQL command will delete all pending links:
Content visible to registered users only.
First, BACK UP YOUR DATABASE!

If you want to remove a few at a time, do this:
Content visible to registered users only.

Or let's suppose there is this one domain that spammed you to death:
Content visible to registered users only.
Deletes all links where the Title contains the word "poker"

or...

Content visible to registered users only.
Deletes all links where the URL contains the word "poker"

[Ap0s7le]

Only problem using Content visible to registered users only. is that for example and ease of use I'm going to use "can"

So lets say I do
Content visible to registered users only.

That's going to delete all titles that contain "scanner", "cannot", "can't", "canon" etc.

Be careful, as this could lead to unwanted deletions.

-Casey

[seothatworks]

Hope not many people will be inspired by the first one :).

It would be cool to have a mass approval/mass deletion tools on each page. I mean, instead of now going one by one, you would only check the checkboxes next to each link, and press the delete button or approval button only once per page. Nothing crucial, though.

[Ap0s7le]

Sounds good Tom, I may have to look into that ;)

-Casey

[David]

You could do something like approve all of the links that you feel are appropriate, and then use the first option. ;)