How many threads and posts since your last visit!

[Gary King]

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
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
# 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

# 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 :)

[Gio Takahashi]

Hmmm might actually do this one.

[MGM]

good job man, thanks for the hack!

*clicks install*

MGM out

[Gio Takahashi]

Installed, works smoothly.

[Dan]

nice one this will help with making a custom Welcome panel :D

[assassingod]

Shame I didn't get to release my version that I did ages ago:(

[The Keeper]

Does it actually show new threads, or will a thread show as new if there is a new post in it?

[Gary King]

Both.

[DCX]

i'm new to vb and i wanna try to add hacks and stuff to my board. i found the global.php file on the server but i couldn't find the navbar template file. to make things easier for me, is there a site or list somewhere showing where all the files are installed into which folder or whatever? oh yeah, will this work for vb3 gamma?

[SnowBot]

i'm new to vb and i wanna try to add hacks and stuff to my board. i found the global.php file on the server but i couldn't find the navbar template file. to make things easier for me, is there a site or list somewhere showing where all the files are installed into which folder or whatever? oh yeah, will this work for vb3 gamma?the templates are located in your admin control panel under

Style Manager

in the dropdown menu click edit templates and you will see them all

good luck :)

[Link14716]

Installed to phpinclude_start.

Thanks. :)

[The Keeper]

Both.Wouldn't it be better to have it so that new threads only showed up when there actually were new threads? You could do that by selecting the id from thread table where createdate is newer than last visit.

SELECT threadid FROM thread WHERE dateline > $pmlastvisit

Or something like that.

[macshrine]

really easy to install!! great mod, i installed it at www.macshrine.com/forums/index.php

thanks alot :)

[Gary King]

i'm new to vb and i wanna try to add hacks and stuff to my board. i found the global.php file on the server but i couldn't find the navbar template file. to make things easier for me, is there a site or list somewhere showing where all the files are installed into which folder or whatever? oh yeah, will this work for vb3 gamma?
Yep it should work with vB 3 Gamma, you can try anyways, it's a very quick install and uninstall if required :)

[Littlebit]

installed :) thanks for the mod Gary

[Bernd Glasstett]

I added something to it, phrases to be exact.

Enter the following phrases on GLOBAL:

home_sincelastvisit = since your last visit
home_newthreadssincelastvisit = new threads
home_newpostsssincelastvisit = new posts

and then use this code in the navbar-template:


<br /><b>$getnewthread[threads]</b> $vbphrase[home_newthreadssincelastvisit], <b>$getnewpost[posts]</b> $vbphrase[home_newpostsssincelastvisit] $vbphrase[home_sincelastvisit]


For the ones who would like to translate it ;)

[Link14716]

All you need is one phrase.

Just call it "home_sincelastvisit"
"There have been {1} threads and {2} posts since your last visit!"

Then use this in navbar:
<phrase 1="$getnewthread[threads]" 2="$getnewpost[posts]" />$vbphrase[home_sincelastvisit]</phrase>

[Bernd Glasstett]

true... I still have to get used to some things on the new system. Thanks Link :)

[ogden2k]

Which one do I use if I don't want the thread count to go up if someone posts into a thread?

[SmEdD]

This is also possible to be done in one query instead of two.

And you should also give credit to the orignal author for the vb2 one as the query has barley changed.

[squawell]

All you need is one phrase.

Just call it "home_sincelastvisit"
"There have been {1} threads and {2} posts since your last visit!"

Then use this in navbar:
<phrase 1="$getnewthread[threads]" 2="$getnewpost[posts]" />$vbphrase[home_sincelastvisit]</phrase>
thats a good infomation to me

Thankz Link:D

[Gary King]

Okay I'll be integrating all this new information into the next version of this hack, so stay tooned! :D

[Gary King]

This is also possible to be done in one query instead of two.

And you should also give credit to the orignal author for the vb2 one as the query has barley changed.

How will I make it into one query, why don't you just post the one query so I can use that instead :)

[Gary King]

Okay the instructions have been updated slightly to be able to incorporate the phrases feature of vB 3. This update is strictly optional, so you do not have to install it, but if you want to have this hack in a different language, then you can install the hack with the updated instructions :)

