Cmxmods.net - phpBB 2.0.x - Scripts

This script, once run, will display every post made by a user in chronological order. There is support for bbCode and smilies upon display. Post information such as the time (in board default timezone) is displayed, as well as the post subject if specified.

Script: Copy into Notepad, and save as post_output.php.

<?php
// Post Output
// http://www.cmxmods.net/v2/scripts/post_output/ (C) July 2007

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

$userdata = session_pagestart($user_ip, PAGE_PROFILE);
init_userprefs($userdata);

if( $userdata['user_level'] != ADMIN )
{
	message_die(GENERAL_ERROR, 'You must be logged in as an administrator to view this page');
}

$user_id = intval($_GET['u']);

echo '<div style="font-family: verdana; font-size: 10pt">';

$sql = "SELECT * FROM " . POSTS_TABLE . " WHERE poster_id = $user_id";
$result = $db->sql_query($sql);

$p = 1;

while( $row = $db->sql_fetchrow($result) )
	{
		$post = "SELECT * FROM " . POSTS_TEXT_TABLE . " WHERE post_id = " . $row['post_id'];
		if( !($post_result = $db->sql_query($post)) )
		{
			message_die(GENERAL_ERROR, 'Cannot display post text');
		}
		
		$post_row = $db->sql_fetchrow($post_result);
		
		echo '<b>#' . $p . ')</b> Posted: ' . create_date($board_config['default_dateformat'], $row['post_time'], $board_config['board_timezone']) . '    Subject: ' . $post_row['post_subject'] . '<br /><br />';
		echo smilies_pass(bbencode_second_pass($post_row['post_text'], $post_row['bbcode_uid']));
		echo '<br /><br /><hr><br />';
		$p++;
	}
	
echo '</div>';
?>

Instructions: Upload the script using FTP, to your forum root folder (the folder with index.php, viewforum.php, etc). Log in as an administrator, and direct yourself (by typing in the browser address bar) to /post_output.php?u=X. Replace u=X with the user_id number of the user whose posts you wish to obtain. For instance, suppose the user_id is 34, you would direct yourself to /post_output.php?u=34. Delete the script once you have finished with it.