Viewing file:  purga_phplist.php (3.02 KB) -rw-rw-r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
include ($_SERVER["DOCUMENT_ROOT"]."/frames/conn.php");
include ("/home/wwwroot/frames/conn.php"); // solo para consola
$encontrado=0;
$noencontrado=0;
$totales=0;
//echo $query="select username, user_email,FROM_UNIXTIME(user_lastvisit) as ultima from papyr225_phpb1.phpbb_users where user_email>'' and user_lastvisit < (UNIX_TIMESTAMP()-12960000) ";
echo $query="select username, user_email,FROM_UNIXTIME(user_lastvisit) as ultima
from papyr225_phpb1.phpbb_users
where user_email>'' and user_lastvisit < (UNIX_TIMESTAMP()-23667694) ";
$res=mysql_query($query,$conn);
echo chr(10).$res.mysql_error();
while($row=mysql_fetch_array($res)){
$totales++;
echo "++++++++++++++++++++".chr(10);
echo $sql="select * from phplist.phplist_user_user where email='{$row['user_email']}'";
echo chr(10);
$res2=mysql_query($sql,$conn);
echo mysql_error().chr(10);
if (mysql_numrows($res2)>0){
$encontrado++;
echo "\n -----------------------------------------<br> \n";
echo "\n <b>CLIENTE ENCONTRADRO. PARA BORRAR:</B><br> \n";
echo $row['username']."-".$row['user_email']."-".$row['ultima']."<br>";
echo "\n -----------------------------------------<br> \n";
$list=mysql_fetch_array($res2);
echo "identificativo: ".$list['id'].", mail ".$list['email']."<br>";
echo chr(10);
$sql3="delete from phplist.phplist_user_user where email='{$row['user_email']}'";
$res3=mysql_query($sql3,$conn) or die(mysql_error());
echo chr(10);
$sql3="delete from phplist.phplist_listuser where userid={$list['id']}";
$res3=mysql_query($sql3,$conn) or die(mysql_error());
// procedemos a su borrado
}else{
$noencontrado++;
echo chr(10)."->no encontrado";
}
echo "<br> totales: $totales, encontrados=$encontrado, no encontrados=$noencontrado";
//boramos los que est�n en phplist.bajas
$sqlbaja="select * from phplist.bajas where 1=1";
$resbaja=mysql_query($sqlbaja,$conn);
while($rox=mysql_fetch_array($resbaja)){
$mail=$rox['user'];
$sql="select * from phplist.phplist_user_user where email='$mail'";
$res2=mysql_query($sql,$conn);
if (mysql_numrows($res2)>0){
$encontrado++;
$list=mysql_fetch_array($res2);
echo "borrando identificativo: ".$list['id'].", mail ".$list['email']."<br>".chr(10);
$sql3="delete from phplist.phplist_user_user where email='{$list['email']}'";
$res3=mysql_query($sql3,$conn) or die(mysql_error());
$sql3="delete from phplist.phplist_listuser where userid={$list['id']}";
$res3=mysql_query($sql3,$conn) or die(mysql_error());
}
}
?>
|