f("webtext")){?> text="#f("webtext")?>"f("weblink")){?> link="#f("weblink")?>"f("webvlink")){?> vlink="#f("webvlink")?>"f("webalink")){?> alink="#f("webalink")?>"f("webbg")){?> bgcolor="#f("webbg")?>"f("webback")) {?> background="f("webback")?>">


Your search of '' yielded no results. Please Search again. Either no product categories and/or search terms were specified, or your search returned no results. Please return to the product selection page and choose a category or enter a search term. Thank you.

Click here to return to the home page.

query("select * from web where webzid=$zid and weblid=$lid"); $fcw->next_record(); $srt=$fcw->f("websort"); $fcz->query("select zonecurrsym,usescat from zone where zoneid=$zid"); if($fcz->next_record()){ $csym=$fcz->f("zonecurrsym"); $csym=trim($csym); $zscat=(int)$fcz->f("usescat"); }else{ $csym=""; $zscat=0; } // get the language templates $fcl->Auto_free=1; $fcl->query("select langtdsp,langshow,langterr from lang ". "where langid=$lid"); $fcl->next_record(); $show=$fcl->f("langshow"); // if they didn't tell us to do anything if(empty($cat) && empty($key1) && empty($psku) && empty($nlst) && empty($olst)){ error_log ("display-jw: nothing? cat is $cat, key is $key1, sku is $psku, nlst is $nlst olst is $olst"); showerr(); }else{ // log the access $fcl->Auto_commit = 1; $fcl->query("select accesscnt from acc where accessip='$REMOTE_ADDR'"); if($fcl->next_record()==0){ $fcl->query("insert into acc (accesshost,accessip,accesstime,accesscnt)". " values ('$REMOTE_HOST','$REMOTE_ADDR',$now,1)"); }else{ $tmp=(int)$fcl->f("accesscnt") + 1; $fcl->query("update acc set accesscnt=$tmp,accesstime=$now ". "where accessip='$REMOTE_ADDR'"); } // display the new product list if(!empty($nlst)){ $cat=""; $key1=""; $tbs="nprod,prod,prodlang"; $pj="nzid=$zid and nprodsku=prodsku and prodzid=$zid and ". "nprodsku=prodlsku and prodlzid=$zid and prodlid=$lid"; } // display the closeout product list if(!empty($olst)){ $cat=""; $key1=""; $tbs="oprod,prod,prodlang"; $pj="ozid=$zid and oprodsku=prodsku and prodzid=$zid and ". "oprodsku=prodlsku and prodlzid=$zid and prodlid=$lid"; } // category and/or search terms if(!empty($cat)){ $cf="catdescr,catbg,catback,cattext,catlink,catvlink,". "catalink,catlogo,catlogoh,catlogow,catfree,catbanr,". "catbanrh,catbanrw,catsku,catmast,cattmpl,catsort"; if($zscat && $scat){ // if subcats enabled and a subcat given $fcs->query("select usescat from cat ". "where catval=$cat and catzid=$zid and catlid=$lid"); $fcs->next_record(); $cscat=(int)$fcs->f("usescat"); $fcs->free_result(); if($cscat){ $sf="scatdescr,scatbg,scatback,scattext,scatlink,scatvlink,". "scatalink,scatlogo,scatlogoh,scatlogow,scatfree,scatbanr,". "scatbanrh,scatbanrw,scatsku,scatmast,scattmpl,scatsort"; $fcs->query("select $sf from subcat where scatcat=$cat and ". "scatzid=$zid and scatlid=$lid and scatval=$scat"); $fcs->next_record(); $srt=$fcs->f("scatsort"); }else{ $fcs->query("select $cf from cat where ". "catval=$cat and catzid=$zid and catlid=$lid"); $fcs->next_record(); $srt=$fcs->f("catsort"); } }else{ //error_log("display: cat $query is select $cf from cat where ". "catval=$cat and catzid=$zid and catlid=$lid"); $fcs->query("select $cf from cat where ". "catval=$cat and catzid=$zid and catlid=$lid"); $fcs->next_record(); $srt=$fcs->f("catsort"); } if(!empty($psku)){ // single product display $pj="pcatval=$cat and pcatzid=$zid and pcatzid=prodzid and ". "prodzid=prodlzid and prodlid=$lid and pcatsku='$psku' and ". "prodsku='$psku' and prodlsku='$psku'"; }elseif($scat){ // join with subcategory $pj="pcatval=$cat and pcatzid=$zid and pcatzid=prodzid and prodzid=". "prodlzid and prodlid=$lid and pcatsku=prodsku and prodsku=prodlsku ". "and pscatval=$scat"; }else{ // from a category selection, no subcategory $pj="pcatval=$cat and pcatzid=$zid and pcatzid=prodzid and prodzid=". "prodlzid and prodlid=$lid and pcatsku=prodsku and prodsku=prodlsku"; } $tbs="prod,prodlang,prodcat"; if(!empty($key1)){ if($databaseeng=="pgsql") { $pj.=" and (lower(proddescr) like lower('%$key1%')". " or lower(prodsdescr) like lower('%$key1%')". " or lower(prodsku) like lower('%$key1%')". " or lower(prodkeywords) like lower('%$key1%'))"; } else { $pj.=" and (lcase(proddescr) like lcase('%$key1%')". " or lcase(prodsdescr) like lcase('%$key1%')". " or lcase(prodsku) like lcase('%$key1%')". " or lcase(prodkeywords) like lcase('%$key1%'))"; } } }else{ if(!empty($psku)){ // single product display, category not selected $pj="prodsku='$psku' and prodlsku='$psku' and prodzid=$zid ". "and prodzid=prodlzid and prodlid=$lid"; $tbs="prod,prodlang"; } elseif(!empty($key1)){ // keyword search, no categories selected if($databaseeng=="pgsql") { $pj="(lower(proddescr) like lower('%$key1%')". " or lower(prodkeywords) like lower('%$key1%')". " or lower(prodsdescr) like lower('%$key1%')". " or lower(prodsku) like lower('%$key1%'))". " and prodsku=prodlsku and prodzid=$zid". " and prodlzid=$zid and prodlid=$lid"; $tbs="prod,prodlang"; } else { $pj="(lcase(proddescr) like lcase('%$key1%')". " or lcase(prodkeywords) like lcase('%$key1%')". " or lcase(prodsdescr) like lcase('%$key1%')". " or lcase(prodsku) like lcase('%$key1%'))". " and prodsku=prodlsku and prodzid=$zid". " and prodlzid=$zid and prodlid=$lid"; $tbs="prod,prodlang"; } } } // same for all queries $fds="proddescr,prodpic,prodpicw,prodpich,prodtpic,prodtpicw,prodtpich,". "prodsku,prodprice,prodinvqty,prodaudio,prodvideo,prodsalebeg,prodsaleend,". "prodsplash,prodsaleprice,produseinvq,prodseq,prodoffer,prodsdescr,proddload"; $pj.=" and (produseinvq=0 or (produseinvq=1 and prodinvqty>0))"; // echo "select count(*) from $tbs where $pj
"; //error_log("select count(*) from $tbs where $pj
"); //error_log("select count(*) from $tbs where ". addslashes($pj)); $fcp->query("select count(*) from $tbs where $pj"); $fcp->next_record(); $total=(int)$fcp->f("0"); $fcp->free_result(); $count=$total; // this because the "got" count below is commented out if(!$count){ showerr(); }else{ // echo "select $fds from $tbs where $pj order by $srt
"; $fcp->query("select $fds from $tbs where $pj order by $srt"); // THIS IS ONLY NEEDED DUE TO SOLID'S POOR LIMIT ABILITY... // if olimit>0, read off the first olimit rows if(!$psku && $olimit){ $i=0; while($i<$olimit){ $fcp->next_record(); $i++; } } if(!empty($key1)){ // log keyword search results $key1=strtolower($key1); $fck->Auto_free=1; $fck->query("select keycnt,keyres from keyword where keyval='$key1'"); if( !$fck->next_record ){ $fck->query( "insert into keyword (keyval,keycnt,keyres) values ('$key1',1,$total)"); }else{ $tmp=(int)$fck->f("keycnt") + 1; $kres=(int)$fck->f("keyres") + $count; $fck->query( "update keyword set keycnt=$tmp,keyres=$kres where keyval='$key1'"); } $fck->commit(); } ?><?php if($cat && !$cscat){ echo stripslashes($fcs->f("catdescr")); }elseif($cat && $cscat){ echo stripslashes($fcs->f("scatdescr")); } ?> f("cattext")){?> text="#f("cattext")?>"f("catlink")){?> link="#f("catlink")?>"f("catvlink")){?> vlink="#f("catvlink")?>"f("catalink")){?> alink="#f("catalink")?>"f("catbg")){?> bgcolor="#f("catbg")?>"f("catback")){?> background="f("catback")?>"f("scattext")); // if subcategory values override if($fcs->f("scattext")>0){?> text="#f("scattext")?>"f("scatlink")>0){?> link="#f("scatlink")?>"f("scatvlink")>0){?> vlink="#f("scatvlink")?>"f("scatalink")>0){?> alink="#f("scatalink")?>"f("scatbg")>0){?> bgcolor="#f("scatbg")?>"f("scatback")>0){?> background="f("scatback")?>"f("webtext")){?> text="#f("webtext")?>"f("weblink")){?> link="#f("weblink")?>"f("webvlink")){?> vlink="#f("webvlink")?>"f("webalink")){?> alink="#f("webalink")?>"f("webbg")){?> bgcolor="#f("webbg")?>"f("webback")) {?> background="f("webback")?>"> f("weblogo")?>" width="f("weblogow")?>" height="f("weblogoh")?>" border=0 alt="">

f("catlogo")){?>
" width="f("catlogow")?>" height="f("catlogoh")?>" border=0 alt="">
f("scatlogo")){?> " width="f("scatlogow")?>" height="f("scatlogoh")?>" border=0 alt=""> f("weblogo")){?> f("weblogo")?>" width="f("weblogow")?>" height="f("weblogoh")?>" border=0 alt="">
f("catmast"));?>
f("scatmast"));?>
f("catsku") || $cat && $cscat && $fcs->f("scatsku") ){ // if a category and SKU given ?>
f("catsku") ){ $hsku=$fcs->f("catsku"); $img=$fcs->f("catbanr"); $wid=$fcs->f("catbanrw"); $hgt=$fcs->f("catbanrh"); }elseif($cat && $cscat && $fcs->f("scatsku") ){ $hsku=$fcs->f("scatsku"); $img=$fcs->f("scatbanr"); $wid=$fcs->f("scatbanrw"); $hgt=$fcs->f("scatbanrh"); } if(!$img){ $fca->query("select * from prodlang ". "where prodlsku='".$hsku."' and prodlzid=$zid"); $fca->next_record(); $img=$fca->f("prodbanr"); $wid=$fca->f("prodbanrw"); $hgt=$fca->f("prodbanrh"); $fca->free_result(); } ?>
Quantity:
$dn){?>
images, pages, Click on an image for a larger version.
Gallery Pages --> 0) { if($i!=$olimit){?> '; } } echo "\n"; ?>
Search Results:
next_record() ){ if ($count==2) { echo ""; $count=0; } $count ++; ?> //\"%s", //$row["id"], //$row["id"], $w, $h,$imgID, //$imgsmall, $size[3], $row["ttl"], $imgID); printf("=$dn){ // check if max products per page has been reached per $dn variable above break; } } // END OF PRODUCT DISPLAY LOOP ?>
\"%s", $fcp->f("prodsku"), $fcp->f("prodsku"), $fcp->f("prodpicw") + 30, $fcp->f("prodpich") + 50,$fcp->f("prodsku"), $fcp->f("prodtpic"), $fcp->f("prodtpicw"), $fcp->f("prodtpich"), $fcp->f("prodsdescr"), $fcp->f("prodsku")); ?>
f("prodsdescr"))?>