phpBB.de

Code: Alles auswählen

<?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);
include($phpbb_root_path . 'includes/cms_auth.'.$phpEx);
include($phpbb_root_path . 'includes/cms_functions.'.$phpEx);
include($phpbb_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_cms.'.$phpEx);

get_cms_config();

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

//
// Parameters
//
$start = ( isset($HTTP_POST_VARS['start']) ) ? intval($HTTP_POST_VARS['start']) : ( ( isset($HTTP_GET_VARS['start']) ) ? intval($HTTP_GET_VARS['start']) : 0 );
$mode = ( isset($HTTP_POST_VARS['mode']) ) ? htmlspecialchars($HTTP_POST_VARS['mode']) : ( ( isset($HTTP_GET_VARS['mode']) ) ? htmlspecialchars($HTTP_GET_VARS['mode']) : '' );
$article_id = ( isset($HTTP_POST_VARS['aid']) ) ? intval($HTTP_POST_VARS['aid']) : ( ( isset($HTTP_GET_VARS['aid']) ) ? intval($HTTP_GET_VARS['aid']) : 0 );
$chapter_id = ( isset($HTTP_POST_VARS['cid']) ) ? intval($HTTP_POST_VARS['cid']) : ( ( isset($HTTP_GET_VARS['cid']) ) ? intval($HTTP_GET_VARS['cid']) : 0 );


// Set vars to prevent naughtiness
$home = array();

//
// Load the appropriate home file
//

	$lang_file = 'lang_main';
	$l_title = $lang['Home'];

include($phpbb_root_path . 'language/lang_' . $board_config['default_lang'] . '/' . $lang_file . '.' . $phpEx);

//
// Lets build a page ...
//

$page_title = $l_title;
include($phpbb_root_path . 'includes/page_header.'.$phpEx);

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

$template->assign_vars(array(
	'L_ARTICLES' => $lang['Articles'],
	'L_AUTHOR' => $lang['Author'],
	'L_CHAPTER' => $lang['Chapter'],
	'L_COMMENTS' => $lang['Comments'],
	'L_RATING' => $lang['Rating'],
	'L_VIEWS' => $lang['Views'],
	'L_NO_ARTICLES' => $lang['No_articles'],
	'L_TIME' => $lang['Time'],

	'CHAPTER_NAME' => $chapter_info['chapter_name'],
	'CHAPTER_DESC' => $chapter_info['chapter_desc'],

	'U_VIEW_CHAPTER' => append_sid("cms_articles.$phpEx?cid=" . $chapter_info['chapter_id']),

	'S_AUTH_CAN' => $s_auth_can
	)
);

if( !$chapter_id )
{
	$template->assign_block_vars('showchapter', array());

	$sql = "SELECT * FROM " . CMS_CHAPTERS_TABLE . " ORDER BY chapter_id";
	if( !$result = $db->sql_query($sql) )
	{
		message_die(GENERAL_ERROR, 'Could not retrieve chapter information', '', __LINE__, __FILE__, $sql);
	}

	$chapter_data = array();
	while( $row = $db->sql_fetchrow($result) )
	{
		$chapter_data[] = $row;
	}

	$db->sql_freeresult($result);

	$is_auth_ary = array();
	$is_auth_ary = cms_auth(AUTH_LIST_ALL, $userdata);

	$chapter_sql = '';
	for( $i = 0; $i < count($chapter_data); $i++ )
	{
		$this_chapter_id = $chapter_data[$i]['chapter_id'];
		if( $is_auth_ary[$this_chapter_id]['a_view'] && $is_auth_ary[$this_chapter_id]['a_read'] )
		{
			$chapter_sql .= ( ( $chapter_sql != '' ) ? ', ' : '' ) . $this_chapter_id;
		}
	}

	if( $chapter_sql != '' )
	{
		$pending_sql = ( $userdata['user_level'] == ADMIN ) ? '' : 'AND a.article_pending = 0';
		$sql = "SELECT a.*, at.*, c.chapter_name, u.username
				FROM " . CMS_ARTICLES_TABLE . " a, " . CMS_ARTICLES_TEXT_TABLE . " at, " . CMS_CHAPTERS_TABLE . " c, " . USERS_TABLE . " u
				WHERE at.article_id = a.article_id
					AND u.user_id = a.user_id
					AND c.chapter_id = a.chapter_id
					AND c.chapter_id IN ($chapter_sql)
					$pending_sql
				ORDER BY time DESC
				LIMIT 0, " . $cms_config['articles_on_list'];
		if( !$result = $db->sql_query($sql) )
		{
			message_die(GENERAL_ERROR, 'Could not retrieve most recent articles information', '', __LINE__, __FILE__, $sql);
		}

		$article_row = array();
		while( $row = $db->sql_fetchrow($result) )
		{
			$article_row[] = $row;
		}

		$db->sql_freeresult($result);
	}
}
else
{
	if( !$is_auth['a_view'] && !$is_auth['a_read'] )
	{
		message_die(GENERAL_MESSAGE, 'No_such_chapter_id');
	}

	//
	// Fetch the articles
	//
	$pending_sql = ( $userdata['user_level'] == ADMIN ) ? '' : 'AND article_pending = 0';
	$sql = "SELECT COUNT(*) AS total
			FROM " . CMS_ARTICLES_TABLE . "
			WHERE chapter_id = $chapter_id
				$pending_sql";
	if( !$result = $db->sql_query($sql) )
	{
		message_die(GENERAL_ERROR, 'Could not retrieve articles total information', '', __LINE__, __FILE__, $sql);
	}
	$row = $db->sql_fetchrow($result);
	$db->sql_freeresult($result);

	$total_articles = $row['total'];

	$pagination = '';
	if( $total_articles > 0 )
	{
		$template->assign_vars(array(
			'PAGINATION' => generate_pagination("cms_articles.$phpEx?cid=$chapter_id", $total_articles, $cms_config['articles_per_page'], $start),
			'PAGE_NUMBER' => sprintf($lang['Page_of'], ( floor( $start / intval($cms_config['articles_per_page']) ) + 1 ), ceil( $total_articles / intval($cms_config['articles_per_page']) ))
			)
		);
	}
	else
	{
		$template->assign_block_vars('switch_no_articles', array());
	}


	$pending_sql = ( $userdata['user_level'] == ADMIN ) ? '' : 'AND a.article_pending = 0';
	$sql = "SELECT a.*, at.* , u.username
			FROM " . CMS_ARTICLES_TABLE . " a, " . CMS_ARTICLES_TEXT_TABLE . " at, " . USERS_TABLE . " u
			WHERE a.chapter_id = $chapter_id
				AND at.article_id = a.article_id
				AND u.user_id = a.user_id
				$pending_sql
			ORDER BY time DESC
			LIMIT $start, " . $cms_config['articles_per_page'];
	if( !$result = $db->sql_query($sql) )
	{
		message_die(GENERAL_ERROR, 'Could not retrieve articles information', '', __LINE__, __FILE__, $sql);
	}

	$article_row = array();
	while( $row = $db->sql_fetchrow($result) )
	{
		$article_row[] = $row;
	}

	$db->sql_freeresult($result);
}


for( $i = 0; $i < count($article_row); $i++ )
{
	$row_class = ( $i % 2 ) ? $theme['td_class1'] : $theme['td_class2'];
	$row_color = ( $i % 2 ) ? $theme['td_color1'] : $theme['td_color2'];

	$article_title = $article_row[$i]['article_title'];
	if ( count($orig_word) )
	{
		$article_title = preg_replace($orig_word, $replacement_word, $article_title);
	}

	$article_icon = '';
	for( $j = 0; $j < count($icon_row); $j++ )
	{
		if( $icon_row[$j]['icon_id'] == $article_row[$i]['article_icon'] )
		{
			$article_icon = '<img src="' . $cms_config['icons_path'] . '/' . $icon_row[$j]['icon_href'] . '" width="19" height="19" alt="" border="0" hspace="3" />';
		}
	}

	//
	// Set the username
	// If user is anonymous and has a username, set it as well
	//
	$s_author = ( $article_row[$i]['user_id'] == ANONYMOUS ) ? $lang['Guest'] : '<a href="' . append_sid("profile.$phpEx?mode=viewprofile&u=" . $article_row[$i]['user_id']) . '">' . $article_row[$i]['username'] . '</a>';
	if( $article_row[$i]['user_id'] == ANONYMOUS )
	{
		if( $article_row[$i]['article_username'] != '' )
		{
			$s_author = ( count($orig_word) ) ? preg_replace($orig_word, $replacement_word, $article_row[$i]['article_username']) : $article_row[$i]['article_username'];
		}
	}


	$template->assign_block_vars('articlerow', array(
		'ROW_CLASS' => $row_class,
		'ROW_COLOR' => '#' . $row_color,

		'ARTICLE_TITLE' => $article_title,
		'ARTICLE_VIEWS' => intval($article_row[$i]['article_views']),
		'ARTICLE_COMMENTS' => intval($article_row[$i]['article_comments']),
		'ARTICLE_ICON' => $article_icon,
		'ARTICLE_RATING' => calc_rating('article', $article_row[$i]['article_id'], true),
		'POST_TIME' => create_date($board_config['default_dateformat'], $article_row[$i]['time'], $board_config['board_timezone']),

		'U_VIEW_ARTICLE' => append_sid("cms_view_article.$phpEx?aid=" . $article_row[$i]['article_id']),

		'S_AUTHOR' => $s_author
		)
	);

	if( !$chapter_id )
	{
		$template->assign_block_vars('articlerow.showchapter', array(
			'CHAPTER_NAME' => $article_row[$i]['chapter_name'],

			'U_VIEW_CHAPTER' => append_sid("cms_articles.$phpEx?cid=" . $article_row[$i]['chapter_id'])
			)
		);
	}
}



make_jumpbox('viewforum.'.$phpEx);

include($phpbb_root_path .'recent.'.$phpEx);
$template->pparse('body');
include($phpbb_root_path . 'includes/page_tail.'.$phpEx);

?>