$SQL = "select media_instance.instance,\n\t\t\t\t\t\t\tmedia_instance.file_type,\n media_item.id as media_item_id,\n\t\t\t\t\t\t\tmedia_item.slug, \n\t\t\t\t\t\t\tmedia_vfolder.vfolder_path\n\t\t\t\t\tfrom media_instance\n\t\t\t\t\tleft join media_item on media_item.id = media_instance.media_item_id and media_item.active = 1\n\t\t\t\t\tleft join media_vfolder on media_item.media_vfolder_id = media_vfolder.id and media_vfolder.active = 1\n\t\t\t\t\twhere media_instance.active = 1\n\t\t\t\t\tand media_instance.id = {$media_instance_id}";
// die($SQL);
$r = $db->Execute($SQL) or die("{$SQL}<br>" . $db->ErrorMsg());
if (!$r->EOF) {
$slug = $r->Fields('slug');
$instance = $r->Fields('instance');
if ($instance) {
$instance_folder = '/' . $instance;
}
$file_type = $r->Fields('file_type');
$vfolder_path = $r->Fields('vfolder_path');
$dest_dir = $sky_media_local_path . $vfolder_path . $instance_folder;
$local_path = $dest_dir . '/' . $slug . '.' . $file_type;
if (!file_exists($local_path)) {
include_once 'lib/core/class.media.php';
media::get_if_not_here($r->Fields('media_item_id'), $sky_media_src_path, $file_type, $local_path, $dest_dir);
}
if (file_exists($local_path)) {
$content = $sky_content_type[$file_type];
header("Content-type: {$content}");
$ft = filemtime($local_path);
$modified = strftime("%a, %d %b %Y %T GMT", $ft);
header('Last-Modified: ' . $modified);
$t = strtotime("+35 days");
$expires = strftime("%a, %d %b %Y %T GMT", $t);
header('Expires: ' . $expires);
header('Content-Length: ' . filesize($local_path));
readfile($local_path);
exit(0);
}
}
