Vergleich admin/modules/user/users.php - 1.4.0 - 1.4.9

Keine Änderungen Hinzugefügt Modifiziert Entfernt
Zeile 1	Zeile 1
<?php /** * MyBB 1.4	<?php /** * MyBB 1.4
* Copyright � 2008 MyBB Group, All Rights Reserved	* Copyright © 2008 MyBB Group, All Rights Reserved
* * 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 4054 2008-07-31 05:19:05Z Tikitiki $	* $Id: users.php 4389 2009-06-26 04:29:32Z RyanGordon $
*/ // Disallow direct access to this file for security reasons	*/ // Disallow direct access to this file for security reasons
Zeile 165	Zeile 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 175	Zeile 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 199	Zeile 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 222	Zeile 228
else { $breadcrumb .= " » {$gallery_name}";	else { $breadcrumb .= " » {$gallery_name}";
}	}
} } else	} } else
Zeile 332	Zeile 338
echo "</html>"; exit; }	echo "</html>"; exit; }

if($mybb->input['action'] == "activate_user") { $plugins->run_hooks("admin_user_users_coppa_activate");	if($mybb->input['action'] == "activate_user") { $plugins->run_hooks("admin_user_users_coppa_activate");
Zeile 342	Zeile 348
// Does the user not exist? if(!$user['uid'] \|\| $user['usergroup'] != 5)	// Does the user not exist? if(!$user['uid'] \|\| $user['usergroup'] != 5)
{	{
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");
}	}
$updated_user['usergroup'] = $user['usergroup'];	$updated_user['usergroup'] = $user['usergroup'];
Zeile 355	Zeile 361
$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']}'");
}	}
// 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) {
Zeile 374	Zeile 380
// Log admin action log_admin_action($user['uid'], $user['username']);	// Log admin action log_admin_action($user['uid'], $user['username']);
if($user['coppauser'])	if($mybb->input['from'] == "home")
{	{
flash_message($lang->success_coppa_activated, 'success');	if($user['coppauser']) { $message = $lang->success_coppa_activated; } else { $message = $lang->success_activated; } update_admin_session('flash_message2', array('message' => $message, 'type' => 'success'));
} else {	} else {
flash_message($lang->success_activated, 'success');	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 { $url = "index.php?module=user/users&action=edit&uid={$user['uid']}"; }	else { $url = "index.php?module=user/users&action=edit&uid={$user['uid']}"; }
admin_redirect($url); } if($mybb->input['action'] == "add") { $plugins->run_hooks("admin_user_users_add");	admin_redirect($url); } 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 = ''; }	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";	// Set up user handler. require_once MYBB_ROOT."inc/datahandlers/user.php";
Zeile 546	Zeile 574
{ unset($mybb->input['additionalgroups'][$gid]); }	{ unset($mybb->input['additionalgroups'][$gid]); }
}	}
$additionalgroups = implode(",", $mybb->input['additionalgroups']); } else	$additionalgroups = implode(",", $mybb->input['additionalgroups']); } else
Zeile 569	Zeile 597
"displaygroup" => $mybb->input['displaygroup'], "postnum" => $mybb->input['postnum'], "usertitle" => $mybb->input['usertitle'],	"displaygroup" => $mybb->input['displaygroup'], "postnum" => $mybb->input['postnum'], "usertitle" => $mybb->input['usertitle'],
"timezone" => $mybb->input['timezoneoffset'],	"timezone" => $mybb->input['timezone'],
"language" => $mybb->input['language'], "profile_fields" => $mybb->input['profile_fields'], "profile_fields_editable" => true,	"language" => $mybb->input['language'], "profile_fields" => $mybb->input['profile_fields'], "profile_fields_editable" => true,
Zeile 597	Zeile 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 652	Zeile 674
"avatardimensions" => "", "avatartype" => "" );	"avatardimensions" => "", "avatartype" => "" );
remove_avatars($mybb->user['uid']);	remove_avatars($user['uid']);
}	}
Zeile 716	Zeile 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 902	Zeile 924
} else {	} else {
$percent_posts = round($memprofile['postnum']*100/$posts, 2);;	$percent_posts = round($user['postnum']*100/$posts, 2);
} $user_permissions = user_permissions($user['uid']);	} $user_permissions = user_permissions($user['uid']);
Zeile 932	Zeile 954
{ $age = get_age($user['birthday']); }	{ $age = get_age($user['birthday']); }

