From 0fe83c7f76b2fd6ce79541a71cdde5ec0b12becf Mon Sep 17 00:00:00 2001 From: horus Date: Sun, 29 Mar 2026 22:15:13 +0200 Subject: small hack to prevent publishing articles without categories --- app/Http/Controllers/FeedController.php | 3 +++ 1 file changed, 3 insertions(+) diff --git a/app/Http/Controllers/FeedController.php b/app/Http/Controllers/FeedController.php index 6dadf8f..9d20fce 100644 --- a/app/Http/Controllers/FeedController.php +++ b/app/Http/Controllers/FeedController.php @@ -18,6 +18,7 @@ class FeedController extends Controller $articles = Article::join('discussion', 'discussion.article_id', '=', 'view_article.id') ->select('view_article.id', 'view_article.article_id', 'view_article.url', 'view_article.title', 'view_article.excerpt_html', 'view_article.impact', 'view_article.upvotes', 'view_article.comments', 'view_article.repost') ->groupBy('view_article.id', 'view_article.article_id', 'view_article.url', 'view_article.title', 'view_article.excerpt_html', 'view_article.impact', 'view_article.upvotes', 'view_article.comments', 'view_article.repost') + ->where('view_article.created_at', '<', now()->subMinutes(30)) ->orderByRaw('MAX(discussion.posted_on) DESC') ->take(20) ->get(); @@ -30,6 +31,7 @@ class FeedController extends Controller $articles = Article::join('discussion', 'discussion.article_id', '=', 'view_article.id') ->select('view_article.id', 'view_article.article_id', 'view_article.url', 'view_article.title', 'view_article.excerpt_html', 'view_article.impact', 'view_article.upvotes', 'view_article.comments', 'view_article.repost') ->groupBy('view_article.id', 'view_article.article_id', 'view_article.url', 'view_article.title', 'view_article.excerpt_html', 'view_article.impact', 'view_article.upvotes', 'view_article.comments', 'view_article.repost') + ->where('view_article.created_at', '<', now()->subMinutes(30)) ->orderByRaw('MAX(discussion.posted_on) DESC') ->take(20) ->get(); @@ -40,6 +42,7 @@ class FeedController extends Controller $articles = Article::join('discussion', 'discussion.article_id', '=', 'view_article.id') ->select('view_article.id', 'view_article.article_id', 'view_article.url', 'view_article.title', 'view_article.excerpt_html', 'view_article.impact', 'view_article.upvotes', 'view_article.comments', 'view_article.repost') ->groupBy('view_article.id', 'view_article.article_id', 'view_article.url', 'view_article.title', 'view_article.excerpt_html', 'view_article.impact', 'view_article.upvotes', 'view_article.comments', 'view_article.repost') + ->where('view_article.created_at', '<', now()->subMinutes(30)) ->orderByRaw('MAX(discussion.posted_on) DESC') ->take(20) ->get(); -- cgit v1.2.3