Viewing file:  elimina_usuarios_baneados.php (1.01 KB) -rw-rw-r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
$pos=strpos($_REQUEST['mail'],'@');
if (!$_REQUEST['mail'] or $pos === false){
echo "mail no p�sado";
die();
}
echo "<pre>";
//borrar usuarios del foro. datos por e-mail
include ("../frames/conn.php");
include ("../frames/classes/class.log.php");
$control= new control();
if ($control->usuario=="darklooker"){
$sql="select * from ".BBDD_FORO.".phpbb_users where user_email='{$_REQUEST['mail']}'";
echo $sql."<br>";
$res=mysql_query($sql,$conn);
$row=mysql_fetch_array($res);
//print_r($row);
echo "<h1>usuario:{$row['user_id']}</h1>";
//lo borramos
$sql2="delete from ".BBDD_FORO.".phpbb_users where user_id={$row['user_id']}";
mysql_query($sql2,$conn);
echo mysql_error();
$sql3="delete from ".BBDD_FORO.".phpbb_banlist where ban_userid={$row['user_id']}";
mysql_query($sql3,$conn);
echo mysql_error();
$sql4="delete from ".BBDD_FORO.".phpbb_profile_fields_data where user_id={$row['user_id']}";
mysql_query($sql4,$conn);
echo mysql_error();
}
?>
|