openside("Ostatnie na forum");



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

      <tr bgcolor='000000'>

<td align='center' width='170'><font color='#fffff'><b>Dzia³</td>

<td align='center' width='260'><font color='#fffff'><b>Temat Posta</td>

<td align='center' width='70'><font color='#fffff'><b>Ostatnia odpowied¼</td>

<td align='center' width='150'><font color='#fffff'><b>Czas ostatniej odpowiedzi</td>

<td align='center' width='40'><font color='#fffff'><b>Postów</td>

<td align='center' width='40'><font color='#fffff'><b>Ods³on</td>

</tr>

";

$con = mysql_connect('HOST', 'USER', 'PASS') or die(mysql_error());

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

$limit='13';

$strAdr='LINK DO 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.'');

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

$strT=$row['title'];

if (strlen($strT)>30)

{

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



}

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

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

<td><a href="'.$strAdr.'/index.php?index.php&showtopic='.$row['tid'].'&view=findpost" onMouseover="" onMouseout="">'.trimlink($strT, 40).'</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>';

} 

}



echo"</table>";

closeside();

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