vb.org Archive - List todays Threads /Posts totals

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

- Member Archives (https://vborg.vbsupport.ru/forumdisplay.php?f=202)

- - List todays Threads /Posts totals (https://vborg.vbsupport.ru/showthread.php?t=33095)

Diva	12-10-2001 07:47 AM

I'll never be a hacker, that's for darn sure! Would someone please help me to fix this hack. What I would like is:

Total Threads: 426 | Total Posts: 3,592
New Threads Today: | New Posts Today:

Notice the missing numbers in todays totals! Heh. What I 'thought' would work is:

In the index.php:

// get number of posts and Threads today
$datecut=mktime(0,0,0,date("m"), date("d"), date("y"));
$countpoststoday=$DB_site->query_first('SELECT COUNT(*) AS posts FROM post WHERE dateline>='$datecut'");
$totalpoststoday=number_format($countpoststoday['posts']);

$countthreadstoday=$DB_site->query_first('SELECT COUNT(*) AS threads FROM thread WHERE dateline>='$datecut'");
$totalthreadstoday=number_format($countthreadstoda y['threads']);

Any suggestions? Thanks bunches!

Lesane

12-10-2001 11:03 AM

There is already a hack for: New Threads Today. I will paste the code from that hack:

PHP Code:


		
			
// number of threads today

$datecut = mktime(0,0,0,date("m"), date("d"), date("y"));

$getthreadstoday=$DB_site->query_first("SELECT count(*) AS count FROM thread WHERE dateline>='$datecut'");

$threadstoday=$getthreadstoday[count];

Diva	12-10-2001 01:31 PM

I actually have that one as a search. Does it also just list the total threads How can I get the ?total posts? this is the one that I would really like to have.

squawell

12-10-2001 01:44 PM

try this one

PHP Code:


		
			
// today total posts

$squawell = mktime(0,0,0,date("m"), date("d"), date("y"));

$getpoststoday=$DB_site->query_first("SELECT count(*) AS count FROM post WHERE dateline>='$squawell'");

$poststoday=$getpoststoday[count];

Diva	12-10-2001 01:59 PM

Hi. Thanks! Ummm. One question though:

"$squawell" what is that equal to? I would like it to pull all posts and not just the individual. Will this do that?

Admin

12-10-2001 04:29 PM

Just like squawell posted:

Code:

$nowmktime=mktime(date("g"),date("i"),date("s"),date("m"),date("d"),date("y"));

// today total posts

$poststoday=$DB_site->query_first("SELECT COUNT(*) AS count FROM post WHERE dateline>='$nowmktime'");

$poststoday=$poststoday[count];

// today total threads

$threadstoday=$DB_site->query_first("SELECT COUNT(*) AS count FROM thread WHERE dateline>='$nowmktime'");

$threadstoday=$threadstoday[count];

squawell

12-10-2001 04:47 PM

[QUOTE]Originally posted by Diva
Hi. Thanks! Ummm. One question though:

"$squawell" what is that equal to? I would like it to pull all posts and not just the individual. Will this do that?

NSeXcellent

04-05-2002 09:53 PM

I also would like to find out how to get the # of posts 'today'... Is there an easy way to get 'Total Posts Today: #' ???

All times are GMT. The time now is 03:28 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.00977 seconds Memory Usage 1,732KB 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_code_printable (2)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (8)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 bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: