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


<?php
defined('_VALID') or die('Restricted Access!');
class VComponent_Admin_video_ratings
{
    private $db;
    public function __construct()
    {
        $this->db        = &VF::factory('database');
    }
    
    public function render()
    {
        $tpl        = VF::factory('template');
        
        $errors        = array();
        $messages    = array();
        $comments    = array();
        $video_id     = (isset($_GET['id']) && is_numeric($_GET['id'])) ? (int) $_GET['id'] : 0;
        $page        = (isset($_GET['page']) && is_numeric($_GET['page'])) ? (int) $_GET['page'] : 0;
        
        if (isset($_POST['submit_reset'])) {
            if (isset($_SESSION['search_vratings_options'])) {
                unset($_SESSION['search_vratings_options']);
            }
        }
        
        if (isset($_SESSION['search_vratings_options'])) {
            $this->coption = $_SESSION['search_vratings_options'];
        }
        
        $this->db->query("SELECT rating FROM #__video WHERE video_id = ".$video_id." LIMIT 1");
        if ($this->db->affected_rows()) {
            $sql_count            = "SELECT COUNT(*) AS total_ratings
                                   FROM #__video_rating AS r
                                   WHERE r.video_id = ".$video_id;
            $ratings_total        = $this->db->get_field($sql_count, 'total_ratings');
            $pagination            = VPagination::get($page, $ratings_total, 10);
            $sql                = "SELECT r.*, u.username
                                   FROM #__video_rating AS r
                                   LEFT JOIN #__user AS u ON u.user_id = r.voter_id
                                   WHERE r.video_id = ".$video_id."
                                   ORDER BY r.add_date DESC
                                   LIMIT ".$pagination['limit'];
            $ratings            = $this->db->get_rows($sql);
            $tpl->pagination     = $pagination;
        }
    
        $tpl->menu                = 'video';
        $tpl->submenu            = 'video_ratings';
        $tpl->meta_title        = 'Admin::Video::View::Ratings';
        $tpl->vcfg                = VF::cfg('module.video');
        $tpl->errors            = $errors;
        $tpl->messages            = $messages;
        $tpl->video_id            = $video_id;
        $tpl->ratings            = $ratings;
        $tpl->load(array('header', 'video_ratings', 'footer'));
        $tpl->display();
    }    
}
?>