Users Online Script.

[Zepo.]

Is there any tutorials on this? Liike it will list the users online and the guests and stuff.

[mr_mind]

You are looking for php startsession(); you can find this in the php maual at php.net

[pocobueno1388]

You are looking for php startsession(); you can find this in the php maual at php.net

 

startsession() doesn't exist, I think your thinking about session_start()...although I'm not sure how that relates to the question asked.

 

Just do a google for  "PHP online users tutorial", tons of results come up for this topic.

[Zepo.]

Theres only about 2 scripts, one using sessions which i dont want to use, and the other one would kill the database... i was just wondering if anyone has their own way of doing it..

[pocobueno1388]

If you want to know how many users are online, this is what you need to do.

 

• Put a datetime field in the users table called "last_active"
  
• On your header page, put an update query that will update that field for that specific user to the current date/time.

 

Now on your online users page, do a query like this

SELECT username FROM users WHERE last_active > (NOW - INTERVAL 5 minute)

 

That will get every user (registered) thats been active within the last 5 minutes.

[Demont]

Not to jack this thread or anything, but would the query work like this as well?

 

SELECT username FROM users WHERE last_active == (NOW)

 

To show who is online at that moment, and not the last 5 minutes?

[pocobueno1388]

Not to jack this thread or anything, but would the query work like this as well?

 

SELECT username FROM users WHERE last_active == (NOW)

 

To show who is online at that moment, and not the last 5 minutes?

 

You only use one equal sign in MySQL, other than that though, that would get anyone online at that EXACT moment which would be pretty pointless as it would be hard to catch people who were being active.

[Demont]

I'm not exactly sure how to use the MySQL update query with date/time...

 

the query is:

 

mysql_query("UPDATE username SET last_active = '?'
WHERE username = '$username'");

 

Is that somewhat right? the ? of course signifying, I don't know what to do... ???

 

[pocobueno1388]

UPDATE users SET last_active=NOW() WHERE username = '$username'

[Zepo.]

I actually like that idea better then the way ive started doing it, it seems more logical and database friendly.

I might write a tut on it after im done.

[Zepo.]

mysql_query("UPDATE teams SET lastactive=NOW() WHERE id='{$_COOKIE['user']}'");

 

That gives no errors, but lastactive is still blank after updating.

[pocobueno1388]

Change it to

mysql_query("UPDATE teams SET lastactive=NOW() WHERE id='{$_COOKIE['user']}'")or die(mysql_error());

 

 

[Zepo.]

Still no errors..... i think imma come up with a better way for time....

 

$timestamp = time();

Then updating it with that...then it would be easier to work with later.

[pocobueno1388]

Are you sure the DB field is a datetime?

[Zepo.]

//Last Active Update
if(isset($_COOKIE['user'])){
$timestamp = time();
mysql_query("UPDATE teams SET lastactive='$timestamp' WHERE id='{$_COOKIE['user']}'") or die(mysql_error());
}

 

Is the code

The lastactive field is int(15)

 

Doesnt wanna update for some reason... no errors either....weird.

[pocobueno1388]

//Last Active Update
if(isset($_COOKIE['user'])){
$timestamp = time();
mysql_query("UPDATE teams SET lastactive='$timestamp' WHERE id='{$_COOKIE['user']}'") or die(mysql_error());
}

 

Is the code

The lastactive field is int(15)

 

Did that work for you? If not, change you field to a datetime.

[Demont]

I was having the problem Zepo was having. Nothing showing up, and now for some reason, users can't log in, and it has me stumped.

[Zepo.]

It works now... i just have to do the other parts of the code...thanks.

 

[Zepo.]

Ok, now how would i go on to tackle pulling from the database's users last updated within 300 second.... any ideas?

I was thinking something like this, but idk how to use inequalities like that...

$timestamp = time();
$timeout = $timestamp-$timeoutseconds;
$uonline = mysql_num_rows(mysql_query("SELECT teamid FROM teamsonline WHERE lastupdated>$timeout"));

[Zepo.]

Forgot in the last code chunk

$timeoutseconds ="300";