vb.org Archive - Select count from table...

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

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

- - Select count from table... (https://vborg.vbsupport.ru/showthread.php?t=323857)

sixpackspeak

11-11-2016 01:05 PM

Select count from table...

I am using this code for an AJAX Chat Integration.

https://vborg.vbsupport.ru/showthrea...=269509&page=2

Updated to the following recently:
vBulletin 4.2.3 Patch Level 2
PHP 5.6.27-0+deb8u1 (cli)

And now the user counter doesn't work properly on the nav bar.

FYI, I've updated the "global_bootstrap_init_start" slightly, to make it a little more specific (and to remove duplicate login entries):

Code:

$resCNT = mysql_query("SELECT COUNT(userID) FROM ajax_chat_online GROUP BY userID");   

$num_chatting = $resCNT[0];

vB_Template::preRegister('navbar',array('num_chatting' => $num_chatting));

vB_Template::preRegister('FORUMHOME',array('num_chatting' => $num_chatting));

The query works perfectly as intended, however, it was not outputting any numerical counts, either with the current code (in OP) or the updated code. Does anyone have any suggestions?

Dave	11-11-2016 01:42 PM

It's not outputting anything because you don't fetch the results.
What you want to do is COUNT all DISTINCT records, example (untested):

PHP Code:


		
			
$resCNT = $vbulletin->db->query_first_slave("SELECT COUNT(DISTINCT userID) AS online FROM " . TABLE_PREFIX . "ajax_chat_online");   

$num_chatting = $resCNT['online'];

vB_Template::preRegister('navbar',array('num_chatting' => $num_chatting));

vB_Template::preRegister('FORUMHOME',array('num_chatting' => $num_chatting));

sixpackspeak

11-11-2016 02:33 PM

Thank you. That did it.

All times are GMT. The time now is 08:57 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02896 seconds Memory Usage 1,716KB 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 (1)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (3)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: