Completed
Pull Request — release-2.1 (#4574)
by Matthew
07:51
created
Sources/ManageAttachments.php 1 patch
Braces   +429 added lines, -325 removed lines patch added patch discarded remove patch
@@ -14,8 +14,9 @@  discard block
 block discarded – undo
14 14
  * @version 2.1 Beta 4
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
  * The main 'Attachments and Avatars' management function.
@@ -63,10 +64,11 @@  discard block
 block discarded – undo
63 64
 	call_integration_hook('integrate_manage_attachments', array(&$subActions));
64 65
 
65 66
 	// Pick the correct sub-action.
66
-	if (isset($_REQUEST['sa']) && isset($subActions[$_REQUEST['sa']]))
67
-		$context['sub_action'] = $_REQUEST['sa'];
68
-	else
69
-		$context['sub_action'] = 'browse';
67
+	if (isset($_REQUEST['sa']) && isset($subActions[$_REQUEST['sa']])) {
68
+			$context['sub_action'] = $_REQUEST['sa'];
69
+	} else {
70
+			$context['sub_action'] = 'browse';
71
+	}
70 72
 
71 73
 	// Default page title is good.
72 74
 	$context['page_title'] = $txt['attachments_avatars'];
@@ -94,20 +96,20 @@  discard block
 block discarded – undo
94 96
 	$context['attachmentUploadDir'] = $modSettings['attachmentUploadDir'][$modSettings['currentAttachmentUploadDir']];
95 97
 
96 98
 	// If not set, show a default path for the base directory
97
-	if (!isset($_GET['save']) && empty($modSettings['basedirectory_for_attachments']))
98
-		if (is_dir($modSettings['attachmentUploadDir'][1]))
99
+	if (!isset($_GET['save']) && empty($modSettings['basedirectory_for_attachments'])) {
100
+			if (is_dir($modSettings['attachmentUploadDir'][1]))
99 101
 			$modSettings['basedirectory_for_attachments'] = $modSettings['attachmentUploadDir'][1];
100
-
101
-	else
102
-		$modSettings['basedirectory_for_attachments'] = $context['attachmentUploadDir'];
102
+	} else {
103
+			$modSettings['basedirectory_for_attachments'] = $context['attachmentUploadDir'];
104
+	}
103 105
 
104 106
 	$context['valid_upload_dir'] = is_dir($context['attachmentUploadDir']) && is_writable($context['attachmentUploadDir']);
105 107
 
106
-	if (!empty($modSettings['automanage_attachments']))
107
-		$context['valid_basedirectory'] = !empty($modSettings['basedirectory_for_attachments']) && is_writable($modSettings['basedirectory_for_attachments']);
108
-
109
-	else
110
-		$context['valid_basedirectory'] = true;
108
+	if (!empty($modSettings['automanage_attachments'])) {
109
+			$context['valid_basedirectory'] = !empty($modSettings['basedirectory_for_attachments']) && is_writable($modSettings['basedirectory_for_attachments']);
110
+	} else {
111
+			$context['valid_basedirectory'] = true;
112
+	}
111 113
 
112 114
 	// A bit of razzle dazzle with the $txt strings. :)
113 115
 	$txt['attachment_path'] = $context['attachmentUploadDir'];
@@ -185,8 +187,9 @@  discard block
 block discarded – undo
185 187
 
186 188
 	call_integration_hook('integrate_modify_attachment_settings', array(&$config_vars));
187 189
 
188
-	if ($return_config)
189
-		return $config_vars;
190
+	if ($return_config) {
191
+			return $config_vars;
192
+	}
190 193
 
191 194
 	// These are very likely to come in handy! (i.e. without them we're doomed!)
192 195
 	require_once($sourcedir . '/ManagePermissions.php');
@@ -197,21 +200,24 @@  discard block
 block discarded – undo
197 200
 	{
198 201
 		checkSession();
199 202
 
200
-		if (isset($_POST['attachmentUploadDir']))
201
-			unset($_POST['attachmentUploadDir']);
203
+		if (isset($_POST['attachmentUploadDir'])) {
204
+					unset($_POST['attachmentUploadDir']);
205
+		}
202 206
 
203 207
 		if (!empty($_POST['use_subdirectories_for_attachments']))
204 208
 		{
205
-			if (isset($_POST['use_subdirectories_for_attachments']) && empty($_POST['basedirectory_for_attachments']))
206
-				$_POST['basedirectory_for_attachments'] = (!empty($modSettings['basedirectory_for_attachments']) ? ($modSettings['basedirectory_for_attachments']) : $boarddir);
209
+			if (isset($_POST['use_subdirectories_for_attachments']) && empty($_POST['basedirectory_for_attachments'])) {
210
+							$_POST['basedirectory_for_attachments'] = (!empty($modSettings['basedirectory_for_attachments']) ? ($modSettings['basedirectory_for_attachments']) : $boarddir);
211
+			}
207 212
 
208 213
 			if (!empty($_POST['use_subdirectories_for_attachments']) && !empty($modSettings['attachment_basedirectories']))
209 214
 			{
210
-				if (!is_array($modSettings['attachment_basedirectories']))
211
-					$modSettings['attachment_basedirectories'] = $smcFunc['json_decode']($modSettings['attachment_basedirectories'], true);
215
+				if (!is_array($modSettings['attachment_basedirectories'])) {
216
+									$modSettings['attachment_basedirectories'] = $smcFunc['json_decode']($modSettings['attachment_basedirectories'], true);
217
+				}
218
+			} else {
219
+							$modSettings['attachment_basedirectories'] = array();
212 220
 			}
213
-			else
214
-				$modSettings['attachment_basedirectories'] = array();
215 221
 
216 222
 			if (!empty($_POST['use_subdirectories_for_attachments']) && !empty($_POST['basedirectory_for_attachments']) && !in_array($_POST['basedirectory_for_attachments'], $modSettings['attachment_basedirectories']))
217 223
 			{
@@ -219,8 +225,9 @@  discard block
 block discarded – undo
219 225
 
220 226
 				if (!in_array($_POST['basedirectory_for_attachments'], $modSettings['attachmentUploadDir']))
221 227
 				{
222
-					if (!automanage_attachments_create_directory($_POST['basedirectory_for_attachments']))
223
-						$_POST['basedirectory_for_attachments'] = $modSettings['basedirectory_for_attachments'];
228
+					if (!automanage_attachments_create_directory($_POST['basedirectory_for_attachments'])) {
229
+											$_POST['basedirectory_for_attachments'] = $modSettings['basedirectory_for_attachments'];
230
+					}
224 231
 				}
225 232
 
226 233
 				if (!in_array($_POST['basedirectory_for_attachments'], $modSettings['attachment_basedirectories']))
@@ -336,8 +343,9 @@  discard block
 block discarded – undo
336 343
 
337 344
 	call_integration_hook('integrate_modify_avatar_settings', array(&$config_vars));
338 345
 
339
-	if ($return_config)
340
-		return $config_vars;
346
+	if ($return_config) {
347
+			return $config_vars;
348
+	}
341 349
 
342 350
 	// We need this file for the settings template.
343 351
 	require_once($sourcedir . '/ManageServer.php');
@@ -348,17 +356,21 @@  discard block
 block discarded – undo
348 356
 		checkSession();
349 357
 
350 358
 		// These settings cannot be left empty!
351
-		if (empty($_POST['custom_avatar_dir']))
352
-			$_POST['custom_avatar_dir'] = $boarddir . '/custom_avatar';
359
+		if (empty($_POST['custom_avatar_dir'])) {
360
+					$_POST['custom_avatar_dir'] = $boarddir . '/custom_avatar';
361
+		}
353 362
 
354
-		if (empty($_POST['custom_avatar_url']))
355
-			$_POST['custom_avatar_url'] = $boardurl . '/custom_avatar';
363
+		if (empty($_POST['custom_avatar_url'])) {
364
+					$_POST['custom_avatar_url'] = $boardurl . '/custom_avatar';
365
+		}
356 366
 
357
-		if (empty($_POST['avatar_directory']))
358
-			$_POST['avatar_directory'] = $boarddir . '/avatars';
367
+		if (empty($_POST['avatar_directory'])) {
368
+					$_POST['avatar_directory'] = $boarddir . '/avatars';
369
+		}
359 370
 
360
-		if (empty($_POST['avatar_url']))
361
-			$_POST['avatar_url'] = $boardurl . '/avatars';
371
+		if (empty($_POST['avatar_url'])) {
372
+					$_POST['avatar_url'] = $boardurl . '/avatars';
373
+		}
362 374
 
363 375
 		call_integration_hook('integrate_save_avatar_settings');
364 376
 
@@ -406,11 +418,13 @@  discard block
 block discarded – undo
406 418
 	$list_title = $txt['attachment_manager_browse_files'] . ': ';
407 419
 	foreach ($titles as $browse_type => $details)
408 420
 	{
409
-		if ($browse_type != 'attachments')
410
-			$list_title .= ' | ';
421
+		if ($browse_type != 'attachments') {
422
+					$list_title .= ' | ';
423
+		}
411 424
 
412
-		if ($context['browse_type'] == $browse_type)
413
-			$list_title .= '<img src="' . $settings['images_url'] . '/selected.png" alt="&gt;"> ';
425
+		if ($context['browse_type'] == $browse_type) {
426
+					$list_title .= '<img src="' . $settings['images_url'] . '/selected.png" alt="&gt;"> ';
427
+		}
414 428
 
415 429
 		$list_title .= '<a href="' . $scripturl . $details[0] . '">' . $details[1] . '</a>';
416 430
 	}
@@ -446,28 +460,33 @@  discard block
 block discarded – undo
446 460
 						$link = '<a href="';
447 461
 
448 462
 						// In case of a custom avatar URL attachments have a fixed directory.
449
-						if ($rowData['attachment_type'] == 1)
450
-							$link .= sprintf('%1$s/%2$s', $modSettings['custom_avatar_url'], $rowData['filename']);
463
+						if ($rowData['attachment_type'] == 1) {
464
+													$link .= sprintf('%1$s/%2$s', $modSettings['custom_avatar_url'], $rowData['filename']);
465
+						}
451 466
 
452 467
 						// By default avatars are downloaded almost as attachments.
453
-						elseif ($context['browse_type'] == 'avatars')
454
-							$link .= sprintf('%1$s?action=dlattach;type=avatar;attach=%2$d', $scripturl, $rowData['id_attach']);
468
+						elseif ($context['browse_type'] == 'avatars') {
469
+													$link .= sprintf('%1$s?action=dlattach;type=avatar;attach=%2$d', $scripturl, $rowData['id_attach']);
470
+						}
455 471
 
456 472
 						// Normal attachments are always linked to a topic ID.
457
-						else
458
-							$link .= sprintf('%1$s?action=dlattach;topic=%2$d.0;attach=%3$d', $scripturl, $rowData['id_topic'], $rowData['id_attach']);
473
+						else {
474
+													$link .= sprintf('%1$s?action=dlattach;topic=%2$d.0;attach=%3$d', $scripturl, $rowData['id_topic'], $rowData['id_attach']);
475
+						}
459 476
 
460 477
 						$link .= '"';
461 478
 
462 479
 						// Show a popup on click if it's a picture and we know its dimensions.
463
-						if (!empty($rowData['width']) && !empty($rowData['height']))
464
-							$link .= sprintf(' onclick="return reqWin(this.href' . ($rowData['attachment_type'] == 1 ? '' : ' + \';image\'') . ', %1$d, %2$d, true);"', $rowData['width'] + 20, $rowData['height'] + 20);
480
+						if (!empty($rowData['width']) && !empty($rowData['height'])) {
481
+													$link .= sprintf(' onclick="return reqWin(this.href' . ($rowData['attachment_type'] == 1 ? '' : ' + \';image\'') . ', %1$d, %2$d, true);"', $rowData['width'] + 20, $rowData['height'] + 20);
482
+						}
465 483
 
466 484
 						$link .= sprintf('>%1$s</a>', preg_replace('~&amp;#(\\\\d{1,7}|x[0-9a-fA-F]{1,6});~', '&#\\\\1;', $smcFunc['htmlspecialchars']($rowData['filename'])));
467 485
 
468 486
 						// Show the dimensions.
469
-						if (!empty($rowData['width']) && !empty($rowData['height']))
470
-							$link .= sprintf(' <span class="smalltext">%1$dx%2$d</span>', $rowData['width'], $rowData['height']);
487
+						if (!empty($rowData['width']) && !empty($rowData['height'])) {
488
+													$link .= sprintf(' <span class="smalltext">%1$dx%2$d</span>', $rowData['width'], $rowData['height']);
489
+						}
471 490
 
472 491
 						return $link;
473 492
 					},
@@ -500,12 +519,14 @@  discard block
 block discarded – undo
500 519
 					'function' => function($rowData) use ($scripturl, $smcFunc)
501 520
 					{
502 521
 						// In case of an attachment, return the poster of the attachment.
503
-						if (empty($rowData['id_member']))
504
-							return $smcFunc['htmlspecialchars']($rowData['poster_name']);
522
+						if (empty($rowData['id_member'])) {
523
+													return $smcFunc['htmlspecialchars']($rowData['poster_name']);
524
+						}
505 525
 
506 526
 						// Otherwise it must be an avatar, return the link to the owner of it.
507
-						else
508
-							return sprintf('<a href="%1$s?action=profile;u=%2$d">%3$s</a>', $scripturl, $rowData['id_member'], $rowData['poster_name']);
527
+						else {
528
+													return sprintf('<a href="%1$s?action=profile;u=%2$d">%3$s</a>', $scripturl, $rowData['id_member'], $rowData['poster_name']);
529
+						}
509 530
 					},
510 531
 				),
511 532
 				'sort' => array(
@@ -524,8 +545,9 @@  discard block
 block discarded – undo
524 545
 						$date = empty($rowData['poster_time']) ? $txt['never'] : timeformat($rowData['poster_time']);
525 546
 
526 547
 						// Add a link to the topic in case of an attachment.
527
-						if ($context['browse_type'] !== 'avatars')
528
-							$date .= sprintf('<br>%1$s <a href="%2$s?topic=%3$d.msg%4$d#msg%4$d">%5$s</a>', $txt['in'], $scripturl, $rowData['id_topic'], $rowData['id_msg'], $rowData['subject']);
548
+						if ($context['browse_type'] !== 'avatars') {
549
+													$date .= sprintf('<br>%1$s <a href="%2$s?topic=%3$d.msg%4$d#msg%4$d">%5$s</a>', $txt['in'], $scripturl, $rowData['id_topic'], $rowData['id_msg'], $rowData['subject']);
550
+						}
529 551
 
530 552
 						return $date;
531 553
 					},
@@ -610,8 +632,8 @@  discard block
 block discarded – undo
610 632
 	global $smcFunc, $txt;
611 633
 
612 634
 	// Choose a query depending on what we are viewing.
613
-	if ($browse_type === 'avatars')
614
-		$request = $smcFunc['db_query']('', '
635
+	if ($browse_type === 'avatars') {
636
+			$request = $smcFunc['db_query']('', '
615 637
 			SELECT
616 638
 				{string:blank_text} AS id_msg, COALESCE(mem.real_name, {string:not_applicable_text}) AS poster_name,
617 639
 				mem.last_login AS poster_time, 0 AS id_topic, a.id_member, a.id_attach, a.filename, a.file_hash, a.attachment_type,
@@ -630,8 +652,8 @@  discard block
 block discarded – undo
630 652
 				'per_page' => $items_per_page,
631 653
 			)
632 654
 		);
633
-	else
634
-		$request = $smcFunc['db_query']('', '
655
+	} else {
656
+			$request = $smcFunc['db_query']('', '
635 657
 			SELECT
636 658
 				m.id_msg, COALESCE(mem.real_name, m.poster_name) AS poster_name, m.poster_time, m.id_topic, m.id_member,
637 659
 				a.id_attach, a.filename, a.file_hash, a.attachment_type, a.size, a.width, a.height, a.downloads, mf.subject, t.id_board
@@ -650,9 +672,11 @@  discard block
 block discarded – undo
650 672
 				'per_page' => $items_per_page,
651 673
 			)
652 674
 		);
675
+	}
653 676
 	$files = array();
654
-	while ($row = $smcFunc['db_fetch_assoc']($request))
655
-		$files[] = $row;
677
+	while ($row = $smcFunc['db_fetch_assoc']($request)) {
678
+			$files[] = $row;
679
+	}
656 680
 	$smcFunc['db_free_result']($request);
657 681
 
658 682
 	return $files;
@@ -670,8 +694,8 @@  discard block
 block discarded – undo
670 694
 	global $smcFunc;
671 695
 
672 696
 	// Depending on the type of file, different queries are used.
673
-	if ($browse_type === 'avatars')
674
-		$request = $smcFunc['db_query']('', '
697
+	if ($browse_type === 'avatars') {
698
+			$request = $smcFunc['db_query']('', '
675 699
 		SELECT COUNT(*)
676 700
 		FROM {db_prefix}attachments
677 701
 		WHERE id_member != {int:guest_id_member}',
@@ -679,8 +703,8 @@  discard block
 block discarded – undo
679 703
 			'guest_id_member' => 0,
680 704
 		)
681 705
 	);
682
-	else
683
-		$request = $smcFunc['db_query']('', '
706
+	} else {
707
+			$request = $smcFunc['db_query']('', '
684 708
 			SELECT COUNT(*) AS num_attach
685 709
 			FROM {db_prefix}attachments AS a
686 710
 				INNER JOIN {db_prefix}messages AS m ON (m.id_msg = a.id_msg)
@@ -693,6 +717,7 @@  discard block
 block discarded – undo
693 717
 				'guest_id_member' => 0,
694 718
 			)
695 719
 		);
720
+	}
696 721
 
697 722
 	list ($num_files) = $smcFunc['db_fetch_row']($request);
698 723
 	$smcFunc['db_free_result']($request);
@@ -775,12 +800,14 @@  discard block
 block discarded – undo
775 800
 	$current_dir_size /= 1024;
776 801
 
777 802
 	// If they specified a limit only....
778
-	if (!empty($modSettings['attachmentDirSizeLimit']))
779
-		$context['attachment_space'] = comma_format(max($modSettings['attachmentDirSizeLimit'] - $current_dir_size, 0), 2);
803
+	if (!empty($modSettings['attachmentDirSizeLimit'])) {
804
+			$context['attachment_space'] = comma_format(max($modSettings['attachmentDirSizeLimit'] - $current_dir_size, 0), 2);
805
+	}
780 806
 	$context['attachment_current_size'] = comma_format($current_dir_size, 2);
781 807
 
782
-	if (!empty($modSettings['attachmentDirFileLimit']))
783
-		$context['attachment_files'] = comma_format(max($modSettings['attachmentDirFileLimit'] - $current_dir_files, 0), 0);
808
+	if (!empty($modSettings['attachmentDirFileLimit'])) {
809
+			$context['attachment_files'] = comma_format(max($modSettings['attachmentDirFileLimit'] - $current_dir_files, 0), 0);
810
+	}
784 811
 	$context['attachment_current_files'] = comma_format($current_dir_files, 0);
785 812
 
786 813
 	$context['attach_multiple_dirs'] = count($attach_dirs) > 1 ? true : false;
@@ -817,8 +844,8 @@  discard block
 block discarded – undo
817 844
 		$messages = removeAttachments(array('attachment_type' => 0, 'poster_time' => (time() - 24 * 60 * 60 * $_POST['age'])), 'messages', true);
818 845
 
819 846
 		// Update the messages to reflect the change.
820
-		if (!empty($messages) && !empty($_POST['notice']))
821
-			$smcFunc['db_query']('', '
847
+		if (!empty($messages) && !empty($_POST['notice'])) {
848
+					$smcFunc['db_query']('', '
822 849
 				UPDATE {db_prefix}messages
823 850
 				SET body = CONCAT(body, {string:notice})
824 851
 				WHERE id_msg IN ({array_int:messages})',
@@ -827,8 +854,8 @@  discard block
 block discarded – undo
827 854
 					'notice' => '<br><br>' . $_POST['notice'],
828 855
 				)
829 856
 			);
830
-	}
831
-	else
857
+		}
858
+	} else
832 859
 	{
833 860
 		// Remove all the old avatars.
834 861
 		removeAttachments(array('not_id_member' => 0, 'last_login' => (time() - 24 * 60 * 60 * $_POST['age'])), 'members');
@@ -853,8 +880,8 @@  discard block
 block discarded – undo
853 880
 	$messages = removeAttachments(array('attachment_type' => 0, 'size' => 1024 * $_POST['size']), 'messages', true);
854 881
 
855 882
 	// And make a note on the post.
856
-	if (!empty($messages) && !empty($_POST['notice']))
857
-		$smcFunc['db_query']('', '
883
+	if (!empty($messages) && !empty($_POST['notice'])) {
884
+			$smcFunc['db_query']('', '
858 885
 			UPDATE {db_prefix}messages
859 886
 			SET body = CONCAT(body, {string:notice})
860 887
 			WHERE id_msg IN ({array_int:messages})',
@@ -863,6 +890,7 @@  discard block
 block discarded – undo
863 890
 				'notice' => '<br><br>' . $_POST['notice'],
864 891
 			)
865 892
 		);
893
+	}
866 894
 
867 895
 	redirectexit('action=admin;area=manageattachments;sa=maintenance');
868 896
 }
@@ -882,16 +910,17 @@  discard block
 block discarded – undo
882 910
 	{
883 911
 		$attachments = array();
884 912
 		// There must be a quicker way to pass this safety test??
885
-		foreach ($_POST['remove'] as $removeID => $dummy)
886
-			$attachments[] = (int) $removeID;
913
+		foreach ($_POST['remove'] as $removeID => $dummy) {
914
+					$attachments[] = (int) $removeID;
915
+		}
887 916
 
888 917
 		// If the attachments are from a 3rd party, let them remove it. Hooks should remove their ids from the array.
889 918
 		$filesRemoved = false;
890 919
 		call_integration_hook('integrate_attachment_remove', array(&$filesRemoved, $attachments));
891 920
 
892
-		if ($_REQUEST['type'] == 'avatars' && !empty($attachments))
893
-			removeAttachments(array('id_attach' => $attachments));
894
-		else if (!empty($attachments))
921
+		if ($_REQUEST['type'] == 'avatars' && !empty($attachments)) {
922
+					removeAttachments(array('id_attach' => $attachments));
923
+		} else if (!empty($attachments))
895 924
 		{
896 925
 			$messages = removeAttachments(array('id_attach' => $attachments), 'messages', true);
897 926
 
@@ -930,12 +959,13 @@  discard block
 block discarded – undo
930 959
 
931 960
 	$messages = removeAttachments(array('attachment_type' => 0), '', true);
932 961
 
933
-	if (!isset($_POST['notice']))
934
-		$_POST['notice'] = $txt['attachment_delete_admin'];
962
+	if (!isset($_POST['notice'])) {
963
+			$_POST['notice'] = $txt['attachment_delete_admin'];
964
+	}
935 965
 
936 966
 	// Add the notice on the end of the changed messages.
937
-	if (!empty($messages))
938
-		$smcFunc['db_query']('', '
967
+	if (!empty($messages)) {
968
+			$smcFunc['db_query']('', '
939 969
 			UPDATE {db_prefix}messages
940 970
 			SET body = CONCAT(body, {string:deleted_message})
941 971
 			WHERE id_msg IN ({array_int:messages})',
@@ -944,6 +974,7 @@  discard block
 block discarded – undo
944 974
 				'deleted_message' => '<br><br>' . $_POST['notice'],
945 975
 			)
946 976
 		);
977
+	}
947 978
 
948 979
 	redirectexit('action=admin;area=manageattachments;sa=maintenance');
949 980
 }
@@ -982,24 +1013,26 @@  discard block
 block discarded – undo
982 1013
 			$is_not = substr($real_type, 0, 4) == 'not_';
983 1014
 			$type = $is_not ? substr($real_type, 4) : $real_type;
984 1015
 
985
-			if (in_array($type, array('id_member', 'id_attach', 'id_msg')))
986
-				$new_condition[] = 'a.' . $type . ($is_not ? ' NOT' : '') . ' IN (' . (is_array($restriction) ? '{array_int:' . $real_type . '}' : '{int:' . $real_type . '}') . ')';
987
-			elseif ($type == 'attachment_type')
988
-				$new_condition[] = 'a.attachment_type = {int:' . $real_type . '}';
989
-			elseif ($type == 'poster_time')
990
-				$new_condition[] = 'm.poster_time < {int:' . $real_type . '}';
991
-			elseif ($type == 'last_login')
992
-				$new_condition[] = 'mem.last_login < {int:' . $real_type . '}';
993
-			elseif ($type == 'size')
994
-				$new_condition[] = 'a.size > {int:' . $real_type . '}';
995
-			elseif ($type == 'id_topic')
996
-				$new_condition[] = 'm.id_topic IN (' . (is_array($restriction) ? '{array_int:' . $real_type . '}' : '{int:' . $real_type . '}') . ')';
1016
+			if (in_array($type, array('id_member', 'id_attach', 'id_msg'))) {
1017
+							$new_condition[] = 'a.' . $type . ($is_not ? ' NOT' : '') . ' IN (' . (is_array($restriction) ? '{array_int:' . $real_type . '}' : '{int:' . $real_type . '}') . ')';
1018
+			} elseif ($type == 'attachment_type') {
1019
+							$new_condition[] = 'a.attachment_type = {int:' . $real_type . '}';
1020
+			} elseif ($type == 'poster_time') {
1021
+							$new_condition[] = 'm.poster_time < {int:' . $real_type . '}';
1022
+			} elseif ($type == 'last_login') {
1023
+							$new_condition[] = 'mem.last_login < {int:' . $real_type . '}';
1024
+			} elseif ($type == 'size') {
1025
+							$new_condition[] = 'a.size > {int:' . $real_type . '}';
1026
+			} elseif ($type == 'id_topic') {
1027
+							$new_condition[] = 'm.id_topic IN (' . (is_array($restriction) ? '{array_int:' . $real_type . '}' : '{int:' . $real_type . '}') . ')';
1028
+			}
997 1029
 
998 1030
 			// Add the parameter!
999 1031
 			$query_parameter[$real_type] = $restriction;
1000 1032
 
1001
-			if ($type == 'do_logging')
1002
-				$do_logging = $condition['id_attach'];
1033
+			if ($type == 'do_logging') {
1034
+							$do_logging = $condition['id_attach'];
1035
+			}
1003 1036
 		}
