/**
* @return array
*/
function cartGetCartContent()
{
$cart_content = array();
$total_price = 0;
$freight_cost = 0;
$variants = '';
$currencyEntry = Currency::getSelectedCurrencyInstance();
$customerEntry = Customer::getAuthedInstance();
if (!is_null($customerEntry)) {
//get cart content from the database
$q = db_phquery('
SELECT t3.*, t1.itemID, t1.Quantity, t1.sample, t4.thumbnail FROM ?#SHOPPING_CARTS_TABLE t1
LEFT JOIN ?#SHOPPING_CART_ITEMS_TABLE t2 ON t1.itemID=t2.itemID
LEFT JOIN ?#PRODUCTS_TABLE t3 ON t2.productID=t3.productID
LEFT JOIN ?#PRODUCT_PICTURES t4 ON t3.default_picture=t4.photoID
WHERE customerID=?', $customerEntry->customerID);
while ($cart_item = db_fetch_assoc($q)) {
// get variants
$variants = GetConfigurationByItemId($cart_item["itemID"]);
LanguagesManager::ml_fillFields(PRODUCTS_TABLE, $cart_item);
if (isset($cart_item["sample"]) && $cart_item["sample"] == 1) {
$q_sample_price = db_phquery('SELECT sample_price FROM SC_categories WHERE categoryID=(SELECT categoryID FROM SC_products WHERE productID=?)', $cart_item["productID"]);
$sample_price = db_fetch_assoc($q_sample_price);
$costUC = $sample_price["sample_price"];
$quantity = 1;
$free_shipping = 1;
} else {
$costUC = GetPriceProductWithOption($variants, $cart_item["productID"]);
$quantity = $cart_item["Quantity"];
$free_shipping = $cart_item["free_shipping"];
}
$tmp = array("productID" => $cart_item["productID"], "slug" => $cart_item["slug"], "id" => $cart_item["itemID"], "name" => $cart_item["name"], 'thumbnail_url' => $cart_item['thumbnail'] && file_exists(DIR_PRODUCTS_PICTURES . '/' . $cart_item['thumbnail']) ? URL_PRODUCTS_PICTURES . '/' . $cart_item['thumbnail'] : '', "brief_description" => $cart_item["brief_description"], "quantity" => $quantity, "free_shipping" => $free_shipping, "costUC" => $costUC, "product_priceWithUnit" => show_price($costUC), "cost" => show_price($quantity * $costUC), "product_code" => $cart_item["product_code"]);
if ($tmp['thumbnail_url']) {
list($thumb_width, $thumb_height) = getimagesize(DIR_PRODUCTS_PICTURES . '/' . $cart_item['thumbnail']);
list($tmp['thumbnail_width'], $tmp['thumbnail_height']) = shrink_size($thumb_width, $thumb_height, round(CONF_PRDPICT_THUMBNAIL_SIZE / 2), round(CONF_PRDPICT_THUMBNAIL_SIZE / 2));
}
$freight_cost += $cart_item["Quantity"] * $cart_item["shipping_freight"];
$strOptions = GetStrOptions(GetConfigurationByItemId($tmp["id"]));
if (trim($strOptions) != "") {
$tmp["name"] .= " (" . $strOptions . ")";
}
if (isset($cart_item["sample"]) && $cart_item["sample"] == 1) {
$tmp["name"] .= " [SAMPLE]";
}
if ($cart_item["min_order_amount"] > $cart_item["Quantity"]) {
$tmp["min_order_amount"] = $cart_item["min_order_amount"];
}
if ($cart_item["min_order_amount"] > 1 && $cart_item["Quantity"] % $cart_item["min_order_amount"] != 0) {
$tmp["multiplicity"] = $cart_item["min_order_amount"];
}
if (isset($cart_item["sample"]) && $cart_item["sample"] == 1) {
unset($tmp["min_order_amount"]);
unset($tmp["multiplicity"]);
$tmp["sample"] = 1;
}
$total_price += $quantity * $costUC;
$cart_content[] = $tmp;
}
} else {
//unauthorized user - get cart from session vars
$total_price = 0;
//total cart value
$cart_content = array();
//shopping cart items count
if (isset($_SESSION["gids"])) {
for ($j = 0; $j < count($_SESSION["gids"]); $j++) {
if ($_SESSION["gids"][$j]) {
$session_items[] = CodeItemInClient($_SESSION["configurations"][$j], $_SESSION["gids"][$j]);
$q = db_phquery("SELECT t1.*, p1.thumbnail FROM ?#PRODUCTS_TABLE t1 LEFT JOIN ?#PRODUCT_PICTURES p1 ON t1.default_picture=p1.photoID WHERE t1.productID=?", $_SESSION["gids"][$j]);
if ($r = db_fetch_row($q)) {
LanguagesManager::ml_fillFields(PRODUCTS_TABLE, $r);
if (isset($_SESSION["sample"][$j]) && $_SESSION["sample"][$j] == 1) {
$q_sample_price = db_phquery('SELECT sample_price FROM SC_categories WHERE categoryID=(SELECT categoryID FROM SC_products WHERE productID=?)', $_SESSION["gids"][$j]);
$sample_price = db_fetch_assoc($q_sample_price);
$costUC = $sample_price["sample_price"];
$quantity = 1;
$free_shipping = 1;
} else {
$costUC = GetPriceProductWithOption($_SESSION["configurations"][$j], $_SESSION["gids"][$j]);
$quantity = $_SESSION["counts"][$j];
$free_shipping = $r["free_shipping"];
}
$id = $_SESSION["gids"][$j];
if (count($_SESSION["configurations"][$j]) > 0) {
for ($tmp1 = 0; $tmp1 < count($_SESSION["configurations"][$j]); $tmp1++) {
$id .= "_" . $_SESSION["configurations"][$j][$tmp1];
}
}
$tmp = array("productID" => $_SESSION["gids"][$j], "slug" => $r['slug'], "id" => $id, "name" => $r['name'], 'thumbnail_url' => $r['thumbnail'] && file_exists(DIR_PRODUCTS_PICTURES . '/' . $r['thumbnail']) ? URL_PRODUCTS_PICTURES . '/' . $r['thumbnail'] : '', "brief_description" => $r["brief_description"], "quantity" => $quantity, "free_shipping" => $free_shipping, "costUC" => $costUC, "product_priceWithUnit" => show_price($costUC), "cost" => show_price($costUC * $quantity));
if ($tmp['thumbnail_url']) {
list($thumb_width, $thumb_height) = getimagesize(DIR_PRODUCTS_PICTURES . '/' . $r['thumbnail']);
list($tmp['thumbnail_width'], $tmp['thumbnail_height']) = shrink_size($thumb_width, $thumb_height, round(CONF_PRDPICT_THUMBNAIL_SIZE / 2), round(CONF_PRDPICT_THUMBNAIL_SIZE / 2));
}
$strOptions = GetStrOptions($_SESSION["configurations"][$j]);
if (trim($strOptions) != "") {
$tmp["name"] .= " (" . $strOptions . ")";
}
if (isset($_SESSION["sample"][$j]) && $_SESSION["sample"][$j] == 1) {
$tmp["name"] .= " [SAMPLE]";
}
$q_product = db_query("select min_order_amount, shipping_freight from " . PRODUCTS_TABLE . " where productID=" . $_SESSION["gids"][$j]);
$product = db_fetch_row($q_product);
if ($product["min_order_amount"] > $_SESSION["counts"][$j]) {
$tmp["min_order_amount"] = $product["min_order_amount"];
}
if ($product["min_order_amount"] > 1 && $_SESSION["counts"][$j] % $product["min_order_amount"] != 0) {
$tmp["multiplicity"] = $product["min_order_amount"];
}
if (isset($_SESSION["sample"][$j]) && $_SESSION["sample"][$j] == 1) {
unset($tmp["min_order_amount"]);
unset($tmp["multiplicity"]);
$tmp["sample"] = 1;
}
$freight_cost += $_SESSION["counts"][$j] * $product["shipping_freight"];
$cart_content[] = $tmp;
if (isset($_SESSION["sample"][$j]) && $_SESSION["sample"][$j] == 1) {
$q_sample_price = db_phquery('SELECT sample_price FROM SC_categories WHERE categoryID=(SELECT categoryID FROM SC_products WHERE productID=?)', $_SESSION["gids"][$j]);
$sample_price = db_fetch_assoc($q_sample_price);
$total_price += $sample_price["sample_price"];
} else {
$total_price += GetPriceProductWithOption($_SESSION["configurations"][$j], $_SESSION["gids"][$j]) * $_SESSION["counts"][$j];
}
}
}
}
}
}
return array("cart_content" => $cart_content, "total_price" => $total_price, "freight_cost" => $freight_cost);
}
FROM ' . SHOPPING_CARTS_TABLE . '
WHERE customerID= ' . regGetIdByLogin($_SESSION['log']);
$q = db_query($sql);
unset($_SESSION['special_set']['cart']);
while ($row = db_fetch_row($q)) {
$sql = '
SELECT
productID
FROM ' . SHOPPING_CART_ITEMS_TABLE . '
WHERE itemID=' . $row['itemID'];
$q1 = db_query($sql);
$r1 = db_fetch_row($q1);
if ($r1['productID']) {
$_SESSION['special_set']['cart'][] = $r1['productID'];
$variants = GetConfigurationByItemId($row['itemID']);
$k += GetPriceProductWithOption($variants, $r1['productID']) * $row['Quantity'];
$cnt += $row['Quantity'];
}
}
} else {
//...session vars
if (isset($_SESSION['gids'])) {
$_SESSION['special_set']['cart'] = array_unique($_SESSION['gids']);
for ($i = 0; $i < count($_SESSION['gids']); $i++) {
if ($_SESSION['gids'][$i]) {
$sql = '
SELECT
Price
FROM ' . PRODUCTS_TABLE . '
WHERE productID=' . (int) $_SESSION['gids'][$i];
$t = db_query($sql);
function _moveSessionCartContentToOrderedCart($orderID, $paymentMethodID)
{
$i = 0;
$sql = 'DELETE FROM ' . ORDERED_CARTS_TABLE . ' WHERE orderID=' . (int) $orderID;
db_query($sql);
foreach ($_SESSION['gids'] as $productID) {
if ($productID == 0) {
$i++;
continue;
}
$q = db_query('select count(*) from ' . PRODUCTS_TABLE . ' where productID=' . (int) $productID);
$row = db_fetch_row($q);
if ($row[0] == 0) {
$i++;
continue;
}
// create new item
db_query('insert into ' . SHOPPING_CART_ITEMS_TABLE . '(productID) values("' . (int) $productID . '")');
$itemID = db_insert_id();
foreach ($_SESSION['configurations'][$i] as $vars) {
db_query('insert into ' . SHOPPING_CART_ITEMS_CONTENT_TABLE . '(itemID, variantID) ' . 'values( "' . (int) $itemID . '', '' . (int) $vars . '")');
}
$q_product = db_query('select name, Price, product_code, opt_margin from ' . PRODUCTS_TABLE . ' where productID=' . (int) $productID);
$product = db_fetch_row($q_product);
$quantity = $_SESSION['counts'][$i];
$variants = array();
foreach ($_SESSION['configurations'][$i] as $vars) {
$variants[] = $vars;
}
$options = GetStrOptions($variants);
$productComplexName = $options != '' ? $product['name'] . '(' . $options . ')' : $product['name'];
if (strlen($product['product_code']) > 0) {
$productComplexName = '[' . $product['product_code'] . '] ' . $productComplexName;
}
$price = GetPriceProductWithOption($variants, $productID);
if (!empty($product['opt_margin']) && $paymentMethodID == 2) {
$price += $price / 100 * CONF_PERCENT_MARGIN;
}
$shippingAddress = array('countryID' => $_SESSION['receiver_countryID'], 'zoneID' => $_SESSION['receiver_zoneID']);
$billingAddress = array('countryID' => $_SESSION['billing_countryID'], 'zoneID' => $_SESSION['billing_zoneID']);
$tax = taxCalculateTax2($productID, $shippingAddress, $billingAddress);
$sql = '
INSERT INTO ' . ORDERED_CARTS_TABLE . '
SET
itemID = ' . (int) $itemID . ',
orderID=' . (int) $orderID . ',
name="' . xEscSQL($productComplexName) . '",
Price="' . xEscSQL($price) . '",
Quantity=' . (int) $quantity . ',
tax="' . xEscSQL($tax) . '"';
db_query($sql);
$i++;
}
unset($_SESSION['gids']);
unset($_SESSION['counts']);
unset($_SESSION['configurations']);
session_unregister('gids');
//calling session_unregister() is required since unset() may not work on some systems
session_unregister('counts');
session_unregister('configurations');
}
$variants = array();
if (!is_null($customerEntry)) {
//taking products from database
$q = db_phquery("SELECT itemID, Quantity, sample FROM ?#SHOPPING_CARTS_TABLE WHERE customerID=?", $customerEntry->customerID);
while ($row = db_fetch_assoc($q)) {
$q1 = db_query("select productID from " . SHOPPING_CART_ITEMS_TABLE . " where itemID='" . $row["itemID"] . "'");
$r1 = db_fetch_row($q1);
$variants = GetConfigurationByItemId($row["itemID"]);
if ($row["sample"]) {
$quantity = 1;
$q_sample_price = db_phquery('SELECT sample_price FROM SC_categories WHERE categoryID=(SELECT categoryID FROM SC_products WHERE productID=?)', $r1["productID"]);
$sample_price = db_fetch_assoc($q_sample_price);
$price = $sample_price["sample_price"];
} else {
$quantity = $row["Quantity"];
$price = GetPriceProductWithOption($variants, $r1["productID"]) * $quantity;
}
$k += $price;
$cnt += $quantity;
}
} elseif (isset($_SESSION["gids"])) {
//...session vars
for ($i = 0; $i < count($_SESSION["gids"]); $i++) {
if (!$_SESSION["gids"][$i]) {
continue;
}
$sum = db_phquery_fetch(DBRFETCH_FIRST, "SELECT Price FROM ?#PRODUCTS_TABLE WHERE productID=?", $_SESSION["gids"][$i]);
foreach ($_SESSION["configurations"][$i] as $var) {
$sum += db_phquery_fetch(DBRFETCH_FIRST, "SELECT price_surplus FROM ?#PRODUCTS_OPTIONS_SET_TABLE WHERE variantID=? AND productID=?", $var, $_SESSION["gids"][$i]);
}
if ($_SESSION["sample"][$i]) {
function cartGetCartContent()
{
$cart_content = array();
$total_price = 0;
$freight_cost = 0;
if (isset($_SESSION['log'])) {
//get cart content from the database
$sql = '
SELECT
itemID,
Quantity
FROM ' . SHOPPING_CARTS_TABLE . '
WHERE customerID=' . (int) regGetIdByLogin($_SESSION['log']);
$q = db_query($sql);
while ($cart_item = db_fetch_row($q)) {
// get variants
$variants = GetConfigurationByItemId($cart_item['itemID']);
// shopping cart item
$sql = '
SELECT
productID
FROM ' . SHOPPING_CART_ITEMS_TABLE . '
WHERE itemID=' . (int) $cart_item['itemID'];
$q_shopping_cart_item = db_query($sql);
$shopping_cart_item = db_fetch_row($q_shopping_cart_item);
$sql = '
SELECT
name,
productID,
min_order_amount,
shipping_freight,
free_shipping,
product_code,
categoryID,
opt_margin,
uri,
uri_opt_val
FROM ' . PRODUCTS_TABLE . '
WHERE productID=' . (int) $shopping_cart_item['productID'];
$q_products = db_query($sql);
if ($product = db_fetch_row($q_products)) {
$costUC = GetPriceProductWithOption($variants, $shopping_cart_item['productID']);
$tmp = array('productID' => $product['productID'], 'categoryID' => $product['categoryID'], 'uri' => $product['uri'], 'uri_opt_val' => $product['uri_opt_val'], 'id' => $cart_item['itemID'], 'name' => $product['name'], 'quantity' => $cart_item['Quantity'], 'free_shipping' => $product['free_shipping'], 'costUC' => $costUC, 'cost' => show_price($cart_item['Quantity'] * GetPriceProductWithOption($variants, $shopping_cart_item['productID'])), 'product_code' => $product['product_code'], 'opt_margin' => $product['opt_margin']);
$freight_cost += $cart_item['Quantity'] * $product['shipping_freight'];
$strOptions = GetStrOptions(GetConfigurationByItemId($tmp['id']));
if (trim($strOptions) != '') {
$tmp['name'] .= ' (' . $strOptions . ')';
}
if ($product['min_order_amount'] > $cart_item['Quantity']) {
$tmp['min_order_amount'] = $product['min_order_amount'];
}
$cart_content[] = $tmp;
$total_price += $cart_item['Quantity'] * GetPriceProductWithOption($variants, $shopping_cart_item['productID']);
}
}
} else {
//unauthorized user - get cart from session vars
$total_price = 0;
//total cart value
$cart_content = array();
//shopping cart items count
if (isset($_SESSION['gids'])) {
for ($j = 0; $j < count($_SESSION['gids']); $j++) {
if ($_SESSION['gids'][$j]) {
$session_items[] = CodeItemInClient($_SESSION['configurations'][$j], $_SESSION['gids'][$j]);
$sql = '
SELECT
name,
shipping_freight,
free_shipping,
product_code,
categoryID,
opt_margin,
uri,
uri_opt_val
FROM ' . PRODUCTS_TABLE . '
WHERE productID=' . (int) $_SESSION['gids'][$j];
$q = db_query($sql);
if ($r = db_fetch_row($q)) {
/* * $_SESSION['counts'][$j] */
$costUC = GetPriceProductWithOption($_SESSION['configurations'][$j], $_SESSION['gids'][$j]);
$id = $_SESSION['gids'][$j];
if (count($_SESSION['configurations'][$j]) > 0) {
for ($tmp1 = 0; $tmp1 < count($_SESSION['configurations'][$j]); $tmp1++) {
$id .= '_' . $_SESSION['configurations'][$j][$tmp1];
}
}
$tmp = array('productID' => $_SESSION['gids'][$j], 'categoryID' => $r['categoryID'], 'uri' => $r['uri'], 'uri_opt_val' => $r['uri_opt_val'], 'id' => $id, 'name' => $r[0], 'quantity' => $_SESSION['counts'][$j], 'free_shipping' => $r['free_shipping'], 'costUC' => $costUC, 'cost' => show_price($costUC * $_SESSION['counts'][$j]), 'product_code' => $r['product_code'], 'opt_margin' => $r['opt_margin']);
$strOptions = GetStrOptions($_SESSION['configurations'][$j]);
if (trim($strOptions) != '') {
$tmp['name'] .= ' (' . $strOptions . ')';
}
$sql = '
SELECT
min_order_amount,
shipping_freight,
categoryID,
uri,
uri_opt_val
FROM ' . PRODUCTS_TABLE . '
WHERE productID=' . (int) $_SESSION['gids'][$j];
$q_product = db_query($sql);
$product = db_fetch_row($q_product);
if ($product['min_order_amount'] > $_SESSION['counts'][$j]) {
$tmp['min_order_amount'] = $product['min_order_amount'];
}
$freight_cost += $_SESSION['counts'][$j] * $product['shipping_freight'];
$cart_content[] = $tmp;
$total_price += GetPriceProductWithOption($_SESSION['configurations'][$j], $_SESSION['gids'][$j]) * $_SESSION['counts'][$j];
}
}
}
}
}
return array('cart_content' => $cart_content, 'total_price' => $total_price, 'freight_cost' => $freight_cost);
}
/**
* @param int $orderID
* @param array $shipping_info - ('countryID','zoneID', 'zip')
* @param array $billing_info - ('countryID','zoneID', 'zip')
*/
function saveToOrderedCarts($orderID, $shipping_info, $billing_info, $calculate_tax = true)
{
$sql = "DELETE FROM ?#ORDERED_CARTS_TABLE WHERE orderID=?";
db_phquery($sql, $orderID);
$r_aItem = $this->Items->getChildNodes('item');
$tc = count($r_aItem);
for ($i = 0; $i < $tc; $i++) {
$aItem =& $r_aItem[$i];
/* @var $aItem xmlNodeX */
$aProduct =& $aItem->getFirstChildByName('product');
$productID = $aProduct->attribute('id');
db_phquery('INSERT ?#SHOPPING_CART_ITEMS_TABLE (productID) VALUES(?)', $productID);
$aItem->attribute('id', db_insert_id(SHOPPING_CART_ITEMS_TABLE));
//if(strpos($aItem->attribute('id'), '_') !== false){
// db_phquery('INSERT ?#SHOPPING_CART_ITEMS_TABLE (productID) VALUES(?)',$productID);
// $aItem->attribute('id', db_insert_id(SHOPPING_CART_ITEMS_TABLE));
$aVariants =& $aItem->getFirstChildByName('variants');
$r_aVariant = $aVariants->getChildrenByName('variant');
foreach ($r_aVariant as $aVariant) {
/* @var $aVariant xmlNodeX */
db_phquery('INSERT ?#SHOPPING_CART_ITEMS_CONTENT_TABLE (itemID, variantID)
VALUES(?,?)', $aItem->attribute('id'), $aVariant->attribute('id'));
}
//}
$dbq = '
SELECT ' . LanguagesManager::sql_prepareField('name') . ' AS name, product_code, categoryID FROM ?#PRODUCTS_TABLE WHERE productID=?
';
$q_product = db_phquery($dbq, $productID);
$product = db_fetch_row($q_product);
$productComplexName = '';
$aVariants =& $aItem->getFirstChildByName('variants');
$r_aVariant = $aVariants->getChildrenByName('variant');
$variants = array();
foreach ($r_aVariant as $aVariant) {
/* @var $aVariant xmlNodeX */
$variants[] = $aVariant->attribute('id');
}
$options = GetStrOptions($variants);
if ($options != "") {
$productComplexName = $product["name"] . " (" . $options . ")";
} else {
$productComplexName = $product["name"];
}
if ($product["product_code"]) {
$productComplexName = "[" . $product["product_code"] . "] " . $productComplexName;
}
$price = GetPriceProductWithOption($variants, $productID);
if ($aItem->getChildData('sample')) {
$productComplexName .= " [SAMPLE]";
$q_sample_price = db_phquery('SELECT sample_price FROM SC_categories WHERE categoryID=(SELECT categoryID FROM SC_products WHERE productID=?)', $productID);
$sample_price = db_fetch_assoc($q_sample_price);
$price = $sample_price["sample_price"];
$quantity = 1;
} else {
$quantity = $aItem->getChildData('quantity');
}
$tax = $calculate_tax ? taxCalculateTax2($productID, $shipping_info, $billing_info) : 0;
$dbq = '
INSERT ?#ORDERED_CARTS_TABLE (itemID, orderID, name, Price, Quantity, tax )
VALUES (?, ?, ?, ?, ?, ?)
';
db_phquery($dbq, $aItem->attribute('id'), $orderID, $productComplexName, $price, $quantity, $tax);
$q = db_phquery('SELECT statusID FROM ?#ORDERS_TABLE WHERE orderID=?', $orderID);
$order = db_fetch_row($q);
if ($order["statusID"] != ostGetCanceledStatusId() && CONF_CHECKSTOCK) {
$dbq = '
UPDATE ?#PRODUCTS_TABLE SET in_stock=in_stock-' . xEscapeSQLstring($quantity) . '
WHERE productID=?
';
db_phquery($dbq, $productID);
}
}
}
cartAddToCart((int) $_GET["addproduct"], $variants);
}
}
$resCart = cartGetCartContent();
$resDiscount = dscCalculateDiscount($resCart["total_price"], isset($_SESSION["log"]) ? $_SESSION["log"] : "");
$discount_value = addUnitToPrice($resDiscount["discount_current_unit"]);
$discount_percent = $resDiscount["discount_percent"];
$k = 0;
$cnt = 0;
if (isset($_SESSION["log"])) {
$q = db_query("select itemID, Quantity FROM " . SHOPPING_CARTS_TABLE . " WHERE customerID=" . (int) regGetIdByLogin($_SESSION["log"]));
while ($row = db_fetch_row($q)) {
$q1 = db_query("select productID from " . SHOPPING_CART_ITEMS_TABLE . " where itemID=" . (int) $row["itemID"]);
$r1 = db_fetch_row($q1);
$variants = GetConfigurationByItemId($row["itemID"]);
$k += GetPriceProductWithOption($variants, $r1["productID"]) * $row["Quantity"];
$cnt += $row["Quantity"];
}
} else {
if (isset($_SESSION["gids"])) {
for ($i = 0; $i < count($_SESSION["gids"]); $i++) {
if ($_SESSION["gids"][$i]) {
$t = db_query("select Price FROM " . PRODUCTS_TABLE . " WHERE productID=" . (int) $_SESSION["gids"][$i]);
$rr = db_fetch_row($t);
$sum = $rr["Price"];
// $rr["Price"]
foreach ($_SESSION["configurations"][$i] as $varconf) {
$q1 = db_query("select price_surplus from " . PRODUCTS_OPTIONS_SET_TABLE . " where variantID=" . (int) $varconf . " AND productID=" . (int) $_SESSION["gids"][$i]);
$r1 = db_fetch_row($q1);
$sum += $r1["price_surplus"];
}