par
JohnSteven » 01 févr. 2011, 22:38
J'ai trouve qqchose qui ressemble a ca:
$time_flood = '60'; //
mysql_query("DELETE FROM flood WHERE dernier + $time_flood < " . time());
$resultat = mysql_query(
"SELECT dernier FROM flood WHERE ip='$_SERVER[REMOTE_ADDR]'");
if(mysql_num_rows($resultat) > 0 )
echo 'vous spammez !';
else mysql_query("INSERT INTO flood VALUES ('$_SERVER[REMOTE_ADDR]', '" . time() . "')");
?>
Ma fonction d'envoi est comme ca:
private function addShout($nickname = null, $ville = null, $gsm = null, $message = null) {
$time = date('Y-m-d H:i:s');
$query = mysql_query("INSERT INTO `shouts` (`nickname`, `ville`, `gsm`, `message`, `date_added`) VALUES ('".$nickname."', '".$ville."', '".$gsm."', '".$message."','".$time."');");
if(!$query) {
$this->returnShouts(null, 'Database connection problem!');
} else {
$this->returnShouts('Shout added successfully');
}
Je sais pas comment l'integrer en fait. J'ai deja un INSERT INTO
J'ai trouve qqchose qui ressemble a ca:
[php]
$time_flood = '60'; //
mysql_query("DELETE FROM flood WHERE dernier + $time_flood < " . time());
$resultat = mysql_query(
"SELECT dernier FROM flood WHERE ip='$_SERVER[REMOTE_ADDR]'");
if(mysql_num_rows($resultat) > 0 )
echo 'vous spammez !';
else mysql_query("INSERT INTO flood VALUES ('$_SERVER[REMOTE_ADDR]', '" . time() . "')");
?>[/php]
Ma fonction d'envoi est comme ca:
[php]private function addShout($nickname = null, $ville = null, $gsm = null, $message = null) {
$time = date('Y-m-d H:i:s');
$query = mysql_query("INSERT INTO `shouts` (`nickname`, `ville`, `gsm`, `message`, `date_added`) VALUES ('".$nickname."', '".$ville."', '".$gsm."', '".$message."','".$time."');");
if(!$query) {
$this->returnShouts(null, 'Database connection problem!');
} else {
$this->returnShouts('Shout added successfully');
}
[/php]
Je sais pas comment l'integrer en fait. J'ai deja un INSERT INTO