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

echo '<div class="phdr"> Последние темы форума</div>';
    $l = '5'; //// Количество тем 
    $req = $db->query("SELECT * FROM `forum` WHERE `type`='t' ORDER BY `time` DESC LIMIT $l "); // запрос 
    while($res = $req->fetch()){ 
        echo '<div class="list1">';
        $colmes = $db->query("SELECT `from`, `time` FROM `forum` WHERE `refid` = '" . $res['id'] . "' AND `type` = 'm'" . ($systemUser->rights >= 7 ? '' : " AND `close` != '1'") . " ORDER BY `time` DESC");
        $f = $db->query("SELECT COUNT(*) FROM `forum` WHERE `type`='m' AND `refid`='" . $res['id'] . "'" . ($rights >= 7 ? '' : " AND `close` != '1'"))->fetchColumn();
        $p = ceil($f / $kmess);
        $nick = $colmes->fetch();
        echo '<img src="https://img.icons8.com/color/2x/sony-vegas.png" width="20" height="20"><a href="/forum/?id='.$res['id'].'">'.$res['text'].'</a> ('.$f.')  ';
        echo '<img src="http://joxi.net/Vm6KK5xhj0wGM2.png" width="20" height="20">' . $nick['from'];
        if ($p > 1) {
            echo '</a> <a href="' . $config->homeurl . '/forum/index.php?id=' . $res['id'] . '&amp;page=' . $p . '">&#160;&gt;&gt;</a>';
        }
        echo '</div>';
    }