X newposts in Y threads

##############################################
##############################################

THIS HACK CHANGED TOO MUCH!!
IT'S NO LONGER A PLUGIN!!
New Thread ... New File!!
Old removed to help eliminate confusion!!
Please visit the new thread!!!

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

I'll leave this old post and thread here for reference purposes.

##############################################
##############################################

I'm sure this is worked to death already, but I make mine a little differently. It grabs the new posts (via dateline time) but it grabs the threads (via lastpost time). This makes it slightly more intuative as it will show the number of posts found in "X threads" instead of "X newthreads".


Ohhh, and this one doesn't use a phrase.
So if you don't like english I guess you shouldn't use this.


Contents:
One plugin to upload (runs two queries in global).
One line of code to add to navbar template.

The line of code and instructions are in the included readme file.


updated to v2 already
----------------------------
Now uses Link14716's single query, but I added a conditional to set 0 if no new posts.

Also added screenshot

[Link14716]

If you only want the amount of new posts and the amount of threads those posts where in, it can be done with only one query.

[Mr Blunt]

Bring it on bro!!
I'm all ears!!
I love constructive critisism and/or being taught!!
That's how amateurs like me learn best...

[Link14716]

Let me see if I can get this right on my first try.

PHP Code:

$getnewposts = $db->query_read("SELECT COUNT(*) AS posts, threadid
                                FROM " . TABLE_PREFIX . "post
                                WHERE visible = 1 AND dateline >= '{$vbulletin->userinfo['lastvisit']}'
                                GROUP BY threadid");
while ($getnewpost = $db->fetch_array($getnewposts)) {
    $newposts += $getnewpost['posts'];
    $newthreads++;
} 


[Mr Blunt]

Rock on .... file is updated.

I noticed no new posts reflected empty so I added a conditional to set as 0 if not set.
Thanks Link14716 .... I now see the light!!

[Link14716]

Originally Posted by Mr Blunt

Rock on .... file is updated.

I noticed no new posts reflected empty so I added a conditional to set as 0 if not set.
Thanks Link14716 .... I now see the light!!

Ah, yeah, forgot to make them 0.

[Mr Blunt]

Only thing it will screw up is like a vote in a poll.
Some boards set the admincp so new votes "up" the thread which adds to it's dateline.

But I like the one query better!!

Someday the vb staff should change that feature so a vote adds to the post count too (for boards that set that feature), but I suppose that gets complex as most boards ... even if they use the feature .... would still not want post counts to actually be raised by a vote.

Guess this is why I released what some would call a duplicate hack.
Fact is there's lots of strokes for different folks this is a very tweakable little area.
....So why not ... I said to myself.

[Allan]

an screen please

[Mr Blunt]

There ya go Allan.
Screenshot posted.

[Azhrialilu]

Works lovely