mktime maybe?

fnbcprog

I have a user log file that everytime the user moves form page to page a entry in recorded in the log with the username,date,time,action,and ip.

I also have a table that holds all the user information such as user_id,user_pw,active,permissions.

I have created a function that gets all the users where active is set to 'Y'. From here I am looping in a while loop and for each user I want to get the log entries from todays date.

I have all this taken care of but I need some help when it comes to comparing the times. If the last log entry is 10 minutes or greater then the current time, then the user table will be updated to set the user active status to 'N'

I hope you can help!! Let me know if you need some further clarification.

kevinsequeira

post your existing code

reg
kevin

fnbcprog

// Check status according to idle time
function idleUser() {

// Connect to database
$link = mysql_connect("localhost","root","");
mysql_select_db("nbmm",$link);

$getActive = mysql_query("SELECT user_id,active FROM nbuser WHERE active = 'Y'");

while( $row = mysql_fetch_array($getActive) ) {

	// SELECT with username in nblog and see how long there has been no activity
	$getUserActivity = mysql_query("SELECT id_nblog,user_id,log_time FROM nblog WHERE user_id = '$row[user_id]' ORDER BY id_nblog");
	$numUserActivity = mysql_num_rows($getUserActivity);
	// Move to last log entry for user
	mysql_data_seek( $getUserActivity,($numUserActivity - 1) );

	$userInfo = mysql_fetch_array($getUserActivity);

	Need code here to compare the last time with the current time
}

// Free result memory
if( $getActive )
	mysql_free_result($getActive);
if( $getUserActivity )
	mysql_free_result($getUserActivity);
}

benkillin

I dont know how to use mysql yet, but you could make a page that refreshes every 1 minute, with code in it to check if the user is unactive for 10 min, and if they are, change the mysql entry. not the best of solutions, but I think it would work...

fnbcprog

The code is called from an included script already.