phpBB.de

Code: Alles auswählen

/**
* @ignore
*/
if (!defined('IN_PHPBB'))
{
	exit;
}

/* Configuration START */
$show = 10;			//Number of entries to show in list
$scrollbox = false;	// Show scollable list (about 5 entries high) instead of all entries
/* Configuration END */

include($phpbb_root_path . 'blog/functions.' . $phpEx);

$sql = 'SELECT b.blog_id, b.user_id, b.blog_time, b.blog_subject, u.username, u.user_colour 
	FROM '. BLOG_TABLE. ' AS b 
		LEFT JOIN '. USERS_TABLE. " AS u 
			ON b.user_id = u.user_id 
	WHERE b.blog_deleted != 1
	ORDER BY b.blog_time DESC"
$result = $db->sql_query_limit($sql, (int) $show);
while ($row = $db->sql_fetchrow($result))
{
	if(handle_user_blog_permissions($row['blog_id']))
	{
		$template->assign_block_vars('latest_blogs', array(
			'BLOG_SUBJECT'		=> censor_text($row['blog_subject']),
			'BLOG_AUTHOR'		=> get_username_string('username', $row['user_id'], $row['username'], $row['user_colour']),
			'BLOG_AUTHOR_COLOUR'=> get_username_string('colour', $row['user_id'], $row['username'], $row['user_colour']),
			'BLOG_AUTHOR_FULL'	=> get_username_string('full', $row['user_id'], $row['username'], $row['user_colour']),
			'BLOG_TIME'			=> $user->format_date($row['blog_time'], 'd.m.Y'),
			'U_VIEW_BLOG'		=> blog_url($row['user_id'], $row['blog_id'], false, array(), array('blog_subject' => censor_text($row['blog_subject']))),
			'S_SCROLL'			=> $scrollbox,
			));
	}
}
$db->sql_freeresult($result);

$template->assign_vars( array(
	'S_SCROLL_LATEST'			=> $scrollbox,
));