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

[Hooper]

Hey Tube,

Is this hack ready then.... Looks like the above errors were installation errors. Any reason not to install this yet?

Thank You,
Hooper

Originally posted by tubedogg


This is a problem with your server's PHP. It means for whatever reason it decided to take a break. But seriously, unknown at line 0 isn't anything to do with my hack, and it's nothing that can really be fixed in terms of the scripts.

k
nice hack, big brother is watching you

[Hooper]

Tube,

I've installed RC3 and your WOL hack. It works fantastic. I am real happy to have this one. If you would like to see it let me know. I have access blocked at this point.

Thank You,
Great work.
Hooper

[Hooper]

OOps,

Spoke to soon.

I am having problems. I need help with WOL. Each time you log in with one browser session, you close without logging off, go back and you are still logged in. (disabled in cp auto log cookie). If you log in again it shows 2 of you and so on. Then you cannot log out of the session you closed out. I have had 2 of myself on at one time. and a guest that was also me.

If you use just one browser session, login, log out, it works fine.

I reinstalled the hack and had the same thing. I did notice that there was a new string added to the sessions in RC3, or at least the line numbering changed since RC2.

on 111 $DB_site->query("UPDATE session SET lastactivity=".time()."$styleup WHERE sessionhash='".addslashes($session['sessionhash'])."'");

This one was not mentioned in your instructions. I didn't know if maybe this had something to do with it or not.

Something else is that you have to refresh to see WOL. If you don't hit refresh, everyone is viewing main page.

Any help appreciated.
Hooper

[tubedogg]

Hooper, you know the drill. I'm gonna need more info than "I'm having problems".

[Hooper]

I was just making sure the posting was working. It didn't work for me all day. I was having IP probs. That's fixed now so if I coould only get this working.

Anyhow I was adding to the above when you posted response.
Look above please.

Thanks Tube,
Hooper

[tubedogg]

Hooper, try this.

In online.php, find

$loggedins=$DB_site->query("SELECT DISTINCT session.userid,username,invisible,location
                            FROM session
                            LEFT JOIN user ON (user.userid=session.userid)
                            WHERE session.userid>0 AND session.lastactivity>$datecut
                            ORDER BY invisible, username");

Replace it with

$loggedins=$DB_site->query("SELECT DISTINCT username,session.userid,invisible,location FROM session
							  LEFT JOIN user ON (user.userid=session.userid)
							 WHERE session.userid>0 AND session.lastactivity>$datecut
						  ORDER BY invisible, username");

[Hooper]

I'm up. I'll go try this.......zoooom..

[Hooper]

Still the same thing... I'm not sure what to do. I go to the forums and it always shows that there is guest from the get go. Then if I log in and out I'm back to guest as should be. But if I close the browser and come back in, I am a guest, a member, etc..
Now If I log in and out It straightens up somewhat in the forums, but when I go to the show where online I am in there twice as the administrator.

I'm all for you checking this out for yourself so you can see first hand what it is doing. Everything else seems to work. If you decide you would like to see this let me know and set a time in here so I can turn off .htaccess. Or you could give me your IP and I'll add you to the user list.

This hack is going to work if it kills me.


Hooper

If I'm not mistaken the session table is HEAP type, meaning that it's completely in RAM, and is lost when mySQL server is shutdown

Does this mean that I will have to run the mysql sctipt included in this hack every time after I restart mySQL database?