else { $age = ''; }	else { $age = ''; }
$table->construct_cell("<div style=\"width: 126px; height: 126px;\" class=\"user_avatar\"><img src=\"{$user['avatar']}\" style=\"margin-top: {$avatar_top}px\" width=\"{$scaled_dimensions['width']}\" height=\"{$scaled_dimensions['height']}\" alt=\"\" /></div>", array('rowspan' => 6, 'width' => 1));	$table->construct_cell("<div style=\"width: 126px; height: 126px;\" class=\"user_avatar\"><img src=\"".htmlspecialchars_uni($user['avatar'])."\" style=\"margin-top: {$avatar_top}px\" width=\"{$scaled_dimensions['width']}\" height=\"{$scaled_dimensions['height']}\" alt=\"\" /></div>", array('rowspan' => 6, 'width' => 1));
$table->construct_cell("<strong>{$lang->email_address}:</strong> <a href=\"mailto:".htmlspecialchars_uni($user['email'])."\">".htmlspecialchars_uni($user['email'])."</a>"); $table->construct_cell("<strong>{$lang->last_active}:</strong> {$last_active}"); $table->construct_row(); $table->construct_cell("<strong>{$lang->registration_date}:</strong> {$reg_date}"); $table->construct_cell("<strong>{$lang->local_time}:</strong> {$local_time}");	$table->construct_cell("<strong>{$lang->email_address}:</strong> <a href=\"mailto:".htmlspecialchars_uni($user['email'])."\">".htmlspecialchars_uni($user['email'])."</a>"); $table->construct_cell("<strong>{$lang->last_active}:</strong> {$last_active}"); $table->construct_row(); $table->construct_cell("<strong>{$lang->registration_date}:</strong> {$reg_date}"); $table->construct_cell("<strong>{$lang->local_time}:</strong> {$local_time}");
$table->construct_row();	$table->construct_row();
$table->construct_cell("<strong>{$lang->posts}:</strong> {$user['postnum']}"); $table->construct_cell("<strong>{$lang->age}:</strong> {$age}"); $table->construct_row();	$table->construct_cell("<strong>{$lang->posts}:</strong> {$user['postnum']}"); $table->construct_cell("<strong>{$lang->age}:</strong> {$age}"); $table->construct_row();
Zeile 964	Zeile 987
// PROFILE // echo "<div id=\"tab_profile\">\n";	// PROFILE // echo "<div id=\"tab_profile\">\n";

$form_container = new FormContainer($lang->required_profile_info.": {$user['username']}"); $form_container->output_row($lang->username." <em>*</em>", "", $form->generate_text_box('username', $mybb->input['username'], array('id' => 'username')), 'username'); $form_container->output_row($lang->new_password, $lang->new_password_desc, $form->generate_password_box('new_password', $mybb->input['new_password'], array('id' => 'new_password')), 'new_password');	$form_container = new FormContainer($lang->required_profile_info.": {$user['username']}"); $form_container->output_row($lang->username." <em>*</em>", "", $form->generate_text_box('username', $mybb->input['username'], array('id' => 'username')), 'username'); $form_container->output_row($lang->new_password, $lang->new_password_desc, $form->generate_password_box('new_password', $mybb->input['new_password'], array('id' => 'new_password')), 'new_password');
Zeile 977	Zeile 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']);
} $form_container->output_row($lang->primary_user_group." <em>*</em>", "", $form->generate_select_box('usergroup', $options, $mybb->input['usergroup'], array('id' => 'usergroup')), 'usergroup');	} $form_container->output_row($lang->primary_user_group." <em>*</em>", "", $form->generate_select_box('usergroup', $options, $mybb->input['usergroup'], array('id' => 'usergroup')), 'usergroup');
Zeile 986	Zeile 1014
// Output custom profile fields - required output_custom_profile_fields($profile_fields['required'], $mybb->input['profile_fields'], $form_container, $form);	// Output custom profile fields - required output_custom_profile_fields($profile_fields['required'], $mybb->input['profile_fields'], $form_container, $form);

$form_container->end(); $form_container = new FormContainer($lang->optional_profile_info.": {$user['username']}");	$form_container->end(); $form_container = new FormContainer($lang->optional_profile_info.": {$user['username']}");
Zeile 1007	Zeile 1035
// // ACCOUNT SETTINGS //	// // ACCOUNT SETTINGS //

