vb.org Archive - Count users threads from specific forum ID's

Page 2 of 3

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

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

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

- - Count users threads from specific forum ID's (https://vborg.vbsupport.ru/showthread.php?t=233402)

kh99	02-11-2010 07:19 PM

I meant it should look like:

Code:

$count = $vbulletin->db->query_first("SELECT COUNT(*) AS count

                              FROM ".TABLE_PREFIX."thread 

                                WHERE postuserid = ".

                                    $vbulletin->userinfo['userid']."

                                    AND forumid IN(164, 165, 166)");

global $template_hook; 

$template_hook[profile_stats_threadcount] = $count['count'];

If that doesn't work I give up, someone else will have to help. :)

bartek24m

02-11-2010 07:31 PM

unfortunately it doesn't work :(
ok, thank you for you time.
i hope that somene else answer.

kh99	02-11-2010 07:48 PM

OK, I hate to give up, so I actually went to the test site and tried this (which I should have done from the start and saved us both time).

I made this plugin and used the hook member_profileblock_fetch_unwrapped

Code:

if ($this->template_name == 'memberinfo_block_statistics')

{

   global $vbulletin;



   $count = $vbulletin->db->query_first("SELECT COUNT(*) AS count

                              FROM ".TABLE_PREFIX."thread 

                                WHERE postuserid = ".

                                    $vbulletin->userinfo['userid']."

                                    AND forumid IN(164, 165, 166)");

}

Then in the template I just used $count[count]. This avoids the global variable problem because the hook is in the same place as the template eval.

Sorry I wasted your time before, this time I *really* quit :)

bartek24m

02-11-2010 08:31 PM

You are great man ! ;)
But i have still problem ...
It works perfect when I set specific number of postuserid like:

Code:

if ($this->template_name == 'memberinfo_block_statistics')

{

   global $vbulletin;



   $count = $vbulletin->db->query_first("SELECT COUNT(*) AS count

                              FROM thread 

                                WHERE postuserid = 1491

                                    AND forumid IN(164, 165, 166)");

}

and it doesn't when i use: ".$vbulletin->userinfo['userid'].":

Code:

if ($this->template_name == 'memberinfo_block_statistics')

{

   global $vbulletin;



   $count = $vbulletin->db->query_first("SELECT COUNT(*) AS count

                              FROM thread 

                                WHERE postuserid = ".$vbulletin->userinfo['userid']."

                                    AND forumid IN(164, 165, 166)");

}

instead of the number threads, the result of counting is always 0 :(

is there any another way to replace

Quote:

".$vbulletin->userinfo['userid']."

in 3.7.4 version ?

kh99	02-11-2010 09:03 PM

Oh, I wish it were true, but in fact that problem is probably why it didn't work before. I should have thought of making sure that it was right.

Anyway, here we go again :): I found this in class_profileblock.php (the same file where the hook is called):

Code:

$requirements = $this->registry->db->query_read_slave("

        SELECT blockid, requirement

        FROM " . TABLE_PREFIX . "profileblockprivacy

        WHERE userid = " . intval($this->profile->userinfo['userid']) . "

");

So maybe you can use intval($this->profile->userinfo['userid']).

bartek24m

02-11-2010 09:40 PM

YEAH ! it works !
Exactly what i want !

Thank you again mate without your help i cant solve the problem!

Give via PM you paypal account.

blind-eddie

06-20-2014 01:00 AM

I know this is an old thread Kevin but, I have edited this and edited this to get this to work on postbit_legacy with no luck.

I tried to get it to show (link) all threads by user in postbit_legacy but, only in select forum.

Any chance you could have a look at your code again and help me out?
I would really appreciate it.

Though, I have done a great deal of research before posting this request, I was not able to locate anything like this, so, if you or anyone that reads this know of an edit or addon that does what I am seeking please let me know...

Thank you for your time.... Tim

kh99	06-20-2014 07:53 AM

Wow, that's an old one. But I'm not sure what you're asking. The code above was only showing how many threads a user has in a certain set of forums. It sounds like you want links or something?

blind-eddie

06-20-2014 10:01 AM

I am looking to edit this to show how many threads a user has in a certain set of forums, but not in a profile tab, I want it to show on the postbit_legacy, below total post.
I want to allow members to be able to click the link similar to what is show below, but in the postbit_legacy template, not in a profile tab.
I am only going to show the link in the same forum that I want it to show all the threads a user made in those forums.
I think I said that right....

https://vborg.vbsupport.ru/external/2014/06/39.png

kh99	06-20-2014 10:24 AM

OK, I guess you could do something like this, at hook postbit_display_complete:

Code:

$forumids=array(1, 2, 3);

$show['threadcount'] = in_array($post['forumid'], $forumids);

if ($show['threadcount'])

{

   $threadcount = $vbulletin->db->query_first("SELECT COUNT(*) AS count

                              FROM ".TABLE_PREFIX."thread 

                                WHERE postuserid = ". $post['userid']." 

                                    AND forumid IN (" . implode(',', $forumids) . ");

   if ($threadcount === FALSE)

      $show['threadcount'] = false;

   else

      $threadcount = $threadcount['count'];

}

and then in the postbit_legacy template, something like:

Code:

<if condition="$show['threadcount']">

Threads: $threadcount<br />

</if>

I see you said that you want it to be a link, but I don't know what you want it to link to. But you can probably change the html above to be a link.

I should also point out that adds a query for each postbit displayed. If you're concerned about that, you could add a column to the user table and adjust the count whenever a thread is created or deleted, but of course that takes more work and probably a few more plugins. You could also keep and array for users that you've already done the query for, so if for instance the same user posts 5 times on a page, you'd only be doing it once.

All times are GMT. The time now is 04:40 PM.

Page 2 of 3

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02668 seconds Memory Usage 1,749KB 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 (7)bbcode_code_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: