I'm trying to update
user_login in the
wp_users table, to force update a user's username to their email address on submission of a front end edit profile form.
I know WordPress forbids this via the
wp_update_user function so I am trying to use SQL with wpdb functions.
Here is what I have, and it is not working :(
global $wpdb; $tablename = $wpdb->prefix . "users"; $sql = $wpdb->prepare( "UPDATE ".$tablename." SET user_login=".$user_email." WHERE ID=".$user_id."", $tablename ); $wpdb->query($sql);
Can anyone help?
Fixed it, see here: https://gist.github.com/4045215