Count users threads from specific forum ID's

[kh99]

I meant it should look like:

$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]

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

[kh99]

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

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]

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

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'].":

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

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

in 3.7.4 version ?

[kh99]

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):

$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]

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]

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]

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]

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....

[kh99]

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

$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:

<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.