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

NTLDR · #32 01-06-2004, 09:17 PM

There is no COUNT() because that wouldn't do the job

I use a totally different method in order to get the three sets of data I need from just the one query, which with testing on a usual new post/thread count seems equally as fast as two queries.

Remember also thats more queries can sometimes be better and quicker.

Gary King · #33 01-06-2004, 11:14 PM

Quote:

Originally Posted by NTLDR

There is no COUNT() because that wouldn't do the job

I use a totally different method in order to get the three sets of data I need from just the one query, which with testing on a usual new post/thread count seems equally as fast as two queries.

Remember also thats more queries can sometimes be better and quicker.

I know, that's why I've left it at 2 queries (for now anyways, until I find time to test the different queries I could use and their speeds

)

gmarik · #34 01-08-2004, 05:42 PM

Yours hacks are used rather often!

Linear Helix · #35 01-08-2004, 11:41 PM

Is it just me, or will this let people who have no access to a certain forum realize that a new post has been made even if they can't check it?

I make a post in my Central Command, some registered user sees that the posts since last visit went up by 1, even though he has no permission to view the post.

Anybody know a way to fix this? Check for permission somehow in or after the query?

DanGarion · #36 01-09-2004, 09:09 PM

Am I the only person that has no idea where to find the hack installer listed in the txt? installer.php?

:/

NTLDR · #37 01-09-2004, 09:14 PM

I think Gary W made an error, I don't think you need to run an installer with this hack, just make the changes listed

corsacrazy · #38 01-09-2004, 09:27 PM

LOL its just one file edit, like a mini mod

DanGarion · #39 01-09-2004, 09:39 PM

Yeah I figured it was just a accident. I got it working, now I'm working on trying out vbIndex and eventually replacing vbportal when I switch to 3.0. I got to post on the vbindex topic about an error I'm getting there now

DCX · #40 01-10-2004, 01:35 AM

i really want this hack on my forum but when i try to look in the global.php file, i cannot find those commands listed anywhere on that file. i did a search on the global.php file and i can't find anywhere it says echo or anything. and i'm not sure if the navbar template file is the same as the template file in the admincp directory or not.... can someone please help? thanks.

PranK · #41 01-10-2004, 11:39 AM

/me clicks install

Thanks mate!

Christian

The Keeper · #42 01-10-2004, 11:53 AM

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

walkingthepath · #43 01-10-2004, 04:36 PM

Hack not working for me!!

I've got VB 3.0 RC2

Gary King · #44 01-10-2004, 04:41 PM

Quote:

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 · #45 01-10-2004, 04:45 PM

Quote:

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 · #46 01-10-2004, 06:03 PM

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.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05430 seconds Memory Usage 2,361KB Queries Executed 30 (?)
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 (1)bbcode_code (2)bbcode_html (3)bbcode_php (3)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 (16)post_thanks_box (16)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (16)post_thanks_postbit_info (15)postbit (16)postbit_onlinestatus (16)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!