Vergleich admin/modules/user/users.php - 1.4.3 - 1.4.5

  Keine Änderungen   Hinzugefügt   Modifiziert   Entfernt
Zeile 6Zeile 6
 * Website: http://www.mybboard.net
 * License: http://www.mybboard.net/about/license
 *

 
 * Website: http://www.mybboard.net
 * License: http://www.mybboard.net/about/license
 *

 * $Id: users.php 4180 2008-09-07 16:44:43Z Tikitiki $

 * $Id: users.php 4337 2009-03-30 01:21:51Z Tikitiki $

 */

// Disallow direct access to this file for security reasons

 */

// Disallow direct access to this file for security reasons

Zeile 165Zeile 165
			$updated_avatar = array(
				"avatar" => $db->escape_string($mybb->settings['avatardir']."/".$mybb->input['avatar']),
				"avatardimensions" => "{$dimensions[0]}|{$dimensions[1]}",

 
			$updated_avatar = array(
				"avatar" => $db->escape_string($mybb->settings['avatardir']."/".$mybb->input['avatar']),
				"avatardimensions" => "{$dimensions[0]}|{$dimensions[1]}",

 


				"avatartype" => "gallery"
			);


				"avatartype" => "gallery"
			);


Zeile 175Zeile 176
			// Log admin action
			log_admin_action($user['uid'], $user['username']);
		}

 
			// Log admin action
			log_admin_action($user['uid'], $user['username']);
		}

		remove_avatars($mybb->user['uid']);

		remove_avatars($user['uid']);

		// Now a tad of javascript to submit the parent window form
		echo "<script type=\"text/javascript\">window.parent.submitUserForm();</script>";
		exit;

		// Now a tad of javascript to submit the parent window form
		echo "<script type=\"text/javascript\">window.parent.submitUserForm();</script>";
		exit;

Zeile 199Zeile 200

	$mybb->settings['avatardir'] = "../".$mybb->settings['avatardir'];


 

	$mybb->settings['avatardir'] = "../".$mybb->settings['avatardir'];


 
	if(!is_dir($mybb->settings['avatardir']) && is_dir(MYBB_ROOT."/images/avatars/"))
	{
		$mybb->settings['avatardir'] = "../images/avatars/";
	}
	

	// Within a gallery

 
	// Within a gallery

	if($gallery)

	if(!empty($gallery))

	{
		$path = $gallery."/";
		$real_path = $mybb->settings['avatardir']."/".$path;

 
	{
		$path = $gallery."/";
		$real_path = $mybb->settings['avatardir']."/".$path;

		if(is_dir($path))

		if(is_dir($real_path))

		{
			// Build friendly gallery breadcrumb
			$gallery_path = explode("/", $gallery);

		{
			// Build friendly gallery breadcrumb
			$gallery_path = explode("/", $gallery);

Zeile 222Zeile 228
				else
				{
					$breadcrumb .= " &raquo; {$gallery_name}";

 
				else
				{
					$breadcrumb .= " &raquo; {$gallery_name}";

				}
			}

				}
			}

		}
		else
		{

		}
		else
		{

Zeile 363Zeile 369

	// Move out of awaiting activation if they're in it.
	if($user['usergroup'] == 5)

 

	// Move out of awaiting activation if they're in it.
	if($user['usergroup'] == 5)

	{

	{

		$updated_user['usergroup'] = 2;
	}

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

 
		$updated_user['usergroup'] = 2;
	}

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





	// Log admin action
	log_admin_action($user['uid'], $user['username']);


 
	// Log admin action
	log_admin_action($user['uid'], $user['username']);


	if($user['coppauser'])
	{
		flash_message($lang->success_coppa_activated, 'success');
	}
	else
	{
		flash_message($lang->success_activated, 'success');
	}


















	if($mybb->input['from'] == "home")
	{
		if($user['coppauser'])
		{
			$message = $lang->success_coppa_activated;
		}
		else
		{
			$message = $lang->success_activated;
		}
		
		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');
		}
	}
	

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

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

 
		
		if($mybb->input['from'] == "home")
		{
			update_admin_session('from', 'home');
		}

	}
	else
	{

 
	}
	else
	{

		$url = "index.php?module=user/users&amp;action=edit&amp;uid={$user['uid']}";

		$url = "index.php?module=user/users&action=edit&uid={$user['uid']}";

	}

 
	}

 
	

	admin_redirect($url);

 
	admin_redirect($url);

}


}


