Pour ceux qui veulent améliorer ce code.
c'est un code de dernier message du forum phpbb à mettre dans votre site ou une page html ou dans un portail.
<?php
if (eregi("blok.php", $_SERVER['PHP_SELF'])) {
die ("You cannot open this page directly");
}
global $user, $bgcolor3, $bgcolor2, $nuked, $language;
include("modules/Forums/language/lang_french/lang_main.php");
$sql2=mysql_query("SELECT active FROM $nuked[prefix]"._block." WHERE module='Forums'");
list($active) = mysql_fetch_array($sql2);
echo" <div align=right><img src=images/akhirfor.gif><table border=\"0\" width=\"98%\" cellspacing=\"1\">";
$sql5 = "SELECT forum_id, topic_id, topic_title, topic_last_post_id FROM phpbb_topics ORDER BY topic_last_post_id DESC LIMIT 10";
$req5=mysql_query($sql5);
while ($row4 = mysql_fetch_array($req5)) {
$forum_id = $row4[forum_id];
$topic_id = $row4[topic_id];
$topic_title = $row4[topic_title];
$topic_last_post_id = $row4[topic_last_post_id];
$sql = "SELECT * FROM phpbb_posts WHERE post_id='$topic_last_post_id'";
$req = mysql_query($sql);
$row = mysql_fetch_array($req);
$poster_id = $row[poster_id];
$post_time = strftime("%d/%m/%y %H:%M", $row[post_time]);
$sql4 = "SELECT username FROM phpbb_users WHERE user_id='$poster_id'";
$req4=mysql_query($sql4);
$row3 = mysql_fetch_array($req4);
$auteur = $row3[username];
$sql3 = "SELECT auth_view, auth_read FROM phpbb_forums WHERE forum_id='$forum_id'";
$req3=mysql_query($sql3);
$row2 = mysql_fetch_array($req3);
$auth_view = $row2[auth_view];
$auth_read = $row2[auth_read];
$tmpcnt++ % 2 == 1 ? $color = "#DAECD0" : $color = "#FFFFFF";
if (($auth_view != 2) OR ($auth_read != 2)) {
echo" <TR style=\"background: $color;\"><td width=1 bgcolor=#44AA00></td><TD> <a href=\"index.php?abk=Forums&stoune=viewtopic&t=$topic_id\"><b>$topic_title</b></a><br>
<small>Par <a href=\"index.php?abk=Forums&stoune=profile&mode=viewprofile&u=$poster_id\">$auteur</a> "._THE." $post_time</small></font></b></a></td><td width=1 bgcolor=#44AA00></td></tr>";
}
}
echo"<tr height=1 bgcolor=#44AA00 border=0><td></td><td></td><td></td></tr></table></div>";
?>