Board3

Code: Select all

//
// + new photo since last visit & you photo number
//
if ($user->data['is_registered'])
{
	$ex_fid_ary = array_unique(array_merge(array_keys($auth->acl_getf('!f_read', true)), array_keys($auth->acl_getf('!f_search', true))));
	
	if ($auth->acl_get('m_approve'))
	{
		$m_approve_fid_ary = array(-1);
		$m_approve_fid_sql = '';
	}
	else if ($auth->acl_getf_global('m_approve'))
	{
		$m_approve_fid_ary = array_diff(array_keys($auth->acl_getf('!m_approve', true)), $ex_fid_ary);
		$m_approve_fid_sql = ' AND (p.post_approved = 1' . ((sizeof($m_approve_fid_ary)) ? ' OR ' . $db->sql_in_set('p.forum_id', $m_approve_fid_ary, true) : '') . ')';
	}
	else
	{
		$m_approve_fid_ary = array();
		$m_approve_fid_sql = ' AND p.post_approved = 1';
	}

	$sql = 'SELECT COUNT(distinct t.image_id) as total
				FROM phpbb_gallery_images t
				WHERE t.image_time > ' . $user->data['user_lastvisit'] . '
					AND t.topic_moved_id = 0
					' . str_replace(array('p.', 'post_'), array('t.', 'topic_'), $m_approve_fid_sql) . '
					' . ((sizeof($ex_fid_ary)) ? 'AND ' . $db->sql_in_set('t.image_id', $ex_fid_ary, true) : '');
	$result = $db->sql_query($sql);
	$new_photo_count = (int) $db->sql_fetchfield('total');

	// your photo number
	$sql = "SELECT user_images
		FROM phpbb_gallery_users
		WHERE user_id = " . $user->data['user_id'];
	$result = $db->sql_query($sql);
	$you_photo_count = (int) $db->sql_fetchfield('user_images');
}
//
// - new photo since last visit & you photo number
//

Code: Select all

			case 'newphotos':
				$template->assign_block_vars('navlinks', array(
					'FORUM_NAME'	=> $user->lang['NEW_PHOTO'],
					'U_VIEW_FORUM'	=> append_sid("{$phpbb_root_path}{$gallery_root_path}search.$phpEx", 'search_id=' . $search_id),
				));

				$l_search_title = $user->lang['NEW_PHOTO'];
				$search_results = 'image';

				$sql_order = 'image_time DESC';
				$sql_limit = SEARCH_PAGES_NUMBER * $per_page;
				$sql = 'SELECT image_id
					FROM ' . GALLERY_IMAGES_TABLE . '
					WHERE image_time > ' . $user->data['user_lastvisit'] . '
						AND ((' . $db->sql_in_set('image_album_id', gallery_acl_album_ids('i_view'), false, true) . ' AND image_status <> ' . IMAGE_UNAPPROVED . ' AND image_contest = ' . IMAGE_NO_CONTEST . ')
							OR ' . $db->sql_in_set('image_album_id', gallery_acl_album_ids('m_status'), false, true) . ')
					ORDER BY ' . $sql_order;
			break;