<?php
    //invalid id number, so we 404
    if (!is_numeric($_GET['id'])) {
        pageNotFound();
    } else {
        $id = $_GET['id'];
    }
   
    $rrow = dbQuery("SELECT content_deleted.* FROM content_deleted WHERE content = '$id' LIMIT 0,1", true, $video_cache_time);
    $rrow = $rrow[0];
    $rrow = unserialize($rrow['data']);
    $softDelete = true;

    if (!is_numeric($rrow['record_num'])) {
        pageNotFound();
    }

    //grab ads
    $ads = getAds($rrow['paysite']);

    //seo
    $title = $rrow['title'];
    $metadescription = truncate($rrow['description'], 156);
    $metakeywords = $rrow['keywords'];

    if ($rrow['paysite'] != 0) {
        $paysiteq = dbQuery("SELECT paysites.name, paysites.url FROM paysites WHERE record_num = '$rrow[paysite]'");
        $prow = $paysiteq[0];
        $rrow['paysiteurl'] = $prow['url'];
        $rrow['paysitename'] = $prow['name'];
    } else {
        $rrow['paysiteurl'] = $basehttp;
        $rrow['paysitename'] = $sitename;
    }

    //prepend force related to related string
    if ($rrow['force_related']) {
        $rrow['related'] = $rrow['force_related'] . ',' . $rrow['related'];
    }
    
    $rrow[embed] = "Deleted";

setMessage(_t("We're sorry, the content titled %title has been deleted from our site and is no longer available.", array('%title' => $rrow['title'])), 'error');

    getTemplate('template.video_header.php'); 
    getTemplate('template.video_content.php'); 
    getTemplate('template.video_footer.php');
?>