Text Formatted Code
$LANG28[37], 'field' => $_TABLES['users'] . '.uid', 'sort' => true), array('text' => $LANG28[3], 'field' => 'username', 'sort' => true), array('text' => $LANG28[4], 'field' => 'fullname', 'sort' => true), array('text' => 'Member Since', 'field' => 'regdate', 'sort' => true), array('text' => 'Location', 'field' => 'location', 'sort' => true), array('text' => 'About', 'field' => 'about', 'sort' => false) ); $defsort_arr = array('field' => $_TABLES['users'] . '.uid', 'direction' => 'ASC'); $menu_arr = array (); if ($_CONF['user_login_method']['openid'] || $_CONF['user_login_method']['3rdparty']) { $header_arr[] = array('text' => $LANG04[121], 'field' => 'remoteservice', 'sort' => true); } $retval .= COM_startBlock('User Directory', '', COM_getBlockTemplate('_admin_block', 'header')); $retval .= ADMIN_createMenu( $menu_arr, 'Click on the username to view the the user\'s full profile.', $_CONF['layout_url'] . '/images/icons/user.' . $_IMAGE_TYPE ); $text_arr = array( 'has_extras' => true, 'form_url' => $_CONF['site_url'] . '/user-directory.php', 'help_url' => '' ); $join_userinfo = ''; $select_userinfo = ''; if ($_CONF['lastlogin']) { $join_userinfo .= "LEFT JOIN {$_TABLES['userinfo']} ON {$_TABLES['users']}.uid={$_TABLES['userinfo']}.uid "; $select_userinfo .= ",lastlogin, about, location"; } if ($_CONF['user_login_method']['openid'] || $_CONF['user_login_method']['3rdparty']) { $select_userinfo .= ',remoteservice'; } $sql = "SELECT {$_TABLES['users']}.uid,username,fullname,email,photo,status,regdate$select_userinfo " . "FROM {$_TABLES['users']} $join_userinfo WHERE 1=1"; $query_arr = array('table' => 'users', 'sql' => $sql, 'query_fields' => array('username', 'email', 'fullname', 'regdate'), 'default_filter' => "AND {$_TABLES['users']}.uid > 1"); $retval .= ADMIN_list('user', 'ADMIN_getListField_users', $header_arr, $text_arr, $query_arr, $defsort_arr); $retval .= COM_endBlock(COM_getBlockTemplate('_admin_block', 'footer')); return $retval; } }