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


<?php
defined('_VALID') or die('Restricted Access!');
class VComponent_user_playlists extends VModule_user
{
    public function __construct()
    {
        parent::__construct();
    }

    public function render()
    {
        VAuth::check('Registered');
        
        VLanguage::load('frontend.video');

        $user_id            = (int) $_SESSION['user_id'];
        $page               = (isset($_GET['page'])) ? (int) $_GET['page'] : 1;
        
        $sql_count            = "SELECT COUNT(*) AS total_playlists
                               FROM #__playlist
                               WHERE user_id = ".$user_id;
        $total_playlists    = $this->db->get_field($sql_count, 'total_playlists');
        $pagination            = VPagination::get($page, $total_playlists, 10);
        $sql                = "SELECT p.playlist_id, p.user_id, p.name, p.type, p.slug, p.likes, p.rated_by,
                                      p.total_videos, p.duration, p.thumb_id, v.thumb, v.slug as vslug
                               FROM #__playlist AS p
                               LEFT JOIN #__video AS v ON (v.video_id = p.thumb_id AND v.status = 1)
                               WHERE p.user_id = ".$user_id."
                               ORDER BY p.playlist_id DESC
                               LIMIT ".$pagination['limit'];
        $playlists            = $this->db->get_rows($sql);
                             
        $this->tpl->menu        = 'community';
        $this->tpl->colmenu     = 'manage';
        $this->tpl->submenu     = 'user-playlists';

        $this->tpl->title       = e(__('my-playlists'));
        $this->tpl->meta_title  = __('my-playlists');
        
        $this->tpl->playlists        = $playlists;
        $this->tpl->pagination        = $pagination;
        
        $this->tpl->load(array('header', 'user_playlists', 'footer'));
        $this->tpl->display();
    }
}