if (!$res1 || mysql_num_rows($res1) == 0) {
die("<p><b>This database does not have uploaded files");
} else {
print "<p>Number of files to process: " . mysql_num_rows($res1) . "<br>";
}
$files_orphaned = array();
$files_notfound = array();
$files_path_to_correct = array();
$external_count = 0;
$local_count = 0;
while ($res = mysql_fetch_assoc($res1)) {
//verify path
$res['db_fullpath'] = null;
if (@$res['ulf_FilePath'] || @$res['ulf_FileName']) {
$res['db_fullpath'] = $res['ulf_FilePath'] . @$res['ulf_FileName'];
$res['res_fullpath'] = resolveFilePath(@$res['db_fullpath']);
}
//missed link from recDetails - orphaned files
$query2 = "SELECT dtl_RecID from recDetails where dtl_UploadedFileID=" . $res['ulf_ID'];
$res2 = mysql_query($query2);
$currentRecID = null;
if ($res2) {
if (mysql_num_rows($res2) == 0) {
$files_orphaned[$res['ulf_ID']] = array('ulf_ID' => $res['ulf_ID'], 'res_fullpath' => @$res['res_fullpath'], 'isfound' => 0, 'ulf_ExternalFileReference' => @$res['ulf_ExternalFileReference']);
} else {
$row = mysql_fetch_row($res2);
$currentRecID = $row[0];
}
}
if ($res['db_fullpath'] != null && @$res['res_fullpath']) {
if ($currentRecID == null) {
//from uploadFile.php
$type_media = array_key_exists('mediatype', $fileparams) ? $fileparams['mediatype'] : null;
$type_source = array_key_exists('source', $fileparams) ? $fileparams['source'] : null;
if ($type_source == null || $type_source == 'heurist') {
if ($file['ulf_FileName']) {
$filename = $file['ulf_FilePath'] . $file['ulf_FileName'];
// post 18/11/11 proper file path and name
} else {
$filename = HEURIST_FILESTORE_DIR . $file['ulf_ID'];
// pre 18/11/11 - bare numbers as names, just use file ID
}
$filename = str_replace('/../', '/', $filename);
}
if (isset($filename)) {
//add database media storage folder for relative paths
$filename = resolveFilePath($filename);
}
if (isset($filename)) {
$current_file = $file['ulf_ID'] . ': ' . $filename;
if (file_exists($filename)) {
$mimeExt = '';
if ($file['ulf_MimeExt']) {
$mimeExt = $file['ulf_MimeExt'];
} else {
preg_match('/\\.([^.]+)$/', $file["ulf_OrigFileName"], $matches);
//find the extention
$mimeExt = $matches[1];
}
if (function_exists('exif_imagetype')) {
switch (@exif_imagetype($filename)) {
case IMAGETYPE_JPEG:
?>
" src="<?php
echo $filepath;
?>
" />
</audio>
<?php
}
}
?>
</body>
</html>
<?php
} else {
$filepath = resolveFilePath($filepath);
//DEBUG error_log($filepath.' '.file_exists($filepath).' '.$mimeType);
if (file_exists($filepath)) {
downloadFile($mimeType, $filepath, $originalFileName);
} else {
if ($fileinfo[1]) {
//DEBUG error_log('External '.$fileinfo[1]);
header('Location: ' . $fileinfo[1]);
//redirect to URL (external)
} else {
//DEBUG
error_log('File not found ' . $filepath);
}
}
}
} else {
/**
* put your comment there...
*
* @param mixed $fileID
* @param mixed $needConnect
* @return bool
*/
function get_uploaded_file_info_internal($fileID, $needConnect)
{
if ($needConnect) {
mysql_connection_overwrite(DATABASE);
}
$res = null;
$fres = mysql_query('select ulf_ID as id,
ulf_ObfuscatedFileID as nonce,
ulf_OrigFileName as origName,
ulf_FileSizeKB as fileSize,
fxm_MimeType as mimeType,
ulf_Added as date,
ulf_Description as description,
ulf_MimeExt as ext,
ulf_ExternalFileReference as remoteURL,
ulf_Parameters as parameters,
ulf_FilePath, ulf_FileName,
ulf_PreferredSource as prefsource
from recUploadedFiles left join defFileExtToMimetype on ulf_MimeExt = fxm_Extension
where ' . (is_numeric($fileID) ? 'ulf_ID = ' . intval($fileID) : 'ulf_ObfuscatedFileID = "' . addslashes($fileID) . '"'));
if (mysql_num_rows($fres) == 1) {
$res = mysql_fetch_assoc($fres);
$origName = urlencode($res["origName"]);
$thumbnail_file = "ulf_" . $res["nonce"] . ".png";
if (file_exists(HEURIST_THUMB_DIR . $thumbnail_file)) {
$res["thumbURL"] = HEURIST_THUMB_URL . $thumbnail_file;
} else {
$res["thumbURL"] = HEURIST_BASE_URL . "common/php/resizeImage.php?" . (defined('HEURIST_DBNAME') ? "db=" . HEURIST_DBNAME . "&" : "") . "ulf_ID=" . $res["nonce"];
}
$downloadURL = HEURIST_BASE_URL . "records/files/downloadFile.php/" . $origName . "?" . (defined('HEURIST_DBNAME') ? "db=" . HEURIST_DBNAME . "&" : "") . "ulf_ID=" . $res["nonce"];
if ($res["remoteURL"] != null || $res["prefsource"] == "external") {
$res["URL"] = $res["remoteURL"];
} else {
$res["URL"] = $downloadURL;
}
if (@$res['ulf_FilePath'] || @$res['ulf_FileName']) {
$res['fullpath'] = @$res['ulf_FilePath'] . @$res['ulf_FileName'];
}
//add database media storage folder for relative paths
$res['fullpath'] = resolveFilePath(@$res['fullpath']);
$params = parseParameters($res["parameters"]);
$res["mediaType"] = array_key_exists('mediatype', $params) ? $params['mediatype'] : null;
$res["remoteSource"] = array_key_exists('source', $params) ? $params['source'] : null;
$type_source = $res['remoteSource'];
if (!($type_source == null || $type_source == 'heurist')) {
//verify that this is actually remote resource
if (@$res['fullpath'] && file_exists($res['fullpath'])) {
$res['remoteSource'] = 'heurist';
}
}
//
//@todo - add special parameters for specific sources and media types
// QUESTION - store it in database? Or create on-fly??
//
if ($res["remoteSource"] == "youtube" || $res["remoteSource"] == "gdrive" || $res["mediaType"] == "image" || $res["ext"] == "pdf" || $res["mediaType"] == "video" || $res["mediaType"] == "audio") {
$res["playerURL"] = $downloadURL . "&player=yes";
}
//$res = array("file" => $res);
}
return $res;
}
$params = array();
$params["q"] = $q;
$query = prepareQuery($params, $squery, BOTH, $detTable, $ourwhere);
$mysqli = mysqli_connection_overwrite(DATABASE);
$res = $mysqli->query($query);
if (!$res) {
print "<p class='error'>Failed to obtain list of file resources from MySQL database.{$please_advise}</p>";
} else {
//loop for records/details
while ($row = $res->fetch_row()) {
//$row = $res->fetch_assoc()) {
$filename_orig = $row[4];
$filename_insys = null;
if (@$row[2] || @$row[3]) {
$filename_insys = @$row[2] . @$row[3];
$filename_insys = resolveFilePath($filename_insys);
}
if ($filename_insys && $row[1] && $filename_orig) {
if (file_exists($filename_insys)) {
//get relative path
$imgfolder = $folder . '/resources/';
if (!file_exists($imgfolder) && !mkdir($imgfolder, 0777, true)) {
print "<p class='error'>'Failed to create folder for file resources: " . $imgfolder . "{$please_advise}</p>";
break;
} else {
$filename = $imgfolder . $filename_orig;
//copy file
copy($filename_insys, $filename);
}
} else {
print "<p class='error'>File not found: " . $filename_insys . "<br>Name indicated includes relative path from database file store directory" . "{$please_advise}</p>";
