From 0f94a6c78dc5d4563c7f10a43e93c80832d9bf71 Mon Sep 17 00:00:00 2001
From: horus
Date: Tue, 16 Jan 2024 02:28:48 +0100
Subject: stats!

---
 app/Http/Controllers/IndexController.php | 10 +++++++++-
 1 file changed, 9 insertions(+), 1 deletion(-)

(limited to 'app/Http')

diff --git a/app/Http/Controllers/IndexController.php b/app/Http/Controllers/IndexController.php
index 824a2e2..f24d1ad 100644
--- a/app/Http/Controllers/IndexController.php
+++ b/app/Http/Controllers/IndexController.php
@@ -19,7 +19,15 @@ class IndexController extends Controller
 
     public function about()
     {
-            return view('about');
+	    $count_articles = DB::Select("SELECT COUNT(*) as count FROM article;")[0];
+	    $count_discussions = DB::Select("SELECT COUNT(*) as count FROM discussion;")[0];
+	    $count_comments = DB::Select("SELECT sum(comments) as count FROM discussion;")[0];
+	    $count_upvotes = DB::Select("SELECT sum(upvotes) as count FROM discussion;")[0];
+	    return view('about', [
+		    "count_articles" => $count_articles->count,
+		    "count_discussions" => $count_discussions->count,
+		    "count_comments" => number_format($count_comments->count),
+		    "count_upvotes" => number_format($count_upvotes->count)]);
     }
 
     public function topic( $topic )
-- 
cgit v1.2.3