'; } if (isset($_GET['modif'])) { // Empty the $_SESSION['cart'] array $_SESSION['cart'.'pez'][$_GET['pz']] = $_GET['qt']; echo ''; } if (isset($_GET['nota'])) { $_SESSION['cart'.'not'][$_GET['pz']] =$_REQUEST['note']; echo ''; } if ($_REQUEST["brend"]<=0) {$cid=$_REQUEST["cid"];} if ($_REQUEST["brend"]>=0) {$_SESSION['cart'.'brend']=$_REQUEST["brend"];} if ($_SESSION['cart'.'brend']>0) { $_REQUEST["brend"]=$_SESSION['cart'.'brend'];} $_SESSION['cart'.'brend']=$_REQUEST["brend"]; if($cid>=1) { //$_SESSION['cart'.'brend']=""; if($cid<=10){$cid="45";} //deve essere 743 $scelta=1; } elseif ( isset( $_REQUEST["cid"] ) && $_REQUEST["cid"]!="" ) { $cid=$_REQUEST["cid"]; $scelta=3; $_SESSION["u_categ"]=$cid ; // header('location: ' . $_SERVER['PHP_SELF'] . '?' . SID); } elseif($_SESSION['u_categ']>=1) { $cid=$_SESSION['u_categ']; $scelta=2; } else { $cid=45; // 743 $scelta=4; $_SESSION["u_categ"]=0 ; //header('location: ' . $_SERVER['PHP_SELF'] . '?' . SID); } ////////////////////////////////FINE ///categoria cid ///////// $_SESSION["visita"][$uid] =$cid; // sta visitando ///////////////////////////////////////////////////////////////////////////////// if(!isset($_REQUEST["type"])) { $type=1; } else { $type=$_REQUEST["type"]; } $strpass=""; if ( isset($_REQUEST["keyword"] ) ) { $strpass=$strpass . "&keyword=" . $_REQUEST["keyword"]; } if ( isset($_REQUEST["radio"] ) ) { $strpass=$strpass . "&radio=" . $_REQUEST["radio"]; } $strpass=$strpass . "&cid=" . $cid; $strpass=$strpass . "&uid=" . $uid; $strpass=$strpass . "&type=" . $type; $strpass1=$strpass; $rs_query=mysql_query("Select * from astevirtuali_categorie where id=" . $cid ); if ($rs=mysql_fetch_array($rs_query)) { $catname=$rs["cat_name"]; $category=$rs["id"]; $cid=$rs["id"]; $descrizione=$rs["cat_desc"]; $collegamento=$rs["collegamento"]; $foto1=$rs["cat_foto1"]; $foto2=$rs["cat_foto2"]; } else { $catname=""; $category=0; $cid=0; } $catpath=""; $rs_query=mysql_query("Select * from astevirtuali_categorie where id=" . $category ); while ($rs=mysql_fetch_array($rs_query)) { $catpath ="> " .$rs["cat_name"]."" . $catpath; $rs_query=mysql_query("Select * from astevirtuali_categorie where id=" . $rs["pid"] ); } if ($_REQUEST["brend"]>0) { $recperpage=70 ; // righe per pagina } else { $recperpage=150 ; // righe per pagina } //$sql="select *,DATE_FORMAT(date_submitted,'%d-%b-%Y %r') as postedon,DATE_FORMAT(DATE_ADD(date_submitted,INTERVAL auction_period DAY),'%d-%b-%Y %r') as endson,UNIX_TIMESTAMP(DATE_ADD(date_submitted,INTERVAL auction_period DAY)) as expiry from astevirtuali_prodotti where approved='yes' and aucid in (1,3,5,6,7,10,20,25,30)"; $sql="select * from astevirtuali_prodotti where approved='yes' "; if (($type==1) || ($type==9)) { $date1=date(time()); //$sql.=" and UNIX_TIMESTAMP(DATE_ADD(date_submitted,INTERVAL auction_period DAY)) > $date1 and status='open' and uid=" . $uid; //$date1=date(time()); //$sql.=" and status='open' and uid=" . $uid; } ////// leggi pure ditta dalu(12) SEMPRE e se in RICERCA TUTTE ///////////////////////////////////////// $sql.=" and status in ('open')"; //,'concluaucid in sa vend','Venduto' $sql.=" and uid in (1,3,5,6,7,8,10,11,12,14,20,21,25,27,28,30,31,36,37,38,45,175)"; //if ($_REQUEST["radio"]==29) // { $sql.=" and location in (29,33) ";} //if ($_REQUEST["radio"]==30) // { $sql.=" and location in (30,33) ";} //$sql.=" and uid=9 "; // solo 9 per garden sicily //if (($_REQUEST["radio"]>=1) || ($cid>10)) // { $sql.=" and uid in (175,31,28,27,11,12,14,9,37)";} // 7 è ditta per orologi da fare a parte ! //else // { $sql.=" and uid in (175,31,28,27,11,12,14,9,37) and gallery_featured='yes'";} // gallery_featured = in evidenza ! /// if ( isset($_REQUEST["keyword"] ) && $_REQUEST["keyword"]!="" && isset($_REQUEST["radio"] ) && $_REQUEST["radio"]==1) { $sql=$sql." and ( product_name like '%".str_replace("'","''",$_REQUEST["keyword"])."%' or codice like'%".str_replace("'","''",$_REQUEST["keyword"])."%' or id like'%".str_replace("'","''",$_REQUEST["keyword"])."%' )"; } if ( isset($_REQUEST["keyword"] ) && $_REQUEST["keyword"]!="" && isset($_REQUEST["radio"] ) && $_REQUEST["radio"]==2) { $sql=$sql." and ( product_name like '%".str_replace("'","''",$_REQUEST["keyword"])."%')"; } if ($_REQUEST["brend"]>0) { $sql=$sql." and bold=". $_REQUEST["brend"] . " "; } if ( isset($_REQUEST["keyword"] ) && $_REQUEST["keyword"]!="" && isset($_REQUEST["radio"] ) && $_REQUEST["radio"]==3) { $sql=$sql." and ( product_name like '%".str_replace("'","''",$_REQUEST["keyword"])."%' or product_desc like '%".str_replace("'","''",$_REQUEST["keyword"]). "%')"; } if ( isset($_REQUEST["keyword"] ) && $_REQUEST["keyword"]!="" && isset($_REQUEST["radio"] ) && $_REQUEST["radio"]==4) { $sql=$sql." and ( raffina3='".str_replace("'","''",$_REQUEST["keyword"])."') "; } // --- eliminato il 20 ott 2017 --- //if ( isset($_REQUEST["keyword"] ) && $_REQUEST["keyword"]!="" && isset($_REQUEST["radio"] ) && $_REQUEST["radio"]==3) //{ //$sql0=mysql_query("select id from astevirtuali_utenti where (username like '%".str_replace("'","''",$_REQUEST["keyword"])."%' or fname like '%".str_replace("'","''",$_REQUEST["keyword"])."%' or lname like '%".str_replace("'","''",$_REQUEST["keyword"])."%' or c_name like'%".str_replace("'","''",$_REQUEST["keyword"])."%')"); //$u_list="-1"; //while($rs_t1=mysql_fetch_array($sql0)) //{ //$u_list.=",".$rs_t1["id"]; //} //$sql=$sql." and uid in (".$u_list.")"; //} // --- fine eliminato il 20 ott $clist=$cid; // --- inizio 2 eliminato il 20 ott $rst1_query=mysql_query("Select * from astevirtuali_categorie where pid=" . $cid ); while ( $rst1=mysql_fetch_array($rst1_query) ) { $clist.="," . $rst1["id"]; $rst1_query=mysql_query("Select * from astevirtuali_categorie where pid IN (" . $clist . ") and id not in ( ". $clist . ")") ; } // --- fine 2 eliminato il 20 ott $sql.=" and cid in (" . $clist . ") " ; //$sql.= " order by endson desc" ; if($type==9) { $sql.= " order by featured desc" ; // , date_submitted desc } else { $sql.= " order by pezzi desc" ; // , in ordine pezzi } //$sql.= " order by featured desc, aucid, date_submitted desc" ; $rs_query=mysql_query($sql); ///////////////////////////////////PAGINATION ///////// if($pg>=1) {$scelta=1;} elseif($_REQUEST['pg']>=1) { $pg=$_REQUEST["pg"]; $scelta=3; $_SESSION["u_pagina"]=$pg ; //header('location: ' . $_SERVER['PHP_SELF'] . '?' . SID); $pag=$_SESSION['u_pagina']; } elseif($_SESSION['u_pagina']>=1) { $pg=$_SESSION['u_pagina']; $pag=$_SESSION['u_pagina']; $scelta=2; } else { $pg=1; $scelta=4; $_SESSION["u_pagina"]=1 ; //header('location: ' . $_SERVER['PHP_SELF'] . '?' . SID); $pag=$_SESSION['u_pagina']; } ////////////////////////////////FINE ///PAGINATION ///////// $rcount=mysql_num_rows($rs_query); if ($rcount==0 ) { $pages=0; } else { $pages=floor($rcount / $recperpage); if (($rcount%$recperpage) > 0 ) { $pages=$pages+1; } } $jmpcnt=1; while ( $jmpcnt<=($pg-1)*$recperpage && $row = mysql_fetch_array($rs_query) ) { $jmpcnt = $jmpcnt + 1; } $label=1; $featured_label=1; ?>

