//print_r($productCustomizedIDs); exit; // Now that we have the product ID array select the products that the customer has access to and assign them to smarty $productsResult = mysqli_query($db, "\r\n\t\t\t\t\tSELECT *\r\n\t\t\t\t\tFROM {$dbinfo[pre]}products\r\n\t\t\t\t\tLEFT JOIN {$dbinfo[pre]}perms\r\n\t\t\t\t\tON ({$dbinfo[pre]}products.prod_id = {$dbinfo[pre]}perms.item_id AND {$dbinfo[pre]}perms.perm_area = 'products') \r\n\t\t\t\t\tWHERE ({$dbinfo[pre]}products.prod_id IN ({$productIDsArrayFlat}) OR {$dbinfo[pre]}products.all_galleries = 1) \r\n\t\t\t\t\tAND {$dbinfo[pre]}products.active = 1 \r\n\t\t\t\t\tAND {$dbinfo[pre]}products.deleted = 0\r\n\t\t\t\t\tAND ({$dbinfo[pre]}products.everyone = 1 OR {$dbinfo[pre]}perms.perm_value IN ({$memberPermissionsForDB}))\r\n\t\t\t\t\tORDER BY {$dbinfo[pre]}products.sortorder\r\n\t\t\t\t\t"); if ($returnRows = mysqli_num_rows($productsResult)) { while ($product = mysqli_fetch_array($productsResult)) { $product['price'] = defaultPrice($product['price']); // Make sure to assign a default price if needed $product['credits'] = defaultCredits($product['credits']); // Make sure to assign default credits if needed /* * Custom Pricing calculations */ if (@in_array($product['prod_id'], $productCustomizedIDs)) { $product['price_calc'] = $customProduct[$product['prod_id']]['price_calc']; $product['price'] = defaultPrice($customProduct[$product['prod_id']]['price']); $product['credits'] = defaultCredits($customProduct[$product['prod_id']]['credits']); $product['credits_calc'] = $customProduct[$product['prod_id']]['credits_calc']; $product['quantity'] = $customProduct[$product['prod_id']]['quantity']; } /* * Advanced Pricing calculations */ switch ($product['price_calc']) { case 'add': $product['price'] = $mediaPrice + $product['price']; break; case 'sub': $product['price'] = $mediaPrice - $product['price']; break; case 'mult': $product['price'] = $mediaPrice * $product['price'];
// Get the media credits based on the license $product['price'] = defaultPrice($product['price']); // Make sure to assign a default price if needed $product['credits'] = defaultCredits($product['credits']); // Make sure to assign default credits if needed /* * Custom Pricing calculations */ $mediaProductsResult = mysqli_query($db, "SELECT * FROM {$dbinfo[pre]}media_products WHERE media_id = '{$mediaID}' AND prod_id = '{$id}'"); // Find if this has a customization if (mysqli_num_rows($mediaProductsResult)) { $mediaProduct = mysqli_fetch_array($mediaProductsResult); if ($mediaProduct['customized']) { $product['price_calc'] = $mediaProduct['price_calc']; $product['price'] = defaultPrice($mediaProduct['price']); $product['credits'] = defaultCredits($mediaProduct['credits']); $product['credits_calc'] = $mediaProduct['credits_calc']; $product['quantity'] = $mediaProduct['quantity']; } } /* * Advanced Pricing calculations */ switch ($product['price_calc']) { case 'add': $product['price'] = $mediaPrice + $product['price']; break; case 'sub': $product['price'] = $mediaPrice - $product['price']; break; case 'mult':
$digital['credits_calc'] = $dsp['credits_calc']; $digital['quantity'] = $dsp['quantity']; $digital['quantityText'] = $dsp['quantity']; $digital['customized'] = true; $digital['customizeID'] = $dsp['mds_id']; $digital['useCustomizeID'] = $config['EncryptIDs'] ? k_encrypt($dsp['mds_id']) : $dsp['mds_id']; $digital['license'] = $dsp['license']; $digital['width'] = $dsp['width'] ? $dsp['width'] : $digital['width']; $digital['height'] = $dsp['height'] ? $dsp['height'] : $digital['height']; $digital['format'] = $dsp['format'] ? $dsp['format'] : $digital['format']; $digital['running_time'] = $dsp['running_time'] ? $dsp['running_time'] : $digital['running_time']; $digital['hd'] = $dsp['hd']; $digital['fps'] = $dsp['fps'] ? $dsp['fps'] : $digital['fps']; } else { $digital['price'] = defaultPrice($digital['price']); $digital['credits'] = defaultCredits($digital['credits']); $digital['quantity'] = '1000000'; // Unlimited $digital['quantityText'] = $lang['unlimited']; $digital['customizeID'] = 0; $digital['useCustomizeID'] = $config['EncryptIDs'] ? k_encrypt(0) : 0; $digital['customized'] = false; } //echo $digital['license']; exit; /* * Advanced Pricing calculations */ switch ($digital['price_calc']) { case 'add': $digital['price'] = $mediaPrice + $digital['price']; break;
// Get the media credits based on the license $print['price'] = defaultPrice($print['price']); // Make sure to assign a default price if needed $print['credits'] = defaultCredits($print['credits']); // Make sure to assign default credits if needed /* * Custom Pricing calculations */ $mediaPrintsResult = mysqli_query($db, "SELECT * FROM {$dbinfo[pre]}media_prints WHERE media_id = '{$mediaID}' AND print_id = '{$id}'"); // Find if this has a customization if (mysqli_num_rows($mediaPrintsResult)) { $mediaPrint = mysqli_fetch_array($mediaPrintsResult); if ($mediaPrint['customized']) { $print['price_calc'] = $mediaPrint['price_calc']; $print['price'] = defaultPrice($mediaPrint['price']); $print['credits'] = defaultCredits($mediaPrint['credits']); $print['credits_calc'] = $mediaPrint['credits_calc']; $print['quantity'] = $mediaPrint['quantity']; } } /* * Advanced Pricing calculations */ switch ($print['price_calc']) { case 'add': $print['price'] = $mediaPrice + $print['price']; break; case 'sub': $print['price'] = $mediaPrice - $print['price']; break; case 'mult':
if ($longestDigitalSizeSide <= $media['width'] or $longestDigitalSizeSide <= $media['height']) { $validSize = true; } else { $validSize = false; } // Make sure that this size is big enough to list or if force list is in effect if ($validSize == true or $digital['force_list']) { //echo "id".$digital['ds_id']." {$longestDigitalSizeSide} <= ({$media[width]} or {$media[height]})".'<br>'; //echo $digital['ds_id'].'yes<br>'; /* * Custom Pricing calculations */ if (@in_array($digital['ds_id'], $digitalCustomizedIDs)) { $digital['price_calc'] = $customDigitalItems[$digital['ds_id']]['price_calc']; $digital['price'] = defaultPrice($customDigitalItems[$digital['ds_id']]['price']); $digital['credits'] = defaultCredits($customDigitalItems[$digital['ds_id']]['credits']); $digital['credits_calc'] = $customDigitalItems[$digital['ds_id']]['credits_calc']; $digital['quantity'] = $customDigitalItems[$digital['ds_id']]['quantity']; $digital['customized'] = true; $digital['customizeID'] = $customDigitalItems[$digital['ds_id']]['mds_id']; //print_r($customDigitalItems); //echo $customDigitalItems[$digital['ds_id']]['license']; // License $licenseResult = mysqli_query($db, "SELECT * FROM {$dbinfo[pre]}licenses WHERE license_id = '" . $customDigitalItems[$digital['ds_id']]['license'] . "'"); $license = mysqli_fetch_assoc($licenseResult); $digital = array_merge($digital, $license); // Merge the digital profile and license $digital['license'] = $license['lic_purchase_type']; $digital['licenseLang'] = $license['lic_name_' . $selectedLanguage] ? $license['lic_name_' . $selectedLanguage] : $license['lic_name']; $digital['width'] = $customDigitalItems[$digital['ds_id']]['width'] ? $customDigitalItems[$digital['ds_id']]['width'] : $digital['width']; $digital['height'] = $customDigitalItems[$digital['ds_id']]['height'] ? $customDigitalItems[$digital['ds_id']]['height'] : $digital['height'];