User list

2. $rid = 3; ?>

Administrators

t('Username'), 'field' => 'u.name', 'sort' => 'asc'), array('data' => t('Status'), 'field' => 'u.status'), array('data' => t('Member for'), 'field' => 'u.created') ); $sql = "SELECT u.uid, u.name, u.status, u.created FROM {users} u INNER JOIN {users_roles} ur ON u.uid=ur.uid WHERE ur.rid = $rid"; $sql .= tablesort_sql($header); $result = pager_query($sql, 50); $status = array(t('blocked'), t('active')); while ($account = db_fetch_object($result)) { $rows[] = array(theme('username', $account), $status[$account->status], format_interval(time() - $account->created); } $output = theme('table', $header, $rows); $output .= theme('pager', NULL, 50, 0); print ($output); ?> 2. $rid = 5; ?>

Editors

t('Username'), 'field' => 'u.name', 'sort' => 'asc'), array('data' => t('Status'), 'field' => 'u.status'), array('data' => t('Member for'), 'field' => 'u.created') ); $sql = "SELECT u.uid, u.name, u.status, u.created FROM {users} u INNER JOIN {users_roles} ur ON u.uid=ur.uid WHERE ur.rid = $rid"; $sql .= tablesort_sql($header); $result = pager_query($sql, 50); $status = array(t('blocked'), t('active')); while ($account = db_fetch_object($result)) { $rows[] = array(theme('username', $account), $status[$account->status], format_interval(time() - $account->created) ; } $output = theme('table', $header, $rows); $output .= theme('pager', NULL, 50, 0); print ($output); ?> 2. $rid = 4; ?>

Trusted authors

t('Username'), 'field' => 'u.name', 'sort' => 'asc'), array('data' => t('Status'), 'field' => 'u.status'), array('data' => t('Member for'), 'field' => 'u.created') ); $sql = "SELECT u.uid, u.name, u.status, u.created FROM {users} u INNER JOIN {users_roles} ur ON u.uid=ur.uid WHERE ur.rid = $rid"; $sql .= tablesort_sql($header); $result = pager_query($sql, 50); $status = array(t('blocked'), t('active')); while ($account = db_fetch_object($result)) { $rows[] = array(theme('username', $account), $status[$account->status], format_interval(time() - $account->created); } $output = theme('table', $header, $rows); $output .= theme('pager', NULL, 50, 0); print ($output); ?>
 

Community Guidelines

By using this site, you agree to our community guidelines. Inappropriate or disruptive behavior will result in moderation or eviction.

 

Content license

By contributing to OrangePolitics, you agree to license your contributions under a Creative Commons Attribution-NoDerivs 3.0 United States License.

Creative Commons License

 
Zircon - This is a contributing Drupal Theme
Design by WeebPal.