1004 1037
 		$condition = implode(' AND ', $new_condition);
1005 1038
 	}
@@ -1031,15 +1064,15 @@  discard block
 block discarded – undo
1031 1064
 			// wasn't it obvious? :P
1032 1065
 			// @todo look again at this.
1033 1066
 			@unlink($modSettings['custom_avatar_dir'] . '/' . $row['filename']);
1034
-		}
1035
-		else
1067
+		} else
1036 1068
 		{
1037 1069
 			$filename = getAttachmentFilename($row['filename'], $row['id_attach'], $row['id_folder'], false, $row['file_hash']);
1038 1070
 			@unlink($filename);
1039 1071
 
1040 1072
 			// If this was a thumb, the parent attachment should know about it.
1041
-			if (!empty($row['id_parent']))
1042
-				$parents[] = $row['id_parent'];
1073
+			if (!empty($row['id_parent'])) {
1074
+							$parents[] = $row['id_parent'];
1075
+			}
1043 1076
 
1044 1077
 			// If this attachments has a thumb, remove it as well.
1045 1078
 			if (!empty($row['id_thumb']) && $autoThumbRemoval)
@@ -1051,8 +1084,9 @@  discard block
 block discarded – undo
1051 1084
 		}
1052 1085
 
1053 1086
 		// Make a list.
1054
-		if ($return_affected_messages && empty($row['attachment_type']))
1055
-			$msgs[] = $row['id_msg'];
1087
+		if ($return_affected_messages && empty($row['attachment_type'])) {
1088
+					$msgs[] = $row['id_msg'];
1089
+		}
1056 1090
 
1057 1091
 		$attach[] = $row['id_attach'];
1058 1092
 	}
@@ -1060,8 +1094,8 @@  discard block
 block discarded – undo
1060 1094
 
1061 1095
 	// Removed attachments don't have to be updated anymore.
1062 1096
 	$parents = array_diff($parents, $attach);
1063
-	if (!empty($parents))
1064
-		$smcFunc['db_query']('', '
1097
+	if (!empty($parents)) {
1098
+			$smcFunc['db_query']('', '
1065 1099
 			UPDATE {db_prefix}attachments
1066 1100
 			SET id_thumb = {int:no_thumb}
1067 1101
 			WHERE id_attach IN ({array_int:parent_attachments})',
@@ -1070,6 +1104,7 @@  discard block
 block discarded – undo
1070 1104
 				'no_thumb' => 0,
1071 1105
 			)
1072 1106
 		);
1107
+	}
1073 1108
 
1074 1109
 	if (!empty($do_logging))
1075 1110
 	{
@@ -1086,31 +1121,34 @@  discard block
 block discarded – undo
1086 1121
 			)
1087 1122
 		);
1088 1123
 
1089
-		while ($row = $smcFunc['db_fetch_assoc']($request))
1090
-			logAction(
1124
+		while ($row = $smcFunc['db_fetch_assoc']($request)) {
1125
+					logAction(
1091 1126
 				'remove_attach',
1092 1127
 				array(
1093 1128
 					'message' => $row['id_msg'],
1094 1129
 					'filename' => preg_replace('~&amp;#(\\d{1,7}|x[0-9a-fA-F]{1,6});~', '&#\\1;', $smcFunc['htmlspecialchars']($row['filename'])),
1095 1130
 				)
1096 1131
 			);
1132
+		}
1097 1133
 		$smcFunc['db_free_result']($request);
1098 1134
 	}
1099 1135
 
1100
-	if (!empty($attach))
1101
-		$smcFunc['db_query']('', '
1136
+	if (!empty($attach)) {
1137
+			$smcFunc['db_query']('', '
1102 1138
 			DELETE FROM {db_prefix}attachments
1103 1139
 			WHERE id_attach IN ({array_int:attachment_list})',
1104 1140
 			array(
1105 1141
 				'attachment_list' => $attach,
1106 1142
 			)
1107 1143
 		);
1144
+	}
1108 1145
 
1109 1146
 	call_integration_hook('integrate_remove_attachments', array($attach));
1110 1147
 
1111
-	if ($return_affected_messages)
1112
-		return array_unique($msgs);
1113
-}
1148
+	if ($return_affected_messages) {
1149
+			return array_unique($msgs);
1150
+	}
1151
+	}
1114 1152
 
