Bonjours,
Code : PHP
$timestamp = time();
$timestamp_5min = $timestamp - (60 * 5);
$timestamp_30min = $timestamp - (60 * 30);
$timestamp_1h = $timestamp - (60 * 60);
$timestamp_2h = $timestamp - (60 * 120);
$timestamp_1j = $timestamp - (60 * 1440);
$sql_select_query_site_visit = mysql_query("SELECT COUNT(*) AS nbr_entrees FROM $sql_table_3_1 WHERE Ip=´$pc_ip´");
$sql_donnees_site_visit = mysql_fetch_array($sql_select_query_site_visit);
$sql_select_query_site_visit_block = mysql_query("SELECT * FROM $sql_table_3_1 WHERE Ip=´$pc_ip´");
$sql_donnees_site_visit_block =
mysql_fetch_array($sql_select_query_site_visit_blo
ck);
$verif_block = $sql_donnees_site_visit_block[´Block´];
- Verifie les ip´s:
if($sql_donnees_site_visit[´nbr_entrees´] == "0")
{
mysql_query("INSERT DELAYED INTO $sql_table_3_1 (ID,Ip,Block,Prov,Timestamp)
VALUES(´´,´".$pc_ip."´,´´,´".$lien_ac_vi."´,´".$ti
mestamp."´)");
}
else
{
- Vérifie les fraudes:
if($verif_block == "0")
{
mysql_query("UPDATE $sql_table_3_1 SET Timestamp=´".$timestamp."´ ANd Prov=´".$lien_ac_vi."´ WHERE Ip=´$pc_ip´");
mysql_query("DELETE FROM $sql_table_3_1 WHERE Timestamp < ´".$timestamp_1h."´");
return true;
}
elseif($verif_block == "1")
{
mysql_query("UPDATE $sql_table_3_1 SET Timestamp=´".$timestamp."´ ANd Prov=´".$lien_ac_vi."´ WHERE Ip=´$pc_ip´");
mysql_query("DELETE FROM $sql_table_3_1 WHERE Timestamp < ´".$timestamp_2h."´");
redirect("
http://serveur-hack.fr/fraude.php");
return false;
}
}
j´ai réalisé ceci, pour bloquer des ip´s, genre si trop de tentative de connexion Block = 1;
le problème c´est que l´ip, s´update toutes les 2 à 3 pages, sa ve dire que j´ai les informations ip´s, etc..., et d´un coup je les ais plsu quand il change de page, et d´un coup je les ais à nouveau, j´ai du mal programmer pour une mauvaise "update", pouvez-vous m´aider !?
merci !