Kempwire Forums

Just another bbPress community

1. 

   macavitycat
   Member

   Hi,

   I've got a normal WP blog, which I'd like to move to Wordpress MU. But I'm having trouble getting the 'Wordpress Users' plugin to display only the users for the blog being looked at. At the moment it shows all the users registered on all blogs, rather than just the one I am looking at. Unfortunately I can't quite work out how to filter out the other users. The two options I can see are;

   1) adding another clause to the SQL query, to require 'meta_key = wp_[blog id]_user_level', or
   2) adding an 'if' clause somewhere using the built in functions like 'is_user_member_of_blog'.

   I think the second one would work for both WP and WPMU, so I'd rather try that approach. Has anyone tried doing this themselves?

   Cheers

   Posted 3 months ago #
2. 

   macavitycat
   Member

   Managed to work it out (but I'm just planning to use it for 10-20 blogs, so might be done more efficiently).

   I'm a beginner, so was getting confused by get_users_of_site which was giving me all users for all blogs. I added an 'AND' clause to the SQL query to find users who have an entry for meta_key 'wp_[blog_id]_capabilities' in the usermeta table.

   It seems ok, but would welcome any corrections or alternatives (that would be ok in both WP and WPMU).

   function display_user_list() {
[...]

   // Get the authors from the database ordered by user nicename
   global $wpdb;
   global $blog_id;
   $roles = wpu_get_roles();

   $wpcaps = '\'wp_'.$blog_id.'_capabilities\'';
   $query = "SELECT ID, user_nicename FROM $wpdb->users WHERE ID = ANY (SELECT user_id FROM $wpdb->usermeta WHERE meta_value IN ($roles) and meta_key = $wpcaps) ORDER BY user_nicename LIMIT $offset, $usersPerPage";
   $author_ids = $wpdb->get_results($query);

   $output = '';

   // Loop through each author
   foreach($author_ids as $author) {

   // Get user data
   $curauth = get_userdata($author->ID);

   $output .= get_user_listing($curauth);
   }

   echo $output;

   // how many rows we have in database
$user_count = $wpdb->get_var("SELECT COUNT(ID) FROM $wpdb->users WHERE ID = ANY (SELECT user_id FROM $wpdb->usermeta WHERE meta_value IN ($roles) and meta_key = $wpcaps)");

   Posted 3 months ago #

RSS feed for this topic

Reply

You must log in to post.