From 1426f2722871cb1c08084ee43f6edaeb7028578c Mon Sep 17 00:00:00 2001
From: Simon Rettberg
Date: Wed, 4 May 2022 15:01:59 +0200
Subject: [news] List locations with overrides when editing global

---
 modules-available/news/page.inc.php | 5 +++++
 1 file changed, 5 insertions(+)

(limited to 'modules-available/news/page.inc.php')

diff --git a/modules-available/news/page.inc.php b/modules-available/news/page.inc.php
index ceffd028..3b58e9a2 100644
--- a/modules-available/news/page.inc.php
+++ b/modules-available/news/page.inc.php
@@ -180,6 +180,11 @@ class Page_News extends Page
 		$data['locationid'] = $this->locationId;
 		if ($this->locationId > 0) {
 			$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
+				INNER JOIN location l USING (locationid)
+				WHERE expires > UNIX_TIMESTAMP() ORDER BY locationname ASC");
 		}
 		Render::addTemplate('page-news', $data);
 	}
-- 
cgit v1.2.3-55-g7522