Found out you can pass the –exclude option to wp user list to exclude a user by their ID from the list. So let’s assume your user ID is 2 then you could do the following: wp user delete $(wp user list –field=ID –exclude=2) And just to be sure all content gets reassigned to you … Read more
Hi @Holidaymaine: Not sure where you are doing wrong, but try the following instead which is a self contained test.php file you can drop into the root of your website and load in your browser with http://yoursite.com/test.php (assuming you replace yoursite.com with your site’s domain! Also, note how I adding in a WHERE {$wpdb->usermeta}.meta_key = … Read more
I believe Crazycoolcam spelled the table incorrectly, user_meta vs usermeta. You may also want to define the else case, what happens if the table is not user. Try this: <?php $wpdb->add_database(array( //Connect to Users Database ‘host’ => DB_HOST, // I am using the same host for my two DBs ‘user’ => DB_USER, // I am … Read more
It looks like you’re using wrong parameters, please try this instead (untested): $q = new WP_User_Query( array( ‘role’ => ‘contributor’, ‘meta_query’ => array( ‘relation’ => ‘AND’, array( ‘key’ => ‘first_meta’, ‘value’ => ‘2’, ), array( ‘key’ => ‘second_meta’, ‘value’ => ”, ‘compare’ => ‘!=’ ) ) ) ); where we’ve used the key, value and … Read more
Quite a specific feature, never seen any plugin. But it’s a matter of taking a drag’n’drop plugin and adapting it. Here, a stripped and adapted version of My Link Order. Description and to-do: A new submenu is created in Users, My Users Order. In the plugin page, execute the function orderUsers() in your browser console, … Read more
A quick (and dirty) solution would be to prevent the final deletion where it happens (function delete_user). You could implement a little plugin or paste the code into your functions.php: <?php /* Plugin Name: Please don’t delete me! Description: Prevent accidental user deletion of my account */ define(‘PDDM_USER_ID’, 1); // User ID of your Account … Read more
The function needs an array with the parameters. See The Codex. Also, you map the parameter with the value: ex. ‘user_email’ => $_POST[‘user_email’]. In your example, the code would look like this: $user_id = (int) $_POST[ ‘ID’ ]; wp_update_user( array( ‘ID’ => $user_id, ‘user_email’ => $_POST[ ‘user_email’ ] ) ); Also, the important hint: you … Read more
For activation process you can follow following steps: As you can see user_activation_key column in wp_users table. You can make use of that column for sending user activation link. While signing up users you can insert certain code into that column with custom sql. After the user is signed up with wp_insert_user() and returns an … Read more
There is actually a plugin that offers this exact functionality: Polylang User Manager: Polylang User Manager will work with Polylang WordPress multilingual Plugin, it will allow you to restrict access for editors/shop_manager or other user role based on languages they’re not assigned as Translators or editor.
You can use the following function: function get_user_id_by_display_name( $display_name ) { global $wpdb; if ( ! $user = $wpdb->get_row( $wpdb->prepare( “SELECT `ID` FROM $wpdb->users WHERE `display_name` = %s”, $display_name ) ) ) return false; return $user->ID; } This is the same code get_user_by() uses, but since that function only allows ID, slug, email or login … Read more