List of Users

Create a page using the "PHP code" input format. Then use something like this (it's just a sample to get you started)

global $user;

if (!$user->uid || !in_array('role name', $user->roles)) {
  print 'Access denied';
}
else {
  $r = db_query('SELECT name FROM {users} WHERE status != 0 ORDER BY name');
  print '<ul>';
  while ($row = db_fetch_object($r)) {
    print '<li>'. $row->name .'</li>';
  }
  print '</ul>';
}

how could i modify this code to just display the current users avatar?

I picked up the code here some days ago and struggled with the sorting issue too. Then I saw that the views module can sort on profile.module fields, so I checked the code. And finally with some help from gnari at #mysql@irc.freenode.net I managed to get it to work!

Personally I needed an 'address book'. A list of users searchable on fields which were added by profile.module (then still sortable). So the code does just that :)

I didn't turn it into a module, because I don't have the time. Should someone be able to pick it up from here please do! I tried to make the code as flexible as I could, so I believe that turning it into a module shouldn't be that hard.

To 'configure' the script, just change the arrays $columns and $search_buttons at the top to specify what columns you want to show and be able to search on.
What's not (yet - hint hint ;)) configurable is the restriction to the search criteria I have added to force it to be no less than 2 character; and the WHERE clause that excludes the first 3 users + the blocked onces from the search.

$columns = array(
  array('data' => 'Titel', 'field' => 'profile_algemeen_titel'),
  array('data' => 'Voorletters', 'field' => 'profile_algemeen_voorletters'),
  array('data' => 'Achternaam', 'field' => 'profile_algemeen_achternaam', 'sort' => 'asc'),
  array('data' => 'Plaatsnaam', 'field' => 'profile_prive_plaats'),
  array('data' => 'Bekijk profiel')
);
$search_buttons = array(
  array('name' => 'naam', 'field' => 'profile_algemeen_achternaam'),
  array('name' => 'plaats', 'field' => 'profile_prive_plaats')
);


$addressbook_search = (!isset($_POST['addressbook_search']['reset']) ? $_REQUEST['addressbook_search'] : '');

print '<form method="post" action="?q=' . drupal_get_path_alias($_GET['q']) . ($_GET['sort'] ? '&sort=' . $_GET['sort'] : '') . ($_GET['order'] ? '&order=' . $_GET['order'] : '') . '" id="addressbook_form"><fieldset>';
print '<input type="text" name="addressbook_search[criteria]" id="addressbook_search[criteria]" value="' . ($addressbook_search['criteria'] ? $addressbook_search['criteria'] : t('Enter value')) . '" onclick="if(this.defaultValue == this.value){this.value = \'\';}" onblur="if(this.value.replace(/^\s+|\s+$/g, \'\') == \'\'){this.value = this.defaultValue}" />';
print '<span id="addressbook_form_delimiter">&raquo;</span>';

foreach ($search_buttons as $button) {
  print ' <input type="submit" value="' . $button['name'] . '" name="addressbook_search[column][' . $button['field'] . ']" class="addressbook_search_column ' . $button['field'] . '" />';
}
if ($addressbook_search) {
  print '<input type="image" title="' . t('Show all users') . '" src="' . $imagePath . '/addressbook_reset.gif" name="addressbook_search[reset]" id="addressbook_search_reset" />';
}

print '</fieldset></form>';

if (!$GLOBALS['user']->uid || !in_array('authenticated user', $GLOBALS['user']->roles)) {
  print t('Access denied');
}
else {

  $sql_columns = $sql_joins = '';
  foreach ($columns as $column) {
    if ($column['field']) {
      $sql_columns .= ', ' . $column['field'] . '.value AS ' . $column['field'];
      $sql_joins .= ' LEFT JOIN {profile_values} ' . $column['field'] . ' ON ' . $column['field'] . '.fid = (SELECT fid FROM {profile_fields} WHERE name = "' . $column['field'] . '") AND users.uid = ' . $column['field'] . '.uid';
    }
  }
  $sql = 'SELECT users.uid' . $sql_columns . ' FROM {users}' . $sql_joins . ' WHERE users.uid > 4 AND status = 1';

  if ($addressbook_search['criteria']) {
    if (strlen($addressbook_search['criteria']) < 3) {
      print t('Please enter at least 2 characters.');
    }
    else {
      foreach ($addressbook_search['column'] as $column => $value) {
        $sql .= ' AND ' . $column . '.value LIKE "%s%%"';
      }

      $sql .= tablesort_sql($columns);
      $result = pager_query($sql, 50, 0, NULL, $addressbook_search['criteria']);
    }
  }
  else
  {
    $sql .= tablesort_sql($columns);
    $result = pager_query($sql, 50);
  }

  if ($result) {
    $rows = array();
    while ($account = db_fetch_array($result)) {

      unset($account['uid']);
      $account[] = '<a href="?q=user/' . $account->uid . '">profile</a>';
      $rows[] = $account;
    }

    if (count($rows) > 0) {
      print theme('table', $columns, $rows, array('id' => 'addressbook_table'));
      print theme('pager', NULL, 50);
    }
    else {
      print t('No users were found.');
    }
  }

}

Sorry about the inline javascript, but that's also because of the lack of time...

Several classnames and IDs are used, so the script is themeable. Some example CSS :

#addressbook_form {
  position: relative;
  margin-bottom: 26px;
}

.addressbook_search_column {
  margin-left: 6px;
}

#addressbook_search_reset {
  position: absolute;
  right: 12px;
  top: 13px;
}

#addressbook_table
{
}

#addressbook_table tr.odd
{
}
#addressbook_table tr.even
{
  background-color: #E5E5E5;
}

#addressbook_table td
{
  padding-right: 16px;
}

.pager
{
  margin-top: 16px;
}

The icon used for the reset button can be found at http://www.saulmade.nl/forum/addressbook_reset.png or as a gif blended on a white bg http://www.saulmade.nl/forum/addressbook_reset.gif .

Paul