Home

Fix for attach files to nodes

October 27, 2008 - 3:11am — Anonymous
  1. $fid = db_result(db_query("SELECT MAX(f.fid) FROM {files} f"));
  2.                 $new_fid = $fid +1;
  3.                 $nid = db_result(db_query("SELECT MAX(n.nid) FROM {node} n"));
  4.                
  5.                
  6.                 $fileName = $newnode->title;
  7.                 $filePath = $newnode->destinationURL;
  8.                 $filemime = 'video/mp4';
  9.                 $filesize = '999999';
  10.                
  11. db_query("INSERT INTO {files} (fid, nid, filename, filepath, filemime, filesize ) VALUES (%d, %d, '%s', '%s', '%s', %d)",
  12.     $new_fid, $nid, $fileName, $filePath, $filemime, $filesize);
  13. echo $nid;

Submit Fix

Any tags you'd like to associate with your code, delimitered by commas (example: Views, CCK, Module, etc).
Select the syntax highlighting mode to use.