Страница со всеми фотографиями пользователей?

 
        $routes[] = array(
                            '_uri'  => '/^users\/photoalbum.html$/i',
                            'do'    => 'ualbum'
 
                         );
 
 

 
////////////вывод альбомов всех пользователей/////////////////
if ($do=='ualbum'){
 
$albums = $model->getAlbum();
 
            $smarty = $inCore->initSmarty('components', 'com_users_album.tpl');
            $smarty->assign('albums', $albums);
 
            $smarty->display('com_users_album.tpl');
 
}
 

 
public function getAlbum() {
        $albums     = array();
 $sql = "SELECT a.id as id,
                       a.title as title,
                       a.user_id,
                       a.pubdate as pubdate,
                       a.allow_who as allow_who,
                       'private' as type,
                       p.imageurl as imageurl,
 
                       COUNT(p.id) as photos_count,
                       n.nickname as autor,
                       n.login as log
                FROM cms_user_albums a
                LEFT JOIN cms_users n on n.id = a.user_id
				LEFT JOIN cms_user_photos p ON p.album_id = a.id
                GROUP BY a.id
                ";
        $result = $this->inDB->query($sql);
 
        if ($this->inDB->num_rows($result)) { 
            while($album = $this->inDB->fetch_assoc($result)){
                $album['imageurl'] = "/images/users/photos/small/{$album['imageurl']}";
                $album['pubdate']  = cmsCore::dateFormat($album['pubdate']);
                $albums[] = $album;
            }
        }
$albums = cmsCore::callEvent('GET_USER_ALBUMS', $albums);
 
        return $albums;
 
 
}
 
 
 

 
{if $albums}
 
    <div class="usr_albums_block" style="margin-top:30px">
        <ul class="usr_albums_list">
            {foreach key=key item=album from=$albums}
                <li>
                    <div class="usr_album_thumb">
                        <a href="/users/{$album.log}/photos/{$album.type}{$album.id}.html" title="{$album.title|escape:'html'}">
                            <img src="{$album.imageurl}" width="64" height="64" border="0" alt="{$album.title|escape:'html'}" />
                        </a>
                    </div>
                    <div class="usr_album">
                        <div class="link">
                            <a href="/users/{$album.log}/photos/{$album.type}{$album.id}.html">{$album.title}</a>
                        </div>
                        <div class="count">{$album.photos_count|spellcount:$LANG.PHOTO:$LANG.PHOTO2:$LANG.PHOTO10}</div>
                        <div class="date">{$album.pubdate}</div>
                        <div class="date"><b>автор:</b>{$album.autor}</div>
 
                    </div>
                </li>
            {/foreach}
         </ul>
         <div class="blog_desc"></div>
    </div>
 
{else}
    <p>{$LANG.NOT_PHOTOS}</p>
{/if}
 

 
//Делим на страницы
    $total      = sizeof($albums);
 
    if ($total){
         $perpage = 10;
//вместо 10 ставим нужное количество
        $page           = $inCore->request('page', 'int', 1);
        $pagination     = cmsPage::getPagebar($total, $page, $perpage, '/users/photoalbumpage-%page%');
 
        $page_albums    = array();
        $start          = $perpage*($page-1);
        for($p=$start; $p<$start+$perpage; $p++){
            if ($albums[$p]){
                $page_albums[] = $albums[$p];
            }
        }
        $albums = $page_albums; unset($page_albums);
    }
 
 
 

 
 $routes[] = array(
                            '_uri'  => '/^users\/photoalbumpage-([0-9]+)$/i',
                            'do'    => 'ualbum',
                            1       => 'page'
                         );