prepare("SELECT COUNT(*) AS ip FROM ip_banned WHERE ip= ? LIMIT 0, 1"); $request->execute(array( retrieve_ip() )); $data = $request->fetch(); $ip=$data['ip']; $request->closeCursor(); if ($ip>=1)//si l'ip de l'utilisateur se trouve dans la base de données des bannis { $request = $_VAR['system']['data_base']->prepare("SELECT * FROM ip_banned WHERE ip= ? LIMIT 0, 1"); $request->execute(array( retrieve_ip() )); $data=$request->fetch(); $id =$data['id']; $ip =$data['ip']; $time_banned =$data['time_banned']; $number_visit =$data['number_visit']+1; $time_last_visit =$data['time_last_visit']; //on met à jour les informations sur le banni dans la bbd (inutile mais bon... :) ) $request = $_VAR['system']['data_base']->prepare('UPDATE ip_banned SET number_visit = :number_visit, time_last_visit = :time_last_visit WHERE id = :id'); $request->execute(array( 'number_visit' => $number_visit, 'time_last_visit' => time(), 'id' => $id )); //on lui met un petit message et on arrete le script (lui bloquant acces au site) echo "'; exit(); } } catch(Exception $e) { die('Error : '.$e->getMessage()); } }