Ik heb het Destop (last_topic) script toegepast.
Maar wil dat als je op de topics klikt je ook uitkomt op het nieuwe antwoord en niet aan het begin van het topic.
Ik heb al het e.e.a. geprobeerd uit merge.php te halen, maar dat lukte me niet. (en wat vergeleken met viewtopic.php)
Waar moet ik zoeken??
Code: Selecteer alles
<?php
// phpBB Desktop
// By Dave Atkins
//
// http://www.tech-forum.co.uk
// Version 1.0 Feb 18 2003
$phpbb_root_path = './'; //edit this to your phpBB root path
define('IN_PHPBB', true);
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);
Function replacebbcode($text){
$text = eregi_replace("\[b:.{0,10}\]", "<b>", $text);
$text = eregi_replace("\[\/b:.{0,10}\]", "</b>", $text);
$text = eregi_replace("\[u:.{0,10}\]", "<u>", $text);
$text = eregi_replace("\[\/u:.{0,10}\]", "</u>", $text);
$text = eregi_replace("\[i:.{0,10}\]", "<i>", $text);
$text = eregi_replace("\[\/i:.{0,10}\]", "</i>", $text);
$text = eregi_replace("\[url=http:.{1,80}\]"," ",$text);
$text = eregi_replace("\[\/url\]"," ",$text);
$text = eregi_replace("\[url\]"," ",$text);
$text = eregi_replace("\[.{1,10}:.{1,10}\]"," ",$text);
$text = eregi_replace("\[\/.{1,10}:.{1,10}\]"," ",$text);
$text = eregi_replace("\[\/.{1,20}\]"," ",$text);
$text = eregi_replace("\[.{1,20}\]"," ",$text);
Return $text;
}
// various attributes - experiment!
$NUM_POSTS = 80;
$POST_IMAGE ="XP_NewFile.gif"; // icon next to each item
$TEXT_ON = FALSE; //display some of the text of the post?
$TEXT_LEN = 200; //number of chars if above is true
$HIDE = true;//true or false - if true, do not show posts from certain forums - see below
$hide_level = 0;// display threshold 0=only show posts in forums open for guest reading,1= also registered, 2=also Mods only 3=show ALL posts even those froums for admins only
$fontheadersize="2";
$fontheadercolor="black";
$fontsize=1;
$fontcolor="#5695BA";
$fontsizetext=1;
$fontcolortext="#5695BA";
$fontheaderface="verdana";
$box_title = "<font size=\"$fontheadersize\" color=\"$fontheadercolor\" face=\"$fontheaderface\"><b> The Latest Posts in the Forums</b></font>";
$box_content = "";
$time=time();
$time=date("d M Y H:i ",$time);
$sqlxx="SELECT a1.post_id AS postid, a1.poster_id AS poster, a1.forum_id, a1.topic_id AS topic, a1.post_time AS time, a2.post_subject AS subject, a2.post_text AS text FROM phpbb_posts a1, phpbb_posts_text a2, phpbb_forums a3 WHERE a1.post_id = a2.post_id AND a1.forum_id = a3.forum_id";
if($HIDE) $sqlxx .= " AND a3.auth_view <= \"" . $hide_level . "\"";
$sqlxx .= " ORDER BY a1.post_time DESC";
$resultxx = mysql_query($sqlxx) or die("Cannot query database");
if($resultxx){
$box_content .="<table cellpadding=\"0\" cellspacing = \"0\" width= \"100%\" border=\"0\">";
for($i=0;$i<$NUM_POSTS;$i++){
if($post = mysql_fetch_array($resultxx)){
$result3=mysql_query("SELECT username FROM phpbb_users WHERE user_id =" . $post["poster"]);
$author=mysql_fetch_array($result3);
$result4 = mysql_query("SELECT forum_name FROM phpbb_forums WHERE forum_id =" . $post["forum_id"]);
$forum=mysql_fetch_array($result4);
if(!$post["subject"]){
$result2=mysql_query("SELECT topic_title FROM phpbb_topics WHERE topic_id =" . $post["topic"]);
$replyto = mysql_fetch_array($result2);
$post["subject"]="RE: " . $replyto["topic_title"];
mysql_free_result($result2);
}
$box_content .="<tr><td ><font size=\"$fontsize\" color=\"$fontcolor\" face=\"$fontheaderface\"><img src=\"$POST_IMAGE \" width=\"10\" height=\"15\" ><a target='_top' href=\"" . $phpbb_root_path . "viewtopic.php?t=" .$post["topic"] . "\" title=\"Posted by:" . $author["username"]. " In:" . $forum["forum_name"] . "\"> " . $post["subject"] . "</a><br> on " . date("d-m-y ", $post["time"]) . " @ " . date("H:i", $post["time"]) . "</font></td></tr>";
if($TEXT_ON){
$post["text"] = replacebbcode($post["text"]);
$post["text"] = substr($post["text"],0,$TEXT_LEN);
$box_content .= "<tr><td cellpadding=\"0\"> <font color=\"$fontcolortext\" size=\"$fontsizetext\" face=\"$fontheaderface\">" . $post["text"] . "...</font></td></tr>";
}
}
}
$box_content .="</table>";
}
print('<head>
<META NAME="REVISIT-AFTER" CONTENT="3 DAYS">
<meta http-equiv="refresh" content="59">
<link href="../style_dam.css" type="text/css" rel="STYLESHEET">
</head>');
print("<table width=\"250\"><tr><td>" . $box_title . "</td></tr><tr><td><font size=\"$fontsize\" color=\"$fontcolor\" face=\"$fontheaderface\">Last Updated $time</font></td></tr><tr><td>" . $box_content . "</td></tr></table>");
?>
, want google geeft maar één hit ...