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