From b007f09506dd21ac7728f7f71c43ee6eed36aa17 Mon Sep 17 00:00:00 2001
From: Alexander Ebert <ebert@woltlab.com>
Date: Mon, 9 Jul 2018 17:52:43 +0200
Subject: [PATCH] Support for random order in article list boxes

See #2592
---
 .../lib/system/box/ArticleListBoxController.class.php      | 7 ++++++-
 wcfsetup/install/lang/de.xml                               | 1 +
 wcfsetup/install/lang/en.xml                               | 1 +
 3 files changed, 8 insertions(+), 1 deletion(-)

diff --git a/wcfsetup/install/files/lib/system/box/ArticleListBoxController.class.php b/wcfsetup/install/files/lib/system/box/ArticleListBoxController.class.php
index 86c7c8a45a..5816a6b4a7 100644
--- a/wcfsetup/install/files/lib/system/box/ArticleListBoxController.class.php
+++ b/wcfsetup/install/files/lib/system/box/ArticleListBoxController.class.php
@@ -40,7 +40,8 @@ class ArticleListBoxController extends AbstractDatabaseObjectListBoxController {
 	public $validSortFields = [
 		'time',
 		'comments',
-		'views'
+		'views',
+		'random'
 	];
 	
 	/**
@@ -69,6 +70,10 @@ class ArticleListBoxController extends AbstractDatabaseObjectListBoxController {
 				break;
 		}
 		
+		if ($this->sortField === 'random') {
+			$this->sortField = 'RAND()';
+		}
+		
 		return $objectList;
 	}
 	
diff --git a/wcfsetup/install/lang/de.xml b/wcfsetup/install/lang/de.xml
index 2374b15c71..0cc4b527b8 100644
--- a/wcfsetup/install/lang/de.xml
+++ b/wcfsetup/install/lang/de.xml
@@ -2342,6 +2342,7 @@ Benutzerkontos nun in vollem Umfang nutzen.]]></item>
 		<item name="wcf.article.commentResponse"><![CDATA[Antwort auf Artikel-Kommentar]]></item>
 		<item name="wcf.article.sortField.comments"><![CDATA[Kommentare]]></item>
 		<item name="wcf.article.sortField.cumulativeLikes"><![CDATA[Likes]]></item>
+		<item name="wcf.article.sortField.random"><![CDATA[Zufällig]]></item>
 		<item name="wcf.article.sortField.time"><![CDATA[Datum]]></item>
 		<item name="wcf.article.sortField.views"><![CDATA[Zugriffe]]></item>
 		<item name="wcf.article.markAllAsRead"><![CDATA[Alle Artikel als gelesen markieren]]></item>
diff --git a/wcfsetup/install/lang/en.xml b/wcfsetup/install/lang/en.xml
index 577a961cc3..6c66d6e6f4 100644
--- a/wcfsetup/install/lang/en.xml
+++ b/wcfsetup/install/lang/en.xml
@@ -2278,6 +2278,7 @@ full extend.]]></item>
 		<item name="wcf.article.commentResponse"><![CDATA[Reply to Article Comment]]></item>
 		<item name="wcf.article.sortField.comments"><![CDATA[Comments]]></item>
 		<item name="wcf.article.sortField.cumulativeLikes"><![CDATA[Likes]]></item>
+		<item name="wcf.article.sortField.random"><![CDATA[Random]]></item>
 		<item name="wcf.article.sortField.time"><![CDATA[Date]]></item>
 		<item name="wcf.article.sortField.views"><![CDATA[Views]]></item>
 		<item name="wcf.article.markAllAsRead"><![CDATA[Mark All Articles as Read]]></item>
-- 
2.20.1