How would I go about getting the info from custom profile fields. I dont believe they are global variables and I know they are in a different table than the 'users' table thats being displayed on this page. They are in userfields. How would I go about making a query for these 2 Custom Profile Fields I need on this /admincp/user.php?do=moderate page.
Code:
print_form_header('user', 'domoderate'); print_table_header($vbphrase['users_awaiting_moderation'], 4);
print_cells_row(array(
$vbphrase['username'],
$vbphrase['email'],
$vbphrase['ip_address'],
"Main Server", "MS Username",
"<input type=\"button\" class=\"button\" value=\"" . $vbphrase['accept_all'] . "\" onclick=\"js_check_radio(1)\" />
<input type=\"button\" class=\"button\" value=\"" . $vbphrase['delete_all'] . "\" onclick=\"js_check_radio(-1)\" />
<input type=\"button\" class=\"button\" value=\"" . $vbphrase['ignore_all'] . "\" onclick=\"js_check_radio(0)\" />"
), 0, 'thead', -3);
while ($user = $db->fetch_array($users))
{
$cell = array();
$cell[] = "<a href=\"user.php?" . $vbulletin->session->vars['sessionurl'] . "do=edit&u=$user[userid]\" target=\"_blank\"><b>$user[username]</b></a>";
$cell[] = "<a href=\"mailto:$user[email]\">$user[email]</a>";
$cell[] = "<a href=\"usertools.php?" . $vbulletin->session->vars['sessionurl'] . "do=doips&depth=2&ipaddress=$user[ipaddress]&hash=" . CP_SESSIONHASH . "\" target=\"_blank\">$user[ipaddress]</a>";
$cell[] = "$profilefield[field5]";
$cell[] = "$profilefield[field6]";
$cell[] = "
<label for=\"v_$user[userid]\"><input type=\"radio\" name=\"validate[$user[userid]]\" value=\"1\" id=\"v_$user[userid]\" tabindex=\"1\" />$vbphrase[accept]</label>
<label for=\"d_$user[userid]\"><input type=\"radio\" name=\"validate[$user[userid]]\" value=\"-1\" id=\"d_$user[userid]\" tabindex=\"1\" />$vbphrase[delete]</label>
<label for=\"i_$user[userid]\"><input type=\"radio\" name=\"validate[$user[userid]]\" value=\"0\" id=\"i_$user[userid]\" tabindex=\"1\" checked=\"checked\" />$vbphrase[ignore]</label>
";
print_cells_row($cell, 0, '', -4);
}
require_once(DIR . '/includes/functions_misc.php');
$template = fetch_phrase('validated', 'emailbody', 'email_');
print_table_break();
print_table_header($vbphrase['email_options']);
print_yes_no_row($vbphrase['send_email_to_accepted_users'], 'send_validated', 1);
print_yes_no_row($vbphrase['send_email_to_deleted_users'], 'send_deleted', 1);
print_description_row($vbphrase['email_will_be_sent_in_user_specified_language']);
print_table_break();
print_submit_row($vbphrase['continue']);
}
}