// Invoice Item ID $downloadMemberID = $orderInfo['member_id']; // Member ID $downloadTypeID = $orderInfo['order_id']; // Download Type ID / Order ID } // Downloadable Status - 0 = order not approved | 1 = active/ok | 2 = expired | 3 = downloads exceeded | 4 = Not available for download if ($nowGMT > $itemValue['expires'] and $itemValue['expires'] != '0000-00-00 00:00:00') { $downloadableStatus = 2; } elseif ($itemValue['downloads'] >= $maxDownloadAttempts) { $downloadableStatus = 3; } else { // Check if file is available try { // Get the media information $mediaObj = new mediaTools($itemValue['asset_id']); $media = $mediaObj->getMediaInfoFromDB($itemValue['asset_id']); $folderInfo = $mediaObj->getFolderStorageInfoFromDB($media['folder_id']); //echo $itemValue['asset_id']; print_r($folderInfo); echo "<br /><br /><br /><br />"; // testing if ($itemValue['item_id']) { $mdspResult = mysqli_query($db, "\r\n\t\t\t\t\t\t\t\t\t\t\tSELECT *\r\n\t\t\t\t\t\t\t\t\t\t\tFROM {$dbinfo[pre]}media_digital_sizes \r\n\t\t\t\t\t\t\t\t\t\t\tWHERE ds_id = '{$itemValue[item_id]}' \r\n\t\t\t\t\t\t\t\t\t\t\tAND media_id = '{$itemValue[asset_id]}'\r\n\t\t\t\t\t\t\t\t\t\t\t"); if ($mdspRows = mysqli_num_rows($mdspResult)) { $mdsp = mysqli_fetch_assoc($mdspResult); } // Get the digital profile details $dspResult = mysqli_query($db, "\r\n\t\t\t\t\t\t\t\t\t\t\tSELECT * \r\n\t\t\t\t\t\t\t\t\t\t\tFROM {$dbinfo[pre]}digital_sizes \r\n\t\t\t\t\t\t\t\t\t\t\tWHERE ds_id = '{$itemValue[item_id]}'\r\n\t\t\t\t\t\t\t\t\t\t\t"); $dsp = mysqli_fetch_assoc($dspResult); // Get the digital profile details $deliveryMethod = $dsp['delivery_method']; // Delivery method of file // echo $deliveryMethod.'<br>'; // Testing
/* if(!$_SESSION['crumbsSession']) // Get a crumb trail - doesn't work for contibutors yet { @$galleryInfo = mysqli_fetch_assoc(mysqli_query($db,"SELECT * FROM {$dbinfo[pre]}media_galleries WHERE gmedia_id = '{$mediaID}' ORDER BY mg_id LIMIT 1")); if($galleryInfo['gallery_id']) { $galleriesMainPageLink['page'] = "gallery.php?mode=gallery"; $_SESSION['galleriesData'][0]['linkto'] = linkto($galleriesMainPageLink); // Check for SEO $_SESSION['galleriesData'][0]['name'] = $lang['galleries']; // $_SESSION['crumbsSession'] = galleryCrumbsFull($galleryInfo['gallery_id']); } } */ // Check for video sample $mediaInfo2 = new mediaTools($mediaID); if ($media['dsp_type'] == 'video') { if ($video = $mediaInfo2->getVidSampleInfoFromDB()) { $videoCheck = $mediaInfo2->verifyVidSampleExists(); if ($videoCheck['status']) { // Make sure the video exists //print_k($videoCheck); exit; if ($videoCheck['url'] and $config['passVideoThroughPHP'] === false) { $video['url'] = $videoCheck['url']; } else { $video['url'] = $config['settings']['site_url'] . '/video.php?mediaID=' . $media['encryptedID']; } // Use PHP pass-through //echo $video['url']; exit; //print_k($video); $media['videoStatus'] = 1;
exit; } } catch (Exception $e) { echo $e->getMessage(); exit; } //print_k($digitalItem); // Testing //echo $_SESSION['downloadAuthorization']; exit; // Testing } } // End authorization check try { idCheck($download['mediaID']); // Make sure ID is numeric // Get the media information $media = new mediaTools($download['mediaID']); $mediaInfo = $media->getMediaInfoFromDB(); $folderInfo = $media->getFolderStorageInfoFromDB($mediaInfo['folder_id']); if ($download['externalLink']) { $externalLink = 1; // External Link $filecheck['status'] = checkExternalFile($download['externalLink']) > 400 ? 0 : 1; $filecheck['path'] = $download['externalLink']; } else { $filecheck = $media->verifyMediaFileExists(); // Returns array [stauts,path,filename] } //$filecheck = $media->verifyMediaFileExists(); // Returns array [stauts,path,filename] // Old //print_r($mediaInfo); //echo $_SESSION['member']['mem_id']; //exit;
/****************************************************************** * Copyright 2011 Ktools.net LLC - All Rights Reserved * http://www.ktools.net * Created: 12-20-2011 * Modified: 12-20-2011 ******************************************************************/ define('BASE_PATH', dirname(__FILE__)); // Define the base path require_once BASE_PATH . '/assets/includes/initialize.php'; require_once BASE_PATH . '/assets/classes/imagetools.php'; require_once BASE_PATH . '/assets/classes/mediatools.php'; $mediaID = k_decrypt($mediaID); //$folderID = k_decrypt($folderID); try { $media = new mediaTools($mediaID); $mediaInfo = $media->getMediaInfoFromDB(); $folderInfo = $media->getFolderStorageInfoFromDB($mediaInfo['folder_id']); $useFolderName = $folderInfo['encrypted'] ? $folderInfo['enc_name'] : $folderInfo['name']; // Check if it is encrypted or not // Check if the video sample file exists if ($vidSampleInfo = $media->getVidSampleInfoFromDB()) { $vidSampleVerify = $media->verifyVidSampleExists(); } else { $vidSampleVerify['status'] = 0; } } catch (Exception $e) { echo "<span style='color: #EEE'>" . $e->getMessage() . "</span>"; } $file = "{$config[settings][library_path]}/{$useFolderName}/samples/{$vidSampleInfo[vidsample_filename]}"; //echo file_exists($file); exit;
require_once BASE_PATH . '/assets/includes/header.inc.php'; require_once BASE_PATH . '/assets/includes/errors.php'; require_once BASE_PATH . '/assets/classes/imagetools.php'; require_once BASE_PATH . '/assets/classes/mediatools.php'; require_once BASE_PATH . '/assets/classes/colors.php'; $colorPalette = new GetMostCommonColors(); try { $x = 0; $mediaResult = mysqli_query($db, "SELECT * FROM {$dbinfo[pre]}media WHERE active = 1"); // Select the active media $mediaRows = mysqli_num_rows($mediaResult); while ($media = mysqli_fetch_assoc($mediaResult)) { $colorPaletteResult = mysqli_query($db, "SELECT * FROM {$dbinfo[pre]}color_palettes WHERE media_id = '{$media[media_id]}' ORDER BY cp_id"); $colorPaletteRows = mysqli_num_rows($colorPaletteResult); if (!$colorPaletteRows and $x < 10) { $mediaInfo = new mediaTools($media['media_id']); $folderInfo = $mediaInfo->getFolderInfoFromDB($media['folder_id']); $folderName = $mediaInfo->getFolderName(); $thumbInfo = $mediaInfo->getThumbInfoFromDB($media['media_id']); $path = BASE_PATH . "/assets/library/{$folderName}/thumbs/{$thumbInfo[thumb_filename]}"; // xxxxxx No encryption detection //$image = new imagetools($path); //$colorPalette = $image->colorPalette(10,5); if ($config['cpResults'] > 0) { $colors = $colorPalette->Get_Color($path, $config['cpResults'], $config['cpReduceBrightness'], $config['cpReduceGradients'], $config['cpDelta']); } @mysqli_query($db, "DELETE FROM {$dbinfo[pre]}color_palettes WHERE media_id = '{$media[media_id]}'"); // Delete old color palette first - just in case if (count($colors) > 0) { echo "Updated: {$media[media_id]}<br>"; // Save color palette
} } } require_once BASE_PATH . '/assets/includes/initialize.php'; require_once BASE_PATH . '/assets/classes/imagetools.php'; require_once BASE_PATH . '/assets/classes/mediatools.php'; $mediaID = k_decrypt($mediaID); $folderID = k_decrypt($folderID); $hcrop = $_GET['hcrop']; //echo 'mid'.$mediaID; exit; if (!is_numeric($mediaID) or !is_numeric($folderID)) { die('An error has occurred!'); } // Check to make sure the IDs are numeric try { $mediaInfo = new mediaTools($mediaID); $folderInfo = $mediaInfo->getFolderInfoFromDB($folderID); $folderName = $mediaInfo->getFolderName(); switch ($type) { default: case "thumbnail": if ($size and !is_numeric($size)) { header("location: error.php?eType=invalidQuery"); exit; } $size = ($size and $size <= $config['settings']['thumb_size']) ? $size : $config['settings']['thumb_size']; $quality = $config['settings']['thumb_quality']; $sharpen = $config['settings']['thumb_sharpen']; $watermark = $config['settings']['thumb_wm'] ? $config['settings']['thumb_wm'] : false; // Determine if a watermark is needed if ($config['settings']['thumbcrop'] or $crop) {
break; case "uploadVideoPreview": /* * Security check */ $checkToken = md5($config['settings']['serial_number'] . $_POST['securityTimestamp']); if ($checkToken != $_POST['securityToken']) { exit; } $approvalStatus = $_SESSION['member']['membershipDetails']['approval'] ? 1 : 0; // Check the approval status if ($approvalStatus == 0) { @mysqli_query($db, "UPDATE {$dbinfo[pre]}media SET approval_status='0' WHERE media_id = '{$mediaID}'"); } // Update the approval_status in the db $media = new mediaTools($mediaID); $mediaInfo = $media->getMediaInfoFromDB(); $folderInfo = $media->getFolderStorageInfoFromDB($mediaInfo['folder_id']); if ($folderInfo['encrypted']) { $folderName = $folderInfo['enc_name']; } else { $folderName = $folderInfo['name']; } $folderPath = "{$config[settings][library_path]}/{$folderName}/samples/"; $newFilename = basefilename($mediaInfo['filename']); if ($vidSampleInfo = $media->getVidSampleInfoFromDB()) { @unlink($folderPath . $vidSampleInfo['vidsample_filename']); } // It already exists - delete the old one first $temp_filename = strtolower($_FILES['Filedata']['name']); $temp_array = explode(".", $temp_filename);
$sql = "SELECT SQL_CALC_FOUND_ROWS * FROM {$dbinfo[pre]}media WHERE media_id = '{$mediaID}'"; //$sql = "SELECT SQL_CALC_FOUND_ROWS * FROM {$dbinfo[pre]}media LEFT JOIN {$dbinfo[pre]}licenses ON {$dbinfo[pre]}media.license = {$dbinfo[pre]}licenses.license_id WHERE media_id = '{$mediaID}'"; $mediaInfo = new mediaList($sql); if ($mediaInfo->getRows()) { $media = $mediaInfo->getSingleMediaDetails('thumb'); $galleryIDArray = $mediaInfo->getMediaGalleryIDs(); // Get an array of galleries this media is in $mediaPrice = getMediaPrice($media); // Get the media price based on the license $mediaCredits = getMediaCredits($media); // Get the media credits based on the license // Grab the correct title for this language $media['title'] = $media['title_' . $selectedLanguage] ? $media['title_' . $selectedLanguage] : $media['title']; } // Get the media information $mediaObj = new mediaTools($mediaID); $mediaObj->getMediaInfoFromDB($mediaID, $media); $folderInfo = $mediaObj->getFolderStorageInfoFromDB($media['folder_id']); //print_r($filecheck); $totalPixels = $media['width'] * $media['height']; if ($id == 0) { // Check if this original is instantly available if ($media['external_link']) { $externalLink = 1; // External Link $filecheck['status'] = checkExternalFile($media['external_link']) > 400 ? 0 : 1; $filecheck['path'] = $media['external_link']; } else { $filecheck = $mediaObj->verifyMediaFileExists(); // Returns array [stauts,path,filename] }