0, "thisday"=>date("Y-m-d"), "alltime"=>0, "month"=>0, "thismonth"=>date("n"))); $views = get_option("pmpro_views", array("today"=>0, "thisday"=>date("Y-m-d"), "alltime"=>0, "month"=>0, "thismonth"=>date("n"))); $logins = get_option("pmpro_logins", array("today"=>0, "thisday"=>date("Y-m-d"), "alltime"=>0, "month"=>0, "thismonth"=>date("n"))); ?>

:

:

:

:

:

:

:

:

:

users u LEFT JOIN $wpdb->usermeta um ON u.ID = um.user_id LEFT JOIN $wpdb->pmpro_memberships_users mu ON u.ID = mu.user_id AND mu.status = 'active' LEFT JOIN $wpdb->pmpro_membership_levels m ON mu.membership_id = m.id WHERE (u.user_login LIKE '%$s%' OR u.user_email LIKE '%$s%' OR um.meta_value LIKE '%$s%') "; if($l == "all") $sqlQuery .= " AND mu.status = 'active' AND mu.membership_id > 0 "; elseif($l) $sqlQuery .= " AND mu.membership_id = '" . $l . "' "; $sqlQuery .= "GROUP BY u.ID ORDER BY user_registered DESC LIMIT $start, $limit"; } else { $sqlQuery = "SELECT SQL_CALC_FOUND_ROWS u.ID, u.user_login, u.user_email, UNIX_TIMESTAMP(u.user_registered) as joindate, mu.membership_id, mu.initial_payment, mu.billing_amount, mu.cycle_period, mu.cycle_number, mu.billing_limit, mu.trial_amount, mu.trial_limit, UNIX_TIMESTAMP(mu.startdate) as startdate, UNIX_TIMESTAMP(mu.enddate) as enddate, m.name as membership FROM $wpdb->users u LEFT JOIN $wpdb->pmpro_memberships_users mu ON u.ID = mu.user_id AND mu.status = 'active' LEFT JOIN $wpdb->pmpro_membership_levels m ON mu.membership_id = m.id"; $sqlQuery .= " WHERE 1=1 "; if($l == "all") $sqlQuery .= " AND mu.membership_id > 0 AND mu.status = 'active' "; elseif($l) $sqlQuery .= " AND mu.membership_id = '" . $l . "' "; $sqlQuery .= "GROUP BY u.ID ORDER BY user_registered DESC LIMIT $start, $limit"; } $sqlQuery = apply_filters("pmpro_members_list_sql", $sqlQuery); $theusers = $wpdb->get_results($sqlQuery); $totalrows = $wpdb->get_var("SELECT FOUND_ROWS() as found_rows"); if($theusers) { ?>

found. ID); $visits = get_user_meta($auser->ID, "pmpro_visits", true); $views = get_user_meta($auser->ID, "pmpro_views", true); $logins = get_user_meta($auser->ID, "pmpro_logins", true); if(empty($logins)) $logins = array("last"=>"N/A", "month"=>"N/A", "alltime"=>"N/A"); ?> class="alternate">
ID?> ID, 32)?> ID . '">' . $theuser->user_login . ''; $userlink = apply_filters("pmpro_members_list_user_link", $userlink, $theuser); echo $userlink; ?> display_name;?> membership?> user_registered))?> enddate) echo date(get_option('date_format'), $auser->enddate); else echo "Never"; ?>

.

ID)) { $visits = $current_user->pmpro_visits; if(empty($visits)) $visits = array("last"=>"N/A", "month"=>0, "alltime"=>0); //track logins for user $visits['last'] = date(get_option("date_format")); $visits['alltime']++; $thismonth = date("n"); if($thismonth == $visits['thismonth']) $visits['month']++; else { $visits['month'] = 1; $visits['thismonth'] = $thismonth; } //update user data update_user_meta($current_user->ID, "pmpro_visits", $visits); } //track for all $visits = get_option("pmpro_visits"); if(empty($visits)) $visits = array("today"=>0, "month"=>0, "alltime"=>0); $visits['alltime']++; $thisdate = date("Y-d-m"); if($thisdate == $visits['thisdate']) $visits['today']++; else { $visits['today'] = 1; $visits['thisdate'] = $thisdate; } if($thismonth == $visits['thismonth']) $visits['month']++; else { $visits['month'] = 1; $visits['thismonth'] = $thismonth; } update_option("pmpro_visits", $visits); } add_action("wp", "pmpro_report_login_wp_visits"); //we want to clear the pmpro_visit cookie on login/logout function pmpro_report_login_clear_visit_cookie() { if(isset($_COOKIE['pmpro_visit'])) unset($_COOKIE['pmpro_visit']); } add_action("wp_login", "pmpro_report_login_clear_visit_cookie"); add_action("wp_logout", "pmpro_report_login_clear_visit_cookie"); //track views function pmpro_report_login_wp_views() { //don't track admin if(is_admin()) return; global $current_user; //track for user if(!empty($current_user->ID)) { $views = $current_user->pmpro_views; if(empty($views)) $views = array("last"=>"N/A", "month"=>0, "alltime"=>0); //track logins for user $views['last'] = date(get_option("date_format")); $views['alltime']++; $thismonth = date("n"); if(isset($views['thismonth']) && $thismonth == $views['thismonth']) $views['month']++; else { $views['month'] = 1; $views['thismonth'] = $thismonth; } //update user data update_user_meta($current_user->ID, "pmpro_views", $views); } //track for all $views = get_option("pmpro_views"); if(empty($views)) $views = array("today"=>0, "month"=>0, "alltime"=>0); $views['alltime']++; $thisdate = date("Y-d-m"); if($thisdate == $views['thisdate']) $views['today']++; else { $views['today'] = 1; $views['thisdate'] = $thisdate; } $thismonth = date("n"); if(isset($views['thismonth']) && $thismonth == $views['thismonth']) $views['month']++; else { $views['month'] = 1; $views['thismonth'] = $thismonth; } update_option("pmpro_views", $views); } add_action("wp", "pmpro_report_login_wp_views"); //track logins function pmpro_report_login_wp_login($user_login) { //get user data $user = get_user_by("login", $user_login); $logins = $user->pmpro_logins; if(empty($logins)) $logins = array("last"=>"N/A", "month"=>0, "alltime"=>0); //track logins for user $logins['last'] = date(get_option("date_format")); $logins['alltime']++; $thismonth = date("n"); if($thismonth == $logins['thismonth']) $logins['month']++; else { $logins['month'] = 1; $logins['thismonth'] = $thismonth; } //update user data update_user_meta($user->ID, "pmpro_logins", $logins); //track logins overall $logins = get_option("pmpro_logins"); if(empty($logins)) $logins = array("today"=>0, "month"=>0, "alltime"=>0); $logins['alltime']++; $thisdate = date("Y-d-m"); if($thisdate == $logins['thisdate']) $logins['today']++; else { $logins['today'] = 1; $logins['thisdate'] = $thisdate; } if($thismonth == $logins['thismonth']) $logins['month']++; else { $logins['month'] = 1; $logins['thismonth'] = $thismonth; } update_option("pmpro_logins", $logins); } add_action("wp_login", "pmpro_report_login_wp_login");