Okay, the code to auto populate from jos_comprofiler works great.

Unfortonately, thanks to a silly glitch on Community Builder's part, email is one of the only data strings not stored in that table. So I'm looking for some help on modifying the code to pull from jos_comprofiler to pull from jos_user, the default Joomla login storage, which I am sure will be very helpful to many.

Here is what I have so far:

//<code>
$my = & JFactory::getUser();
$db = JFactory::getDBO(); $myid = $my->id;
if ($myid > 0)
{
$db->setQuery("SELECT `email` FROM `jos_users` WHERE `user_id`='".$myid."' LIMIT 1");
$result = $db->loadResult();
}
return $result;
//</code>


Where jos_users is the name of the table and 'email' is the name of the string in the table. So far, it doesn't work. Any suggestions?

Did you ever get this working? I have the same question.