"; } else { ?> 1) { ?>

=1) { ?>

"") {?> immage

Brend:

Notizie/Storia

1) { $colcat=mysql_fetch_array(mysql_query("Select * from astevirtuali_categorie where id=" . $collegamento )); $colname=$colcat["cat_name"]; ?>Vedi pure Categoria:

Clicca Sulle Foto per i Dettagli o per Ordinare

=$recperpage)) { $blankpad=(($row*2)-$num)%2; while( ($blankpad>0) ) { ?>

&uid=" class="biglink"> " alt="" title="" width=220 border="0">	", '\n',$descr4); $descr2=str_replace("<", ' ',$descr3); $descr=str_replace(">", ' ',$descr2); ?> &uid=" class="biglink"> SKU:
=2 && $rs0["pezzi"]>=$rs0["pezzi_sconto"]) { ?> =1) { $sconto=$rs0["min_sconto"]$rs0["sconto_mom"]/100; $scontato=$rs0["min_sconto"]-$sconto; } else { $scontato=$rs0["min_sconto"]; } ?> Prezzo su qt: €. per Min. cf/.pz. &pz=&bold=" target="_self"> Non sappiamo Quando sarà daccapo disponibile &cid=&pz=1&bold="> &cid=&pz=1&bold="> - Non sappiamo Quando sara' daccapo disponibile - &pz=1&bold="> &pz=1&bold="> Nel Carrello 0) && ($rs0["sconto_mom"]>=1)) {?> 0) && ($rs0["sconto_mom"]<1)) {?> 0) && ($rs0["max_price"]>$rs0["min_bid"])) { ?> (Listino: ) =1) { $sconto=$rs0["min_bid"]$rs0["sconto_mom"]/100; $scontato=$rs0["min_bid"]-$sconto; ?> Offerta €.
=1) {?> :

" >

Pagina

" >