Changeset 21 for trunk/bb-includes/functions.php

Timestamp:

12/28/2004 09:56:41 PM (18 years ago)

Author:

matt

Message:

Added RSS support, used gmdate everywhere. Fixes #3.

File:

• trunk/bb-includes/functions.php (modified) (2 diffs)

trunk/bb-includes/functions.php

@@ -19 +19 @@
 }
 
-function get_thread( $topic, $page = 0 ) {
-    global $bbdb, $bb;
+function get_thread( $topic, $page = 0, $reverse = 0 ) {
+    global $bbdb;
 
     $limit = bb_get_option('page_topics');
     if ( $page )
         $limit = ($limit * $page) . ", $limit";
-    return $bbdb->get_results("SELECT * FROM $bbdb->posts WHERE topic_id = $topic ORDER BY post_time ASC LIMIT $limit");
+    $order = ($reverse) ? 'DESC' : 'ASC';
+
+    return $bbdb->get_results("SELECT * FROM $bbdb->posts WHERE topic_id = $topic ORDER BY post_time $order LIMIT $limit");
 }
 
@@ -42 +44 @@
         $limit = ($limit * $page) . ", $limit";
     return $bbdb->get_results("SELECT * FROM $bbdb->topics $where ORDER BY topic_time DESC LIMIT $limit");
+}
+
+function get_latest_posts( $num ) {
+    global $bbdb;
+    $num = (int) $num;
+    return $bbdb->get_results("SELECT * FROM $bbdb->posts ORDER BY post_time DESC LIMIT $num");
 }