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

<?php

foreach (array('start', 'compress', 'sess', 'settings', 'db_connect', 'ipua', 'fnc', 'user') as $inc) {
    require_once "../../sys/inc/$inc.php";
}

$set['title'] = lang('Лучшие фото');
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='/modules/foto/'>" . lang('Фотоальбомы') . "</a> <i class='fa fa-angle-right fa-fw'></i> ";
echo lang('Лучшие фото');
echo "</div>";

 
echo "<div class='list-group-item-komm'><table style='width: 100%; text-align: center;'><tr>";
echo "<td class='fn-lefti'><a style='display: block;padding: 10px;' href='/modules/foto/konkursy.php'><font color=#587C94><b>КОНКУРСЫ</b></font></a></td>";
echo "<td class='fn-centeri-o'><a style='display: block;padding: 10px;' href='/modules/foto/rating.php'><font color=#587C94><b>ТОП</b></font></a></td>";
echo "<td class='fn-righti'><a style='display: block;padding: 10px;' href='/modules/foto/'><b><font color=#587C94>АЛЬБОМЫ</font></b></a></td>";
echo "</tr></table></div>";

if (isset($_GET['vse'])){
$order = "AND `k_loads` > '1' order by `time` asc"; 
echo "<div class='list-group-item'>Сортировка: <a href='rating.php'>За сегодня</a> | <b>За всё время</b>";
echo "</div>";    
}else{
$order = "AND `k_loads` > '1' order by `time` desc";
echo "<div class='list-group-item'>Сортировка: <b>За сегодня</b> | <a href='?vse'>За всё время</a>";
echo "</div>";    
}    


$set['p_str'] = 30;
$k_rxn = $pdo->query(("SELECT `id` FROM `gallery_foto` WHERE `private_foto` = '0' AND `top` = '1' AND `adult` = '0' AND `block_yes` = '0' AND `k_loads` > '1'"))->fetchColumn();
$k_page = k_page($k_rxn, $set['p_str']);
$page = page($k_page);
$start = $set['p_str'] * $page - $set['p_str'];

if ($k_rxn == '0') {
    $doc->NoResult();
}

$r_xn = $pdo->query("SELECT * FROM `gallery_foto` WHERE `private_foto` = '0' AND `top` = '1' AND `adult` = '0' AND `block_yes` = '0' $order LIMIT $start, $set[p_str]");
    echo "<div class='list-group-item'><table style='width: 100%; text-align: center;' cellspacing='0' cellpadding='0'><tr>";
while ($ank = $r_xn->fetch(PDO::FETCH_ASSOC)) {

    $f = $ank['id'];
    $foto = $pdo->query(("SELECT * FROM `gallery_foto` WHERE `id` = '" . intval($f) . "'  LIMIT 1"))->fetch(PDO::FETCH_ASSOC);
    $gallery = $pdo->query(("SELECT * FROM `gallery` WHERE `id`='" . intval($foto['id_gallery']) . "'  LIMIT 1"))->fetch(PDO::FETCH_ASSOC);
    $ank_p = get_user($gallery['id_user']);

echo "<td style='display: inline-block;'>";
echo "<a href='/modules/foto/$foto[id_user]/$gallery[id]/$foto[id]/'><div style='padding: 2px; border: 1px #D1D7DB solid; border-radius: 4px; margin: 3px;'>";
echo "<img src='/modules/foto/foto128/$foto[id].$foto[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($foto['id']) . "'"), 0)->fetchColumn() . "</small></font></div></a></td>";


}


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

if ($k_page > 1) {
echo "<div class='list-group-item'>";
if (isset($_GET['vse'])){
str("rating.php?vse&", $k_page, $page);
}else{
str("rating.php?", $k_page, $page);    
}
echo "</div>";
}

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