$cartitems = "";
if (isset($_SESSION["sess_userid"]) and $_SESSION["sess_userid"] != "") {
$sql_cart = "SELECT c.*, p.product_name,(p.product_price+po.additional_price) AS product_price,po.discount,p.vdigital_product,p.product_id,p.product_artist_id,\n\t\t\t\t\t\t\t\tctry.gift_certificate_flag,p.fAdditionalItemCost,\n (SELECT pm.vimage_name FROM " . $tableprefix . "product_view_images pm where pm.nimage_productid=p.product_id LIMIT 0,1)AS smallimage\n\t\t\t\t\t\t FROM " . $tableprefix . "cart c\n INNER JOIN " . $tableprefix . "product_options po ON po.product_option_id = c.product_option_id\n INNER JOIN " . $tableprefix . "products p ON p.product_id = po.product_id\n INNER JOIN " . $tableprefix . "categories ctry ON ctry.category_id = p.product_category\n WHERE c.user_id = '" . addslashes($_SESSION["sess_userid"]) . "'";
} else {
$sql_cart = "SELECT c.*, p.product_name,(p.product_price+po.additional_price) AS product_price,po.discount,p.product_artist_id,p.fAdditionalItemCost,\n (SELECT pm.vimage_name FROM " . $tableprefix . "product_view_images pm where pm.nimage_productid=p.product_id LIMIT 0,1)AS smallimage\n\t\t\t\t\t\tFROM " . $tableprefix . "cart c \n INNER JOIN " . $tableprefix . "product_options po ON po.product_option_id = c.product_option_id\n INNER JOIN " . $tableprefix . "products p ON p.product_id = po.product_id\n WHERE c.visitor_cart_id = '" . addslashes(session_id()) . "' ";
}
$res_cart = mysql_query($sql_cart);
if (mysql_num_rows($res_cart) > 0) {
while ($rw_cart = mysql_fetch_array($res_cart)) {
if (isset($_SESSION["sess_userid"]) and $_SESSION["sess_userid"] != "") {
if ($rw_cart['vdigital_product'] == 'Y' || $rw_cart['gift_certificate_flag'] == 'Y') {
/*---------Checking if shipping is enable-----------*/
//$check_shipping_enable = checkShippingEnable();
//if($check_shipping_enable == "Y")
//{
cartClearDigital($_SESSION["sess_userid"]);
//}
/*---------Checking if shipping is enable-----------*/
}
}
$_SESSION['gift_certificate_flag'] = $rw_cart['gift_certificate_flag'];
}
}
if (isset($_SESSION["sess_userid"]) and $_SESSION["sess_userid"] != "") {
$sql = "SELECT c.*, p.product_category,p.product_name,(p.product_price+po.additional_price) AS product_price,po.discount,po.image_small,p.product_artist_id,po.product_stock,p.fAdditionalItemCost,p.eProductTaxExempt,\n (SELECT pm.vimage_name FROM " . $tableprefix . "product_view_images pm where pm.nimage_productid=p.product_id LIMIT 0,1)AS smallimage\n\t\t\t\t\tFROM " . $tableprefix . "cart c\n INNER JOIN " . $tableprefix . "product_options po ON po.product_option_id = c.product_option_id\n INNER JOIN " . $tableprefix . "products p ON p.product_id = po.product_id\n\t\t\t\t\tWHERE c.user_id = '" . addslashes($_SESSION["sess_userid"]) . "'";
} else {
$sql = "SELECT c.*,p.product_category, p.product_name,(p.product_price+po.additional_price) AS product_price,po.discount,po.image_small,p.product_artist_id,po.product_stock,p.fAdditionalItemCost,p.eProductTaxExempt,\n (SELECT pm.vimage_name FROM " . $tableprefix . "product_view_images pm where pm.nimage_productid=p.product_id LIMIT 0,1)AS smallimage\n\t\t\t\t\tFROM " . $tableprefix . "cart c\n INNER JOIN " . $tableprefix . "product_options po ON po.product_option_id = c.product_option_id\n INNER JOIN " . $tableprefix . "products p ON p.product_id = po.product_id\n WHERE c.visitor_cart_id = '" . addslashes(session_id()) . "' ";
}
//echo $sql;
$res = mysql_query($sql);
$res1 = mysql_query($sql);
}
if (isset($_SESSION["sess_affiliateid"]) and $_SESSION["sess_affiliateid"] != "") {
// Logging OutSeller from same window
session_unregister($_SESSION["sess_artistid"]);
}
// End check
/*---------------Multicart 2.0 Upgradation------------------*/
/*-------function call to manage the different sessions--------*/
manageSession(3);
/*---------------Multicart 2.0 Upgradation------------------*/
if (!isVisitorCartEmpty(session_id())) {
mergeVisitorCartToUserCart(session_id(), $row["user_id"]);
}
// Check Gift Products Exists in Cart // Then delete NON gift Products
if (checkGiftProductsExistsinCart($row["user_id"])) {
cartClearDigital($row["user_id"]);
}
if ($wishMessage == 'Product added successfully!') {
header("Location:" . SITE_URL . "/mywishlist.php");
exit;
}
if ($action != "") {
switch ($action) {
case "checkout":
header("Location:viewcart.php?action=checkout");
exit;
break;
case "postartistfeedback":
header("Location:postartistfeedback.php?artistid={$artistid}&productid={$productid}");
exit;
break;
$_SESSION["TAX_TOTAL"] += $_SESSION["TAX_DETAILS"][$product_option_id];
}
// End Tax
//=========================If rate per state is not activated and default rate is activated
$exchangeRate = getCurrencyrate($currency_attributes[2]);
//===========================================
if ($_SESSION["TAX_TOTAL"] != 0) {
// if tax rate is not null include tax rate
$taxrates = $_SESSION["TAX_TOTAL"];
}
$_SESSION['session_taxrate'] = $taxrates;
// if Gift Certificate Order placed
if (checkGiftProductsExistsinCart($userid)) {
$_SESSION['session_taxrate'] = '';
$_SESSION['SHIPPING_TOTAL'] = '';
cartClearDigital($userid);
}
//===============================End Tax Calulation===================================
/*function call to fetch details from site settings*/
//echo "hi".$_SESSION['SESS_digital_product'];exit;
if (!checkGiftProductsExistsinCart($userid)) {
if ($_SESSION['SESS_upscost'] != '') {
if ($_SESSION["sessBillingFirstName"] == '' || $_SESSION["sessBillingEmail"] == '' || $_SESSION["sessShippingFirstName"] == '' || $_SESSION["sessShippingEmail"] == '') {
$_SESSION["sess_addresses_collected"] = false;
header("Location:checkout.php");
exit;
}
}
}
$digital_product_count = digitalProductsCartCount($userid);
if ($digital_product_count == 1) {
