[wp-trac] [WordPress Trac] #15467: Multisite with separate users table

[WordPress Trac]

#15467: Multisite with separate users table
-----------------------------+----------------------
 Reporter:  fale             |       Owner:
     Type:  feature request  |      Status:  closed
 Priority:  normal           |   Milestone:
Component:  Multisite        |     Version:  3.0.1
 Severity:  normal           |  Resolution:  wontfix
 Keywords:  close            |
-----------------------------+----------------------

Comment (by lightningspirit):

 Between yesterday and today I made a draft of what could be a plugin to
 achieve this functionality.

 I think I did it! :)

 NOTE: Use this method in test environments only! It is not stable enough
 (and I think it will never be...)

 '''Description:'''
 Those two files ( sunrise.php and blog-user-table.php ) can create
 separated user tables for each blog in a multisite instalation.
 It lacks the possibility of creating users inside a blog, even if the
 netwok option is enabled, but I think it might be an issue related to
 capabilities.

 It actually performs what it is expected: separate users for each blog!

 '''Issues:'''
 - one have to create the users manually in MySQL tables due to a
 capability issue that I wasn't able to seek.
 - Network panel just shows users from the global table (don't know if this
 is really an issue)

 Those files could be the first steps to "recreate" this functionality with
 a plugin in WordPress I think...

 '''Instalation:'''
 0. Install a WordPress 3.4 from the trunk - make sure it is used just as a
 test instance
 0. Create at least a blog in your multisite test install
 1. sunrise.php goes to wp-content/ directory
 2. blog-user-tables.php goes to wp-content/mu-plugins/ directory
 3. Put {{{define('SUNRISE', true);}}} in wp-config.php file
 4. Using SQL in a MySQL browser (like phpmyadmin) copy an existing or
 create a new user inside wp_2_users and wp_2_usermeta (change the
 generated SQL as necessary)
 5. Try to login with the new account in the new blog

 Tested in a local instalation of a Multisite WordPress 3.4 (trunk).

 '''No security tests made! Please, avoid to use it in production sites.'''

 Have fun! :)

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/15467#comment:19>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software