// Plugin hook note - we should add hooks in above each output_row for the below so users can add their own options to each group :> echo "<div id=\"tab_settings\">\n";	// Plugin hook note - we should add hooks in above each output_row for the below so users can add their own options to each group :> echo "<div id=\"tab_settings\">\n";
Zeile 1017	Zeile 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 1043	Zeile 1076
$date_options = array( "<label for=\"dateformat\">{$lang->date_format}:</label><br />".$form->generate_select_box("dateformat", $date_format_options, $mybb->input['dateformat'], array('id' => 'dateformat')), "<label for=\"dateformat\">{$lang->time_format}:</label><br />".$form->generate_select_box("timeformat", $time_format_options, $mybb->input['timeformat'], array('id' => 'timeformat')),	$date_options = array( "<label for=\"dateformat\">{$lang->date_format}:</label><br />".$form->generate_select_box("dateformat", $date_format_options, $mybb->input['dateformat'], array('id' => 'dateformat')), "<label for=\"dateformat\">{$lang->time_format}:</label><br />".$form->generate_select_box("timeformat", $time_format_options, $mybb->input['timeformat'], array('id' => 'timeformat')),
"<label for=\"timezone\">{$lang->time_zone}:</label><br />".build_timezone_select("timezone", $mybb->user['timezone']),	"<label for=\"timezone\">{$lang->time_zone}:</label><br />".build_timezone_select("timezone", $mybb->input['timezone']),
"<label for=\"dstcorrection\">{$lang->daylight_savings_time_correction}:</label><br />".$form->generate_select_box("dstcorrection", array(2 => $lang->automatically_detect, 1 => $lang->always_use_dst_correction, 0 => $lang->never_use_dst_correction), $mybb->input['dstcorrection'], array('id' => 'dstcorrection')) ); $form_container->output_row($lang->date_and_time_options, "", "<div class=\"user_settings_bit\">".implode("</div><div class=\"user_settings_bit\">", $date_options)."</div>");	"<label for=\"dstcorrection\">{$lang->daylight_savings_time_correction}:</label><br />".$form->generate_select_box("dstcorrection", array(2 => $lang->automatically_detect, 1 => $lang->always_use_dst_correction, 0 => $lang->never_use_dst_correction), $mybb->input['dstcorrection'], array('id' => 'dstcorrection')) ); $form_container->output_row($lang->date_and_time_options, "", "<div class=\"user_settings_bit\">".implode("</div><div class=\"user_settings_bit\">", $date_options)."</div>");
Zeile 1104	Zeile 1137
"<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')) ); $form_container->output_row($lang->thread_view_options, "", "<div class=\"user_settings_bit\">".implode("</div><div class=\"user_settings_bit\">", $thread_options)."</div>");	"<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')) ); $form_container->output_row($lang->thread_view_options, "", "<div class=\"user_settings_bit\">".implode("</div><div class=\"user_settings_bit\">", $thread_options)."</div>");
	$languages = array_merge(array('' => $lang->use_default), $lang->get_languages());
$other_options = array( $form->generate_check_box("showredirect", 1, $lang->show_redirect, array("checked" => $mybb->input['showredirect'])), $form->generate_check_box("showcodebuttons", "1", $lang->show_code_buttons, array("checked" => $mybb->input['showcodebuttons'])), "<label for=\"style\">{$lang->theme}:</label><br />".build_theme_select("style", $mybb->input['style'], 0, "", 1),	$other_options = array( $form->generate_check_box("showredirect", 1, $lang->show_redirect, array("checked" => $mybb->input['showredirect'])), $form->generate_check_box("showcodebuttons", "1", $lang->show_code_buttons, array("checked" => $mybb->input['showcodebuttons'])), "<label for=\"style\">{$lang->theme}:</label><br />".build_theme_select("style", $mybb->input['style'], 0, "", 1),
"<label for=\"language\">{$lang->board_language}:</label><br />".$form->generate_select_box("language", $lang->get_languages(), $mybb->input['language'], array('id' => 'language'))	"<label for=\"language\">{$lang->board_language}:</label><br />".$form->generate_select_box("language", $languages, $mybb->input['language'], array('id' => 'language'))
); $form_container->output_row($lang->other_options, "", "<div class=\"user_settings_bit\">".implode("</div><div class=\"user_settings_bit\">", $other_options)."</div>");	); $form_container->output_row($lang->other_options, "", "<div class=\"user_settings_bit\">".implode("</div><div class=\"user_settings_bit\">", $other_options)."</div>");
Zeile 1120	Zeile 1155
// SIGNATURE EDITOR // $signature_editor = $form->generate_text_area("signature", $mybb->input['signature'], array('id' => 'signature', 'rows' => 15, 'cols' => '70', 'style' => 'width: 95%'));	// SIGNATURE EDITOR // $signature_editor = $form->generate_text_area("signature", $mybb->input['signature'], array('id' => 'signature', 'rows' => 15, 'cols' => '70', 'style' => 'width: 95%'));
$sig_smilies = "off";	$sig_smilies = $lang->off;
if($mybb->settings['sigsmilies'] == 1) {	if($mybb->settings['sigsmilies'] == 1) {
$sig_smilies = "on";	$sig_smilies = $lang->on;
}	}
$sig_mycode = "off";	$sig_mycode = $lang->off;
if($mybb->settings['sigmycode'] == 1) {	if($mybb->settings['sigmycode'] == 1) {
$sig_mycode = "on";	$sig_mycode = $lang->on;
$signature_editor .= build_mycode_inserter("signature");	$signature_editor .= build_mycode_inserter("signature");
} $sig_html = "off";	} $sig_html = $lang->off;
if($mybb->settings['sightml'] == 1)	if($mybb->settings['sightml'] == 1)
{ $sig_html = "on";	{ $sig_html = $lang->on;
}	}
$sig_imcode = "on";	$sig_imgcode = $lang->off;
if($mybb->settings['sigimgcode'] == 1) {	if($mybb->settings['sigimgcode'] == 1) {
$sig_imgcode = "off";	$sig_imgcode = $lang->on;
} echo "<div id=\"tab_signature\">\n"; $form_container = new FormContainer("{$lang->signature}: {$user['username']}"); $form_container->output_row($lang->signature, $lang->sprintf($lang->signature_desc, $sig_mycode, $sig_smilies, $sig_imgcode, $sig_html), $signature_editor, 'signature');	} echo "<div id=\"tab_signature\">\n"; $form_container = new FormContainer("{$lang->signature}: {$user['username']}"); $form_container->output_row($lang->signature, $lang->sprintf($lang->signature_desc, $sig_mycode, $sig_smilies, $sig_imgcode, $sig_html), $signature_editor, 'signature');

$signature_options = array( $form->generate_radio_button("update_posts", "enable", $lang->enable_sig_in_all_posts, array("checked" => 0)), $form->generate_radio_button("update_posts", "disable", $lang->disable_sig_in_all_posts, array("checked" => 0)),	$signature_options = array( $form->generate_radio_button("update_posts", "enable", $lang->enable_sig_in_all_posts, array("checked" => 0)), $form->generate_radio_button("update_posts", "disable", $lang->disable_sig_in_all_posts, array("checked" => 0)),
Zeile 1152	Zeile 1187
); $form_container->output_row($lang->singature_preferences, "", implode("<br />", $signature_options));	); $form_container->output_row($lang->singature_preferences, "", implode("<br />", $signature_options));

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

// // AVATAR MANAGER //	// // AVATAR MANAGER //
Zeile 1163	Zeile 1198
$table = new Table; $table->construct_header($lang->current_avatar, array('colspan' => 2));	$table = new Table; $table->construct_header($lang->current_avatar, array('colspan' => 2));
$table->construct_cell("<div style=\"width: 126px; height: 126px;\" class=\"user_avatar\"><img src=\"{$user['avatar']}\" width=\"{$scaled_dimensions['width']}\" style=\"margin-top: {$avatar_top}px\" height=\"{$scaled_dimensions['height']}\" alt=\"\" /></div>", array('width' => 1));	$table->construct_cell("<div style=\"width: 126px; height: 126px;\" class=\"user_avatar\"><img src=\"".htmlspecialchars_uni($user['avatar'])."\" width=\"{$scaled_dimensions['width']}\" style=\"margin-top: {$avatar_top}px\" height=\"{$scaled_dimensions['height']}\" alt=\"\" /></div>", array('width' => 1));
if($user['avatartype'] == "upload" \|\| stristr($user['avatar'], $mybb->settings['avataruploadpath']))	if($user['avatartype'] == "upload" \|\| stristr($user['avatar'], $mybb->settings['avataruploadpath']))
{	{
$current_avatar_msg = "<br /><strong>{$lang->user_current_using_uploaded_avatar}</strong>"; } else if($user['avatartype'] == "gallery" \|\| stristr($user['avatar'], $mybb->settings['avatardir']))	$current_avatar_msg = "<br /><strong>{$lang->user_current_using_uploaded_avatar}</strong>"; } else if($user['avatartype'] == "gallery" \|\| stristr($user['avatar'], $mybb->settings['avatardir']))
Zeile 1177	Zeile 1212
{ $current_avatar_msg = "<br /><strong>{$lang->user_current_using_remote_avatar}</strong>"; $avatar_url = $user['avatar'];	{ $current_avatar_msg = "<br /><strong>{$lang->user_current_using_remote_avatar}</strong>"; $avatar_url = $user['avatar'];
}	}
if($errors) { $avatar_url = $mybb->input['avatar_url'];	if($errors) { $avatar_url = $mybb->input['avatar_url'];
}	}
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}";
}	}
if($mybb->settings['avatarsize'])	if($mybb->settings['avatarsize'])
{	{
$maximum_size = get_friendly_size($mybb->settings['avatarsize']*1024); $max_size .= "<br />{$lang->avatar_max_size} {$maximum_size}"; }	$maximum_size = get_friendly_size($mybb->settings['avatarsize']*1024); $max_size .= "<br />{$lang->avatar_max_size} {$maximum_size}"; }
Zeile 1199	Zeile 1234
if($user['avatar']) { $remove_avatar = "<br /><br />".$form->generate_check_box("remove_avatar", 1, "<strong>{$lang->remove_avatar}</strong>");	if($user['avatar']) { $remove_avatar = "<br /><br />".$form->generate_check_box("remove_avatar", 1, "<strong>{$lang->remove_avatar}</strong>");
}	}
$table->construct_cell($lang->avatar_desc."{$remove_avatar}<br /><small>{$max_size}</small>"); $table->construct_row();	$table->construct_cell($lang->avatar_desc."{$remove_avatar}<br /><small>{$max_size}</small>"); $table->construct_row();
Zeile 1265	Zeile 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 1275	Zeile 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')); $plugins->run_hooks("admin_user_users_delete_commit");	// Update forum stats update_stats(array('numusers' => '-1')); $plugins->run_hooks("admin_user_users_delete_commit");

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

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");
} else	} else
{ $page->output_confirm_action("index.php?module=user/users&action=delete&uid={$user['uid']}", $lang->user_deletion_confirmation); }	{ $page->output_confirm_action("index.php?module=user/users&action=delete&uid={$user['uid']}", $lang->user_deletion_confirmation); }
Zeile 1305	Zeile 1342
'title' => $lang->show_referrers, 'link' => "index.php?module=user/users&action=referrers&uid={$mybb->input['uid']}", 'description' => $lang->show_referrers_desc	'title' => $lang->show_referrers, 'link' => "index.php?module=user/users&action=referrers&uid={$mybb->input['uid']}", 'description' => $lang->show_referrers_desc
); $page->output_nav_tabs($sub_tabs, 'referrers');	); $page->output_nav_tabs($sub_tabs, 'referrers');
// 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);

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

