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

RichieBoy67 · #**162** 07-08-2004, 07:58 PM

Yep, I did it like 5 times already..... Maybe another hack is interfering with it..My site is hacked bigtime....

S@NL - BlackBik · #**163** 07-17-2004, 09:39 AM

Installed it and it works great

(on vB 3.03)

If you can find the time to look into the permissions thingy, it would be greatly appriciated Gary

S@NL - BlackBik · #**164** 07-17-2004, 01:51 PM

Quote:

Originally Posted by Linear Helix

AH! Thanks, M1th. The problem is solved!

Linear Helix, did you solve the problems with the permissions query?
If Yes, would you be so kind to post the correct query?

WEForums · #**165** 07-19-2004, 11:15 AM

*sigh*

Just posting to say this hack makes MySQL rise above 90% a lot of times. Not a good thing, especially since it's on all pages...

weaver · #**166** 08-06-2004, 01:38 AM

Works great.

I had forgotten to upload global.php and had the no numbers problem but all was fixed after getting it onto the server.

Dark Zero · #**167** 08-09-2004, 07:32 AM

Quote:

Originally Posted by WEForums

*sigh*

Just posting to say this hack makes MySQL rise above 90% a lot of times. Not a good thing, especially since it's on all pages...

i note the same problem

look the query time in the debug:

Code:

Query:
 SELECT count(*) AS posts FROM post WHERE dateline > '1092038482'
Time before: 0.48323607444763
Time after: 1.2166719436646
Time taken: 0.73343586921692

took 0.7 seconds, and i only tested in a test forum with 178.000 post
(my full forum have 220.000)

is much time for a query

my patch solution is only put the code in the index.php
no in global.php
that save much use

ambumann · #**168** 08-10-2004, 12:18 AM

I tried to install it, but keep getting error messages when I navigate the forum

Not able to add cookies, header allready sent.
File: /home/ybskldmn/public_html/pratkomp/global.php
Line: 651

When I try to view a post i get a blank screen.

YLP1 · #**169** 08-10-2004, 07:09 PM

Great mod and I have a question.... The number of new threads and posts do not show on the vbadvanced portal...how do I get it to show there?

http://yourlincolnpark.com/lpsforum/index.php

YLP1 · #**170** 08-10-2004, 07:14 PM

I wasn't thinking about about the server strain...where would I place this code in the index and is it the same code used in the global?

mcyates · #**171** 08-17-2004, 09:20 AM

i installed this but got nothing
www.myfootballforum.com

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04700 seconds Memory Usage 2,322KB 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 (2)bbcode_code (2)bbcode_html (3)bbcode_php (2)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!