I am writing a custom code to call up dolphin 7 user profile avater url
Can someone save me some time by directing me to where dolphin 7 stores avaters
here is the custom code below...
function getDolphinAvatar($userid) {
//get the connection to the db
//query db
$db->setQuery('SELECT 'Avatar' FROM #__Profiles WHERE 'ID' = ' . (int)$userid);
$avatar_id = $db->loadResult();
$db->setQuery('SELECT 'Uri' FROM #__bx_photos_main WHERE Owner = ' . (int)$avatar_id);
$avatar = $db->loadResult();
$url = base_path . modules/?r=avatar. $avatar;
return $url;
}