function ceo_archive_list_by_all_years($thumbnail = false, $order = 'ASC', $chapter = 0) { global $wpdb; $latest_comic = ceo_get_last_comic(false); $archive_year_latest = get_post_time('Y', false, $latest_comic, true); $first_comic = ceo_get_first_comic(false); $archive_year_first = get_post_time('Y', false, $first_comic, true); if ($chapter) { $years = $wpdb->get_col("SELECT DISTINCT YEAR(post_date) FROM {$wpdb->posts} LEFT JOIN {$wpdb->term_relationships} ON ({$wpdb->posts}.ID = {$wpdb->term_relationships}.object_id) LEFT JOIN {$wpdb->term_taxonomy} ON ({$wpdb->term_relationships}.term_taxonomy_id = {$wpdb->term_taxonomy}.term_taxonomy_id) WHERE {$wpdb->posts}.post_status = 'publish' AND {$wpdb->term_taxonomy}.taxonomy = 'chapters' AND {$wpdb->term_taxonomy}.term_id = " . $chapter . " ORDER BY post_date " . $order); } else { $years = $wpdb->get_col("SELECT DISTINCT YEAR(post_date) FROM {$wpdb->posts} WHERE post_status = 'publish' AND post_type='comic' ORDER BY post_date " . $order); } $output = ''; foreach ($years as $year) { if ($chapter) { $comic_args = array('showposts' => -1, 'year' => (int) $year, 'post_type' => 'comic', 'chapter' => $chapter, 'order' => $order); } else { $comic_args = array('showposts' => -1, 'year' => (int) $year, 'post_type' => 'comic', 'order' => $order); } $theposts = get_posts($comic_args); $output .= '<h3 class="year-title">' . $year . '</h3>'; $output .= '<table class="month-table">'; foreach ($theposts as $post) { $output .= '<tr><td class="archive-date">' . get_the_time('M j', $post->ID) . '</td><td class="archive-title"><a href="' . get_permalink($post->ID) . '" rel="bookmark" title="' . get_the_title($post->ID) . '">' . get_the_title($post->ID) . '</a></td></tr>'; } $output .= '</table>'; } return $output; }
function ceo_get_last_comic_in_chapter_permalink() { $terminal = ceo_get_last_comic(true); return !empty($terminal) ? get_permalink($terminal->ID) : false; }