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

[squawell]

Originally Posted by 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>

thats a good infomation to me

Thankz Link

[Gary King]

Okay I'll be integrating all this new information into the next version of this hack, so stay tooned!

[Gary King]

Originally Posted by 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.

How will I make it into one query, why don't you just post the one query so I can use that instead

[Gary King]

Okay the instructions have been updated slightly to be able to incorporate the phrases feature of vB 3. This update is strictly optional, so you do not have to install it, but if you want to have this hack in a different language, then you can install the hack with the updated instructions

Thanks to Bernd Glasstett for the idea of using phrases and Link14716 because I'm actually using the phrases that he suggested

[NTLDR]

Originally Posted by Gary W

How will I make it into one query, why don't you just post the one query so I can use that instead

It can easily be done with one query. My version in vBindex 3 which uses origional code only uses one query for new threads, posts and updated subscribed threads.

[DCX]

ok, i'm really stupid.... i just managed to upgrade to rc2 myself with no prior experience and it worked out good. i didn't install this hack into it yet cause i was probably going to upgrade first. now i did look for the global.php file and found it in the admincp folder but i couldn't find this text:

******************************

OPEN global.php AND FIND

******************************

echo "End call of global.php: $aftertime\n";

echo "\n<hr />\n\n";

and i looked in the same directory and i looked in the templates folder and i couldn't find this text either:

<if condition="$show['pmstats']"><br /><a

href="private.php?$session[sessionurl]">$vbphrase[private_messages]</a>: $vbphrase[unread] <if

condition="$bbuserinfo['pmunread']"><strong>$bbuserinfo[pmunread]</strong><else

/>$bbuserinfo[pmunread]</if>, $vbphrase[total] $bbuserinfo[pmtotal].</if>

can someone give me step by step where everything is and how it's done. thanks a lot.

[corsacrazy]

i put it here so its easier for users to understand

[ogden2k]

Originally Posted by corsacrazy

i put it here so its easier for users to understand

Good idea.

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

[corsacrazy]

just use the second query

[Gary King]

Originally Posted by NTLDR

It can easily be done with one query. My version in vBindex 3 which uses origional code only uses one query for new threads, posts and updated subscribed threads.

Okay I never meant said that it's impossible, and I never had something like "if you're good enough then show me the query"

I just asked for the query, instead of just saying it's possible to do in one query

Also, I can't seem to find the COUNT() function in your code?