Viewing file:  controller_subcat.php (3.44 KB) -rw-rw-r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<? include ("header.php");?>
<body>
<?// aqui, metemos la comprobación. De no estar identificado, lo largamos a index.php
include ("/home/wwwroot/frames/conn.php");
include ("/home/wwwroot/frames/classes/class.log.php");
mysql_query("SET NAMES 'utf8'",$conn);
$control= new control();
$encriptado=new Encriptor();
if ($control->usuario=="anonimo"){
// redirigimos
?>
<script type="text/javascript">
window.location="<?echo "/1a1b/m/index.php";?>";</script>
<?}
$lu=15;
// fin comprobacion identidad
$cat=reSanitizar($encriptado->decrypt($_REQUEST['id2']));
$subcat=reSanitizar($encriptado->decrypt($_REQUEST['id']));
$ld=reSanitizar($encriptado->decrypt($_REQUEST['ld']));
$limit="$ld,$lu";
if (trim($limit)<3){
$limit="0,$lu";
$ld=0;
}
IF ($cat=="JARL"){
$cat='%';
$subcat='%';
}
$sql="SELECT * from libros where genero like '$cat'
and subgenero like '".$encriptado->decrypt($_REQUEST['id'])."' and inftp=1 order by fecha_subida desc limit $limit";
$counter_sql=" select count(*) as contador from libros where genero like '$cat'
and subgenero like '".$encriptado->decrypt($_REQUEST['id'])."' and inftp=1 ";
$counter_libros=mysql_fetch_array(mysql_query($counter_sql,$conn));
?>
<div data-role="page" id="controller_subcat" data-theme="<?echo $formato;?>">
<?echo cabecera();?>
<div role="main" class="ui-content" data-role="content">
<div class="content-primary">
<?if ($cat=="%"){
$cat= "Ultimas subidas";
$subcat="por fecha";
}?>
<div class="ui-body ui-body-b ui-corner-all">
<p style='text-align : center'><h3>Libros en <?echo "$cat/$subcat";?></h3></p>
</div>
<div class="ui-body ui-body-b ui-corner-all">
<ul data-role="listview">
<?
$res=mysql_query($sql,$conn);
while ($row=mysql_fetch_array($res)){
$id_book=$encriptado->encrypt($row['id']);
$titulo= $row['titulo'];
$autor= $row['autor'];
$version=$row['version'];
?>
<li>
<?
echo "<a href='enlace.php?ID=$id_book'>";
$portada=$localhost."/includes/".$row['id'].".jpg";
?>
<img src="<? echo $portada;?>" />
<h3><? echo $titulo." ".$version; echo " <i><small> (".($row['anyo']).")</small></i>";?></h3>
<p style="font-size : small;"><? echo $autor;?>
<? IF ($cat=="Ultimas subidas");
echo "<img src='http://i87.servimg.com/u/f87/13/67/94/49/upload10.png' />".
substr($row['fecha_subida'],0,10);?>
</p>
</a></li>
<?
}
?>
</ul>
</div><!-- ui-body ui-body-b ui-corner-all-->
<hr>
<?if ($ld>0){?>
<a href="./controller_subcat.php?id=<?echo $_REQUEST['id'];?>&id2=<?echo $_REQUEST['id2'];?>&lu=<?echo ($encriptado->encrypt(15));?>&ld=<?echo ($encriptado->encrypt($ld-15));?>" data-role="button" data-inline="true">«-15</a>
<?}?>
<?if ($counter_libros['contador'] > $ld+15 ){?>
<a href="./controller_subcat.php?id=<?echo $_REQUEST['id'];?>&id2=<?echo $_REQUEST['id2'];?>&lu=<?echo ($encriptado->encrypt(15));?>&ld=<?echo ($encriptado->encrypt($ld+15));?>" data-role="button" data-inline="true">+15»</a>
<?}?>
</div> <!--div role="content-primary"-->
</div> <!--div role="main"-->
<? include ("./footer.php");?>
</div> <!-- div data-role="page" id="controller_subcat"> -->
</body>
</html>
|