oll

return (int)mysql_num_rows($result);

<?php
/*********************************************************************************************/
//																							 //
//                              InstantCMS v1.5   (c) 2009 FREEWARE                          //
//	 					  http://instantcms.ru/, info@instantcms.ru                      //
//                                                                                           //
// 						    written by Vladimir E. Obukhov, 2007-2009                        //
//                                                                                           //
/*********************************************************************************************/
 
	function mod_random_image($module_id){
        $inCore = cmsCore::getInstance();
        $inDB = cmsDatabase::getInstance();
		$cfg = $inCore->loadModuleConfig($module_id);
 
		if ($cfg['menuid']>0) {
			$menuid = $cfg['menuid'];
		} else {
			$menuid = $inCore->menuId();
		}
 
		if ($cfg['album_id']>0){
			$s = "AND f.album_id = ". $cfg['album_id'];			
		} else {
			$s = "";
		}
 
		$sql = "SELECT f.*, a.title album_title
				FROM cms_photo_files f, cms_photo_albums a
				WHERE f.album_id = a.id ".$s." AND f.published = 1
				ORDER BY RAND()
				LIMIT 1
				";
 
		$result = $inDB->query($sql) ;
 
		if ($inDB->num_rows($result)){
			while ($item=$inDB->fetch_assoc($result)){ 
                        $randimag[]=$item ;
 
 
				}
 
				  $smarty = $inCore->initSmarty('modules','mod_randimag.tpl');			
			$smarty->assign('item', $randimag);
                        $smarty->assign('menuid', $menuid);						
			$smarty->display('mod_randimag.tpl');
 
 
 
 
 
			}  
 
 
		return true;	
	}
?>

{foreach key=tid item=randimag from=$item}
 
			<div> 
 
 
			<a href="/photos/{$menuid}/photo{$randimag.id}.html "><p align="center" border="0"><img src="/images/photos/small/{$randimag.file}"><p align="center" border="0">{$randimag.title}</p></a> 
			</div>
 
 
{/foreach}  

<?php
/*********************************************************************************************/
//																							 //
//                              InstantCMS v1.5   (c) 2009 FREEWARE                          //
//	 					  http://instantcms.ru/, info@instantcms.ru                      //
//                                                                                           //
// 						    written by Vladimir E. Obukhov, 2007-2009                        //
//                                                                                           //
/*********************************************************************************************/
 
function mod_arhive($module_id){
        $inCore = cmsCore::getInstance();
        $inDB = cmsDatabase::getInstance();
 
		$cfg = $inCore->loadModuleConfig($module_id);
		if ($cfg['menuid']>0) {
			$menuid = $cfg['menuid'];
		} else {
			$menuid = $inCore->menuId();
		}
 
		$sql = "SELECT DATE_FORMAT( pubdate, '%M, %Y' ) fdate, DATE_FORMAT( pubdate, '%Y' ) year, DATE_FORMAT( pubdate, '%m' ) month, COUNT( id ) num
				FROM cms_content"."\n";
 
		if($cfg['cat_id']>0){
			$sql .= "WHERE category_id = ".$cfg['cat_id'];
			if ($cfg['source']!='both'){
				if ($cfg['source']=='arhive'){
					$sql .= " AND is_arhive = 1". "\n";
				} else {
					$sql .= " AND is_arhive = 0". "\n";
				}				
			} else {
				$sql .= "\n";
			}
		}
 
		$sql .= "GROUP BY DATE_FORMAT(pubdate, '%M, %Y')"."\n";
		$sql .= "ORDER BY pubdate DESC";
 
		$result = $inDB->query($sql) ;
 
		if ($inDB->num_rows($result)>0){		
			while ($item = $inDB->fetch_assoc($result)){
				$item['fdate'] = $inCore->getRusDate($item['fdate']);
 
 
                          $itemar[]=$item ;                    
 
			}
 
 
                        $smarty = $inCore->initSmarty('modules','mod_arhiv.tpl');			
			$smarty->assign('item', $itemar);						
			$smarty->display('mod_arhiv.tpl');  
 
 
		}
                 else { echo '<p>Нет материалов для отображения</p>'; }
		return true;
 
 
}
?>

{foreach key=tid item=itemar from=$item}
	               	<ul>		
			<div class="arhive_month"> 
			<li><a href="/arhive/{$menuid}/{$itemar.year}/{$itemar.month} ">{$itemar.fdate}({$itemar.num})</a></li>
			</div>
			</ul>  
 
{/foreach}