From 08253a6b16e5abe09718e9a593f296c3a66b482b Mon Sep 17 00:00:00 2001
From: Simon Rettberg
Date: Mon, 27 Oct 2014 17:13:30 +0100
Subject: Show modules of sysconfig using fancy javascript mouseover effects

---
 modules/sysconfig.inc.php | 7 ++++++-
 1 file changed, 6 insertions(+), 1 deletion(-)

(limited to 'modules/sysconfig.inc.php')

diff --git a/modules/sysconfig.inc.php b/modules/sysconfig.inc.php
index dc2458de..6bb96c80 100644
--- a/modules/sysconfig.inc.php
+++ b/modules/sysconfig.inc.php
@@ -133,12 +133,17 @@ class Page_SysConfig extends Page
 	private function listConfigs()
 	{
 		// Configs
-		$res = Database::simpleQuery("SELECT configid, title, filepath FROM configtgz ORDER BY title ASC");
+		$res = Database::simpleQuery("SELECT configtgz.configid, configtgz.title, configtgz.filepath, GROUP_CONCAT(configtgz_x_module.moduleid) AS modlist"
+			. " FROM configtgz"
+			. " INNER JOIN configtgz_x_module USING (configid)"
+			. " GROUP BY configid"
+			. " ORDER BY title ASC");
 		$configs = array();
 		while ($row = $res->fetch(PDO::FETCH_ASSOC)) {
 			$configs[] = array(
 				'configid' => $row['configid'],
 				'config' => $row['title'],
+				'modlist' => $row['modlist'],
 				'current' => readlink(CONFIG_HTTP_DIR . '/default/config.tgz') === $row['filepath']
 			);
 		}
-- 
cgit v1.2.3-55-g7522