Вывод на главную JohnCMS 7.1.0

$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>
}

echo '<div class="phdr"><b>Новые топики (<a href="/forum/index.php?act=new&do=period">Все за 24 часа</a>)</b></div>';

$vr = isset($_REQUEST['vr']) ? abs(intval($_REQUEST['vr'])) : 24;
            $vr1 = time() - $vr * 3600;

            if ($systemUser->rights == 9) {
                $req = $db->query("SELECT COUNT(*) FROM `forum` WHERE `type`='t' AND `time` > '$vr1'");
            } else {
                $req = $db->query("SELECT COUNT(*) FROM `forum` WHERE `type`='t' AND `time` > '$vr1' AND `close` != '1'");
            }

            $count = $req->fetchColumn();
           // echo '<div class="phdr"><a href="index.php"><b>' . _t('Forum') . '</b></a> | ' . sprintf(_t('All for period %d hours'), $vr) . '</div>';

            // Форма выбора периода времени
            echo '<div class="topmenu"><form action="index.php?&amp;do=period" method="post">' .
                '<input type="text" maxlength="3" name="vr" value="' . $vr . '" size="3"/>' .
                ' <input type="submit" name="submit" value="' . _t('Показать') . '"/>' .
                '</form></div>';


            if ($count) {
                if ($systemUser->rights == 9) {
                    $req = $db->query("SELECT * FROM `forum` WHERE `type`='t' AND `time` > '" . $vr1 . "' ORDER BY `time` DESC LIMIT 3");
                } else {
                    $req = $db->query("SELECT * FROM `forum` WHERE `type`='t' AND `time` > '" . $vr1 . "' AND `close` != '1' ORDER BY `time` DESC LIMIT 3");
                }

                for ($i = 0; $res = $req->fetch(); ++$i) {
                    echo $i % 2 ? '<div class="list2">' : '<div class="list1">';
                    $razd = $db->query("SELECT `id`, `refid`, `text` FROM `forum` WHERE `type`='r' AND `id`='" . $res['refid'] . "'")->fetch();
                    $frm = $db->query("SELECT `text` FROM `forum` WHERE `type`='f' AND `id`='" . $razd['refid'] . "'")->fetch();
                    $colmes = $db->query("SELECT * FROM `forum` WHERE `refid` = '" . $res['id'] . "' AND `type` = 'm'" . ($systemUser->rights >= 7 ? '' : " AND `close` != '1'") . " ORDER BY `time` DESC");
                    $colmes1 = $colmes->rowCount();
                    $cpg = ceil($colmes1 / $kmess);
                    $nick = $colmes->fetch();

                    if ($res['edit']) {
                        echo $tools->image('tz.gif');
                    } elseif ($res['close']) {
                        echo $tools->image('dl.gif');
                    } else {
                        echo $tools->image('np.gif');
                    }

                    if ($res['realid'] == 1) {
                        echo $tools->image('rate.gif');
                    }

                    echo '&#160;<a href="/forum/index.php?id=' . $res['id'] . ($cpg > 1 && $set_forum['upfp'] && $set_forum['postclip'] ? '&amp;clip' : '') . ($set_forum['upfp'] && $cpg > 1 ? '&amp;page=' . $cpg : '') . '">' . (empty($res['text']) ? '-----' : $res['text']) .
                        '</a>&#160;[' . $colmes1 . ']';
                    if ($cpg > 1) {
                        echo '<a href="/forum/index.php?id=' . $res['id'] . (!$set_forum['upfp'] && $set_forum['postclip'] ? '&amp;clip' : '') . ($set_forum['upfp'] ? '' : '&amp;page=' . $cpg) . '">&#160;&gt;&gt;</a>';
                    }

                    echo '<br /><div class="sub">' . $frm['text'] . '&#160;/<a href="/forum/index.php?id=' . $razd['id'] . '">&#160;' . $razd['text'] . '</a><br />';
                    echo $res['from'];

                    if ($colmes1 > 1) {
                        echo '&#160;/&#160;' . $nick['from'];
                    }

                    echo ' <span class="gray">' . $tools->displayDate($nick['time']) . '</span>';
                    echo '</div></div>';
                }
            } else {
                echo '<div class="rmenu"><p>' . _t('Новых тем за этот период нет') . '</p></div>';
            }