db_query("SELECT title FROM $TB_SHOP_CLASS WHERE id = $id"); list($db_title) = $basis->db_fetchrow($query_id); $db_title = stripslashes($db_title); if(!empty($sub_id)) { $query_id = $basis->db_query("SELECT shsc_title FROM $TB_SHOP_SUB_CLASS WHERE shsc_id = $sub_id AND shsc_shcl_id = $id"); list($db_sub_title) = $basis->db_fetchrow($query_id); $sub_sql = " AND class_sub_id = $sub_id"; $db_title = $backLink = "\"$db_title\"\n".$db_title."/".$db_sub_title.""; } else $sub_id = 0; if(empty($f_order)) $f_order = 'title'; if(empty($f_sort)) $f_sort = 'asc'; if(empty($start_entry)) { $start_entry = 0; } $show_entries = $CONFIG['max_article_entries']; $next_entry = $start_entry + $show_entries; $prev_entry = $start_entry - $show_entries; $query_id = $basis->db_query("SELECT COUNT(id) FROM $TB_SHOP_ARTICLE WHERE class_id = $id AND active = 1$sub_sql"); list($cnt) = $basis->db_fetchrow($query_id); if($cnt > $show_entries and $show_entries > 0) { $pages = ceil($cnt / $show_entries); $cur_page = ($start_entry + $show_entries) / $show_entries; echo "$db_title (Seite $cur_page von $pages)\n"; if($prev_entry >= 0) echo "\"vorige\n"; else echo "\"vorige\n"; if($next_entry < $cnt) echo "\"nächste\n"; else echo "\"nächste\n"; } else echo "$db_title\n"; echo "

\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "
$cnt Artikel\n • Sortierung: \n"; echo "\n"; echo "
\n"; echo "

\n"; if($cnt > 0) { $sql = " select * from $TB_SHOP_ARTICLE where class_id = $id$sub_sql and active = 1 order by $f_order $f_sort ".($show_entries > 0 ? "limit $start_entry,$show_entries" : ""); $query_id = $basis->db_query($sql); // Statement abfeuern while($entries = $basis->db_fetch($query_id)) { // Fetch Array $db_id = stripslashes($entries['id']); $db_shar_article_id = stripslashes($entries['shar_article_id']); $db_title = stripslashes($entries['title']); $db_sdesc = stripslashes($entries['sdesc']); $db_simg = stripslashes($entries['simg']); $db_ldesc = stripslashes($entries['ldesc']); $db_limg = stripslashes($entries['limg']); $db_price = stripslashes($entries['price']); $db_inventory = stripslashes($entries['inventory']); $db_disc_date = stripslashes($entries['disc_date']); $db_disc_active = stripslashes($entries['disc_active']); $db_disc_percent = stripslashes($entries['disc_percent']); $db_disc_date = $basis->con_date_mysql2german($db_disc_date); if($CONFIG['show_net_price'] == '1') $db_price = $db_price * 100 / (100 + $CONFIG['tax']); echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; if(!empty($db_disc_active) AND !empty($db_disc_percent) AND $basis->con_date2unix($db_disc_date) > $basis->con_date2unix(date("d.m.Y"))) { $disc_price = $db_price - ($db_price * $db_disc_percent / 100); echo "\n"; } else echo "\n"; echo "\n"; if(!empty($CONFIG['show_inventory'])) { if($db_inventory < 1) { echo "\n"; } else if($db_inventory < $CONFIG['inventory_limit']) { echo "\n"; } else { echo "\n"; } } else { echo "\n"; } echo "\n"; if(!empty($s_articles[$db_id])) { echo "\n"; } else { echo "\n"; } echo "\n"; echo "\n"; echo "\n"; } // Seitenanzeige... if($cnt > $show_entries and $show_entries > 0) { $iblock = ceil($next_entry / $show_entries / 5); $end_page = $iblock * 5; $start_page = $end_page - 4; echo "

"; if($db_simg) { if($db_ldesc) echo "\"$CONFIG[detail_link]\""; else echo "\"\""; } else echo " "; echo "$db_titleArt.-Nr.PreisMengeBestellen
$db_sdesc\n"; if($db_ldesc) echo "
$CONFIG[detail_link]"; echo "		$db_shar_article_id".$basis->con_number($db_price)." $CONFIG[currency]
\n"; echo "".$basis->con_number($disc_price)." $CONFIG[currency]		".$basis->con_number($db_price)." $CONFIG[currency] \"Warenbestand\"\"Warenbestand\"\"Warenbestand\" "; echo "\"Artikel 
 
