New Posts & Threads Since Last visit

Um. I think this one is fairly self explaintiory by now.

It gets a count of the newest posts and threads since their last visit.


Optionally you should add indexes on your post and thread tables for the dateline columns
[sql]
ALTER TABLE `post` ADD INDEX ( `dateline` );
ALTER TABLE `thread` ADD INDEX ( `dateline` );
[/sql]

[Reverend]

Originally Posted by Zachery

Then I'd suggest using my original code and not running that somewhat intensive query on every page view.

Yep,fair point Zach,and i have now moved it back to forumhome_start.

[ogden2k]

Sigh, let's hope vB devs come out with a workable solution.

[Zachery]

Originally Posted by ogden2k

Sigh, let's hope vB devs come out with a workable solution.

Why would the vB devs come out with somthing? Its always been rejected due to possible server load...

[ogden2k]

True, but it could be an option to turn on / off. On 3.0.x I have had this working in the navbar on every page an have not had any performance issues with ~20 members online.

------
edit:
After playing with this a little more, it works great when you are using the cookie mark read system, but if you are using the Database (automatic forum marking) system then that's where the problem comes in.

Lets say user 1 posts a new thread, user 2 logs in and doesn't read it, the new posts option shows as new like it should, user 2 logs out, logs in 2 days later (
Database Read Marking Limit is set to 1 day) and the new posts still reads as one, but when user 2 clicks on New Posts, nothing shows up- But, if you switch back to cookie base mark read system, the thread will show up.

Is there a fix / work around for this?

[Zachery]

Originally Posted by ogden2k

True, but it could be an option to turn on / off. On 3.0.x I have had this working in the navbar on every page an have not had any performance issues with ~20 members online.

------
edit:
After playing with this a little more, it works great when you are using the cookie mark read system, but if you are using the Database (automatic forum marking) system then that's where the problem comes in.

Lets say user 1 posts a new thread, user 2 logs in and doesn't read it, the new posts option shows as new like it should, user 2 logs out, logs in 2 days later (
Database Read Marking Limit is set to 1 day) and the new posts still reads as one, but when user 2 clicks on New Posts, nothing shows up- But, if you switch back to cookie base mark read system, the thread will show up.

Is there a fix / work around for this?

You can add &oldmethod=1 and have it use the old getnew function.

[ogden2k]

I just tried that under the Database (automatic forum marking) system, and the forum with the new thread does show as "new" but when I click on New Posts, the thread does not show, since I logged out and logged in w/o reading that thread.

<a href="search.php?$session[sessionurl]do=getnew&amp;oldmethod=1" accesskey="2">

[southernlady]

Has this been updated to beta 2 yet? Liz

[Chris M]

It works with Beta 2

Satan

[southernlady]

Thanks, Liz

[southernlady]

There was something I needed to do in the nav bar specifically for beta 2 that screwed up with this on the thread tools.

Add the pagenav popup stuff for it in (look for the <!-- PAGENAV POPUP --> comment)

That's what I was told to do.

Can y'all help? Liz