| Conditions | 43 |
| Paths | > 20000 |
| Total Lines | 199 |
| Code Lines | 101 |
| Lines | 0 |
| Ratio | 0 % |
| Changes | 2 | ||
| Bugs | 0 | Features | 1 |
Small methods make your code easier to understand, in particular if combined with a good name. Besides, if your method is small, finding a good name is usually much easier.
For example, if you find yourself adding comments to a method's body, this is usually a good sign to extract the commented part to a new method, and use the comment as a starting point when coming up with a good name for this new method.
Commonly applied refactorings include:
If many parameters/temporary variables are present:
| 1 | <?php |
||
| 146 | public function display_similar_topics($topic_data) |
||
| 147 | { |
||
| 148 | $topic_title = $this->clean_topic_title($topic_data['topic_title']); |
||
| 149 | |||
| 150 | // If the cleaned up topic_title is empty, no need to continue |
||
| 151 | if (empty($topic_title)) |
||
| 152 | { |
||
| 153 | return; |
||
| 154 | } |
||
| 155 | |||
| 156 | // Similar Topics query |
||
| 157 | $sql_array = array( |
||
| 158 | 'SELECT' => "f.forum_id, f.forum_name, t.*, |
||
| 159 | MATCH (t.topic_title) AGAINST ('" . $this->db->sql_escape($topic_title) . "') AS score", |
||
| 160 | |||
| 161 | 'FROM' => array( |
||
| 162 | TOPICS_TABLE => 't', |
||
| 163 | ), |
||
| 164 | 'LEFT_JOIN' => array( |
||
| 165 | array( |
||
| 166 | 'FROM' => array(FORUMS_TABLE => 'f'), |
||
| 167 | 'ON' => 'f.forum_id = t.forum_id', |
||
| 168 | ), |
||
| 169 | ), |
||
| 170 | 'WHERE' => "MATCH (t.topic_title) AGAINST ('" . $this->db->sql_escape($topic_title) . "') >= 0.5 |
||
| 171 | AND t.topic_status <> " . ITEM_MOVED . ' |
||
| 172 | AND t.topic_visibility = ' . ITEM_APPROVED . ' |
||
| 173 | AND t.topic_time > (UNIX_TIMESTAMP() - ' . $this->config['similar_topics_time'] . ') |
||
| 174 | AND t.topic_id <> ' . (int) $topic_data['topic_id'], |
||
| 175 | //'GROUP_BY' => 't.topic_id', |
||
| 176 | //'ORDER_BY' => 'score DESC', // this is done automatically by MySQL when not using IN BOOLEAN MODE |
||
| 177 | ); |
||
| 178 | |||
| 179 | // Add topic tracking data to the query (only if query caching is off) |
||
| 180 | if ($this->user->data['is_registered'] && $this->config['load_db_lastread'] && !$this->config['similar_topics_cache']) |
||
| 181 | { |
||
| 182 | $sql_array['LEFT_JOIN'][] = array('FROM' => array(TOPICS_TRACK_TABLE => 'tt'), 'ON' => 'tt.topic_id = t.topic_id AND tt.user_id = ' . $this->user->data['user_id']); |
||
| 183 | $sql_array['LEFT_JOIN'][] = array('FROM' => array(FORUMS_TRACK_TABLE => 'ft'), 'ON' => 'ft.forum_id = f.forum_id AND ft.user_id = ' . $this->user->data['user_id']); |
||
| 184 | $sql_array['SELECT'] .= ', tt.mark_time, ft.mark_time as f_mark_time'; |
||
| 185 | } |
||
| 186 | else if ($this->config['load_anon_lastread'] || $this->user->data['is_registered']) |
||
| 187 | { |
||
| 188 | // Cookie based tracking copied from search.php |
||
| 189 | $tracking_topics = $this->request->variable($this->config['cookie_name'] . '_track', '', true, \phpbb\request\request_interface::COOKIE); |
||
| 190 | $tracking_topics = ($tracking_topics) ? tracking_unserialize($tracking_topics) : array(); |
||
| 191 | } |
||
| 192 | |||
| 193 | // We need to exclude passworded forums so we do not leak the topic title |
||
| 194 | $passworded_forums = $this->user->get_passworded_forums(); |
||
| 195 | |||
| 196 | // See if the admin set this forum to only search a specific group of other forums, and include them |
||
| 197 | if (!empty($topic_data['similar_topic_forums'])) |
||
| 198 | { |
||
| 199 | // Remove any passworded forums from this group of forums we will be searching |
||
| 200 | $included_forums = array_diff(explode(',', $topic_data['similar_topic_forums']), $passworded_forums); |
||
| 201 | // if there's nothing left to display (user has no access to the forums we want to search) |
||
| 202 | if (empty($included_forums)) |
||
| 203 | { |
||
| 204 | return; |
||
| 205 | } |
||
| 206 | |||
| 207 | $sql_array['WHERE'] .= ' AND ' . $this->db->sql_in_set('f.forum_id', $included_forums); |
||
| 208 | } |
||
| 209 | // Otherwise, see what forums are not allowed to be searched, and exclude them |
||
| 210 | else if (!empty($this->config['similar_topics_ignore'])) |
||
| 211 | { |
||
| 212 | // Add passworded forums to the exlude array |
||
| 213 | $excluded_forums = array_unique(array_merge(explode(',', $this->config['similar_topics_ignore']), $passworded_forums)); |
||
| 214 | $sql_array['WHERE'] .= ' AND ' . $this->db->sql_in_set('f.forum_id', $excluded_forums, true); |
||
| 215 | } |
||
| 216 | // In all other cases, exclude any passworded forums the user is not allowed to view |
||
| 217 | else if (!empty($passworded_forums)) |
||
| 218 | { |
||
| 219 | $sql_array['WHERE'] .= ' AND ' . $this->db->sql_in_set('f.forum_id', $passworded_forums, true); |
||
| 220 | } |
||
| 221 | |||
| 222 | /** |
||
| 223 | * Event to modify the sql_array for similar topics |
||
| 224 | * |
||
| 225 | * @event vse.similartopics.get_topic_data |
||
| 226 | * @var array sql_array SQL array to get similar topics data |
||
| 227 | * @since 1.3.0 |
||
| 228 | */ |
||
| 229 | $vars = array('sql_array'); |
||
| 230 | extract($this->dispatcher->trigger_event('vse.similartopics.get_topic_data', compact($vars))); |
||
| 231 | |||
| 232 | $sql = $this->db->sql_build_query('SELECT', $sql_array); |
||
| 233 | $result = $this->db->sql_query_limit($sql, $this->config['similar_topics_limit'], 0, $this->config['similar_topics_cache']); |
||
| 234 | |||
| 235 | // Grab icons |
||
| 236 | $icons = $this->cache->obtain_icons(); |
||
| 237 | |||
| 238 | $rowset = array(); |
||
| 239 | |||
| 240 | while ($row = $this->db->sql_fetchrow($result)) |
||
| 241 | { |
||
| 242 | $similar_forum_id = (int) $row['forum_id']; |
||
| 243 | $similar_topic_id = (int) $row['topic_id']; |
||
| 244 | $rowset[$similar_topic_id] = $row; |
||
| 245 | |||
| 246 | if ($this->auth->acl_get('f_read', $similar_forum_id)) |
||
| 247 | { |
||
| 248 | // Get topic tracking info |
||
| 249 | if ($this->user->data['is_registered'] && $this->config['load_db_lastread'] && !$this->config['similar_topics_cache']) |
||
| 250 | { |
||
| 251 | $topic_tracking_info = get_topic_tracking($similar_forum_id, $similar_topic_id, $rowset, array($similar_forum_id => $row['f_mark_time'])); |
||
| 252 | } |
||
| 253 | else if ($this->config['load_anon_lastread'] || $this->user->data['is_registered']) |
||
| 254 | { |
||
| 255 | $topic_tracking_info = get_complete_topic_tracking($similar_forum_id, $similar_topic_id); |
||
| 256 | |||
| 257 | if (!$this->user->data['is_registered']) |
||
| 258 | { |
||
| 259 | $this->user->data['user_lastmark'] = (isset($tracking_topics['l'])) ? (int) (base_convert($tracking_topics['l'], 36, 10) + $this->config['board_startdate']) : 0; |
||
| 260 | } |
||
| 261 | } |
||
| 262 | |||
| 263 | // Replies |
||
| 264 | $replies = $this->content_visibility->get_count('topic_posts', $row, $similar_forum_id) - 1; |
||
| 265 | |||
| 266 | // Get folder img, topic status/type related information |
||
| 267 | $folder_img = $folder_alt = $topic_type = ''; |
||
| 268 | $unread_topic = (isset($topic_tracking_info[$similar_topic_id]) && $row['topic_last_post_time'] > $topic_tracking_info[$similar_topic_id]) ? true : false; |
||
| 269 | topic_status($row, $replies, $unread_topic, $folder_img, $folder_alt, $topic_type); |
||
| 270 | |||
| 271 | $topic_unapproved = ($row['topic_visibility'] == ITEM_UNAPPROVED && $this->auth->acl_get('m_approve', $similar_forum_id)) ? true : false; |
||
| 272 | $posts_unapproved = ($row['topic_visibility'] == ITEM_APPROVED && $row['topic_posts_unapproved'] && $this->auth->acl_get('m_approve', $similar_forum_id)) ? true : false; |
||
| 273 | //$topic_deleted = $row['topic_visibility'] == ITEM_DELETED; |
||
| 274 | $u_mcp_queue = ($topic_unapproved || $posts_unapproved) ? append_sid("{$this->root_path}mcp.{$this->php_ext}", 'i=queue&mode=' . (($topic_unapproved) ? 'approve_details' : 'unapproved_posts') . "&t=$similar_topic_id", true, $this->user->session_id) : ''; |
||
| 275 | //$u_mcp_queue = (!$u_mcp_queue && $topic_deleted) ? append_sid("{$this->root_path}mcp.{$this->php_ext}", "i=queue&mode=deleted_topics&t=$similar_topic_id", true, $this->user->session_id) : $u_mcp_queue; |
||
| 276 | |||
| 277 | $base_url = append_sid("{$this->root_path}viewtopic.{$this->php_ext}", 'f=' . $similar_forum_id . '&t=' . $similar_topic_id); |
||
| 278 | |||
| 279 | $topic_row = array( |
||
| 280 | 'TOPIC_AUTHOR_FULL' => get_username_string('full', $row['topic_poster'], $row['topic_first_poster_name'], $row['topic_first_poster_colour']), |
||
| 281 | 'FIRST_POST_TIME' => $this->user->format_date($row['topic_time']), |
||
| 282 | 'LAST_POST_TIME' => $this->user->format_date($row['topic_last_post_time']), |
||
| 283 | 'LAST_POST_AUTHOR_FULL' => get_username_string('full', $row['topic_last_poster_id'], $row['topic_last_poster_name'], $row['topic_last_poster_colour']), |
||
| 284 | |||
| 285 | 'TOPIC_REPLIES' => $replies, |
||
| 286 | 'TOPIC_VIEWS' => $row['topic_views'], |
||
| 287 | 'TOPIC_TITLE' => censor_text($row['topic_title']), |
||
| 288 | 'FORUM_TITLE' => $row['forum_name'], |
||
| 289 | |||
| 290 | 'TOPIC_IMG_STYLE' => $folder_img, |
||
| 291 | 'TOPIC_FOLDER_IMG' => $this->user->img($folder_img, $folder_alt), |
||
| 292 | 'TOPIC_FOLDER_IMG_ALT' => $this->language->lang($folder_alt), |
||
| 293 | |||
| 294 | 'TOPIC_ICON_IMG' => (!empty($icons[$row['icon_id']])) ? $icons[$row['icon_id']]['img'] : '', |
||
| 295 | 'TOPIC_ICON_IMG_WIDTH' => (!empty($icons[$row['icon_id']])) ? $icons[$row['icon_id']]['width'] : '', |
||
| 296 | 'TOPIC_ICON_IMG_HEIGHT' => (!empty($icons[$row['icon_id']])) ? $icons[$row['icon_id']]['height'] : '', |
||
| 297 | 'ATTACH_ICON_IMG' => ($this->auth->acl_get('u_download') && $this->auth->acl_get('f_download', $similar_forum_id) && $row['topic_attachment']) ? $this->user->img('icon_topic_attach', $this->language->lang('TOTAL_ATTACHMENTS')) : '', |
||
| 298 | 'UNAPPROVED_IMG' => ($topic_unapproved || $posts_unapproved) ? $this->user->img('icon_topic_unapproved', ($topic_unapproved) ? 'TOPIC_UNAPPROVED' : 'POSTS_UNAPPROVED') : '', |
||
| 299 | |||
| 300 | 'S_UNREAD_TOPIC' => $unread_topic, |
||
| 301 | 'S_TOPIC_REPORTED' => (!empty($row['topic_reported']) && $this->auth->acl_get('m_report', $similar_forum_id)) ? true : false, |
||
| 302 | 'S_TOPIC_UNAPPROVED' => $topic_unapproved, |
||
| 303 | 'S_POSTS_UNAPPROVED' => $posts_unapproved, |
||
| 304 | //'S_TOPIC_DELETED' => $topic_deleted, |
||
| 305 | 'S_HAS_POLL' => ($row['poll_start']) ? true : false, |
||
| 306 | |||
| 307 | 'U_NEWEST_POST' => append_sid("{$this->root_path}viewtopic.{$this->php_ext}", 'f=' . $similar_forum_id . '&t=' . $similar_topic_id . '&view=unread') . '#unread', |
||
| 308 | 'U_LAST_POST' => append_sid("{$this->root_path}viewtopic.{$this->php_ext}", 'f=' . $similar_forum_id . '&t=' . $similar_topic_id . '&p=' . $row['topic_last_post_id']) . '#p' . $row['topic_last_post_id'], |
||
| 309 | 'U_VIEW_TOPIC' => append_sid("{$this->root_path}viewtopic.{$this->php_ext}", 'f=' . $similar_forum_id . '&t=' . $similar_topic_id), |
||
| 310 | 'U_VIEW_FORUM' => append_sid("{$this->root_path}viewforum.{$this->php_ext}", 'f=' . $similar_forum_id), |
||
| 311 | 'U_MCP_REPORT' => append_sid("{$this->root_path}mcp.{$this->php_ext}", 'i=reports&mode=reports&f=' . $similar_forum_id . '&t=' . $similar_topic_id, true, $this->user->session_id), |
||
| 312 | 'U_MCP_QUEUE' => $u_mcp_queue, |
||
| 313 | ); |
||
| 314 | |||
| 315 | /** |
||
| 316 | * Event to modify the similar topics template block |
||
| 317 | * |
||
| 318 | * @event vse.similartopics.modify_topicrow |
||
| 319 | * @var array row Array with similar topic data |
||
| 320 | * @var array topic_row Template block array |
||
| 321 | * @since 1.3.0 |
||
| 322 | */ |
||
| 323 | $vars = array('row', 'topic_row'); |
||
| 324 | extract($this->dispatcher->trigger_event('vse.similartopics.modify_topicrow', compact($vars))); |
||
| 325 | |||
| 326 | $this->template->assign_block_vars('similar', $topic_row); |
||
| 327 | |||
| 328 | $this->pagination->generate_template_pagination($base_url, 'similar.pagination', 'start', $replies + 1, $this->config['posts_per_page'], 1, true, true); |
||
| 329 | } |
||
| 330 | } |
||
| 331 | |||
| 332 | $this->db->sql_freeresult($result); |
||
| 333 | |||
| 334 | $this->language->add_lang('similar_topics', 'vse/similartopics'); |
||
| 335 | |||
| 336 | $this->template->assign_vars(array( |
||
| 337 | 'L_SIMILAR_TOPICS' => $this->language->lang('SIMILAR_TOPICS'), |
||
| 338 | 'NEWEST_POST_IMG' => $this->user->img('icon_topic_newest', 'VIEW_NEWEST_POST'), |
||
| 339 | 'LAST_POST_IMG' => $this->user->img('icon_topic_latest', 'VIEW_LATEST_POST'), |
||
| 340 | 'REPORTED_IMG' => $this->user->img('icon_topic_reported', 'TOPIC_REPORTED'), |
||
| 341 | //'DELETED_IMG' => $this->user->img('icon_topic_deleted', 'TOPIC_DELETED'), |
||
| 342 | 'POLL_IMG' => $this->user->img('icon_topic_poll', 'TOPIC_POLL'), |
||
| 343 | )); |
||
| 344 | } |
||
| 345 | |||
| 457 |
In PHP it is possible to write to properties without declaring them. For example, the following is perfectly valid PHP code:
Generally, it is a good practice to explictly declare properties to avoid accidental typos and provide IDE auto-completion: