Viewing file:  send_to_mirror.php (2.13 KB) -rw-rw-r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
include("./classes/encdec.php");
include("./conn.php");
include("./classes/class.http_client.php");
include("./classes/class.encriptacion.php");
// esta es una query para sacar los libros que no coinciden su timestamp. Eso es que est�n sin actualizar
$sql="SELECT * FROM libros as t1, mirror_libros as t2 WHERE t2.bbdd='libros' and t1.id=t2.id_book and t1.timestamp<>t2.timestamp ";
$pid="1234";
$ptask="sql_fetch";
$pparams="SELECT t1.id as id ,t1.autor,t1.genero,t1.subgenero,t1.titulo,t1.anyo,t1.fecha_subida,t1.correo,t1.tamano,t1.sinopsis,t1.comentarios,t1.ruta,t1.rapidshare,t1.rapidshare_kill,t1.megaupload,t1.megaupload_kill,t1.zshare,t1.zshare_kill,t1.descargas,t1.inftp,t1.ruta2,t1.tiempo,t1.programa,t1.borrar FROM libros as t1, mirror_libros as t2 WHERE t2.bbdd='libros' and t1.id=t2.id_book and t1.tiempo<>t2.tiempo";
$ptimestamp="2010-03-23 12:00:01";
$tratamiento=new encriptacion($pid,$ptimestamp,$ptask,$pparams);
@$cweb=new http_Client($mirror."/frames/mirror_operation.php","ver=$tratamiento->ver&base=$tratamiento->base&tim=$tratamiento->tim&task=$tratamiento->task¶ms=".$tratamiento->params);
echo(trim($cweb->result));
$xml = simplexml_load_string(trim($cweb->result));
//print_r($xml);
$insert_campos="insert into libros (";
$insert_values="values (";
$duplicate=" ON DUPLICATE KEY UPDATE ";
foreach ($xml->registro as $registro){
foreach ($registro->valor_campo as $valor_campo){
//echo $valor_campo->field."\n";
//echo $valor_campo->valor."\n";
$insert_campos.="$valor_campo->field,";
$duplicate.=$valor_campo->field;
if (strpos("--".$valor_campo->type,"int")>0){
// es un numero
$insert_values.="$valor_campo->valor,";
$duplicate.="=$valor_campo->valor,";
}else{
// no es un numero
$insert_values.=utf8_decode("'$valor_campo->valor',");
$duplicate.=utf8_decode("='$valor_campo->valor',");
}
}
}
$insert_campos=substr($insert_campos,0,strlen($insert_campos)-1).")";
$insert_values=substr($insert_values,0,strlen($insert_values)-1).")";
$duplicate=substr($duplicate,0,strlen($duplicate)-1);
$sql=$insert_campos.$insert_values.$duplicate;
?>
|