Hello Ravi

Thank you so much for your help 🙂
I was suspecting that your code is correct.
I have tried many different examples of codes and i really can’t understand why it gives me wrong results.

https://ibb.co/Z25Mw1x (keeps giving the oldest article)
https://ibb.co/RND6Dm7

It seems like the DESC doesn’t affect.

What i am trying to do is similar to previous https://buddydev.com/support/forums/topic/send-email-to-user-that-has-been-inactive-for-2-months/ :

With a cron job, send an email reminder to authors that have not published a post for the last 60 days.

So i am trying to create my function, something like this :

function reminder_email() {
	
       $days = 60; // if these days have passed from the last published post of the author send email reminder

	global $wpdb;
	
	// get the most recent post for each author
	$posts = $wpdb->get_results();

	// No post found.
	if ( empty( $posts ) ) {
		return;
	}

	
	if ( ! empty( $posts ) ) { 
	foreach( $posts as $post ) {
	
        // get today's date in unix timestamp format
		$today = strtotime( date( 'Y-m-d' ) );	
		
		// the date is X number of days from last post published date where X is set in the $days variable above
		$expire = strtotime( '+'. $days .'days', strtotime( $post->post_date ) );
		
	$user_info = get_userdata( $post->post_author );
	
	if ( $expire < $today ) { wp_mail();  //send email reminder to $user_info->user_email  }
       }
	}
}
add_action( 'reminder_email', 'reminder_email' );

I don’t understand why results from db are wrong.

• This reply was modified 1 year, 4 months ago by Lefteris.

Hello Ravi.
I believe i’ve got it working but i am not sure if there is any mistake in my code. Could you also check it and confirm:

function reminder_email() {
	
       $today = strtotime( date( 'Y-m-d' ) ); // Get today's date
	$args = array(
   'orderby' => 'post_date',
   'order' => 'DESC',
   'author' => '',
   'post_type' => 'post',
   'post_status' => 'publish',
   'posts_per_page' => 1,
);

$authors = get_users( array(
    'role__in' => array( 'contributor', 'author', 'administrator' ), // get only specific roles
    'fields' => array( 'ID' )
) );

foreach ( $authors as $author ) {
   $args['author'] = $author->ID;
   $author_posts = new WP_Query( $args );
   if ( $author_posts->have_posts() ) {
	   
     
	   
      while ( $author_posts->have_posts() ) {
         $author_posts->the_post();
         $expire = strtotime( '+60 days', strtotime( $post->post_date ) ); //Calculation to compare the post_date of the last post's with today date (when is more than 60 days that author haven't published a new post)
		 
         if ( $expire < $today ) {  wp_mail();  //send email reminder to get_the_author_meta( 'user_email' ) }
     
	 }
   
   }
   wp_reset_postdata();
}

}
add_action( 'reminder_email', 'reminder_email' );

Thank you very much for your help 🙂

• This reply was modified 1 year, 4 months ago by Lefteris.