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

[Linear Helix]

Attention M1th.

PHP Code:

$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)) {
        unset($forumids["$key"]);
    }
} 


$forumids apparently ends up empty, because when the script tries to implode() it later on for use in the IN() in the query, nothing results, breaking the query.

[DCX]

ok, i found out that the reason i couldn't find the phrase in the global.php section was because i was lookin at the wrong global.php file....... the only thing i need help on now is editing the navbar template. where do i find that????

[M1th]

Originally Posted by Linear Helix

Attention M1th.

PHP Code:

$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)) {
        unset($forumids["$key"]);
    }
} 


$forumids apparently ends up empty, because when the script tries to implode() it later on for use in the IN() in the query, nothing results, breaking the query.

Yep, It'll work if you use it for one query only. The second one ends up empty.

[DCX]

ok... i found the templates in the admin control panel. i'll let you know if i got it to work......

[Linear Helix]

AH! Thanks, M1th. The problem is solved!

[gmarik]

nice one

[DCX]

finally, this newb figured it all out..... got it working and it's all good.

[Gary King]

Originally Posted by DCX

finally, this newb figured it all out..... got it working and it's all good.

Who exactly are you talking about?

[M1th]

Originally Posted by Gary W

Who exactly are you talking about?

I think he's talking about himself.

[Gary King]

Originally Posted by M1th

I think he's talking about himself.

Apparently