alpik

 
<?php
/******************************************************************************/
//                                                                            //
//                             InstantCMS v1.10                               //
//                        http://instantcms.ru/                           //
//                                                                            //
//                   written by InstantCMS Team, 2007-2012                    //
//                produced by InstantSoft, (www.instantsoft.ru)               //
//                                                                            //
//                        LICENSED BY GNU/GPL v2                              //
//                                                                            //
/******************************************************************************/
 
	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 7";        
    $result = $inDB->query($sql);
    $is_img = false;
    if ($inDB->num_rows($result)){
        $is_img = true;
        $qty = 7; //количество случайных фоток
           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 >
		<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}