phpBB.de

Code: Alles auswählen

##############################################################
## Mod Name:			view_recent_posts_v1_0_3.txt
## Mod Date:			2002-06-07
## Mod Title:			View Recent Posts
## Mod Version:			1.0.3
## for phpBB Version:	2.0.1
## Author:				Matthias C. Hormann <matthias@hormann-online.net>
## Description:			This mod allows viewing recent posts directly from
##						the index page. It introduces a new 'View Posts
##						from previous <selection>' on the main page,
##						directly below the 'View unanswered posts' link.
##						The selection box has the standard search selections
##						(1 day/1 week/2 weeks/1 month/3months/6 month/1 year)
##						and defaults to '1 day'.
##
##						Results are shown as a search-like topic list.
##						If you really want, you can also follow the 'OR'
##						REPLACE in 'templates/subSilver/index_body.tpl' to
##						get results displayed as posts, but personally I
##						don't like it since it's non-standard and doesn't
##						really help if your user wants an overview.
##
##						Guests can also use it (no need to be logged in).
##						The mod will honor all board restrictions, i.e.,
##						no hidden forums/topics will be shown if permissions
##						are insufficient (uses the 'search' logic).
##
##						This mod was requested by users that are not online
##						so very often and just want to easily check what has
##						happened recently.
##
## Installation Level:	Easy
## Installation Time:	5 Minutes
##
## Files To Edit:		3 (4)
##						index.php
##
##	The following need to be modified for every TEMPLATE you are using:
## 						templates/subSilver/index_body.tpl
##
##	The following need to be modified for every LANGUAGE you are supporting:
## 						language/lang_english/lang_main.php
## 						language/lang_german/lang_main.php
##
## Included Files:		(n/a)
##############################################################

##############################################################

##############################################################
## Author Note: 
## ------------
## 
## o This mod is EasyMod v0.4alpha compatible.
## o Best viewed when your editor's tab size is set to 4.
##
##
## Change Log:
## -----------
##
## o v1.0.3
##   - Sorry! Forgot including template vars - now works!
##     Kudos to 'bitboy0' of phpBB2-users.de for pointing
##     this out to me :-)
## o v1.0.2
##   - Initial release to the public.
##   - Includes English as well as German language mod.
## o v1.0.0
##   - Initial release for internal testing.
##
##############################################################

##############################################################
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD
##############################################################

#
#-----[ OPEN ]------------------------------------------
#
index.php
#
#-----[ FIND ]------------------------------------------
#
	//
	// Start output of page
#
#-----[ BEFORE, ADD ]------------------------------------------
#
	//
	// MOD: View Recent Posts v1.0.3
	//
	$previous_days = array(1, 7, 14, 30, 90, 180, 364);
	$previous_days_text = array($lang['1_Day'], $lang['7_Days'], $lang['2_Weeks'], $lang['1_Month'], $lang['3_Months'], $lang['6_Months'], $lang['1_Year']);
	
	$s_time = '';
	for($i = 0; $i < count($previous_days); $i++)
	{
		$selected = ( $topic_days == $previous_days[$i] ) ? ' selected="selected"' : '';
		$s_time .= '<option value="' . $previous_days[$i] . '"' . $selected . '>' . $previous_days_text[$i] . '</option>';
	}
	//
	// MOD: -END-
	//

#
#-----[ FIND ]------------------------------------------
#
		'L_ONLINE_EXPLAIN' => $lang['Online_explain'], 
#
#-----[ AFTER, ADD ]------------------------------------------
#
		//
		// MOD: View Recent Posts v1.0.3
		//
		'L_SEARCH_TIME' => $lang['View_posts_of_last'],
		'L_GO' => $lang['Go'],
		'S_SEARCH_ACTION' => append_sid("search.$phpEx?mode=results&search_author=*"),
		'S_TIME_OPTIONS' => $s_time,
		//
		// MOD: -END-
		//
#
#-----[ OPEN ]------------------------------------------
#
# The following need to be modified for every TEMPLATE you are using:
#
templates/subSilver/index_body.tpl
#
#-----[ FIND ]------------------------------------------
#
		<a href="{U_SEARCH_UNANSWERED}" class="gensmall">{L_SEARCH_UNANSWERED}</a></td>
#
#-----[ REPLACE WITH ]------------------------------------------
#
# Show results as a forum/topic list (recommended)
#
		<!-- MOD: View Recent Posts v1.0.3 -->
		<a href="{U_SEARCH_UNANSWERED}" class="gensmall">{L_SEARCH_UNANSWERED}</a><br />
		<span class="gensmall"><form action="{S_SEARCH_ACTION}" method="POST">{L_SEARCH_TIME}&nbsp;<select class="gensmall" name="search_time">{S_TIME_OPTIONS}</select>&nbsp;<input type="submit" class="gensmall" value="{L_GO}" name="submit" /><input type="hidden" name="show_results" value="topics"><input type="hidden" name="sort_by" value="0"><input type="hidden" name="sort_dir" value="DESC"></form>
		</td>
		<!-- MOD: -END- -->
#
#-----[ OR ]------------------------------------------
#
# Show results as a list of single posts (not recommended)
#
		<!-- MOD: View Recent Posts v1.0.3 -->
		<a href="{U_SEARCH_UNANSWERED}" class="gensmall">{L_SEARCH_UNANSWERED}</a><br />
		<span class="gensmall"><form action="{S_SEARCH_ACTION}" method="POST">{L_SEARCH_TIME}&nbsp;<select class="gensmall" name="search_time">{S_TIME_OPTIONS}</select>&nbsp;<input type="submit" class="gensmall" value="{L_GO}" name="submit" /><input type="hidden" name="show_results" value="posts"><input type="hidden" name="sort_by" value="0"><input type="hidden" name="sort_dir" value="DESC"></form>
		</td>
		<!-- MOD: -END- -->
#
#-----[ OPEN ]------------------------------------------
#
# The following need to be modified for every LANGUAGE you are supporting:
# (ENGLISH)
#
language/lang_english/lang_main.php
#
#-----[ FIND ]------------------------------------------
#
$lang['7_Days'] = '7 Days';
#
#-----[ REPLACE WITH ]------------------------------------------
#
# Replace '7 days' with '1 week' -- it's more easy understandable at a glance ;-)
#
$lang['7_Days'] = '1 Week';
#
#-----[ FIND ]------------------------------------------
#
//
// That's all Folks!
#
#-----[ BEFORE, ADD ]------------------------------------------
#
//
// MOD: View Recent Posts v1.0.3
//
$lang['View_posts_of_last'] = 'View posts from previous';
//
// MOD: -END-
//

#
#-----[ OPEN ]------------------------------------------
#
# The following need to be modified for every LANGUAGE you are supporting:
# (GERMAN)
#
language/lang_german/lang_main.php
#
#-----[ FIND ]------------------------------------------
#
$lang['7_Days'] = '7 Tage';
#
#-----[ REPLACE WITH ]------------------------------------------
#
# Replace '7 days' with '1 week' -- it's more easy understandable at a glance ;-)
#
$lang['7_Days'] = '1 Woche';
#
#-----[ FIND ]------------------------------------------
#
//
// That's all Folks!
#
#-----[ BEFORE, ADD ]------------------------------------------
#
//
// MOD: View Recent Posts v1.0.3
//
$lang['View_posts_of_last'] = 'Beiträge anzeigen, die neuer sind als';
//
// MOD: -END-
//

#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
#
# EoM

Code: Alles auswählen

#
#------[ FINDE ]------------------
#
				$sql = "SELECT post_id 
					FROM " . POSTS_TABLE . "
					WHERE poster_id IN ($matching_userids)";

#
#------[ MIT FOLGENDEM ERSETZEN ]------------------
#
# ForenIDs eintragen

				$sql = "SELECT p.post_id FROM ". POSTS_TABLE ." p, ". TOPICS_TABLE ." t
					WHERE p.poster_id IN ($matching_userids) AND t.topic_id = p.topic_id AND t.forum_id NOT IN(1,2,3)";