[development] Attachment Indexing module.

[Darrel O'Pry]

On Thu, 2006-03-09 at 18:30 +0000, Adam Cooper wrote:
> Hello all,
> 

> So far I've created all the back end administration interface and I am
> now moving on to the actual work part but I am having problems with
> the file revisioning system. I need some clarification of the file and
> file_revisions table so I can write some more specific SQL.
> 
> I would only like to index attachments if they are listed on the node
> but I have no idea how the 'list' column of file_revisions controls
> this behaviour. It seems that if it is a '0' then it isn't listed, but
> if it is anything else, it is. Is this correct?
> 
You are correct, and the join for a node is something like
SELECT * FROM {files} f INNER JOIN {file_revisions} r ON f.fid = r.fid WHERE r.vid = %d and r.list != 0

You could always just use 
upload_load($node) 
foreach ($node->files as $file) { 
  if ($file->list) { 
    //do your thing
  }
}




> Is there any documentation on the structure of the DB? as I cannot
> find any and it would help.
 



> Thanks
> Adam
> 
> P.S. If this is the wrong list then apologies. I could not find a
> module development list.
> 
>