How many threads and posts since your last visit!

PLEASE CLICK ON THE INSTALL BUTTON IF YOU INSTALLED THIS! THANKS!

What does this hack do?

This hack basically shows the number of new threads and posts since your last visit, in the navbar (under your nick.) Check out the attached screenshot for more information

Installation
This is a pretty simple hack to install.
Instructions are as follows:

FILE MODIFICATIONS
global.php

TEMPLATE MODIFICATIONS
navbar

PHRASES
navbar_sincelastvisit

OPEN global.php AND FIND

PHP Code:

    echo "End call of global.php:  $aftertime\n"; 
    echo "\n<hr />\n\n"; 
} 


(NOTE: If you want old threads with new posts to count as a new thread, then skip this next step)
UNDER IT, ADD

PHP Code:

# SINCE YOUR LAST VISIT 
$getnewthread=$DB_site->query_first("SELECT COUNT(*) AS threads FROM ".TABLE_PREFIX."thread WHERE lastpost > '".$bbuserinfo['lastvisit']."'"); 
$getnewpost=$DB_site->query_first("SELECT COUNT(*) AS posts FROM ".TABLE_PREFIX."post WHERE dateline > '".$bbuserinfo['lastvisit']."'"); 


(NOTE: If you did the step above, then skip this next step)

UNDER IT, ADD

PHP Code:

# SINCE YOUR LAST VISIT 
$getnewthread=$DB_site->query_first("SELECT COUNT(*) AS threads FROM ".TABLE_PREFIX."thread WHERE dateline > '".$bbuserinfo['lastvisit']."'"); 
$getnewpost=$DB_site->query_first("SELECT COUNT(*) AS posts FROM ".TABLE_PREFIX."post WHERE dateline > '".$bbuserinfo['lastvisit']."'"); 


OPEN UP THE navbar TEMPLATE AND FIND

<if condition="$show['pmstats']"><br /><phrase 1="$vbphrase[unread_x_nav_compiled]" 2="$vbphrase[total_x_nav_compiled]" 3="$session[sessionurl]">$vbphrase[private_messages_nav]</phrase></if>

UNDER IT, ADD

<br /><phrase 1="$getnewthread[threads]" 2="$getnewpost[posts]" />$vbphrase[navbar_sincelastvisit]</phrase>

CREATE NEW PHRASE CALLED navbar_sincelastvisit
WITH THE FOLLOWING CONTENT:

There have been {1} threads and {2} posts since your last visit!

THE HACK IS NOW INSTALLED, ENJOY!

Screenshots

Attached

[Link14716]

Installed to phpinclude_start.

Thanks.

[The Keeper]

Originally Posted by Gary W

Both.

Wouldn't it be better to have it so that new threads only showed up when there actually were new threads? You could do that by selecting the id from thread table where createdate is newer than last visit.

SELECT threadid FROM thread WHERE dateline > $pmlastvisit

Or something like that.

[macshrine]

really easy to install!! great mod, i installed it at www.macshrine.com/forums/index.php

thanks alot

[Gary King]

Originally Posted by DCX

i'm new to vb and i wanna try to add hacks and stuff to my board. i found the global.php file on the server but i couldn't find the navbar template file. to make things easier for me, is there a site or list somewhere showing where all the files are installed into which folder or whatever? oh yeah, will this work for vb3 gamma?

Yep it should work with vB 3 Gamma, you can try anyways, it's a very quick install and uninstall if required

[Littlebit]

installed thanks for the mod Gary

[Bernd Glasstett]

I added something to it, phrases to be exact.

Enter the following phrases on GLOBAL:

home_sincelastvisit = since your last visit
home_newthreadssincelastvisit = new threads
home_newpostsssincelastvisit = new posts

and then use this code in the navbar-template:

 <br /><b>$getnewthread[threads]</b> $vbphrase[home_newthreadssincelastvisit], <b>$getnewpost[posts]</b> $vbphrase[home_newpostsssincelastvisit] $vbphrase[home_sincelastvisit]

For the ones who would like to translate it

[Link14716]

All you need is one phrase.

Just call it "home_sincelastvisit"
"There have been {1} threads and {2} posts since your last visit!"

Then use this in navbar:

<phrase 1="$getnewthread[threads]" 2="$getnewpost[posts]" />$vbphrase[home_sincelastvisit]</phrase>

[Bernd Glasstett]

true... I still have to get used to some things on the new system. Thanks Link

[ogden2k]

Which one do I use if I don't want the thread count to go up if someone posts into a thread?

[SmEdD]

This is also possible to be done in one query instead of two.

And you should also give credit to the orignal author for the vb2 one as the query has barley changed.