Vergleich admin/modules/user/users.php - 1.8.12 - 1.8.38

			}
		}

			}
		}

		{

		{

		}
	}

		}
	}

if($mybb->input['action'] == "activate_user")
{

if($mybb->input['action'] == "activate_user")
{

	{
		flash_message($lang->invalid_post_verify_key2, 'error');
		admin_redirect("index.php?module=user-users");

	{
		flash_message($lang->invalid_post_verify_key2, 'error');
		admin_redirect("index.php?module=user-users");

	$user = get_user($mybb->input['uid']);

	// Does the user not exist?

	$user = get_user($mybb->input['uid']);

	// Does the user not exist?

	{
		flash_message($lang->error_invalid_user, 'error');
		admin_redirect("index.php?module=user-users");

	{
		flash_message($lang->error_invalid_user, 'error');
		admin_redirect("index.php?module=user-users");

	// Update
	if($user['coppauser'])

	// Update
	if($user['coppauser'])

		$updated_user = array(
			"coppauser" => 0
		);

		$updated_user = array(
			"coppauser" => 0
		);

	else
	{
		$db->delete_query("awaitingactivation", "uid='{$user['uid']}'");

	else
	{
		$db->delete_query("awaitingactivation", "uid='{$user['uid']}'");

	}

	$plugins->run_hooks("admin_user_users_coppa_activate_commit");

	}

	$plugins->run_hooks("admin_user_users_coppa_activate_commit");

	$db->update_query("users", $updated_user, "uid='{$user['uid']}'");

	$cache->update_awaitingactivation();

	$db->update_query("users", $updated_user, "uid='{$user['uid']}'");

	$cache->update_awaitingactivation();

	my_mail($user['email'], $lang->sprintf($lang->emailsubject_activateaccount, $mybb->settings['bbname']), $message);

	// Log admin action

	my_mail($user['email'], $lang->sprintf($lang->emailsubject_activateaccount, $mybb->settings['bbname']), $message);

	// Log admin action

	if($mybb->input['from'] == "home")

	if($mybb->input['from'] == "home")

		if($user['coppauser'])
		{
			$message = $lang->success_coppa_activated;
		}

		if($user['coppauser'])
		{
			$message = $lang->success_coppa_activated;
		}

		update_admin_session('flash_message2', array('message' => $message, 'type' => 'success'));
	}
	else
	{
		if($user['coppauser'])

		update_admin_session('flash_message2', array('message' => $message, 'type' => 'success'));
	}
	else
	{
		if($user['coppauser'])

			flash_message($lang->success_coppa_activated, 'success');
		}
		else
		{
			flash_message($lang->success_activated, 'success');

			flash_message($lang->success_coppa_activated, 'success');
		}
		else
		{
			flash_message($lang->success_activated, 'success');

	if($admin_session['data']['last_users_url'])
	{
		$url = $admin_session['data']['last_users_url'];

	if($admin_session['data']['last_users_url'])
	{
		$url = $admin_session['data']['last_users_url'];

	if($mybb->request_method == "post")
	{
		// Determine the usergroup stuff

	if($mybb->request_method == "post")
	{
		// Determine the usergroup stuff

		{
			foreach($mybb->input['additionalgroups'] as $key => $gid)
			{

		{
			foreach($mybb->input['additionalgroups'] as $key => $gid)
			{

					unset($mybb->input['additionalgroups'][$key]);
				}
			}

					unset($mybb->input['additionalgroups'][$key]);
				}
			}

		}
		else
		{

		}
		else
		{

		// Set the data for the new user.
		$new_user = array(

		// Set the data for the new user.
		$new_user = array(

			"additionalgroups" => $additionalgroups,

			"additionalgroups" => $additionalgroups,

			"profile_fields_editable" => true,
		);

			"profile_fields_editable" => true,
		);

		// Set the data of the user in the datahandler.
		$userhandler->set_data($new_user);
		$errors = '';

		// Set the data of the user in the datahandler.
		$userhandler->set_data($new_user);
		$errors = '';

		// Validate the user and get any errors that might have occurred.
		if(!$userhandler->validate_user())

		// Validate the user and get any errors that might have occurred.
		if(!$userhandler->validate_user())

			$errors = $userhandler->get_friendly_errors();
		}
		else
		{
			$user_info = $userhandler->insert_user();

			$errors = $userhandler->get_friendly_errors();
		}
		else
		{
			$user_info = $userhandler->insert_user();

			$plugins->run_hooks("admin_user_users_add_commit");

			// Log admin action

			$plugins->run_hooks("admin_user_users_add_commit");

			// Log admin action

			flash_message($lang->success_user_created, 'success');
			admin_redirect("index.php?module=user-users&action=edit&uid={$user_info['uid']}");

			flash_message($lang->success_user_created, 'success');
			admin_redirect("index.php?module=user-users&action=edit&uid={$user_info['uid']}");

	// Fetch custom profile fields - only need required profile fields here
	$query = $db->simple_select("profilefields", "*", "required=1", array('order_by' => 'disporder'));

	// Fetch custom profile fields - only need required profile fields here
	$query = $db->simple_select("profilefields", "*", "required=1", array('order_by' => 'disporder'));

	while($profile_field = $db->fetch_array($query))
	{
		$profile_fields['required'][] = $profile_field;

	while($profile_field = $db->fetch_array($query))
	{
		$profile_fields['required'][] = $profile_field;

	$page->add_breadcrumb_item($lang->create_user);
	$page->output_header($lang->create_user);

	$form = new Form("index.php?module=user-users&action=add", "post");

	$page->add_breadcrumb_item($lang->create_user);
	$page->output_header($lang->create_user);

	$form = new Form("index.php?module=user-users&action=add", "post");

	$page->output_nav_tabs($sub_tabs, 'create_user');

	// If we have any error messages, show them

	$page->output_nav_tabs($sub_tabs, 'create_user');

	// If we have any error messages, show them

	{
		$mybb->input = array_merge($mybb->input, array('usergroup' => 2));
	}

	{
		$mybb->input = array_merge($mybb->input, array('usergroup' => 2));
	}

	$form_container = new FormContainer($lang->required_profile_info);
	$form_container->output_row($lang->username." <em>*</em>", "", $form->generate_text_box('username', htmlspecialchars_uni($mybb->get_input('username')), array('id' => 'username')), 'username');

	$form_container = new FormContainer($lang->required_profile_info);
	$form_container->output_row($lang->username." <em>*</em>", "", $form->generate_text_box('username', htmlspecialchars_uni($mybb->get_input('username')), array('id' => 'username')), 'username');

	$display_group_options[0] = $lang->use_primary_user_group;
	$options = array();

	$display_group_options[0] = $lang->use_primary_user_group;
	$options = array();

		$display_group_options[$usergroup['gid']] = htmlspecialchars_uni($usergroup['title']);
	}

		$display_group_options[$usergroup['gid']] = htmlspecialchars_uni($usergroup['title']);
	}

	// Output custom profile fields - required

	// Output custom profile fields - required

	$form_container->end();
	$buttons[] = $form->generate_submit_button($lang->save_user);

	$form_container->end();
	$buttons[] = $form->generate_submit_button($lang->save_user);

	$user = get_user($mybb->input['uid']);

	// Does the user not exist?

	$user = get_user($mybb->input['uid']);

	// Does the user not exist?

	{
		flash_message($lang->error_invalid_user, 'error');
		admin_redirect("index.php?module=user-users");

	{
		flash_message($lang->error_invalid_user, 'error');
		admin_redirect("index.php?module=user-users");

		}

		// Determine the usergroup stuff

		}

		// Determine the usergroup stuff

		{
			foreach($mybb->input['additionalgroups'] as $key => $gid)
			{

		{
			foreach($mybb->input['additionalgroups'] as $key => $gid)
			{

					unset($mybb->input['additionalgroups'][$key]);
				}
			}

					unset($mybb->input['additionalgroups'][$key]);
				}
			}

		}
		else
		{

		}
		else
		{

		// Set the data for the new user.
		$updated_user = array(

		// Set the data for the new user.
		$updated_user = array(

			"additionalgroups" => $additionalgroups,

			"additionalgroups" => $additionalgroups,

			"profile_fields_editable" => true,

			"profile_fields_editable" => true,

			"birthday" => array(

			"birthday" => array(

			),

			),

			"dateformat" => $mybb->get_input('dateformat', MyBB::INPUT_INT),
			"timeformat" => $mybb->get_input('timeformat', MyBB::INPUT_INT),

			"dateformat" => $mybb->get_input('dateformat', MyBB::INPUT_INT),
			"timeformat" => $mybb->get_input('timeformat', MyBB::INPUT_INT),

			"away" => array(

			"away" => array(

				"date" => TIME_NOW,
				"returndate" => $returndate,

				"date" => TIME_NOW,
				"returndate" => $returndate,

			)
		);

			)
		);

		{
			if($user['coppauser'] == 1)
			{
				$updated_user['coppa_user'] = 0;
			}
		}

		{
			if($user['coppauser'] == 1)
			{
				$updated_user['coppa_user'] = 0;
			}
		}

		{

		{

		}

		$updated_user['options'] = array(

		}

		$updated_user['options'] = array(

		);

		if($mybb->settings['usertppoptions'])

		);

		if($mybb->settings['usertppoptions'])

		else
		{
			// Are we removing an avatar from this user?

		else
		{
			// Are we removing an avatar from this user?

			{
				$extra_user_updates = array(
					"avatar" => "",

			{
				$extra_user_updates = array(
					"avatar" => "",

				}
			}
			// Are we setting a new avatar from a URL?

				}
			}
			// Are we setting a new avatar from a URL?

			{
				if(!$mybb->settings['allowremoteavatars'])
				{

			{
				if(!$mybb->settings['allowremoteavatars'])
				{

						}

						// Because Gravatars are square, hijack the width

						}

						// Because Gravatars are square, hijack the width

						$s = "?s={$maxwidth}";
						$maxheight = (int)$maxwidth;

						$s = "?s={$maxwidth}";
						$maxheight = (int)$maxwidth;

						{
							if($width && $height && $mybb->settings['maxavatardims'] != "")
							{

						{
							if($width && $height && $mybb->settings['maxavatardims'] != "")
							{

								if(($maxwidth && $width > $maxwidth) || ($maxheight && $height > $maxheight))
								{
									$lang->error_avatartoobig = $lang->sprintf($lang->error_avatartoobig, $maxwidth, $maxheight);

								if(($maxwidth && $width > $maxwidth) || ($maxheight && $height > $maxheight))
								{
									$lang->error_avatartoobig = $lang->sprintf($lang->error_avatartoobig, $maxwidth, $maxheight);

			require_once MYBB_ROOT."inc/functions_warnings.php";
			foreach($moderator_options as $option)
			{

			require_once MYBB_ROOT."inc/functions_warnings.php";
			foreach($moderator_options as $option)
			{

				{
					if($user[$option['update_field']] == 1)
					{

				{
					if($user[$option['update_field']] == 1)
					{

					// Skip this option if we haven't selected it
					continue;
				}

					// Skip this option if we haven't selected it
					continue;
				}

				{
					if((int)$mybb->input[$option['time']] == 0 && $mybb->input[$option['period']] != "never" && $user[$option['update_field']] != 1)
					{

				{
					if((int)$mybb->input[$option['time']] == 0 && $mybb->input[$option['period']] != "never" && $user[$option['update_field']] != 1)
					{

				}
			}

				}
			}

			{
				$errors[] = $lang->suspendmoderate_error;
			}

			{
				$errors[] = $lang->suspendmoderate_error;
			}

				$plugins->run_hooks("admin_user_users_edit_commit_start");

				$plugins->run_hooks("admin_user_users_edit_commit_start");

				// if we're updating the user's signature preferences, do so now
				if($mybb->input['update_posts'] == 'enable' || $mybb->input['update_posts'] == 'disable')

				// if we're updating the user's signature preferences, do so now
				if($mybb->input['update_posts'] == 'enable' || $mybb->input['update_posts'] == 'disable')

				}

				// Log admin action

				}

				// Log admin action

				flash_message($lang->success_user_updated, 'success');
				admin_redirect("index.php?module=user-users");

				flash_message($lang->success_user_updated, 'success');
				admin_redirect("index.php?module=user-users");

		}
	}

		}
	}

	{
		$mybb->input['away_year'] = $mybb->get_input('away_year', MyBB::INPUT_INT);
	}

	{
		$mybb->input['away_year'] = $mybb->get_input('away_year', MyBB::INPUT_INT);
	}

	// Fetch custom profile fields
	$query = $db->simple_select("profilefields", "*", "", array('order_by' => 'disporder'));

	// Fetch custom profile fields
	$query = $db->simple_select("profilefields", "*", "", array('order_by' => 'disporder'));

	while($profile_field = $db->fetch_array($query))
	{
		if($profile_field['required'] == 1)

	while($profile_field = $db->fetch_array($query))
	{
		if($profile_field['required'] == 1)

			$profile_fields['required'][] = $profile_field;
		}
		else

			$profile_fields['required'][] = $profile_field;
		}
		else

	}

	$page->add_breadcrumb_item($lang->edit_user.": ".htmlspecialchars_uni($user['username']));

	}

	$page->add_breadcrumb_item($lang->edit_user.": ".htmlspecialchars_uni($user['username']));

	$page->extra_header .= <<<EOF

	$page->extra_header .= <<<EOF

EOF;
	$page->output_header($lang->edit_user);

EOF;
	$page->output_header($lang->edit_user);

	$form = new Form("index.php?module=user-users&action=edit&uid={$user['uid']}", "post", "", 1);

	$page->output_nav_tabs($sub_tabs, 'edit_user');

	$form = new Form("index.php?module=user-users&action=edit&uid={$user['uid']}", "post", "", 1);

	$page->output_nav_tabs($sub_tabs, 'edit_user');

	// If we have any error messages, show them
	if($errors)
	{
		$page->output_inline_error($errors);

	// If we have any error messages, show them
	if($errors)
	{
		$page->output_inline_error($errors);

	// Is this user a COPPA user? We show a warning & activate link
	if($user['coppauser'])
	{

	// Is this user a COPPA user? We show a warning & activate link
	if($user['coppauser'])
	{

	}

	$tabs = array(

	}

	$tabs = array(

	$table->construct_header($lang->general_account_stats, array('colspan' => '2', 'class' => 'align_center'));

	// Avatar

	$table->construct_header($lang->general_account_stats, array('colspan' => '2', 'class' => 'align_center'));

	// Avatar

	{

	{

		if(!my_validate_url($user['avatar']))
		{

		if(!my_validate_url($user['avatar']))
		{

		}
	}
	else

		}
	}
	else

		else
		{
			$user['avatar'] = "../".str_replace('{theme}', 'images', $mybb->settings['useravatar']);

		else
		{
			$user['avatar'] = "../".str_replace('{theme}', 'images', $mybb->settings['useravatar']);

	}
	$avatar_top = ceil((126-$scaled_dimensions['height'])/2);

	}
	$avatar_top = ceil((126-$scaled_dimensions['height'])/2);

	{

	{

	}
	else
	{

	}
	else
	{

			$warning_level = 100;
		}
		$warning_level = get_colored_warning_level($warning_level);

			$warning_level = 100;
		}
		$warning_level = get_colored_warning_level($warning_level);

	}

	$age = $lang->na;

	}

	$age = $lang->na;

		$display_group_options[$usergroup['gid']] = htmlspecialchars_uni($usergroup['title']);
	}

		$display_group_options[$usergroup['gid']] = htmlspecialchars_uni($usergroup['title']);
	}

	{
		$mybb->input['additionalgroups'] = explode(',', $mybb->input['additionalgroups']);
	}

	{
		$mybb->input['additionalgroups'] = explode(',', $mybb->input['additionalgroups']);
	}

	// Output custom profile fields - required
	if(!isset($profile_fields['required']))
	{
		$profile_fields['required'] = array();
	}

	// Output custom profile fields - required
	if(!isset($profile_fields['required']))
	{
		$profile_fields['required'] = array();
	}

	$form_container->end();

	$form_container = new FormContainer($lang->optional_profile_info.': '.htmlspecialchars_uni($user['username']));

	$form_container->end();

	$form_container = new FormContainer($lang->optional_profile_info.': '.htmlspecialchars_uni($user['username']));

	// Birthday
	$birthday_days = array(0 => '');

	// Birthday
	$birthday_days = array(0 => '');

	// Output custom profile fields - optional
	output_custom_profile_fields($profile_fields['optional'], $mybb->input['profile_fields'], $form_container, $form);

	// Output custom profile fields - optional
	output_custom_profile_fields($profile_fields['optional'], $mybb->input['profile_fields'], $form_container, $form);

	$form_container->end();

	$form_container->end();

	//
	// ACCOUNT SETTINGS
	//

	//
	// ACCOUNT SETTINGS
	//

	echo "<div id=\"tab_settings\">\n";
	$form_container = new FormContainer($lang->account_settings.': '.htmlspecialchars_uni($user['username']));
	$login_options = array(

	echo "<div id=\"tab_settings\">\n";
	$form_container = new FormContainer($lang->account_settings.': '.htmlspecialchars_uni($user['username']));
	$login_options = array(

	$form_container->output_row($lang->login_cookies_privacy, "", "<div class=\"user_settings_bit\">".implode("</div><div class=\"user_settings_bit\">", $login_options)."</div>");

	$form_container->output_row($lang->login_cookies_privacy, "", "<div class=\"user_settings_bit\">".implode("</div><div class=\"user_settings_bit\">", $login_options)."</div>");

	{
		$mybb->input['pmnotice'] = 1;
	}

	$messaging_options = array(

	{
		$mybb->input['pmnotice'] = 1;
	}

	$messaging_options = array(

	);

	);

	$form_container->output_row($lang->messaging_and_notification, "", "<div class=\"user_settings_bit\">".implode("</div><div class=\"user_settings_bit\">", $messaging_options)."</div>");

	$date_format_options = array($lang->use_default);

	$form_container->output_row($lang->messaging_and_notification, "", "<div class=\"user_settings_bit\">".implode("</div><div class=\"user_settings_bit\">", $messaging_options)."</div>");

	$date_format_options = array($lang->use_default);

	foreach($time_formats as $key => $format)
	{
		$time_format_options[$key] = my_date($format, TIME_NOW, "", 0);

	foreach($time_formats as $key => $format)
	{
		$time_format_options[$key] = my_date($format, TIME_NOW, "", 0);

	$date_options = array(

	$date_options = array(

	);

	);

	$form_container->output_row($lang->date_and_time_options, "", "<div class=\"user_settings_bit\">".implode("</div><div class=\"user_settings_bit\">", $date_options)."</div>");

	$form_container->output_row($lang->date_and_time_options, "", "<div class=\"user_settings_bit\">".implode("</div><div class=\"user_settings_bit\">", $date_options)."</div>");

	);

	$forum_options = array(

	);

	$forum_options = array(

	);

	);

	$form_container->output_row($lang->forum_display_options, "", "<div class=\"user_settings_bit\">".implode("</div><div class=\"user_settings_bit\">", $forum_options)."</div>");

	$ppp_options = array($lang->use_default);

	$form_container->output_row($lang->forum_display_options, "", "<div class=\"user_settings_bit\">".implode("</div><div class=\"user_settings_bit\">", $forum_options)."</div>");

	$ppp_options = array($lang->use_default);

			}
		}
	}

			}
		}
	}

	$thread_options = array(

	$thread_options = array(

		"<label for=\"threadmode\">{$lang->default_thread_view_mode}:</label><br />".$form->generate_select_box("threadmode", array("" => $lang->use_default, "linear" => $lang->linear_mode, "threaded" => $lang->threaded_mode), $mybb->input['threadmode'], array('id' => 'threadmode'))
	);

		"<label for=\"threadmode\">{$lang->default_thread_view_mode}:</label><br />".$form->generate_select_box("threadmode", array("" => $lang->use_default, "linear" => $lang->linear_mode, "threaded" => $lang->threaded_mode), $mybb->input['threadmode'], array('id' => 'threadmode'))
	);

	$languages = array_merge(array('' => $lang->use_default), $lang->get_languages());

	$other_options = array(

	$languages = array_merge(array('' => $lang->use_default), $lang->get_languages());

	$other_options = array(

	);

	);

	$form_container->output_row($lang->other_options, "", "<div class=\"user_settings_bit\">".implode("</div><div class=\"user_settings_bit\">", $other_options)."</div>");

	$form_container->end();
	$plugins->run_hooks("admin_user_users_edit_settings");
	echo "</div>\n";

	$form_container->output_row($lang->other_options, "", "<div class=\"user_settings_bit\">".implode("</div><div class=\"user_settings_bit\">", $other_options)."</div>");

	$form_container->end();
	$plugins->run_hooks("admin_user_users_edit_settings");
	echo "</div>\n";

	// SIGNATURE EDITOR
	//

	// SIGNATURE EDITOR
	//

	$sig_smilies = $lang->off;
	if($mybb->settings['sigsmilies'] == 1)
	{

	$sig_smilies = $lang->off;
	if($mybb->settings['sigsmilies'] == 1)
	{

	}
	$sig_html = $lang->off;
	if($mybb->settings['sightml'] == 1)

	}
	$sig_html = $lang->off;
	if($mybb->settings['sightml'] == 1)

		$sig_html = $lang->on;
	}
	$sig_imgcode = $lang->off;

		$sig_html = $lang->on;
	}
	$sig_imgcode = $lang->off;

	);

	// Are we already suspending the signature?

	);

	// Are we already suspending the signature?

	{
		$sig_checked = 1;

	{
		$sig_checked = 1;

				<tr>
					<td colspan="2">'.$lang->suspend_expire_info.'<br />'.$lang->suspend_sig_extend.'</td>
				</tr>';

				<tr>
					<td colspan="2">'.$lang->suspend_expire_info.'<br />'.$lang->suspend_sig_extend.'</td>
				</tr>';

	else
	{
		$sig_checked = 0;

	else
	{
		$sig_checked = 0;

	if($errors)
	{

	if($errors)
	{

	}

	if($mybb->settings['maxavatardims'] != "")
	{

	}

	if($mybb->settings['maxavatardims'] != "")
	{

		$max_size = "<br />{$lang->max_dimensions_are} {$max_width}x{$max_height}";
	}

		$max_size = "<br />{$lang->max_dimensions_are} {$max_width}x{$max_height}";
	}

	// Do we have any existing suspensions here?
	$existing_info = '';

	// Do we have any existing suspensions here?
	$existing_info = '';

	{
		$mybb->input['moderateposting'] = 1;
		if($user['moderationtime'] != 0)

	{
		$mybb->input['moderateposting'] = 1;
		if($user['moderationtime'] != 0)

		}
	}

		}
	}

	$lang->moderate_posts_info = $lang->sprintf($lang->moderate_posts_info, htmlspecialchars_uni($user['username']));

	$lang->moderate_posts_info = $lang->sprintf($lang->moderate_posts_info, htmlspecialchars_uni($user['username']));

	// Suspend posts
	// Generate check box

	// Suspend posts
	// Generate check box

	// Do we have any existing suspensions here?

	// Do we have any existing suspensions here?

	{
		$mybb->input['suspendposting'] = 1;

	{
		$mybb->input['suspendposting'] = 1;

		{
			$existing_info = $lang->suspended_perm;
		}

		{
			$existing_info = $lang->suspended_perm;
		}

		}
	}

		}
	}

	$lang->suspend_posts_info = $lang->sprintf($lang->suspend_posts_info, htmlspecialchars_uni($user['username']));

	$lang->suspend_posts_info = $lang->sprintf($lang->suspend_posts_info, htmlspecialchars_uni($user['username']));

	$form_container->end();

	$form_container->end();

	$user = get_user($mybb->input['uid']);

	// Does the user not exist?

	$user = get_user($mybb->input['uid']);

	// Does the user not exist?

	{
		flash_message($lang->error_invalid_user, 'error');
		admin_redirect("index.php?module=user-users");

	{
		flash_message($lang->error_invalid_user, 'error');
		admin_redirect("index.php?module=user-users");

	}

	// User clicked no

	}

	// User clicked no

	{
		admin_redirect("index.php?module=user-users");
	}

	{
		admin_redirect("index.php?module=user-users");
	}

		$plugins->run_hooks("admin_user_users_delete_commit_end");

		$plugins->run_hooks("admin_user_users_delete_commit_end");

		flash_message($lang->success_user_deleted, 'success');
		admin_redirect("index.php?module=user-users");

		flash_message($lang->success_user_deleted, 'success');
		admin_redirect("index.php?module=user-users");

	$query = $db->simple_select("adminviews", "*", "type='user' AND (vid='{$default_view}' OR uid=0)", array("order_by" => "uid", "order_dir" => "desc"));
	$admin_view = $db->fetch_array($query);

	$query = $db->simple_select("adminviews", "*", "type='user' AND (vid='{$default_view}' OR uid=0)", array("order_by" => "uid", "order_dir" => "desc"));
	$admin_view = $db->fetch_array($query);

	{
		$admin_view['view_type'] = $mybb->input['type'];
	}

	{
		$admin_view['view_type'] = $mybb->input['type'];
	}

	$user = $db->fetch_array($query);

	// Log admin action

	$user = $db->fetch_array($query);

	// Log admin action

	$table = new Table;

	$table = new Table;

	{
		$user['lastip'] = my_inet_ntop($db->unescape_binary($user['lastip']));
		$popup = new PopupMenu("user_last", $lang->options);

	{
		$user['lastip'] = my_inet_ntop($db->unescape_binary($user['lastip']));
		$popup = new PopupMenu("user_last", $lang->options);

		$popup->add_item($lang->info_on_ip, "index.php?module=user-users&action=iplookup&ipaddress={$user['lastip']}", "MyBB.popupWindow('index.php?module=user-users&action=iplookup&ipaddress={$user['lastip']}', null, true); return false;");
		$popup->add_item($lang->ban_ip, "index.php?module=config-banning&filter={$user['lastip']}");
		$controls = $popup->fetch();

		$popup->add_item($lang->info_on_ip, "index.php?module=user-users&action=iplookup&ipaddress={$user['lastip']}", "MyBB.popupWindow('index.php?module=user-users&action=iplookup&ipaddress={$user['lastip']}', null, true); return false;");
		$popup->add_item($lang->ban_ip, "index.php?module=config-banning&filter={$user['lastip']}");
		$controls = $popup->fetch();

	{
		$user['regip'] = my_inet_ntop($db->unescape_binary($user['regip']));
		$popup = new PopupMenu("user_reg", $lang->options);

	{
		$user['regip'] = my_inet_ntop($db->unescape_binary($user['regip']));
		$popup = new PopupMenu("user_reg", $lang->options);

		$popup->add_item($lang->info_on_ip, "index.php?module=user-users&action=iplookup&ipaddress={$user['regip']}", "MyBB.popupWindow('index.php?module=user-users&action=iplookup&ipaddress={$user['regip']}', null, true); return false;");
		$popup->add_item($lang->ban_ip, "index.php?module=config-banning&filter={$user['regip']}");
		$controls = $popup->fetch();

		$popup->add_item($lang->info_on_ip, "index.php?module=user-users&action=iplookup&ipaddress={$user['regip']}", "MyBB.popupWindow('index.php?module=user-users&action=iplookup&ipaddress={$user['regip']}', null, true); return false;");
		$popup->add_item($lang->ban_ip, "index.php?module=config-banning&filter={$user['regip']}");
		$controls = $popup->fetch();

		++$counter;
		$ip['ipaddress'] = my_inet_ntop($db->unescape_binary($ip['ipaddress']));
		$popup = new PopupMenu("id_{$counter}", $lang->options);

		++$counter;
		$ip['ipaddress'] = my_inet_ntop($db->unescape_binary($ip['ipaddress']));
		$popup = new PopupMenu("id_{$counter}", $lang->options);

		$popup->add_item($lang->info_on_ip, "index.php?module=user-users&action=iplookup&ipaddress={$ip['ipaddress']}", "MyBB.popupWindow('index.php?module=user-users&action=iplookup&ipaddress={$ip['ipaddress']}', null, true); return false;");
		$popup->add_item($lang->ban_ip, "index.php?module=config-banning&filter={$ip['ipaddress']}");
		$controls = $popup->fetch();

		$popup->add_item($lang->info_on_ip, "index.php?module=user-users&action=iplookup&ipaddress={$ip['ipaddress']}", "MyBB.popupWindow('index.php?module=user-users&action=iplookup&ipaddress={$ip['ipaddress']}', null, true); return false;");
		$popup->add_item($lang->ban_ip, "index.php?module=config-banning&filter={$ip['ipaddress']}");
		$controls = $popup->fetch();

	if($mybb->request_method == "post")
	{

	if($mybb->request_method == "post")
	{

		{

		{

		}

		// If we're not a super admin and we're merging a source super admin or a destination super admin then dissallow this action

		}

		// If we're not a super admin and we're merging a source super admin or a destination super admin then dissallow this action

			admin_redirect("index.php?module=user-users");
		}

			admin_redirect("index.php?module=user-users");
		}

		{
			$errors[] = $lang->error_cannot_merge_same_account;
		}

		{
			$errors[] = $lang->error_cannot_merge_same_account;
		}

			merge_thread_ratings($source_user['uid'], $destination_user['uid']);

			// Banning

			merge_thread_ratings($source_user['uid'], $destination_user['uid']);

			// Banning

			// Merging Reputation
			// First, let's change all the details over to our new user...

			// Merging Reputation
			// First, let's change all the details over to our new user...

			);

			$to_remove = array();

			);

			$to_remove = array();

			while($rep = $db->fetch_array($query))
			{
				if($rep['pid'] == 0 && $mybb->settings['multirep'] == 0 && $last_result['uid'] == $rep['uid'])

			while($rep = $db->fetch_array($query))
			{
				if($rep['pid'] == 0 && $mybb->settings['multirep'] == 0 && $last_result['uid'] == $rep['uid'])

					"rid" => $rep['rid'],
					"uid" => $rep['uid']
				);

					"rid" => $rep['rid'],
					"uid" => $rep['uid']
				);

			// Remove any reputations we've selected to remove...
			if(!empty($to_remove))
			{

			// Remove any reputations we've selected to remove...
			if(!empty($to_remove))
			{

			// Calculate the new reputation for this user...
			$query = $db->simple_select("reputation", "SUM(reputation) as total_rep", "uid='{$destination_user['uid']}'");
			$total_reputation = $db->fetch_field($query, "total_rep");

			// Calculate the new reputation for this user...
			$query = $db->simple_select("reputation", "SUM(reputation) as total_rep", "uid='{$destination_user['uid']}'");
			$total_reputation = $db->fetch_field($query, "total_rep");

			$db->update_query("users", array('reputation' => (int)$total_reputation), "uid='{$destination_user['uid']}'");

			// Calculate warning points

			$db->update_query("users", array('reputation' => (int)$total_reputation), "uid='{$destination_user['uid']}'");

			// Calculate warning points

				WHERE uid='{$source_user['uid']}' AND expired='0'
			");
			$original_warn_level = $db->fetch_field($query, "warn_lev");

				WHERE uid='{$source_user['uid']}' AND expired='0'
			");
			$original_warn_level = $db->fetch_field($query, "warn_lev");

			$from_uid = array(
				"fromid" => $destination_user['uid']

			$from_uid = array(
				"fromid" => $destination_user['uid']

			$db->update_query("privatemessages", $from_uid, "fromid='{$source_user['uid']}'");
			$to_uid = array(
				"toid" => $destination_user['uid']
			);
			$db->update_query("privatemessages", $to_uid, "toid='{$source_user['uid']}'");

			$db->update_query("privatemessages", $from_uid, "fromid='{$source_user['uid']}'");
			$to_uid = array(
				"toid" => $destination_user['uid']
			);
			$db->update_query("privatemessages", $to_uid, "toid='{$source_user['uid']}'");

			// Buddy/ignore lists
			$destination_buddies = explode(',', $destination_user['buddylist']);
			$source_buddies = explode(',', $source_user['buddylist']);

			// Buddy/ignore lists
			$destination_buddies = explode(',', $destination_user['buddylist']);
			$source_buddies = explode(',', $source_user['buddylist']);

			if(!empty($fids))
			{
				$fids_not_in = "AND fid NOT IN(".implode(',', $fids).")";

			if(!empty($fids))
			{
				$fids_not_in = "AND fid NOT IN(".implode(',', $fids).")";

			// Update user post count
			$query = $db->simple_select("posts", "COUNT(*) AS postnum", "uid='".$destination_user['uid']."' {$fids_not_in}");

			// Update user post count
			$query = $db->simple_select("posts", "COUNT(*) AS postnum", "uid='".$destination_user['uid']."' {$fids_not_in}");

				"postnum" => $num['postnum']
			);
			$db->update_query("users", $updated_count, "uid='{$destination_user['uid']}'");

				"postnum" => $num['postnum']
			);
			$db->update_query("users", $updated_count, "uid='{$destination_user['uid']}'");

			// Delete the old user
			$userhandler->delete_user($source_user['uid']);

			// Delete the old user
			$userhandler->delete_user($source_user['uid']);

			$cache->update_awaitingactivation();

			// Log admin action

			$cache->update_awaitingactivation();

			// Log admin action

			// Redirect!
			$username = htmlspecialchars_uni($source_user['username']);

			// Redirect!
			$username = htmlspecialchars_uni($source_user['username']);

			flash_message("<strong>{$username}</strong> {$lang->success_merged} {$destination_username}", "success");
			admin_redirect("index.php?module=user-users");
			exit;

			flash_message("<strong>{$username}</strong> {$lang->success_merged} {$destination_username}", "success");
			admin_redirect("index.php?module=user-users");
			exit;

	$page->add_breadcrumb_item($lang->merge_users);
	$page->output_header($lang->merge_users);

	$page->add_breadcrumb_item($lang->merge_users);
	$page->output_header($lang->merge_users);

	$form = new Form("index.php?module=user-users&action=merge", "post");

	$form_container = new FormContainer($lang->merge_users);

	$form = new Form("index.php?module=user-users&action=merge", "post");

	$form_container = new FormContainer($lang->merge_users);

	$form_container->end();

	// Autocompletion for usernames

	$form_container->end();

	// Autocompletion for usernames

	<script type="text/javascript">
	<!--
	$("#source_username").select2({

	<script type="text/javascript">
	<!--
	$("#source_username").select2({

		}
	});
	$("#destination_username").select2({

		}
	});
	$("#destination_username").select2({

	$buttons[] = $form->generate_submit_button($lang->merge_user_accounts);
	$form->output_submit_wrapper($buttons);
	$form->end();

	$buttons[] = $form->generate_submit_button($lang->merge_user_accounts);
	$form->output_submit_wrapper($buttons);
	$form->end();

	$page->output_footer();
}

	$page->output_footer();
}

{
	$plugins->run_hooks("admin_user_users_search");

{
	$plugins->run_hooks("admin_user_users_search");

	{
		// Build view options from incoming search options

	{
		// Build view options from incoming search options

		{
			$query = $db->simple_select("adminviews", "*", "vid='".$mybb->get_input('vid', MyBB::INPUT_INT)."'");
			$admin_view = $db->fetch_array($query);

		{
			$query = $db->simple_select("adminviews", "*", "vid='".$mybb->get_input('vid', MyBB::INPUT_INT)."'");
			$admin_view = $db->fetch_array($query);

			if(!$admin_view['vid'] || ($admin_view['visibility'] == 1 && $admin_view['uid'] != $mybb->user['uid']))
			{
				unset($admin_view);

			if(!$admin_view['vid'] || ($admin_view['visibility'] == 1 && $admin_view['uid'] != $mybb->user['uid']))
			{
				unset($admin_view);

		}

		}

		{

		{

			unset($admin_view['extra_sql']);

			unset($admin_view['extra_sql']);

		{

		{

			{

			{

			}

			}

		}

		// Override specific parts of the view
		unset($admin_view['vid']);

		}

		// Override specific parts of the view
		unset($admin_view['vid']);

		{

		{

		}

		}

		{

		{

		}

		}

		{

		{

		}

		if($mybb->get_input('perpage', MyBB::INPUT_INT))

		}

		if($mybb->get_input('perpage', MyBB::INPUT_INT))

		}

		}

		{

		{

		}

		}

		{

		{

		}

		}

		{

		{

		}

		$plugins->run_hooks("admin_user_users_search_commit");

		}

		$plugins->run_hooks("admin_user_users_search_commit");

		}
		else
		{

		}
		else
		{

			{
				flash_message($lang->error_no_users_found, 'error');
				admin_redirect("index.php");

			{
				flash_message($lang->error_no_users_found, 'error');
				admin_redirect("index.php");

		$page->output_inline_error($errors);
	}

		$page->output_inline_error($errors);
	}

	{
		$mybb->input['displayas'] = "card";
	}

	{
		$mybb->input['displayas'] = "card";
	}

		"asc" => $lang->ascending,
		"desc" => $lang->descending
	);

		"asc" => $lang->ascending,
		"desc" => $lang->descending
	);

	$form_container->end();

	$buttons[] = $form->generate_submit_button($lang->find_users);

	$form_container->end();

	$buttons[] = $form->generate_submit_button($lang->find_users);

{
	$plugins->run_hooks("admin_user_users_inline");

{
	$plugins->run_hooks("admin_user_users_inline");

	{
		// We have a custom view

	{
		// We have a custom view

		{
			// Set a cookie
			my_setcookie("acp_view", $mybb->input['vid'], 60);
		}

		{
			// Set a cookie
			my_setcookie("acp_view", $mybb->input['vid'], 60);
		}

		{
			// We already have a cookie, so let's use it...
			$mybb->input['vid'] = $mybb->cookies['acp_view'];

		{
			// We already have a cookie, so let's use it...
			$mybb->input['vid'] = $mybb->cookies['acp_view'];

	}

	// First, collect the user IDs that we're performing the moderation on

	}

	// First, collect the user IDs that we're performing the moderation on

	{

	{

		{

		{

		}
	}

	// Verify incoming POST request

		}
	}

	// Verify incoming POST request

	{
		flash_message($lang->invalid_post_verify_key2, 'error');
		admin_redirect("index.php?module=user-user");

	{
		flash_message($lang->invalid_post_verify_key2, 'error');
		admin_redirect("index.php?module=user-user");

	);
	$page->add_breadcrumb_item($lang->manage_users);

	);
	$page->add_breadcrumb_item($lang->manage_users);

	{
		// Not selected any users, show error
		flash_message($lang->error_inline_no_users_selected, 'error');

	{
		// Not selected any users, show error
		flash_message($lang->error_inline_no_users_selected, 'error');

		case 'multiactivate':
			// Run through the activating users, so that users already registered (but have been selected) aren't affected
			if(is_array($selected))

		case 'multiactivate':
			// Run through the activating users, so that users already registered (but have been selected) aren't affected
			if(is_array($selected))

				$sql_array = implode(",", $selected);
				$query = $db->simple_select("users", "uid, username, email", "usergroup = '5' AND uid IN (".$sql_array.")");
				$user_mail_data = array();

				$sql_array = implode(",", $selected);
				$query = $db->simple_select("users", "uid, username, email", "usergroup = '5' AND uid IN (".$sql_array.")");
				$user_mail_data = array();

				}
			}

				}
			}

			{
				$sql_array = implode(",", $to_update);
				$db->write_query("UPDATE ".TABLE_PREFIX."users SET usergroup = '2' WHERE uid IN (".$sql_array.")");

			{
				$sql_array = implode(",", $to_update);
				$db->write_query("UPDATE ".TABLE_PREFIX."users SET usergroup = '2' WHERE uid IN (".$sql_array.")");

				$to_update_count = count($to_update);
				$lang->inline_activated = $lang->sprintf($lang->inline_activated, my_number_format($to_update_count));

				$to_update_count = count($to_update);
				$lang->inline_activated = $lang->sprintf($lang->inline_activated, my_number_format($to_update_count));

				{
					// The update count is different to how many we selected!
					$not_updated_count = count($selected) - $to_update_count;

				{
					// The update count is different to how many we selected!
					$not_updated_count = count($selected) - $to_update_count;

			break;
		case 'multilift':
			// Get the users that are banned, and check that they have been selected

			break;
		case 'multilift':
			// Get the users that are banned, and check that they have been selected

			{
				admin_redirect("index.php?module=user-users".$vid_url); // User clicked on 'No'
			}

			{
				admin_redirect("index.php?module=user-users".$vid_url); // User clicked on 'No'
			}

				{
					$updated_group = array(
						"usergroup" => $ban['oldgroup'],

				{
					$updated_group = array(
						"usergroup" => $ban['oldgroup'],

						"displaygroup" => $ban['olddisplaygroup']
					);
					$db->update_query("users", $updated_group, "uid = '".$ban['uid']."'");
					$db->delete_query("banned", "uid = '".$ban['uid']."'");
				}

						"displaygroup" => $ban['olddisplaygroup']
					);
					$db->update_query("users", $updated_group, "uid = '".$ban['uid']."'");
					$db->delete_query("banned", "uid = '".$ban['uid']."'");
				}

				$cache->update_moderators();

				$mybb->input['action'] = "inline_lift";

				$cache->update_moderators();

				$mybb->input['action'] = "inline_lift";

							'uid' => $user['uid'],
							'gid' => $mybb->get_input('usergroup', MyBB::INPUT_INT),
							'oldgroup' => $user['usergroup'],

							'uid' => $user['uid'],
							'gid' => $mybb->get_input('usergroup', MyBB::INPUT_INT),
							'oldgroup' => $user['usergroup'],

							'olddisplaygroup' => $user['displaygroup'],
							'admin' => (int)$mybb->user['uid'],
							'dateline' => TIME_NOW,

							'olddisplaygroup' => $user['displaygroup'],
							'admin' => (int)$mybb->user['uid'],
							'dateline' => TIME_NOW,

					$db->delete_query("forumsubscriptions", "uid = '{$user['uid']}'");
					$db->delete_query("threadsubscriptions", "uid = '{$user['uid']}'");

					$db->delete_query("forumsubscriptions", "uid = '{$user['uid']}'");
					$db->delete_query("threadsubscriptions", "uid = '{$user['uid']}'");

					++$banned_count;
				}
				$mybb->input['action'] = "inline_banned";

					++$banned_count;
				}
				$mybb->input['action'] = "inline_banned";

			$page->output_header($lang->manage_users);
			$page->output_nav_tabs($sub_tabs, 'manage_users');

			$page->output_header($lang->manage_users);
			$page->output_nav_tabs($sub_tabs, 'manage_users');

			// Provide the user with a warning of what they're about to do
			$table = new Table;
			$lang->mass_ban_info = $lang->sprintf($lang->mass_ban_info, count($selected));

			// Provide the user with a warning of what they're about to do
			$table = new Table;
			$lang->mass_ban_info = $lang->sprintf($lang->mass_ban_info, count($selected));

			$page->output_footer();
			break;
		case 'multidelete':

			$page->output_footer();
			break;
		case 'multidelete':

			{
				admin_redirect("index.php?module=user-users".$vid_url); // User clicked on 'No
			}

			{
				admin_redirect("index.php?module=user-users".$vid_url); // User clicked on 'No
			}

							$prune_array = array_merge_recursive($prune_array, $return_array);
						}
					}

							$prune_array = array_merge_recursive($prune_array, $return_array);
						}
					}

					// No posts were found for the user, return error
					if(!is_array($prune_array) || count($prune_array) == 0)

					// No posts were found for the user, return error
					if(!is_array($prune_array) || count($prune_array) == 0)

			$page->output_footer();
			break;
		case 'multiusergroup':

			$page->output_footer();
			break;
		case 'multiusergroup':

			{
				// Determine additional usergroups
				if(is_array($mybb->input['additionalgroups']))

			{
				// Determine additional usergroups
				if(is_array($mybb->input['additionalgroups']))

							unset($mybb->input['additionalgroups'][$key]);
						}
					}

							unset($mybb->input['additionalgroups'][$key]);
						}
					}

					$additionalgroups = implode(",", array_map('intval', $mybb->input['additionalgroups']));
				}
				else
				{
					$additionalgroups = '';
				}

					$additionalgroups = implode(",", array_map('intval', $mybb->input['additionalgroups']));
				}
				else
				{
					$additionalgroups = '';
				}

				// Create an update array
				$update_array = array(
					"usergroup" => $mybb->get_input('usergroup', MyBB::INPUT_INT),
					"additionalgroups" => $additionalgroups,
					"displaygroup" => $mybb->get_input('displaygroup', MyBB::INPUT_INT)
				);

				// Create an update array
				$update_array = array(
					"usergroup" => $mybb->get_input('usergroup', MyBB::INPUT_INT),
					"additionalgroups" => $additionalgroups,
					"displaygroup" => $mybb->get_input('displaygroup', MyBB::INPUT_INT)
				);

				// Do the usergroup update for all those selected
				// If the a selected user is a super admin, don't update that user

				// Do the usergroup update for all those selected
				// If the a selected user is a super admin, don't update that user

				foreach($selected as $user)
				{
					if(!is_super_admin($user))

				foreach($selected as $user)
				{
					if(!is_super_admin($user))

				}

				$to_update_count = count($users_to_update);

				}

				$to_update_count = count($users_to_update);

				{
					// Update the users in the database
					$sql = implode(",", $users_to_update);

				{
					// Update the users in the database
					$sql = implode(",", $users_to_update);

			{
				$options[$usergroup['gid']] = htmlspecialchars_uni($usergroup['title']);
				$display_group_options[$usergroup['gid']] = htmlspecialchars_uni($usergroup['title']);

			{
				$options[$usergroup['gid']] = htmlspecialchars_uni($usergroup['title']);
				$display_group_options[$usergroup['gid']] = htmlspecialchars_uni($usergroup['title']);

			$form_container->output_row($lang->additional_user_groups, $lang->additional_user_groups_desc, $form->generate_select_box('additionalgroups[]', $options, $mybb->input['additionalgroups'], array('id' => 'additionalgroups', 'multiple' => true, 'size' => 5)), 'additionalgroups');
			$form_container->output_row($lang->display_user_group, "", $form->generate_select_box('displaygroup', $display_group_options, $mybb->input['displaygroup'], array('id' => 'displaygroup')), 'displaygroup');

			$form_container->output_row($lang->additional_user_groups, $lang->additional_user_groups_desc, $form->generate_select_box('additionalgroups[]', $options, $mybb->input['additionalgroups'], array('id' => 'additionalgroups', 'multiple' => true, 'size' => 5)), 'additionalgroups');
			$form_container->output_row($lang->display_user_group, "", $form->generate_select_box('displaygroup', $display_group_options, $mybb->input['displaygroup'], array('id' => 'displaygroup')), 'displaygroup');

	$page->output_nav_tabs($sub_tabs, 'browse_users');

	if(isset($mybb->input['search_id']) && $admin_session['data']['user_views'][$mybb->input['search_id']])

	$page->output_nav_tabs($sub_tabs, 'browse_users');

	if(isset($mybb->input['search_id']) && $admin_session['data']['user_views'][$mybb->input['search_id']])

		$admin_view = $admin_session['data']['user_views'][$mybb->input['search_id']];
		unset($admin_view['extra_sql']);
	}

		$admin_view = $admin_session['data']['user_views'][$mybb->input['search_id']];
		unset($admin_view['extra_sql']);
	}

		{
			$default_view = fetch_default_view("user");
			if(!$default_view)

		{
			$default_view = fetch_default_view("user");
			if(!$default_view)

				$default_view = "0";
			}
			$query = $db->simple_select("adminviews", "*", "type='user' AND (vid='{$default_view}' OR uid=0)", array("order_by" => "uid", "order_dir" => "desc"));

				$default_view = "0";
			}
			$query = $db->simple_select("adminviews", "*", "type='user' AND (vid='{$default_view}' OR uid=0)", array("order_by" => "uid", "order_dir" => "desc"));

	$view_title = '';
	if($view['title'])
	{

	$view_title = '';
	if($view['title'])
	{

		{

		{

		}

		$view_title .= " (".htmlspecialchars_uni($view['title']).")";

		}

		$view_title .= " (".htmlspecialchars_uni($view['title']).")";

		$view['conditions']['username'] = $mybb->input['username'];
		$view['url'] .= "&username=".urlencode(htmlspecialchars_uni($mybb->input['username']));
	}

		$view['conditions']['username'] = $mybb->input['username'];
		$view['url'] .= "&username=".urlencode(htmlspecialchars_uni($mybb->input['username']));
	}

	{
		$view['url'] .= "&vid={$view['vid']}";
	}

	{
		$view['url'] .= "&vid={$view['vid']}";
	}

	{
		// If this is a custom view we need to save everything ready to pass it on from page to page
		global $admin_session;

	{
		// If this is a custom view we need to save everything ready to pass it on from page to page
		global $admin_session;

		{
			$search_id = md5(random_str());
			$admin_session['data']['user_views'][$search_id] = $view;

		{
			$search_id = md5(random_str());
			$admin_session['data']['user_views'][$search_id] = $view;

	// Build header for table based view
	if($view['view_type'] != "card")

	// Build header for table based view
	if($view['view_type'] != "card")

		foreach($view['fields'] as $field)
		{
			if(!$user_view_fields[$field])

		foreach($view['fields'] as $field)
		{
			if(!$user_view_fields[$field])

			$table->construct_header($view_field['title'], $field_options);
		}
		$table->construct_header("<input type=\"checkbox\" name=\"allbox\" onclick=\"inlineModeration.checkAll(this);\" />"); // Create a header for the "select" boxes

			$table->construct_header($view_field['title'], $field_options);
		}
		$table->construct_header("<input type=\"checkbox\" name=\"allbox\" onclick=\"inlineModeration.checkAll(this);\" />"); // Create a header for the "select" boxes

	// Build the search SQL for users

	// List of valid LIKE search fields

	// Build the search SQL for users

	// List of valid LIKE search fields

	foreach($user_like_fields as $search_field)

	foreach($user_like_fields as $search_field)

			$search_sql .= " AND u.{$search_field} LIKE '%".$db->escape_string_like($view['conditions'][$search_field])."%'";
		}
		else if(!empty($view['conditions'][$search_field.'_blank']))

			$search_sql .= " AND u.{$search_field} LIKE '%".$db->escape_string_like($view['conditions'][$search_field])."%'";
		}
		else if(!empty($view['conditions'][$search_field.'_blank']))

			$search_sql .= " AND u.{$search_field} != ''";
		}
	}

			$search_sql .= " AND u.{$search_field} != ''";
		}
	}

		if(!empty($view['conditions'][$search_field]))
		{
			$search_sql .= " AND u.{$search_field}='".$db->escape_string($view['conditions'][$search_field])."'";

		if(!empty($view['conditions'][$search_field]))
		{
			$search_sql .= " AND u.{$search_field}='".$db->escape_string($view['conditions'][$search_field])."'";

	// LESS THAN or GREATER THAN
	$direction_fields = array("postnum", "threadnum");
	foreach($direction_fields as $search_field)

	// LESS THAN or GREATER THAN
	$direction_fields = array("postnum", "threadnum");
	foreach($direction_fields as $search_field)

			{
				case "greater_than":
					$direction = ">";

			{
				case "greater_than":
					$direction = ">";

				case "less_than":
					$direction = "<";
					break;

				case "less_than":
					$direction = "<";
					break;

			if(!is_array($ip_range))
			{
				$ip_sql = "{$search_field}=".$db->escape_binary($ip_range);

			if(!is_array($ip_range))
			{
				$ip_sql = "{$search_field}=".$db->escape_binary($ip_range);

			{
				$ip_sql = "{$search_field} BETWEEN ".$db->escape_binary($ip_range[0])." AND ".$db->escape_binary($ip_range[1]);
			}
			$search_sql .= " AND {$ip_sql}";

			{
				$ip_sql = "{$search_field} BETWEEN ".$db->escape_binary($ip_range[0])." AND ".$db->escape_binary($ip_range[1]);
			}
			$search_sql .= " AND {$ip_sql}";

	// Post IP searching
	if(!empty($view['conditions']['postip']))
	{

	// Post IP searching
	if(!empty($view['conditions']['postip']))
	{

		$userfield_sql = '1=1';
		foreach($view['custom_profile_fields'] as $column => $input)
		{

		$userfield_sql = '1=1';
		foreach($view['custom_profile_fields'] as $column => $input)
		{

			if(is_array($input))
			{
				foreach($input as $value => $text)
				{
					if($value == $column)

			if(is_array($input))
			{
				foreach($input as $value => $text)
				{
					if($value == $column)

						$value = $text;
					}

						$value = $text;
					}

					{
						$column = str_replace('_blank', '', $column);
						$userfield_sql .= ' AND '.$db->escape_string($column)." != ''";

					{
						$column = str_replace('_blank', '', $column);
						$userfield_sql .= ' AND '.$db->escape_string($column)." != ''";

					else
					{
						$userfield_sql .= ' AND '.$db->escape_string($column)."='".$db->escape_string($value)."'";

					else
					{
						$userfield_sql .= ' AND '.$db->escape_string($column)."='".$db->escape_string($value)."'";

		if($mybb->input['page'])
		{
			$start = ($mybb->input['page'] - 1) * $view['perpage'];

		if($mybb->input['page'])
		{
			$start = ($mybb->input['page'] - 1) * $view['perpage'];

		}
		else

		}
		else

			$start = 0;
			$mybb->input['page'] = 1;
		}

			$start = 0;
			$mybb->input['page'] = 1;
		}

		if(isset($mybb->input['from']) && $mybb->input['from'] == "home")
		{
			$from_bit = "&from=home";

		if(isset($mybb->input['from']) && $mybb->input['from'] == "home")
		{
			$from_bit = "&from=home";

		switch($view['sortby'])
		{
			case "regdate":

		switch($view['sortby'])
		{
			case "regdate":

				break;
			default:
				$view['sortby'] = "username";

				break;
			default:
				$view['sortby'] = "username";

		if($view['sortorder'] != "desc")
		{
			$view['sortorder'] = "asc";

		if($view['sortorder'] != "desc")
		{
			$view['sortorder'] = "asc";

		// Fetch matching users
		$query = $db->query("
			SELECT u.*

		// Fetch matching users
		$query = $db->query("
			SELECT u.*

				}
			}
			if(!$groups_list)

				}
			}
			if(!$groups_list)

				$groups_list = $lang->none;

				$groups_list = $lang->none;

			$user['view']['additionalgroups'] = "<small>{$groups_list}</small>";
			$user['view']['email'] = "<a href=\"mailto:".htmlspecialchars_uni($user['email'])."\">".htmlspecialchars_uni($user['email'])."</a>";
			$user['view']['regdate'] = my_date('relative', $user['regdate']);

			$user['view']['additionalgroups'] = "<small>{$groups_list}</small>";
			$user['view']['email'] = "<a href=\"mailto:".htmlspecialchars_uni($user['email'])."\">".htmlspecialchars_uni($user['email'])."</a>";
			$user['view']['regdate'] = my_date('relative', $user['regdate']);

			// Build popup menu
			$popup = new PopupMenu("user_{$user['uid']}", $lang->options);

			// Build popup menu
			$popup = new PopupMenu("user_{$user['uid']}", $lang->options);

			}

			if($user['usergroup'] == 5)

			}

			if($user['usergroup'] == 5)

				if($user['coppauser'])
				{
					$popup->add_item($lang->approve_coppa_user, "index.php?module=user-users&action=activate_user&uid={$user['uid']}&my_post_key={$mybb->post_code}{$from_bit}");

				if($user['coppauser'])
				{
					$popup->add_item($lang->approve_coppa_user, "index.php?module=user-users&action=activate_user&uid={$user['uid']}&my_post_key={$mybb->post_code}{$from_bit}");

				else
				{
					$popup->add_item($lang->approve_user, "index.php?module=user-users&action=activate_user&uid={$user['uid']}&my_post_key={$mybb->post_code}{$from_bit}");

				else
				{
					$popup->add_item($lang->approve_user, "index.php?module=user-users&action=activate_user&uid={$user['uid']}&my_post_key={$mybb->post_code}{$from_bit}");

			$popup->add_item($lang->delete_user, "index.php?module=user-users&action=delete&uid={$user['uid']}&my_post_key={$mybb->post_code}", "return AdminCP.deleteConfirmation(this, '{$lang->user_deletion_confirmation}')");
			$popup->add_item($lang->show_referred_users, "index.php?module=user-users&action=referrers&uid={$user['uid']}");

			$popup->add_item($lang->delete_user, "index.php?module=user-users&action=delete&uid={$user['uid']}&my_post_key={$mybb->post_code}", "return AdminCP.deleteConfirmation(this, '{$lang->user_deletion_confirmation}')");
			$popup->add_item($lang->show_referred_users, "index.php?module=user-users&action=referrers&uid={$user['uid']}");

			// Fetch the reputation for this user
			if($usergroups[$user['usergroup']]['usereputationsystem'] == 1 && $mybb->settings['enablereputation'] == 1)

			// Fetch the reputation for this user
			if($usergroups[$user['usergroup']]['usereputationsystem'] == 1 && $mybb->settings['enablereputation'] == 1)

				$user['view']['reputation'] = get_reputation($user['reputation']);
			}
			else

				$user['view']['reputation'] = get_reputation($user['reputation']);
			}
			else

				}
				$user['view']['warninglevel'] = get_colored_warning_level($warning_level);
			}

				}
				$user['view']['warninglevel'] = get_colored_warning_level($warning_level);
			}

			// Convert IP's to readable
			$user['regip'] = my_inet_ntop($db->unescape_binary($user['regip']));

			// Convert IP's to readable
			$user['regip'] = my_inet_ntop($db->unescape_binary($user['regip']));

	}
	$built_view .= $search->generate_text_box('username', htmlspecialchars_uni($value), array('id' => 'search_keywords', 'class' => "{$default_class} field150 field_small"))."\n";
	$built_view .= "<input type=\"submit\" class=\"search_button\" value=\"{$lang->search}\" />\n";

	}
	$built_view .= $search->generate_text_box('username', htmlspecialchars_uni($value), array('id' => 'search_keywords', 'class' => "{$default_class} field150 field_small"))."\n";
	$built_view .= "<input type=\"submit\" class=\"search_button\" value=\"{$lang->search}\" />\n";

	{
		$built_view .= " <div style=\"display: inline\">{$view['popup']}</div>\n";
	}
	$built_view .= "<script type=\"text/javascript\">
		var form = $(\"#search_form\");

	{
		$built_view .= " <div style=\"display: inline\">{$view['popup']}</div>\n";
	}
	$built_view .= "<script type=\"text/javascript\">
		var form = $(\"#search_form\");

			var search = $('#search_keywords');
			if(search.val() == '' || search.val() == '".addcslashes($lang->search_for_user, "'")."')
			{

			var search = $('#search_keywords');
			if(search.val() == '' || search.val() == '".addcslashes($lang->search_for_user, "'")."')
			{

				return false;
			}
		});

		var search = $(\"#search_keywords\");

				return false;
			}
		});

		var search = $(\"#search_keywords\");

		{
			var searched_focus = $(this);
			if(searched_focus.val() == '".addcslashes($lang->search_for_user, "'")."')

		{
			var searched_focus = $(this);
			if(searched_focus.val() == '".addcslashes($lang->search_for_user, "'")."')

				searched_focus.removeClass(\"search_default\");
				searched_focus.val(\"\");
			}

				searched_focus.removeClass(\"search_default\");
				searched_focus.val(\"\");
			}

		{
			var searched_blur = $(this);
			if(searched_blur.val() == \"\")

		{
			var searched_blur = $(this);
			if(searched_blur.val() == \"\")

	}

	$built_view .= '

	}

	$built_view .= '

<form action="index.php?module=user-users" method="post">
<input type="hidden" name="my_post_key" value="'.$mybb->post_code.'" />
<input type="hidden" name="action" value="inline_edit" />

<form action="index.php?module=user-users" method="post">
<input type="hidden" name="my_post_key" value="'.$mybb->post_code.'" />
<input type="hidden" name="action" value="inline_edit" />

	}

	// And build the final card

	}

	// And build the final card

	$card = "<fieldset id=\"uid_{$user['uid']}\" style=\"width: 47%; float: {$float};\">\n";

	$card = "<fieldset id=\"uid_{$user['uid']}\" style=\"width: 47%; float: {$float};\">\n";

		$card .= "<div class=\"user_avatar\">{$avatar}</div>\n";
	}

		$card .= "<div class=\"user_avatar\">{$avatar}</div>\n";
	}

	{
		$card .= "<div class=\"user_details\">".implode("<br />", $user_details)."</div>\n";

	{
		$card .= "<div class=\"user_details\">".implode("<br />", $user_details)."</div>\n";

	{
		$card .= "<div class=\"float_right\" style=\"padding: 4px;\">{$controls}</div>\n";
	}
	$card .= "</fieldset>";
	return $card;

	{
		$card .= "<div class=\"float_right\" style=\"padding: 4px;\">{$controls}</div>\n";
	}
	$card .= "</fieldset>";
	return $card;

}

/**

}

/**

		}
		$view_field = $user_view_fields[$field];
		$field_options = array();

		}
		$view_field = $user_view_fields[$field];
		$field_options = array();

		{
			$field_options['class'] = "align_".$view_field['align'];
		}

		{
			$field_options['class'] = "align_".$view_field['align'];
		}

		{
			$value = $user['view'][$field];

		{
			$value = $user['view'][$field];

		else
		{
			$value = $user[$field];

		else
		{
			$value = $user[$field];

			$value = my_number_format($user[$field]);
		}
		$table->construct_cell($value, $field_options);

			$value = my_number_format($user[$field]);
		}
		$table->construct_cell($value, $field_options);

	$table->construct_cell("<input type=\"checkbox\" class=\"checkbox\" name=\"inlinemod_{$user['uid']}\" id=\"inlinemod_{$user['uid']}\" value=\"1\" onclick=\"$('#uid_{$user['uid']}').toggleClass('inline_selected');\" />");

	$table->construct_row();

	$table->construct_cell("<input type=\"checkbox\" class=\"checkbox\" name=\"inlinemod_{$user['uid']}\" id=\"inlinemod_{$user['uid']}\" value=\"1\" onclick=\"$('#uid_{$user['uid']}').toggleClass('inline_selected');\" />");

	$table->construct_row();

}

/**

}

/**

 */
function output_custom_profile_fields($fields, $values, &$form_container, &$form, $search=false)
{

 */
function output_custom_profile_fields($fields, $values, &$form_container, &$form, $search=false)
{

	if(!is_array($fields))

	if(!is_array($fields))

		return;
	}
	foreach($fields as $profile_field)
	{
		$profile_field['name'] = htmlspecialchars_uni($profile_field['name']);
		$profile_field['description'] = htmlspecialchars_uni($profile_field['description']);

		return;
	}
	foreach($fields as $profile_field)
	{
		$profile_field['name'] = htmlspecialchars_uni($profile_field['name']);
		$profile_field['description'] = htmlspecialchars_uni($profile_field['description']);

		$type = trim($type);
		$field_name = "fid{$profile_field['fid']}";

		$type = trim($type);
		$field_name = "fid{$profile_field['fid']}";

		switch($type)
		{
			case "multiselect":

		switch($type)
		{
			case "multiselect":

				{
					$user_options = $values[$field_name];
				}

				{
					$user_options = $values[$field_name];
				}

				foreach($user_options as $val)

				foreach($user_options as $val)

					$selected_options[$val] = htmlspecialchars_uni($val);
				}

				$select_options = explode("\n", $options);

					$selected_options[$val] = htmlspecialchars_uni($val);
				}

				$select_options = explode("\n", $options);

				{
					$select_options[''] = $lang->na;
				}

				{
					$select_options[''] = $lang->na;
				}

				}
				$code = $form->generate_select_box("profile_fields[{$field_name}][]", $options, $selected_options, array('id' => "profile_field_{$field_name}", 'multiple' => true, 'size' => $profile_field['length']));
				break;
			case "select":
				$select_options = array();

				}
				$code = $form->generate_select_box("profile_fields[{$field_name}][]", $options, $selected_options, array('id' => "profile_field_{$field_name}", 'multiple' => true, 'size' => $profile_field['length']));
				break;
			case "select":
				$select_options = array();

					$select_options[''] = $lang->na;
				}
				$select_options += explode("\n", $options);
				$options = array();
				foreach($select_options as $val)

					$select_options[''] = $lang->na;
				}
				$select_options += explode("\n", $options);
				$options = array();
				foreach($select_options as $val)

					$val = htmlspecialchars_uni(trim($val));
					$options[$val] = $val;
				}
				if(!$profile_field['length'])
				{
					$profile_field['length'] = 1;

					$val = htmlspecialchars_uni(trim($val));
					$options[$val] = $val;
				}
				if(!$profile_field['length'])
				{
					$profile_field['length'] = 1;

				{
					$code = $form->generate_select_box("profile_fields[{$field_name}]", $options, htmlspecialchars_uni($values[$field_name]), array('id' => "profile_field_{$field_name}", 'size' => $profile_field['length']));
				}
				break;
			case "radio":
				$radio_options = array();

				{
					$code = $form->generate_select_box("profile_fields[{$field_name}]", $options, htmlspecialchars_uni($values[$field_name]), array('id' => "profile_field_{$field_name}", 'size' => $profile_field['length']));
				}
				break;
			case "radio":
				$radio_options = array();

				{
					$radio_options[''] = $lang->na;
				}

				{
					$radio_options[''] = $lang->na;
				}

				}
				break;
			case "checkbox":

				}
				break;
			case "checkbox":

				if(!is_array($values[$field_name]))
				{
					$user_options = explode("\n", $values[$field_name]);
				}
				else

				if(!is_array($values[$field_name]))
				{
					$user_options = explode("\n", $values[$field_name]);
				}
				else

					$user_options = $values[$field_name];
				}

					$user_options = $values[$field_name];
				}

				foreach($user_options as $val)
				{
					$selected_options[$val] = $val;

				foreach($user_options as $val)
				{
					$selected_options[$val] = $val;

				if($search == true)
				{
					$select_options[''] = $lang->na;

				if($search == true)
				{
					$select_options[''] = $lang->na;

				foreach($select_options as $val)
				{
					$val = trim($val);

				foreach($select_options as $val)
				{
					$val = trim($val);

				}
				break;
			case "textarea":

				}
				break;
			case "textarea":

				$code = $form->generate_text_area("profile_fields[{$field_name}]", $values[$field_name], array('id' => "profile_field_{$field_name}", 'rows' => 6, 'cols' => 50)).$extra;
				break;
			default:

				$code = $form->generate_text_area("profile_fields[{$field_name}]", $values[$field_name], array('id' => "profile_field_{$field_name}", 'rows' => 6, 'cols' => 50)).$extra;
				break;
			default:

				$code = $form->generate_text_box("profile_fields[{$field_name}]", $values[$field_name], array('id' => "profile_field_{$field_name}", 'maxlength' => $profile_field['maxlength'], 'length' => $profile_field['length'])).$extra;
				break;

				$code = $form->generate_text_box("profile_fields[{$field_name}]", $values[$field_name], array('id' => "profile_field_{$field_name}", 'maxlength' => $profile_field['maxlength'], 'length' => $profile_field['length'])).$extra;
				break;

		$form_container->output_row($profile_field['name'], $profile_field['description'], $code, "", array('id' => "profile_field_{$field_name}"));
		$code = $user_options = $selected_options = $radio_options = $val = $options = '';
	}

		$form_container->output_row($profile_field['name'], $profile_field['description'], $code, "", array('id' => "profile_field_{$field_name}"));
		$code = $user_options = $selected_options = $radio_options = $val = $options = '';
	}

 * @param array $input
 * @param DefaultForm $form
 */

 * @param array $input
 * @param DefaultForm $form
 */

{
	global $mybb, $db, $lang;

{
	global $mybb, $db, $lang;

	if(!$input)

	if(!$input)

		$input = $mybb->input;

		$input = $mybb->input;