rendered paste body 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