$admin_view['conditions'] = unserialize($admin_view['conditions']); $admin_view['conditions']['referrer'] = $mybb->input['uid'];	$admin_view['conditions'] = unserialize($admin_view['conditions']); $admin_view['conditions']['referrer'] = $mybb->input['uid'];

echo build_users_view($admin_view); $page->output_footer(); } if($mybb->input['action'] == "ipaddresses")	echo build_users_view($admin_view); $page->output_footer(); } if($mybb->input['action'] == "ipaddresses")
{	{
$plugins->run_hooks("admin_user_users_ipaddresses"); $page->add_breadcrumb_item($lang->ip_addresses);	$plugins->run_hooks("admin_user_users_ipaddresses"); $page->add_breadcrumb_item($lang->ip_addresses);
Zeile 1361	Zeile 1402
else { $popup = new PopupMenu("user_last", $lang->options);	else { $popup = new PopupMenu("user_last", $lang->options);
$popup->add_item($lang->show_users_regged_with_ip, "index.php?module=user/users&action=search&regip={$user['lastip']}"); $popup->add_item($lang->show_users_posted_with_ip, "index.php?module=user/users&action=search&postip={$user['lastip']}");	$popup->add_item($lang->show_users_regged_with_ip, "index.php?module=user/users&action=search&results=1&conditions=".urlencode(serialize(array("regip" => $user['lastip'])))); $popup->add_item($lang->show_users_posted_with_ip, "index.php?module=user/users&results=1&action=search&conditions=".urlencode(serialize(array("postip" => $user['lastip']))));
$popup->add_item($lang->ban_ip, "index.php?module=config/banning&filter={$user['lastip']}"); $controls = $popup->fetch(); } $table->construct_cell("<strong>{$lang->last_known_ip}:</strong> {$user['lastip']}");	$popup->add_item($lang->ban_ip, "index.php?module=config/banning&filter={$user['lastip']}"); $controls = $popup->fetch(); } $table->construct_cell("<strong>{$lang->last_known_ip}:</strong> {$user['lastip']}");
$table->construct_cell($controls, array('class' => "align_center")); $table->construct_row();	$table->construct_cell($controls, array('class' => "align_center")); $table->construct_row();
if(empty($user['regip'])) { $user['regip'] = $lang->unknown; $controls = '';	if(empty($user['regip'])) { $user['regip'] = $lang->unknown; $controls = '';
}	}
else { $popup = new PopupMenu("user_reg", $lang->options);	else { $popup = new PopupMenu("user_reg", $lang->options);
$popup->add_item($lang->show_users_regged_with_ip, "index.php?module=user/users&action=search&regip={$user['regip']}"); $popup->add_item($lang->show_users_posted_with_ip, "index.php?module=user/users&action=search&postip={$user['regip']}");	$popup->add_item($lang->show_users_regged_with_ip, "index.php?module=user/users&results=1&action=search&conditions=".urlencode(serialize(array("regip" => $user['regip'])))); $popup->add_item($lang->show_users_posted_with_ip, "index.php?module=user/users&results=1&action=search&conditions=".urlencode(serialize(array("postip" => $user['regip']))));
$popup->add_item($lang->ban_ip, "index.php?module=config/banning&filter={$user['regip']}"); $controls = $popup->fetch(); }	$popup->add_item($lang->ban_ip, "index.php?module=config/banning&filter={$user['regip']}"); $controls = $popup->fetch(); }
Zeile 1387	Zeile 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&action=search&regip={$ip['ipaddress']}"); $popup->add_item($lang->show_users_posted_with_ip, "index.php?module=user/users&action=search&postip={$ip['ipaddress']}"); $popup->add_item($lang->ban_ip, "index.php?module=config/banning&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&results=1&action=search&conditions=".urlencode(serialize(array("regip" => $ip['ipaddress'])))); $popup->add_item($lang->show_users_posted_with_ip, "index.php?module=user/users&results=1&action=search&conditions=".urlencode(serialize(array("postip" => $ip['ipaddress'])))); $popup->add_item($lang->ban_ip, "index.php?module=config/banning&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 1421	Zeile 1462
if(!$source_user['uid']) { $errors[] = $lang->error_invalid_user_source;	if(!$source_user['uid']) { $errors[] = $lang->error_invalid_user_source;
}	}
$query = $db->simple_select("users", "*", "LOWER(username)='".$db->escape_string(my_strtolower($mybb->input['destination_username']))."'"); $destination_user = $db->fetch_array($query); if(!$destination_user['uid'])	$query = $db->simple_select("users", "*", "LOWER(username)='".$db->escape_string(my_strtolower($mybb->input['destination_username']))."'"); $destination_user = $db->fetch_array($query); if(!$destination_user['uid'])
Zeile 1459	Zeile 1500
$db->update_query("pollvotes", $uid_update, "uid='{$source_user['uid']}'"); $db->update_query("posts", $uid_update, "uid='{$source_user['uid']}'"); $db->update_query("privatemessages", $uid_update, "uid='{$source_user['uid']}'");	$db->update_query("pollvotes", $uid_update, "uid='{$source_user['uid']}'"); $db->update_query("posts", $uid_update, "uid='{$source_user['uid']}'"); $db->update_query("privatemessages", $uid_update, "uid='{$source_user['uid']}'");
$db->update_query("reputation", $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->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']}'"); // Merging Reputation $query = $db->simple_select("reputation", "rid, uid", "adduid = '{$source_user['uid']}' OR adduid = '{$uid_update['uid']}'", array("order_by" => "dateline", "order_dir" => "DESC")); while($result = $db->fetch_array($query)) { // Let's try and remove old one if it's the same uid if($result['uid'] == $last['uid']) { $db->delete_query("reputation", "rid = '".$result['rid']."'"); $db->update_query("reputation", array("adduid" => $uid_update['uid']), "rid = '".$last['rid']."'"); } $last = array( "rid" => $result['rid'], "uid" => $result['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 1575	Zeile 1637
if(!$admin_view['vid']) { $default_view = fetch_default_view("user");	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 1596	Zeile 1662
if($mybb->input['sortby']) { $admin_view['sortby'] = $mybb->input['sortby'];	if($mybb->input['sortby']) { $admin_view['sortby'] = $mybb->input['sortby'];
}	}
if($mybb->input['perpage']) {	if($mybb->input['perpage']) {
Zeile 1625	Zeile 1691
} 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; }
}	}
}	}
$page->add_breadcrumb_item($lang->find_users); $page->output_header($lang->find_users);	$page->add_breadcrumb_item($lang->find_users); $page->output_header($lang->find_users);
$page->output_nav_tabs($sub_tabs, 'find_users'); // If we have any error messages, show them if($errors) { $page->output_inline_error($errors); }	$page->output_nav_tabs($sub_tabs, 'find_users'); // If we have any error messages, show them if($errors) { $page->output_inline_error($errors); }
if(!$mybb->input['displayas']) { $mybb->input['displayas'] = "card";	if(!$mybb->input['displayas']) { $mybb->input['displayas'] = "card";
Zeile 1675	Zeile 1750
$page->output_nav_tabs($sub_tabs, 'browse_users');	$page->output_nav_tabs($sub_tabs, 'browse_users');
if($mybb->input['search_id'] && $admin_session['user_views'][$mybb->input['search_id']])	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	{ $admin_view = $admin_session['data']['user_views'][$mybb->input['search_id']]; unset($admin_view['extra_sql']); } else
{	{
// Showing a specific view if($mybb->input['vid'])	// Showing a specific view 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 if(!$admin_view['vid'] \|\| ($admin_view['visibility'] == 1 && $admin_view['uid'] != $mybb->user['uid']))	$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 if(!$admin_view['vid'] \|\| ($admin_view['visibility'] == 1 && $admin_view['uid'] != $mybb->user['uid']))
{	{
unset($admin_view); } }	unset($admin_view); } }
Zeile 1698	Zeile 1773
if(!$admin_view) { $default_view = fetch_default_view("user");	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);
} }	} }
// Fetch a list of all of the views for this user $popup = new PopupMenu("views", $lang->views);	// Fetch a list of all of the views for this user $popup = new PopupMenu("views", $lang->views);