if($mybb->input['action'] == "add")
{
	$plugins->run_hooks("admin_user_users_add");

 
if($mybb->input['action'] == "add")
{
	$plugins->run_hooks("admin_user_users_add");

	
	if($mybb->request_method == "post")
	{
		// Determine the usergroup stuff
		if(is_array($mybb->input['additionalgroups']))
		{
			foreach($mybb->input['additionalgroups'] as $gid)
			{
				if($gid == $mybb->input['usergroup'])
				{
					unset($mybb->input['additionalgroups'][$gid]);
				}
			}
			$additionalgroups = implode(",", $mybb->input['additionalgroups']);
		}
		else
		{
			$additionalgroups = '';
		}

		// Set up user handler.

	
	if($mybb->request_method == "post")
	{
		// Determine the usergroup stuff
		if(is_array($mybb->input['additionalgroups']))
		{
			foreach($mybb->input['additionalgroups'] as $gid)
			{
				if($gid == $mybb->input['usergroup'])
				{
					unset($mybb->input['additionalgroups'][$gid]);
				}
			}
			$additionalgroups = implode(",", $mybb->input['additionalgroups']);
		}
		else
		{
			$additionalgroups = '';
		}

		// Set up user handler.

		require_once MYBB_ROOT."inc/datahandlers/user.php";
		$userhandler = new UserDataHandler('insert');


		require_once MYBB_ROOT."inc/datahandlers/user.php";
		$userhandler = new UserDataHandler('insert');


Zeile 443Zeile 471

		// 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

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

Zeile 597Zeile 625
			$updated_user['password'] = $mybb->input['new_password'];
			$updated_user['password2'] = $mybb->input['confirm_new_password'];
		}

 
			$updated_user['password'] = $mybb->input['new_password'];
			$updated_user['password2'] = $mybb->input['confirm_new_password'];
		}


		$updated_user['birthday'] = array(
			"day" => $mybb->input['birthday_day'],
			"month" => $mybb->input['birthday_month'],
			"year" => $mybb->input['birthday_year']
		);

 

		$updated_user['options'] = array(
			"allownotices" => $mybb->input['allownotices'],


		$updated_user['options'] = array(
			"allownotices" => $mybb->input['allownotices'],

Zeile 652Zeile 674
					"avatardimensions" => "",
					"avatartype" => ""
				);

 
					"avatardimensions" => "",
					"avatartype" => ""
				);

				remove_avatars($mybb->user['uid']);

				remove_avatars($user['uid']);

			}



			}



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

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

						list($maxwidth, $maxheight) = explode("x", $mybb->settings['maxavatardims']);

						list($maxwidth, $maxheight) = explode("x", my_strtolower($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);

Zeile 844Zeile 866
			require_once MYBB_ROOT."inc/functions_image.php";
			list($width, $height) = explode("|", $user['avatardimensions']);
			$scaled_dimensions = scale_image($width, $height, 120, 120);

 
			require_once MYBB_ROOT."inc/functions_image.php";
			list($width, $height) = explode("|", $user['avatardimensions']);
			$scaled_dimensions = scale_image($width, $height, 120, 120);

		}
		else

		}
		else

		{
			$scaled_dimensions = array(
				"width" => 120,

		{
			$scaled_dimensions = array(
				"width" => 120,

Zeile 890Zeile 912
	{
		$posts_per_day = round($user['postnum'] / $days_registered, 2);
		if($posts_per_day > $user['postnum'])

 
	{
		$posts_per_day = round($user['postnum'] / $days_registered, 2);
		if($posts_per_day > $user['postnum'])

		{

		{

			$posts_per_day = $user['postnum'];
		}
	}
	$stats = $cache->read("stats");
	$posts = $stats['numposts'];
	if($posts == 0)

 
			$posts_per_day = $user['postnum'];
		}
	}
	$stats = $cache->read("stats");
	$posts = $stats['numposts'];
	if($posts == 0)

	{

	{

		$percent_posts = "0";

 
		$percent_posts = "0";

	}
	else

	}
	else

	{
		$percent_posts = round($memprofile['postnum']*100/$posts, 2);;

 
	{
		$percent_posts = round($memprofile['postnum']*100/$posts, 2);;

	}

	}


	$user_permissions = user_permissions($user['uid']);



	$user_permissions = user_permissions($user['uid']);


Zeile 911Zeile 933
	if($user_permissions['usereputationsystem'] == 1 && $mybb->settings['enablereputation'] == 1)
	{
		$reputation = get_reputation($user['reputation']);

 
	if($user_permissions['usereputationsystem'] == 1 && $mybb->settings['enablereputation'] == 1)
	{
		$reputation = get_reputation($user['reputation']);

	}
	else

	}
	else

	{
		$reputation = "-";

 
	{
		$reputation = "-";

	}

	}


	if($mybb->settings['enablewarningsystem'] != 0 && $user_permissions['canreceivewarnings'] != 0)
	{


	if($mybb->settings['enablewarningsystem'] != 0 && $user_permissions['canreceivewarnings'] != 0)
	{

Zeile 932Zeile 954
	{
		$age = get_age($user['birthday']);
	}

 
	{
		$age = get_age($user['birthday']);
	}

 


	else
	{
		$age = '';

	else
	{
		$age = '';

Zeile 956Zeile 979
	$table->construct_cell("<strong>{$lang->registration_ip}:</strong> {$user['regip']}");
	$table->construct_cell("<strong>{$lang->last_known_ip}:</strong> {$user['lastip']}");
	$table->construct_row();

 
	$table->construct_cell("<strong>{$lang->registration_ip}:</strong> {$user['regip']}");
	$table->construct_cell("<strong>{$lang->last_known_ip}:</strong> {$user['lastip']}");
	$table->construct_row();

	

	

	$table->output("{$lang->user_overview}: {$user['username']}");
	echo "</div>\n";


	$table->output("{$lang->user_overview}: {$user['username']}");
	echo "</div>\n";


Zeile 977Zeile 1000
	{
		$options[$usergroup['gid']] = $usergroup['title'];
		$display_group_options[$usergroup['gid']] = $usergroup['title'];

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

	}
	

	}
	

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

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

Zeile 1022Zeile 1045
		$form->generate_check_box("remember", 1, $lang->remember_login_details, array("checked" => $mybb->input['remember']))
	);
	$form_container->output_row($lang->login_cookies_privacy, "", "<div class=\"user_settings_bit\">".implode("</div><div class=\"user_settings_bit\">", $login_options)."</div>");

 
		$form->generate_check_box("remember", 1, $lang->remember_login_details, array("checked" => $mybb->input['remember']))
	);
	$form_container->output_row($lang->login_cookies_privacy, "", "<div class=\"user_settings_bit\">".implode("</div><div class=\"user_settings_bit\">", $login_options)."</div>");








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

	$messaging_options = array(
		$form->generate_check_box("allownotices", 1, $lang->recieve_admin_emails, array("checked" => $mybb->input['allownotices'])),
		$form->generate_check_box("hideemail", 1, $lang->hide_email_from_others, array("checked" => $mybb->input['hideemail'])),

	$messaging_options = array(
		$form->generate_check_box("allownotices", 1, $lang->recieve_admin_emails, array("checked" => $mybb->input['allownotices'])),
		$form->generate_check_box("hideemail", 1, $lang->hide_email_from_others, array("checked" => $mybb->input['hideemail'])),

Zeile 1193Zeile 1221

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

 

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

		list($max_width, $max_height) = explode("x", $mybb->settings['maxavatardims']);

		list($max_width, $max_height) = explode("x", my_strtolower($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}";
	}


Zeile 1272Zeile 1300
	{
		// Delete the user
		$db->update_query("posts", array('uid' => 0), "uid='{$user['uid']}'");

 
	{
		// Delete the user
		$db->update_query("posts", array('uid' => 0), "uid='{$user['uid']}'");

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

 
		$db->delete_query("userfields", "ufid='{$user['uid']}'");
		$db->delete_query("privatemessages", "uid='{$user['uid']}'");
		$db->delete_query("events", "uid='{$user['uid']}'");

		$db->delete_query("userfields", "ufid='{$user['uid']}'");
		$db->delete_query("privatemessages", "uid='{$user['uid']}'");
		$db->delete_query("events", "uid='{$user['uid']}'");

Zeile 1282Zeile 1309
		$db->delete_query("sessions", "uid='{$user['uid']}'");
		$db->delete_query("banned", "uid='{$user['uid']}'");
		$db->delete_query("threadratings", "uid='{$user['uid']}'");

 
		$db->delete_query("sessions", "uid='{$user['uid']}'");
		$db->delete_query("banned", "uid='{$user['uid']}'");
		$db->delete_query("threadratings", "uid='{$user['uid']}'");

 
		$db->delete_query("users", "uid='{$user['uid']}'");
		$db->delete_query("joinrequests", "uid='{$user['uid']}'");
		$db->delete_query("warnings", "uid='{$user['uid']}'");


		// Update forum stats
		update_stats(array('numusers' => '-1'));


		// Update forum stats
		update_stats(array('numusers' => '-1'));

Zeile 1318Zeile 1348
	
	// Fetch default admin view
	$default_view = fetch_default_view("user");

 
	
	// Fetch default admin 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"));
	$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);


Zeile 1395Zeile 1429
	$table->construct_cell($controls, array('class' => "align_center"));
	$table->construct_row();
	

	$table->construct_cell($controls, array('class' => "align_center"));
	$table->construct_row();
	

	$query = $db->simple_select("posts", "DISTINCT ipaddress, pid", "uid='{$mybb->input['uid']}'");



	$counter = 0;
	
	$query = $db->simple_select("posts", "DISTINCT ipaddress", "uid='{$mybb->input['uid']}'");

	while($ip = $db->fetch_array($query))

 
	while($ip = $db->fetch_array($query))

	{
		if(!$done_ip[$ip['ipaddress']])
		{
			$popup = new PopupMenu("post_{$ip['pid']}", $lang->options);
			$popup->add_item($lang->show_users_regged_with_ip, "index.php?module=user/users&amp;results=1&amp;action=search&amp;conditions=".urlencode(serialize(array("regip" => $ip['ipaddress']))));
			$popup->add_item($lang->show_users_posted_with_ip, "index.php?module=user/users&amp;results=1&amp;action=search&amp;conditions=".urlencode(serialize(array("postip" => $ip['ipaddress']))));
			$popup->add_item($lang->ban_ip, "index.php?module=config/banning&amp;filter={$ip['ipaddress']}");
			$controls = $popup->fetch();
		
			$table->construct_cell($ip['ipaddress']);
			$table->construct_cell($controls, array('class' => "align_center"));
			$table->construct_row();
			$done_ip[$ip['ipaddres']] = 1;
		}

	{
		++$counter;
		$popup = new PopupMenu("id_{$counter}", $lang->options);
		$popup->add_item($lang->show_users_regged_with_ip, "index.php?module=user/users&amp;results=1&amp;action=search&amp;conditions=".urlencode(serialize(array("regip" => $ip['ipaddress']))));
		$popup->add_item($lang->show_users_posted_with_ip, "index.php?module=user/users&amp;results=1&amp;action=search&amp;conditions=".urlencode(serialize(array("postip" => $ip['ipaddress']))));
		$popup->add_item($lang->ban_ip, "index.php?module=config/banning&amp;filter={$ip['ipaddress']}");
		$controls = $popup->fetch();
	
		$table->construct_cell($ip['ipaddress']);
		$table->construct_cell($controls, array('class' => "align_center"));
		$table->construct_row();




	}
	
	$table->output($lang->ip_address_for." {$user['username']}");

	}
	
	$table->output($lang->ip_address_for." {$user['username']}");

Zeile 1427Zeile 1460
		$query = $db->simple_select("users", "*", "LOWER(username)='".$db->escape_string(my_strtolower($mybb->input['source_username']))."'");
		$source_user = $db->fetch_array($query);
		if(!$source_user['uid'])

 
		$query = $db->simple_select("users", "*", "LOWER(username)='".$db->escape_string(my_strtolower($mybb->input['source_username']))."'");
		$source_user = $db->fetch_array($query);
		if(!$source_user['uid'])

		{

		{

			$errors[] = $lang->error_invalid_user_source;
		}


			$errors[] = $lang->error_invalid_user_source;
		}


Zeile 1471Zeile 1504
			$db->update_query("reputation", array('adduid' => $destination_user['uid']), "adduid='{$source_user['uid']}'");
			$db->update_query("threadratings", $uid_update, "uid='{$source_user['uid']}'");
			$db->update_query("threads", $uid_update, "uid='{$source_user['uid']}'");

 
			$db->update_query("reputation", array('adduid' => $destination_user['uid']), "adduid='{$source_user['uid']}'");
			$db->update_query("threadratings", $uid_update, "uid='{$source_user['uid']}'");
			$db->update_query("threads", $uid_update, "uid='{$source_user['uid']}'");











			$db->delete_query("sessions", "uid='{$source_user['uid']}'");
			$db->delete_query("reputation", "uid='{$destination_user['uid']}' AND adduid='{$destination_user['uid']}'");
			
			// Calculate new reputation
			$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' => $total_reputation), "uid='{$destination_user['uid']}'");
			

			// Additional updates for non-uid fields
			$last_poster = array(
				"lastposteruid" => $destination_user['uid'],

			// Additional updates for non-uid fields
			$last_poster = array(
				"lastposteruid" => $destination_user['uid'],

Zeile 1523Zeile 1564
	$page->output_header($lang->merge_users);
	
	$page->output_nav_tabs($sub_tabs, 'merge_users');

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


	// If we have any error messages, show them
	if($errors)
	{


	// If we have any error messages, show them
	if($errors)
	{

		$page->output_inline_error($errors);
	}

 
		$page->output_inline_error($errors);
	}





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

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

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

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

Zeile 1548Zeile 1589
	</script>';

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

 
	</script>';

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

	$form->output_submit_wrapper($buttons);
	$form->end();

	$page->output_footer();
}

	$form->output_submit_wrapper($buttons);
	$form->end();

	$page->output_footer();
}


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


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

Zeile 1562Zeile 1603
	{
		// Build view options from incoming search options
		if($mybb->input['vid'])

 
	{
		// Build view options from incoming search options
		if($mybb->input['vid'])

		{

		{

			$query = $db->simple_select("adminviews", "*", "vid='".intval($mybb->input['vid'])."'");
			$admin_view = $db->fetch_array($query);
			// View does not exist or this view is private and does not belong to the current user

			$query = $db->simple_select("adminviews", "*", "vid='".intval($mybb->input['vid'])."'");
			$admin_view = $db->fetch_array($query);
			// View does not exist or this view is private and does not belong to the current user

Zeile 1571Zeile 1612
				unset($admin_view);
			}
		}

 
				unset($admin_view);
			}
		}

		



		if($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']);

 
		if($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']);

		}
		else
		{

		}
		else
		{

			// Don't have a view? Fetch the default
			if(!$admin_view['vid'])
			{
				$default_view = fetch_default_view("user");

 
			// Don't have a view? Fetch the default
			if(!$admin_view['vid'])
			{
				$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"));
				$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);
			}

Zeile 1633Zeile 1678
		}
		else
		{

 
		}
		else
		{

			$errors[] = $lang->error_no_users_found;










			if($mybb->input['from'] == "home")
			{
				flash_message($lang->error_no_users_found, 'error');
				admin_redirect("index.php");
				exit;
			}
			else
			{
				$errors[] = $lang->error_no_users_found;
			}

		}
	}


		}
	}


Zeile 1680Zeile 1734
	
	$page->output_header($lang->browse_users);
	echo "<script type=\"text/javascript\" src=\"jscripts/users.js\"></script>";

 
	
	$page->output_header($lang->browse_users);
	echo "<script type=\"text/javascript\" src=\"jscripts/users.js\"></script>";

	

	

	$page->output_nav_tabs($sub_tabs, 'browse_users');
	
	if($mybb->input['search_id'] && $admin_session['data']['user_views'][$mybb->input['search_id']])

 
	$page->output_nav_tabs($sub_tabs, 'browse_users');
	
	if($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']);
	}

Zeile 1699Zeile 1753
			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);

			}

			}

		}

		// Don't have a view? Fetch the default
		if(!$admin_view)
		{
			$default_view = fetch_default_view("user");

 
		}

		// Don't have a view? Fetch the default
		if(!$admin_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"));
			$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);
		}

Zeile 1731Zeile 1789

	if(!$results)
	{

 

	if(!$results)
	{

 
		// If we came from the home page and clicked on the "Activate Users" link, send them back to here
		if($admin_session['data']['from'] == "home")
		{
			flash_message($admin_session['data']['flash_message2']['message'], $admin_session['data']['flash_message2']['type']);
			update_admin_session('flash_message2', '');
			update_admin_session('from', '');
			admin_redirect("index.php");
			exit;
		}
		else
		{

			$errors[] = $lang->error_no_users_found;

 
			$errors[] = $lang->error_no_users_found;

 
		}

	}

	// If we have any error messages, show them

	}

	// If we have any error messages, show them

Zeile 1884Zeile 1954
	{
		if($view['conditions'][$search_field])
		{

 
	{
		if($view['conditions'][$search_field])
		{

			$view['conditions'][$search_field] = str_replace("*", "%", $view['conditions'][$search_field]);

 
			// IPv6 IP
			if(strpos($view['conditions'][$search_field], ":") !== false)
			{

 
			// IPv6 IP
			if(strpos($view['conditions'][$search_field], ":") !== false)
			{

 
				$view['conditions'][$search_field] = str_replace("*", "%", $view['conditions'][$search_field]);

				$ip_sql = "{$search_field} LIKE '".$db->escape_string($view['conditions'][$search_field])."'";
			}
			else

				$ip_sql = "{$search_field} LIKE '".$db->escape_string($view['conditions'][$search_field])."'";
			}
			else

Zeile 1905Zeile 1974
			}
			$search_sql .= " AND {$ip_sql}";
		}

 
			}
			$search_sql .= " AND {$ip_sql}";
		}

 
	}

	// Post IP searching
	if($view['conditions']['postip'])
	{
		// IPv6 IP
		if(strpos($view['conditions']['postip'], ":") !== false)
		{
			$view['conditions']['postip'] = str_replace("*", "%", $view['conditions']['postip']);
			$ip_sql = "ipaddress LIKE '".$db->escape_string($view['conditions']['postip'])."'";
		}
		else
		{
			$ip_range = fetch_longipv4_range($view['conditions']['postip']);
			if(!is_array($ip_range))
			{
				$ip_sql = "longipaddress='{$ip_range}'";
			}
			else
			{
				$ip_sql = "longipaddress > '{$ip_range[0]}' AND longipaddress < '{$ip_range[1]}'";
			}
		}
		$ip_uids = array(0);
		$query = $db->simple_select("posts", "uid", $ip_sql);
		while($uid = $db->fetch_field($query, "uid"))
		{
			$ip_uids[] = $uid;
		}
		$search_sql .= " AND u.uid IN(".implode(',', $ip_uids).")";
		unset($ip_uids);

	}

	// Usergroup based searching

	}

	// Usergroup based searching

