Code Duplication    Length = 14-22 lines in 3 locations

Sources/Load.php 1 location

@@ 1298-1311 (lines=14) @@
1295
		$smcFunc['db_free_result']($request);
1296
	}
1297
1298
	if (!empty($new_loaded_ids) && $set !== 'minimal')
1299
	{
1300
		$request = $smcFunc['db_query']('', '
1301
			SELECT id_member, variable, value
1302
			FROM {db_prefix}themes
1303
			WHERE id_member IN ({array_int:loaded_ids})',
1304
			array(
1305
				'loaded_ids' => $new_loaded_ids,
1306
			)
1307
		);
1308
		while ($row = $smcFunc['db_fetch_assoc']($request))
1309
			$user_profile[$row['id_member']]['options'][$row['variable']] = $row['value'];
1310
		$smcFunc['db_free_result']($request);
1311
	}
1312
1313
	$additional_mods = array();
1314

Sources/PersonalMessage.php 2 locations

@@ 2576-2597 (lines=22) @@
2573
	if (!empty($to_label) && $context['folder'] == 'inbox')
2574
	{
2575
		// Are we dealing with conversation view? If so, get all the messages in each conversation
2576
		if ($context['display_mode'] == 2)
2577
		{
2578
			$get_pms = $smcFunc['db_query']('', '
2579
				SELECT pm.id_pm_head, pm.id_pm
2580
				FROM {db_prefix}personal_messages AS pm
2581
					INNER JOIN {db_prefix}pm_recipients AS pmr ON (pmr.id_pm = pm.id_pm)
2582
				WHERE pm.id_pm_head IN ({array_int:head_pms})
2583
					AND pm.id_pm NOT IN ({array_int:head_pms})
2584
					AND pmr.id_member = {int:current_member}',
2585
				array(
2586
					'head_pms' => array_keys($to_label),
2587
					'current_member' => $user_info['id'],
2588
				)
2589
			);
2590
2591
			while ($other_pms = $smcFunc['db_fetch_assoc']($get_pms))
2592
			{
2593
				$to_label[$other_pms['id_pm']] = $to_label[$other_pms['id_pm_head']];
2594
			}
2595
2596
			$smcFunc['db_free_result']($get_pms);
2597
		}
2598
2599
		// Get information about each message...
2600
		$request = $smcFunc['db_query']('', '
@@ 3711-3724 (lines=14) @@
3708
				if ($criteria['t'] == 'mid' && !empty($criteria['v']))
3709
					$members[(int) $criteria['v']] = $k;
3710
3711
			if (!empty($members))
3712
			{
3713
				$request = $smcFunc['db_query']('', '
3714
					SELECT id_member, member_name
3715
					FROM {db_prefix}members
3716
					WHERE id_member IN ({array_int:member_list})',
3717
					array(
3718
						'member_list' => array_keys($members),
3719
					)
3720
				);
3721
				while ($row = $smcFunc['db_fetch_assoc']($request))
3722
					$context['rule']['criteria'][$members[$row['id_member']]]['v'] = $row['member_name'];
3723
				$smcFunc['db_free_result']($request);
3724
			}
3725
		}
3726
		else
3727
			$context['rule'] = array(