"); $liste=$link->query('SELECT * FROM `phpbb_3users` WHERE `user_inactive_time` != 0 ORDER BY `user_id` ASC'); while($membre=$liste->fetch_assoc()) { //$i=$i+1; $count_r=$link->query("SELECT COUNT(*) FROM `nospam` WHERE `ip` LIKE '".$membre['user_ip']."'"); //echo($membre['user_ip']."="); $q_spam=$link->query("SELECT COUNT(*) FROM `nospam` WHERE `ip` LIKE '".$membre['user_ip']."'"); $q=$q_spam->fetch_assoc(); $ct=$q['COUNT(*)']; //echo($ct."
"); if($ct>0){kill($membre['username'],$membre['user_ip'],$membre['user_email'],$membre['user_id'],$ct);} } //SELECT * FROM `phpbb3_users` WHERE `user_inactive_time` != 0 $liste=$link->query('SELECT * FROM `phpbb_3users` WHERE `user_inactive_time` != 0 ORDER BY `user_id` ASC'); echo(''); while($membre=$liste->fetch_assoc()) { $i=$i+1; echo('"); } function kill($user,$ip,$mail,$id,$ct) { echo($user."--".$ip."--".$id."--".$ct."
"); $link = mysqli_connect("mehariclglobale.mysql.db", "mehariclglobale", "Pva131254", "mehariclglobale"); $req1="DELETE FROM `phpbb_3users` WHERE `phpbb_3users`.`user_id` = ".$id; //echo($req1."
"); $req2="DELETE FROM `phpbb_3user_group` WHERE `phpbb_3user_group`.`user_id` = ".$id; //echo($req2."
"); $req3="INSERT INTO `nospam` (`id`, `date`, `ip`, `pseudo`, `mail`) VALUES (NULL, CURRENT_DATE(), '".$ip."', '".$user."', '".$mail."')"; $req4="INSERT INTO `phpbb_3banlist` (`ban_id`, `ban_userid`, `ban_ip`, `ban_start`, `ban_end`, `ban_exclude`) VALUES (NULL, '0', '".$ip."', '".time()."', '0', '0')"; $link->query($req1); $link->query($req2); $link->query($req3); $link->query($req4); } //echo('Kill'); //INSERT INTO `nospam` (`id`, `date`, `ip`, `pseudo`, `mail`) VALUES (NULL, '2022-05-17', '127.0.0.1', 'pva', 'toto@wanadoo.com'); //UPDATE `phpbb3_users` SET `user_rank` = '8' WHERE `phpbb3_users`.`user_id` = 12849; ?>

'.date("d-mY H:i",$membre['user_regdate'])."

". ''.$membre['user_ip'].''. "

".$membre['username']."

".$membre['user_email']."

" .$membre['user_id']. 'Kill'. "