In wp-config.php for your second site, define the following two constants: define(‘CUSTOM_USER_TABLE’, ‘yourfirstprefix_users’); define(‘CUSTOM_USERMETA_TABLE’, ‘yourfirstprefix_usermeta’); You’ll have to add some custom logic to your second site limiting logins by user role.
In the users table the primary key should be ID (auto-increment) and the user_login, user_nicename and user_email fields should be indexed. In the usermeta table the umeta_id should be primary key (auto-increment) and the umeta_id and meta_key fields should be indexed.
To achieve this, you first need to get all the current user roles, X and Y(s)… function get_current_user_roles(){ global $wp_roles; $current_user = wp_get_current_user(); $user_groups = groups_get_user_groups( $current_user->ID ); $user_roles = isset( $current_user->roles[‘X’] ) ? array( ‘X’ ) : array(); // Let’s get all Y dynamic user roles… foreach ( $user_groups[‘groups’] as $id ) { $group … Read more
This Should Work? ALTER TABLE wp_usermeta ADD COLUMN old_user_id bigint(20) unsigned; INSERT INTO wp_usermeta (old_user_id) SELECT u.id FROM wp_users AS u; INSERT INTO wp_usermeta (user_id, meta_key, meta_value) SELECT u.id, ‘wp_2_capabilities’, meta_value JOIN wp_users AS u ON u.user_id = u.old_user_id; ALTER TABLE wp_users DROP COLUMN old_user_id;
Correct usage: $arr = array(‘[email protected]’,’[email protected]’); in_array($user->user_email, $arr)
What you are doing is not a valid way of retrieving and checking serialize data from the WP. You may insert array as a user meta but this array behind the scenes is transformed to serialize string something the MySql can handle. There are options for searching with the LIKE operator but I don’t endorse … Read more
Try this: function thebroker_agents() { global $current_user; $bmail = $current_user->user_email; $user_query = new WP_User_Query( array( ‘meta_key’ => ‘broker_email’, ‘meta_value’ => $bmail, ‘fields’ => ‘all’ ) ); $users = $user_query->get_results(); if (!empty($users)) { $results=”<ul>”; foreach ($users as $user){ $results=”<li>” . $user->display_name . ‘</li>’; } $results=”</ul>”; } else { $results=”No users found”; } wp_reset_postdata(); return $results; } … Read more
You can hook into the user_register action hook and lower case the strings manually, by using the wp_update_user function. Here’s a quick example: add_action( ‘user_register’, ‘callback_function’, 10, 1 ); function callback_function( $user_id ) { // Get the user by their ID $user = get_user_by( ‘id’, $user_id ); // Update their user_login wp_update_user( array( ‘ID’ => … Read more
This process is pretty straightforward. Add the following pieces of code to the current ( preferably child ) theme’s functions.php. Step 1 – add new column to the users table list: function wpse_add_user_table_list_column($column) { $column[‘call_sign’] = ‘Call Sign’; return $column; } add_filter(‘manage_users_columns’, ‘wpse_add_user_table_list_column’); Step 2 – make this new column sortable: function wpse_user_table_list_sortable_columns($columns) { $columns[‘call_sign’] … Read more
That action doesn’t pass that data: function return_user_data_on_logout( $user ) { Here, $user will alway be undefined. Additionally, you need to tell add_action how many parameters the function takes. But.. do_action( ‘clear_auth_cookie’ ); No information is passed to begin with, that’s not how this particular event/action works. So how do we get the current user … Read more