Hallo,
benutze den code für den Warenkorb wie schaffe ich das ich eine Auflistung erhalte welche Produkte in den Warenkorb sind ?
also
Position 1: Counter strike Preis: 0,99 € /mtl.
Code ist eig bekannt hänge ihn nochmal an wäre super wenn mir hier jemand helfen könnte.
<?php
if ($site_agecheck) {
echo '<div style="position:absolute;right:10px;top:10px;z-index:1000;"><a href="http://teklab.de/youth_protection.html" target="_blank"><img src="images/status/content-'.$site_agecheck.'.png" border="0"></a></div>';
}
mt_srand ((double)microtime()*1000000);
$maxran = 1000000;
$randomnum = mt_rand(0, $maxran);
/* BASKET CODE START */
$past = time()-6400;
$db->sql_query("DELETE FROM ".$prefix."_shop_basket WHERE time < '$past'");
$ip = $_SERVER["REMOTE_ADDR"];
$urow = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_shop_basket WHERE member='$memname'"));
if ($urow == "" OR !$urow) {
$memname = $member[1];
if (!isset($memname) OR $member[6] > 0) {
$memname = "$ip";
$guest = 1;
}
}
$vrow = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_shop_basket WHERE member='$memname'"));
if ($urow < $vrow OR $urow == "" OR !$urow) {
$urow = $vrow;
}
$b = 0;
$counter = 0;
$totalprice = 0;
$basket = "";
$sql = "SELECT * FROM ".$prefix."_shop_basket WHERE member='$memname' ORDER BY time ASC";
$result = $db->sql_query($sql);
while($row = $db->sql_fetchrow($result)) {
$prodstats = $db->sql_fetchrow($db->sql_query("SELECT * FROM ".$prefix."_shop_products WHERE id='$row[prodid]' AND active='1'"));
$prodpercent = 0;
$prodmoney = 0;
$counter++;
$prodvari = preg_replace('/\r\n|\r|\n/', "{TD}", $row[prodvari]);
$prodvari = explode("{TD}",$prodvari);
for ($j=0; $j<count($prodvari); $j++) {
$prodvaristats = $db->sql_fetchrow($db->sql_query("SELECT * FROM ".$prefix."_shop_prodvari WHERE id='$prodvari[$j]' AND active='1'"));
$varistats = $db->sql_fetchrow($db->sql_query("SELECT * FROM ".$prefix."_shop_variation WHERE id='$prodvaristats[varid]' AND active='1'"));
$varicatstats = $db->sql_fetchrow($db->sql_query("SELECT * FROM ".$prefix."_shop_varicat WHERE id='$varistats[catid]' AND active='1'"));
if ($varicatstats[paymonths] == 1) {
$paymonths = "$varistats[title]";
}
if ($varicatstats[onetime] == 0) {
$prodonetime = 0;
if ($varicatstats[status] == 1) {
$prodpercent = $prodpercent + $prodvaristats[monper];
}else{
if ($user_tax > 0) {
$prodvarimoney = $prodvaristats[monper] * 100 / ($global_localtax + 100);
$prodvarimoney = $prodvarimoney * ($user_tax + 100) / 100;
$prodvarimoney = number_format($prodvarimoney,2,".",".");
}else{
$prodvarimoney = $prodvaristats[monper];
}
$prodmoney = $prodmoney + $prodvarimoney;
}
}else{
$prodonetime = 1;
if ($varicatstats[status] == 1) {
$prodopercent = $prodopercent + $prodvaristats[monper];
}else{
if ($user_tax > 0) {
$prodovarimoney = $prodvaristats[monper] * 100 / ($global_localtax + 100);
$prodovarimoney = $prodovarimoney * ($user_tax + 100) / 100;
$prodovarimoney = number_format($prodovarimoney,2,".",".");
}else{
$prodovarimoney = $prodvaristats[monper];
}
$prodomoney = $prodomoney + $prodovarimoney;
}
}
}
if ($user_tax > 0) {
$baseprice = $prodstats[price] * 100 / ($global_localtax + 100);
$baseprice = $baseprice * ($user_tax + 100) / 100;
$baseprice = number_format($baseprice,2,".",".");
}else{
$baseprice = $prodstats[price];
}
$allprice = $baseprice + $prodmoney;
$allprice = $allprice * $prodpercent / 100 + $allprice;
$paymonths = explode(' ',$paymonths);
if ($paymonths[0] > 0) {
$allprice = $allprice * $paymonths[0];
}
if ($prodomoney != 0) {
$prodomoney = $prodomoney * $prodopercent / 100 + $prodomoney;
$allprice = $allprice + $prodomoney;
}
$alloprice = $prodomoney;
$allprice = $allprice * $row[prodcount];
$allprice = round($allprice,2);
$totalprice = $totalprice + $allprice;
}
if ($cmsoption[active] == 1 AND $cmsoption[currencycalc] > 0) {
$totalpricetwo = $totalprice * $cmsoption[currencycalc];
$totalprice = number_format($totalprice,2,",",".");
$totalpricetwo = number_format($totalpricetwo,2,",",".");
}else{
$totalprice = number_format($totalprice,2,",",".");
}
if ($language == "german" OR $language == "") {
$basket.= 'Artikel im Warenkorb: '.$urow.'<br>
Zwischensumme: '.$totalprice.' '.$cmsoption[short].'';
}else{
$basket.= 'Products: '.$urow.'<br>
Subtotal: '.$totalprice.' '.$cmsoption[short].'';
}
if ($cmsoption[active] == 1 AND $cmsoption[currencycalc] > 0) {
$basket.= ' / '.$totalpricetwo.' '.$cmsoption[shorttwo].'';
}
if ($language == "german" OR $language == "") {
$basket.= '';
}else{
$basket.= '<br><div class="small"><a href="modules.php?name=store&op=basket">Basket</a></div>';
}
/* BASKET CODE END */
?>
Alles anzeigen