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

Boofo · #52 01-10-2004, 09:05 PM

Quote:

Originally Posted by M1th

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 to the same thing for the other query.

Havent tested it but it should work.

I was talking about the one where forums that the user is not allowed to access is included in the query.

M1th · #53 01-10-2004, 09:07 PM

Quote:

Originally Posted by Boofo

I was talking about the one where forums that the user is not allowed to access is included in the query.

well, look again.. I HAVE included it in the query. :P

IN(" . implode(', ', $forumids) . ")

Boofo · #54 01-10-2004, 09:12 PM

Shows you what I know, huh?

Any way to combine the 2 queries like that?

EDIT: That query had a syntax error in it somewhere.

M1th · #55 01-10-2004, 09:48 PM

Quote:

Originally Posted by Boofo

Shows you what I know, huh?

Any way to combine the 2 queries like that?

EDIT: That query had a syntax error in it somewhere.

where? Dont see anything wrong with it.. :/

And why would you want to combine those two? they are from two different table... You wont gain anything by joining them.

Boofo · #56 01-10-2004, 10:08 PM

Well, it wouldn't run. It gave me an error near lastpost IN.

Joining the queries will reduce it to one and save one query.

Reverend · #57 01-10-2004, 10:24 PM

Quote:

Originally Posted by Gary W

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

No probs Gary.

M1th · #58 01-10-2004, 10:58 PM

Quote:

Originally Posted by Boofo

Well, it wouldn't run. It gave me an error near lastpost IN.

Joining the queries will reduce it to one and save one query.

it will, but the process and execusion time would be about the same.

But then again, im a n00b and get things wrong most of the time...

Blackbeard · #59 01-11-2004, 01:30 PM

I have installed the regular file, how do i make the numbers bold so they stick out

Gary King · #60 01-11-2004, 03:04 PM

Quote:

Originally Posted by Blackbeard

I have installed the regular file, how do i make the numbers bold so they stick out

Find:

PHP Code:


			
    $show = $memberstext.' '.strtolower($vbphrase['online']).': '.$regmemberson.'. '.$gueststext.' '.strtolower($vbphrase['online']).': '.$guestson.'.';

Replace with

PHP Code:


			
    $show = $memberstext.' '.strtolower($vbphrase['online']).': <b>'.$regmemberson.'</b>. '.$gueststext.' '.strtolower($vbphrase['online']).': <b>'.$guestson.'</b>.';

That should do it

Linear Helix · #61 01-11-2004, 05:51 PM

Thanks, M1th. I haven't tried your stuff there yet, but I'm gonna check it out and make it work.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04906 seconds Memory Usage 2,330KB 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 (1)bbcode_code (2)bbcode_html (6)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!