1 files changed, 17 insertions, 0 deletions
diff --git a/modules-available/sysconfig/inc/sysconfig.inc.php b/modules-available/sysconfig/inc/sysconfig.inc.php
new file mode 100644
index 00000000..15bd4104
--- /dev/null
+++ b/modules-available/sysconfig/inc/sysconfig.inc.php
@@ -0,0 +1,17 @@
+<?php
+
+class SysConfig
+{
+
+	public static function getAll()
+	{
+		$res = Database::simpleQuery("SELECT c.configid, c.title, c.filepath, c.status, Group_Concat(cl.locationid) AS locs FROM configtgz c"
+			. " LEFT JOIN configtgz_location cl USING (configid) GROUP BY c.configid");
+		$ret = array();
+		while ($row = $res->fetch(PDO::FETCH_ASSOC)) {
+			$ret[] = $row;
+		}
+		return $ret;
+	}
+
+}
+\ No newline at end of file