phpBB.de

Code: Alles auswählen

$anzahlTopics = 5;   // Anzahl der Topics die angezeigt sollen

$queryString = "SELECT topic_id, topic_title, topic_last_post_id, forum_name, phpbb_forums.forum_id
  FROM phpbb_topics, phpbb_forums
  WHERE phpbb_topics.forum_id = phpbb_forums.forum_id AND
  phpbb_topics.forum_id !=4 AND
  phpbb_topics.forum_id !=21 AND
  phpbb_topics.forum_id !=20
  GROUP  BY topic_id
  ORDER  BY topic_last_post_id  DESC
  LIMIT $anzahlTopics";

$result = mysql_query($queryString);
$today = time();

while($resultArray = mysql_fetch_array($result))
{
if(strlen($resultArray[topic_title]) > 25) //Titel kürzen, falls länger als 25 Zeichen
{
$resultArray[topic_title] = substr($resultArray[topic_title],0,22)." ..";

}
echo"   <tr> \n";
echo"     <td><a href=\"/forum/viewtopic.php?t=$resultArray[topic_id]#$resultArray[topic_last_post_id]\">$resultArray[topic_title]</a>&nbsp;&nbsp;</td>\n";
echo"     <td><a href=\"/forum/viewforum.php?f=$resultArray[forum_id]\">$resultArray[forum_name]</a>&nbsp;&nbsp;</td>\n";
echo"   </tr>";
}
echo "</table>";

Code: Alles auswählen

  phpbb_topics.forum_id !=4 AND
  phpbb_topics.forum_id !=21 AND
  phpbb_topics.forum_id !=20