vb.org Archive - Count number of search results

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

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

- - Count number of search results (https://vborg.vbsupport.ru/showthread.php?t=329178)

Count number of search results

Hi is there a way for me to be about to count the number of search results returned from a searchJSON to pass into a variable that I can display to users.

I'm trying to do this as a way to display post counts each user has in a specific topic and this is where I am stuck.

Any help would be amazing.

Code:

<a href="{vb:url 'search'}?searchJSON=%7B%22author%22:%22{vb:raw conversation.authorname}%22,%22exactname%22:%221%22,%22channel%22:[{vb:raw conversation.nodeid}]%7D">[ISO {vb:raw conversation.authorname}]</a>

<vb:else />

<a href="{vb:url 'search'}?searchJSON=%7B%22author%22:%22{vb:raw conversation.authorname}%22,%22exactname%22:%221%22,%22channel%22:[{vb:raw conversation.parentid}]%7D">[ISO {vb:raw conversation.authorname}]</a>

</vb:if>

So far I have been able to generate the search to pull every post a user has in a specific topic in this snippet.

Im not good with json, or vb4 for that matter, but I literally JUST finished making a product that one of the features is grabbing the count of post a user has made in a thread. So if its of any help, or gets you in the right direction take a look at this product for vb4 that is able to pull post count of a user in a thread (its what i just used as my vb3 base). hopefully it will help.

https://vborg.vbsupport.ru/showthread.php?t=285293

Thanks, unfortunatly with vb5 they got rid of some of the critical pieces that made the old way this was done. One of them being in the admincp/misc.php as well as changing what a "thread" is and restructuring the forum so that its easier to store in the database without bogging it down.

https://vbulletin.org/forum/showthread.php?t=328571

Thats why I'm trying to find different ways to go about solving this. I appreciate the quick response tho.

--------------- Added [DATE]1647223560[/DATE] at [TIME]1647223560[/TIME] ---------------

Owell you have inspired me tho I do need to get out of my comfort zone and try another strategy and get into building something more significant.

Code:

{class TalonThreadPostCount_dB_MYSQL_QueryDefs extends vB_dB_QueryDefs

{



        protected $db_type = 'MYSQL';

        protected static $permission_string = false;        

        protected $query_data = array

        (

                'getUserThreadPostCount' => array(

                        vB_dB_Query::QUERYTYPE_KEY => vB_dB_Query::QUERY_SELECT,

            'query_string' => "

              SELECT COUNT from {TABLE_PREFIX}node 

                                Where userid = {userid} AND parentid = {parentid}

                          "

                ),



                );

    

}

This should do the same thing essentially just gotta build off it

I would do that directly in a new template and do a search via the API search, getInitialResults.
Then you get an array containing all the required values. Also the number of posts.

Just look at the templates for an example:
widget_blognodes
widget_search_results

..and use debugvardump to get dump of the array.

Edit: Your query is not taking care of any permission or closed status. The search will ...

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 (2)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (4)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:

Phrase Groups Available:

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