 |
|
|
|
|
execute($sql);
if($rs->numrows){
subtitulo("DESCARGAS");
while(!$rs->eof){
$titulo=$rs->field("advTitulo");
$link=$rs->field("advLink");
$descripcion = $rs->field("advDescripcion");
$ext=substr($link,strrpos($link,".")+1,strlen($link));
$formato="nn.gif";
if($ext=="pdf"){$formato="pdf.gif";}
if($ext=="xls"){$formato="excel.gif";}
if($ext=="doc"){$formato="word.gif";}
include("archivos_asoc_tpl.php");
$rs->movenext();
}}?>
'D' and b.attrib<>'M' order by fsn.orden, fse.orden, fsc.orden, fsl.orden, b.date desc,b.attrib desc";
$sql_FS_N = "select advID as ID,muestrafecha as MF,child,a.orden,b.date as date1,'N' as attrib from fsFAT a, fsFiles b left join fsFiles_N fs on (b.id=fs.file_id) where a.parent='$id' and a.child=b.id and b.attrib='N' and fs.activo='S'"; //se agegro activo='S'
$sql_FS_E = "select advID as ID,'N' as MF,child,a.orden,b.date as date1,'E' as attrib from fsFAT a, fsFiles b left join fsFiles_E fs on (b.id=fs.file_id) where a.parent='$id' and a.child=b.id and b.attrib='E'";//se agegro activo='S' and fs.activo='S'
$sql_FS_C = "select advID as ID,'N' as MF,child,a.orden,b.date as date1,'C' as attrib from fsFAT a, fsFiles b left join fsFiles_C fs on (b.id=fs.file_id) where a.parent='$id' and a.child=b.id and b.attrib='C'";//se agegro activo='S' and fs.activo='S'
$sql_FS_L = "select advID as ID,'N' as MF,child,a.orden,b.date as date1,'L' as attrib from fsFAT a, fsFiles b left join fsFiles_L fs on (b.id=fs.file_id) where a.parent='$id' and a.child=b.id and b.attrib='L'";//se agegro activo='S' and fs.activo='S'
$sql = "($sql_FS_N) union ($sql_FS_E) union ($sql_FS_C) union ($sql_FS_L)";
$rs1 = $conn->execute($sql." order by orden,date1,attrib limit $curr,$disprows");
//echo $sql." order by orden limit $curr,$disprows";
if (!isset($max) || trim($max)==""){
$sqlaux = "$sql";
$rsaux = $conn->execute($sqlaux);
$max = $rsaux->numrows;
unset($rsaux);
}
$numpage=ceil($max/$disprows);
if(!isset($currpage) || trim($currpage)==""){$currpage=1;}
if($rs1->numrows && !is__dir($id)){
subtitulo("ARTICULOS RELACIONADOS");
}
while(!$rs1->eof)
{
$child=$rs1->field("child");
$muestrafecha = $rs1->field("MF");
$imagen = $rs1->field("ID");
$tipo = $rs1->field("attrib");
switch($tipo){
case "N":
$imgChiquita = "ico_nove_noticias.gif";
include("lista_N_tpl.php");
break;
case "L":
$imgChiquita = "ico_nove_link.gif";
include("lista_L_tpl.php");
break;
case "E":
$imgChiquita = "ico_nove_empresas.gif";
include("lista_E_tpl.php");
break;
case "C":
$imgChiquita = "ico_nove_calendario.gif";
include("lista_C_tpl.php");
break;
}
$rs1->movenext();
}
//LISTA SUBTEMAS DE NIVEL 2
$nivel=get__pathlevel($id);
if($nivel>0 && is__dir($id)){
$handler=$fs->open__dir($id);
$id_file=$handler->read__dir();
if($id_file){
//subtitulo(" ");
}
while($id_file){
if(is__dir($id_file)){
include("dir_nivel2_tpl.php");
}
$id_file=$handler->read__dir();
}
}
?>
|
|
| |
|
|
$disprows || $go){
while(list($var,$val)=each($_GET)){
if($var!="go" && $var!="max" && $var!="currpage" && $var!="a"){
$url_pag.= $var."=".$val."&";
}
}
?>
|
|
=0){?>
 Anterior
|
5){$ii=$ii+$currpage-3;}
while($ii<=$numpage-1 && $i <= 7){
if($currpage==$ii){
?>
|
Siguiente 
|
|
|
|
|
| |
|
|
|
$disprows || $go){
while(list($var,$val)=each($_GET)){
if($var!="go" && $var!="max" && $var!="currpage" && $var!="a"){
$url_pag.= $var."=".$val."&";
}
}
?>
|
|