<?

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['newid'])) {
	$newid = $_GET['newid'];
} else {
	header("Location: /novedades/");
	exit;
}

$sqlcmd = 'SELECT newid, title, content, publishdate '
		. 'FROM news '
		. "WHERE newid='$newid' AND status LIKE 'active' LIMIT 1";

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

if ($filas = mysql_fetch_object($resultado)) {
	$smarty->assign('title', $filas->title);
	$smarty->assign('content', $filas->content);
	$smarty->assign('publishdate', $filas->publishdate);
	$smarty->assign('newid', $newid);
	
	$sqlcmd2 = "SELECT nbyid FROM news_binary WHERE newid='" . $newid . "'";
	
	$resultado2 = mysql_db_query(DB_DATABASE, "$sqlcmd2");
	
	if ($filas2 = mysql_fetch_object($resultado2)) {
		if ($filas2->nbyid > 0) {
			$smarty->assign('haveimage', 'yes');
		} else {
			$smarty->assign('haveimage', 'no');
		}
	}

} else {
	header("Location: /novedades/");
	exit;
}

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

?>