diff options
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 |