<?php
$mimeTypes  = array('pdf' => 'application/pdf', 'jpg' => 'image/jpeg', 'mpg' => 'application/binary', 'wmv' => 'video/x-ms-wmv', 'flv' => 'application/octet-stream', 'avi' => 'video/x-msvideo');
$file_id    = (isset($_GET['file_id']))     ? $_GET['file_id']      : false;

//RM povezava na bazo, dobimo file glede na file_id
$result = mysql_query("SELECT ftp_filename, original_filename, file_extension FROM `files` WHERE `file_id`='$file_id' LIMIT 0,1");
$rows   = mysql_fetch_array($result);

//RM če datoteka obstaja jo izpišemo drugače vržemo 404 error header
if (isset($rows[0])) {
    $filename = $rows [0]['ftp_filename'];

    //RM je datoteka na FTP-ju (obstaja), je berljiva, velikost večja od 0
    if (file_exists($filename) and is_readable($filename) and filesize($filename) > 0) {
        $original   = $rows [0]['original_filename'];
        $mimetype   = $mimeTypes[$rows[0]['file_extension']]; // dobimo ven vedno pravi mimetype (zgoraj defenirani)

        header("Content-length: ".filesize($filename));
        header("Content-type: $mimetype");
        header("Content-Disposition: attachment; filename=$original");
        header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
        readfile($filename);
        exit;
    } else {
        header("HTTP/1.0 404 Not Found");
        echo 'file_not_found_on_ftp.jpg';
    }
} else {
    header("HTTP/1.0 404 Not Found");
    echo 'file_not_found_in_db.jpg';
}
?>