similar_topics_module::enable_fulltext_support() - Code Metrics - Inspection of "PostgreSQL support" - iMattPro/similartopics - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Pull Request — master (#25)

by Matt

created 2018-03-11 08:06 UTC

similar_topics_module::enable_fulltext_support() A

↳ Parent: Project

Complexity

Conditions	3
Paths	4

Size

Total Lines	20
Code Lines	9

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
dl	0
loc	20
rs	9.4285
c	0
b	0
f	0
cc	3
eloc	9
nc	4
nop	0

<?php
/**
 *
 * Precise Similar Topics
 *
 * @copyright (c) 2013 Matt Friedman
 * @license GNU General Public License, version 2 (GPL-2.0)
 *
 */

namespace vse\similartopics\acp;

/**
 * @package acp
 */
class similar_topics_module
{
	/** @var \phpbb\cache\driver\driver_interface */
	protected $cache;

	/** @var \phpbb\config\config */
	protected $config;

	/** @var \phpbb\db\driver\driver_interface */
	protected $db;

	/** @var \vse\similartopics\driver\mysqli|\vse\similartopics\driver\postgres */
	protected $driver;

	/** @var \phpbb\log\log */
	protected $log;

	/** @var \phpbb\request\request */
	protected $request;

	/** @var \phpbb\template\template */
	protected $template;

	/** @var \phpbb\user */
	protected $user;

	/** @var string */
	protected $root_path;

	/** @var string */
	protected $php_ext;

	/** @var array */
	protected $times;

	/** @var string */
	public $page_title;

	/** @var string */
	public $tpl_name;

	/** @var string */
	public $u_action;

	/**
	 * ACP module constructor
	 *
	 * @access public
	 */
	public function __construct()
	{
		global $phpbb_container;

		$this->cache     = $phpbb_container->get('cache');
		$this->config    = $phpbb_container->get('config');
		$this->db        = $phpbb_container->get('dbal.conn');
		$this->driver    = $phpbb_container->get('vse.similartopics.driver.manager')->get_driver($this->db->get_sql_layer());
		$this->log       = $phpbb_container->get('log');
		$this->request   = $phpbb_container->get('request');
		$this->template  = $phpbb_container->get('template');
		$this->user      = $phpbb_container->get('user');
		$this->root_path = $phpbb_container->getParameter('core.root_path');
		$this->php_ext   = $phpbb_container->getParameter('core.php_ext');
		$this->times     = array(
			'd' => 86400, // one day
			'w' => 604800, // one week
			'm' => 2626560, // one month
			'y' => 31536000, // one year
		);
	}

	/**
	 * Main ACP module
	 *
	 * @access public
	 */
	public function main()
	{
		$this->user->add_lang_ext('vse/similartopics', 'acp_similar_topics');

		$this->tpl_name = 'acp_similar_topics';
		$this->page_title = $this->user->lang('PST_TITLE_ACP');

		$form_key = 'acp_similar_topics';
		add_form_key($form_key);

		$action = $this->request->variable('action', '');

		switch ($action)
		{
			case 'advanced':
				$forum_id = $this->request->variable('f', 0);

				if ($this->request->is_set_post('submit'))
				{
					$this->check_form_key($form_key);

					$similar_topic_forums = $this->request->variable('similar_forums_id', array(0));
					$similar_topic_forums = !empty($similar_topic_forums) ? json_encode($similar_topic_forums) : '';

					$sql = 'UPDATE ' . FORUMS_TABLE . "
						SET similar_topic_forums = '" . $this->db->sql_escape($similar_topic_forums) . "'
						WHERE forum_id = $forum_id";
					$this->db->sql_query($sql);

					$this->log->add('admin', $this->user->data['user_id'], $this->user->ip, 'PST_LOG_MSG');

					$this->end('PST_SAVED');
				}

				$forum_name = '';
				$selected = array();
				if ($forum_id > 0)
				{
					$sql = 'SELECT forum_name, similar_topic_forums
						FROM ' . FORUMS_TABLE . "
						WHERE forum_id = $forum_id";
					$result = $this->db->sql_query($sql);
					while ($fid = $this->db->sql_fetchrow($result))
					{
						$selected = json_decode($fid['similar_topic_forums'], true);
						$forum_name = $fid['forum_name'];
					}
					$this->db->sql_freeresult($result);
				}

				$this->template->assign_vars(array(
					'S_ADVANCED_SETTINGS'		=> true,
					'SIMILAR_FORUMS_OPTIONS'	=> make_forum_select($selected, false, false, true),
					'PST_FORUM_NAME'			=> $forum_name,
					'PST_ADVANCED_EXP'			=> $this->user->lang('PST_ADVANCED_EXP', $forum_name),
					'U_ACTION'					=> $this->u_action . '&amp;action=advanced&amp;f=' . $forum_id,
					'U_BACK'					=> $this->u_action,
				));
			break;

			default:
				if ($this->request->is_set_post('submit'))
				{
					$this->check_form_key($form_key);

					// Set basic config settings
					$this->config->set('similar_topics', $this->request->variable('pst_enable', 0));
					$this->config->set('similar_topics_limit', abs($this->request->variable('pst_limit', 0))); // use abs for positive values only
					$this->config->set('similar_topics_cache', abs($this->request->variable('pst_cache', 0))); // use abs for positive values only
					$this->config->set('similar_topics_words', $this->request->variable('pst_words', '', true));

					// Set sensitivity
					$pst_sense = min(abs($this->request->variable('pst_sense', 5)), 10); // use abs for positive values only
					$this->config->set('similar_topics_sense', $pst_sense);

					// Set date/time config settings
					$pst_time = abs($this->request->variable('pst_time', 0)); // use abs for positive values only
					$pst_time_type = $this->request->variable('pst_time_type', '');
					$this->config->set('similar_topics_type', $pst_time_type);
					$this->config->set('similar_topics_time', $this->set_pst_time($pst_time, $pst_time_type));

					// Set checkbox array form data
					$this->update_forum('similar_topics_hide', $this->request->variable('mark_noshow_forum', array(0), true));
					$this->update_forum('similar_topics_ignore', $this->request->variable('mark_ignore_forum', array(0), true));

					// Set PostgreSQL TS Name
					if ($this->driver && $this->driver->get_type() === 'postgres')
					{
						$ts_name = $this->request->variable('pst_postgres_ts_name', ($this->config['pst_postgres_ts_name'] ?: 'simple'));
						$this->config->set('pst_postgres_ts_name', $ts_name);
						$this->driver->set_ts_name($ts_name)->create_fulltext_index('topic_title');
class A
{
    public function foo() { }
}

class B extends A
{
    public function bar() { }
}

/**
 * @param A|B $x
 */
function someFunction($x)
{
    $x->foo(); // This call is fine as the method exists in A and B.
    $x->bar(); // This method only exists in B and might cause an error.
}
					}

					$this->log->add('admin', $this->user->data['user_id'], $this->user->ip, 'PST_LOG_MSG');

					$this->cache->destroy('sql', TOPICS_TABLE);

					$this->end('PST_SAVED');
				}

				// Build the time options select menu
				$time_options = array(
					'd' => $this->user->lang('PST_DAYS'),
					'w' => $this->user->lang('PST_WEEKS'),
					'm' => $this->user->lang('PST_MONTHS'),
					'y' => $this->user->lang('PST_YEARS')
				);
				foreach ($time_options as $value => $label)
				{
					$this->template->assign_block_vars('similar_time_options', array(
						'VALUE'			=> $value,
						'LABEL'			=> $label,
						'S_SELECTED'	=> $value === $this->config['similar_topics_type'],
					));
				}

				$this->template->assign_vars(array(
					'S_PST_ENABLE'		=> $this->isset_or_default($this->config['similar_topics'], false),
					'PST_LIMIT'			=> $this->isset_or_default($this->config['similar_topics_limit'], ''),
					'PST_CACHE'			=> $this->isset_or_default($this->config['similar_topics_cache'], ''),
					'PST_SENSE'			=> $this->isset_or_default($this->config['similar_topics_sense'], ''),
					'PST_WORDS'			=> $this->isset_or_default($this->config['similar_topics_words'], ''),
					'PST_TIME'			=> $this->get_pst_time($this->config['similar_topics_time'], $this->config['similar_topics_type']),
					'S_PST_NO_COMPAT'	=> $this->driver === null || !$this->driver->is_index('topic_title'),
					'U_ACTION'			=> $this->u_action,
				));

				// If postgresql, we need to make an options list of text search names
				if ($this->driver && $this->driver->get_type() === 'postgres')
				{
					$this->user->add_lang('acp/search');
					foreach ($this->driver->get_cfgname_list() as $row)
class A
{
    public function foo() { }
}

class B extends A
{
    public function bar() { }
}

/**
 * @param A|B $x
 */
function someFunction($x)
{
    $x->foo(); // This call is fine as the method exists in A and B.
    $x->bar(); // This method only exists in B and might cause an error.
}
					{
						$this->template->assign_block_vars('postgres_ts_names', array(
							'NAME'			=> $row['ts_name'],
							'S_SELECTED'	=> $row['ts_name'] === $this->config['pst_postgres_ts_name'],
						));
					}
				}

				$forum_list = $this->get_forum_list();
				foreach ($forum_list as $row)
				{
					$this->template->assign_block_vars('forums', array(
						'FORUM_NAME'			=> $row['forum_name'],
						'FORUM_ID'				=> $row['forum_id'],
						'CHECKED_IGNORE_FORUM'	=> $row['similar_topics_ignore'] ? 'checked="checked"' : '',
						'CHECKED_NOSHOW_FORUM'	=> $row['similar_topics_hide'] ? 'checked="checked"' : '',
						'S_IS_ADVANCED'			=> (bool) $row['similar_topic_forums'],
						'U_ADVANCED'			=> "{$this->u_action}&amp;action=advanced&amp;f=" . $row['forum_id'],
						'U_FORUM'				=> append_sid("{$this->root_path}viewforum.{$this->php_ext}", 'f=' . $row['forum_id']),
					));
				}
			break;
		}
	}

	/**
	 * Check form key, trigger error if invalid
	 *
	 * @access protected
	 * @param string $form_key The form key value
	 */
	protected function check_form_key($form_key)
	{
		if (!check_form_key($form_key))
		{
			$this->end('FORM_INVALID', E_USER_WARNING);
		}
	}

	/**
	 * Get forums list
	 *
	 * @access protected
	 * @return array forum data rows
	 */
	protected function get_forum_list()
	{
		$sql = 'SELECT forum_id, forum_name, similar_topic_forums, similar_topics_hide, similar_topics_ignore
			FROM ' . FORUMS_TABLE . '
			WHERE forum_type = ' . FORUM_POST . '
			ORDER BY left_id ASC';
		$result = $this->db->sql_query($sql);
		$forum_list = $this->db->sql_fetchrowset($result);
		$this->db->sql_freeresult($result);

		return $forum_list;
	}

	/**
	 * Update the similar topics columns in the forums table
	 *
	 * @param string $column    The name of the column to update
	 * @param array  $forum_ids An array of forum_ids
	 */
	protected function update_forum($column, $forum_ids)
	{
		$this->db->sql_transaction('begin');

		// Set marked forums (in set) to 1
		$sql = 'UPDATE ' . FORUMS_TABLE . "
			SET $column = 1
			WHERE " . $this->db->sql_in_set('forum_id', $forum_ids, false, true);
		$this->db->sql_query($sql);

		// Set unmarked forums (not in set) to 0
		$sql = 'UPDATE ' . FORUMS_TABLE . "
			SET $column = 0
			WHERE " . $this->db->sql_in_set('forum_id', $forum_ids, true, true);
		$this->db->sql_query($sql);

		$this->db->sql_transaction('commit');
	}

	/**
	 * Calculate the time in seconds based on requested time period length
	 *
	 * @access protected
	 * @param int    $length user entered value
	 * @param string $type   years, months, weeks, days (y|m|w|d)
	 * @return int time in seconds
	 */
	protected function set_pst_time($length, $type = 'y')
	{
		$type = isset($this->times[$type]) ? $type : 'y';

		return (int) ($length * $this->times[$type]);
	}

	/**
	 * Get the correct time period length value for the form
	 *
	 * @access protected
	 * @param int    $time as a timestamp
	 * @param string $type years, months, weeks, days (y|m|w|d)
	 * @return int time converted to the given $type
	 */
	protected function get_pst_time($time, $type = '')
	{
		return isset($this->times[$type]) ? (int) round($time / $this->times[$type]) : 0;
	}

	/**
	 * Return a variable if it is set, otherwise default
	 *
	 * @access protected
	 * @param mixed $var     The variable to test
	 * @param mixed $default The default value to use
	 * @return mixed The value of the variable if set, otherwise default value
	 */
	protected function isset_or_default($var, $default)
	{
		return null !== $var ? $var : $default;
	}

	/**
	 * End script execution with a trigger_error message
	 *
	 * @access protected
	 * @param string $message Language key string
	 * @param int    $code    E_USER_NOTICE|E_USER_WARNING
	 * @return void
	 */
	protected function end($message, $code = E_USER_NOTICE)
	{
		trigger_error($this->user->lang($message) . adm_back_link($this->u_action), $code);
	}
}


Pull Request — master (#25)

similar_topics_module::enable_fulltext_support() A

Complexity

Size

Duplication

Importance

Available Fixes

Available Fixes

1			<?php
2			/**
3			*
4			* Precise Similar Topics
5			*
6			* @copyright (c) 2013 Matt Friedman
7			* @license GNU General Public License, version 2 (GPL-2.0)
8			*
9			*/
10
11			namespace vse\similartopics\acp;
12
13			/**
14			* @package acp
15			*/
16			class similar_topics_module
17			{
18			/** @var \phpbb\cache\driver\driver_interface */
19			protected $cache;
20
21			/** @var \phpbb\config\config */
22			protected $config;
23
24			/** @var \phpbb\db\driver\driver_interface */
25			protected $db;
26
27			/** @var \vse\similartopics\driver\mysqli\|\vse\similartopics\driver\postgres */
28			protected $driver;
29
30			/** @var \phpbb\log\log */
31			protected $log;
32
33			/** @var \phpbb\request\request */
34			protected $request;
35
36			/** @var \phpbb\template\template */
37			protected $template;
38
39			/** @var \phpbb\user */
40			protected $user;
41
42			/** @var string */
43			protected $root_path;
44
45			/** @var string */
46			protected $php_ext;
47
48			/** @var array */
49			protected $times;
50
51			/** @var string */
52			public $page_title;
53
54			/** @var string */
55			public $tpl_name;
56
57			/** @var string */
58			public $u_action;
59
60			/**
61			* ACP module constructor
62			*
63			* @access public
64			*/
65			public function __construct()
66			{
67			global $phpbb_container;
68
69			$this->cache = $phpbb_container->get('cache');
70			$this->config = $phpbb_container->get('config');
71			$this->db = $phpbb_container->get('dbal.conn');
72			$this->driver = $phpbb_container->get('vse.similartopics.driver.manager')->get_driver($this->db->get_sql_layer());
73			$this->log = $phpbb_container->get('log');
74			$this->request = $phpbb_container->get('request');
75			$this->template = $phpbb_container->get('template');
76			$this->user = $phpbb_container->get('user');
77			$this->root_path = $phpbb_container->getParameter('core.root_path');
78			$this->php_ext = $phpbb_container->getParameter('core.php_ext');
79			$this->times = array(
80			'd' => 86400, // one day
81			'w' => 604800, // one week
82			'm' => 2626560, // one month
83			'y' => 31536000, // one year
84			);
85			}
86
87			/**
88			* Main ACP module
89			*
90			* @access public
91			*/
92			public function main()
93			{
94			$this->user->add_lang_ext('vse/similartopics', 'acp_similar_topics');
95
96			$this->tpl_name = 'acp_similar_topics';
97			$this->page_title = $this->user->lang('PST_TITLE_ACP');
98
99			$form_key = 'acp_similar_topics';
100			add_form_key($form_key);
101
102			$action = $this->request->variable('action', '');
103
104			switch ($action)
105			{
106			case 'advanced':
107			$forum_id = $this->request->variable('f', 0);
108
109			if ($this->request->is_set_post('submit'))
110			{
111			$this->check_form_key($form_key);
112
113			$similar_topic_forums = $this->request->variable('similar_forums_id', array(0));
114			$similar_topic_forums = !empty($similar_topic_forums) ? json_encode($similar_topic_forums) : '';
115
116			$sql = 'UPDATE ' . FORUMS_TABLE . "
117			SET similar_topic_forums = '" . $this->db->sql_escape($similar_topic_forums) . "'
118			WHERE forum_id = $forum_id";
119			$this->db->sql_query($sql);
120
121			$this->log->add('admin', $this->user->data['user_id'], $this->user->ip, 'PST_LOG_MSG');
122
123			$this->end('PST_SAVED');
124			}
125
126			$forum_name = '';
127			$selected = array();
128			if ($forum_id > 0)
129			{
130			$sql = 'SELECT forum_name, similar_topic_forums
131			FROM ' . FORUMS_TABLE . "
132			WHERE forum_id = $forum_id";
133			$result = $this->db->sql_query($sql);
134			while ($fid = $this->db->sql_fetchrow($result))
135			{
136			$selected = json_decode($fid['similar_topic_forums'], true);
137			$forum_name = $fid['forum_name'];
138			}
139			$this->db->sql_freeresult($result);
140			}
141
142			$this->template->assign_vars(array(
143			'S_ADVANCED_SETTINGS' => true,
144			'SIMILAR_FORUMS_OPTIONS' => make_forum_select($selected, false, false, true),
145			'PST_FORUM_NAME' => $forum_name,
146			'PST_ADVANCED_EXP' => $this->user->lang('PST_ADVANCED_EXP', $forum_name),
147			'U_ACTION' => $this->u_action . '&action=advanced&f=' . $forum_id,
148			'U_BACK' => $this->u_action,
149			));
150			break;
151
152			default:
153			if ($this->request->is_set_post('submit'))
154			{
155			$this->check_form_key($form_key);
156
157			// Set basic config settings
158			$this->config->set('similar_topics', $this->request->variable('pst_enable', 0));
159			$this->config->set('similar_topics_limit', abs($this->request->variable('pst_limit', 0))); // use abs for positive values only
160			$this->config->set('similar_topics_cache', abs($this->request->variable('pst_cache', 0))); // use abs for positive values only
161			$this->config->set('similar_topics_words', $this->request->variable('pst_words', '', true));
162
163			// Set sensitivity
164			$pst_sense = min(abs($this->request->variable('pst_sense', 5)), 10); // use abs for positive values only
165			$this->config->set('similar_topics_sense', $pst_sense);
166
167			// Set date/time config settings
168			$pst_time = abs($this->request->variable('pst_time', 0)); // use abs for positive values only
169			$pst_time_type = $this->request->variable('pst_time_type', '');
170			$this->config->set('similar_topics_type', $pst_time_type);
171			$this->config->set('similar_topics_time', $this->set_pst_time($pst_time, $pst_time_type));
172
173			// Set checkbox array form data
174			$this->update_forum('similar_topics_hide', $this->request->variable('mark_noshow_forum', array(0), true));
175			$this->update_forum('similar_topics_ignore', $this->request->variable('mark_ignore_forum', array(0), true));
176
177			// Set PostgreSQL TS Name
178			if ($this->driver && $this->driver->get_type() === 'postgres')
179			{
180			$ts_name = $this->request->variable('pst_postgres_ts_name', ($this->config['pst_postgres_ts_name'] ?: 'simple'));
181			$this->config->set('pst_postgres_ts_name', $ts_name);
182			$this->driver->set_ts_name($ts_name)->create_fulltext_index('topic_title');
			0 ignored issues – show Bug introduced 2018-03-09 01:17 UTC by Report Bug Copy Issue Report The method `set_ts_name` does only exist in `vse\similartopics\driver\postgres`, but not in `vse\similartopics\driver\mysqli`. It seems like the method you are trying to call exists only in some of the possible types. Let’s take a look at an example: class A { public function foo() { } } class B extends A { public function bar() { } } /** * @param A\|B $x / function someFunction($x) { $x->foo(); // This call is fine as the method exists in A and B. $x->bar(); // This method only exists in B and might cause an error. } Available Fixes Add an additional type-check: /* * @param A\|B $x / function someFunction($x) { $x->foo(); if ($x instanceof B) { $x->bar(); } } Only allow a single type to be passed if the variable comes from a parameter: function someFunction(B $x) { /* ... */ } Loading history...
183			}
184
185			$this->log->add('admin', $this->user->data['user_id'], $this->user->ip, 'PST_LOG_MSG');
186
187			$this->cache->destroy('sql', TOPICS_TABLE);
188
189			$this->end('PST_SAVED');
190			}
191
192			// Build the time options select menu
193			$time_options = array(
194			'd' => $this->user->lang('PST_DAYS'),
195			'w' => $this->user->lang('PST_WEEKS'),
196			'm' => $this->user->lang('PST_MONTHS'),
197			'y' => $this->user->lang('PST_YEARS')
198			);
199			foreach ($time_options as $value => $label)
200			{
201			$this->template->assign_block_vars('similar_time_options', array(
202			'VALUE' => $value,
203			'LABEL' => $label,
204			'S_SELECTED' => $value === $this->config['similar_topics_type'],
205			));
206			}
207
208			$this->template->assign_vars(array(
209			'S_PST_ENABLE' => $this->isset_or_default($this->config['similar_topics'], false),
210			'PST_LIMIT' => $this->isset_or_default($this->config['similar_topics_limit'], ''),
211			'PST_CACHE' => $this->isset_or_default($this->config['similar_topics_cache'], ''),
212			'PST_SENSE' => $this->isset_or_default($this->config['similar_topics_sense'], ''),
213			'PST_WORDS' => $this->isset_or_default($this->config['similar_topics_words'], ''),
214			'PST_TIME' => $this->get_pst_time($this->config['similar_topics_time'], $this->config['similar_topics_type']),
215			'S_PST_NO_COMPAT' => $this->driver === null \|\| !$this->driver->is_index('topic_title'),
216			'U_ACTION' => $this->u_action,
217			));
218
219			// If postgresql, we need to make an options list of text search names
220			if ($this->driver && $this->driver->get_type() === 'postgres')
221			{
222			$this->user->add_lang('acp/search');
223			foreach ($this->driver->get_cfgname_list() as $row)
			0 ignored issues – show Bug introduced 2018-03-09 01:17 UTC by Report Bug Copy Issue Report The method `get_cfgname_list` does only exist in `vse\similartopics\driver\postgres`, but not in `vse\similartopics\driver\mysqli`. It seems like the method you are trying to call exists only in some of the possible types. Let’s take a look at an example: class A { public function foo() { } } class B extends A { public function bar() { } } /** * @param A\|B $x / function someFunction($x) { $x->foo(); // This call is fine as the method exists in A and B. $x->bar(); // This method only exists in B and might cause an error. } Available Fixes Add an additional type-check: /* * @param A\|B $x / function someFunction($x) { $x->foo(); if ($x instanceof B) { $x->bar(); } } Only allow a single type to be passed if the variable comes from a parameter: function someFunction(B $x) { /* ... */ } Loading history...
224			{
225			$this->template->assign_block_vars('postgres_ts_names', array(
226			'NAME' => $row['ts_name'],
227			'S_SELECTED' => $row['ts_name'] === $this->config['pst_postgres_ts_name'],
228			));
229			}
230			}
231
232			$forum_list = $this->get_forum_list();
233			foreach ($forum_list as $row)
234			{
235			$this->template->assign_block_vars('forums', array(
236			'FORUM_NAME' => $row['forum_name'],
237			'FORUM_ID' => $row['forum_id'],
238			'CHECKED_IGNORE_FORUM' => $row['similar_topics_ignore'] ? 'checked="checked"' : '',
239			'CHECKED_NOSHOW_FORUM' => $row['similar_topics_hide'] ? 'checked="checked"' : '',
240			'S_IS_ADVANCED' => (bool) $row['similar_topic_forums'],
241			'U_ADVANCED' => "{$this->u_action}&action=advanced&f=" . $row['forum_id'],
242			'U_FORUM' => append_sid("{$this->root_path}viewforum.{$this->php_ext}", 'f=' . $row['forum_id']),
243			));
244			}
245			break;
246			}
247			}
248
249			/**
250			* Check form key, trigger error if invalid
251			*
252			* @access protected
253			* @param string $form_key The form key value
254			*/
255			protected function check_form_key($form_key)
256			{
257			if (!check_form_key($form_key))
258			{
259			$this->end('FORM_INVALID', E_USER_WARNING);
260			}
261			}
262
263			/**
264			* Get forums list
265			*
266			* @access protected
267			* @return array forum data rows
268			*/
269			protected function get_forum_list()
270			{
271			$sql = 'SELECT forum_id, forum_name, similar_topic_forums, similar_topics_hide, similar_topics_ignore
272			FROM ' . FORUMS_TABLE . '
273			WHERE forum_type = ' . FORUM_POST . '
274			ORDER BY left_id ASC';
275			$result = $this->db->sql_query($sql);
276			$forum_list = $this->db->sql_fetchrowset($result);
277			$this->db->sql_freeresult($result);
278
279			return $forum_list;
280			}
281
282			/**
283			* Update the similar topics columns in the forums table
284			*
285			* @param string $column The name of the column to update
286			* @param array $forum_ids An array of forum_ids
287			*/
288			protected function update_forum($column, $forum_ids)
289			{
290			$this->db->sql_transaction('begin');
291
292			// Set marked forums (in set) to 1
293			$sql = 'UPDATE ' . FORUMS_TABLE . "
294			SET $column = 1
295			WHERE " . $this->db->sql_in_set('forum_id', $forum_ids, false, true);
296			$this->db->sql_query($sql);
297
298			// Set unmarked forums (not in set) to 0
299			$sql = 'UPDATE ' . FORUMS_TABLE . "
300			SET $column = 0
301			WHERE " . $this->db->sql_in_set('forum_id', $forum_ids, true, true);
302			$this->db->sql_query($sql);
303
304			$this->db->sql_transaction('commit');
305			}
306
307			/**
308			* Calculate the time in seconds based on requested time period length
309			*
310			* @access protected
311			* @param int $length user entered value
312			* @param string $type years, months, weeks, days (y\|m\|w\|d)
313			* @return int time in seconds
314			*/
315			protected function set_pst_time($length, $type = 'y')
316			{
317			$type = isset($this->times[$type]) ? $type : 'y';
318
319			return (int) ($length * $this->times[$type]);
320			}
321
322			/**
323			* Get the correct time period length value for the form
324			*
325			* @access protected
326			* @param int $time as a timestamp
327			* @param string $type years, months, weeks, days (y\|m\|w\|d)
328			* @return int time converted to the given $type
329			*/
330			protected function get_pst_time($time, $type = '')
331			{
332			return isset($this->times[$type]) ? (int) round($time / $this->times[$type]) : 0;
333			}
334
335			/**
336			* Return a variable if it is set, otherwise default
337			*
338			* @access protected
339			* @param mixed $var The variable to test
340			* @param mixed $default The default value to use
341			* @return mixed The value of the variable if set, otherwise default value
342			*/
343			protected function isset_or_default($var, $default)
344			{
345			return null !== $var ? $var : $default;
346			}
347
348			/**
349			* End script execution with a trigger_error message
350			*
351			* @access protected
352			* @param string $message Language key string
353			* @param int $code E_USER_NOTICE\|E_USER_WARNING
354			* @return void
355			*/
356			protected function end($message, $code = E_USER_NOTICE)
357			{
358			trigger_error($this->user->lang($message) . adm_back_link($this->u_action), $code);
359			}
360			}
361

iMattPro / similartopics

Pull Request — master (#25)

similar_topics_module::enable_fulltext_support() A

Complexity

Size

Duplication

Importance

Available Fixes

Available Fixes

Duplication Side-by-Side

Filter issues like