laatste forum berichten
Geplaatst: 07 dec 2003, 22:47
Ik heb een aparte phpbb forum geinstalleerd.<?php
// Hier het pad naar je phpBB folder
$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;
}
// Diverse settings
$NUM_POSTS = 5; // Aantal laatste topics
$POST_IMAGE ="XP_NewFile.gif"; // Het plaatje naast het bericht
$TEXT_ON = FALSE; //Laat een gedeelte tekst zien uit de topic
$TEXT_LEN = 200; //maximum aantal letters als je hierboven "true" hebt gekozen
$HIDE = true;//true of false - als je kiest voor true, worden berichten uit bepaalde forums niet weergegeven - (optie hieronder)
$hide_level = 0;// display threshold 0=laat alleen berichten zien uit forums open voor gasten, 1= ook uit geregistreerd, 2=ook uit Moderators, 3=Laat alle posts zien, ook die uit forums voor admins only
$fontheadercolor="black";
$fontsize=1;
$fontcolor="#5695BA";
$fontsizetext=1;
echo"<body style=\"background-color: #EBEBF5\">";
$fontcolortext="#5695BA";
$fontheaderface="verdana";
$box_title = "<font size=\"$fontheadersize\" color=\"$fontheadercolor\" face=\"$fontheaderface\"><b></b></font>";
$box_content = "";
$time=time();
$time=date("d M Y h:i a",$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 sranangplazaforum_posts a1, sranangplazaforum_posts_text a2, sranangplazaforum_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 .="<marquee behavior=\"scroll\" direction=\"up\" height=\"200\" scrolldelay=\"100\" scrollamount=\"2\"> <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 sranangplazaforum_users WHERE user_id =" . $post["poster"]);
$author=mysql_fetch_array($result3);
$result4 = mysql_query("SELECT forum_name FROM sranangplazaforum_forums WHERE forum_id =" . $post["forum_id"]);
$forum=mysql_fetch_array($result4);
if(!$post["subject"]){
$result2=mysql_query("SELECT topic_title FROM sranangplazaforum_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 href=\"" . $phpbb_root_path . "viewtopic.php?t=" .$post["topic"] . "\" title=\"Geplaatst door:" . $author["username"]. " && In:" . $forum["forum_name"] . "\"> " . $post["subject"] . "</a><br> geplaatst op " . 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></marquee>";
}
print("<head>
<meta http-equiv=\"Refresh\"
content=\"1200;url=http://www.forum.sranangplaza.nl/script.php\"> </head>");
//Pas hierboven je url aan
print("<table width=\"200\"><tr><td>" . $box_title . "</td></tr><tr><td><font size=\"$fontsize\" color=\"$fontcolor\" face=\"$fontheaderface\">Laatste Updated $time</font></td></tr><tr><td>" . $box_content . "</td></tr></table>");
?>
Laatste 5 berichten uit de db halen is dit..
Nou wil ik laatste berichten scrollend hebben en dat ze in een
new window openen..
Hoe doe ik dat?
