Viewing file:  antispamforo.php (7.34 KB) -rw-rw-r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
#if (@$_REQUEST['debug']=='true')antispam();
function antispam(){
return(''); // DESACTIVADO!
include ("../frames/conn.php");
$debug=false;
if ($_REQUEST['debug']=='true')$debug=true;
$counter=false;
$fecha=NEW DateTime(date("Y-m-d H:i:s"));
$fecha->modify("+".DIF_HORARIA." hour");
$conn=&mysql_connect(localhost,BBDDUSER,BBDDPASSWORD);
//ESTO DE MOMENTO LO ELIMINAMOS. pOR LO MENOS, HASTA QUE ENTREN BOTYS DE NUEVO. MIRAR EL id DESDE EL CUAL QUEREMOS TRABAJAR!
// nos cargamos los mensajes y topics de la gente con ID mayor a 84000, cuyas respuestas a las preguntas de perfil sean erróneas
// PUES NO, HAY PROBLEMILLAS
$limite_inferior=700000;
$sql="delete from ".BBDD_FORO.".phpbb_posts
WHERE poster_id
IN (select user_id from ".BBDD_FORO.".phpbb_profile_fields_data where (pf_queescomestible !=4 or pf_colorhierba!=3 and user_id > $limite_inferior)) ";
//echo $sql;
//mysql_query($sql,$conn);
//Los topics mejor que no, no sea que se produzca el borrado masivo de mensajes anterior
/*$sql="delete from ".BBDD_FORO.".phpbb_topics
WHERE topic_poster
IN (select user_id from ".BBDD_FORO.".phpbb_profile_fields_data where (pf_queescomestible !=4 or pf_colorhierba!=3))";
//echo $sql;
//mysql_query($sql,$conn);
*/
//ahora, los baneamos
$sql8="select * FROM ".BBDD_FORO.".phpbb_users t1 where t1.user_id>$limite_inferior and t1.user_id in (select t2.user_id from ".BBDD_FORO.".phpbb_profile_fields_data t2 where t2.user_id=t1.user_id and (t2.pf_queescomestible !=4 or t2.pf_colorhierba!=3)) and t1.user_id not in (select ban_userid from ".BBDD_FORO.".phpbb_banlist t3 where t3.ban_userid=t1.user_id)";
$resocho=mysql_query($sql8,$conn);
echo mysql_error();
while ($row_ocho=mysql_fetch_array($resocho)){
// vemos que respuesta hea dado mal:
$rowrespuestas=mysql_fetch_array(mysql_query("select user_id,pf_queescomestible, pf_colorhierba from ".BBDD_FORO.".phpbb_profile_fields_data where user_id={$row_ocho['user_id']}"));
if ($row_ocho['user_id']==8537){
echo "<pre>";
print_r($rowrespuestas);
}
if ($rowrespuestas['pf_queescomestible']!=4){
$sqlb="select * from ".BBDD_FORO.".phpbb_profile_fields_lang where field_id=1 and option_id=";
$resultado=$rowrespuestas['pf_queescomestible']-1;
$sqlb.=$resultado;
if ($debug){
echo "la sql es: ";
echo $sqlb;
$counter=true;
}
$rescom=mysql_query($sqlb,$conn);
$comestible=mysql_fetch_array($rescom);
}
if ($rowrespuestas['pf_colorhierba']!=3){
$sqlc="select * from ".BBDD_FORO.".phpbb_profile_fields_lang where field_id=3 and option_id=";
$resultado=$rowrespuestas['pf_colorhierba']-1;
$sqlc.=$resultado;
$counter=true;
$rescol=mysql_query($sqlc,$conn);
$colorhierba=mysql_fetch_array($rescol);
}
$ccadena="";
if ($comestible)$ccadena.="respuesta a QUE ES COMESTIBLE:{$comestible['lang_value']} (incorrecto), ";
if ($colorhierba)$ccadena.="respuesta a COLOR DE LA HIERBA:{$colorhierba['lang_value']} (incorrecto),";
$sql="insert into ".BBDD_FORO.".phpbb_banlist
(ban_userid,
ban_start,
ban_reason,
ban_give_reason)
values
({$row_ocho['user_id']},
".time().",
'respuesta',
'error en repuesta de usuario:{$row_ocho['username_clean']},$ccadena el dia ".$fecha->format("Y-m-d H:i:s")." {$row_ocho['post_text']}')";
if($debug){
echo $sql;
}
mysql_query($sql,$conn);
}
// nos cargamos los mensajes y topics de la gente con ICQ e intereses
//pUES TAMPOCO
$sql="delete from ".BBDD_FORO.".phpbb_posts
where post_id > 452000 and
poster_id
IN (
SELECT user_id
FROM ".BBDD_FORO.".phpbb_users
WHERE user_icq >0
AND user_interests > ''
)";
/*
mysql_query($sql,$conn);
$sql="delete from ".BBDD_FORO.".phpbb_topics
WHERE topic_poster
IN (
SELECT user_id
FROM ".BBDD_FORO.".phpbb_users
WHERE user_icq >0
AND user_interests > ''
)";
// mysql_query($sql,$conn);
*/
// ahora, los baneamos
$sql9="SELECT *
FROM ".BBDD_FORO.".phpbb_users
where user_id > 452000
and user_icq >0
AND user_interests > '' and user_id not in (select ban_userid from ".BBDD_FORO.".phpbb_banlist where 1=1)";
$resusu=mysql_query($sql9,$conn);
echo mysql_error();
while ($row_usu=mysql_fetch_array($resusu)){
$sql="insert into ".BBDD_FORO.".phpbb_banlist
(ban_userid,
ban_start,
ban_reason,
ban_give_reason)
values
({$row_usu['user_id']},
".time().",
'spammer',
'spammer {$row_usu['username_clean']} dia: ".$fecha->format("Y-m-d H:i:s")." {$row['post_text']}')";
mysql_query($sql,$conn);
$counter=true;
}
/*
// ahora, ponemos las estadisticas de ultimo escritor de post con el usuario correcto
if ($counter){
$sql="SELECT topic_id, topic_last_poster_id, topic_title, topic_last_poster_name
FROM ".BBDD_FORO.".phpbb_topics
WHERE topic_last_poster_id
IN (SELECT ban_userid
FROM ".BBDD_FORO.".phpbb_banlist
WHERE (
ban_reason LIKE '%respuesta%'
OR ban_reason LIKE '%spam%'
))";
if ($debug)echo $sql."<br>";
$res_ult=mysql_query($sql,$conn);
if ($debug)echo mysql_error()."<br>";
while ($topic=mysql_fetch_array($res_ult)){
// $topic['topic_id']
$sql="SELECT poster_id,post_id
FROM ".BBDD_FORO.".phpbb_posts
WHERE topic_id ={$topic['topic_id']}
ORDER BY post_id DESC limit 1 ";
$sustituir=mysql_fetch_array(mysql_query($sql,$conn));
$sql2="update ".BBDD_FORO.".phpbb_topics
set topic_last_poster_id=".$sustituir['poster_id']." ,
topic_last_post_id=".$sustituir['post_id']." ,
topic_last_poster_name=
(select username from phpbb_users where user_id=".$sustituir['poster_id'].")
where topic_id={$topic['topic_id']}";
if ($debug)echo $sql."<br>".$sql2."<br>";
// mysql_query($sql2);
if ($debug)echo mysql_error()."<br>";
}
}
*/
// segundo paso:
// ESTO DE MOMENTO LOELIMINAMOS, HASTA QUE APAREZCAN BOTS
/*
// buscamos la palabra choosing, arimidecs y similares
$sql="select * from ".BBDD_FORO.".phpbb_posts where post_text like '%choosing%' or post_text like '%to leave%'
or post_text like '%pharmaceutical%' or post_text like '% buy %' or post_text like '%arimidex%' or post_text like '%Wholesale%' or post_text like '% nude %' or post_text like '% celebrities %' or post_text like '%celebs%'";
$res=mysql_query($sql,$conn);
echo mysql_error();
//echo "<pre>";
//echo $sql."<br>";
while ($row=mysql_fetch_array($res)){
print_r($row);
// borrariamos el hilo entero
$sql="delete from ".BBDD_FORO.".phpbb_posts where topic_id={$row['topic_id']}";
mysql_query($sql,$conn);
$sql="delete from ".BBDD_FORO.".phpbb_topics where topic_id={$row['topic_id']}";
mysql_query($sql,$conn);
// buscariamos el poster_id
$sql="SELECT * FROM ".BBDD_FORO.".phpbb_users WHERE user_id ={$row['poster_id']}";
$rowusuario=mysql_fetch_array(mysql_query($sql,$conn));
$sql="insert into ".BBDD_FORO.".phpbb_banlist
(ban_userid,
ban_start,
ban_reason,
ban_give_reason)
values
({$row['poster_id']},
".time().",
'spammer',
'spammer {$rowusuario['username_clean']} dia: ".$fecha->format("Y-m-d H:i:s")." {$row['post_text']}')";
mysql_query($sql,$conn);
}
*/
//y para acabar, a ver si acabamos con "no leuidos" y los baneados que se hayan colado.
// $sql="delete from ".BBDD_FORO.".phpbb_topics_posted
//where user_id in (select ban_userid from ".BBDD_FORO.".phpbb_banlist where 1=1 )";
//echo $sql;
//mysql_query($sql,$conn);
}
?>
|