View file ä󿪫¬/modules/foto/top_user.php

<?php

/* Mixanza
 * Дата последнего редактирования 11.08.2018
 * Модифицировал Mixanza
 */
 
foreach (array('start', 'compress', 'sess', 'settings', 'db_connect', 'ipua', 'fnc', 'user') as $inc) {
    require_once "../../sys/inc/$inc.php";
} 

$foto = $pdo->query(("SELECT * FROM `gallery_foto` WHERE `id_user` = '".intval($_GET['id'])."' AND `block_yes` = '0' AND `anonim` = '0' LIMIT 1"))->fetch(PDO::FETCH_ASSOC);
$ank_u = $pdo->query(("SELECT * FROM `user` WHERE `id` = '".intval($_GET['id'])."' LIMIT 1"))->fetch(PDO::FETCH_ASSOC);
$ank = get_user($ank_u['id']);

$set['title'] = 'Популярные фото'; // заголовок страницы

require_once H . 'sys/inc/thead.php';

aut();
err();

#Навигация
echo "<div class='card-header'>";
echo "<a href='/' data-toggle='tooltip' data-placement='right' title='" . lang('На главную') . "'><i class='fa fa-home fa-lg'></i></a> <i class='fa fa-angle-right fa-fw'></i> ";
echo "<a href='/info.php?id=$ank[id]'>$ank[nick]</a> <i class='fa fa-angle-right fa-fw'></i> <a href='/modules/foto/$ank[id]/'>";
echo lang('Фотоальбомы') . "</a> <i class='fa fa-angle-right fa-fw'></i> Популярные фото";
echo "</div>";

    echo "<div class='list-group-item-komm'>";
echo "<table style='width: 100%; text-align: center;'><tr>
<td class='fn-lefti'><a style='display: block;padding: 10px;' href='/modules/foto/$ank[id]/'><font color=#587C94><b>ВСЕ</b></font></a></td>
<td class='fn-centeri-o'><a style='display: block;padding: 10px;' href='/modules/foto/top_user.php?id=$ank[id]'><b><font color=#587C94>ПОПУЛЯРНЫЕ</font></b></a></td>
<td class='fn-righti'><a style='display: block;padding: 10px;' href='/modules/foto/block.php'><b><font color=#587C94>БЛОК</font></b></a></td>
</tr></table></div>";


$k_post = $pdo->query(("SELECT COUNT(*) FROM `gallery_foto` WHERE `id_user` = '$user[id]' AND `block_yes` = '0' AND `anonim` = '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 `block_yes` = '0' AND `anonim` = '0' ORDER BY `k_loads` DESC LIMIT $start, $set[p_str]");

if ($k_post == 0) {
  echo "<div class='list-group-item'>У пользователя ещё нет фотографий</div>";    
}   
    
  echo "<div class='list-group-item'><table style='width: 100%; text-align: center;' cellspacing='0' cellpadding='0'><tr>";
    while ($post = $q->fetch(PDO::FETCH_ASSOC)) {
        
$gallery = $pdo->query(("SELECT * FROM `gallery` WHERE `id` = '$post[id_gallery]' AND `id_user` = '$ank[id]' LIMIT 1"))->fetch(PDO::FETCH_ASSOC);

echo "<td style='display: inline-block;'>";
echo "<a href='/modules/foto/$post[id_user]/$gallery[id]/$post[id]/'><div style='padding: 2px; border: 1px #D1D7DB solid; border-radius: 4px; margin: 3px;'>";
echo "<img src='/modules/foto/foto128/$post[id].$post[ras]' width='82' height='82' style='margin: 3px;'><br>";
echo "<font color=#7997AA><i class='fa fa-eye'></i> <small>" . $pdo->query(("SELECT COUNT(*) FROM `foto_count` WHERE `id_foto` = '" . intval($post['id']) . "'"), 0)->fetchColumn() . "</small></font></div></a></td>";
        
        
        
        
    }

 echo '</tr></table></div>';


if ($k_page > 1) {
    echo "<div class='list-group-item'>";
    str('?', $k_page, $page);
    echo "</div>";
}








require_once H . 'sys/inc/tfoot.php';
exit;