Here is a question, how do you run a check to see if a person is on a website?

The reason I ask is because i've been coding an IM system that stores whether the person is online inside of a database rather then a cookie cause i kept having problems with the cookie. The thing is though it will still say they are online within the database even when they are offline, and because of this is it still showing them in the online list. If i know of a way I could check to see if they where on the website, i could use the check in an if statement, and so when they leave the site it updates the database, changing it from online to offline. Well here is the code i got so far:

Code:

Select All

 

$session_check = mysql_connect(DB_SERVER, DB_USERNAME, DB_PASSWORD) or die(mysql_error());
mysql_select_db(DB_NAME) or die(mysql_error());
 
$userid = getUserID();
 
if (!$_SESSION['userid']) {
mysql_query("UPDATE cometchat_status SET status='offline' WHERE userid='$userid' ");
}
 
mysql_close($session_check);

$session_check = mysql_connect(DB_SERVER, DB_USERNAME, DB_PASSWORD) or die(mysql_error()); {BR}mysql_select_db(DB_NAME) or die(mysql_error()); {BR} {BR}$userid = getUserID(); {BR} {BR}if (!$_SESSION['userid']) { {BR}mysql_query("UPDATE cometchat_status SET status='offline' WHERE userid='$userid' "); {BR}} {BR} {BR}mysql_close($session_check);

 

Everytime they reload the page you set a database item perhaps called Last_online to something like time(); (current unix timestamp)

Then you do a query to get people that have time()-Last_online < 900 (aka 15 mins) ... that'll show people that were last active in the last 15 mins. That is, that they've navigated around the site in the last 15 mins.

ok and then if they weren't around in the last 15 minutes, i can use that in an if statement and update the database. Thanks i think i can do that

You don't have to update the database. 'cause you shouldn't really have an online/offline field!

but i do need the field XD a lot of things are calling from the fields. The IM system i am doing right now is for a friend, i'm setting one up so it will integrate with his vbulletin. But when you mentioned the time with the last active, i realized i could use vb's last active table, which makes this rather easy

Yes. No point having 2 fields being used when the one (last active) will suffice!

yea but i can't seem to get it to work XD I have never used the time() function before and i did look it up, and did what you said and here is what i came up with:

Code:

Select All

 

$session_check = mysql_connect(DB_SERVER, DB_USERNAME, DB_PASSWORD) or die(mysql_error());
mysql_select_db(DB_NAME) or die(mysql_error());
 
$userid = getUserID();
$last_online = ("SELECT lastvisit FROM user WHERE userid = '".$userid."'");
 
if (time() - $last_online < 5) {
mysql_query("UPDATE cometchat_status SET status='offline' WHERE userid='".$userid."'");
}
 
mysql_close($session_check);

$session_check = mysql_connect(DB_SERVER, DB_USERNAME, DB_PASSWORD) or die(mysql_error()); {BR}mysql_select_db(DB_NAME) or die(mysql_error()); {BR} {BR}$userid = getUserID(); {BR}$last_online = ("SELECT lastvisit FROM user WHERE userid = '".$userid."'"); {BR} {BR}if (time() - $last_online < 5) { {BR}mysql_query("UPDATE cometchat_status SET status='offline' WHERE userid='".$userid."'"); {BR}} {BR} {BR}mysql_close($session_check);

 

$userid = getUserID(); <------------------------ Gets The user Id

$last_online = ("SELECT lastvisit FROM user WHERE userid = '".$userid."'"); <--------------------- Calls the array for the active to the propers userid


if (time() - $last_online < 5) { <-------------- the if statement running the time() function
mysql_query("UPDATE cometchat_status SET status='offline' WHERE userid='".$userid."'"); <---- what happens if the IF returns true.
}




The code as is does nothing at all, I tihnk i have done everything right. I also flipped the < before the 5 into an > and it just always says the person is logged out. I knowi'm always asking for help, but I don't ask unless i have been trying for a while.

5 means 5 seconds. Now I doubt it'll do anything. Try something big to test!

i have XD i set it to 60 seconds, it didn't work either then i tried 5 minutes (300), and yet still did nothing

$last_online = ("SELECT lastvisit FROM user WHERE userid = '".$userid."'");

Won't work ... you'll have to run that through as a query (mysql_query(....))

oh yea, i left it out because of the rest of the code was being called


Edit: Still not helping any