|
<%
/*Paginado*/
$disprows=10;
if (!isset($go) || trim($go)=="")
{
$go=0;
}
$curr=$go;
$prev=$go - $disprows;
$next=$go + $disprows;
/*se fija si debe mostrar las imágenes de todas las categorías*/
if($catID){$filtro=" and catID='$catID'";}
else{$filtro="";}
if($advTitulo){$filtro_titulo=" and advTitulo like '%$advTitulo%' ";}
else{$filtro_titulo="";}
if($ListaUser=="ls_usuario"){$filtro_usuario=" and advAutor='$usradID' ";}
else if($ListaUser=="ls_todos"){$filtro_usuario="";}
$sql = "select A.* from ADVF A
where advTipo='F' $filtro
$filtro_titulo
$filtro_usuario
order by advFecha desc
limit $curr,$disprows";
$rs = $conn->execute($sql);
if (!isset($max) || trim($max)=="")
{
$sqlaux = "select count(*) as CANT from ADVF
where advTipo='F' $filtro
$filtro_titulo
$filtro_usuario
";
$rsaux = $conn->execute($sqlaux);
$max=$rsaux->field(CANT);
}
$numpage=ceil($max/$disprows);
if(!isset($currpage) || trim($currpage)=="")
{
$currpage=1;
}
%>
<%if($ListaTipo=="text"){%>
<%
$color="#eeefff";
while(!$rs->eof)
{
%>
>
|
<%=$rs->field(advTitulo)%> (<%=img_size($rs->field(advLink))%>)
|
<%
if($color=="#eeefff"){$color="#dcdcee";}
else if($color=="#dcdcee"){$color="#eeefff";}
$rs->movenext();
}
%>
<%} else if($ListaTipo=="images"){%>
<%
$color="#eeefff";
while(!$rs->eof)
{
$sp=0;
%>
>
|
<%if (substr($rs->field(advLink),-3)!="swf"){$source=getimagesize("../".GetThumbnailName ($rs->field(advLink), "100x100"));}%>
|
<%
if($color=="#eeefff"){$color="#dcdcee";}
else if($color=="#dcdcee"){$color="#eeefff";}
$rs->movenext();
}
%>
<%}%>
<%if($prev>=0){%> <%}else{%> <%}%> |
<%if($currpage<$numpage){%> <%}else{%> <%}%> |
| <%=$I_page%> <%=$currpage%> <%=$I_of%> <%=$numpage%> (<%=$max%> <%=$I_images%>) |
|
|
|
<%}%>