Untitled

<?php

if (! $db = mysql_connect('localhost','user','pass')) { exit( "DB connection failed\n"); }
if (! mysql_select_db('database')) { exit( "Failed to select DB\n"); }
if (! $fid = mysql_result(mysql_query('SELECT id FROM sequences WHERE name=\'files_fid\''),0)) { exit("Error getting sequence\n"); }
if (! $result = mysql_query('SELECT fi.nid as nid, fs.filename as filename, fs.cachename as filepath, fs.mimetype as filemime, fs.size as filesize, n.vid as vid FROM filestore2 as fi, fscache as fs, node as n WHERE fi.fsid=fs.fsid AND fi.nid=n.nid')) { exit("Error getting files data\n"); }
while ($row = mysql_fetch_assoc($result)) {
  $row['filepath'] = 'files/fscache/'.substr($row['filepath'],0,2).'/'.substr($row['filepath'],2,2).'/'.$row['filepath'];
  if (! mysql_query(sprintf("INSERT INTO files (fid, nid, filename, filepath, filemime, filesize) VALUES (%d, %d, '%s', '%s', '%s', %d)", ++$fid, $row['nid'], $row['filename'], $row['filepath'], $row['filemime'], $row['filesize']))) { print "Error writing {$row['filename']} as fid $fid\n"; } 
  if (! mysql_query(sprintf("INSERT INTO file_revisions (fid, vid, list) VALUES (%d, %d, 1)", $fid, $row['vid']))) { print "Error writing revision $fid"; } else { print "{$row['filename']} as $fid, "; }
}
if (! mysql_query("UPDATE sequences SET id=$fid WHERE name='files_fid'")) { exit( "Error setting fid sequence as $fid\n"); }
print "Done\n";

?>