You are using the system cron to trigger a function hooked into the AJAX API, not, as your title reads, using “admin-ajax.php to run a real cron job”. You are doing exactly the opposite of what you wrote in the title (I’d advise editing that). Yes, that is perfectly fine. I have advised using the … Read more
This is what normal query run by wp_get_associated_nav_menu_items() looks like: SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.id = wp_postmeta.post_id ) WHERE 1 = 1 AND wp_posts.post_type=”nav_menu_item” AND (( wp_posts.post_status <> ‘trash’ AND wp_posts.post_status <> ‘auto-draft’ )) AND (( wp_postmeta.meta_key = ‘_menu_item_object_id’ AND Cast(wp_postmeta.meta_value AS CHAR) = ‘3111’ )) GROUP BY wp_posts.id ORDER … Read more
Yes, in my opinion that’s exactly the right way to extend the default schedule timings. I would be a little more informative with the display value but I think that is only example code. However, one important thing should be taken into account. The default WordPress schedule implementation that is invoked as a side effect … Read more
It is set_site_transient, not set_site_site_transient. You should be aware that a single user will still wait that half a minute for this to complete. wp_cron does not run on clock time. It runs when a user visits the site. If you have the ability to create a system cron job then hook your callback to … Read more
You do not need to use raw SQL, WordPress already provides WP_User_Query, and even provides examples of date based queries, for example the official docs say that this will retrieve all users registered within the last 12 hours: $args = array( ‘date_query’ => array( array( ‘after’ => ’12 hours ago’, ‘inclusive’ => true ) ) … Read more
The WordPress cron is run by the wp_cron() function, which is hooked to run on the init hook, which runs on every page load. wp_cron() is defined in wp-includes/cron.php and hooked in wp-includes/default-filters.php. The wp_cron() function kicks off a wp_remote_post() request to /wp-cron.php. Some server configurations prevent scripts sending a request to the same domain … Read more
OK, so first of all you’ll need to add your own WP_Schedule event: add_action( ‘wp’, function () { if (! wp_next_scheduled ( ‘mark_posts_as_featured_event’ )) { wp_schedule_event(time(), ‘daily’, ‘mark_posts_as_featured_event’); } } ); function mark_posts_as_featured_event_callback() { // if there are sticky posts in our CPT, unstick them $sticked_post_ids = get_option( ‘sticky_posts’ ); if ( ! empty ) … Read more
Don’t use global $post. Everything you need should be passed into the function in the $data and $postarr parameters. Secondly, you have to return the $data in all cases. What you are doing now is effectively erasing data for everything but your profile post type. You need to reorganize a bit: function reset_post_date_wpse_121565($data,$postarr) { if … Read more
First things first: Say hello! to $wpdb The wpdb Class is what you take to interact with the database on it’s most basic level. Forget all those mysql_* functions, when it comes to WordPress. The core has a nice wrapper, that makes most things pretty safe for you (hint: SQL-injections and other bad boys). Or … Read more
custom cron interval is not working