__( 'A widget with collapsible feature which displays posts by authors. ', 'text_domain' ), ) // Args ); } public function widget( $args, $instance ) { // outputs the content of the widget global $wpdb; $limit_posts = ($instance['number']>0?$instance['number']:''); $html = '

Authors

'; $table = $wpdb->prefix . 'users'; $users = $wpdb->get_results('SELECT ID FROM '.$table.' ORDER BY user_login'); if(!empty($users)){ foreach($users as $results){ $id = $results->ID; $user_info = get_userdata($id); $table = $wpdb->prefix . 'posts'; $result = $wpdb->get_results('SELECT * FROM '.$table.' WHERE post_author = '.$id.' AND post_status = "publish" AND post_type = "post" ORDER BY post_date DESC '.($limit_posts!=''?'LIMIT 0,'.$limit_posts:'')); $i = 0; if(!empty($result)){ $html .= '

'.$user_info->first_name.' '.$user_info->last_name.' ('.count($result).')'; $html .= '

'.$numpost->post_title.''; if($excerpt == 'true'){ $html .= '
'.$numpost->post_excerpt.'
'; } $html .= '

'; } } } $html .= '

'; echo $html; } public function form( $instance ) { // outputs the options form on admin $title = isset( $instance['title'] ) ? esc_attr( $instance['title'] ) : ''; $number = isset( $instance['number'] ) ? absint( $instance['number'] ) : 5; ?>