function getFiles($table, $id, $field_name = false, $limit = 0, $start_record = 0, $randomize = false)
{
if (!FormDB::tableExists($table)) {
return false;
}
$sql = "SELECT *, CONCAT('" . str_ireplace('_files', '', $table) . "','_',f_id,'_',id) AS name FROM {$table} WHERE 1 ";
if ($id > 0) {
$sql .= " AND f_id = {$id} ";
}
if ($field_name) {
$sql .= " AND field_name = '{$field_name}' ";
}
if ($randomize) {
/*
if (is_array(FormDB::$random_ids[$field_name])) {
foreach (FormDB::$random_ids[$field_name] as $id) {
$sql .= " AND id != $id ";
}
}
*/
$sql .= " ORDER BY RAND() ";
}
if ($limit > 0) {
$start_record = $start_record > 0 ? $start_record : '0';
$sql .= " LIMIT {$start_record},{$limit} ";
}
$result = db_query_array($sql);
if ($randomize) {
if ($result) {
foreach ($result as $row) {
FormDB::$random_ids[$field_name] = $row['id'];
}
}
}
return $result;
}
