$cartItemsArray[$cartItem['oi_id']]['lineItemPriceTotal'] = $lineItemPriceTotal;
$cartItemsArray[$cartItem['oi_id']]['lineItemPriceTotalLocal'] = $lineItemPriceTotalLocal;
$cartItemsArray[$cartItem['oi_id']]['lineItemPriceEach'] = $lineItemPriceEach;
$cartItemsArray[$cartItem['oi_id']]['lineItemPriceEachLocal'] = $lineItemPriceEachLocal;
$cartItemsArray[$cartItem['oi_id']]['lineItemCreditsEach'] = $lineItemCreditsEach;
$cartItemsArray[$cartItem['oi_id']]['lineItemCreditsTotal'] = $lineItemCreditsTotal;
$cartItemsArray[$cartItem['oi_id']]['itemDetails'] = $collectionDetails;
$cartItemsArray[$cartItem['oi_id']]['itemTypeShort'] = 'coll';
break;
case "subscription":
$accountWorkbox = 1;
// Must require an account if this is a sub
$subscriptionResult = mysqli_query($db, "\r\n\t\t\t\t\t\t\tSELECT * FROM {$dbinfo[pre]}subscriptions \r\n\t\t\t\t\t\t\tWHERE sub_id = '{$cartItem[item_id]}'\r\n\t\t\t\t\t\t\t");
// Select subscription here
$subscription = mysqli_fetch_assoc($subscriptionResult);
$subscriptionDetails = subscriptionsList($subscription, 0);
$subscriptionDetails['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'];
// Set the payType to the item
$cartItemsArray[$cartItem['oi_id']]['payTypeCount'] = 0;
// Number of options available to pay
$numOfSubscriptions += $cartItem['quantity'];
// Count the number of subscriptions items in the cart
/*
* Currency
*/
$smarty->assign('featuredPromotionsRows',$returnRows);
$smarty->assign('featuredPromotions',$featuredPromotionsArray);
}
*/
} catch (Exception $e) {
die(exceptionError($e));
}
}
/*
* Get featured homepage subscriptions
*/
if ($config['settings']['hpsubs'] and $config['settings']['subscriptions']) {
try {
$featuredSubscriptionsResult = mysqli_query($db, "\r\n\t\t\t\tSELECT *\r\n\t\t\t\tFROM {$dbinfo[pre]}subscriptions \r\n\t\t\t\tLEFT JOIN {$dbinfo[pre]}perms\r\n\t\t\t\tON ({$dbinfo[pre]}subscriptions.sub_id = {$dbinfo[pre]}perms.item_id AND {$dbinfo[pre]}perms.perm_area = 'subscriptions') \r\n\t\t\t\tWHERE {$dbinfo[pre]}subscriptions.active = 1 \r\n\t\t\t\tAND {$dbinfo[pre]}subscriptions.homepage = 1 \r\n\t\t\t\tAND {$dbinfo[pre]}subscriptions.deleted = 0\r\n\t\t\t\tAND ({$dbinfo[pre]}subscriptions.everyone = 1 OR {$dbinfo[pre]}perms.perm_value IN ({$memberPermissionsForDB}))\r\n\t\t\t\tORDER BY {$dbinfo[pre]}subscriptions.sortorder\r\n\t\t\t\t");
while ($featuredSubscriptions = mysqli_fetch_assoc($featuredSubscriptionsResult)) {
$featuredSubscriptionsArray[] = subscriptionsList($featuredSubscriptions);
}
$smarty->assign('featuredSubscriptionsRows', count($featuredSubscriptionsArray));
$smarty->assign('featuredSubscriptions', $featuredSubscriptionsArray);
/*
if($returnRows = mysqli_num_rows($featuredSubscriptionsResult))
{
while($featuredSubscriptions = mysqli_fetch_assoc($featuredSubscriptionsResult))
$featuredSubscriptionsArray[] = subscriptionsList($featuredSubscriptions);
$smarty->assign('featuredSubscriptionsRows',$returnRows);
$smarty->assign('featuredSubscriptions',$featuredSubscriptionsArray);
}
*/
} catch (Exception $e) {
die(exceptionError($e));
* Get discounts
*/
$discountsResult = mysqli_query($db, "\r\n\t\t\t\tSELECT *\r\n\t\t\t\tFROM {$dbinfo[pre]}discount_ranges \r\n\t\t\t\tWHERE item_type = 'subscriptions' \r\n\t\t\t\tAND start_discount_number > 0\r\n\t\t\t\tAND item_id = '{$id}' \r\n\t\t\t\tORDER BY start_discount_number\r\n\t\t\t\t");
if ($discountReturnRows = mysqli_num_rows($discountsResult)) {
while ($discount = mysqli_fetch_array($discountsResult)) {
$discountsArray[$discount['dr_id']] = $discount;
}
$smarty->assign('discountRows', $discountReturnRows);
$smarty->assign('discountsArray', $discountsArray);
}
if ($edit) {
// We are editing this item
$smarty->assign('edit', k_encrypt($edit));
}
$subscription = mysqli_fetch_assoc($subscriptionResult);
$subscriptionArray = subscriptionsList($subscription);
if ($subscription['active'] == 1 and $subscription['deleted'] == 0) {
$smarty->assign('subscription', $subscriptionArray);
$smarty->assign('subscriptionRows', $returnRows);
} else {
$smarty->assign('noAccess', 1);
}
} else {
$smarty->assign('noAccess', 1);
}
$smarty->display('subscription.tpl');
// Smarty template
} catch (Exception $e) {
echo $e->getMessage();
}
if ($db) {
// Override page title, description, keywords and page encoding here
define('META_DESCRIPTION', '');
define('META_KEYWORDS', '');
define('PAGE_ENCODING', '');
require_once BASE_PATH . '/assets/includes/header.inc.php';
require_once BASE_PATH . '/assets/includes/errors.php';
try {
$memberID = $_SESSION['member']['mem_id'];
if (!$memberID) {
die('No member ID exists');
}
// Just to be safe make sure a memberID exists before continuing
$memsubResult = mysqli_query($db, "\r\n\t\t\tSELECT *\r\n\t\t\tFROM {$dbinfo[pre]}memsubs \r\n\t\t\tLEFT JOIN {$dbinfo[pre]}subscriptions \r\n\t\t\tON {$dbinfo[pre]}memsubs.sub_id = {$dbinfo[pre]}subscriptions.sub_id \r\n\t\t\tWHERE {$dbinfo[pre]}memsubs.mem_id = {$memberID}\r\n\t\t\t");
if ($returnRows = mysqli_num_rows($memsubResult)) {
while ($memsub = mysqli_fetch_array($memsubResult)) {
$memsubArray[$memsub['msub_id']] = subscriptionsList($memsub);
$memsubArray[$memsub['msub_id']]['expire_date_display'] = $customDate->showdate($memsub['expires'], 0);
if ($nowGMT > $memsub['expires']) {
$memsubArray[$memsub['msub_id']]['expired'] = true;
// See if the subscription is expired
$memsubArray[$memsub['msub_id']]['status_lang'] = 'expired';
} else {
$memsubArray[$memsub['msub_id']]['status_lang'] = 'active';
}
if ($memsub['perday']) {
$memsubArray[$memsub['msub_id']]['downloads_per_day'] = $memsub['perday'];
} else {
$memsubArray[$memsub['msub_id']]['downloads_per_day'] = 0;
}
// Unlimited
//$today = explode(" ",$nowGMT);
$collectionsResult = mysqli_query($db, "\r\n\t\t\t\t\tSELECT * \r\n\t\t\t\t\tFROM {$dbinfo[pre]}package_items \r\n\t\t\t\t\tLEFT JOIN {$dbinfo[pre]}collections \r\n\t\t\t\t\tON {$dbinfo[pre]}package_items.item_id = {$dbinfo[pre]}collections.coll_id\r\n\t\t\t\t\tWHERE {$dbinfo[pre]}collections.deleted='0' \r\n\t\t\t\t\tAND {$dbinfo[pre]}package_items.pack_id = '{$package[pack_id]}'\r\n\t\t\t\t\tAND {$dbinfo[pre]}package_items.item_type = 'coll'\r\n\t\t\t\t\tORDER BY {$dbinfo[pre]}collections.sortorder,{$dbinfo[pre]}collections.item_name\r\n\t\t\t\t\t");
if ($collectionRows = mysqli_num_rows($collectionsResult)) {
while ($collection = mysqli_fetch_array($collectionsResult)) {
$arrayNum++;
$collectionsArray[$arrayNum] = collectionsList($collection);
}
}
$smarty->assign('collections', $collectionsArray);
$smarty->assign('collectionRows', $collectionRows);
/*
* Subscriptions within the package
*/
$subscriptionsResult = mysqli_query($db, "\r\n\t\t\t\t\tSELECT * \r\n\t\t\t\t\tFROM {$dbinfo[pre]}package_items \r\n\t\t\t\t\tLEFT JOIN {$dbinfo[pre]}subscriptions \r\n\t\t\t\t\tON {$dbinfo[pre]}package_items.item_id = {$dbinfo[pre]}subscriptions.sub_id\r\n\t\t\t\t\tWHERE {$dbinfo[pre]}subscriptions.deleted='0' \r\n\t\t\t\t\tAND {$dbinfo[pre]}package_items.pack_id = '{$package[pack_id]}'\r\n\t\t\t\t\tAND {$dbinfo[pre]}package_items.item_type = 'sub'\r\n\t\t\t\t\tORDER BY {$dbinfo[pre]}subscriptions.sortorder,{$dbinfo[pre]}subscriptions.item_name\r\n\t\t\t\t\t");
if ($subscriptionRows = mysqli_num_rows($subscriptionsResult)) {
while ($subscription = mysqli_fetch_array($subscriptionsResult)) {
$subscriptionsArray[] = subscriptionsList($subscription);
}
}
$smarty->assign('subscriptions', $subscriptionsArray);
$smarty->assign('subscriptionRows', $subscriptionRows);
//$packageArray['options'] = getProductOptions('packages',$packageArray['pack_id']);
$smarty->assign('useMediaID', $useMediaID);
$smarty->assign('package', $packageArray);
$smarty->assign('packageRows', $returnRows);
$template = 'package.tpl';
} else {
$smarty->assign('noAccess', 1);
}
} else {
$smarty->assign('noAccess', 1);
}
