Код выводит n последних тем форума на главную

Для JohnCMS

                        
<?php

$lim_top = 'n'; //n/Меняем на нужное число выводимых тем

$req = mysql_query("SELECT * FROM `forum` where type='t' ORDER BY time DESC LIMIT $lim_top"); 

$i = 0; 

while ($res = mysql_fetch_array($req)){ 

    $nikuser = mysql_query("SELECT `from` FROM `forum` WHERE `type` = 'm' AND `close` != '1' AND `refid` = '" . $res['id'] . "' ORDER BY `time` DESC LIMIT 1"); 

    $nam = mysql_fetch_assoc($nikuser); 

    $colmes = mysql_query("SELECT COUNT(*) FROM `forum` WHERE `type`='m' AND `refid`='" . $res['id'] . "'" . ($rights >= 7 ? '' : " AND `close` != '1'")); 

    $colmes1 = mysql_result($colmes, 0); 

    // Значки 

    $icons = array( 

        ($np ? (!$res['vip'] ? '<img src="../theme/' . $set_user['skin'] . '/images/op.gif" alt=""/>' : '') : '<img src="../theme/' . $set_user['skin'] . '/images/np.gif" alt=""/>'), 

        ($res['vip'] ? '<img src="../theme/' . $set_user['skin'] . '/images/pt.gif" alt=""/>' : ''), 

        ($res['realid'] ? '<img src="../theme/' . $set_user['skin'] . '/images/rate.gif" alt=""/>' : ''), 

        ($res['edit'] ? '<img src="../theme/' . $set_user['skin'] . '/images/tz.gif" alt=""/>' : '') 

    ); 

echo is_integer($i / 2) ? '<div class="list1"><div>' : '<div class="list2"><div>'; 

  echo functions::display_menu($icons, '&#160;', '&#160;'); 

    echo '<a href="forum/index.php?id='.$res['id'].'">'.$res['text'].'</a> ['.$colmes1.']'; 

    echo '<div class="sub">'; 

    echo $res['from']; 

    if (!empty($nam['from'])) { 

        echo '&#160;/&#160;' . $nam['from']; 

    } 

    echo ' <span class="gray">(' . functions::display_date($res['time']) . ')</span></div></div>'; 

    echo'</div>'; 

    ++$i; 

}

?>