public function fetchAllFiles($limit = null, $offset = null, $orderBy = 'upload_date', $sortOrder = 'DESC')
{
if (is_null($limit)) {
$limit = 60;
}
if (is_null($offset)) {
$offset = 0;
}
$sql = "SELECT * FROM `" . DB_TABLE_PREFIX . "uploads` ";
$sql .= "ORDER BY `" . mysql_real_escape_string($orderBy) . "` " . mysql_real_escape_string($sortOrder) . " ";
$sql .= "LIMIT " . mysql_real_escape_string((int) $offset) . ", " . mysql_real_escape_string((int) $limit);
$res = mysql_query($sql) or die(mysql_error() . '<br>' . $sql);
if (mysql_num_rows($res) > 0) {
while ($row = mysql_fetch_assoc($res)) {
$WeTransfer_Users = new WeTransfer_Users();
$row['owner_name'] = $WeTransfer_Users->fetchUsernameById($row['owner_id']);
$data[] = $row;
}
return $data;
} else {
return array();
}
}
