Results 1 to 3 of 3

Thread: Clean Up Users - Delete Users with no ads

  1. #1
    Thread Starter
    canadawebservices's Avatar
    Join Date
    Nov 2012
    Location
    Canada
    Posts
    242
    Thanks
    2
    Thanked 9 Times in 8 Posts

    Clean Up Users - Delete Users with no ads

    I would really love to know this. Is there a way to go into WP multisite admin, display users, and have it show ad count beside users? I have been looking into this for so long. Basically, I would like to delete any user with no ad posting what so ever. If I go into each site individually. I can see the user and post amount. However, the users main profile still is in the main site as I am using multisite user management. I would need to do this with admin panel of multisite under users. PLEASE HELP...

    OR USE THE DATABASE OPTION BELOW

    - - - Updated - - -

    What would the code be to execute this in Phpmyadmin to remove users with no ads ( not post ) I have this code, but it only gets rid of users with no post

    DELETE FROM wp_users WHERE ID NOT IN (SELECT DISTINCT post_author FROM wp_posts)

    Can one of you Classipress people provide a code for which I can clean up my site please from users with no ad listings. Anyone that has 0 ads. I am not sure what the tables would be for the removal of users with ads and their meta data,

    PLEASE HELP..
    360 Web Firm
    https://360webfirm.ca
    Business Directory
    https://businessdirectory.cc

  2. #2
    talent's Avatar
    Join Date
    Jul 2011
    Location
    London UK
    Posts
    3,497
    Thanks
    75
    Thanked 553 Times in 502 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!
    $function ('CUSTOMIZATION'); } else { .DESIGN { display: awesome; }
    If you require any additional functionality or design customization, just ask. Afterall... anything is possible! However, I may not know how to implement your particular request, but if you don't ask, you don't get

    If you build it, they will come...


  3. #3
    Newbie beraf's Avatar
    Join Date
    Aug 2011
    Location
    Belgium
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to sort users and delete never logged in users
    By manishkhullar in forum Help Using ClassiPress
    Replies: 5
    Last Post: January 17th, 2017, 01:17 AM
  2. How to delete users with no ads ??!!
    By anunturitop_ro in forum ClassiPress General Discussion
    Replies: 2
    Last Post: September 17th, 2016, 10:32 AM
  3. Prevent delete ads by users
    By drabello in forum ClassiPress General Discussion
    Replies: 3
    Last Post: June 8th, 2015, 09:08 AM
  4. Delete spam users
    By pcognard in forum Vantage General Discussion (Legacy)
    Replies: 3
    Last Post: June 2nd, 2014, 02:36 AM
  5. Allow users to delete their own accounts
    By Florin in forum ClassiPress General Discussion
    Replies: 12
    Last Post: June 13th, 2012, 04:17 PM