//require_once BASE_PATH.'/assets/includes/affiliate.inc.php'; require_once BASE_PATH . '/assets/includes/header.inc.php'; require_once BASE_PATH . '/assets/includes/errors.php'; try { $useMediaID = $mediaID; // Original untouched media ID if (!$mediaID) { // Make sure a media ID was passed exit; } else { idCheck($mediaID); // Make sure ID is numeric $sql = "SELECT SQL_CALC_FOUND_ROWS * FROM {$dbinfo[pre]}media WHERE media_id = '{$mediaID}'"; $mediaInfo = new mediaList($sql); if ($mediaInfo->getRows()) { $media = $mediaInfo->getSingleMediaDetails('preview'); $galleryIDArray = $mediaInfo->getMediaGalleryIDs(); // Get an array of galleries this media is in switch ($incMode) { default: case 'digital': $galleryIDArrayFlat = $galleryIDArray ? implode(",", $galleryIDArray) : 0; // Get the gallery IDs for this photo require_once 'media.details.inc.php'; $smarty->assign('mediaID', $mediaID); $smarty->display('download.mini.window.tpl'); // Smarty template break; } } }
try { $memberID = $_SESSION['member']['mem_id']; if (!$memberID) { die('No member ID exists'); } // Just to be safe make sure a memberID exists before continuing $downloadsResult = mysqli_query($db, "\r\n\t\t\tSELECT *\r\n\t\t\tFROM {$dbinfo[pre]}downloads \r\n\t\t\tWHERE mem_id = {$memberID} \r\n\t\t\tORDER BY dl_id DESC\r\n\t\t\t"); if ($returnRows = mysqli_num_rows($downloadsResult)) { while ($downloads = mysqli_fetch_array($downloadsResult)) { $downloadsArray[$downloads['dl_id']] = $downloads; $downloadsArray[$downloads['dl_id']]['download_date_display'] = $customDate->showdate($downloads['dl_date'], 1); $sql = "SELECT SQL_CALC_FOUND_ROWS * FROM {$dbinfo[pre]}media WHERE media_id = '{$downloads[asset_id]}'"; $mediaObj = new mediaList($sql); // Create a new mediaList object if ($returnMediaRows = $mediaObj->getRows()) { $downloadsArray[$downloads['dl_id']]['media'] = $mediaObj->getSingleMediaDetails(); } switch ($downloads['dl_type']) { default: $downloadsArray[$downloads['dl_id']]['download_type_display'] = $lang['unknown']; break; case "free": $downloadsArray[$downloads['dl_id']]['download_type_display'] = $lang['freeDownload']; break; case "sub": $downloadsArray[$downloads['dl_id']]['download_type_display'] = $lang['subscription']; break; case "order": $downloadsArray[$downloads['dl_id']]['download_type_display'] = $lang['order']; break; case "credits":
$contrSalesResult = mysqli_query($db, "\r\n\t\t\tSELECT * FROM {$dbinfo[pre]}commission \r\n\t\t\tLEFT JOIN {$dbinfo[pre]}invoice_items \r\n\t\t\tON {$dbinfo[pre]}commission.oitem_id = {$dbinfo[pre]}invoice_items.oi_id \r\n\t\t\tWHERE {$dbinfo[pre]}commission.contr_id = '{$_SESSION[member][mem_id]}' \r\n\t\t\tAND {$dbinfo[pre]}commission.order_status = '1' \r\n\t\t\tORDER BY {$dbinfo[pre]}commission.com_id DESC\r\n\t\t"); if ($saleRows = mysqli_num_rows($contrSalesResult)) { while ($contrSales = mysqli_fetch_assoc($contrSalesResult)) { if ($contrSales['omedia_id']) { /* $media = new mediaTools($contrSales['omedia_id']); $mediaInfo = $media->getMediaInfoFromDB(); $thumbInfo = $media->getIconInfoFromDB(); $verify = $media->verifyMediaSubFileExists('icons'); $mediaStatus = $verify['status']; */ $sql = "SELECT SQL_CALC_FOUND_ROWS * FROM {$dbinfo[pre]}media WHERE media_id = '{$contrSales[omedia_id]}'"; $mediaObj = new mediaList($sql); // Create a new mediaList object if ($returnMediaRows = $mediaObj->getRows()) { $contrSales['media'] = $mediaObj->getSingleMediaDetails(); } } //print_r($contrSales['media']); switch ($contrSales['comtype']) { default: case "cur": // Currency based payment $total = $contrSales['com_total'] * $contrSales['item_qty']; if ($contrSales['item_percent'] == 0) { // Change a 0 to a 100% $contrSales['item_percent'] = 100; } $itemCommission = round($total * ($contrSales['item_percent'] / 100) * ($contrSales['mem_percent'] / 100), 2); break; case "cred":
break; case "digital": //$mediaObj = new mediaTools($cartItem['asset_id']); //$mediaObj->getMediaInfoFromDB($cartItem['asset_id'],$media); $sql = "SELECT SQL_CALC_FOUND_ROWS * FROM {$dbinfo[pre]}media WHERE media_id = '{$cartItem[asset_id]}'"; $mediaInfo = new mediaList($sql); // Check for customized profile /* $customizedDSPResult = mysqli_query($db,"SELECT SQL_CALC_FOUND_ROWS * FROM {$dbinfo[pre]}media_digital_sizes WHERE ds_id = '{$cartItem[item_id]}' AND media_id = '{$cartItem[asset_id]}'"); if(getRows()) $customizedDSP = mysqli_fetch_assoc($customizedDSPResult); */ //print_r($customizedDSP); //echo "rows: {$customizedRows}"; if ($mediaInfo->getRows()) { $media = $mediaInfo->getSingleMediaDetails('thumb'); } $digital = digitalPrep($cartItem['item_id'], $media); $numOfDigitals += $cartItem['quantity']; // Count the number of product items in the cart //$isOriginal = ($cartItem['item_id']) ? true : false; $digitalDetails = digitalsList($digital, $cartItem['asset_id']); //print_r($digitalDetails); exit; //print_r($digitalDetails); exit; $digitalDetails['cartEditLink'] .= '&edit=' . $cartItem['oi_id']; // Add edit var if (!$cartItem['paytype']) { $cartItem['paytype'] = 'cur'; } // Make sure the payType is set just in case $cartItemsArray[$cartItem['oi_id']]['usePayType'] = $cartItem['paytype'];
// Use Smarty require_once BASE_PATH . '/assets/includes/session.php'; require_once BASE_PATH . '/assets/includes/initialize.php'; require_once BASE_PATH . '/assets/includes/init.member.php'; require_once BASE_PATH . '/assets/includes/security.inc.php'; require_once BASE_PATH . '/assets/includes/language.inc.php'; require_once BASE_PATH . '/assets/includes/header.inc.php'; require_once BASE_PATH . '/assets/classes/mediatools.php'; try { $unencryptedMediaID = k_decrypt($mediaID); // Get the mediaID unencrypted $sql = "SELECT SQL_CALC_FOUND_ROWS * FROM {$dbinfo[pre]}media WHERE media_id = '{$unencryptedMediaID}'"; $mediaObj = new mediaList($sql); // Create a new mediaList object if ($returnRows = $mediaObj->getRows()) { $media = $mediaObj->getSingleMediaDetails(); } $mediaInfo = new mediaTools($unencryptedMediaID); $thumb = $mediaInfo->getThumbInfoFromDB(); $sample = $mediaInfo->getSampleInfoFromDB(); if ($media['dsp_type'] == 'video') { if ($video = $mediaInfo->getVidSampleInfoFromDB()) { $videoCheck = $mediaInfo->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']; }