Any mass submission tools for PHPLD?

Discussion in 'Directories' started by Sejje, May 2, 2007.

  1. #1
    I need to approve around 1000-2000 links fast and doing it manually will take a REALLY long time. Are there any free tools that can help me with this? I have the paid version but it still will take a while to look over each one manually to make sure it is the right quality and a unique site and all of those factors.
     
    Sejje, May 2, 2007 IP
  2. bested

    bested Active Member

    Messages:
    1,165
    Likes Received:
    35
    Best Answers:
    0
    Trophy Points:
    88
    #2
    I'd like to see something like this as well
     
    bested, May 2, 2007 IP
  3. Joobz

    Joobz Peon

    Messages:
    598
    Likes Received:
    9
    Best Answers:
    0
    Trophy Points:
    0
    #3
    You could write a mySQL script to go into the database and remove the flag that keeps it in "unapproved" status. You might want to go to the PHPLD forum as I think I remember seeing something like that before.
     
    Joobz, May 2, 2007 IP
  4. Sejje

    Sejje Banned

    Messages:
    1,312
    Likes Received:
    41
    Best Answers:
    0
    Trophy Points:
    0
    #4
    I will look there right now thanks for the fast responses +rep for anyone that finds me that link. :)
     
    Sejje, May 2, 2007 IP
  5. an0n

    an0n Prominent Member

    Messages:
    5,688
    Likes Received:
    915
    Best Answers:
    0
    Trophy Points:
    360
    #5
    for just the pending
    UPDATE `PLD_LINK` SET `STATUS` = 2 WHERE `STATUS` = 1;

    for anything and everything
    UPDATE `PLD_LINK` SET `STATUS` = 2;


    Run either in phpmyadmin.

    I wonder if this guy could have just written that 'on the Fly'

    hahaha
     
    an0n, May 2, 2007 IP
  6. Joobz

    Joobz Peon

    Messages:
    598
    Likes Received:
    9
    Best Answers:
    0
    Trophy Points:
    0
    #6
    green rep for anyone who can give me the mySQL script to delete all of the pending approvals records. (I have some old ones that are non-compliant I keep ignoring)
     
    Joobz, May 2, 2007 IP
  7. malcolm1

    malcolm1 Prominent Member

    Messages:
    7,148
    Likes Received:
    758
    Best Answers:
    0
    Trophy Points:
    310
    #7
    Well why in gods green earth werent you handling your submissions?

    I mean why did you let it get so bad?

    thx
    malcolm

    PS...25+ directories is called "network" anything else is a handful ;)
     
    malcolm1, May 2, 2007 IP
  8. an0n

    an0n Prominent Member

    Messages:
    5,688
    Likes Received:
    915
    Best Answers:
    0
    Trophy Points:
    360
    #8
    no need for green.

    DELETE FROM `PLD_LINK` WHERE `STATUS` = 1;

    done. all pending go bye bye.
     
    an0n, May 3, 2007 IP
    Joobz likes this.
  9. Joobz

    Joobz Peon

    Messages:
    598
    Likes Received:
    9
    Best Answers:
    0
    Trophy Points:
    0
    #9
    These were submissions that did not qualify for my submission guidelines - there was someone with some sort of mass-submission script spamming the crap out of me with MFA's, penis enlargement pills and gambling sites. So, they started to stack up quickly. For the record, I post these rules on my submission page.
     
    Joobz, May 3, 2007 IP
  10. centime

    centime Peon

    Messages:
    847
    Likes Received:
    46
    Best Answers:
    0
    Trophy Points:
    0
    #10
    I am sorry to ask, but are you actually requesting for an automated algo to simulate a human reviewer ?

    or

    an approve all button ?
     
    centime, May 3, 2007 IP
  11. Richie_Ni

    Richie_Ni Illustrious Member

    Messages:
    10,721
    Likes Received:
    1,175
    Best Answers:
    0
    Trophy Points:
    410
    #11
    Approve all.....
     
    Richie_Ni, May 3, 2007 IP