<?php 
	$show_message = 'n'; 
	
	$query = "SELECT m.name, m.description,  t2m.model_id, t2m.asset_id, 
	UNIX_TIMESTAMP(a.p_date) as f_date   ";
	$query .= "FROM mod2vid t2m, models m, assets a ";
	$query .= "where t2m.model_id = m.model_id and t2m.asset_id = a.asset_id and  a.site_id = '".CURR_SITE_ID."' and t2m.model_id = '".$model_id."' ";
	$result = mysql_query($query) or die('Query failed: ' . mysql_error());
	$row_model = mysql_fetch_assoc($result);
	$f_date = $row_model["f_date"];
	$description = $row_model["description"];
	

	$title_add = $row_model["name"];
	$name = $row_model["name"];
	$name_nospace = str_replace(' ', '', $name);
	
	
	$static_page = TOUR_URL."/model/$name_nospace/$name_nospace.php";
	$top_img_dir = TOUR_ROOT."/images/model/".substr($row_model["name"], 0, 1)."/".$row_model["name"];
	$url_dir = TOUR_URL."/images/model/".substr($row_model["name"], 0, 1)."/".$row_model["name"]."/";
	
	
// ==========================================================================================================		
	$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 = 5;                                 		// 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, t.free_link, t.tour_title,  t.tour_description
FROM mod2vid t2m, assets a, tour t  
WHERE (t2m.asset_id = a.asset_id)  and (t.asset_id = a.asset_id) and  t.site_id = '".CURR_SITE_ID."' and a.hide_photo <> 'y' and t.tour_title <> ''  and t2m.model_id = '$model_id' 
group by a.asset_id order by t.tour_date desc";

// and a.p_date <= '".date('Y-m-d')."'
	$result2 = mysql_query($query);

	$row2 = mysql_fetch_assoc($result2)or die('error: ' .$query. mysql_error());
	$media = $row2["media"];
	$asset_id = $row2["asset_id"];
	$f_date = $row2["f_date"];
	$free_link = $row2["free_link"];

	$nume = mysql_num_rows($result2);

	$query .= " limit $eu, $limit";
	$result_main = mysql_query($query)or die('error: ' .$query. mysql_error());
		$num_result_main = mysql_num_rows($result_main);
?>