Viewing file:  adfly_pba.php (2.72 KB) -rw-rw-r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
echo " ejecutar solo desde consola";
include "/home/wwwroot/frames/conn.php";
$sql="select count(0) AS `contador`,`estadistica`.`id_book` AS `id_book`,`libros`.`titulo` AS `titulo`,`libros`.`autor` AS `autor`,`libros`.`id` AS `id`,`libros`.`inftp` AS `inftp`,
`libros`.`ruta`,
`libros`.`ruta_epub`,
`libros`.`ruta_mobi`,
`libros`.`ruta_adfly`,
`libros`.`ruta_adfly_epub`,
`libros`.`ruta_adfly_mobi`
from (`estadistica` join `libros`)
where ((`estadistica`.`id_book` = `libros`.`id`)
and
(`estadistica`.`id_book` > 9)
and
(`libros`.`inftp` = 1))
group by `estadistica`.`id_book` order by count(0) desc limit 300;";
$sql="select * from libros where `id` > 9
and
`libros`.`inftp` = 1
and
(`libros`.`ruta_adfly` is null or `libros`.`ruta_adfly`='' or
`libros`.`ruta_adfly_epub` is null or `libros`.`ruta_adfly_epub`='' or
`libros`.`ruta_adfly_mobi` is null or `libros`.`ruta_adfly_mobi`=''
)
order by id desc
limit 20
";
$res=mysql_query($sql,$conn);
echo mysql_error();
flush();
while ($row=mysql_fetch_array($res)){
$url_fb2="http://api.adf.ly/api.php?key=879318edd7ca516aea4f0eda3da867df&uid=3147378&advert_type=int&domain=adf.ly&url=".$row['ruta'];
$url_epub="http://api.adf.ly/api.php?key=879318edd7ca516aea4f0eda3da867df&uid=3147378&advert_type=int&domain=adf.ly&url=".$row['ruta_epub'];
$url_mobi="http://api.adf.ly/api.php?key=879318edd7ca516aea4f0eda3da867df&uid=3147378&advert_type=int&domain=adf.ly&url=".$row['ruta_mobi'];
//usleep(100000);
if (!$row['ruta_adfly'] or $row['ruta_adfly']==''){
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $url_fb2);
curl_setopt ($ch, CURLOPT_RETURNTRANSFER, 1);
$response = curl_exec ($ch);
curl_close($ch);
echo $url_fb2.chr(10);
$sql2="update papyr225_papyre.libros set ruta_adfly='$response' where id={$row['id']}";
echo $sql2.chr(10);
mysql_query($sql2,$conn);
echo mysql_error().chr(10);
}
if (!$row['ruta_adfly_epub'] or $row['ruta_adfly_epub']==''){
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $url_epub);
curl_setopt ($ch, CURLOPT_RETURNTRANSFER, 1);
$response = curl_exec ($ch);
curl_close($ch);
echo $url_epub.chr(10);
$sql2="update papyr225_papyre.libros set ruta_adfly_epub='$response' where id={$row['id']}";
echo $sql2.chr(10);
mysql_query($sql2,$conn);
echo mysql_error().chr(10);
}
if (!$row['ruta_adfly_mobi'] or $row['ruta_adfly_mobi']==''){
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $url_mobi);
curl_setopt ($ch, CURLOPT_RETURNTRANSFER, 1);
$response = curl_exec ($ch);
curl_close($ch);
echo $url_mobi.chr(10);
$sql2="update papyr225_papyre.libros set ruta_adfly_mobi='$response' where id={$row['id']}";
echo $sql2.chr(10);
mysql_query($sql2,$conn);
echo mysql_error().chr(10);
}
}
|