Code: Selecteer alles
<?
$urlPath = "../../phpBB2"; //example: if your forum URL looks like http://kocky-online.cz/forum, this should be "/forum"
$serverPath = "../../phpBB2/config.php"; //example: when this file is in URL path /forum/mod, this should be ../config.php
if(empty($count))
$count = "10"; //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)
//-----------------[ DO NOT EDIT BELOW HERE ]-------------------------
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>";
}
}
//-------------------[ DO NOT EDIT UP HERE ]--------------------------
?><A href="blablabal">Re: Lukt het nog een beetje?...</A> (raadsel...)
De re: lukt het een beetje is de titel van de replay en raadsel is de topictitel.
Nou wil ik dat er komt te staan: <A href="blablabla">Re: raadsel</A> Dus Re: als het een reactie is, maar wel de titel van de topic.
Iemand enig idee hoe dit kan?