phpBB.nl

Code: Selecteer alles

<?php 
error_reporting(E_ALL); 
include("http://www.domein.nl/pad/config.php"); 

$limit = 5; //aantal topics 
$letters = 20; //aantal letters voor strip 
$forumpath = "http://www.domein.nl/pad/"; 


function strippen($c,$letters){ 
    if(strlen($c) > $letters){ 
        $kort = substr($c, 0, $letters); 
        $laatste_spatie = strrpos($kort, ' '); 
        $kort = substr($kort, 0, $laatste_spatie); 
        $c = $kort.'...'; 
        return $c; 
    } 
    else{ 
        return $c; 
    } 
} 

$hostname = "localhost"; 
$user = "gebruiker"; 
$password = "wachtwoord"; 
$database = "databees"; 

mysql_connect($hostname, $user, $password) or die ("Kan geen verbinding maken met de host"); 
mysql_select_db($database) or die ("Kan de database niet openen"); 

$query = "SELECT topic_id,topic_title FROM phpbb_topics WHERE topic_status != 1 ORDER BY topic_last_post_id DESC LIMIT 0,".$limit; 

$res = mysql_query($query) or die(mysql_error()); 

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

   $topic_titel = strippen(stripslashes($data["topic_title"]), $letters); 
           
    echo "&nbsp; &raquo; <a href=\"".$forumpath."viewtopic.php?t=".$data["topic_id"]."\" title=\"Forum topic :: ".$data["topic_title"]."\" onmouseover=\"window.status='Forum topic :: ".addslashes($data["topic_title"])."';return true\" target=\"_blank\">".$topic_titel."</a><br>"; 

} 
?>