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

[The Keeper]

Does it properly parse new threads and new posts yet? A new post in an old thread is not a new thread.

[walkingthepath]

Hack not working for me!! I've got VB 3.0 RC2

[Gary King]

Originally Posted by walkingthepath

Hack not working for me!! I've got VB 3.0 RC2

What do you mean not working? What's the problem?

[Gary King]

Originally Posted by The Keeper

Does it properly parse new threads and new posts yet? A new post in an old thread is not a new thread.

Download instructions_regular.txt

[Reverend]

Like Linear Helix mentioned earlier.
Is there anyway to make it so that the totals only show threads/posts forums that users have permission to view.

i.e if a member posts in a private forum,the total only goes up for other users that have permission to view it.

Would solve any possible complaints from members when the stats show new threads/posts have been made,but when they click on "new posts" the totals don't match.

BTW, clicks Install.

[feldon23]

Reverend, that would require a very complex query.

[Gary King]

Originally Posted by Reverend

Like Linear Helix mentioned earlier.
Is there anyway to make it so that the totals only show threads/posts forums that users have permission to view.

i.e if a member posts in a private forum,the total only goes up for other users that have permission to view it.

Would solve any possible complaints from members when the stats show new threads/posts have been made,but when they click on "new posts" the totals don't match.

BTW, clicks Install.

Something like that probably wouldn't be worth it for the time and power it'll require for a query like that, I'm not too sure right now anyways on how exactly the query would be written out

[M1th]

Originally Posted by Reverend

Like Linear Helix mentioned earlier.
Is there anyway to make it so that the totals only show threads/posts forums that users have permission to view.

i.e if a member posts in a private forum,the total only goes up for other users that have permission to view it.

Would solve any possible complaints from members when the stats show new threads/posts have been made,but when they click on "new posts" the totals don't match.

BTW, clicks Install.

you can use something like this:

PHP Code:

     // to check permissions for different users in forums
     $forumids = array_keys($forumcache);
             foreach($forumids AS $key => $value)
     
        {
             $fperms = &$bbuserinfo['forumpermissions']["$forumid"];
             $forum = &$forumcache["$forumid"];
     
         if (!($fperms & CANVIEW) OR !($fperms & CANSEARCH) OR !verify_forum_password($forumid, $forum['password'], false))
             {
              // get rid of the forumids that the user doesnt have permission to view
                 unset($forumids["$key"]);
             }
         } 


Then you add (new threads count in this case) ,

PHP Code:

$getnewthread=$DB_site->query_first("
        SELECT COUNT(*) AS threads
        FROM ".TABLE_PREFIX."thread
        WHERE lastpost IN(" . implode(', ', $forumids) . ") > '".$bbuserinfo['lastvisit']."'
         "); 


as the query.

[Boofo]

Can you show us the whole thing?

[M1th]

Originally Posted by Boofo

Can you show us the whole thing?

an example (for getting count of new threads since last visit):

PHP Code:

   
       $getnewthread=$DB_site->query_first("
       SELECT COUNT(*) AS threads
       FROM ".TABLE_PREFIX."thread
       WHERE lastpost IN(" . implode(', ', $forumids) . ") > '".$bbuserinfo['lastvisit']."'
        "); 


You just do the same thing for the other query.

Havent tested it but it should work.