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

AlkatraZ, А я прочитал, и сразу вопросы возникли

// $req = $db->query("SELECT * FROM `news` ORDER BY `time` DESC LIMIT ${start}, " . $user->config->kmess);
    $req = $db->query("SELECT n.*, t.post_count FROM `news` n LEFT JOIN `forum_topic` t ON t.id=n.kom ORDER BY n.`time` DESC LIMIT ${start}, " . $user->config->kmess);

    echo $view->render('news::index', [
        'pagination' => $tools->displayPagination('?', $start, $total, $user->config->kmess),
        'total'      => $total,
        'list'       =>
            function () use ($req, $tools/*, $db*/) {// а $db на кой хрен тут? 0_0
                while ($res = $req->fetch()) {
                    $text = $tools->checkout($res['text'], 1, 1);
                    $res['text'] = $tools->smilies($text, 1);

                    if (! empty($res['kom'])) {
                        //$res_mes = $db->query("SELECT * FROM `forum_topic` WHERE `id` = '" . $res['kom'] . "'");                    
                        if ($res['post_count']/*$mes = $res_mes->fetch()*/) {
                            $res['kom_count'] = $res['post_count'] - 1;
                        } else {
                            $res['kom_count'] = 0;
                        }
                    }

                    yield $res;
                }
            },
    ]);