list($id) = mysql_fetch_row(mysql_query("SELECT id FROM core_crm_filesystem_folders WHERE uid='".$record_id."' AND pesistant=1 AND folder_name='Recycle Bin'")); if($id<1) { mysql_query("INSERT INTO `core_crm_filesystem_folders` (`uid` , `parent_folder_id` , `folder_name` , `folder_created` , `pesistant` ) VALUES ('".$record_id."', '0', 'Recycle Bin', '".time()."', '1')"); } list($id) = mysql_fetch_row(mysql_query("SELECT id FROM core_crm_filesystem_folders WHERE uid='".$record_id."' AND pesistant=1 AND folder_name='Notes'")); if($id<1) { mysql_query("INSERT INTO `core_crm_filesystem_folders` (`uid` , `parent_folder_id` , `folder_name` , `folder_created` , `pesistant` ) VALUES ('".$record_id."', '0', 'Notes', '".time()."', '1')"); $cvFolderId = mysql_insert_id(); } else { $cvFolderId = $id; } $fhandle = fopen("../cvs/new_names/".$file, "r"); $contents = fread($fhandle, filesize("../cvs/new_names/".$file)); fclose($fhandle); $chunks = floor(strlen($contents)/512000); $start = 0; for ($kk=0; $kk < $chunks; $kk++){ $data_chunks[] = substr($contents, $start, 512000); $start += 512000; } $data_chunks[] = substr($contents, $start); mysql_query("INSERT INTO core_crm_filesystem_headers (filename,filetype,filesize,filedate,folder_id,uid) VALUES ('".$fileName."','".up_mime_content_type($file)."','".filesize("../cvs/new_names/".$file)."',".time().",".$cvFolderId.",".$record_id.")"); $fid = mysql_insert_id(); foreach($data_chunks as $key=>$val) { mysql_query("INSERT INTO core_crm_filesystem_blocks (`header_id`, `block_id`, `block`) VALUES (".$fid.",".$key.",'".addslashes($val)."')"); } echo("."); unset($data_chunks); ////////////////////////////////////////////////////////////////////////////////* END OF LOOP