Loveley iVi-EyEeMail:
Passwort:

Warenkorb
"; //--------------------------------------------------------------------------------------- //---- Kategorie Header einblenden //---- JPG-HEADER if (file_exists("images/KatTitel-id$selAnl.jpg")) echo " "; ?> "; echo ""; } echo "

 
 
"; echo "
"; echo "
Bestimmte Anlässe:
"; //--- Anlass auswählen echo "Alle anzeigen
"; if (substr($selCat,-1)=="0") { $res_anlass_kat=mysql("$db","SELECT * FROM anlass_kategorie INNER JOIN anlass_name ON anlass_kategorie.anlass_kat_id=anlass_name.anlass_kat INNER JOIN anlass ON anlass.anlass_id=anlass_name.anlass_id INNER JOIN products ON products.products_id=anlass.products_id WHERE products.categories_id>'$selCat' AND products.categories_id < '".($selCat+10)."' GROUP BY anlass_kat_id;"); } else { $res_anlass_kat=mysql("$db","SELECT * FROM anlass_kategorie INNER JOIN anlass_name ON anlass_kategorie.anlass_kat_id=anlass_name.anlass_kat INNER JOIN anlass ON anlass.anlass_id=anlass_name.anlass_id INNER JOIN products ON products.products_id=anlass.products_id WHERE products.categories_id='$selCat' GROUP BY anlass_kat_id;"); } while($data_anlass_kat = mysql_fetch_array($res_anlass_kat, MYSQL_ASSOC)) { echo "
".$data_anlass_kat['anlass_kat_name']."
    "; $res_anlass=mysql("$db","SELECT anlass_name,anlass_name.anlass_id AS anlass_id FROM anlass_name INNER JOIN anlass ON anlass.anlass_id=anlass_name.anlass_id WHERE anlass_kat='".$data_anlass_kat['anlass_kat_id']."' GROUP BY anlass_name.anlass_id"); while($data_anlass = mysql_fetch_array($res_anlass, MYSQL_ASSOC)) { echo "
  • ".$data_anlass['anlass_name']."
  • "; } echo "
"; } echo "
Seite:"; // --- Seitenübersicht anzeigen for($i=1; $i<=$maxPages; $i++) { if ($i>1) echo " | "; if ($i==$pageNum) echo ""; echo "$i"; if ($i==$pageNum) echo ""; } ?>
 
 


