[Release v2] Who's Online

UPDATE: v0.2.2 has been released, fixing the problem of session hashes not always being removed and replaced correctly in the URLs of where people are. It also attempts to fix the problem of members appearing on the list twice, however don't hold your breath on this one.
To upgrade, just reupload online.php to your server.
--------------------------------
Old update: v0.2.1 has been released. If you already have this hack installed and working you DO NOT NEED TO UPGRADE! The only change is I adjusted the instructions to account for an error in the order I had them in. THERE IS NO CHANGE TO THE HACK ITSELF. If you have not gotten this installed and working yet, please download the zip file (online021.zip) and work from that one.
--------------------------------
Old Update: You can now see where guests are on your board. To upgrade, simply download the new zip file, and read the UPGRADE INSTRUCTIONS in the online.txt file.
--------------------------------
Old Update: I fixed a small bug that was making one long string out of the URL To upgrade, just replace online.php on your server.
--------------------------------
Old Update: I added the missing mysql.php file.
--------------------------------

This has been requested many, many times. It produces a page that displays who's online and where they are. You can link to it from anywhere on your board, or make it just for Admins and Moderators (instructions for that included).

Hack version: v0.2.2

For version: vB2 RC2

Files needed: online.php

Files to edit: admin/sessions.php, possibly admin/index.php and mod/index.php

Templates to edit/create: online, online_userbits, online_guestbits, possibly forumhome_loggedinusers

Instructions are included in the zip file.

Feedback wanted.
Please do not PM or IM me about this hack. Please post it in this thread. Thanks!

[tubedogg]

glad you got it working...i had no idea what was wrong. there was nothing else i could fix!

[nuno]

Kevin one last question:
When i'm seeing a thread or replying to a thread, shouldnt online.php show me exactly that message instead of Browsing Board??

[tubedogg]

If you are viewing or replying to a thread, yes it should (and did in all my testing). Maybe have someone else go around the board while you look at online.php - you may be seeing that message because you are looking at online.php (although it should be saying Viewing Who's Online then anyway...).

[fruitsalad]

works wonderfully

any thoughts on how i can get it to work with non-vb pages which i have required global.php
at the moment it just says browsing the board for people on the non vb pages.

[tubedogg]

My system is very, very crude. It doesn't actually figure out which page the person is on, it just looks for clues in the file name (e.g. if the filename is memberlist.php, they must be looking at the memberlist, etc.). If you look through the online.php, you'll see the different places I've planned for, and you'll also see where it defaults to "Browsing Board".

One thought that just came to me is you could make a list of all the vB files. From that list, remove any that I've accounted for already in the script. Then, do a big if(strpos()===false) statement with all of those names. If it's none of those names, then they're not browsing the board. However, this is also awkward. You might also try following the "clue-and-result" system. If they're looking at a page called "mail" with the variables "send=yes" then they're sending mail. That kind of thing.

Someday I'll figure out a better way to do this. Just not today.

[fruitsalad]

oh dats cool..

i already felt lost looking at the code, what you just said confused me more lol

when i had this working for vB 1.1x they actually wrote the url to the location field if i remember correctly.

[Freddie Bingham]

Kevin did this hack in the same style that the hack for 1.1.x was done.

[JJR512]

Tubedogg, I'm looking forward to getting this hack on my site...except I can't, I'm having a little trouble. I've modified sessions.php as prescribed, and I've uploaded that file, mysql.php and online.php, again as per the instructions. However, when I try the next step, running mysql.php, I get an error message.

This is the meat of the error:

<!-- Database error in vBulletin Control Panel: Invalid SQL: INSERT INTO session (sessionhash,userid,host,useragent,lastactivity,lo cation) VALUES ('a70bf25218fcc096dc225ee88971d1c9','384','63.208. 191.85','Mozilla/4.0 (compatible; MSIE 6.0b; Windows NT 5.0','','989269645')
mysql error: Unknown column 'location' in 'field list'
mysql error number: 1054
Date: Monday 07th of May 2001 05:07:25 PM
Script: /forums/admin/mysql.php
Referer:
-->

Any suggestions/ideas/etc.? You can hit me on ICQ if you want.

[Dioxin]

very very nice hack

thanx a lot from germany, but i have one problem:

some links in my online.php page look like this:

http://www.aktienboard.com/vb/showth...0348#post20348post20348post20348

i think this is a bug. this link contains the string "post20348" three times...

perhaps you forgot to initialize a variable?? i could not resolve the bug...perhaps you have an idea.. thanx a lot

greets, dioxin!!

the link: http://www.aktienboard.com/vb/online.php

[fruitsalad]

Originally posted by JJR512
Tubedogg, I'm looking forward to getting this hack on my site...except I can't, I'm having a little trouble. I've modified sessions.php as prescribed, and I've uploaded that file, mysql.php and online.php, again as per the instructions. However, when I try the next step, running mysql.php, I get an error message.

This is the meat of the error:


Any suggestions/ideas/etc.? You can hit me on ICQ if you want.

I had that problem when trying to run mysql.php too. I just opened it and cut and paste the command in that file to phpmyadmin and created the location field from there.