Is there any mod for Removing all Pendings in 1 attempt?

Hello All

i was looking Is there any mod for Removing all Pendings in 1 attempt?

Actually some of my directories have about over 15000 + pending enteries.

It is difficult to remove them by default code. As we can only select 20 in 1 step?

Is there any mod to select all pendings and remove all at once?

Thanks
Sanjay

 

delete from `PLD_LINK` where `STATUS`=1

Code (markup):

^^ Run command at your mysql.

Use at your own risk though, always backup db before use. Keep the code saved, its very useful.

 

hmm why not review those slowly ?? are all SPAM ??

 

Gotta say not a shining endorsement of your sites...you have so many people who took the time to submit to your directory that you are going to thank them by deleting all of their submissions regardless of quality.

Why not close submissions and work to get the queues down?

 

I think YMC 's suggestion is a far Better idea than blindly removing all pending links.

Alternatively you can do selective link deleting.

Deletes all links where the Title contains the word "poker"

DELETE FROM `PLD_LINK` WHERE `TITLE` LIKE '%poker%' LIMIT 50;

Code (markup):

or...


Deletes all links where the URL contains the word "poker"

DELETE FROM `PLD_LINK` WHERE WHERE `URL` LIKE '%poker%' LIMIT 50;

Code (markup):

BACK UP YOUR DATABASE BEFORE TRYING THE ABOVE

 

Nice one dotcompals. I liked it

 

do something like that as suggested by dotcompals and ymc than wasting the submitters time.

 

Thanks all for the suggestions.

I got it working now with above codes mentioned by sunny and dotcompals

Sanjay

 

let me know which is working too.
I also want to delete mass spam submissions.

 

This one by sunny

is good to delete all spam pendings.

 

I some times use the soution shown by Sunny on my free directories, when the amount of spam submission just grows out of proportion, I am really impressed with the query shown by dotcompals, will try and blog about it.

 

you should be careful though in case you have active listings with that keyword in the title or description. you can add "AND STATUS = '1'"


ps: in the second query there is a typo (extra WHERE).

 

Hi, I am new at sql but would love to ged rid of some of the spam that I have submitted. can someone pls let me know exactly how to type in that command.

ie I go to cpanel, mysql, then phpMyAdmin, then I select the db from the left and it shows me the db structure. what field do I use to type in commands??

would appreciate any help. thanks

 

fantastic, easy when you know how! rep added, thanks for quick answer..

 

Reading this lot and looking at how complicated mysql is to the untrained I'm glad we put a 'pending' status in the script in my sig, that way you can delete them all in one go via admin without worrying about messing with complicated databases.

 

very usefull info for me infact as i have over 150k listing pending per dir

 

150K links pending? LOL , that's a lot..

 

yea as i am out this shit now

 

Punks is always best at what he does.