phpBB.nl

Code: Selecteer alles

<? 

$absolutPath = "phpBB2/config.php"; 
$urlPath    = "http://www.flashtweax.sonnexh.com/newsite"; 
$limit      = "10"; 

include_once("$absolutPath"); 
$db = @mysql_connect("$dbhost", "$dbuser", "$dbpasswd") or die("Problem!?"); 
@mysql_select_db("$dbname",$db) or die("No available?"); 

$sql = "SELECT t.topic_title, t.topic_time, u.username, t.topic_id, f.forum_id 
        FROM topics t, forums f, users u WHERE t.topic_poster = u.user_id AND f.forum_id = t.forum_id AND f.forum_type != '1' 
        ORDER BY topic_time DESC LIMIT $limit"; 

if ($r = mysql_query($sql, $db)) { 
   echo "<table width=\"50%\">"; 
   echo "<tr><td><b>Recent Topics:</b></td></tr>"; 
   while($m = mysql_fetch_array($r)) { 
      $j = stripslashes($m[topic_title]); 
      if ($shortsubj) $k = substr($j, 0, 20) . "..."; else $k = $j; 
         echo "<tr><td><a href=\"$urlPath/viewtopic.php?topic=$m[topic_id]&forum=$m[forum_id]\">$k</a></td>"; 
         echo "<td> ( ".$m["topic_time"]." )</td>"; 
         echo "<td>  by ".$m["username"]."</td></tr>"; 
      } 
   echo "</table>"; 
   } 

?>