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

[BillaBongUSA]

You have to re-install it when you upgrade.

[Gary King]

Well you shouldn't have to re-install unless you upgrade 'properly' (by NOT replacing all files) but if you did, try re-installing and hopefully it'll work

[DCX]

yeah, when i upgraded... i saw "There have been threads and posts since your last visit" was there but there was no numbers....

i basically was goin in like i was gonna install them again but everything was in place... even the navbar template and the phrases i added. all i did was double check everything and it was working fine again.

[Logikos]

/me clicks install

[Logikos]

Don't like the fact that the permissions don't work, thought since it was vB3 it wouldn't be like the vB2 version where it does the same thing.

/me uninstalls

[MischiefThought]

GREAT Hack. Wonderfull job.

[Wifey]

Installed and it's working perfectly. Thanks!

[Cloudrunner]

Is this working on Gold anyone know?

I cleanly redid everything on me site, and have been bugged about getting this one back, but don't wanna chance it til I have confirmation that it works on Gold.

Thanks

)O( Cloudrunner )O(

[Gary King]

Originally Posted by Cloudrunner

Is this working on Gold anyone know?

I cleanly redid everything on me site, and have been bugged about getting this one back, but don't wanna chance it til I have confirmation that it works on Gold.

Thanks

)O( Cloudrunner )O(

Yep works on Gold

[trafix]

Originally Posted by Gary W

Yep works on Gold

interesting, i just installed this and acording to the hack it says...

There have been 747 threads and 4488 posts since your last visit!

any ideas?