On blogs page, display users of blogs

On Users page, display blogs of users.
Display array options of blogs as disabled text areas.


git-svn-id: http://svn.automattic.com/wordpress-mu/trunk@63 7be80a69-a1ef-0310-a953-fb0f7c49ff36

1 files changed, 13 insertions, 0 deletions

diff --git a/wp-inst/wp-includes/wpmu-functions.php b/wp-inst/wp-includes/wpmu-functions.php
index 2163cca..45368cb 100644
--- a/wp-inst/wp-includes/wpmu-functions.php
+++ b/wp-inst/wp-includes/wpmu-functions.php
@@ -772,4 +772,17 @@ function restore_current_blogid() {
     $wpdb->postmeta = $tmpoldblogdetails[ 'postmeta' ];
     $wpdb->prefix = $tmpoldblogdetails[ 'prefix' ];
 }
+
+function get_users_of_blog( $id ) {
+    global $wpdb, $wpmuBaseTablePrefix;
+    $users = $wpdb->get_results( "SELECT user_id, user_login FROM $wpdb->users, $wpdb->usermeta WHERE " . $wpdb->users . ".ID = " . $wpdb->usermeta . ".user_id AND meta_key LIKE '" . $wpmuBaseTablePrefix . $id . "%capabilities'" );
+    return $users;
+}
+
+function get_blogs_of_user( $id ) {
+    global $wpdb, $wpmuBaseTablePrefix;
+    $blogs = $wpdb->get_results( "SELECT domain, REPLACE( REPLACE( meta_key, '$wpmuBaseTablePrefix', '' ), '_capabilities', '' ) as userblog_id  FROM $wpdb->blogs, $wpdb->usermeta WHERE $wpdb->blogs.blog_id = REPLACE( REPLACE( $wpdb->usermeta.meta_key, '$wpmuBaseTablePrefix', '' ), '_capabilities', '' ) AND user_id = '$id' AND meta_key LIKE '%capabilities'" );
+
+    return $blogs;
+}
 ?>