blob: 135499486af56184acbef8935c576e6a7eef6c28 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
<?php
class SysConfig
{
const GLOBAL_MINIMAL_CONFIG = '/opt/openslx/configs/config-global.tgz';
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;
}
}
|
