prepare("SELECT fileId FROM validations WHERE token=:token LIMIT 1;");
$query->execute(array(':token' => $token));
$validation = $query->fetchAll(PDO::FETCH_ASSOC);
if (!isset($validation[0])) {
echo 'Invalid token specified!';
die();
}
$query = $db->prepare("SELECT * FROM files WHERE id=:fileId LIMIT 1;");
$query->execute(array(':fileId' => $validation[0]['fileId']));
$file = $query->fetchAll(PDO::FETCH_ASSOC);
$file = $file[0];
if (isset($_GET['download'])) {
header($_SERVER["SERVER_PROTOCOL"] . " 200 OK");
header("Cache-Control: public");
header("Content-Transfer-Encoding: Binary");
header("Content-Length:".filesize($file['filePath']));
header("Content-Disposition: attachment; filename=" . basename($file['filePath']));
readfile($file['filePath']);
die();
} else if (isset($_GET['validate'])) {
$query = $db->prepare("UPDATE validations SET validated = 1 WHERE token=:token LIMIT 1;");
$query->execute(array(':token' => $token));
} else if (isset($_GET['infringement'])) {
$query = $db->prepare("UPDATE validations SET validated = 0 WHERE token=:token LIMIT 1;");
$query->execute(array(':token' => $token));
}
?>
Download File
Mark File as validated
Report copyright infringement