// 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]
}
