* Collection gallery
*/
case "collection":
$collectionResult = mysqli_query($db, "\t\t\t\r\n\t\t\t\t\tSELECT SQL_CALC_FOUND_ROWS *\r\n\t\t\t\t\tFROM {$dbinfo[pre]}collections \r\n\t\t\t\t\tLEFT JOIN {$dbinfo[pre]}perms\r\n\t\t\t\t\tON ({$dbinfo[pre]}collections.coll_id = {$dbinfo[pre]}perms.item_id AND {$dbinfo[pre]}perms.perm_area = 'collections') \r\n\t\t\t\t\tWHERE {$dbinfo[pre]}collections.coll_id = {$_SESSION[id]}\r\n\t\t\t\t\tAND ({$dbinfo[pre]}collections.everyone = 1 OR {$dbinfo[pre]}perms.perm_value IN ({$memberPermissionsForDB}))\r\n\t\t\t\t");
if ($returnRows = getRows()) {
$collection = mysqli_fetch_array($collectionResult);
/*
// Update crumbs links
unset($_SESSION['crumbsSession']);
$newestMediaPageLink['page'] = "gallery.php?mode=newest-media&page=1";
$crumbs[0]['linkto'] = linkto($newestMediaPageLink); // Check for SEO
$crumbs[0]['name'] = $lang['newestMedia']; //
$_SESSION['crumbsSession'] = $crumbs; // Assign these to a session to be used elsewhere
*/
if ($collection['active'] == 1 and $collection['deleted'] == 0 and ($collection['quantity'] == '' or $collection['quantity'] > 0)) {
$collectionArray = collectionsList($collection);
$smarty->assign('collectionRows', $returnRows);
$smarty->assign('collection', $collectionArray);
// Update crumbs links
unset($_SESSION['crumbsSession']);
$collMediaPageLink['page'] = "gallery.php?mode=collection&id={$collectionArray[useCollectionID]}&page=1";
$crumbs[0]['linkto'] = linkto($collMediaPageLink);
// Check for SEO
$crumbs[0]['name'] = $collectionArray['name'];
//
$_SESSION['crumbsSession'] = $crumbs;
// Assign these to a session to be used elsewhere
if ($collection['colltype'] == 1) {
/* Only needed if we are checking active/inactive or expiration dates
$collectionGalleriesResult = mysqli_query($db,
"
}
$mediaCollectionsResult = mysqli_query($db, "SELECT coll_id FROM {$dbinfo[pre]}media_collections WHERE cmedia_id = '{$mediaID}'");
// Find collections this item is directly in
$mediaCollectionsRows = mysqli_num_rows($mediaCollectionsResult);
if ($mediaCollectionsRows) {
while ($mediaCollection = mysqli_fetch_array($mediaCollectionsResult)) {
$collectionIDs[] = $mediaCollection['coll_id'];
}
}
if ($collectionIDs) {
$collectionIDsFlat = implode(',', $collectionIDs);
$collectionsResult = mysqli_query($db, "\r\n\t\t\t\t\t\tSELECT *\r\n\t\t\t\t\t\tFROM {$dbinfo[pre]}collections \r\n\t\t\t\t\t\tLEFT JOIN {$dbinfo[pre]}perms\r\n\t\t\t\t\t\tON ({$dbinfo[pre]}collections.coll_id = {$dbinfo[pre]}perms.item_id AND {$dbinfo[pre]}perms.perm_area = 'collections') \r\n\t\t\t\t\t\tWHERE {$dbinfo[pre]}collections.active = 1 \r\n\t\t\t\t\t\tAND {$dbinfo[pre]}collections.deleted = 0\r\n\t\t\t\t\t\tAND ({$dbinfo[pre]}collections.everyone = 1 OR {$dbinfo[pre]}perms.perm_value IN ({$memberPermissionsForDB}))\r\n\t\t\t\t\t\tAND ({$dbinfo[pre]}collections.quantity = '' OR {$dbinfo[pre]}collections.quantity > '0') \r\n\t\t\t\t\t\tAND {$dbinfo[pre]}collections.coll_id IN ({$collectionIDsFlat})\r\n\t\t\t\t\t\tORDER BY {$dbinfo[pre]}collections.sortorder\r\n\t\t\t\t\t\t");
// Select collections that member has access to
if ($returnRows = mysqli_num_rows($collectionsResult)) {
while ($collections = mysqli_fetch_array($collectionsResult)) {
$collectionsArray[$collections['coll_id']] = collectionsList($collections);
$collectionsWithAccess[] = $collections['coll_id'];
}
$smarty->assign('collectionRows', $returnRows);
$smarty->assign('collections', $collectionsArray);
}
}
/*
* Packages *****************************************************************************************************************************
*/
/*
$galleryPackagesResult = mysqli_query($db,
"
SELECT *
FROM {$dbinfo[pre]}packages
WHERE all_galleries = 1
$smarty->assign('featuredPackagesRows',$returnRows);
$smarty->assign('featuredPackages',$featuredPackagesArray);
}
*/
} catch (Exception $e) {
die(exceptionError($e));
}
}
/*
* Get featured homepage collections
*/
if ($config['settings']['hpcolls']) {
try {
$featuredCollectionsResult = mysqli_query($db, "\r\n\t\t\t\tSELECT *\r\n\t\t\t\tFROM {$dbinfo[pre]}collections \r\n\t\t\t\tLEFT JOIN {$dbinfo[pre]}perms\r\n\t\t\t\tON ({$dbinfo[pre]}collections.coll_id = {$dbinfo[pre]}perms.item_id AND {$dbinfo[pre]}perms.perm_area = 'collections') \r\n\t\t\t\tWHERE {$dbinfo[pre]}collections.active = 1 \r\n\t\t\t\tAND {$dbinfo[pre]}collections.homepage = 1 \r\n\t\t\t\tAND {$dbinfo[pre]}collections.deleted = 0\r\n\t\t\t\tAND ({$dbinfo[pre]}collections.everyone = 1 OR {$dbinfo[pre]}perms.perm_value IN ({$memberPermissionsForDB}))\r\n\t\t\t\tAND ({$dbinfo[pre]}collections.quantity = '' OR {$dbinfo[pre]}collections.quantity > '0')\r\n\t\t\t\tORDER BY {$dbinfo[pre]}collections.sortorder\r\n\t\t\t\t");
while ($featuredCollections = mysqli_fetch_assoc($featuredCollectionsResult)) {
$featuredCollectionsArray[] = collectionsList($featuredCollections);
}
$smarty->assign('featuredCollectionsRows', count($featuredCollectionsArray));
$smarty->assign('featuredCollections', $featuredCollectionsArray);
/*
if($returnRows = mysqli_num_rows($featuredCollectionsResult))
{
while($featuredCollections = mysqli_fetch_assoc($featuredCollectionsResult))
$featuredCollectionsArray[] = collectionsList($featuredCollections);
$smarty->assign('featuredCollectionsRows',$returnRows);
$smarty->assign('featuredCollections',$featuredCollectionsArray);
}
*/
} catch (Exception $e) {
die(exceptionError($e));
$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'] = $packageDetails;
$cartItemsArray[$cartItem['oi_id']]['itemTypeShort'] = 'pack';
// Update prices and credits for invoice item in the db
mysqli_query($db, "\r\n\t\t\t\t\t\t\tUPDATE {$dbinfo[pre]}invoice_items SET \r\n\t\t\t\t\t\t\tprice_total='{$lineItemPriceTotal}',\r\n\t\t\t\t\t\t\tprice='{$lineItemPriceEach}',\r\n\t\t\t\t\t\t\tcredits_total='{$lineItemCreditsTotal}',\r\n\t\t\t\t\t\t\tcredits='{$lineItemCreditsEach}'\r\n\t\t\t\t\t\t\tWHERE oi_id = '{$cartItem[oi_id]}'\r\n\t\t\t\t\t\t");
break;
case "collection":
$collectionResult = mysqli_query($db, "\r\n\t\t\t\t\t\t\tSELECT * FROM {$dbinfo[pre]}collections \r\n\t\t\t\t\t\t\tWHERE coll_id = '{$cartItem[item_id]}'\r\n\t\t\t\t\t\t\t");
// Select collection here
$collection = mysqli_fetch_assoc($collectionResult);
$collectionDetails = collectionsList($collection, 0);
$collectionDetails['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
$numOfCollections += $cartItem['quantity'];
// Count the number of collection items in the cart
/*
* Currency
*/
}
}
}
}
}
}
$smarty->assign('products', $productsArray);
$smarty->assign('productRows', $productRows);
/*
* Collections within the package
*/
$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);
