phpBB.nl

Code: Selecteer alles

 <?php include "last.php"; ?> 

Code: Selecteer alles

<?PHP

// adjust this to your needs
$CFG['db_host']            = '**********';
$CFG['db_user']            = '**********';
$CFG['db_pass']            = '**********';
$CFG['db_name']            = '**********';

$CFG['font_face']	   = 'Arial';
$CFG['font_size']	   = '2';

$CFG['number_of_posts']    = '5';
$CFG['phpbb_table_prefix'] = 'phpbb_';
$CFG['phpBB_folder']	   = './forum/'; //Here you have to put de root map of the forum.

// ignore forums (indicated by the forum number)
// you can put between '' a number of the forum you want to ignore)
//$IGNORE[0] = '4';
//$IGNORE[1] = '7';
//$IGNORE[2] = '9';

define('IN_PHPBB',true);
include_once ($CFG['phpBB_folder'] . 'extension.inc');

$DB = '';
$postspp = '';
$phpEx = 'php';

function phpbb_news() {
    global $CFG, $DB, $IGNORE, $postspp; 

    // connect the DB
    $DB = mysql_connect($CFG['db_host'], $CFG['db_user'], $CFG['db_pass']);
    if (!$DB) {
        die('Unable to connect to database.');
    }
    mysql_select_db($CFG['db_name']) or die('Unable to select database');

	// get number of posts per page
	$sql = 'SELECT config_value FROM ' . $CFG['phpbb_table_prefix'] . 'config WHERE config_name = \'posts_per_page\'';

	$query = mysql_query($sql, $DB);
	$row = mysql_fetch_row($query);
	$postspp = $row[0];

	// this is the SQL statement
    // in the WHERE clause I had to add a time limit
    // due to some corrupt posting times in my forum
    $sql = 'SELECT
              p.post_time,
              t.topic_title,
			  t.topic_id,
			  f.forum_name,
			  f.forum_id,
			  t.topic_replies
            FROM
              ' . $CFG['phpbb_table_prefix'] . 'topics AS t,
              ' . $CFG['phpbb_table_prefix'] . 'forums AS f,
              ' . $CFG['phpbb_table_prefix'] . 'posts AS p
            WHERE
			  t.forum_id = f.forum_id AND
			  #f.auth_read = ' . '0' .' AND
			  p.post_id = t.topic_last_post_id ';

	for ($i = 0; $i < count($IGNORE); $i++) {
		$sql .= 'AND t.forum_id <> ' . $IGNORE[$i] . ' ';
	}

	$sql .= 'ORDER BY
              t.topic_last_post_id DESC
            LIMIT
              0,' . $CFG['number_of_posts'];

    $query = mysql_query($sql, $DB);

    // fetch the result
    $i = 0;
    while ($row = mysql_fetch_row($query)) {
        // you can refer to theses elements later
        $post[$i]['topic_time']    = $row[0];
        $post[$i]['topic_title']   = $row[1];
        $post[$i]['topic_id']      = $row[2];
        $post[$i]['forum_name']    = $row[3];
        $post[$i]['forum_id']      = $row[4];
        $post[$i]['numposts']      = $row[5];
        $post[$i]['date']          = date('d.m', $post[$i]['topic_time']);
        $post[$i]['time']          = date('H:i', $post[$i]['topic_time']);

        $i++;
    }

	return $post;
}

?>
<table width="100%" border="0" cellpadding="0" cellspacing="0">

<?php

$news = phpbb_news();

for ($i = 0; $i < count($news); $i++) {

?>
<tr>
<td width="80" align="left" valign="top">

<?PHP 
	$font_face = $CFG['font_face'];
	$font_size = $CFG['font_size'];
	echo("<font face=\"$font_face\" size=\"$font_size\">");
	echo($news[$i]['date']);
	echo(" ");
	echo($news[$i]['time']);
	echo("</font>");
?></td>
<td width="160" align="left" valign="top">

<?PHP
	$forum_id = $CFG['phpBB_folder'] . "viewforum." . $phpEx . "?f=" . $news[$i]['forum_id'];
	echo("<font face=\"$font_face\" size=\"$font_size\">");
	echo("<a href=\"$forum_id\" target=_blank>");
	echo($news[$i]['forum_name']);
	echo("</a>");
	echo("</font>");
?></td>
<td align="left" valign="top">

<?PHP
	$topic_id = $CFG['phpBB_folder'] . "viewtopic." . $phpEx . "?t=" . $news[$i]['topic_id'];
	$start = $news[$i]['numposts'] - ($news[$i]['numposts'] % $postspp);

	if ($start != 0) {
		$topic_id .= "&start=$start";
	}

	echo("<font face=\"$font_face\" size=\"$font_size\">");
	echo("<a href=\"$topic_id\" target=_blank>");
	echo($news[$i]['topic_title']);
	echo("</a>");
	echo("</font>");
?></td>
</tr>

<?PHP

}

?>
</table>