<?
if(isset($_GET['id'])){
$id = abs(intval($_GET['id']));
$foto = DB::a()->d->query("SELECT `gallery`.* ,".User::a()->join."
FROM `gallery` JOIN `users`
ON `users`.`id` = `gallery`.`user` WHERE `gallery`.`id` = '".$id."' LIMIT 1")->fetch();
if($foto===false){
header('Location:/Photos/');
die();
}
$isLike = False;
$users = json_decode($foto['who'],true);
if($users==NULL)$users = array();
if(in_array(User::a()->user['id'], $users))$isLike = true;
Template::a()->setTitle('Фото #'.$foto['id']);
Template::a()->set('fotos',$foto);
Template::a()->set('isLike',$isLike);
Template::a()->display('photos/showfoto');
die();
}
if(isset($_GET['like'])){
$id = abs(intval($_GET['like']));
$foto = DB::a()->d->query("SELECT `gallery`.* ,".User::a()->join."
FROM `gallery` JOIN `users`
ON `users`.`id` = `gallery`.`user` WHERE `gallery`.`id` = '".$id."' LIMIT 1")->fetch();
if($foto===false){
header('Location:/Photos/');
die();
}
$users = json_decode($foto['who'],true);
if($users==NULL)$users = array();
if(in_array(User::a()->user['id'], $users)){
header('Location:/Photos/');
die();
}
$users[]=User::a()->user['id'];
$users = json_encode($users);
DB::a()->d->query("UPDATE `gallery` SET `likes` = `likes` + 1 ,`who` = '".$users."' WHERE `id`= '".$foto['id']."' LIMIT 1");
header('Location:/Photos/?id='.$foto['id'].'/');
die();
}
if(isset($_GET['delrating'])){
if(User::a()->isAdmin!==true){
header('Location:/Photos/?id='.$foto['id'].'/');
die();
}
$id = abs(intval($_GET['delrating']));
$foto = DB::a()->d->query("SELECT `gallery`.* ,".User::a()->join."
FROM `gallery` JOIN `users`
ON `users`.`id` = `gallery`.`user` WHERE `gallery`.`id` = '".$id."' LIMIT 1")->fetch();
if($foto===false){
header('Location:/Photos/');
die();
}
DB::a()->d->query("UPDATE `gallery` SET `rating` = 0 WHERE `id`= '".$foto['id']."' LIMIT 1");
header('Location:/Photos/');
die();
}
$page = 1;
if(isset($_GET['page'])) $page = abs(intval($_GET['page']));
$start = $page * 10 - 10;
$fotos = DB::a()->d->query("SELECT `gallery`.* ,".User::a()->join."
FROM `gallery` JOIN `users`
ON `users`.`id` = `gallery`.`user` WHERE `gallery`.`rating` = 1
ORDER BY `gallery`.`likes` DESC LIMIT ".$start.",10")->fetchAll();
$count = DB::a()->d->query("SELECT `gallery`.* FROM `gallery` WHERE `gallery`.`rating` = 1")->fetchAll();
$count = count($count);
Template::a()->setTitle('Фотогаллерея');
Template::a()->set('fotos',$fotos);
Template::a()->set('count',$count);
Template::a()->display('photos/index');
?>