Add role across network in multisite

This is my experience.

I had to add role for each site in WordPress, I developed an add page in dashboard so the site administrator can add the self-defined role/capabilities.

But I found the $wp_roles->add_role, add_cap only works the subsite. So I did some fix,

I’ve made a plugin, the super-admin(not site administrator but the “admin”) can “Network Activate” in dashboard

xxx/wp-admin/network/plugins.php

the self-defined role/capabilities was saved in role.ini file, the plugin can create two table named wp_s_role and wp_s_cap, The pre-self-defined role/capabilities will insert into the table.

Then the $wp_roles->add_role and add_cap can across the network and insert the role/capabilities to all subsites.

But the subsite administrator must add the self-defined role/capabilities and make it works in all subsites, so I create a trigger for 

    register_activation_hook(__FILE__, array($s_role, 'install'));
    register_deactivation_hook(__FILE__, array($s_role, 'uninstall'));

Then the uninstall function works, all the two tables data will be saved into the role.ini file again, after that, the install function will works again. and all self-defined role/capabilities was added into all subsites.

As you see, I made a trigger in order to add the self-defined role into all subsites, but the effectivity is very low, the plugin restart will take more than 5 seconds. So I’ve improve the methods, This time, when the add_role function is done, I copied the subsite role/capabilities into the others subsites.

Some steps:

  • In subsites, when the administrator add the role, I use $blog_id and $table_prefix to get a subsite table wp_2_options contents. (We assumed the blog_id is 2 and the table_prefix is wp).

  • I select the option_name=wp_2_user_roles 

    result($wpdb->get_row("select `option_value` from `wp_2_options` where `option_name`='wp_2_user_roles'", ARRAY_A);),

then I foreach the blogs and get the subsite table. So I insert the select result into each subsite table(wp_n_options) and the main table(wp_options), muhaha, am I smart enough? : )

The below function is how to remove the self-defined roles in all subsites. I think it’s would helpful with you.

public function reset_subsite_role_cap()
{
    //select * from `wp_options` where `option_name` = 'wp_user_roles';
    //select * from `wp_options` where `option_name` = 'wp_backup_user_roles';
    //select * from `wp_3_options` where `option_name` = 'wp_3_user_roles';
    //select * from `wp_4_options` where `option_name` = 'wp_4_user_roles';
    //select * from `wp_5_options` where `option_name` = 'wp_5_user_roles';
    global $wpdb;
    $sql = "select * from ".$wpdb->blogs;
    $multisite_info = $wpdb->get_results($sql, ARRAY_A);
    $site_result = array();
    if (!empty($multisite_info) && is_array($multisite_info)) {
        foreach ($multisite_info as $k => $v) {
            $site_result[$v['blog_id']] = trim($v['path'], "https://wordpress.stackexchange.com/");
        }
    }

    global $table_prefix;
    $tp_arr = explode('_', $table_prefix);
    $table_arr = array();
    foreach ($site_result as $blog_id => $site_name) {
        if ($blog_id !== 1) {
            $table_arr[$tp_arr[0].'_'.$blog_id.'_options'] = $tp_arr[0].'_'.$blog_id.'_user_roles';
        } else {
            $table_arr[$tp_arr[0].'_options'] = $tp_arr[0].'_user_roles';
        }
    }

    // get the backup user roles.
    $backup_roles_result = $wpdb->get_row("select `option_value` from `".$tp_arr[0]."_options` where `option_name`='wp_backup_user_roles'", ARRAY_A);

    // clean the others role cap
    if (isset($table_arr) && is_array($table_arr)) {
        foreach ($table_arr as $table_role_cap_name => $table_role_cap_filed) {
            $wpdb->update(
                $table_role_cap_name,
                array('option_value' => $backup_roles_result['option_value']),
                array('option_name' => $table_role_cap_filed)
            );
        }
    }
    return true;
}

For the $site_result, I have another function to fetch all exact site info.

/**
 * Get the all site info.
 *
 * @param integer $id BlogID.
 *
 * @return array array('blog_id' => 'path', '1' => 'printsolv', '2' => 'govsolv')
 */
public function s_get_multisite_info($id = null)
{
    global $wpdb;
    $where="1=1";
    if (isset($id)) {
        $sql = "select * from ".$wpdb->blogs." where `blog_id`="."'".$id."'";
    } else {
        $sql = "select * from ".$wpdb->blogs." where 1=1 ";
    }
    $multisite_info = $wpdb->get_results($sql, ARRAY_A);
    $result = array();
    if (!empty($multisite_info) && is_array($multisite_info)) {
        // clean the path, > 1 means not http://site_name/theme.php but http://site_name/path_name/theme.php
        if (isset($id)) {
            $site_info = $wpdb->get_row("select * from ".$wpdb->site." where `id`="."'".$multisite_info[0]['site_id']."'", ARRAY_A);
        } else {
            $site_info = $wpdb->get_row("select * from ".$wpdb->site, ARRAY_A);
        }

        $site_path_status = false; // path= /
        if (isset($site_info['path']) && strlen(trim($site_info['path'], "https://wordpress.stackexchange.com/")) > 1 ) {
            // site have path./xxx/
            $site_path_status = true;
        }

        foreach ($multisite_info as $k => $v) {
            if (isset($site_info['domain']) && $site_info['domain'] == $v['domain']) {
                if ($site_path_status == true) {
                    $result[$v['blog_id']] = trim(substr($v['path'], strlen(trim($site_info['path'], "https://wordpress.stackexchange.com/")) + 1), "https://wordpress.stackexchange.com/");
                } else {
                    $result[$v['blog_id']] = trim($v['path'], "https://wordpress.stackexchange.com/");
                }
            }
        }
    }
    return $result;
}

