phpBB.nl

Code: Selecteer alles

<? 
$urlPath = "/Forum";	//example: if your forum URL looks like http://kocky-online.cz/forum, this should be "/forum"
$serverPath = "/Forum/config.php";			//example: when this file is in URL path /forum/mod, this should be ../config.php
if(empty($count))
	$count = "3";									//default value of how many posts/topics to show
if(empty($type))
	$type = "posts";		//default value of whether to show 'posts' or 'topics' 
$titleLimit = 30;			//this is max.length of 'title' of topic/post
$moreLimit = 20;			//this is max.length of 'more' (used in posts)

include_once("$serverPath"); 
$db = @mysql_connect("$dbhost", "$dbuser", "$dbpasswd") or die("here we die at connection"); 
@mysql_select_db("$dbname",$db) or die("here we die"); 

if($type == "posts") 
{
	$prefix = 'p';
   $sql = "SELECT x.post_subject as title, p.post_id as id, f.forum_id, t.topic_title as more "
   		."FROM ${table_prefix}topics t, ${table_prefix}forums f, ${table_prefix}posts p, ${table_prefix}posts_text x "
   		."WHERE t.topic_id = p.topic_id AND f.forum_id = t.forum_id AND p.post_id = x.post_id "
   		."ORDER BY p.post_id DESC "
   		."LIMIT $count"; 
}
else 
{
	$prefix = 't';
   $sql = "SELECT t.topic_title as title, t.topic_id as id, f.forum_id, '' as more "
   		."FROM ${table_prefix}topics t, ${table_prefix}forums f "
   		."WHERE f.forum_id = t.forum_id "
   		."ORDER BY topic_time DESC "
   		."LIMIT $count"; 
}

//echo $sql;

if($r = mysql_query($sql, $db)) { 
	while($m = mysql_fetch_array($r)) { 
		$j = stripslashes($m[title]); 
		$k = substr($j, 0, $titleLimit) . "..."; 
		if(!empty($m[more]))
			$m[more] = '('.substr($m[more], 0, $moreLimit) . '...)'; 
		if ($type == 'posts') {
			$anchor = '#'.$m[id];
		}
		//-------------------[ THIS IS ONLY LINE YOU COULD CHANGE ]--------------------------
		echo "<a title=\"$m[title]\" href=\"$urlPath/viewtopic.php?${prefix}=$m[id]&sid=$m[forum_id]${anchor}\">$k</a> $m[more]<br>"; 
	} 
} 

?>