phpBB.de

Code: Alles auswählen

define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);
include($phpbb_root_path . 'includes/bbcode.'.$phpEx);
include($phpbb_root_path . 'includes/functions_post.'.$phpEx);

// Number of NEWS

$number_of_news ='10';

// Read NEWS Configuration from DB
define('NEWS', $table_prefix.'news');
define('NEWS_COMMENT', $table_prefix.'news_comment');

//
// Start session management
//
$userdata = session_pagestart($user_ip, PAGE_INDEX);
init_userprefs($userdata);
//
// End session management
//

// Start output of page
$template->set_filenames(array('body' => 'news_body.tpl'));

$page_title = $lang['News_portal'];
include($phpbb_root_path . 'includes/page_header.'.$phpEx);

function phpbb_fetch_news($number_of_news)
{

global $db, $board_config;

$sql = 'SELECT
		 news_id,
		 news_title,
		 news_user_id,
		 news_username,
		 news_user_ip,
		 news_user_email,
		 news_time,
		 news_view_count
		FROM
		 ' . NEWS . ' 
		ORDER BY
		 news_time';
	
	if ($number_of_news != 0)
	{
		$sql .= ' LIMIT ' . $number_of_news;
	}
	
	if(!($result = $db->sql_query($sql)))
	{
		message_die(GENERAL_ERROR, 'Could not query news information', '', __LINE__, __FILE__, $sql);
	}

	$news = array();
	if ($row = $db->sql_fetchrow($result))
	{	
		$i = 0;
		do
		{
		$news[$i]['news_id'] = $row['news_uid'];
		$news[$i]['news_title'] = $row['news_title'];
		$news[$i]['news_user_id'] = $row['news_user_id'];
		$news[$i]['news_username'] = $row['news_username'];
		$news[$i]['news_user_ip'] = $row['news_user_ip'];
		$news[$i]['news_user_email'] = $row['news_user_email'];		 
		$news[$i]['news_time'] = create_date($board_config['default_dateformat'], $row['news_time'], $board_config['board_timezone']);
		$news[$i]['news_view_count'] = $row['news_view_count'];		
		$i++;
		}
		while ($row = $db->sql_fetchrow($result));
	}
	return $news;
}

$fetchnews = phpbb_fetch_news($number_of_news);

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

	$template->assign_block_vars('news', array(
		'ID' => $fetchnews[$i]['news_id'],
		'TITLE' => $fetchnews[$i]['news_title'],
		'POSTER' => $fetchnews[$i]['news_username'],
		'TIME' => $fetchnews[$i]['news_time'],		
		)
	);

}

// Generate the page
$template->pparse('body');

include($phpbb_root_path . 'includes/page_tail.'.$phpEx);