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


<?php
defined('_VALID') or die('Restricted Access!');
function ajax_plugin_rate()
{
    $data = array('status' => 0, 'code' => '', 'msg' => '', 'debug' => '');
    $mcfg = VF::cfg('module.mobile');
    
    VLanguage::load('frontend.mobile');
    if ($mcfg['allow_rating'] != '1') {
        $data['msg'] = __('rating-disabled');
        return json_encode($data);
    }
    
    if (isset($_POST['rating']) && isset($_POST['video_id'])) {
        $user_id = (VAuth::loggedin()) ? (int) $_SESSION['user_id'] : 0;
        if ($mcfg['rating_type'] == 'user' && !$user_id) {
            $data['msg'] = __('rating-login');
            return json_encode($data);
        }
    
        $video_id    = (int) trim($_POST['video_id']);
        $vote        = (float) trim($_POST['rating']);
        $ip            = VServer::ip(TRUE);
        
        $db            = VF::factory('database');
        if ($mcfg['rating_count'] == '1') {
            if ($mcfg['rating_type'] == 'user') {
                $sql = "SELECT rating_id
                        FROM #__video_rating
                        WHERE video_id = ".$video_id."
                        AND voter_id = ".$user_id."
                        LIMIT 1";
            } else {
                $sql = "SELECT rating_id
                        FROM #__video_rating
                        WHERE video_id = ".$video_id."
                        AND voter_ip = ".$ip."
                        LIMIT 1";
            }
        
            $db->query($sql);
            if ($db->affected_rows()) {
                $data['msg'] = __('rating-already');
                return json_encode($data);
            }
        }
        
        $db->query("SELECT rating, rated_by
                    FROM #__video
                    WHERE video_id = ".$video_id."
                    LIMIT 1");
        if ($db->affected_rows()) {
            $rating        = (float) $db->fetch_field('rating');
            $rated_by    = (int) $db->fetch_field('rated_by');
            $value      = round($rating*$rated_by, 2);
            $rating     = $value+$vote;
            $rated_by   = $rated_by+1;
            $rating     = round($rating/$rated_by, 2);
            $db->query("UPDATE #__video
                        SET rating = ".$rating.",
                            rated_by = ".$rated_by."
                        WHERE video_id = ".$video_id."
                        LIMIT 1");
            $db->query("INSERT INTO #__video_rating
                        SET video_id = ".$video_id.",
                            voter_id = ".$user_id.",
                            voter_ip = ".$ip.",
                            rating = ".$vote.",
                            add_date = '".date('Y-m-d h:i:s')."'");
                            $data['status'] = 1;
            VF::factory('cache')->remove('video_'.$video_id);
            
            $data['status']    = 1;
            $data['code']    = '<strong>'.round(($rating*100)/5).'%</strong>';
            $data['msg']    = __('rating-success');
        } else {
            $data['msg'] = __('video-invalid');;
        }
    } else {
        $data['msg']    = 'Invalid request!';
    }
    
    return json_encode($data);
}
?>