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

// вывод на главную форума и библиотеки 
function LastNotes($switch = 'F', $lmt = 5) {
    if ($switch == 'F' && intval($lmt) > 0) {
        $sql = "SELECT id, text FROM forum WHERE type = 't' ORDER BY time DESC LIMIT $lmt";
    } elseif ($switch == 'L' && intval($lmt) > 0) {
        $sql = "SELECT id, name, count_views, count_comments FROM library_texts 
            WHERE premod = 1 ORDER BY time DESC LIMIT $lmt";
    } else {
        return false;
    }
    $res = mysql_query($sql) or die (mysql_error());
    $out = ''; $i = 0;
    while ($row = mysql_fetch_assoc($res)) {
        if ($switch == 'F') {
            $out .= ($i % 2 ? '<div class="news">' : '<div class="news">') .
                '<a href="/forum/?id='. $row['id'] .'">'. $row['text'] .'</a></div>';
        } elseif ($switch == 'L') {
            $color_views = ($row['count_views'] > 0 ? 'green' : 'red');
            $color_comments = ($row['count_comments'] > 0 ? 'green' : 'red');
            $out .= ($i % 2 ? '<div class="news">' : '<div class="news">') .
                '<a href="/library/?id='. $row['id'] .'">'. $row['name'] .'</a>' . 
                $row['count_comments'] .'</span></div></div>';
        }
        $i++;
    }
    return $out;
}