Вывод на главную!

// Ссылка на загрузки
if ($set['mod_down'] || $rights >= 7)
    echo '<div class="mainmenu"><img src="/download/img/save.png" alt="" class="icon"/><b><a href="download/">' . $lng['downloads'] . '</a></b> (' . counters::downloads() . ')</div>';


 $sql = "SELECT * FROM `downfiles` 
    WHERE `type`='file' 
    ORDER BY RAND() DESC LIMIT 3";
$i = 0;
$res = mysql_query($sql);
while ($row = mysql_fetch_assoc($res)) {
    echo '<div class="list'. ($i & 1 ? 1 : 2) .'">'.
        '<img src="/images/op.gif" alt="" class="icon"/><a href="download/file.php?act=file&amp;view='. $row['id'] .'">'. str_replace('|', '', $row['name']) .'</a></div>';
    $i++;
}

$q = mysql_query("SELECT COUNT(*) FROM `forum` WHERE `type` = 'm' AND `close` != '1'");

$c = mysql_result($q, 0);

$num = rand(0, ($c - 1)); 

$post = mysql_query ("SELECT `user_id`,`id`,`from`, `time`, `text` FROM `forum` WHERE `type` = 'm' AND `close` != '1' LIMIT " . $num . ", 1;");

$post1 = mysql_fetch_array($post); 

echo '<img src="../files/photo/'.$post1['user_id'].'_small.jpg" width="32" height="32" alt="'. $post1['from']. '" />';

echo '<a href="../str/anketa.php?id='. $post1['user_id']. '">'. $post1['from']. '</a> ('. date("d.m.y H:i", $post1['time']). ')<br/>';

$text = $post1['text'];

$cut='50'; //количество символов поста на главную 

if (!isset ($set_forum) || empty ($set_forum))

$set_forum = array('farea' => 0, 'upfp' => 0, 'farea_w' => 20, 'farea_h' => 4, 'postclip' => 1, 'postcut' => 2);

if ($set_forum['postcut'] && mb_strlen($text) > $cut) {

$text = mb_substr($text, 0, $cut);

$text = checkout($text, 1, 0);

$text = preg_replace('#\[c\](.*?)\[/c\]#si', '<div class="quote">\1</div>', $text);

echo $text . '...<br /><a href="../forum/index.php?act=post&amp;id=' . $post1['id'] . '">Читать все &gt;&gt;</a>';

} else {

 

// Или, обрабатываем тэги и выводим весь тек 

$text = checkout($text, 1, 1);

if ($set_user['smileys'])

$text = smileys($text, $post1['rights'] ? 1 : 0);

echo $text;

}

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">';
        $f = $db->query("SELECT COUNT(*) FROM `forum` WHERE `type`='m' AND `refid`='" . $res['id'] . "'" . ($rights >= 7 ? '' : " AND `close` != '1'"))->fetchColumn();
        $p = ceil($f / $kmess);   
        echo '<a href="/forum/?id='.$res['id'].'">'.$res['text'].'</a> ('.$f.')';
        if ($p > 1) {
            echo ' <a href="' . $config->homeurl . '/forum/index.php?id=' . $res['id'] . '&amp;page=' . $p . '">&#160;&gt;&gt;</a>';
        }
        echo '</div>';
    }

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>';
    }