Code Duplication    Length = 12-14 lines in 4 locations

Sources/Subs-Membergroups.php 1 location

@@ 49-62 (lines=14) @@
46
	$protected_groups = array(-1, 0, 1, 3, 4);
47
48
	// There maybe some others as well.
49
	if (!allowedTo('admin_forum'))
50
	{
51
		$request = $smcFunc['db_query']('', '
52
			SELECT id_group
53
			FROM {db_prefix}membergroups
54
			WHERE group_type = {int:is_protected}',
55
			array(
56
				'is_protected' => 1,
57
			)
58
		);
59
		while ($row = $smcFunc['db_fetch_assoc']($request))
60
			$protected_groups[] = $row['id_group'];
61
		$smcFunc['db_free_result']($request);
62
	}
63
64
	// Make sure they don't delete protected groups!
65
	$groups = array_diff($groups, array_unique($protected_groups));

Sources/Subs-Post.php 2 locations

@@ 947-958 (lines=12) @@
944
	// Load the membergrounp message limits.
945
	// @todo Consider caching this?
946
	static $message_limit_cache = array();
947
	if (!allowedTo('moderate_forum') && empty($message_limit_cache))
948
	{
949
		$request = $smcFunc['db_query']('', '
950
			SELECT id_group, max_messages
951
			FROM {db_prefix}membergroups',
952
			array(
953
			)
954
		);
955
		while ($row = $smcFunc['db_fetch_assoc']($request))
956
			$message_limit_cache[$row['id_group']] = $row['max_messages'];
957
		$smcFunc['db_free_result']($request);
958
	}
959
960
	// Load the groups that are allowed to read PMs.
961
	require_once($sourcedir . '/Subs-Members.php');
@@ 1138-1151 (lines=14) @@
1135
		$message = '';
1136
1137
	$to_names = array();
1138
	if (count($to_list) > 1)
1139
	{
1140
		$request = $smcFunc['db_query']('', '
1141
			SELECT real_name
1142
			FROM {db_prefix}members
1143
			WHERE id_member IN ({array_int:to_members})',
1144
			array(
1145
				'to_members' => $to_list,
1146
			)
1147
		);
1148
		while ($row = $smcFunc['db_fetch_assoc']($request))
1149
			$to_names[] = un_htmlspecialchars($row['real_name']);
1150
		$smcFunc['db_free_result']($request);
1151
	}
1152
	$replacements = array(
1153
		'SUBJECT' => $subject,
1154
		'MESSAGE' => $message,

Sources/RemoveTopic.php 1 location

@@ 1475-1488 (lines=14) @@
1472
	if (!empty($source_topic_data['id_first_msg']) && $from_first_msg != $source_topic_data['id_first_msg'])
1473
		$cache_updates[] = $source_topic_data['id_first_msg'];
1474
1475
	if (!empty($cache_updates))
1476
	{
1477
		$request = $smcFunc['db_query']('', '
1478
			SELECT id_topic, subject
1479
			FROM {db_prefix}messages
1480
			WHERE id_msg IN ({array_int:first_messages})',
1481
			array(
1482
				'first_messages' => $cache_updates,
1483
			)
1484
		);
1485
		while ($row = $smcFunc['db_fetch_assoc']($request))
1486
			updateStats('subject', $row['id_topic'], $row['subject']);
1487
		$smcFunc['db_free_result']($request);
1488
	}
1489
1490
	updateLastMessages(array($from_board, $target_board));
1491
}