main_id!=0) { $navigation_main_active=$r_cat->main_id; } else { $navigation_main_active=$r_cat->id; } $r1 = mysql_fetch_object(mysql_query("SELECT * FROM shop_categories WHERE id='$r_cat->id' LIMIT 1")); // Get the Category ?> Herzliche Karten - <?php echo "$r1->description"; ?> description"; ?> von Herzliche Karten" />

description"; ?>

 

id' OR subcategory='$r1->id') AND active='1' ORDER BY level"; $e2 = mysql_query($a2); while($r2 = mysql_fetch_object($e2)) { // construct variables $fid1 = explode("|",$r2->formats); // Get the first format $cid1 = explode("|",$r2->color); // Get the first color description $cid1 = mysql_fetch_object(mysql_query("SELECT description FROM shop_products_colors WHERE id='$cid1[1]' LIMIT 1")); $cid1 = $cid1->description; $thisimgpath="/usr/www/users/herzli/katalog/_images/product_" . $r2->id . "_0_0"; echo "
description) . "/" . urlrewrite($r2->title) . "-" . $fid1[1] . "-" . urlrewrite($cid1) . ".html\">id . "_0_0." . imgext($thisimgpath) . "\" alt=\"$r2->title\" title=\"$r2->title\" />

 

"; // Get the format-id's $format_exp = explode("|",$r2->formats); $format_cnt = count($format_exp)-1; for($format_cum=1;$format_cum<$format_cnt;$format_cum++){ // Get the format $r21 = mysql_fetch_object(mysql_query("SELECT * FROM shop_products_formats WHERE id='$format_exp[$format_cum]' LIMIT 1")); $thisimgpath="/usr/www/users/herzli/katalog/_images/format_preview_" . $r21->id; echo "description) . "/" . urlrewrite($r2->title) . "-" . $r21->id . "-" . urlrewrite($cid1) . ".html\">id . "." . imgext($thisimgpath) . "\" alt=\"Formatvorschau\" title=\"Format offen: $r21->open | Format geschlossen: $r21->closed | Fotos: $r21->photos | Seiten: $r21->pages\" />  "; } echo "

"; // Get the color-id's $color_exp = explode("|",$r2->color); $color_cnt = count($color_exp)-1; for($color_cum=1;$color_cum<$color_cnt;$color_cum++){ // Get the colors $r21 = mysql_fetch_object(mysql_query("SELECT * FROM shop_products_colors WHERE id='$color_exp[$color_cum]' LIMIT 1")); $c21 = 0; if($r21->color1!="") {$c21++; $colorbg="$r21->color1";} if($r21->color2!="") {$c21++; $colorbg="$r21->color2";} if($r21->color3!="") {$c21++; $colorbg="$r21->color3";} if($r21->color4!="") {$c21++; $colorbg="$r21->color4";} if($r21->color5!="") {$c21++; $colorbg="$r21->color5";} if($r21->color6!="") {$c21++; $colorbg="$r21->color6";} if($r21->color7!="") {$c21++; $colorbg="$r21->color7";} if($r21->color8!="") {$c21++; $colorbg="$r21->color8";} if($r21->color9!="") {$c21++; $colorbg="$r21->color9";} if($r21->color10!=""){$c21++; $colorbg="$r21->color10";} echo "description) . "/" . urlrewrite($r2->title) . "-" . $fid1[1] . "-" . urlrewrite($r21->description) . ".html\" class=\"color\" title=\"Farboption "$r21->description"\" style=\"background:#$colorbg;\">"; if($r21->color1!="") {echo "color1;\">";} if($r21->color2!="") {echo "color2;\">";} if($r21->color3!="") {echo "color3;\">";} if($r21->color4!="") {echo "color4;\">";} if($r21->color5!="") {echo "color5;\">";} if($r21->color6!="") {echo "color6;\">";} if($r21->color7!="") {echo "color7;\">";} if($r21->color8!="") {echo "color8;\">";} if($r21->color9!="") {echo "color9;\">";} if($r21->color10!=""){echo "color10;\">";} echo " "; } echo "

 

 

"; // Get the prices $prices_exp = explode(",",$r2->prices); // array of first format $prices_prices_exp = explode("|",$prices_exp[1]); // array of first format prices $prices_prices_cnt = count($prices_prices_exp)-1; for($prices_prices_cum=1;$prices_prices_cum<$prices_prices_cnt;$prices_prices_cum++){ // Get the prices $r21 = mysql_fetch_object(mysql_query("SELECT * FROM shop_products_prices WHERE id='$prices_prices_exp[$prices_prices_cum]' LIMIT 1")); echo ""; } echo "

$r21->number Stück

ab " . number_format($r21->amount, 2, '.', '') . " €

 

description) . "/" . urlrewrite($r2->title) . "-" . $fid1[1] . "-" . urlrewrite($cid1) . ".html\" title=\"Mehr Infos über $r2->title\">weiter

"; } ?>