if(isset($_GET['id']))
{
$id=str_prepare($_GET['id']);
$sql_main="SELECT * FROM t_articole WHERE art_id='".$id."'";
$res_main=query($sql_main);
$row_main=fetch($res_main);
?>
=scrieTitluCustom(ucfirst(trans("proiecte"))." > ".str_display($row_main['art_denumire']))?>
$sql="SELECT * FROM t_galerie WHERE g_art_id='".$id."' ORDER BY g_ordine";
$res=query($sql);
while($row=fetch($res))
{
?>
}
?>
// descrierea
if($row_main['art_descriere']!="")
{
?>
=$row_main['art_descriere']?>
}
$set=$row_main['art_set'];
$sql="SELECT * FROM t_atribute_set_grupe WHERE asg_set='".$set."'";
$res=query($sql);
while($row=fetch($res))
{
$sql_leg="SELECT * FROM t_atribute_set_legaturi AS asl
INNER JOIN t_atribute AS atr ON asl.asl_atribut=atr.atr_id
WHERE asl_grupa='".$row['asg_id']."'";
$res_leg=query($sql_leg);
$sql_val_test="SELECT * FROM t_atribute_set_legaturi AS asl
INNER JOIN t_articole_valori AS artv ON artv.artv_atribut=asl.asl_atribut
WHERE asl_grupa='".$row['asg_id']."' AND artv_articol='".$id."'";
$res_val_test=query($sql_val_test);
if(num($res_leg)>0 && num($res_val_test)>0)
{
$sql_trad="SELECT tr_traducere FROM t_traduceri AS tr
INNER JOIN t_limbi AS lb ON lb.lb_id=tr.tr_limba
WHERE tr_keyword='".$row['asg_keyword']."'
AND lb_scurt='".LIMBA."'";
$res_trad=query($sql_trad);
$row_trad=fetch($res_trad);
?>
echo ($row_trad['tr_traducere']!="")?str_display($row_trad['tr_traducere']):str_display($row['asg_denumire']); ?>
$index=1;
while($row_leg=fetch($res_leg))
{
$sql_val="SELECT * FROM t_articole_valori WHERE artv_atribut='".$row_leg['atr_id']."' AND artv_articol='".$id."'";
$res_val=query($sql_val);
$row_val=fetch($res_val);
if($row_val['artv_valoare']!="")
{
?>
">
|
$sql_trad="SELECT tr_traducere FROM t_traduceri AS tr
INNER JOIN t_limbi AS lb ON lb.lb_id=tr.tr_limba
WHERE tr_keyword='".$row_leg['atr_keyword']."'
AND lb_scurt='".LIMBA."'";
$res_trad=query($sql_trad);
$row_trad=fetch($res_trad);
echo ($row_trad['tr_traducere']!="")?str_display($row_trad['tr_traducere']):str_display($row_leg['atr_denumire']);
?>
|
echo nl2br(str_display($row_val['artv_valoare']));
?>
|
$index++;
}
}
?>
}
}
?>