';
$menu .= '';
tmpl();
}
// CATALOGUE //
if (!isset($_GET['p'])) {
$type = 'brands';
$stype = 'brd';
$title = t('Welcome');
$content = "
:: ".t(217)." ::
";
$q = " select distinct(brands.name),brands.* from brands,products where brands.active=1 and brands.id=products.brd order by wgt"; # brands have weight
$cps = "select id from products where active=1 or ".$stype;
if (isset($_GET['brd']) && !isset($_GET['cat'])) {
$q = "select name from brands where id=".$_GET['brd']." limit 1";
$q = mysql_query($q)or sql_err(mysql_error());
$q = mysql_fetch_assoc($q);
$type = $stype = 'cat';
$title = $q['name'];
$content = "
:: ".t('187')." ::
";
if ($_GET['brd'] == 0) { # display all categories of all
$q = " select distinct(cat.id),cat.* from cat,products,pcat where cat.active=1 and cat.id=pcat.c and products.id=pcat.p";
$cps = "select products.id from products,pcat where products.active=1 and pcat.c";
} else {
$q = " select distinct(cat.id),cat.* from cat,products,pcat where cat.active=1 and products.brd='".$_GET['brd']."' and cat.id=pcat.c and products.id=pcat.p";
$cps = "select products.id from products,pcat where products.active=1 and products.brd='".$_GET['brd']."' and pcat.c";
}
}
#if (isset($_GET['cat']) && !isset($_GET['sex'])) {
#$type = $stype = 'sex';
##$title = t('191');
##$content = "
:: ".t('192')." ::
";
#$title = $content = '';
#$q = "select * from ".$type." where active=1 order by id";
#$cps = "select id from products where active=1 and brd='".$_GET['brd']."' and cat='".$_GET['cat']."' and ".$stype;
#}
#if (isset($_GET['sex'])) {
if (isset($_GET['cat'])) {
$q = "select cat.name from cat where cat.id=".$_GET['cat']." limit 1";
$q = mysql_query($q)or sql_err(mysql_error());
$q = mysql_fetch_assoc($q);
$cat = $q['name'];
if ($_GET['brd'] != 0) {
$q = "select brands.name from brands where brands.id=".$_GET['brd']." limit 1";
$q = mysql_query($q)or sql_err(mysql_error());
$q = mysql_fetch_assoc($q);
$brd = $q['name'];
} else { $brd = t('All brands'); }
$type = 'products';
$title = $cat.' ('.$brd.')';
$content = "
:: ".t('Make a choice')." ::
";
if ($_GET['brd'] == 0) { # display all products of this cat
$q = "select products.* from products,pcat where products.active=1 and pcat.c='".$_GET['cat']."' and products.id=pcat.p order by name";
$cps = "select products.id from products,pcat where products.active=1 and pcat.c='".$_GET['cat']."' and products.sex=";
} else {
$q = "select products.* from products,pcat where products.active=1 and pcat.c='".$_GET['cat']."' and products.brd='".$_GET['brd']."' and products.id=pcat.p order by name";
$cps = "select products.id from products,pcat where products.active=1 and products.brd='".$_GET['brd']."' and pcat.c='".$_GET['cat']."' and products.sex=";
}
}
$menu .= '
'.$title.'';
} # end !isset $_GET['p']
else {
$type = 'products';
$content = '';
$q = "select * from ".$type." where id='".$_GET['p']."'";
$title = 'Artikel details';
}
$dbq = mysql_query($q)or sql_err(mysql_error());
if (@mysql_num_rows($dbq)>0) {
if (!isset($_GET['p'])) { $content .= ""; }
$li = 0;
while ($list = mysql_fetch_assoc($dbq)) { $li++;
if (!isset($_GET['p'])) { $cp = mysql_query($cps."='".$list['id']."'"); }
if ((@mysql_num_rows($cp)>0) || ($type == 'products')) {
if ((!isset($_GET['p'])) && ($li >= 5)) { $content .= "
"; $li = 1; }
if (is_null($list['pic']) || $list['pic'] == '' || $list['pic'] == '0') { $plist['file'] = 'unknown.gif'; } else {
$dbqp = mysql_query("select file from images where id='".$list['pic']."'")or sql_err(mysql_error());
$plist = mysql_fetch_assoc($dbqp);
} # end else pic
if ($type != 'products') {
if ($list['active'] == 0) { $link = ""; } else {
if ($s_q == '') { $link = ""; } else { $link = ""; }
}
} # !prod
else { $link = ""; }
$menu .= '- '.$link.$list['name'].'
';
if (!isset($_GET['p'])) {
$content .= "
".$link."![](\"/images/image.php?img=".$plist['file']."\")
".$link.$list['name']."
|
";
} else { # display a product
$mrs = str_replace("\r\n","
- ",$list['mrs']);
$des = str_replace("\r\n","
",$list['des']);
# brand name
$q = "select name from brands where id='".$list['brd']."'";
$q = mysql_query($q)or sql_err(mysql_error());
$q = mysql_fetch_assoc($q); $b = $q['name'];
# cat name
$q = "select distinct(cat.name) from cat,pcat where pcat.p='".$list['id']."' and pcat.c=cat.id";
$q = mysql_query($q)or sql_err(mysql_error());
$c = '';
while ($ql = mysql_fetch_assoc($q)) { $c .= $ql['name'].", "; }
# sex name
$q = "select name from sex where id='".$list['sex']."'";
$q = mysql_query($q)or sql_err(mysql_error());
$q = mysql_fetch_assoc($q); $s = $q['name'];
# get price
$price = getprice($UID,$list['id'],'in');
$content .= "
".$list['name']." | ".t('Description')." |
|
![](\"/images/image.php?w=160&img=".$plist['file']."\")
![](\"images/zoomglass.gif\") ".t('198')." | ".$des." |
Info |
Merk: ".$b."
Categorie(s): ".$c."
Sex/Gender: ".$s."
|
|
";
$q = "select * from products where pid=".$list['id'];
$q = mysql_query($q)or sql_err(mysql_error());
$content .= "| Maat | Kleur | Vorm | Extra | Prijs | Bestellen |
|---|
";
while ($ql = mysql_fetch_array($q)) {
foreach ($ql as $n => $v) { if ($v == '') { $ql[$n] = '-'; } }
$content .= '| '.$ql['mrs'].' | '.$ql['col'].' | '.$ql['shape'].' | '.$ql['extra'].' | '.$price.'€ |  |
';
}
$content .= "
";
$content .= "
Alle prijzen zijn inclusief 21% BTW.";
} # end else !isset $_GET['p']
} elseif (isset($content)) { $content = "".t('195')."
"; } # end cp numrows
} # end while $list
$menu .= '';
if (!isset($_GET['p'])) { $content .= "
\n"; }
} else { $content = t(15); } # no list ?
tmpl();
?>
![](\"/images/image.php?percent=100&w=720&img=".$pic."\")
";
$content .= '