phpBB.de

Code: Alles auswählen

<?php
//Beginn Forenausschnitt 
 echo" <table width=\"100%\">"; 
 echo"   <tr>"; 
 echo"     <th align=\"left\">Thema</th><th align=\"left\">Forum</th>\n"; //<th align=\"left\">Datum</th> 
 echo"   </tr>"; 
 $anzahlTopics = 5;   // Anzahl der Topics die angezeigt sollen 

 $queryString = "SELECT topic_id, topic_title, topic_last_post_id, forum_name, 2forum_forums.forum_id 
                 FROM 2forum_topics, 2forum_forums 
                 WHERE 2forum_topics.forum_id = 2forum_forums.forum_id AND 
                 2forum_topics.forum_id !=4 AND 
                 2forum_topics.forum_id !=21 AND 
                 2forum_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>"; 
 echo "<br>"; 
 echo "<br>"; 
//Ende Forenausschnitt
?>