Changeset 268

Timestamp:

07/23/2003 09:04:25 PM (23 years ago)

Author:

mikelittle

Message:

previous/next_post don't link to non-published posts.
Fix by Alex King

File:

• trunk/b2-include/b2template.functions.php (modified) (2 diffs)

trunk/b2-include/b2template.functions.php

@@ -619 +619 @@
 
         $limitprev--;
-        $lastpost = @$wpdb->get_row("SELECT ID, post_title FROM $tableposts WHERE post_date < '$current_post_date' AND post_category > 0 $sqlcat $sql_exclude_cats ORDER BY post_date DESC LIMIT $limitprev, 1");
+        $lastpost = @$wpdb->get_row("SELECT ID, post_title FROM $tableposts WHERE post_date < '$current_post_date' AND post_category > 0 AND post_status = 'publish' $sqlcat $sql_exclude_cats ORDER BY post_date DESC LIMIT $limitprev, 1");
         ++$querycount;
         if ($lastpost) {
@@ -660 +660 @@
         $limitnext--;
 
-        $nextpost = @$wpdb->get_row("SELECT ID,post_title FROM $tableposts WHERE post_date > '$current_post_date' AND post_date < '$now' AND post_category > 0 $sqlcat $sql_exclude_cats ORDER BY post_date ASC LIMIT $limitnext,1");
+        $nextpost = @$wpdb->get_row("SELECT ID,post_title FROM $tableposts WHERE post_date > '$current_post_date' AND post_date < '$now' AND post_category > 0 AND post_status = 'publish' $sqlcat $sql_exclude_cats ORDER BY post_date ASC LIMIT $limitnext,1");
         ++$querycount;
         if ($nextpost) {