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

[Dark Zero]

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:

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]

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]

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]

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]

i installed this but got nothing
www.myfootballforum.com

[Blackbeard]

I use this hack, but have installed vbadvance cms and it dont show any numbers at all anyone fixed this.

[Jpc]

Same here, I dont use vbaadvance cms but mine will not present numbers, just the phrase text. Ive reinstalled literally 6+ times, double checked everything and again and again.... What to try next?

[Envy-UK]

Originally Posted by Jpc

Same here, I dont use vbaadvance cms but mine will not present numbers, just the phrase text. Ive reinstalled literally 6+ times, double checked everything and again and again.... What to try next?

I'm with you on this one. I've started from scratch many times and it's still not showing the numbers, just the phrase text.

[Dark Aura]

Is there a way to provide a link for the number of new posts and threads so when you click on it, it takes you to a page and shows them all to you?

[Envy-UK]

Could you not just link it to /search.php?do=getnew' ?

[JKeats]

unless there's been a change to the code i missed somewhere in these 12 pages... this hack counts all new posts... is there a way to alter it so that if a user doesn't have access to a particular forum it won't coun't new posts from that forum?

[Reverend]

Originally Posted by JKeats

is there a way to alter it so that if a user doesn't have access to a particular forum it won't coun't new posts from that forum?

I asked the same question in this thread a while back and from the replies i got back it would apparently be too complex to exclude non permission forums.

https://vborg.vbsupport.ru/showpost....2&postcount=45

[JKeats]

that's unfortunate.

[noppid]

I started installing this and realized it puts those two queries system wide. Forum home is the way to go IMO. The permissions need to be worked out to. Great idea, the codes just not ready yet.

Neither thread nor post have an index on dateline, perhaps that would help performance?

[noppid]

Here's my test with no indexes on...
Threads: 4,164,
Posts: 60,276

no indexes: 1.8818728923798 seconds
try two, much later: 2.7305688858032 seconds
immediate retry, must be a cache: 0.00036907196044922 seconds
five minutes later: 0.23074579238892 seconds

I'll add the indexes and try much later so the cache hopefully expires.