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 wii

Will this hack work for Version 3.5.1 ?

I'm using 3.5.1 and it works fine.

[wii]

Do you have a test login so I can see it in action?

Thanks

By the way, how do you get this on the non-forum page?

Members: 13059
Forum Posts: 78791

[HMBeaty]

How do I get this to show on the navbar of EVERY page? Thanks

[HMBeaty]

Anyone?

[Zachery]

Originally Posted by NRR

How do I get this to show on the navbar of EVERY page? Thanks

Thats alot of extra overhead... are you sure you want to be running large querys on EVERY page displayed on your forum?

[Gio Takahashi]

There has been Array new posts and 0 new threads since your last visit.

Any explanations why, and how exactly do I fix this?

[Gio Takahashi]

hmm. Got it fixed.

[dark dragun]

I change up the navbar code. it looked to cluttered, this is simpler.

PHP Code:

<if condition="$vbulletin->userinfo['userid'] != '0' AND THIS_SCRIPT == 'index'"><br /><span class="smallfont"><a href="$vboptions[bburl]/search.php?do=getnew">New posts</a>:$newposts <a href="$vboptions[bburl]/search.php?do=getnew">New threads</a>:$newthreads </span></if> 


[Gio Takahashi]

Hmmm. Curious.

I am wondering if it is possible to add this in the Who's Online page, so that people could see whether there is new post or new threads while idling in the who's online page.

[xeyr]

Installed, thanks!