Thanks to Bernd Glasstett for the idea of using phrases and Link14716 because I'm actually using the phrases that he suggested :p

[NTLDR]

How will I make it into one query, why don't you just post the one query so I can use that instead :)

It can easily be done with one query. My version in vBindex 3 which uses origional code only uses one query for new threads, posts and updated subscribed threads.

[DCX]

ok, i'm really stupid.... i just managed to upgrade to rc2 myself with no prior experience and it worked out good. i didn't install this hack into it yet cause i was probably going to upgrade first. now i did look for the global.php file and found it in the admincp folder but i couldn't find this text:

******************************

OPEN global.php AND FIND

******************************

echo "End call of global.php: $aftertime\n";

echo "\n<hr />\n\n";

and i looked in the same directory and i looked in the templates folder and i couldn't find this text either:

<if condition="$show['pmstats']"><br /><a

href="private.php?$session[sessionurl]">$vbphrase[private_messages]</a>: $vbphrase[unread] <if

condition="$bbuserinfo['pmunread']"><strong>$bbuserinfo[pmunread]</strong><else

/>$bbuserinfo[pmunread]</if>, $vbphrase[total] $bbuserinfo[pmtotal].</if>

can someone give me step by step where everything is and how it's done. thanks a lot.

[corsacrazy]

i put it here so its easier for users to understand :)

[ogden2k]

i put it here so its easier for users to understand :) Good idea.

Which one do I use if I don't want the thread count to go up if someone posts into a thread?

[corsacrazy]

just use the second query

[Gary King]

It can easily be done with one query. My version in vBindex 3 which uses origional code only uses one query for new threads, posts and updated subscribed threads.
Okay I never meant said that it's impossible, and I never had something like "if you're good enough then show me the query" :)

I just asked for the query, instead of just saying it's possible to do in one query :)

Also, I can't seem to find the COUNT() function in your code?

[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.

[Gary King]

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 :D)

[gmarik]

Yours hacks are used rather often!

[Linear Helix]

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]

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

:/

[NTLDR]

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]

LOL its just one file edit, like a mini mod

[DanGarion]

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]

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]

/me clicks install

Thanks mate!

Christian

[The Keeper]

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

[walkingthepath]

Hack not working for me!! :( I've got VB 3.0 RC2

[Gary King]

Hack not working for me!! :( I've got VB 3.0 RC2
What do you mean not working? What's the problem?

[Gary King]

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]

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. ;)

[feldon23]

Reverend, that would require a very complex query.

[Gary King]

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. ;)
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 :)

[M1th]

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. ;) you can use something like this:



// to check permissions for different users in forums
$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))
{
// get rid of the forumids that the user doesnt have permission to view
unset($forumids["$key"]);
}
}



Then you add (new threads count in this case) ,

$getnewthread=$DB_site->query_first("
SELECT COUNT(*) AS threads
FROM ".TABLE_PREFIX."thread
WHERE lastpost IN(" . implode(', ', $forumids) . ") > '".$bbuserinfo['lastvisit']."'
");


as the query.

[Boofo]

Can you show us the whole thing? ;)

[M1th]

Can you show us the whole thing? ;)
an example (for getting count of new threads since last visit):



$getnewthread=$DB_site->query_first("
SELECT COUNT(*) AS threads
FROM ".TABLE_PREFIX."thread
WHERE lastpost IN(" . implode(', ', $forumids) . ") > '".$bbuserinfo['lastvisit']."'
");



You just do the same thing for the other query.

Havent tested it but it should work. :)

[Boofo]

an example (for getting count of new threads since last visit):



$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]

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]

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]

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]

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]

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]

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... :p

[Blackbeard]

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

[Gary King]

I have installed the regular file, how do i make the numbers bold so they stick out
Find: $show = $memberstext.' '.strtolower($vbphrase['online']).': '.$regmemberson.'. '.$gueststext.' '.strtolower($vbphrase['online']).': '.$guestson.'.';


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


That should do it :)

[Linear Helix]

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

[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:

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

To this:

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

[Linear Helix]

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

// ################################################## ###########################
// 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]

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

From this:

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

To this:

There have been {2} posts in {1} threads since your last visit!
What's the difference? :p

[Gary King]

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

// ################################################## ###########################
// 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]

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() &gt; '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 ') &gt; '1068258593'' at line 3

