1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

For all those who spam my blog comments.

Discussion in 'Blogging' started by killer2021, Apr 30, 2011.

  1. killer2021

    killer2021 Regular Member

    Joined:
    Sep 9, 2010
    Messages:
    229
    Likes Received:
    76
    I'd just like to thank all of you for your efforts and posting such nice comments. I delete your links, change your username and then post the comment ;) Makes my blog look very active and also gives me free content.

    Once again thanks, keep up the good work everyone!
     
  2. xpleet

    xpleet Regular Member

    Joined:
    Jan 18, 2010
    Messages:
    377
    Likes Received:
    327
    Location:
    Morocco
    :bsflag:
     
  3. RamChaturvedi

    RamChaturvedi Supreme Member

    Joined:
    Apr 7, 2009
    Messages:
    1,359
    Likes Received:
    436
    Occupation:
    Internet Marketing
    Location:
    Undetected
    Send me your blog and I will send you some 10000-20000 more comments!! :D Happy Editing!!
     
  4. dotcomdesigns

    dotcomdesigns Power Member

    Joined:
    May 16, 2009
    Messages:
    673
    Likes Received:
    646
    Location:
    UK
    just activate akismet - it's blocks most of the spam commenting
     
  5. cyberzilla

    cyberzilla Elite Member Premium Member

    Joined:
    Nov 15, 2009
    Messages:
    2,204
    Likes Received:
    3,363
    Location:
    zeta reticuli
    You should post your blog URL so that people can add that to their exception list..;)
     
    • Thanks Thanks x 3
  6. Maruk

    Maruk Power Member

    Joined:
    Jun 15, 2009
    Messages:
    562
    Likes Received:
    898
    Home Page:
    Hahaha indeed, I would be happy to add you to my Blacklist...
     
  7. bk071

    bk071 Jr. Executive VIP Jr. VIP Premium Member

    Joined:
    Nov 24, 2010
    Messages:
    3,104
    Likes Received:
    7,915
    Occupation:
    I don't have a job
    Location:
    .............
    Yeah its very little work involved for the quality of content you get, and again for 'free' of course.
    Actually, I'm feeling generous today, so give my your blog URL and I will get you 15,000 pieces of 'content' within 30 minutes. Won't take that long to edit 'em :p

    Do we have a deal here? :rolleyes:
     
  8. Shaken not Stirred

    Shaken not Stirred Registered Member

    Joined:
    Dec 30, 2010
    Messages:
    94
    Likes Received:
    69
    Occupation:
    Search & Rescue Trainee
    Location:
    United Kingdom
    Dude I wouldnt approve them, its going to be dupe/copied/content spammed throughout the world wide web, Google will frown upon thy.
     
  9. bloggerjunk

    bloggerjunk Newbie

    Joined:
    Apr 30, 2011
    Messages:
    44
    Likes Received:
    2
    haha.. You could post your blog URL here and I would be fond adding comments to your collection. :D
     
  10. banghead

    banghead Junior Member

    Joined:
    Jan 12, 2009
    Messages:
    135
    Likes Received:
    138
    hey i have few 1000000000 comments to send you -pm me your blog...
     
  11. Aremys

    Aremys Regular Member

    Joined:
    Sep 13, 2008
    Messages:
    307
    Likes Received:
    72
    Instead of doing it manually, you could have just edited your theme so it won't display backlinks in your comments section.
     
    • Thanks Thanks x 1
  12. ash1ey

    ash1ey BANNED BANNED

    Joined:
    Jul 21, 2006
    Messages:
    320
    Likes Received:
    144
    I did the same a while back until i got bored of seeing so many comments.

    Added re-captcha plugin and hardly ever see 1 comment now.
     
  13. OldMadHatter

    OldMadHatter Junior Member

    Joined:
    Feb 26, 2009
    Messages:
    193
    Likes Received:
    70
    Occupation:
    Running own company
    Location:
    The MadCave
    regexp on top of an SQL query - who said manually?
     
    Last edited: Apr 30, 2011
  14. WPRipper

    WPRipper Supreme Member

    Joined:
    Mar 24, 2010
    Messages:
    1,377
    Likes Received:
    1,493
    Location:
    Proudly romanian
    Expand this please :)
     
  15. mazgalici

    mazgalici Supreme Member

    Joined:
    Jan 2, 2009
    Messages:
    1,489
    Likes Received:
    881
    Home Page:

    He is replacing all the links from the comments with one sql command
     
  16. eskimo

    eskimo Regular Member

    Joined:
    Dec 1, 2008
    Messages:
    474
    Likes Received:
    178
    so you post comments like:

    "I am just uncovering this internet site via the Archos product and I can't obtain the detailed internet site to arrive to be from the positioning to load. we Just assumed you wants to know!"

    "This is often i will be looking for. This I refer to value. The data provided right here is usually to the greatest. I must say you must have spent some time in putting these satisfied with each other. They're match with your theme. I shall advocate these to any or all and then to all my friends. I shall go back here to experiment the quality of give good results. Thank you for producing this kind of ensue."

    "Reading this particular next submit the considering pattern appears much more better compared to once i was first unveiled in your opinions"


    because that is about the average quality of comments on all my sites
     
  17. WPRipper

    WPRipper Supreme Member

    Joined:
    Mar 24, 2010
    Messages:
    1,377
    Likes Received:
    1,493
    Location:
    Proudly romanian
    Ya but what is the command ? I dont know noting about sql :p
     
  18. ixrumer

    ixrumer Regular Member

    Joined:
    Jul 3, 2010
    Messages:
    495
    Likes Received:
    236
    Occupation:
    Xrumer Geek
    Location:
    Melbourne, Australia
    Wouldn't it be too easy to tweak the comment submit process?
    1. change the links in website fields
    2. remove all Anchor tags in message field
    3. remove bad words (porn, sex, etc.)
    3. replace particular words with your anchored links (for internal linking, inter linking between your sites, etc.)

    =)
     
  19. SpiritFall

    SpiritFall Newbie

    Joined:
    Apr 10, 2011
    Messages:
    8
    Likes Received:
    0
    mysql_connect("host","user","pass") or die("DB connection failed.");
    mysql_select_db("db_name") or die("Couldnt't select DB.");
    $query = mysql_query("SELECT * FROM table");
    $row = mysql_fetch_array($query);
    $comments = $row['comment'];
    $my_comment = "Your comment goes here";
    $final_query = mysql_query("UPDATE table_name SET comments='$my_comment'");
    if ($final_query)
    {
    echo "Comments replaced.";
    exit;
    }
    else
    echo "Something went wrong.";

    This is really basic php script to replace all comments with one comment. I haven't tried it but it should work. I didn't want to make it too long, if someone needs advanced script lemme know. And yeah, i almost forgot to mention, you need to replace your info on first line also on second line as well as third line, five, six and seven line too :)
    if everything worked fine you should see "Comments replaced.".
     
    Last edited: May 1, 2011
  20. mhatter

    mhatter Regular Member

    Joined:
    Feb 8, 2009
    Messages:
    224
    Likes Received:
    93
    I guess the best way to do this is to let a set amount of people, say 100+, spam your comments with useful comments. I'm talking about the people who make OK posts just so they can have a backlink. After, run a PHP script that uses regex to remove all URLs from the comments in your database.