Azura

		$sql = "SELECT con.*,
                       con.pubdate as fdate,
                       u.nickname as author,
                       u.login as author_login
                       FROM cms_content con
				       LEFT JOIN cms_category cat ON cat.id = con.category_id
				       LEFT JOIN cms_users u ON u.id = con.user_id
                       WHERE con.published = 1 AND con.showlatest = 1 AND con.is_arhive = 0 AND con.pubdate <= '$today'
                      AND (con.is_end=0 OR (con.is_end=1 AND con.enddate >= '$today'))
                      ".$catsql."
				ORDER BY con.pubdate DESC
				LIMIT ".$cfg['newscount'];
 
		$result = $inDB->query($sql);
 
		$is_con = false;
 
		if ($cfg['is_pag']) {
			// Считаем общее количество материалов если опция пагинация включена
			$sql_total = "SELECT 1
					FROM cms_content con
					LEFT JOIN cms_category cat ON cat.id = con.category_id
					WHERE con.published = 1 AND con.showlatest = 1 AND con.is_arhive = 0 AND con.pubdate <= '$today' AND (con.is_end=0 OR (con.is_end=1 AND con.enddate >= '$today')) ".$catsql."";
			$result_total = $inDB->query($sql_total) ;
			$total_page = $inDB->num_rows($result_total);
		}
 
		if ($inDB->num_rows($result)){
 
			$is_con = true;
 
            $inCore->loadModel('content');
            $model = new cms_model_content();
 
			$articles = array();					
			while($con = $inDB->fetch_assoc($result)){
				$next = sizeof($articles);				
				$articles[$next]['id']          = $con['id'];
				$articles[$next]['title']       = $con['title'];
				$articles[$next]['hits']        = $con['hits'];
				$articles[$next]['href']        = $model->getArticleURL(null, $con['seolink']);
				$articles[$next]['author']      = $con['author'];
				$articles[$next]['authorhref']  = cmsUser::getProfileURL($con['author_login']);
				$articles[$next]['comments']    = $cfg['showcom'] ? $inCore->getCommentsCount('article', $con['id']) : false;
				$articles[$next]['date']        = $inCore->dateformat($con['fdate']);
				$articles[$next]['description'] = $con['description'];
                $articles[$next]['image']       = (file_exists(PATH.'/images/photos/small/article'.$con['id'].'.jpg') ? 'article'.$con['id'].'.jpg' : '');                
			}
 
		}

$sql = "SELECT f.*, 
				a.id as album_id, 
				a.title as album
				u.nickname as author,
                                u.login as author_login
				FROM cms_photo_files f
				LEFT JOIN cms_photo_albums a ON a.id = f.album_id
				LEFT JOIN cms_users u ON u.id = con.user_id
				WHERE f.published = 1 ".$catsql."
				ORDER BY f.id DESC
				LIMIT ".$cfg['shownum'];		
 
		$result = $inDB->query($sql);
		$is_photo = false;	
 
		if ($inDB->num_rows($result)){	
			$photos = array();			
			$is_photo = true;	
 
			while($con = $inDB->fetch_assoc($result)){
				if ($cfg['showtype']=='full'){
						if($cfg['showcom'] || $cfg['showdate']){
								if ($cfg['showdate']){
									$con['fpubdate'] = $inCore->dateFormat($con['pubdate']);
								}
								if ($cfg['showcom']){
									$con['comments'] = $inCore->getCommentsCount('photo', $con['id']);
								}
						}
				}
				$photos[] = $con;	
			}			
			}

u.nickname as author,
u.login as author_login
LEFT JOIN cms_users u ON u.id = con.user_id

if ($cfg['user_id']){
									$con['authorhref'] = cmsUser::getProfileURL($con['author_login']);