1115 1153
 /**
1116 1154
  * This function should find attachments in the database that no longer exist and clear them, and fix filesize issues.
@@ -1122,8 +1160,9 @@  discard block
 block discarded – undo
1122 1160
 	checkSession('get');
1123 1161
 
1124 1162
 	// If we choose cancel, redirect right back.
1125
-	if (isset($_POST['cancel']))
1126
-		redirectexit('action=admin;area=manageattachments;sa=maintenance');
1163
+	if (isset($_POST['cancel'])) {
1164
+			redirectexit('action=admin;area=manageattachments;sa=maintenance');
1165
+	}
1127 1166
 
1128 1167
 	// Try give us a while to sort this out...
1129 1168
 	@set_time_limit(600);
@@ -1140,13 +1179,15 @@  discard block
 block discarded – undo
1140 1179
 		if (isset($_GET['fixErrors']))
1141 1180
 		{
1142 1181
 			// Nothing?
1143
-			if (empty($_POST['to_fix']))
1144
-				redirectexit('action=admin;area=manageattachments;sa=maintenance');
1182
+			if (empty($_POST['to_fix'])) {
1183
+							redirectexit('action=admin;area=manageattachments;sa=maintenance');
1184
+			}
1145 1185
 
1146 1186
 			$_SESSION['attachments_to_fix'] = array();
1147 1187
 			// @todo No need to do this I think.
1148
-			foreach ($_POST['to_fix'] as $value)
1149
-				$_SESSION['attachments_to_fix'][] = $value;
1188
+			foreach ($_POST['to_fix'] as $value) {
1189
+							$_SESSION['attachments_to_fix'][] = $value;
1190
+			}
1150 1191
 		}
1151 1192
 	}
1152 1193
 
@@ -1213,13 +1254,14 @@  discard block
 block discarded – undo
1213 1254
 					}
1214 1255
 				}
1215 1256
 			}
1216
-			if ($smcFunc['db_num_rows']($result) != 0)
1217
-				$to_fix[] = 'missing_thumbnail_parent';
1257
+			if ($smcFunc['db_num_rows']($result) != 0) {
1258
+							$to_fix[] = 'missing_thumbnail_parent';
1259
+			}
1218 1260
 			$smcFunc['db_free_result']($result);
1219 1261
 
1220 1262
 			// Do we need to delete what we have?
1221
-			if ($fix_errors && !empty($to_remove) && in_array('missing_thumbnail_parent', $to_fix))
1222
-				$smcFunc['db_query']('', '
1263
+			if ($fix_errors && !empty($to_remove) && in_array('missing_thumbnail_parent', $to_fix)) {
1264
+							$smcFunc['db_query']('', '
1223 1265
 					DELETE FROM {db_prefix}attachments
1224 1266
 					WHERE id_attach IN ({array_int:to_remove})
1225 1267
 						AND attachment_type = {int:attachment_type}',
@@ -1228,6 +1270,7 @@  discard block
 block discarded – undo
1228 1270
 						'attachment_type' => 3,
1229 1271
 					)
1230 1272
 				);
1273
+			}
1231 1274
 
1232 1275
 			pauseAttachmentMaintenance($to_fix, $thumbnails);
1233 1276
 		}
@@ -1272,13 +1315,14 @@  discard block
 block discarded – undo
1272 1315
 				$to_update[] = $row['id_attach'];
1273 1316
 				$context['repair_errors']['parent_missing_thumbnail']++;
1274 1317
 			}
1275
-			if ($smcFunc['db_num_rows']($result) != 0)
1276
-				$to_fix[] = 'parent_missing_thumbnail';
1318
+			if ($smcFunc['db_num_rows']($result) != 0) {
1319
+							$to_fix[] = 'parent_missing_thumbnail';
1320
+			}
1277 1321
 			$smcFunc['db_free_result']($result);
1278 1322
 
1279 1323
 			// Do we need to delete what we have?
1280
-			if ($fix_errors && !empty($to_update) && in_array('parent_missing_thumbnail', $to_fix))
1281
-				$smcFunc['db_query']('', '
1324
+			if ($fix_errors && !empty($to_update) && in_array('parent_missing_thumbnail', $to_fix)) {
1325
+							$smcFunc['db_query']('', '
1282 1326
 					UPDATE {db_prefix}attachments
1283 1327
 					SET id_thumb = {int:no_thumb}
1284 1328
 					WHERE id_attach IN ({array_int:to_update})',
@@ -1287,6 +1331,7 @@  discard block
 block discarded – undo
1287 1331
 						'no_thumb' => 0,
1288 1332
 					)
1289 1333
 				);
1334
+			}
1290 1335
 
1291 1336
 			pauseAttachmentMaintenance($to_fix, $thumbnails);
1292 1337
 		}
@@ -1324,10 +1369,11 @@  discard block
 block discarded – undo
1324 1369
 			while ($row = $smcFunc['db_fetch_assoc']($result))
1325 1370
 			{
1326 1371
 				// Get the filename.
1327
-				if ($row['attachment_type'] == 1)
1328
-					$filename = $modSettings['custom_avatar_dir'] . '/' . $row['filename'];
1329
-				else
1330
-					$filename = getAttachmentFilename($row['filename'], $row['id_attach'], $row['id_folder'], false, $row['file_hash']);
1372
+				if ($row['attachment_type'] == 1) {
1373
+									$filename = $modSettings['custom_avatar_dir'] . '/' . $row['filename'];
1374
+				} else {
1375
+									$filename = getAttachmentFilename($row['filename'], $row['id_attach'], $row['id_folder'], false, $row['file_hash']);
1376
+				}
1331 1377
 
1332 1378
 				// File doesn't exist?
1333 1379
 				if (!file_exists($filename))
@@ -1339,15 +1385,16 @@  discard block
 block discarded – undo
1339 1385
 						$attachment_name = $row['id_attach'] . '_' . $row['file_hash'] . '.dat';
1340 1386
 
1341 1387
 						// Loop through the other folders.
1342
-						foreach ($modSettings['attachmentUploadDir'] as $id => $dir)
1343
-							if (file_exists($dir . '/' . $attachment_name))
1388
+						foreach ($modSettings['attachmentUploadDir'] as $id => $dir) {
1389
+													if (file_exists($dir . '/' . $attachment_name))
1344 1390
 							{
1345 1391
 								$context['repair_errors']['wrong_folder']++;
1392
+						}
1346 1393
 								$errors_found[] = 'wrong_folder';
1347 1394
 
1348 1395
 								// Are we going to fix this now?
1349
-								if ($fix_errors && in_array('wrong_folder', $to_fix))
1350
-									$smcFunc['db_query']('', '
1396
+								if ($fix_errors && in_array('wrong_folder', $to_fix)) {
1397
+																	$smcFunc['db_query']('', '
1351 1398
 										UPDATE {db_prefix}attachments
1352 1399
 										SET id_folder = {int:new_folder}
1353 1400
 										WHERE id_attach = {int:id_attach}',
@@ -1356,6 +1403,7 @@  discard block
 block discarded – undo
1356 1403
 											'id_attach' => $row['id_attach'],
1357 1404
 										)
1358 1405
 									);
1406
+								}
1359 1407
 
1360 1408
 								continue 2;
1361 1409
 							}
@@ -1364,8 +1412,7 @@  discard block
 block discarded – undo
1364 1412
 					$to_remove[] = $row['id_attach'];
1365 1413
 					$context['repair_errors']['file_missing_on_disk']++;
1366 1414
 					$errors_found[] = 'file_missing_on_disk';
1367
-				}
1368
-				elseif (filesize($filename) == 0)
1415
+				} elseif (filesize($filename) == 0)
1369 1416
 				{
1370 1417
 					$context['repair_errors']['file_size_of_zero']++;
1371 1418
 					$errors_found[] = 'file_size_of_zero';
@@ -1376,8 +1423,7 @@  discard block
 block discarded – undo
1376 1423
 						$to_remove[] = $row['id_attach'];
1377 1424
 						@unlink($filename);
1378 1425
 					}
1379
-				}
1380
-				elseif (filesize($filename) != $row['size'])
1426
+				} elseif (filesize($filename) != $row['size'])
1381 1427
 				{
1382 1428
 					$context['repair_errors']['file_wrong_size']++;
1383 1429
 					$errors_found[] = 'file_wrong_size';
@@ -1398,14 +1444,18 @@  discard block
 block discarded – undo
1398 1444
 				}
1399 1445
 			}
1400 1446
 
1401
-			if (in_array('file_missing_on_disk', $errors_found))
1402
-				$to_fix[] = 'file_missing_on_disk';
1403
-			if (in_array('file_size_of_zero', $errors_found))
1404
-				$to_fix[] = 'file_size_of_zero';
1405
-			if (in_array('file_wrong_size', $errors_found))
1406
-				$to_fix[] = 'file_wrong_size';
1407
-			if (in_array('wrong_folder', $errors_found))
1408
-				$to_fix[] = 'wrong_folder';
1447
+			if (in_array('file_missing_on_disk', $errors_found)) {
1448
+							$to_fix[] = 'file_missing_on_disk';
1449
+			}
1450
+			if (in_array('file_size_of_zero', $errors_found)) {
1451
+							$to_fix[] = 'file_size_of_zero';
1452
+			}
1453
+			if (in_array('file_wrong_size', $errors_found)) {
1454
+							$to_fix[] = 'file_wrong_size';
1455
+			}
1456
+			if (in_array('wrong_folder', $errors_found)) {
1457
+							$to_fix[] = 'wrong_folder';
1458
+			}
1409 1459
 			$smcFunc['db_free_result']($result);
1410 1460
 
1411 1461
 			// Do we need to delete what we have?
@@ -1475,20 +1525,22 @@  discard block
 block discarded – undo
1475 1525
 				// If we are repairing remove the file from disk now.
1476 1526
 				if ($fix_errors && in_array('avatar_no_member', $to_fix))
1477 1527
 				{
1478
-					if ($row['attachment_type'] == 1)
1479
-						$filename = $modSettings['custom_avatar_dir'] . '/' . $row['filename'];
1480
-					else
1481
-						$filename = getAttachmentFilename($row['filename'], $row['id_attach'], $row['id_folder'], false, $row['file_hash']);
1528
+					if ($row['attachment_type'] == 1) {
1529
+											$filename = $modSettings['custom_avatar_dir'] . '/' . $row['filename'];
1530
+					} else {
1531
+											$filename = getAttachmentFilename($row['filename'], $row['id_attach'], $row['id_folder'], false, $row['file_hash']);
1532
+					}
1482 1533
 					@unlink($filename);
1483 1534
 				}
1484 1535
 			}
1485
-			if ($smcFunc['db_num_rows']($result) != 0)
1486
-				$to_fix[] = 'avatar_no_member';
1536
+			if ($smcFunc['db_num_rows']($result) != 0) {
1537
+							$to_fix[] = 'avatar_no_member';
1538
+			}
1487 1539
 			$smcFunc['db_free_result']($result);
1488 1540
 
1489 1541
 			// Do we need to delete what we have?
1490
-			if ($fix_errors && !empty($to_remove) && in_array('avatar_no_member', $to_fix))
1491
-				$smcFunc['db_query']('', '
1542
+			if ($fix_errors && !empty($to_remove) && in_array('avatar_no_member', $to_fix)) {
1543
+							$smcFunc['db_query']('', '
1492 1544
 					DELETE FROM {db_prefix}attachments
1493 1545
 					WHERE id_attach IN ({array_int:to_remove})
1494 1546
 						AND id_member != {int:no_member}
@@ -1499,6 +1551,7 @@  discard block
 block discarded – undo
1499 1551
 						'no_msg' => 0,
1500 1552
 					)
1501 1553
 				);
1554
+			}
1502 1555
 
1503 1556
 			pauseAttachmentMaintenance($to_fix, $thumbnails);
1504 1557
 		}
@@ -1558,13 +1611,14 @@  discard block
 block discarded – undo
1558 1611
 					@unlink($filename);
1559 1612
 				}
1560 1613
 			}
1561
-			if ($smcFunc['db_num_rows']($result) != 0)
1562
-				$to_fix[] = 'attachment_no_msg';
1614
+			if ($smcFunc['db_num_rows']($result) != 0) {
1615
+							$to_fix[] = 'attachment_no_msg';
1616
+			}
1563 1617
 			$smcFunc['db_free_result']($result);
1564 1618
 
1565 1619
 			// Do we need to delete what we have?
1566
-			if ($fix_errors && !empty($to_remove) && in_array('attachment_no_msg', $to_fix))
1567
-				$smcFunc['db_query']('', '
1620
+			if ($fix_errors && !empty($to_remove) && in_array('attachment_no_msg', $to_fix)) {
1621
+							$smcFunc['db_query']('', '
1568 1622
 					DELETE FROM {db_prefix}attachments
1569 1623
 					WHERE id_attach IN ({array_int:to_remove})
1570 1624
 						AND id_member = {int:no_member}
@@ -1575,6 +1629,7 @@  discard block
 block discarded – undo
1575 1629
 						'attach_thumb' => array(0,3),
1576 1630
 					)
1577 1631
 				);
1632
+			}
1578 1633
 
1579 1634
 			pauseAttachmentMaintenance($to_fix, $thumbnails);
1580 1635
 		}
@@ -1598,8 +1653,9 @@  discard block
 block discarded – undo
1598 1653
 			{
1599 1654
 				while ($file = readdir($dir))
1600 1655
 				{
1601
-					if (in_array($file, array('.', '..', '.htaccess', 'index.php')))
1602
-						continue;
1656
+					if (in_array($file, array('.', '..', '.htaccess', 'index.php'))) {
1657
+											continue;
1658
+					}
1603 1659
 
1604 1660
 					if ($files_checked <= $current_check)
1605 1661
 					{
@@ -1607,8 +1663,9 @@  discard block
 block discarded – undo
1607 1663
 						if (strpos($file, 'post_tmp_') !== false)
1608 1664
 						{
1609 1665
 							// Temp file is more than 5 hours old!
1610
-							if (filemtime($attach_dir . '/' . $file) < time() - 18000)
1611
-								@unlink($attach_dir . '/' . $file);
1666
+							if (filemtime($attach_dir . '/' . $file) < time() - 18000) {
1667
+															@unlink($attach_dir . '/' . $file);
1668
+							}
1612 1669
 						}
1613 1670
 						// That should be an attachment, let's check if we have it in the database
1614 1671
 						elseif (strpos($file, '_') !== false)
@@ -1630,8 +1687,7 @@  discard block
 block discarded – undo
1630 1687
 									if ($fix_errors && in_array('files_without_attachment', $to_fix))
1631 1688
 									{
1632 1689
 										@unlink($attach_dir . '/' . $file);
1633
-									}
1634
-									else
1690
+									} else
1635 1691
 									{
1636 1692
 										$context['repair_errors']['files_without_attachment']++;
1637 1693
 										$to_fix[] = 'files_without_attachment';
@@ -1639,14 +1695,12 @@  discard block
 block discarded – undo
1639 1695
 								}
1640 1696
 								$smcFunc['db_free_result']($request);
1641 1697
 							}
1642
-						}
1643
-						else
1698
+						} else
1644 1699
 						{
1645 1700
 							if ($fix_errors && in_array('files_without_attachment', $to_fix))
1646 1701
 							{
1647 1702
 								@unlink($attach_dir . '/' . $file);
1648
-							}
1649
-							else
1703
+							} else
1650 1704
 							{
1651 1705
 								$context['repair_errors']['files_without_attachment']++;
1652 1706
 								$to_fix[] = 'files_without_attachment';
@@ -1655,8 +1709,9 @@  discard block
 block discarded – undo
1655 1709
 					}
1656 1710
 					$current_check++;
1657 1711
 					$_GET['substep'] = $current_check;
1658
-					if ($current_check - $files_checked >= $max_checks)
1659
-						pauseAttachmentMaintenance($to_fix);
1712
+					if ($current_check - $files_checked >= $max_checks) {
1713
+											pauseAttachmentMaintenance($to_fix);
1714
+					}
1660 1715
 				}
1661 1716
 				closedir($dir);
1662 1717
 			}
@@ -1692,12 +1747,14 @@  discard block
 block discarded – undo
1692 1747
 
1693 1748
 	// Try get more time...
1694 1749
 	@set_time_limit(600);
1695
-	if (function_exists('apache_reset_timeout'))
1696
-		@apache_reset_timeout();
1750
+	if (function_exists('apache_reset_timeout')) {
1751
+			@apache_reset_timeout();
1752
+	}
1697 1753
 
1698 1754
 	// Have we already used our maximum time?
1699
-	if ((time() - $time_start) < 3 || $context['starting_substep'] == $_GET['substep'])
1700
-		return;
1755
+	if ((time() - $time_start) < 3 || $context['starting_substep'] == $_GET['substep']) {
1756
+			return;
1757
+	}
1701 1758
 
1702 1759
 	$context['continue_get_data'] = '?action=admin;area=manageattachments;sa=repair' . (isset($_GET['fixErrors']) ? ';fixErrors' : '') . ';step=' . $_GET['step'] . ';substep=' . $_GET['substep'] . ';' . $context['session_var'] . '=' . $context['session_id'];
1703 1760
 	$context['page_title'] = $txt['not_done_title'];
@@ -1709,10 +1766,11 @@  discard block
 block discarded – undo
1709 1766
 	$context[$context['admin_menu_name']]['current_subsection'] = 'maintenance';
1710 1767
 
1711 1768
 	// Change these two if more steps are added!
1712
-	if (empty($max_substep))
1713
-		$context['continue_percent'] = round(($_GET['step'] * 100) / 25);
1714
-	else
1715
-		$context['continue_percent'] = round(($_GET['step'] * 100 + ($_GET['substep'] * 100) / $max_substep) / 25);
1769
+	if (empty($max_substep)) {
1770
+			$context['continue_percent'] = round(($_GET['step'] * 100) / 25);
1771
+	} else {
1772
+			$context['continue_percent'] = round(($_GET['step'] * 100 + ($_GET['substep'] * 100) / $max_substep) / 25);
1773
+	}
1716 1774
 
1717 1775
 	// Never more than 100%!
1718 1776
 	$context['continue_percent'] = min($context['continue_percent'], 100);
@@ -1754,15 +1812,17 @@  discard block
 block discarded – undo
1754 1812
 				'attachment_type' => 0,
1755 1813
 			)
1756 1814
 		);
1757
-		while ($row = $smcFunc['db_fetch_assoc']($request))
1758
-			$attachments[] = $row['id_attach'];
1815
+		while ($row = $smcFunc['db_fetch_assoc']($request)) {
1816
+					$attachments[] = $row['id_attach'];
1817
+		}
1759 1818
 		$smcFunc['db_free_result']($request);
1819
+	} elseif (!empty($_GET['aid'])) {
1820
+			$attachments[] = (int) $_GET['aid'];
1760 1821
 	}
1761
-	elseif (!empty($_GET['aid']))
1762
-		$attachments[] = (int) $_GET['aid'];
1763 1822
 
1764
-	if (empty($attachments))
1765
-		fatal_lang_error('no_access', false);
1823
+	if (empty($attachments)) {
1824
+			fatal_lang_error('no_access', false);
1825
+	}
1766 1826
 
1767 1827
 	// Now we have some ID's cleaned and ready to approve, but first - let's check we have permission!
1768 1828
 	$allowed_boards = boardsAllowedTo('approve_posts');
@@ -1795,17 +1855,18 @@  discard block
 block discarded – undo
1795 1855
 	}
1796 1856
 	$smcFunc['db_free_result']($request);
1797 1857
 
1798
-	if (empty($attachments))
1799
-		fatal_lang_error('no_access', false);
1858
+	if (empty($attachments)) {
1859
+			fatal_lang_error('no_access', false);
1860
+	}
1800 1861
 
1801 1862
 	// Finally, we are there. Follow through!
1802 1863
 	if ($is_approve)
1803 1864
 	{
1804 1865
 		// Checked and deemed worthy.
1805 1866
 		ApproveAttachments($attachments);
1867
+	} else {
1868
+			removeAttachments(array('id_attach' => $attachments, 'do_logging' => true));
1806 1869
 	}
1807
-	else
1808
-		removeAttachments(array('id_attach' => $attachments, 'do_logging' => true));
1809 1870
 
1810 1871
 	// Return to the topic....
1811 1872
 	redirectexit($redirect);
@@ -1821,8 +1882,9 @@  discard block
 block discarded – undo
1821 1882
 {
1822 1883
 	global $smcFunc;
1823 1884
 
1824
-	if (empty($attachments))
1825
-		return 0;
1885
+	if (empty($attachments)) {
1886
+			return 0;
1887
+	}
1826 1888
 
1827 1889
 	// For safety, check for thumbnails...
1828 1890
 	$request = $smcFunc['db_query']('', '
@@ -1841,15 +1903,17 @@  discard block
 block discarded – undo
1841 1903
 	while ($row = $smcFunc['db_fetch_assoc']($request))
1842 1904
 	{
1843 1905
 		// Update the thumbnail too...
1844
-		if (!empty($row['id_thumb']))
1845
-			$attachments[] = $row['id_thumb'];
1906
+		if (!empty($row['id_thumb'])) {
1907
+					$attachments[] = $row['id_thumb'];
1908
+		}
1846 1909
 
1847 1910
 		$attachments[] = $row['id_attach'];
1848 1911
 	}
1849 1912
 	$smcFunc['db_free_result']($request);
1850 1913
 
1851
-	if (empty($attachments))
1852
-		return 0;
1914
+	if (empty($attachments)) {
1915
+			return 0;
1916
+	}
1853 1917
 
1854 1918
 	// Approving an attachment is not hard - it's easy.
1855 1919
 	$smcFunc['db_query']('', '
@@ -1875,14 +1939,15 @@  discard block
 block discarded – undo
1875 1939
 		)
1876 1940
 	);
1877 1941
 
1878
-	while ($row = $smcFunc['db_fetch_assoc']($request))
1879
-		logAction(
1942
+	while ($row = $smcFunc['db_fetch_assoc']($request)) {
1943
+			logAction(
1880 1944
 			'approve_attach',
1881 1945
 			array(
1882 1946
 				'message' => $row['id_msg'],
1883 1947
 				'filename' => preg_replace('~&amp;#(\\d{1,7}|x[0-9a-fA-F]{1,6});~', '&#\\1;', $smcFunc['htmlspecialchars']($row['filename'])),
1884 1948
 			)
1885 1949
 		);
1950
+	}
1886 1951
 	$smcFunc['db_free_result']($request);
1887 1952
 
1888 1953
 	// Remove from the approval queue.
@@ -1905,11 +1970,11 @@  discard block
 block discarded – undo
1905 1970
 	global $modSettings, $scripturl, $context, $txt, $sourcedir, $boarddir, $smcFunc, $settings;
1906 1971
 
1907 1972
 	// Since this needs to be done eventually.
1908
-	if (!isset($modSettings['attachment_basedirectories']))
1909
-		$modSettings['attachment_basedirectories'] = array();
1910
-
1911
-	elseif (!is_array($modSettings['attachment_basedirectories']))
1912
-		$modSettings['attachment_basedirectories'] = $smcFunc['json_decode']($modSettings['attachment_basedirectories'], true);
1973
+	if (!isset($modSettings['attachment_basedirectories'])) {
1974
+			$modSettings['attachment_basedirectories'] = array();
1975
+	} elseif (!is_array($modSettings['attachment_basedirectories'])) {
1976
+			$modSettings['attachment_basedirectories'] = $smcFunc['json_decode']($modSettings['attachment_basedirectories'], true);
1977
+	}
1913 1978
 
1914 1979
 	$errors = array();
1915 1980
 
@@ -1924,8 +1989,9 @@  discard block
 block discarded – undo
1924 1989
 		{
1925 1990
 			$error = '';
1926 1991
 			$id = (int) $id;
1927
-			if ($id < 1)
1928
-				continue;
1992
+			if ($id < 1) {
1993
+							continue;
1994
+			}
1929 1995
 
1930 1996
 			// Sorry, these dirs are NOT valid
1931 1997
 			$invalid_dirs = array($boarddir, $settings['default_theme_dir'], $sourcedir);
@@ -1944,8 +2010,7 @@  discard block
 block discarded – undo
1944 2010
 				{
1945 2011
 						$errors[] = $path . ': ' . $txt['attach_dir_duplicate_msg'];
1946 2012
 						continue;
1947
-				}
1948
-				elseif (empty($path))
2013
+				} elseif (empty($path))
1949 2014
 				{
1950 2015
 					// Ignore this and set $id to one less
1951 2016
 					continue;
@@ -1953,10 +2018,11 @@  discard block
 block discarded – undo
1953 2018
 
1954 2019
 				// OK, so let's try to create it then.
1955 2020
 				require_once($sourcedir . '/Subs-Attachments.php');
1956
-				if (automanage_attachments_create_directory($path))
1957
-					$_POST['current_dir'] = $modSettings['currentAttachmentUploadDir'];
1958
-				else
1959
-					$errors[] = $path . ': ' . $txt[$context['dir_creation_error']];
2021
+				if (automanage_attachments_create_directory($path)) {
2022
+									$_POST['current_dir'] = $modSettings['currentAttachmentUploadDir'];
2023
+				} else {
2024
+									$errors[] = $path . ': ' . $txt[$context['dir_creation_error']];
2025
+				}
1960 2026
 			}
1961 2027
 
1962 2028
 			// Changing a directory name?
@@ -1969,8 +2035,7 @@  discard block
 block discarded – undo
1969 2035
 						$errors[] = $path . ': ' . $txt['attach_dir_no_rename'];
1970 2036
 						$path = $modSettings['attachmentUploadDir'][$id];
1971 2037
 					}
1972
-				}
1973
-				else
2038
+				} else
1974 2039
 				{
1975 2040
 					$errors[] = $path . ': ' . $txt['attach_dir_exists_msg'];
1976 2041
 					$path = $modSettings['attachmentUploadDir'][$id];
@@ -1995,12 +2060,13 @@  discard block
 block discarded – undo
1995 2060
 				$path = $modSettings['attachmentUploadDir'][$id];
1996 2061
 
1997 2062
 				// It's not a good idea to delete the current directory.
1998
-				if ($id == (!empty($_POST['current_dir']) ? $_POST['current_dir'] : $modSettings['currentAttachmentUploadDir']))
1999
-					$errors[] = $path . ': ' . $txt['attach_dir_is_current'];
2063
+				if ($id == (!empty($_POST['current_dir']) ? $_POST['current_dir'] : $modSettings['currentAttachmentUploadDir'])) {
2064
+									$errors[] = $path . ': ' . $txt['attach_dir_is_current'];
2065
+				}
2000 2066
 				// Or the current base directory
2001
-				elseif (!empty($modSettings['basedirectory_for_attachments']) && $modSettings['basedirectory_for_attachments'] == $modSettings['attachmentUploadDir'][$id])
2002
-					$errors[] = $path . ': ' . $txt['attach_dir_is_current_bd'];
2003
-				else
2067
+				elseif (!empty($modSettings['basedirectory_for_attachments']) && $modSettings['basedirectory_for_attachments'] == $modSettings['attachmentUploadDir'][$id]) {
2068
+									$errors[] = $path . ': ' . $txt['attach_dir_is_current_bd'];
2069
+				} else
2004 2070
 				{
2005 2071
 					// Let's not try to delete a path with files in it.
2006 2072
 					$request = $smcFunc['db_query']('', '
@@ -2019,17 +2085,18 @@  discard block
 block discarded – undo
2019 2085
 					if (!empty($modSettings['attachment_basedirectories']))
2020 2086
 					{
2021 2087
 						// Count any sub-folders.
2022
-						foreach ($modSettings['attachmentUploadDir'] as $sub)
2023
-							if (strpos($sub, $path . DIRECTORY_SEPARATOR) !== false)
2088
+						foreach ($modSettings['attachmentUploadDir'] as $sub) {
2089
+													if (strpos($sub, $path . DIRECTORY_SEPARATOR) !== false)
2024 2090
 								$num_attach++;
2091
+						}
2025 2092
 					}
2026 2093
 
2027 2094
 					// It's safe to delete. So try to delete the folder also
2028 2095
 					if ($num_attach == 0)
2029 2096
 					{
2030
-						if (is_dir($path))
2031
-							$doit = true;
2032
-						elseif (is_dir($boarddir . DIRECTORY_SEPARATOR . $path))
2097
+						if (is_dir($path)) {
2098
+													$doit = true;
2099
+						} elseif (is_dir($boarddir . DIRECTORY_SEPARATOR . $path))
2033 2100
 						{
2034 2101
 							$doit = true;
2035 2102
 							$path = $boarddir . DIRECTORY_SEPARATOR . $path;
@@ -2039,8 +2106,9 @@  discard block
 block discarded – undo
2039 2106
 						{
2040 2107
 							unlink($path . '/.htaccess');
2041 2108
 							unlink($path . '/index.php');
2042
-							if (!@rmdir($path))
2043
-								$error = $path . ': ' . $txt['attach_dir_no_delete'];
2109
+							if (!@rmdir($path)) {
2110
+															$error = $path . ': ' . $txt['attach_dir_no_delete'];
2111
+							}
2044 2112
 						}
2045 2113
 
2046 2114
 						// Remove it from the base directory list.
@@ -2050,14 +2118,15 @@  discard block
 block discarded – undo
2050 2118
 							updateSettings(array('attachment_basedirectories' => $smcFunc['json_encode']($modSettings['attachment_basedirectories'])));
2051 2119
 							$modSettings['attachment_basedirectories'] = $smcFunc['json_decode']($modSettings['attachment_basedirectories'], true);
2052 2120
 						}
2121
+					} else {
2122
+											$error = $path . ': ' . $txt['attach_dir_no_remove'];
2053 2123
 					}
2054
-					else
2055
-						$error = $path . ': ' . $txt['attach_dir_no_remove'];
2056 2124
 
2057
-					if (empty($error))
2058
-						continue;
2059
-					else
2060
-						$errors[] = $error;
2125
+					if (empty($error)) {
2126
+											continue;
2127
+					} else {
2128
+											$errors[] = $error;
2129
+					}
2061 2130
 				}
2062 2131
 			}
2063 2132
 
@@ -2065,23 +2134,26 @@  discard block
 block discarded – undo
2065 2134
 		}
2066 2135
 
2067 2136
 		// We need to make sure the current directory is right.
2068
-		if (empty($_POST['current_dir']) && !empty($modSettings['currentAttachmentUploadDir']))
2069
-			$_POST['current_dir'] = $modSettings['currentAttachmentUploadDir'];
2137
+		if (empty($_POST['current_dir']) && !empty($modSettings['currentAttachmentUploadDir'])) {
2138
+					$_POST['current_dir'] = $modSettings['currentAttachmentUploadDir'];
2139
+		}
2070 2140
 
2071 2141
 		// Find the current directory if there's no value carried,
2072 2142
 		if (empty($_POST['current_dir']) || empty($new_dirs[$_POST['current_dir']]))
2073 2143
 		{
2074
-			if (array_key_exists($modSettings['currentAttachmentUploadDir'], $modSettings['attachmentUploadDir']))
2075
-				$_POST['current_dir'] = $modSettings['currentAttachmentUploadDir'];
2076
-			else
2077
-				$_POST['current_dir'] = max(array_keys($modSettings['attachmentUploadDir']));
2144
+			if (array_key_exists($modSettings['currentAttachmentUploadDir'], $modSettings['attachmentUploadDir'])) {
2145
+							$_POST['current_dir'] = $modSettings['currentAttachmentUploadDir'];
2146
+			} else {
2147
+							$_POST['current_dir'] = max(array_keys($modSettings['attachmentUploadDir']));
2148
+			}
2078 2149
 		}
2079 2150
 
2080 2151
 		// If the user wishes to go back, update the last_dir array
2081 2152
 		if ($_POST['current_dir'] != $modSettings['currentAttachmentUploadDir'] && !empty($modSettings['last_attachments_directory']) && (isset($modSettings['last_attachments_directory'][$_POST['current_dir']]) || isset($modSettings['last_attachments_directory'][0])))
2082 2153
 		{
2083
-			if (!is_array($modSettings['last_attachments_directory']))
2084
-				$modSettings['last_attachments_directory'] = $smcFunc['json_decode']($modSettings['last_attachments_directory'], true);
2154
+			if (!is_array($modSettings['last_attachments_directory'])) {
2155
+							$modSettings['last_attachments_directory'] = $smcFunc['json_decode']($modSettings['last_attachments_directory'], true);
2156
+			}
2085 2157
 			$num = substr(strrchr($modSettings['attachmentUploadDir'][$_POST['current_dir']], '_'), 1);
2086 2158
 
2087 2159
 			if (is_numeric($num))
@@ -2089,16 +2161,18 @@  discard block
 block discarded – undo
2089 2161
 				// Need to find the base folder.
2090 2162
 				$bid = -1;
2091 2163
 				$use_subdirectories_for_attachments = 0;
2092
-				if (!empty($modSettings['attachment_basedirectories']))
2093
-					foreach ($modSettings['attachment_basedirectories'] as $bid => $base)
2164
+				if (!empty($modSettings['attachment_basedirectories'])) {
2165
+									foreach ($modSettings['attachment_basedirectories'] as $bid => $base)
2094 2166
 						if (strpos($modSettings['attachmentUploadDir'][$_POST['current_dir']], $base . DIRECTORY_SEPARATOR) !== false)
2095 2167
 						{
2096 2168
 							$use_subdirectories_for_attachments = 1;
2169
+				}
2097 2170
 							break;
2098 2171
 						}
2099 2172
 
2100
-				if ($use_subdirectories_for_attachments == 0 && strpos($modSettings['attachmentUploadDir'][$_POST['current_dir']], $boarddir . DIRECTORY_SEPARATOR) !== false)
2101
-					$bid = 0;
2173
+				if ($use_subdirectories_for_attachments == 0 && strpos($modSettings['attachmentUploadDir'][$_POST['current_dir']], $boarddir . DIRECTORY_SEPARATOR) !== false) {
2174
+									$bid = 0;
2175
+				}
2102 2176
 
2103 2177
 				$modSettings['last_attachments_directory'][$bid] = (int) $num;
2104 2178
 				$modSettings['basedirectory_for_attachments'] = !empty($modSettings['basedirectory_for_attachments']) ? $modSettings['basedirectory_for_attachments'] : '';
@@ -2117,8 +2191,8 @@  discard block
 block discarded – undo
2117 2191
 			// We might need to reset the paths. This loop will just loop through once.
2118 2192
 			foreach ($new_dirs as $id => $dir)
2119 2193
 			{
2120
-				if ($id != 1)
2121
-					$smcFunc['db_query']('', '
2194
+				if ($id != 1) {
2195
+									$smcFunc['db_query']('', '
2122 2196
 						UPDATE {db_prefix}attachments
2123 2197
 						SET id_folder = {int:default_folder}
2124 2198
 						WHERE id_folder = {int:current_folder}',
@@ -2127,14 +2201,14 @@  discard block
 block discarded – undo
2127 2201
 							'current_folder' => $id,
2128 2202
 						)
2129 2203
 					);
2204
+				}
2130 2205
 
2131 2206
 				$update = array(
2132 2207
 					'currentAttachmentUploadDir' => 1,
2133 2208
 					'attachmentUploadDir' => $smcFunc['json_encode'](array(1 => $dir)),
2134 2209
 				);
2135 2210
 			}
2136
-		}
2137
-		else
2211
+		} else
2138 2212
 		{
2139 2213
 			// Save it to the database.
2140 2214
 			$update = array(
@@ -2143,11 +2217,13 @@  discard block
 block discarded – undo
2143 2217
 			);
2144 2218
 		}
2145 2219
 
2146
-		if (!empty($update))
2147
-			updateSettings($update);
2220
+		if (!empty($update)) {
2221
+					updateSettings($update);
2222
+		}
2148 2223
 
2149
-		if (!empty($errors))
2150
-			$_SESSION['errors']['dir'] = $errors;
2224
+		if (!empty($errors)) {
2225
+					$_SESSION['errors']['dir'] = $errors;
2226
+		}
2151 2227
 
2152 2228
 		redirectexit('action=admin;area=manageattachments;sa=attachpaths;' . $context['session_var'] . '=' . $context['session_id']);
2153 2229
 	}
@@ -2161,10 +2237,11 @@  discard block
 block discarded – undo
2161 2237
 		$_POST['current_base_dir'] = isset($_POST['current_base_dir']) ? (int) $_POST['current_base_dir'] : 1;
2162 2238
 		if (empty($_POST['new_base_dir']) && !empty($_POST['current_base_dir']))
2163 2239
 		{
2164
-			if ($modSettings['basedirectory_for_attachments'] != $modSettings['attachmentUploadDir'][$_POST['current_base_dir']])
2165
-				$update = (array(
2240
+			if ($modSettings['basedirectory_for_attachments'] != $modSettings['attachmentUploadDir'][$_POST['current_base_dir']]) {
2241
+							$update = (array(
2166 2242
 					'basedirectory_for_attachments' => $modSettings['attachmentUploadDir'][$_POST['current_base_dir']],
2167 2243
 				));
2244
+			}
2168 2245
 		}
2169 2246
 
2170 2247
 		if (isset($_POST['base_dir']))
@@ -2212,13 +2289,15 @@  discard block
 block discarded – undo
2212 2289
 
2213 2290
 			if (!in_array($_POST['new_base_dir'], $modSettings['attachmentUploadDir']))
2214 2291
 			{
2215
-				if (!automanage_attachments_create_directory($_POST['new_base_dir']))
2216
-					$errors[] = $_POST['new_base_dir'] . ': ' . $txt['attach_dir_base_no_create'];
2292
+				if (!automanage_attachments_create_directory($_POST['new_base_dir'])) {
2293
+									$errors[] = $_POST['new_base_dir'] . ': ' . $txt['attach_dir_base_no_create'];
2294
+				}
2217 2295
 			}
2218 2296
 
2219 2297
 			$modSettings['currentAttachmentUploadDir'] = array_search($_POST['new_base_dir'], $modSettings['attachmentUploadDir']);
2220
-			if (!in_array($_POST['new_base_dir'], $modSettings['attachment_basedirectories']))
2221
-				$modSettings['attachment_basedirectories'][$modSettings['currentAttachmentUploadDir']] = $_POST['new_base_dir'];
2298
+			if (!in_array($_POST['new_base_dir'], $modSettings['attachment_basedirectories'])) {
2299
+							$modSettings['attachment_basedirectories'][$modSettings['currentAttachmentUploadDir']] = $_POST['new_base_dir'];
2300
+			}
2222 2301
 			ksort($modSettings['attachment_basedirectories']);
2223 2302
 
2224 2303
 			$update = (array(
@@ -2228,11 +2307,13 @@  discard block
 block discarded – undo
2228 2307
 			));
2229 2308
 		}
2230 2309
 
2231
-		if (!empty($errors))
2232
-			$_SESSION['errors']['base'] = $errors;
2310
+		if (!empty($errors)) {
2311
+					$_SESSION['errors']['base'] = $errors;
2312
+		}
2233 2313
 
2234
-		if (!empty($update))
2235
-			updateSettings($update);
2314
+		if (!empty($update)) {
2315
+					updateSettings($update);
2316
+		}
2236 2317
 
2237 2318
 		redirectexit('action=admin;area=manageattachments;sa=attachpaths;' . $context['session_var'] . '=' . $context['session_id']);
2238 2319
 	}
@@ -2242,13 +2323,15 @@  discard block
 block discarded – undo
2242 2323
 		if (is_array($_SESSION['errors']))
2243 2324
 		{
2244 2325
 			$errors = array();
2245
-			if (!empty($_SESSION['errors']['dir']))
2246
-				foreach ($_SESSION['errors']['dir'] as $error)
2326
+			if (!empty($_SESSION['errors']['dir'])) {
2327
+							foreach ($_SESSION['errors']['dir'] as $error)
2247 2328
 					$errors['dir'][] = $smcFunc['htmlspecialchars']($error, ENT_QUOTES);
2329
+			}
2248 2330
 
2249
-			if (!empty($_SESSION['errors']['base']))
2250
-				foreach ($_SESSION['errors']['base'] as $error)
2331
+			if (!empty($_SESSION['errors']['base'])) {
2332
+							foreach ($_SESSION['errors']['base'] as $error)
2251 2333
 					$errors['base'][] = $smcFunc['htmlspecialchars']($error, ENT_QUOTES);
2334
+			}
2252 2335
 		}
2253 2336
 		unset($_SESSION['errors']);
2254 2337
 	}
@@ -2458,8 +2541,9 @@  discard block
 block discarded – undo
2458 2541
 	foreach ($modSettings['attachmentUploadDir'] as $id => $dir)
2459 2542
 	{
2460 2543
 		// If there aren't any attachments in this directory this won't exist.
2461
-		if (!isset($expected_files[$id]))
2462
-			$expected_files[$id] = 0;
2544
+		if (!isset($expected_files[$id])) {
2545
+					$expected_files[$id] = 0;
2546
+		}
2463 2547
 
2464 2548
 		// Check if the directory is doing okay.
2465 2549
 		list ($status, $error, $files) = attachDirStatus($dir, $expected_files[$id]);
@@ -2472,10 +2556,11 @@  discard block
 block discarded – undo
2472 2556
 			$is_base_dir = in_array($dir, $modSettings['attachment_basedirectories']);
2473 2557
 
2474 2558
 			// Count any sub-folders.
2475
-			foreach ($modSettings['attachmentUploadDir'] as $sid => $sub)
2476
-				if (strpos($sub, $dir . DIRECTORY_SEPARATOR) !== false)
2559
+			foreach ($modSettings['attachmentUploadDir'] as $sid => $sub) {
2560
+							if (strpos($sub, $dir . DIRECTORY_SEPARATOR) !== false)
2477 2561
 				{
2478 2562
 					$expected_files[$id]++;
2563
+			}
2479 2564
 					$sub_dirs++;
2480 2565
 				}
2481 2566
 		}
@@ -2493,8 +2578,8 @@  discard block
 block discarded – undo
2493 2578
 	}
2494 2579
 
2495 2580
 	// Just stick a new directory on at the bottom.
2496
-	if (isset($_REQUEST['new_path']))
2497
-		$attachdirs[] = array(
2581
+	if (isset($_REQUEST['new_path'])) {
2582
+			$attachdirs[] = array(
2498 2583
 			'id' => max(array_merge(array_keys($expected_files), array_keys($modSettings['attachmentUploadDir']))) + 1,
2499 2584
 			'current' => false,
2500 2585
 			'path' => '',
@@ -2502,6 +2587,7 @@  discard block
 block discarded – undo
2502 2587
 			'num_files' => '',
2503 2588
 			'status' => '',
2504 2589
 		);
2590
+	}
2505 2591
 
2506 2592
 	return $attachdirs;
2507 2593
 }
@@ -2514,8 +2600,9 @@  discard block
 block discarded – undo
2514 2600
 {
2515 2601
 	global $modSettings, $txt;
2516 2602
 
2517
-	if (empty($modSettings['attachment_basedirectories']))
2518
-		return;
2603
+	if (empty($modSettings['attachment_basedirectories'])) {
2604
+			return;
2605
+	}
2519 2606
 
2520 2607
 	$basedirs = array();
2521 2608
 	// Get a list of the base directories.
@@ -2523,16 +2610,18 @@  discard block
 block discarded – undo
2523 2610
 	{
2524 2611
 		// Loop through the attach directory array to count any sub-directories
2525 2612
 		$expected_dirs = 0;
2526
-		foreach ($modSettings['attachmentUploadDir'] as $sid => $sub)
2527
-			if (strpos($sub, $dir . DIRECTORY_SEPARATOR) !== false)
2613
+		foreach ($modSettings['attachmentUploadDir'] as $sid => $sub) {
2614
+					if (strpos($sub, $dir . DIRECTORY_SEPARATOR) !== false)
2528 2615
 				$expected_dirs++;
2616
+		}
2529 2617
 
2530
-		if (!is_dir($dir))
2531
-			$status = 'does_not_exist';
2532
-		elseif (!is_writeable($dir))
2533
-			$status = 'not_writable';
2534
-		else
2535
-			$status = 'ok';
2618
+		if (!is_dir($dir)) {
2619
+					$status = 'does_not_exist';
2620
+		} elseif (!is_writeable($dir)) {
2621
+					$status = 'not_writable';
2622
+		} else {
2623
+					$status = 'ok';
2624
+		}
2536 2625
 
2537 2626
 		$basedirs[] = array(
2538 2627
 			'id' => $id,
@@ -2543,14 +2632,15 @@  discard block
 block discarded – undo
2543 2632
 		);
2544 2633
 	}
2545 2634
 
2546
-	if (isset($_REQUEST['new_base_path']))
2547
-		$basedirs[] = array(
2635
+	if (isset($_REQUEST['new_base_path'])) {
2636
+			$basedirs[] = array(
2548 2637
 			'id' => '',
2549 2638
 			'current' => false,
2550 2639
 			'path' => '<input type="text" name="new_base_dir" value="" size="40">',
2551 2640
 			'num_dirs' => '',
2552 2641
 			'status' => '',
2553 2642
 		);
2643
+	}
2554 2644
 
2555 2645
 	return $basedirs;
2556 2646
 }
@@ -2566,10 +2656,11 @@  discard block
 block discarded – undo
2566 2656
  */
