Viewing file:  listatwitter.php (5.64 KB) -rw-rw-r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<? $iskindle = strpos($_SERVER['HTTP_USER_AGENT'],'Kindle');
$isiphone = strpos($_SERVER['HTTP_USER_AGENT'],'Mobile');
$isandroid=strpos($_SERVER['HTTP_USER_AGENT'],'Android');
$pagina="http://m.papyrefb2.net/listatwitter_mobile.php?q1={$_REQUEST['q1']}";
if ($iskindle || $isiphone || $isandroid){
Header("Location: $pagina");
die();
}
?><head>
<meta http-equiv='Content-Type' content='text/html; charset=iso-8859-1' />
<link rel="stylesheet" type="text/css" href="nuevo.css">
<link rel="STYLESHEET" type="text/css" href="estilo.css">
</head>
<?php
$fecha=date('Y-m-d', strtotime('-1 days'));
if ($_REQUEST['q1']){
// amos a ver...
// cogemos el array que viene con los libros.
//el separador es || , y viene encriptado, claro
// el array de libros, se llama q1, y el encabezamiento que pondremos, se llama q2
$array_parametros=explode("@@**@@",$_REQUEST['q1']);
include "conn.php";
$cript = new Encriptor();
$libros_bruto=$cript->decrypt($array_parametros[0]);
$texto=$cript->decrypt($array_parametros[1]);
$array_libros=explode ("||",$libros_bruto);
$ccadenalibros="";
foreach ($array_libros as $key =>$valor){
$ccadenalibros.=",".$valor;
}
$ccadenalibros=substr($ccadenalibros,2);
echo "<center><a href='http://www.papyrefb2.net'><img src='http://papyrefb2.net/frames/logo.jpg?324' /></a></center><br>";
echo "<center><h2>$texto</h2></center>";
if (strpos($texto,'+')){
$texto2="(POR DEFECTO,ORDENADO POR POPULARIDAD)";
$default_sort=false;
}else{
$texto2="(POR DEFECTO,ORDENADO POR FECHA)";
$default_sort=true;
}
}else{
die();
}
function abrir_masiva($value_of_clicked_field, $array_with_the_values_of_all_fields_in_clicked_row)
{
$enlace= $array_with_the_values_of_all_fields_in_clicked_row["ruta"];
return "javascript:document.location.href='enlace.php?enlace=".base64_encode($enlace)."&ID={$array_with_the_values_of_all_fields_in_clicked_row['id']}'";
// return "javascript:window.open('enlace.php?enlace=".base64_encode($enlace)."&ID={$array_with_the_values_of_all_fields_in_clicked_row['id']}','',Directories='NO',Titlebar='',Toolbar='NO',Location='NO',resizable='YES', scrollbars='YES',width=300,height=100,top=85,left=140)";
}
require "./class.datagrid.php";
echo "<br> ";
echo "<center>Puede ordenar la lista a su gusto, simplemente pulsando en las cabeceras <B>en negrita</B> $texto2<BR>";
echo "<br> ";
if (@!$_REQUEST['valor2']){
$titulo="%";
}else{
$titulo=$_REQUEST['valor2']."%";
}
$query="select
t1.id,
t1.autor,
t1.genero,
t1.subgenero as tematica,
concat (t1.titulo,' <b>',t1.version,'</b>') as titulo,
t1.fecha_subida,
t1.tamano,
t1.programa as maquetacion,
t1.sinopsis as sinop,
t1.numero_comentarios as coment,
t1.votos as votos,
t1.puntuacion,
(
SELECT count( * ) AS contador
FROM `estadistica`
WHERE fecha > '$fecha 00:00:00'
AND fecha < '$fecha 23:59:59'
and id_book=t1.id
GROUP BY id_book ) as descargas ,
t1.ruta,
t1.anyo as a�o
from libros as t1
where t1.id in ($ccadenalibros)
";
$time_start = microtime(true);
$grid = new dataGrid($query,$conn);
// bound the function to the rows
//$grid->setRowActionFunction("action");
$grid->setlanguage("spanish");
$grid->rowsOnPage=100;
$grid->showColumn("autor");
$grid->showColumn("titulo");
$grid->showColumn("a�o");
$grid->showColumn("genero");
$grid->showColumn("tematica");
$grid->showColumn("tamano");
//$grid->showColumn("sinop");
$grid->showColumn("coment");
$grid->showColumn("maquetacion");
$grid->showColumn("votos");
$grid->showColumn("puntuacion");
$grid->showColumn("fecha_subida");
//$grid->showColumn("descargas");
$grid->setColumnHTMLProperties("autor", "align=center");
$grid->setColumnHTMLProperties("titulo", "align=left");
$grid->setColumnHTMLProperties("a�o", "align=center");
$grid->setColumnHTMLProperties("genero", "align=center");
$grid->setColumnHTMLProperties("tematica", "align=center");
$grid->setColumnHTMLProperties("tamano", "align=center");
$grid->setColumnHTMLProperties("sinop", "align=center");
$grid->setColumnHTMLProperties("coment", "align=center");
$grid->setColumnHTMLProperties("votos", "align=center");
$grid->setColumnHTMLProperties("puntuacion", "align=center");
$grid->setColumnHTMLProperties("fecha_subida", "align=center");
//$grid->setColumnHTMLProperties("descargas", "align=center");
if ($default_sort){
$grid->setDefaultSortColumn("fecha_subida","DESC");
}else{
$grid->setDefaultSortColumn("descargas","DESC");
}
$grid->enableSorting("autor") ;
$grid->enableSorting("a�o") ;
$grid->enableSorting("tamano");
$grid->enableSorting("titulo" );
$grid->enableSorting("votos" );
$grid->enableSorting("puntuacion" );
//$grid->enableSorting("descargas");
//$grid->setRowActionFunction("titulo","action");
$grid->unsetActionFunction("titulo");
$grid->unsetActionFunction("autor");
$grid->unsetActionFunction("genero");
$grid->unsetActionFunction("fecha_subida");
$grid->setActionFunction("titulo","abrir_masiva");
$grid->setActionFunction("autor","abrir_masiva");
$grid->setActionFunction("genero","abrir_masiva");
$grid->setActionFunction("tamano","abrir_masiva");
$grid->setActionFunction("votos","abrir_masiva");
$grid->setActionFunction("puntuacion","abrir_masiva");
$grid->setActionFunction("fecha_subida","abrir_masiva");
$grid->render();
$time_end = microtime(true);
ECHO $time = $time_end - $time_start;
?>
|