Author Periodic Report


'administrator', 'orderby' => 'display_name', 'fields' => array('ID','display_name')); $admins = get_users($args); $args = array('role' => 'editor', 'orderby' => 'display_name', 'fields' => array('ID','display_name')); $editors = get_users($args); $args = array('role' => 'author', 'orderby' => 'display_name', 'fields' => array('ID','display_name')); $authors = get_users($args); $args = array('role' => 'contributor', 'orderby' => 'display_name', 'fields' => array('ID','display_name')); $contributors = get_users($args); foreach ($admins as $user) { $arr[]=array($user->ID,$user->display_name,'Admin',$this->get_numbers($user->ID,$time)); } foreach ($editors as $user) { $arr[]=array($user->ID,$user->display_name,'Editor',$this->get_numbers($user->ID,$time)); } foreach ($authors as $user) { $arr[]=array($user->ID,$user->display_name,'Author',$this->get_numbers($user->ID,$time)); } foreach ($contributors as $user) { $arr[]=array($user->ID,$user->display_name,'Contributor',$this->get_numbers($user->ID,$time)); } return $arr; } function get_numbers($author, $time) { global $wpdb; $sql = "SELECT count(ID) as c FROM ". $wpdb->posts . " WHERE post_author=". $author; $sql .= " and post_status='publish'"; if ($time) { $sql .= " and post_date LIKE '%".$time."%';"; } $res = $wpdb->get_row($sql); return $res->c; } } ?>