2567 2657
 function attachDirStatus($dir, $expected_files)
2568 2658
 {
2569
-	if (!is_dir($dir))
2570
-		return array('does_not_exist', true, '');
2571
-	elseif (!is_writable($dir))
2572
-		return array('not_writable', true, '');
2659
+	if (!is_dir($dir)) {
2660
+			return array('does_not_exist', true, '');
2661
+	} elseif (!is_writable($dir)) {
2662
+			return array('not_writable', true, '');
2663
+	}
2573 2664
 
2574 2665
 	// Everything is okay so far, start to scan through the directory.
2575 2666
 	$num_files = 0;
@@ -2577,22 +2668,26 @@  discard block
 block discarded – undo
2577 2668
 	while ($file = $dir_handle->read())
2578 2669
 	{
2579 2670
 		// Now do we have a real file here?
2580
-		if (in_array($file, array('.', '..', '.htaccess', 'index.php')))
2581
-			continue;
2671
+		if (in_array($file, array('.', '..', '.htaccess', 'index.php'))) {
2672
+					continue;
2673
+		}
2582 2674
 
2583 2675
 		$num_files++;
2584 2676
 	}
2585 2677
 	$dir_handle->close();
2586 2678
 
2587
-	if ($num_files < $expected_files)
2588
-		return array('files_missing', true, $num_files);
2679
+	if ($num_files < $expected_files) {
2680
+			return array('files_missing', true, $num_files);
2681
+	}
2589 2682
 	// Empty?
2590
-	elseif ($expected_files == 0)
2591
-		return array('unused', false, $num_files);
2683
+	elseif ($expected_files == 0) {
2684
+			return array('unused', false, $num_files);
2685
+	}
2592 2686
 	// All good!
2593
-	else
2594
-		return array('ok', false, $num_files);
2595
-}
2687
+	else {
2688
+			return array('ok', false, $num_files);
2689
+	}
2690
+	}
2596 2691
 
