header('Content-type: text/html; charset=ISO-8859-1');
include '../modules/InterfaceChunks.php';
include '../modules/ConfigInc.php';
include '../admin/modules/DbControl.php';
$lingua = "deu";
$section = "news";
$id = $_GET['id'];
$pn = $_GET['pn']; if(!$pn){$pn=1;} //page number
$dbc = new DbControl();
$dbdata = $dbc->get_db_conn_var();
$pid = mysql_connect($dbdata[0],$dbdata[1],$dbdata[2]); mysql_select_db($dbdata[3]);
$sql = "SELECT * FROM albekduo_notizie WHERE id=$id";
$res = mysql_query($sql);
$row = mysql_fetch_array($res);
$int_chnk = new InterfaceChunks();
$int_chnk->getHead();
?>
|
$id=$row['id'];
$titolo = stripslashes(utf8_decode($row['titolo']));
$data = $int_chnk->formatDate(stripslashes($row['data']));
$luogo = stripslashes(utf8_decode($row['luogo']));
$informazione = preg_replace("/\n/", " ", stripslashes(utf8_decode($row['informazione'])));
//estrazione documenti
$docs = array();
$sql2 = "SELECT * FROM albekduo_notizie_docs WHERE online=1 and obj_id =".$id." ORDER BY col_order desc";
$res2 = mysql_query($sql2);
while($row2 = mysql_fetch_array($res2)){
array_push($docs, $row2);
}
//estrazione immagini
$imgs = array();
$sql2 = "SELECT * FROM albekduo_notizie_imgs WHERE online=1 and obj_id =".$id." ORDER BY col_order desc";
$res2 = mysql_query($sql2);
while($row2 = mysql_fetch_array($res2)){
array_push($imgs, $row2);
}
?>
}?>
//se ci sono immgini
if(sizeof($imgs)){
$imageInfo = getimagesize($cfg['common']['doc_news_path'].$imgs[0]['img']);
$width = $imageInfo[0];
($width > $cfg['common']['news_max_pic_width'])? $pic_width=250 : $pic_width=$width;
?>
}?>
//se ci sono documenti
if(sizeof($docs)){?>
|
|
|
|
}?>
}?>
|
|
|
|
|
$int_chnk->getBottom();
?>