<?php	    //require_once("foro/foro_login.php");require_once("common/utils.php");require_once("common/config.php.inc");require_once("common/init.php");
require_once(CLASSES_DIR.'dao.class.php'); require_once(CLASSES_DIR.'auth.class.php');
require_once(CLASSES_DIR.'user.class.php');  require_once(CLASSES_DIR.'documentedDao.class.php');require_once(CLASSES_DIR.'itemDao.class.php');    //require_once(CLASSES_DIR.'categoryDao.class.php'); //require_once(CLASSES_DIR.'user.class.php');
	global $smarty;

	$user = trim($_REQUEST['login_usuario']);	$pass = trim($_REQUEST['password_usuario']);	
	//print("user: ".$user."<br>");
	//die("pass: ".$pass);
    	//agregado!, no me cargaba la session...
    	session_start();
	if($user ==""  or $pass==""){		
		$login = 0 ;
		HTMLRedirect(HTTP_DIR . "/");
		exit();
	}
	
	$auth = new Auth ("frontend");	$auth->authUser($user,$pass);	$login = 0;
	if($user=="" or $pass=""){
		return false;
	}
    	if ( $auth->isLogged ()) 		$login= true;//foro_login($_REQUEST["login_usuario"]);	//die("login: ".$login);
		/*
		$user = new userDao();		$user = $user->get($auth->getUserLogged(),"","");		$user = $user->getOne();		*/
		
		//HTMLRedirect(HTTP_DIR );
		//exit();
		
	
	$userID = $auth->getUserLogged();
	$userN = new userDao();
	$userN = $userN->get($userID,"","");
	$userN = $userN->getOne();
	
	$smarty->assign('userLoged',	            	$user);	   
	$smarty->assign('isloged',          		$login);
	$smarty->assign('usrId',     			$userN	->usrId);
   	$smarty->assign('user_name',		$_POST['user_name']); 
	$smarty->assign('password',			$_POST['password']);	
	$smarty->assign('squareTop', 		getSquare(2));     //1 position_block
	$smarty->assign('squareButton',		getSquare(3));     //2 position_block
	$smarty->assign('skyscrapers', 		getSkyscraper());
	$smarty->assign('skinsize', 			getSkinSize());	
	$smarty->assign('mediumsize', 		getMediumsize());	
	$smarty->assign('bannersModule', 		getAllBannersModule());
	$smarty->assign('modules',			getAllModules());
	$smarty->assign('instances',			getInstances());
	
	$smarty->display($templateDir . 'modules/portal/home/templates/index.htm');
	
	//********************************************************************
	//    FUNCIONES
	//********************************************************************
function  getSubSections($nameSection){
	global $db;
	$sql = "SELECT are_sessions.* FROM are_sessions INNER JOIN are_sections
			WHERE are_sections.id_section = are_sessions.id_section
			AND are_sections.section_name = '".$nameSection."' ORDER BY are_sections.section_name, are_sessions.ssnPosition";
	$rs = $db->execute($sql);
	$rs = $rs->getArray();
	return $rs;
}
function getTop5Game($type){
	global $db;
	$sql = "SELECT are_contents.* FROM are_contents " .
		   "JOIN are_content_types ON are_content_types.id_content_type = are_contents.cntId_content_type " .
		   "JOIN are_contents_type_statistics ON are_contents_type_statistics.id_content = are_contents.cntId_content " .
		   "WHERE are_content_types.type_name = 'Juegos' " . 
		   "AND  are_contents_type_statistics.type_statistics = '".$type."' ".
		   "ORDER BY are_contents_type_statistics.value_statistic desc LIMIT 0,5 ";
	$rs = $db->execute($sql);
	$rs = $rs->getArray();
	return($rs);
}

function getMoreViewGallery(){
	global $db;
	$sql = "SELECT are_contents.cntContent_title, are_contents.cntId_content, are_contents.cntSummary 
			FROM are_contents INNER JOIN are_content_types 
			INNER JOIN are_contents_type_statistics
			WHERE are_content_types.id_content_type = are_contents.cntId_content_type
			AND are_contents_type_statistics.id_content = are_contents.cntId_content
			AND (are_content_types.type_name = 'Galeria de Fotos'
			OR are_content_types.type_name = 'Galeria de Videos')
			AND are_contents.cntContent_status = 'published'
			AND are_contents_type_statistics.type_statistics = 'more view'
			ORDER BY are_contents_type_statistics.value_statistic desc LIMIT 0,2";
	$rs = $db->execute($sql);
	$rs = $rs->getArray();
	return $rs;
}

