/* * If the download type is order then check to make sure that the * customer has access to download the file by doing these checks. */ if ($download['downloadType'] == 'order') { $maxDownloadAttempts = ($config['settings']['dl_attempts'] == 0 or $download['collectionDownload'] == 1) ? 9999 : $config['settings']['dl_attempts']; // Find the max download attempts - if unlimited use 999 //echo $maxDownloadAttempts; exit; // Check authorization if ($_SESSION['downloadAuthorization'] != k_encrypt($download['downloadTypeID'])) { echo "You are not authorized to download this file"; exit; } else { try { $invoice = new invoiceTools(); $digitalItem = $invoice->getSingleInvoiceItem($download['invoiceItemID']); // Check expiration if ($nowGMT > $digitalItem['expires'] and $digitalItem['expires'] != '0000-00-00 00:00:00') { echo "This download has expired"; exit; } // Check download count if ($digitalItem['downloads'] >= $maxDownloadAttempts) { echo "You have reached the maximum number of downloads for this file."; exit; } } catch (Exception $e) { echo $e->getMessage(); exit; } //print_k($digitalItem); // Testing
// Parse the query string //$downloadKey['collectionID']; //$downloadKey['uorderID']; if ($config['EncryptIDs']) { $downloadKey['collectionID'] = k_decrypt($downloadKey['collectionID']); // Collection ID $downloadKey['uorderID'] = k_decrypt($downloadKey['uorderID']); // Order ID $downloadKey['invoiceItemID'] = k_decrypt($downloadKey['invoiceItemID']); // Invoice Item ID } //print_r($downloadKey); exit; $invoice = new invoiceTools(); $invoice->setOrderID($downloadKey['uorderID']); // Set the order ID $invoiceItem = $invoice->getSingleInvoiceItem($downloadKey['invoiceItemID']); //echo $downloadKey['invoiceItemID']; exit; if ($orderInfo = $invoice->getOrderDetails()) { $collectionResult = mysqli_query($db, "\t\t\t\r\n\t\t\t\tSELECT SQL_CALC_FOUND_ROWS *\r\n\t\t\t\tFROM {$dbinfo[pre]}collections \r\n\t\t\t\tWHERE coll_id = '{$downloadKey[collectionID]}'\r\n\t\t\t"); if ($returnRows = getRows()) { $collection = mysqli_fetch_array($collectionResult); $collectionArray = collectionsList($collection); $smarty->assign('collectionRows', $returnRows); $smarty->assign('collection', $collectionArray); if ($collection['colltype'] == 1) { $collectionGalleriesResult = mysqli_query($db, "SELECT gallery_id FROM {$dbinfo[pre]}item_galleries WHERE mgrarea = 'collections' AND item_id = '{$downloadKey[collectionID]}'"); while ($collectionGallery = mysqli_fetch_array($collectionGalleriesResult)) { $collectionGalleriesArray[] = $collectionGallery['gallery_id']; } $collectionGalleries = implode(",", $collectionGalleriesArray); $sql = "\r\n\t\t\t\t\t\t\tSELECT SQL_CALC_FOUND_ROWS * \r\n\t\t\t\t\t\t\tFROM {$dbinfo[pre]}media \r\n\t\t\t\t\t\t\tLEFT JOIN {$dbinfo[pre]}media_galleries \r\n\t\t\t\t\t\t\tON {$dbinfo[pre]}media.media_id = {$dbinfo[pre]}media_galleries.gmedia_id \r\n\t\t\t\t\t\t\tWHERE {$dbinfo[pre]}media_galleries.gallery_id IN ({$collectionGalleries})\r\n\t\t\t\t\t\t\tAND {$dbinfo[pre]}media.active = 1 \r\n\t\t\t\t\t\t\tAND {$dbinfo[pre]}media.approval_status = 1 \r\n\t\t\t\t\t\t\tGROUP BY {$dbinfo[pre]}media.media_id\r\n\t\t\t\t\t\t\tORDER BY {$dbinfo[pre]}media.date_added DESC\r\n\t\t\t\t\t\t";