You can prevent more than three revisions from being saved to the database in the future by adding this line to your wp-config.php file: define( ‘WP_POST_REVISIONS’, 3 ); That line should limit new posts to three revisions, but it won’t go through your database and clean it up. The SQL snippet that you found for … Read more
After some hours of investigation I deactivated W3 Total Cache plugin. Still no changes. And then I noticed WP Redis plugin.. soo I searched for Redis Object Caching on serverside and found it. When I flushed the cache, the stock showed updated stock quantity. Soo.. always double-check your caching. 😀
I believe you’re looking for SQL UNION.
Note, before going further: Take care about portability and security: function wpse50056_get_post_meta() { global $wpdb; $results = $wpdb->get_results( ” SELECT ID, post_date, post_title, post_content, meta_key, meta_value FROM {$wpdb->posts} INNER JOIN {$wpdb->postmeta} ON ( $wpdb->posts.ID = {$wpdb->postmeta}.post_id ) ” ); foreach( $results as $result ) { printf( ‘<pre>%s</pre>’, htmlspecialchars( var_export( $result, true ) ) ); } … Read more
Actually, the customary way to do this in WordPress would be to use <?php update_post_meta($post_id, $meta_key, $meta_value, $prev_value); ?> as per the codex: https://codex.wordpress.org/Function_Reference/update_post_meta. It yields shorter code, and the intent of the code is clearer.
change where clause with or SELECT P.ID, P.post_title, P.post_content, P.post_author, meta_value FROM wp_posts AS P LEFT JOIN wp_postmeta AS PM on PM.post_id = P.ID WHERE P.post_type=”post” and P.post_status=”publish” and ( meta_key = ‘job_title’ or meta_key = ‘company_email’ ) ORDER BY P.post_date DESC but this sql will return the same post in 2 row for your … Read more
I found when attempting similar I needed to clear the user cache to get the relogin to work (after much frustrating testing!): wp_cache_delete($user_id, ‘users’); wp_cache_delete($old_user_login, ‘userlogins’); // maybe unnecessary? $creds = array(‘user_login’ => $user_login, ‘user_password’ => $user_password, ‘remember’ => true); wp_signon($creds); Note for this to work you may also need the user to change their … Read more
As @bonger said, let your filters accept a second argument, which will be the instance of WP_Query that’s executing the filter, and check it is indeed the main query for an event: function single_posts_fields( $sql, $wp_query ) { if ( $wp_query->is_main_query() && $wp_query->is_singular( ‘event’ ) ) { // Do your stuff } } add_filter( ‘posts_fields’, … Read more
I am not sure why you are using a custom query and not get_posts() or WP_Query as you should. Anyway, you need to get the post ID … $query =”SELECT wp_posts.post_title AS title , wp_posts.post_content AS content, wp_posts.post_date AS blogdate , wp_posts.ID AS ID And then just pass this ID to get_permalink(): get_permalink( $post->ID ); … Read more
It’s not stored as attribute, but as list of all stickies. Snippet from core: $sticky_posts = get_option(‘sticky_posts’); So look for the option and then use IDs to retrieve posts.