Show latest thread/post on pages

1 files changed, 20 insertions, 2 deletions

diff --git a/category.php b/category.php
index a71029e..ad4faa6 100644
--- a/category.php
+++ b/category.php
@@ -28,13 +28,31 @@ if (!isset($_GET['id']) || !filter_var($_GET['id'], FILTER_VALIDATE_INT)) {
 			<th>Latest Post</th>
 		</tr>
 		<?php
+		function cmp($a, $b) {
+			$da = strtotime($a->date_lastpost);
+			$db = strtotime($b->date_lastpost);
+
+			if ($da == $db) return 0;
+
+			return ($da > $db) ? -1 : 1;
+		}
+		
 		$threads = $current->get_threads($dbc);
+		usort($threads, "cmp");
 
 		foreach ($threads as $thread) {
+			$latest_post = $thread->get_latest_post($dbc);
+
 			echo '<tr>';
 			echo '<td><b><a href="../thread/' . $thread->id . '">' . $thread->subject . '</a></b><br>'; 
-			echo '<small>by ' . $thread->author->name . ' on ' . date('M d, Y', strtotime($thread->date_created)) . '</small></td>';
-			echo '<td>' . date('M d, Y', strtotime($thread->date_lastpost)) . '</td>';
+			echo '<small>by <b><a href="../user/' . $thread->author->name . '">' . $thread->author->name . '</a></b> on ' . date('M d, Y', strtotime($thread->date_created)) . '</small></td>';
+
+			if (!is_null($latest_post)) {
+				echo '<td>by <b><a href="../user/' . $latest_post->author->name . '">' . $latest_post->author->name . '</a></b><br><small>on ' . $latest_post->date . '</small></td>';
+			} else {
+				echo '<td>No posts yet!</td>';
+			}
+
 			echo '</tr>';
 		}
 		?>