Phpld 2.1.1 Question of mass edit

Discussion in 'Directories' started by procrastinator, Nov 4, 2007.

  1. #1
    Is there any way ? ive got truckloads of spam submissions in my directories & havent been able to get the time to approve submissions, and i see truckloads of spam :mad::mad: , is there anyyyyyyyyy way i can mass edit the submissions?
     
    procrastinator, Nov 4, 2007 IP
  2. deluxdon

    deluxdon Catch Me If You Can...!!!™ Staff

    Messages:
    25,481
    Likes Received:
    1,943
    Best Answers:
    32
    Trophy Points:
    480
    #2
    Do you want to edit them all (spam submissions) or delete them through one click :confused: Searh here if you want to delete them at once through php My Admin as few days back it was already discussed here.
     
    deluxdon, Nov 4, 2007 IP
  3. dargre

    dargre Peon

    Messages:
    1,007
    Likes Received:
    161
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Yeah, load all spam on truck and say BYE, BYE!
    or
    change the script
     
    dargre, Nov 4, 2007 IP
  4. humm

    humm बहादुर बच्चा

    Messages:
    4,346
    Likes Received:
    850
    Best Answers:
    0
    Trophy Points:
    310
    #4
    If you wanna delete all pending links at once, here is the code:

    delete from `PLD_LINK` where `STATUS`=1
    PHP:
    ^^Run that to your db via myphpadmin. (At your own risk, backup the db first)

    Btw upgrade to phpld 2.1.2 it doesn't bring in spam from what I know.
     
    humm, Nov 4, 2007 IP
  5. procrastinator

    procrastinator Peon

    Messages:
    1,718
    Likes Received:
    56
    Best Answers:
    0
    Trophy Points:
    0
    #5
    thanks for inputs deluxdon & humm , i shall surely look more into it.
     
    procrastinator, Nov 5, 2007 IP
  6. msolution

    msolution Well-Known Member

    Messages:
    1,182
    Likes Received:
    123
    Best Answers:
    0
    Trophy Points:
    175
    #6
    upgrade to 3.2, or atleast to 2.1.3!

    i would suggest this

    M.
     
    msolution, Nov 5, 2007 IP
  7. procrastinator

    procrastinator Peon

    Messages:
    1,718
    Likes Received:
    56
    Best Answers:
    0
    Trophy Points:
    0
    #7
    yeah, i guess an upgrade would be a less risky option than going in for phpmyadmin option
     
    procrastinator, Nov 7, 2007 IP
  8. Red_Virus

    Red_Virus Well-Known Member

    Messages:
    3,756
    Likes Received:
    249
    Best Answers:
    0
    Trophy Points:
    135
    #8
    Red_Virus, Nov 8, 2007 IP
  9. WatchOut

    WatchOut Guest

    Messages:
    1,359
    Likes Received:
    65
    Best Answers:
    0
    Trophy Points:
    0
    #9
    Backup the database and run that Query. If anything happens, simply restore the DB.

    Meti
     
    WatchOut, Nov 8, 2007 IP