} else {
if ($_REQUEST['do'] == 'edit') {
print_input_row($vbphrase['moderator_username'], 'modusername', $moderator['username'], 0);
}
}
construct_hidden_code('redir', $vbulletin->GPC['redir']);
}
// usergroup membership options
if ($_REQUEST['do'] == 'add' and can_administer('canadminusers')) {
$usergroups = array(0 => $vbphrase['do_not_change_usergroup']);
foreach ($vbulletin->usergroupcache as $usergroupid => $usergroup) {
$usergroups["{$usergroupid}"] = $usergroup['title'];
}
print_table_header($vbphrase['usergroup_options']);
print_select_row($vbphrase['change_moderator_primary_usergroup_to'], 'usergroupid', $usergroups, 0);
print_membergroup_row($vbphrase['make_moderator_a_member_of'], 'membergroupids', 2);
}
// post permissions
print_description_row($vbphrase['post_thread_permissions'], false, 2, 'thead');
print_yes_no_row($vbphrase['can_edit_posts'], 'modperms[caneditposts]', $moderator['caneditposts']);
print_yes_no_row($vbphrase['can_delete_posts'], 'modperms[candeleteposts]', $moderator['candeleteposts']);
print_yes_no_row($vbphrase['can_physically_delete_posts'], 'modperms[canremoveposts]', $moderator['canremoveposts']);
// thread permissions
print_yes_no_row($vbphrase['can_open_close_threads'], 'modperms[canopenclose]', $moderator['canopenclose']);
print_yes_no_row($vbphrase['can_edit_threads'], 'modperms[caneditthreads]', $moderator['caneditthreads']);
print_yes_no_row($vbphrase['can_manage_threads'], 'modperms[canmanagethreads]', $moderator['canmanagethreads']);
print_yes_no_row($vbphrase['can_edit_polls'], 'modperms[caneditpoll]', $moderator['caneditpoll']);
// moderation permissions
print_description_row($vbphrase['forum_permissions'], false, 2, 'thead');
print_yes_no_row($vbphrase['can_post_announcements'], 'modperms[canannounce]', $moderator['canannounce']);
print_yes_no_row($vbphrase['can_moderate_posts'], 'modperms[canmoderateposts]', $moderator['canmoderateposts']);
function print_user_search_rows($email = false)
{
global $vbulletin, $vbphrase, $stylevar;
print_label_row($vbphrase['username'], "\n\t\t<input type=\"text\" class=\"bginput\" name=\"user[username]\" tabindex=\"1\" size=\"35\"\n\t\t/><input type=\"image\" src=\"../" . $vbulletin->options['cleargifurl'] . "\" width=\"1\" height=\"1\"\n\t\t/><input type=\"submit\" class=\"button\" value=\"{$vbphrase['exact_match']}\" tabindex=\"1\" name=\"user[exact]\" />\n\t", '', 'top', 'user[username]');
if ($email) {
global $iusergroupcache;
$userarray = array('usergroupid' => 0, 'membergroupids' => '');
$iusergroupcache = array();
$usergroups = $vbulletin->db->query_read("SELECT usergroupid, title, (forumpermissions & " . $vbulletin->bf_ugp_forumpermissions['canview'] . ") AS CANVIEW FROM " . TABLE_PREFIX . "usergroup ORDER BY title");
while ($usergroup = $vbulletin->db->fetch_array($usergroups)) {
if ($usergroup['CANVIEW']) {
$userarray['membergroupids'] .= "{$usergroup['usergroupid']},";
}
$iusergroupcache["{$usergroup['usergroupid']}"] = $usergroup['title'];
}
unset($usergroup);
$vbulletin->db->free_result($usergroups);
print_checkbox_row($vbphrase['all_usergroups'], 'usergroup_all', 0, -1, $vbphrase['all_usergroups'], 'check_all_usergroups(this.form, this.checked);');
print_membergroup_row($vbphrase['primary_usergroup'], 'user[usergroupid]', 2, $userarray);
print_membergroup_row($vbphrase['additional_usergroups'], 'user[membergroup]', 2);
print_yes_no_row($vbphrase['include_users_that_have_declined_email'], 'user[adminemail]', 0);
} else {
print_chooser_row($vbphrase['primary_usergroup'], 'user[usergroupid]', 'usergroup', -1, '-- ' . $vbphrase['all_usergroups'] . ' --');
print_membergroup_row($vbphrase['additional_usergroups'], 'user[membergroup]', 2);
}
print_description_row('<div align="' . $stylevar['right'] . '"><input type="submit" class="button" value=" ' . iif($email, $vbphrase['submit'], $vbphrase['find']) . ' " tabindex="1" /></div>');
print_input_row($vbphrase['email'], 'user[email]');
print_input_row($vbphrase['parent_email_address'], 'user[parentemail]');
print_yes_no_other_row($vbphrase['coppa_user'], 'user[coppauser]', $vbphrase['either'], -1);
print_input_row($vbphrase['home_page'], 'user[homepage]');
print_input_row($vbphrase['icq_uin'], 'user[icq]');
print_input_row($vbphrase['aim_screen_name'], 'user[aim]');
print_input_row($vbphrase['yahoo_id'], 'user[yahoo]');
print_input_row($vbphrase['msn_id'], 'user[msn]');
print_input_row($vbphrase['skype_name'], 'user[skype]');
print_input_row($vbphrase['signature'], 'user[signature]');
print_input_row($vbphrase['user_title'], 'user[usertitle]');
print_input_row($vbphrase['join_date_is_after'] . '<dfn>(yyyy-mm-dd)</dfn>', 'user[joindateafter]');
print_input_row($vbphrase['join_date_is_before'] . '<dfn>(yyyy-mm-dd)</dfn>', 'user[joindatebefore]');
print_input_row($vbphrase['last_activity_is_after'] . '<dfn>(yyyy-mm-dd hh:mm:ss)</dfn>', 'user[lastactivityafter]');
print_input_row($vbphrase['last_activity_is_before'] . '<dfn>(yyyy-mm-dd hh:mm:ss)</dfn>', 'user[lastactivitybefore]');
print_input_row($vbphrase['last_post_is_after'] . '<dfn>(yyyy-mm-dd hh:mm:ss)</dfn>', 'user[lastpostafter]');
print_input_row($vbphrase['last_post_is_before'] . '<dfn>(yyyy-mm-dd hh:mm:ss)</dfn>', 'user[lastpostbefore]');
print_input_row($vbphrase['birthday_is_after'] . '<dfn>(yyyy-mm-dd)</dfn>', 'user[birthdayafter]');
print_input_row($vbphrase['birthday_is_before'] . '<dfn>(yyyy-mm-dd)</dfn>', 'user[birthdaybefore]');
print_input_row($vbphrase['posts_are_greater_than'], 'user[postslower]', '', 1, 7);
print_input_row($vbphrase['posts_are_less_than'], 'user[postsupper]', '', 1, 7);
print_input_row($vbphrase['reputation_is_greater_than'], 'user[reputationlower]', '', 1, 7);
print_input_row($vbphrase['reputation_is_less_than'], 'user[reputationupper]', '', 1, 7);
print_input_row($vbphrase['warnings_are_greater_than'], 'user[warningslower]', '', 1, 7);
print_input_row($vbphrase['warnings_are_less_than'], 'user[warningsupper]', '', 1, 7);
print_input_row($vbphrase['infractions_are_greater_than'], 'user[infractionslower]', '', 1, 7);
print_input_row($vbphrase['infractions_are_less_than'], 'user[infractionsupper]', '', 1, 7);
print_input_row($vbphrase['infraction_points_are_greater_than'], 'user[pointslower]', '', 1, 7);
print_input_row($vbphrase['infraction_points_are_less_than'], 'user[pointsupper]', '', 1, 7);
print_input_row($vbphrase['userid_is_greater_than'], 'user[useridlower]', '', 1, 7);
print_input_row($vbphrase['userid_is_less_than'], 'user[useridupper]', '', 1, 7);
print_input_row($vbphrase['registration_ip_address'], 'user[ipaddress]');
print_description_row('<div align="' . $stylevar['right'] . '"><input type="submit" class="button" value=" ' . iif($email, $vbphrase['submit'], $vbphrase['find']) . ' " tabindex="1" /></div>');
$forms = array(0 => $vbphrase['edit_your_details'], 1 => "{$vbphrase['options']}: {$vbphrase['log_in']} / {$vbphrase['privacy']}", 2 => "{$vbphrase['options']}: {$vbphrase['messaging']} / {$vbphrase['notification']}", 3 => "{$vbphrase['options']}: {$vbphrase['thread_viewing']}", 4 => "{$vbphrase['options']}: {$vbphrase['date']} / {$vbphrase['time']}", 5 => "{$vbphrase['options']}: {$vbphrase['other']}");
$currentform = -1;
print_table_header($vbphrase['user_profile_fields']);
$profilefields = $vbulletin->db->query_read("\n\t\tSELECT *\n\t\tFROM " . TABLE_PREFIX . "profilefield AS profilefield\n\t\tLEFT JOIN " . TABLE_PREFIX . "profilefieldcategory AS profilefieldcategory ON\n\t\t\t(profilefield.profilefieldcategoryid = profilefieldcategory.profilefieldcategoryid)\n\t\tORDER BY profilefield.form, profilefieldcategory.displayorder, profilefield.displayorder\n\t");
while ($profilefield = $vbulletin->db->fetch_array($profilefields)) {
if ($profilefield['form'] != $currentform) {
print_description_row(construct_phrase($vbphrase['fields_from_form_x'], $forms["{$profilefield['form']}"]), false, 2, 'optiontitle');
$currentform = $profilefield['form'];
}
$profilefield['def'] = 0;
print_profilefield_row('profile', $profilefield);
}
print_description_row('<div align="' . $stylevar['right'] . '"><input type="submit" class="button" value=" ' . iif($email, $vbphrase['submit'], $vbphrase['find']) . ' " tabindex="1" /></div>');
}
print_yes_no_row($vbphrase['tax'], 'options[tax]', $sub['tax']);
print_select_row($vbphrase['shipping_address'], 'shipping', array(0 => $vbphrase['none'], 2 => $vbphrase['optional'], 4 => $vbphrase['required']), ($sub['options'] & $subobj->_SUBSCRIPTIONOPTIONS['shipping1']) + ($sub['options'] & $subobj->_SUBSCRIPTIONOPTIONS['shipping2']));
print_table_break('', '100%');
print_table_header($vbphrase['admin_override_options']);
foreach ($vbulletin->bf_misc_adminoptions as $field => $value) {
print_yes_no_row($vbphrase['keep_' . $field], 'adminoptions[' . $field . ']', $sub["{$field}"]);
}
?>
</table>
</td><td> </td><td>
<table cellpadding="4" cellspacing="0" border="0" align="center" width="100%" class="tborder">
<?php
// USERGROUP SECTION
print_table_header($vbphrase['usergroup_options']);
print_chooser_row($vbphrase['primary_usergroup'], 'sub[nusergroupid]', 'usergroup', $sub['nusergroupid'], $vbphrase['no_change']);
print_membergroup_row($vbphrase['additional_usergroups'], 'membergroup', 0, $sub);
?>
</table>
</tr>
<?php
print_table_break('', $OUTERTABLEWIDTH);
print_table_header($vbphrase['forums']);
print_description_row($vbphrase['here_you_can_select_which_forums_the_user']);
//require_once(DIR . '/includes/functions_databuild.php');
//cache_forums();
if ($old_sub_masks = @unserialize($sub['forums']) and is_array($old_sub_masks)) {
$forums = array_keys($old_sub_masks);
} else {
$forums = explode(',', $sub['forums']);
}
if (is_array($vbulletin->forumcache)) {
</td><td> </td><td>
<table cellpadding="4" cellspacing="0" border="0" align="center" width="100%" class="tborder">
<?php
} else {
print_table_break('', $INNERTABLEWIDTH);
}
// USERGROUP SECTION
print_table_header($vbphrase['usergroup_options']);
print_chooser_row($vbphrase['primary_usergroup'], 'user[usergroupid]', 'usergroup', $user['usergroupid']);
if (!empty($user['membergroupids'])) {
$usergroupids = $user['usergroupid'] . (!empty($user['membergroupids']) ? ',' . $user['membergroupids'] : '');
print_chooser_row($vbphrase['display_usergroup'], 'user[displaygroupid]', 'usergroup', iif($user['displaygroupid'] == 0, -1, $user['displaygroupid']), $vbphrase['default'], 0, "WHERE usergroupid IN ({$usergroupids})");
}
$tempgroup = $user['usergroupid'];
$user['usergroupid'] = 0;
print_membergroup_row($vbphrase['additional_usergroups'], 'user[membergroupids]', 0, $user);
print_table_break('', $INNERTABLEWIDTH);
$user['usergroupid'] = $tempgroup;
if ($banreason = $db->query_first("SELECT * FROM " . TABLE_PREFIX . "userban WHERE userid = " . intval($user['userid']))) {
print_table_header($vbphrase['banning'], 3);
$row = array($vbphrase['ban_reason'], !empty($banreason['reason']) ? $banreason['reason'] : $vbphrase['n_a'], construct_link_code($vbphrase['lift_ban'], "../" . $vbulletin->config['Misc']['modcpdir'] . "/banning.php?" . $vbulletin->session->vars['sessionurl'] . "do=liftban&userid=" . $user['userid']));
print_cells_row($row);
print_table_break('', $INNERTABLEWIDTH);
}
if (!empty($subobj->subscriptioncache)) {
$subscribed = array();
// fetch all active subscriptions the user is subscribed too
$subs = $db->query_read("\n\t\t\tSELECT status, regdate, expirydate, subscriptionlogid, subscription.subscriptionid\n\t\t\tFROM " . TABLE_PREFIX . "subscriptionlog AS subscriptionlog\n\t\t\tINNER JOIN " . TABLE_PREFIX . "subscription AS subscription USING (subscriptionid)\n\t\t\tWHERE userid = " . intval($user['userid']) . "\n\t\t\tORDER BY status DESC, regdate\n\t\t\t");
if ($db->num_rows($subs)) {
print_table_header($vbphrase['paid_subscriptions']);
while ($sub = $db->fetch_array($subs)) {
// Usergroups (the biggie!)
if ($vbulletin->GPC['step'] == 21) {
// first of all let's just check that we know what usergroups are 'banned'
$vbulletin->input->clean_gpc('p', 'bangroup', TYPE_ARRAY);
if (empty($vbulletin->GPC['bangroup'])) {
$bangroup = array();
$groups = $db->query_read("SELECT usergroupid, title FROM usergroup WHERE title LIKE('%banned%')");
while ($group = $db->fetch_array($groups)) {
$bangroup[] = $group['usergroupid'];
}
print_form_header('upgrade_300b3', '');
construct_hidden_code('step', 21);
construct_hidden_code('bangroup[]', 0);
print_table_header($upgrade_phrases['upgrade_300b3.php']['select_banned_groups']);
print_description_row("<div align=\"center\" style=\"font-size:10pt\"><br /> \n\t\t\t{$upgrade_phrases['upgrade_300b3.php']['explain_banned_groups']}\n\t\t\t<br /> </div>");
print_membergroup_row("<b>{$upgrade_phrases['upgrade_300b3.php']['user_groups']}</b>", 'bangroup', 2, array('usergroupid' => 0, 'membergroupids' => implode(',', $bangroup)));
print_submit_row($vbphrase['proceed'], $vbphrase['reset']);
exit;
}
// if we got this far the user has filled in the form above
$query[] = "ALTER TABLE usergroup\n\t\tCHANGE title title CHAR(100) NOT NULL DEFAULT '',\n\t\tCHANGE usertitle usertitle CHAR(100) NOT NULL DEFAULT '',\n\t\tCHANGE maxbuddypm pmsendmax SMALLINT UNSIGNED NOT NULL DEFAULT '5',\n\t\tCHANGE showgroup genericoptions INT UNSIGNED NOT NULL DEFAULT '0'\n\t";
$explain[] = sprintf($vbphrase['alter_table_step_x'], 'usergroup', 1, 9);
$query[] = "ALTER TABLE usergroup\n\t\tADD ispublicgroup SMALLINT UNSIGNED NOT NULL DEFAULT '0',\n\t\tADD canoverride SMALLINT UNSIGNED NOT NULL DEFAULT '0'\n\t";
$explain[] = sprintf($vbphrase['alter_table_step_x'], 'usergroup', 2, 9);
$query[] = "ALTER TABLE usergroup\n\t\tADD description CHAR(250) NOT NULL DEFAULT '',\n\t\tADD opentag CHAR(100) NOT NULL DEFAULT '',\n\t\tADD closetag CHAR(100) NOT NULL DEFAULT ''\n\t";
$explain[] = sprintf($vbphrase['alter_table_step_x'], 'usergroup', 3, 9);
$query[] = "ALTER TABLE usergroup\n\t\tADD forumpermissions INT UNSIGNED NOT NULL DEFAULT '0',\n\t\tADD pmpermissions INT UNSIGNED NOT NULL DEFAULT '0',\n\t\tADD calendarpermissions INT UNSIGNED NOT NULL DEFAULT '0'\n\t";
$explain[] = sprintf($vbphrase['alter_table_step_x'], 'usergroup', 4, 9);
$query[] = "ALTER TABLE usergroup\n\t\tADD wolpermissions INT UNSIGNED NOT NULL DEFAULT '0',\n\t\tADD adminpermissions INT UNSIGNED NOT NULL DEFAULT '0',\n\t\tADD genericpermissions INT UNSIGNED NOT NULL DEFAULT '0',\n\t\tADD signaturepermissions INT UNSIGNED NOT NULL DEFAULT '0'\n\t";
$explain[] = sprintf($vbphrase['alter_table_step_x'], 'usergroup', 5, 9);
$query[] = "ALTER TABLE usergroup\n\t\tADD passwordexpires SMALLINT UNSIGNED NOT NULL DEFAULT '0',\n\t\tADD passwordhistory SMALLINT UNSIGNED NOT NULL DEFAULT '0'\n\t";
