<?php
require ($_SERVER['DOCUMENT_ROOT'].'/system/connections/core.php');
access('users');
if (ajax() == true) {
if (get('plikes')) {
$photo = db::get_string("SELECT `USER_ID`,`ID` FROM `PHOTOS` WHERE `ID` = ? LIMIT 1", [intval(get('plikes'))]);
if (isset($photo['ID'])) {
get_check_valid();
if (db::get_column("SELECT COUNT(`ID`) FROM `LIKES` WHERE `USER_ID` = ? AND `OBJECT_ID` = ? AND `OBJECT_TYPE` = ? AND `TYPE` = ? LIMIT 1", [user('ID'), $photo['ID'], 'photos', 'like']) == 0) {
db::get_add("INSERT INTO `LIKES` (`USER_ID`, `TIME`, `OBJECT_ID`, `OBJECT_TYPE`, `TYPE`) VALUES (?, ?, ?, ?, ?)", [user('ID'), TM, $photo['ID'], 'photos', 'like']);
db::get_set("DELETE FROM `LIKES` WHERE `USER_ID` = ? AND `OBJECT_ID` = ? AND `OBJECT_TYPE` = ? AND `TYPE` = ? LIMIT 1", [user('ID'), $photo['ID'], 'photos', 'dislike']);
/*
--------------------
Уведомления в журнал
--------------------
*/
if ($photo['USER_ID'] != user('ID')){
if (db::get_column("SELECT COUNT(*) FROM `NOTIFICATIONS_SETTINGS` WHERE `USER_ID` = ? AND `LIKES` = ? LIMIT 1", [$photo['USER_ID'], 1]) == 1){
db::get_add("INSERT INTO `NOTIFICATIONS` (`USER_ID`, `OBJECT_ID`, `OBJECT_ID_LIST`, `TIME`, `TYPE`) VALUES (?, ?, ?, ?, ?)", [$photo['USER_ID'], user('ID'), $photo['ID'], TM, 'photos_like']);
}
}
}
}else{
db::get_set("DELETE FROM `LIKES` WHERE `USER_ID` = ? AND `OBJECT_ID` = ? AND `OBJECT_TYPE` = ? AND `TYPE` = ? LIMIT 1", [user('ID'), $photo['ID'], 'photos', 'like']);
}
}
if (get('pdislikes')) {
$photo = db::get_string("SELECT `USER_ID`,`ID` FROM `PHOTOS` WHERE `ID` = ? LIMIT 1", [intval(get('pdislikes'))]);
if (isset($photo['ID'])) {
get_check_valid();
if (db::get_column("SELECT COUNT(`ID`) FROM `LIKES` WHERE `USER_ID` = ? AND `OBJECT_ID` = ? AND `OBJECT_TYPE` = ? AND `TYPE` = ? LIMIT 1", [user('ID'), $photo['ID'], 'photos', 'dislike']) == 0) {
db::get_add("INSERT INTO `LIKES` (`USER_ID`, `TIME`, `OBJECT_ID`, `OBJECT_TYPE`, `TYPE`) VALUES (?, ?, ?, ?, ?)", [user('ID'), TM, $photo['ID'], 'photos', 'dislike']);
db::get_set("DELETE FROM `LIKES` WHERE `USER_ID` = ? AND `OBJECT_ID` = ? AND `OBJECT_TYPE` = ? AND `TYPE` = ? LIMIT 1", [user('ID'), $photo['ID'], 'photos', 'like']);
}else{
db::get_set("DELETE FROM `LIKES` WHERE `USER_ID` = ? AND `OBJECT_ID` = ? AND `OBJECT_TYPE` = ? AND `TYPE` = ? LIMIT 1", [user('ID'), $photo['ID'], 'photos', 'dislike']);
}
}
}
if (isset($photo['ID'])) {
$likes = db::get_column("SELECT COUNT(*) FROM `LIKES` WHERE `OBJECT_ID` = ? AND `OBJECT_TYPE` = ? AND `TYPE` = 'like'", [$photo['ID'], 'photos']);
$dislikes = db::get_column("SELECT COUNT(*) FROM `LIKES` WHERE `OBJECT_ID` = ? AND `OBJECT_TYPE` = ? AND `TYPE` = 'dislike'", [$photo['ID'], 'photos']);
$ulikes = db::get_column("SELECT COUNT(*) FROM `LIKES` WHERE `USER_ID` = ? AND `OBJECT_ID` = ? AND `OBJECT_TYPE` = ? AND `TYPE` = 'like'", [user('ID'), $photo['ID'], 'photos']);
$udislikes = db::get_column("SELECT COUNT(*) FROM `LIKES` WHERE `USER_ID` = ? AND `OBJECT_ID` = ? AND `OBJECT_TYPE` = ? AND `TYPE` = 'dislike'", [user('ID'), $photo['ID'], 'photos']);
echo json_encode(array(
'likes' => '<button class="AVP_modal_bottom_button" onclick="AVP_likes(\''.$photo['ID'].'\', \''.TOKEN_URL.'\')">'.($ulikes > 0 ? '<font color="#21C49A">'.icons('thumbs-up', 20, 'fa-fw').' '.$likes.'</font>' : icons('thumbs-up', 20, 'fa-fw').' '.$likes).'</button>',
'dislikes' => '<button class="AVP_modal_bottom_button" onclick="AVP_dislikes(\''.$photo['ID'].'\', \''.TOKEN_URL.'\')">'.($udislikes > 0 ? '<font color="#FF3D7F">'.icons('thumbs-down', 20, 'fa-fw').' '.$dislikes.'</font>' : icons('thumbs-down', 20, 'fa-fw').' '.$dislikes).'</button>',
));
}else{
echo lg('Не удалось установить соединение');
}
}else{
echo lg('Не удалось установить соединение');
}