Файл: adultscript-2.0.3-pro/files/templates/defboot/extend/ajax/photo_favorite.plugin.php
Строк: 27
<?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, a.album_id, p.total_favorites
FROM #__photo AS p
INNER JOIN #__photo_albums AS a ON (p.album_id = a.album_id)
WHERE p.photo_id = ".$photo_id."
LIMIT 1
");
if ($db->affected_rows()) {
VLanguage::load('frontend.photo');
$photo = $db->fetch_assoc();
$owner_id = (int) $photo['user_id'];
$album_id = (int) $photo['album_id'];
$total_favorites = (int) $photo['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'] = __('favorite-already');
} else {
$db->query("INSERT INTO #__photo_favorites
SET photo_id = ".$photo_id.",
user_id = ".$user_id);
if ($db->affected_rows()) {
$db->query("UPDATE #__photo
SET total_favorites = total_favorites+1
WHERE photo_id = ".$photo_id."
LIMIT 1");
$db->query("UPDATE #__photo_albums
SET total_favorites = total_favorites+1
WHERE album_id = ".$album_id."
LIMIT 1");
$data['status'] = 1;
$data['total'] = $total_favorites+1;
} else {
throw new VException('Application Errror! 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);
}