I have just finished the function and it works perfectly. You can use s_copy_site_role_cap() to call. The function can copy the role into others subsite roles after you add_role. Because the plugin might works in main site or subsite, there will have two ways in network(subdomain, subpath) , so i made another function to get the right current blog_name , so I can get the lastest roles contents from the blog_name information.

/**
 * Copy the subsite role/caps to all subsites and main site..
 *
 * @param string $subsite_name SubSite Name.
 *
 * @return boolean.
 */
public function s_copy_site_role_cap()
{
    global $wpdb;
    // Get all site info 
    $multisite_info = $this->s_get_multisite_info();

    global $table_prefix;
    $tp_arr = explode('_', $table_prefix);
    // Get all site wp_x_options table. and table filed.
    $table_arr = array();
    foreach ($multisite_info as $blog_id => $site_name) {
        if ($blog_id !== 1) {
            $table_arr[$tp_arr[0].'_'.$blog_id.'_options'] = $tp_arr[0].'_'.$blog_id.'_user_roles';
        } else {
            $table_arr[$tp_arr[0].'_options'] = $tp_arr[0].'_user_roles';
        }
    }
    // select the blog id by blog name.
    $subsite_name = $this->s_get_dashboard_site_name();
    $subsite_id = array_search($subsite_name, $multisite_info);
    if ($subsite_id === false) {
        return false;
    }
    $current_site_table_pre = $tp_arr[0].'_'.$subsite_id;
    // get the current subsite roles.
    $subsite_roles = $wpdb->get_row("select `option_value` from `".$current_site_table_pre."_options` where `option_name`='".$current_site_table_pre."_user_roles'", ARRAY_A);

    if (isset($table_arr) && is_array($table_arr)) {
        foreach ($table_arr as $table_role_cap_name => $table_role_cap_filed) {
            if ($table_role_cap_name != $current_site_table_pre.'_options') {
                $wpdb->update(
                    $table_role_cap_name,
                    array('option_value' => $subsite_roles['option_value']),
                    array('option_name' => $table_role_cap_filed)
                );
            }
        }
    }
    return true;
}

/**
 * Get dashboard site name.
 *
 * @return string. SiteName
 */
public function s_get_dashboard_site_name()
{
    $dashboard_url = admin_url();

    //$dashboard_url = "http://xxx/wp-admin/";
    //$dashboard_url = "http://subsite_name.xxx/wp-admin/";
    //$dashboard_url = "http://xxx/subsite_name/wp-admin/";

    // get main site name.
    $site_name = get_current_site()->domain;
    $parse_url = parse_url($dashboard_url);
    if (!is_subdomain_install()) {
        // base path  http://xxx/wp-admin/
        // subsite path http://xxx/subsite_name/wp-admin/
        if ($parse_url['path'] == "/wp-admin/") {
            return $site_name;
        } else {
            $tmp_url = explode("https://wordpress.stackexchange.com/", trim($parse_url['path'], "https://wordpress.stackexchange.com/"));
            return $tmp_url[0];
        }
    } else {
        // base domain  http://xxx/wp-admin/
        // subsite domain  http://subsite_name.xxx/wp-admin/
        if ($parse_url['host'] == $site_name) {
            return $site_name;
        } else {
            $tmp_url = explode(".", $parse_url['host']);
            return $tmp_url[0];
        }
    }

}

Thanks.

