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

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

			if ($row['forum_password_last_post'] === '' && $auth->acl_get('f_read', $row['forum_id_last_post']))
			{
				$sql2 = 'SELECT t.*, p.post_id
					FROM ' . TOPICS_TABLE . ' AS t, ' . POSTS_TABLE . ' AS p, ' . FORUMS_TABLE . " AS f
					WHERE t.forum_id = f.forum_id
						AND p.post_id = t.topic_first_post_id
					ORDER BY t.topic_last_post_id DESC";
				$result2 = $db->sql_query_limit($sql2, 1);	
				$recent_topics2 = $db->sql_fetchrowset($result2);	
				$topic_title2 = $recent_topics2[0]['topic_title'];
				$last_post_subject = $topic_title2.'*'.censor_text($row['forum_last_post_subject']);

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

	/**
	* Event to modify the SQL query before the forum data is queried
	*
	* @event core.display_forums_modify_sql
	* @var	array	sql_ary		The SQL array to get the data of the forums
	* @since 3.1.0-a1
	*/
	$vars = array('sql_ary');
	extract($phpbb_dispatcher->trigger_event('core.display_forums_modify_sql', compact($vars)));

	$sql = $db->sql_build_query('SELECT', $sql_ary);
	$result = $db->sql_query($sql);

	$forum_tracking_info = $valid_categories = array();
	$branch_root_id = $root_data['forum_id'];

	$phpbb_content_visibility = $phpbb_container->get('content.visibility');

	while ($row = $db->sql_fetchrow($result))
	{

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

				$sql2 = 'SELECT *
					FROM ' . TOPICS_TABLE . ' AS t ' . "
					WHERE t.forum_id = {$row['forum_id']}
					ORDER BY t.topic_last_post_id DESC";
				$result2 = $db->sql_query_limit($sql2, 1);	
				$recent_topics2 = $db->sql_fetchrowset($result2);	
				$topic_title2 = $recent_topics2[0]['topic_title'];
				if ($topic_title2 <> $row['forum_last_post_subject'])
				{
					$last_post_subject =($row['forum_last_post_subject'] ? censor_text($row['forum_last_post_subject']).' - ' : '').$topic_title2;
				}
				else
				{
					$last_post_subject =$row['forum_last_post_subject'];
				}
				$last_post_subject_truncated = truncate_string($last_post_subject, 30, 255, false, $user->lang['ELLIPSIS']);

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

			if ($row['forum_password_last_post'] === '' && $auth->acl_get('f_read', $row['forum_id_last_post']))
			{
				$sql2 = 'SELECT p.post_id, p.post_subject, t.topic_title
					FROM ' . POSTS_TABLE . ' p, ' . TOPICS_TABLE . " t
		 			WHERE p.post_id = {$row['forum_last_post_id']}
					AND p.topic_id = t.topic_id";
				$result2 = $db->sql_query($sql2);
				while ($row2 = $db->sql_fetchrow($result2))
				{
					$last_post_subject = ($row2['post_subject'] AND ($row2['post_subject'] <> $row2['topic_title'])) ? ($row2['post_subject'] .' - '. $row2['topic_title']) : $row2['topic_title'];
				}
				$db->sql_freeresult($result2);
				$last_post_subject_truncated = truncate_string($last_post_subject, 30, 255, false, $user->lang['ELLIPSIS']);