phpBB.de

Code: Alles auswählen

phpbb_

Code: Alles auswählen

Warning: file_exist()[function.file-exist]:open_basedir restriction in effect. File(/cache) is not within the allowed path(s): (/www/htdocs/xxxxxxxxx/) in /www/htdocs/xxxxx/phpBB2/attach_mod/attachment on line 100

Code: Alles auswählen

// ---------------------------------------------------------
// FETCH LATEST POSTINGS
// ---------------------------------------------------------
$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, a1.post_id AS postID, 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");

$box_content  = "<TABLE BORDER='0' WIDTH='100%' CELLPADDING='0' CELLSPACING='0'>";

if($resultxx)
	{
	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);
			$profileURL = $board_path."profile.php?mode=viewprofile&u=".$post["poster"];
			$result2    = mysql_query("SELECT topic_replies, topic_title FROM phpbb_topics WHERE topic_id =" . $post["topic"]);
			$topic      = mysql_fetch_array($result2);
			$replies    = $topic['topic_replies'];
			$topicTitle = $topic['topic_title'];
			
			
			$topicDate = date("G:i", $post["time"]);
			
			// FROM TODAY?
			if (date("m:d",$post["time"]) == date("m:d",time()))
				{
				$topicDate .= " ".$todayText;
				}
			
			$post["subject"] = $topicTitle;

			// NO REPLIES - NEW THREAD
			if(intval($replies) == 0)
				{ $post["subject"] = "<IMG SRC=\"$TOPIC_IMAGE \" BORDER='0'><B>$topicText</B> " . $post["subject"]; }
			// IS A REPLY
			else 	{ $post["subject"] = "<IMG SRC=\"$POST_IMAGE \" BORDER='0'><B>$answerText</B> " . $post["subject"]; }

			mysql_free_result($result2);

			if($TEXT_ON)
				{
				$post["text"] = replacebbcode($post["text"]);
				$post["text"] = substr($post["text"],0,$TEXT_LEN)."...";
				$tooltip = " onMouseover='EnterContent(\"<B>&raquo;</B> ".$post["text"]." <B>&laquo;</B>\"); Activate();' onMouseout='deActivate()' ";
				}
			else	{ $tooltip = ""; }
			
			$box_content .= "\n\n<TR>";
			$box_content .= "\n<TD CLASS='CONTENT' ALIGN='LEFT' WIDTH='70%' NOWRAP='NOWRAP'>\n&nbsp;<A HREF='" . $board_path . "/viewtopic.php?t=" .$post["topic"] . "' TARGET = '_blank' ".$tooltip."></B>" . $post["subject"] . "</B></A></TD>";
			$box_content .= "\n<TD CLASS='CONTENT' ALIGN='LEFT' WIDTH='20%' NOWRAP='NOWRAP'>\n<IMG SRC='$PROFILE_IMAGE' BORDER='0'>&nbsp;<A HREF='".$profileURL."' TARGET='_blank'><B>".$author["username"]."</B></A>&nbsp;</TD>";
			$box_content .= "\n<TD CLASS='CONTENT' ALIGN='LEFT' WIDTH='10%' NOWRAP='NOWRAP'>\n".$topicDate."&nbsp;&nbsp;</TD>";
			$box_content .= "\n</TR>";
			}
		}
	}

$box_content .="</TABLE>";

Code: Alles auswählen

// ---------------------------------------------------------
// SETTINGS
// ---------------------------------------------------------
$refresh_interval   = 300;	// REFRESH INTERVAL IN SECONDS (60 = EVERY MINUTE, ETC...)
$show_members	    = false; 	// DISPLAY NUMBER OF MEMBERS
$show_total_topics  = true;	// DISPLAY TOPIC AND POST COUNT
$show_post_previews = true;	// DISPLAY POST TEXT TOOLTIPS
$post_preview_length= 250;	// LENGTH OF POST PREVIEWS (CHARS)
$phpBB_table_prefix = "phpbb_"; // CUSTOMIZE THIS TO YOUR NEEDS