Phpld 2.1.1 Question of mass edit

[procrastinator]

Is there any way ? ive got truckloads of spam submissions in my directories & havent been able to get the time to approve submissions, and i see truckloads of spam :mad::mad: , is there anyyyyyyyyy way i can mass edit the submissions?

[deluxdon]

Is there any way ? ive got truckloads of spam submissions in my directories & havent been able to get the time to approve submissions, and i see truckloads of spam :mad::mad: , is there anyyyyyyyyy way i can mass edit the submissions?

Do you want to edit them all (spam submissions) or delete them through one click :confused: Searh here if you want to delete them at once through php My Admin as few days back it was already discussed here.

[dargre]

Is there any way ? ive got truckloads of spam submissions in my directories & havent been able to get the time to approve submissions, and i see truckloads of spam :mad::mad: , is there anyyyyyyyyy way i can mass edit the submissions?

Yeah, load all spam on truck and say BYE, BYE!
or
change the script

[humm]

If you wanna delete all pending links at once, here is the code:

delete from `PLD_LINK` where `STATUS`=1

^^Run that to your db via myphpadmin. (At your own risk, backup the db first)

Btw upgrade to phpld 2.1.2 it doesn't bring in spam from what I know.

[procrastinator]

thanks for inputs deluxdon & humm , i shall surely look more into it.

[msolution]

upgrade to 3.2, or atleast to 2.1.3!

i would suggest this (http://www.dir.vc/free-phpld-mods/#down_2)

M.

[procrastinator]

yeah, i guess an upgrade would be a less risky option than going in for phpmyadmin option

[Red_Virus]

I think that you should get the spam prevention mod from Anon & also check the below link for some help.
http://www.directorytotal.com/rejecting-spam-links-on-phpld-from-phpmyadmin/

[WatchOut]

Backup the database and run that Query. If anything happens, simply restore the DB.

Meti