How to Reject pending links via phpmyadmin ?

Hi,

I have a lot of spam submissions in my directory, Im currently running 2.1 and it will take me a very long time to delete them.

Is there a quicker way to delete pending links via phpmyadmin?
Which table is it in?

Thanks.

 

Well If u are trying to delete all the pending links with that method if possible, then you will also be deleting some of the good links also !

 

Do you think i havent already figured that out?
I have already, approved all the non-spammy links. Theres about 200 or so spam links left.

 

you need to run this query in phpmyadmin

 

Thank you.

 

The same does for 3x version too mhamdi?

 

yes chetan.

 

Thanks mhamdi, for the code, I just made a blog post on the same as It is working both on the 2.x & 3.x versions.

 

I suggest you edit your post as this deletes pending links not spam links. just add a sentence or 2 to clarify that you need to approve first all good submissions.

 

1. which code to use for approve all pending links

2. delete only pending featured listings

 

Thanks mhamdi, for pointing that I have edited the blogpost.

I have also included these two codes in the original blog post, thanks so much for sharing.

 

good stuff mhamdi , thanks for sharing