Community members

t('Username'), 'field' => 'u.name', 'sort' => 'asc'), array('data' => t('Display name'), 'field' => 'u.name'), //array('data' => t('Photo'), 'field' => 'u.photo'), //array('data' => t('Membership'), 'field' => 'u.membership'), //array('data' => t('Zip code'), 'field' => 'u.zipcode'), //array('data' => t('Age'), 'field' => 'u.age'), //array('data' => t('Gender'), 'field' => 'u.gender'), //array('data' => t('Profession'), 'field' => 'u.profession'), array('data' => t('Last access'), 'field' => 'u.access', 'sort' => 'desc') ); $sql = 'SELECT u.uid, u.name, u.status, u.created, u.access FROM {users} u WHERE uid != 0'; $sql .= tablesort_sql($header); $result = pager_query($sql, 50); $status = array(t('blocked'), t('active')); while ($account = db_fetch_object($result)) { $account = user_load(array('uid' => $account->uid)); $rows[] = array(theme('username', $account), // $account->picture, //$account->profile_membership, //$account->profile_zipcode, //$account->profile_age, //$account->profile_gender, //$account->profile_profession, $account->access ? t('%time ago', array('%time' => format_interval(time() - $account->access))) : t('never')); } $output = theme('table', $header, $rows); $output .= theme('pager', NULL, 50, 0); print ($output); ?>