mysql error number: 1064

***

Character entity. I'll see if I can fix that &gt; crappage.

[Gary King]

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() &gt; '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 ') &gt; '1068258593'' at line 3

mysql error number: 1064

***

Character entity. I'll see if I can fix that &gt; 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.php?p=460218&postcount=48

[Linear Helix]

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]

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

From this:

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

To this:

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]

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]

What's the difference? :pI was merely pointing out that some people might want to change the grammar.

Geez,sorry for mentioning it. :devious:

[Boofo]

I would only use it with new posts AND new threads. Then it wouldn't work right. ;)

[Gary King]

I would only use it with new posts AND new threads. Then it wouldn't work right. ;)
I'm not sure if you've noticed, but both those phrases would do the exact same thing only move things around :)

And to Reverend, I can't really see how either way would be "gramatically correct" :p

[Reverend]

And to Reverend, I can't really see how either way would be "gramatically correct" :pDid i say anything about the grammar being correct or incorrect. ????

Whatever ... :rolleyes: :D

[Gary King]

Did i say anything about the grammar being correct or incorrect. ????

Whatever ... :rolleyes: :D
My mistake :rolleyes:

[Tru Smiles]

Err.. Am I just stupid or something, but what does it mean by 'Phrase'? Is it a query that has to be run or a new template? o_o

[Gary King]

Err.. Am I just stupid or something, but what does it mean by 'Phrase'? Is it a query that has to be run or a new template? o_o
Admin CP -> Languages & Phrases -> Phrase Manager

[Tru Smiles]

Thanks, I should have noticed that myself >_>;;

Text has come up, but the number of threads and posts ain't there - Is there something that has to be added for RC2?

[Gary King]

Thanks, I should have noticed that myself >_>;;

Text has come up, but the number of threads and posts ain't there - Is there something that has to be added for RC2?
Nope these instructions are for vB 3 RC 2, you probably missed a step.

[Rampag33]

All you need is one phrase.

Just call it "home_sincelastvisit"
"There have been {1} threads and {2} posts since your last visit!"

Then use this in navbar:
<phrase 1="$getnewthread[threads]" 2="$getnewpost[posts]" />$vbphrase[home_sincelastvisit]</phrase>
Installs

Great job was looking for this.

[Gary King]

Installs

Great job was looking for this.
Already included in the instructions I believe :)

[Linear Helix]

Attention M1th.

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

$forumids apparently ends up empty, because when the script tries to implode() it later on for use in the IN() in the query, nothing results, breaking the query.

[DCX]

ok, i found out that the reason i couldn't find the phrase in the global.php section was because i was lookin at the wrong global.php file....... the only thing i need help on now is editing the navbar template. where do i find that????

[M1th]

Attention M1th.

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

$forumids apparently ends up empty, because when the script tries to implode() it later on for use in the IN() in the query, nothing results, breaking the query.
Yep, It'll work if you use it for one query only. The second one ends up empty.

[DCX]

ok... i found the templates in the admin control panel. i'll let you know if i got it to work......

[Linear Helix]

AH! Thanks, M1th. The problem is solved!

[gmarik]

nice one

[DCX]

finally, this newb figured it all out..... got it working and it's all good.

[Gary King]

finally, this newb figured it all out..... got it working and it's all good.
Who exactly are you talking about?

[M1th]

Who exactly are you talking about?

I think he's talking about himself. :p

[Gary King]

I think he's talking about himself. :p
Apparently :rolleyes: :p

[DCX]

yes i was.

[KuraFire]

The COUNT(*) method of doing the query is rather intensive for your server if you have it in phpinclude_start - it's a slow query (the more posts and threads, the slower) that can really hog down a server. I'm interested in seeing NTLDR's method though...

[Mijae]

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

Geez,sorry for mentioning it. :devious:
How many queries does this use? It is too hard on the server?

[Gary King]

How many queries does this use? It is too hard on the server?
2 queries, and no, the queries aren't really that much of a strain on the server :)

[Boofo]

