openside("Ostatnio na forum");



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

      <tr>

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

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

<td align='center' width='70'><b>ostatni<br>post napisal</td>

<td align='center' width='150'><b>Napisano o</td>

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

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

</tr>

";

$con = mysql_connect('WPISZ HOST', 'NAZWA USERA', 'HASLO') or die(mysql_error());

mysql_select_db('videoaudio') or die(mysql_error());

$limit='12'; // ilość wyświetlanych tematów

$strAdr='http://www.videoaudio.pl/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.forum_id, f.name 

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 ) . '.';



}

echo'<tr><td>'.trimlink($row['name'], 25).'</td>

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

<td align="center">'.$row['last_poster_name'].'</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);