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; }