Das Problem ist aber, dass ich die Latest Posts von einer anderen (auch meine) Domaine auf dieser Website sehen möchte; der Script schreibt aber "Cannot query database" (weiter unten auf meine Hauptseite), obwohl ich für beide Domainen die gleiche Datenbank habe.
Den Script habe ich zusammen gebastelt!
Wer kann mir bitte helfen!
<?php
###############################################
## Compatibility: 2.0.4 - 2.0.6
##
## Installation Level: Very, very easy!
## Installation Time: 30 seconds
##
## desktop.php
## post.gif
##
##
###############################################
## Externer Ort:
## <hr width="600" size="1" align="center" color="#666666">
## <p align="center"><font size="2"><?php include("desktop.php"); ?></font></p>
## <hr width="600" size="1" align="center" color="#666666">
##
###############################################
## nameforum_ (SQL) & Variabel (phpBB) ersetzen!
## ROOT/desktop.php
## ROOT/images/post.gif
## Hochladen!
###############################################
$phpbb_root_path = '../phpBB/'; //edit this to your phpBB root path
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 = 3;
$POST_IMAGE ="images/post.gif"; // icon next to each item
$TEXT_ON = true; //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="1";
$fontheadercolor="black";
$fontsize=1;
$fontcolor="#5695BA";
$fontsizetext=1;
$fontcolortext="#5695BA";
$fontheaderface="verdana";
$box_title = "<font size=\"$fontheadersize\" color=\"$fontheadercolor\" face=\"$fontheaderface\"><b> Die aktuellen Themen in <a href=\"http://www.xy.xy\"> ... Forum</a>: </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 nameforum_phpbb_posts a1, nameforum_phpbb_posts_text a2, nameforum_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 nameforum_phpbb_users WHERE user_id =" . $post["poster"]);
$author=mysql_fetch_array($result3);
$result4 = mysql_query("SELECT forum_name FROM nameforum_phpbb_forums WHERE forum_id =" . $post["forum_id"]);
$forum=mysql_fetch_array($result4);
if(!$post["subject"]){
$result2=mysql_query("SELECT topic_title FROM nameforum_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 href=\"" . $phpbb_root_path . "viewtopic.php?t=" .$post["topic"] . "\" title=\"Posted by: " . $author["username"]. " In: " . $forum["forum_name"] . "\"> " . $post["subject"] . "</a> on " . date("l, 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>
</head>");
print("<table width=\"75%\"><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>");
?>
