Upgrade article summary image for article
$value) {
$all[$key]['article_image'] = unserialize($all[$key]['article_image']);
if(isset($all[$key]['article_image']['prev']) && !empty($all[$key]['article_image']['id'])) {
//dumpVar($all[$key]);
unset($all[$key]['article_image']['prev']);
unset($all[$key]['article_image']['prev_info']);
unset($all[$key]['article_image']['prev_make']);
unset($all[$key]['article_image']['add']);
unset($all[$key]['article_image']['cname']);
$all[$key]['article_image']['id'] = intval($all[$key]['article_image']['id']);
// retrieve image information
$file = _dbQuery("SELECT f_id, f_hash, f_ext FROM ".DB_PREPEND."phpwcms_file WHERE f_id=".$all[$key]['article_image']['id']." LIMIT 1");
if(!empty($file[0]['f_id']) && $file[0]['f_id'] == $all[$key]['article_image']['id']) {
$all[$key]['article_image']['hash'] = $file[0]['f_hash'];
$all[$key]['article_image']['ext'] = $file[0]['f_ext'];
$all[$key]['article_image']['list_usesummary'] = 1;
$sql = "UPDATE ".DB_PREPEND."phpwcms_article SET ";
$sql .= "article_image = '".aporeplace(serialize($all[$key]['article_image']))."',";
$sql .= "article_tstamp = '".$all[$key]['article_tstamp']."' WHERE article_id = ".$all[$key]['article_id']." LIMIT 1";
$result = _dbQuery($sql, 'UPDATE');
echo '[ID:'.sprintf('%04s', $all[$key]['article_id']).'] '.html_specialchars($all[$key]['article_title']);
echo ''.LF;
}
} else {
unset($all[$key]);
}
}
}
?>
Done! All articles not listed here are not touched.