"; $i=1; //--------------------------------------------------------------------------------------- //---- START AUSgabe der Produkte $cardNr=0; $multiFormat=0; if (substr($selCat,-1)=="0") $multiFormat=1; while ($pidData = mysql_fetch_array($results, MYSQL_ASSOC)) { if ($multiFormat>0) { $sql2="SELECT * FROM products INNER JOIN products_description ON products.products_id=products_description.products_id INNER JOIN products_options ON products.products_id=products_options.products_id WHERE products.categories_id > '$selCat' AND products.categories_id < '".($selCat+10)."' AND RIGHT(products.products_id,3)='".$pidData['pid']."' ORDER BY products.products_id ASC"; $resMultipleProducts=mysql("$db",$sql2); $data = mysql_fetch_array($resMultipleProducts, MYSQL_ASSOC); } else { $data=$pidData; } $cardNr++; // Make Thumbnails ------------------------------------------------ $bild=$data['products_large_img']; if ($bild<>"") { if (preg_match("/jpg+/i",$bild)) { $bild=strtok($bild,"."); $ext=strtok("."); $srcimg="$pimg_abs$bild.$ext"; $destimg="$pimg_th_abs$bild-$pthumbext_l.$ext"; $thumb_l="$pimg_th_rel$bild-$pthumbext_l.$ext"; if (!file_exists("$thumb_l")) { RatioResizeImg($srcimg, $pthumbwidth_l, $pthumbheight_l, $destimg,"watermark.png"); chmod($destimg,0777);} $destimg="$pimg_th_abs$bild-$pthumbext_m.$ext"; $thumb_m="$pimg_th_rel$bild-$pthumbext_m.$ext"; if (!file_exists("$thumb_m")) { RatioResizeImg($srcimg, $pthumbwidth_m, $pthumbheight_m, $destimg); chmod($destimg,0777);} } } $bild2=$data['products_large_img2']; if ($bild2<>"") { if (preg_match("/jpg+/i",$bild2)) { $bild2=strtok($bild2,"."); $ext=strtok("."); $srcimg2="$pimg_abs$bild2.$ext"; $destimg2="$pimg_th_abs$bild2-$pthumbext_l.$ext"; $thumb_l2="$pimg_th_rel$bild2-$pthumbext_l.$ext"; if (!file_exists("$thumb_l2")) { RatioResizeImg($srcimg2, $pthumbwidth_l, $pthumbheight_l, $destimg2,"watermark.png"); chmod($destimg2,0777);} $destimg2="$pimg_th_abs$bild2-$pthumbext_m.$ext"; $thumb_m2="$pimg_th_rel$bild2-$pthumbext_m.$ext"; if (!file_exists("$thumb_m2")) { RatioResizeImg($srcimg2, $pthumbwidth_m, $pthumbheight_m, $destimg2); chmod($destimg2,0777);} } } //------------------------------------------------------------------ echo "
"; //--- Farbliste laden $res_collist=mysql("$db","SELECT products_options.options_id, products_options.color_id, products_color.color_name, products_color.color_img FROM products_options INNER JOIN products_color ON products_options.color_id=products_color.color_id WHERE products_id='".$data['products_id']."' AND products_options.quantity>0 GROUP BY color_id;"); // die ("SELECT products_options.color_id, products_color.color_name FROM products_options INNER JOIN products_color ON products_options.color_id=products_color.color_id WHERE products_id='103' AND products_options.quantity>0 GROUP BY color_id;"); $collist = mysql_fetch_array($res_collist, MYSQL_ASSOC); if (!$col) $col=$collist['color_id']; //------------------------ //--Bild ausgeben echo "
"; if ($data['products_description']<>"") echo "
".$data['products_description']."
"; echo "
"; //--------------------------------------------------------------------------------------- //--- Nur ein Formate für ein Motiv if ($multiFormat==0) { echo " "; } //--------------------------------------------------------------------------------------- //--- Mehrere Formate für ein Motiv else { $weiter=1; while ($weiter==1) { if (!$data2 = mysql_fetch_array($resMultipleProducts, MYSQL_ASSOC)) $weiter=0; //$weiter=0; echo " "; if ($data['categories_id']=="1012") { echo ""; } $data=$data2; } } echo " "; /* Vergrößern | INFO
".$data['products_name']."
"; // Special Price ------------------------------------------------------------- if ($data['products_price']>0) { $res_special=mysql("$db","SELECT * FROM specials INNER JOIN specials_description ON specials.specials_description_id=specials_description.specials_description_id WHERE specials_from_date <= now() AND specials_to_date >= now() AND products_id='".$data['products_id']."' AND specials_description.language_id='".LANGUAGE."';"); if ($special = mysql_fetch_array($res_special, MYSQL_ASSOC)) { echo "Preis: € ".$data['products_price']."
".$special['specials_description'].": € ".$special['specials_new_price'].""; } else { echo "Preis: € ".$data['products_price']." ";} } if ($collist['color_id']==99) { echo ""; } echo "
"; if (check_status($data['products_status'],STAT_ORDER)) { echo "";} echo "
".constant("TXT_".$data['categories_id'])."
"; // Special Price ------------------------------------------------------------- if ($data['products_price']>0) { $res_special=mysql("$db","SELECT * FROM specials INNER JOIN specials_description ON specials.specials_description_id=specials_description.specials_description_id WHERE specials_from_date <= now() AND specials_to_date >= now() AND products_id='".$data['products_id']."' AND specials_description.language_id='".LANGUAGE."';"); if ($special = mysql_fetch_array($res_special, MYSQL_ASSOC)) { echo "Preis: € ".$data['products_price']."
".$special['specials_description'].": € ".$special['specials_new_price'].""; } else { echo "Preis: € ".$data['products_price']." ";} } if ($collist['color_id']==99) { echo ""; } echo "
"; if (check_status($data['products_status'],STAT_ORDER)) { echo "";} echo "
 
".$data['products_description']."
"; if ($collist['color_id']==99) { echo ""; } else { echo "
Farbe:
Größe:
"; } */ /* echo "
"; */ echo "


"; echo "
"; ?>
Seite: 1) echo " | "; if ($i==$pageNum) echo ""; echo "$i"; if ($i==$pageNum) echo ""; } ?>