function __perform_refresh_thumbnails_batch() { if ($this->_batchlimit > 0) { $results = fetch_file_cache_rs('ITEM'); if ($results) { while ($file_cache_r = db_fetch_assoc($results)) { // its not a case of only a thumbnail, if not even the source exists if (file_cache_get_cache_file($file_cache_r) !== FALSE && file_cache_get_cache_file_thumbnail($file_cache_r) === FALSE) { // in this case we want to refresh the URL, so TRUE as last parameter idicates overwrite if (file_cache_save_thumbnail_file($file_cache_r, $errors)) { $this->_processed++; } else { $this->_failures++; } // don't process anymore this time around. if ($this->_processed >= $this->_batchlimit) { break; } } } db_free_result($results); } } $this->_remaining = fetch_file_cache_missing_thumbs_cnt('ITEM'); }
if ($results) { while ($file_cache_r = db_fetch_assoc($results)) { $listingObject->startRow(); if (file_cache_get_cache_file($file_cache_r)) { $hrefUrl = "url.php?id=" . $file_cache_r['sequence_number']; if (!is_url_absolute($file_cache_r['url'])) { $url = get_item_input_file_upload_url($file_cache_r['url']); if ($url !== FALSE) { $hrefUrl = $url; } } $listingObject->addColumn("<a href=\"" . $hrefUrl . "\" target=\"_new\">" . get_overflow_tooltip_column($file_cache_r['url'], 100) . "</a>"); } else { $listingObject->addColumn(get_overflow_tooltip_column($file_cache_r['url'], 100)); } if (file_cache_get_cache_file_thumbnail($file_cache_r)) { $listingObject->addThemeImageColumn('tick.gif'); } else { $listingObject->addThemeImageColumn('cross.gif'); } $listingObject->addColumn(get_localised_timestamp(get_opendb_config_var('http', 'datetime_mask'), $file_cache_r['cache_date'])); $column = ''; if ($file_cache_r['expired_ind'] == 'Y') { $column .= "<span class=\"error\">"; } if ($file_cache_r['expire_date'] != NULL) { $column .= get_localised_timestamp(get_opendb_config_var('http', 'datetime_mask'), $file_cache_r['expire_date']); } else { $column .= "NA"; } if ($file_cache_r['expired_ind'] == 'Y') {
function delete_file_cache($file_cache_r) { if (($filename = file_cache_get_cache_file($file_cache_r)) !== FALSE) { delete_file($filename); } // in case thumbnail file is orphaned, delete separately. if (($thumbnail_filename = file_cache_get_cache_file_thumbnail($file_cache_r)) !== FALSE) { delete_file($thumbnail_filename); } $query = "DELETE FROM file_cache WHERE sequence_number = " . $file_cache_r['sequence_number']; $delete = db_query($query); if ($delete) { // Even if no attributes were deleted, because there were none, this should still return true. if (db_affected_rows() > 0) { opendb_logger(OPENDB_LOG_INFO, __FILE__, __FUNCTION__, NULL, $file_cache_r); } return TRUE; } else { opendb_logger(OPENDB_LOG_ERROR, __FILE__, __FUNCTION__, db_error(), $file_cache_r); return FALSE; } }