我已经使用 postype tvshows、seasons、episodes 为我的网站创建了此 cron 作业，它正确获取季节，然后生成它并发布，但是当其现有季节剧集的时间调用时，它不会生成和发布？有哪位好朋友能帮我解决这个问题吗？
`// 第 1 步：注册自定义一分钟间隔进行测试
add_filter('cron_schedules', 'custom_one_month_cron_schedule');
函数 custom_one_month_cron_schedule($schedules) {
$schedules['every_month'] = array(
'interval' => 60, // 60 秒
'display' => __('每分钟')
);
返回 $schedules;
}
// 第 2 步：安排 cron 作业每分钟运行一次（用于测试目的）
if (!wp_next_scheduled('auto_generate_new_seasons')) {
wp_schedule_event(time(), 'every_month', 'auto_generate_new_seasons');
}
// 第 3 步：定义回调函数以生成新的季节和剧集
add_action('auto_generate_new_seasons', 'generate_new_seasons');
函数generate_new_seasons() {
全局 $wpdb;
// query to get all tmdb ids of existing tv shows from post meta
$tmdb_ids = $wpdb->get_col("select distinct meta_value from {$wpdb->postmeta} where meta_key = 'ids'");
foreach ($tmdb_ids as $tmdb_id) {
// check if the tv show exists in the 'tvshows' custom post type
$tv_show_posts = get_posts(array(
'post_type' => 'tvshows',
'meta_key' => 'ids',
'meta_value'=> $tmdb_id,
'posts_per_page' => 1, // only need one result
));
// if tv show does not exist, skip to the next tmdb id
if (empty($tv_show_posts)) {
continue;
}
// if the tv show is found, process it
foreach ($tv_show_posts as $post) {
// first, check if the 'clgnrt' meta is already set to avoid duplicate generation
$clgnrt = get_post_meta($post->id, 'clgnrt', true);
if (!$clgnrt) {
// set the 'clgnrt' meta to '1' for the tv show to avoid regenerating it
update_post_meta($post->id, 'clgnrt', '1');
}
}
// now check for and import new seasons for each tmdb id
$existing_seasons = $wpdb->get_col($wpdb->prepare(
"select meta_value from {$wpdb->postmeta} where post_id in (
select post_id from {$wpdb->postmeta} where meta_key = 'ids' and meta_value = %s
) and meta_key = 'temporada'",
$tmdb_id
));
$season = 1;
while ($season) {
// skip seasons that already exist (duplicate check)
if (in_array($season, $existing_seasons)) {
$season++;
continue;
}
// fetch season data from tmdb api
$response = wp_remote_get("https://api.themoviedb.org/3/tv/$tmdb_id/season/$season", array(
'body' => array(
'api_key' => 'your_tmdb_api_key',
'language' => 'en-us',
'append_to_response' => 'images'
)
));
if (is_wp_error($response) || wp_remote_retrieve_response_code($response) != 200) {
break;
}
$json_tmdb = json_decode(wp_remote_retrieve_body($response), true);
// if no season data is found, break the loop
if (!isset($json_tmdb['season_number'])) {
break;
}
// create a new season post
$post_data = array(
'post_status' => 'publish',
'post_title' => $json_tmdb['name'] . ': season ' . $json_tmdb['season_number'], // season title: "show name: season 1"
'post_content' => $json_tmdb['overview'],
'post_type' => 'seasons',
);
$post_id = wp_insert_post($post_data);
if (!is_wp_error($post_id)) {
// add meta data for the new season
add_post_meta($post_id, 'ids', $tmdb_id);
add_post_meta($post_id, 'temporada', $json_tmdb['season_number']);
add_post_meta($post_id, 'air_date', $json_tmdb['air_date']);
add_post_meta($post_id, 'dt_poster', $json_tmdb['poster_path']);
// update the 'clgnrt' meta for seasons to avoid regeneration
update_post_meta($post_id, 'clgnrt', '1');
// generate episodes for the new season
generate_episodes($tmdb_id, $season, $post_id);
}
$season++;
}
}
}
// 第 4 步：生成一季的剧集
函数generate_episodes($tmdb_id, $season_number, $season_post_id) {
全局 $wpdb;
// check if the episodes for this season already exist
$existing_episodes = $wpdb->get_col($wpdb->prepare(
"select meta_value from {$wpdb->postmeta} where post_id in (
select post_id from {$wpdb->postmeta} where meta_key = 'temporada' and meta_value = %s
) and meta_key = 'episodio' ",
$season_number
));
$episode_number = 1;
while ($episode_number) {
// skip episodes that already exist (duplicate check)
if (in_array($episode_number, $existing_episodes)) {
$episode_number++;
continue;
}
// fetch episode data from tmdb api
$response = wp_remote_get("https://api.themoviedb.org/3/tv/$tmdb_id/season/$season_number/episode/$episode_number", array(
'body' => array(
'api_key' => 'your_tmdb_api_key',
'language' => 'en-us',
'append_to_response' => 'images'
)
));
if (is_wp_error($response) || wp_remote_retrieve_response_code($response) != 200) {
break;
}
$json_tmdb = json_decode(wp_remote_retrieve_body($response), true);
// if no episode data is found, break the loop
if (!isset($json_tmdb['episode_number'])) {
break;
}
// create a new episode post
$post_data = array(
'post_status' => 'publish',
'post_title' => $json_tmdb['name'] . ' ' . $season_number . 'x' . $episode_number, // episode title: "show name: 1x1"
'post_content' => $json_tmdb['overview'],
'post_type' => 'episodes',
);
$episode_post_id = wp_insert_post($post_data);
if (!is_wp_error($episode_post_id)) {
// add meta data for the new episode
add_post_meta($episode_post_id, 'ids', $tmdb_id);
add_post_meta($episode_post_id, 'temporada', $season_number);
add_post_meta($episode_post_id, 'episodio', $json_tmdb['episode_number']);
add_post_meta($episode_post_id, 'air_date', $json_tmdb['air_date']);
add_post_meta($episode_post_id, 'dt_poster', $json_tmdb['still_path']);
// update the 'clgnrt' meta for episodes to avoid regeneration
update_post_meta($episode_post_id, 'clgnrt', '1');
}
$episode_number++;
}
}
// 第 5 步：测试后清理并重置 cron 作业计划
add_action('init', function() {
if (已定义('wp_debug') && wp_debug) {
// 删除现有的 cron 计划以重置它
$timestamp = wp_next_scheduled('auto_generate_new_seasons');
if ($timestamp) {
wp_unschedule_event($timestamp, 'auto_generate_new_seasons');
}
}
// Re-schedule the cron job to run hourly instead of every minute for production
if (!wp_next_scheduled('auto_generate_new_seasons')) {
wp_schedule_event(time(), 'hourly', 'auto_generate_new_seasons');
}
});
`