The COUNT(*) method of doing the query is rather intensive for your server if you have it in phpinclude_start - it's a slow query (the more posts and threads, the slower) that can really hog down a server. I'm interested in seeing NTLDR's method though...
How would you do it? ;)

[KuraFire]

How would you do it? ;)
Haven't looked into it much, but apparently NTLDR has a working method :)

[Boofo]

NTLDR, buddy, can you share it with us? ;)

[WetWired]

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

From this:

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

To this:

There have been {2} posts in {1} threads since your last visit!
For those arguing over this, it's quite simple. If you installed the version that counts old threads with new posts as new threads, then those threads aren't neccessarily new. Therefore, "There have been {2} posts in {1} threads since your last visit!", because the number of "new threads" is really the number of threads with new posts in them. If you installed the version that only lists threads started since the last visit, then the original phrase is more correct.
Not installing this 'cause of the permissions thing. Gonna take some time and look into it myself.

[ogden2k]

I've found a problem with this, if I go to new posts, there's 8 new let's say, New Posts shows all 8. But, when I view all of the 8 posts, the hack still shows that they are new. Shouldn't the hack show 5 new threads if I've read 3 of the 8?

Can this be fixed?

[Gary King]

I've found a problem with this, if I go to new posts, there's 8 new let's say, New Posts shows all 8. But, when I view all of the 8 posts, the hack still shows that they are new. Shouldn't the hack show 5 new threads if I've read 3 of the 8?

Can this be fixed?
Nope, that's how vBulletin works. Click on 'marks forum read' or wait until you expire (time limit depends on what you set in your Who's Online options) then check back on the forums :)

[ogden2k]

Ah ok, that's too bad. It can be confusing for some people.

[Gary King]

Ah ok, that's too bad. It can be confusing for some people.
It's because technically, you would be online your forums for only 0.1 seconds, which is the time it takes to load the page. Because once page is loaded, connection is killed :)

[KuraFire]

It's because technically, you would be online your forums for only 0.1 seconds, which is the time it takes to load the page. Because once page is loaded, connection is killed :)
minor detail: unless you're using persistent connections, but those won't affect new posts indicators :)

I'm such a nitpicker.. ;D

[ogden2k]

I am using RC4, and when there are 0 new threads or posts, I get this:
%1$s

[Gary King]

I am using RC4, and when there are 0 new threads or posts, I get this:
%1$s
Strange, works fine for me on RC 3 with 0 threads and 0 posts.

[ogden2k]

It worked fine on RC3 for me as well, not RC4...

[Gary King]

Strange, I'll wait until someone else can confirm this before looking into it :)

[ogden2k]

You can't try it your self...?

[Gary King]

You can't try it your self...?
Well I was hoping someone could respond within a few minutes :p
Anyways, installed RC4, and works fine for me :)

[DCX]

Well I was hoping someone could respond within a few minutes :p
Anyways, installed RC4, and works fine for me :)

so do i upgrade to RC4 and RE-install the hack or should it already be on there?

[BillaBongUSA]

You have to re-install it when you upgrade.

[Gary King]

Well you shouldn't have to re-install unless you upgrade 'properly' (by NOT replacing all files) but if you did, try re-installing and hopefully it'll work :)

[DCX]

yeah, when i upgraded... i saw "There have been threads and posts since your last visit" was there but there was no numbers....

i basically was goin in like i was gonna install them again but everything was in place... even the navbar template and the phrases i added. all i did was double check everything and it was working fine again.

[Logikos]

/me clicks install

[Logikos]

Don't like the fact that the permissions don't work, thought since it was vB3 it wouldn't be like the vB2 version where it does the same thing.

/me uninstalls

[MischiefThought]

GREAT Hack. Wonderfull job.

[Wifey]

Installed and it's working perfectly. Thanks!

[Cloudrunner]

Is this working on Gold anyone know?

I cleanly redid everything on me site, and have been bugged about getting this one back, but don't wanna chance it til I have confirmation that it works on Gold.

Thanks

)O( Cloudrunner )O(

[Gary King]

Is this working on Gold anyone know?

I cleanly redid everything on me site, and have been bugged about getting this one back, but don't wanna chance it til I have confirmation that it works on Gold.

Thanks

)O( Cloudrunner )O(
Yep works on Gold :)

