[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!

Thank you so much tubedogg...
I did what you told me and the problem was fixed...thanks again...

[RobAC]

For some reason, I'm getting nothing but binary text spit back. I'm calling online.php on the homepage and it's full of binary text. I've gone back and made sure that the files were uploaded in ascii and tried running the mysql.php file again. When I do that, I get a database error message:

Database error in vBulletin Control Panel: Invalid SQL: ALTER TABLE session ADD location VARCHAR(225) not null
mysql error: Duplicate column name 'location'
mysql error number: 1060
Date: Monday 02nd of July 2001 12:12:44 AM
Script: /forums/admin/mysql.php
Referer:

Any ideas what I should do?

[SFishy]

Hola hola,

I'm going to ask two questions (and I'll feel really dumb if it IS in fact covered within all the replies -- I've looked through them and couldn't find it)...

Uno: Is is possible to change how the logged in users are sorted? I'd love to see mine sorted by latest activity first.

Dos: Has the duplicated listing of users things been resolved and I missed it? It's not a huge problem, but it would make for a much tidier list if users weren't listed two, three or even four time. Is it possible that hitting "refresh" or "reload" has something to do with this (might be a dumb questions, but I'm no .php wizard, so be nice!)

Thanks!

[Mutt]

I'm working on a cleaned up version of this hack but need a little help. I've gotten rid of the bad urls and and duplicate listings but I'd like to make it even better

see this thread
http://www.vbulletin.com/forum/showt...threadid=21516

my main problem is that the sessions table will list the same person more than once. I've told the script to ignore these duplicates, but I'd perfer to get rid of the duplicates. If you have any knowledge of sessions.php, the sessions table and how it's used please check out the above thread. I don't want to edit the code so it cleans out the duplicates if they are needed elsewhere by another script.

Thank in advance

[RobAC]

Mutt,

Keep us posted on your progress. I'd just be happy to get this cool hack working again.

-Rob

[99SIVTEC]

I have a quick question that should be easy. I have this on my site and am using an SSI call to show it on my main page. The problem is the text color. Its black by default which makes it invisible in my table. Where would I change the color. I'm not sure if its using a forum color from the templates or if its imbedded into the code or what...

My site is at www.highaltitudeimports.com you can see the problem after you enter the site..

[Mutt]

I have a beta version that could use some testing. If you already have the who's online hack installed and working, install is a snap. follow the link to a thread with details


http://www.vbulletin.com/forum/showt...threadid=21935

[Ruth]

thanks for this script, i have some questions before installing:

(1) will this work for vb version 2 ?

(2) most importantly: if i use a Mod_Auth_MySQL with .htaccess, and the user logs into my site, but not into any of the vB forums...will i get to see the online members? if not, can the script recall the members from the .htaccess, i'm not familiar with php and MySQL, please help.

(3) if #2 is achieved, can you be able to track the users?

Thanks

[dwh]

1. There are multiple instances in v 2.01 that we aren't told to replace. Do we replace each instance?
2. This hack would be more expandable if the list of programs -> Title (e.g.

PHP Code:

    } elseif (strpos($location,"private")!==false) {
        $locationtitle="Viewing private messages";
        $location="index.php?s=$session[sessionhash]";
        $f="1";
    } else {
        $location="index.php?s=$session[sessionhash]";
        $locationtitle="Browsing Board"; 


would be placed in a template or in phpinclude or a text file modified in the CP, so we can change the wording, add new scripts etc...

otherwise, nice hack!

[Christian]

I also asked before what exactly has to be replaced in vB 2.0.1, because the lines don't fit anymore!
Also some pieces of code are there now more than once!

Anyone uses it with 2.0.1?

What did you replace and what not?