Sort attatchments by name (alphabetically)

If you are interested in doing the same for the Drupal 4.6 ver of Attachment module, look for the db_query on line 323 and and the Order BY query like this:

$result = db_query("SELECT aid, title, description, fid, filename, size, hidden FROM {attachment} WHERE nid = %d ORDER BY title", $node->nid);

I shouldn't do this, but I'm posting this code without testing it. Let me know if you get any errors. ;o)

// All of the following code should go into your template.php file
// in your theme folder, assuming you are using phptemplate as your
// theme engine.

// This is our comparison function

function _upload_attachments_compare($a, $b) {
  return ($a > $b) ? 1 : (($a < $b) ? -1 : 0);
}

// This is the theme function that we are overriding.  We are using
// the override technique discussed here: http://drupal.org/node/11811

function phptemplate_upload_attachments($files) {
 
  // First, we need to build an array where the filename is the key,
  // and the value is the file id.
  // This is a temporary array for use in the uksort() function.
  // usort() cannot be used, since it does not retain the keys.
  
  $temp_array = array();
  
  foreach ($files as $key => $val) {
    $val = (object)$val;
    $temp_array[$val->filename] = $key;
  }
  
  $temp_array = uksort($temp_array, '_upload_attachments_compare');
  
  // now we use the sorted array to build a new file array
  
  $new_file_list = array();
  
  foreach ($temp_array as $val) {
    $new_file_list[$val] = $files[$val];
  }
  
  $files = $new_file_list;
  
  // continuing happily...
  
  $header = array(t('Attachment'), t('Size'));
  $rows = array();
  
  foreach ($files as $file) {
    $file = (object)$file;
    if ($file->list && !$file->remove) {
      // Generate valid URL for both existing attachments and preview of new attachments (these have 'upload' in fid)
      $href = file_create_url((strpos($file->fid, 'upload') === FALSE ? $file->filepath : file_create_filename($file->filename, file_create_path())));
      $text = $file->description ? $file->description : $file->filename;
      $rows[] = array(l($text, $href), format_size($file->filesize));
    }
  }
  if (count($rows)) {
    return theme('table', $header, $rows, array('id' => 'attachments'));
  }
} 

This method should work for 4.7 and 5.x alike.

Usual warnings apply: This is untested code, so syntax and/or logical errors may exist. Backup your files first (you're doing that anyway, right?). Not guaranteed against data loss. No pets were harmed in the making of this snippet.

- Corey