phpBB Guru - Официальная русская поддержка форума phpBB3

Код: Выделить всё

Hack Title:		Recent articles on ezPortal
##	Hack Version:	0.0.1
##	Author:			Freakin' Booty ;-P
##	Website:		http://www.freakingbooty.tk
##	Description:	This add-on for the ezPortal allows you to display phpBB easyCMS articles
##					in a block. Both static and scrolling blocks are available.
##	Compatibility:	2.0.3 - 2.0.6
##					phpBB easyCMS 1.0.0 or later
##					ezPortal 2.1.8
##
##	Installation Level: Easy
##	Installation Time: 5 - 10 minutes
##	Files To Edit: 4
##		fetchposts.php
##		portal.php
##		language/lang_english/lang_main.php
##		templates/subSilver/portal_body.tpl
##
##	Included Files: 0
##
##	History:
##		0.0.1:	Initial release
##
##	Author Notes:
##		None
##
##	Support:		http://www.phpbbhacks.com/forums
##	Copyright:		©2003 Recent articles on ezPortal 0.0.1 - Freakin' Booty ;-P
##
###############################################
##   You downloaded this hack from phpBBHacks.com, the #1 source for phpBB related downloads.
##   Please visit http://www.phpbbhacks.com/forums for support.
###############################################
##
###############################################
##	This hack is released under the GPL License.
##	This hack can be freely used, but not distributed, without permission.
##	Intellectual Property is retained by the hack author(s) listed above.
###############################################

#
#-----[ OPEN ]--------------------------------------------
#
fetchposts.php

#
#-----[ FIND ]--------------------------------------------
#
include_once($phpbb_root_path . 'includes/bbcode.'.$phpEx);

#
#-----[ AFTER, ADD ]--------------------------------------
#
include($phpbb_root_path . 'includes/cms_auth.'.$phpEx);

#
#-----[ FIND ]--------------------------------------------
#
?>

#
#-----[ BEFORE, ADD ]-------------------------------------
#
function phpbb_fetch_articles($num_articles)
{
	global $db, $userdata;

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

	//
	// First fetch the chapters, and see if the user has permission to view and read them
	//
	$sql = "SELECT chapter_id FROM " . CMS_CHAPTERS_TABLE;
	if( !$result = $db->sql_query($sql) )
	{
		message_die(GENERAL_ERROR, 'could not retrieve chapters information', '', __LINE__, __FILE__, $sql);
	}

	$chapter_id_sql = '';
	while( $row = $db->sql_fetchrow($result) )
	{
		$chapter_id = $row['chapter_id'];

		if( $is_auth[$chapter_id]['a_view'] && $is_auth[$chapter_id]['a_read'] )
		{
			$chapter_id_sql .= ( ( $chapter_id_sql != '' ) ? ',' : '' ) . $chapter_id;
		}
	}
	$db->sql_freeresult($result);

	//
	// Fetch the articles from the chapters the user has permission for
	//
	$article_row = array();
	if( $chapter_id_sql != '' )
	{
		$sql = "SELECT DISTINCT(a.article_id), a.user_id, a.article_username, a.time, at.article_title, u.username
				FROM " . CMS_ARTICLES_TABLE . " a, " . CMS_ARTICLES_TEXT_TABLE . " at, " . USERS_TABLE . " u
				WHERE a.article_pending = 0
					AND a.chapter_id IN ($chapter_id_sql)
					AND at.article_id = a.article_id
					AND u.user_id = a.user_id
				ORDER BY a.time DESC
				LIMIT 0, $num_articles";
		if( !$result = $db->sql_query($sql) )
		{
			message_die(GENERAL_ERROR, 'Could not retrieve articles information', '', __LINE__, __FILE__, $sql);
		}
		$article_row = $db->sql_fetchrowset($result);
		$db->sql_freeresult($result);
	}

	return $article_row;
}

#
#-----[ OPEN ]--------------------------------------------
#
portal.php

#
#-----[ FIND ]--------------------------------------------
#
// Poll Forum ID: separate by comma for multi-forums, eg. '3,8,14'
$CFG['poll_forum'] = '1';

#
#-----[ AFTER, ADD ]--------------------------------------
#
// Number of Recent Articles: change number according to how many you want displayed
$CFG['number_recent_articles'] = 10;

#
#-----[ FIND ]--------------------------------------------
#
//
// End session management
//

#
#-----[ AFTER, ADD ]--------------------------------------
#
//
// Define censored word matches
//
$orig_word = array();
$replacement_word = array();
obtain_word_list($orig_word, $replacement_word);

#
#-----[ FIND ]--------------------------------------------
#
	'L_VOTE_BUTTON' => $lang['Vote'],

#
#-----[ AFTER, ADD ]--------------------------------------
#
	'L_RECENT_ARTICLES' => $lang['Recent_articles'],

#
#-----[ FIND ]--------------------------------------------
#
//
// Generate the page
//

#
#-----[ BEFORE, ADD ]-------------------------------------
#
//
// Fetch recent articles
//
$article_row = phpbb_fetch_articles($CFG['number_recent_articles']);
for( $i = 0; $i < count($article_row); $i++ )
{
	$poster_id = $article_row[$i]['user_id'];

	$temp_url = append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . '=' . $poster_id);
	$poster = ( $poster_id != ANONYMOUS ) ? '<a href="' . $temp_url . '">' . $article_row[$i]['username'] . '</a>' : $lang['Guest'];

	if( $poster_id == ANONYMOUS && $article_row[$i]['article_username'] != '' )
	{
		$poster = ( count($orig_word) ) ? preg_replace($orig_word, $replacement_word, $article_row[$i]['article_username']) : $poster;
	}


	$template->assign_block_vars('recent_article_row', array(
		'U_ARTICLE_TITLE' => append_sid("cms_view_article.$phpEx?aid=" . $article_row[$i]['article_id']),

		'ARTICLE_TITLE' => ( count($orig_word) ) ? preg_replace($orig_word, $replacement_word, $article_row[$i]['article_title']) : $article_row[$i]['article_title'],
		'POSTER' => $poster,
		'POSTTIME' => create_date($board_config['default_dateformat'], $article_row[$i]['time'], $board_config['board_timezone'])
		)
	);
}

#
#-----[ OPEN ]--------------------------------------------
#
# Make sure to edit this file for every language installed
#
language/lang_english/lang_main.php

#
#-----[ FIND ]--------------------------------------------
#
$lang['Vote'] = 'Vote';
$lang['No_poll'] = 'No poll at the moment';

#
#-----[ AFTER, ADD ]--------------------------------------
#
$lang['Recent_articles'] = 'Recent articles';

#
#-----[ OPEN ]--------------------------------------------
#
# Make sure to edit this file for every template installed
#
templates/subSilver/portal_body.tpl

#
#-----[ FIND ]--------------------------------------------
#
			<td class="row1" align="left"><span class="gensmall">{TOTAL_USERS}<br />{NEWEST_USER}<br /><br/>{TOTAL_POSTS} {TOTAL_TOPICS}<br />&nbsp;</span></td>
		   </tr>
		  </table>

#
#-----[ AFTER, ADD ]--------------------------------------
#
# This is the static version
#
		  <br />

		  <table width="100%" cellpadding="2" cellspacing="1" border="0" class="forumline">
		  	<tr>
		  		<td class="catHead" height="25"><span class="genmed"><b>{L_RECENT_ARTICLES}</b></span></td>
		  	</tr>
		  	<tr>
		  		<td class="row1" align="left"><span class="gensmall">
					<!-- BEGIN recent_article_row -->
					&raquo; <a href="{recent_article_row.U_ARTICLE_TITLE}">{recent_article_row.ARTICLE_TITLE}</a><br />
					by {recent_article_row.POSTER} on {recent_article_row.POSTTIME}<br /><br />
					<!-- END recent_article_row -->
				</span></td>
			</tr>
		  </table>

#
#-----[ AFTER, ADD ]--------------------------------------
#
# This is the scrolling version
#
		  <br />

		  <table width="100%" cellpadding="2" cellspacing="1" border="0" class="forumline">
		  	<tr>
		  		<td class="catHead" height="25"><span class="genmed"><b>{L_RECENT_ARTICLES}</b></span></td>
		  	</tr>
		  	<tr>
		  		<td class="row1" align="left"><span class="gensmall">
					<marquee behavior="scroll" direction="up" height="200" scrolldelay="100" scrollamount="2">
						<!-- BEGIN recent_article_row -->
						&raquo; <a href="{recent_article_row.U_ARTICLE_TITLE}">{recent_article_row.ARTICLE_TITLE}</a><br />
						by {recent_article_row.POSTER} on {recent_article_row.POSTTIME}<br /><br />
						<!-- END recent_article_row -->
					</marquee>
				</span></td>
			</tr>
		  </table>

#
#-----[ SAVE & CLOSE ALL FILES ]--------------------------
#

Код: Выделить всё

#
#-----[ OPEN ]--------------------------------------------
#
includes/constants.php

#
#-----[ FIND ]--------------------------------------------
#
?>

#
#-----[ BEFORE, ADD ]-------------------------------------
#
//
// phpBB easyCMS
//
include($phpbb_root_path . 'includes/cms_constants.'.$phpEx);

Код: Выделить всё

// Length of article 
$CFG['article_length'] = '200'; // Adjust length of articles