Bulletin Boards - Thread: Online Users Script(help)

By M.J kInG (1331)
On 30 Jun 2011 04:28

hello i made a chatroom but i trying to make something where it show the users name in the chatroom

if you can help
i really be thankful

A true developer

By SBP tonex (410)
On 01 Jul 2011 10:02

The part where it shows who's on the chat on the top screen?

Aye...Hit me up on twitter 'do lol

By M.J kInG (1331)
On 01 Jul 2011 15:22

yupe i no it have something to do with time()

A true developer

By SBP tonex (410)
On 01 Jul 2011 19:04

hmm....I'm guessing put it with the styles...?

Aye...Hit me up on twitter 'do lol

By DSiGameMaster (25)
On 07 Jul 2011 09:43

Try learning PHP.. Its a big help!

Another Day, Another Don't

By SBP tonex (410)
On 07 Jul 2011 10:47

Oh really?? Wow PHP must be very popular then! I'm going to learn PHP then since we both already know PHP! Its really great! Thanks for that advice kid! Really appreciated that comment that you posted for nothing! :D

Aye...Hit me up on twitter 'do lol

By PasserByGuy (268)
On 07 Jul 2011 22:54

To create a user online table, you must make a database table.
CREATE TABLE online_chatroom
(
id NOT NULL AUTO_INCREMENT,
user varchar(18),
chatroom varchar(30),
online int(100)
)

Then whenever someone enters a chatroom, insert the data with row online=time() + 1800.
time() +1800 is the current time plus 15 minutes.
To prevent from a user being inserted more than once per chatroom, use mysql_num_rows() to check with a query that selects the user and chatroom rows.
If the row(s) exist, update the table where the user and chatroom are the values given.
If not, insert.
Then just run a query to check where the chatroom equals the current chatroom and online>=time() + 1800.
Every time the users posts, update the table with online=time() + 1800.

We've all grown up. Cheers.

By SBP tonex (410)
On 08 Jul 2011 07:47

Or just do:

$result = mysql_query("COUNT users online='".$_SESSION['online']"'");

?>

Aye...Hit me up on twitter 'do lol

By PasserByGuy (268)
On 08 Jul 2011 12:33

Again, unreliable scripting.↑
Don't use sessions for everything.
They expire, and then what?
Re-declare the session?
You're just making too much work for yourself--a database is the greatest tool for PHP.

We've all grown up. Cheers.

By M.J kInG (1331)
On 08 Jul 2011 19:04

yupe he right but remember to many connects

A true developer

By SBP tonex (410)
On 09 Jul 2011 07:04

Exactly, though. I use sessions so if the user is not active for a period of time, 30 minutes, the user is logged out.

Aye...Hit me up on twitter 'do lol

By PasserByGuy (268)
On 10 Jul 2011 03:27

Well, if you have the right host, it doesn't matter.
And you can't define how long a session lasts. A session is supposed to when the browser window is closed--not before.
That's one of the screwy things with the DSi's parsing of PHP: sessions expire without the browser closing out.

We've all grown up. Cheers.

By SBP tonex (410)
On 11 Jul 2011 00:22

I am. And I use 3DS.

Aye...Hit me up on twitter 'do lol

By COMMANDER (705)
On 11 Jul 2011 15:31

SELECT
DISTINCT(username)
FROM t_members
WHERE TIMESTAMPDIFF(MINUTE, `last_online`, NOW())<5

That is only the query. Assuming you know the rest.
That query pulls away the data that is less than 5 minutes. Due to a dyslexic moment I'm suffering right now, the less-than may need to be switched to a greater-than. But I'm sure I have it right.
"last_online", and the other column/table names can be changed according to what your table uses.
"last_online" is a timestamp column that updates whenever a user comes online. You will have to program it separately to make it function. It can also be your chatroom table's timestamp, which in that case, you will have to use LEFT JOIN.
DISTINCT will make sure only one record at a time is pulled up, otherwise you will have doubles or triples (or mores).

I know my apprehensions might never be allayed. And so I close, realizing that perhaps the ending has not yet been written...

By PasserByGuy (268)
On 11 Jul 2011 19:47

Gosh, how do you know all of that crap, Chuck?

We've all grown up. Cheers.

By SBP tonex (410)
On 12 Jul 2011 17:10

He probably works with Danny.

Aye...Hit me up on twitter 'do lol

By SBP tonex (410)
On 13 Jul 2011 07:19

I like your style, Chuck. Let this be a lesson to everyone. Take the initiative to take some scripting classes, online or offline, to learn advanced scripts.

Aye...Hit me up on twitter 'do lol

By SBP tonex (410)
On 15 Jul 2011 09:33

I think that'll be an addition to 3DSU in the future. Classes.

Aye...Hit me up on twitter 'do lol

By M.J kInG (1331)
On 15 Jul 2011 14:39

will guys i learned how to make online script it very esay it like mysql updated but with $time = time()-60>

A true developer

By PasserByGuy (268)
On 15 Jul 2011 17:50

Translation:
Well guys I learned how to make an online script. It's very easy, just a MySQL update query but with $time as time() - 60.

Yeah, not really different from what Chuck showed us--he just used SQL more than PHP in his online script.
And to burst your bubble, 1 minute to track if a user online is terrible.
What if they stay on one page and say compose a message/blog or whatever that takes LONGER than 1 minute to make?
They will not be shown on the online table then even though they are online, just busy.
Try 5 minutes. That's 300 seconds I believe.

We've all grown up. Cheers.