<?
// *******************************************************************
//  include/show.php
// *******************************************************************

if(!isset($sr)){
	
	$sr=0;
}

$get_sites_count = sql_query("
	select
		ID
	from
		$tb_links
");

$total_sites = sql_num_rows($get_sites_count);

$sql = "
	select
		$tb_links.ID as site_id,
		$tb_links.SiteName as site_name,
		$tb_links.SiteURL as site_url,
		$tb_categories.Category as category_name,
		$tb_categories.ID as cat_id,
		$tb_links.Added as added,
		$tb_links.LastUpdate as last_update,
		$tb_links.Description as site_description,
		$tb_links.Country as country,
		$tb_links.HitsIn as hits_in,
		$tb_links.HitsOut as hits_out,
		count($tb_reviews.ID) as total_reviews
	from
		$tb_links
	left join
		$tb_categories
	on
		$tb_links.Category = $tb_categories.ID
	left join
		$tb_reviews
	on
		$tb_links.ID = $tb_reviews.SiteID
	group by
		site_id
	order by 
";

if($show == "new"){
	
	$sql .= "last_update ";
}

if($show == "cool"){
	
	$sql .= "hits_in ";
}

if($show == "pop"){
	
	$sql .= "hits_out ";
}

$sql .= "
		desc
	limit
		$sr, $pp
";

$get_sites = sql_query($sql);

echo draw_sites($total_sites, $get_sites);

?>