summaryrefslogtreecommitdiff
path: root/category.php
blob: ad4faa6a282f75b0af88202c7e5d7a01256f3863 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
<?php
include_once 'includes/db_inc.php';
include_once 'model/Category.php';

session_start();

$current = new Category();

if (!isset($_GET['id']) || !filter_var($_GET['id'], FILTER_VALIDATE_INT)) {
} else {
	$current->get_from_database($_GET['id'], $dbc);
}
?>
<!DOCTYPE html>
<html>
<head>
	<title><?php echo $current->name; ?> - cflip.net forum</title>
</head>
<body>
<?php include_once 'templates/header.php';?>
	<h1><?php echo $current->name; ?></h1>
	<p><?php echo $current->description; ?></p>
	<?php echo $current->thread_count . ' threads, ' . $current->post_count . ' posts'; ?>
	<h2>Threads</h2>
	<table width="100%">
		<tr>
			<th>Thread Name</th>
			<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 <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>';
		}
		?>
	</table>
</body>
</html>