next »

[M0ZZA]

I am making a temporary banning system, but I dont know how to compare the time the user has been banned with the alloted ban duration


Say I wanted to ban them for 15 minutes, how would I check the time (stored in mysql database) with the current time ?

I know how to do all the SQL etc, its just the time bit im stumped on...

[Confuser]

well when u ban them insert the time() as well. Then when checking compare the 2 times eg

Code:

$time = time() - $database['time'];
if($time > 900) {
//unban them
}

900 is 15mins in seconds
or you could just change the 900 to (60 * number of mins)

[tpog]

strtotime is quite useful as well, lets you get a unix time stamp for the comparison, using strings, e.g.

Code:

strtotime("-15 min");

[M0ZZA]

Thanks, that worked great !