<?php
/**
* mobiCMS (https://mobicms.org/)
* This file is part of mobiCMS Content Management System.
*
* @license https://opensource.org/licenses/GPL-3.0 GPL-3.0 (see the LICENSE.md file)
* @link http://mobicms.org mobiCMS Project
* @copyright Copyright (C) mobiCMS Community
*/
defined('MOBICMS') or die('Error: restricted access');
/** @var Psr\Container\ContainerInterface $container */
$container = App::getContainer();
/** @var PDO $db */
$db = $container->get(PDO::class);
/** @var Mobicms\Checkpoint\UserConfig $userConfig */
$userConfig = $container->get(Mobicms\Api\UserInterface::class)->getConfig();
/** @var Mobicms\Api\ToolsInterface $tools */
$tools = $container->get(Mobicms\Api\ToolsInterface::class);
require ROOT_PATH . 'system/head.php';
// Топ юзеров
$pageTitle = _t('Top Users');
echo '<div class="phdr"><a href="?"><b>' . _t('Downloads') . '</b></a> | ' . $pageTitle . '</div>';
$req = $db->query("SELECT * FROM `download__files` WHERE `user_id` > 0 GROUP BY `user_id` ORDER BY COUNT(`user_id`)");
$total = $req->rowCount();
// Навигация
if ($total > $userConfig->kmess) {
echo '<div class="topmenu">' . $tools->displayPagination('?act=top_users&', $total) . '</div>';
}
// Список файлов
$i = 0;
if ($total) {
$req_down = $db->query("SELECT *, COUNT(`user_id`) AS `count` FROM `download__files` WHERE `user_id` > 0 GROUP BY `user_id` ORDER BY `count` DESC" . $tools->getPgStart(true));
while ($res_down = $req_down->fetch()) {
$user = $db->query("SELECT * FROM `users` WHERE `id`=" . $res_down['user_id'])->fetch();
echo (($i++ % 2) ? '<div class="list2">' : '<div class="list1">') .
$tools->displayUser($user, ['iphide' => 0, 'sub' => '<a href="?act=user_files&id=' . $user['id'] . '">' . _t('User Files') . ':</a> ' . $res_down['count']]) . '</div>';
}
} else {
echo '<div class="menu"><p>' . _t('The list is empty') . '</p></div>';
}
echo '<div class="phdr">' . _t('Total') . ': ' . $total . '</div>';
// Навигация
if ($total > $userConfig->kmess) {
echo '<div class="topmenu">' . $tools->displayPagination('?act=top_users&', $total) . '</div>' .
'<p><form action="?" method="get">' .
'<input type="hidden" value="top_users" name="act" />' .
'<input type="text" name="page" size="2"/><input type="submit" value="' . _t('To Page') . ' >>"/></form></p>';
}
echo '<p><a href="?">' . _t('Downloads') . '</a></p>';
require ROOT_PATH . 'system/end.php';