summaryrefslogtreecommitdiffstats
path: root/modules-available/news
diff options
context:
space:
mode:
authorSimon Rettberg2023-04-24 11:35:34 +0200
committerSimon Rettberg2023-04-24 11:35:34 +0200
commitf4a5a668f72e80b06c0d47e248c39c25eca0293b (patch)
tree54eab9cd8e09a8123ffed54015af9a93b47c9a0f /modules-available/news
parent[news] Fix: Global news could not be saved (diff)
downloadslx-admin-f4a5a668f72e80b06c0d47e248c39c25eca0293b.tar.gz
slx-admin-f4a5a668f72e80b06c0d47e248c39c25eca0293b.tar.xz
slx-admin-f4a5a668f72e80b06c0d47e248c39c25eca0293b.zip
[news] Don't show duplicates in list of locs with overrides
Diffstat (limited to 'modules-available/news')
-rw-r--r--modules-available/news/page.inc.php2
1 files changed, 1 insertions, 1 deletions
diff --git a/modules-available/news/page.inc.php b/modules-available/news/page.inc.php
index 852aaae5..a122d37c 100644
--- a/modules-available/news/page.inc.php
+++ b/modules-available/news/page.inc.php
@@ -182,7 +182,7 @@ class Page_News extends Page
$data['location_name'] = Location::getName($this->locationId);
} else {
// Superadmin can see all overridden locations
- $data['overridden'] = Database::queryAll("SELECT l.locationid, l.locationname FROM vmchooser_pages
+ $data['overridden'] = Database::queryAll("SELECT DISTINCT l.locationid, l.locationname FROM vmchooser_pages
INNER JOIN location l USING (locationid)
WHERE expires > UNIX_TIMESTAMP() ORDER BY locationname ASC");
}