Шапки блогов (хак)

function getAvatar($auth){
	$sql = "SELECT imageurl FROM cms_user_profiles WHERE user_id='$auth' LIMIT 1";
	$result = $this->inDB->query($sql);
	$author = $this->inDB->fetch_assoc($result);
	$avatar ='/images/users/avatars/nopic.jpg';
	if(!empty($author[imageurl])){
	if(file_exists('images/users/avatars/'.$author[imageurl])){
	$avatar='/images/users/avatars/'.$author[imageurl];
    	}
    }
    return "<img style='max-width:150px; max-height:150px' src='$avatar' />";
}
function getAvatarClub($club_id){
	$sql = "SELECT imageurl FROM cms_clubs WHERE id='$club_id' LIMIT 1";
	$result = $this->inDB->query($sql);
	$author = $this->inDB->fetch_assoc($result);
 	$avatar ='';
	if(!empty($author[imageurl])){
  		if(file_exists('images/clubs/'.$author[imageurl])){
              $avatar='/images/clubs/'.$author[imageurl];
    	}
    }
    return "<img style='max-width:150px; max-height:150px' src='$avatar' />";;
}
function getClubMember($club_id){
	if (!$club_id) { exit; }
	$members = array();
	$sql = "SELECT c.user_id
			FROM cms_user_clubs c
			WHERE c.club_id = '$club_id' AND c.role = 'member'";
	$result = $this->inDB->query($sql);
	return $this->inDB->num_rows($result);
}
function getDeco($id,$owner){
	if ($owner=='user'){$ur= $id;}
	else {$sql = "SELECT admin_id
				FROM cms_clubs
				WHERE id='$id' LIMIT 1";
		$result = $this->inDB->query($sql);
		$idmin=$this->inDB->fetch_assoc($result);
	    $ur= $idmin['admin_id'];
    }
    $sql = "SELECT user_id
			FROM cms_user_awards
			WHERE user_id='$ur' AND title='Золотое перо'";
    $result = $this->inDB->query($sql);
	$award= $this->inDB->num_rows($result);
	$deco['head']=$deco['foot']='/templates/_default_/images/bg.jpg';
	if ($award){
		$lin='upload/userfiles/'.$ur.'/bloghead.jpg';
		if(file_exists($lin)){$deco['head']='/'.$lin;}
		$lin='upload/userfiles/'.$ur.'/blogfoot.jpg';
		if(file_exists($lin)){$deco['foot']='/'.$lin;}
		else {$deco['foot']=$deco['head'];}
	}
	return $deco;
}
function getPostsRating($blog_id){
	$sql = "SELECT SUM(r.total_rating) AS rating, SUM(r.total_votes) AS votes
			FROM cms_ratings_total r
			LEFT JOIN cms_blog_posts p ON p.id = r.item_id
            WHERE p.blog_id = $blog_id AND r.target = 'blogpost'";
    $result = $this->inDB->query($sql);
    $post = $this->inDB->num_rows($result) ? $this->inDB->fetch_assoc($result) : false;
    return $post;
}

if ($do=='blog'){

if($owner=='user'){

$avatar=$model->getAvatar($blog['user_id']);

if ($owner=='club'){

$ClubMember=   $model->getClubMember($blog['user_id'])+1;
$avatar=$model->getAvatarClub($blog['user_id']);
 

$smarty->assign('myblog', $myblog);

$ratings=$model->getPostsRating($blog['id']);
$deco=$model->getDeco($blog['user_id'],$owner); 	
$smarty->assign('deco', $deco);
$smarty->assign('clubmembers', $ClubMember);
$smarty->assign('ratings', $ratings);
$smarty->assign('avatar', $avatar);
 

if($do=='post'){

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

$avatar=$model->getAvatar($post['author_id']);
$deco=$model->getDeco($blog['user_id'],$owner);
$smarty->assign('deco', $deco);
$smarty->assign('avatar', $avatar);