$needs_thumb = true;
} elseif (defined('THUMB_EXACT_W') and defined('THUMB_EXACT_H')) {
$thumb1 = $uplo->save_thumbnail(THUMB_EXACT_W, THUMB_EXACT_H, 'shrink_to_size');
$needs_thumb = true;
}
if ($needs_thumb && empty($thumb1)) {
$thumb1 = $newfilename;
}
if (PEAR::isError($thumb1)) {
$errs[] = $thumb1->getMessage();
} else {
$vals['system_location'] = CSHOP_MEDIA_URLPATH;
$vals['filename_large'] = $newfilename;
$vals['dims_large'] = $img_dims;
$vals['filename_thumb'] = $thumb1;
$vals['dims_thumb'] = $uplo->get_thumb_dims();
$vals['mime_type'] = $uplo->get_filetype();
if (isset($zoom_file)) {
$vals['filename_zoom'] = basename($zoom_file);
}
}
}
}
if (!count($errs)) {
if ($ACTION == OP_ADD) {
$vals['id'] = $pdb->nextId($tablename);
$res = $pdb->autoExecute($tablename, $vals, DB_AUTOQUERY_INSERT);
} elseif ($ACTION == OP_EDIT) {
$where = sprintf("id = %d", $reqid);
$res = $pdb->autoExecute($tablename, $vals, DB_AUTOQUERY_UPDATE, $where);
}
$res = $uplo->save_upload();
if (PEAR::isError($res)) {
$errs[] = $res->getMessage();
} else {
// get the name of the new file
$newfilename = $uplo->get_newname();
// vals to be put in DB
$upfiles[$upfile] = array('sFilename' => $newfilename, 'sType' => 'image', 'dtDate' => date('Y-m-d h:i'), 'img_dims' => $uplo->get_img_dims());
if ($upfile == 'imageid') {
// create a thumbnail right here:
$thumb1 = $uplo->save_thumbnail(THUMB_MAX_W, THUMB_MAX_H);
if (PEAR::isError($thumb1)) {
$errs[] = $thumb1->getMessage();
} else {
// another upfile for the thumbnail image
$upfiles['image_thumbid'] = array('sFilename' => $thumb1, 'sType' => 'image', 'dtDate' => date('Y-m-d h:i'), 'img_dims' => $uplo->get_thumb_dims());
}
}
}
}
}
$imgcount = 0;
/** try to insert or update image info to DB table media_prod **/
foreach ($upfiles as $upfile => $img_vals) {
if (count($img_vals)) {
$imgcount++;
$oldimg = null;
$sql = sprintf("SELECT %s FROM cm_products WHERE id = %d", $upfile, $productid);
if ($oldfileid = $pdb->getOne($sql)) {
$sql = sprintf("SELECT id, sFilename FROM media_prod \n WHERE id = %d", $oldfileid);
$oldimg = $pdb->getRow($sql);
