vb.org Archive - Number Of Posts On Forumhome Today

Page 1 of 3

Show 40 post(s) from this thread on one page

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

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

- - Number Of Posts On Forumhome Today (https://vborg.vbsupport.ru/showthread.php?t=82926)

eXtremeTim

06-11-2005 10:00 PM

Number Of Posts On Forumhome Today

What does this hack do?

This hack shows the number of posts that have been made today on your forums.

One Template Edit
One New Plugin

Demo: http://www.extremescripts.com/forums/ Look in the whats going on section.

mholtum

06-12-2005 03:20 AM

Nice work.

Thanks.

Breaker

06-12-2005 07:03 AM

thanks, very useful :D

Boofo

07-25-2005 03:14 PM

Can you add the number of threads made today to this, too? ;)

Chris M

07-25-2005 11:28 PM

Quote:

Originally Posted by Boofo

Can you add the number of threads made today to this, too? ;)

I've yet to find a way to join two COUNT(*) queries together, but this will work ;)

PHP Code:


		
			
$starttime = mktime(0, 0, 0, date('m'), date('d'), date('Y'));
 $newposts = $db->query_first("SELECT COUNT(*) AS count FROM " . TABLE_PREFIX . "post WHERE dateline >= $starttime");
 $newthreads = $db->query_first("SELECT COUNT(*) AS count FROM " . TABLE_PREFIX . "thread WHERE dateline >= $starttime");
 $poststoday = vb_number_format($newposts['count']);
 $threadstoday = vb_number_format($newthreads['count']);

Sadly, 2 queries per view of the forumhome page -.-

If we could store the data in the datastore that would help >_<

Satan

Pham Tuan Hai

08-14-2005 12:23 AM

hellsatan ! good job, thx bro.

.Tim	08-14-2005 12:58 AM

Nice!

Mr Chad

08-15-2005 05:02 AM

Thx worked fine and was easy and fast.

Installed On: 3.5.0 Beta 2

Pham Tuan Hai

08-15-2005 08:15 AM

it also works with RC2 :D

Mathiau

09-14-2005 10:20 PM

nice hack .

P.S your forum is hard on the eyes :(

All times are GMT. The time now is 08:56 PM.

Page 1 of 3

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01131 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 (2)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: