Вход Регистрация
Файл: adultscript-2.0.3-pro/files/mobile/templates/default/extend/ajax/photo_favorite.plugin.php
Строк: 26
<?php
defined
('_VALID') or die('Restricted Access!');
function 
ajax_plugin_photo_favorite()
{
    
$data = array('status' => 0'msg' => '');
    if (isset(
$_POST['photo_id'])) {
        if (
VAuth::loggedin()) {
            
$photo_id    = (int) trim($_POST['photo_id']);
            
$user_id    = (int) $_SESSION['user_id'];
            
            
$db VF::factory('database');
            
$db->query("SELECT a.user_id, p.total_favorites
                        FROM #__photo AS p
                        INNER JOIN #__photo_albums AS a ON (a.album_id = p.album_id)
                        WHERE p.photo_id = "
.$photo_id."
                        LIMIT 1"
);
            if (
$db->affected_rows()) {
                
VLanguage::load('frontend.photo');
            
                
$owner_id     = (int) $db->fetch_field('user_id');
                
$total        = (int) $db->fetch_field('total_favorites');
                if (
$owner_id !== $user_id) {
                    
$db->query("SELECT photo_id
                                FROM #__photo_favorites
                                WHERE photo_id = "
.$photo_id."
                                AND user_id = "
.$user_id."
                                LIMIT 1"
);
                    if (
$db->affected_rows()) {
                        
$data['msg'] = 'You already favorited this photo!';
                    } else {
                        
$db->query("UPDATE #__photo
                                    SET total_favorites = total_favorites+1
                                    WHERE photo_id = "
.$photo_id."
                                    LIMIT 1"
);
                        
$db->query("INSERT INTO #__photo_favorites
                                    SET photo_id = "
.$photo_id.",
                                        user_id = "
.$user_id);
                        if (
$db->affected_rows()) {
                            
$data['status'] = 1;
                            
$data['code']    = $total+1;
                            
$data['msg']     = __('favorite-success', array('<a href="'.BASE_URL.'/user/photos/">''</a>'));
                        } else {
                            throw new 
VException('Application Error! Aborting...');
                        }
                    }
                } else {
                    
$data['msg'] = __('favorite-own');
                }
            } else {
                
$data['msg'] = 'Invalid photo! Are you sure this photo exists!?';
            }
        } else {
            
$data['msg'] = 'Please login to favorite photos!';
        }
    } else {
        
$data['msg'] = 'Invalid ajax request!';
    }
    
    return 
json_encode($data);
}
Онлайн: 1
Реклама