[trafix]

Yep works on Gold :)
interesting, i just installed this and acording to the hack it says...

There have been 747 threads and 4488 posts since your last visit!

any ideas?

[Ocean]

Gary, M1th made a post here suggesting a change that would account for not counting posts/threads that the user didn't have permission for.


Have you looked at this? If so, what's your opinion on it?


And if anyone else has tried it - can you tell me how well it works, as well as how much added load it puts on the Server?

Thanks, all!

[Gary King]

interesting, i just installed this and acording to the hack it says...

There have been 747 threads and 4488 posts since your last visit!

any ideas?
Check now it should be working fine :)

[Gary King]

Gary, M1th made a post here suggesting a change that would account for not counting posts/threads that the user didn't have permission for.


Have you looked at this? If so, what's your opinion on it?


And if anyone else has tried it - can you tell me how well it works, as well as how much added load it puts on the Server?

Thanks, all!
I'll look into that when I have enough free time; also, might take up too much processing time on each page, but if someone wants to make this, then be my guest :)

[trafix]

Check now it should be working fine :)
nope, just checked it now and i have ---> There have been 750 threads and 4499 posts since your last visit!

[Gary King]

nope, just checked it now and i have ---> There have been 750 threads and 4499 posts since your last visit!
I can tell you right now that it's not this hack that's having the problem, but something else going on in the forums. Which board is it for?

[trafix]

We are using Gold! and only has 5 hacks installed

HTL -- has 3 file edits
VB Trader (Full) -- has NO file edits
Members Choice Voting -- has NO file edits
On line Today (yours)
and this one

[Gary King]

We are using Gold! and only has 5 hacks installed

HTL -- has 3 file edits
VB Trader (Full) -- has NO file edits
Members Choice Voting -- has NO file edits
On line Today (yours)
and this one
http://www.petnshow.com/network/ ?

[trafix]

nope ... another site that i am co admin for http://www.usodja.com/forums/index.php?

[Ocean]

Hi!

Quick question - the Instructions at some point tell you to look for:


******************************
OPEN UP THE navbar TEMPLATE AND FIND
******************************
<if condition="$show['pmstats']"><br /><a href="private.php?$session[sessionurl]">$vbphrase[private_messages]</a>: $vbphrase[unread] <if condition="$bbuserinfo['pmunread']"><strong>$bbuserinfo[pmunread]</strong><else />$bbuserinfo[pmunread]</if>, $vbphrase[total] $bbuserinfo[pmtotal].</if>
******************************



However, I couldn't find that code anywhere in my navbar template.

Am I blind? Or has there been a change for vB 3.0 Gold?

[Hellburn]

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>

Below add the code.

[Ocean]

Thank you, Hellburn. That did the trick. :)

[Gary King]

nope ... another site that i am co admin for http://www.usodja.com/forums/index.php?
Wow that is really messed up, I'm not too sure on what the problem is though. They look like they have no relation with any of the forum stats; anyhow, maybe something to do with your vB Trader? Because this hack relies on the thread and post tables, not sure if that has anything to do with the hacks that you installed. Anyhow you're the only one reporting this problem as of now.

[Choclo]

I got strange characters...

íæÌÜÏ 1 ãæÇÖíÚ æ 30 ãÔÇÑßÇÊ ãõäÐ ÃÎÑ ÒíÇÑÉ áß

on vB 3.0 gold...

[Stray]

The problem with the hack listing so many posts and threads might have something to do with the fact that it seems to continually add threads and posts made since you came back, in other words it shows threads and posts made while you were gone plus continues to add whatever is going on while you're currently there until you leave or mark all forums read.
At least that's what it does for me...

[Gary King]

The problem with the hack listing so many posts and threads might have something to do with the fact that it seems to continually add threads and posts made since you came back, in other words it shows threads and posts made while you were gone plus continues to add whatever is going on while you're currently there until you leave or mark all forums read.
At least that's what it does for me...
Yep that's how the built-in new post feature works in vBulletin (when you click on 'Get New Posts').

It will reset once it passes the cookie timeout setting you chose in your admin cp.

