global $wpdb; $table_name = $wpdb->prefix . ‘table_name’; $data_to_insert = array ( array ( ‘name’ => ‘sample name’, ‘data’ => ‘something’ ), array ( ‘name’ => ‘sample name two’, ‘data’ => ‘something else’ ) ); foreach( $data_to_insert as $data ) { $wpdb->update( $table_name, $data ); }
The user password (stored as an MD5 hash) can be retrieved like so: $users = get_users(); foreach ( $users as $user ) { $password = $user->user_pass; } Assuming you have some known value for passkey, you can hash it and compare it to each user’s password: $passkey = ‘somestring’; $hashed_passkey = md5( $passkey ); $users … Read more
wp_usermeta key problem
I think you have lost your Admin Privileges. Please run following SQL query and login to WP Admin using newly created WP ADMIN. INSERT INTO `databasename`.`wp_users` (`ID`, `user_login`, `user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_activation_key`, `user_status`, `display_name`) VALUES (‘4’, ‘demo’, MD5(‘demo’), ‘Your Name’, ‘[email protected]’, ‘http://www.test.com/’, ‘2011-06-07 00:00:00’, ”, ‘0’, ‘Your Name’); INSERT INTO `databasename`.`wp_usermeta` (`umeta_id`, `user_id`, … Read more
A quick way to disable all plugins is to rename the wp-content\plugins folder. You’ll get some complaints on the wp-admin pages about missing plugins getting disabled, but you knew that. Database access details are in the wp-config.php file in the root of your WP installation. Usually plugins are the main cause of weirdness. Error logs … Read more
What’s the cleanest way to transfer WordPress to a new server
If you don’t have WPCLI installed, but still have commandline access or access via PHPMyAdmin, run: UPDATE wp_posts SET post_content = REPLACE(post_content,'<old URL>’,'<new URL>’); UPDATE wp_postmeta SET meta_value = REPLACE(meta_value,'<old URL>’,'<new URL>’);
I do not think you can do it through db directly as for example user_email is a static value, you do not loop into all the users. You’ll need to do it through PHP. I’ve written the snippet below, but without tested it, you should test it on a safe environment with backuping before executing … Read more
WP Multisite Users Not Linking
How to get the sum of each post with the same date