}
//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':
$mediaCredits = getMediaCredits($media);
// 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;
$digital['credits'] = defaultCredits($dsp['credits']);
$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'];
$mediaCredits = getMediaCredits($media);
// 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;
*/
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'];
