From 84c110647b84fc29fb8443d088c710ba8ecf42fe Mon Sep 17 00:00:00 2001
From: Simon Rettberg
Date: Thu, 21 Mar 2019 13:48:57 +0100
Subject: [sysconfig] Remember last modified date, show as tooltip

---
 modules-available/sysconfig/page.inc.php | 17 +++++++++--------
 1 file changed, 9 insertions(+), 8 deletions(-)

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

diff --git a/modules-available/sysconfig/page.inc.php b/modules-available/sysconfig/page.inc.php
index 515d432c..05a83924 100644
--- a/modules-available/sysconfig/page.inc.php
+++ b/modules-available/sysconfig/page.inc.php
@@ -213,13 +213,13 @@ class Page_SysConfig extends Page
 	private function listConfigs()
 	{
 		// Configs
-		$res = Database::simpleQuery("SELECT c.configid, c.title, c.filepath, c.status,"
-			. "   GROUP_CONCAT(DISTINCT cl.locationid) AS loclist, GROUP_CONCAT(cxm.moduleid) AS modlist"
-			. " FROM configtgz c"
-			. " LEFT JOIN configtgz_x_module cxm USING (configid)"
-			. " LEFT JOIN configtgz_location cl ON (c.configid = cl.configid)"
-			. " GROUP BY configid"
-			. " ORDER BY title ASC");
+		$res = Database::simpleQuery("SELECT c.configid, c.title, c.filepath, c.status, c.dateline,
+				GROUP_CONCAT(DISTINCT cl.locationid) AS loclist, GROUP_CONCAT(cxm.moduleid) AS modlist
+			FROM configtgz c
+			LEFT JOIN configtgz_x_module cxm USING (configid)
+			LEFT JOIN configtgz_location cl ON (c.configid = cl.configid)
+			GROUP BY configid
+			ORDER BY title ASC");
 		$configs = array();
 		if ($this->currentLoc !== 0) {
 			$locationName = $this->locations[$this->currentLoc]['locationname'];
@@ -254,7 +254,8 @@ class Page_SysConfig extends Page
 				'loclist' => $row['loclist'],
 				'readableLocList' => $this->getLocationNames($this->locations, $locList),
 				'locationCount' => $locCount,
-				'needrebuild' => ($row['status'] !== 'OK')
+				'needrebuild' => ($row['status'] !== 'OK'),
+				'dateline_s' => Util::prettyTime($row['dateline']),
 			);
 		}
 		$data = array(
-- 
cgit v1.2.3-55-g7522