[Lynne]

Here's the article on how to add the tabs - [How-to] Add more tabs to the vB 3.7 profile pages The basic query would be something along the lines of (this doesn't take into account any permissions):

PHP Code:

$myid=$this->profile->userinfo['userid']; 
$getthreads = $vbulletin->db->query_read(" 
                SELECT threadid,title,dateline,forumid 
                FROM " . TABLE_PREFIX ."thread 
                WHERE postuserid = '$myid' AND forumid IN ('x','y','z') 
                ORDER BY dateline DESC 
                LIMIT aa 
        "); 


If you need someone to write the whole thing for you, you'll need to post in the Request for Mods (Unpaid) or Paid Requests.