[kh99]

Well, you could try something like this:

$result = $vbulletin->db->query_slave("SELECT subscribeforum.forumid, forum.title FROM " . TABLE_PREFIX . "subscribeforum AS subscribeforum
LEFT JOIN " . TABLE_PREFIX . "forum AS forum ON (forum.forumid = subscribeforum.forumid)
WHERE userid = " . $vbulletin->userinfo['userid']);

while ($subscribed_forum = $vbulletin->db->fetch_array($result))
{
    $subscribed_forums .= '<a href="forumdisplay.php?f=' . $subscribed_forum['forumid'] . '">' . $subscribed_forum['title'] . '</a><br />';
}

I tried the query and I think it's correct, but I didn't test the code at all.