How can I display all Multisite blogs where this user is administrator?
The capabilities are stored as user meta data in a serialized array for each site. The key as a regular expression would look like that: ‘~’ . $GLOBALS[‘wpdb’]->base_prefix . ‘(\d+)_capabilities~’ So … get the user meta data, find the capability strings (they hold the roles), and compare the unserialized result with the role you want … Read more