|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
Anyone ever give thought to or manage to do a "new Since Last Visit" link?
Where in the database does it keep track of what's "new" for users?
|
|
|
|
Joined: Jun 2001
Posts: 3,273
That 70's Guy
|
That 70's Guy
Joined: Jun 2001
Posts: 3,273 |
I have given this some thought. lol One field is needed for a unix timestamp in the users table, call it U_NewPosts. A page would be generated pulling in all threads that they have access to that are newer than this time stamp. Once a user has read all that they want to read they can upate the page and have a current timestamp set and all of the previous threads will not be displayed because they are now older than the timestamp. If there is no value for the timestamp have it set to 24 hours ago and load the threads accordingly. This is actually a pretty simple script to write up and I think it would be handy as I have heard of something simular if not this exact thing being requested here and there.  This has been on my list but feel free to whip it out. 
|
|
|
|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
What does w3t_Last store?????? I guess that's the last post they read in each forum????? This one seems a bit over my head still..... How would you get the timestamp into the w3t_Users table? Maybe after that I could do it.... no promises. LOL 
|
|
|
|
Joined: Jun 2001
Posts: 3,273
That 70's Guy
|
That 70's Guy
Joined: Jun 2001
Posts: 3,273 |
That's the nice thing about doing it this way. w3t_Last doesn't matter. The user themselves are in controll of updating their lists.
As far as the field goes it's something like ALTER w3t_Users ADD U_NewThreads INT(11)
|
|
|
|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
Right to add the field. I meant... how would you timestamp into that field. Where would you have it write that info.. how often. Taken from w3t_Online?.... that's the part that confuses me.  
|
|
|
|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
I use the who's online hack on every page....
I'm guessing you could have the ubbt.inc.php file write the timestamp to the users table in there. Or would that be too much?
You can't count on people logging out each time to make it work.
|
|
|
|
Joined: Aug 1999
Posts: 184
Member
|
Member
Joined: Aug 1999
Posts: 184 |
Maybe a 'next unread thread' type button?
Silly ricer.. Wings are for airplanes!
|
|
|
|
Joined: Jun 2001
Posts: 3,273
That 70's Guy
|
That 70's Guy
Joined: Jun 2001
Posts: 3,273 |
It would only write to that field if the member choses to update their list. If they have read all they wanted to in the list they then click update and the current timestamp is added to their information and all threads added after this will be displayed next time they view it. You will also need to paginate because this list could become quite long. Have the number of displayed threads use their prefs also like postlist.php 
|
|
|
|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
So instead of "new since your last visit" more like "new since you last looked at this list". That makes sense. I wonder if you read posts from there if they would get marked as read? I think I read rick post that postlist updates that.  Maybe it would be best to make a "all new posts" link.... although that still baffles me as to how and where in the database that's tracked.  Oh well.... an idea worth kicking around. Not sure if it's practical to implement as a hack. Maybe it'll end up on Rick's radar one of these days.
|
|
|
|
Joined: Jun 2001
Posts: 3,273
That 70's Guy
|
That 70's Guy
Joined: Jun 2001
Posts: 3,273 |
More like "new since you last reset this"  Your right in that it's postlist.php that does the actual tracking though. So basicly what you would want is a postlist.php script that grabs from all forums that you have access to and not just one forum at a time. The route I suggest is less intrusive into the database and much easier to impliment. I guess it's up to you on a course of action. 
|
|
|
|
Joined: Aug 2000
Posts: 25
User
|
User
Joined: Aug 2000
Posts: 25 |
Why not, New since last Mark All Read. 
|
|
|
|
Joined: Aug 1999
Posts: 184
Member
|
Member
Joined: Aug 1999
Posts: 184 |
New Posts since -=insert date here=- ? And there is a cool new Javascript thing over at hotscripts that would toss a calendar up when you click to enter the date to allow you to select a date in calendar mode.
I know its sounds confusing.
Silly ricer.. Wings are for airplanes!
|
|
|
|
Joined: Feb 2002
Posts: 950
Hacker
|
Hacker
Joined: Feb 2002
Posts: 950 |
I wouldnt mind seeing this. Couldnt we also take the w3t_Last which was the greatest for the user and assume that was the last visit? Then we list all threads since that most recent visit to a forum.
|
|
|
|
Joined: Apr 2002
Posts: 206
Member
|
Member
Joined: Apr 2002
Posts: 206 |
[]sigridsholm said: Why not, New since last Mark All Read. <img src="/threads/php/images/graemlins/smile.gif" alt="" /> [/]
Wouldn't that be the same as full post tracking (in theory)? If it's showing all new since Mark All Read, then it's just doing what it normally does, unless it isn't unflagging posts after you read them.
|
|
|
|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
I think they want to display a list of all new posts on one page.
|
|
|
|
Joined: Apr 2002
Posts: 206
Member
|
Member
Joined: Apr 2002
Posts: 206 |
Ahhhh. That's actually kinda related to something I've been thinking about working on. If I ever get around to it, you'll be certain to hear of it 
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
Posts: 5,833
Joined: January 2000
|
|
Forums63
Topics37,573
Posts293,925
Members13,849
|
Most Online5,166 Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|