Any way of approving all links at once in phpld v2.1 ?

Is there any way of approving all links at once in phpld v2.1? I've thousands of links to approve and I'm a bit lazy so I just wanna take a look at all submissions and submit them all at once and maybe later delete the ones I don't want. To cut it short, can I simply approve all of submissions at once?

 

Just goto phpmyadmin, i think it's 'active' = 1. So run a line of mySQL;

UPDATE TABLE_NAME SET `active`='1'

Code (markup):

Hope that helps.

 

I recommend that you take the time needed to review all of the sites that are submitted instead of just approving everything that comes in the box. You could easily find yourself linking out to some bad sites. Morever, it would not show that you are concerned with quality but quanity and that is not good.

Just mo though.

 

I will review them. But I don't wanna click an approve button for each submission.

Didn't work. Says there is no "active" field. I'm looking for the right variable now.

 

You can't do it from admin panel, otherwise, nobody will purchase 3.* .

 

Well, if there was a way to do it from admin panel, I'd have found it till now anyway

 

pretty close terry

added the where clause, just in case there are some some to inactive(e.g. 0) so only those pending get the approval.

 

UPDATE PLD_LINK SET `status`='2'

I did with this. But yours is more logical with the where clause. Thanks everyone, reps are on the way

 

hehe

I'm in a rush to do things today lol, so that explains the wrong answer

 

we all live and learn right