WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Displaying random authors while excluding admin role (7 posts)

  1. Troy Chaplin
    Member
    Posted 2 years ago #

    I'm trying to run a loop on my homepage where 3 random user profiles will be displayed. I found the following in the forums, which works almost exactly how I want: http://wordpress.org/support/topic/display-random-authors-on-homepage?replies=16

    However, I'm not quite sure how I would edit this to exclude any user profiles that are set as the administrator role.

    Any help from the community would be greatly appreciated. My code is as follows:

    <?php
    $uid = $wpdb->get_col("SELECT ID FROM $wpdb->users WHERE user_status = 0");
    shuffle($uid);
    array_rand($uid);
    
    for($someNumber = 1; $someNumber <= 3; $someNumber++) {
    
    $userID = $uid[$someNumber]; ?>
    
    	<article>
    
            <h1><a href="<?php echo get_author_posts_url($userID); ?>" class="author"><?php the_author_meta( 'display_name', $userID ) ?></a></h1>
    
            <div class="postmeta"><a href="<?php echo get_author_posts_url($userID); ?>" class="author">View Author Bio</a></div>
    
    	</article>
    
    <?php } unset($uid,$userID); ?>
  2. vtxyzzy
    Member
    Posted 2 years ago #

    I think you can get what you want by changing the query to this:

    $uid = $wpdb->get_col("SELECT ID
    FROM $wpdb->users u, $wpdb->usermeta m
    WHERE user_status = 0
    AND u.ID = m.user_id
    AND m.meta_key = 'wp_capabilities'
    AND m.meta_value NOT LIKE 'administrator'");
  3. Troy Chaplin
    Member
    Posted 2 years ago #

    Thanks, but unfortunately this causes the 3 users being listed to all be the only administrator account for the site, none of the others are being included in the query.

  4. vtxyzzy
    Member
    Posted 2 years ago #

    Sorry, I didn't cut and paste the query I tested, and I should have. I made an error in retyping it. Please try this:

    $uid = $wpdb->get_col("SELECT ID
    FROM $wpdb->users u, $wpdb->usermeta m
    WHERE user_status = 0
    AND u.ID = m.user_id
    AND m.meta_key = 'wp_capabilities'
    AND m.meta_value NOT LIKE '%administrator%'");
  5. Troy Chaplin
    Member
    Posted 2 years ago #

    Unfortunately this has the same results as the first example you provided. My revised code, with old query commented out and your sample added in, looks like:

    <?php
    	// $uid = $wpdb->get_col("SELECT ID FROM $wpdb->users WHERE user_status = 0");
    
    	$uid = $wpdb->get_col("SELECT ID
    	FROM $wpdb->users u, $wpdb->usermeta m
    	WHERE user_status = 0
    	AND u.ID = m.user_id
    	AND m.meta_key = 'wp_capabilities'
    	AND m.meta_value NOT LIKE '%administrator%'");
    
    	shuffle($uid);
    	array_rand($uid);
    
    	for($someNumber = 1; $someNumber <= 3; $someNumber++) {
    	$userID = $uid[$someNumber];
    
    ?>
  6. vtxyzzy
    Member
    Posted 2 years ago #

    I added meta_value so I could easily check the results of the query. Here is the exact query that I tested:

    SELECT ID,meta_value
    FROM wp_users u, wp_usermeta m
    	WHERE user_status = 0
    	AND u.ID = m.user_id
    	AND m.meta_key = 'wp_capabilities'
    	AND m.meta_value NOT LIKE '%administrator%'

    Don't know why it works for me, but not for you.

  7. Troy Chaplin
    Member
    Posted 2 years ago #

    Strange. Thanks for the help! I'll keep looking for a solution, I also have another bit of similar code that works, except it only randomizes the first 3 people based on the alphabetical order of their last names, instead of randomizing from the entire list of users in the editor role:

    <?php
    
    	$args  = array(
    		'number' => 3,
    		// 'role' => 'editor',
    	);
    
    	global $wp_query;
    	$wp_query = new WP_User_Query($args);
    
    	// Get the results
    	$authors = $wp_query->get_results();
    
    	if ($authors) : shuffle ($authors);
    
    ?>
    
    <?php foreach ($authors as $author) : ?>
    
    <!-- DO STUFF -->
    
    <?php endforeach; ?>
    
    <?php endif; wp_reset_query(); ?>

Topic Closed

This topic has been closed to new replies.

About this Topic