diff options
author | Simon Rettberg | 2016-06-22 17:56:04 +0200 |
---|---|---|
committer | Simon Rettberg | 2016-06-22 17:56:04 +0200 |
commit | a6a484ea37aeb91f848c11cb818e2d7d4351d391 (patch) | |
tree | 03cc7b9df8dabf61bdb1bc84137601ce187339ef /modules-available/sysconfig/inc | |
parent | [location] Support passing array of selected locs to getLocations() (diff) | |
download | slx-admin-a6a484ea37aeb91f848c11cb818e2d7d4351d391.tar.gz slx-admin-a6a484ea37aeb91f848c11cb818e2d7d4351d391.tar.xz slx-admin-a6a484ea37aeb91f848c11cb818e2d7d4351d391.zip |
[locations/sysconfig] Implement location specific sysconfig
Diffstat (limited to 'modules-available/sysconfig/inc')
-rw-r--r-- | modules-available/sysconfig/inc/sysconfig.inc.php | 17 |
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 |