<?

include $_SERVER['DOCUMENT_ROOT'] . '/includes/conexion.php';
require $_SERVER['DOCUMENT_ROOT'] . '/includes/smarty.php';

$smarty = new Smarty_Bebosoft;

$smarty->assign('documentroot', $_SERVER['DOCUMENT_ROOT']);

if (!isset($_GET['fromnewid'])) {
	$fromnewid = 0;
} else {
	$fromnewid = $_GET['fromnewid'];
}

define('CUANTASNOVADMIN',20);
$myLanid = 2;

$sqlcmd = 'SELECT newid, title, summary, content, publishdate '
		. 'FROM news '
		. "WHERE lanid='$myLanid' AND status LIKE 'active' AND publishdate <= NOW() "
		. 'ORDER BY publishdate DESC '
		. "LIMIT $fromnewid, " . CUANTASNOVADMIN;

$resultado = mysql_db_query(DB_DATABASE, "$sqlcmd");
$cnt = 0;

while ($filas = mysql_fetch_object($resultado))
{
	$news[$cnt]['newid'] = $filas->newid;
	$news[$cnt]['title'] = $filas->title;
	$news[$cnt]['summary'] = $filas->summary;
	$news[$cnt]['publishdate'] = $filas->publishdate;
	$news[$cnt]['content'] = $filas->content;

	$sqlcmd2 = "SELECT nbyid FROM news_binary WHERE newid='" . $filas->newid . "'";
	
	$resultado2 = mysql_db_query(DB_DATABASE, "$sqlcmd2");
	
	if ($filas2 = mysql_fetch_object($resultado2)) {
		if ($filas2->nbyid > 0) {
			$news[$cnt]['haveimage'] = 'yes';
		} else {
			$news[$cnt]['haveimage'] = 'no';
		}
	}

	$cnt++;
}

$smarty->assign('news', $news);


# Determina si hace falta paginator, y el rango

$sqlcmd = 'SELECT count(*) AS cuantos '
		. 'FROM news '
		. "WHERE lanid='2' AND status LIKE 'active'";

$resultado = mysql_db_query(DB_DATABASE, "$sqlcmd");

if ($filas = mysql_fetch_object($resultado))
{
	$cuantos = $filas->cuantos;
}

if ($cuantos > CUANTASNOVADMIN)
{
	$smarty->assign('paginator', 'yes');

	# ACTUALDESDE
	$smarty->assign('actualfrom', $fromnewid + 1);

	#ACTUALHASTA
	$actualto = $fromnewid + CUANTASNOVADMIN;

	if ($actualto > $cuantos)
	{
		$actualto = $cuantos;
	}

	$smarty->assign('actualto', $actualto);

	# hace falta paginator siguiente?
	if (($cuantos - CUANTASNOVADMIN) > $fromnewid)
	{
		$smarty->assign('nextpage', 'yes');
	}

	# hace falta paginator anterior?
	if ($fromnewid > 0)
	{
		$smarty->assign('prevpage', 'yes');

		$prevpagefrom = $fromnewid - CUANTASNOVADMIN;

		if ($prevpagefrom < 0)
		{
			$prevpagefrom = 0;
		}

		$smarty->assign('prevpagefrom', $prevpagefrom);
	}
}

$smarty->assign('howmany', $cuantos);


$smarty->display($_SERVER['DOCUMENT_ROOT'] . '/novedades/index.tpl');

?>