Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- if ($naaa > 3) {
- echo "error";
- } else {
- $sql = "INSERT INTO messages (user,message,textcolor,date) VALUES (:sas,:asas,:asafs,$time_limit)";
- $q = $db->prepare($sql);
- $q->execute(array(':sas'=>$user,':asas'=>$message,':asafs'=>$text));
- echo '<div style="color:'.$text.'">'.$user .' : '. $message.'</div>';
- }
- $oneMinute = 60; // 60 seconds in a minute
- $threshold = $oneMinute * 3; // we want three minutes to be our cutoff
- $compareTime = time() - $threshold; // messages since 3 seconds ago
- $query = "SELECT COUNT(1) FROM `messages` WHERE `sent` > $compareTime;";
- <?php
- session_start();
- // Check if we stored the last message sent date to session
- $lastTime = ( isset( $_SESSION["lastTime"] ) ) ? (int)$_SESSION["lastTime"] : false;
- // Check if we stored the number of times user sent messages in a row
- $hasError = ( isset( $_SESSION["hasError"] ) ) ? (int)$_SESSION["hasError"] : 0;
- // if we got the last message sent time
- if ( $lastTime ) {
- $difference = ( time() - $lastTime );
- if ( $difference < 10 ) { // 10 seconds
- // increase the number of messages user sent in a row
- $_SESSION["hasError"] = $hasError = ( $hasError + 1 );
- }
- else {
- // else reset the counter to 0
- $_SESSION["hasError"] = $hasError = 0;
- }
- }
- // if user trying to send more that 3 messages in a row
- if ( $hasError > 3 ) {
- // show the error
- echo "error";
- }
- else {
- // save the last sent time
- $_SESSION["lastTime"] = time();
- // insert message to db
- $sql = "INSERT INTO messages( user, message, textcolor, date ) VALUES( :sas, :asas, :asafs, $time_limit )";
- $q = $db->prepare ($sql );
- $q->execute( array( ':sas' => $user, ':asas' => $message, ':asafs' => $text ) );
- echo '<div style="color:'.$text.'">'.$user .' : '. $message.'</div>';
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement