}
break;
case "sample":
if ($size and !is_numeric($size)) {
header("location: error.php?eType=invalidQuery");
exit;
}
$size = $size ? $size : $config['settings']['preview_size'];
$quality = $config['settings']['preview_quality'];
$sharpen = $config['settings']['preview_sharpen'];
$crop = $crop ? $crop : 0;
// Set cropping if crop was passed
$watermark = $config['settings']['preview_wm'] ? $config['settings']['preview_wm'] : false;
// Determine if a watermark is needed
//"./assets/watermarks/" . $config['settings']['preview_wm'];
$sampleDetails = $mediaInfo->getSampleInfoFromDB();
// Get an array of the thumbnail details from the db
if ($size <= 500) {
$thumbDetails = $mediaInfo->getThumbInfoFromDB();
// Get an array of the thumbnail details from the db
$path = $config['settings']['library_path'] . DIRECTORY_SEPARATOR . $folderName . DIRECTORY_SEPARATOR . "thumbs" . DIRECTORY_SEPARATOR . $thumbDetails['thumb_filename'];
} else {
$path = $config['settings']['library_path'] . DIRECTORY_SEPARATOR . $folderName . DIRECTORY_SEPARATOR . "samples" . DIRECTORY_SEPARATOR . $sampleDetails['sample_filename'];
}
//echo $path; exit;
break;
case "featured":
if ($size and !is_numeric($size)) {
header("location: error.php?eType=invalidQuery");
exit;
}
// Use PHP pass-through
//echo $video['url']; exit;
//print_k($video);
$media['videoStatus'] = 1;
$media['videoInfo'] = $video;
} else {
$media['videoStatus'] = 0;
}
} else {
$media['videoStatus'] = 0;
}
} else {
/*
* Get an estimated preview width and height
*/
$sample = $mediaInfo2->getSampleInfoFromDB();
$sampleSize = getScaledSizeNoSource($sample['sample_width'], $sample['sample_height'], $config['settings']['preview_size'], $crop = 0);
$media['previewWidth'] = $sampleSize[0];
$media['previewHeight'] = $sampleSize[1];
}
$mediaPrice = getMediaPrice($media);
// Get the media price based on the license
$mediaCredits = getMediaCredits($media);
// Get the media credits based on the license
// Get category ID - Make sure member has access to category - maybe add this later
$galleryIDArrayFlat = $galleryIDArray ? implode(",", $galleryIDArray) : 0;
/*
* Prints *****************************************************************************************************************************
*/
$galleryPrintsResult = mysqli_query($db, "\r\n\t\t\t\t\tSELECT DISTINCT(item_id) \r\n\t\t\t\t\tFROM {$dbinfo[pre]}item_galleries \r\n\t\t\t\t\tLEFT JOIN {$dbinfo[pre]}prints \r\n\t\t\t\t\tON {$dbinfo[pre]}item_galleries.item_id = {$dbinfo[pre]}prints.print_id\r\n\t\t\t\t\tWHERE {$dbinfo[pre]}item_galleries.gallery_id IN ({$galleryIDArrayFlat}) \r\n\t\t\t\t\tAND {$dbinfo[pre]}item_galleries.mgrarea = 'prints' \r\n\t\t\t\t\tAND ({$dbinfo[pre]}prints.attachment = 'media' OR {$dbinfo[pre]}prints.attachment = 'both')\r\n\t\t\t\t\t");
// Find out which prints are assigned to galleries this photo is in
// Update icon
mysqli_query($db, "\r\n\t\t\t\t\t\t\tUPDATE {$dbinfo[pre]}media_thumbnails SET \r\n\t\t\t\t\t\t\tthumb_filename='{$iconImageName}',\r\n\t\t\t\t\t\t\tthumb_width='{$iconSize[0]}',\r\n\t\t\t\t\t\t\tthumb_height='{$iconSize[1]}',\r\n\t\t\t\t\t\t\tthumb_filesize='{$iconFilesize}'\r\n\t\t\t\t\t\t\tWHERE media_id = '{$mediaID}' \r\n\t\t\t\t\t\t\tAND thumbtype = 'icon'\r\n\t\t\t\t\t\t\t");
} else {
// No sample - upload and create
# INSERT THUMB INFO INTO THE DATABASE
$sql = "INSERT INTO {$dbinfo[pre]}media_thumbnails (\r\n\t\t\t\t\t\t\t\tmedia_id,\r\n\t\t\t\t\t\t\t\tthumbtype,\r\n\t\t\t\t\t\t\t\tthumb_filename,\r\n\t\t\t\t\t\t\t\tthumb_width,\r\n\t\t\t\t\t\t\t\tthumb_height,\r\n\t\t\t\t\t\t\t\tthumb_filesize\r\n\t\t\t\t\t\t\t\t) VALUES (\r\n\t\t\t\t\t\t\t\t'{$mediaID}',\r\n\t\t\t\t\t\t\t\t'thumb',\r\n\t\t\t\t\t\t\t\t'{$thumbImageName}',\r\n\t\t\t\t\t\t\t\t'{$thumbSize[0]}',\r\n\t\t\t\t\t\t\t\t'{$thumbSize[1]}',\r\n\t\t\t\t\t\t\t\t'{$thumbFilesize}'\r\n\t\t\t\t\t\t\t\t)";
$result = mysqli_query($db, $sql);
$thumbSaveID = mysqli_insert_id($db);
# INSERT ICON INFO INTO THE DATABASE
$sql = "INSERT INTO {$dbinfo[pre]}media_thumbnails (\r\n\t\t\t\t\t\t\t\tmedia_id,\r\n\t\t\t\t\t\t\t\tthumbtype,\r\n\t\t\t\t\t\t\t\tthumb_filename,\r\n\t\t\t\t\t\t\t\tthumb_width,\r\n\t\t\t\t\t\t\t\tthumb_height,\r\n\t\t\t\t\t\t\t\tthumb_filesize\r\n\t\t\t\t\t\t\t\t) VALUES (\r\n\t\t\t\t\t\t\t\t'{$mediaID}',\r\n\t\t\t\t\t\t\t\t'icon',\r\n\t\t\t\t\t\t\t\t'{$iconImageName}',\r\n\t\t\t\t\t\t\t\t'{$iconSize[0]}',\r\n\t\t\t\t\t\t\t\t'{$iconSize[1]}',\r\n\t\t\t\t\t\t\t\t'{$iconFilesize}'\r\n\t\t\t\t\t\t\t\t)";
$result = mysqli_query($db, $sql);
$iconSaveID = mysqli_insert_id($db);
}
}
if (file_exists($sampleImage)) {
if ($sampleInfo = $media->getSampleInfoFromDB()) {
// Update sample
mysqli_query($db, "\r\n\t\t\t\t\t\t\tUPDATE {$dbinfo[pre]}media_samples SET \r\n\t\t\t\t\t\t\tsample_filename='{$sampleImageName}',\r\n\t\t\t\t\t\t\tsample_width='{$sampleSize[0]}',\r\n\t\t\t\t\t\t\tsample_height='{$sampleSize[1]}',\r\n\t\t\t\t\t\t\tsample_filesize='{$sampleFilesize}'\r\n\t\t\t\t\t\t\tWHERE media_id = '{$mediaID}'\r\n\t\t\t\t\t\t\t");
} else {
// No sample - upload and create
# INSERT SAMPLE INFO INTO THE DATABASE
$sql = "INSERT INTO {$dbinfo[pre]}media_samples (\r\n\t\t\t\t\t\t\t\tmedia_id,\r\n\t\t\t\t\t\t\t\tsample_filename,\r\n\t\t\t\t\t\t\t\tsample_width,\r\n\t\t\t\t\t\t\t\tsample_height,\r\n\t\t\t\t\t\t\t\tsample_filesize\r\n\t\t\t\t\t\t\t\t) VALUES (\r\n\t\t\t\t\t\t\t\t'{$mediaID}',\r\n\t\t\t\t\t\t\t\t'{$sampleImageName}',\r\n\t\t\t\t\t\t\t\t'{$sampleSize[0]}',\r\n\t\t\t\t\t\t\t\t'{$sampleSize[1]}',\r\n\t\t\t\t\t\t\t\t'{$sampleFilesize}'\r\n\t\t\t\t\t\t\t\t)";
$result = mysqli_query($db, $sql);
$thumbSaveID = mysqli_insert_id($db);
}
}
// Remove mgr caches
if ($cacheA = glob("./assets/cache/id{$mediaID}-*")) {
foreach ($cacheA as $filename) {
@unlink($filename);
}
