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>";