<?php 
	$show_message = 'n'; 
	
	$query = "SELECT m2a.model_id, m.name,  a.user_def_id  ";
	$query .= "FROM mod2vid  m2a ";
	$query .= " left join models m on  m.model_id = m2a.model_id ";	
	$query .= " left join assets a on  m2a.asset_id = a.asset_id ";	
	$query .= " where m2a.asset_id = '".$asset_id."' ";

	$result = mysql_query($query) or die("ERROR: <br>$query<br /> <strong>" . mysql_error()."</strong>");
	$model_name_nospace = '';
	$row = mysql_fetch_assoc($result);
		
	$starring_string = tour_models_starring($asset_id, $nats);
	$nolink_starring_string = nolink_models_starring($asset_id, $nats);
	
	$needles = array(" ", "&", ",");
	$name_nospace = str_replace($needles, '', $nolink_starring_string);
	
	
		if(isset($row["tour_title"])){	$tour_title  = $row["tour_title"];}
			$user_def_id  = $row["user_def_id"];

	$put_dir = HOGAL_ROOT."/".$asset_id."/".$name_nospace."_".$user_def_id."/"; 
	$hogal_url = HOGAL_URL."/".$asset_id."/".$name_nospace."_".$user_def_id."/"; 
	$static_page = $hogal_url."".$name_nospace.".php";
	$filename = $put_dir."".$name_nospace.".php";
	$main_pic_media = "P";
	
	// ==========================================================================================================	
	$page_name="../tour.php";
if(!isset($_GET["start"])) {                         // This variable is set to zero for the first page
$start = '0';
}else {$start = $_GET["start"];}

$eu = ($start); 
$limit = 1;                                 		// No of records to be shown per page.
$this1 = $eu + $limit; 
$back = $eu - $limit; 
$next = $eu + $limit; 



$query = " SELECT distinct(a.asset_id),  a.media, a.user_def_id, t2m.model_id, DATE_FORMAT(a.p_date, '%m.%d.%Y') as show_date,   a.description, UNIX_TIMESTAMP(a.p_date) as f_date, a.photos_count, t.free_link, t.tour_description, t.tour_title 
FROM mod2vid t2m, assets a, tour t 
WHERE ((t2m.asset_id = a.asset_id) and t.asset_id = a.asset_id) and a.asset_id = '".$asset_id."'   group by a.asset_id   order by a.p_date desc";

$result2 = mysql_query($query);
	$row2 = mysql_fetch_assoc($result2)or die('The scorn is so hot there it is creating an error: ' . mysql_error());
	$nume = mysql_num_rows($result2);
	$f_date = $row2["f_date"];
	$media = $row2["media"];
	$free_link = $row2["free_link"];
	$query .= " limit $eu, $limit";
	
	$result_main = mysql_query($query)or die('The sporn is so hot there it is creating an error: ' . mysql_error());
		$num_result_main = mysql_num_rows($result_main);
	$top_img_dir = "../tour/images/assets/".wordwrap($asset_id, 1, "/",1)."/".$asset_id;
	
	$url_dir = TOUR_URL."/images/".$asset_id."/topgraphic.jpg";
	
	$i='1';
?>