$query = $db->simple_select("adminviews", "*", "type='user' AND (visibility=2 OR uid={$mybb->user['uid']})", array("order_by" => "title")); while($view = $db->fetch_array($query)) { $popup->add_item(htmlspecialchars_uni($view['title']), "index.php?module=user/users&vid={$view['vid']}");	$query = $db->simple_select("adminviews", "*", "type='user' AND (visibility=2 OR uid={$mybb->user['uid']})", array("order_by" => "title")); while($view = $db->fetch_array($query)) { $popup->add_item(htmlspecialchars_uni($view['title']), "index.php?module=user/users&vid={$view['vid']}");
}	}
$popup->add_item("<em>{$lang->manage_views}</em>", "index.php?module=user/users&action=views"); $admin_view['popup'] = $popup->fetch(); if($mybb->input['type'])	$popup->add_item("<em>{$lang->manage_views}</em>", "index.php?module=user/users&action=views"); $admin_view['popup'] = $popup->fetch(); if($mybb->input['type'])
{	{
$admin_view['view_type'] = $mybb->input['type']; }	$admin_view['view_type'] = $mybb->input['type']; }
Zeile 1723	Zeile 1802
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($errors) {	} // If we have any error messages, show them if($errors) {
	echo "<div style=\"display: inline; float: right;\">{$admin_view['popup']}</div><br />\n";
