New Pornstar Interviews - [more]
Introducing Natasha Carter

"Dirty talk is a really big thing for me."
All Forums > Tech Talk > Tech Talk Forum Page 12 > Forum support question
AuthorPost
Mathle21
Senior Member

2033 Posts
12/11
Posted - Feb 9 2014 : 3:27PM
didn't know where to post this question and figured 'Tech talk' was probably the best place for this. Does anyone know how to automatically go to the last unread or last new post period for the threads in 'My topics'? It is a huge pain in the ass to automatically be taken to my own last post, which can be many pages behind the current post. Any help would be aweseome!
jayo All-Star Supporter
All-Star Member

2117 Posts
7/04
Posted - Feb 9 2014 : 6:26PM
Agreed. There've been a number of times I didn't notice that I was on page 2 of 4 of a thread, because my reply was on page 2.
I've often thought a number of people reply to threads solely for that reason: it's a placeholder for the conversation.
Drew Black
broken crankshaft

8009 Posts
9/99
Posted - Feb 10 2014 : 9:58AM
The forum keeps track of the datestamp for the topics you have read in the past 7 days. It will automatically redirect you to the most recent post after your last to the topic. If you haven't visited the topic within the past 7 days it will redirect you to your most recent post in the topic. If you have never posted/visited a topic it takes you to the first post.
jayo All-Star Supporter
All-Star Member

2117 Posts
7/04
Posted - Feb 10 2014 : 9:03PM
I respectifully differ. I just tested it by going to the "Best Assassin/Hitman Movie" thread, which I posted in but haven't looked at in ages, and it immediately took me to the first post after my post, which was dated December 13, 2013. There were a number of posts after that.
What is best hitman/assassin movie?
Drew Black
broken crankshaft

8009 Posts
9/99
Posted - Feb 11 2014 : 9:10AM
You just confirmed that it works as I (poorly) described, assuming that "ages" is longer than 7 days.
The forum keeps datestamps for each user's topic "visits". It stores these dates for 7 days. We only keep 7 days worth of data because the storage requirements start getting huge. I'll take a look at it to see if I can increase the retention period and what effect it would have.
When you visit a topic the database will look for your last visit to that topic (within the prior 7 days). If it finds you in that table it redirects you to the next post after your last visit. If it doesn't find you in the topic visits table it looks for your last post in the topic. If you haven't posted in the topic it sends you to the first post in the topic.
 
Drew Black
broken crankshaft

8009 Posts
9/99
Posted - Feb 11 2014 : 9:17AM
Just looked at the data in the topic visits table. Looks like we're storing the data for a month. 885,000 rows at the moment. These are topic visits from actual logged-in users with a max of 1 row per user per topic visited.
I'll look at the stored procedure that does the topic reading from the database.
jayo All-Star Supporter
All-Star Member

2117 Posts
7/04
Posted - Feb 11 2014 : 11:46PM
Okay. I see. Personally I'd rather it just took me to the last post in the thread.



Jump To: