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


<?php
defined('_VALID') or die('Restricted Access!');
function ajax_plugin_user_video_delete()
{
    $data = array('status' => 0, 'msg' => '', 'debug' => '');
    if (isset($_POST['video_id'])) {
        if (!VAuth::loggedin()) {
            $data['msg'] = 'Please login to delete videos!';
            return json_encode($data);
        }
        
        $delete        = VCfg::get('video.delete_enabled');
        if (empty($delete)) {
            $data['msg'] = 'You are not allowed to delete videos!';
            return json_encode($data);
        }
        
        $user_id    = (int) $_SESSION['user_id'];
        $video_id    = (int) trim($_POST['video_id']);
        
        $db         = VF::factory('database');
        $db->query("SELECT v.user_id, v.thumbs, v.server,
                           GROUP_CONCAT(c.cat_id) AS categories
                    FROM #__video AS v
                    LEFT JOIN #__video_category AS c ON (c.video_id = v.video_id)
                    WHERE v.video_id = ".$video_id."
                    AND v.user_id = ".$user_id."
                    AND v.status = 1
                    LIMIT 1");
        if ($db->affected_rows()) {
            $video        = $db->fetch_assoc();
            $method        = VCfg::get('video.delete_method');
            if ($method == 'delete') {
                VHelper::load('module.video.manage');
                VHelper_video_manage::delete($video_id);

                $data['msg']    = 'Video deleted!';
                $data['status']    = 1;
            } elseif ($method == 'suspend') {
                $db->query("UPDATE #__video
                            SET status = 0
                            WHERE video_id = ".$video_id."
                            LIMIT 1");
                $data['msg']     = 'Video deleted!';
                $data['status']    = 1;
            } elseif ($method == 'change') {
                $delete_username    = VF::cfg_item('module.video.delete_username');
                $db->query("SELECT user_id
                            FROM #__user
                            WHERE username = '".$db->escape($delete_username)."'
                            LIMIT 1");
                if ($db->affected_rows()) {
                    $new_user_id    = (int) $db->fetch_field('user_id');
                    $old_user_id    = (int) $video['user_id'];
                    
                    $db->query("UPDATE #__user_activity
                                SET total_videos = total_videos-1
                                WHERE user_id = ".$old_user_id."
                                LIMIT 1");
                    $db->query("UPDATE #__user_activity
                                SET total_videos = total_videos+1
                                WHERE user_id = ".$new_user_id."
                                LIMIT 1");
                    $db->query("UPDATE #__video
                                SET user_id = ".$new_user_id."
                                WHERE video_id = ".$video_id."
                                LIMIT 1");
                }
                
                $data['msg']    = 'Video deleted!';
                $data['status']    = 1;
            }
        } else {
            $data['msg'] = 'You are not allowed to delete this video!';
        }
    }
    
    return json_encode($data);
}