Progressive Medical

// Scheduled Action Hook
function expiration_check( ) {
	global $wpdb;
				$course_completed = 'course_completed_' . $course_choice;
				//Data retrieval query
	
				$course_listing = $wpdb->get_results("SELECT wp_users.user_email, wp_usermeta.user_id, wp_usermeta.meta_key, wp_usermeta.meta_value FROM wp_users INNER JOIN wp_usermeta on wp_users.ID = wp_usermeta.user_id WHERE wp_usermeta.meta_key LIKE 'course_completed_%'");
	
				$date = new DateTime();
				$date = $date->getTimestamp();
				
	
	
				/*$user_chron_delete = new array();
				foreach($course_listing as $item) {
					if($date <= $item)
					array_push($user_chron_delete, $item->ID);
				}*/
	
	
	
				//Data retrieval query
				$wpdb->query("DELETE FROM wp_usermeta WHERE meta_key LIKE 'course_completed_%' AND $date <= (meta_value + 7776000)");
}

// Schedule Cron Job Event
function expiration_date_checker() {
	if ( ! wp_next_scheduled( 'expiration_check' ) ) {
		wp_schedule_event( time(), 'hourly', 'expiration_check' );
	}
}
add_action( 'wp', 'expiration_date_checker' );