File size: 3.35Kb
<?php
if (isset($_GET['category_id'])) {
$category_id = (int) $_GET['category_id'];
$set['p_str'] = 24;
$k_post = $pdo->query(("SELECT COUNT(*) FROM `gallery_foto` WHERE `id_user` = '$user[id]' AND `block_yes` = '0'"), 0)->fetchColumn();
$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();
}
$q = $pdo->query("SELECT * FROM `gallery_foto` WHERE `id_user` = '$user[id]' AND `id_gallery` = '$category_id' AND `block_yes` = '0' ORDER BY `time` DESC LIMIT $start, $set[p_str]");
echo "<div class='list-group-item'>";
while ($post = $q->fetch(PDO::FETCH_ASSOC)) {
echo "<a href='?type=$type&attachments_id=$post[id]'><img src='/modules/foto/foto48/$post[id].$post[ras]' /></a>";
}
echo "</div>";
if ($k_page > 1) {
echo "<div class='list-group-item'>";
str('?type=' . $type . '&category_id=' . $category_id . '&', $k_page, $page);
echo "</div>";
}
} elseif (isset($_GET['category'])) {
$k_post = $pdo->query(("SELECT COUNT(*) FROM `gallery` WHERE `id_user` = '$user[id]'"), 0)->fetchColumn();
$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();
}
$q = $pdo->query("SELECT * FROM `gallery` WHERE `id_user` = '$user[id]' ORDER BY `time` DESC LIMIT $start, $set[p_str]");
while ($post = $q->fetch(PDO::FETCH_ASSOC)) {
$count = $pdo->query(("SELECT COUNT(*) FROM `gallery_foto` WHERE `id_gallery` = '$post[id]' AND `block_yes` = '0'"), 0)->fetchColumn();
echo "<div class='list-group-item'>";
echo "<a href='?type=$type&category_id=$post[id]'><i class='fa fa-folder fa-fw'></i> $post[name] ($count " . lang('фото') . ")</a>";
echo "</div>";
}
if ($k_page > 1) {
echo "<div class='list-group-item'>";
str('?type=' . $type . '&category&', $k_page, $page);
echo "</div>";
}
} else {
$q = $pdo->query("SELECT * FROM `gallery_foto` WHERE `id_user` = '$user[id]' ORDER BY `time` DESC LIMIT 5");
if ($q->rowCount() > 0) {
echo "<div class='list-group-item'>";
while ($post = $q->fetch(PDO::FETCH_ASSOC)) {
echo "<a href='?type=$type&attachments_id=$post[id]'><img src='/modules/foto/foto48/$post[id].jpg' /></a> ";
}
echo "</div>";
echo "<div class='list-group-item'>";
echo "<a href='?type=$type&category'>" . lang('Показать все фото') . "</a>";
echo "</div>";
} else {
echo "<div class='alert alert-info'>" . lang('У вас еще нет на сайте загруженных фотографий, но вы можете воспользоваться формой ниже') . ".</div>";
}
echo "<form class='list-group-item' action='?type=$type' method='POST' enctype='multipart/form-data'>";
echo "<br>Выберите фото:<br><input class='form-control' style='width:50%;' name='file' type='file'/><br />";
$doc->Textarea('msg', 'Описание', 256);
echo "<br />";
$doc->Button('knopka', 'submit', 'upload', 'Загрузить');
echo "</form>";
}