@@ -13,8 +13,9 @@ discard block |
||
13 | 13 | * @version 2.1 Beta 3 |
14 | 14 | */ |
15 | 15 | |
16 | -if (!defined('SMF')) |
|
16 | +if (!defined('SMF')) { |
|
17 | 17 | die('No direct access...'); |
18 | +} |
|
18 | 19 | |
19 | 20 | // This defines two version types for checking the API's are compatible with this version of SMF. |
20 | 21 | $GLOBALS['search_versions'] = array( |
@@ -39,8 +40,9 @@ discard block |
||
39 | 40 | global $txt, $scripturl, $modSettings, $user_info, $context, $smcFunc, $sourcedir; |
40 | 41 | |
41 | 42 | // Is the load average too high to allow searching just now? |
42 | - if (!empty($context['load_average']) && !empty($modSettings['loadavg_search']) && $context['load_average'] >= $modSettings['loadavg_search']) |
|
43 | - fatal_lang_error('loadavg_search_disabled', false); |
|
43 | + if (!empty($context['load_average']) && !empty($modSettings['loadavg_search']) && $context['load_average'] >= $modSettings['loadavg_search']) { |
|
44 | + fatal_lang_error('loadavg_search_disabled', false); |
|
45 | + } |
|
44 | 46 | |
45 | 47 | loadLanguage('Search'); |
46 | 48 | // Don't load this in XML mode. |
@@ -88,23 +90,30 @@ discard block |
||
88 | 90 | @list ($k, $v) = explode('|\'|', $data); |
89 | 91 | $context['search_params'][$k] = $v; |
90 | 92 | } |
91 | - if (isset($context['search_params']['brd'])) |
|
92 | - $context['search_params']['brd'] = $context['search_params']['brd'] == '' ? array() : explode(',', $context['search_params']['brd']); |
|
93 | + if (isset($context['search_params']['brd'])) { |
|
94 | + $context['search_params']['brd'] = $context['search_params']['brd'] == '' ? array() : explode(',', $context['search_params']['brd']); |
|
95 | + } |
|
93 | 96 | } |
94 | 97 | |
95 | - if (isset($_REQUEST['search'])) |
|
96 | - $context['search_params']['search'] = un_htmlspecialchars($_REQUEST['search']); |
|
98 | + if (isset($_REQUEST['search'])) { |
|
99 | + $context['search_params']['search'] = un_htmlspecialchars($_REQUEST['search']); |
|
100 | + } |
|
97 | 101 | |
98 | - if (isset($context['search_params']['search'])) |
|
99 | - $context['search_params']['search'] = $smcFunc['htmlspecialchars']($context['search_params']['search']); |
|
100 | - if (isset($context['search_params']['userspec'])) |
|
101 | - $context['search_params']['userspec'] = $smcFunc['htmlspecialchars']($context['search_params']['userspec']); |
|
102 | - if (!empty($context['search_params']['searchtype'])) |
|
103 | - $context['search_params']['searchtype'] = 2; |
|
104 | - if (!empty($context['search_params']['minage'])) |
|
105 | - $context['search_params']['minage'] = (int) $context['search_params']['minage']; |
|
106 | - if (!empty($context['search_params']['maxage'])) |
|
107 | - $context['search_params']['maxage'] = (int) $context['search_params']['maxage']; |
|
102 | + if (isset($context['search_params']['search'])) { |
|
103 | + $context['search_params']['search'] = $smcFunc['htmlspecialchars']($context['search_params']['search']); |
|
104 | + } |
|
105 | + if (isset($context['search_params']['userspec'])) { |
|
106 | + $context['search_params']['userspec'] = $smcFunc['htmlspecialchars']($context['search_params']['userspec']); |
|
107 | + } |
|
108 | + if (!empty($context['search_params']['searchtype'])) { |
|
109 | + $context['search_params']['searchtype'] = 2; |
|
110 | + } |
|
111 | + if (!empty($context['search_params']['minage'])) { |
|
112 | + $context['search_params']['minage'] = (int) $context['search_params']['minage']; |
|
113 | + } |
|
114 | + if (!empty($context['search_params']['maxage'])) { |
|
115 | + $context['search_params']['maxage'] = (int) $context['search_params']['maxage']; |
|
116 | + } |
|
108 | 117 | |
109 | 118 | $context['search_params']['show_complete'] = !empty($context['search_params']['show_complete']); |
110 | 119 | $context['search_params']['subject_only'] = !empty($context['search_params']['subject_only']); |
@@ -116,11 +125,13 @@ discard block |
||
116 | 125 | $context['search_errors']['messages'] = array(); |
117 | 126 | foreach ($context['search_errors'] as $search_error => $dummy) |
118 | 127 | { |
119 | - if ($search_error === 'messages') |
|
120 | - continue; |
|
128 | + if ($search_error === 'messages') { |
|
129 | + continue; |
|
130 | + } |
|
121 | 131 | |
122 | - if ($search_error == 'string_too_long') |
|
123 | - $txt['error_string_too_long'] = sprintf($txt['error_string_too_long'], $context['search_string_limit']); |
|
132 | + if ($search_error == 'string_too_long') { |
|
133 | + $txt['error_string_too_long'] = sprintf($txt['error_string_too_long'], $context['search_string_limit']); |
|
134 | + } |
|
124 | 135 | |
125 | 136 | $context['search_errors']['messages'][] = $txt['error_' . $search_error]; |
126 | 137 | } |
@@ -143,12 +154,13 @@ discard block |
||
143 | 154 | while ($row = $smcFunc['db_fetch_assoc']($request)) |
144 | 155 | { |
145 | 156 | // This category hasn't been set up yet.. |
146 | - if (!isset($context['categories'][$row['id_cat']])) |
|
147 | - $context['categories'][$row['id_cat']] = array( |
|
157 | + if (!isset($context['categories'][$row['id_cat']])) { |
|
158 | + $context['categories'][$row['id_cat']] = array( |
|
148 | 159 | 'id' => $row['id_cat'], |
149 | 160 | 'name' => $row['cat_name'], |
150 | 161 | 'boards' => array() |
151 | 162 | ); |
163 | + } |
|
152 | 164 | |
153 | 165 | // Set this board up, and let the template know when it's a child. (indent them..) |
154 | 166 | $context['categories'][$row['id_cat']]['boards'][$row['id_board']] = array( |
@@ -159,8 +171,9 @@ discard block |
||
159 | 171 | ); |
160 | 172 | |
161 | 173 | // If a board wasn't checked that probably should have been ensure the board selection is selected, yo! |
162 | - if (!$context['categories'][$row['id_cat']]['boards'][$row['id_board']]['selected'] && (empty($modSettings['recycle_enable']) || $row['id_board'] != $modSettings['recycle_board'])) |
|
163 | - $context['boards_check_all'] = false; |
|
174 | + if (!$context['categories'][$row['id_cat']]['boards'][$row['id_board']]['selected'] && (empty($modSettings['recycle_enable']) || $row['id_board'] != $modSettings['recycle_board'])) { |
|
175 | + $context['boards_check_all'] = false; |
|
176 | + } |
|
164 | 177 | } |
165 | 178 | $smcFunc['db_free_result']($request); |
166 | 179 | |
@@ -182,18 +195,20 @@ discard block |
||
182 | 195 | } |
183 | 196 | |
184 | 197 | $max_boards = ceil(count($temp_boards) / 2); |
185 | - if ($max_boards == 1) |
|
186 | - $max_boards = 2; |
|
198 | + if ($max_boards == 1) { |
|
199 | + $max_boards = 2; |
|
200 | + } |
|
187 | 201 | |
188 | 202 | // Now, alternate them so they can be shown left and right ;). |
189 | 203 | $context['board_columns'] = array(); |
190 | 204 | for ($i = 0; $i < $max_boards; $i++) |
191 | 205 | { |
192 | 206 | $context['board_columns'][] = $temp_boards[$i]; |
193 | - if (isset($temp_boards[$i + $max_boards])) |
|
194 | - $context['board_columns'][] = $temp_boards[$i + $max_boards]; |
|
195 | - else |
|
196 | - $context['board_columns'][] = array(); |
|
207 | + if (isset($temp_boards[$i + $max_boards])) { |
|
208 | + $context['board_columns'][] = $temp_boards[$i + $max_boards]; |
|
209 | + } else { |
|
210 | + $context['board_columns'][] = array(); |
|
211 | + } |
|
197 | 212 | } |
198 | 213 | |
199 | 214 | if (!empty($_REQUEST['topic'])) |
@@ -225,8 +240,9 @@ discard block |
||
225 | 240 | ) |
226 | 241 | ); |
227 | 242 | |
228 | - if ($smcFunc['db_num_rows']($request) == 0) |
|
229 | - fatal_lang_error('topic_gone', false); |
|
243 | + if ($smcFunc['db_num_rows']($request) == 0) { |
|
244 | + fatal_lang_error('topic_gone', false); |
|
245 | + } |
|
230 | 246 | |
231 | 247 | list ($context['search_topic']['subject']) = $smcFunc['db_fetch_row']($request); |
232 | 248 | $smcFunc['db_free_result']($request); |
@@ -256,11 +272,13 @@ discard block |
||
256 | 272 | global $excludedWords, $participants, $smcFunc; |
257 | 273 | |
258 | 274 | // if comming from the quick search box, and we want to search on members, well we need to do that ;) |
259 | - if (isset($_REQUEST['search_selection']) && $_REQUEST['search_selection'] === 'members') |
|
260 | - redirectexit($scripturl . '?action=mlist;sa=search;fields=name,email;search=' . urlencode($_REQUEST['search'])); |
|
275 | + if (isset($_REQUEST['search_selection']) && $_REQUEST['search_selection'] === 'members') { |
|
276 | + redirectexit($scripturl . '?action=mlist;sa=search;fields=name,email;search=' . urlencode($_REQUEST['search'])); |
|
277 | + } |
|
261 | 278 | |
262 | - if (!empty($context['load_average']) && !empty($modSettings['loadavg_search']) && $context['load_average'] >= $modSettings['loadavg_search']) |
|
263 | - fatal_lang_error('loadavg_search_disabled', false); |
|
279 | + if (!empty($context['load_average']) && !empty($modSettings['loadavg_search']) && $context['load_average'] >= $modSettings['loadavg_search']) { |
|
280 | + fatal_lang_error('loadavg_search_disabled', false); |
|
281 | + } |
|
264 | 282 | |
265 | 283 | // No, no, no... this is a bit hard on the server, so don't you go prefetching it! |
266 | 284 | if (isset($_SERVER['HTTP_X_MOZ']) && $_SERVER['HTTP_X_MOZ'] == 'prefetch') |
@@ -307,8 +325,9 @@ discard block |
||
307 | 325 | } |
308 | 326 | |
309 | 327 | // Zero weight. Weightless :P. |
310 | - if (empty($weight_total)) |
|
311 | - fatal_lang_error('search_invalid_weights'); |
|
328 | + if (empty($weight_total)) { |
|
329 | + fatal_lang_error('search_invalid_weights'); |
|
330 | + } |
|
312 | 331 | |
313 | 332 | // These vars don't require an interface, they're just here for tweaking. |
314 | 333 | $recentPercentage = 0.30; |
@@ -326,11 +345,13 @@ discard block |
||
326 | 345 | $context['search_string_limit'] = 100; |
327 | 346 | |
328 | 347 | loadLanguage('Search'); |
329 | - if (!isset($_REQUEST['xml'])) |
|
330 | - loadTemplate('Search'); |
|
348 | + if (!isset($_REQUEST['xml'])) { |
|
349 | + loadTemplate('Search'); |
|
350 | + } |
|
331 | 351 | //If we're doing XML we need to use the results template regardless really. |
332 | - else |
|
333 | - $context['sub_template'] = 'results'; |
|
352 | + else { |
|
353 | + $context['sub_template'] = 'results'; |
|
354 | + } |
|
334 | 355 | |
335 | 356 | // Are you allowed? |
336 | 357 | isAllowedTo('search_posts'); |
@@ -363,34 +384,39 @@ discard block |
||
363 | 384 | $search_params[$k] = $v; |
364 | 385 | } |
365 | 386 | |
366 | - if (isset($search_params['brd'])) |
|
367 | - $search_params['brd'] = empty($search_params['brd']) ? array() : explode(',', $search_params['brd']); |
|
387 | + if (isset($search_params['brd'])) { |
|
388 | + $search_params['brd'] = empty($search_params['brd']) ? array() : explode(',', $search_params['brd']); |
|
389 | + } |
|
368 | 390 | } |
369 | 391 | |
370 | 392 | // Store whether simple search was used (needed if the user wants to do another query). |
371 | - if (!isset($search_params['advanced'])) |
|
372 | - $search_params['advanced'] = empty($_REQUEST['advanced']) ? 0 : 1; |
|
393 | + if (!isset($search_params['advanced'])) { |
|
394 | + $search_params['advanced'] = empty($_REQUEST['advanced']) ? 0 : 1; |
|
395 | + } |
|
373 | 396 | |
374 | 397 | // 1 => 'allwords' (default, don't set as param) / 2 => 'anywords'. |
375 | - if (!empty($search_params['searchtype']) || (!empty($_REQUEST['searchtype']) && $_REQUEST['searchtype'] == 2)) |
|
376 | - $search_params['searchtype'] = 2; |
|
398 | + if (!empty($search_params['searchtype']) || (!empty($_REQUEST['searchtype']) && $_REQUEST['searchtype'] == 2)) { |
|
399 | + $search_params['searchtype'] = 2; |
|
400 | + } |
|
377 | 401 | |
378 | 402 | // Minimum age of messages. Default to zero (don't set param in that case). |
379 | - if (!empty($search_params['minage']) || (!empty($_REQUEST['minage']) && $_REQUEST['minage'] > 0)) |
|
380 | - $search_params['minage'] = !empty($search_params['minage']) ? (int) $search_params['minage'] : (int) $_REQUEST['minage']; |
|
403 | + if (!empty($search_params['minage']) || (!empty($_REQUEST['minage']) && $_REQUEST['minage'] > 0)) { |
|
404 | + $search_params['minage'] = !empty($search_params['minage']) ? (int) $search_params['minage'] : (int) $_REQUEST['minage']; |
|
405 | + } |
|
381 | 406 | |
382 | 407 | // Maximum age of messages. Default to infinite (9999 days: param not set). |
383 | - if (!empty($search_params['maxage']) || (!empty($_REQUEST['maxage']) && $_REQUEST['maxage'] < 9999)) |
|
384 | - $search_params['maxage'] = !empty($search_params['maxage']) ? (int) $search_params['maxage'] : (int) $_REQUEST['maxage']; |
|
408 | + if (!empty($search_params['maxage']) || (!empty($_REQUEST['maxage']) && $_REQUEST['maxage'] < 9999)) { |
|
409 | + $search_params['maxage'] = !empty($search_params['maxage']) ? (int) $search_params['maxage'] : (int) $_REQUEST['maxage']; |
|
410 | + } |
|
385 | 411 | |
386 | 412 | // Searching a specific topic? |
387 | 413 | if (!empty($_REQUEST['topic']) || (!empty($_REQUEST['search_selection']) && $_REQUEST['search_selection'] == 'topic')) |
388 | 414 | { |
389 | 415 | $search_params['topic'] = empty($_REQUEST['search_selection']) ? (int) $_REQUEST['topic'] : (isset($_REQUEST['sd_topic']) ? (int) $_REQUEST['sd_topic'] : ''); |
390 | 416 | $search_params['show_complete'] = true; |
417 | + } elseif (!empty($search_params['topic'])) { |
|
418 | + $search_params['topic'] = (int) $search_params['topic']; |
|
391 | 419 | } |
392 | - elseif (!empty($search_params['topic'])) |
|
393 | - $search_params['topic'] = (int) $search_params['topic']; |
|
394 | 420 | |
395 | 421 | if (!empty($search_params['minage']) || !empty($search_params['maxage'])) |
396 | 422 | { |
@@ -408,19 +434,21 @@ discard block |
||
408 | 434 | ) |
409 | 435 | ); |
410 | 436 | list ($minMsgID, $maxMsgID) = $smcFunc['db_fetch_row']($request); |
411 | - if ($minMsgID < 0 || $maxMsgID < 0) |
|
412 | - $context['search_errors']['no_messages_in_time_frame'] = true; |
|
437 | + if ($minMsgID < 0 || $maxMsgID < 0) { |
|
438 | + $context['search_errors']['no_messages_in_time_frame'] = true; |
|
439 | + } |
|
413 | 440 | $smcFunc['db_free_result']($request); |
414 | 441 | } |
415 | 442 | |
416 | 443 | // Default the user name to a wildcard matching every user (*). |
417 | - if (!empty($search_params['userspec']) || (!empty($_REQUEST['userspec']) && $_REQUEST['userspec'] != '*')) |
|
418 | - $search_params['userspec'] = isset($search_params['userspec']) ? $search_params['userspec'] : $_REQUEST['userspec']; |
|
444 | + if (!empty($search_params['userspec']) || (!empty($_REQUEST['userspec']) && $_REQUEST['userspec'] != '*')) { |
|
445 | + $search_params['userspec'] = isset($search_params['userspec']) ? $search_params['userspec'] : $_REQUEST['userspec']; |
|
446 | + } |
|
419 | 447 | |
420 | 448 | // If there's no specific user, then don't mention it in the main query. |
421 | - if (empty($search_params['userspec'])) |
|
422 | - $userQuery = ''; |
|
423 | - else |
|
449 | + if (empty($search_params['userspec'])) { |
|
450 | + $userQuery = ''; |
|
451 | + } else |
|
424 | 452 | { |
425 | 453 | $userString = strtr($smcFunc['htmlspecialchars']($search_params['userspec'], ENT_QUOTES), array('"' => '"')); |
426 | 454 | $userString = strtr($userString, array('%' => '\%', '_' => '\_', '*' => '%', '?' => '_')); |
@@ -432,19 +460,21 @@ discard block |
||
432 | 460 | { |
433 | 461 | $possible_users[$k] = trim($possible_users[$k]); |
434 | 462 | |
435 | - if (strlen($possible_users[$k]) == 0) |
|
436 | - unset($possible_users[$k]); |
|
463 | + if (strlen($possible_users[$k]) == 0) { |
|
464 | + unset($possible_users[$k]); |
|
465 | + } |
|
437 | 466 | } |
438 | 467 | |
439 | 468 | // Create a list of database-escaped search names. |
440 | 469 | $realNameMatches = array(); |
441 | - foreach ($possible_users as $possible_user) |
|
442 | - $realNameMatches[] = $smcFunc['db_quote']( |
|
470 | + foreach ($possible_users as $possible_user) { |
|
471 | + $realNameMatches[] = $smcFunc['db_quote']( |
|
443 | 472 | '{string:possible_user}', |
444 | 473 | array( |
445 | 474 | 'possible_user' => $possible_user |
446 | 475 | ) |
447 | 476 | ); |
477 | + } |
|
448 | 478 | |
449 | 479 | // Retrieve a list of possible members. |
450 | 480 | $request = $smcFunc['db_query']('', ' |
@@ -456,9 +486,9 @@ discard block |
||
456 | 486 | ) |
457 | 487 | ); |
458 | 488 | // Simply do nothing if there're too many members matching the criteria. |
459 | - if ($smcFunc['db_num_rows']($request) > $maxMembersToSearch) |
|
460 | - $userQuery = ''; |
|
461 | - elseif ($smcFunc['db_num_rows']($request) == 0) |
|
489 | + if ($smcFunc['db_num_rows']($request) > $maxMembersToSearch) { |
|
490 | + $userQuery = ''; |
|
491 | + } elseif ($smcFunc['db_num_rows']($request) == 0) |
|
462 | 492 | { |
463 | 493 | $userQuery = $smcFunc['db_quote']( |
464 | 494 | 'm.id_member = {int:id_member_guest} AND ({raw:match_possible_guest_names})', |
@@ -467,12 +497,12 @@ discard block |
||
467 | 497 | 'match_possible_guest_names' => 'm.poster_name LIKE ' . implode(' OR m.poster_name LIKE ', $realNameMatches), |
468 | 498 | ) |
469 | 499 | ); |
470 | - } |
|
471 | - else |
|
500 | + } else |
|
472 | 501 | { |
473 | 502 | $memberlist = array(); |
474 | - while ($row = $smcFunc['db_fetch_assoc']($request)) |
|
475 | - $memberlist[] = $row['id_member']; |
|
503 | + while ($row = $smcFunc['db_fetch_assoc']($request)) { |
|
504 | + $memberlist[] = $row['id_member']; |
|
505 | + } |
|
476 | 506 | $userQuery = $smcFunc['db_quote']( |
477 | 507 | '(m.id_member IN ({array_int:matched_members}) OR (m.id_member = {int:id_member_guest} AND ({raw:match_possible_guest_names})))', |
478 | 508 | array( |
@@ -486,22 +516,25 @@ discard block |
||
486 | 516 | } |
487 | 517 | |
488 | 518 | // If the boards were passed by URL (params=), temporarily put them back in $_REQUEST. |
489 | - if (!empty($search_params['brd']) && is_array($search_params['brd'])) |
|
490 | - $_REQUEST['brd'] = $search_params['brd']; |
|
519 | + if (!empty($search_params['brd']) && is_array($search_params['brd'])) { |
|
520 | + $_REQUEST['brd'] = $search_params['brd']; |
|
521 | + } |
|
491 | 522 | |
492 | 523 | // Ensure that brd is an array. |
493 | 524 | if ((!empty($_REQUEST['brd']) && !is_array($_REQUEST['brd'])) || (!empty($_REQUEST['search_selection']) && $_REQUEST['search_selection'] == 'board')) |
494 | 525 | { |
495 | - if (!empty($_REQUEST['brd'])) |
|
496 | - $_REQUEST['brd'] = strpos($_REQUEST['brd'], ',') !== false ? explode(',', $_REQUEST['brd']) : array($_REQUEST['brd']); |
|
497 | - else |
|
498 | - $_REQUEST['brd'] = isset($_REQUEST['sd_brd']) ? array($_REQUEST['sd_brd']) : array(); |
|
526 | + if (!empty($_REQUEST['brd'])) { |
|
527 | + $_REQUEST['brd'] = strpos($_REQUEST['brd'], ',') !== false ? explode(',', $_REQUEST['brd']) : array($_REQUEST['brd']); |
|
528 | + } else { |
|
529 | + $_REQUEST['brd'] = isset($_REQUEST['sd_brd']) ? array($_REQUEST['sd_brd']) : array(); |
|
530 | + } |
|
499 | 531 | } |
500 | 532 | |
501 | 533 | // Make sure all boards are integers. |
502 | - if (!empty($_REQUEST['brd'])) |
|
503 | - foreach ($_REQUEST['brd'] as $id => $brd) |
|
534 | + if (!empty($_REQUEST['brd'])) { |
|
535 | + foreach ($_REQUEST['brd'] as $id => $brd) |
|
504 | 536 | $_REQUEST['brd'][$id] = (int) $brd; |
537 | + } |
|
505 | 538 | |
506 | 539 | // Special case for boards: searching just one topic? |
507 | 540 | if (!empty($search_params['topic'])) |
@@ -520,17 +553,18 @@ discard block |
||
520 | 553 | ) |
521 | 554 | ); |
522 | 555 | |
523 | - if ($smcFunc['db_num_rows']($request) == 0) |
|
524 | - fatal_lang_error('topic_gone', false); |
|
556 | + if ($smcFunc['db_num_rows']($request) == 0) { |
|
557 | + fatal_lang_error('topic_gone', false); |
|
558 | + } |
|
525 | 559 | |
526 | 560 | $search_params['brd'] = array(); |
527 | 561 | list ($search_params['brd'][0]) = $smcFunc['db_fetch_row']($request); |
528 | 562 | $smcFunc['db_free_result']($request); |
529 | 563 | } |
530 | 564 | // Select all boards you've selected AND are allowed to see. |
531 | - elseif ($user_info['is_admin'] && (!empty($search_params['advanced']) || !empty($_REQUEST['brd']))) |
|
532 | - $search_params['brd'] = empty($_REQUEST['brd']) ? array() : $_REQUEST['brd']; |
|
533 | - else |
|
565 | + elseif ($user_info['is_admin'] && (!empty($search_params['advanced']) || !empty($_REQUEST['brd']))) { |
|
566 | + $search_params['brd'] = empty($_REQUEST['brd']) ? array() : $_REQUEST['brd']; |
|
567 | + } else |
|
534 | 568 | { |
535 | 569 | $see_board = empty($search_params['advanced']) ? 'query_wanna_see_board' : 'query_see_board'; |
536 | 570 | $request = $smcFunc['db_query']('', ' |
@@ -548,19 +582,22 @@ discard block |
||
548 | 582 | ) |
549 | 583 | ); |
550 | 584 | $search_params['brd'] = array(); |
551 | - while ($row = $smcFunc['db_fetch_assoc']($request)) |
|
552 | - $search_params['brd'][] = $row['id_board']; |
|
585 | + while ($row = $smcFunc['db_fetch_assoc']($request)) { |
|
586 | + $search_params['brd'][] = $row['id_board']; |
|
587 | + } |
|
553 | 588 | $smcFunc['db_free_result']($request); |
554 | 589 | |
555 | 590 | // This error should pro'bly only happen for hackers. |
556 | - if (empty($search_params['brd'])) |
|
557 | - $context['search_errors']['no_boards_selected'] = true; |
|
591 | + if (empty($search_params['brd'])) { |
|
592 | + $context['search_errors']['no_boards_selected'] = true; |
|
593 | + } |
|
558 | 594 | } |
559 | 595 | |
560 | 596 | if (count($search_params['brd']) != 0) |
561 | 597 | { |
562 | - foreach ($search_params['brd'] as $k => $v) |
|
563 | - $search_params['brd'][$k] = (int) $v; |
|
598 | + foreach ($search_params['brd'] as $k => $v) { |
|
599 | + $search_params['brd'][$k] = (int) $v; |
|
600 | + } |
|
564 | 601 | |
565 | 602 | // If we've selected all boards, this parameter can be left empty. |
566 | 603 | $request = $smcFunc['db_query']('', ' |
@@ -574,15 +611,16 @@ discard block |
||
574 | 611 | list ($num_boards) = $smcFunc['db_fetch_row']($request); |
575 | 612 | $smcFunc['db_free_result']($request); |
576 | 613 | |
577 | - if (count($search_params['brd']) == $num_boards) |
|
614 | + if (count($search_params['brd']) == $num_boards) { |
|
615 | + $boardQuery = ''; |
|
616 | + } elseif (count($search_params['brd']) == $num_boards - 1 && !empty($modSettings['recycle_board']) && !in_array($modSettings['recycle_board'], $search_params['brd'])) { |
|
617 | + $boardQuery = '!= ' . $modSettings['recycle_board']; |
|
618 | + } else { |
|
619 | + $boardQuery = 'IN (' . implode(', ', $search_params['brd']) . ')'; |
|
620 | + } |
|
621 | + } else { |
|
578 | 622 | $boardQuery = ''; |
579 | - elseif (count($search_params['brd']) == $num_boards - 1 && !empty($modSettings['recycle_board']) && !in_array($modSettings['recycle_board'], $search_params['brd'])) |
|
580 | - $boardQuery = '!= ' . $modSettings['recycle_board']; |
|
581 | - else |
|
582 | - $boardQuery = 'IN (' . implode(', ', $search_params['brd']) . ')'; |
|
583 | 623 | } |
584 | - else |
|
585 | - $boardQuery = ''; |
|
586 | 624 | |
587 | 625 | $search_params['show_complete'] = !empty($search_params['show_complete']) || !empty($_REQUEST['show_complete']); |
588 | 626 | $search_params['subject_only'] = !empty($search_params['subject_only']) || !empty($_REQUEST['subject_only']); |
@@ -596,11 +634,13 @@ discard block |
||
596 | 634 | 'id_msg', |
597 | 635 | ); |
598 | 636 | call_integration_hook('integrate_search_sort_columns', array(&$sort_columns)); |
599 | - if (empty($search_params['sort']) && !empty($_REQUEST['sort'])) |
|
600 | - list ($search_params['sort'], $search_params['sort_dir']) = array_pad(explode('|', $_REQUEST['sort']), 2, ''); |
|
637 | + if (empty($search_params['sort']) && !empty($_REQUEST['sort'])) { |
|
638 | + list ($search_params['sort'], $search_params['sort_dir']) = array_pad(explode('|', $_REQUEST['sort']), 2, ''); |
|
639 | + } |
|
601 | 640 | $search_params['sort'] = !empty($search_params['sort']) && in_array($search_params['sort'], $sort_columns) ? $search_params['sort'] : 'relevance'; |
602 | - if (!empty($search_params['topic']) && $search_params['sort'] === 'num_replies') |
|
603 | - $search_params['sort'] = 'id_msg'; |
|
641 | + if (!empty($search_params['topic']) && $search_params['sort'] === 'num_replies') { |
|
642 | + $search_params['sort'] = 'id_msg'; |
|
643 | + } |
|
604 | 644 | |
605 | 645 | // Sorting direction: descending unless stated otherwise. |
606 | 646 | $search_params['sort_dir'] = !empty($search_params['sort_dir']) && $search_params['sort_dir'] == 'asc' ? 'asc' : 'desc'; |
@@ -624,17 +664,19 @@ discard block |
||
624 | 664 | // What are we searching for? |
625 | 665 | if (empty($search_params['search'])) |
626 | 666 | { |
627 | - if (isset($_GET['search'])) |
|
628 | - $search_params['search'] = un_htmlspecialchars($_GET['search']); |
|
629 | - elseif (isset($_POST['search'])) |
|
630 | - $search_params['search'] = $_POST['search']; |
|
631 | - else |
|
632 | - $search_params['search'] = ''; |
|
667 | + if (isset($_GET['search'])) { |
|
668 | + $search_params['search'] = un_htmlspecialchars($_GET['search']); |
|
669 | + } elseif (isset($_POST['search'])) { |
|
670 | + $search_params['search'] = $_POST['search']; |
|
671 | + } else { |
|
672 | + $search_params['search'] = ''; |
|
673 | + } |
|
633 | 674 | } |
634 | 675 | |
635 | 676 | // Nothing?? |
636 | - if (!isset($search_params['search']) || $search_params['search'] == '') |
|
637 | - $context['search_errors']['invalid_search_string'] = true; |
|
677 | + if (!isset($search_params['search']) || $search_params['search'] == '') { |
|
678 | + $context['search_errors']['invalid_search_string'] = true; |
|
679 | + } |
|
638 | 680 | // Too long? |
639 | 681 | elseif ($smcFunc['strlen']($search_params['search']) > $context['search_string_limit']) |
640 | 682 | { |
@@ -648,8 +690,9 @@ discard block |
||
648 | 690 | $stripped_query = un_htmlspecialchars($smcFunc['strtolower']($stripped_query)); |
649 | 691 | |
650 | 692 | // This (hidden) setting will do fulltext searching in the most basic way. |
651 | - if (!empty($modSettings['search_simple_fulltext'])) |
|
652 | - $stripped_query = strtr($stripped_query, array('"' => '')); |
|
693 | + if (!empty($modSettings['search_simple_fulltext'])) { |
|
694 | + $stripped_query = strtr($stripped_query, array('"' => '')); |
|
695 | + } |
|
653 | 696 | |
654 | 697 | $no_regexp = preg_match('~&#(?:\d{1,7}|x[0-9a-fA-F]{1,6});~', $stripped_query) === 1; |
655 | 698 | |
@@ -672,8 +715,9 @@ discard block |
||
672 | 715 | { |
673 | 716 | if ($word === '-') |
674 | 717 | { |
675 | - if (($word = trim($phraseArray[$index], '-_\' ')) !== '' && !in_array($word, $blacklisted_words)) |
|
676 | - $excludedWords[] = $word; |
|
718 | + if (($word = trim($phraseArray[$index], '-_\' ')) !== '' && !in_array($word, $blacklisted_words)) { |
|
719 | + $excludedWords[] = $word; |
|
720 | + } |
|
677 | 721 | unset($phraseArray[$index]); |
678 | 722 | } |
679 | 723 | } |
@@ -683,8 +727,9 @@ discard block |
||
683 | 727 | { |
684 | 728 | if (strpos(trim($word), '-') === 0) |
685 | 729 | { |
686 | - if (($word = trim($word, '-_\' ')) !== '' && !in_array($word, $blacklisted_words)) |
|
687 | - $excludedWords[] = $word; |
|
730 | + if (($word = trim($word, '-_\' ')) !== '' && !in_array($word, $blacklisted_words)) { |
|
731 | + $excludedWords[] = $word; |
|
732 | + } |
|
688 | 733 | unset($wordArray[$index]); |
689 | 734 | } |
690 | 735 | } |
@@ -697,8 +742,9 @@ discard block |
||
697 | 742 | foreach ($searchArray as $index => $value) |
698 | 743 | { |
699 | 744 | // Skip anything practically empty. |
700 | - if (($searchArray[$index] = trim($value, '-_\' ')) === '') |
|
701 | - unset($searchArray[$index]); |
|
745 | + if (($searchArray[$index] = trim($value, '-_\' ')) === '') { |
|
746 | + unset($searchArray[$index]); |
|
747 | + } |
|
702 | 748 | // Skip blacklisted words. Make sure to note we skipped them in case we end up with nothing. |
703 | 749 | elseif (in_array($searchArray[$index], $blacklisted_words)) |
704 | 750 | { |
@@ -710,39 +756,45 @@ discard block |
||
710 | 756 | { |
711 | 757 | $context['search_ignored'][] = $value; |
712 | 758 | unset($searchArray[$index]); |
759 | + } else { |
|
760 | + $searchArray[$index] = $searchArray[$index]; |
|
713 | 761 | } |
714 | - else |
|
715 | - $searchArray[$index] = $searchArray[$index]; |
|
716 | 762 | } |
717 | 763 | $searchArray = array_slice(array_unique($searchArray), 0, 10); |
718 | 764 | |
719 | 765 | // Create an array of replacements for highlighting. |
720 | 766 | $context['mark'] = array(); |
721 | - foreach ($searchArray as $word) |
|
722 | - $context['mark'][$word] = '<strong class="highlight">' . $word . '</strong>'; |
|
767 | + foreach ($searchArray as $word) { |
|
768 | + $context['mark'][$word] = '<strong class="highlight">' . $word . '</strong>'; |
|
769 | + } |
|
723 | 770 | |
724 | 771 | // Initialize two arrays storing the words that have to be searched for. |
725 | 772 | $orParts = array(); |
726 | 773 | $searchWords = array(); |
727 | 774 | |
728 | 775 | // Make sure at least one word is being searched for. |
729 | - if (empty($searchArray)) |
|
730 | - $context['search_errors']['invalid_search_string' . (!empty($foundBlackListedWords) ? '_blacklist' : '')] = true; |
|
776 | + if (empty($searchArray)) { |
|
777 | + $context['search_errors']['invalid_search_string' . (!empty($foundBlackListedWords) ? '_blacklist' : '')] = true; |
|
778 | + } |
|
731 | 779 | // All words/sentences must match. |
732 | - elseif (empty($search_params['searchtype'])) |
|
733 | - $orParts[0] = $searchArray; |
|
780 | + elseif (empty($search_params['searchtype'])) { |
|
781 | + $orParts[0] = $searchArray; |
|
782 | + } |
|
734 | 783 | // Any word/sentence must match. |
735 | - else |
|
736 | - foreach ($searchArray as $index => $value) |
|
784 | + else { |
|
785 | + foreach ($searchArray as $index => $value) |
|
737 | 786 | $orParts[$index] = array($value); |
787 | + } |
|
738 | 788 | |
739 | 789 | // Don't allow duplicate error messages if one string is too short. |
740 | - if (isset($context['search_errors']['search_string_small_words'], $context['search_errors']['invalid_search_string'])) |
|
741 | - unset($context['search_errors']['invalid_search_string']); |
|
790 | + if (isset($context['search_errors']['search_string_small_words'], $context['search_errors']['invalid_search_string'])) { |
|
791 | + unset($context['search_errors']['invalid_search_string']); |
|
792 | + } |
|
742 | 793 | // Make sure the excluded words are in all or-branches. |
743 | - foreach ($orParts as $orIndex => $andParts) |
|
744 | - foreach ($excludedWords as $word) |
|
794 | + foreach ($orParts as $orIndex => $andParts) { |
|
795 | + foreach ($excludedWords as $word) |
|
745 | 796 | $orParts[$orIndex][] = $word; |
797 | + } |
|
746 | 798 | |
747 | 799 | // Determine the or-branches and the fulltext search words. |
748 | 800 | foreach ($orParts as $orIndex => $andParts) |
@@ -756,8 +808,9 @@ discard block |
||
756 | 808 | ); |
757 | 809 | |
758 | 810 | // Sort the indexed words (large words -> small words -> excluded words). |
759 | - if ($searchAPI->supportsMethod('searchSort')) |
|
760 | - usort($orParts[$orIndex], 'searchSort'); |
|
811 | + if ($searchAPI->supportsMethod('searchSort')) { |
|
812 | + usort($orParts[$orIndex], 'searchSort'); |
|
813 | + } |
|
761 | 814 | |
762 | 815 | foreach ($orParts[$orIndex] as $word) |
763 | 816 | { |
@@ -769,15 +822,17 @@ discard block |
||
769 | 822 | if (!$is_excluded || count($subjectWords) === 1) |
770 | 823 | { |
771 | 824 | $searchWords[$orIndex]['subject_words'] = array_merge($searchWords[$orIndex]['subject_words'], $subjectWords); |
772 | - if ($is_excluded) |
|
773 | - $excludedSubjectWords = array_merge($excludedSubjectWords, $subjectWords); |
|
825 | + if ($is_excluded) { |
|
826 | + $excludedSubjectWords = array_merge($excludedSubjectWords, $subjectWords); |
|
827 | + } |
|
828 | + } else { |
|
829 | + $excludedPhrases[] = $word; |
|
774 | 830 | } |
775 | - else |
|
776 | - $excludedPhrases[] = $word; |
|
777 | 831 | |
778 | 832 | // Have we got indexes to prepare? |
779 | - if ($searchAPI->supportsMethod('prepareIndexes')) |
|
780 | - $searchAPI->prepareIndexes($word, $searchWords[$orIndex], $excludedIndexWords, $is_excluded); |
|
833 | + if ($searchAPI->supportsMethod('prepareIndexes')) { |
|
834 | + $searchAPI->prepareIndexes($word, $searchWords[$orIndex], $excludedIndexWords, $is_excluded); |
|
835 | + } |
|
781 | 836 | } |
782 | 837 | |
783 | 838 | // Search_force_index requires all AND parts to have at least one fulltext word. |
@@ -785,8 +840,7 @@ discard block |
||
785 | 840 | { |
786 | 841 | $context['search_errors']['query_not_specific_enough'] = true; |
787 | 842 | break; |
788 | - } |
|
789 | - elseif ($search_params['subject_only'] && empty($searchWords[$orIndex]['subject_words']) && empty($excludedSubjectWords)) |
|
843 | + } elseif ($search_params['subject_only'] && empty($searchWords[$orIndex]['subject_words']) && empty($excludedSubjectWords)) |
|
790 | 844 | { |
791 | 845 | $context['search_errors']['query_not_specific_enough'] = true; |
792 | 846 | break; |
@@ -814,8 +868,9 @@ discard block |
||
814 | 868 | $found_misspelling = false; |
815 | 869 | foreach ($searchArray as $word) |
816 | 870 | { |
817 | - if (empty($link)) |
|
818 | - continue; |
|
871 | + if (empty($link)) { |
|
872 | + continue; |
|
873 | + } |
|
819 | 874 | |
820 | 875 | // Don't check phrases. |
821 | 876 | if (preg_match('~^\w+$~', $word) === 0) |
@@ -830,8 +885,7 @@ discard block |
||
830 | 885 | $did_you_mean['search'][] = $word; |
831 | 886 | $did_you_mean['display'][] = $smcFunc['htmlspecialchars']($word); |
832 | 887 | continue; |
833 | - } |
|
834 | - elseif (spell_check($link, $word)) |
|
888 | + } elseif (spell_check($link, $word)) |
|
835 | 889 | { |
836 | 890 | $did_you_mean['search'][] = $word; |
837 | 891 | $did_you_mean['display'][] = $smcFunc['htmlspecialchars']($word); |
@@ -842,11 +896,13 @@ discard block |
||
842 | 896 | foreach ($suggestions as $i => $s) |
843 | 897 | { |
844 | 898 | // Search is case insensitive. |
845 | - if ($smcFunc['strtolower']($s) == $smcFunc['strtolower']($word)) |
|
846 | - unset($suggestions[$i]); |
|
899 | + if ($smcFunc['strtolower']($s) == $smcFunc['strtolower']($word)) { |
|
900 | + unset($suggestions[$i]); |
|
901 | + } |
|
847 | 902 | // Plus, don't suggest something the user thinks is rude! |
848 | - elseif ($suggestions[$i] != censorText($s)) |
|
849 | - unset($suggestions[$i]); |
|
903 | + elseif ($suggestions[$i] != censorText($s)) { |
|
904 | + unset($suggestions[$i]); |
|
905 | + } |
|
850 | 906 | } |
851 | 907 | |
852 | 908 | // Anything found? If so, correct it! |
@@ -856,8 +912,7 @@ discard block |
||
856 | 912 | $did_you_mean['search'][] = $suggestions[0]; |
857 | 913 | $did_you_mean['display'][] = '<em><strong>' . $smcFunc['htmlspecialchars']($suggestions[0]) . '</strong></em>'; |
858 | 914 | $found_misspelling = true; |
859 | - } |
|
860 | - else |
|
915 | + } else |
|
861 | 916 | { |
862 | 917 | $did_you_mean['search'][] = $word; |
863 | 918 | $did_you_mean['display'][] = $smcFunc['htmlspecialchars']($word); |
@@ -874,8 +929,7 @@ discard block |
||
874 | 929 | { |
875 | 930 | $temp_excluded['search'][] = '-"' . $word . '"'; |
876 | 931 | $temp_excluded['display'][] = '-"' . $smcFunc['htmlspecialchars']($word) . '"'; |
877 | - } |
|
878 | - else |
|
932 | + } else |
|
879 | 933 | { |
880 | 934 | $temp_excluded['search'][] = '-' . $word; |
881 | 935 | $temp_excluded['display'][] = '-' . $smcFunc['htmlspecialchars']($word); |
@@ -887,11 +941,13 @@ discard block |
||
887 | 941 | |
888 | 942 | $temp_params = $search_params; |
889 | 943 | $temp_params['search'] = implode(' ', $did_you_mean['search']); |
890 | - if (isset($temp_params['brd'])) |
|
891 | - $temp_params['brd'] = implode(',', $temp_params['brd']); |
|
944 | + if (isset($temp_params['brd'])) { |
|
945 | + $temp_params['brd'] = implode(',', $temp_params['brd']); |
|
946 | + } |
|
892 | 947 | $context['params'] = array(); |
893 | - foreach ($temp_params as $k => $v) |
|
894 | - $context['did_you_mean_params'][] = $k . '|\'|' . $v; |
|
948 | + foreach ($temp_params as $k => $v) { |
|
949 | + $context['did_you_mean_params'][] = $k . '|\'|' . $v; |
|
950 | + } |
|
895 | 951 | $context['did_you_mean_params'] = base64_encode(implode('|"|', $context['did_you_mean_params'])); |
896 | 952 | $context['did_you_mean'] = implode(' ', $did_you_mean['display']); |
897 | 953 | } |
@@ -899,18 +955,20 @@ discard block |
||
899 | 955 | |
900 | 956 | // Let the user adjust the search query, should they wish? |
901 | 957 | $context['search_params'] = $search_params; |
902 | - if (isset($context['search_params']['search'])) |
|
903 | - $context['search_params']['search'] = $smcFunc['htmlspecialchars']($context['search_params']['search']); |
|
904 | - if (isset($context['search_params']['userspec'])) |
|
905 | - $context['search_params']['userspec'] = $smcFunc['htmlspecialchars']($context['search_params']['userspec']); |
|
958 | + if (isset($context['search_params']['search'])) { |
|
959 | + $context['search_params']['search'] = $smcFunc['htmlspecialchars']($context['search_params']['search']); |
|
960 | + } |
|
961 | + if (isset($context['search_params']['userspec'])) { |
|
962 | + $context['search_params']['userspec'] = $smcFunc['htmlspecialchars']($context['search_params']['userspec']); |
|
963 | + } |
|
906 | 964 | |
907 | 965 | // Do we have captcha enabled? |
908 | 966 | if ($user_info['is_guest'] && !empty($modSettings['search_enable_captcha']) && empty($_SESSION['ss_vv_passed']) && (empty($_SESSION['last_ss']) || $_SESSION['last_ss'] != $search_params['search'])) |
909 | 967 | { |
910 | 968 | // If we come from another search box tone down the error... |
911 | - if (!isset($_REQUEST['search_vv'])) |
|
912 | - $context['search_errors']['need_verification_code'] = true; |
|
913 | - else |
|
969 | + if (!isset($_REQUEST['search_vv'])) { |
|
970 | + $context['search_errors']['need_verification_code'] = true; |
|
971 | + } else |
|
914 | 972 | { |
915 | 973 | require_once($sourcedir . '/Subs-Editor.php'); |
916 | 974 | $verificationOptions = array( |
@@ -920,12 +978,14 @@ discard block |
||
920 | 978 | |
921 | 979 | if (is_array($context['require_verification'])) |
922 | 980 | { |
923 | - foreach ($context['require_verification'] as $error) |
|
924 | - $context['search_errors'][$error] = true; |
|
981 | + foreach ($context['require_verification'] as $error) { |
|
982 | + $context['search_errors'][$error] = true; |
|
983 | + } |
|
925 | 984 | } |
926 | 985 | // Don't keep asking for it - they've proven themselves worthy. |
927 | - else |
|
928 | - $_SESSION['ss_vv_passed'] = true; |
|
986 | + else { |
|
987 | + $_SESSION['ss_vv_passed'] = true; |
|
988 | + } |
|
929 | 989 | } |
930 | 990 | } |
931 | 991 | |
@@ -933,19 +993,22 @@ discard block |
||
933 | 993 | |
934 | 994 | // All search params have been checked, let's compile them to a single string... made less simple by PHP 4.3.9 and below. |
935 | 995 | $temp_params = $search_params; |
936 | - if (isset($temp_params['brd'])) |
|
937 | - $temp_params['brd'] = implode(',', $temp_params['brd']); |
|
996 | + if (isset($temp_params['brd'])) { |
|
997 | + $temp_params['brd'] = implode(',', $temp_params['brd']); |
|
998 | + } |
|
938 | 999 | $context['params'] = array(); |
939 | - foreach ($temp_params as $k => $v) |
|
940 | - $context['params'][] = $k . '|\'|' . $v; |
|
1000 | + foreach ($temp_params as $k => $v) { |
|
1001 | + $context['params'][] = $k . '|\'|' . $v; |
|
1002 | + } |
|
941 | 1003 | |
942 | 1004 | if (!empty($context['params'])) |
943 | 1005 | { |
944 | 1006 | // Due to old IE's 2083 character limit, we have to compress long search strings |
945 | 1007 | $params = @gzcompress(implode('|"|', $context['params'])); |
946 | 1008 | // Gzcompress failed, use try non-gz |
947 | - if (empty($params)) |
|
948 | - $params = implode('|"|', $context['params']); |
|
1009 | + if (empty($params)) { |
|
1010 | + $params = implode('|"|', $context['params']); |
|
1011 | + } |
|
949 | 1012 | // Base64 encode, then replace +/= with uri safe ones that can be reverted |
950 | 1013 | $context['params'] = str_replace(array('+', '/', '='), array('-', '_', '.'), base64_encode($params)); |
951 | 1014 | } |
@@ -971,8 +1034,9 @@ discard block |
||
971 | 1034 | } |
972 | 1035 | |
973 | 1036 | // Spam me not, Spam-a-lot? |
974 | - if (empty($_SESSION['last_ss']) || $_SESSION['last_ss'] != $search_params['search']) |
|
975 | - spamProtection('search'); |
|
1037 | + if (empty($_SESSION['last_ss']) || $_SESSION['last_ss'] != $search_params['search']) { |
|
1038 | + spamProtection('search'); |
|
1039 | + } |
|
976 | 1040 | // Store the last search string to allow pages of results to be browsed. |
977 | 1041 | $_SESSION['last_ss'] = $search_params['search']; |
978 | 1042 | |
@@ -1032,8 +1096,9 @@ discard block |
||
1032 | 1096 | 'where' => array(), |
1033 | 1097 | ); |
1034 | 1098 | |
1035 | - if ($modSettings['postmod_active']) |
|
1036 | - $subject_query['where'][] = 't.approved = {int:is_approved}'; |
|
1099 | + if ($modSettings['postmod_active']) { |
|
1100 | + $subject_query['where'][] = 't.approved = {int:is_approved}'; |
|
1101 | + } |
|
1037 | 1102 | |
1038 | 1103 | $numTables = 0; |
1039 | 1104 | $prev_join = 0; |
@@ -1045,8 +1110,7 @@ discard block |
||
1045 | 1110 | { |
1046 | 1111 | $subject_query['left_join'][] = '{db_prefix}log_search_subjects AS subj' . $numTables . ' ON (subj' . $numTables . '.word ' . (empty($modSettings['search_match_words']) ? 'LIKE {string:subject_words_' . $numTables . '_wild}' : '= {string:subject_words_' . $numTables . '}') . ' AND subj' . $numTables . '.id_topic = t.id_topic)'; |
1047 | 1112 | $subject_query['where'][] = '(subj' . $numTables . '.word IS NULL)'; |
1048 | - } |
|
1049 | - else |
|
1113 | + } else |
|
1050 | 1114 | { |
1051 | 1115 | $subject_query['inner_join'][] = '{db_prefix}log_search_subjects AS subj' . $numTables . ' ON (subj' . $numTables . '.id_topic = ' . ($prev_join === 0 ? 't' : 'subj' . $prev_join) . '.id_topic)'; |
1052 | 1116 | $subject_query['where'][] = 'subj' . $numTables . '.word ' . (empty($modSettings['search_match_words']) ? 'LIKE {string:subject_words_' . $numTables . '_wild}' : '= {string:subject_words_' . $numTables . '}'); |
@@ -1064,14 +1128,18 @@ discard block |
||
1064 | 1128 | } |
1065 | 1129 | $subject_query['where'][] = $userQuery; |
1066 | 1130 | } |
1067 | - if (!empty($search_params['topic'])) |
|
1068 | - $subject_query['where'][] = 't.id_topic = ' . $search_params['topic']; |
|
1069 | - if (!empty($minMsgID)) |
|
1070 | - $subject_query['where'][] = 't.id_first_msg >= ' . $minMsgID; |
|
1071 | - if (!empty($maxMsgID)) |
|
1072 | - $subject_query['where'][] = 't.id_last_msg <= ' . $maxMsgID; |
|
1073 | - if (!empty($boardQuery)) |
|
1074 | - $subject_query['where'][] = 't.id_board ' . $boardQuery; |
|
1131 | + if (!empty($search_params['topic'])) { |
|
1132 | + $subject_query['where'][] = 't.id_topic = ' . $search_params['topic']; |
|
1133 | + } |
|
1134 | + if (!empty($minMsgID)) { |
|
1135 | + $subject_query['where'][] = 't.id_first_msg >= ' . $minMsgID; |
|
1136 | + } |
|
1137 | + if (!empty($maxMsgID)) { |
|
1138 | + $subject_query['where'][] = 't.id_last_msg <= ' . $maxMsgID; |
|
1139 | + } |
|
1140 | + if (!empty($boardQuery)) { |
|
1141 | + $subject_query['where'][] = 't.id_board ' . $boardQuery; |
|
1142 | + } |
|
1075 | 1143 | if (!empty($excludedPhrases)) |
1076 | 1144 | { |
1077 | 1145 | if ($subject_query['from'] != '{db_prefix}messages AS m') |
@@ -1091,8 +1159,9 @@ discard block |
||
1091 | 1159 | foreach ($weight_factors as $type => $value) |
1092 | 1160 | { |
1093 | 1161 | $relevance .= $weight[$type]; |
1094 | - if (!empty($value['results'])) |
|
1095 | - $relevance .= ' * ' . $value['results']; |
|
1162 | + if (!empty($value['results'])) { |
|
1163 | + $relevance .= ' * ' . $value['results']; |
|
1164 | + } |
|
1096 | 1165 | $relevance .= ' + '; |
1097 | 1166 | } |
1098 | 1167 | $relevance = substr($relevance, 0, -3) . ') / ' . $weight_total . ' AS relevance'; |
@@ -1130,20 +1199,23 @@ discard block |
||
1130 | 1199 | while ($row = $smcFunc['db_fetch_row']($ignoreRequest)) |
1131 | 1200 | { |
1132 | 1201 | // No duplicates! |
1133 | - if (isset($inserts[$row[1]])) |
|
1134 | - continue; |
|
1202 | + if (isset($inserts[$row[1]])) { |
|
1203 | + continue; |
|
1204 | + } |
|
1135 | 1205 | |
1136 | - foreach ($row as $key => $value) |
|
1137 | - $inserts[$row[1]][] = (int) $row[$key]; |
|
1206 | + foreach ($row as $key => $value) { |
|
1207 | + $inserts[$row[1]][] = (int) $row[$key]; |
|
1208 | + } |
|
1138 | 1209 | } |
1139 | 1210 | $smcFunc['db_free_result']($ignoreRequest); |
1140 | 1211 | $numSubjectResults = count($inserts); |
1212 | + } else { |
|
1213 | + $numSubjectResults += $smcFunc['db_affected_rows'](); |
|
1141 | 1214 | } |
1142 | - else |
|
1143 | - $numSubjectResults += $smcFunc['db_affected_rows'](); |
|
1144 | 1215 | |
1145 | - if (!empty($modSettings['search_max_results']) && $numSubjectResults >= $modSettings['search_max_results']) |
|
1146 | - break; |
|
1216 | + if (!empty($modSettings['search_max_results']) && $numSubjectResults >= $modSettings['search_max_results']) { |
|
1217 | + break; |
|
1218 | + } |
|
1147 | 1219 | } |
1148 | 1220 | |
1149 | 1221 | // If there's data to be inserted for non-IGNORE databases do it here! |
@@ -1158,8 +1230,7 @@ discard block |
||
1158 | 1230 | } |
1159 | 1231 | |
1160 | 1232 | $_SESSION['search_cache']['num_results'] = $numSubjectResults; |
1161 | - } |
|
1162 | - else |
|
1233 | + } else |
|
1163 | 1234 | { |
1164 | 1235 | $main_query = array( |
1165 | 1236 | 'select' => array( |
@@ -1191,8 +1262,7 @@ discard block |
||
1191 | 1262 | $main_query['weights'] = $weight_factors; |
1192 | 1263 | |
1193 | 1264 | $main_query['group_by'][] = 't.id_topic'; |
1194 | - } |
|
1195 | - else |
|
1265 | + } else |
|
1196 | 1266 | { |
1197 | 1267 | // This is outrageous! |
1198 | 1268 | $main_query['select']['id_topic'] = 'm.id_msg AS id_topic'; |
@@ -1213,8 +1283,9 @@ discard block |
||
1213 | 1283 | $main_query['where'][] = 't.id_topic = {int:topic}'; |
1214 | 1284 | $main_query['parameters']['topic'] = $search_params['topic']; |
1215 | 1285 | } |
1216 | - if (!empty($search_params['show_complete'])) |
|
1217 | - $main_query['group_by'][] = 'm.id_msg, t.id_first_msg, t.id_last_msg'; |
|
1286 | + if (!empty($search_params['show_complete'])) { |
|
1287 | + $main_query['group_by'][] = 'm.id_msg, t.id_first_msg, t.id_last_msg'; |
|
1288 | + } |
|
1218 | 1289 | } |
1219 | 1290 | |
1220 | 1291 | // *** Get the subject results. |
@@ -1241,14 +1312,15 @@ discard block |
||
1241 | 1312 | ) !== false; |
1242 | 1313 | |
1243 | 1314 | // Clean up some previous cache. |
1244 | - if (!$createTemporary) |
|
1245 | - $smcFunc['db_search_query']('delete_log_search_topics', ' |
|
1315 | + if (!$createTemporary) { |
|
1316 | + $smcFunc['db_search_query']('delete_log_search_topics', ' |
|
1246 | 1317 | DELETE FROM {db_prefix}log_search_topics |
1247 | 1318 | WHERE id_search = {int:search_id}', |
1248 | 1319 | array( |
1249 | 1320 | 'search_id' => $_SESSION['search_cache']['id_search'], |
1250 | 1321 | ) |
1251 | 1322 | ); |
1323 | + } |
|
1252 | 1324 | |
1253 | 1325 | foreach ($searchWords as $orIndex => $words) |
1254 | 1326 | { |
@@ -1280,8 +1352,7 @@ discard block |
||
1280 | 1352 | $subject_query['where'][] = '(subj' . $numTables . '.word IS NULL)'; |
1281 | 1353 | $subject_query['where'][] = 'm.body NOT ' . (empty($modSettings['search_match_words']) || $no_regexp ? ' LIKE ' : ' RLIKE ') . '{string:body_not_' . $count . '}'; |
1282 | 1354 | $subject_query['params']['body_not_' . $count++] = empty($modSettings['search_match_words']) || $no_regexp ? '%' . strtr($subjectWord, array('_' => '\\_', '%' => '\\%')) . '%' : '[[:<:]]' . addcslashes(preg_replace(array('/([\[\]$.+*?|{}()])/'), array('[$1]'), $subjectWord), '\\\'') . '[[:>:]]'; |
1283 | - } |
|
1284 | - else |
|
1355 | + } else |
|
1285 | 1356 | { |
1286 | 1357 | $subject_query['inner_join'][] = '{db_prefix}log_search_subjects AS subj' . $numTables . ' ON (subj' . $numTables . '.id_topic = ' . ($prev_join === 0 ? 't' : 'subj' . $prev_join) . '.id_topic)'; |
1287 | 1358 | $subject_query['where'][] = 'subj' . $numTables . '.word LIKE {string:subject_like_' . $count . '}'; |
@@ -1336,8 +1407,9 @@ discard block |
||
1336 | 1407 | call_integration_hook('integrate_subject_search_query', array(&$subject_query)); |
1337 | 1408 | |
1338 | 1409 | // Nothing to search for? |
1339 | - if (empty($subject_query['where'])) |
|
1340 | - continue; |
|
1410 | + if (empty($subject_query['where'])) { |
|
1411 | + continue; |
|
1412 | + } |
|
1341 | 1413 | |
1342 | 1414 | $ignoreRequest = $smcFunc['db_search_query']('insert_log_search_topics', ($smcFunc['db_support_ignore'] ? ( ' |
1343 | 1415 | INSERT IGNORE INTO {db_prefix}' . ($createTemporary ? 'tmp_' : '') . 'log_search_topics |
@@ -1360,19 +1432,21 @@ discard block |
||
1360 | 1432 | { |
1361 | 1433 | $ind = $createTemporary ? 0 : 1; |
1362 | 1434 | // No duplicates! |
1363 | - if (isset($inserts[$row[$ind]])) |
|
1364 | - continue; |
|
1435 | + if (isset($inserts[$row[$ind]])) { |
|
1436 | + continue; |
|
1437 | + } |
|
1365 | 1438 | |
1366 | 1439 | $inserts[$row[$ind]] = $row; |
1367 | 1440 | } |
1368 | 1441 | $smcFunc['db_free_result']($ignoreRequest); |
1369 | 1442 | $numSubjectResults = count($inserts); |
1443 | + } else { |
|
1444 | + $numSubjectResults += $smcFunc['db_affected_rows'](); |
|
1370 | 1445 | } |
1371 | - else |
|
1372 | - $numSubjectResults += $smcFunc['db_affected_rows'](); |
|
1373 | 1446 | |
1374 | - if (!empty($modSettings['search_max_results']) && $numSubjectResults >= $modSettings['search_max_results']) |
|
1375 | - break; |
|
1447 | + if (!empty($modSettings['search_max_results']) && $numSubjectResults >= $modSettings['search_max_results']) { |
|
1448 | + break; |
|
1449 | + } |
|
1376 | 1450 | } |
1377 | 1451 | |
1378 | 1452 | // Got some non-MySQL data to plonk in? |
@@ -1390,8 +1464,9 @@ discard block |
||
1390 | 1464 | { |
1391 | 1465 | $main_query['weights']['subject']['search'] = 'CASE WHEN MAX(lst.id_topic) IS NULL THEN 0 ELSE 1 END'; |
1392 | 1466 | $main_query['left_join'][] = '{db_prefix}' . ($createTemporary ? 'tmp_' : '') . 'log_search_topics AS lst ON (' . ($createTemporary ? '' : 'lst.id_search = {int:id_search} AND ') . 'lst.id_topic = t.id_topic)'; |
1393 | - if (!$createTemporary) |
|
1394 | - $main_query['parameters']['id_search'] = $_SESSION['search_cache']['id_search']; |
|
1467 | + if (!$createTemporary) { |
|
1468 | + $main_query['parameters']['id_search'] = $_SESSION['search_cache']['id_search']; |
|
1469 | + } |
|
1395 | 1470 | } |
1396 | 1471 | } |
1397 | 1472 | |
@@ -1419,14 +1494,15 @@ discard block |
||
1419 | 1494 | ) !== false; |
1420 | 1495 | |
1421 | 1496 | // Clear, all clear! |
1422 | - if (!$createTemporary) |
|
1423 | - $smcFunc['db_search_query']('delete_log_search_messages', ' |
|
1497 | + if (!$createTemporary) { |
|
1498 | + $smcFunc['db_search_query']('delete_log_search_messages', ' |
|
1424 | 1499 | DELETE FROM {db_prefix}log_search_messages |
1425 | 1500 | WHERE id_search = {int:id_search}', |
1426 | 1501 | array( |
1427 | 1502 | 'id_search' => $_SESSION['search_cache']['id_search'], |
1428 | 1503 | ) |
1429 | 1504 | ); |
1505 | + } |
|
1430 | 1506 | |
1431 | 1507 | foreach ($searchWords as $orIndex => $words) |
1432 | 1508 | { |
@@ -1460,19 +1536,21 @@ discard block |
||
1460 | 1536 | while ($row = $smcFunc['db_fetch_row']($ignoreRequest)) |
1461 | 1537 | { |
1462 | 1538 | // No duplicates! |
1463 | - if (isset($inserts[$row[0]])) |
|
1464 | - continue; |
|
1539 | + if (isset($inserts[$row[0]])) { |
|
1540 | + continue; |
|
1541 | + } |
|
1465 | 1542 | |
1466 | 1543 | $inserts[$row[0]] = $row; |
1467 | 1544 | } |
1468 | 1545 | $smcFunc['db_free_result']($ignoreRequest); |
1469 | 1546 | $indexedResults = count($inserts); |
1547 | + } else { |
|
1548 | + $indexedResults += $smcFunc['db_affected_rows'](); |
|
1470 | 1549 | } |
1471 | - else |
|
1472 | - $indexedResults += $smcFunc['db_affected_rows'](); |
|
1473 | 1550 | |
1474 | - if (!empty($maxMessageResults) && $indexedResults >= $maxMessageResults) |
|
1475 | - break; |
|
1551 | + if (!empty($maxMessageResults) && $indexedResults >= $maxMessageResults) { |
|
1552 | + break; |
|
1553 | + } |
|
1476 | 1554 | } |
1477 | 1555 | } |
1478 | 1556 | |
@@ -1492,8 +1570,7 @@ discard block |
||
1492 | 1570 | $context['search_errors']['query_not_specific_enough'] = true; |
1493 | 1571 | $_REQUEST['params'] = $context['params']; |
1494 | 1572 | return PlushSearch1(); |
1495 | - } |
|
1496 | - elseif (!empty($indexedResults)) |
|
1573 | + } elseif (!empty($indexedResults)) |
|
1497 | 1574 | { |
1498 | 1575 | $main_query['inner_join'][] = '{db_prefix}' . ($createTemporary ? 'tmp_' : '') . 'log_search_messages AS lsm ON (lsm.id_msg = m.id_msg)'; |
1499 | 1576 | if (!$createTemporary) |
@@ -1515,15 +1592,18 @@ discard block |
||
1515 | 1592 | foreach ($words['all_words'] as $regularWord) |
1516 | 1593 | { |
1517 | 1594 | $where[] = 'm.body' . (in_array($regularWord, $excludedWords) ? ' NOT' : '') . (empty($modSettings['search_match_words']) || $no_regexp ? ' LIKE ' : ' RLIKE ') . '{string:all_word_body_' . $count . '}'; |
1518 | - if (in_array($regularWord, $excludedWords)) |
|
1519 | - $where[] = 'm.subject NOT' . (empty($modSettings['search_match_words']) || $no_regexp ? ' LIKE ' : ' RLIKE ') . '{string:all_word_body_' . $count . '}'; |
|
1595 | + if (in_array($regularWord, $excludedWords)) { |
|
1596 | + $where[] = 'm.subject NOT' . (empty($modSettings['search_match_words']) || $no_regexp ? ' LIKE ' : ' RLIKE ') . '{string:all_word_body_' . $count . '}'; |
|
1597 | + } |
|
1520 | 1598 | $main_query['parameters']['all_word_body_' . $count++] = empty($modSettings['search_match_words']) || $no_regexp ? '%' . strtr($regularWord, array('_' => '\\_', '%' => '\\%')) . '%' : '[[:<:]]' . addcslashes(preg_replace(array('/([\[\]$.+*?|{}()])/'), array('[$1]'), $regularWord), '\\\'') . '[[:>:]]'; |
1521 | 1599 | } |
1522 | - if (!empty($where)) |
|
1523 | - $orWhere[] = count($where) > 1 ? '(' . implode(' AND ', $where) . ')' : $where[0]; |
|
1600 | + if (!empty($where)) { |
|
1601 | + $orWhere[] = count($where) > 1 ? '(' . implode(' AND ', $where) . ')' : $where[0]; |
|
1602 | + } |
|
1603 | + } |
|
1604 | + if (!empty($orWhere)) { |
|
1605 | + $main_query['where'][] = count($orWhere) > 1 ? '(' . implode(' OR ', $orWhere) . ')' : $orWhere[0]; |
|
1524 | 1606 | } |
1525 | - if (!empty($orWhere)) |
|
1526 | - $main_query['where'][] = count($orWhere) > 1 ? '(' . implode(' OR ', $orWhere) . ')' : $orWhere[0]; |
|
1527 | 1607 | |
1528 | 1608 | if (!empty($userQuery)) |
1529 | 1609 | { |
@@ -1561,8 +1641,9 @@ discard block |
||
1561 | 1641 | foreach ($main_query['weights'] as $type => $value) |
1562 | 1642 | { |
1563 | 1643 | $relevance .= $weight[$type]; |
1564 | - if (!empty($value['search'])) |
|
1565 | - $relevance .= ' * ' . $value['search']; |
|
1644 | + if (!empty($value['search'])) { |
|
1645 | + $relevance .= ' * ' . $value['search']; |
|
1646 | + } |
|
1566 | 1647 | $relevance .= ' + '; |
1567 | 1648 | $new_weight_total += $weight[$type]; |
1568 | 1649 | } |
@@ -1593,11 +1674,13 @@ discard block |
||
1593 | 1674 | while ($row = $smcFunc['db_fetch_row']($ignoreRequest)) |
1594 | 1675 | { |
1595 | 1676 | // No duplicates! |
1596 | - if (isset($inserts[$row[2]])) |
|
1597 | - continue; |
|
1677 | + if (isset($inserts[$row[2]])) { |
|
1678 | + continue; |
|
1679 | + } |
|
1598 | 1680 | |
1599 | - foreach ($row as $key => $value) |
|
1600 | - $inserts[$row[2]][] = (int) $row[$key]; |
|
1681 | + foreach ($row as $key => $value) { |
|
1682 | + $inserts[$row[2]][] = (int) $row[$key]; |
|
1683 | + } |
|
1601 | 1684 | } |
1602 | 1685 | $smcFunc['db_free_result']($ignoreRequest); |
1603 | 1686 | |
@@ -1605,8 +1688,9 @@ discard block |
||
1605 | 1688 | if (!empty($inserts)) |
1606 | 1689 | { |
1607 | 1690 | $query_columns = array(); |
1608 | - foreach ($main_query['select'] as $k => $v) |
|
1609 | - $query_columns[$k] = 'int'; |
|
1691 | + foreach ($main_query['select'] as $k => $v) { |
|
1692 | + $query_columns[$k] = 'int'; |
|
1693 | + } |
|
1610 | 1694 | |
1611 | 1695 | $smcFunc['db_insert']('', |
1612 | 1696 | '{db_prefix}log_search_results', |
@@ -1616,21 +1700,23 @@ discard block |
||
1616 | 1700 | ); |
1617 | 1701 | } |
1618 | 1702 | $_SESSION['search_cache']['num_results'] += count($inserts); |
1703 | + } else { |
|
1704 | + $_SESSION['search_cache']['num_results'] = $smcFunc['db_affected_rows'](); |
|
1619 | 1705 | } |
1620 | - else |
|
1621 | - $_SESSION['search_cache']['num_results'] = $smcFunc['db_affected_rows'](); |
|
1622 | 1706 | } |
1623 | 1707 | |
1624 | 1708 | // Insert subject-only matches. |
1625 | 1709 | if ($_SESSION['search_cache']['num_results'] < $modSettings['search_max_results'] && $numSubjectResults !== 0) |
1626 | 1710 | { |
1627 | 1711 | $relevance = '1000 * ('; |
1628 | - foreach ($weight_factors as $type => $value) |
|
1629 | - if (isset($value['results'])) |
|
1712 | + foreach ($weight_factors as $type => $value) { |
|
1713 | + if (isset($value['results'])) |
|
1630 | 1714 | { |
1631 | 1715 | $relevance .= $weight[$type]; |
1632 | - if (!empty($value['results'])) |
|
1633 | - $relevance .= ' * ' . $value['results']; |
|
1716 | + } |
|
1717 | + if (!empty($value['results'])) { |
|
1718 | + $relevance .= ' * ' . $value['results']; |
|
1719 | + } |
|
1634 | 1720 | $relevance .= ' + '; |
1635 | 1721 | } |
1636 | 1722 | $relevance = substr($relevance, 0, -3) . ') / ' . $weight_total . ' AS relevance'; |
@@ -1664,8 +1750,9 @@ discard block |
||
1664 | 1750 | while ($row = $smcFunc['db_fetch_row']($ignoreRequest)) |
1665 | 1751 | { |
1666 | 1752 | // No duplicates! |
1667 | - if (isset($usedIDs[$row[1]])) |
|
1668 | - continue; |
|
1753 | + if (isset($usedIDs[$row[1]])) { |
|
1754 | + continue; |
|
1755 | + } |
|
1669 | 1756 | |
1670 | 1757 | $usedIDs[$row[1]] = true; |
1671 | 1758 | $inserts[] = $row; |
@@ -1683,12 +1770,12 @@ discard block |
||
1683 | 1770 | ); |
1684 | 1771 | } |
1685 | 1772 | $_SESSION['search_cache']['num_results'] += count($inserts); |
1773 | + } else { |
|
1774 | + $_SESSION['search_cache']['num_results'] += $smcFunc['db_affected_rows'](); |
|
1686 | 1775 | } |
1687 | - else |
|
1688 | - $_SESSION['search_cache']['num_results'] += $smcFunc['db_affected_rows'](); |
|
1776 | + } elseif ($_SESSION['search_cache']['num_results'] == -1) { |
|
1777 | + $_SESSION['search_cache']['num_results'] = 0; |
|
1689 | 1778 | } |
1690 | - elseif ($_SESSION['search_cache']['num_results'] == -1) |
|
1691 | - $_SESSION['search_cache']['num_results'] = 0; |
|
1692 | 1779 | } |
1693 | 1780 | } |
1694 | 1781 | |
@@ -1758,14 +1845,16 @@ discard block |
||
1758 | 1845 | ) |
1759 | 1846 | ); |
1760 | 1847 | $posters = array(); |
1761 | - while ($row = $smcFunc['db_fetch_assoc']($request)) |
|
1762 | - $posters[] = $row['id_member']; |
|
1848 | + while ($row = $smcFunc['db_fetch_assoc']($request)) { |
|
1849 | + $posters[] = $row['id_member']; |
|
1850 | + } |
|
1763 | 1851 | $smcFunc['db_free_result']($request); |
1764 | 1852 | |
1765 | 1853 | call_integration_hook('integrate_search_message_list', array(&$msg_list, &$posters)); |
1766 | 1854 | |
1767 | - if (!empty($posters)) |
|
1768 | - loadMemberData(array_unique($posters)); |
|
1855 | + if (!empty($posters)) { |
|
1856 | + loadMemberData(array_unique($posters)); |
|
1857 | + } |
|
1769 | 1858 | |
1770 | 1859 | // Get the messages out for the callback - select enough that it can be made to look just like Display. |
1771 | 1860 | $messages_request = $smcFunc['db_query']('', ' |
@@ -1799,8 +1888,9 @@ discard block |
||
1799 | 1888 | ); |
1800 | 1889 | |
1801 | 1890 | // If there are no results that means the things in the cache got deleted, so pretend we have no topics anymore. |
1802 | - if ($smcFunc['db_num_rows']($messages_request) == 0) |
|
1803 | - $context['topics'] = array(); |
|
1891 | + if ($smcFunc['db_num_rows']($messages_request) == 0) { |
|
1892 | + $context['topics'] = array(); |
|
1893 | + } |
|
1804 | 1894 | |
1805 | 1895 | // If we want to know who participated in what then load this now. |
1806 | 1896 | if (!empty($modSettings['enableParticipation']) && !$user_info['is_guest']) |
@@ -1818,8 +1908,9 @@ discard block |
||
1818 | 1908 | 'limit' => count($participants), |
1819 | 1909 | ) |
1820 | 1910 | ); |
1821 | - while ($row = $smcFunc['db_fetch_assoc']($result)) |
|
1822 | - $participants[$row['id_topic']] = true; |
|
1911 | + while ($row = $smcFunc['db_fetch_assoc']($result)) { |
|
1912 | + $participants[$row['id_topic']] = true; |
|
1913 | + } |
|
1823 | 1914 | $smcFunc['db_free_result']($result); |
1824 | 1915 | } |
1825 | 1916 | } |
@@ -1828,15 +1919,17 @@ discard block |
||
1828 | 1919 | $context['page_index'] = constructPageIndex($scripturl . '?action=search2;params=' . $context['params'], $_REQUEST['start'], $num_results, $modSettings['search_results_per_page'], false); |
1829 | 1920 | |
1830 | 1921 | // Consider the search complete! |
1831 | - if (!empty($modSettings['cache_enable']) && $modSettings['cache_enable'] >= 2) |
|
1832 | - cache_put_data('search_start:' . ($user_info['is_guest'] ? $user_info['ip'] : $user_info['id']), null, 90); |
|
1922 | + if (!empty($modSettings['cache_enable']) && $modSettings['cache_enable'] >= 2) { |
|
1923 | + cache_put_data('search_start:' . ($user_info['is_guest'] ? $user_info['ip'] : $user_info['id']), null, 90); |
|
1924 | + } |
|
1833 | 1925 | |
1834 | 1926 | $context['key_words'] = &$searchArray; |
1835 | 1927 | |
1836 | 1928 | // Setup the default topic icons... for checking they exist and the like! |
1837 | 1929 | $context['icon_sources'] = array(); |
1838 | - foreach ($context['stable_icons'] as $icon) |
|
1839 | - $context['icon_sources'][$icon] = 'images_url'; |
|
1930 | + foreach ($context['stable_icons'] as $icon) { |
|
1931 | + $context['icon_sources'][$icon] = 'images_url'; |
|
1932 | + } |
|
1840 | 1933 | |
1841 | 1934 | $context['sub_template'] = 'results'; |
1842 | 1935 | $context['page_title'] = $txt['search_results']; |
@@ -1867,26 +1960,31 @@ discard block |
||
1867 | 1960 | global $boards_can, $participants, $smcFunc; |
1868 | 1961 | static $recycle_board = null; |
1869 | 1962 | |
1870 | - if ($recycle_board === null) |
|
1871 | - $recycle_board = !empty($modSettings['recycle_enable']) && !empty($modSettings['recycle_board']) ? (int) $modSettings['recycle_board'] : 0; |
|
1963 | + if ($recycle_board === null) { |
|
1964 | + $recycle_board = !empty($modSettings['recycle_enable']) && !empty($modSettings['recycle_board']) ? (int) $modSettings['recycle_board'] : 0; |
|
1965 | + } |
|
1872 | 1966 | |
1873 | 1967 | // Remember which message this is. (ie. reply #83) |
1874 | 1968 | static $counter = null; |
1875 | - if ($counter == null || $reset) |
|
1876 | - $counter = $_REQUEST['start'] + 1; |
|
1969 | + if ($counter == null || $reset) { |
|
1970 | + $counter = $_REQUEST['start'] + 1; |
|
1971 | + } |
|
1877 | 1972 | |
1878 | 1973 | // If the query returned false, bail. |
1879 | - if ($messages_request == false) |
|
1880 | - return false; |
|
1974 | + if ($messages_request == false) { |
|
1975 | + return false; |
|
1976 | + } |
|
1881 | 1977 | |
1882 | 1978 | // Start from the beginning... |
1883 | - if ($reset) |
|
1884 | - return @$smcFunc['db_data_seek']($messages_request, 0); |
|
1979 | + if ($reset) { |
|
1980 | + return @$smcFunc['db_data_seek']($messages_request, 0); |
|
1981 | + } |
|
1885 | 1982 | |
1886 | 1983 | // Attempt to get the next message. |
1887 | 1984 | $message = $smcFunc['db_fetch_assoc']($messages_request); |
1888 | - if (!$message) |
|
1889 | - return false; |
|
1985 | + if (!$message) { |
|
1986 | + return false; |
|
1987 | + } |
|
1890 | 1988 | |
1891 | 1989 | // Can't have an empty subject can we? |
1892 | 1990 | $message['subject'] = $message['subject'] != '' ? $message['subject'] : $txt['no_subject']; |
@@ -1925,9 +2023,9 @@ discard block |
||
1925 | 2023 | |
1926 | 2024 | if ($smcFunc['strlen']($message['body']) > $charLimit) |
1927 | 2025 | { |
1928 | - if (empty($context['key_words'])) |
|
1929 | - $message['body'] = $smcFunc['substr']($message['body'], 0, $charLimit) . '<strong>...</strong>'; |
|
1930 | - else |
|
2026 | + if (empty($context['key_words'])) { |
|
2027 | + $message['body'] = $smcFunc['substr']($message['body'], 0, $charLimit) . '<strong>...</strong>'; |
|
2028 | + } else |
|
1931 | 2029 | { |
1932 | 2030 | $matchString = ''; |
1933 | 2031 | $force_partial_word = false; |
@@ -1936,18 +2034,20 @@ discard block |
||
1936 | 2034 | $keyword = un_htmlspecialchars($keyword); |
1937 | 2035 | $keyword = preg_replace_callback('~(&#(\d{1,7}|x[0-9a-fA-F]{1,6});)~', 'entity_fix__callback', strtr($keyword, array('\\\'' => '\'', '&' => '&'))); |
1938 | 2036 | |
1939 | - if (preg_match('~[\'\.,/@%&;:(){}\[\]_\-+\\\\]$~', $keyword) != 0 || preg_match('~^[\'\.,/@%&;:(){}\[\]_\-+\\\\]~', $keyword) != 0) |
|
1940 | - $force_partial_word = true; |
|
2037 | + if (preg_match('~[\'\.,/@%&;:(){}\[\]_\-+\\\\]$~', $keyword) != 0 || preg_match('~^[\'\.,/@%&;:(){}\[\]_\-+\\\\]~', $keyword) != 0) { |
|
2038 | + $force_partial_word = true; |
|
2039 | + } |
|
1941 | 2040 | $matchString .= strtr(preg_quote($keyword, '/'), array('\*' => '.+?')) . '|'; |
1942 | 2041 | } |
1943 | 2042 | $matchString = un_htmlspecialchars(substr($matchString, 0, -1)); |
1944 | 2043 | |
1945 | 2044 | $message['body'] = un_htmlspecialchars(strtr($message['body'], array(' ' => ' ', '<br>' => "\n", '[' => '[', ']' => ']', ':' => ':', '@' => '@'))); |
1946 | 2045 | |
1947 | - if (empty($modSettings['search_method']) || $force_partial_word) |
|
1948 | - preg_match_all('/([^\s\W]{' . $charLimit . '}[\s\W]|[\s\W].{0,' . $charLimit . '}?|^)(' . $matchString . ')(.{0,' . $charLimit . '}[\s\W]|[^\s\W]{0,' . $charLimit . '})/is' . ($context['utf8'] ? 'u' : ''), $message['body'], $matches); |
|
1949 | - else |
|
1950 | - preg_match_all('/([^\s\W]{' . $charLimit . '}[\s\W]|[\s\W].{0,' . $charLimit . '}?[\s\W]|^)(' . $matchString . ')([\s\W].{0,' . $charLimit . '}[\s\W]|[\s\W][^\s\W]{0,' . $charLimit . '})/is' . ($context['utf8'] ? 'u' : ''), $message['body'], $matches); |
|
2046 | + if (empty($modSettings['search_method']) || $force_partial_word) { |
|
2047 | + preg_match_all('/([^\s\W]{' . $charLimit . '}[\s\W]|[\s\W].{0,' . $charLimit . '}?|^)(' . $matchString . ')(.{0,' . $charLimit . '}[\s\W]|[^\s\W]{0,' . $charLimit . '})/is' . ($context['utf8'] ? 'u' : ''), $message['body'], $matches); |
|
2048 | + } else { |
|
2049 | + preg_match_all('/([^\s\W]{' . $charLimit . '}[\s\W]|[\s\W].{0,' . $charLimit . '}?[\s\W]|^)(' . $matchString . ')([\s\W].{0,' . $charLimit . '}[\s\W]|[\s\W][^\s\W]{0,' . $charLimit . '})/is' . ($context['utf8'] ? 'u' : ''), $message['body'], $matches); |
|
2050 | + } |
|
1951 | 2051 | |
1952 | 2052 | $message['body'] = ''; |
1953 | 2053 | foreach ($matches[0] as $index => $match) |
@@ -1960,8 +2060,7 @@ discard block |
||
1960 | 2060 | // Re-fix the international characters. |
1961 | 2061 | $message['body'] = preg_replace_callback('~(&#(\d{1,7}|x[0-9a-fA-F]{1,6});)~', 'entity_fix__callback', $message['body']); |
1962 | 2062 | } |
1963 | - } |
|
1964 | - else |
|
2063 | + } else |
|
1965 | 2064 | { |
1966 | 2065 | // Run BBC interpreter on the message. |
1967 | 2066 | $message['body'] = parse_bbc($message['body'], $message['smileys_enabled'], $message['id_msg']); |
@@ -1980,21 +2079,26 @@ discard block |
||
1980 | 2079 | // Sadly, we need to check the icon ain't broke. |
1981 | 2080 | if (!empty($modSettings['messageIconChecks_enable'])) |
1982 | 2081 | { |
1983 | - if (!isset($context['icon_sources'][$message['first_icon']])) |
|
1984 | - $context['icon_sources'][$message['first_icon']] = file_exists($settings['theme_dir'] . '/images/post/' . $message['first_icon'] . '.png') ? 'images_url' : 'default_images_url'; |
|
1985 | - if (!isset($context['icon_sources'][$message['last_icon']])) |
|
1986 | - $context['icon_sources'][$message['last_icon']] = file_exists($settings['theme_dir'] . '/images/post/' . $message['last_icon'] . '.png') ? 'images_url' : 'default_images_url'; |
|
1987 | - if (!isset($context['icon_sources'][$message['icon']])) |
|
1988 | - $context['icon_sources'][$message['icon']] = file_exists($settings['theme_dir'] . '/images/post/' . $message['icon'] . '.png') ? 'images_url' : 'default_images_url'; |
|
1989 | - } |
|
1990 | - else |
|
2082 | + if (!isset($context['icon_sources'][$message['first_icon']])) { |
|
2083 | + $context['icon_sources'][$message['first_icon']] = file_exists($settings['theme_dir'] . '/images/post/' . $message['first_icon'] . '.png') ? 'images_url' : 'default_images_url'; |
|
2084 | + } |
|
2085 | + if (!isset($context['icon_sources'][$message['last_icon']])) { |
|
2086 | + $context['icon_sources'][$message['last_icon']] = file_exists($settings['theme_dir'] . '/images/post/' . $message['last_icon'] . '.png') ? 'images_url' : 'default_images_url'; |
|
2087 | + } |
|
2088 | + if (!isset($context['icon_sources'][$message['icon']])) { |
|
2089 | + $context['icon_sources'][$message['icon']] = file_exists($settings['theme_dir'] . '/images/post/' . $message['icon'] . '.png') ? 'images_url' : 'default_images_url'; |
|
2090 | + } |
|
2091 | + } else |
|
1991 | 2092 | { |
1992 | - if (!isset($context['icon_sources'][$message['first_icon']])) |
|
1993 | - $context['icon_sources'][$message['first_icon']] = 'images_url'; |
|
1994 | - if (!isset($context['icon_sources'][$message['last_icon']])) |
|
1995 | - $context['icon_sources'][$message['last_icon']] = 'images_url'; |
|
1996 | - if (!isset($context['icon_sources'][$message['icon']])) |
|
1997 | - $context['icon_sources'][$message['icon']] = 'images_url'; |
|
2093 | + if (!isset($context['icon_sources'][$message['first_icon']])) { |
|
2094 | + $context['icon_sources'][$message['first_icon']] = 'images_url'; |
|
2095 | + } |
|
2096 | + if (!isset($context['icon_sources'][$message['last_icon']])) { |
|
2097 | + $context['icon_sources'][$message['last_icon']] = 'images_url'; |
|
2098 | + } |
|
2099 | + if (!isset($context['icon_sources'][$message['icon']])) { |
|
2100 | + $context['icon_sources'][$message['icon']] = 'images_url'; |
|
2101 | + } |
|
1998 | 2102 | } |
1999 | 2103 | |
2000 | 2104 | // Do we have quote tag enabled? |
@@ -2004,12 +2108,14 @@ discard block |
||
2004 | 2108 | $colorClass = 'windowbg'; |
2005 | 2109 | |
2006 | 2110 | // Sticky topics should get a different color, too. |
2007 | - if ($message['is_sticky']) |
|
2008 | - $colorClass .= ' sticky'; |
|
2111 | + if ($message['is_sticky']) { |
|
2112 | + $colorClass .= ' sticky'; |
|
2113 | + } |
|
2009 | 2114 | |
2010 | 2115 | // Locked topics get special treatment as well. |
2011 | - if ($message['locked']) |
|
2012 | - $colorClass .= ' locked'; |
|
2116 | + if ($message['locked']) { |
|
2117 | + $colorClass .= ' locked'; |
|
2118 | + } |
|
2013 | 2119 | |
2014 | 2120 | $output = array_merge($context['topics'][$message['id_msg']], array( |
2015 | 2121 | 'id' => $message['id_topic'], |
@@ -2153,8 +2259,9 @@ discard block |
||
2153 | 2259 | |
2154 | 2260 | // Load up the search API we are going to use. |
2155 | 2261 | $modSettings['search_index'] = empty($modSettings['search_index']) ? 'standard' : $modSettings['search_index']; |
2156 | - if (!file_exists($sourcedir . '/SearchAPI-' . ucwords($modSettings['search_index']) . '.php')) |
|
2157 | - fatal_lang_error('search_api_missing'); |
|
2262 | + if (!file_exists($sourcedir . '/SearchAPI-' . ucwords($modSettings['search_index']) . '.php')) { |
|
2263 | + fatal_lang_error('search_api_missing'); |
|
2264 | + } |
|
2158 | 2265 | require_once($sourcedir . '/SearchAPI-' . ucwords($modSettings['search_index']) . '.php'); |
2159 | 2266 | |
2160 | 2267 | // Create an instance of the search API and check it is valid for this version of SMF. |
@@ -11,8 +11,9 @@ discard block |
||
11 | 11 | * @version 2.1 Beta 3 |
12 | 12 | */ |
13 | 13 | |
14 | -if (!defined('SMF')) |
|
14 | +if (!defined('SMF')) { |
|
15 | 15 | die('No direct access...'); |
16 | +} |
|
16 | 17 | |
17 | 18 | /** |
18 | 19 | * Generates the query to determine the list of available boards for a user |
@@ -25,8 +26,9 @@ discard block |
||
25 | 26 | { |
26 | 27 | global $smcFunc, $sourcedir; |
27 | 28 | |
28 | - if (isset($boardListOptions['excluded_boards']) && isset($boardListOptions['included_boards'])) |
|
29 | - trigger_error('getBoardList(): Setting both excluded_boards and included_boards is not allowed.', E_USER_ERROR); |
|
29 | + if (isset($boardListOptions['excluded_boards']) && isset($boardListOptions['included_boards'])) { |
|
30 | + trigger_error('getBoardList(): Setting both excluded_boards and included_boards is not allowed.', E_USER_ERROR); |
|
31 | + } |
|
30 | 32 | |
31 | 33 | $where = array(); |
32 | 34 | $where_parameters = array(); |
@@ -42,11 +44,11 @@ discard block |
||
42 | 44 | $where_parameters['included_boards'] = $boardListOptions['included_boards']; |
43 | 45 | } |
44 | 46 | |
45 | - if (!empty($boardListOptions['ignore_boards'])) |
|
46 | - $where[] = '{query_wanna_see_board}'; |
|
47 | - |
|
48 | - elseif (!empty($boardListOptions['use_permissions'])) |
|
49 | - $where[] = '{query_see_board}'; |
|
47 | + if (!empty($boardListOptions['ignore_boards'])) { |
|
48 | + $where[] = '{query_wanna_see_board}'; |
|
49 | + } elseif (!empty($boardListOptions['use_permissions'])) { |
|
50 | + $where[] = '{query_see_board}'; |
|
51 | + } |
|
50 | 52 | |
51 | 53 | if (!empty($boardListOptions['not_redirection'])) |
52 | 54 | { |
@@ -68,12 +70,13 @@ discard block |
||
68 | 70 | { |
69 | 71 | while ($row = $smcFunc['db_fetch_assoc']($request)) |
70 | 72 | { |
71 | - if (!isset($return_value[$row['id_cat']])) |
|
72 | - $return_value[$row['id_cat']] = array( |
|
73 | + if (!isset($return_value[$row['id_cat']])) { |
|
74 | + $return_value[$row['id_cat']] = array( |
|
73 | 75 | 'id' => $row['id_cat'], |
74 | 76 | 'name' => $row['cat_name'], |
75 | 77 | 'boards' => array(), |
76 | 78 | ); |
79 | + } |
|
77 | 80 | |
78 | 81 | $return_value[$row['id_cat']]['boards'][$row['id_board']] = array( |
79 | 82 | 'id' => $row['id_board'], |
@@ -13,8 +13,9 @@ discard block |
||
13 | 13 | * @version 2.1 Beta 3 |
14 | 14 | */ |
15 | 15 | |
16 | -if (!defined('SMF')) |
|
16 | +if (!defined('SMF')) { |
|
17 | 17 | die('No direct access...'); |
18 | +} |
|
18 | 19 | |
19 | 20 | /** |
20 | 21 | * The news dispatcher; doesn't do anything, just delegates. |
@@ -67,8 +68,9 @@ discard block |
||
67 | 68 | ); |
68 | 69 | |
69 | 70 | // Force the right area... |
70 | - if (substr($_REQUEST['sa'], 0, 7) == 'mailing') |
|
71 | - $context[$context['admin_menu_name']]['current_subsection'] = 'mailingmembers'; |
|
71 | + if (substr($_REQUEST['sa'], 0, 7) == 'mailing') { |
|
72 | + $context[$context['admin_menu_name']]['current_subsection'] = 'mailingmembers'; |
|
73 | + } |
|
72 | 74 | |
73 | 75 | call_helper($subActions[$_REQUEST['sa']][0]); |
74 | 76 | } |
@@ -99,9 +101,10 @@ discard block |
||
99 | 101 | $temp_news = explode("\n", $modSettings['news']); |
100 | 102 | |
101 | 103 | // Remove the items that were selected. |
102 | - foreach ($temp_news as $i => $news) |
|
103 | - if (in_array($i, $_POST['remove'])) |
|
104 | + foreach ($temp_news as $i => $news) { |
|
105 | + if (in_array($i, $_POST['remove'])) |
|
104 | 106 | unset($temp_news[$i]); |
107 | + } |
|
105 | 108 | |
106 | 109 | // Update the database. |
107 | 110 | updateSettings(array('news' => implode("\n", $temp_news))); |
@@ -117,9 +120,9 @@ discard block |
||
117 | 120 | |
118 | 121 | foreach ($_POST['news'] as $i => $news) |
119 | 122 | { |
120 | - if (trim($news) == '') |
|
121 | - unset($_POST['news'][$i]); |
|
122 | - else |
|
123 | + if (trim($news) == '') { |
|
124 | + unset($_POST['news'][$i]); |
|
125 | + } else |
|
123 | 126 | { |
124 | 127 | $_POST['news'][$i] = $smcFunc['htmlspecialchars']($_POST['news'][$i], ENT_QUOTES); |
125 | 128 | preparsecode($_POST['news'][$i]); |
@@ -154,11 +157,12 @@ discard block |
||
154 | 157 | 'data' => array( |
155 | 158 | 'function' => function ($news) |
156 | 159 | { |
157 | - if (is_numeric($news['id'])) |
|
158 | - return '<textarea id="data_' . $news['id'] . '" rows="3" cols="50" name="news[]" class="padding block">' . $news['unparsed'] . '</textarea> |
|
160 | + if (is_numeric($news['id'])) { |
|
161 | + return '<textarea id="data_' . $news['id'] . '" rows="3" cols="50" name="news[]" class="padding block">' . $news['unparsed'] . '</textarea> |
|
159 | 162 | <div class="floatleft" id="preview_' . $news['id'] . '"></div>'; |
160 | - else |
|
161 | - return $news['unparsed']; |
|
163 | + } else { |
|
164 | + return $news['unparsed']; |
|
165 | + } |
|
162 | 166 | }, |
163 | 167 | 'style' => 'width: 50%;', |
164 | 168 | ), |
@@ -183,10 +187,11 @@ discard block |
||
183 | 187 | 'data' => array( |
184 | 188 | 'function' => function ($news) |
185 | 189 | { |
186 | - if (is_numeric($news['id'])) |
|
187 | - return '<input type="checkbox" name="remove[]" value="' . $news['id'] . '" class="input_check">'; |
|
188 | - else |
|
189 | - return ''; |
|
190 | + if (is_numeric($news['id'])) { |
|
191 | + return '<input type="checkbox" name="remove[]" value="' . $news['id'] . '" class="input_check">'; |
|
192 | + } else { |
|
193 | + return ''; |
|
194 | + } |
|
190 | 195 | }, |
191 | 196 | 'class' => 'centercol', |
192 | 197 | ), |
@@ -280,12 +285,13 @@ discard block |
||
280 | 285 | |
281 | 286 | $admin_current_news = array(); |
282 | 287 | // Ready the current news. |
283 | - foreach (explode("\n", $modSettings['news']) as $id => $line) |
|
284 | - $admin_current_news[$id] = array( |
|
288 | + foreach (explode("\n", $modSettings['news']) as $id => $line) { |
|
289 | + $admin_current_news[$id] = array( |
|
285 | 290 | 'id' => $id, |
286 | 291 | 'unparsed' => un_preparsecode($line), |
287 | 292 | 'parsed' => preg_replace('~<([/]?)form[^>]*?[>]*>~i', '<em class="smalltext"><$1form></em>', parse_bbc($line)), |
288 | 293 | ); |
294 | + } |
|
289 | 295 | |
290 | 296 | $admin_current_news['last'] = array( |
291 | 297 | 'id' => 'last', |
@@ -352,10 +358,11 @@ discard block |
||
352 | 358 | 'member_count' => 0, |
353 | 359 | ); |
354 | 360 | |
355 | - if ($row['min_posts'] == -1) |
|
356 | - $normalGroups[$row['id_group']] = $row['id_group']; |
|
357 | - else |
|
358 | - $postGroups[$row['id_group']] = $row['id_group']; |
|
361 | + if ($row['min_posts'] == -1) { |
|
362 | + $normalGroups[$row['id_group']] = $row['id_group']; |
|
363 | + } else { |
|
364 | + $postGroups[$row['id_group']] = $row['id_group']; |
|
365 | + } |
|
359 | 366 | } |
360 | 367 | $smcFunc['db_free_result']($request); |
361 | 368 | |
@@ -371,8 +378,9 @@ discard block |
||
371 | 378 | 'post_group_list' => $postGroups, |
372 | 379 | ) |
373 | 380 | ); |
374 | - while ($row = $smcFunc['db_fetch_assoc']($query)) |
|
375 | - $context['groups'][$row['id_group']]['member_count'] += $row['member_count']; |
|
381 | + while ($row = $smcFunc['db_fetch_assoc']($query)) { |
|
382 | + $context['groups'][$row['id_group']]['member_count'] += $row['member_count']; |
|
383 | + } |
|
376 | 384 | $smcFunc['db_free_result']($query); |
377 | 385 | } |
378 | 386 | |
@@ -388,8 +396,9 @@ discard block |
||
388 | 396 | 'normal_group_list' => $normalGroups, |
389 | 397 | ) |
390 | 398 | ); |
391 | - while ($row = $smcFunc['db_fetch_assoc']($query)) |
|
392 | - $context['groups'][$row['id_group']]['member_count'] += $row['member_count']; |
|
399 | + while ($row = $smcFunc['db_fetch_assoc']($query)) { |
|
400 | + $context['groups'][$row['id_group']]['member_count'] += $row['member_count']; |
|
401 | + } |
|
393 | 402 | $smcFunc['db_free_result']($query); |
394 | 403 | |
395 | 404 | // Also do those who have it as an additional membergroup - this ones more yucky... |
@@ -406,8 +415,9 @@ discard block |
||
406 | 415 | 'blank_string' => '', |
407 | 416 | ) |
408 | 417 | ); |
409 | - while ($row = $smcFunc['db_fetch_assoc']($query)) |
|
410 | - $context['groups'][$row['id_group']]['member_count'] += $row['member_count']; |
|
418 | + while ($row = $smcFunc['db_fetch_assoc']($query)) { |
|
419 | + $context['groups'][$row['id_group']]['member_count'] += $row['member_count']; |
|
420 | + } |
|
411 | 421 | $smcFunc['db_free_result']($query); |
412 | 422 | } |
413 | 423 | |
@@ -458,10 +468,11 @@ discard block |
||
458 | 468 | { |
459 | 469 | $context[$key] = !empty($_REQUEST[$post]) ? $_REQUEST[$post] : ''; |
460 | 470 | |
461 | - if (empty($context[$key]) && empty($_REQUEST['xml'])) |
|
462 | - $context['post_error']['messages'][] = $txt['error_no_' . $post]; |
|
463 | - elseif (!empty($_REQUEST['xml'])) |
|
464 | - continue; |
|
471 | + if (empty($context[$key]) && empty($_REQUEST['xml'])) { |
|
472 | + $context['post_error']['messages'][] = $txt['error_no_' . $post]; |
|
473 | + } elseif (!empty($_REQUEST['xml'])) { |
|
474 | + continue; |
|
475 | + } |
|
465 | 476 | |
466 | 477 | preparsecode($context[$key]); |
467 | 478 | if ($html) |
@@ -540,10 +551,12 @@ discard block |
||
540 | 551 | |
541 | 552 | // Start by finding any members! |
542 | 553 | $toClean = array(); |
543 | - if (!empty($_POST['members'])) |
|
544 | - $toClean[] = 'members'; |
|
545 | - if (!empty($_POST['exclude_members'])) |
|
546 | - $toClean[] = 'exclude_members'; |
|
554 | + if (!empty($_POST['members'])) { |
|
555 | + $toClean[] = 'members'; |
|
556 | + } |
|
557 | + if (!empty($_POST['exclude_members'])) { |
|
558 | + $toClean[] = 'exclude_members'; |
|
559 | + } |
|
547 | 560 | if (!empty($toClean)) |
548 | 561 | { |
549 | 562 | require_once($sourcedir . '/Subs-Auth.php'); |
@@ -555,11 +568,13 @@ discard block |
||
555 | 568 | preg_match_all('~"([^"]+)"~', $_POST[$type], $matches); |
556 | 569 | $_POST[$type] = array_unique(array_merge($matches[1], explode(',', preg_replace('~"[^"]+"~', '', $_POST[$type])))); |
557 | 570 | |
558 | - foreach ($_POST[$type] as $index => $member) |
|
559 | - if (strlen(trim($member)) > 0) |
|
571 | + foreach ($_POST[$type] as $index => $member) { |
|
572 | + if (strlen(trim($member)) > 0) |
|
560 | 573 | $_POST[$type][$index] = $smcFunc['htmlspecialchars']($smcFunc['strtolower'](trim($member))); |
561 | - else |
|
562 | - unset($_POST[$type][$index]); |
|
574 | + } |
|
575 | + else { |
|
576 | + unset($_POST[$type][$index]); |
|
577 | + } |
|
563 | 578 | |
564 | 579 | // Find the members |
565 | 580 | $_POST[$type] = implode(',', array_keys(findMembers($_POST[$type]))); |
@@ -569,16 +584,18 @@ discard block |
||
569 | 584 | if (isset($_POST['member_list']) && is_array($_POST['member_list'])) |
570 | 585 | { |
571 | 586 | $members = array(); |
572 | - foreach ($_POST['member_list'] as $member_id) |
|
573 | - $members[] = (int) $member_id; |
|
587 | + foreach ($_POST['member_list'] as $member_id) { |
|
588 | + $members[] = (int) $member_id; |
|
589 | + } |
|
574 | 590 | $_POST['members'] = implode(',', $members); |
575 | 591 | } |
576 | 592 | |
577 | 593 | if (isset($_POST['exclude_member_list']) && is_array($_POST['exclude_member_list'])) |
578 | 594 | { |
579 | 595 | $members = array(); |
580 | - foreach ($_POST['exclude_member_list'] as $member_id) |
|
581 | - $members[] = (int) $member_id; |
|
596 | + foreach ($_POST['exclude_member_list'] as $member_id) { |
|
597 | + $members[] = (int) $member_id; |
|
598 | + } |
|
582 | 599 | $_POST['exclude_members'] = implode(',', $members); |
583 | 600 | } |
584 | 601 | |
@@ -602,8 +619,9 @@ discard block |
||
602 | 619 | 'current_time' => time(), |
603 | 620 | ) |
604 | 621 | ); |
605 | - while ($row = $smcFunc['db_fetch_assoc']($request)) |
|
606 | - $context['recipients']['exclude_members'][] = $row['id_member']; |
|
622 | + while ($row = $smcFunc['db_fetch_assoc']($request)) { |
|
623 | + $context['recipients']['exclude_members'][] = $row['id_member']; |
|
624 | + } |
|
607 | 625 | $smcFunc['db_free_result']($request); |
608 | 626 | |
609 | 627 | $request = $smcFunc['db_query']('', ' |
@@ -638,8 +656,9 @@ discard block |
||
638 | 656 | WHERE email_address IN(' . implode(', ', $condition_array) .')', |
639 | 657 | $condition_array_params |
640 | 658 | ); |
641 | - while ($row = $smcFunc['db_fetch_assoc']($request)) |
|
642 | - $context['recipients']['exclude_members'][] = $row['id_member']; |
|
659 | + while ($row = $smcFunc['db_fetch_assoc']($request)) { |
|
660 | + $context['recipients']['exclude_members'][] = $row['id_member']; |
|
661 | + } |
|
643 | 662 | $smcFunc['db_free_result']($request); |
644 | 663 | } |
645 | 664 | |
@@ -657,10 +676,11 @@ discard block |
||
657 | 676 | ); |
658 | 677 | while ($row = $smcFunc['db_fetch_assoc']($request)) |
659 | 678 | { |
660 | - if (in_array(3, $context['recipients'])) |
|
661 | - $context['recipients']['exclude_members'][] = $row['identifier']; |
|
662 | - else |
|
663 | - $context['recipients']['members'][] = $row['identifier']; |
|
679 | + if (in_array(3, $context['recipients'])) { |
|
680 | + $context['recipients']['exclude_members'][] = $row['identifier']; |
|
681 | + } else { |
|
682 | + $context['recipients']['members'][] = $row['identifier']; |
|
683 | + } |
|
664 | 684 | } |
665 | 685 | $smcFunc['db_free_result']($request); |
666 | 686 | } |
@@ -707,8 +727,9 @@ discard block |
||
707 | 727 | $num_at_once = 1000; |
708 | 728 | |
709 | 729 | // If by PM's I suggest we half the above number. |
710 | - if (!empty($_POST['send_pm'])) |
|
711 | - $num_at_once /= 2; |
|
730 | + if (!empty($_POST['send_pm'])) { |
|
731 | + $num_at_once /= 2; |
|
732 | + } |
|
712 | 733 | |
713 | 734 | checkSession(); |
714 | 735 | |
@@ -731,8 +752,7 @@ discard block |
||
731 | 752 | ); |
732 | 753 | list ($context['total_members']) = $smcFunc['db_fetch_row']($request); |
733 | 754 | $smcFunc['db_free_result']($request); |
734 | - } |
|
735 | - else |
|
755 | + } else |
|
736 | 756 | { |
737 | 757 | $context['total_members'] = (int) $_REQUEST['total_members']; |
738 | 758 | } |
@@ -750,32 +770,35 @@ discard block |
||
750 | 770 | if (!empty($_POST['exclude_members'])) |
751 | 771 | { |
752 | 772 | $members = explode(',', $_POST['exclude_members']); |
753 | - foreach ($members as $member) |
|
754 | - if ($member >= $context['start']) |
|
773 | + foreach ($members as $member) { |
|
774 | + if ($member >= $context['start']) |
|
755 | 775 | $context['recipients']['exclude_members'][] = (int) $member; |
776 | + } |
|
756 | 777 | } |
757 | 778 | |
758 | 779 | // What about members we *must* do? |
759 | 780 | if (!empty($_POST['members'])) |
760 | 781 | { |
761 | 782 | $members = explode(',', $_POST['members']); |
762 | - foreach ($members as $member) |
|
763 | - if ($member >= $context['start']) |
|
783 | + foreach ($members as $member) { |
|
784 | + if ($member >= $context['start']) |
|
764 | 785 | $context['recipients']['members'][] = (int) $member; |
786 | + } |
|
765 | 787 | } |
766 | 788 | // Cleaning groups is simple - although deal with both checkbox and commas. |
767 | 789 | if (isset($_POST['groups'])) |
768 | 790 | { |
769 | 791 | if (is_array($_POST['groups'])) |
770 | 792 | { |
771 | - foreach ($_POST['groups'] as $group => $dummy) |
|
772 | - $context['recipients']['groups'][] = (int) $group; |
|
773 | - } |
|
774 | - else |
|
793 | + foreach ($_POST['groups'] as $group => $dummy) { |
|
794 | + $context['recipients']['groups'][] = (int) $group; |
|
795 | + } |
|
796 | + } else |
|
775 | 797 | { |
776 | 798 | $groups = explode(',', $_POST['groups']); |
777 | - foreach ($groups as $group) |
|
778 | - $context['recipients']['groups'][] = (int) $group; |
|
799 | + foreach ($groups as $group) { |
|
800 | + $context['recipients']['groups'][] = (int) $group; |
|
801 | + } |
|
779 | 802 | } |
780 | 803 | } |
781 | 804 | // Same for excluded groups |
@@ -783,14 +806,15 @@ discard block |
||
783 | 806 | { |
784 | 807 | if (is_array($_POST['exclude_groups'])) |
785 | 808 | { |
786 | - foreach ($_POST['exclude_groups'] as $group => $dummy) |
|
787 | - $context['recipients']['exclude_groups'][] = (int) $group; |
|
788 | - } |
|
789 | - else |
|
809 | + foreach ($_POST['exclude_groups'] as $group => $dummy) { |
|
810 | + $context['recipients']['exclude_groups'][] = (int) $group; |
|
811 | + } |
|
812 | + } else |
|
790 | 813 | { |
791 | 814 | $groups = explode(',', $_POST['exclude_groups']); |
792 | - foreach ($groups as $group) |
|
793 | - $context['recipients']['exclude_groups'][] = (int) $group; |
|
815 | + foreach ($groups as $group) { |
|
816 | + $context['recipients']['exclude_groups'][] = (int) $group; |
|
817 | + } |
|
794 | 818 | } |
795 | 819 | } |
796 | 820 | // Finally - emails! |
@@ -800,14 +824,16 @@ discard block |
||
800 | 824 | foreach ($addressed as $curmem) |
801 | 825 | { |
802 | 826 | $curmem = trim($curmem); |
803 | - if ($curmem != '' && filter_var($curmem, FILTER_VALIDATE_EMAIL)) |
|
804 | - $context['recipients']['emails'][$curmem] = $curmem; |
|
827 | + if ($curmem != '' && filter_var($curmem, FILTER_VALIDATE_EMAIL)) { |
|
828 | + $context['recipients']['emails'][$curmem] = $curmem; |
|
829 | + } |
|
805 | 830 | } |
806 | 831 | } |
807 | 832 | |
808 | 833 | // If we're only cleaning drop out here. |
809 | - if ($clean_only) |
|
810 | - return; |
|
834 | + if ($clean_only) { |
|
835 | + return; |
|
836 | + } |
|
811 | 837 | |
812 | 838 | require_once($sourcedir . '/Subs-Post.php'); |
813 | 839 | |
@@ -823,16 +849,18 @@ discard block |
||
823 | 849 | if (!$context['send_pm'] && !empty($_POST['send_html'])) |
824 | 850 | { |
825 | 851 | // Prepare the message for HTML. |
826 | - if (!empty($_POST['parse_html'])) |
|
827 | - $_POST['message'] = str_replace(array("\n", ' '), array('<br>' . "\n", ' '), $_POST['message']); |
|
852 | + if (!empty($_POST['parse_html'])) { |
|
853 | + $_POST['message'] = str_replace(array("\n", ' '), array('<br>' . "\n", ' '), $_POST['message']); |
|
854 | + } |
|
828 | 855 | |
829 | 856 | // This is here to prevent spam filters from tagging this as spam. |
830 | 857 | if (preg_match('~\<html~i', $_POST['message']) == 0) |
831 | 858 | { |
832 | - if (preg_match('~\<body~i', $_POST['message']) == 0) |
|
833 | - $_POST['message'] = '<html><head><title>' . $_POST['subject'] . '</title></head>' . "\n" . '<body>' . $_POST['message'] . '</body></html>'; |
|
834 | - else |
|
835 | - $_POST['message'] = '<html>' . $_POST['message'] . '</html>'; |
|
859 | + if (preg_match('~\<body~i', $_POST['message']) == 0) { |
|
860 | + $_POST['message'] = '<html><head><title>' . $_POST['subject'] . '</title></head>' . "\n" . '<body>' . $_POST['message'] . '</body></html>'; |
|
861 | + } else { |
|
862 | + $_POST['message'] = '<html>' . $_POST['message'] . '</html>'; |
|
863 | + } |
|
836 | 864 | } |
837 | 865 | } |
838 | 866 | |
@@ -886,15 +914,17 @@ discard block |
||
886 | 914 | foreach ($context['recipients']['emails'] as $k => $email) |
887 | 915 | { |
888 | 916 | // Done as many as we can? |
889 | - if ($i >= $num_at_once) |
|
890 | - break; |
|
917 | + if ($i >= $num_at_once) { |
|
918 | + break; |
|
919 | + } |
|
891 | 920 | |
892 | 921 | // Don't sent it twice! |
893 | 922 | unset($context['recipients']['emails'][$k]); |
894 | 923 | |
895 | 924 | // Dammit - can't PM emails! |
896 | - if ($context['send_pm']) |
|
897 | - continue; |
|
925 | + if ($context['send_pm']) { |
|
926 | + continue; |
|
927 | + } |
|
898 | 928 | |
899 | 929 | $to_member = array( |
900 | 930 | $email, |
@@ -928,8 +958,9 @@ discard block |
||
928 | 958 | $queryBuild[] = 'mem.id_post_group = {int:group_' . $group . '}'; |
929 | 959 | } |
930 | 960 | } |
931 | - if (!empty($queryBuild)) |
|
932 | - $sendQuery .= implode(' OR ', $queryBuild); |
|
961 | + if (!empty($queryBuild)) { |
|
962 | + $sendQuery .= implode(' OR ', $queryBuild); |
|
963 | + } |
|
933 | 964 | } |
934 | 965 | if (!empty($context['recipients']['members'])) |
935 | 966 | { |
@@ -948,8 +979,9 @@ discard block |
||
948 | 979 | } |
949 | 980 | |
950 | 981 | // Anything to exclude? |
951 | - if (!empty($context['recipients']['exclude_groups']) && in_array(0, $context['recipients']['exclude_groups'])) |
|
952 | - $sendQuery .= ' AND mem.id_group != {int:regular_group}'; |
|
982 | + if (!empty($context['recipients']['exclude_groups']) && in_array(0, $context['recipients']['exclude_groups'])) { |
|
983 | + $sendQuery .= ' AND mem.id_group != {int:regular_group}'; |
|
984 | + } |
|
953 | 985 | if (!empty($context['recipients']['exclude_members'])) |
954 | 986 | { |
955 | 987 | $sendQuery .= ' AND mem.id_member NOT IN ({array_int:exclude_members})'; |
@@ -985,21 +1017,24 @@ discard block |
||
985 | 1017 | foreach ($rows as $row) |
986 | 1018 | { |
987 | 1019 | // Force them to have it? |
988 | - if (empty($context['email_force']) || empty($prefs[$row['id_member']]['announcements'])) |
|
989 | - continue; |
|
1020 | + if (empty($context['email_force']) || empty($prefs[$row['id_member']]['announcements'])) { |
|
1021 | + continue; |
|
1022 | + } |
|
990 | 1023 | |
991 | 1024 | // What groups are we looking at here? |
992 | - if (empty($row['additional_groups'])) |
|
993 | - $groups = array($row['id_group'], $row['id_post_group']); |
|
994 | - else |
|
995 | - $groups = array_merge( |
|
1025 | + if (empty($row['additional_groups'])) { |
|
1026 | + $groups = array($row['id_group'], $row['id_post_group']); |
|
1027 | + } else { |
|
1028 | + $groups = array_merge( |
|
996 | 1029 | array($row['id_group'], $row['id_post_group']), |
997 | 1030 | explode(',', $row['additional_groups']) |
998 | 1031 | ); |
1032 | + } |
|
999 | 1033 | |
1000 | 1034 | // Excluded groups? |
1001 | - if (array_intersect($groups, $context['recipients']['exclude_groups'])) |
|
1002 | - continue; |
|
1035 | + if (array_intersect($groups, $context['recipients']['exclude_groups'])) { |
|
1036 | + continue; |
|
1037 | + } |
|
1003 | 1038 | |
1004 | 1039 | // We might need this |
1005 | 1040 | $cleanMemberName = empty($_POST['send_html']) || $context['send_pm'] ? un_htmlspecialchars($row['real_name']) : $row['real_name']; |
@@ -1022,10 +1057,11 @@ discard block |
||
1022 | 1057 | ), $_POST['subject']); |
1023 | 1058 | |
1024 | 1059 | // Send the actual email - or a PM! |
1025 | - if (!$context['send_pm']) |
|
1026 | - sendmail($row['email_address'], $subject, $message, null, 'news', !empty($_POST['send_html']), 5); |
|
1027 | - else |
|
1028 | - sendpm(array('to' => array($row['id_member']), 'bcc' => array()), $subject, $message); |
|
1060 | + if (!$context['send_pm']) { |
|
1061 | + sendmail($row['email_address'], $subject, $message, null, 'news', !empty($_POST['send_html']), 5); |
|
1062 | + } else { |
|
1063 | + sendpm(array('to' => array($row['id_member']), 'bcc' => array()), $subject, $message); |
|
1064 | + } |
|
1029 | 1065 | } |
1030 | 1066 | } |
1031 | 1067 | |
@@ -1074,8 +1110,9 @@ discard block |
||
1074 | 1110 | |
1075 | 1111 | call_integration_hook('integrate_modify_news_settings', array(&$config_vars)); |
1076 | 1112 | |
1077 | - if ($return_config) |
|
1078 | - return $config_vars; |
|
1113 | + if ($return_config) { |
|
1114 | + return $config_vars; |
|
1115 | + } |
|
1079 | 1116 | |
1080 | 1117 | $context['page_title'] = $txt['admin_edit_news'] . ' - ' . $txt['settings']; |
1081 | 1118 | $context['sub_template'] = 'show_settings'; |
@@ -10,8 +10,9 @@ discard block |
||
10 | 10 | * @version 2.1 Beta 3 |
11 | 11 | */ |
12 | 12 | |
13 | -if (!defined('SMF')) |
|
13 | +if (!defined('SMF')) { |
|
14 | 14 | die('No direct access...'); |
15 | +} |
|
15 | 16 | |
16 | 17 | /** |
17 | 18 | * Class curl_fetch_web_data |
@@ -87,10 +88,11 @@ discard block |
||
87 | 88 | public function get_url_data($url, $post_data = array()) |
88 | 89 | { |
89 | 90 | // POSTing some data perhaps? |
90 | - if (!empty($post_data) && is_array($post_data)) |
|
91 | - $this->post_data = $this->build_post_data($post_data); |
|
92 | - elseif (!empty($post_data)) |
|
93 | - $this->post_data = trim($post_data); |
|
91 | + if (!empty($post_data) && is_array($post_data)) { |
|
92 | + $this->post_data = $this->build_post_data($post_data); |
|
93 | + } elseif (!empty($post_data)) { |
|
94 | + $this->post_data = trim($post_data); |
|
95 | + } |
|
94 | 96 | |
95 | 97 | // set the options and get it |
96 | 98 | $this->set_options(); |
@@ -111,10 +113,11 @@ discard block |
||
111 | 113 | private function curl_request($url, $redirect = false) |
112 | 114 | { |
113 | 115 | // we do have a url I hope |
114 | - if ($url == '') |
|
115 | - return false; |
|
116 | - else |
|
117 | - $this->options[CURLOPT_URL] = $url; |
|
116 | + if ($url == '') { |
|
117 | + return false; |
|
118 | + } else { |
|
119 | + $this->options[CURLOPT_URL] = $url; |
|
120 | + } |
|
118 | 121 | |
119 | 122 | // if we have not already been redirected, set it up so we can if needed |
120 | 123 | if (!$redirect) |
@@ -194,10 +197,11 @@ discard block |
||
194 | 197 | $max_result = count($this->response) - 1; |
195 | 198 | |
196 | 199 | // just return a specifed area or the entire result? |
197 | - if ($area == '') |
|
198 | - return $this->response[$max_result]; |
|
199 | - else |
|
200 | - return isset($this->response[$max_result][$area]) ? $this->response[$max_result][$area] : $this->response[$max_result]; |
|
200 | + if ($area == '') { |
|
201 | + return $this->response[$max_result]; |
|
202 | + } else { |
|
203 | + return isset($this->response[$max_result][$area]) ? $this->response[$max_result][$area] : $this->response[$max_result]; |
|
204 | + } |
|
201 | 205 | } |
202 | 206 | |
203 | 207 | /** |
@@ -210,9 +214,9 @@ discard block |
||
210 | 214 | */ |
211 | 215 | public function result_raw($response_number = '') |
212 | 216 | { |
213 | - if (!is_numeric($response_number)) |
|
214 | - return $this->response; |
|
215 | - else |
|
217 | + if (!is_numeric($response_number)) { |
|
218 | + return $this->response; |
|
219 | + } else |
|
216 | 220 | { |
217 | 221 | $response_number = min($response_number, count($this->response) - 1); |
218 | 222 | return $this->response[$response_number]; |
@@ -234,13 +238,14 @@ discard block |
||
234 | 238 | $postvars = array(); |
235 | 239 | |
236 | 240 | // build the post data, drop ones with leading @'s since those can be used to send files, we don't support that. |
237 | - foreach ($post_data as $name => $value) |
|
238 | - $postvars[] = $name . '=' . urlencode($value[0] == '@' ? '' : $value); |
|
241 | + foreach ($post_data as $name => $value) { |
|
242 | + $postvars[] = $name . '=' . urlencode($value[0] == '@' ? '' : $value); |
|
243 | + } |
|
239 | 244 | |
240 | 245 | return implode('&', $postvars); |
246 | + } else { |
|
247 | + return $post_data; |
|
241 | 248 | } |
242 | - else |
|
243 | - return $post_data; |
|
244 | 249 | |
245 | 250 | } |
246 | 251 | |
@@ -261,9 +266,9 @@ discard block |
||
261 | 266 | $keys = array_merge(array_keys($this->default_options), array_keys($this->user_options)); |
262 | 267 | $vals = array_merge($this->default_options, $this->user_options); |
263 | 268 | $this->options = array_combine($keys, $vals); |
269 | + } else { |
|
270 | + $this->options = $this->default_options; |
|
264 | 271 | } |
265 | - else |
|
266 | - $this->options = $this->default_options; |
|
267 | 272 | |
268 | 273 | // POST data options, here we don't allow any overide |
269 | 274 | if (isset($this->post_data)) |
@@ -302,8 +307,9 @@ discard block |
||
302 | 307 | $temp = explode(': ', $_header, 2); |
303 | 308 | |
304 | 309 | // set proper headers only |
305 | - if (isset($temp[0]) && isset($temp[1])) |
|
306 | - $this->headers[strtolower($temp[0])] = strtolower(trim($temp[1])); |
|
310 | + if (isset($temp[0]) && isset($temp[1])) { |
|
311 | + $this->headers[strtolower($temp[0])] = strtolower(trim($temp[1])); |
|
312 | + } |
|
307 | 313 | |
308 | 314 | // return the length of what was passed unless you want a Failed writing header error ;) |
309 | 315 | return strlen($header); |
@@ -13,8 +13,9 @@ discard block |
||
13 | 13 | * @version 2.1 Beta 3 |
14 | 14 | */ |
15 | 15 | |
16 | -if (!defined('SMF')) |
|
16 | +if (!defined('SMF')) { |
|
17 | 17 | die('No direct access...'); |
18 | +} |
|
18 | 19 | |
19 | 20 | /** |
20 | 21 | * This is a handling function for all things post moderation. |
@@ -39,8 +40,9 @@ discard block |
||
39 | 40 | ); |
40 | 41 | |
41 | 42 | // Pick something valid... |
42 | - if (!isset($_REQUEST['sa']) || !isset($subActions[$_REQUEST['sa']])) |
|
43 | - $_REQUEST['sa'] = 'replies'; |
|
43 | + if (!isset($_REQUEST['sa']) || !isset($subActions[$_REQUEST['sa']])) { |
|
44 | + $_REQUEST['sa'] = 'replies'; |
|
45 | + } |
|
44 | 46 | |
45 | 47 | call_integration_hook('integrate_post_moderation', array(&$subActions)); |
46 | 48 | |
@@ -68,13 +70,15 @@ discard block |
||
68 | 70 | $approve_boards = $approve_boards == array(0) ? $filter_board : array_intersect($approve_boards, $filter_board); |
69 | 71 | } |
70 | 72 | |
71 | - if ($approve_boards == array(0)) |
|
72 | - $approve_query = ''; |
|
73 | - elseif (!empty($approve_boards)) |
|
74 | - $approve_query = ' AND m.id_board IN (' . implode(',', $approve_boards) . ')'; |
|
73 | + if ($approve_boards == array(0)) { |
|
74 | + $approve_query = ''; |
|
75 | + } elseif (!empty($approve_boards)) { |
|
76 | + $approve_query = ' AND m.id_board IN (' . implode(',', $approve_boards) . ')'; |
|
77 | + } |
|
75 | 78 | // Nada, zip, etc... |
76 | - else |
|
77 | - $approve_query = ' AND 1=0'; |
|
79 | + else { |
|
80 | + $approve_query = ' AND 1=0'; |
|
81 | + } |
|
78 | 82 | |
79 | 83 | // We also need to know where we can delete topics and/or replies to. |
80 | 84 | if ($context['current_view'] == 'topics') |
@@ -82,8 +86,7 @@ discard block |
||
82 | 86 | $delete_own_boards = boardsAllowedTo('remove_own'); |
83 | 87 | $delete_any_boards = boardsAllowedTo('remove_any'); |
84 | 88 | $delete_own_replies = array(); |
85 | - } |
|
86 | - else |
|
89 | + } else |
|
87 | 90 | { |
88 | 91 | $delete_own_boards = boardsAllowedTo('delete_own'); |
89 | 92 | $delete_any_boards = boardsAllowedTo('delete_any'); |
@@ -92,21 +95,25 @@ discard block |
||
92 | 95 | |
93 | 96 | $toAction = array(); |
94 | 97 | // Check if we have something to do? |
95 | - if (isset($_GET['approve'])) |
|
96 | - $toAction[] = (int) $_GET['approve']; |
|
98 | + if (isset($_GET['approve'])) { |
|
99 | + $toAction[] = (int) $_GET['approve']; |
|
100 | + } |
|
97 | 101 | // Just a deletion? |
98 | - elseif (isset($_GET['delete'])) |
|
99 | - $toAction[] = (int) $_GET['delete']; |
|
102 | + elseif (isset($_GET['delete'])) { |
|
103 | + $toAction[] = (int) $_GET['delete']; |
|
104 | + } |
|
100 | 105 | // Lots of approvals? |
101 | - elseif (isset($_POST['item'])) |
|
102 | - foreach ($_POST['item'] as $item) |
|
106 | + elseif (isset($_POST['item'])) { |
|
107 | + foreach ($_POST['item'] as $item) |
|
103 | 108 | $toAction[] = (int) $item; |
109 | + } |
|
104 | 110 | |
105 | 111 | // What are we actually doing. |
106 | - if (isset($_GET['approve']) || (isset($_POST['do']) && $_POST['do'] == 'approve')) |
|
107 | - $curAction = 'approve'; |
|
108 | - elseif (isset($_GET['delete']) || (isset($_POST['do']) && $_POST['do'] == 'delete')) |
|
109 | - $curAction = 'delete'; |
|
112 | + if (isset($_GET['approve']) || (isset($_POST['do']) && $_POST['do'] == 'approve')) { |
|
113 | + $curAction = 'approve'; |
|
114 | + } elseif (isset($_GET['delete']) || (isset($_POST['do']) && $_POST['do'] == 'delete')) { |
|
115 | + $curAction = 'delete'; |
|
116 | + } |
|
110 | 117 | |
111 | 118 | // Right, so we have something to do? |
112 | 119 | if (!empty($toAction) && isset($curAction)) |
@@ -135,8 +142,9 @@ discard block |
||
135 | 142 | while ($row = $smcFunc['db_fetch_assoc']($request)) |
136 | 143 | { |
137 | 144 | // If it's not within what our view is ignore it... |
138 | - if (($row['id_msg'] == $row['id_first_msg'] && $context['current_view'] != 'topics') || ($row['id_msg'] != $row['id_first_msg'] && $context['current_view'] != 'replies')) |
|
139 | - continue; |
|
145 | + if (($row['id_msg'] == $row['id_first_msg'] && $context['current_view'] != 'topics') || ($row['id_msg'] != $row['id_first_msg'] && $context['current_view'] != 'replies')) { |
|
146 | + continue; |
|
147 | + } |
|
140 | 148 | |
141 | 149 | $can_add = false; |
142 | 150 | // If we're approving this is simple. |
@@ -148,18 +156,22 @@ discard block |
||
148 | 156 | elseif ($curAction == 'delete') |
149 | 157 | { |
150 | 158 | // Own post is easy! |
151 | - if ($row['id_member'] == $user_info['id'] && ($delete_own_boards == array(0) || in_array($row['id_board'], $delete_own_boards))) |
|
152 | - $can_add = true; |
|
159 | + if ($row['id_member'] == $user_info['id'] && ($delete_own_boards == array(0) || in_array($row['id_board'], $delete_own_boards))) { |
|
160 | + $can_add = true; |
|
161 | + } |
|
153 | 162 | // Is it a reply to their own topic? |
154 | - elseif ($row['id_member'] == $row['id_member_started'] && $row['id_msg'] != $row['id_first_msg'] && ($delete_own_replies == array(0) || in_array($row['id_board'], $delete_own_replies))) |
|
155 | - $can_add = true; |
|
163 | + elseif ($row['id_member'] == $row['id_member_started'] && $row['id_msg'] != $row['id_first_msg'] && ($delete_own_replies == array(0) || in_array($row['id_board'], $delete_own_replies))) { |
|
164 | + $can_add = true; |
|
165 | + } |
|
156 | 166 | // Someone elses? |
157 | - elseif ($row['id_member'] != $user_info['id'] && ($delete_any_boards == array(0) || in_array($row['id_board'], $delete_any_boards))) |
|
158 | - $can_add = true; |
|
167 | + elseif ($row['id_member'] != $user_info['id'] && ($delete_any_boards == array(0) || in_array($row['id_board'], $delete_any_boards))) { |
|
168 | + $can_add = true; |
|
169 | + } |
|
159 | 170 | } |
160 | 171 | |
161 | - if ($can_add) |
|
162 | - $anItem = $context['current_view'] == 'topics' ? $row['id_topic'] : $row['id_msg']; |
|
172 | + if ($can_add) { |
|
173 | + $anItem = $context['current_view'] == 'topics' ? $row['id_topic'] : $row['id_msg']; |
|
174 | + } |
|
163 | 175 | $toAction[] = $anItem; |
164 | 176 | |
165 | 177 | // All clear. What have we got now, what, what? |
@@ -177,8 +189,7 @@ discard block |
||
177 | 189 | if ($curAction == 'approve') |
178 | 190 | { |
179 | 191 | approveMessages ($toAction, $details, $context['current_view']); |
180 | - } |
|
181 | - else |
|
192 | + } else |
|
182 | 193 | { |
183 | 194 | removeMessages ($toAction, $details, $context['current_view']); |
184 | 195 | } |
@@ -265,16 +276,19 @@ discard block |
||
265 | 276 | for ($i = 1; $row = $smcFunc['db_fetch_assoc']($request); $i++) |
266 | 277 | { |
267 | 278 | // Can delete is complicated, let's solve it first... is it their own post? |
268 | - if ($row['id_member'] == $user_info['id'] && ($delete_own_boards == array(0) || in_array($row['id_board'], $delete_own_boards))) |
|
269 | - $can_delete = true; |
|
279 | + if ($row['id_member'] == $user_info['id'] && ($delete_own_boards == array(0) || in_array($row['id_board'], $delete_own_boards))) { |
|
280 | + $can_delete = true; |
|
281 | + } |
|
270 | 282 | // Is it a reply to their own topic? |
271 | - elseif ($row['id_member'] == $row['id_member_started'] && $row['id_msg'] != $row['id_first_msg'] && ($delete_own_replies == array(0) || in_array($row['id_board'], $delete_own_replies))) |
|
272 | - $can_delete = true; |
|
283 | + elseif ($row['id_member'] == $row['id_member_started'] && $row['id_msg'] != $row['id_first_msg'] && ($delete_own_replies == array(0) || in_array($row['id_board'], $delete_own_replies))) { |
|
284 | + $can_delete = true; |
|
285 | + } |
|
273 | 286 | // Someone elses? |
274 | - elseif ($row['id_member'] != $user_info['id'] && ($delete_any_boards == array(0) || in_array($row['id_board'], $delete_any_boards))) |
|
275 | - $can_delete = true; |
|
276 | - else |
|
277 | - $can_delete = false; |
|
287 | + elseif ($row['id_member'] != $user_info['id'] && ($delete_any_boards == array(0) || in_array($row['id_board'], $delete_any_boards))) { |
|
288 | + $can_delete = true; |
|
289 | + } else { |
|
290 | + $can_delete = false; |
|
291 | + } |
|
278 | 292 | |
279 | 293 | $context['unapproved_items'][] = array( |
280 | 294 | 'id' => $row['id_msg'], |
@@ -323,28 +337,31 @@ discard block |
||
323 | 337 | // Once again, permissions are king! |
324 | 338 | $approve_boards = boardsAllowedTo('approve_posts'); |
325 | 339 | |
326 | - if ($approve_boards == array(0)) |
|
327 | - $approve_query = ''; |
|
328 | - elseif (!empty($approve_boards)) |
|
329 | - $approve_query = ' AND m.id_board IN (' . implode(',', $approve_boards) . ')'; |
|
330 | - else |
|
331 | - $approve_query = ' AND 1=0'; |
|
340 | + if ($approve_boards == array(0)) { |
|
341 | + $approve_query = ''; |
|
342 | + } elseif (!empty($approve_boards)) { |
|
343 | + $approve_query = ' AND m.id_board IN (' . implode(',', $approve_boards) . ')'; |
|
344 | + } else { |
|
345 | + $approve_query = ' AND 1=0'; |
|
346 | + } |
|
332 | 347 | |
333 | 348 | // Get together the array of things to act on, if any. |
334 | 349 | $attachments = array(); |
335 | - if (isset($_GET['approve'])) |
|
336 | - $attachments[] = (int) $_GET['approve']; |
|
337 | - elseif (isset($_GET['delete'])) |
|
338 | - $attachments[] = (int) $_GET['delete']; |
|
339 | - elseif (isset($_POST['item'])) |
|
340 | - foreach ($_POST['item'] as $item) |
|
350 | + if (isset($_GET['approve'])) { |
|
351 | + $attachments[] = (int) $_GET['approve']; |
|
352 | + } elseif (isset($_GET['delete'])) { |
|
353 | + $attachments[] = (int) $_GET['delete']; |
|
354 | + } elseif (isset($_POST['item'])) { |
|
355 | + foreach ($_POST['item'] as $item) |
|
341 | 356 | $attachments[] = (int) $item; |
357 | + } |
|
342 | 358 | |
343 | 359 | // Are we approving or deleting? |
344 | - if (isset($_GET['approve']) || (isset($_POST['do']) && $_POST['do'] == 'approve')) |
|
345 | - $curAction = 'approve'; |
|
346 | - elseif (isset($_GET['delete']) || (isset($_POST['do']) && $_POST['do'] == 'delete')) |
|
347 | - $curAction = 'delete'; |
|
360 | + if (isset($_GET['approve']) || (isset($_POST['do']) && $_POST['do'] == 'approve')) { |
|
361 | + $curAction = 'approve'; |
|
362 | + } elseif (isset($_GET['delete']) || (isset($_POST['do']) && $_POST['do'] == 'delete')) { |
|
363 | + $curAction = 'delete'; |
|
364 | + } |
|
348 | 365 | |
349 | 366 | // Something to do, let's do it! |
350 | 367 | if (!empty($attachments) && isset($curAction)) |
@@ -372,17 +389,19 @@ discard block |
||
372 | 389 | ) |
373 | 390 | ); |
374 | 391 | $attachments = array(); |
375 | - while ($row = $smcFunc['db_fetch_assoc']($request)) |
|
376 | - $attachments[] = $row['id_attach']; |
|
392 | + while ($row = $smcFunc['db_fetch_assoc']($request)) { |
|
393 | + $attachments[] = $row['id_attach']; |
|
394 | + } |
|
377 | 395 | $smcFunc['db_free_result']($request); |
378 | 396 | |
379 | 397 | // Assuming it wasn't all like, proper illegal, we can do the approving. |
380 | 398 | if (!empty($attachments)) |
381 | 399 | { |
382 | - if ($curAction == 'approve') |
|
383 | - ApproveAttachments($attachments); |
|
384 | - else |
|
385 | - removeAttachments(array('id_attach' => $attachments, 'do_logging' => true)); |
|
400 | + if ($curAction == 'approve') { |
|
401 | + ApproveAttachments($attachments); |
|
402 | + } else { |
|
403 | + removeAttachments(array('id_attach' => $attachments, 'do_logging' => true)); |
|
404 | + } |
|
386 | 405 | } |
387 | 406 | } |
388 | 407 | |
@@ -682,15 +701,16 @@ discard block |
||
682 | 701 | { |
683 | 702 | approveTopics($topic, !$approved); |
684 | 703 | |
685 | - if ($starter != $user_info['id']) |
|
686 | - logAction(($approved ? 'un' : '') . 'approve_topic', array('topic' => $topic, 'subject' => $subject, 'member' => $starter, 'board' => $board)); |
|
687 | - } |
|
688 | - else |
|
704 | + if ($starter != $user_info['id']) { |
|
705 | + logAction(($approved ? 'un' : '') . 'approve_topic', array('topic' => $topic, 'subject' => $subject, 'member' => $starter, 'board' => $board)); |
|
706 | + } |
|
707 | + } else |
|
689 | 708 | { |
690 | 709 | approvePosts($_REQUEST['msg'], !$approved); |
691 | 710 | |
692 | - if ($poster != $user_info['id']) |
|
693 | - logAction(($approved ? 'un' : '') . 'approve', array('topic' => $topic, 'subject' => $subject, 'member' => $poster, 'board' => $board)); |
|
711 | + if ($poster != $user_info['id']) { |
|
712 | + logAction(($approved ? 'un' : '') . 'approve', array('topic' => $topic, 'subject' => $subject, 'member' => $poster, 'board' => $board)); |
|
713 | + } |
|
694 | 714 | } |
695 | 715 | |
696 | 716 | redirectexit('topic=' . $topic . '.msg' . $_REQUEST['msg']. '#msg' . $_REQUEST['msg']); |
@@ -716,8 +736,7 @@ discard block |
||
716 | 736 | { |
717 | 737 | logAction('approve_topic', array('topic' => $topic, 'subject' => $messageDetails[$topic]['subject'], 'member' => $messageDetails[$topic]['member'], 'board' => $messageDetails[$topic]['board'])); |
718 | 738 | } |
719 | - } |
|
720 | - else |
|
739 | + } else |
|
721 | 740 | { |
722 | 741 | approvePosts($messages); |
723 | 742 | // and tell the world about it again |
@@ -745,8 +764,9 @@ discard block |
||
745 | 764 | ) |
746 | 765 | ); |
747 | 766 | $msgs = array(); |
748 | - while ($row = $smcFunc['db_fetch_row']($request)) |
|
749 | - $msgs[] = $row[0]; |
|
767 | + while ($row = $smcFunc['db_fetch_row']($request)) { |
|
768 | + $msgs[] = $row[0]; |
|
769 | + } |
|
750 | 770 | $smcFunc['db_free_result']($request); |
751 | 771 | |
752 | 772 | if (!empty($msgs)) |
@@ -765,8 +785,9 @@ discard block |
||
765 | 785 | ) |
766 | 786 | ); |
767 | 787 | $attaches = array(); |
768 | - while ($row = $smcFunc['db_fetch_row']($request)) |
|
769 | - $attaches[] = $row[0]; |
|
788 | + while ($row = $smcFunc['db_fetch_row']($request)) { |
|
789 | + $attaches[] = $row[0]; |
|
790 | + } |
|
770 | 791 | $smcFunc['db_free_result']($request); |
771 | 792 | |
772 | 793 | if (!empty($attaches)) |
@@ -794,12 +815,12 @@ discard block |
||
794 | 815 | { |
795 | 816 | removeTopics($messages); |
796 | 817 | // and tell the world about it |
797 | - foreach ($messages as $topic) |
|
798 | - // Note, only log topic ID in native form if it's not gone forever. |
|
818 | + foreach ($messages as $topic) { |
|
819 | + // Note, only log topic ID in native form if it's not gone forever. |
|
799 | 820 | logAction('remove', array( |
800 | 821 | (empty($modSettings['recycle_enable']) || $modSettings['recycle_board'] != $messageDetails[$topic]['board'] ? 'topic' : 'old_topic_id') => $topic, 'subject' => $messageDetails[$topic]['subject'], 'member' => $messageDetails[$topic]['member'], 'board' => $messageDetails[$topic]['board'])); |
801 | - } |
|
802 | - else |
|
822 | + } |
|
823 | + } else |
|
803 | 824 | { |
804 | 825 | foreach ($messages as $post) |
805 | 826 | { |
@@ -13,8 +13,9 @@ discard block |
||
13 | 13 | * @version 2.1 Beta 3 |
14 | 14 | */ |
15 | 15 | |
16 | -if (!defined('SMF')) |
|
16 | +if (!defined('SMF')) { |
|
17 | 17 | die('No direct access...'); |
18 | +} |
|
18 | 19 | |
19 | 20 | /** |
20 | 21 | * Entry point for this section. |
@@ -38,8 +39,7 @@ discard block |
||
38 | 39 | 'stats' => 'SpiderStats', |
39 | 40 | ); |
40 | 41 | $default = 'stats'; |
41 | - } |
|
42 | - else |
|
42 | + } else |
|
43 | 43 | { |
44 | 44 | $subActions = array( |
45 | 45 | 'settings' => 'ManageSearchEngineSettings', |
@@ -90,11 +90,12 @@ discard block |
||
90 | 90 | { |
91 | 91 | disabledState = document.getElementById(\'spider_mode\').value == 0;'; |
92 | 92 | |
93 | - foreach ($config_vars as $variable) |
|
94 | - if ($variable[1] != 'spider_mode') |
|
93 | + foreach ($config_vars as $variable) { |
|
94 | + if ($variable[1] != 'spider_mode') |
|
95 | 95 | $javascript_function .= ' |
96 | 96 | if (document.getElementById(\'' . $variable[1] . '\')) |
97 | 97 | document.getElementById(\'' . $variable[1] . '\').disabled = disabledState;'; |
98 | + } |
|
98 | 99 | |
99 | 100 | $javascript_function .= ' |
100 | 101 | } |
@@ -102,8 +103,9 @@ discard block |
||
102 | 103 | |
103 | 104 | call_integration_hook('integrate_modify_search_engine_settings', array(&$config_vars)); |
104 | 105 | |
105 | - if ($return_config) |
|
106 | - return $config_vars; |
|
106 | + if ($return_config) { |
|
107 | + return $config_vars; |
|
108 | + } |
|
107 | 109 | |
108 | 110 | // We need to load the groups for the spider group thingy. |
109 | 111 | $request = $smcFunc['db_query']('', ' |
@@ -116,13 +118,15 @@ discard block |
||
116 | 118 | 'moderator_group' => 3, |
117 | 119 | ) |
118 | 120 | ); |
119 | - while ($row = $smcFunc['db_fetch_assoc']($request)) |
|
120 | - $config_vars['spider_group'][2][$row['id_group']] = $row['group_name']; |
|
121 | + while ($row = $smcFunc['db_fetch_assoc']($request)) { |
|
122 | + $config_vars['spider_group'][2][$row['id_group']] = $row['group_name']; |
|
123 | + } |
|
121 | 124 | $smcFunc['db_free_result']($request); |
122 | 125 | |
123 | 126 | // Make sure it's valid - note that regular members are given id_group = 1 which is reversed in Load.php - no admins here! |
124 | - if (isset($_POST['spider_group']) && !isset($config_vars['spider_group'][2][$_POST['spider_group']])) |
|
125 | - $_POST['spider_group'] = 0; |
|
127 | + if (isset($_POST['spider_group']) && !isset($config_vars['spider_group'][2][$_POST['spider_group']])) { |
|
128 | + $_POST['spider_group'] = 0; |
|
129 | + } |
|
126 | 130 | |
127 | 131 | // We'll want this for our easy save. |
128 | 132 | require_once($sourcedir . '/ManageServer.php'); |
@@ -166,8 +170,9 @@ discard block |
||
166 | 170 | } |
167 | 171 | |
168 | 172 | // Are we adding a new one? |
169 | - if (!empty($_POST['addSpider'])) |
|
170 | - return EditSpider(); |
|
173 | + if (!empty($_POST['addSpider'])) { |
|
174 | + return EditSpider(); |
|
175 | + } |
|
171 | 176 | // User pressed the 'remove selection button'. |
172 | 177 | elseif (!empty($_POST['removeSpiders']) && !empty($_POST['remove']) && is_array($_POST['remove'])) |
173 | 178 | { |
@@ -175,8 +180,9 @@ discard block |
||
175 | 180 | validateToken('admin-ser'); |
176 | 181 | |
177 | 182 | // Make sure every entry is a proper integer. |
178 | - foreach ($_POST['remove'] as $index => $spider_id) |
|
179 | - $_POST['remove'][(int) $index] = (int) $spider_id; |
|
183 | + foreach ($_POST['remove'] as $index => $spider_id) { |
|
184 | + $_POST['remove'][(int) $index] = (int) $spider_id; |
|
185 | + } |
|
180 | 186 | |
181 | 187 | // Delete them all! |
182 | 188 | $smcFunc['db_query']('', ' |
@@ -215,8 +221,9 @@ discard block |
||
215 | 221 | ); |
216 | 222 | |
217 | 223 | $context['spider_last_seen'] = array(); |
218 | - while ($row = $smcFunc['db_fetch_assoc']($request)) |
|
219 | - $context['spider_last_seen'][$row['id_spider']] = $row['last_seen_time']; |
|
224 | + while ($row = $smcFunc['db_fetch_assoc']($request)) { |
|
225 | + $context['spider_last_seen'][$row['id_spider']] = $row['last_seen_time']; |
|
226 | + } |
|
220 | 227 | $smcFunc['db_free_result']($request); |
221 | 228 | |
222 | 229 | createToken('admin-ser'); |
@@ -346,8 +353,9 @@ discard block |
||
346 | 353 | ) |
347 | 354 | ); |
348 | 355 | $spiders = array(); |
349 | - while ($row = $smcFunc['db_fetch_assoc']($request)) |
|
350 | - $spiders[$row['id_spider']] = $row; |
|
356 | + while ($row = $smcFunc['db_fetch_assoc']($request)) { |
|
357 | + $spiders[$row['id_spider']] = $row; |
|
358 | + } |
|
351 | 359 | $smcFunc['db_free_result']($request); |
352 | 360 | |
353 | 361 | return $spiders; |
@@ -397,14 +405,15 @@ discard block |
||
397 | 405 | foreach ($ip_sets as $set) |
398 | 406 | { |
399 | 407 | $test = ip2range(trim($set)); |
400 | - if (!empty($test)) |
|
401 | - $ips[] = $set; |
|
408 | + if (!empty($test)) { |
|
409 | + $ips[] = $set; |
|
410 | + } |
|
402 | 411 | } |
403 | 412 | $ips = implode(',', $ips); |
404 | 413 | |
405 | 414 | // Goes in as it is... |
406 | - if ($context['id_spider']) |
|
407 | - $smcFunc['db_query']('', ' |
|
415 | + if ($context['id_spider']) { |
|
416 | + $smcFunc['db_query']('', ' |
|
408 | 417 | UPDATE {db_prefix}spiders |
409 | 418 | SET spider_name = {string:spider_name}, user_agent = {string:spider_agent}, |
410 | 419 | ip_info = {string:ip_info} |
@@ -416,8 +425,8 @@ discard block |
||
416 | 425 | 'ip_info' => $ips, |
417 | 426 | ) |
418 | 427 | ); |
419 | - else |
|
420 | - $smcFunc['db_insert']('insert', |
|
428 | + } else { |
|
429 | + $smcFunc['db_insert']('insert', |
|
421 | 430 | '{db_prefix}spiders', |
422 | 431 | array( |
423 | 432 | 'spider_name' => 'string', 'user_agent' => 'string', 'ip_info' => 'string', |
@@ -427,6 +436,7 @@ discard block |
||
427 | 436 | ), |
428 | 437 | array('id_spider') |
429 | 438 | ); |
439 | + } |
|
430 | 440 | |
431 | 441 | |
432 | 442 | cache_put_data('spider_search', null); |
@@ -454,13 +464,14 @@ discard block |
||
454 | 464 | 'current_spider' => $context['id_spider'], |
455 | 465 | ) |
456 | 466 | ); |
457 | - if ($row = $smcFunc['db_fetch_assoc']($request)) |
|
458 | - $context['spider'] = array( |
|
467 | + if ($row = $smcFunc['db_fetch_assoc']($request)) { |
|
468 | + $context['spider'] = array( |
|
459 | 469 | 'id' => $row['id_spider'], |
460 | 470 | 'name' => $row['spider_name'], |
461 | 471 | 'agent' => $row['user_agent'], |
462 | 472 | 'ip_info' => $row['ip_info'], |
463 | 473 | ); |
474 | + } |
|
464 | 475 | $smcFunc['db_free_result']($request); |
465 | 476 | } |
466 | 477 | |
@@ -477,8 +488,9 @@ discard block |
||
477 | 488 | { |
478 | 489 | global $modSettings, $smcFunc; |
479 | 490 | |
480 | - if (isset($_SESSION['id_robot'])) |
|
481 | - unset($_SESSION['id_robot']); |
|
491 | + if (isset($_SESSION['id_robot'])) { |
|
492 | + unset($_SESSION['id_robot']); |
|
493 | + } |
|
482 | 494 | $_SESSION['robot_check'] = time(); |
483 | 495 | |
484 | 496 | // We cache the spider data for ten minutes if we can. |
@@ -492,15 +504,17 @@ discard block |
||
492 | 504 | ) |
493 | 505 | ); |
494 | 506 | $spider_data = array(); |
495 | - while ($row = $smcFunc['db_fetch_assoc']($request)) |
|
496 | - $spider_data[] = $row; |
|
507 | + while ($row = $smcFunc['db_fetch_assoc']($request)) { |
|
508 | + $spider_data[] = $row; |
|
509 | + } |
|
497 | 510 | $smcFunc['db_free_result']($request); |
498 | 511 | |
499 | 512 | cache_put_data('spider_search', $spider_data, 600); |
500 | 513 | } |
501 | 514 | |
502 | - if (empty($spider_data)) |
|
503 | - return false; |
|
515 | + if (empty($spider_data)) { |
|
516 | + return false; |
|
517 | + } |
|
504 | 518 | |
505 | 519 | // Only do these bits once. |
506 | 520 | $ci_user_agent = strtolower($_SERVER['HTTP_USER_AGENT']); |
@@ -508,33 +522,38 @@ discard block |
||
508 | 522 | foreach ($spider_data as $spider) |
509 | 523 | { |
510 | 524 | // User agent is easy. |
511 | - if (!empty($spider['user_agent']) && strpos($ci_user_agent, strtolower($spider['user_agent'])) !== false) |
|
512 | - $_SESSION['id_robot'] = $spider['id_spider']; |
|
525 | + if (!empty($spider['user_agent']) && strpos($ci_user_agent, strtolower($spider['user_agent'])) !== false) { |
|
526 | + $_SESSION['id_robot'] = $spider['id_spider']; |
|
527 | + } |
|
513 | 528 | // IP stuff is harder. |
514 | 529 | elseif ($_SERVER['REMOTE_ADDR']) |
515 | 530 | { |
516 | 531 | $ips = explode(',', $spider['ip_info']); |
517 | 532 | foreach ($ips as $ip) |
518 | 533 | { |
519 | - if ($ip === '') |
|
520 | - continue; |
|
534 | + if ($ip === '') { |
|
535 | + continue; |
|
536 | + } |
|
521 | 537 | |
522 | 538 | $ip = ip2range($ip); |
523 | 539 | if (!empty($ip)) |
524 | 540 | { |
525 | - if (inet_ptod($ip['low']) <= inet_ptod($_SERVER['REMOTE_ADDR']) && inet_ptod($ip['high']) >= inet_ptod($_SERVER['REMOTE_ADDR'])) |
|
526 | - $_SESSION['id_robot'] = $spider['id_spider']; |
|
541 | + if (inet_ptod($ip['low']) <= inet_ptod($_SERVER['REMOTE_ADDR']) && inet_ptod($ip['high']) >= inet_ptod($_SERVER['REMOTE_ADDR'])) { |
|
542 | + $_SESSION['id_robot'] = $spider['id_spider']; |
|
543 | + } |
|
527 | 544 | } |
528 | 545 | } |
529 | 546 | } |
530 | 547 | |
531 | - if (isset($_SESSION['id_robot'])) |
|
532 | - break; |
|
548 | + if (isset($_SESSION['id_robot'])) { |
|
549 | + break; |
|
550 | + } |
|
533 | 551 | } |
534 | 552 | |
535 | 553 | // If this is low server tracking then log the spider here as opposed to the main logging function. |
536 | - if (!empty($modSettings['spider_mode']) && $modSettings['spider_mode'] == 1 && !empty($_SESSION['id_robot'])) |
|
537 | - logSpider(); |
|
554 | + if (!empty($modSettings['spider_mode']) && $modSettings['spider_mode'] == 1 && !empty($_SESSION['id_robot'])) { |
|
555 | + logSpider(); |
|
556 | + } |
|
538 | 557 | |
539 | 558 | return !empty($_SESSION['id_robot']) ? $_SESSION['id_robot'] : 0; |
540 | 559 | } |
@@ -548,8 +567,9 @@ discard block |
||
548 | 567 | { |
549 | 568 | global $smcFunc, $modSettings, $context; |
550 | 569 | |
551 | - if (empty($modSettings['spider_mode']) || empty($_SESSION['id_robot'])) |
|
552 | - return; |
|
570 | + if (empty($modSettings['spider_mode']) || empty($_SESSION['id_robot'])) { |
|
571 | + return; |
|
572 | + } |
|
553 | 573 | |
554 | 574 | // Attempt to update today's entry. |
555 | 575 | if ($modSettings['spider_mode'] == 1) |
@@ -590,9 +610,9 @@ discard block |
||
590 | 610 | $url = $_GET + array('USER_AGENT' => $_SERVER['HTTP_USER_AGENT']); |
591 | 611 | unset($url['sesc'], $url[$context['session_var']]); |
592 | 612 | $url = json_encode($url); |
613 | + } else { |
|
614 | + $url = ''; |
|
593 | 615 | } |
594 | - else |
|
595 | - $url = ''; |
|
596 | 616 | |
597 | 617 | $smcFunc['db_insert']('insert', |
598 | 618 | '{db_prefix}log_spider_hits', |
@@ -620,12 +640,14 @@ discard block |
||
620 | 640 | ) |
621 | 641 | ); |
622 | 642 | $spider_hits = array(); |
623 | - while ($row = $smcFunc['db_fetch_assoc']($request)) |
|
624 | - $spider_hits[] = $row; |
|
643 | + while ($row = $smcFunc['db_fetch_assoc']($request)) { |
|
644 | + $spider_hits[] = $row; |
|
645 | + } |
|
625 | 646 | $smcFunc['db_free_result']($request); |
626 | 647 | |
627 | - if (empty($spider_hits)) |
|
628 | - return; |
|
648 | + if (empty($spider_hits)) { |
|
649 | + return; |
|
650 | + } |
|
629 | 651 | |
630 | 652 | // Attempt to update the master data. |
631 | 653 | $stat_inserts = array(); |
@@ -646,18 +668,20 @@ discard block |
||
646 | 668 | 'hits' => $stat['num_hits'], |
647 | 669 | ) |
648 | 670 | ); |
649 | - if ($smcFunc['db_affected_rows']() == 0) |
|
650 | - $stat_inserts[] = array($date, $stat['id_spider'], $stat['num_hits'], $stat['last_seen']); |
|
671 | + if ($smcFunc['db_affected_rows']() == 0) { |
|
672 | + $stat_inserts[] = array($date, $stat['id_spider'], $stat['num_hits'], $stat['last_seen']); |
|
673 | + } |
|
651 | 674 | } |
652 | 675 | |
653 | 676 | // New stats? |
654 | - if (!empty($stat_inserts)) |
|
655 | - $smcFunc['db_insert']('ignore', |
|
677 | + if (!empty($stat_inserts)) { |
|
678 | + $smcFunc['db_insert']('ignore', |
|
656 | 679 | '{db_prefix}log_spider_stats', |
657 | 680 | array('stat_date' => 'date', 'id_spider' => 'int', 'page_hits' => 'int', 'last_seen' => 'int'), |
658 | 681 | $stat_inserts, |
659 | 682 | array('stat_date', 'id_spider') |
660 | 683 | ); |
684 | + } |
|
661 | 685 | |
662 | 686 | // All processed. |
663 | 687 | $smcFunc['db_query']('', ' |
@@ -700,8 +724,7 @@ discard block |
||
700 | 724 | 'delete_period' => $deleteTime, |
701 | 725 | ) |
702 | 726 | ); |
703 | - } |
|
704 | - else |
|
727 | + } else |
|
705 | 728 | { |
706 | 729 | // Deleting all of them |
707 | 730 | $smcFunc['db_query']('', ' |
@@ -791,10 +814,11 @@ discard block |
||
791 | 814 | foreach ($context['spider_logs']['rows'] as $k => $row) |
792 | 815 | { |
793 | 816 | // Feature disabled? |
794 | - if (empty($row['data']['viewing']['value']) && isset($modSettings['spider_mode']) && $modSettings['spider_mode'] < 3) |
|
795 | - $context['spider_logs']['rows'][$k]['viewing']['value'] = '<em>' . $txt['spider_disabled'] . '</em>'; |
|
796 | - else |
|
797 | - $urls[$k] = array($row['data']['viewing']['value'], -1); |
|
817 | + if (empty($row['data']['viewing']['value']) && isset($modSettings['spider_mode']) && $modSettings['spider_mode'] < 3) { |
|
818 | + $context['spider_logs']['rows'][$k]['viewing']['value'] = '<em>' . $txt['spider_disabled'] . '</em>'; |
|
819 | + } else { |
|
820 | + $urls[$k] = array($row['data']['viewing']['value'], -1); |
|
821 | + } |
|
798 | 822 | } |
799 | 823 | |
800 | 824 | // Now stick in the new URLs. |
@@ -836,8 +860,9 @@ discard block |
||
836 | 860 | ) |
837 | 861 | ); |
838 | 862 | $spider_logs = array(); |
839 | - while ($row = $smcFunc['db_fetch_assoc']($request)) |
|
840 | - $spider_logs[] = $row; |
|
863 | + while ($row = $smcFunc['db_fetch_assoc']($request)) { |
|
864 | + $spider_logs[] = $row; |
|
865 | + } |
|
841 | 866 | $smcFunc['db_free_result']($request); |
842 | 867 | |
843 | 868 | return $spider_logs; |
@@ -913,14 +938,18 @@ discard block |
||
913 | 938 | |
914 | 939 | // Prepare the dates for the drop down. |
915 | 940 | $date_choices = array(); |
916 | - for ($y = $min_year; $y <= $max_year; $y++) |
|
917 | - for ($m = 1; $m <= 12; $m++) |
|
941 | + for ($y = $min_year; $y <= $max_year; $y++) { |
|
942 | + for ($m = 1; |
|
943 | + } |
|
944 | + $m <= 12; $m++) |
|
918 | 945 | { |
919 | 946 | // This doesn't count? |
920 | - if ($y == $min_year && $m < $min_month) |
|
921 | - continue; |
|
922 | - if ($y == $max_year && $m > $max_month) |
|
923 | - break; |
|
947 | + if ($y == $min_year && $m < $min_month) { |
|
948 | + continue; |
|
949 | + } |
|
950 | + if ($y == $max_year && $m > $max_month) { |
|
951 | + break; |
|
952 | + } |
|
924 | 953 | |
925 | 954 | $date_choices[$y . $m] = $txt['months_short'][$m] . ' ' . $y; |
926 | 955 | } |
@@ -933,13 +962,14 @@ discard block |
||
933 | 962 | ' . $txt['spider_stats_select_month'] . ': |
934 | 963 | <select name="new_date" onchange="document.spider_stat_list.submit();">'; |
935 | 964 | |
936 | - if (empty($date_choices)) |
|
937 | - $date_select .= ' |
|
965 | + if (empty($date_choices)) { |
|
966 | + $date_select .= ' |
|
938 | 967 | <option></option>'; |
939 | - else |
|
940 | - foreach ($date_choices as $id => $text) |
|
968 | + } else { |
|
969 | + foreach ($date_choices as $id => $text) |
|
941 | 970 | $date_select .= ' |
942 | 971 | <option value="' . $id . '"' . ($current_date == $id ? ' selected' : '') . '>' . $text . '</option>'; |
972 | + } |
|
943 | 973 | |
944 | 974 | $date_select .= ' |
945 | 975 | </select> |
@@ -1063,8 +1093,9 @@ discard block |
||
1063 | 1093 | ) |
1064 | 1094 | ); |
1065 | 1095 | $spider_stats = array(); |
1066 | - while ($row = $smcFunc['db_fetch_assoc']($request)) |
|
1067 | - $spider_stats[] = $row; |
|
1096 | + while ($row = $smcFunc['db_fetch_assoc']($request)) { |
|
1097 | + $spider_stats[] = $row; |
|
1098 | + } |
|
1068 | 1099 | $smcFunc['db_free_result']($request); |
1069 | 1100 | |
1070 | 1101 | return $spider_stats; |
@@ -1105,8 +1136,9 @@ discard block |
||
1105 | 1136 | array() |
1106 | 1137 | ); |
1107 | 1138 | $spiders = array(); |
1108 | - while ($row = $smcFunc['db_fetch_assoc']($request)) |
|
1109 | - $spiders[$row['id_spider']] = $row['spider_name']; |
|
1139 | + while ($row = $smcFunc['db_fetch_assoc']($request)) { |
|
1140 | + $spiders[$row['id_spider']] = $row['spider_name']; |
|
1141 | + } |
|
1110 | 1142 | $smcFunc['db_free_result']($request); |
1111 | 1143 | |
1112 | 1144 | updateSettings(array('spider_name_cache' => json_encode($spiders))); |
@@ -14,8 +14,9 @@ discard block |
||
14 | 14 | * @version 2.1 Beta 3 |
15 | 15 | */ |
16 | 16 | |
17 | -if (!defined('SMF')) |
|
17 | +if (!defined('SMF')) { |
|
18 | 18 | die('No direct access...'); |
19 | +} |
|
19 | 20 | |
20 | 21 | /** |
21 | 22 | * Shows a listing of registered members. |
@@ -110,8 +111,9 @@ discard block |
||
110 | 111 | |
111 | 112 | $context['custom_profile_fields'] = getCustFieldsMList(); |
112 | 113 | |
113 | - if (!empty($context['custom_profile_fields']['columns'])) |
|
114 | - $context['columns'] += $context['custom_profile_fields']['columns']; |
|
114 | + if (!empty($context['custom_profile_fields']['columns'])) { |
|
115 | + $context['columns'] += $context['custom_profile_fields']['columns']; |
|
116 | + } |
|
115 | 117 | |
116 | 118 | $context['colspan'] = 0; |
117 | 119 | $context['disabled_fields'] = isset($modSettings['disabled_profile_fields']) ? array_flip(explode(',', $modSettings['disabled_profile_fields'])) : array(); |
@@ -147,12 +149,12 @@ discard block |
||
147 | 149 | call_integration_hook('integrate_memberlist_buttons'); |
148 | 150 | |
149 | 151 | // Jump to the sub action. |
150 | - if (isset($subActions[$context['listing_by']])) |
|
151 | - call_helper($subActions[$context['listing_by']][1]); |
|
152 | - |
|
153 | - else |
|
154 | - call_helper($subActions['all'][1]); |
|
155 | -} |
|
152 | + if (isset($subActions[$context['listing_by']])) { |
|
153 | + call_helper($subActions[$context['listing_by']][1]); |
|
154 | + } else { |
|
155 | + call_helper($subActions['all'][1]); |
|
156 | + } |
|
157 | + } |
|
156 | 158 | |
157 | 159 | /** |
158 | 160 | * List all members, page by page, with sorting. |
@@ -177,8 +179,9 @@ discard block |
||
177 | 179 | if ($use_cache) |
178 | 180 | { |
179 | 181 | // Maybe there's something cached already. |
180 | - if (!empty($modSettings['memberlist_cache'])) |
|
181 | - $memberlist_cache = smf_json_decode($modSettings['memberlist_cache'], true); |
|
182 | + if (!empty($modSettings['memberlist_cache'])) { |
|
183 | + $memberlist_cache = smf_json_decode($modSettings['memberlist_cache'], true); |
|
184 | + } |
|
182 | 185 | |
183 | 186 | // The chunk size for the cached index. |
184 | 187 | $cache_step_size = 500; |
@@ -234,13 +237,15 @@ discard block |
||
234 | 237 | } |
235 | 238 | |
236 | 239 | // Set defaults for sort (real_name) and start. (0) |
237 | - if (!isset($_REQUEST['sort']) || !isset($context['columns'][$_REQUEST['sort']])) |
|
238 | - $_REQUEST['sort'] = 'real_name'; |
|
240 | + if (!isset($_REQUEST['sort']) || !isset($context['columns'][$_REQUEST['sort']])) { |
|
241 | + $_REQUEST['sort'] = 'real_name'; |
|
242 | + } |
|
239 | 243 | |
240 | 244 | if (!is_numeric($_REQUEST['start'])) |
241 | 245 | { |
242 | - if (preg_match('~^[^\'\\\\/]~' . ($context['utf8'] ? 'u' : ''), $smcFunc['strtolower']($_REQUEST['start']), $match) === 0) |
|
243 | - fatal_error('Hacker?', false); |
|
246 | + if (preg_match('~^[^\'\\\\/]~' . ($context['utf8'] ? 'u' : ''), $smcFunc['strtolower']($_REQUEST['start']), $match) === 0) { |
|
247 | + fatal_error('Hacker?', false); |
|
248 | + } |
|
244 | 249 | |
245 | 250 | $_REQUEST['start'] = $match[0]; |
246 | 251 | |
@@ -259,16 +264,18 @@ discard block |
||
259 | 264 | } |
260 | 265 | |
261 | 266 | $context['letter_links'] = ''; |
262 | - for ($i = 97; $i < 123; $i++) |
|
263 | - $context['letter_links'] .= '<a href="' . $scripturl . '?action=mlist;sa=all;start=' . chr($i) . '#letter' . chr($i) . '">' . strtoupper(chr($i)) . '</a> '; |
|
267 | + for ($i = 97; $i < 123; $i++) { |
|
268 | + $context['letter_links'] .= '<a href="' . $scripturl . '?action=mlist;sa=all;start=' . chr($i) . '#letter' . chr($i) . '">' . strtoupper(chr($i)) . '</a> '; |
|
269 | + } |
|
264 | 270 | |
265 | 271 | // Sort out the column information. |
266 | 272 | foreach ($context['columns'] as $col => $column_details) |
267 | 273 | { |
268 | 274 | $context['columns'][$col]['href'] = $scripturl . '?action=mlist;sort=' . $col . ';start=0'; |
269 | 275 | |
270 | - if ((!isset($_REQUEST['desc']) && $col == $_REQUEST['sort']) || ($col != $_REQUEST['sort'] && !empty($column_details['default_sort_rev']))) |
|
271 | - $context['columns'][$col]['href'] .= ';desc'; |
|
276 | + if ((!isset($_REQUEST['desc']) && $col == $_REQUEST['sort']) || ($col != $_REQUEST['sort'] && !empty($column_details['default_sort_rev']))) { |
|
277 | + $context['columns'][$col]['href'] .= ';desc'; |
|
278 | + } |
|
272 | 279 | |
273 | 280 | $context['columns'][$col]['link'] = '<a href="' . $context['columns'][$col]['href'] . '" rel="nofollow">' . $context['columns'][$col]['label'] . '</a>'; |
274 | 281 | $context['columns'][$col]['selected'] = $_REQUEST['sort'] == $col; |
@@ -317,8 +324,9 @@ discard block |
||
317 | 324 | elseif ($use_cache && $_REQUEST['sort'] === 'real_name') |
318 | 325 | { |
319 | 326 | $first_offset = floor(($memberlist_cache['num_members'] - $modSettings['defaultMaxMembers'] - $_REQUEST['start']) / $cache_step_size) * $cache_step_size; |
320 | - if ($first_offset < 0) |
|
321 | - $first_offset = 0; |
|
327 | + if ($first_offset < 0) { |
|
328 | + $first_offset = 0; |
|
329 | + } |
|
322 | 330 | $second_offset = ceil(($memberlist_cache['num_members'] - $_REQUEST['start']) / $cache_step_size) * $cache_step_size; |
323 | 331 | |
324 | 332 | $where = 'mem.real_name BETWEEN {string:real_name_low} AND {string:real_name_high}'; |
@@ -395,12 +403,13 @@ discard block |
||
395 | 403 | ) |
396 | 404 | ); |
397 | 405 | $context['custom_search_fields'] = array(); |
398 | - while ($row = $smcFunc['db_fetch_assoc']($request)) |
|
399 | - $context['custom_search_fields'][$row['col_name']] = array( |
|
406 | + while ($row = $smcFunc['db_fetch_assoc']($request)) { |
|
407 | + $context['custom_search_fields'][$row['col_name']] = array( |
|
400 | 408 | 'colname' => $row['col_name'], |
401 | 409 | 'name' => $row['field_name'], |
402 | 410 | 'desc' => $row['field_desc'], |
403 | 411 | ); |
412 | + } |
|
404 | 413 | $smcFunc['db_free_result']($request); |
405 | 414 | |
406 | 415 | // They're searching.. |
@@ -413,23 +422,27 @@ discard block |
||
413 | 422 | $context['old_search_value'] = urlencode($_REQUEST['search']); |
414 | 423 | |
415 | 424 | // No fields? Use default... |
416 | - if (empty($_POST['fields'])) |
|
417 | - $_POST['fields'] = array('name'); |
|
425 | + if (empty($_POST['fields'])) { |
|
426 | + $_POST['fields'] = array('name'); |
|
427 | + } |
|
418 | 428 | |
419 | 429 | // Set defaults for how the results are sorted |
420 | - if (!isset($_REQUEST['sort']) || !isset($context['columns'][$_REQUEST['sort']])) |
|
421 | - $_REQUEST['sort'] = 'real_name'; |
|
430 | + if (!isset($_REQUEST['sort']) || !isset($context['columns'][$_REQUEST['sort']])) { |
|
431 | + $_REQUEST['sort'] = 'real_name'; |
|
432 | + } |
|
422 | 433 | |
423 | 434 | // Build the column link / sort information. |
424 | 435 | foreach ($context['columns'] as $col => $column_details) |
425 | 436 | { |
426 | 437 | $context['columns'][$col]['href'] = $scripturl . '?action=mlist;sa=search;start=0;sort=' . $col; |
427 | 438 | |
428 | - if ((!isset($_REQUEST['desc']) && $col == $_REQUEST['sort']) || ($col != $_REQUEST['sort'] && !empty($column_details['default_sort_rev']))) |
|
429 | - $context['columns'][$col]['href'] .= ';desc'; |
|
439 | + if ((!isset($_REQUEST['desc']) && $col == $_REQUEST['sort']) || ($col != $_REQUEST['sort'] && !empty($column_details['default_sort_rev']))) { |
|
440 | + $context['columns'][$col]['href'] .= ';desc'; |
|
441 | + } |
|
430 | 442 | |
431 | - if (isset($_POST['search']) && isset($_POST['fields'])) |
|
432 | - $context['columns'][$col]['href'] .= ';search=' . $_POST['search'] . ';fields=' . implode(',', $_POST['fields']); |
|
443 | + if (isset($_POST['search']) && isset($_POST['fields'])) { |
|
444 | + $context['columns'][$col]['href'] .= ';search=' . $_POST['search'] . ';fields=' . implode(',', $_POST['fields']); |
|
445 | + } |
|
433 | 446 | |
434 | 447 | $context['columns'][$col]['link'] = '<a href="' . $context['columns'][$col]['href'] . '" rel="nofollow">' . $context['columns'][$col]['label'] . '</a>'; |
435 | 448 | $context['columns'][$col]['selected'] = $_REQUEST['sort'] == $col; |
@@ -452,8 +465,7 @@ discard block |
||
452 | 465 | { |
453 | 466 | $fields = allowedTo('moderate_forum') ? array('member_name', 'real_name') : array('real_name'); |
454 | 467 | $search_fields[] = 'name'; |
455 | - } |
|
456 | - else |
|
468 | + } else |
|
457 | 469 | { |
458 | 470 | $fields = array(); |
459 | 471 | $search_fields = array(); |
@@ -478,9 +490,10 @@ discard block |
||
478 | 490 | $search_fields[] = 'email'; |
479 | 491 | } |
480 | 492 | |
481 | - if ($smcFunc['db_case_sensitive']) |
|
482 | - foreach ($fields as $key => $field) |
|
493 | + if ($smcFunc['db_case_sensitive']) { |
|
494 | + foreach ($fields as $key => $field) |
|
483 | 495 | $fields[$key] = 'LOWER(' . $field . ')'; |
496 | + } |
|
484 | 497 | |
485 | 498 | $customJoin = array(); |
486 | 499 | $customCount = 10; |
@@ -499,8 +512,9 @@ discard block |
||
499 | 512 | } |
500 | 513 | |
501 | 514 | // No search fields? That means you're trying to hack things |
502 | - if (empty($search_fields)) |
|
503 | - fatal_lang_error('invalid_search_string', false); |
|
515 | + if (empty($search_fields)) { |
|
516 | + fatal_lang_error('invalid_search_string', false); |
|
517 | + } |
|
504 | 518 | |
505 | 519 | $query = $_POST['search'] == '' ? '= {string:blank_string}' : ($smcFunc['db_case_sensitive'] ? 'LIKE LOWER({string:search})' : 'LIKE {string:search}'); |
506 | 520 | |
@@ -538,8 +552,7 @@ discard block |
||
538 | 552 | ); |
539 | 553 | printMemberListRows($request); |
540 | 554 | $smcFunc['db_free_result']($request); |
541 | - } |
|
542 | - else |
|
555 | + } else |
|
543 | 556 | { |
544 | 557 | // These are all the possible fields. |
545 | 558 | $context['search_fields'] = array( |
@@ -554,14 +567,14 @@ discard block |
||
554 | 567 | { |
555 | 568 | unset($context['search_fields']['email']); |
556 | 569 | $context['search_defaults'] = array('name'); |
557 | - } |
|
558 | - else |
|
570 | + } else |
|
559 | 571 | { |
560 | 572 | $context['search_defaults'] = array('name', 'email'); |
561 | 573 | } |
562 | 574 | |
563 | - foreach ($context['custom_search_fields'] as $field) |
|
564 | - $context['search_fields']['cust_' . $field['colname']] = sprintf($txt['mlist_search_by'], $field['name']); |
|
575 | + foreach ($context['custom_search_fields'] as $field) { |
|
576 | + $context['search_fields']['cust_' . $field['colname']] = sprintf($txt['mlist_search_by'], $field['name']); |
|
577 | + } |
|
565 | 578 | |
566 | 579 | $context['sub_template'] = 'search'; |
567 | 580 | $context['old_search'] = isset($_GET['search']) ? $_GET['search'] : (isset($_POST['search']) ? $smcFunc['htmlspecialchars']($_POST['search']) : ''); |
@@ -603,12 +616,14 @@ discard block |
||
603 | 616 | $smcFunc['db_free_result']($result); |
604 | 617 | |
605 | 618 | // Avoid division by zero... |
606 | - if ($most_posts == 0) |
|
607 | - $most_posts = 1; |
|
619 | + if ($most_posts == 0) { |
|
620 | + $most_posts = 1; |
|
621 | + } |
|
608 | 622 | |
609 | 623 | $members = array(); |
610 | - while ($row = $smcFunc['db_fetch_assoc']($request)) |
|
611 | - $members[] = $row['id_member']; |
|
624 | + while ($row = $smcFunc['db_fetch_assoc']($request)) { |
|
625 | + $members[] = $row['id_member']; |
|
626 | + } |
|
612 | 627 | |
613 | 628 | // Load all the members for display. |
614 | 629 | loadMemberData($members); |
@@ -616,8 +631,9 @@ discard block |
||
616 | 631 | $context['members'] = array(); |
617 | 632 | foreach ($members as $member) |
618 | 633 | { |
619 | - if (!loadMemberContext($member)) |
|
620 | - continue; |
|
634 | + if (!loadMemberContext($member)) { |
|
635 | + continue; |
|
636 | + } |
|
621 | 637 | |
622 | 638 | $context['members'][$member] = $memberContext[$member]; |
623 | 639 | $context['members'][$member]['post_percent'] = round(($context['members'][$member]['real_posts'] * 100) / $most_posts); |
@@ -634,20 +650,21 @@ discard block |
||
634 | 650 | continue; |
635 | 651 | } |
636 | 652 | |
637 | - if ($column['bbc'] && !empty($context['members'][$member]['options'][$key])) |
|
638 | - $context['members'][$member]['options'][$key] = strip_tags(parse_bbc($context['members'][$member]['options'][$key])); |
|
639 | - |
|
640 | - elseif ($column['type'] == 'check') |
|
641 | - $context['members'][$member]['options'][$key] = $context['members'][$member]['options'][$key] == 0 ? $txt['no'] : $txt['yes']; |
|
653 | + if ($column['bbc'] && !empty($context['members'][$member]['options'][$key])) { |
|
654 | + $context['members'][$member]['options'][$key] = strip_tags(parse_bbc($context['members'][$member]['options'][$key])); |
|
655 | + } elseif ($column['type'] == 'check') { |
|
656 | + $context['members'][$member]['options'][$key] = $context['members'][$member]['options'][$key] == 0 ? $txt['no'] : $txt['yes']; |
|
657 | + } |
|
642 | 658 | |
643 | 659 | // Enclosing the user input within some other text? |
644 | - if (!empty($column['enclose'])) |
|
645 | - $context['members'][$member]['options'][$key] = strtr($column['enclose'], array( |
|
660 | + if (!empty($column['enclose'])) { |
|
661 | + $context['members'][$member]['options'][$key] = strtr($column['enclose'], array( |
|
646 | 662 | '{SCRIPTURL}' => $scripturl, |
647 | 663 | '{IMAGES_URL}' => $settings['images_url'], |
648 | 664 | '{DEFAULT_IMAGES_URL}' => $settings['default_images_url'], |
649 | 665 | '{INPUT}' => $context['members'][$member]['options'][$key], |
650 | 666 | )); |
667 | + } |
|
651 | 668 | } |
652 | 669 | } |
653 | 670 | } |
@@ -688,17 +705,17 @@ discard block |
||
688 | 705 | ); |
689 | 706 | |
690 | 707 | // Get the right sort method depending on the cust field type. |
691 | - if ($row['field_type'] != 'check') |
|
692 | - $cpf['columns'][$row['col_name']]['sort'] = array( |
|
708 | + if ($row['field_type'] != 'check') { |
|
709 | + $cpf['columns'][$row['col_name']]['sort'] = array( |
|
693 | 710 | 'down' => 'LENGTH(t' . $row['col_name'] . '.value) > 0 ASC, COALESCE(t' . $row['col_name'] . '.value, "") DESC', |
694 | 711 | 'up' => 'LENGTH(t' . $row['col_name'] . '.value) > 0 DESC, COALESCE(t' . $row['col_name'] . '.value, "") ASC' |
695 | 712 | ); |
696 | - |
|
697 | - else |
|
698 | - $cpf['columns'][$row['col_name']]['sort'] = array( |
|
713 | + } else { |
|
714 | + $cpf['columns'][$row['col_name']]['sort'] = array( |
|
699 | 715 | 'down' => 't' . $row['col_name'] . '.value DESC', |
700 | 716 | 'up' => 't' . $row['col_name'] . '.value ASC' |
701 | 717 | ); |
718 | + } |
|
702 | 719 | |
703 | 720 | $cpf['join'][$row['col_name']] = 'LEFT JOIN {db_prefix}themes AS t' . $row['col_name'] . ' ON (t' . $row['col_name'] . '.variable = {literal:' . $row['col_name'] . '} AND t' . $row['col_name'] . '.id_theme = 1 AND t' . $row['col_name'] . '.id_member = mem.id_member)'; |
704 | 721 | } |
@@ -13,8 +13,9 @@ discard block |
||
13 | 13 | * @version 2.1 Beta 3 |
14 | 14 | */ |
15 | 15 | |
16 | -if (!defined('SMF')) |
|
16 | +if (!defined('SMF')) { |
|
17 | 17 | die('No direct access...'); |
18 | +} |
|
18 | 19 | |
19 | 20 | /** |
20 | 21 | * Add the functions implemented in this file to the $smcFunc array. |
@@ -23,8 +24,8 @@ discard block |
||
23 | 24 | { |
24 | 25 | global $smcFunc; |
25 | 26 | |
26 | - if (!isset($smcFunc['db_backup_table']) || $smcFunc['db_backup_table'] != 'smf_db_backup_table') |
|
27 | - $smcFunc += array( |
|
27 | + if (!isset($smcFunc['db_backup_table']) || $smcFunc['db_backup_table'] != 'smf_db_backup_table') { |
|
28 | + $smcFunc += array( |
|
28 | 29 | 'db_backup_table' => 'smf_db_backup_table', |
29 | 30 | 'db_optimize_table' => 'smf_db_optimize_table', |
30 | 31 | 'db_table_sql' => 'smf_db_table_sql', |
@@ -32,7 +33,8 @@ discard block |
||
32 | 33 | 'db_get_version' => 'smf_db_get_version', |
33 | 34 | 'db_get_engine' => 'smf_db_get_engine', |
34 | 35 | ); |
35 | -} |
|
36 | + } |
|
37 | + } |
|
36 | 38 | |
37 | 39 | /** |
38 | 40 | * Backup $table to $backup_table. |
@@ -48,13 +50,14 @@ discard block |
||
48 | 50 | |
49 | 51 | // Do we need to drop it first? |
50 | 52 | $tables = smf_db_list_tables(false, $backup_table); |
51 | - if (!empty($tables)) |
|
52 | - $smcFunc['db_query']('', ' |
|
53 | + if (!empty($tables)) { |
|
54 | + $smcFunc['db_query']('', ' |
|
53 | 55 | DROP TABLE {raw:backup_table}', |
54 | 56 | array( |
55 | 57 | 'backup_table' => $backup_table, |
56 | 58 | ) |
57 | 59 | ); |
60 | + } |
|
58 | 61 | |
59 | 62 | /** |
60 | 63 | * @todo Should we create backups of sequences as well? |
@@ -117,8 +120,9 @@ discard block |
||
117 | 120 | ) |
118 | 121 | ); |
119 | 122 | |
120 | - if (!$request) |
|
121 | - return -1; |
|
123 | + if (!$request) { |
|
124 | + return -1; |
|
125 | + } |
|
122 | 126 | |
123 | 127 | $request = $smcFunc['db_query']('', ' |
124 | 128 | SELECT pg_relation_size(C.oid) AS "size" |
@@ -136,11 +140,12 @@ discard block |
||
136 | 140 | $row = $smcFunc['db_fetch_assoc']($request); |
137 | 141 | $smcFunc['db_free_result']($request); |
138 | 142 | |
139 | - if (isset($row['size'])) |
|
140 | - return ($old_size - $row['size']) / 1024; |
|
141 | - else |
|
142 | - return 0; |
|
143 | -} |
|
143 | + if (isset($row['size'])) { |
|
144 | + return ($old_size - $row['size']) / 1024; |
|
145 | + } else { |
|
146 | + return 0; |
|
147 | + } |
|
148 | + } |
|
144 | 149 | |
145 | 150 | /** |
146 | 151 | * This function lists all tables in the database. |
@@ -167,8 +172,9 @@ discard block |
||
167 | 172 | ); |
168 | 173 | |
169 | 174 | $tables = array(); |
170 | - while ($row = $smcFunc['db_fetch_row']($request)) |
|
171 | - $tables[] = $row[0]; |
|
175 | + while ($row = $smcFunc['db_fetch_row']($request)) { |
|
176 | + $tables[] = $row[0]; |
|
177 | + } |
|
172 | 178 | $smcFunc['db_free_result']($request); |
173 | 179 | |
174 | 180 | return $tables; |
@@ -209,12 +215,14 @@ discard block |
||
209 | 215 | ); |
210 | 216 | while ($row = $smcFunc['db_fetch_assoc']($result)) |
211 | 217 | { |
212 | - if ($row['data_type'] == 'character varying') |
|
213 | - $row['data_type'] = 'varchar'; |
|
214 | - elseif ($row['data_type'] == 'character') |
|
215 | - $row['data_type'] = 'char'; |
|
216 | - if ($row['character_maximum_length']) |
|
217 | - $row['data_type'] .= '(' . $row['character_maximum_length'] . ')'; |
|
218 | + if ($row['data_type'] == 'character varying') { |
|
219 | + $row['data_type'] = 'varchar'; |
|
220 | + } elseif ($row['data_type'] == 'character') { |
|
221 | + $row['data_type'] = 'char'; |
|
222 | + } |
|
223 | + if ($row['character_maximum_length']) { |
|
224 | + $row['data_type'] .= '(' . $row['character_maximum_length'] . ')'; |
|
225 | + } |
|
218 | 226 | |
219 | 227 | // Make the CREATE for this column. |
220 | 228 | $schema_create .= ' "' . $row['column_name'] . '" ' . $row['data_type'] . ($row['is_nullable'] != 'YES' ? ' NOT NULL' : ''); |
@@ -265,13 +273,14 @@ discard block |
||
265 | 273 | { |
266 | 274 | if ($row['is_primary']) |
267 | 275 | { |
268 | - if (preg_match('~\(([^\)]+?)\)~i', $row['inddef'], $matches) == 0) |
|
269 | - continue; |
|
276 | + if (preg_match('~\(([^\)]+?)\)~i', $row['inddef'], $matches) == 0) { |
|
277 | + continue; |
|
278 | + } |
|
270 | 279 | |
271 | 280 | $index_create .= $crlf . 'ALTER TABLE ' . $tableName . ' ADD PRIMARY KEY ("' . $matches[1] . '");'; |
281 | + } else { |
|
282 | + $index_create .= $crlf . $row['inddef'] . ';'; |
|
272 | 283 | } |
273 | - else |
|
274 | - $index_create .= $crlf . $row['inddef'] . ';'; |
|
275 | 284 | } |
276 | 285 | $smcFunc['db_free_result']($result); |
277 | 286 | |
@@ -289,8 +298,9 @@ discard block |
||
289 | 298 | { |
290 | 299 | static $ver; |
291 | 300 | |
292 | - if(!empty($ver)) |
|
293 | - return $ver; |
|
301 | + if(!empty($ver)) { |
|
302 | + return $ver; |
|
303 | + } |
|
294 | 304 | |
295 | 305 | global $smcFunc; |
296 | 306 |
@@ -13,8 +13,9 @@ discard block |
||
13 | 13 | * @version 2.1 Beta 3 |
14 | 14 | */ |
15 | 15 | |
16 | -if (!defined('SMF')) |
|
16 | +if (!defined('SMF')) { |
|
17 | 17 | die('No direct access...'); |
18 | +} |
|
18 | 19 | |
19 | 20 | /** |
20 | 21 | * Scheduled tasks management dispatcher. This function checks permissions and delegates |
@@ -40,10 +41,11 @@ discard block |
||
40 | 41 | ); |
41 | 42 | |
42 | 43 | // We need to find what's the action. |
43 | - if (isset($_REQUEST['sa']) && isset($subActions[$_REQUEST['sa']])) |
|
44 | - $context['sub_action'] = $_REQUEST['sa']; |
|
45 | - else |
|
46 | - $context['sub_action'] = 'tasks'; |
|
44 | + if (isset($_REQUEST['sa']) && isset($subActions[$_REQUEST['sa']])) { |
|
45 | + $context['sub_action'] = $_REQUEST['sa']; |
|
46 | + } else { |
|
47 | + $context['sub_action'] = 'tasks'; |
|
48 | + } |
|
47 | 49 | |
48 | 50 | // Now for the lovely tabs. That we all love. |
49 | 51 | $context[$context['admin_menu_name']]['tab_data'] = array( |
@@ -90,9 +92,10 @@ discard block |
||
90 | 92 | |
91 | 93 | // Enable and disable as required. |
92 | 94 | $enablers = array(0); |
93 | - foreach ($_POST['enable_task'] as $id => $enabled) |
|
94 | - if ($enabled) |
|
95 | + foreach ($_POST['enable_task'] as $id => $enabled) { |
|
96 | + if ($enabled) |
|
95 | 97 | $enablers[] = (int) $id; |
98 | + } |
|
96 | 99 | |
97 | 100 | // Do the update! |
98 | 101 | $smcFunc['db_query']('', ' |
@@ -130,8 +133,9 @@ discard block |
||
130 | 133 | |
131 | 134 | // Lets figure out which ones they want to run. |
132 | 135 | $tasks = array(); |
133 | - foreach ($_POST['run_task'] as $task => $dummy) |
|
134 | - $tasks[] = (int) $task; |
|
136 | + foreach ($_POST['run_task'] as $task => $dummy) { |
|
137 | + $tasks[] = (int) $task; |
|
138 | + } |
|
135 | 139 | |
136 | 140 | // Load up the tasks. |
137 | 141 | $request = $smcFunc['db_query']('', ' |
@@ -151,36 +155,41 @@ discard block |
||
151 | 155 | while ($row = $smcFunc['db_fetch_assoc']($request)) |
152 | 156 | { |
153 | 157 | // What kind of task are we handling? |
154 | - if (!empty($row['callable'])) |
|
155 | - $task_string = $row['callable']; |
|
158 | + if (!empty($row['callable'])) { |
|
159 | + $task_string = $row['callable']; |
|
160 | + } |
|
156 | 161 | |
157 | 162 | // Default SMF task or old mods? |
158 | - elseif (function_exists('scheduled_' . $row['task'])) |
|
159 | - $task_string = 'scheduled_' . $row['task']; |
|
163 | + elseif (function_exists('scheduled_' . $row['task'])) { |
|
164 | + $task_string = 'scheduled_' . $row['task']; |
|
165 | + } |
|
160 | 166 | |
161 | 167 | // One last resource, the task name. |
162 | - elseif (!empty($row['task'])) |
|
163 | - $task_string = $row['task']; |
|
168 | + elseif (!empty($row['task'])) { |
|
169 | + $task_string = $row['task']; |
|
170 | + } |
|
164 | 171 | |
165 | 172 | $start_time = microtime(); |
166 | 173 | // The functions got to exist for us to use it. |
167 | - if (empty($task_string)) |
|
168 | - continue; |
|
174 | + if (empty($task_string)) { |
|
175 | + continue; |
|
176 | + } |
|
169 | 177 | |
170 | 178 | // Try to stop a timeout, this would be bad... |
171 | 179 | @set_time_limit(300); |
172 | - if (function_exists('apache_reset_timeout')) |
|
173 | - @apache_reset_timeout(); |
|
180 | + if (function_exists('apache_reset_timeout')) { |
|
181 | + @apache_reset_timeout(); |
|
182 | + } |
|
174 | 183 | |
175 | 184 | // Get the callable. |
176 | 185 | $callable_task = call_helper($task_string, true); |
177 | 186 | |
178 | 187 | // Perform the task. |
179 | - if (!empty($callable_task)) |
|
180 | - $completed = call_user_func($callable_task); |
|
181 | - |
|
182 | - else |
|
183 | - $completed = false; |
|
188 | + if (!empty($callable_task)) { |
|
189 | + $completed = call_user_func($callable_task); |
|
190 | + } else { |
|
191 | + $completed = false; |
|
192 | + } |
|
184 | 193 | |
185 | 194 | // Log that we did it ;) |
186 | 195 | if ($completed) |
@@ -197,8 +206,9 @@ discard block |
||
197 | 206 | $smcFunc['db_free_result']($request); |
198 | 207 | |
199 | 208 | // If we had any errors, push them to session so we can pick them up next time to tell the user. |
200 | - if (!empty($context['scheduled_errors'])) |
|
201 | - $_SESSION['st_error'] = $context['scheduled_errors']; |
|
209 | + if (!empty($context['scheduled_errors'])) { |
|
210 | + $_SESSION['st_error'] = $context['scheduled_errors']; |
|
211 | + } |
|
202 | 212 | |
203 | 213 | redirectexit('action=admin;area=scheduledtasks;done'); |
204 | 214 | } |
@@ -370,8 +380,9 @@ discard block |
||
370 | 380 | $context['server_time'] = timeformat(time(), false, 'server'); |
371 | 381 | |
372 | 382 | // Cleaning... |
373 | - if (!isset($_GET['tid'])) |
|
374 | - fatal_lang_error('no_access', false); |
|
383 | + if (!isset($_GET['tid'])) { |
|
384 | + fatal_lang_error('no_access', false); |
|
385 | + } |
|
375 | 386 | $_GET['tid'] = (int) $_GET['tid']; |
376 | 387 | |
377 | 388 | // Saving? |
@@ -387,10 +398,12 @@ discard block |
||
387 | 398 | preg_match('~(\d{1,2}):(\d{1,2})~', $_POST['offset'], $matches); |
388 | 399 | |
389 | 400 | // If a half is empty then assume zero offset! |
390 | - if (!isset($matches[2]) || $matches[2] > 59) |
|
391 | - $matches[2] = 0; |
|
392 | - if (!isset($matches[1]) || $matches[1] > 23) |
|
393 | - $matches[1] = 0; |
|
401 | + if (!isset($matches[2]) || $matches[2] > 59) { |
|
402 | + $matches[2] = 0; |
|
403 | + } |
|
404 | + if (!isset($matches[1]) || $matches[1] > 23) { |
|
405 | + $matches[1] = 0; |
|
406 | + } |
|
394 | 407 | |
395 | 408 | // Now the offset is easy; easy peasy - except we need to offset by a few hours... |
396 | 409 | $offset = $matches[1] * 3600 + $matches[2] * 60 - date('Z'); |
@@ -400,8 +413,9 @@ discard block |
||
400 | 413 | $unit = in_array(substr($_POST['unit'], 0, 1), array('m', 'h', 'd', 'w')) ? substr($_POST['unit'], 0, 1) : 'd'; |
401 | 414 | |
402 | 415 | // Don't allow one minute intervals. |
403 | - if ($interval == 1 && $unit == 'm') |
|
404 | - $interval = 2; |
|
416 | + if ($interval == 1 && $unit == 'm') { |
|
417 | + $interval = 2; |
|
418 | + } |
|
405 | 419 | |
406 | 420 | // Is it disabled? |
407 | 421 | $disabled = !isset($_POST['enabled']) ? 1 : 0; |
@@ -439,8 +453,9 @@ discard block |
||
439 | 453 | ); |
440 | 454 | |
441 | 455 | // Should never, ever, happen! |
442 | - if ($smcFunc['db_num_rows']($request) == 0) |
|
443 | - fatal_lang_error('no_access', false); |
|
456 | + if ($smcFunc['db_num_rows']($request) == 0) { |
|
457 | + fatal_lang_error('no_access', false); |
|
458 | + } |
|
444 | 459 | |
445 | 460 | while ($row = $smcFunc['db_fetch_assoc']($request)) |
446 | 461 | { |
@@ -598,13 +613,14 @@ discard block |
||
598 | 613 | ) |
599 | 614 | ); |
600 | 615 | $log_entries = array(); |
601 | - while ($row = $smcFunc['db_fetch_assoc']($request)) |
|
602 | - $log_entries[] = array( |
|
616 | + while ($row = $smcFunc['db_fetch_assoc']($request)) { |
|
617 | + $log_entries[] = array( |
|
603 | 618 | 'id' => $row['id_log'], |
604 | 619 | 'name' => isset($txt['scheduled_task_' . $row['task']]) ? $txt['scheduled_task_' . $row['task']] : $row['task'], |
605 | 620 | 'time_run' => $row['time_run'], |
606 | 621 | 'time_taken' => $row['time_taken'], |
607 | 622 | ); |
623 | + } |
|
608 | 624 | $smcFunc['db_free_result']($request); |
609 | 625 | |
610 | 626 | return $log_entries; |