vidfile, strlen($base)); $fid = db_next_id('files_fid'); $filepath = file_directory_path() .'/'. $filename; if (file_exists($filepath)) { $size = filesize($filepath); } else { $size = 0; echo "- Couldn't find $filepath!
\n"; } db_query("INSERT INTO {files} (fid, nid, filename, filepath, filemime, filesize) VALUES (%d, %d, '%s', '%s', '%s', %d)", $fid, $row->nid, basename($filename), $filepath, getmime(substr($filename, -3)), $size); } echo "- files table populated.
\n"; // Set up videos we have all needed data for already. // Bdragon note: I changed description to match the node title. Is this sane? // Bdragon note: There were only 4 rows in the result? $sql = "INSERT INTO {". $table ."} (vid, nid, $fid, $description, $list) ( SELECT n.vid, n.nid, f.fid, n.title, '1' FROM {video} v INNER JOIN {node} n ON v.nid = n.nid INNER JOIN {files} f ON n.nid = f.nid WHERE n.type = 'video' AND v.vidfile LIKE '%%%s%%' GROUP BY n.vid)"; if (db_query($sql, $base)) { echo "- $table populated.
\n"; } // Change the content type from 'video' to the configured type per Prerequisites. $sql = "UPDATE {node} SET type = '%s' WHERE type = 'video' AND v.vidfile LIKE '%%%s%%'"; db_query($sql, $type_name, $base); // Clear CCK cache. $sql = "DELETE FROM {cache_content}"; db_query($sql);