łap:
Kod
<BODY topmargin=0 leftmargin=0>
<table width=400 height=152 border=0 cellspacing=0 cellpadding=2 bordercolor=black style='border-style: solid; border-width: 1;'>
<tr bgcolor=navy><tH width=210 align=left><font size=2 face=verdana color=white>Ostatni aktywny temat:</tH>
<tH width=95 align=right><CENTER><font size=2 face=verdana color=white>Ostatni post:</CENTER></TH>
<tH width=95 align=right><CENTER><font size=2 face=verdana color=white>Czas:</CENTER></tH></tr>
<?
$link=mysql_connect("mysql", "login", "haslo");
mysql_select_db("nazwa bazy danych");
$query = "select tid, last_poster_name, last_post, forum_id, title, last_poster_id from _ipb_topics ORDER BY last_post DESC LIMIT 8;";
$result = mysql_query($query);
while ($row = mysql_fetch_object($result)) {
$Atytul=$row->title;
$Aforumid=$row->forum_id;
$Alastposter=$row->last_poster_name;
$Atid=$row->tid;
$Alp=$row->last_post;
$Aczas=date("G:i - d.m",$Alp);
$Adl=strlen($Atytul);
if($Adl>40){ $Atytul=substr($Atytul, 0, 37); $Atytul=$Atytul.'...'; }
$Adl=strlen($Alastposter);
if($Adl>12){$Alastposter=substr($Alastposter, 0, 12); $Alastposter=$Alastposter.'...';}
echo "<tr><td width=250><font size=1 face=verdana color=black>";
echo '<a href="forum/index.php?act=ST&f='.$Aforumid.'&t='.$Atid.'&view=getlastpost" target=_blank>'.$Atytul.'</a>';
echo "</font></td><tH width=110 align=right><font size=1 face=verdana color=black>$Alastposter</TH><TH width=80 align=right><font size=1 face=verdana color=black>";
echo "$Aczas<br>";
echo "</TH></TR>";
}
echo"</table>";
mysql_free_result($result);
mysql_close($link);
?>
a skrypt wyglada tak:
http://iglu.cz/g4_forum/newpost.php