All pastes #136007 Raw Edit

Anonymous

public text v1 · immutable
#136007 ·published 2006-08-17 11:09 UTC
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