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