9){
$query="SELECT * FROM `categorie` WHERE `cod`='".$item."'";
$result=mysql_query($query);
$rcat=mysql_fetch_array($result, MYSQL_ASSOC);
$tt=fText($rcat['denumire']);
$tcat=$rcat['denumire'];
if($i==0){
$numecat.="{$rcat['denumire']}";
}
else{
$numecat.=", {$rcat['denumire']}";
}
$i++;
}
}
if ($i>0){$numecat="Categoria: {$numecat}";}
// se determina colectia
$colectie="Colectia: ";
$collist=explode(',',$prod['colectie']);
$i=0;
foreach($collist as $item){
$query="SELECT * FROM `colectie` WHERE `cod`='".$item."'";
$result=mysql_query($query);
$numecol=mysql_fetch_array($result, MYSQL_ASSOC);
$tt=fText($numecol['denumire']);
$tcol=$numecol['denumire'];
if($i==0){
$colectie.="{$numecol['denumire']}";
$colcod0=$numecol['cod'];
$colnume0=$numecol['denumire'];
}
else{
$colectie.=", {$numecol['denumire']}";
}
$i++;
}
// prelucrare poze
$picname=$prod['poza'];
if($picname==''){$picname="nopic.gif";}
if (file_exists($path.$picpath.$picname)){
$pic="![](\"{$picpath}{$picname}\" "\\"{$prod['titlu']}")
";
//$pic="";
}
else{
$pic="![](\"{$picpath}resize.php?f=nopic.gif&h={$hmax}\" "\\"{$prod['titlu']}")
";
}
$prod['tehnic']=ereg_replace("\r\n",", ",$prod['tehnic']);
$prod['sumar']=ereg_replace("\r\n","
",$prod['sumar']);
$prod['sinopsis']=ereg_replace("\r\n","
",$prod['sinopsis']);
$tehnic=$prod['tehnic'];
$keys=array_keys($luni);
if($prod['ana']!=0){ //daca exista anul aparitiei
$tehnic.=", Aparitie: {$prod['ana']}, {$keys[$prod['lunaa']-1]}";
}
$promopic="";
if($prod['promo']=='1'){
$promopic="![](\"../images/prom.gif\")
";
}
$pret="{$promopic}PRET: {$prod['pret']} LEI";
if ($prod['redus']!=0){
$pret="{$promopic}PRET: {$prod['pret']} {$prod['redus']} LEI";
}
$prod['autor']=ereg_replace(", ",",",$prod['autor']);
$autori=split(',',$prod['autor']);
$autor="";
foreach ($autori as $nautor){
$autor.="{$nautor}
";
}
//$query="SELECT * FROM `carti` WHERE `colectie`='{$colcod0}' AND `isbn`<>'{$prod['isbn']}' ORDER BY RAND() LIMIT 9";
$query="SELECT * FROM `carti` WHERE `colectie`='{$colcod0}' ORDER BY RAND()";
$result=mysql_query($query);
$propcat=makeprodlist($result,"",true);
if ($propcat != ''){
$tags=maketag($query);
$tags.=maketag($query,4,'autor');
if ($tags != ''){$tags="Etichete
{$tags}
";}
}
//se verifica daca este in oferta
$isofcod="";
$query="SELECT `activ` FROM `oferta_text`";
$result=mysql_query($query);
$a=mysql_fetch_array($result, MYSQL_ASSOC);
if($a['activ']==1){
$query="SELECT * FROM `oferta` WHERE `isbn`='{$prod['isbn']}'";
$result=mysql_query($query);
$totofer=mysql_fetch_array($result, MYSQL_ASSOC);
if($totofer>0){
$isofcod=" ![](\"../images/ofer.gif\")
";
}
}
$fav="![](\"../images/addfav.gif\")
";
$buy="";
if($prod['categorie']=='2'){//in curand nu se afiseaza pretul
$pret="In curand...";
$buy="{$fav}";
}
else{
if($prod['stoc']=='999'){ //in curand
$pret="Momentan
indisponibil";
$buy="{$fav}";
}
elseif($prod['stoc']=='1000000'){
$pret="Free download";
$buy="{$fav}";
}
else{
if($prod['stoc']=='0'){ //in curand
$pret="Indisponibil momentan";
$buy="{$fav}";
}
}
}
$page=new ModulePage;
$page->page_location("$path"."templates/detail.html");
$page->parse_variable(array(PTITLU=>"{$prod['titlu']}, {$prod['autor']}, {$tcat}, {$tcol}",PIC=>$pic,TITLU=>$prod['titlu'],AUTOR=>$autor,MTXT=>$tehnic,PRET=>"{$pret}",OPIS=>$prod['sinopsis'],CATEGORIE=>$numecat,COLECTIE=>$colectie,NCOLECTIE=>$colnume0,PROPCAT=>$propcat,PID=>$pid,BUYBTN=>$buy,TAGS=>$tags) );
echo $page->send_page;
}
else{
$msg="{$picerr} Cartea nu a fost gasita pe site !";
$page=new ModulePage;
$page->page_location("$path"."templates/cfrm.html");
$page->parse_variable(array(PTITLU=>"{$tcat},{$tcol}",NP=>$np,MSG=>$msg) );
echo $page->send_page;
}
exit;
?>