Results 1 to 2 of 2

Thread: Resumes access - Inactive list displays Job seekers and Job Listers

  1. January 24th, 2013 #1
    jonduckett
    jonduckett is offline
    Thread Starter
    Member jonduckett's Avatar
    Join Date
    Mar 2011
    Location
    United Kingdom
    Posts
    51
    Thanks
    0
    Thanked 3 Times in 2 Posts

    Resumes access - Inactive list displays Job seekers and Job Listers

    Just a quick one.

    In the backend in Resume access, the inactive list displays job seekers and job listers - This is a bit tacky!

    Here is the query:

    PHP Code:
            case 'inactive':
                    $sql = "SELECT distinct user_meta.user_id, start_date, end_date, trial FROM ".$wpdb->prefix."usermeta AS user_meta, "
                            . $sql_subscr_meta .
                            " AND user_meta.user_id NOT IN ( SELECT user_id FROM ".$wpdb->prefix."usermeta WHERE meta_key = '_valid_resume_subscription' AND meta_value = '1' OR ( meta_key = '_valid_resume_subscription_order' ) )";                
            break; 
    How can I add into the query:

    PHP Code:
    WHERE meta_key = 'wp_capabilities'
    AND meta_value LIKE '%job_lister%' 
    Just something so simple but annoying when you have 2000 job_seekers and only 150 job_listers.

    Thanks
    Nathan
    Reply With Quote Reply With Quote
  2. January 31st, 2013 #2
    dimitris
    dimitris is offline
    dimitris's Avatar
    Join Date
    Oct 2011
    Location
    Earth
    Posts
    20,617
    Thanks
    222
    Thanked 1,873 Times in 1,770 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!
    Reply With Quote Reply With Quote
« Ability To Embed YouTube Videos For Job Seekers | blocking countries »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Allow Job Listers to view resumes - how to implement
    By vfmonsen in forum Report JobRoller Bugs
    Replies: 3
    Last Post: August 14th, 2012, 02:40 PM
  2. Back Office Access Displays even when disabled.
    By centurypixel in forum Report ClassiPress Bugs
    Replies: 5
    Last Post: August 10th, 2012, 12:57 AM
  3. [SOLVED] Browse Resumes Tab For Job Seekers
    By pumapunku in forum Report JobRoller Bugs
    Replies: 3
    Last Post: October 7th, 2011, 10:17 AM
  4. How to seperate the user registration of seekers and listers?
    By maorlast in forum Report JobRoller Bugs
    Replies: 1
    Last Post: June 14th, 2011, 08:14 AM