The plugin should use the API, not some made-up SQL. addslashes() is not safe enough anyway. $user = get_user_by( ’email’, ‘[email protected]’ ); echo $user->ID; Besides that, the user tables are almost the same, there are just some tighter restrictions for user names in multi-site, because new sub domains could be made from the names.
Just log back into your admin, go to Plugins, and reactivate each of the plugins you use.
I think your first partial code be this partial code: $wpdb->prepare( “SELECT * … from … WHERE ( post_title LIKE ‘%%%s%%’ or post_content LIKE ‘%%%s%%’ )…, $string, $string ); You have to have to pass the same number of arguments into the query as you specify (with %s) in it.
You can upload images in 2 places: Media page (uploads.php) or from Add Media button in a post/page edit page. When you upload images from the post edit screen, ‘post_parent’ for all images uploaded is set to current post. When you upload images from the Media page, ‘post_parent’ is set to 0. When an image … Read more
Solved – UPDATE wp_postmeta SET meta_value = REPLACE(REPLACE(REPLACE(meta_value, ‘å’, ‘a’) , ‘ä’, ‘a’) , ‘ö’, ‘o’) WHERE LOWER(RIGHT(meta_value, 5)) = ‘.jpeg’ OR LOWER(RIGHT(meta_value, 4)) IN (‘.jpg’, ‘.gif’, ‘.png’)
It is done through the following query: delete from `wp_terms` where `term_id` in ( SELECT `term_id` FROM `wp_term_taxonomy` WHERE `taxonomy` = ‘category’ ) and `term_id` not like 1 This query deleted all the category except the default. Hope this helps to the others.
WP CLI has a command that can upgrade the database: wp core update-db If that command doesn’t upgrade the entire network, you can pass in the site you want upgraded as an additional parameter e.g. wp core update-db –site=”http://example.com/testsite/” You can get WP CLI from here: http://wp-cli.org it’s also available on github You can install … Read more
Before trying to write to the database, always validate the values you’re putting in: $fValid = true; if ( !isset( $payment->status ) ) { echo ‘Error: Payment status is not set’; $fValid = false; } if ( !isset( $order_id ) ) { echo ‘Error: Order ID is not set’; $fValid = false; } if ( … Read more
This is an answer I re-porpoised from a question that was abandoned. I thought this will help you solve this issue By default, all custom post types are excluded from the main query, that is why you don’t see any posts when going to the front end author page. To accomplish this, you will need … Read more
I did something like this when making custom reports for WooCommerce since the data was in tables not part of WordPress. My advice to you as well, I can’t tell all that you’re trying to accomplish here but research WP_Query a lot because most any WordPress query can be accomplished with it and ONLY if … Read more