Kempwire Forums » Topic: How to use in Wordpress MU

Kempwire Forums » Topic: How to use in Wordpress MU http://kempwire.com/bb/topic/how-to-use-in-wordpress-mu Just another bbPress community en-US Sat, 11 Sep 2010 02:55:13 +0000 http://bbpress.org/?v=1.0.2 <![CDATA[Search]]> q http://kempwire.com/bb/search.php macavitycat on "How to use in Wordpress MU" http://kempwire.com/bb/topic/how-to-use-in-wordpress-mu#post-80 Sun, 04 Jul 2010 14:03:42 +0000 macavitycat 80@http://kempwire.com/bb/ Not sure if this is useful for anyone else, but I needed to make another change, after I upgraded to Wordpress 3.0 The capabilities metakey is different for roles in Wordpress 3.0 (I couldn't track down the reason). There is another ':"1"' at the end of each one; i.e. '{s:13:"administrator";s:1:"1";}' for administrator. I had to amend the two arrays to add that extra 4 characters to each role. This change is only for newly created users, or existing users that had their role changed after the upgrade to 3.0 (admin to subscriber, subscriber to contributor, etc.) I had to move all my previous users to subscriber and back to their original role, so that all the users (new and old) were listed in the database in the same way. I'm not an expert at this, but I think this is a diff file of the changes from wp-users.php (V1.1) to the version that works for me. <code>--- /var/www/blogs/wp-content/plugins/wordpress-users/wp-users.php_file 2010-06-25 19:28:57.000000000 +0100 +++ /var/www/blogs/wp-content/plugins/wordpress-users/wp-users.php 2010-06-25 21:15:09.000000000 +0100 @@ -49,7 +49,7 @@ $editor = get_option('wpu_roles_editor'); $contributor = get_option('wpu_roles_contributor'); - $rolelist = array('\'a:1:{s:13:\"administrator\";b:1;}\''=>$administrator, '\'a:1:{s:10:\"subscriber\";b:1;}\''=>$subscriber, '\'a:1:{s:6:\"author\";b:1;}\''=>$author, '\'a:1:{s:6:\"editor\";b:1;}\''=>$editor, '\'a:1:{s:11:\"contributor\";b:1;}\''=>$contributor); + $rolelist = array('\'a:1:{s:13:\"administrator\";s:1:"1";}\''=>$administrator, '\'a:1:{s:10:\"subscriber\";s:1:"1";}\''=>$subscriber, '\'a:1:{s:6:\"author\";s:1:"1";}\''=>$author, '\'a:1:{s:6:\"editor\";s:1:"1";}\''=>$editor, '\'a:1:{s:11:\"contributor\";s:1:"1";}\''=>$contributor); $roles = array(); @@ -62,7 +62,7 @@ } if (empty($roles)) - $roles = array('\'a:1:{s:13:\"administrator\";b:1;}\'', '\'a:1:{s:10:\"subscriber\";b:1;}\'', '\'a:1:{s:6:\"author\";b:1;}\'', '\'a:1:{s:6:\"editor\";b:1;}\'', '\'a:1:{s:11:\"contributor\";b:1;}\''); + $roles = array('\'a:1:{s:13:\"administrator\";s:1:"1";}\'', '\'a:1:{s:10:\"subscriber\";s:1:"1";}\'', '\'a:1:{s:6:\"author\";s:1:"1";}\'', '\'a:1:{s:6:\"editor\";s:1:"1";}\'', '\'a:1:{s:11:\"contributor\";s:1:"1";}\''); //create a string for use in a MySQL statement $roles = implode(', ', $roles); @@ -86,8 +86,11 @@ // Get the authors from the database ordered by user nicename global $wpdb; + global $blog_id; $roles = wpu_get_roles(); - $query = "SELECT ID, user_nicename FROM $wpdb->users WHERE ID = ANY (SELECT user_id FROM $wpdb->usermeta WHERE meta_value IN ($roles)) ORDER BY user_nicename LIMIT $offset, $usersPerPage"; + + $wpcaps = '\'cb_'.$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); @@ -105,7 +108,7 @@ 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))"); + $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)"); // how many pages we have when using paging? $maxPage = ceil($user_count/$usersPerPage); </code> macavitycat on "How to use in Wordpress MU" http://kempwire.com/bb/topic/how-to-use-in-wordpress-mu#post-69 Sun, 29 Nov 2009 12:03:47 +0000 macavitycat 69@http://kempwire.com/bb/ 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). <code>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)");</code> macavitycat on "How to use in Wordpress MU" http://kempwire.com/bb/topic/how-to-use-in-wordpress-mu#post-68 Sat, 28 Nov 2009 21:45:54 +0000 macavitycat 68@http://kempwire.com/bb/ 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