Announcement

Collapse
No announcement yet.

[Release v2] Who's Online

Collapse
This topic is closed.
X
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Mitrofan
    replied
    Do you think it had something to do with this hack?

    I don't do cp backups, I only do it from telnet, either mysqldump or complete copy of forum database.

    I just installed this hack and it seems to be working so far, I hope there will be a new version with more intelligent way to guess what users are doing, and to also I would like the way to split the output into several pages because my board usually has over 140 members/guests and the who's online page gets really long.

    Just a suggestion.

    I also using this hack together with the first who's online hack which I am using to display the number of users online on non-vb page and then have a link to this new script for more info on users online.

    Leave a comment:


  • Hooper
    replied
    My server move and restore from a CP backup is totally trashed.
    This was my answer.
    Thank You,

    Leave a comment:


  • Mitrofan
    replied
    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?

    Leave a comment:


  • Hooper
    replied
    Notta,

    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
    Last edited by Hooper; Sun 13 May '01, 1:06am.

    Leave a comment:


  • Hooper
    replied
    I'm up. I'll go try this.......zoooom..

    Leave a comment:


  • tubedogg
    replied
    Hooper, try this.

    In online.php, find
    Code:
    $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
    Code:
    $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");

    Leave a comment:


  • Hooper
    replied
    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
    Last edited by Hooper; Sat 12 May '01, 6:38pm.

    Leave a comment:


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

    Leave a comment:


  • Hooper
    replied
    Tube,

    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
    Last edited by Hooper; Sat 12 May '01, 7:02pm.

    Leave a comment:


  • Hooper
    replied
    Installed and working with RC3

    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

    Leave a comment:


  • furious
    replied
    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

    Leave a comment:


  • Hooper
    replied
    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

    Leave a comment:


  • fruitsalad
    replied
    Originally posted by tubedogg
    fruitsalad: Are you missing members from the list on the main page, or are you noticing the members appearing multiple times on the Who's Online page? Those would be two different problems. The first has nothing to do with my hack, I'm quite sure, as it does not have any control over the main listing.

    The second thing I'm working on. I don't understand how it happens because it should be selecting distinct records from the DB based on the userid, meaning pull one record per time it sees a particular number...I'll see what I can do.
    I cant say for sure, cos my board is not that busy, but with the edited sessions.php running my board always said 0 members, 0 guests when i first logged in to the main page. it was only refreshing it that i would then be able to see myself.

    However i opened up and browed the sessions table in phpmyadmin and there are alot more sessions recorded in that table than are showing on the board. but i dont think this was related to your script issit? the sessions table didnt seem to be updating.

    as for the problems i witnessed first hand. My guest count was always zero and also the problem of more than 1 entry for the members on the who's online page as on the screenshot of jjr page i included earlier

    Leave a comment:


  • tubedogg
    replied
    Code:
    If they are on this page			This list will say this
    newthread.php				User is starting a new thread in forumtitle forum
    showthread.php
    --Using a post #				Viewing post #n in thread threadtitle
    --Using a post # that has a title		Viewing post posttitle (post #n) in thread threadtitle
    --Without a post number			Viewing thread threadtitle
    forumdisplay.php				Viewing forumtitle forum
    online.php				Viewing Who's Online
    index.php					Viewing the Main Page
    newreply.php				Posting a reply to threadtitle
    editing a post				Editing their post in thread threadtitle
    search.php?action=showresults		Viewing search results
    search.php				Using Search
    memberlist				Viewing the Memberlist
    calender.php				Viewing the calendar
    misc.php?action=faq			Viewing the FAQ
    usercp.php					In their User CP
    private.php or private2.php			Viewing private messages
    anywhere else				Browsing Board
    This only applies to members listed. Guests listed are basically the same, except without the members-only functions (replying, etc.)
    Last edited by tubedogg; Tue 8 May '01, 5:50pm.

    Leave a comment:


  • tubedogg
    replied
    Good question I should probably have given a list anyway. Let me put one together and I'll post it.

    Leave a comment:

widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X