Вывод на главную в JohnCMS v6.x.x

<?php

/*
-----------------------------------------------------------------
Последние темы на форуме
-----------------------------------------------------------------
*/
echo '<div class="phdr"><b>Последние 3 темы форума:</b></div>'; 
$req = mysql_query("SELECT * FROM `forum` WHERE `type`='t'" . ($rights >= 7 ? '' : " AND `close`!='1'") . " ORDER BY `time` DESC LIMIT 3 "); 
while (($res = mysql_fetch_assoc($req)) !== false) { 
  echo $i % 2 ? '<div class="list2">' : '<div class="list1">'; 
  $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); 
  $cpg = ceil($colmes1 / $kmess); 
  $np = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_forum_rdm` WHERE `time` >= '" . $res['time'] . "' AND `topic_id` = '" . $res['id'] . "' AND `user_id`='$user_id'"), 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 functions::display_menu($icons, '&#160;', '&#160;'); 
  echo '<a href="index.php?id=' . $res['id'] . '">' . $res['text'] . '</a> [' . $colmes1 . ']'; 
  if ($cpg > 1) { 
    echo '<a href="index.php?id=' . $res['id'] . '&amp;page=' . $cpg . '">&#160;&gt;&gt;</a>'; 
  } 
  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>'; 
  ++$i; 
}

<?php

/*
-----------------------------------------------------------------
Последние темы на форуме
-----------------------------------------------------------------
*/
$set_forum = $datauser['set_forum'] ? unserialize($datauser['set_forum']) : array();
$settings = $set['lastThemes'] ? unserialize($set['lastThemes']) : array('totalThemes' => 3, 'timeCache' => 30);

if ($settings['totalThemes'] > 0 && !$set_forum['viewThemes']) {
$themesOut = '';
$file_cache = ROOTPATH .'files/cache/lastThemes.dat';

# В этом запросе была ошибка - после оператора LIMIT небыло пробела
$sql = "SELECT * FROM `forum` WHERE `type`='t' ". ($rights >= 7 ? "" : " AND `close` !='1'") .
"ORDER BY `time` DESC LIMIT ". $settings['totalThemes'];

# А такое написание запроса помогло выявить эту ошибку
$req = mysql_query($sql) or die(mysql_error());

$i = 0;
while (($res = mysql_fetch_assoc($req)) !== false) {
if ($res['close']) $themesOut .= '<div class="rmenu">';
else $themesOut .= $i % 2 ? '<div class="sist2"><a href="forum/index.php?id='. $res['id'] .'&amp;page='. $endPage .'">'
: '<div class="sist1"><a href="forum/index.php?id='. $res['id'] .'&amp;page='. $endPage .'">';
$nickUser = mysql_fetch_assoc(mysql_query("SELECT `from` FROM `forum` WHERE `type`='m' AND `close` != '1' AND `refid`= '".
$res['id'] ."' ORDER BY `time` DESC LIMIT 1"));
$totalPosts = mysql_result(mysql_query("SELECT COUNT(*)FROM `forum` WHERE `type`='m' AND `refid`='". $res['id'] ."'".
($rights >= 7 ? '' : "AND `close`!='1'")), 0);
$endPage = ceil($totalPosts / $kmess);
$icons = array(
(!$res['vip'] ? '<img src="../theme/'. $set_user['skin'] .'/images/op.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=""/>' : '')
);

$themesOut .= functions::display_menu($icons, '&#160;', '&#160;') . $res['text'] .'['. $totalPosts .']';
$themesOut .= '<div class="sub">Автор: '. $res['from'];
if (!empty($nickUser['from']))
$themesOut .= '&#160;/&#160;Последний: '. $nickUser['from'];
$themesOut .= '<span class="gray">('. functions::display_date($res['time']) .')</span></a></div></div>';
$i++;
}

if ($settings['timeCache'] > 0 && time() < (filemtime($file_cache) + $settings['timeCache'])) {
echo file_get_contents($file_cache);
} else {
echo $themesOut;
if ($settings['timeCache'] > 0)
file_put_contents($file_cache, $themesOut);
}
}