Users Online Type Thing

[Shaun13]

Hi, I am creating a forum and I was wondering how I could create a users online legend at the bottom of the index. I tried something like echo "$myusername" and it will only display your username. How could I accomplish this?

 

~Shaun

[john010117]

Since I don't know the structure of your forum, I can't quite say. But the basic idea would be to have a column in your users and/or sessions table named $logged_in, and the only values would be 1 for true and 0 for false. Then, run a mysql_query on the table WHERE logged_in = 1.

[Shaun13]

If they like closed the window, how would it log them out?

[john010117]

Let's say you wanted to log a user out after 10 minutes. Create a new function named whatever you want, and a new column in the table named something like last_activity and set the type to timestamp. In the function, use strtotime to check when the user was last active, and if that was more than 10 minutes ago, unset the session for that user. Put the function in a file, and include/require that for every secure page.

 

[Shaun13]

Could you create the function for me? I don't know how. 

[Psycho]

Could you create the function for me? I don't know how. 

Since we do not know the structure of your database, no. Are you using a CMS or is this your own build?

[john010117]

http://us2.php.net/manual/en/function.create-function.php

 

Look at example 722.

[Shaun13]

So what am i putting for the options for the new last_activity field?

[john010117]

Set the Type to TIMESTAMP, and Attributes to ON UPDATE CURRENT_TIMESTAMP.

[Shaun13]

Ok, I have the new field, now what?

 

~Shaun

[Shaun13]

Can anyone help?  ???

 

~Shaun

[Shaun13]

I would really appreciate some help. 

 

~Shaun

[Shaun13]

John, help please?

[john010117]

First of all, list all the fields you have for the table (as well as their types). I need to know what you're table structure is first.

[radar]

http://www.phpfreaks.com/forums/index.php/topic,140745.0.html

 

ive copied some code into this thread that is just what you are looking for... it's the 2nd one in my post.

[AbydosGater]

You should also check out this tutorial on phpIT. I was the same as you just a few months back didnt have a clue. You might not be able to use this exact code from the tutorial but it will give you great insight to how such functions should work. Tutorial Here.

 

 

Hope its helpful.

Andy