[Solved] Add Custom Profile Fields to New User Moderation

[HyphyMike]

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.

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&amp;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&amp;depth=2&amp;ipaddress=$user[ipaddress]&amp;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']);
    }
}