• Mike •

 
function clubMembersListWithAvatar($club_id){
	    $inCore     = cmsCore::getInstance();
	    $inDB       = cmsDatabase::getInstance();
	    $inPage     = cmsPage::getInstance();
 
	    $sql = "SELECT u.id as id, u.nickname as nickname, u.login as login, p.imageurl as imageurl
	            FROM cms_user_clubs c
	            LEFT JOIN cms_users u ON u.id = c.user_id
	            LEFT JOIN cms_user_profiles p ON p.user_id = u.id
	            WHERE c.club_id = '$club_id' AND c.role = 'member'";
 
	    $rs     = $inDB->query($sql);
	    $total  = $inDB->num_rows($rs);
 
 
	    $now=0;
        if ($total > 10) {
        $html = '<div id="all_user_list" style="width: 190px; height: 570px; overflow-y:auto; overflow-x: hidden;">';
        }
        if ($total <= 10) {
        $html = '<div id="all_user_list" style="width: 190px;">';
        }
	    while($usr = $inDB->fetch_assoc($rs)){
	        if (!function_exists('usrImageNOdb')){
	        include_once($_SERVER['DOCUMENT_ROOT'].'/components/users/includes/usercore.php');
	        }
	        $usrimage = usrImageNOdb($usr['id'], 'small', $usr['imageurl'], $usr['is_deleted']);
 
	        $html .= '<div class="avatar" style="float:left;width:78px;height:100px;text-align:center;padding-left:2px;padding-bottom:5px;margin:4px auto;">'. $usrimage.'<a href="/users/'.$usr['login'].'" class="none" style="width:76px;float:left;line-height:9px;margin-top:4px;margin-bottom:6px;">'.$usr['nickname'].'</a></div>';
 
	        $now ++;
	    }
	    $html .= '</div></div><div style="clear:both"></div>';
 
	    return $html;
	}
 

 
$con_text = $con['con_text'];
if (strstr($con_text, '[cut')){
    $con_text = $model->getPostShort($con_text, $con['href']);
}
$con['con_text'] = $con_text;
 
$con_web = $con['con_web'];
if (strstr($con_web, '[cut')){
   $con_web = $model->getPostShort($con_web, $con['href']);
}
$con['con_web'] = $con_web;
 

 
$con['con_text'] = $con['con_text'];
$con['con_web'] = $con['con_web'];
 

 
$con_text = $con['con_text'];
if (strstr($con_text, '[cut')){
   $con_text = $model->getPostShort($con_text, $post['url']);
}
$con['con_text'] = $con_text;
 
$con_web = $con['con_web'];
if (strstr($con_web, '[cut')){
   $con_web = $model->getPostShort($con_web, $post['url']);
}
$con['con_web'] = $con_web;
 

 
<span class="members"><strong>{assign var="club_total" value =`$club.moders+$club.members`}{$club_total|spellcount:$LANG.USER:$LANG.USER2:$LANG.USER10}</strong></span>
 

 
function clubTotalMembers($club_id){
    $inDB = cmsDatabase::getInstance();
	if (!$club_id) { exit; }
	$members = array();
	$sql = "SELECT 1
			FROM cms_user_clubs c
			WHERE c.club_id = '$club_id' AND c.role = 'member'";
	$rs = $inDB->query($sql);
	if ($inDB->num_rows($rs)){
		return $inDB->num_rows($rs) +1; //+1 потому что считаем еще и админа, не только юзеров
	} else {
		return 1;
	}
}
 

 
function clubTotalModers($club_id){
    $inDB = cmsDatabase::getInstance();
	if (!$club_id) { exit; }
	$members = array();
	$sql = "SELECT 1
			FROM cms_user_clubs c
			WHERE c.club_id = '$club_id' AND c.role = 'moderator'";
	$rs = $inDB->query($sql);
	if ($inDB->num_rows($rs)){
		return $inDB->num_rows($rs);
    }
}
 

 
{if $club.moders > 0}
    <div class="members_list">
	<div class="title">{$LANG.MODERATORS} ({$club.moders}):</div>
	<div class="list">{$club.moders_list}</div>
    </div>
{/if}
 

 
<span class="members"><strong>{$club.members|spellcount:$LANG.USER:$LANG.USER2:$LANG.USER10}</strong></span>
 

 
<span class="members"><strong>{$club.moders + $club.members|spellcount:$LANG.USER:$LANG.USER2:$LANG.USER10}</strong></span>