Also, for that vB3 Gold problem with strange characters, works fine for me on vBulletin 3 :)

[Stray]

That's kinda odd, but it does make sense. Maybe I'll add something to my FAQ about it because people are already getting confused.
It's funny how every new thread also counts as one new post, it's gonna take me awhile to get used to finding logical explanations, seems like such a rare occurence with other software. :laugh:

[Gary King]

That's kinda odd, but it does make sense. Maybe I'll add something to my FAQ about it because people are already getting confused.
It's funny how every new thread also counts as one new post, it's gonna take me awhile to get used to finding logical explanations, seems like such a rare occurence with other software. :laugh:
Well technically, new threads ARE new posts as well ;)

[SaN-DeeP]

* SaN-DeeP installed ;)

[SaN-DeeP]

OPEN UP THE navbar TEMPLATE AND FIND
******************************
<if condition="$show['pmstats']"><br /><a href="private.php?$session[sessionurl]">$vbphrase[private_messages]</a>: $vbphrase[unread] <if condition="$bbuserinfo['pmunread']"><strong>$bbuserinfo[pmunread]</strong><else />$bbuserinfo[pmunread]</if>, $vbphrase[total] $bbuserinfo[pmtotal].</if>
******************************
UNDER IT, ADD
******************************
<br /><phrase 1="$getnewthread[threads]" 2="$getnewpost[posts]" />$vbphrase[navbar_sincelastvisit]</phrase>






I am unable to find that line in navbar :rolleyes: :rolleyes:

need help pls.

Thxn.
Sandy...

[Gary King]

OPEN UP THE navbar TEMPLATE AND FIND
******************************
<if condition="$show['pmstats']"><br /><a href="private.php?$session[sessionurl]">$vbphrase[private_messages]</a>: $vbphrase[unread] <if condition="$bbuserinfo['pmunread']"><strong>$bbuserinfo[pmunread]</strong><else />$bbuserinfo[pmunread]</if>, $vbphrase[total] $bbuserinfo[pmtotal].</if>
******************************
UNDER IT, ADD
******************************
<br /><phrase 1="$getnewthread[threads]" 2="$getnewpost[posts]" />$vbphrase[navbar_sincelastvisit]</phrase>






I am unable to find that line in navbar :rolleyes: :rolleyes:

need help pls.

Thxn.
Sandy...
Instructions updated take a look :)

[SaN-DeeP]

Gary W thnx for quick reply
works :)

Sandy...

[LadyBeth]

clicking install!

[SaN-DeeP]

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!

I cant find that line in my navbar template 0_o
also the PRivate Messages link on navbar is not visible after installing this hack.
I am sure. something i did wrong somewhere.

Please help

Thnx.

[leitel]

Just curious. Does the count of new posts and threads since their last visit INCLUDE new posts/threads in forums from which they do not have access? Thanks! :)

[Illuvatar]

Illuvatar installs this one again on VB Gold! :p

Modified the phrase just a tad...but hey. lol

http://www.warofthering.net/forums/vbulletin225/upload/index.php?

[Linear Helix]

leitel:

Just curious. Does the count of new posts and threads since their last visit INCLUDE new posts/threads in forums from which they do not have access? Thanks!
Yeah, that's the big problem with this mod. I worked on it a while but I don't know enough php/MySQL to get it to count only stuff the user has permission to see.

[GaleForce]

When there are 0 threads and 0 new posts it shows this;

There have been threads and posts since your last visit!

Wait... it's showing that for everything. :surprised:

[budlite74]

i dont get the actuall #post and #threads ... I just get the phrase

[Sooner95]

thanks bud...works great!

[Reverend]

Has anyone managed to code this so that it only counts threads/posts that the user has permission to view.

Members are constantly enquiring why the counts don't match the "new posts" search results.Feels awkward explaining to them that the totals include forums they don't have access to. :disappointed:

[WEForums]

When there are 0 threads and 0 new posts it shows this;

There have been threads and posts since your last visit!

Wait... it's showing that for everything. :surprised:Upload global.php.

You, too, budlite74.

[whitetigergrowl]

Upload global.php.

You, too, budlite74.
I'm having the same problem even though everything (after double and triple checking) seems to look like it's supposed to. It shows the words but no #'s. Any idea how I can fix this?

