1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

How Do I Remove All Regular Link in PHPLD Version 2.2 Using SQL query

Discussion in 'Directories' started by unknownpray, Mar 14, 2012.

0
  1. #1
    Today google adsense send me email you have 3 working days to remove violation content.

    There is lot of regular link in my directory who need to be removed...i want to save all featured links so i'm wondering if there is way to remove all regular link or we can remove links using specific title in SQL query.

    i desperately need help only have 3 working days so please help me ASAP.
     
    unknownpray, Mar 14, 2012 IP
  2. YMC

    YMC Well-Known Member

    Messages:
    2,787
    Likes Received:
    404
    Best Answers:
    4
    Trophy Points:
    190
    #2
    Why are you assuming that the listings are at fault? It might be your placement or some other violation of their Terms of Service.
     
    YMC, Mar 14, 2012 IP
  3. unknownpray

    unknownpray Active Member

    Messages:
    3,831
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    70
    #3
    Google Adsense Send me example link where i can see Escorts links...
     
    unknownpray, Mar 14, 2012 IP
  4. YMC

    YMC Well-Known Member

    Messages:
    2,787
    Likes Received:
    404
    Best Answers:
    4
    Trophy Points:
    190
    #4
    That makes more sense. Dump the listings for gambling, pornography, and other adult things if you want to keep using Adsense. Or take the ads off of any page which they appear. The full list of unapproved topics is in Google's terms of service.
     
    YMC, Mar 15, 2012 IP
  5. youloveme44

    youloveme44 Peon

    Messages:
    10
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    more comments please
     
    youloveme44, Mar 15, 2012 IP
  6. unknownpray

    unknownpray Active Member

    Messages:
    3,831
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    70
    #6
    you did not give me mysql query to remove regular links but i got idea after reading your comment i can simply just put adsense on main page and remove adsense from all other pages.
     
    unknownpray, Mar 15, 2012 IP
  7. WallaceYeung

    WallaceYeung Notable Member

    Messages:
    3,377
    Likes Received:
    164
    Best Answers:
    0
    Trophy Points:
    230
    Digital Goods:
    1
    #7
    You can login to mysql, and then select PLD_LINK to edit or remove any listing accordingly. ;)
     
    WallaceYeung, Mar 15, 2012 IP
  8. unknownpray

    unknownpray Active Member

    Messages:
    3,831
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    70
    #8
    Thanks for your Reply but i have millions of links :( who have time to figure out...Finally what i have done i just put my Adsense in just Index page
     
    unknownpray, Mar 16, 2012 IP
  9. unknownpray

    unknownpray Active Member

    Messages:
    3,831
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    70
    #9
    Lol Some People just want to increase there post....
     
    unknownpray, Mar 16, 2012 IP
  10. dvduval

    dvduval Notable Member

    Messages:
    3,369
    Likes Received:
    356
    Best Answers:
    1
    Trophy Points:
    260
    #10
    Use at your own risk! But something like this

    DELETE FROM `PLD_LINK` WHERE `STATUS` = '2' AND `FEATURED` = '0';
     
    dvduval, Mar 17, 2012 IP