stats!

1 files changed, 9 insertions, 1 deletions

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 )