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