public static function getPersonsComments($id)
{
$data = array();
$sql = '
SELECT {{tree}}.* FROM {{tree}}
INNER JOIN ({{data}}
INNER JOIN {{relations}} ON {{relations}}.id1={{data}}.id
) ON {{data}}.tree={{tree}}.id
WHERE {{relations}}.modul1=\'data\' AND {{relations}}.id2=' . $id . ' AND {{relations}}.modul2=\'tree\'
AND {{data}}.path=\'newscom\'
ORDER BY num
';
$list = DB::getAll($sql);
foreach ($list as $item) {
$fields = Fields::getFieldsByTree($item['id']);
$item['preview'] = $fields['preview'];
$item['person'] = Persons::getOne($item['parent']);
$data[] = $item;
}
return $data;
}
