Previous Thread
Next Thread
Print Thread
Rating: 8
#226862 10/27/2002 9:11 PM
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?

Sponsored Links
Joined: Jun 2001
Posts: 3,273
That 70's Guy
That 70's Guy
Offline
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

Daine #226865 10/27/2002 11:30 PM
Joined: Jun 2001
Posts: 3,273
That 70's Guy
That 70's Guy
Offline
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.


Sponsored Links
Daine #226867 10/27/2002 11:56 PM
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.

Daine #226868 10/29/2002 12:55 PM
Joined: Aug 1999
Posts: 184
Member
Member
Offline
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
Offline
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
Offline
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.

Sponsored Links
Joined: Aug 2000
Posts: 25
User
User
Offline
Joined: Aug 2000
Posts: 25
Why not, New since last Mark All Read.

Joined: Aug 1999
Posts: 184
Member
Member
Offline
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
Offline
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
Offline
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.

Daine #226877 04/22/2003 12:27 AM
Joined: Apr 2002
Posts: 206
Member
Member
Offline
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


Link Copied to Clipboard
Donate Today!
Donate via PayPal

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.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
JAISP
JAISP
PA
Posts: 449
Joined: February 2008
Forum Statistics
Forums63
Topics37,573
Posts293,925
Members13,849
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,833
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
WebGuy 2
Morgan 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2024 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20221218)