phpBB.nl

Code: Selecteer alles

<?php
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);


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


/* To keep a forum secret (i.e. a mods only forum) find, AND t.forum_id != 1
   and change 1 to the forums id (according to your database). To select a specific forum (i.e. news forum)
   find AND t.forum_id != 1, and change it to t.forum_id = 1 (where 1 = the forums id) */
$sql = ("SELECT DISTINCT t.topic_id, t.topic_title, t.topic_replies, u.user_id, u.username, u.user_allowsmile, s.post_text, s.bbcode_uid
FROM " . POSTS_TABLE . " p, " . TOPICS_TABLE . " t, " . USERS_TABLE . " u, " . POSTS_TEXT_TABLE . " s
WHERE p.topic_id = t.topic_id AND t.topic_poster = u.user_id AND t.topic_first_post_id = s.post_id AND t.forum_id = 3 AND u.user_id != -1
ORDER BY p.post_time DESC LIMIT 1");

if ( !($result = $db->sql_query($sql)) )
{
	message_die(GENERAL_ERROR, "Could not obtain news.", '', __LINE__, __FILE__, $sql);
}

$postrow = array();
if ($row = $db->sql_fetchrow($result))
{
	do
	{
		$postrow[] = $row;
	}
	while ($row = $db->sql_fetchrow($result));
	$db->sql_freeresult($result);

	$total_posts = count($postrow);
}
else
{

   message_die(GENERAL_MESSAGE, $lang['No_posts_topic']);
}


//
// Start output of page
//
$page_title = $lang['Site_Index'];
include($phpbb_root_path . 'includes/page_header.'.$phpEx);

$template->set_filenames(array(
	'body' => 'site_index_body.tpl')
);

$template->assign_vars(array(
	'L_SUBJECT' => $lang['Subject'],
	'L_VIEW_TOPIC' => $lang['News_View_Topic'],
	'L_AUTHOR' => $lang['Author'],
	'L_NEWS' => $lang['News'])
);


//
// Okay, let's do the loop, yeah come on baby let's do the loop
// and it goes like this ...
//
for($i = 0; $i < $total_posts; $i++)
{
	$message = $postrow[$i]['post_text'];
	$bbcode_uid = $postrow[$i]['bbcode_uid'];
	$message = str_replace("\n", "\n<br />\n", $message);
	
	//
	// Note! The order used for parsing the message _is_ important, moving things around could break any
	// output
	//
	
	//
	// If the board has HTML off but the post has HTML
	// on then we process it, else leave it alone
	//
	if ( !$board_config['allow_html'] || !$userdata['user_allowhtml'])
	{
		if ( $postrow[$i]['enable_html'] )
		{
			$message = preg_replace('#(<)([\/]?.*?)(>)#is', "<\\2>", $message);
		}
	}
	
	//
	// Parse message and/or sig for BBCode if reqd
	//
	if ($bbcode_uid != '')
		{
			$message = ($board_config['allow_bbcode']) ? bbencode_second_pass($message, $bbcode_uid) : preg_replace("/\:$bbcode_uid/si", '', $message);
		}
	
	//
	// Parse smilies
	//
	if ( $board_config['allow_smilies'] )
	{		
		if ( $postrow[$i]['enable_smilies'] )
		{
			$message = smilies_pass($message);
		}
	}
	
	$template->assign_block_vars('newsrow', array(
		'NEWS_TITEL' => $postrow[$i]['topic_title'],
		'NEWS_MESSAGE' => $message,
		'U_NEWS_AUTHOR' => "profile.$phpEx?mode=viewprofile&u=" . $postrow[$i]['user_id'],
		'NEWS_AUTHOR' => $postrow[$i]['username'],
		'U_VIEW_TOPIC' => "viewtopic.php?t=" . $postrow[$i]['topic_id'])
	);
}

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

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

?>