<?php
	
	require_once("header.php");
	
	require_once("system/template.php");
	use system\template;

	$tpl = new Template("view/blog.html");

	$tpl->addFile("INCLUDE_HEADER", "view/header.html");

	$tpl->HEADER_TELEFONE = getStatic("site_telefone");
	$tpl->HEADER_EMAIL    = getStatic("site_email");
	$tpl->HEADER_FACEBOOK = trataEndereco(getStatic("site_facebook"));
	$tpl->HEADER_INT      = 'data-int="1"';

	$tpl->BLOG_FUNDO = getStatic("blog_fundo");

	$sqlCatBlog = mysql_query("SELECT * FROM site_blog_categorias ORDER BY ordem ASC");
	while($lnCatBlog = mysql_fetch_object($sqlCatBlog))
	{
		$resultBlog = mysql_num_rows(mysql_query("SELECT * FROM site_blog WHERE categoriaID = '".$lnCatBlog->ID."'"));

		if($resultBlog > 0)
		{
			$tpl->BLOG_CAT_ID   = $lnCatBlog->ID;
			$tpl->BLOG_CAT_NOME = $lnCatBlog->nome;
			$tpl->block("BLOCK_BLOG_CAT");
		}
	}

	// $sql = mysql_query("SELECT * FROM site_blog WHERE ID ORDER BY RAND() LIMIT 12");

	$sql = mysql_query("SELECT * FROM site_blog ORDER BY `site_blog`.`data_pub` DESC");	

	$cont = 0;
	while($ln = mysql_fetch_object($sql))
	{
		$cont++;

		$cat = @mysql_fetch_object(mysql_query("SELECT * FROM site_blog_categorias WHERE ID = '".$ln->categoriaID."'"));

		$tpl->LN_BLOG_CAT  = $cat->nome;
		$tpl->LN_BLOG_ID   = $ln->ID;
		$tpl->LN_BLOG_SLUG = slug($ln->titulo);
		$tpl->LN_BLOG      = $ln;

		if(($cont)%4 == 0)
		{
			$tpl->block('BLOCK_FIX');
		}

		$tpl->block("WHILE_BLOG");
	}

	$tpl->show();
	require_once("footer.php");
	die();	

?>