phpBB.de

Code: Alles auswählen

$lang['Newest_user'] = '..

Code: Alles auswählen

$lang['Last_post'] = 'Letzter Beitrag in %s von %s am %s.';

Code: Alles auswählen

{NEWEST_USER}

Code: Alles auswählen

<br />{LAST_POST}

Code: Alles auswählen

	$template->assign_vars(array(
		'TOTAL_POSTS' => sprintf($l_total_post_s, $total_posts),

Code: Alles auswählen

	$sql2 = "SELECT p.*, u.user_id, u.username, t.topic_title
                        FROM ".POSTS_TABLE." p, ".USERS_TABLE." u, ".TOPICS_TABLE." t
                        WHERE p.poster_id = u.user_id AND p.topic_id = t.topic_id
                        ORDER BY post_time DESC LIMIT 1"; 
	if ( !($result2 = $db->sql_query($sql2)) ) 
	{ 
                        message_die(GENERAL_ERROR, 'Error getting lastpost.', '', __LINE__, __FILE__, $sql); 
	} 
	$row2 = $db->sql_fetchrow($result2); 
	$poster = $row2['username'];
	$post_time = create_date($board_config['default_dateformat'], $row2['post_time'], $board_config['board_timezone']);
	$topictitle = '<a href="'.append_sid("viewtopic.$phpEx?" . POST_POST_URL . "=".$row2['post_id']."#".$row2['post_id']."").'">'.$row2['topic_title'].'</a>';
	$lastpost = ( $row2['post_id'] ) ? sprintf($lang['Last_post'], $topictitle, $poster, $post_time) : ''; 

	$template->assign_vars(array(
		'LAST_POST' => $lastpost,
		'TOTAL_POSTS' => sprintf($l_total_post_s, $total_posts),