Directories SQL Query Codes Required for Deleting Listings

Consider installing the Spam Guard Mod Amit. Its doesn't bring in any nonsense spam submissions.

 

Hey Amit.

A more permanent solution to get rid of the "[URL =" mass spammer (and others) would be to add some simple code to your submit.php. I used to get hundreds of the following type of spam submissions...

Title: ultram,soma,tramadol
URL: http://xanax.xepharmacy.com/xanax-overnight-cod.html
PageRank: -1
Description:
  
<a href=http://www.mysportsforum.com/forums/t6801-order-ambien.html>Order ambien</a> 
<a href=http://www.care2.com/c2c/people/profile.html?pid=972495625>tramadol</a> 
<a href=http://us.cyworld.com/Buy-phentermine>Buy phentermine</a> 
<a href=http://forum.internetdomainmanagement.com/showthread.php?t=3215>Diazepam</a> 
<a href=http://www.mysportsforum.com/forums/t6800-buy-ambien.html>Buy ambien</a> 
<a href=http://www.gametab.com/forums/showthread.php?t=3336>Buy phentermine</a> 
<a h ...

Code (markup):

To completely eliminate these, just open up your directory's submit.php and add the following code:

// Check Description for SPAM 
if (preg_match("/\[url=/i", $data['DESCRIPTION']))
{
Header("Location: http://www.amishrakefight.org/gfy/");
return;
}

Code (markup):

This adds a redirect to this page ( ) when someone submits a description with "[URL=" in it.

Another code that is great against these mass spammers...

// Check Description for SPAM 2
if (preg_match("/\http:/i", $data['DESCRIPTION']))
{
Header("Location: http://www.amishrakefight.org/gfy/");
return;
}

The example above redirects to the GFY page when a spammer submits a description with "http:" in it.

P.S. I added the above codes right above the "$RegularLink_notif = true;" line in the submit.php page.

 

That's a good tip EveryQuery and the redirect page is cool too

 

lol, nice idea..
i like that page

But spammers are bots, they dont see anything