Случайное изображение

 
{if $is_img}
{foreach from=$item item=img}
	<div align="center">
		<a href="/photos/photo{$img.id}.html">
			<img src="/images/photos/small/{$img.file}" border="0" />
		</a>
	</div>
	{ if $cfg.showtitle}
		<div align="center"><a href="/photos/photo{$img.id}.html">{$img.title}</a></div>
	{/if}
{/foreach}
{/if}
 

 
function mod_random_image($module_id){
       $inCore = cmsCore::getInstance();
       $inDB = cmsDatabase::getInstance();
    $cfg = $inCore->loadModuleConfig($module_id);
       $catsql = '';
    if ($cfg['album_id'] != 0) {
        if ($cfg['subs']) {
            $rootcat = $inDB->get_fields('cms_photo_albums', 'id='.$cfg['album_id'], 'NSLeft, NSRight');
            $catsql = " AND a.NSLeft >= {$rootcat['NSLeft']} AND a.NSRight <= {$rootcat['NSRight']}";
    } else {
            $catsql = "AND f.album_id = ". $cfg['album_id'];
        }
    }
    $sql = "SELECT f.*, a.title album_title
            FROM cms_photo_files f
            LEFT JOIN cms_photo_albums a ON a.id = f.album_id
            WHERE f.published = 1 ".$catsql."
            ORDER BY RAND()
            LIMIT 3";        
    $result = $inDB->query($sql);
    $is_img = false;
    if ($inDB->num_rows($result)){
        $is_img = true;
        $qty = 3; //количество случайных фоток
           for ($j = 0; $j < $qty; ++$j){
                $items[] = $inDB->fetch_assoc($result);
           }
    }
    $smarty = $inCore->initSmarty('modules', 'mod_random_image.tpl');
    $smarty->assign('items', $items);
    $smarty->assign('is_img', $is_img);
    $smarty->assign('cfg', $cfg);
    $smarty->display('mod_random_image.tpl');
    return true;
}
 

 
{if $is_img}
{foreach from=$items item="item"}
	<div align="center">
		<a href="/photos/photo{$item.id}.html">
			<img src="/images/photos/small/{$item.file}" alt="{$item.title}" />
		</a>
	</div>
	{ if $cfg.showtitle}
		<div align="center"><a href="/photos/photo{$item.id}.html">{$item.title}</a></div>
	{/if}
{/foreach}
{/if}