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