Viewing file:  ftpuploadsinopsisnuevo.php (6.68 KB) -rw-rw-r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<head>
<!-- END -->
<link rel="stylesheet" type="text/css" href="nuevo.css">
<link rel="STYLESHEET" type="text/css" href="estilo.css">
</head>
<body>
<?php
include("conn.php");
include("class.imagetransform.php");
#print_r($_REQUEST) ;
if ($_SERVER) {
$realip = $_SERVER["REMOTE_ADDR"];
} else {
$realip = getenv( 'REMOTE_ADDR' );
}
$Arrayextension_imagen=explode(".",$_FILES['imagen']['name']);
$extensionimagen=$Arrayextension_imagen[count($Arrayextension_imagen)-1];
$fecha=date("Y-m-d H:i:s");
if ($imagen=$_FILES['imagen']['name']){
$imagen=$_FILES['imagen']['name'];
echo "<h1>imagen es $imagen<h1>";
$localfile = $_FILES['imagen']['tmp_name'];
//modificacion con clase imagetransform.php
$newimagen=$_REQUEST['ID'].".".$extensionimagen;
@chmod("../includes/$newimagen",0777);
@unlink ("../includes/$newimagen");
$imgTrans = new imageTransform();
$imgTrans->sourceFile = $localfile;
$imgTrans->chmodValue = 0777;
$imgTrans->targetFile = "../includes/$newimagen";
$imgTrans->resizeToWidth = 132;
$imgTrans->resizeToHeight = 216;
$imgTrans->resize();
#print_r($imgTrans);
echo "\n";
echo $tamano=filesize("../includes/$newimagen");
echo "\n";
}
// primero vemos si no existe: insertamos.
$sqla="select * from sinopsis where id_book='{$_REQUEST['ID']}'";
$resa=mysql_query($sqla,$conn);
@$rowa=mysql_fetch_array($resa);
if (!$rowa){
// no exista, insertamos
echo "insercion";
$querysip="insert into sinopsis (id_book, sinopsis) values ('{$_REQUEST['ID']}','{$_REQUEST['sinopsis']}')";
mysql_query($querysip,$conn);
echo mysql_error();
if(!EMPTY($_FILES['imagen']['name'])){
$querysip="update sinopsis set imagename='$newimagen' where id_book='{$_REQUEST['ID']}'";
mysql_query($querysip,$conn);
$querysip="update sinopsis set tamano_imagen=$tamano where id_book='{$_REQUEST['ID']}'";
mysql_query($querysip,$conn);
}
$querysip="update libros set sinopsis='*' where id={$_REQUEST['ID']}";
//echo $querysip."<br>";
mysql_query($querysip,$conn);
ECHO mysql_error();
}elseif (!EMPTY($_FILES['imagen']['name'])){
echo "actualizando imagen ";
// no existe imagen
$querysip="update sinopsis set imagename='$newimagen' where id_book='{$_REQUEST['ID']}'";
mysql_query($querysip,$conn);
if ($rowa['tamano_imagen']<>$tamano){
$querysip="update sinopsis set tamano_imagen=$tamano where id_book='{$_REQUEST['ID']}'";
mysql_query($querysip,$conn);
}
// solo por subir imagen, no voy a poner sinopsis en OK!!
//$querysip="update libros set sinopsis='*' where id={$_REQUEST['ID']}";
//echo $querysip."<br>";
//mysql_query($querysip,$conn);
}elseif (!empty($_REQUEST['sinopsis'])){
echo "actualizando sinopsis ";
// no existe sinopsis
$querysip="update sinopsis set sinopsis='{$_REQUEST['sinopsis']}' where id_book='{$_REQUEST['ID']}'";
$anyo=$_POST['anyo'];
settype($anyo,"int");
mysql_query($querysip,$conn);
$querysip="update libros set sinopsis='*', anyo=$anyo where id={$_REQUEST['ID']}";
//echo $querysip."<br>";
mysql_query($querysip,$conn);
}
/*
$sql="SELECT t1.session_user_id, t2.username_clean as usuario
FROM phpbb_sessions t1, phpbb_users t2
WHERE t1.session_user_id = t2.user_id
AND t1.session_id = '".$_REQUEST['phpbb3_f6ktf_sid']."'";
$res2=mysql_query($sql,$conn);
$row2=mysql_fetch_array($res2);
if ($row2['usuario']=='anonymous' or !$row2['usuario']){
$usuario="an�nimo";
}else{
$usuario=$row2['usuario'];
}
$fecha=date("Y-m-d H:i:s");
$query="insert estadistica (id_book,
fecha,
ip ,
titulo,
autor,
accion,
nick)
values(
{$_REQUEST['ID']},
'$fecha',
'$realip',
'{$row['titulo']}',
'{$row['autor']}',
'sinopsis',
'$usuario'
)";
mysql_query($query,$conn);
*/
$sqlf="select * from sinopsis where id_book='{$_REQUEST['ID']}'";
$resf=mysql_query($sqlf,$conn);
$rowf=mysql_fetch_array($resf);
$rand=rand(1111,9999);
?><center><img src="../includes/<?php echo $rowf['imagename']."?qwfe=$rand";?>"></img>
<table border=1 whidth=width='450'><tr><td><?php echo $rowf['sinopsis'];?></table>
<br><center>
<a href='javascript:history.back(-1)' style="text-decoration:none"><img src=volver.png border=0></img></a>
<?php
//echo '<center><a href ="entradilla.php"><img src="papyreicon.gif" WIDTH=32 HEIGHT=32></img><B>P�gina Principal</B></a>';
mysql_close($conn);
/*
function elimina_acentos($cadena){
$tofind = "�������������������������������������������������������+[]?�!�,;�";
$replac = "nnAAAAAAaaaaaaOOOOOOooooooEEEEeeeeCcIIIIiiiiUUUUuuuuyNn___----_-i";
return(strtr($cadena,$tofind,$replac));
}
*/
function imgress($diror,$dirdest,$val,$qual){
$q=$qual;
//open the directory
if (is_dir($diror)) {
if ($dh = opendir($diror)) {
while (($file = readdir($dh)) !== false) {
if($file == "." || $file == ".."){continue;}
$k=explode(".",$file);
if(strpos($k[1],"jpg")===0 || strpos($k[1],"jpeg")===0){
$salva=$dirdest.$file;
$image=$diror.$file;
$im =imagecreatefromjpeg("$image");
$x=imagesx($im);
$y=imagesy($im);
if ($x<>132 or $y<>216){
$k=array("salidaenfalso","salidaenfalso");
}
$thumbnail=imagecreatetruecolor(132,216);
$im_ridimensionata=imagecopyresized( $thumbnail, $im, 0, 0, 0, 0, 132,
216, $x, $y);
imagejpeg($thumbnail, $salva, $q);
}
elseif(strpos($k[1],"gif")===0){
$salva=$dirdest.$file;
$image=$diror.$file;
$im =imagecreatefromgif("$image");
$x=imagesx($im);
$y=imagesy($im);
$thumbnail=imagecreatetruecolor(132,216);
$im_ridimensionata=imagecopyresized( $thumbnail, $im, 0, 0, 0, 0, 132,
216, $x, $y);
imagegif($thumbnail, $salva, $q);
}
elseif(strpos($k[1],"png")===0){
$salva=$dirdest.$file;
$image=$diror.$file;
$im =imagecreatefrompng("$image");
$x=imagesx($im);
$y=imagesy($im);
$thumbnail=imagecreatetruecolor(132,216);
$im_ridimensionata=imagecopyresized( $thumbnail, $im, 0, 0, 0, 0, 132,
216, $x, $y);
imagepng($thumbnail, $salva, $q);
}
else{
echo "$diror File not compatible(no jpg,gif or png)";
}
flush();
}
closedir($dh);
}else{
echo "no se pudo abrir";
}
}
}
?>
</body>
|