include ('lib/class.TemplatePower.inc.php');
include ('lib/class.DataPager.inc.php');
include ('config.php');
$tplname = 'txt3.tpl';
$pagesize = 30; // Tamaño máximo de documentos por página
$HTTP_GET_VARS=$_GET;
$HTTP_POST_VARS=$_POST;
$page=$HTTP_GET_VARS['page']; // Si no página, página = 1
if (empty($page))
$page = 1;
$conn = @mysql_connect($db_host, $db_user, $db_passwd);
@mysql_select_db($db_name);
$color = array('#EBEFF5', '#CDDCEF');
$i = 1;
$cerca=$_GET["paraula"];
if ($cerca=="") { $sql = "SELECT * FROM consejero ORDER BY ID DESC"; }
else {
$sql = "SELECT * FROM consejero WHERE MATCH(noticia) AGAINST ('$cerca') ORDER by ID DESC";
}
$dp = new datapager($conn, $sql);
$res = $dp->execute($page, $pagesize);
$tpl = new TemplatePower ($tplname);
$tpl->prepare();
// Impresión resultados HTML
if ($dp->recordcount > 0) {
$tpl->assign('page', $dp->page);
$tpl->assign('pagecount', $db->pagecount);
$tpl->assign('cerca',$cerca);
while ($k = mysql_fetch_row($res)) {
$tpl->newBlock('data');
$i = ($i + 1) % 2;
$tpl->assign('color',$color[$i]);
$tpl->assign('ID', $k[0]);
$tpl->assign('titulo', stripslashes($k[1]));
}
$tpl->gotoBlock ('_ROOT');
$tpl->assign ('prev', $dp->prevpage("<\n") );
$tpl->assign ('pagelinks', $dp->pagelinks("%page%", "%page%") );
$tpl->assign ('next', $dp->nextpage(">\n") );
} else {
$tpl->gotoBlock ('_ROOT');
$tpl->assign ('pagelinks', 'No se han encontrado resultados con este criterio');
}
$txt = $tpl->getOutputContent();
$txt3 ="
";
$tpl2 = new TemplatePower ( "tpl/main.tpl" );
$tpl2->assignInclude( "TXT", $txt, T_BYVAR );
$tpl2->assignInclude("IMA", $txt3, T_BYVAR );
$tpl2->prepare();
$tpl2->printToScreen();
?>