function get_tmp_file($id, $nonewver = "")
{
global $CONF, $DB, $PAGE_ELEMENT;
$rs = $DB->Execute("SELECT * FROM document WHERE id={$id}");
if (!($thisfile = $rs->FetchRow())) {
return false;
}
$PAGE_ELEMENT[PAGE][1][0][param] = $thisfile[ref_prat];
if ($thisfile[ref_id] == 0) {
$old_ref = $thisfile[id];
$old_ver = $thisfile[version];
$old_note = $thisfile[note];
$old_desc = $thisfile[descr];
$ref_orig = $thisfile[version];
$ref_ext = $thisfile[ext];
} else {
$rs2 = $DB->Execute("SELECT * FROM document WHERE id=" . $thisfile[ref_id]);
$thisfile_base = $rs2->FetchRow();
$old_ref = $thisfile_base[id];
$old_ver = $thisfile_base[version];
$old_note = $thisfile_base[note];
$old_desc = $thisfile_base[descr];
$ref_orig = $thisfile[version];
$ref_ext = $thisfile[ext];
}
if ($nonewver != 1) {
//Insert new document
$rs_insnew = $DB->Execute("INSERT INTO document SET operatore=" . $_SESSION[fw_userid] . ", descr='" . $old_desc . "', note='" . $old_note . "', version=" . ($old_ver + 1) . ", ref_id=0, ref_orig=" . $ref_orig . ", filename='" . $thisfile[filename] . "', data=NOW(), ref_prat=" . $thisfile[ref_prat] . ", ref_pres=" . $thisfile[ref_pres] . ", ext='" . $ref_ext . "'");
//REMEMBER Change with adodb syntax
$ret = mysql_insert_id();
} else {
$ret = 0;
}
//Update other document and unlock user
$rs_updold = $DB->Execute("UPDATE document SET ref_id={$ret}, `lock`=0, user_lock=0 WHERE ref_id={$old_ref} OR id={$old_ref}");
$rs_updusr = $DB->Execute("UPDATE " . $CONF[auth_db_table] . " SET `lock`=0 WHERE id=" . $thisfile[user_lock]);
if ($nonewver != 1) {
$filename = $thisfile[filename] . '-' . $thisfile[id] . '-' . $thisfile[version] . '.' . $thisfile[ext];
$newfilename = $thisfile[filename] . '-' . $ret . '-' . ($old_ver + 1) . '.' . $thisfile[ext];
} else {
$filename = $thisfile[filename] . '-' . $thisfile[id] . '-' . $thisfile[version] . '.' . $thisfile[ext];
$newfilename = $thisfile[filename] . '-' . $thisfile[id] . '-' . $thisfile[version] . '.' . $thisfile[ext];
}
if ($thisfile[ext] == "sxw") {
if (!file_exists($CONF[path_base] . $CONF[dir_upload] . $filename)) {
return false;
}
copy($CONF[path_base] . $CONF[dir_upload] . $filename, $CONF[path_base] . $CONF[dir_upload] . 'document/' . $newfilename);
unlink($CONF[path_base] . $CONF[dir_upload] . $filename);
getTextfromSXW($CONF[path_base] . $CONF[dir_upload] . 'document/' . $newfilename);
} else {
if (!file_exists($CONF[path_base] . $CONF[dir_upload] . $filename)) {
return false;
}
copy($_FILES["fileupl"]['tmp_name'], $CONF[path_base] . $CONF[dir_upload] . 'document/' . $newfilename);
unlink($CONF[path_base] . $CONF[dir_upload] . $filename);
}
return $newfilename;
$_SESSION[user][lock] = 0;
}
#!/usr/bin/php
<?php
include 'functions.php';
getTextfromSXW('/www/htdocs/cw-portal.com/framework/tmp/document/nuovosistema-123-1.sxw');
$ret = searchDocuments('aliquam');
print_r($ret);
?>
