Board3

Code: Select all

<?php
//    error_reporting(0);
    define('IN_PHPBB', true);

include_once ('');            //Path to phpBB Config File. Due to some restrictions by PHP, you have to provide complete physical path
$urlPath = "";                //phpBB URL with respect to root
$topicnumber = 1;            //Total Post Count to Display
$posttext = 200;                //Number of Characters to display in Post Text
$completeurl = "";
$excludedforums = "6";        //Forum, in dem das betreffende Topic ist
$extopicid = 203; // Id des gewählten Topics

    $table_topics = $table_prefix. "topics";    //Usually you don't have to change below 4 variables
    $table_forums = $table_prefix. "forums";
    $table_posts = $table_prefix. "posts";
    $table_users = $table_prefix. "users";

function stripBBCode($text_to_search) {
     $pattern = '|[[\/\!]*?[^\[\]]*?]|si';
     $replace = '';
     return preg_replace($pattern, $replace, $text_to_search);
}


	
    $link = mysqli_connect("$dbhost", "$dbuser", "$dbpasswd") or die("Could not connect");
    mysqli_select_db("$dbname") or die("Could not select database");
    $sub_query = '';
    if(strlen($excludedforums) > 0) {
        $pieces = explode(",", $excludedforums);
        foreach ($pieces as $exforumid) {
        
$sub_query .= " t.forum_id = " . $exforumid . ' AND ';
$sub_query .= " p.topic_id = " . $extopicid . ' AND ';
            }
    }
  
    $query = "SELECT t.topic_id, t.topic_title, t.topic_last_post_id, t.forum_id, p.post_id, p.poster_id, p.post_time, u.user_id, u.username, f.forum_name, p.post_text, p.bbcode_uid, p.bbcode_bitfield, f.forum_desc_options
    FROM $table_topics t, $table_forums f, $table_posts p, $table_users u
    WHERE t.topic_id = p.topic_id AND
    f.forum_id = t.forum_id AND ";



    if(strlen($sub_query) > 0) {
        $query .=  $sub_query ;
    }

    $query .= " t.topic_status <> 2 AND
    p.post_id = t.topic_last_post_id AND
    p.poster_id = u.user_id
    ORDER BY p.post_id DESC LIMIT $topicnumber";
    //echo $query;
    $result = mysql_query($query) or die("Query failed" . mysql_error($link));

    print "<div class=\"typecontent\">";
    if($topicnumber % 2) {
        $x="even";
    } else {
        $x="odd";
    }
    $y=0;
 while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
    ++$y;
    if ($y==$topicnumber) {
        $x= $x .  " dataitemlast";
    }
print "<div class=\"dataitem $x \">
                <table class=\"plain\">
                    <tr>
                        <td class=\"data\">
                                <div class=\"itemheader\">".
						date('d.m.y H:i ', $row["post_time"])."                                     
                                </div>
                            <div class=\"entry\">" .
                                substr(stripBBCode($row["post_text"]),0,$posttext) . "
<br>von <a href=\"$completeurl/memberlist.php?mode=viewprofile&u=$row[user_id] \">".$row["username"]."</a>
                            </div>
                        </td>
                    </tr>
                </table>
                </div>";

                if ($x=="odd") {
                    $x="even";
                } else {
                    $x="odd";
                }

}
print "<div class=\"clear\"></div></div>";
    mysql_free_result($result);
//  mysql_close($link);
?>