0) { $sql="select subcatURL from tbl_subcategory where subcatid = ".$subcatid.""; $rs = $db->execute($sql); if (!$rs->EOF){ $tpl=$rs->fields["subcatURL"]; } $sql="select * from tbl_items where itemcat = ".$catid." and itemsubcat = ".$subcatid." order by priority asc, titel asc"; } else { $sql="select catURL from tbl_category where catid = ".$catid.""; $rs = $db->execute($sql); if (!$rs->EOF){ $tpl=$rs->fields["catURL"]; } $sql="select * from tbl_items where itemcat = ".$catid." order by priority asc, titel asc"; } $rs = $db->execute($sql); if ($tpl==0) { $tpl=11; } if ($_GET["pageno"]=="") { $pageno=1; } else { $pageno=$_GET["pageno"]; } switch ($tpl) { case 11: $totalpages = 9; break; case 12: $totalpages = 4; break; case 13: $totalpages = 5; break; case 14: $totalpages = 10; break; default: $totalpages = 9; break; } $rs = $db->execute($sql); $totalrecs = $rs->RecordCount(); $rs->move(($pageno-1)*$totalpages); $maxCount = intval(($totalrecs+$totalpages-1)/$totalpages); switch ($tpl) { case 11: include "menu/tpl11.php"; break; case 12: include "menu/tpl12.php"; break; case 13: include "menu/tpl13.php"; break; case 14: include "menu/tpl14.php"; break; case 15: include "menu/tpl15.php"; break; case 16: include "menu/tpl16.php"; break; } } else if ($prodid!="") { if ($prodid=="") { $prodid=0; } ?>

execute($sql); if (!$rs->EOF) { $prodid=$rs->fields["productID_ID"]; $imgbig=$rs->fields["img_big"]; $longdesc=$rs->fields["longDesc"]; $titel=$rs->fields["Titel"]; $price=$rs->fields["price"]; $shipping=$rs->fields["shipping"]; $onstock=$rs->fields["onStock"]; $optionid=$rs->fields["options"]; $specialPrice=$rs->fields["specialPrice"]; $optionid=$rs->fields["options"]; $tpl=$rs->fields["tplID"]; } switch ($tpl) { case 11: if ($itemtpl) { tbl_header("80","center"); } include "items/tpl11.php"; if ($itemtpl) { tbl_footer(); } break; } } else if ($lid == "search") { $sql = "select * from tbl_items where Titel like '%".$searchstr."%' or longDesc like '%".$searchstr."%' order by Titel asc;"; $rs = $db->execute($sql); include "menu/tpl11.php"; } else if ($lid == "aboutus") { include "_aboutus.php"; } else if ($lid == "faq") { include "_faq.php"; } else if ($lid == "feedback") { include "_feedback.php"; } else if ($lid == "agb") { include "_agb.php"; } else { include "_front.php"; } ?>

close(); ?>