function file2statement($toMove, $db, $user_id)
{
extract($toMove);
$filekey = generateAFilekey(array('filename' => $file, 'filesize' => filesize($file), 'db' => $db, 'user_id' => $user_id));
$filedata = get_filekey_data($filekey, $db);
$maindir = $GLOBALS['s3db_info']['server']['db']['uploads_folder'] . $GLOBALS['s3db_info']['server']['db']['uploads_file'];
$folder = project_folder_name($project_id, $db);
$tmp = fileNameAndExtension($file);
extract($tmp);
$newSpot = $maindir . '/tmps3db/' . $filedata['file_id'] . '.' . $extension;
#$newSpot = ereg_replace('/.$','',$newSpot);
copy($file, $newSpot);
$s3ql = compact('user_id', 'db');
$s3ql['insert'] = 'file';
$s3ql['where']['filekey'] = $filekey;
$s3ql['where']['rule_id'] = $rule_id;
$s3ql['where']['item_id'] = $item_id;
#echo '<pre>';print_r($s3ql);exit;
$fileinserted = S3QLaction($s3ql);
#echo '<pre>';print_r($fileinserted);exit;
$fileinserted = html2cell($fileinserted);
if ($fileinserted[2]['error_code'] == '0') {
return $fileinserted[2]['file_id'];
} else {
return False;
}
}
if (!$_FILES) {
echo formatReturn('3', 'No file to upload.', $_REQUEST['format'], '');
exit;
} elseif ($file_id == '') {
if (is_array($_FILES)) {
$folder = $GLOBALS['s3db_info']['server']['db']['uploads_folder'] . $GLOBALS['s3db_info']['server']['db']['uploads_file'] . '/tmps3db/';
$filekey = '';
$filename = '';
foreach ($_FILES as $inputName => $fileData) {
ereg('.*\\.([a-zA-Z0-9]*)$', $_FILES[$inputName]['name'], $ext);
$ext = $ext[1];
$filename = $_FILES[$inputName]['name'];
$filesize = $_FILES[$inputName]['size'];
$filekey = generateAFilekey(compact('filename', 'filesize', 'db', 'user_id'));
#Retrieve the file_id fro mthe filekey
$tmp = get_filekey_data($filekey, $db);
$file_id = $tmp['file_id'];
##Now upload the file
$final = $folder . $file_id . '.' . $ext;
$moved = copy($_FILES[$inputName]['tmp_name'], $final);
if ($moved) {
##Was a rule_id and item_id provided? If yes, insert it using s3ql, if not, provide the filekey
if ($_REQUEST['item_id'] && $_REQUEST['rule_id']) {
$s3ql = compact('user_id', 'db');
$s3ql['insert'] = 'file';
$s3ql['where']['item_id'] = $_REQUEST['item_id'];
$s3ql['where']['rule_id'] = $_REQUEST['rule_id'];
$s3ql['where']['filekey'] = $filekey;
$s3ql['format'] = $_REQUEST['format'];
$done = S3QLaction($s3ql);
$msg .= $done;
function fileFoundInfo($F)
{
extract($F);
#$F must contain filekey, instance_id/instance_info, rule_id/rule_info, db, user_id
#Find out if the file already exists in the tmp directory
$filedata = get_filekey_data($filekey, $db);
#echo '<pre>';print_r($filedata);exit;
if (!$filedata || !is_array($filedata)) {
return array(False, '<message>Filekey is not valid.</message>');
} else {
extract($filedata);
}
#$file_id = get_entry('file_transfer', 'file_id', 'filekey', $filekey, $db);
#list($name, $extension) = explode('.', $filedata['filename']);
#separate file name from extensions
$a = fileNameAndExtension($filedata['filename']);
extract($a);
#$tmp=explode(".", $filedata['filename']);
#ereg('.([A-Za-z0-9]+)$',$filedata['filename'], $tokens);
#echo '<pre>';print_r($tokens);exit;
#$extension= $tokens[1];
$maindir = $GLOBALS['s3db_info']['server']['db']['uploads_folder'] . $GLOBALS['s3db_info']['server']['db']['uploads_file'] . '/tmps3db';
$old_file = $maindir . '/' . $file_id . '.' . $extension;
$old_file = ereg_replace('/.$', '', $old_file);
if (!is_file($old_file)) {
return array(False, $something_does_not_exist . "<message>File not found, please upload file first.</message>");
} else {
return array(True, 'old_file' => $old_file, 'file_name' => $filedata['filename'], 'file_size' => filesize($old_file), 'mime_type' => $extension);
}
}
