Аватар в общей фотогалерее

 
/////////////////////////////// VIEW PHOTO //////////////////////////////////
if($do=='viewphoto'){
 

 
	$sql = "SELECT f.id, f.album_id, f.title, f.description, f.pubdate, f.file, f.published, f.hits, f.comments, f.user_id,
			a.id cat_id, a.NSLeft as NSLeft, a.NSRight as NSRight, a.NSDiffer as NSDiffer, a.user_id as album_user_id, a.title cat_title, a.nav album_nav, a.public public, a.showtype a_type, a.showtags a_tags, a.bbcode a_bbcode, u.nickname, u.login, u.is_deleted as author_deleted, p.gender, p.imageurl as author_image,
			IFNULL(r.total_rating, 0) as rating
			FROM cms_photo_files f
			LEFT JOIN cms_photo_albums a ON a.id = f.album_id
			LEFT JOIN cms_ratings_total r ON r.item_id = f.id AND r.target = 'photo'
			INNER JOIN cms_users u ON u.id = f.user_id
			INNER JOIN cms_user_profiles p ON p.user_id = u.id
			WHERE f.id = '$id'";
 

 
$smarty = $inCore->initSmarty('components', 'com_photos_view_photo.tpl');
 

 
	$inCore->includeFile("components/users/includes/usercore.php");
	$photo['author_image'] = usrImageNOdb($photo['user_id'], 'small', $photo['author_image'], $photo['author_deleted']);
 

 
{$photo.author_image}