Файл: modules/public/foto.php
Строк: 108
<?php
/* DCMS Special
* Дата последнего редактирования 24.01.2016
* Модифицировал densnet
*/
foreach (array('start', 'compress', 'sess', 'settings', 'db_connect', 'ipua', 'fnc', 'user') as $inc) {
require_once "../../sys/inc/$inc.php";
}
if (isset($_GET['id'])) {
$public['id'] = intval($_GET['id']);
}
$public = mysql_fetch_array(mysql_query("SELECT * FROM `public` WHERE `id` = '" . $public['id'] . ")'"));
if ($public['id'] == intval($_GET['id'])) {
$set['title'] = lang('Фотографии') . " - " . $public['name'];
require_once H . 'sys/inc/thead.php';
if (isset($_GET['del']) && $_GET['del'] == 'del' && intval($_GET['foto'])) {
$f = mysql_fetch_array(mysql_query("SELECT * FROM `public_foto` WHERE `id` = '" . intval($_GET['foto']) . ")'"));
mysql_query("DELETE FROM `public_foto` WHERE `id` = '" . $f['id'] . "'");
@unlink(H . "sys/public/foto/600/" . $f['id'] . ".jpg");
@unlink(H . "sys/public/foto/foto/" . $f['id'] . ".jpg");
$_SESSION['message'] = lang('Фото успешно удалено');
header("Location: foto.php?id=" . $public['id'] . "");
}
if (isset($_GET['like']) && $_GET['like'] == 'dislike' && intval($_GET['foto'])) {
mysql_query("DELETE FROM `public_like` WHERE `id_user` = '" . $user['id'] . "' AND `pub_foto` = '" . intval($_GET['foto']) . "'");
mysql_query("OPTIMIZE TABLE `public_like`");
msg('Лайк отменен');
header("Location: foto.php?id=" . $public['id'] . "");
} elseif (isset($_GET['like']) && $_GET['like'] == 'like' && intval($_GET['foto'])) {
mysql_query("INSERT INTO `public_like` (`id_user`, `pub_foto`, `like`) values('" . $user['id'] . "', '" . intval($_GET['foto']) . "', '+1')", $db);
mysql_query("INSERT INTO `public_wall` (`id_wall`, `link`, `ras`, `name`, `id_public`) values('" . $user['id'] . "', '/sys/public/foto/600/" . intval($_GET['foto']) . ".jpg', 'jpg', '" . $foto['name'] . "', '" . $public['id'] . "')");
mysql_query("OPTIMIZE TABLE `public_like`");
mysql_query("OPTIMIZE TABLE `public_wall`");
msg('Вам понравилось');
header("Location: foto.php?id=" . $public['id'] . "");
}
aut();
err();
$doc->Link('list-group-item', "index.php?id=" . $public['id'] . "", 'arrow-left', 'Вернуться в сообщество');
$ank = mysql_fetch_array(mysql_query("SELECT * FROM `public_coint` WHERE `id_public` = '" . $public['id'] . "' AND `id_user` = '" . $user['id'] . "' LIMIT 1"));
if (isset($user) && $ank['id_user'] == $user['id']) {
if (isset($user) && $user['id'] == $public['id_user'] || $public['p'] == '0') {
echo "<div class='list-group-item'>";
echo "<div class='btn btn-secondary btn-sm'><a href='edit.php?id=" . $public['id'] . "&foto=add'><i class='fa fa-camera fa-fw'></i> " . lang('Выгрузить фото') . "</a></div>";
echo "</div>";
}
}
$fotki = mysql_result(mysql_query("SELECT COUNT(*) FROM `public_foto` WHERE `id_public` = '" . $public['id'] . "' AND `foto` = '2'"), 0);
echo "<div class='list-group-item list-group-item-info'>";
echo "<a href='foto.php?id=" . $public['id'] . "'>Фотографии</a><span class='badge'>$fotki</span>";
echo "</div>";
?>
<script src="/modules/public/js/jquery-1.8.3.min.js"></script>
<script>
$(document).ready(function () {
$('span#like').click(function () {
setVote('like', $(this));
});
});
function setVote(type, element) {
var go = $('#go').val();
var us = $('#us').val();
var id_post = element.parent().find('#id_post').val();
$.ajax({
type: "POST",
url: "/modules/public/like.php?pub_foto=pub_foto",
data: {
'go': go,
'id_post': id_post,
'us': us
},
dataType: "json",
success: function (data) {
if (data.result == 'like') {
var count = parseInt(element.find('b').html());
element.find('b').html(count + 1);
} else {
var count = parseInt(element.find('b').html());
element.find('b').html(count - 1);
}
}
});
}
</script>
<?php
$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `public_foto` WHERE `id_public` = '" . $public['id'] . "'"), 0);
$k_page = k_page($k_post, $set['p_str']);
$page = page($k_page);
$start = $set['p_str'] * $page - $set['p_str'];
if ($k_post == 0) {
$doc->NoResult();
}
echo "<table width='100%' cellpadding='0' cellspacing='0' border='0'>";
$f = mysql_query("SELECT id,ras FROM `public_foto` WHERE `id_public` = '" . $public['id'] . "' AND `foto` = '2' LIMIT $start, " . $set['p_str'] . "");
while ($foto = mysql_fetch_array($f)) {
echo "<tr><td align='center'>";
if (isset($user) && $user['id'] == $public['id_user']) {
echo "<span style='float: right;' class='list-group-item'>";
echo "<a href='foto.php?id=" . $public['id'] . "&del=del&foto=" . $foto['id'] . "' data-toggle='tooltip' data-placement='left' title='" . lang('Удалить') . "'><i class='fa fa-trash-o fa-fw'></i></a>";
echo "</span>";
}
if (IS_WEB) {
echo "<div class='list-group-item'><img src='/sys/public/foto/600/" . $foto['id'] . ".jpg' width='300'>";
} else {
echo "<div class='list-group-item'><img src='/sys/public/foto/600/" . $foto['id'] . ".jpg' width='200'>";
}
echo "</td></tr>";
echo "<tr><td class='list-group-item'>";
echo "<table width='100%' cellpadding='0' cellspacing='0' border='0'><tr><td>";
?>
<style>
.likes {
cursor: pointer;
}
</style>
<?php
$us = $user['id'];
$go = 'go';
$like_f = mysql_result(mysql_query("SELECT COUNT(*) FROM `public_like` WHERE `pub_foto` = '" . $foto['id'] . "'"), 0);
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `public_like` WHERE `id_user` = '" . $user['id'] . "' AND `pub_foto` = '" . $foto['id'] . "'"), 0) == 0) {
if (!isset($webbrowser)) {
echo "<a href='foto.php?id=" . $public['id'] . "&like=like&foto=" . $foto['id'] . "'>Мне нравится <i class='fa fa-heart fa-fw'></i></a>";
if ($like_f > 0) {
echo $like_f;
}
} else {
echo "<span id='like'><a class='likes'>Мне нравится <i class='fa fa-heart fa-fw'></i><b>$like_f</b></a></span>";
echo '<input type="hidden" id="id_post" value="' . $foto['id'] . '" />';
echo '<input type="hidden" id="go" value="' . $go . '" />';
echo '<input type="hidden" id="us" value="' . $user['id'] . '" />';
}
} else {
if (!isset($webbrowser)) {
echo "<a href='foto.php?id=" . $public['id'] . "&like=dislike&foto=" . $foto['id'] . "'>Мне нравится <i class='fa fa-heart fa-fw'></i> " . (($like_f > 0) ? "$like_f" : "$like_f") . "</a>";
} else {
echo "<span id='like'><a class='likes'>Мне нравится <i class='fa fa-heart fa-fw'></i> <b>$like_f</b></a></span>";
echo '<input type="hidden" id="id_post" value="' . $foto['id'] . '" />';
echo '<input type="hidden" id="go" value="' . $go . '" />';
echo '<input type="hidden" id="us" value="' . $user['id'] . '" />';
}
}
echo "</td><td align='right'>";
echo "<a href='/sys/public/foto/foto/" . $foto['id'] . ".jpg'><i class='fa fa-save fa-fw'></i> Скачать</a>";
echo "</td></tr></table>";
echo "</td></tr>";
}
echo "</table>";
if ($k_page > 1) {
echo "<div class='list-group-item'>";
str("foto.php?id=" . $public['id'] . "&", $k_page, $page);
echo "</div>";
}
}
require_once H . 'sys/inc/tfoot.php';