[bartek24m]

I need insert in member profile page (memberinfo_block_statistics)
MYSQL query (count threads from specific forums ID)



What query i should use in hook area ?
I search forum with similar problem but i only found this::

SELECT t.forumid = 1 AND t.forumid = 2 AND t.forumid = 3
FROM thread AS t
WHERE t.postuserid = X

Is it correct? What should be a right location for this hook?
What should i repleace X with to get stats for every single user ?


edit: i found also something like this:

PHP Code:

if (is_array($vbulletin->forumcache))
{
    foreach ($vbulletin->forumcache AS $forum)
    {
        $totalthreads += $forum['threadcount'];
        if ($forum['forumid'] == xx) $forumthreadcount = $forum['threadcount'];
    }
} 


i need copy it somewhere in member.php and place $forumthreadcount in memberinfo_block_statistics template
It does not work

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

anyone ?