Просмотр архива Акул сайт


<?php
defined('_VALID') or die('Restricted Access!');
class VComponent_user_albums extends VModule_user
{
    public function __construct()
    {
        parent::__construct();
    }
    
    public function render()
    {
        if (!VModule::enabled('photo')) {
            VModule::load('404', TRUE);
        }
    
        VAuth::check('Registered');
    
        $this->db         = VF::factory('database');
        $user_id    = (int) $_SESSION['user_id'];
        $page        = (isset($_GET['page'])) ? (int) $_GET['page'] : 1;
        
        $sql_count        = "SELECT COUNT(*) AS total_albums
                             FROM #__photo_albums
                           WHERE user_id = ".$user_id;
        $total_albums    = $this->db->get_field($sql_count, 'total_albums');
        $pagination        = VPagination::get($page, $total_albums, 20);
        $sql            = "SELECT a.album_id, a.title, a.slug, a.total_views, a.rating, 
                                  a.rated_by, a.total_photos, a.add_time, a.likes, a.type
                           FROM #__photo_albums AS a
                           WHERE a.user_id = ".$user_id."
                           AND a.status = '1'
                           ORDER BY a.album_id DESC
                           LIMIT ".$pagination['limit'];
        $albums            = $this->db->get_rows($sql);
        
        $this->tpl->menu        = 'home';
        $this->tpl->colmenu        = 'manage';
        $this->tpl->submenu        = 'user-albums';

        $this->tpl->title        = __('my-albums');
        $this->tpl->meta_title    = __('my-albums');

        $this->tpl->css            = array(TPL_REL.'/css/style_photo.css');

        $this->tpl->albums        = $albums;
        $this->tpl->pagination    = $pagination;
        
        $this->tpl->load(array('header', 'user_albums', 'footer'));
        $this->tpl->display();
    }
}