flood control

slimjim

If I am using this for date:

    $date = date("h:i A dS M");

How can I make a secect statment that would check the ip or a check for cookie or both, not actually sure what would be best.

But anyway, check to see if a post was done within the last 15 minutes and if one was, echo something and if 15 minutes has passed by, then allow a post.

devinemke

i assume that you are storing posts in database? if so simply grab the date/time of the last post by the user. for example:

SELECT datetime FROM posts WHERE user_id = 123 ORDER BY datetime DESC LIMIT 1

then check to see if the resulting datetime is older then 15 minutes.

slimjim

how would i do that ? I mean to check it last post was at least 15 minutes ago...

devinemke

what database system are you using?

slimjim

mysql

devinemke

a simple example, let's assume we are logged in as user_id #123 (i'm just guessing here at your actual data structure):

$result = mysql_query("SELECT COUNT(*) FROM posts WHERE user_id = 123 AND TIMEDIFF(datetime, NOW()) > '00:15:00'");
if (mysql_result($result, 0)) {echo 'you have posted within the last 15 minutes';}
else {echo 'you have NOT posted within the last 15 minutes';}

slimjim

I was using varchar for the date, should I change that to datetime and instead of this $date = date("h:i A dS M");

Use like this : $date = now();

devinemke

don't store dates as strings, store dates as dates. the mySQL date/time format is YYYY-MM-DD HH:MM:SS. read up on mySQL Date and Time Types.

slimjim

 $result = mysql_query("SELECT COUNT(*) FROM post WHERE memid = 2 AND TIMEDIFF(datetime, NOW()) > '00:15:00'"); 
if (mysql_result($result, 0)) {echo 'you have posted within the last 15 minutes';} 
else {echo 'you have NOT posted within the last 15 minutes';}

Ok I figured out the time but,

Now I get an error:

Warning: mysql_result(): supplied argument is not a valid MySQL result resource
Something I am assuming is wrong with the syntax..

devinemke

the TIMEDIFF() function was added in mySQL 4.1.1 so i suspect you are running an older version.

$result = mysql_query("SELECT COUNT(*) FROM post WHERE memid = 2 AND TIMEDIFF(datetime, NOW()) > '00:15:00'") or exit(mysql_error());  

if (mysql_result($result, 0)) {echo 'you have posted within the last 15 minutes';}  

else {echo 'you have NOT posted within the last 15 minutes';}

slimjim

Now I get this

You have an error in your SQL syntax near '(datetime, NOW()) > '00:15:00'' at line 1

slimjim

so is there something else other then timediff to use ?

devinemke

$result = mysql_query('SELECT datetime FROM post WHERE memid = 2 ORDER BY datetime DESC LIMIT 1') or exit(mysql_error());   

$row = mysql_fetch_assoc($result);
$diff = time() - strtotime($row['datetime']);
if ($diff < 900) {echo 'you have posted within the last 15 minutes';}   

else {echo 'you have NOT posted within the last 15 minutes';}

slimjim

Well regarless if i wait or not the 15 minutes, it still says I havnt posted within 15 minutes