[RichieBoy67]

Dam, same problem here.... Help please...

[Steve123]

My forums have a million posts or so..

When it runs the query on the posts table it takes a while.. is there any way around this?

[RichieBoy67]

Is there any support for this??? Please???

[Illuvatar]

lol...

This wonderfull hack has been re-installed twice in 3 days!

First for VB 3.0.2 and now for 3.0.3!! :p

Thanks again!

[RichieBoy67]

maybe you can help me for a minute????

[Illuvatar]

Not a problem! I actually had the same problem you did after I upgraded, and that was because the globals.php file is replaced with the upgrade. All of my other pieces, the phrase, etc. were not affected. So all I had to do was reinsert the code into globals.php and re-upload it....and poof.....all fixed.

Have you verified that your globals is hacked proper?

[RichieBoy67]

Yep, my global.php should be right on the money.. I uninstalled the template right now though because it wasn't working..

[Illuvatar]

Jeez...dunno..... I'd say to try again....make sure everything is backed out and reapply the whole thing. Should only take like 5 minutes.

[RichieBoy67]

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

[S@NL - BlackBik]

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]

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]

*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]

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]

*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]

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]

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.php?p=460142&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.

[Boofo]

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?
I've been running my own version of this on the forumhome in my forumhome cache stats hack since before this came out. 1 query. ;)

[carwash]

I am unable to find that line in the navbar template.....has anyone else had this problem? Copying it and pasting it elsewhere and then searching brings up nothing. :(

[steadicamop]

carwash;

Tip - this is something I do, just copy part of the code and search for that, it may just be one character different, then if you do find it, just check the original code and the one you have in your navbar.

I find that sometimes works.

If not, here's whereabouts it is on mine:

<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>
<br /><phrase 1="$getnewthread[threads]" 2="$getnewpost[posts]" />$vbphrase[navbar_sincelastvisit]</phrase>
</div>
</td>

<else />
It's quite near the top, where it shows how many new Private Messages you have.

HTH

Jason

[asarian-host]

This hack does not work at all! :( It just says: "There have been threads and posts since your last visit!" And it does not update any counters (Vbulletin 3.0.5).

- Mark

[silent.dr3am]

*cllicks the install button

nice hack, i like!

[sigh]

This hack does not work at all! :( It just says: "There have been threads and posts since your last visit!" And it does not update any counters (Vbulletin 3.0.5).

- Mark

Same here - doesn't work in 3.0.6

[Reverend]

This hack does not work at all! :( It just says: "There have been threads and posts since your last visit!" And it does not update any counters (Vbulletin 3.0.5).

- MarkDouble check your global.php edit.

Its the global.php that adds the counters.

Works perfect for me on 3.0.6

[agiacosa]

It is working fine within vB but it doesn't show the counts in my portal page (CMPS). Anyone got it working on a portal?

[AxEsLoCkEd]

Greate Mod *clicks install* :)

[cnczone]

it works!

[Snake]

Thanks.

[neil b]

No problems here. Great hack.

[Deyth]

Fatal error: Call to a member function on a non-object in c:\hosting\webhost4life\member\deyth\vbulletin\glo bal.php on line 727

[Carforumsnet]

This hack still works even on VB 3.0.9.....you just have to change the placement of the lines in Global.php. You need to add them under


$vbphrase['unread_x_nav_compiled'] = construct_phrase($vbphrase['unread_x_nav'], $pmunread_html);
$vbphrase['total_x_nav_compiled'] = construct_phrase($vbphrase['total_x_nav'], $bbuserinfo['pmtotal']);

[DrewzR/T]

Yeah I couldnt find the lines in 3.0.7. But I think its mainly because I have the blinking PM indicator. Oh well.

[Illuvatar]

Cannot get this to work in 3.5 :(

[s?dpol]

Hi,

I queried the forum but can't find a version working with vb 3.5x. Is there a new Version available?

Thanks

[Reverend]

Hi,

I queried the forum but can't find a version working with vb 3.5x. Is there a new Version available?

Thanks

https://vborg.vbsupport.ru/showthread.php?t=82774

works with 3.5x