Polskie forum wsparcia dla phpBB

Kod: Zaznacz cały

// Count posts since last vivist
	if ($user->data['is_registered'] && $config['load_search'] && $auth->acl_get('u_search') && $auth->acl_getf_global('f_search'))
	{
		// Include forum_id 0 (globals) in the list and then look up and include all other forums the user is authorized to read
		if (!isset($forum_ids))
		{
			$forum_ids[] = 0;

			$sql = 'SELECT forum_id
				FROM ' . FORUMS_TABLE;
			$result = $db->sql_query($sql);

			while ($row = $db->sql_fetchrow($result))
			{
				if ($auth->acl_get('f_read', $row['forum_id']))
				{
					$forum_ids[] = $row['forum_id'];
				}
			}

			$db->sql_freeresult($result);
		}

		$unread_posts_count = 0;

		// Unread posts count
		$sql = $db->sql_build_query('SELECT', array(
			'SELECT'	=> 'COUNT(p.post_id) as total',

			'FROM'		=> array(
				POSTS_TABLE => 'p'
			),

			'LEFT_JOIN'	=> array(
				array(
					'FROM'	=> array(FORUMS_TRACK_TABLE => 'ft'),
					'ON'	=> 'p.forum_id = ft.forum_id AND ft.user_id = ' . $user->data['user_id']
				),
				array(
					'FROM'	=> array(TOPICS_TRACK_TABLE => 'tt'),
					'ON'	=> 'p.topic_id = tt.topic_id AND tt.user_id = ' . $user->data['user_id']
				)
			),

			'WHERE'		=> '(p.post_time > tt.mark_time
				OR (tt.mark_time IS NULL AND p.post_time > ft.mark_time)
				OR (ft.mark_time IS NULL AND p.post_time > ' . $user->data['user_lastmark'] . '))
				AND ' . $db->sql_in_set('p.forum_id', $forum_ids)
		));

		$result = $db->sql_query($sql);
		$unread_posts_count = $db->sql_fetchfield('total', false, $result);
		$db->sql_freeresult($result);

		$template->assign_var('UNREAD_POSTS_COUNT', $unread_posts_count);
	}