include_once "myconnect.php"; function main() { /////////////getting null char include "myutente.php"; //////////////////////////////////////////////// ///////// if (isset($_REQUEST["pt"])) {$pt=$_REQUEST["pt"];$lingua=$_REQUEST["pt"];$_SESSION["ling"]=$_REQUEST["pt"];} else { if (isset($_SESSION["ling"])) {$pt=$_SESSION["ling"];$lingua=$_SESSION["ling"];} else {$pt=1;$lingua=1;} } ///////////////////////////////////////////////////////// include "lingua.php"; include_once "include-visite.php"; //////////////////////////////////////////////// ///////// //$config=mysql_fetch_array(mysql_query("select * from astevirtuali_configurazione")); $config=mysql_fetch_array(mysql_query("select recperpage from astevirtuali_configurazione")); $null_char[0]=$config["null_char"]; //////////////////////////////controllo utente eshop ///////// $rsu=mysql_fetch_array(mysql_query("select * from astevirtuali_utenti where id=".$uid)); if($rsu["eshop"]=="") { //header("Location: ". "eshop.php?uid=161"); //die(); } ///////////////////////////////////session///////// session_start(); if (!isset($_SESSION['cart'])) { $_SESSION['cart'] = array(); setcookie("cart",time()+777600); setcookie('cart'.'pez',time()+777600); setcookie('cart'.'not',time()+777600); setcookie('cart'.'pag',time()+777600); setcookie('cart'.'sco',time()+777600); setcookie('cart'.'dove',time()+777600); setcookie('cart'.'myg',time()+777600); } //-----------------------------------------/// if (($_GET['azzera']==1)) { unset ($_SESSION['cart']); header('location: ' . $_SERVER['PHP_SELF'] . '?' . SID); exit(); } if (($_GET['empty']==1)) { $_SESSION['cart'.'pez'][$_GET['pz']] = "0"; echo ''; } 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($cid>=1) { 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)) { if($lingua<=1) { $traC=$rs["cat_name"];} if(($lingua==2) && ($rs["c2"]<>"")) { $traC=$rs["c2"];} else { $traC=$rs["cat_name"];} if(($lingua==3) && ($rs["c3"]<>"")) { $traC=$rs["c3"];} else { $traC=$rs["cat_name"];} if(($lingua==4) && ($rs["c4"]<>"")) { $traC=$rs["c4"];} else { $traC=$rs["cat_name"];} if(($lingua==5) && ($rs["c5"]<>"")) { $traC=$rs["c5"];} else { $traC=$rs["cat_name"];} if(($lingua==6) && ($rs["c6"]<>"")) { $traC=$rs["c6"];} else { $traC=$rs["cat_name"];} $catpath ="> " .$traC."" . $catpath; $rs_query=mysql_query("Select * from astevirtuali_categorie where id=" . $rs["pid"] ); } if ($_REQUEST["brend"] > 0 ) { $_REQUEST["radio"]=1; $recperpage=290 ; //$config["recperpage"]; } else { $recperpage=36 ; //$config["recperpage"]; } // ---- inizio SQL proncipale ............. $sql="select "; if ($_REQUEST["radio"]>=1) {$sql.=" id, product_name, product_subt, soddisfatti, cid, tempi, peso, codice, location, raffina2, raffina3, raffina0, raffina4, raffina, codice, pezzi, pezzi_sconto, sconto_mom, min_sconto, min_bid, max_price,";} else {$sql.=" *,";} $sql.=" 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 aucid in (1,3,5,6,7,8,10,11,12,14,20,21,25,27,28,30,31,36,37,38,45,175)"; 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='open' "; //,'conclusa vend','Venduto' if (($_REQUEST["radio"]>=1) || ($cid>10)) { $sql.=" and uid in (175,31,28,27,11,12,14,37,45,72,30,36,38,39,3,4,5,7,8,21,10)";} // 7 e 9 è ditta per orologi da fare a parte ! else { $sql.=" and uid in (175,31,28,27,11,12,14,37,45,72,30,36,38,39,3,4,5,7,8,21,10) 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 product_subt like'%".str_replace("'","''",$_REQUEST["keyword"])."%' or codice like'%".str_replace("'","''",$_REQUEST["keyword"])."%' or raffina like'%".str_replace("'","''",$_REQUEST["keyword"])."%' or raffinaa like'%".str_replace("'","''",$_REQUEST["keyword"])."%' or raffinab like'%".str_replace("'","''",$_REQUEST["keyword"])."%' or raffina0 like'%".str_replace("'","''",$_REQUEST["keyword"])."%' or raffina3 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"])."') "; } 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.")"; } /////////////////////////////////////////////// $rst1_query=mysql_query("Select * from astevirtuali_categorie where pid=" . $cid ); $clist=$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 . ")") ; } $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, featured desc" ; // , date_submitted desc } //$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; ?> ////////////////////////////////FINE ///categoria cid ///////// $_SESSION["visita"][$uid] =$cid; // sta visitando $_SESSION["pagina"]="galleria"; // sta visitando ?>
| |||||||||
|
|||||||||
$si = 0;
for ($ni = 0; $ni <= count($_SESSION['cart'.'art']); $ni++)
{
if ($_SESSION['cart'.'art'][$ni]==$rs0["id"] )
{
$si = 1;
}
}
if ($si==0)
{
if ($rs0["pezzi_sconto"]>=2 && $rs0["pezzi"]>=$rs0["pezzi_sconto"])
{
?>
}
?> if($rs0["sconto_mom"]>=1) { $sconto=$rs0["min_sconto"]*$rs0["sconto_mom"]/100; $scontato=$rs0["min_sconto"]-$sconto; } else { $scontato=$rs0["min_sconto"]; } ?> if($lingua==1) { echo 'Prezzo su Quantità:';} if($lingua==2) { echo 'Price on Quantity:';} if($lingua==3) { echo "Prix sur Quantité:";} if($lingua==4) { echo 'Preis auf Menge:';} if($lingua==5) { echo 'Escandallo sobre Cantidad:';} if($lingua==6) { echo 'Prijs op hoeveelheid:';} ?> €. echo $scontato;?> if($lingua==1) { echo 'Per Minimo:';} if($lingua==2) { echo 'For Least:';} if($lingua==3) { echo "Pour Minimum:";} if($lingua==4) { echo 'Für am wenigsten:';} if($lingua==5) { echo 'Por Mínimo:';} if($lingua==6) { echo 'Voor ten minste:';} ?> echo $rs0["pezzi_sconto"];?> cf/.pz. &pz= echo $rs0["pezzi_sconto"] ?>" target="_self"> } //$_SESSION['u_pagina']=$pg; if ($cid==0) { if ($rs0["pezzi"]==0) if ($rs0["tempi"]=="2 mesi") { ?> Non sappiamo Quando sarà daccapo disponibile } else {echo " - - "; } else { if ($rs0["pezzi"]<0) {?> &pz=1"> } else {?> &cid= echo $rs0["cid"]; ?>&pz=1"> } } //echo "galleria.php?uid=" . $uid . "&pg=" . $pg . "&buy=" . $rs0["id"]. "&pz=1" } else { if ($rs0["pezzi"]==0) { if ($rs0["tempi"]=="2 Mesi") { ?>- Non sappiamo Quando sara' daccapo disponibile - } else {echo "- - -"; } } else { if ($rs0["pezzi"]<=0) {?>&cid= echo $rs0["cid"]; ?>&pz=1"> } else {?>&cid= echo $rs0["cid"]; ?>&pz=1"> } } } } else { ?> if($lingua==1) { echo 'Nel Carrello';} if($lingua==2) { echo 'in the cart';} if($lingua==3) { echo "dans le panier";} if($lingua==4) { echo 'Im Karren';} if($lingua==5) { echo 'en un carro';} if($lingua==6) { echo 'In de winkelwagen';} ?>
Eur.
if (($rs0["pezzi"]>0) && ($rs0["sconto_mom"]>=1)) // prezzo di vendita if($rs0["sconto_mom"]>=1) { $sconto=$rs0["min_bid"]*$rs0["sconto_mom"]/100; $scontato=$rs0["min_bid"]-$sconto; ?> €. echo number_format($scontato, 2, ',', ' ') ?> } else { $scontato=$rs0["min_bid"]; } $imponibile=$scontato/1.21; $imponibile=number_format($imponibile, 2, ',', ' '); // solo 2 decimali ?> |
|||||||||
/////////////////////////////////// lingue straniere ////////////////////////////
$rs_n=mysql_fetch_array(mysql_query("select * from astevirtuali_prodotti_note where nid=".$rs0["id"]));
//////////////////////////////////////////////////////////////
//if (($lingua>1) && (strstr($rs0["done"],$lingua)))
if (($lingua>1))
{
if($lingua==2) { echo $rs_n["titolo_en"]." ".substr($rs_n["sottotitolo_en"],0,40);} if($lingua==3) { echo $rs_n["titolo_fr"]." ".substr($rs_n["sottotitolo_fr"],0,40);} if($lingua==4) { echo $rs_n["titolo_de"]." ".substr($rs_n["sottotitolo_de"],0,40);} if($lingua==5) { echo $rs_n["titolo_es"]." ".substr($rs_n["sottotitolo_es"],0,40);} if($lingua==6) { echo $rs_n["titolo_nl"]." ".substr($rs_n["sottotitolo_nl"],0,40);} } else {echo "" .substr($titolo, 0,57)." ".substr($rs0["product_subt"],0,40)."";} ?> |
|||||||||
if(($rt_d["raffina0"]<>'') || ($rt_d["raffina1"]<>''))
{?>
echo $rt_d["raffina0"];?> echo $rt_d["raffina1"];?> } ?> |
|||||||||
if ($pg!=1) { //$pg=$pg-1; //$_SESSION['u_pagina']=($pg-1); ?> } ?> if ($pg!=1) { ?> } ?> | Pg | di | if ($pg!=$pages) { //$pg=$pg+1; //$_SESSION['u_pagina']=($pg+1); ?> } ?> if ($pg!=$pages) { ?> } ?> |
echo $descrizione; ?> |