2597 2692
 /**
2598 2693
  * Maintance function to move attachments from one directory to another
@@ -2604,10 +2699,11 @@  discard block
 block discarded – undo
2604 2699
 	checkSession();
2605 2700
 
2606 2701
 	$modSettings['attachmentUploadDir'] = $smcFunc['json_decode']($modSettings['attachmentUploadDir'], true);
2607
-	if (!empty($modSettings['attachment_basedirectories']))
2608
-		$modSettings['attachment_basedirectories'] = $smcFunc['json_decode']($modSettings['attachment_basedirectories'], true);
2609
-	else
2610
-		$modSettings['basedirectory_for_attachments'] = array();
2702
+	if (!empty($modSettings['attachment_basedirectories'])) {
2703
+			$modSettings['attachment_basedirectories'] = $smcFunc['json_decode']($modSettings['attachment_basedirectories'], true);
2704
+	} else {
2705
+			$modSettings['basedirectory_for_attachments'] = array();
2706
+	}
2611 2707
 
2612 2708
 	$_POST['from'] = (int) $_POST['from'];
2613 2709
 	$_POST['auto'] = !empty($_POST['auto']) ? (int) $_POST['auto'] : 0;
@@ -2621,11 +2717,13 @@  discard block
 block discarded – undo
2621 2717
 	$total_moved = 0;
2622 2718
 	$total_not_moved = 0;
2623 2719
 
2624
-	if (empty($_POST['from']) || (empty($_POST['auto']) && empty($_POST['to'])))
2625
-		$results[] = $txt['attachment_transfer_no_dir'];
2720
+	if (empty($_POST['from']) || (empty($_POST['auto']) && empty($_POST['to']))) {
2721
+			$results[] = $txt['attachment_transfer_no_dir'];
2722
+	}
2626 2723
 
2627
-	if ($_POST['from'] == $_POST['to'])
2628
-		$results[] = $txt['attachment_transfer_same_dir'];
2724
+	if ($_POST['from'] == $_POST['to']) {
2725
+			$results[] = $txt['attachment_transfer_same_dir'];
2726
+	}
2629 2727
 
2630 2728
 	if (empty($results))
2631 2729
 	{
@@ -2644,8 +2742,9 @@  discard block
 block discarded – undo
2644 2742
 		$smcFunc['db_free_result']($request);
2645 2743
 		$total_progress -= $start;
2646 2744
 
2647
-		if ($total_progress < 1)
2648
-			$results[] = $txt['attachment_transfer_no_find'];
2745
+		if ($total_progress < 1) {
2746
+					$results[] = $txt['attachment_transfer_no_find'];
2747
+		}
2649 2748
 	}
2650 2749
 
2651 2750
 	if (empty($results))
@@ -2661,9 +2760,9 @@  discard block
 block discarded – undo
2661 2760
 
2662 2761
 			automanage_attachments_check_directory();
2663 2762
 			$new_dir = $modSettings['currentAttachmentUploadDir'];
2763
+		} else {
2764
+					$new_dir = $_POST['to'];
2664 2765
 		}
2665
-		else
2666
-			$new_dir = $_POST['to'];
2667 2766
 
2668 2767
 		$modSettings['currentAttachmentUploadDir'] = $new_dir;
2669 2768
 
@@ -2671,8 +2770,9 @@  discard block
 block discarded – undo
2671 2770
 		while ($break == false)
2672 2771
 		{
2673 2772
 			@set_time_limit(300);
2674
-			if (function_exists('apache_reset_timeout'))
2675
-				@apache_reset_timeout();
2773
+			if (function_exists('apache_reset_timeout')) {
2774
+							@apache_reset_timeout();
2775
+			}
2676 2776
 
2677 2777
 			// If limits are set, get the file count and size for the destination folder
2678 2778
 			if ($dir_files <= 0 && (!empty($modSettings['attachmentDirSizeLimit']) || !empty($modSettings['attachmentDirFileLimit'])))
@@ -2708,13 +2808,15 @@  discard block
 block discarded – undo
2708 2808
 
2709 2809
 			if ($smcFunc['db_num_rows']($request) === 0)
2710 2810
 			{
2711
-				if (empty($current_progress))
2712
-					$results[] = $txt['attachment_transfer_no_find'];
2811
+				if (empty($current_progress)) {
2812
+									$results[] = $txt['attachment_transfer_no_find'];
2813
+				}
2713 2814
 				break;
2714 2815
 			}
2715 2816
 
2716
-			if ($smcFunc['db_num_rows']($request) < $limit)
2717
-				$break = true;
2817
+			if ($smcFunc['db_num_rows']($request) < $limit) {
2818
+							$break = true;
2819
+			}
2718 2820
 
2719 2821
 			// Move them
2720 2822
 			$moved = array();
@@ -2738,8 +2840,9 @@  discard block
 block discarded – undo
2738 2840
 							automanage_attachments_by_space();
2739 2841
 
2740 2842
 							$results[] = sprintf($txt['attachments_transferred'], $total_moved, $modSettings['attachmentUploadDir'][$new_dir]);
2741
-							if (!empty($total_not_moved))
2742
-								$results[] = sprintf($txt['attachments_not_transferred'], $total_not_moved);
2843
+							if (!empty($total_not_moved)) {
2844
+															$results[] = sprintf($txt['attachments_not_transferred'], $total_not_moved);
2845
+							}
2743 2846
 
2744 2847
 							$dir_files = 0;
2745 2848
 							$total_moved = 0;
@@ -2747,8 +2850,7 @@  discard block
 block discarded – undo
2747 2850
 
2748 2851
 							$break = false;
2749 2852
 							break;
2750
-						}
2751
-						else
2853
+						} else
2752 2854
 						{
2753 2855
 							// Hmm, not in auto. Time to bail out then...
2754 2856
 							$results[] = $txt['attachment_transfer_no_room'];
@@ -2763,9 +2865,9 @@  discard block
 block discarded – undo
2763 2865
 					$total_moved++;
2764 2866
 					$current_progress++;
2765 2867
 					$moved[] = $row['id_attach'];
2868
+				} else {
2869
+									$total_not_moved++;
2766 2870
 				}
2767
-				else
2768
-					$total_not_moved++;
2769 2871
 			}
2770 2872
 			$smcFunc['db_free_result']($request);
2771 2873
 
@@ -2803,13 +2905,15 @@  discard block
 block discarded – undo
2803 2905
 		}
2804 2906
 
2805 2907
 		$results[] = sprintf($txt['attachments_transferred'], $total_moved, $modSettings['attachmentUploadDir'][$new_dir]);
2806
-		if (!empty($total_not_moved))
2807
-			$results[] = sprintf($txt['attachments_not_transferred'], $total_not_moved);
2908
+		if (!empty($total_not_moved)) {
2909
+					$results[] = sprintf($txt['attachments_not_transferred'], $total_not_moved);
2910
+		}
2808 2911
 	}
2809 2912
 
2810 2913
 	$_SESSION['results'] = $results;
2811
-	if (file_exists($boarddir . '/progress.php'))
2812
-		unlink($boarddir . '/progress.php');
2914
+	if (file_exists($boarddir . '/progress.php')) {
2915
+			unlink($boarddir . '/progress.php');
2916
+	}
2813 2917
 
2814 2918
 	redirectexit('action=admin;area=manageattachments;sa=maintenance#transfer');
2815 2919
 }
Please login to merge, or discard this patch.
Sources/ManageMaintenance.php 1 patch
Braces   +266 added lines, -197 removed lines patch added patch discarded remove patch
@@ -13,8 +13,9 @@  discard block
 block discarded – undo
13 13
  * @version 2.1 Beta 4
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
  * Main dispatcher, the maintenance access point.
@@ -96,14 +97,16 @@  discard block
 block discarded – undo
96 97
 	call_integration_hook('integrate_manage_maintenance', array(&$subActions));
97 98
 
98 99
 	// Yep, sub-action time!
99
-	if (isset($_REQUEST['sa']) && isset($subActions[$_REQUEST['sa']]))
100
-		$subAction = $_REQUEST['sa'];
101
-	else
102
-		$subAction = 'routine';
100
+	if (isset($_REQUEST['sa']) && isset($subActions[$_REQUEST['sa']])) {
101
+			$subAction = $_REQUEST['sa'];
102
+	} else {
103
+			$subAction = 'routine';
104
+	}
103 105
 
104 106
 	// Doing something special?
105
-	if (isset($_REQUEST['activity']) && isset($subActions[$subAction]['activities'][$_REQUEST['activity']]))
106
-		$activity = $_REQUEST['activity'];
107
+	if (isset($_REQUEST['activity']) && isset($subActions[$subAction]['activities'][$_REQUEST['activity']])) {
108
+			$activity = $_REQUEST['activity'];
109
+	}
107 110
 
108 111
 	// Set a few things.
109 112
 	$context['page_title'] = $txt['maintain_title'];
@@ -114,12 +117,14 @@  discard block
 block discarded – undo
114 117
 	call_helper($subActions[$subAction]['function']);
115 118
 
116 119
 	// Any special activity?
117
-	if (isset($activity))
118
-		call_helper($subActions[$subAction]['activities'][$activity]);
120
+	if (isset($activity)) {
121
+			call_helper($subActions[$subAction]['activities'][$activity]);
122
+	}
119 123
 
120 124
 	//converted to UTF-8? show a small maintenance info
121
-	if (isset($_GET['done']) && $_GET['done'] == 'convertutf8')
122
-		$context['maintenance_finished'] = $txt['utf8_title'];
125
+	if (isset($_GET['done']) && $_GET['done'] == 'convertutf8') {
126
+			$context['maintenance_finished'] = $txt['utf8_title'];
127
+	}
123 128
 
124 129
 	// Create a maintenance token.  Kinda hard to do it any other way.
125 130
 	createToken('admin-maint');
@@ -141,19 +146,22 @@  discard block
 block discarded – undo
141 146
 		db_extend('packages');
142 147
 
143 148
 		$colData = $smcFunc['db_list_columns']('{db_prefix}messages', true);
144
-		foreach ($colData as $column)
145
-			if ($column['name'] == 'body')
149
+		foreach ($colData as $column) {
150
+					if ($column['name'] == 'body')
146 151
 				$body_type = $column['type'];
152
+		}
147 153
 
148 154
 		$context['convert_to'] = $body_type == 'text' ? 'mediumtext' : 'text';
149 155
 		$context['convert_to_suggest'] = ($body_type != 'text' && !empty($modSettings['max_messageLength']) && $modSettings['max_messageLength'] < 65536);
150 156
 	}
151 157
 
152
-	if (isset($_GET['done']) && $_GET['done'] == 'convertutf8')
153
-		$context['maintenance_finished'] = $txt['utf8_title'];
154
-	if (isset($_GET['done']) && $_GET['done'] == 'convertentities')
155
-		$context['maintenance_finished'] = $txt['entity_convert_title'];
156
-}
158
+	if (isset($_GET['done']) && $_GET['done'] == 'convertutf8') {
159
+			$context['maintenance_finished'] = $txt['utf8_title'];
160
+	}
161
+	if (isset($_GET['done']) && $_GET['done'] == 'convertentities') {
162
+			$context['maintenance_finished'] = $txt['entity_convert_title'];
163
+	}
164
+	}
157 165
 
158 166
 /**
159 167
  * Supporting function for the routine maintenance area.
@@ -162,9 +170,10 @@  discard block
 block discarded – undo
162 170
 {
163 171
 	global $context, $txt;
164 172
 
165
-	if (isset($_GET['done']) && $_GET['done'] == 'recount')
166
-		$context['maintenance_finished'] = $txt['maintain_recount'];
167
-}
173
+	if (isset($_GET['done']) && $_GET['done'] == 'recount') {
174
+			$context['maintenance_finished'] = $txt['maintain_recount'];
175
+	}
176
+	}
168 177
 
169 178
 /**
170 179
  * Supporting function for the members maintenance area.
@@ -195,8 +204,9 @@  discard block
 block discarded – undo
195 204
 	}
196 205
 	$smcFunc['db_free_result']($result);
197 206
 
198
-	if (isset($_GET['done']) && $_GET['done'] == 'recountposts')
199
-		$context['maintenance_finished'] = $txt['maintain_recountposts'];
207
+	if (isset($_GET['done']) && $_GET['done'] == 'recountposts') {
208
+			$context['maintenance_finished'] = $txt['maintain_recountposts'];
209
+	}
200 210
 
201 211
 	loadJavaScriptFile('suggest.js', array('defer' => false), 'smf_suggest');
202 212
 }
@@ -222,11 +232,12 @@  discard block
 block discarded – undo
222 232
 	$context['categories'] = array();
223 233
 	while ($row = $smcFunc['db_fetch_assoc']($result))
224 234
 	{
225
-		if (!isset($context['categories'][$row['id_cat']]))
226
-			$context['categories'][$row['id_cat']] = array(
235
+		if (!isset($context['categories'][$row['id_cat']])) {
236
+					$context['categories'][$row['id_cat']] = array(
227 237
 				'name' => $row['cat_name'],
228 238
 				'boards' => array()
229 239
 			);
240
+		}
230 241
 
231 242
 		$context['categories'][$row['id_cat']]['boards'][$row['id_board']] = array(
232 243
 			'id' => $row['id_board'],
@@ -239,11 +250,12 @@  discard block
 block discarded – undo
239 250
 	require_once($sourcedir . '/Subs-Boards.php');
240 251
 	sortCategories($context['categories']);
241 252
 
242
-	if (isset($_GET['done']) && $_GET['done'] == 'purgeold')
243
-		$context['maintenance_finished'] = $txt['maintain_old'];
244
-	elseif (isset($_GET['done']) && $_GET['done'] == 'massmove')
245
-		$context['maintenance_finished'] = $txt['move_topics_maintenance'];
246
-}
253
+	if (isset($_GET['done']) && $_GET['done'] == 'purgeold') {
254
+			$context['maintenance_finished'] = $txt['maintain_old'];
255
+	} elseif (isset($_GET['done']) && $_GET['done'] == 'massmove') {
256
+			$context['maintenance_finished'] = $txt['move_topics_maintenance'];
257
+	}
258
+	}
247 259
 
248 260
 /**
249 261
  * Find and fix all errors on the forum.
@@ -351,15 +363,17 @@  discard block
 block discarded – undo
351 363
 	// Show me your badge!
352 364
 	isAllowedTo('admin_forum');
353 365
 
354
-	if ($db_type != 'mysql')
355
-		return;
366
+	if ($db_type != 'mysql') {
367
+			return;
368
+	}
356 369
 
357 370
 	db_extend('packages');
358 371
 
359 372
 	$colData = $smcFunc['db_list_columns']('{db_prefix}messages', true);
360
-	foreach ($colData as $column)
361
-		if ($column['name'] == 'body')
373
+	foreach ($colData as $column) {
374
+			if ($column['name'] == 'body')
362 375
 			$body_type = $column['type'];
376
+	}
363 377
 
364 378
 	$context['convert_to'] = $body_type == 'text' ? 'mediumtext' : 'text';
365 379
 
@@ -369,33 +383,36 @@  discard block
 block discarded – undo
369 383
 		validateToken('admin-maint');
370 384
 
371 385
 		// Make it longer so we can do their limit.
372
-		if ($body_type == 'text')
373
-			$smcFunc['db_change_column']('{db_prefix}messages', 'body', array('type' => 'mediumtext'));
386
+		if ($body_type == 'text') {
387
+					$smcFunc['db_change_column']('{db_prefix}messages', 'body', array('type' => 'mediumtext'));
388
+		}
374 389
 		// Shorten the column so we can have a bit (literally per record) less space occupied
375
-		else
376
-			$smcFunc['db_change_column']('{db_prefix}messages', 'body', array('type' => 'text'));
390
+		else {
391
+					$smcFunc['db_change_column']('{db_prefix}messages', 'body', array('type' => 'text'));
392
+		}
377 393
 
378 394
 		// 3rd party integrations may be interested in knowning about this.
379 395
 		call_integration_hook('integrate_convert_msgbody', array($body_type));
380 396
 
381 397
 		$colData = $smcFunc['db_list_columns']('{db_prefix}messages', true);
382
-		foreach ($colData as $column)
383
-			if ($column['name'] == 'body')
398
+		foreach ($colData as $column) {
399
+					if ($column['name'] == 'body')
384 400
 				$body_type = $column['type'];
401
+		}
385 402
 
386 403
 		$context['maintenance_finished'] = $txt[$context['convert_to'] . '_title'];
387 404
 		$context['convert_to'] = $body_type == 'text' ? 'mediumtext' : 'text';
388 405
 		$context['convert_to_suggest'] = ($body_type != 'text' && !empty($modSettings['max_messageLength']) && $modSettings['max_messageLength'] < 65536);
389 406
 
390 407
 		return;
391
-	}
392
-	elseif ($body_type != 'text' && (!isset($_POST['do_conversion']) || isset($_POST['cont'])))
408
+	} elseif ($body_type != 'text' && (!isset($_POST['do_conversion']) || isset($_POST['cont'])))
393 409
 	{
394 410
 		checkSession();
395
-		if (empty($_REQUEST['start']))
396
-			validateToken('admin-maint');
397
-		else
398
-			validateToken('admin-convertMsg');
411
+		if (empty($_REQUEST['start'])) {
412
+					validateToken('admin-maint');
413
+		} else {
414
+					validateToken('admin-convertMsg');
415
+		}
399 416
 
400 417
 		$context['page_title'] = $txt['not_done_title'];
401 418
 		$context['continue_post_data'] = '';
@@ -427,8 +444,9 @@  discard block
 block discarded – undo
427 444
 					'increment' => $increment - 1,
428 445
 				)
429 446
 			);
430
-			while ($row = $smcFunc['db_fetch_assoc']($request))
431
-				$id_msg_exceeding[] = $row['id_msg'];
447
+			while ($row = $smcFunc['db_fetch_assoc']($request)) {
448
+							$id_msg_exceeding[] = $row['id_msg'];
449
+			}
432 450
 			$smcFunc['db_free_result']($request);
433 451
 
434 452
 			$_REQUEST['start'] += $increment;
@@ -457,9 +475,9 @@  discard block
 block discarded – undo
457 475
 			{
458 476
 				$query_msg = array_slice($id_msg_exceeding, 0, 100);
459 477
 				$context['exceeding_messages_morethan'] = sprintf($txt['exceeding_messages_morethan'], count($id_msg_exceeding));
478
+			} else {
479
+							$query_msg = $id_msg_exceeding;
460 480
 			}
461
-			else
462
-				$query_msg = $id_msg_exceeding;
463 481
 
464 482
 			$context['exceeding_messages'] = array();
465 483
 			$request = $smcFunc['db_query']('', '
@@ -470,8 +488,9 @@  discard block
 block discarded – undo
470 488
 					'messages' => $query_msg,
471 489
 				)
472 490
 			);
473
-			while ($row = $smcFunc['db_fetch_assoc']($request))
474
-				$context['exceeding_messages'][] = '<a href="' . $scripturl . '?topic=' . $row['id_topic'] . '.msg' . $row['id_msg'] . '#msg' . $row['id_msg'] . '">' . $row['subject'] . '</a>';
491
+			while ($row = $smcFunc['db_fetch_assoc']($request)) {
492
+							$context['exceeding_messages'][] = '<a href="' . $scripturl . '?topic=' . $row['id_topic'] . '.msg' . $row['id_msg'] . '#msg' . $row['id_msg'] . '">' . $row['subject'] . '</a>';
493
+			}
475 494
 			$smcFunc['db_free_result']($request);
476 495
 		}
477 496
 	}
@@ -495,8 +514,9 @@  discard block
 block discarded – undo
495 514
 	isAllowedTo('admin_forum');
496 515
 
497 516
 	// Check to see if UTF-8 is currently the default character set.
498
-	if ($modSettings['global_character_set'] !== 'UTF-8' || !isset($db_character_set) || $db_character_set !== 'utf8')
499
-		fatal_lang_error('entity_convert_only_utf8');
517
+	if ($modSettings['global_character_set'] !== 'UTF-8' || !isset($db_character_set) || $db_character_set !== 'utf8') {
518
+			fatal_lang_error('entity_convert_only_utf8');
519
+	}
500 520
 
501 521
 	// Some starting values.
502 522
 	$context['table'] = empty($_REQUEST['table']) ? 0 : (int) $_REQUEST['table'];
@@ -558,8 +578,9 @@  discard block
 block discarded – undo
558 578
 		// Make sure we keep stuff unique!
559 579
 		$primary_keys = array();
560 580
 
561
-		if (function_exists('apache_reset_timeout'))
562
-			@apache_reset_timeout();
581
+		if (function_exists('apache_reset_timeout')) {
582
+					@apache_reset_timeout();
583
+		}
563 584
 
564 585
 		// Get a list of text columns.
565 586
 		$columns = array();
@@ -570,9 +591,10 @@  discard block
 block discarded – undo
570 591
 				'cur_table' => $cur_table,
571 592
 			)
572 593
 		);
573
-		while ($column_info = $smcFunc['db_fetch_assoc']($request))
574
-			if (strpos($column_info['Type'], 'text') !== false || strpos($column_info['Type'], 'char') !== false)
594
+		while ($column_info = $smcFunc['db_fetch_assoc']($request)) {
595
+					if (strpos($column_info['Type'], 'text') !== false || strpos($column_info['Type'], 'char') !== false)
575 596
 				$columns[] = strtolower($column_info['Field']);
597
+		}
576 598
 
577 599
 		// Get the column with the (first) primary key.
578 600
 		$request = $smcFunc['db_query']('', '
@@ -586,8 +608,9 @@  discard block
 block discarded – undo
586 608
 		{
587 609
 			if ($row['Key_name'] === 'PRIMARY')
588 610
 			{
589
-				if (empty($primary_key) || ($row['Seq_in_index'] == 1 && !in_array(strtolower($row['Column_name']), $columns)))
590
-					$primary_key = $row['Column_name'];
611
+				if (empty($primary_key) || ($row['Seq_in_index'] == 1 && !in_array(strtolower($row['Column_name']), $columns))) {
612
+									$primary_key = $row['Column_name'];
613
+				}
591 614
 
592 615
 				$primary_keys[] = $row['Column_name'];
593 616
 			}
@@ -596,8 +619,9 @@  discard block
 block discarded – undo
596 619
 
597 620
 		// No primary key, no glory.
598 621
 		// Same for columns. Just to be sure we've work to do!
599
-		if (empty($primary_key) || empty($columns))
600
-			continue;
622
+		if (empty($primary_key) || empty($columns)) {
623
+					continue;
624
+		}
601 625
 
602 626
 		// Get the maximum value for the primary key.
603 627
 		$request = $smcFunc['db_query']('', '
@@ -611,8 +635,9 @@  discard block
 block discarded – undo
611 635
 		list($max_value) = $smcFunc['db_fetch_row']($request);
612 636
 		$smcFunc['db_free_result']($request);
613 637
 
614
-		if (empty($max_value))
615
-			continue;
638
+		if (empty($max_value)) {
639
+					continue;
640
+		}
616 641
 
617 642
 		while ($context['start'] <= $max_value)
618 643
 		{
@@ -636,10 +661,11 @@  discard block
 block discarded – undo
636 661
 			{
637 662
 				$insertion_variables = array();
638 663
 				$changes = array();
639
-				foreach ($row as $column_name => $column_value)
640
-					if ($column_name !== $primary_key && strpos($column_value, '&#') !== false)
664
+				foreach ($row as $column_name => $column_value) {
665
+									if ($column_name !== $primary_key && strpos($column_value, '&#') !== false)
641 666
 					{
642 667
 						$changes[] = $column_name . ' = {string:changes_' . $column_name . '}';
668
+				}
643 669
 						$insertion_variables['changes_' . $column_name] = preg_replace_callback('~&#(\d{1,7}|x[0-9a-fA-F]{1,6});~', 'fixchar__callback', $column_value);
644 670
 					}
645 671
 
@@ -651,8 +677,8 @@  discard block
 block discarded – undo
651 677
 				}
652 678
 
653 679
 				// Update the row.
654
-				if (!empty($changes))
655
-					$smcFunc['db_query']('', '
680
+				if (!empty($changes)) {
681
+									$smcFunc['db_query']('', '
656 682
 						UPDATE {db_prefix}' . $cur_table . '
657 683
 						SET
658 684
 							' . implode(',
@@ -660,6 +686,7 @@  discard block
 block discarded – undo
660 686
 						WHERE ' . implode(' AND ', $where),
661 687
 						$insertion_variables
662 688
 					);
689
+				}
663 690
 			}
664 691
 			$smcFunc['db_free_result']($request);
665 692
 			$context['start'] += 500;
@@ -700,10 +727,11 @@  discard block
 block discarded – undo
700 727
 
701 728
 	checkSession('request');
702 729
 
703
-	if (!isset($_SESSION['optimized_tables']))
704
-		validateToken('admin-maint');
705
-	else
706
-		validateToken('admin-optimize', 'post', false);
730
+	if (!isset($_SESSION['optimized_tables'])) {
731
+			validateToken('admin-maint');
732
+	} else {
733
+			validateToken('admin-optimize', 'post', false);
734
+	}
707 735
 
708 736
 	ignore_user_abort(true);
709 737
 	db_extend();
@@ -719,13 +747,15 @@  discard block
 block discarded – undo
719 747
 	// Get a list of tables, as well as how many there are.
720 748
 	$temp_tables = $smcFunc['db_list_tables'](false, $real_prefix . '%');
721 749
 	$tables = array();
722
-	foreach ($temp_tables as $table)
723
-		$tables[] = array('table_name' => $table);
750
+	foreach ($temp_tables as $table) {
751
+			$tables[] = array('table_name' => $table);
752
+	}
724 753
 
725 754
 	// If there aren't any tables then I believe that would mean the world has exploded...
726 755
 	$context['num_tables'] = count($tables);
727
-	if ($context['num_tables'] == 0)
728
-		fatal_error('You appear to be running SMF in a flat file mode... fantastic!', false);
756
+	if ($context['num_tables'] == 0) {
757
+			fatal_error('You appear to be running SMF in a flat file mode... fantastic!', false);
758
+	}
729 759
 
730 760
 	$_REQUEST['start'] = empty($_REQUEST['start']) ? 0 : (int) $_REQUEST['start'];
731 761
 
@@ -736,8 +766,9 @@  discard block
 block discarded – undo
736 766
 	$_SESSION['optimized_tables'] = !empty($_SESSION['optimized_tables']) ? $_SESSION['optimized_tables'] : array();
737 767
 	for ($key = $_REQUEST['start']; $context['num_tables'] - 1; $key++)
738 768
 	{
739
-		if (empty($tables[$key]))
740
-			break;
769
+		if (empty($tables[$key])) {
770
+					break;
771
+		}
741 772
 
742 773
 		// Continue?
743 774
 		if (microtime(true) - $time_start > 10)
@@ -751,8 +782,9 @@  discard block
 block discarded – undo
751 782
 			createToken('admin-optimize');
752 783
 			$context['continue_post_data'] = '<input type="hidden" name="' . $context['admin-optimize_token_var'] . '" value="' . $context['admin-optimize_token'] . '">';
753 784
 
754
-			if (function_exists('apache_reset_timeout'))
755
-				apache_reset_timeout();
785
+			if (function_exists('apache_reset_timeout')) {
786
+							apache_reset_timeout();
787
+			}
756 788
 
757 789
 			return;
758 790
 		}
@@ -760,11 +792,12 @@  discard block
 block discarded – undo
760 792
 		// Optimize the table!  We use backticks here because it might be a custom table.
761 793
 		$data_freed = $smcFunc['db_optimize_table']($tables[$key]['table_name']);
762 794
 
763
-		if ($data_freed > 0)
764
-			$_SESSION['optimized_tables'][] = array(
795
+		if ($data_freed > 0) {
796
+					$_SESSION['optimized_tables'][] = array(
765 797
 				'name' => $tables[$key]['table_name'],
766 798
 				'data_freed' => $data_freed,
767 799
 			);
800
+		}
768 801
 	}
769 802
 
770 803
 	// Number of tables, etc...
@@ -799,10 +832,11 @@  discard block
 block discarded – undo
799 832
 	checkSession('request');
800 833
 
801 834
 	// validate the request or the loop
802
-	if (!isset($_REQUEST['step']))
803
-		validateToken('admin-maint');
804
-	else
805
-		validateToken('admin-boardrecount');
835
+	if (!isset($_REQUEST['step'])) {
836
+			validateToken('admin-maint');
837
+	} else {
838
+			validateToken('admin-boardrecount');
839
+	}
806 840
 
807 841
 	$context['page_title'] = $txt['not_done_title'];
808 842
 	$context['continue_post_data'] = '';
@@ -823,8 +857,9 @@  discard block
 block discarded – undo
823 857
 	$smcFunc['db_free_result']($request);
824 858
 
825 859
 	$increment = min(max(50, ceil($max_topics / 4)), 2000);
826
-	if (empty($_REQUEST['start']))
827
-		$_REQUEST['start'] = 0;
860
+	if (empty($_REQUEST['start'])) {
861
+			$_REQUEST['start'] = 0;
862
+	}
828 863
 
829 864
 	$total_steps = 8;
830 865
 
@@ -851,8 +886,8 @@  discard block
 block discarded – undo
851 886
 					'max_id' => $_REQUEST['start'] + $increment,
852 887
 				)
853 888
 			);
854
-			while ($row = $smcFunc['db_fetch_assoc']($request))
855
-				$smcFunc['db_query']('', '
889
+			while ($row = $smcFunc['db_fetch_assoc']($request)) {
890
+							$smcFunc['db_query']('', '
856 891
 					UPDATE {db_prefix}topics
857 892
 					SET num_replies = {int:num_replies}
858 893
 					WHERE id_topic = {int:id_topic}',
@@ -861,6 +896,7 @@  discard block
 block discarded – undo
861 896
 						'id_topic' => $row['id_topic'],
862 897
 					)
863 898
 				);
899
+			}
864 900
 			$smcFunc['db_free_result']($request);
865 901
 
866 902
 			// Recount unapproved messages
@@ -879,8 +915,8 @@  discard block
 block discarded – undo
879 915
 					'max_id' => $_REQUEST['start'] + $increment,
880 916
 				)
881 917
 			);
882
-			while ($row = $smcFunc['db_fetch_assoc']($request))
883
-				$smcFunc['db_query']('', '
918
+			while ($row = $smcFunc['db_fetch_assoc']($request)) {
919
+							$smcFunc['db_query']('', '
884 920
 					UPDATE {db_prefix}topics
885 921
 					SET unapproved_posts = {int:unapproved_posts}
886 922
 					WHERE id_topic = {int:id_topic}',
@@ -889,6 +925,7 @@  discard block
 block discarded – undo
889 925
 						'id_topic' => $row['id_topic'],
890 926
 					)
891 927
 				);
928
+			}
892 929
 			$smcFunc['db_free_result']($request);
893 930
 
894 931
 			$_REQUEST['start'] += $increment;
@@ -911,8 +948,8 @@  discard block
 block discarded – undo
911 948
 	// Update the post count of each board.
912 949
 	if ($_REQUEST['step'] <= 1)
913 950
 	{
914
-		if (empty($_REQUEST['start']))
915
-			$smcFunc['db_query']('', '
951
+		if (empty($_REQUEST['start'])) {
952
+					$smcFunc['db_query']('', '
916 953
 				UPDATE {db_prefix}boards
917 954
 				SET num_posts = {int:num_posts}
918 955
 				WHERE redirect = {string:redirect}',
@@ -921,6 +958,7 @@  discard block
 block discarded – undo
921 958
 					'redirect' => '',
922 959
 				)
923 960
 			);
961
+		}
924 962
 
925 963
 		while ($_REQUEST['start'] < $max_topics)
926 964
 		{
@@ -937,8 +975,8 @@  discard block
 block discarded – undo
937 975
 					'is_approved' => 1,
938 976
 				)
939 977
 			);
940
-			while ($row = $smcFunc['db_fetch_assoc']($request))
941
-				$smcFunc['db_query']('', '
978
+			while ($row = $smcFunc['db_fetch_assoc']($request)) {
979
+							$smcFunc['db_query']('', '
942 980
 					UPDATE {db_prefix}boards
943 981
 					SET num_posts = num_posts + {int:real_num_posts}
944 982
 					WHERE id_board = {int:id_board}',
@@ -947,6 +985,7 @@  discard block
 block discarded – undo
947 985
 						'real_num_posts' => $row['real_num_posts'],
948 986
 					)
949 987
 				);
988
+			}
950 989
 			$smcFunc['db_free_result']($request);
951 990
 
952 991
 			$_REQUEST['start'] += $increment;
@@ -969,14 +1008,15 @@  discard block
 block discarded – undo
969 1008
 	// Update the topic count of each board.
970 1009
 	if ($_REQUEST['step'] <= 2)
971 1010
 	{
972
-		if (empty($_REQUEST['start']))
973
-			$smcFunc['db_query']('', '
1011
+		if (empty($_REQUEST['start'])) {
1012
+					$smcFunc['db_query']('', '
974 1013
 				UPDATE {db_prefix}boards
975 1014
 				SET num_topics = {int:num_topics}',
976 1015
 				array(
977 1016
 					'num_topics' => 0,
978 1017
 				)
979 1018
 			);
1019
+		}
980 1020
 
981 1021
 		while ($_REQUEST['start'] < $max_topics)
982 1022
 		{
@@ -993,8 +1033,8 @@  discard block
 block discarded – undo
993 1033
 					'id_topic_max' => $_REQUEST['start'] + $increment,
994 1034
 				)
995 1035
 			);
996
-			while ($row = $smcFunc['db_fetch_assoc']($request))
997
-				$smcFunc['db_query']('', '
1036
+			while ($row = $smcFunc['db_fetch_assoc']($request)) {
1037
+							$smcFunc['db_query']('', '
998 1038
 					UPDATE {db_prefix}boards
999 1039
 					SET num_topics = num_topics + {int:real_num_topics}
1000 1040
 					WHERE id_board = {int:id_board}',
@@ -1003,6 +1043,7 @@  discard block
 block discarded – undo
1003 1043
 						'real_num_topics' => $row['real_num_topics'],
1004 1044
 					)
1005 1045
 				);
1046
+			}
1006 1047
 			$smcFunc['db_free_result']($request);
1007 1048
 
1008 1049
 			$_REQUEST['start'] += $increment;
@@ -1025,14 +1066,15 @@  discard block
 block discarded – undo
1025 1066
 	// Update the unapproved post count of each board.
1026 1067
 	if ($_REQUEST['step'] <= 3)
1027 1068
 	{
1028
-		if (empty($_REQUEST['start']))
1029
-			$smcFunc['db_query']('', '
1069
+		if (empty($_REQUEST['start'])) {
1070
+					$smcFunc['db_query']('', '
1030 1071
 				UPDATE {db_prefix}boards
1031 1072
 				SET unapproved_posts = {int:unapproved_posts}',
1032 1073
 				array(
1033 1074
 					'unapproved_posts' => 0,
1034 1075
 				)
1035 1076
 			);
1077
+		}
1036 1078
 
1037 1079
 		while ($_REQUEST['start'] < $max_topics)
1038 1080
 		{
@@ -1049,8 +1091,8 @@  discard block
 block discarded – undo
1049 1091
 					'is_approved' => 0,
1050 1092
 				)
1051 1093
 			);
1052
-			while ($row = $smcFunc['db_fetch_assoc']($request))
1053
-				$smcFunc['db_query']('', '
1094
+			while ($row = $smcFunc['db_fetch_assoc']($request)) {
1095
+							$smcFunc['db_query']('', '
1054 1096
 					UPDATE {db_prefix}boards
1055 1097
 					SET unapproved_posts = unapproved_posts + {int:unapproved_posts}
1056 1098
 					WHERE id_board = {int:id_board}',
@@ -1059,6 +1101,7 @@  discard block
 block discarded – undo
1059 1101
 						'unapproved_posts' => $row['real_unapproved_posts'],
1060 1102
 					)
1061 1103
 				);
1104
+			}
1062 1105
 			$smcFunc['db_free_result']($request);
1063 1106
 
1064 1107
 			$_REQUEST['start'] += $increment;
@@ -1081,14 +1124,15 @@  discard block
 block discarded – undo
1081 1124
 	// Update the unapproved topic count of each board.
1082 1125
 	if ($_REQUEST['step'] <= 4)
1083 1126
 	{
1084
-		if (empty($_REQUEST['start']))
1085
-			$smcFunc['db_query']('', '
1127
+		if (empty($_REQUEST['start'])) {
1128
+					$smcFunc['db_query']('', '
1086 1129
 				UPDATE {db_prefix}boards
1087 1130
 				SET unapproved_topics = {int:unapproved_topics}',
1088 1131
 				array(
1089 1132
 					'unapproved_topics' => 0,
1090 1133
 				)
1091 1134
 			);
1135
+		}
1092 1136
 
1093 1137
 		while ($_REQUEST['start'] < $max_topics)
1094 1138
 		{
@@ -1105,8 +1149,8 @@  discard block
 block discarded – undo
1105 1149
 					'id_topic_max' => $_REQUEST['start'] + $increment,
1106 1150
 				)
1107 1151
 			);
1108
-			while ($row = $smcFunc['db_fetch_assoc']($request))
1109
-				$smcFunc['db_query']('', '
1152
+			while ($row = $smcFunc['db_fetch_assoc']($request)) {
1153
+							$smcFunc['db_query']('', '
1110 1154
 					UPDATE {db_prefix}boards
1111 1155
 					SET unapproved_topics = unapproved_topics + {int:real_unapproved_topics}
1112 1156
 					WHERE id_board = {int:id_board}',
@@ -1115,6 +1159,7 @@  discard block
 block discarded – undo
1115 1159
 						'real_unapproved_topics' => $row['real_unapproved_topics'],
1116 1160
 					)
1117 1161
 				);
1162
+			}
1118 1163
 			$smcFunc['db_free_result']($request);
1119 1164
 
1120 1165
 			$_REQUEST['start'] += $increment;
@@ -1148,8 +1193,9 @@  discard block
 block discarded – undo
1148 1193
 				'is_not_deleted' => 0,
1149 1194
 			)
1150 1195
 		);
1151
-		while ($row = $smcFunc['db_fetch_assoc']($request))
1152
-			updateMemberData($row['id_member'], array('instant_messages' => $row['real_num']));
1196
+		while ($row = $smcFunc['db_fetch_assoc']($request)) {
1197
+					updateMemberData($row['id_member'], array('instant_messages' => $row['real_num']));
1198
+		}
1153 1199
 		$smcFunc['db_free_result']($request);
1154 1200
 
1155 1201
 		$request = $smcFunc['db_query']('', '
@@ -1164,8 +1210,9 @@  discard block
 block discarded – undo
1164 1210
 				'is_not_read' => 0,
1165 1211
 			)
1166 1212
 		);
1167
-		while ($row = $smcFunc['db_fetch_assoc']($request))
1168
-			updateMemberData($row['id_member'], array('unread_messages' => $row['real_num']));
1213
+		while ($row = $smcFunc['db_fetch_assoc']($request)) {
1214
+					updateMemberData($row['id_member'], array('unread_messages' => $row['real_num']));
1215
+		}
1169 1216
 		$smcFunc['db_free_result']($request);
1170 1217
 
1171 1218
 		if (microtime(true) - $time_start > 3)
@@ -1197,12 +1244,13 @@  discard block
 block discarded – undo
1197 1244
 				)
1198 1245
 			);
1199 1246
 			$boards = array();
1200
-			while ($row = $smcFunc['db_fetch_assoc']($request))
1201
-				$boards[$row['id_board']][] = $row['id_msg'];
1247
+			while ($row = $smcFunc['db_fetch_assoc']($request)) {
1248
+							$boards[$row['id_board']][] = $row['id_msg'];
1249
+			}
1202 1250
 			$smcFunc['db_free_result']($request);
1203 1251
 
1204
-			foreach ($boards as $board_id => $messages)
1205
-				$smcFunc['db_query']('', '
1252
+			foreach ($boards as $board_id => $messages) {
1253
+							$smcFunc['db_query']('', '
1206 1254
 					UPDATE {db_prefix}messages
1207 1255
 					SET id_board = {int:id_board}
1208 1256
 					WHERE id_msg IN ({array_int:id_msg_array})',
@@ -1211,6 +1259,7 @@  discard block
 block discarded – undo
1211 1259
 						'id_board' => $board_id,
1212 1260
 					)
1213 1261
 				);
1262
+			}
1214 1263
 
1215 1264
 			$_REQUEST['start'] += $increment;
1216 1265
 
@@ -1240,8 +1289,9 @@  discard block
 block discarded – undo
1240 1289
 		)
1241 1290
 	);
1242 1291
 	$realBoardCounts = array();
1243
-	while ($row = $smcFunc['db_fetch_assoc']($request))
1244
-		$realBoardCounts[$row['id_board']] = $row['local_last_msg'];
1292
+	while ($row = $smcFunc['db_fetch_assoc']($request)) {
1293
+			$realBoardCounts[$row['id_board']] = $row['local_last_msg'];
1294
+	}
1245 1295
 	$smcFunc['db_free_result']($request);
1246 1296
 
1247 1297
 	$request = $smcFunc['db_query']('', '
@@ -1261,18 +1311,20 @@  discard block
 block discarded – undo
1261 1311
 	krsort($resort_me);
1262 1312
 
1263 1313
 	$lastModifiedMsg = array();
1264
-	foreach ($resort_me as $rows)
1265
-		foreach ($rows as $row)
1314
+	foreach ($resort_me as $rows) {
1315
+			foreach ($rows as $row)
1266 1316
 		{
1267 1317
 			// The latest message is the latest of the current board and its children.
1268 1318
 			if (isset($lastModifiedMsg[$row['id_board']]))
1269 1319
 				$curLastModifiedMsg = max($row['local_last_msg'], $lastModifiedMsg[$row['id_board']]);
1270
-			else
1271
-				$curLastModifiedMsg = $row['local_last_msg'];
1320
+	}
1321
+			else {
1322
+							$curLastModifiedMsg = $row['local_last_msg'];
1323
+			}
1272 1324
 
1273 1325
 			// If what is and what should be the latest message differ, an update is necessary.
1274
-			if ($row['local_last_msg'] != $row['id_last_msg'] || $curLastModifiedMsg != $row['id_msg_updated'])
1275
-				$smcFunc['db_query']('', '
1326
+			if ($row['local_last_msg'] != $row['id_last_msg'] || $curLastModifiedMsg != $row['id_msg_updated']) {
1327
+							$smcFunc['db_query']('', '
1276 1328
 					UPDATE {db_prefix}boards
1277 1329
 					SET id_last_msg = {int:id_last_msg}, id_msg_updated = {int:id_msg_updated}
1278 1330
 					WHERE id_board = {int:id_board}',
@@ -1282,12 +1334,14 @@  discard block
 block discarded – undo
1282 1334
 						'id_board' => $row['id_board'],
1283 1335
 					)
1284 1336
 				);
1337
+			}
1285 1338
 
1286 1339
 			// Parent boards inherit the latest modified message of their children.
1287
-			if (isset($lastModifiedMsg[$row['id_parent']]))
1288
-				$lastModifiedMsg[$row['id_parent']] = max($row['local_last_msg'], $lastModifiedMsg[$row['id_parent']]);
1289
-			else
1290
-				$lastModifiedMsg[$row['id_parent']] = $row['local_last_msg'];
1340
+			if (isset($lastModifiedMsg[$row['id_parent']])) {
1341
+							$lastModifiedMsg[$row['id_parent']] = max($row['local_last_msg'], $lastModifiedMsg[$row['id_parent']]);
1342
+			} else {
1343
+							$lastModifiedMsg[$row['id_parent']] = $row['local_last_msg'];
1344
+			}
1291 1345
 		}
1292 1346
 
1293 1347
 	// Update all the basic statistics.
@@ -1359,8 +1413,9 @@  discard block
 block discarded – undo
1359 1413
 	require_once($sourcedir . '/Subs-Auth.php');
1360 1414
 	$members = findMembers($_POST['to']);
1361 1415
 
1362
-	if (empty($members))
1363
-		fatal_lang_error('reattribute_cannot_find_member');
1416
+	if (empty($members)) {
1417
+			fatal_lang_error('reattribute_cannot_find_member');
1418
+	}
1364 1419
 
1365 1420
 	$memID = array_shift($members);
1366 1421
 	$memID = $memID['id'];
@@ -1390,8 +1445,9 @@  discard block
 block discarded – undo
1390 1445
 		validateToken('admin-maint');
1391 1446
 
1392 1447
 		$groups = array();
1393
-		foreach ($_POST['groups'] as $id => $dummy)
1394
-			$groups[] = (int) $id;
1448
+		foreach ($_POST['groups'] as $id => $dummy) {
1449
+					$groups[] = (int) $id;
1450
+		}
1395 1451
 		$time_limit = (time() - ($_POST['maxdays'] * 24 * 3600));
1396 1452
 		$where_vars = array(
1397 1453
 			'time_limit' => $time_limit,
@@ -1400,9 +1456,9 @@  discard block
 block discarded – undo
1400 1456
 		{
1401 1457
 			$where = 'mem.date_registered < {int:time_limit} AND mem.is_activated = {int:is_activated}';
1402 1458
 			$where_vars['is_activated'] = 0;
1459
+		} else {
1460
+					$where = 'mem.last_login < {int:time_limit} AND (mem.last_login != 0 OR mem.date_registered < {int:time_limit})';
1403 1461
 		}
1404
-		else
1405
-			$where = 'mem.last_login < {int:time_limit} AND (mem.last_login != 0 OR mem.date_registered < {int:time_limit})';
1406 1462
 
1407 1463
 		// Need to get *all* groups then work out which (if any) we avoid.
1408 1464
 		$request = $smcFunc['db_query']('', '
@@ -1421,8 +1477,7 @@  discard block
 block discarded – undo
1421 1477
 				{
1422 1478
 					$where .= ' AND mem.id_post_group != {int:id_post_group_' . $row['id_group'] . '}';
1423 1479
 					$where_vars['id_post_group_' . $row['id_group']] = $row['id_group'];
1424
-				}
1425
-				else
1480
+				} else
1426 1481
 				{
1427 1482
 					$where .= ' AND mem.id_group != {int:id_group_' . $row['id_group'] . '} AND FIND_IN_SET({int:id_group_' . $row['id_group'] . '}, mem.additional_groups) = 0';
1428 1483
 					$where_vars['id_group_' . $row['id_group']] = $row['id_group'];
@@ -1449,8 +1504,9 @@  discard block
 block discarded – undo
1449 1504
 		$members = array();
1450 1505
 		while ($row = $smcFunc['db_fetch_assoc']($request))
1451 1506
 		{
1452
-			if (!$row['is_mod'] || !in_array(3, $groups))
1453
-				$members[] = $row['id_member'];
1507
+			if (!$row['is_mod'] || !in_array(3, $groups)) {
1508
+							$members[] = $row['id_member'];
1509
+			}
1454 1510
 		}
1455 1511
 		$smcFunc['db_free_result']($request);
1456 1512
 
@@ -1497,8 +1553,9 @@  discard block
 block discarded – undo
1497 1553
 		)
1498 1554
 	);
1499 1555
 
1500
-	while ($row = $smcFunc['db_fetch_row']($request))
1501
-		$drafts[] = (int) $row[0];
1556
+	while ($row = $smcFunc['db_fetch_row']($request)) {
1557
+			$drafts[] = (int) $row[0];
1558
+	}
1502 1559
 	$smcFunc['db_free_result']($request);
1503 1560
 
1504 1561
 	// If we have old drafts, remove them
@@ -1541,8 +1598,9 @@  discard block
 block discarded – undo
1541 1598
 	$sticky = isset($_POST['move_type_sticky']) || isset($_GET['sticky']);
1542 1599
 
1543 1600
 	// No boards then this is your stop.
1544
-	if (empty($id_board_from) || empty($id_board_to))
1545
-		return;
1601
+	if (empty($id_board_from) || empty($id_board_to)) {
1602
+			return;
1603
+	}
1546 1604
 
1547 1605
 	// The big WHERE clause
1548 1606
 	$conditions = 'WHERE t.id_board = {int:id_board_from}
@@ -1590,18 +1648,20 @@  discard block
 block discarded – undo
1590 1648
 		);
1591 1649
 		list ($total_topics) = $smcFunc['db_fetch_row']($request);
1592 1650
 		$smcFunc['db_free_result']($request);
1651
+	} else {
1652
+			$total_topics = (int) $_REQUEST['totaltopics'];
1593 1653
 	}
1594
-	else
1595
-		$total_topics = (int) $_REQUEST['totaltopics'];
1596 1654
 
1597 1655
 	// Seems like we need this here.
1598 1656
 	$context['continue_get_data'] = '?action=admin;area=maintain;sa=topics;activity=massmove;id_board_from=' . $id_board_from . ';id_board_to=' . $id_board_to . ';totaltopics=' . $total_topics . ';max_days=' . $max_days;
1599 1657
 
1600
-	if ($locked)
1601
-		$context['continue_get_data'] .= ';locked';
1658
+	if ($locked) {
1659
+			$context['continue_get_data'] .= ';locked';
1660
+	}
1602 1661
 
1603
-	if ($sticky)
1604
-		$context['continue_get_data'] .= ';sticky';
1662
+	if ($sticky) {
1663
+			$context['continue_get_data'] .= ';sticky';
1664
+	}
1605 1665
 
1606 1666
 	$context['continue_get_data'] .= ';start=' . $context['start'] . ';' . $context['session_var'] . '=' . $context['session_id'];
1607 1667
 
@@ -1622,8 +1682,9 @@  discard block
 block discarded – undo
1622 1682
 
1623 1683
 			// Get the ids.
1624 1684
 			$topics = array();
1625
-			while ($row = $smcFunc['db_fetch_assoc']($request))
1626
-				$topics[] = $row['id_topic'];
1685
+			while ($row = $smcFunc['db_fetch_assoc']($request)) {
1686
+							$topics[] = $row['id_topic'];
1687
+			}
1627 1688
 
1628 1689
 			// Just return if we don't have any topics left to move.
1629 1690
 			if (empty($topics))
@@ -1714,9 +1775,9 @@  discard block
 block discarded – undo
1714 1775
 		// save it so we don't do this again for this task
1715 1776
 		list ($_SESSION['total_members']) = $smcFunc['db_fetch_row']($request);
1716 1777
 		$smcFunc['db_free_result']($request);
1778
+	} else {
1779
+			validateToken('admin-recountposts');
1717 1780
 	}
1718
-	else
1719
-		validateToken('admin-recountposts');
1720 1781
 
1721 1782
 	// Lets get a group of members and determine their post count (from the boards that have post count enabled of course).
1722 1783
 	$request = $smcFunc['db_query']('', '
@@ -1762,8 +1823,9 @@  discard block
 block discarded – undo
1762 1823
 		createToken('admin-recountposts');
1763 1824
 		$context['continue_post_data'] = '<input type="hidden" name="' . $context['admin-recountposts_token_var'] . '" value="' . $context['admin-recountposts_token'] . '">';
1764 1825
 
1765
-		if (function_exists('apache_reset_timeout'))
1766
-			apache_reset_timeout();
1826
+		if (function_exists('apache_reset_timeout')) {
1827
+					apache_reset_timeout();
1828
+		}
1767 1829
 		return;
1768 1830
 	}
1769 1831
 
@@ -1849,10 +1911,9 @@  discard block
 block discarded – undo
1849 1911
 		checkSession('request');
1850 1912
 		validateToken('admin-hook', 'request');
1851 1913
 
1852
-		if ($_REQUEST['do'] == 'remove')
1853
-			remove_integration_function($_REQUEST['hook'], urldecode($_REQUEST['function']));
1854
-
1855
-		else
1914
+		if ($_REQUEST['do'] == 'remove') {
1915
+					remove_integration_function($_REQUEST['hook'], urldecode($_REQUEST['function']));
1916
+		} else
1856 1917
 		{
1857 1918
 			$function_remove = urldecode($_REQUEST['function']) . (($_REQUEST['do'] == 'disable') ? '' : '!');
1858 1919
 			$function_add = urldecode($_REQUEST['function']) . (($_REQUEST['do'] == 'disable') ? '!' : '');
@@ -1902,11 +1963,11 @@  discard block
 block discarded – undo
1902 1963
 						// Show a nice icon to indicate this is an instance.
1903 1964
 						$instance = (!empty($data['instance']) ? '<span class="generic_icons news" title="' . $txt['hooks_field_function_method'] . '"></span> ' : '');
1904 1965
 
1905
-						if (!empty($data['included_file']))
1906
-							return $instance . $txt['hooks_field_function'] . ': ' . $data['real_function'] . '<br>' . $txt['hooks_field_included_file'] . ': ' . $data['included_file'];
1907
-
1908
-						else
1909
-							return $instance . $data['real_function'];
1966
+						if (!empty($data['included_file'])) {
1967
+													return $instance . $txt['hooks_field_function'] . ': ' . $data['real_function'] . '<br>' . $txt['hooks_field_included_file'] . ': ' . $data['included_file'];
1968
+						} else {
1969
+													return $instance . $data['real_function'];
1970
+						}
1910 1971
 					},
1911 1972
 				),
1912 1973
 				'sort' =>  array(
@@ -1971,11 +2032,12 @@  discard block
 block discarded – undo
1971 2032
 		'data' => array(
1972 2033
 			'function' => function($data) use ($txt, $scripturl, $context)
1973 2034
 			{
1974
-				if (!$data['hook_exists'])
1975
-					return '
2035
+				if (!$data['hook_exists']) {
2036
+									return '
1976 2037
 					<a href="' . $scripturl . '?action=admin;area=maintain;sa=hooks;do=remove;hook=' . $data['hook_name'] . ';function=' . urlencode($data['function_name']) . $context['filter_url'] . ';' . $context['admin-hook_token_var'] . '=' . $context['admin-hook_token'] . ';' . $context['session_var'] . '=' . $context['session_id'] . '" data-confirm="' . $txt['quickmod_confirm'] . '" class="you_sure">
1977 2038
 						<span class="generic_icons delete" title="' . $txt['hooks_button_remove'] . '"></span>
1978 2039
 					</a>';
2040
+				}
1979 2041
 			},
1980 2042
 			'class' => 'centertext',
1981 2043
 		),
@@ -2010,10 +2072,11 @@  discard block
 block discarded – undo
2010 2072
 		{
2011 2073
 			if ($file != '.' && $file != '..')
2012 2074
 			{
2013
-				if (is_dir($dir_path . '/' . $file))
2014
-					$files = array_merge($files, get_files_recursive($dir_path . '/' . $file));
2015
-				else
2016
-					$files[] = array('dir' => $dir_path, 'name' => $file);
2075
+				if (is_dir($dir_path . '/' . $file)) {
2076
+									$files = array_merge($files, get_files_recursive($dir_path . '/' . $file));
2077
+				} else {
2078
+									$files[] = array('dir' => $dir_path, 'name' => $file);
2079
+				}
2017 2080
 			}
2018 2081
 		}
2019 2082
 	}
@@ -2062,16 +2125,16 @@  discard block
 block discarded – undo
2062 2125
 							// I need to know if there is at least one function called in this file.
2063 2126
 							$temp_data['include'][$hookParsedData['pureFunc']] = array('hook' => $hook, 'function' => $hookParsedData['pureFunc']);
2064 2127
 							unset($temp_hooks[$hook][$rawFunc]);
2065
-						}
2066
-						elseif (strpos(str_replace(' (', '(', $fc), 'function ' . trim($hookParsedData['pureFunc']) . '(') !== false)
2128
+						} elseif (strpos(str_replace(' (', '(', $fc), 'function ' . trim($hookParsedData['pureFunc']) . '(') !== false)
2067 2129
 						{
2068 2130
 							$hook_status[$hook][$hookParsedData['pureFunc']] = $hookParsedData;
2069 2131
 							$hook_status[$hook][$hookParsedData['pureFunc']]['exists'] = true;
2070 2132
 							$hook_status[$hook][$hookParsedData['pureFunc']]['in_file'] = (!empty($file['name']) ? $file['name'] : (!empty($hookParsedData['hookFile']) ? $hookParsedData['hookFile'] : ''));
2071 2133
 
2072 2134
 							// Does the hook has its own file?
2073
-							if (!empty($hookParsedData['hookFile']))
2074
-								$temp_data['include'][$hookParsedData['pureFunc']] = array('hook' => $hook, 'function' => $hookParsedData['pureFunc']);
2135
+							if (!empty($hookParsedData['hookFile'])) {
2136
+															$temp_data['include'][$hookParsedData['pureFunc']] = array('hook' => $hook, 'function' => $hookParsedData['pureFunc']);
2137
+							}
2075 2138
 
2076 2139
 							// I want to remember all the functions called within this file (to check later if they are enabled or disabled and decide if the integrare_*_include of that file can be disabled too)
2077 2140
 							$temp_data['function'][$file['name']][$hookParsedData['pureFunc']] = $hookParsedData['enabled'];
@@ -2098,15 +2161,17 @@  discard block
 block discarded – undo
2098 2161
 	$sort = array();
2099 2162
 	$hooks_filters = array();
2100 2163
 
2101
-	foreach ($hooks as $hook => $functions)
2102
-		$hooks_filters[] = '<option' . ($context['current_filter'] == $hook ? ' selected ' : '') . ' value="' . $hook . '">' . $hook . '</option>';
2164
+	foreach ($hooks as $hook => $functions) {
2165
+			$hooks_filters[] = '<option' . ($context['current_filter'] == $hook ? ' selected ' : '') . ' value="' . $hook . '">' . $hook . '</option>';
2166
+	}
2103 2167
 
2104
-	if (!empty($hooks_filters))
2105
-		$context['insert_after_template'] .= '
2168
+	if (!empty($hooks_filters)) {
2169
+			$context['insert_after_template'] .= '
2106 2170
 		<script>
2107 2171
 			var hook_name_header = document.getElementById(\'header_list_integration_hooks_hook_name\');
2108 2172
 			hook_name_header.innerHTML += ' . JavaScriptEscape('<select style="margin-left:15px;" onchange="window.location=(\'' . $scripturl . '?action=admin;area=maintain;sa=hooks\' + (this.value ? \';filter=\' + this.value : \'\'));"><option value="">' . $txt['hooks_reset_filter'] . '</option>' . implode('', $hooks_filters) . '</select>') . ';
2109 2173
 		</script>';
2174
+	}
2110 2175
 
2111 2176
 	$temp_data = array();
2112 2177
 	$id = 0;
@@ -2148,10 +2213,11 @@  discard block
 block discarded – undo
2148 2213
 
2149 2214
 	foreach ($temp_data as $data)
2150 2215
 	{
2151
-		if (++$counter < $start)
2152
-			continue;
2153
-		elseif ($counter == $start + $per_page)
2154
-			break;
2216
+		if (++$counter < $start) {
2217
+					continue;
2218
+		} elseif ($counter == $start + $per_page) {
2219
+					break;
2220
+		}
2155 2221
 
2156 2222
 		$hooks_data[] = $data;
2157 2223
 	}
@@ -2173,13 +2239,15 @@  discard block
 block discarded – undo
2173 2239
 	$hooks_count = 0;
2174 2240
 
2175 2241
 	$context['filter'] = false;
2176
-	if (isset($_GET['filter']))
2177
-		$context['filter'] = $_GET['filter'];
2242
+	if (isset($_GET['filter'])) {
2243
+			$context['filter'] = $_GET['filter'];
2244
+	}
2178 2245
 
2179 2246
 	foreach ($hooks as $hook => $functions)
2180 2247
 	{
2181
-		if (empty($context['filter']) || (!empty($context['filter']) && $context['filter'] == $hook))
2182
-			$hooks_count += count($functions);
2248
+		if (empty($context['filter']) || (!empty($context['filter']) && $context['filter'] == $hook)) {
2249
+					$hooks_count += count($functions);
2250
+		}
2183 2251
 	}
2184 2252
 
2185 2253
 	return $hooks_count;
@@ -2200,8 +2268,9 @@  discard block
 block discarded – undo
2200 2268
 		$integration_hooks = array();
2201 2269
 		foreach ($modSettings as $key => $value)
2202 2270
 		{
2203
-			if (!empty($value) && substr($key, 0, 10) === 'integrate_')
2204
-				$integration_hooks[$key] = explode(',', $value);
2271
+			if (!empty($value) && substr($key, 0, 10) === 'integrate_') {
2272
+							$integration_hooks[$key] = explode(',', $value);
2273
+			}
2205 2274
 		}
2206 2275
 	}
2207 2276
 
@@ -2232,8 +2301,9 @@  discard block
 block discarded – undo
2232 2301
 	);
2233 2302
 
2234 2303
 	// Meh...
2235
-	if (empty($rawData))
2236
-		return $hookData;
2304
+	if (empty($rawData)) {
2305
+			return $hookData;
2306
+	}
2237 2307
 
2238 2308
 	// For convenience purposes only!
2239 2309
 	$modFunc = $rawData;
@@ -2244,11 +2314,11 @@  discard block
 block discarded – undo
2244 2314
 		list ($hookData['hookFile'], $modFunc) = explode('|', $modFunc);
2245 2315
 
2246 2316
 		// Does the file exists? who knows!
2247
-		if (empty($settings['theme_dir']))
2248
-			$hookData['absPath'] = strtr(trim($hookData['hookFile']), array('$boarddir' => $boarddir, '$sourcedir' => $sourcedir));
2249
-
2250
-		else
2251
-			$hookData['absPath'] = strtr(trim($hookData['hookFile']), array('$boarddir' => $boarddir, '$sourcedir' => $sourcedir, '$themedir' => $settings['theme_dir']));
2317
+		if (empty($settings['theme_dir'])) {
2318
+					$hookData['absPath'] = strtr(trim($hookData['hookFile']), array('$boarddir' => $boarddir, '$sourcedir' => $sourcedir));
2319
+		} else {
2320
+					$hookData['absPath'] = strtr(trim($hookData['hookFile']), array('$boarddir' => $boarddir, '$sourcedir' => $sourcedir, '$themedir' => $settings['theme_dir']));
2321
+		}
2252 2322
 
2253 2323
 		$hookData['fileExists'] = file_exists($hookData['absPath']);
2254 2324
 		$hookData['hookFile'] = basename($hookData['hookFile']);
@@ -2273,11 +2343,10 @@  discard block
 block discarded – undo
2273 2343
 	{
2274 2344
 		list ($hookData['class'], $hookData['method']) = explode('::', $modFunc);
2275 2345
 		$hookData['pureFunc'] = $hookData['method'];
2346
+	} else {
2347
+			$hookData['pureFunc'] = $modFunc;
2276 2348
 	}
2277 2349
 
2278
-	else
2279
-		$hookData['pureFunc'] = $modFunc;
2280
-
2281 2350
 	return $hookData;
2282 2351
 }
2283 2352
 
Please login to merge, or discard this patch.
Sources/DbPackages-mysql.php 1 patch
Braces   +122 added lines, -98 removed lines patch added patch discarded remove patch
@@ -13,8 +13,9 @@  discard block
 block discarded – undo
13 13
  * @version 2.1 Beta 4
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 file functions to the $smcFunc array.
@@ -53,8 +54,9 @@  discard block
 block discarded – undo
53 54
 		'messages', 'moderator_groups', 'moderators', 'package_servers', 'permission_profiles', 'permissions', 'personal_messages',
54 55
 		'pm_labeled_messages', 'pm_labels', 'pm_recipients', 'pm_rules', 'poll_choices', 'polls', 'scheduled_tasks', 'sessions', 'settings', 'smileys',
55 56
 		'spiders', 'subscriptions', 'themes', 'topics', 'user_alerts', 'user_alerts_prefs', 'user_drafts', 'user_likes');
56
-	foreach ($reservedTables as $k => $table_name)
57
-		$reservedTables[$k] = strtolower($db_prefix . $table_name);
57
+	foreach ($reservedTables as $k => $table_name) {
58
+			$reservedTables[$k] = strtolower($db_prefix . $table_name);
59
+	}
58 60
 
59 61
 	// We in turn may need the extra stuff.
60 62
 	db_extend('extra');
@@ -109,8 +111,9 @@  discard block
 block discarded – undo
109 111
 	$table_name = str_replace('{db_prefix}', $db_prefix, $table_name);
110 112
 
111 113
 	// First - no way do we touch SMF tables.
112
-	if (in_array(strtolower($table_name), $reservedTables))
113
-		return false;
114
+	if (in_array(strtolower($table_name), $reservedTables)) {
115
+			return false;
116
+	}
114 117
 
115 118
 	// Log that we'll want to remove this on uninstall.
116 119
 	$db_package_log[] = array('remove_table', $table_name);
@@ -120,9 +123,9 @@  discard block
 block discarded – undo
120 123
 	if (in_array($full_table_name, $tables))
121 124
 	{
122 125
 		// This is a sad day... drop the table? If not, return false (error) by default.
123
-		if ($if_exists == 'overwrite')
124
-			$smcFunc['db_drop_table']($table_name);
125
-		else if ($if_exists == 'update')
126
+		if ($if_exists == 'overwrite') {
127
+					$smcFunc['db_drop_table']($table_name);
128
+		} else if ($if_exists == 'update')
126 129
 		{
127 130
 			$smcFunc['db_transaction']('begin');
128 131
 			$db_trans = true;
@@ -134,15 +137,16 @@  discard block
 block discarded – undo
134 137
 				)
135 138
 			);
136 139
 			$old_table_exists = true;
140
+		} else {
141
+					return $if_exists == 'ignore';
137 142
 		}
138
-		else
139
-			return $if_exists == 'ignore';
140 143
 	}
141 144
 
142 145
 	// Righty - let's do the damn thing!
143 146
 	$table_query = 'CREATE TABLE ' . $table_name . "\n" . '(';
144
-	foreach ($columns as $column)
145
-		$table_query .= "\n\t" . smf_db_create_query_column($column) . ',';
147
+	foreach ($columns as $column) {
148
+			$table_query .= "\n\t" . smf_db_create_query_column($column) . ',';
149
+	}
146 150
 
147 151
 	// Loop through the indexes next...
148 152
 	foreach ($indexes as $index)
@@ -150,19 +154,21 @@  discard block
 block discarded – undo
150 154
 		$columns = implode(',', $index['columns']);
151 155
 
152 156
 		// Is it the primary?
153
-		if (isset($index['type']) && $index['type'] == 'primary')
154
-			$table_query .= "\n\t" . 'PRIMARY KEY (' . implode(',', $index['columns']) . '),';
155
-		else
157
+		if (isset($index['type']) && $index['type'] == 'primary') {
158
+					$table_query .= "\n\t" . 'PRIMARY KEY (' . implode(',', $index['columns']) . '),';
159
+		} else
156 160
 		{
157
-			if (empty($index['name']))
158
-				$index['name'] = implode('_', $index['columns']);
161
+			if (empty($index['name'])) {
162
+							$index['name'] = implode('_', $index['columns']);
163
+			}
159 164
 			$table_query .= "\n\t" . (isset($index['type']) && $index['type'] == 'unique' ? 'UNIQUE' : 'KEY') . ' ' . $index['name'] . ' (' . $columns . '),';
160 165
 		}
161 166
 	}
162 167
 
163 168
 	// No trailing commas!
164
-	if (substr($table_query, -1) == ',')
165
-		$table_query = substr($table_query, 0, -1);
169
+	if (substr($table_query, -1) == ',') {
170
+			$table_query = substr($table_query, 0, -1);
171
+	}
166 172
 
167 173
 	// Which engine do we want here?
168 174
 	if (empty($engines))
@@ -172,8 +178,9 @@  discard block
 block discarded – undo
172 178
 
173 179
 		while ($row = $smcFunc['db_fetch_assoc']($get_engines))
174 180
 		{
175
-			if ($row['Support'] == 'YES' || $row['Support'] == 'DEFAULT')
176
-				$engines[] = $row['Engine'];
181
+			if ($row['Support'] == 'YES' || $row['Support'] == 'DEFAULT') {
182
+							$engines[] = $row['Engine'];
183
+			}
177 184
 		}
178 185
 
179 186
 		$smcFunc['db_free_result']($get_engines);
@@ -187,8 +194,9 @@  discard block
 block discarded – undo
187 194
 	}
188 195
 
189 196
 	$table_query .= ') ENGINE=' . $parameters['engine'];
190
-	if (!empty($db_character_set) && $db_character_set == 'utf8')
191
-		$table_query .= ' DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci';
197
+	if (!empty($db_character_set) && $db_character_set == 'utf8') {
198
+			$table_query .= ' DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci';
199
+	}
192 200
 
193 201
 	// Create the table!
194 202
 	$smcFunc['db_query']('', $table_query,
@@ -255,8 +263,9 @@  discard block
 block discarded – undo
255 263
 	$table_name = str_replace('{db_prefix}', $db_prefix, $table_name);
256 264
 
257 265
 	// God no - dropping one of these = bad.
258
-	if (in_array(strtolower($table_name), $reservedTables))
259
-		return false;
266
+	if (in_array(strtolower($table_name), $reservedTables)) {
267
+			return false;
268
+	}
260 269
 
261 270
 	// Does it exist?
262 271
 	if (in_array($full_table_name, $smcFunc['db_list_tables']()))
@@ -297,14 +306,16 @@  discard block
 block discarded – undo
297 306
 
298 307
 	// Does it exist - if so don't add it again!
299 308
 	$columns = $smcFunc['db_list_columns']($table_name, false);
300
-	foreach ($columns as $column)
301
-		if ($column == $column_info['name'])
309
+	foreach ($columns as $column) {
310
+			if ($column == $column_info['name'])
302 311
 		{
303 312
 			// If we're going to overwrite then use change column.
304 313
 			if ($if_exists == 'update')
305 314
 				return $smcFunc['db_change_column']($table_name, $column_info['name'], $column_info);
306
-			else
307
-				return false;
315
+	}
316
+			else {
317
+							return false;
318
+			}
308 319
 		}
309 320
 
310 321
 	// Get the specifics...
@@ -340,8 +351,8 @@  discard block
 block discarded – undo
340 351
 
341 352
 	// Does it exist?
342 353
 	$columns = $smcFunc['db_list_columns']($table_name, true);
343
-	foreach ($columns as $column)
344
-		if ($column['name'] == $column_name)
354
+	foreach ($columns as $column) {
355
+			if ($column['name'] == $column_name)
345 356
 		{
346 357
 			$smcFunc['db_query']('', '
347 358
 				ALTER TABLE ' . $table_name . '
@@ -350,6 +361,7 @@  discard block
 block discarded – undo
350 361
 					'security_override' => true,
351 362
 				)
352 363
 			);
364
+	}
353 365
 
354 366
 			return true;
355 367
 		}
@@ -375,37 +387,47 @@  discard block
 block discarded – undo
375 387
 	// Check it does exist!
376 388
 	$columns = $smcFunc['db_list_columns']($table_name, true);
377 389
 	$old_info = null;
378
-	foreach ($columns as $column)
379
-		if ($column['name'] == $old_column)
390
+	foreach ($columns as $column) {
391
+			if ($column['name'] == $old_column)
380 392
 			$old_info = $column;
393
+	}
381 394
 
382 395
 	// Nothing?
383
-	if ($old_info == null)
384
-		return false;
396
+	if ($old_info == null) {
397
+			return false;
398
+	}
385 399
 
386 400
 	// Get the right bits.
387
-	if (!isset($column_info['name']))
388
-		$column_info['name'] = $old_column;
389
-	if (!isset($column_info['default']))
390
-		$column_info['default'] = $old_info['default'];
391
-	if (!isset($column_info['null']))
392
-		$column_info['null'] = $old_info['null'];
393
-	if (!isset($column_info['auto']))
394
-		$column_info['auto'] = $old_info['auto'];
395
-	if (!isset($column_info['type']))
396
-		$column_info['type'] = $old_info['type'];
397
-	if (!isset($column_info['size']) || !is_numeric($column_info['size']))
398
-		$column_info['size'] = $old_info['size'];
399
-	if (!isset($column_info['unsigned']) || !in_array($column_info['type'], array('int', 'tinyint', 'smallint', 'mediumint', 'bigint')))
400
-		$column_info['unsigned'] = '';
401
+	if (!isset($column_info['name'])) {
402
+			$column_info['name'] = $old_column;
403
+	}
404
+	if (!isset($column_info['default'])) {
405
+			$column_info['default'] = $old_info['default'];
406
+	}
407
+	if (!isset($column_info['null'])) {
408
+			$column_info['null'] = $old_info['null'];
409
+	}
410
+	if (!isset($column_info['auto'])) {
411
+			$column_info['auto'] = $old_info['auto'];
412
+	}
413
+	if (!isset($column_info['type'])) {
414
+			$column_info['type'] = $old_info['type'];
415
+	}
416
+	if (!isset($column_info['size']) || !is_numeric($column_info['size'])) {
417
+			$column_info['size'] = $old_info['size'];
418
+	}
419
+	if (!isset($column_info['unsigned']) || !in_array($column_info['type'], array('int', 'tinyint', 'smallint', 'mediumint', 'bigint'))) {
420
+			$column_info['unsigned'] = '';
421
+	}
401 422
 
402 423
 	list ($type, $size) = $smcFunc['db_calculate_type']($column_info['type'], $column_info['size']);
403 424
 
404 425
 	// Allow for unsigned integers (mysql only)
405 426
 	$unsigned = in_array($type, array('int', 'tinyint', 'smallint', 'mediumint', 'bigint')) && !empty($column_info['unsigned']) ? 'unsigned ' : '';
406 427
 
407
-	if ($size !== null)
408
-		$type = $type . '(' . $size . ')';
428
+	if ($size !== null) {
429
+			$type = $type . '(' . $size . ')';
430
+	}
409 431
 
410 432
 	$smcFunc['db_query']('', '
411 433
 		ALTER TABLE ' . $table_name . '
@@ -435,18 +457,20 @@  discard block
 block discarded – undo
435 457
 	$table_name = str_replace('{db_prefix}', $db_prefix, $table_name);
436 458
 
437 459
 	// No columns = no index.
438
-	if (empty($index_info['columns']))
439
-		return false;
460
+	if (empty($index_info['columns'])) {
461
+			return false;
462
+	}
440 463
 	$columns = implode(',', $index_info['columns']);
441 464
 
442 465
 	// No name - make it up!
443 466
 	if (empty($index_info['name']))
444 467
 	{
445 468
 		// No need for primary.
446
-		if (isset($index_info['type']) && $index_info['type'] == 'primary')
447
-			$index_info['name'] = '';
448
-		else
449
-			$index_info['name'] = implode('_', $index_info['columns']);
469
+		if (isset($index_info['type']) && $index_info['type'] == 'primary') {
470
+					$index_info['name'] = '';
471
+		} else {
472
+					$index_info['name'] = implode('_', $index_info['columns']);
473
+		}
450 474
 	}
451 475
 
452 476
 	// Log that we are going to want to remove this!
@@ -460,10 +484,11 @@  discard block
 block discarded – undo
460 484
 		if ($index['name'] == $index_info['name'] || ($index['type'] == 'primary' && isset($index_info['type']) && $index_info['type'] == 'primary'))
461 485
 		{
462 486
 			// If we want to overwrite simply remove the current one then continue.
463
-			if ($if_exists != 'update' || $index['type'] == 'primary')
464
-				return false;
465
-			else
466
-				$smcFunc['db_remove_index']($table_name, $index_info['name']);
487
+			if ($if_exists != 'update' || $index['type'] == 'primary') {
488
+							return false;
489
+			} else {
490
+							$smcFunc['db_remove_index']($table_name, $index_info['name']);
491
+			}
467 492
 		}
468 493
 	}
469 494
 
@@ -477,8 +502,7 @@  discard block
 block discarded – undo
477 502
 				'security_override' => true,
478 503
 			)
479 504
 		);
480
-	}
481
-	else
505
+	} else
482 506
 	{
483 507
 		$smcFunc['db_query']('', '
484 508
 			ALTER TABLE ' . $table_name . '
@@ -562,8 +586,7 @@  discard block
 block discarded – undo
562 586
 		$types = array(
563 587
 			'inet' => 'varbinary',
564 588
 		);
565
-	}
566
-	else
589
+	} else
567 590
 	{
568 591
 		$types = array(
569 592
 			'varbinary' => 'inet',
@@ -577,16 +600,15 @@  discard block
 block discarded – undo
577 600
 		{
578 601
 			$type_size = 16;
579 602
 			$type_name = 'varbinary';
580
-		}
581
-		elseif ($type_name == 'varbinary' && $reverse && $type_size == 16)
603
+		} elseif ($type_name == 'varbinary' && $reverse && $type_size == 16)
582 604
 		{
583 605
 			$type_name = 'inet';
584 606
 			$type_size = null;
607
+		} elseif ($type_name == 'varbinary') {
608
+					$type_name = 'varbinary';
609
+		} else {
610
+					$type_name = $types[$type_name];
585 611
 		}
586
-		elseif ($type_name == 'varbinary')
587
-			$type_name = 'varbinary';
588
-		else
589
-			$type_name = $types[$type_name];
590 612
 	}
591 613
 
592 614
 	return array($type_name, $type_size);
@@ -653,8 +675,7 @@  discard block
 block discarded – undo
653 675
 		if (!$detail)
654 676
 		{
655 677
 			$columns[] = $row['Field'];
656
-		}
657
-		else
678
+		} else
658 679
 		{
659 680
 			// Is there an auto_increment?
660 681
 			$auto = strpos($row['Extra'], 'auto_increment') !== false ? true : false;
@@ -664,10 +685,10 @@  discard block
 block discarded – undo
664 685
 			{
665 686
 				$type = $matches[1];
666 687
 				$size = $matches[2];
667
-				if (!empty($matches[3]) && $matches[3] == 'unsigned')
668
-					$unsigned = true;
669
-			}
670
-			else
688
+				if (!empty($matches[3]) && $matches[3] == 'unsigned') {
689
+									$unsigned = true;
690
+				}
691
+			} else
671 692
 			{
672 693
 				$type = $row['Type'];
673 694
 				$size = null;
@@ -718,19 +739,20 @@  discard block
 block discarded – undo
718 739
 	$indexes = array();
719 740
 	while ($row = $smcFunc['db_fetch_assoc']($result))
720 741
 	{
721
-		if (!$detail)
722
-			$indexes[] = $row['Key_name'];
723
-		else
742
+		if (!$detail) {
743
+					$indexes[] = $row['Key_name'];
744
+		} else
724 745
 		{
725 746
 			// What is the type?
726
-			if ($row['Key_name'] == 'PRIMARY')
727
-				$type = 'primary';
728
-			elseif (empty($row['Non_unique']))
729
-				$type = 'unique';
730
-			elseif (isset($row['Index_type']) && $row['Index_type'] == 'FULLTEXT')
731
-				$type = 'fulltext';
732
-			else
733
-				$type = 'index';
747
+			if ($row['Key_name'] == 'PRIMARY') {
748
+							$type = 'primary';
749
+			} elseif (empty($row['Non_unique'])) {
750
+							$type = 'unique';
751
+			} elseif (isset($row['Index_type']) && $row['Index_type'] == 'FULLTEXT') {
752
+							$type = 'fulltext';
753
+			} else {
754
+							$type = 'index';
755
+			}
734 756
 
735 757
 			// This is the first column we've seen?
736 758
 			if (empty($indexes[$row['Key_name']]))
@@ -743,10 +765,11 @@  discard block
 block discarded – undo
743 765
 			}
744 766
 
745 767
 			// Is it a partial index?
746
-			if (!empty($row['Sub_part']))
747
-				$indexes[$row['Key_name']]['columns'][] = $row['Column_name'] . '(' . $row['Sub_part'] . ')';
748
-			else
749
-				$indexes[$row['Key_name']]['columns'][] = $row['Column_name'];
768
+			if (!empty($row['Sub_part'])) {
769
+							$indexes[$row['Key_name']]['columns'][] = $row['Column_name'] . '(' . $row['Sub_part'] . ')';
770
+			} else {
771
+							$indexes[$row['Key_name']]['columns'][] = $row['Column_name'];
772
+			}
750 773
 		}
751 774
 	}
752 775
 	$smcFunc['db_free_result']($result);
@@ -768,11 +791,11 @@  discard block
 block discarded – undo
768 791
 	if (!empty($column['auto']))
769 792
 	{
770 793
 		$default = 'auto_increment';
794
+	} elseif (isset($column['default']) && $column['default'] !== null) {
795
+			$default = 'default \'' . $smcFunc['db_escape_string']($column['default']) . '\'';
796
+	} else {
797
+			$default = '';
771 798
 	}
772
-	elseif (isset($column['default']) && $column['default'] !== null)
773
-		$default = 'default \'' . $smcFunc['db_escape_string']($column['default']) . '\'';
774
-	else
775
-		$default = '';
776 799
 
777 800
 	// Sort out the size... and stuff...
778 801
 	$column['size'] = isset($column['size']) && is_numeric($column['size']) ? $column['size'] : null;
@@ -781,8 +804,9 @@  discard block
 block discarded – undo
781 804
 	// Allow unsigned integers (mysql only)
782 805
 	$unsigned = in_array($type, array('int', 'tinyint', 'smallint', 'mediumint', 'bigint')) && !empty($column['unsigned']) ? 'unsigned ' : '';
783 806
 
784
-	if ($size !== null)
785
-		$type = $type . '(' . $size . ')';
807
+	if ($size !== null) {
808
+			$type = $type . '(' . $size . ')';
809
+	}
786 810
 
787 811
 	// Now just put it together!
788 812
 	return '`' . $column['name'] . '` ' . $type . ' ' . (!empty($unsigned) ? $unsigned : '') . (!empty($column['null']) ? '' : 'NOT NULL') . ' ' . $default;
Please login to merge, or discard this patch.
Sources/RepairBoards.php 1 patch
Braces   +119 added lines, -85 removed lines patch added patch discarded remove patch
@@ -13,8 +13,9 @@  discard block
 block discarded – undo
13 13
  * @version 2.1 Beta 4
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
  * Finds or repairs errors in the database to fix possible problems.
@@ -50,8 +51,9 @@  discard block
 block discarded – undo
50 51
 	);
51 52
 
52 53
 	// Start displaying errors without fixing them.
53
-	if (isset($_GET['fixErrors']))
54
-		checkSession('get');
54
+	if (isset($_GET['fixErrors'])) {
55
+			checkSession('get');
56
+	}
55 57
 
56 58
 	// Will want this.
57 59
 	loadForumTests();
@@ -69,11 +71,11 @@  discard block
 block discarded – undo
69 71
 			$_SESSION['repairboards_to_fix'] = $context['to_fix'];
70 72
 			$_SESSION['repairboards_to_fix2'] = null;
71 73
 
72
-			if (empty($context['repair_errors']))
73
-				$context['repair_errors'][] = '???';
74
+			if (empty($context['repair_errors'])) {
75
+							$context['repair_errors'][] = '???';
76
+			}
74 77
 		}
75
-	}
76
-	else
78
+	} else
77 79
 	{
78 80
 		$context['error_search'] = false;
79 81
 		$context['to_fix'] = isset($_SESSION['repairboards_to_fix']) ? $_SESSION['repairboards_to_fix'] : array();
@@ -120,16 +122,19 @@  discard block
 block discarded – undo
120 122
 
121 123
 	// More time, I need more time!
122 124
 	@set_time_limit(600);
123
-	if (function_exists('apache_reset_timeout'))
124
-		@apache_reset_timeout();
125
+	if (function_exists('apache_reset_timeout')) {
126
+			@apache_reset_timeout();
127
+	}
125 128
 
126 129
 	// Errr, wait.  How much time has this taken already?
127
-	if (!$force && (time() - $time_start) < 3)
128
-		return;
130
+	if (!$force && (time() - $time_start) < 3) {
131
+			return;
132
+	}
129 133
 
130 134
 	// Restore the query cache if interested.
131
-	if (!empty($db_temp_cache))
132
-		$db_cache = $db_temp_cache;
135
+	if (!empty($db_temp_cache)) {
136
+			$db_cache = $db_temp_cache;
137
+	}
133 138
 
134 139
 	$context['continue_get_data'] = '?action=admin;area=repairboards' . (isset($_GET['fixErrors']) ? ';fixErrors' : '') . ';step=' . $_GET['step'] . ';substep=' . $_GET['substep'] . ';' . $context['session_var'] . '=' . $context['session_id'];
135 140
 	$context['page_title'] = $txt['not_done_title'];
@@ -138,10 +143,11 @@  discard block
 block discarded – undo
138 143
 	$context['sub_template'] = 'not_done';
139 144
 
140 145
 	// Change these two if more steps are added!
141
-	if (empty($max_substep))
142
-		$context['continue_percent'] = round(($_GET['step'] * 100) / $context['total_steps']);
143
-	else
144
-		$context['continue_percent'] = round((($_GET['step'] + ($_GET['substep'] / $max_substep)) * 100) / $context['total_steps']);
146
+	if (empty($max_substep)) {
147
+			$context['continue_percent'] = round(($_GET['step'] * 100) / $context['total_steps']);
148
+	} else {
149
+			$context['continue_percent'] = round((($_GET['step'] + ($_GET['substep'] / $max_substep)) * 100) / $context['total_steps']);
150
+	}
145 151
 
146 152
 	// Never more than 100%!
147 153
 	$context['continue_percent'] = min($context['continue_percent'], 100);
@@ -612,8 +618,9 @@  discard block
 block discarded – undo
612 618
 				$row['myid_last_msg'] = (int) $row['myid_last_msg'];
613 619
 
614 620
 				// Not really a problem?
615
-				if ($row['id_first_msg'] == $row['myid_first_msg'] && $row['id_last_msg'] == $row['myid_last_msg'] && $row['approved'] == $row['firstmsg_approved'])
616
-					return false;
621
+				if ($row['id_first_msg'] == $row['myid_first_msg'] && $row['id_last_msg'] == $row['myid_last_msg'] && $row['approved'] == $row['firstmsg_approved']) {
622
+									return false;
623
+				}
617 624
 
618 625
 				$memberStartedID = (int) getMsgMemberID($row['myid_first_msg']);
619 626
 				$memberUpdatedID = (int) getMsgMemberID($row['myid_last_msg']);
@@ -637,15 +644,19 @@  discard block
 block discarded – undo
637 644
 			'message_function' => function ($row) use ($txt, &$context)
638 645
 			{
639 646
 				// A pretend error?
640
-				if ($row['id_first_msg'] == $row['myid_first_msg'] && $row['id_last_msg'] == $row['myid_last_msg'] && $row['approved'] == $row['firstmsg_approved'])
641
-					return false;
647
+				if ($row['id_first_msg'] == $row['myid_first_msg'] && $row['id_last_msg'] == $row['myid_last_msg'] && $row['approved'] == $row['firstmsg_approved']) {
648
+									return false;
649
+				}
642 650
 
643
-				if ($row['id_first_msg'] != $row['myid_first_msg'])
644
-					$context['repair_errors'][] = sprintf($txt['repair_stats_topics_1'], $row['id_topic'], $row['id_first_msg']);
645
-				if ($row['id_last_msg'] != $row['myid_last_msg'])
646
-					$context['repair_errors'][] = sprintf($txt['repair_stats_topics_2'], $row['id_topic'], $row['id_last_msg']);
647
-				if ($row['approved'] != $row['firstmsg_approved'])
648
-					$context['repair_errors'][] = sprintf($txt['repair_stats_topics_5'], $row['id_topic']);
651
+				if ($row['id_first_msg'] != $row['myid_first_msg']) {
652
+									$context['repair_errors'][] = sprintf($txt['repair_stats_topics_1'], $row['id_topic'], $row['id_first_msg']);
653
+				}
654
+				if ($row['id_last_msg'] != $row['myid_last_msg']) {
655
+									$context['repair_errors'][] = sprintf($txt['repair_stats_topics_2'], $row['id_topic'], $row['id_last_msg']);
656
+				}
657
+				if ($row['approved'] != $row['firstmsg_approved']) {
658
+									$context['repair_errors'][] = sprintf($txt['repair_stats_topics_5'], $row['id_topic']);
659
+				}
649 660
 
650 661
 				return true;
651 662
 			},
@@ -675,8 +686,9 @@  discard block
 block discarded – undo
675 686
 				$row['my_num_replies'] = (int) $row['my_num_replies'];
676 687
 
677 688
 				// Not really a problem?
678
-				if ($row['my_num_replies'] == $row['num_replies'])
679
-					return false;
689
+				if ($row['my_num_replies'] == $row['num_replies']) {
690
+									return false;
691
+				}
680 692
 
681 693
 				$smcFunc['db_query']('', '
682 694
 					UPDATE {db_prefix}topics
@@ -695,11 +707,13 @@  discard block
 block discarded – undo
695 707
 				global $txt, $context;
696 708
 
697 709
 				// Just joking?
698
-				if ($row['my_num_replies'] == $row['num_replies'])
699
-					return false;
710
+				if ($row['my_num_replies'] == $row['num_replies']) {
711
+									return false;
712
+				}
700 713
 
701
-				if ($row['num_replies'] != $row['my_num_replies'])
702
-					$context['repair_errors'][] = sprintf($txt['repair_stats_topics_3'], $row['id_topic'], $row['num_replies']);
714
+				if ($row['num_replies'] != $row['my_num_replies']) {
715
+									$context['repair_errors'][] = sprintf($txt['repair_stats_topics_3'], $row['id_topic'], $row['num_replies']);
716
+				}
703 717
 
704 718
 				return true;
705 719
 
@@ -1290,8 +1304,9 @@  discard block
 block discarded – undo
1290 1304
 				$inserts = array();
1291 1305
 				while ($row = $smcFunc['db_fetch_assoc']($result))
1292 1306
 				{
1293
-					foreach (text2words($row['subject']) as $word)
1294
-						$inserts[] = array($word, $row['id_topic']);
1307
+					foreach (text2words($row['subject']) as $word) {
1308
+											$inserts[] = array($word, $row['id_topic']);
1309
+					}
1295 1310
 					if (count($inserts) > 500)
1296 1311
 					{
1297 1312
 						$smcFunc['db_insert']('ignore',
@@ -1305,13 +1320,14 @@  discard block
 block discarded – undo
1305 1320
 
1306 1321
 				}
1307 1322
 
1308
-				if (!empty($inserts))
1309
-					$smcFunc['db_insert']('ignore',
1323
+				if (!empty($inserts)) {
1324
+									$smcFunc['db_insert']('ignore',
1310 1325
 						'{db_prefix}log_search_subjects',
1311 1326
 						array('word' => 'string', 'id_topic' => 'int'),
1312 1327
 						$inserts,
1313 1328
 						array('word', 'id_topic')
1314 1329
 					);
1330
+				}
1315 1331
 
1316 1332
 		},
1317 1333
 			'message_function' => function ($row)
@@ -1581,8 +1597,9 @@  discard block
 block discarded – undo
1581 1597
 		$current_step++;
1582 1598
 
1583 1599
 		// Already done this?
1584
-		if ($_GET['step'] > $current_step)
1585
-			continue;
1600
+		if ($_GET['step'] > $current_step) {
1601
+					continue;
1602
+		}
1586 1603
 
1587 1604
 		// If we're fixing it but it ain't broke why try?
1588 1605
 		if ($do_fix && !in_array($error_type, $to_fix))
@@ -1611,14 +1628,16 @@  discard block
 block discarded – undo
1611 1628
 		while (!$done)
1612 1629
 		{
1613 1630
 			// Make sure there's at least one ID to test.
1614
-			if (isset($test['substeps']) && empty($step_max))
1615
-				break;
1631
+			if (isset($test['substeps']) && empty($step_max)) {
1632
+							break;
1633
+			}
1616 1634
 
1617 1635
 			// What is the testing query (Changes if we are testing or fixing)
1618
-			if (!$do_fix)
1619
-				$test_query = 'check_query';
1620
-			else
1621
-				$test_query = isset($test['fix_query']) ? 'fix_query' : 'check_query';
1636
+			if (!$do_fix) {
1637
+							$test_query = 'check_query';
1638
+			} else {
1639
+							$test_query = isset($test['fix_query']) ? 'fix_query' : 'check_query';
1640
+			}
1622 1641
 
1623 1642
 			// Do the test...
1624 1643
 			$request = $smcFunc['db_query']('',
@@ -1628,10 +1647,11 @@  discard block
 block discarded – undo
1628 1647
 			);
1629 1648
 
1630 1649
 			// Does it need a fix?
1631
-			if (!empty($test['check_type']) && $test['check_type'] == 'count')
1632
-				list ($needs_fix) = $smcFunc['db_fetch_row']($request);
1633
-			else
1634
-				$needs_fix = $smcFunc['db_num_rows']($request);
1650
+			if (!empty($test['check_type']) && $test['check_type'] == 'count') {
1651
+							list ($needs_fix) = $smcFunc['db_fetch_row']($request);
1652
+			} else {
1653
+							$needs_fix = $smcFunc['db_num_rows']($request);
1654
+			}
1635 1655
 
1636 1656
 			$total_queries++;
1637 1657
 
@@ -1643,8 +1663,9 @@  discard block
 block discarded – undo
1643 1663
 					// Assume need to fix.
1644 1664
 					$found_errors = true;
1645 1665
 
1646
-					if (isset($test['message']))
1647
-						$context['repair_errors'][] = $txt[$test['message']];
1666
+					if (isset($test['message'])) {
1667
+											$context['repair_errors'][] = $txt[$test['message']];
1668
+					}
1648 1669
 
1649 1670
 					// One per row!
1650 1671
 					elseif (isset($test['messages']))
@@ -1654,10 +1675,11 @@  discard block
 block discarded – undo
1654 1675
 							$variables = $test['messages'];
1655 1676
 							foreach ($variables as $k => $v)
1656 1677
 							{
1657
-								if ($k == 0 && isset($txt[$v]))
1658
-									$variables[$k] = $txt[$v];
1659
-								elseif ($k > 0 && isset($row[$v]))
1660
-									$variables[$k] = $row[$v];
1678
+								if ($k == 0 && isset($txt[$v])) {
1679
+																	$variables[$k] = $txt[$v];
1680
+								} elseif ($k > 0 && isset($row[$v])) {
1681
+																	$variables[$k] = $row[$v];
1682
+								}
1661 1683
 							}
1662 1684
 							$context['repair_errors'][] = call_user_func_array('sprintf', $variables);
1663 1685
 						}
@@ -1668,13 +1690,15 @@  discard block
 block discarded – undo
1668 1690
 					{
1669 1691
 						// Find out if there are actually errors.
1670 1692
 						$found_errors = false;
1671
-						while ($row = $smcFunc['db_fetch_assoc']($request))
1672
-							$found_errors |= $test['message_function']($row);
1693
+						while ($row = $smcFunc['db_fetch_assoc']($request)) {
1694
+													$found_errors |= $test['message_function']($row);
1695
+						}
1673 1696
 					}
1674 1697
 
1675 1698
 					// Actually have something to fix?
1676
-					if ($found_errors)
1677
-						$to_fix[] = $error_type;
1699
+					if ($found_errors) {
1700
+											$to_fix[] = $error_type;
1701
+					}
1678 1702
 				}
1679 1703
 
1680 1704
 				// We want to fix, we need to fix - so work out what exactly to do!
@@ -1684,8 +1708,9 @@  discard block
 block discarded – undo
1684 1708
 					if (isset($test['fix_collect']))
1685 1709
 					{
1686 1710
 						$ids = array();
1687
-						while ($row = $smcFunc['db_fetch_assoc']($request))
1688
-							$ids[] = $row[$test['fix_collect']['index']];
1711
+						while ($row = $smcFunc['db_fetch_assoc']($request)) {
1712
+													$ids[] = $row[$test['fix_collect']['index']];
1713
+						}
1689 1714
 						if (!empty($ids))
1690 1715
 						{
1691 1716
 							// Fix it!
@@ -1694,30 +1719,34 @@  discard block
 block discarded – undo
1694 1719
 					}
1695 1720
 
1696 1721
 					// Simply executing a fix it query?
1697
-					elseif (isset($test['fix_it_query']))
1698
-						$smcFunc['db_query']('',
1722
+					elseif (isset($test['fix_it_query'])) {
1723
+											$smcFunc['db_query']('',
1699 1724
 							$test['fix_it_query'],
1700 1725
 							array(
1701 1726
 							)
1702 1727
 						);
1728
+					}
1703 1729
 
1704 1730
 					// Do we have some processing to do?
1705 1731
 					elseif (isset($test['fix_processing']))
1706 1732
 					{
1707
-						while ($row = $smcFunc['db_fetch_assoc']($request))
1708
-							$test['fix_processing']($row);
1733
+						while ($row = $smcFunc['db_fetch_assoc']($request)) {
1734
+													$test['fix_processing']($row);
1735
+						}
1709 1736
 					}
1710 1737
 
1711 1738
 					// What about the full set of processing?
1712
-					elseif (isset($test['fix_full_processing']))
1713
-						$test['fix_full_processing']($request);
1739
+					elseif (isset($test['fix_full_processing'])) {
1740
+											$test['fix_full_processing']($request);
1741
+					}
1714 1742
 
1715 1743
 					// Do we have other things we need to fix as a result?
1716 1744
 					if (!empty($test['force_fix']))
1717 1745
 					{
1718
-						foreach ($test['force_fix'] as $item)
1719
-							if (!in_array($item, $to_fix))
1746
+						foreach ($test['force_fix'] as $item) {
1747
+													if (!in_array($item, $to_fix))
1720 1748
 								$to_fix[] = $item;
1749
+						}
1721 1750
 					}
1722 1751
 				}
1723 1752
 			}
@@ -1735,16 +1764,17 @@  discard block
 block discarded – undo
1735 1764
 				if ($_GET['substep'] <= $step_max)
1736 1765
 				{
1737 1766
 					pauseRepairProcess($to_fix, $error_type, $step_max);
1767
+				} else {
1768
+									$done = true;
1738 1769
 				}
1739
-				else
1740
-					$done = true;
1770
+			} else {
1771
+							$done = true;
1741 1772
 			}
1742
-			else
1743
-				$done = true;
1744 1773
 
1745 1774
 			// Don't allow more than 1000 queries at a time.
1746
-			if ($total_queries >= 1000)
1747
-				pauseRepairProcess($to_fix, $error_type, $step_max, true);
1775
+			if ($total_queries >= 1000) {
1776
+							pauseRepairProcess($to_fix, $error_type, $step_max, true);
1777
+			}
1748 1778
 		}
1749 1779
 
1750 1780
 		// Keep going.
@@ -1757,8 +1787,9 @@  discard block
 block discarded – undo
1757 1787
 		if ($do_fix)
1758 1788
 		{
1759 1789
 			$key = array_search($error_type, $to_fix);
1760
-			if ($key !== false && isset($to_fix[$key]))
1761
-				unset($to_fix[$key]);
1790
+			if ($key !== false && isset($to_fix[$key])) {
1791
+							unset($to_fix[$key]);
1792
+			}
1762 1793
 		}
1763 1794
 
1764 1795
 		// Are we done?
@@ -1781,10 +1812,11 @@  discard block
 block discarded – undo
1781 1812
 	static $createOnce = false;
1782 1813
 
1783 1814
 	// Have we already created it?
1784
-	if ($createOnce)
1785
-		return;
1786
-	else
1787
-		$createOnce = true;
1815
+	if ($createOnce) {
1816
+			return;
1817
+	} else {
1818
+			$createOnce = true;
1819
+	}
1788 1820
 
1789 1821
 	// Back to the forum's default language.
1790 1822
 	loadLanguage('Admin', $language);
@@ -1799,8 +1831,9 @@  discard block
 block discarded – undo
1799 1831
 			'cat_name' => $txt['salvaged_category_name'],
1800 1832
 		)
1801 1833
 	);
1802
-	if ($smcFunc['db_num_rows']($result) != 0)
1803
-		list ($salvageCatID) = $smcFunc['db_fetch_row']($result);
1834
+	if ($smcFunc['db_num_rows']($result) != 0) {
1835
+			list ($salvageCatID) = $smcFunc['db_fetch_row']($result);
1836
+	}
1804 1837
 	$smcFunc['db_free_result']($result);
1805 1838
 
1806 1839
 	if (empty($salvageCatID))
@@ -1832,8 +1865,9 @@  discard block
 block discarded – undo
1832 1865
 			'board_name' => $txt['salvaged_board_name'],
1833 1866
 		)
1834 1867
 	);
1835
-	if ($smcFunc['db_num_rows']($result) != 0)
1836
-		list ($salvageBoardID) = $smcFunc['db_fetch_row']($result);
1868
+	if ($smcFunc['db_num_rows']($result) != 0) {
1869
+			list ($salvageBoardID) = $smcFunc['db_fetch_row']($result);
1870
+	}
1837 1871
 	$smcFunc['db_free_result']($result);
1838 1872
 
1839 1873
 	if (empty($salvageBoardID))
Please login to merge, or discard this patch.
Themes/default/ManageNews.template.php 1 patch
Braces   +21 added lines, -14 removed lines patch added patch discarded remove patch
@@ -18,9 +18,10 @@  discard block
 block discarded – undo
18 18
 	global $context, $txt, $scripturl;
19 19
 
20 20
 	// Are we done sending the newsletter?
21
-	if (!empty($context['newsletter_sent']))
22
-		echo '
21
+	if (!empty($context['newsletter_sent'])) {
22
+			echo '
23 23
 	<div class="infobox">', $txt['admin_news_newsletter_' . $context['newsletter_sent']], '</div>';
24
+	}
24 25
 
25 26
 	echo '
26 27
 	<div id="admincenter">
@@ -39,9 +40,10 @@  discard block
 block discarded – undo
39 40
 					</dt>
40 41
 					<dd>';
41 42
 
42
-	foreach ($context['groups'] as $group)
43
-		echo '
43
+	foreach ($context['groups'] as $group) {
44
+			echo '
44 45
 						<label for="groups_', $group['id'], '"><input type="checkbox" name="groups[', $group['id'], ']" id="groups_', $group['id'], '" value="', $group['id'], '" checked> ', $group['name'], '</label> <em>(', $group['member_count'], ')</em><br>';
46
+	}
45 47
 
46 48
 	echo '
47 49
 						<br>
@@ -82,9 +84,10 @@  discard block
 block discarded – undo
82 84
 						</dt>
83 85
 						<dd>';
84 86
 
85
-	foreach ($context['groups'] as $group)
86
-		echo '
87
+	foreach ($context['groups'] as $group) {
88
+			echo '
87 89
 							<label for="exclude_groups_', $group['id'], '"><input type="checkbox" name="exclude_groups[', $group['id'], ']" id="exclude_groups_', $group['id'], '" value="', $group['id'], '"> ', $group['name'], '</label> <em>(', $group['member_count'], ')</em><br>';
90
+	}
88 91
 
89 92
 	echo '
90 93
 							<br>
@@ -230,9 +233,10 @@  discard block
 block discarded – undo
230 233
 				<div id="bbcBox_message"></div>';
231 234
 
232 235
 	// What about smileys?
233
-	if (!empty($context['smileys']['postform']) || !empty($context['smileys']['popup']))
234
-		echo '
236
+	if (!empty($context['smileys']['postform']) || !empty($context['smileys']['popup'])) {
237
+			echo '
235 238
 				<div id="smileyBox_message"></div>';
239
+	}
236 240
 
237 241
 	// Show BBC buttons, smileys and textbox.
238 242
 	echo '
@@ -253,9 +257,10 @@  discard block
 block discarded – undo
253 257
 			<input type="hidden" name="email_force" value="', $context['email_force'], '">
254 258
 			<input type="hidden" name="total_emails" value="', $context['total_emails'], '">';
255 259
 
256
-	foreach ($context['recipients'] as $key => $values)
257
-		echo '
260
+	foreach ($context['recipients'] as $key => $values) {
261
+			echo '
258 262
 			<input type="hidden" name="', $key, '" value="', implode(($key == 'emails' ? ';' : ','), $values), '">';
263
+	}
259 264
 
260 265
 	echo '
261 266
 			<script>';
@@ -411,9 +416,10 @@  discard block
 block discarded – undo
411 416
 				<input type="hidden" name="parse_html" value="', $context['parse_html'], '">';
412 417
 
413 418
 	// All the things we must remember!
414
-	foreach ($context['recipients'] as $key => $values)
415
-		echo '
419
+	foreach ($context['recipients'] as $key => $values) {
420
+			echo '
416 421
 				<input type="hidden" name="', $key, '" value="', implode(($key == 'emails' ? ';' : ','), $values), '">';
422
+	}
417 423
 
418 424
 	echo '
419 425
 			</div><!-- .windowbg -->
@@ -446,9 +452,10 @@  discard block
 block discarded – undo
446 452
 {
447 453
 	global $context, $txt;
448 454
 
449
-	if (!empty($context['saved_successful']))
450
-		echo '
455
+	if (!empty($context['saved_successful'])) {
456
+			echo '
451 457
 			<div class="infobox">', $txt['settings_saved'], '</div>';
458
+	}
452 459
 
453 460
 	template_show_list('news_lists');
454 461
 }
Please login to merge, or discard this patch.
Themes/default/Stats.template.php 1 patch
Braces   +26 added lines, -18 removed lines patch added patch discarded remove patch
@@ -44,10 +44,11 @@  discard block
 block discarded – undo
44 44
 				<dt>', $txt['users_online_today'], ':</dt>
45 45
 				<dd>', $context['online_today'], '</dd>';
46 46
 
47
-	if (!empty($modSettings['hitStats']))
48
-		echo '
47
+	if (!empty($modSettings['hitStats'])) {
48
+			echo '
49 49
 				<dt>', $txt['num_hits'], ':</dt>
50 50
 				<dd>', $context['num_hits'], '</dd>';
51
+	}
51 52
 
52 53
 	echo '
53 54
 			</dl>
@@ -71,17 +72,19 @@  discard block
 block discarded – undo
71 72
 				<dt>', $txt['gender_stats'], ':</dt>
72 73
 				<dd>';
73 74
 
74
-		foreach ($context['gender'] as $g => $n)
75
-			echo $g, ': ', $n, '<br>';
75
+		foreach ($context['gender'] as $g => $n) {
76
+					echo $g, ': ', $n, '<br>';
77
+		}
76 78
 
77 79
 		echo '
78 80
 				</dd>';
79 81
 	}
80 82
 
81
-	if (!empty($modSettings['hitStats']))
82
-		echo '
83
+	if (!empty($modSettings['hitStats'])) {
84
+			echo '
83 85
 				<dt>', $txt['average_hits'], ':</dt>
84 86
 				<dd>', $context['average_hits'], '</dd>';
87
+	}
85 88
 
86 89
 	echo '
87 90
 			</dl>';
@@ -105,14 +108,15 @@  discard block
 block discarded – undo
105 108
 					</dt>
106 109
 					<dd class="statsbar">';
107 110
 
108
-			if (!empty($item['percent']))
109
-				echo '
111
+			if (!empty($item['percent'])) {
112
+							echo '
110 113
 						<div class="bar" style="width: ', $item['percent'], '%;">
111 114
 							<span class="righttext">', $item['num'], '</span>
112 115
 						</div>';
113
-			else
114
-				echo '
116
+			} else {
117
+							echo '
115 118
 						<div class="bar empty"><span class="righttext">', $item['num'], '</span></div>';
119
+			}
116 120
 
117 121
 			echo '
118 122
 					</dd>';
@@ -144,9 +148,10 @@  discard block
 block discarded – undo
144 148
 					<th>', $txt['stats_new_members'], '</th>
145 149
 					<th>', $txt['most_online'], '</th>';
146 150
 
147
-		if (!empty($modSettings['hitStats']))
148
-			echo '
151
+		if (!empty($modSettings['hitStats'])) {
152
+					echo '
149 153
 					<th>', $txt['page_views'], '</th>';
154
+		}
150 155
 
151 156
 		echo '
152 157
 				</tr>
@@ -165,9 +170,10 @@  discard block
 block discarded – undo
165 170
 					<th>', $year['new_members'], '</th>
166 171
 					<th>', $year['most_members_online'], '</th>';
167 172
 
168
-			if (!empty($modSettings['hitStats']))
169
-				echo '
173
+			if (!empty($modSettings['hitStats'])) {
174
+							echo '
170 175
 					<th>', $year['hits'], '</th>';
176
+			}
171 177
 
172 178
 			echo '
173 179
 				</tr>';
@@ -184,9 +190,10 @@  discard block
 block discarded – undo
184 190
 					<th>', $month['new_members'], '</th>
185 191
 					<th>', $month['most_members_online'], '</th>';
186 192
 
187
-				if (!empty($modSettings['hitStats']))
188
-					echo '
193
+				if (!empty($modSettings['hitStats'])) {
194
+									echo '
189 195
 					<th>', $month['hits'], '</th>';
196
+				}
190 197
 
191 198
 				echo '
192 199
 				</tr>';
@@ -203,9 +210,10 @@  discard block
 block discarded – undo
203 210
 					<td>', $day['new_members'], '</td>
204 211
 					<td>', $day['most_members_online'], '</td>';
205 212
 
206
-						if (!empty($modSettings['hitStats']))
207
-							echo '
213
+						if (!empty($modSettings['hitStats'])) {
214
+													echo '
208 215
 					<td>', $day['hits'], '</td>';
216
+						}
209 217
 
210 218
 						echo '
211 219
 				</tr>';
Please login to merge, or discard this patch.
Themes/default/Poll.template.php 1 patch
Braces   +12 added lines, -8 removed lines patch added patch discarded remove patch
@@ -46,8 +46,8 @@  discard block
 block discarded – undo
46 46
 				<h3 class="catbg">', $context['page_title'], '</h3>
47 47
 			</div>';
48 48
 
49
-	if (!empty($context['poll_error']['messages']))
50
-		echo '
49
+	if (!empty($context['poll_error']['messages'])) {
50
+			echo '
51 51
 			<div class="errorbox">
52 52
 				<dl class="poll_error">
53 53
 					<dt>
@@ -58,6 +58,7 @@  discard block
 block discarded – undo
58 58
 					</dt>
59 59
 				</dl>
60 60
 			</div>';
61
+	}
61 62
 
62 63
 	echo '
63 64
 			<div>
@@ -79,8 +80,9 @@  discard block
 block discarded – undo
79 80
 								<input type="text" name="options[', $choice['id'], ']" id="options-', $choice['id'], '" value="', $choice['label'], '" size="80" maxlength="255">';
80 81
 
81 82
 		// Does this option have a vote count yet, or is it new?
82
-		if ($choice['votes'] != -1)
83
-			echo ' (', $choice['votes'], ' ', $txt['votes'], ')';
83
+		if ($choice['votes'] != -1) {
84
+					echo ' (', $choice['votes'], ' ', $txt['votes'], ')';
85
+		}
84 86
 
85 87
 		echo '
86 88
 							</dd>';
@@ -118,14 +120,15 @@  discard block
 block discarded – undo
118 120
 								<input type="checkbox" id="poll_change_vote" name="poll_change_vote"', !empty($context['poll']['change_vote']) ? ' checked' : '', '>
119 121
 							</dd>';
120 122
 
121
-		if ($context['poll']['guest_vote_allowed'])
122
-			echo '
123
+		if ($context['poll']['guest_vote_allowed']) {
124
+					echo '
123 125
 							<dt>
124 126
 								<label for="poll_guest_vote">', $txt['poll_guest_vote'], ':</label>
125 127
 							</dt>
126 128
 							<dd>
127 129
 								<input type="checkbox" id="poll_guest_vote" name="poll_guest_vote"', !empty($context['poll']['guest_vote']) ? ' checked' : '', '>
128 130
 							</dd>';
131
+		}
129 132
 	}
130 133
 
131 134
 	echo '
@@ -141,12 +144,13 @@  discard block
 block discarded – undo
141 144
 					</fieldset>';
142 145
 
143 146
 	// If this is an edit, we can allow them to reset the vote counts.
144
-	if ($context['is_edit'])
145
-		echo '
147
+	if ($context['is_edit']) {
148
+			echo '
146 149
 					<fieldset id="poll_reset">
147 150
 						<legend>', $txt['reset_votes'], '</legend>
148 151
 						<input type="checkbox" name="resetVoteCount" value="on"> ' . $txt['reset_votes_check'] . '
149 152
 					</fieldset>';
153
+	}
150 154
 	echo '
151 155
 					<input type="submit" name="post" value="', $txt['save'], '" onclick="return submitThisOnce(this);" accesskey="s" class="button">
152 156
 				</div><!-- .roundframe -->
Please login to merge, or discard this patch.
Themes/default/ManageMembers.template.php 1 patch
Braces   +6 added lines, -4 removed lines patch added patch discarded remove patch
@@ -148,8 +148,8 @@  discard block
 block discarded – undo
148 148
 				</thead>
149 149
 				<tbody>';
150 150
 
151
-	foreach ($context['membergroups'] as $membergroup)
152
-		echo '
151
+	foreach ($context['membergroups'] as $membergroup) {
152
+			echo '
153 153
 					<tr class="windowbg">
154 154
 						<td>', $membergroup['name'], '</td>
155 155
 						<td class="centercol">
@@ -159,6 +159,7 @@  discard block
 block discarded – undo
159 159
 							', $membergroup['can_be_additional'] ? '<input type="checkbox" name="membergroups[2][]" value="' . $membergroup['id'] . '" checked>' : '', '
160 160
 						</td>
161 161
 					</tr>';
162
+	}
162 163
 
163 164
 	echo '
164 165
 					<tr class="windowbg">
@@ -185,8 +186,8 @@  discard block
 block discarded – undo
185 186
 				</thead>
186 187
 				<tbody>';
187 188
 
188
-	foreach ($context['postgroups'] as $postgroup)
189
-		echo '
189
+	foreach ($context['postgroups'] as $postgroup) {
190
+			echo '
190 191
 					<tr class="windowbg">
191 192
 						<td>
192 193
 							', $postgroup['name'], '
@@ -195,6 +196,7 @@  discard block
 block discarded – undo
195 196
 							<input type="checkbox" name="postgroups[]" value="', $postgroup['id'], '" checked>
196 197
 						</td>
197 198
 					</tr>';
199
+	}
198 200
 
199 201
 	echo '
200 202
 					<tr class="windowbg">
Please login to merge, or discard this patch.
Themes/default/Printpage.template.php 1 patch
Braces   +11 added lines, -8 removed lines patch added patch discarded remove patch
@@ -144,11 +144,12 @@  discard block
 block discarded – undo
144 144
 				<div class="question">', $txt['poll_question'], ': <strong>', $context['poll']['question'], '</strong>';
145 145
 
146 146
 		$options = 1;
147
-		foreach ($context['poll']['options'] as $option)
148
-			echo '
147
+		foreach ($context['poll']['options'] as $option) {
148
+					echo '
149 149
 					<div class="', $option['voted_this'] ? 'voted' : '', '">', $txt['option'], ' ', $options++, ': <strong>', $option['option'], '</strong>
150 150
 						', $context['allow_poll_view'] ? $txt['votes'] . ': ' . $option['votes'] . '' : '', '
151 151
 					</div>';
152
+		}
152 153
 
153 154
 		echo '
154 155
 			</div>';
@@ -170,9 +171,10 @@  discard block
 block discarded – undo
170 171
 			echo '
171 172
 				<hr>';
172 173
 
173
-			foreach ($context['printattach'][$post['id_msg']] as $attach)
174
-				echo '
174
+			foreach ($context['printattach'][$post['id_msg']] as $attach) {
175
+							echo '
175 176
 					<img width="' . $attach['width'] . '" height="' . $attach['height'] . '" src="', $scripturl . '?action=dlattach;topic=' . $topic . '.0;attach=' . $attach['id_attach'] . '" alt="">';
177
+			}
176 178
 		}
177 179
 
178 180
 		echo '
@@ -207,12 +209,13 @@  discard block
 block discarded – undo
207 209
 		<div class="print_options">';
208 210
 
209 211
 	// Which option is set, text or text&images
210
-	if (isset($_REQUEST['images']))
211
-		echo '
212
+	if (isset($_REQUEST['images'])) {
213
+			echo '
212 214
 			<a href="', $url_text, '">', $txt['print_page_text'], '</a> | <strong><a href="', $url_images, '">', $txt['print_page_images'], '</a></strong>';
213
-	else
214
-		echo '
215
+	} else {
216
+			echo '
215 217
 			<strong><a href="', $url_text, '">', $txt['print_page_text'], '</a></strong> | <a href="', $url_images, '">', $txt['print_page_images'], '</a>';
218
+	}
216 219
 
217 220
 	echo '
218 221
 		</div><!-- .print_options -->';
Please login to merge, or discard this patch.