Add user field data to display on admin page

[shershen08]

On admin page "Users awaiting for moderation" table contains fields -
name, email, ip and buttons column

Is there any module to display additional fields to display in this table in AdminCP?

My question on vbulletin.com/forum (http://www.vbulletin.com/forum/forum/vbulletin-4/vbulletin-4-questions-problems-and-troubleshooting/427284-add-user-field-data-to-display-on-admin-page#post3944044)

[kh99]

In file admincp/user.php, around line 1711 is this code:

// ###################### Start moderate + coppa #######################
if ($_REQUEST['do'] == 'moderate')
{

$users = $db->query_read("
SELECT userid, username, email, ipaddress
FROM " . TABLE_PREFIX . "user
WHERE usergroupid = 4
ORDER BY username
");


You would need to modify that query to get the fields you want to display, then modify the code below that to add more columns to the table and display the fields from the query.

[shershen08]

user fields i need to display is a additional field - created via admin pannel
in what table are they stored?