phpLinkBid Spam Submissions - How to delete in one go!

Discussion in 'Directories' started by vicdigi, Jun 23, 2008.

  1. #1
    Are you recieving 100's of spam submissions daily to your phpLinkBid directory?

    Is the following what you are receiving:

    Email:
    Title: uWEGhCerTPzXcpACc
    URL: h ttp:// loan. foryouonlyss. com/guaranteed-personal-l...
    Description: aKOXOVngwiIZBWmGC

    We receive about 400 of these a day to one of our directories.

    To delete these in one go all you need do is follow the instructions below:

    1. Go to phpmyadmin
    2. Click on tbl_links on the left side
    3. Then click on Browse at the top of the main window
    4. The rest should be self explanatory

    It beats me why spammers are making submissions like these?

    .
     
    vicdigi, Jun 23, 2008 IP
  2. mikey1090

    mikey1090 Moderator Staff

    Messages:
    15,869
    Likes Received:
    1,055
    Best Answers:
    0
    Trophy Points:
    445
    Digital Goods:
    2
    #2
    Today I am going to release a public free mod to hopefull prevent spam. It seem the CAPTCHA has failed.

    To delete all pending links in one go run the following query in phpMyAdmin SQL box-

    
    delete from tbl_links where link_status = 0
    
    Code (markup):
     
    mikey1090, Jun 23, 2008 IP
    Katy and hoshheid like this.
  3. jitendraag

    jitendraag Notable Member

    Messages:
    3,982
    Likes Received:
    324
    Best Answers:
    1
    Trophy Points:
    270
    #3
    @vicdigi: good tip :) The spammer doesn't even know that he is spamming your directory. He is probably sending these submissions to 100s of directories without caring about the time you are wasting in deleting these spam requests.

    @mikey: lol, that's a good mod indeed !!
     
    jitendraag, Jun 23, 2008 IP
  4. Spider-Man

    Spider-Man Banned

    Messages:
    2,684
    Likes Received:
    211
    Best Answers:
    0
    Trophy Points:
    0
    #4
    I thought v1.4 fixed all these issues? It did for me, anyway:eek:
     
    Spider-Man, Jun 23, 2008 IP
  5. mikey1090

    mikey1090 Moderator Staff

    Messages:
    15,869
    Likes Received:
    1,055
    Best Answers:
    0
    Trophy Points:
    445
    Digital Goods:
    2
    #5
    No. The robots got around the captcha.
     
    mikey1090, Jun 23, 2008 IP
  6. Spider-Man

    Spider-Man Banned

    Messages:
    2,684
    Likes Received:
    211
    Best Answers:
    0
    Trophy Points:
    0
    #6
    Well, I ain't had any robot spam submissions - I have obviously received a few manually submitted crap entries, but who hasn't? In my case, if it ain't broke, don't fix it:D I'll be buying a new phpLB license tonight for somebody else's project, here's hoping you add the mod into the new download files;)
     
    Spider-Man, Jun 23, 2008 IP
  7. vicdigi

    vicdigi Banned

    Messages:
    1,917
    Likes Received:
    98
    Best Answers:
    0
    Trophy Points:
    0
    #7

    It's great that they can be deleted in one go. Nevertheless, a little time is still valuable time!

    What do these spammers gain though - a majority of the URLs do not go anywhere anyway!

    .
     
    vicdigi, Jun 23, 2008 IP
  8. mikey1090

    mikey1090 Moderator Staff

    Messages:
    15,869
    Likes Received:
    1,055
    Best Answers:
    0
    Trophy Points:
    445
    Digital Goods:
    2
    #8
    Vic, check my new thread. My mod is released, you can block the spammers now I hope.
     
    mikey1090, Jun 23, 2008 IP
  9. Spider-Man

    Spider-Man Banned

    Messages:
    2,684
    Likes Received:
    211
    Best Answers:
    0
    Trophy Points:
    0
    #9
    That's exactly what they gain;) It costs them less than a minute to set the software up to crawl+spam yet if a ten minute crawl gets the site 1 backlink from 1000 submissions then so be it, that'll be their mentality.
     
    Spider-Man, Jun 23, 2008 IP
  10. vicdigi

    vicdigi Banned

    Messages:
    1,917
    Likes Received:
    98
    Best Answers:
    0
    Trophy Points:
    0
    #10
    Cheers Mikey,

    Will check it out later when I get back this evening.

    .
     
    vicdigi, Jun 23, 2008 IP