Просмотр поста

$total1 = $db->query("SELECT COUNT(*) FROM `library_texts` WHERE `time` > '" . (time() - 259200) . "' AND `premod`=1")->fetchColumn();
$sql1 = $db->query("SELECT `id`, `name`, `time`, `uploader`, `uploader_id`, `count_views`, `comments`, `comm_count`, `cat_id`, `announce` FROM `library_texts` WHERE `time` > '" . (time() - 259200) . "' AND `premod`=1 ORDER BY `time` DESC LIMIT 5");

if ($total1) {

    $i1 = 0;
    while ($row1 = $sql1->fetch()) {
    
        echo '<div style="font-family: monospace; font-size: 12px; margin-right: 5px; margin-left: 5px;" class="menu"' . (++$i1 % 2 ? 2 : 1) . '">'
            . '<span class="glyphicon glyphicon-file"></span> <a href="/library/index.php?id=' . $row1['id'] . '">' . $tools->checkout($row1['name']) . '</a>'        
            // Прочтений
            . ' <span style="color: #ffcb08;"><span class="glyphicon glyphicon-eye-open"></span> ' . $row1['count_views'] . '</span>'
            . '';
            
        if ($row1['comments']) {
            echo ' | <a href="/library/?act=comments&amp;id=' . $row1['id'] . '">' . $row1['comm_count'] . ' <span class="glyphicon glyphicon-comment"></span></a>';
        } else {
            echo ' | ' . _t('Comments') . ': ' . _t('Comments are closed') . '';
        }
            
            // Кто добавил?
            echo '<br><span style="font-size: x-small;">Добавил: '
            . '<a href="' . App::getContainer()->get('config')['johncms']['homeurl'] . '/profile/?user=' . $row1['uploader_id'] . '">' . $tools->checkout($row1['uploader']) . '</a> (' . $tools->displayDate($row1['time']) . ')'
            . '</span></div>';
            
            
        
        }  
} else { echo '<div class="rmenu">Нету новых статей</div>';}

$total = $db->query("SELECT COUNT(*) FROM `download__files` WHERE `type` = '2'")->fetchColumn();
 
if ($total) {
    $i = 0;
    $req_down = $db->query("SELECT * FROM `download__files` WHERE `type` = '2' ORDER BY `time` DESC LIMIT 5");
 
    while ($res_down = $req_down->fetch()) {
        echo '<div style="font-family: monospace; font-size: 12px; margin-right: 5px; margin-left: 5px;" class="menu"><span class="glyphicon glyphicon-floppy-disk"></span> <a href="/downloads/?act=view&id='.$res_down['id'].'">'.$res_down['rus_name'].'</a>';
        
        
        
    if ($config['mod_down_comm'] || $systemUser->rights >= 7) {
    echo ' | <a href="/downloads/?act=comments&amp;id=' . $res_down['id'] . '">' . $res_down['comm_count'] . ' <span class="glyphicon glyphicon-comment"></span></a><br>';
    }
    
    $user = $db->query("SELECT `name`, `id` FROM `users` WHERE `id` = " . $res_down['user_id'])->fetch();
    echo '<span style="font-size: x-small;"><span class="gray">Загрузил:</span> ' . $user['name'] . '</span></div>';
    
    }
} else {
    echo '<div class="rmenu">Нету новых файлов</div>'; //<p>' . _t('The list is empty') . '</p>
}