vb.org Archive - Counting number of posts daily

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

- vB4 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=252)

- - Counting number of posts daily (https://vborg.vbsupport.ru/showthread.php?t=320809)

Raakin

11-17-2015 12:27 PM

Counting number of posts daily

I am trying to use this in a plugin but it keeps displaying Resource id #107 or some number instead of the actual post count.

Code:

$start = TIMENOW - 3600 * 24; 



$dailypostcount = $vbulletin->db->query_read("SELECT COUNT(*) FROM " . TABLE_PREFIX . "post WHERE dateline > " . $start);

How can get the actual post count?

squidsk

11-17-2015 02:01 PM

Quote:

Originally Posted by Raakin (Post 2558882)

I am trying to use this in a plugin but it keeps displaying Resource id #107 or some number instead of the actual post count.

Code:

$start = TIMENOW - 3600 * 24; 



$dailypostcount = $vbulletin->db->query_read("SELECT COUNT(*) FROM " . TABLE_PREFIX . "post WHERE dateline > " . $start);

How can get the actual post count?

The result from the a database query is not just one field, it is an array (i.e. resource) of all fields returned by the query.

To get the result from your query change the query as follows:

Code:

$start = TIMENOW - 3600 * 24; 



$dailypostcount = $vbulletin->db->query_first("SELECT COUNT(*) AS postcount FROM " . TABLE_PREFIX . "post WHERE dateline > " . $start)['postcount'];

Raakin

11-17-2015 03:14 PM

I tried this but now it doesn't even display anything.

Dave	11-17-2015 03:22 PM

You have to use query_first if you want it to fetch the first row.

Code:

$start = TIMENOW - 3600 * 24; 



$q = $vbulletin->db->query_first("SELECT COUNT(*) AS postcount FROM " . TABLE_PREFIX . "post WHERE dateline > " . $start);

$dailypostcount = $q['postcount'];

Raakin

11-17-2015 03:50 PM

Thanks. It worked perfectly.

squidsk

11-17-2015 05:12 PM

Sorry I thought I made that change that was my mistake. I've edited the post now to be correct.

All times are GMT. The time now is 06:48 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01375 seconds Memory Usage 1,720KB 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 (4)bbcode_code_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (6)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: