$imageurl = "<img class='product_img' src='" . $product_image . "' border='0' >"; } elseif (is_file(BASE_URL . "/" . $prodimagedir . $product_image) && file_exists(BASE_URL . "/" . $prodimagedir . $product_image)) { $imageurl = "<img class='product_img' src='" . SITE_URL . "/" . $prodimagedir . $product_image . "' border='0' >"; } else { $imageurl = "<img class='product_img' src='" . SITE_URL . "/" . $prodimagedir . "noimage.jpg' >"; } } if (strlen($row["product_name"]) > 30) { $prd_name = stripslashes(substr($row["product_name"], 0, 30)); } else { $prd_name = stripslashes($row["product_name"]); } $price = $row['product_price']; $discountstr = ""; $currency_attributes = displayCurrencyType(); $conversionRate = ConvertedCurrencyRate($currency_attributes[2]); $converted_price = $price * $conversionRate; $discountprice = 0; if ($row["discount"] != "0") { $discountprice = $converted_price - $converted_price * $row["discount"] / 100; $discountprice = number_format($discountprice, 2, ".", ""); $discountstr = "<br>discount(" . $row["discount"] . "%)"; } $display_product_price = number_format($converted_price, 2, ".", ""); $no_margin_class = $count_row == $cells ? 'nomargin' : ''; ?> <div class="pcm_productitem <?php echo $no_margin_class; ?> ">
function getUserCurrencyCartTotal($userid) { global $tableprefix; $currency_attributes = displayCurrencyType(); $sql = "SELECT c.*, (p.product_price+po.additional_price) AS product_price,p.product_artist_id,po.discount\n 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 WHERE c.user_id = '" . addslashes($userid) . "' "; $result = mysql_query($sql); $total = 0; $itemcount = 0; $currency_attributes = displayCurrencyType(); if (mysql_num_rows($result) != 0) { while ($row = mysql_fetch_array($result)) { $conversionRate = ConvertedCurrencyRate($currency_attributes[2]); $converted_price = $row['product_price'] * $conversionRate; $rate = $converted_price; $qty = $row["quantity"]; $price = $qty * $rate; $discountstr = ""; $discountprice = 0; if ($row["discount"] != "0") { $price = number_format($price, 2, ".", ""); $discountprice = $rate - $rate * $row["discount"] / 100; $discountprice = number_format($discountprice, 2, ".", ""); $discountrate = $discountprice * $qty; $price = $discountrate; } $total += $price; } } return $total; }