The Arcive of Official vBulletin Modifications Site.

How many threads and posts since your last visit! · **Released**: 01-02-2004

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

HTML Code:

<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

HTML Code:

<br /><phrase 1="$getnewthread[threads]" 2="$getnewpost[posts]" />$vbphrase[navbar_sincelastvisit]</phrase>

CREATE NEW PHRASE CALLED navbar_sincelastvisit
WITH THE FOLLOWING CONTENT:

Code:

There have been {1} threads and {2} posts since your last visit!

THE HACK IS NOW INSTALLED, ENJOY!

Screenshots

Attached

Reverend · #62 01-11-2004, 06:24 PM

For anyone that has installed the instructions_newthreads.txt version you might want to make a grammatical change to the phrase content

From this:

Code:

There have been {1} threads and {2} posts since your last visit!

To this:

Code:

There have been {2} posts in {1} threads since your last visit!

Linear Helix · #63 01-11-2004, 06:36 PM

This is what I have put in my globals.php, replacing what the original hack prescribed.

PHP Code:


			
// #############################################################################

// activity since last visit hack



$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"]);

    }

} 



$getnewthread=$DB_site->query_first("

    SELECT COUNT(*) AS threads

    FROM " . TABLE_PREFIX . "thread

    WHERE lastpost IN(" . implode(', ', $forumids) . ") > '" . $bbuserinfo['lastvisit'] . "'

    "); 



$getnewpost=$DB_site->query_first("

    SELECT COUNT(*) AS posts

    FROM " . TABLE_PREFIX . "post

    WHERE dateline IN(" . implode(', ', $forumids) . ") > '" . $bbuserinfo['lastvisit'] . "'

    ");

But I got a database error, so... I guess I can't figure it out. I'm used to php, but this is the first experience I've had with vB's scripts. What am I missing?

Gary King · #64 01-11-2004, 06:39 PM

Quote:

Originally Posted by Reverend

For anyone that has installed the instructions_newthreads.txt version you might want to make a grammatical change to the phrase content

From this:

Code:

There have been {1} threads and {2} posts since your last visit!

To this:

Code:

There have been {2} posts in {1} threads since your last visit!

What's the difference?

Gary King · #65 01-11-2004, 06:40 PM

Quote:

Originally Posted by Linear Helix

This is what I have put in my globals.php, replacing what the original hack prescribed.

PHP Code:


			
// #############################################################################

// activity since last visit hack



$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"]);

    }

} 



$getnewthread=$DB_site->query_first("

    SELECT COUNT(*) AS threads

    FROM " . TABLE_PREFIX . "thread

    WHERE lastpost IN(" . implode(', ', $forumids) . ") > '" . $bbuserinfo['lastvisit'] . "'

    "); 



$getnewpost=$DB_site->query_first("

    SELECT COUNT(*) AS posts

    FROM " . TABLE_PREFIX . "post

    WHERE dateline IN(" . implode(', ', $forumids) . ") > '" . $bbuserinfo['lastvisit'] . "'

    ");

But I got a database error, so... I guess I can't figure it out. I'm used to php, but this is the first experience I've had with vB's scripts. What am I missing?

What was the database error? If you can't see it, then go to View Source - it's in there

Linear Helix · #66 01-11-2004, 06:52 PM

Ah, I had not known that the HTML for the database error page would contain the error comment.

***

Database error in vBulletin 3.0.0 Release Candidate 2:

Invalid SQL:
SELECT COUNT(*) AS threads
FROM thread
WHERE lastpost IN() > '1068258593'

mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') > '1068258593'' at line 3

mysql error number: 1064

***

Character entity. I'll see if I can fix that > crappage.

Gary King · #67 01-11-2004, 07:00 PM

Quote:

Originally Posted by Linear Helix

Ah, I had not known that the HTML for the database error page would contain the error comment.

***

Database error in vBulletin 3.0.0 Release Candidate 2:

Invalid SQL:
SELECT COUNT(*) AS threads
FROM thread
WHERE lastpost IN() > '1068258593'

mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') > '1068258593'' at line 3

mysql error number: 1064

***

Character entity. I'll see if I can fix that > crappage.

Nah it's just like that in HTML, it's supposed to be >.

Anyways, I think you're missing the code from this post: https://vborg.vbsupport.ru/showpost....8&postcount=48

Linear Helix · #68 01-11-2004, 07:02 PM

Check the database error I posted. You're right, it probably isn't the gt that is messing up, but it's thereabouts.

I am not missing that code: it's right there at the beginning of the code block I posted.

Boofo · #69 01-11-2004, 07:03 PM

Quote:

Originally Posted by Reverend

For anyone that has installed the instructions_newthreads.txt version you might want to make a grammatical change to the phrase content

From this:

Code:

There have been {1} threads and {2} posts since your last visit!

To this:

Code:

There have been {2} posts in {1} threads since your last visit!

That won't work. What if they make 2 posts in a thread that isn't new?

Reverend · #70 01-11-2004, 09:42 PM

Quote:

Originally Posted by Boofo

That won't work. What if they make 2 posts in a thread that isn't new?

If they make 2 posts in thread which isn't new it will say
"There have been 2 posts in 1 threads since your last visit!"

If they make 3 posts in 2 threads that aren't new it will say
"There have been 3 posts in 2 threads since your last visit!"

So would you like to explain why you reckon that doesn't work. ????

Don't forget i'm using the first version of the hack which isn't specifically for "new" threads

Reverend · #71 01-11-2004, 09:48 PM

Quote:

Originally Posted by Gary W

What's the difference?

I was merely pointing out that some people might want to change the grammar.

Geez,sorry for mentioning it. :devious:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.06084 seconds Memory Usage 2,354KB Queries Executed 25 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (7)bbcode_code (2)bbcode_html (5)bbcode_php (6)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!