/** * Widget Output. * @see WP_Widget::widget() */ public function widget($args, $instance) { global $wpdb; extract($args, EXTR_SKIP); $number = (int) $instance['number']; if (1 > $number) { $number = 5; } elseif (20 < $number) { $number = 20; } echo $before_widget; if (!empty($instance['title'])) { echo $before_title . $instance['title'] . $after_title; } echo '<ul>'; $subquery = aoc_roles_subquery(); $query = "SELECT ID, user_login, display_name FROM ( {$subquery} ) AS usr " . "ORDER BY user_registered DESC " . "LIMIT 0,{$number};"; $users = $wpdb->get_results($query); foreach ($users as $user) { echo '<li>'; if ($instance['avatar']) { echo get_avatar($user->ID, $instance['avatar-size']); } echo '<a href="' . aoc_profile_link(urlencode($user->user_login)) . '">' . $user->display_name . '</a></li>'; } echo '</ul>'; echo $after_widget; }
/** * Widget Output. * @see WP_Widget::widget() */ public function widget($args, $instance) { global $wpdb; extract($args, EXTR_SKIP); $number = (int) $instance['number']; if (1 > $number) { $number = 5; } elseif (20 < $number) { $number = 20; } echo $before_widget; if (!empty($instance['title'])) { echo $before_title . $instance['title'] . $after_title; } echo '<ul>'; $subquery = aoc_roles_subquery(); $query = "SELECT ID, user_login, display_name FROM {$wpdb->usermeta} INNER JOIN ( {$subquery} ) AS usr " . "ON {$wpdb->usermeta}.user_id = usr.id " . "WHERE {$wpdb->usermeta}.meta_key='akucom_gallery_update' " . "ORDER BY {$wpdb->usermeta}.meta_value DESC " . "LIMIT 0,{$number};"; $users = $wpdb->get_results($query); foreach ($users as $user) { echo '<li>'; if ($instance['avatar']) { echo get_avatar($user->ID, $instance['avatar-size']); } echo '<a href="' . aoc_create_link('gallery', urlencode($user->user_login)) . '">' . $user->display_name . '</a></li>'; } echo '</ul>'; echo $after_widget; }