$allowed['resolution'] = $R->enumerate();
$r = array();
- foreach (MTrackDB::q('select c.compid, c.name, p.name from components c left join components_by_project cbp on (c.compid = cbp.compid) left join projects p on (cbp.projid = p.projid) where deleted <> 1 order by c.name')
+ foreach (MTrackDB::q('
+ select c.compid, c.name, p.name
+ from components c
+ left join components_by_project cbp on (c.compid = cbp.compid)
+ left join projects p on (cbp.projid = p.projid)
+ where
+ deleted <> 1
+ order by
+ c.name')
->fetchAll(PDO::FETCH_NUM) as $row) {
+
if (strlen($row[2])) {
$row[1] .= " ($row[2])";
}
$r[$row[0]] = $row[1];
+
}
$allowed['component'] = $r;