phpbbgallery\core\controller\search::base()

Complexity

Conditions	34
Paths	> 20000

Size

Total Lines	231
Code Lines	151

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	1190

Importance

Changes	6
Bugs	0	Features	0

<?php
	public function base($page = 1)
	{
		$search_id		= $this->request->variable('search_id', '');
		$image_id		= $this->request->variable('image_id', 0);

The assignment to $image_id is dead and can be removed.

		$submit			= $this->request->variable('submit', false);
		$keywords		= utf8_normalize_nfc($this->request->variable('keywords', '', true));

The function utf8_normalize_nfc was not found. Maybe you did not declare it correctly or list all dependencies?

		$add_keywords	= utf8_normalize_nfc($this->request->variable('add_keywords', '', true));
		$username		= $this->request->variable('username', '', true);
		$user_id			= $this->request->variable('user_id', array(0));
		$search_terms	= $this->request->variable('terms', 'all');
		$search_album	= $this->request->variable('aid', array(0));
		$search_child	= $this->request->variable('sc', true);
		$search_fields	= $this->request->variable('sf', 'all');
		$sort_days		= $this->request->variable('st', 0);
		$sort_key		= $this->request->variable('sk', 't');
		$sort_dir		= $this->request->variable('sd', 'd');
		$filtered		= $this->request->variable('filtered', false);

		$start 			= ($page - 1) * $this->gallery_config->get('items_per_page');
		if ($filtered)
		{
			$submit = true;
		}
		$this->language->add_lang(array('gallery'), 'phpbbgallery/core');
		$this->language->add_lang('search');
		/**
		* Build the sort options
		*/
		$limit_days = array(0 => $this->language->lang('ALL_IMAGES'), 1 => $this->language->lang('1_DAY'), 7 => $this->language->lang('7_DAYS'), 14 => $this->language->lang('2_WEEKS'), 30 => $this->language->lang('1_MONTH'), 90 => $this->language->lang('3_MONTHS'), 180 => $this->language->lang('6_MONTHS'), 365 => $this->language->lang('1_YEAR'));
		$sort_by_text = array('t' => $this->language->lang('TIME'), 'n' => $this->language->lang('IMAGE_NAME'), 'u' => $this->language->lang('SORT_USERNAME'), 'vc' => $this->language->lang('GALLERY_VIEWS'));
		$sort_by_sql = array('t' => 'image_time', 'n' => 'image_name_clean', 'u' => 'image_username_clean', 'vc' => 'image_view_count');

		if ($this->gallery_config->get('allow_rates'))
		{
			$sort_by_text['ra'] = $this->language->lang('RATING');
			$sort_by_sql['ra'] = 'image_rate_points';//@todo: (phpbb_gallery_contest::$mode == phpbb_gallery_contest::MODE_SUM) ? 'image_rate_points' : 'image_rate_avg';
			$sort_by_text['r'] = $this->language->lang('RATES_COUNT');
			$sort_by_sql['r'] = 'image_rates';
		}
		if ($this->gallery_config->get('allow_comments'))
		{
			$sort_by_text['c'] = $this->language->lang('COMMENTS');
			$sort_by_sql['c'] = 'image_comments';
			$sort_by_text['lc'] = $this->language->lang('NEW_COMMENT');
			$sort_by_sql['lc'] = 'image_last_comment';
		}
		$this->gallery_auth->load_user_permissions($this->user->data['user_id']);

		$s_limit_days = $s_sort_key = $s_sort_dir = $u_sort_param = '';
		gen_sort_selects($limit_days, $sort_by_text, $sort_days, $sort_key, $sort_dir, $s_limit_days, $s_sort_key, $s_sort_dir, $u_sort_param);

The function gen_sort_selects was not found. Maybe you did not declare it correctly or list all dependencies?

		$sql_order = $sort_by_sql[$sort_key] . ' ' . (($sort_dir == 'd') ? 'DESC' : 'ASC');

		// We will build SQL array and then build query (easily change count with rq)
		$sql_array = $sql_where = array();
		$sql_array['FROM'] = array(
			$this->images_table => 'i',
		);
		if ($keywords || $username || $user_id || $search_id || $submit)
		{
			// Let's resolve username to user id ... or array of them.
			if ($username)
			{
				if ((strpos($username, '*') !== false) && (utf8_strlen(str_replace(array('*', '%'), '', $username)) < $this->config['min_search_author_chars']))

The function utf8_strlen was not found. Maybe you did not declare it correctly or list all dependencies?

				{
					trigger_error(sprintf($this->language->lang('TOO_FEW_AUTHOR_CHARS'), $this->config['min_search_author_chars']));
				}
				$username_parsed = (strpos($username, '*') !== false) ? ' username_clean ' . $this->db->sql_like_expression(str_replace('*', $this->db->get_any_char(), utf8_clean_string($this->db->sql_escape($username)))) : ' username_clean = \'' . $this->db->sql_escape(utf8_clean_string($username)) .'\'';

The function utf8_clean_string was not found. Maybe you did not declare it correctly or list all dependencies?

				$sql = 'SELECT user_id
					FROM ' . USERS_TABLE . '

The constant phpbbgallery\core\controller\USERS_TABLE was not found. Maybe you did not declare it correctly or list all dependencies?

					WHERE ' . $username_parsed . '
					AND user_type IN (' . USER_NORMAL . ', ' . USER_FOUNDER . ')';

The constant phpbbgallery\core\controller\USER_FOUNDER was not found. Maybe you did not declare it correctly or list all dependencies?

The constant phpbbgallery\core\controller\USER_NORMAL was not found. Maybe you did not declare it correctly or list all dependencies?

				$result = $this->db->sql_query_limit($sql, 100);

				$user_id_ary = [];
				while ($row = $this->db->sql_fetchrow($result))
				{
					$user_id_ary[] = (int) $row['user_id'];
				}
				$this->db->sql_freeresult($result);

				$user_id_ary[] = (int) ANONYMOUS;

The constant phpbbgallery\core\controller\ANONYMOUS was not found. Maybe you did not declare it correctly or list all dependencies?

				$user_id = $user_id_ary;
			}

			if (!empty($user_id))
			{
				$sql_where[] =  $this->db->sql_in_set('i.image_user_id', $user_id);
			}
			// if we search in an existing search result just add the additional keywords. But we need to use "all search terms"-mode
			// so we can keep the old keywords in their old mode, but add the new ones as required words
			if ($add_keywords)
			{
				if ($search_terms == 'all')
				{
					$keywords .= ' ' . $add_keywords;
				}
				else
				{
					$search_terms = 'all';
					$keywords = preg_replace('#\s+#u', ' |', $keywords) . ' ' .$add_keywords;
				}
			}
			$keywords_ary = ($keywords) ? explode(' ', $keywords) : array();

			// pre-made searches
			$sql = $field = $l_search_title = $search_results = '';

The assignment to $l_search_title is dead and can be removed.

The assignment to $search_results is dead and can be removed.

The assignment to $sql is dead and can be removed.

The assignment to $field is dead and can be removed.

			$total_match_count = 0;

The assignment to $total_match_count is dead and can be removed.

			$sql_limit = 0;

The assignment to $sql_limit is dead and can be removed.

			$search_query = '';
			$matches = array('i.image_name', 'i.image_desc');

The assignment to $matches is dead and can be removed.

			if (is_array($keywords_ary) && !sizeof($keywords_ary) && is_array($user_id_ary) && !sizeof($user_id_ary))

The variable $user_id_ary does not seem to be defined for all execution paths leading up to this point.

			{
				trigger_error('NO_SEARCH_RESULTS');
			}
			$matches = array('i.image_name', 'i.image_desc');

			foreach ($keywords_ary as $word)
			{
				$match_search_query = '';
				foreach ($matches as $match)
				{
					$match_search_query .= (($match_search_query) ? ' OR ' : '') . 'LOWER('. $match . ') ';
					$match_search_query .= $this->db->sql_like_expression(str_replace('*', $this->db->get_any_char(), $this->db->get_any_char() . mb_strtolower($word) . $this->db->get_any_char()));
				}
				$search_query .= ((!$search_query) ? '' : (($search_terms == 'all') ? ' AND ' : ' OR ')) . '(' . $match_search_query . ')';
			}
			$sql_where[] = $search_query;

			if (empty($search_album))
			{
				$sql_where[] = $this->db->sql_in_set('i.image_album_id', $this->gallery_auth->acl_album_ids('i_view'));
			}
			else
			{
				$sql_where[] = $this->db->sql_in_set('i.image_album_id', $search_album);
			}
			$sql_array['WHERE'] = implode(' and ', array_filter($sql_where));
			$sql_array['SELECT'] = 'COUNT(i.image_id) as count';

			$sql = $this->db->sql_build_query('SELECT', $sql_array);
			$result = $this->db->sql_query($sql);
			$row = $this->db->sql_fetchrow($result);
			$search_count = $row['count'];
			//var_dump($sql);
			$this->db->sql_freeresult($result);
			if ($search_count == 0)
			{
				trigger_error('NO_SEARCH_RESULTS');
			}
			$sql_array['SELECT'] = '*, a.album_name, a.album_status, a.album_user_id, a.album_id';
			$sql_array['LEFT_JOIN']	= array(
				array(
					'FROM'		=> array($this->albums_table => 'a'),
					'ON'		=> 'a.album_id = i.image_album_id',
				)
			);
			$sql_array['ORDER_BY'] = $sql_order;
			$sql_array['GROUP_BY'] = $sort_by_sql[$sort_key] . ', i.image_id, a.album_id';

			$sql = $this->db->sql_build_query('SELECT', $sql_array);
			$result = $this->db->sql_query_limit($sql, $this->gallery_config->get('items_per_page'), $start);
			while ($row = $this->db->sql_fetchrow($result))
			{
				$rowset[] = $row;
			}
			$this->db->sql_freeresult($result);
			$this->template->assign_block_vars('imageblock', array(
				'BLOCK_NAME'	=> '',
				'U_BLOCK'	=> $this->helper->route('phpbbgallery_core_search'),
			));

			$show_options = $this->gallery_config->get('search_display');
			$thumbnail_link = $this->gallery_config->get('link_thumbnail');
			$imagename_link = $this->gallery_config->get('link_image_name');
			foreach ($rowset as $row)

The variable $rowset does not seem to be defined for all execution paths leading up to this point.

			{
				$this->image->assign_block('imageblock.image', $row, $show_options, $thumbnail_link, $imagename_link);
			}
			$current_page = $page*$this->gallery_config->get('items_per_page');
			$this->pagination->generate_template_pagination(array(
				'routes' => array(
					'phpbbgallery_core_search',
					'phpbbgallery_core_search_page',
				),
				'params' => array(
					'keywords'	=> $keywords,
					'username'	=> $username,
					'user_id'	=> $user_id,
					'terms'		=> $search_terms,
					'aid'			=> $search_album,
					'sc'			=> $search_child,
					'sf'			=> $search_fields,
					'st'			=> $sort_days,
					'sk'			=> $sort_key,
					'sd'			=> $sort_dir,
					'filtered'	=> true
				),
			), 'pagination', 'page', $search_count, $this->gallery_config->get('items_per_page'), $current_page - 1);

			$this->template->assign_vars(array(
				'SEARCH_MATCHES'	=> $this->language->lang('FOUND_SEARCH_MATCHES', $search_count),
			));
			return $this->helper->render('gallery/search_results.html', $this->language->lang('GALLERY'));
		}
		// Is user able to search? Has search been disabled?
		if (!$this->auth->acl_get('u_search') || !$this->config['load_search'])
		{
			$this->template->assign_var('S_NO_SEARCH', true);
			trigger_error('NO_SEARCH');
		}
		$this->template->assign_block_vars('navlinks', array(
			'FORUM_NAME'	=> $this->language->lang('SEARCH'),
			'U_VIEW_FORUM'	=> $this->helper->route('phpbbgallery_core_search'),
		));

		$s_albums = $this->album->get_albumbox(false, false, false, 'i_view' /*'a_search'*/);

false of type false is incompatible with the type string expected by parameter $select_name of phpbbgallery\core\album\album::get_albumbox().

		$s_hidden_fields = array();
		$this->template->assign_vars(array(
			'S_SEARCH_ACTION'		=> $this->helper->route('phpbbgallery_core_search'), // We force no ?sid= appending by using 0
			'S_HIDDEN_FIELDS'		=> build_hidden_fields($s_hidden_fields),

The function build_hidden_fields was not found. Maybe you did not declare it correctly or list all dependencies?

			'S_ALBUM_OPTIONS'		=> $s_albums,
			'S_SELECT_SORT_DIR'		=> $s_sort_dir,
			'S_SELECT_SORT_KEY'		=> $s_sort_key,
			'S_SELECT_SORT_DAYS'	=> $s_limit_days,
			'S_IN_SEARCH'			=> true,
		));
		return $this->helper->render('gallery/search_body.html', $this->language->lang('GALLERY'));
	}