From Zero To SEO Achieving High Rankings Through Coding

9Mar/108

What’s spamming? II

Here is how I collect your domains and links, spammers :shock:

All you need is a web service and a plugin. The more blogs are "plugged", the more domains and links will be saved.

Domain Collector Web Service

The purpose is obvious – save domains to database. You can code smth like that:

<?php
if (isset($_POST['domain'])) {
    $mysql_connect = mysql_connect('localhost', 'login', 'password');
 
    if ($mysql_connect) {
        mysql_select_db('database', $mysql_connect);
 
        $domain = strtolower(mysql_real_escape_string($_POST['domain']));
        $res = mysql_query("select id from domains where title = '$domain'", $mysql_connect);
 
        if (!mysql_num_rows($res)) {
            mysql_query("insert into domains (title) values ('$domain')", $mysql_connect);
 
            mail('your.email@yourdomain.com', "Domain Collector Notification", 'New domain: ' . $domain);
        }
 
        mysql_close($mysql_connect);
    }
}
?>

Linkpot Plugin

The plugin hits Domain Collector Web Service (POST) when someone posts a comment and the comment's approval status is not 'spam'.

Find the plugin here. It should work with the latest WordPress version. Upload, install and specify params.

I didn’t add the WP Mu support. If you need that, just do it.

All Together

Trolls don't know domains and links are being collected. One day you'll spam their blogs and blogs they spam.

PS: Of course, this is not the only way to populate domains & links database. You can find/buy/scrape similar databases and import data. *tip spam tool tip*

PPS: fromzerotoseo.com is powered by Linkpot  :twisted:

  • Twitter
  • Facebook
  • Digg
  • Reddit
  • del.icio.us
  • MySpace
  • Google Bookmarks
  • Technorati
  • StumbleUpon
  • Sphinn
  • Slashdot
  • NewsVine
  • Propeller
  • Tumblr
  • BlinkList
  • Faves
  • LinkedIn
  • Mixx
  • Netvibes
  • connotea
  • MisterWong
  • Diigo
  • email
Comments (8) Trackbacks (0)
  1. Wow thanks, this will definitely come in handy as I face a lot of spammers daily. :(

    Till then,

    Jean

  2. I’d love to harness the power of some techniques like this, but my programming skills are fading. These days I can’t be bothered to program anything. So instead I find other ways to find spam worthy sites.

  3. One of these days I will have to hire someone to do some work like this for me. A lot of the spammy marketing techniques may not be as effective in a few years. So it’s best to jump on board while you can.

    • I totally Agree with you on that one. It is getting harder and harder. I have had a conversation with a few people aboutt his and unless Google wants to hire actual people to go out and search for these sites it si next to impossible, because the way it was set up. Google is all about the algorithm.

  4. Nice one! Spammers are everywhere and it seems their getting worse and worse. My blog is stuffed with all spams and I can’t seem to handle them. I think they post nonsense comments daily.

  5. Good point, Laptop. No matter how good the anti-spam measures have gotten, there’s nothing like someone actually put in charge of dealing with it.

    Till then,

    Jean

  6. Lol, “good point, laptop”… Why do guys use optimised anchors although this blog uses nofollow ?

  7. They want to be Top Spammers ;)


Leave a comment


No trackbacks yet.