From 44f252fd65703cdcbfcf4d6668007ec67f3cb5ce Mon Sep 17 00:00:00 2001 From: donncha Date: Thu, 21 Jul 2005 14:43:02 +0000 Subject: 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 --- wp-inst/wp-includes/wpmu-functions.php | 13 +++++++++++++ 1 file changed, 13 insertions(+) (limited to 'wp-inst/wp-includes') 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; +} ?> -- cgit