Get array of files attached to node

Create an action that allows one to flush the node's pics on update. Comes in handy when you use node data in the pic; thus when the node changes, the pic needs to change as well.

First Step: How do I get an array of all pics that are connected to a node?
CCK?

function get_files_via_node($nid)
...
return array_of_files['fid'] => ['filename']['filepath']['type'];

This gives an array of all files that are connected to that node

/**
 * Get all filefield files connected to a node id.
 * @param $nid
 *   The Node ID.
 * 
 * Returns array()
 *   ['fid'] = file id
 *   ['type'] = type of cck field
 *   ['path'] = path to file
 *
 * Notes
 *   Does not return imagecache child files, only the base file.
 */
function get_filepaths_via_nid($nid)
{
  $fids = array();
  $filepaths = array();
  foreach (content_fields() as $field) {
    // If Field is an Image (imagefield.module) or filefield then
    if ($field['type'] == 'image' || $field['type'] == 'filefield') {
      $db_info = content_database_info($field);
      // Get Content Type DB name - FROM statement
      $tablename = $db_info['table'];
      //Get File ID DB Column Name - SELECT statement
      $fid_column = $db_info['columns']['fid']['column'];
      
      //get file id's
      $sql = "SELECT ".$fid_column." FROM ".$tablename." WHERE nid = '%s'";
      $result = db_query($sql, array($nid));
      while ($fileid_row = db_fetch_array($result)) {
        $fids[] = array('fid' => $fileid_row[$fid_column], 'type' => $field['type']);
      }
    }
  }
  foreach ($fids as $fid) {
    //get paths for file id
    $sql = "SELECT filepath FROM files WHERE fid = '%s'";
    $result = db_query($sql, array($fid['fid']));
    while ($filepath_row = db_fetch_array($result)) {
      $filepaths[] = array('fid' => $fid['fid'], 'type' => $fid['type'], 'path' => $filepath_row['filepath']);
    }
  }
  return $filepaths;
}

EDIT: give an hierarchical array to include type & fid

Array
(
    [0] => Array
        (
            [fid] => 138
            [type] => image
            [path] => sites/default/files/...jpg
        )

    [1] => Array
        (
            [fid] => 357
            [type] => image
            [path] => sites/default/files/...jpg
        )

    [2] => Array
        (
            [fid] => 356
            [type] => image
            [path] => sites/default/files/...jpg
        )
)

Being able to grab all the files that are attached to a node is quite handy.
http://drupal.org/node/374202

I thought that this code belongs in FileField.

hmmm new site isn't liking attachments right now

--- filefield\filefield-old.module	Fri Feb  6 02:56:30 2009
+++ filefield\filefield.module	Thu Feb 19 02:25:31 2009
@@ -714,3 +714,50 @@
 function filefield_validate_is_image_help($arguments = null) {
   return t('Must be a JPEG, PNG or GIF image');
 }
+
+<?php
+/**
+* Get all filefield files connected to a node id.
+* @param $nid
+*   The Node ID.
+*
+* Returns array()
+*   ['fid'] = file id
+*   ['type'] = type of cck field
+*   ['path'] = path to file
+*
+* Notes
+*   Does not return imagecache child files, only the base file.
+*/
+function filefield_get_paths_via_nid($nid)
+{
+  $fids = array();
+  $filepaths = array();
+  foreach (content_fields() as $field) {
+    // If Field is an Image (imagefield.module) or filefield then
+    if ($field['type'] == 'image' || $field['type'] == 'filefield') {
+      $db_info = content_database_info($field);
+      // Get Content Type DB name - FROM statement
+      $tablename = $db_info['table'];
+      //Get File ID DB Column Name - SELECT statement
+      $fid_column = $db_info['columns']['fid']['column'];
+     
+      //get file id's
+      $sql = "SELECT ".$fid_column." FROM ".$tablename." WHERE nid = '%s'";
+      $result = db_query($sql, array($nid));
+      while ($fileid_row = db_fetch_array($result)) {
+        $fids[] = array('fid' => $fileid_row[$fid_column], 'type' => $field['type']);
+      }
+    }
+  }
+  foreach ($fids as $fid) {
+    //get paths for file id
+    $sql = "SELECT filepath FROM files WHERE fid = '%s'";
+    $result = db_query($sql, array($fid['fid']));
+    while ($filepath_row = db_fetch_array($result)) {
+      $filepaths[] = array('fid' => $fid['fid'], 'type' => $fid['type'], 'path' => $filepath_row['filepath']);
+    }
+  }
+  return $filepaths;
+}
+?>
\ No newline at end of file

or editing posts...

--- filefield\filefield-old.module	Fri Feb  6 02:56:30 2009
+++ filefield\filefield.module	Thu Feb 19 02:34:51 2009
@@ -714,3 +714,48 @@
 function filefield_validate_is_image_help($arguments = null) {
   return t('Must be a JPEG, PNG or GIF image');
 }
+
+/**
+* Get all filefield files connected to a node id.
+* @param $nid
+*   The Node ID.
+*
+* Returns array()
+*   ['fid'] = file id
+*   ['type'] = type of cck field
+*   ['path'] = path to file
+*
+* Notes
+*   Does not return imagecache child files, only the base file.
+*/
+function filefield_get_paths_via_nid($nid)
+{
+  $fids = array();
+  $filepaths = array();
+  foreach (content_fields() as $field) {
+    // If Field is an Image (imagefield.module) or filefield then
+    if ($field['type'] == 'image' || $field['type'] == 'filefield') {
+      $db_info = content_database_info($field);
+      // Get Content Type DB name - FROM statement
+      $tablename = $db_info['table'];
+      //Get File ID DB Column Name - SELECT statement
+      $fid_column = $db_info['columns']['fid']['column'];
+     
+      //get file id's
+      $sql = "SELECT ".$fid_column." FROM ".$tablename." WHERE nid = '%s'";
+      $result = db_query($sql, array($nid));
+      while ($fileid_row = db_fetch_array($result)) {
+        $fids[] = array('fid' => $fileid_row[$fid_column], 'type' => $field['type']);
+      }
+    }
+  }
+  foreach ($fids as $fid) {
+    //get paths for file id
+    $sql = "SELECT filepath FROM files WHERE fid = '%s'";
+    $result = db_query($sql, array($fid['fid']));
+    while ($filepath_row = db_fetch_array($result)) {
+      $filepaths[] = array('fid' => $fid['fid'], 'type' => $fid['type'], 'path' => $filepath_row['filepath']);
+    }
+  }
+  return $filepaths;
+}
\ No newline at end of file

OK cool, thanks for the input. Sorry for the ugly above, this was posted hrs after the d.o 6.x upgrade. Might be a week or 2 with my schedule, will do the join optimization last most likely.

- Nuke 2nd loop, replace with JOIN in first loop.
- SELECT * FROM files would grab [fid, uid, filename, filepath, filemime, filesize, status, timestamp] throw that into the sub-array.
- Optional $field variable in order to grab an individual field.
- Renaming the function to field_file_node_files() sounds like a good plan.

Anything else?

working on the join. one of the added benefits of the join is I can include nid & vid in the array; which is helpful when the nid is not passed. also forgot the filemime. Do you see anyway to simplify the //get cck info code block; I have some repeating code in there still.

here's my take on your patch. for anyone else following this thread, call this function like the last one via filefield_get_node_files(node_load($nid));