<?php defined('ACCESS') OR die('No direct script access...');
/*
* Author - Tw1nGo
* VK - https://vk.com/tw1ngo93
*/
if (isset($_GET['id']))
{
$photo = mysql_fetch_assoc(mysql_query("SELECT * FROM `photos_user` WHERE `id` = '".abs(intval($_GET['id']))."' LIMIT 1"));
$album = mysql_fetch_assoc(mysql_query("SELECT * FROM `photos` WHERE `id` = '".$photo['id_album']."' LIMIT 1"));
$ank = mysql_fetch_assoc(mysql_query("SELECT * FROM `user` WHERE `id` = '".$album['id_user']."' LIMIT 1"));
$ank['nick'] = u_nick($ank['id']);
}
if (!isset($album) || $album['id'] <= 0){
header("Location: /id".$ank['id']."");
exit;
}
if (!isset($_GET['id']) || !isset($photo) || $photo['id'] <= 0){
header("Location: ?act=album&id=".$album['id']."");
exit;
}
if (isset($_GET['photo']) && $_GET['photo'] == 'avka')
{
if (isset($user) && $user['id'] == $ank['id'] || $user['level'] >= 4){
$avatar = mysql_fetch_array(mysql_query("SELECT * FROM `photos_user` WHERE `avatar` = '1' AND `id_user` = '$ank[id]' LIMIT 1"));
if ($avatar['id'] != $photo['id'])
{
mysql_query("UPDATE `photos_user` SET `avatar` = '0' WHERE `id_user` = '$ank[id]'");
mysql_query("UPDATE `photos_user` SET `avatar` = '1' WHERE `id` = '$photo[id]' LIMIT 1");
$msgsa = 'обновил'.($user['pol'] == 1 ? '' : 'а').' фотографию на странице:';
if (isset($user) && $user['id'] == $ank['id']){
mysql_query("INSERT INTO `user_wall` (`id_user`, `id_ank`, `time`, `text`, `type`, `id_object`) values('".$photo['id_user']."', '".$user['id']."', '".$time."', '".my_esc($msgsa)."', 'avatar', '".$photo['id']."')");
$stenka_id = mysql_insert_id();
$q = mysql_query("SELECT * FROM `frends` WHERE `user` = '".$album['id_user']."' AND `i` = '1'");
while ($f = mysql_fetch_array($q))
{
$a = get_user($f['frend']);
if ($a['id'] != $user['id'] && $photo['id'] != $avatar['id'])
mysql_query("INSERT INTO `tape` (`id_user`, `avtor`, `type`, `time`, `id_file`, `count`, `avatar`) values('$a[id]', '$album[id_user]', 'avka', '$time', '$stenka_id', '1', '$avatar[id]')");
}
}
$_SESSION['message'] = 'Фотография в профиле изменена!';
header("Location: ?act=photo&id=".$photo['id']."");
exit;
}
else{
$_SESSION['message'] = 'Фотография в профиле убрана!';
mysql_query("UPDATE `photos_user` SET `avatar` = '0' WHERE `id_user` = '$ank[id]'");
header("Location: ?act=photo&id=".$photo['id']."");
exit;
}
}
}
// Запись просмотра
if (isset($user) && mysql_result(mysql_query("SELECT COUNT(*) FROM `photos_count` WHERE `id_user` = '".$user['id']."' AND `id_photo` = '".$photo['id']."' LIMIT 1"),0)==0){
mysql_query("INSERT INTO `photos_count` (`id_photo`, `id_user`) VALUES ('$photo[id]', '$user[id]')");
mysql_query("UPDATE `photos_user` SET `count` = '".($photo['count']+1)."' WHERE `id` = '$photo[id]' LIMIT 1");
}
$set['title'] = ''.text($photo['name']).'';
include_once '../sys/inc/thead.php';
shapka_VK(true, '?act=album&id='.$album['id'].'', 'Фотография');
$cnt = mysql_fetch_assoc(mysql_query("
SELECT COUNT(ph.id) AS 'cnt',
SUM(IF(ph.id > '$photo[id]', 1, 0)) AS 'left',
SUM(IF(ph.id < '$photo[id]', 1, 0)) AS 'right',
(SELECT id FROM photos_user WHERE id > $photo[id] AND id_album = $album[id] ORDER BY id ASC LIMIT 1) AS 'id_left',
(SELECT id FROM photos_user WHERE id < $photo[id] AND id_album = $album[id] ORDER BY id DESC LIMIT 1) AS 'id_right'
FROM photos_user AS ph
WHERE ph.id_album = '$album[id]'
"));
$like_photo = mysql_result(mysql_query("SELECT COUNT(*) FROM `photos_user_like` WHERE `id_photo` = '".$photo['id']."'"), 0);
$q_like_photo = mysql_query("SELECT * FROM `photos_user_like` WHERE `id_photo` = '".$photo['id']."' ORDER BY `time` DESC LIMIT 2");
$count_pep = array('человеку', 'людям', 'людям');
if (isset($_GET['reply'])){
$otvet_ank = mysql_fetch_assoc(mysql_query("SELECT `id`,`nick` FROM `user` WHERE `id` = '".abs(intval($_GET['reply']))."' LIMIT 1"));
}
?>
<div class="pcont">
<div class="media_view photo_view">
<?
uvedom();
?>
<div class="pv_summary">Фотография <?php echo ($cnt['left'] + 1); ?> из <?php echo ($cnt['cnt']); ?></div>
<div class="pv_tag_wrap"></div>
<div class="pv_body pv_touch pv_touch_full pv_icons_hide">
<a class="thumb_item" href="/files/photos/original/<?= $photo['id'] . $photo['hash']?>.jpg"><div class="pv_photo_wrap" id="pv_photo_tags" onclick="return photo.closeTags(event);">
<img src="/files/photos/original/<?= $photo['id'] . $photo['hash']?>.jpg" class="ph_img" alt="" style="max-width: 380px;"></div>
</a>
<div class="pv_nav">
<table class="row_table pv_nav_cont"><tbody><tr>
<?
if($cnt['left']){
?>
<td class="pv_nav_left">
<a href="?act=photo&id=<?= $cnt['id_left']?>" class="pv_nav_link" onclick="return photo.prev(event);">
<span class="pv_icon" style="opacity: 1;"><i class="i_icon"></i></span>
<span class="pv_nav_label">« пред.</span>
</a>
</td>
<?
}
?>
<td class="pv_nav_z">
<a href="/files/photos/original/<?= $photo['id'] . $photo['hash']?>.jpg" class="pv_nav_link" target="_blank" onclick="return photo.fullscreen('/files/photos/original/<?= $photo['id'] . $photo['hash']?>.jpg', event);">
<span class="pv_icon"><i class="i_icon"></i></span>
</a>
</td>
<?
if($cnt['right']){
?>
<td class="pv_nav_right">
<a href="?act=photo&id=<?= $cnt['id_right']?>" class="pv_nav_link" onclick="return photo.next(event);">
<span class="pv_icon" style="opacity: 1;"><i class="i_icon"></i></span>
<span class="pv_nav_label">след. »</span>
</a>
</td>
<?
}
?>
</tr></tbody></table>
</div>
</div>
<div class="pv_footer bl_cont">
<div class="like_box bl_cont pi_medias wall_item">
<div class="photo_msg bl_none"></div>
<div id="like_who_<?= $photo['id']?>" class="wi_like_wrap" style="padding-bottom: 5px;">
<?
if($like_photo > 0){
?>
<a class="item_like _i" href="?act=like&id=<?= $photo['id']?>">
<span class="like_people" style="padding: 0;margin: 0 -2px 0;">
<span class="like_people_images">
<?
while ($post_like = mysql_fetch_array($q_like_photo))
{
$post_ank = mysql_fetch_assoc(mysql_query("SELECT * FROM `user` WHERE `id` = '".$post_like['id_user']."' LIMIT 1"));
?>
<span class="like_people_image_wrap" style="<?= ($like_photo == 1 ? 'margin: 0;' : '')?>">
<span class="like_people_image"> <?= avka50($post_ank['id'], 'like_people_image')?> </span>
</span>
<?
}
?>
</span>
<?
$count_pep_like = $like_photo - 1;
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `photos_user_like` WHERE `id_photo` = '".$photo['id']."' AND `id_user` = '".$user['id']."'"), 0) != 0)
{
?>
<span class="like_people_text"> Понравилось Вам
<?
if($like_photo > 1){
?>
и еще <?= des2num($count_pep_like, $count_pep)?>
<?
}
?>
</span>
<?
}
else{
?>
<span class="like_people_text"> Понравилось <?= des2num($like_photo, $count_pep)?></span>
<?
}
?>
</span></a>
<?
}
?>
</div>
<div class="mv_details" style="padding: 0;">
<?
if($photo['msg'] != NULL){
?>
<div class="mv_description"><?= text($photo['msg'])?></div>
<?
}
/*<dl class="si_row"><dt>Просмотров:</dt><dd><span class="item_views"><i class="i_views"></i><b class="v_views"><?= $photo['count']?></b></span></dd></dl>*/
?>
<dl class="si_row"><dt>Альбом:</dt><dd><a href="?act=album&id=<?= $album['id']?>"><?= text($album['name'])?></a></dd></dl>
<dl class="si_row"><dt>Отправитель:</dt><dd><a href="/id<?= $ank['id']?>"><?= $ank['nick']?></a></dd></dl>
<div class="vi_values"><span class="item_date">Добавлена <?= vremja($photo['time'])?></span>
<?
if (!isset($user))
{
?>
<a class="item_like is_empty _i"><i class="i_like"></i>
<?
if ($like_photo > 0){
?>
<b class="v_like"><?= $like_photo?></b>
<?
}
?>
</a>
<?
}
else{
?>
<a id="like_photo_<?= $photo['id']?>" onclick="like_photo(<?= $photo['id']?>), who_like_photo(<?= $photo['id']?>);" class="item_like _i">
<?
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `photos_user_like` WHERE `id_photo` = '".$photo['id']."' AND `id_user` = '".$user['id']."'"), 0) == 0)
{
?>
<i class="i_like"></i>
<?
}
else {
?>
<i class="i_like"></i>
<?
}
if ($like_photo > 0){
?>
<b class="v_like"><?= $like_photo?></b>
<?
}
?>
</a>
<?
}
?>
</div>
</div>
<ul class="mv_actions">
<?
$avatar = mysql_fetch_array(mysql_query("SELECT * FROM `photos_user` WHERE `avatar` = '1' AND `id_user` = '$ank[id]' LIMIT 1"));
/* <a href="?act=photo&id=<?= $photo['id']?>&photo=avka" class="mva_item"><span class="mva_label"><?= ($avatar['id'] != $photo['id'] ? 'Использовать как фото профиля' : 'Убрать фото из профиля')?></span></a> */
if (isset($user) && $user['id'] == $ank['id'] || $user['level'] >= 4){
?>
<li id="avka_profile_<?= $photo['id']?>" onclick="upload(<?= $photo['id']?>)">
<a href="?act=photo&id=<?= $photo['id']?>&photo=avka" class="mva_item"><span class="mva_label"><?= ($avatar['id'] != $photo['id'] ? 'Использовать как фото профиля' : 'Убрать фото из профиля')?></span></a>
</li>
<li><a href="?act=edit_photo&id=<?= $photo['id']?>" class="mva_item">Редактировать</a></li>
<?
}
if (isset($user)){
?>
<li><a href="?act=like&id=<?= $photo['id']?>&select=publish" class="mva_item">Отправить другу</a></li>
<?
}
?>
<li><a href="/files/photos/original/<?= $photo['id'] . $photo['hash']?>.jpg" class="mva_item" target="_blank">Загрузить оригинал</a></li>
<?
if (isset($user) && $user['id'] == $ank['id'] || $user['level'] >= 4){
?>
<li><a href="?act=dell_photo&id=<?= $photo['id']?>" class="mva_item">Удалить</a></li>
<?
}
?>
</ul></div>
</div>
<div class="comments_wrap bl_cont">
<a name="comments"></a>
<div class="wall_replies bl_cont">
<?
if (isset($_GET['delete_comment']) && isset($user) && ($user['id'] == $photo['id_user'] || $user['level'] >= 4))
{
mysql_query("DELETE FROM `photos_comm` WHERE `id` = '".abs(intval($_GET['delete_comment']))."' LIMIT 1");
header("Location: ?act=photo&id=".$photo['id']."");
exit;
}
$set['p_str'] = '10';
$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `photos_comm` WHERE `id_photo` = '".$photo['id']."'"), 0);
$k_page = k_page($k_post,$set['p_str']);
$page = page($k_page);
$start = $set['p_str']*$page-$set['p_str'];
if (isset($_POST['cfms']) && isset($user))
{
if (!isset($_POST['message']) || $_POST['message'] == NULL){
$err = 'Введите текст сообщения!';
}
$ya_otvet['id'] = abs(intval($_POST['reply_to']));
if (!isset($err)){
mysql_query("INSERT INTO `photos_comm` (`id_user`, `id_photo`, `msg`, `time`, `id_otv`) values ('".$user['id']."', '".$photo['id']."', '".my_esc($_POST['message'])."', '".$time."', '".$ya_otvet['id']."')");
$id_comms = mysql_insert_id();
if($user['id'] != $photo['id_user'] && $user['id'] != $ank['id']){
mysql_query("INSERT INTO `notifi` (`avtor`, `id_user`, `id_object`, `type`, `time`) VALUES ('$user[id]', '$photo[id_user]', '".$photo['id']."', 'photo_post', '$time')");
}
}
header("Location: ?act=photo&id=".$photo['id']."&p=".$k_page."#comments");
exit;
}
if($k_post && $k_page > 1 && $page != $k_page){
$page = ($page <= 0 OR $page > $k_page) ? 1 : intval($page);
$skok2 = $k_post - $set['p_str'] - $start;
if ($k_page > $page){
$st = $k_post-$page*$set['p_str'];
if ($st>$set['p_str']){
$skok = $set['p_str'];
}
else {
$skok = $st;
}
}
$count_coment = array('комментарий', 'комментария', 'комментариев');
?>
<div class="show_more_wrap">
<a class="show_more" href="?act=photo&id=<?= $photo['id']?>&p=<?= $page+1?>#comments">Показать ещё <?= des2num($skok, $count_coment)?></a>
</div>
<?
}
$q = mysql_query("SELECT * FROM `photos_comm` WHERE `id_photo` = '".$photo['id']."' ORDER BY `time` ASC LIMIT $start, $set[p_str]");
if ($k_post > 0){
while ($komm = mysql_fetch_array($q))
{
$k_ank = mysql_fetch_assoc(mysql_query("SELECT * FROM `user` WHERE `id` = '".$komm['id_user']."' LIMIT 1"));
$o_ank = mysql_fetch_assoc(mysql_query("SELECT * FROM `user` WHERE `id` = '".$komm['id_otv']."' LIMIT 1"));
$k_ank['nick'] = u_nick($k_ank['id']);
$o_ank['nick'] = u_nick($o_ank['id']);
?>
<div id="photo_comment<?= $komm['id']?>" class="post_item comment_item">
<a class="al_u<?= $k_ank['id']?>" href="/id<?= $k_ank['id']?>"><?= avka50($k_ank['id'], 'pi_img')?></a>
<div class="pi_cont">
<div class="pi_head">
<a class="pi_author al_u<?= $k_ank['id']?> _u<?= $k_ank['id']?>" href="/id<?= $k_ank['id']?>"><?= $k_ank['nick']?></a> <?= on_($k_ank['id'])?>
<?
if ($komm['id_otv'] > 0)
{
?>
<span class="explain" style="margin-left: 3px;"> ответил<?= ($k_ank['pol'] == 1 ? '' : 'а')?> <a href="/id<?= $o_ank['id']?>"><?= $o_ank['nick']?></a></span>
<?
}
?>
</div>
<div class="pi_body">
<div class="pi_text"><?= output_text($komm['msg'])?></div>
<div class="pi_info">
<span class="item_date"><?= vremja($komm['time'])?></span>
</div>
<div class="pi_links">
<?
if ($user['id'] == $photo['id_user'] || $user['level'] >= 4){
?>
<span class="like_wrap"><a class="pi_link" href="?act=photo&id=<?= $komm['id_photo']?>&delete_comment=<?= $komm['id']?>">Удалить</a></span>
<?
}
if ($user['id'] != $komm['id_user']){
?>
<span class="pi_reply_wrap"> · <a href="?act=photo&id=<?= $komm['id_photo']?>&reply=<?= $komm['id_user']?>">Ответить</a></span>
<?
}
?>
</div>
</div>
</div>
</div>
<?
}
if($k_post && $k_page > 1 && $page == $k_page || $page != 1){
?>
<div class="show_next_wrap">
<a class="show_next" href="?act=photo&id=<?= $photo['id']?>&p=<?= $page-1?>#comments">Следующие комментарии</a>
</div>
<?
}
}
if(isset($user)){
if (isset($_GET['reply'])){
$otv_ank = mysql_fetch_assoc(mysql_query("SELECT `id`,`nick`,`ank_name` FROM `user` WHERE `id` = '".abs(intval($_GET['reply']))."' LIMIT 1"));
$otv_ank['nick'] = text($otv_ank['ank_name']);
}
if (!isset($_GET['reply']) || !isset($otv_ank) || $otv_ank['id'] <= 0){
$r_text = '';
$r_text1 = '';
$r_text2 = '0';
}
else{
// Если ответ
$r_text = $otv_ank['nick'];
$r_text1 = $otv_ank['nick'] . ', ';
$r_text2 = $otv_ank['id'];
}
?>
<div class="bl_cont" id="reply_id">
<div class="create_post create_message comment_item">
<a href="/id<?= $user['id']?>"><?= avka50($user['id'], 'pi_img')?></a>
<div class="pi_cont">
<form action="?act=photo&id=<?= $photo['id']?>" method="post">
<input id="nc_reply_to" name="reply_to" value="<?= $r_text2?>" type="hidden">
<div class="MentionContainer">
<div class="iwrap">
<textarea name="message" class="textfield" rows="2" id="nc_message"><?= $r_text1?></textarea>
</div>
</div>
<div class="ibwrap">
<div class="cp_attached_wrap" id="attached_wrap"></div>
<div class="cp_buttons_block cp_buttons_block_relative clearfix">
<div class="cp_buttons_block_left clearfix">
<input class="button" value="Отправить" id="nc_submit" name="cfms" type="submit">
<?
if (isset($_GET['reply'])){
?>
<div class="near_btn _ib" style="display: inline-block;">
<a href="?act=photo&id=<?= $photo['id']?>" class="nc_reply_name"><?= $r_text?></a>
</div>
<?
}
?>
</div>
<?php emoji::showContent() ?>
</div>
</div>
</form>
</div>
</div>
</div>
<?
}
?>
</div></div>
</div></div>
<?
?>