Public feed #377015

Anonymous

public text v1 · immutable
Raw Edit
·published 2007-03-01 11:36 UTC
rendered paste body
<?php
require("config.inc.php");
//////////////////////////////////////////////// LAST X FORUM POSTS
print("<table width=97% id=torrenttable border=1><tr>".
"<td class=tabletitle align=center border=1 cellspacing=0 cellpadding=5><b>Unsere letzten 5 Foren Posts</b></td>".
"</tr>");
print("</table>");
print("<table width=97% id=torrenttable border=1><tr>".
"<td class=tablecat align=left>Topic Titel</td>".
"<td class=tablecat align=center>Hits</td>".
"<td class=tablecat align=center>Ersteller</td>".
"<td class=tablecat align=left>erstellt am</td>".
"</tr>");

$res = mysql_query("SELECT * FROM bb1_threads ORDER BY starttime DESCLIMIT 5");

while ($postsx = mysql_fetch_assoc($res))
{

print("<tr><td class=tablea><br />in <a href=\"forums.php?action=viewforum&forumid={$postsx["threadid"]}\">{$postsx["topic"]}</a></td>".
"<td class=tableb align=center>{$postsx["views"]}</td>".
"<td class=tablea align=center><a href=userdetails.php?id=><b>{$postsx["lastposter"]}</b></a></td>".
"<td class=tableb align=center>{$postsx["starttime"]}</td></tr>");

}
print("</table>");


///////////////////////////////////////////////// END LAST X FORUM POSTS
//Last 10 Topics Test
?>