echo"<table border='1' cellspacing='0' cellpadding='4' width='100%' class='tbl-border' >

<tr >

<td width='100%' colspan='6' align='center'><font color='#fffff'><b>Ostatnie tematy na forum</td>

</tr>

      <tr class='tbl2'>

<td align='center' width='170'><b>Dzia³</td>

<td align='center' width='250'><b>Temat Posta</td>

<td align='center' width='80'><b>Ostatnia odpowied¼</td>

<td align='center' width='150'><b>Czas odpowiedzi</td>

<td align='center' width='40'><b>Postów</td>

<td align='center' width='40'><b>Ods³on</td>

</tr>

";

$con = mysql_connect('HOST', 'USER-BAZY', 'HASLO') or die(mysql_error());

mysql_select_db('NAZWA-BAZY') or die(mysql_error());

$limit='13';

$strAdr='ADRES-FORUM'; //sciezka do forum(bez koncowego slasha);

$strPfx='ibf_';//prefix tabel Invision

$r=mysql_query('SELECT t.last_post, t.tid, t.title, t.views, t.posts, t.start_date, t.starter_name, t.last_poster_name, t.last_poster_id, t.approved, t.forum_id, f.name, f.id 

FROM '.$strPfx.'topics t

LEFT JOIN '.$strPfx.'forums f ON (t.forum_id = f.id)

GROUP BY t.title 

ORDER BY t.last_post DESC LIMIT 0,'.$limit.'');

$i=0;

while($row=mysql_fetch_array($r)){

$strT=$row['title'];

if (strlen($strT)>30)

{

$strT = substr( $strT, 0, 400 ) . '.';



}

if ($i % 2 == 0) { $row_color = "tbl1"; } else { $row_color = "tbl2"; }

if ($row['approved'] == 1) {



echo'<tr class="'.$row_color.'">



<td><a href="'.$strAdr.'/index.php?showforum='.$row['id'].'" >'.trimlink($row['name'], 35).'</font></a></td>

<td ><a href="'.$strAdr.'/index.php?index.php&showtopic='.$row['tid'].'&view=findpost">'.trimlink($strT, 35).'</a></td>

<td align="center"><a href="'.$strAdr.'/index.php?showuser='.$row['last_poster_id'].'">'.$row['last_poster_name'].'</a></td>

<td align="center">'.showdate("forumdate", $row['last_post']).'</td>

<td align="center">('.$row['posts'].')</td>

<td align="center">('.$row['views'].')</td></tr>';

} 

$i++;

}



echo"</table>";



dbconnect($db_host, $db_user, $db_pass, $db_name);