Okay many people want to know that how to approve all pending links in PHPLD? Say you have 3000 links pending for approval. That’s a nightmare, coz i know. So I got a simple trick to share. You can now auto-accept all of the links pending validity in phpLD version 2.x (might work with latest version of PHPLD) by using a simple SQL query.
UPDATE `PLD_LINK` SET `STATUS`= 2 WHERE `STATUS` = 1
Here is a step by step instruction for you.
1. Login the phpymyadmin and click your desired sql database
2. Click SQL and enter the query above
3. Hit Go and you are done.