diff options
| author | Simon Rettberg | 2023-04-24 11:35:34 +0200 |
|---|---|---|
| committer | Simon Rettberg | 2023-04-24 11:35:34 +0200 |
| commit | f4a5a668f72e80b06c0d47e248c39c25eca0293b (patch) | |
| tree | 54eab9cd8e09a8123ffed54015af9a93b47c9a0f | |
| parent | [news] Fix: Global news could not be saved (diff) | |
| download | slx-admin-f4a5a668f72e80b06c0d47e248c39c25eca0293b.tar.gz slx-admin-f4a5a668f72e80b06c0d47e248c39c25eca0293b.tar.xz slx-admin-f4a5a668f72e80b06c0d47e248c39c25eca0293b.zip | |
[news] Don't show duplicates in list of locs with overrides
| -rw-r--r-- | modules-available/news/page.inc.php | 2 |
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"); } |