• 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'"; 
 
	    $rs     = $inDB->query($sql); 
	    $total  = $inDB->num_rows($rs); 
 
	    $now=0; $html = '<div id="all_user_list" style="width: 190px; height: 466px; overflow-y:auto; overflow-x: hidden;">';
 
	    while($usr = $inDB->fetch_assoc($rs)){ 
	        if (!function_exists('usrImageNOdb')){ //if not included earlier
	        include_once($_SERVER['DOCUMENT_ROOT'].'/components/users/includes/usercore.php'); 
	        } 
	        $usrimage = usrImageNOdb($usr['id'], 'small', $usr['imageurl'], $usr['is_deleted']);
 
	        $html .= '<div style="float:left; width:70px; height: 88px; text-align:center; padding-left:2px; margin: 2px auto;"><a href="/users/'.$usr['login'].'" class="nn" styles="display:block; float:left;">'. $usrimage.'<p class="user_nick" style="Line-height: 10px; height: 28px; width: 60px; margin: 2px auto;">'.$usr['nickname'].'</p></a></div>';
 
	        $now ++;
	    } 
	    $html .= '</div></div><div style="clear:both"></div>';
 
	    return $html;
	}
 

 
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'";
 
    $rs     = $inDB->query($sql);
    $total  = $inDB->num_rows($rs);
 
    $inPage->addHeadJS('templates/_default_/js/smartpaginator.js');
    $inPage->addHeadJS('templates/_default_/js/pager_init.js');
 
    $inPage->addHeadCSS('templates/_default_/css/smartpaginator.css');
 
    $now=0; $html = '<div id="all_user_list">';
 
    while($usr = $inDB->fetch_assoc($rs)){
        if (!function_exists('usrImageNOdb')){ //if not included earlier
        include_once($_SERVER['DOCUMENT_ROOT'].'/components/users/includes/usercore.php');
        }
        $usrimage = usrImageNOdb($usr['id'], 'small', $usr['imageurl']);
 
        $html .= '<div style="float:left; width:70px; align:left; padding:5px; margin: 5px;">'. $usrimage.'<a href="/users/'.$usr['login'].'" class="nickname" ><p class="user_nick" style="line-height: 16px; width: 60px;">'.$usr['nickname'].'</p></a></div>';
 
        $now ++;
    }
    $html .= '</div> </div><div style="clear:both"></div><div id="black" style="margin: auto;"> ';
 
    return $html;
}