\n"; echo "
Seitenauswahl   "; if($pages > 5) { $next_start = (($iblock - 1) * $show_entries * 5) - $show_entries; if($iblock < 2) { echo "\"voriger\n"; } else { echo "\"voriger\n"; } } if($prev_entry >= 0) echo "\"vorige\n"; else echo "\"vorige\n"; echo "   "; for($i=$start_page;$i<=$end_page;$i++) { if($i > $pages) break; $next_start = ($i * $show_entries) - $show_entries; if($i == $cur_page) echo "$i\n"; else echo "$i\n"; } echo "   "; if($next_entry < $cnt) echo "\"nächste\n"; else echo "\"nächste\n"; if($pages > 5) { $next_start = $iblock * $show_entries * 5; if($next_start > ($pages * $show_entries)) { echo "\"nächster\n"; } else { echo "\"nächster\n"; } } echo "


\n"; } } else { echo "Sorry, zur Zeit gibt es keine Artikel in dieser Kategorie\n"; } echo "\n"; if(!empty($backLink)) echo "

$backLink

\n"; break; //***************************************************************************** case "start": echo $html_header; echo $html_body; include('inc/welcome.inc.php4'); break; //***************************************************************************** case "details": session_name('ORDER'); @session_start(); $sql = " select * from $TB_SHOP_ARTICLE where id = $id order by title"; $query_id = $basis->db_query($sql); // Statement abfeuern $cnt = $basis->db_rows($query_id); $entries = $basis->db_fetch($query_id); // Fetch Array if($cnt > 0) { $db_id = stripslashes($entries['id']); $db_shar_article_id = stripslashes($entries['shar_article_id']); $db_class_id = stripslashes($entries['class_id']); $db_class_sub_id = stripslashes($entries['class_sub_id']); $db_title = stripslashes($entries['title']); $db_sdesc = stripslashes($entries['sdesc']); $db_simg = stripslashes($entries['simg']); $db_ldesc = stripslashes($entries['ldesc']); $db_limg = stripslashes($entries['limg']); $db_price = stripslashes($entries['price']); $db_inventory = stripslashes($entries['inventory']); $db_disc_date = stripslashes($entries['disc_date']); $db_disc_active = stripslashes($entries['disc_active']); $db_disc_percent = stripslashes($entries['disc_percent']); if(!empty($entries['meta_description'])) $html_header = preg_replace('/(]*>)/i', "\${1}".stripslashes($entries['meta_description'])."\${3}", $html_header); if(!empty($entries['meta_keywords'])) $html_header = preg_replace('/(]*>)/i', "\${1}".stripslashes($entries['meta_keywords'])."\${3}", $html_header); } echo $html_header; echo $html_body; if(!empty($db_class_id)) $tid = $db_class_id; else if(!isset($tid)) $tid = 0; if(!empty($db_class_sub_id)) $tsid = $db_class_sub_id; else if(!isset($tsid)) $tsid = 0; $db_ctitle = $db_cstitle = $backLink = ''; if(!empty($tid)) { $query_id = $basis->db_query("SELECT title FROM $TB_SHOP_CLASS WHERE id = $tid"); list($db_ctitle) = $basis->db_fetchrow($query_id); $db_ctitle = stripslashes($db_ctitle); $back_title = $db_ctitle; if(!empty($tsid)) { $query_id = $basis->db_query("SELECT shsc_title FROM $TB_SHOP_SUB_CLASS WHERE shsc_id = $tsid"); list($db_cstitle) = $basis->db_fetchrow($query_id); $db_cstitle = stripslashes($db_cstitle); $back_title .= "/".$db_cstitle; } $backLink = "\"$back_title\"\n"; $backLink .= "$back_title\n"; echo $backLink; } if($cnt < 1) { echo "

\n"; echo "\n"; echo "
Zu dem ausgewählten Produkt konnten keine Details gefunden werden.

\n"; echo "\"$db_ctitle\"

\n"; echo $html_footer; exit; } else { $db_disc_date = $basis->con_date_mysql2german($db_disc_date); if($CONFIG['show_net_price'] == '1') $db_price = $db_price * 100 / (100 + $CONFIG['tax']); echo "

\n"; if($db_limg) echo "\n"; else if($db_simg) echo "\n"; echo "\n"; echo "\n"; echo "
\"$db_title\"
\"$db_title\"
$db_title
$db_ldesc
\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; if(!empty($db_disc_active) AND !empty($db_disc_percent) AND $basis->con_date2unix($db_disc_date) > $basis->con_date2unix(date("d.m.Y"))) { $disc_price = $db_price - ($db_price * $db_disc_percent / 100); echo "\n"; } else echo "\n"; echo "\n"; if(!empty($CONFIG['show_inventory'])) { if($db_inventory < 1) { echo "\n"; } else if($db_inventory < $CONFIG['inventory_limit']) { echo "\n"; } else { echo "\n"; } } else { echo "\n"; } echo "\n"; if(!empty($s_articles[$db_id])) { echo "\n"; } else { echo "\n"; } echo "\n"; echo "
Art.-Nr.PreisMengeBestellen 
$db_shar_article_id".$basis->con_number($db_price)." $CONFIG[currency] \n"; echo "".$basis->con_number($disc_price)." $CONFIG[currency]
\n"; echo "(Angebot bis ".$db_disc_date.")		".$basis->con_number($db_price)." $CONFIG[currency] \"Warenbestand\"\"Warenbestand\"\"Warenbestand\" "; echo "\"Artikel  
\n"; } $qid = $basis->db_query("SELECT * FROM $TB_SHOP_ARTICLE, $TB_SHOP_SIMILAR_ARTICLE WHERE shsa_article_id = $id AND id = shsa_similar_id AND id != $id ORDER BY title"); $cnt_sima = $basis->db_rows($qid); if($cnt_sima > 0) { echo "

\n"; if(!empty($CONFIG["similar_article"])) echo "

".$CONFIG["similar_article"]."

\n"; echo "

\n"; while($entries = $basis->db_fetch($qid)) { $db_sima_id = stripslashes($entries['id']); $db_sima_class_id = stripslashes($entries['class_id']); $db_sima_class_sub_id = stripslashes($entries['class_sub_id']); $db_sima_shar_article_id = stripslashes($entries['shar_article_id']); $db_sima_title = stripslashes($entries['title']); $db_sima_sdesc = stripslashes($entries['sdesc']); $db_sima_simg = stripslashes($entries['simg']); $db_sima_ldesc = stripslashes($entries['ldesc']); $db_sima_limg = stripslashes($entries['limg']); $db_sima_price = stripslashes($entries['price']); $db_sima_inventory = stripslashes($entries['inventory']); $db_sima_disc_date = stripslashes($entries['disc_date']); $db_sima_disc_active = stripslashes($entries['disc_active']); $db_sima_disc_percent = stripslashes($entries['disc_percent']); $db_sima_disc_date = $basis->con_date_mysql2german($db_sima_disc_date); if($CONFIG['show_net_price'] == '1') $db_sima_price = $db_sima_price * 100 / (100 + $CONFIG['tax']); echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; if(!empty($db_sima_disc_active) AND !empty($db_sima_disc_percent) AND $basis->con_date2unix($db_sima_disc_date) > $basis->con_date2unix(date("d.m.Y"))) { $disc_price = $db_sima_price - ($db_sima_price * $db_sima_disc_percent / 100); echo "\n"; } else echo "\n"; echo "\n"; if(!empty($CONFIG['show_inventory'])) { if($db_sima_inventory < 1) echo "\n"; else if($db_sima_inventory < $CONFIG['inventory_limit']) echo "\n"; else echo "\n"; } else echo "\n"; echo "\n"; if(!empty($s_articles[$db_sima_id])) { echo "\n"; } else echo "\n"; echo "\n"; echo "\n"; } echo "
"; if($db_sima_simg) echo "\"\""; else echo " "; echo "$db_sima_titleArt.-Nr.PreisMengeBestellen
$db_sima_sdesc\n"; if($db_sima_ldesc) echo "
$CONFIG[detail_link]"; echo "		$db_sima_shar_article_id".$basis->con_number($db_sima_price)." $CONFIG[currency]
\n"; echo "".$basis->con_number($disc_price)." $CONFIG[currency]		".$basis->con_number($db_sima_price)." $CONFIG[currency] \"Warenbestand\"\"Warenbestand\"\"Warenbestand\" "; echo "\"Artikel 
\n"; if(!empty($backLink)) echo "

$backLink

\n"; } break; //***************************************************************************** case "search": if(@microtime()) { list($low, $high) = split(" ", microtime()); $starttime = $high + $low; } echo $html_header; echo $html_body; echo "\"Zurück\"\n"; echo "Artikelsuche\n"; if(empty($f_search)) { echo "

Sie haben keinen Suchbegriff eingegeben.\n"; } else { $f_search = trim(rawurldecode(stripslashes($f_search))); $f_search_sql = addslashes($f_search); $sql = " select * from $TB_SHOP_ARTICLE where active = 1 and (lower(title) like '%$f_search_sql%' OR lower(shar_article_id) like '%$f_search_sql%' OR lower(sdesc) like '%$f_search_sql%' OR lower(ldesc) like '%$f_search_sql%' OR price like '%$f_search_sql%')"; if(!empty($show_disc)) $sql .= " and disc_active = 1 and disc_date > NOW()"; else $show_disc = 0; $sql .= " order by title limit $CONFIG[max_search_results]"; $query_id = $basis->db_query($sql); // Statement abfeuern $cnt = $basis->db_rows($query_id); if($cnt < 1) { echo "

Sorry, "$f_search" konnte nicht gefunden werden.\n"; } else { session_name('ORDER'); @session_start(); $endtime = ''; if(@microtime()) { list($low, $high) = split(" ", microtime()); $endtime = round($high + $low - $starttime,3); if($endtime < 0) $endtime = 0.001; $endtime = " in ".$endtime.($endtime == 1 ? " Sekunde" : " Sekunden"); } echo "

Suche nach "$f_search": $cnt Treffer".$endtime.".\n"; flush(); if($cnt >= $CONFIG['max_search_results']) echo "(Es werden nur max. $CONFIG[max_search_results] Artikel innerhalb eines Suchergebnisses angezeigt)\n"; echo "

\n"; while($entries = $basis->db_fetch($query_id)) { // Fetch Array $db_id = stripslashes($entries['id']); $db_shar_article_id = stripslashes($entries['shar_article_id']); $db_class_id = stripslashes($entries['class_id']); $db_title = stripslashes($entries['title']); $db_sdesc = stripslashes($entries['sdesc']); $db_simg = stripslashes($entries['simg']); $db_ldesc = stripslashes($entries['ldesc']); $db_limg = stripslashes($entries['limg']); $db_price = stripslashes($entries['price']); $db_inventory = stripslashes($entries['inventory']); $db_disc_date = stripslashes($entries['disc_date']); $db_disc_active = stripslashes($entries['disc_active']); $db_disc_percent = stripslashes($entries['disc_percent']); $db_disc_date = $basis->con_date_mysql2german($db_disc_date); if($CONFIG['show_net_price'] == '1') $db_price = $db_price * 100 / (100 + $CONFIG['tax']); echo "\n"; if($db_simg) echo "\n"; else echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; if(!empty($db_disc_active) AND !empty($db_disc_percent) AND $basis->con_date2unix($db_disc_date) > $basis->con_date2unix(date("d.m.Y"))) { $disc_price = $db_price - ($db_price * $db_disc_percent / 100); echo "\n"; } else echo "\n"; echo "\n"; if(!empty($CONFIG['show_inventory'])) { if($db_inventory < 1) { echo "\n"; } else if($db_inventory < $CONFIG['inventory_limit']) { echo "\n"; } else { echo "\n"; } } else { echo "\n"; } echo "\n"; if(!empty($s_articles[$db_id])) { echo "\n"; } else { echo "\n"; } echo "\n"; echo "\n"; echo "\n"; } echo "
\"\" $db_titleArt.-Nr.PreisMengeBestellen
$db_sdesc\n"; if($db_ldesc) echo "
$CONFIG[detail_link]"; echo "		$db_shar_article_id".$basis->con_number($db_price)." $CONFIG[currency]
\n"; echo "".$basis->con_number($disc_price)." $CONFIG[currency]		".$basis->con_number($db_price)." $CONFIG[currency] \"Warenbestand\"\"Warenbestand\"\"Warenbestand\" "; echo "\"Artikel 
 
\n"; } } break; //***************************************************************************** case "conditions": echo $html_header; echo $html_body; include('inc/conditions.inc.php4'); break; //***************************************************************************** // Browser auf JavaScript prüfen default: $browser_details = preg_split("/[\s\/,;]/",$HTTP_USER_AGENT); $i = array_search("Opera",$browser_details) + 1; $ver = (float) $browser_details[$i]; echo $html_header; if(preg_match("/Opera/i", $HTTP_USER_AGENT) and $ver < 7) { ?> $CONFIG[title]\n"; echo $HTTP_USER_AGENT."\n"; echo "

Sorry, der von Ihnen verwendete Browser unterstützt leider nicht alle erforderlichen JavaScript-Funktionalitäten.
\n"; echo $html_footer; exit; } else { ?> $CONFIG[title] Der Shop funktioniert nur mit JavaScript und Cookies.
Bitte überprüfen Sie die Browsereinstellungen.
Wenn Sie Ihre Einstellungen geprüft haben, klicken Sie hier. EOF; } } //***************************************************************************** echo $html_footer; ?>