<?
session_start();
include('admin/db.php');
if(!is_numeric($_GET[id])) {
	header($_SERVER['SERVER_PROTOCOL']." 404 Not Found");
	header("Location: $basehttp/404.php");
	exit();
}
$id = mysql_real_escape_string($_GET[id]);

//update views
@mysql_query("UPDATE content_views SET views = (views + 1) WHERE content = '$id'"); 
$cacheName = "video".$id;
$cacheResult = getCache($cacheName);

if($cacheResult) {
        $rrow = $cacheResult;
} else {
	$result = mysql_query("SELECT content.*, content_views.views as views, users.username as username FROM content LEFT JOIN users ON users.record_num = content.submitter LEFT JOIN content_views ON content_views.content = content.record_num WHERE content.record_num = '$id' LIMIT 0,1") or die(mysql_error());	
	$rrow = mysql_fetch_assoc($result); 
	if(mysql_num_rows($result) < 1) { 
		header($_SERVER['SERVER_PROTOCOL']." 404 Not Found");
		header("Location: $basehttp/404.php");
		exit(); 
	}
	if($rrow[paysite] != 0) {
		$paysiteq = mysql_query("SELECT paysites.name, paysites.url FROM paysites WHERE record_num = '$rrow[paysite]'");
		$prow = mysql_fetch_assoc($paysiteq);
		$rrow[paysiteurl] = $prow[url];
		$rrow[paysitename] = $prow[name];
	}
	else {
		$rrow[paysiteurl] = $basehttp;
		$rrow[paysitename] = $sitename;
	}
	if(!$rrow[username]) { $rrow[username] = 'Anonymous'; }
        setCache($cacheName,$rrow,$video_cache_time);
}

if($rrow[plug_url]) {
	header("Location: $rrow[embed]");
	exit();
}

$title = "$rrow[title]";
$metakeywords = "$rrow[title] tube video, $rrow[keywords]";
$metadescription = "$rrow[description]";

$ads = getAds($rrow[paysite],$rrow[channel]);

if($isMobile) {
	include($basepath.'/templates/mobile.video_header.php');
}
else {
	include($basepath.'/templates/template.video_header.php');
}


if($rrow[photos] == 1) {
	if($isMobile) {
		include($basepath.'/templates/mobile.gallery_content.php');
	}
	else {
		include($basepath.'/templates/template.gallery_content.php');
	}
}
else {
	if($isMobile) {
		include($basepath.'/templates/mobile.video_content.php');
	}
	else {
		include($basepath.'/templates/template.video_content.php');
	}
}

if($isMobile) {
	include($basepath.'/templates/mobile.video_footer.php'); 
}
else {
	include($basepath.'/templates/template.video_footer.php'); 
}
?>