Related Posts:

  1. Where are available Roles Defined in the wp_ database?
  2. Why are my roles not visible in a Multi-site/Network?
  3. Site admin in a network install can’t edit users?
  4. Troubleshooting a “You do not have sufficient permissions to access this page” error
  5. Issue with Custom Roles in Multisite
  6. How to enable a site administrator to edit users in a WordPress network/ multisite setup?
  7. How can I display all Multisite blogs where this user is administrator?
  8. Restrict users on multisite WordPress install
  9. Possible to make custom role in multisite that can add sites?
  10. Prevent user creating new users with specific roles
  11. WordPress Multisite Layered Admins
  12. How To Remove Dashboard Menu Items for Multisite Users?
  13. How to get a user role of a specific blog in multisite?
  14. Can wp-cli display all users and their roles across all sites in a multisite instance?
  15. Can simple Admin save options in a Multisite?
  16. Identical members roles on all sites in a multisite
  17. WPMU – new users are automatically subscribed to the main blog – how to prevent that?
  18. create_users capabilities on a role on multisite
  19. Within the database, where is the flag which says that a user has Super Admin rights?
  20. Update User Role Across Network when Main Site User is Updated
  21. Assign role to user on first login, if they are first (after admin)
  22. Avoid having infinite loops
  23. Get the User ID Who Owns a Given Blog ID in Multisite
  24. Create custom role, multisite, add users/sites?
  25. Make a user administrator to a sub directory site and a contributor to main site in multisite network
  26. access the plugins for each role in WordPress multisite
  27. How to change user starting role in WordPress MultiSite?
  28. Allow Author on Site A capability to upload files on Site B in Multi Site
  29. Multisite user roles – capabilities not working
  30. Create Custom Multisite User Role to Reduce Capabilities
  31. Restrict Capability of Administrator to Create, Edit and Delete Pages in Multisite
  32. Admin permission for creating blogs in multisite
  33. Remove superadmin role from the “change role to” menu in user listing
  34. Copy user role on multisite so the user can access subsites with same role
  35. How to change a user role after registering in multisite?
  36. How to sync roles across Multisite?
  37. Multisite network admin – User’s role not showing up
  38. WordPress Multisite Add User
  39. WordPress multisite, allow non super admins to create sites
  40. WPMU If MU site has no administrator, deactivate site
  41. Give users acces to admin a single post or set up WP network?
  42. can’t create user without email for an author after converting single site to multisite
  43. Easily adding multiple existing users to a multisite site
  44. Language per user role, how can I achieve this?
  45. Admin users not able to see network menus
  46. let user select roles in the wordpress subsites
  47. Redirect a user roll to a page after login in mutlisite network
  48. User Roles in multisite – odd behavior
  49. WordPress single sign on using cookies with shared user role functionality between more than 2 wordpress subdomains
  50. A different role for each site in a multisite
  51. Multisite error when adding a user: already a member of this site
  52. How to create child/sub user under parent user
  53. How create a multisite setup with “phantom” accounts and passwords?
  54. Multisite vs Role Scoper
  55. Get users from all/specific blog by user_role and current_user role
  56. Is there any way to give all users access to one blog in a multisite network without using a plugin?
  57. How can I display all Multisite blogs where this user is administrator?
  58. How to give “author” user role appropriate capabilities to add PollDaddy polls? WordPress multisite
  59. Multisite and users being listed on network administration dashboard and not main site dashboard
  60. Programmatically create blogs with dummy content on a WPMU site
  61. How to individually set WP_DEBUG on a sub-directory multisite?
  62. How to Set up a Multisite WordPress?
  63. Is it still only possible to do multisite domain mapping with a plugin in WordPress 4.1?
  64. How to get max upload size and accepted file types on multisite?
  65. Split a database will improve performance?
  66. Why are images not displaying?
  67. Multisite Upload URL?
  68. Forgot your password points to main blog on multisite install [duplicate]
  69. How to use same email for multiple users in Multisite version 4.7
  70. How is a user’s primary blog determined?
  71. Master Site for specific taxonomy in MultiSite
  72. Multisite favicon.ico
  73. Why can’t I login to my “network sites”?
  74. Create a database for each site created in multisite?
  75. Adding a existing developed site to a multisite installation of WordPress
  76. How can i define the order of blogs in a multisite network manually (like pages)?
  77. How can I hide certain sidebars from some users?
  78. Hosting 2 WordPress websites in /public_html/ & /public_html/subdirectory/ at the same time
  79. wp_get_attachment_image_src returns incorrect URL on multisite
  80. Locking one blog of many in a multi user/blog WordPress installation
  81. How do I disable XML-RPC in WordPress Multisite?
  82. How to modify wp_config file for set up subdirectory?
  83. Activation Account Email
  84. How to automatically translate plugin using translate.wordpress.org
  85. May I do multiple micro-sites with different themes in a single wordpress without subdirectory nor subdomain separation?
  86. Multisite htaccess file causing segfault (Segmentation fault 11)
  87. Multisite Smtp Server
  88. Images uploaded after adding multisite do not get loaded in any domain of the multisite network
  89. When hooking wp-cron to system
  90. WordPress network, add extra directory to subsite urls
  91. Register a user only to the root blog – WP Multisite
  92. Update Same Contents on every Page
  93. WooCommerce API Returns 401
  94. Define default settings for new sites on multisite network with mu-plugin
  95. MU domain mapping without using a plugin
  96. Multisite authorization error 401
  97. is there a if multisite have posts function?
  98. Multisite – mix sites that use subdomains with sites that use paths
  99. Pick your brain on wp-config.php if statement for multisite
  100. WordPress Multisite restict user access

Leave a Comment