vb.org Archive - X newposts in Y threads

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)

- - X newposts in Y threads (https://vborg.vbsupport.ru/showthread.php?t=91370)

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

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.

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

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++;

}

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

Quote:

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

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.

There ya go Allan.
Screenshot posted.

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_php_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01378 seconds Memory Usage 1,736KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_php_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: