программист сказал мод какой-то есть.
такой скрипт стоит:
<?php
/**************************************
*************** FORUM LAST TOPIC
***************************************/
//$res->page_content .= "<h1>FoRuM</h1>";
// $pref='triz_forum_eng_';
// $forum_link='
http://forum.ххххх.com/';
$pref='triz_forum_';
$forum_link='
http://rus.ххххх.com/forum/';
$sql = "SELECT t.topic_id,
t.topic_title,
t.topic_last_post_id,
t.forum_id,
t.topic_type,
t.topic_status,
p.post_id,
p.poster_id,
p.post_time,
pt.post_text,
u.user_id,
u.username,
u.user_lastvisit
FROM ".$pref."topics t,
".$pref."forums f,
".$pref."posts p,
".$pref."posts_text pt,
".$pref."users u
WHERE t.forum_id = 51
AND t.topic_id = p.topic_id
AND f.forum_id = t.forum_id
AND t.topic_status <> 2
AND p.post_id = t.topic_last_post_id
AND p.poster_id = u.user_id
AND pt.post_id = p.post_id
ORDER BY t.topic_last_post_id DESC
LIMIT 2";
$query=mysql_query($sql);
$total_topics = 0;
$topic_rowset = array();
while( $fetch = mysql_fetch_object($query)){
$topic_rowset[] = $fetch;
$total_topics++;
}
if( $total_topics ){
$res->page_content.='
<tr>
<td><img height="24" alt="" src="images/sin_ug.gif" width="6"/></td>
<td class="bg7" align="right"><img height="1" alt="" src="images/0.gif" width="217"/><br/>
<a href="
http://www.ххххх.com/forum.html"><span class="zag">LATEST TOPIC </span></a><br/>
</td>
</tr>
<tr>
<td colspan="2">
<div>
<table border="0" cellpadding="4" cellspacing="1" width="100%" class="forumline">
<tr>
<td>';
for($i = 0; $i < $total_topics; $i++){
$res->page_content.='
<a href="'.$forum_link.'viewtopic.php?t='.$topic_rowset[$i]->topic_id.'&default_lang=english">'.$topic_rowset[$i]->topic_title.'</a><br>
<span style="font:11px Tahoma; color:#475F6D;">'.substr(del_bb($topic_rowset[$i]->post_text), 0, 150).'... </span><a href="'.$forum_link.'viewtopic.php?default_lang=english&p='.$topic_rowset[$i]->post_id.'#'.$topic_rowset[$i]->post_id.'">read more »</a><br><br>';
}
$res->page_content.=' </td></tr>
</table>
</div>
</td>
</tr>
';
}
/**************************************
*************** FORUM LAST TOPIC END
***************************************/