$page->output_inline_error($errors); }	$page->output_inline_error($errors); }

echo $results; $page->output_footer();	echo $results; $page->output_footer();
Zeile 1744	Zeile 1836
if($view['title']) { $title_string = "view_title_{$view['vid']}";	if($view['title']) { $title_string = "view_title_{$view['vid']}";

if($lang->$title_string) { $view['title'] = $lang->$title_string;	if($lang->$title_string) { $view['title'] = $lang->$title_string;
Zeile 1796	Zeile 1888
if(!isset($admin_session['data']['last_users_view']) \|\| $admin_session['data']['last_users_view'] != str_replace("&", "&", $view['url'])) { update_admin_session('last_users_url', str_replace("&", "&", $view['url']));	if(!isset($admin_session['data']['last_users_view']) \|\| $admin_session['data']['last_users_view'] != str_replace("&", "&", $view['url'])) { update_admin_session('last_users_url', str_replace("&", "&", $view['url']));
} $table = new Table;	} // Do we not have any views? if(empty($view)) { return false; } $table = new Table;
// Build header for table based view if($view['view_type'] != "card") { foreach($view['fields'] as $field) { if(!$user_view_fields[$field])	// Build header for table based view if($view['view_type'] != "card") { foreach($view['fields'] as $field) { if(!$user_view_fields[$field])
{	{
continue; } $view_field = $user_view_fields[$field];	continue; } $view_field = $user_view_fields[$field];
Zeile 1827	Zeile 1925
$search_sql = '1=1'; // Build the search SQL for users	$search_sql = '1=1'; // Build the search SQL for users

// List of valid LIKE search fields $user_like_fields = array("username", "email", "website", "icq", "aim", "yahoo", "msn", "signature", "usertitle"); foreach($user_like_fields as $search_field)	// List of valid LIKE search fields $user_like_fields = array("username", "email", "website", "icq", "aim", "yahoo", "msn", "signature", "usertitle"); foreach($user_like_fields as $search_field)
Zeile 1853	Zeile 1951
foreach($direction_fields as $search_field) { $direction_field = $search_field."_dir";	foreach($direction_fields as $search_field) { $direction_field = $search_field."_dir";
if($view['conditions'][$search_field] && $view['conditions'][$direction_field])	if(($view['conditions'][$search_field] \|\| $view['conditions'][$search_field] === '0') && $view['conditions'][$direction_field])
{ switch($view['conditions'][$direction_field]) {	{ switch($view['conditions'][$direction_field]) {
Zeile 1876	Zeile 1974
{ 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])."'";	$ip_sql = "{$search_field} LIKE '".$db->escape_string($view['conditions'][$search_field])."'";
} else	} else
{ $ip_range = fetch_longipv4_range($view['conditions'][$search_field]); if(!is_array($ip_range)) { $ip_sql = "long{$search_field}='{$ip_range}'";	{ $ip_range = fetch_longipv4_range($view['conditions'][$search_field]); if(!is_array($ip_range)) { $ip_sql = "long{$search_field}='{$ip_range}'";
}	}
else { $ip_sql = "long{$search_field} > '{$ip_range[0]}' AND long{$search_field} < '{$ip_range[1]}'"; }	else { $ip_sql = "long{$search_field} > '{$ip_range[0]}' AND long{$search_field} < '{$ip_range[1]}'"; }
}	}
$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 1915	Zeile 2043
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},%'"; }	default: $additional_sql .= "OR CONCAT(',',additionalgroups,',') LIKE '%,{$usergroup},%'"; }
Zeile 1941	Zeile 2070
WHERE {$search_sql} "); $num_results = $db->fetch_field($query, "num_results");	WHERE {$search_sql} "); $num_results = $db->fetch_field($query, "num_results");

// No matching results then return false if(!$num_results)	// No matching results then return false if(!$num_results)
{	{
return false; } // Generate the list of results	return false; } // Generate the list of results
Zeile 1953	Zeile 2082
if(!$view['perpage']) { $view['perpage'] = 20;	if(!$view['perpage']) { $view['perpage'] = 20;
}	}
$view['perpage'] = intval($view['perpage']); // Establish which page we're viewing and the starting index for querying $mybb->input['page'] = intval($mybb->input['page']); if($mybb->input['page'])	$view['perpage'] = intval($view['perpage']); // Establish which page we're viewing and the starting index for querying $mybb->input['page'] = intval($mybb->input['page']); if($mybb->input['page'])
{	{
$start = ($mybb->input['page'] - 1) * $view['perpage']; } else { $start = 0; $mybb->input['page'] = 1;	$start = ($mybb->input['page'] - 1) * $view['perpage']; } else { $start = 0; $mybb->input['page'] = 1;
	} $from_bit = ""; if($mybb->input['from'] == "home") { $from_bit = "&from=home";
} switch($view['sortby'])	} switch($view['sortby'])
Zeile 2024	Zeile 2159
{ if($user['coppauser']) {	{ if($user['coppauser']) {
$popup->add_item($lang->approve_coppa_user, "index.php?module=user/users&action=activate_user&uid={$user['uid']}");	$popup->add_item($lang->approve_coppa_user, "index.php?module=user/users&action=activate_user&uid={$user['uid']}{$from_bit}");
} else {	} else {
$popup->add_item($lang->approve_user, "index.php?module=user/users&action=activate_user&uid={$user['uid']}");	$popup->add_item($lang->approve_user, "index.php?module=user/users&action=activate_user&uid={$user['uid']}{$from_bit}");
} }	} }
Zeile 2074	Zeile 2209
{ $user['avatar'] = "styles/{$page->style}/images/default_avatar.gif"; }	{ $user['avatar'] = "styles/{$page->style}/images/default_avatar.gif"; }
$user['view']['avatar'] = "<img src=\"{$user['avatar']}\" alt=\"\" width=\"{$scaled_avatar['width']}\" height=\"{$scaled_avatar['height']}\" />";	$user['view']['avatar'] = "<img src=\"".htmlspecialchars_uni($user['avatar'])."\" alt=\"\" width=\"{$scaled_avatar['width']}\" height=\"{$scaled_avatar['height']}\" />";
if($view['view_type'] == "card") {	if($view['view_type'] == "card") {