Zeile 1923Zeile 2023
				case "sqlite3":
				case "sqlite2":
					$additional_sql .= " OR ','||additionalgroups||',' LIKE '%,{$usergroup},%'";

 
				case "sqlite3":
				case "sqlite2":
					$additional_sql .= " OR ','||additionalgroups||',' LIKE '%,{$usergroup},%'";

 
					break;

				default:
					$additional_sql .= "OR CONCAT(',',additionalgroups,',') LIKE '%,{$usergroup},%'";
			}
		}
		$search_sql .= " AND (u.usergroup IN (".implode(",", $view['conditions']['usergroup']).") {$additional_sql})";

 
				default:
					$additional_sql .= "OR CONCAT(',',additionalgroups,',') LIKE '%,{$usergroup},%'";
			}
		}
		$search_sql .= " AND (u.usergroup IN (".implode(",", $view['conditions']['usergroup']).") {$additional_sql})";

	}


	}


	// COPPA users only?
	if($view['conditions']['coppa'])

 
	// COPPA users only?
	if($view['conditions']['coppa'])

	{

	{

		$search_sql .= " AND u.coppauser=1 AND u.usergroup=5";
	}


		$search_sql .= " AND u.coppauser=1 AND u.usergroup=5";
	}


Zeile 1940Zeile 2041
	if($view['extra_sql'])
	{
		$search_sql .= $view['extra_sql'];

 
	if($view['extra_sql'])
	{
		$search_sql .= $view['extra_sql'];

	}

	}


	// Lets fetch out how many results we have
	$query = $db->query("


	// Lets fetch out how many results we have
	$query = $db->query("

Zeile 1974Zeile 2075
		{
			$start = 0;
			$mybb->input['page'] = 1;

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

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

		}
		
		switch($view['sortby'])

		}
		
		switch($view['sortby'])

Zeile 2032Zeile 2139
			{
				if($user['coppauser'])
				{

 
			{
				if($user['coppauser'])
				{

					$popup->add_item($lang->approve_coppa_user, "index.php?module=user/users&amp;action=activate_user&amp;uid={$user['uid']}");

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

				}
				else
				{

 
				}
				else
				{

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

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

				}
			}


				}
			}