/**
* returns a file object for the given file ID
* @param int $fID
* @return File
*/
public static function getByID($fID)
{
$db = Loader::db();
$f = new File();
$row = $db->GetRow("SELECT Files.*, FileVersions.fvID\n\t\tFROM Files LEFT JOIN FileVersions on Files.fID = FileVersions.fID and FileVersions.fvIsApproved = 1\n\t\tWHERE Files.fID = ?", array($fID));
if (!is_null($fID) && $row['fID'] == $fID) {
$f->setPropertiesFromArray($row);
} else {
$f->error = File::F_ERROR_INVALID_FILE;
}
return $f;
}
public function getByID($fID)
{
$f = Cache::get('file_approved', $fID);
if (is_object($f)) {
return $f;
}
Loader::model('file_set');
$db = Loader::db();
$f = new File();
$row = $db->GetRow("SELECT Files.*, FileVersions.fvID\n\t\tFROM Files LEFT JOIN FileVersions on Files.fID = FileVersions.fID and FileVersions.fvIsApproved = 1\n\t\tWHERE Files.fID = ?", array($fID));
if ($row['fID'] == $fID) {
$f->setPropertiesFromArray($row);
Cache::set('file_approved', $fID, $f);
} else {
$f->error = File::F_ERROR_INVALID_FILE;
}
return $f;
}
