<? include("../../db.inc.php");
include("../../classes/templates.php");
$template=new Template("home");

$sql="select * from tags where id= ".$_GET["id"]."";
if(!(   $tag=SQLread($sql)   )){ header("location:/"); die(); }


$where_host = "and articles.site_http_host='".$host_main."' ";


if( !isset($_GET["pager"]) ){ $pager = 1; }else{$pager=addslashes($_GET["pager"]);  };
$offset = 20;
//-------------------------------get nr total rows
$sql="select count(article_id) as nr from articles_tags
	  inner join articles on articles_tags.article_id=articles.id
	  where articles_tags.tag_id=".$tag["id"]." and vizible=1 ".$where_host." ";
$num_rows=SQLread($sql);	
 
//-------------------------------get pages
$num_pages = ceil($num_rows["nr"]/$offset);


//get articles
$sql="select articles.id, articles.name, articles.abstract, articles.picture, created, hasMedia, comments_nr, articles_sections.section_id as section
	  from articles_tags 
	  inner join articles on articles_tags.article_id=articles.id
	  inner join articles_sections on articles_sections.article_id=articles.id
	  where articles_tags.tag_id=".$tag["id"]." and vizible=1 ".$where_host." 
	  order by id desc
	  limit ". (($pager-1)*$offset) . "," . $offset;
$articles=SQL2Array($sql);
$nr_articles = count($articles);

//-----set header
$css_for_layout[] = array("section.css");
$title=$tag["name"];
$location[]=array("link"=>"","name"=>$tag["name"]);
include("views/tag.php");
?>