Viewing file:  renombre_viejas_portadas.php (1.06 KB) -rw-rw-r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
include ("../frames/conn.php");
echo "<pre>";
// buscamos los libros. Luego, sus portadas. numericas. Si existen, borramos las anteriores, y cambiamos la ruta al nuevo
$sql="select * from papyr225_papyre.sinopsis order by id_book desc " ;
$res=mysql_query($sql,$conn);
while ($row=mysql_fetch_array($res)){
if (strlen(trim($row['imagename']))>8 or intval(trim($row['imagename']))!=$row['id_book'].".jpg"){
echo "<br> libro {$row['id_book']} -- inamename= {$row['imagename']} ";
if (@file("/home/wwwroot/includes/{$row['id_book']}.jpg")){
echo "---------------EXISTE /home/wwwroot/includes/{$row['id_book']}.jpg";
//BORRAMOS EL ANTIGUO
unlink("/home/wwwroot/includes/{$row['imagename']}");
// actualizamos el nuevo
$sql2="update papyr225_papyre.sinopsis set imagename='{$row['id_book']}.jpg' where id_book={$row['id_book']} ";
mysql_query($sql2,$conn);
if (mysql_error()){
die(mysql_error());
}
}else{
echo "---------------FALTA /{$row['id_book']}.jpg";
}
}
}
?>
|