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

[Boofo]

Originally Posted by noppid

I started installing this and realized it puts those two queries system wide. Forum home is the way to go IMO. The permissions need to be worked out to. Great idea, the codes just not ready yet.

Neither thread nor post have an index on dateline, perhaps that would help performance?

I've been running my own version of this on the forumhome in my forumhome cache stats hack since before this came out. 1 query.

[carwash]

I am unable to find that line in the navbar template.....has anyone else had this problem? Copying it and pasting it elsewhere and then searching brings up nothing.

[steadicamop]

carwash;

Tip - this is something I do, just copy part of the code and search for that, it may just be one character different, then if you do find it, just check the original code and the one you have in your navbar.

I find that sometimes works.

If not, here's whereabouts it is on mine:

			<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>
<br /><phrase 1="$getnewthread[threads]" 2="$getnewpost[posts]" />$vbphrase[navbar_sincelastvisit]</phrase>
		</div>
		</td>
		
	<else />

It's quite near the top, where it shows how many new Private Messages you have.

HTH

Jason

[asarian-host]

This hack does not work at all! It just says: "There have been threads and posts since your last visit!" And it does not update any counters (Vbulletin 3.0.5).

- Mark

[silent.dr3am]

*cllicks the install button

nice hack, i like!

[sigh]

Originally Posted by asarian-host

This hack does not work at all! It just says: "There have been threads and posts since your last visit!" And it does not update any counters (Vbulletin 3.0.5).

- Mark

Same here - doesn't work in 3.0.6

[Reverend]

Originally Posted by asarian-host

This hack does not work at all! It just says: "There have been threads and posts since your last visit!" And it does not update any counters (Vbulletin 3.0.5).

- Mark

Double check your global.php edit.

Its the global.php that adds the counters.

Works perfect for me on 3.0.6

[agiacosa]

It is working fine within vB but it doesn't show the counts in my portal page (CMPS). Anyone got it working on a portal?

[AxEsLoCkEd]

Greate Mod *clicks install*

[cnczone]

it works!