Finalized report syste,

1 files changed, 12 insertions, 1 deletions

diff --git a/mod.php b/mod.php
index 2e8a993e..04c17ac9 100644
--- a/mod.php
+++ b/mod.php
@@ -107,8 +107,12 @@
 			);
 		} elseif(preg_match('/^\/reports$/', $query)) {
 			$body = '';
+			$reports = 0;
+			
+			$query = prepare("SELECT `reports`.*, `boards`.`uri` FROM `reports` INNER JOIN `boards` ON `board` = `boards`.`id` ORDER BY `time` DESC LIMIT :limit");
+			$query->bindValue(':limit', $config['mod']['recent_reports'], PDO::PARAM_INT);
+			$query->execute() or error(db_error($query));
 			
-			$query = query("SELECT `reports`.*, `boards`.`uri` FROM `reports` INNER JOIN `boards` ON `board` = `boards`.`id` ORDER BY `time` DESC") or error(db_error());
 			if($query->rowCount() < 1)
 				$body = '(Empty.)';
 			else {
@@ -124,6 +128,7 @@
 						$p_query->execute() or error(db_error($query));
 					}
 					
+					$reports++;
 					openBoard($report['uri']);
 					
 					if(!$post['thread']) {
@@ -148,6 +153,12 @@
 				}
 			}
 			
+			$query = query("SELECT COUNT(`id`) AS `count` FROM `reports`") or error(db_error());
+			$count = $query->fetch();
+			
+			$body .= '<p class="unimportant" style="text-align:center">Showing ' . 
+				($reports == $count['count'] ? 'all ' . $reports . ' reports' : $reports . ' of ' . $count['count'] . ' reports') . '.</p>';
+			
 			echo Element('page.html', Array(
 				'index'=>$config['root'],
 				'title'=>'Report queue',