Putting A Word Filter, Word Length, & Time Delay on Shoutbox

[FortMyersDrew]

Can Anyone Help Me add  A Word Filter, Word Length, & Time Delay on my Shoutbox?

 

<?php
//including the database connection
include('config.php');
//getting everything that has been submitted
$name=mysql_real_escape_string(strip_tags($_POST['name']));
$mail=mysql_real_escape_string(strip_tags($_POST['mail']));
$message=mysql_real_escape_string(strip_tags($_POST['message']));
$submit=$_POST['submit'];
//get the current time with php date() function
//note that the server time will be recorded
//more info about all functions - http://php.net
$time=date("m/d/y - g:i a");
//get the ip. Note that this wont see through proxies
$ip=$_SERVER['REMOTE_ADDR'];


//just some basic error checking which
//checks if name,e-mail and message 
//hasnt been left blank or with default text
if (($name!=="") || ($name!=="Name") || ($mail!=="") || ($mail!=="E-mail") || ($message!=="") || ($message!=="Your text"))
{
//inserts data into the database
$sql = "INSERT INTO shoutbox (id, name, mail, message, time, ip) VALUES ('NULL', '$name', '$mail', '$message', '$time', '$ip')";
mysql_query($sql) or die(mysql_error());

$query = "SELECT * FROM `shout_user_log` WHERE `ip` = '$ip'";
$result = mysql_query ($query);
$num_rows = mysql_num_rows ($result);

if ($num_rows > 0) {

$query = "DELETE * FROM `shout_user_log` WHERE `ip` = '$ip'";
mysql_query ($query);

}

$query = "INSERT INTO `shout_user_log` (`id`, `username`, `email`, `ip`) VALUES ('', '$name', '$mail', '$ip')";
mysql_query ($query);

//sends the user back to the form
header("Location:".$_SERVER['HTTP_REFERER']);
}
else{
header("Location:".$_SERVER['HTTP_REFERER']);
}
?>

[FortMyersDrew]

*BUMP*

 

[FortMyersDrew]

*BUMP*

[corbin]

You want to check the length for each individual word?

[corbin]

What you're gonna need to do is add a time column to your log table.  Use a integer field 10 characters long and store unix time stamps in it made from time().  Then you would want to pull the last time logged for the ip... Then you compare it to the current time minus a certain value.  Forexample:

 

$qtime = time() - 300; //only allow posts every 5 minutes
$q = "SELECT time FROM shout_user_log WHERE ip = '{$ip}' AND time > '" . $qtime . "' LIMIT 1";
if(mysql_num_rows($q) > 0) {
//it hasn't been 5 minutes
}
else {
//everything passed fine
}

 

As for word length:

 

$maxlength = 15; //15 character max on words
$exp = explode(" ", $message);
foreach($exp as $v) {
if(strlen($v) > $maxlength) //it failed!
}

 

And then for a censor thing you could do something like

 

$badwords = array('bad', 'another_bad_word');

str_replace($badwords, "****", $message);

[FortMyersDrew]

So i should just add the code you have put just like so?

[FortMyersDrew]

***BUMP***

 

[ryeman98]

Well... it does sound like a good idea.

[FortMyersDrew]

I have tried all of these

 

$qtime = time() - 300; //only allow posts every 5 minutes
$q = "SELECT time FROM shout_user_log WHERE ip = '{$ip}' AND time > '" . $qtime . "' LIMIT 1";
if(mysql_num_rows($q) > 0) {
//it hasn't been 5 minutes
}
else {
//everything passed fine
}


As for word length:


$maxlength = 15; //15 character max on words
$exp = explode(" ", $message);
foreach($exp as $v) {
if(strlen($v) > $maxlength) //it failed!
}


And then for a censor thing you could do something like


$badwords = array('bad', 'another_bad_word');

str_replace($badwords, "****", $message);

 

None of them work so what do i have to do to fix this

[redarrow]

try the time function first please ok.

<?php
$qtime = time() - 300; //only allow posts every 5 minutes
$q = "SELECT time FROM shout_user_log WHERE ip = '$ip' AND time > '" . $qtime . "' LIMIT 1";
if(mysql_num_rows($q) > 0) {
//it hasn't been 5 minutes
}
else {
//everything passed fine
}
?>

[FortMyersDrew]

Well i tried and i get this message

 

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/d/r/e/drewsmedia/html/doit.php on line 4

Warning: Cannot modify header information - headers already sent by (output started at /home/content/d/r/e/drewsmedia/html/doit.php:4) in /home/content/d/r/e/drewsmedia/html/doit.php on line 51

[redarrow]

stick this before session_start

 

ob_start();

[FortMyersDrew]

It doesnt work.. it fixed the error but i can still post one after another

[redarrow]

in the database you got a timestamp to that set varable of time in your current query.

[FortMyersDrew]

wait what? Im so lost im new to this

[redarrow]

corbin code is lovly are you sure in your database you got a timstamp.

[FortMyersDrew]

This is what i use in my doit.php file

 

//note that the server time will be recorded
$time=date("m/d/y - g:i a");

[redarrow]

 

try this then

<?php
$qtime = date("i") - 5; //only allow posts every 5 minutes
$q = "SELECT time FROM shout_user_log WHERE ip = '$ip' AND time > '" . $qtime . "' LIMIT 1";
if(mysql_num_rows($q) > 0) {
//it hasn't been 5 minutes
}
else {
//everything passed fine
}
?>

[FortMyersDrew]

do i paste that below the other <php>

[corbin]

Red arrow, what if someone posts at 0:00 and then they try to post at 1:00?  It will give them an error even though it's been an hour since they posted.  I don't think this problem would be very occurant, but it would be better to not leave that small chance of someone running into it.

 

What is the structure of your shout_user_log table (including datatypes and lengths, please)?