delete all pending feature links

kenvin · 02-05-2010

Ver. 2.1.2 I need to know how to delete all pending feature links. I'm getting hit hard with spam all different titles and ips and some of the links don't have titles. I do have the code to delete all pending but I just want to delete the Pending in feature links.

**James** · 02-05-2010

in the where part of your query (after the WHERE STATUS = 1

add

AND `FEATURED` = '1'

kenvin · 02-05-2010

so like this?

DELETE FROM `PLD_LINK` WHERE `STATUS` = 1 AND `FEATURED` = '1';

**James** · 02-05-2010

yes that should do it... like I said always make a make up for a just in case scenario

kenvin · 02-06-2010

Excellent! It worked.

02-05-2010	#1
kenvin Join Date: Aug 2007 Location: Houston, Texas Posts: 238	delete all pending feature links Ver. 2.1.2 I need to know how to delete all pending feature links. I'm getting hit hard with spam all different titles and ips and some of the links don't have titles. I do have the code to delete all pending but I just want to delete the Pending in feature links. __________________ www.aokdirectory.com pr2 directory www.w4directory.com pr3 directory www.edomaincheck.com Domain Evaluation Tool.

02-05-2010	#2
James :) phpLD Support *phpLD Administrator* Supporter Moderator Join Date: Aug 2006 Location: Nanaimo, BC , Canada Posts: 24,019	in the where part of your query (after the WHERE STATUS = 1 add AND `FEATURED` = '1' __________________ Attention: For Support Please Read this thread. IF the domain is not listed in your PhpLD users area and it is 3.x You will have to list it before ANY questions are answered. My paypal is rentawebmaster @ gmail.com ^^ if I have helped you help me I need a new laptop PhpLD Recommended Hosting: Here They work with you not against you Live Directory

02-05-2010	#3
kenvin Join Date: Aug 2007 Location: Houston, Texas Posts: 238	so like this? DELETE FROM `PLD_LINK` WHERE `STATUS` = 1 AND `FEATURED` = '1'; __________________ www.aokdirectory.com pr2 directory www.w4directory.com pr3 directory www.edomaincheck.com Domain Evaluation Tool.

02-05-2010	#4
James :) phpLD Support *phpLD Administrator* Supporter Moderator Join Date: Aug 2006 Location: Nanaimo, BC , Canada Posts: 24,019	yes that should do it... like I said always make a make up for a just in case scenario __________________ Attention: For Support Please Read this thread. IF the domain is not listed in your PhpLD users area and it is 3.x You will have to list it before ANY questions are answered. My paypal is rentawebmaster @ gmail.com ^^ if I have helped you help me I need a new laptop PhpLD Recommended Hosting: Here They work with you not against you Live Directory

02-06-2010	#5
kenvin Join Date: Aug 2007 Location: Houston, Texas Posts: 238	Excellent! It worked. __________________ www.aokdirectory.com pr2 directory www.w4directory.com pr3 directory www.edomaincheck.com Domain Evaluation Tool.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)