Hello,
Below is a PHP code for an author plugin I have on my site getyourfilmfix.com. I’m trying to change to order of the authors and any attempt simply clears the list. Currently it seems to only sort them alphabetically by display name.
Any help would be appreciated.
/** @todo Move select to get_authors().
SELECT hkwd_wp_users.ID, hkwd_wp_users.user_nicename, hkwd_wp_usermeta.user_id, hkwd_wp_usermeta.meta_value FROM hkwd_wp_users, hkwd_wp_usermeta WHERE hkwd_wp_users.ID = hkwd_wp_usermeta.user_id AND hkwd_wp_usermeta.meta_key = ‘hkwd_wp_user_level’
*/
$authors = $wpdb->get_results(“SELECT $wpdb->users.ID, $wpdb->users.user_nicename, $wpdb->usermeta.meta_value FROM $wpdb->users, $wpdb->usermeta WHERE $wpdb->users.ID = $wpdb->usermeta.user_id AND $wpdb->usermeta.meta_key = ‘”.$wpdb->prefix.”user_level’ ” . ($exclude_admin ? “AND user_login <> ‘admin’ ” : ”) . “ORDER BY display_name”);