function getSkinSize(){
	global $db;
	$sql = "select are_instances_block.*, are_blocks.*, are_banners.*, are_type_banners.* 
			from are_banners, are_blocks, are_instances_block, are_type_banners, are_modules 
			where are_modules.id_module = are_blocks.id_module
			and are_blocks.id_block = are_instances_block.id_block
			and are_blocks.position_block = 1
			and are_instances_block.id_content_instance = are_banners.bnrId
			and are_banners.tbnId_type_banner = are_type_banners.tbnId_type_banner
			and are_type_banners.tbnType_Banner = 'kingSize 810x90px' 
			and are_instances_block.type_union = 'are_banners'
			and are_blocks.visible_block = 'true' ";

	$rs = $db->execute($sql);
	$rs = $rs->getArray();	


	foreach($rs as $key => $valor)
		$rs[$key]['tbnType_file_banner'] = substr($valor['bnrFile_banner'], (strrpos($valor['bnrFile_banner'],'.')+1));
	return $rs;
}
function getMediumsize(){
	global $db;
	$sql = "select are_instances_block.*, are_blocks.*, are_banners.*, are_type_banners.* 
			from are_banners, are_blocks, are_instances_block, are_type_banners, are_modules 
			where are_modules.id_module = are_blocks.id_module
			and are_blocks.id_block = are_instances_block.id_block
			and are_blocks.position_block = 1
			and are_instances_block.id_content_instance = are_banners.bnrId
			and are_banners.tbnId_type_banner = are_type_banners.tbnId_type_banner
			and are_type_banners.tbnType_Banner = 'MediumSize 600x80px' 
			and are_instances_block.type_union = 'are_banners'
			and are_blocks.visible_block ='true'";
	$rs = $db->execute($sql);
	$rs = $rs->getArray();	

	foreach($rs as $key => $valor)
		$rs[$key]['tbnType_file_banner'] = substr($valor['bnrFile_banner'], (strrpos($valor['bnrFile_banner'],'.')+1));
	return $rs;	   
}
function getLastContent(){
	global $db;
	$sql = "SELECT are_contents.cntId_content, are_contents.cntContent_title, are_sessions.ssnName_session, are_contents.cntSummary 
			FROM are_contents INNER JOIN  are_sessions INNER JOIN are_content_types
			WHERE are_contents.ssnId_session = are_sessions.ssnId_session 
			AND are_content_types.id_content_type = are_contents.cntId_content_type
			AND are_content_types.type_name = 'Editorial'
			AND are_contents.cntContent_status = 'published'
			ORDER BY are_contents.cntContent_creation_date asc LIMIT 0,3";
	$rs = $db->execute($sql);
	$rs = $rs->getArray();
	return $rs;		
}

function getTop10(){
	global $db;
	$sql = "SELECT are_contents.cntId_content, are_contents.cntContent_title, are_sessions.ssnName_session FROM are_contents_type_statistics " .
		   "INNER JOIN are_contents JOIN are_sessions INNER JOIN are_content_types " .
		   "WHERE are_contents.cntId_content = are_contents_type_statistics.id_content " .
		   "AND are_contents_type_statistics.type_statistics = 'more view' " .
		   "AND are_content_types.id_content_type = are_contents.cntId_content_type ".
		   "AND are_sessions.ssnId_session = are_contents.ssnId_session ".
		   "AND are_contents.cntContent_status = 'published' ".
		   "ORDER BY are_contents_type_statistics.value_statistic desc LIMIT 0,10";
	$rs = $db->execute($sql);
	$rs = $rs->getArray();	   
	return $rs;
}

function getItems(){	
	$dao = new itemDao();
	$rs = $dao->get(""," Not(itmPublished = 'NULL') ","");
	$out = array();
	foreach($rs->list as $valor)
		array_push($out, $valor); 	   
	return ($out);
}

//Esta funcion retorna todos los contenidos que estan 
//publicados ademas indicando en que modulo y bloque se encuentran
function getInstances(){
	global $db;
	$sql = "SELECT * FROM are_modules, are_blocks, are_instances_block " .
		   "WHERE are_modules.id_module = are_blocks.id_module AND " .
		   "are_blocks.id_block = are_instances_block.id_block " .
		   "ORDER BY are_modules.id_module, are_instances_block.instance ";
	$rs = $db->execute($sql);
	$rs = $rs->getArray();
	return $rs;	   
}

function getAllBannersModule(){
	global $db;
	$sql = "SELECT * FROM are_banners INNER JOIN are_modules 
			INNER JOIN are_blocks INNER JOIN are_instances_block INNER JOIN are_type_banners
			WHERE are_banners.bnrId = are_instances_block.id_content_instance 
			AND are_blocks.id_block = are_instances_block.id_block 
			AND are_modules.id_module = are_blocks.id_module
			AND are_instances_block.type_union = 'are_banners'
			AND are_banners.tbnId_type_banner = are_type_banners.tbnId_type_banner 						AND are_blocks.visible_block = 'true' 			
			ORDER BY are_m