$id=str_prepare($_GET['id']);
$sql="SELECT * FROM t_meniu AS m
INNER JOIN t_static AS s ON m.m_argument=s.s_id
WHERE (m.m_tip_pag='1' OR m.m_tip_pag='6') AND m_id='".$id."'";
$res=query($sql);
if(num($res)==0)
{
?>
=scrieTitluMeniu($id)?>
=trans("no_text")?>
}
else
{
$row=fetch($res);
if($row['m_tip_pag']=="1") // este de tip STATIC
{
?>
=scrieTitluMeniu($id)?>
$sql="SELECT * FROM t_static_detalii WHERE bd_b_id='".$row['s_id']."' ORDER BY bd_ordine";
$res=query($sql);
while($row=fetch($res))
{
switch($row['bd_tip'])
{
case "1":
$parag=$row['bd_text'];
echo str_display($parag);
break;
case "2":
$zoom=($row['bd_zoom']==1)?true:false;
?>
break;
case "3":
?>
$sql_1="SELECT * FROM t_static_galerii_detalii AS bgd
INNER JOIN t_static_galerii AS bg ON bgd.bgd_galerie=bg.bg_id
WHERE bg.bg_sectiune='".$row['bd_id']."'
ORDER BY bgd_ordine";
$res_1=query($sql_1);
while($row_1=fetch($res_1))
{
?>

}
?>
break;
case "4":
?>
scrieFlash_FLV_new(ABS_PATH.$PATHS['upload'].$row['bd_video']); ?>
break;
case "5":
?>
=str_display($row['bd_embed'])?>
break;
case "6":
$sql_1="SELECT * FROM t_static_uploaduri WHERE bu_id='".$row['bd_id_upload']."'";
$res_1=query($sql_1);
$row_1=fetch($res_1);
?>
break;
}
}
/* elemente aditionale in paginile statice */
if(str_prepare($_GET['id'])=='4' || str_prepare($_GET['id'])=='29') // turul virtual pus in pagina "Services & facilities"
{
?>
$sql="SELECT * FROM t_tur_virtual WHERE tur_lb='".LIMBA."' ORDER BY tur_area";
$res=query($sql);
$index=1;
while($row=fetch($res))
{
?>
=$row['tur_area']?>. =$row['tur_denumire']?>
if($index==ceil(num($res)/2)) echo "
";
$index++;
}
?>
}
?>
}
elseif($row['m_tip_pag']=="6") // este de tip SUBSTATIC
{
?>
=scrieTitluMeniu($id)?>
$sql="SELECT * FROM t_static_detalii WHERE bd_b_id='".$row['s_id']."' ORDER BY bd_ordine";
$res=query($sql);
while($rowA=fetch($res))
{
switch($rowA['bd_tip'])
{
case "1":
$parag=$rowA['bd_text'];
echo str_display($parag);
break;
case "2":
$zoom=($rowA['bd_zoom']==1)?true:false;
?>
break;
case "3":
?>
$sql_1="SELECT * FROM t_static_galerii_detalii AS bgd
INNER JOIN t_static_galerii AS bg ON bgd.bgd_galerie=bg.bg_id
WHERE bg.bg_sectiune='".$rowA['bd_id']."'";
$res_1=query($sql_1);
while($row_1=fetch($res_1))
{
?>

}
?>
break;
case "4":
?>
scrieFlash_FLV_new(ABS_PATH.$PATHS['upload'].$rowA['bd_video']); ?>
break;
case "5":
?>
=str_display($rowA['bd_embed'])?>
break;
case "6":
$sql_1="SELECT * FROM t_static_uploaduri WHERE bu_id='".$rowA['bd_id_upload']."'";
$res_1=query($sql_1);
$row_1=fetch($res_1);
?>
break;
}
}
$subPagSQL="SELECT * FROM t_meniu WHERE m_parent_id='".$row['m_id']."' ORDER BY m_ordine";
$subPagRes=query($subPagSQL);
?>
while($subPagRow=fetch($subPagRes))
{
?>
=$subPagRow['m_denumire']?>
}
?>
$subPagSQL="SELECT * FROM t_meniu WHERE m_parent_id='".$row['m_id']."'";
$subPagRes=query($subPagSQL);
while($subPagRow=fetch($subPagRes))
{
?>
$staticSql="SELECT * FROM t_static_detalii WHERE bd_b_id='".$subPagRow['m_argument']."' ORDER BY bd_ordine";
$staticRes=query($staticSql);
while($staticRow=fetch($staticRes))
{
switch($staticRow['bd_tip'])
{
case "1":
$parag=$staticRow['bd_text'];
echo str_display($parag);
break;
case "2":
$zoom=($staticRow['bd_zoom']==1)?true:false;
?>
break;
case "3":
?>
$sql_1="SELECT * FROM t_static_galerii_detalii AS bgd
INNER JOIN t_static_galerii AS bg ON bgd.bgd_galerie=bg.bg_id
WHERE bg.bg_sectiune='".$staticRow['bd_id']."'";
$res_1=query($sql_1);
while($row_1=fetch($res_1))
{
?>

}
?>
break;
case "4":
?>
scrieFlash_FLV_new(ABS_PATH.$PATHS['upload'].$staticRow['bd_video']); ?>
break;
case "5":
?>
=str_display($staticRow['bd_embed'])?>
break;
case "6":
$sql_1="SELECT * FROM t_static_uploaduri WHERE bu_id='".$staticRow['bd_id_upload']."'";
$res_1=query($sql_1);
$row_1=fetch($res_1);
?>
break;
}
}
?>
}
?>
}
}
?>
// if(str_prepare($_GET['mod'])=="static" && (str_prepare($_GET['id'])=='19' || str_prepare($_GET['id'])=='41'))
// include "formular_contact.php";
// else
// {
//include "stiri_mic.php";
?>
include "dreapta.php"; ?>
// }
?>