query($qstr); if ($item->nf() ==1 ) { $item->next_record(); if (!good_owner($item->f('OID'))) { send404(); } } else { send404(); } $tpl = new Template(".", 'comment'); $tpl->set_file ('page', $setup['TEMPLATE'] ); $tpl->set_block('page','dettaglio','dd'); $rl->query('SELECT s_oggetto.*, UNIX_TIMESTAMP(s_oggetto.data) AS udata, s_testi.titolo AS tt, s_testi.sottotitolo AS st, s_testi.ID AS tid FROM s_oggetto, s_testi, s_clienti2oggetti WHERE s_testi.oggetto = s_oggetto.ID AND s_oggetto.categoria = '.$item->f('categoria').' AND s_testi.ID != '.$ID.' AND s_clienti2oggetti.cliente = '.$setup['ID_CLIENTE'].' AND s_clienti2oggetti.oggetto = s_oggetto.ID ORDER BY s_oggetto.ID DESC LIMIT '.$setup['NUM']); $reltxt = array(); while ($rl->next_record()) { $reltxt[] = sprintf('

%s [%s]

', $rl->f('tid'), $rl->f('tt'), date('d/m', $rl->f('udata'))); } $tpl->set_var('RELATED', join("\n", $reltxt)); $tpl->set_var('KEYWORDS', $item->f('keywords') ); $tpl->set_var('TITOLO', $item->f('titolo') ); $tpl->set_var('SOTTOTITOLO', ifPara( $item->f('sottotitolo') ) ); $tpl->set_var('TIPO', $item->f('tipo') ); $tpl->set_var('LOCALE', $item->f('locale') ); $tpl->set_var('PROVINCIA', $item->f('provincia') ); $tpl->set_var('FONTE', $item->f('fonte_text') ); if ($item->f('fonte') !=0) { $extra->query('SELECT url FROM s_fonti WHERE ID = '.$item->f('fonte')); $extra->next_record(); $tpl->set_var('FONTEURL', $extra->f('url') ); } else { $tpl->set_var('FONTEURL', ''); } $tpl->set_var('AUTORE', $item->f('autore_text') ); $tpl->set_var('CATEGORIA', $item->f('categoria_text') ); $tpl->set_var('CATID', $item->f('categoria') ); $tpl->set_var('DATA', date( $setup['FORMATO_DATA'],$item->f('udata') ) ); $tpl->set_var('TSTAMP', date( 'H:i:s d/m/Y', $item->f('uts') ) ); $tpl->set_var('ABSTRACT', ifPara( $item->f('abstract') ) ); $tpl->set_var('TESTO', $item->f('corpo') ); $urls = new DB; $urls->query('SELECT s_categorie2links.link FROM s_categorie2links, s_clienti2links WHERE categoria = '.$item->f('categoria').' AND s_clienti2links.cliente = '.$setup['ID_CLIENTE'].' AND s_clienti2links.link = s_categorie2links.link'); if ($urls->nf() > 0) { $alink = new DB; $li = array(); while ($urls->next_record()) { $alink->query('SELECT * FROM s_url WHERE ID = '.$urls->f('link')); $alink->next_record(); $li[] = sprintf('', $alink->f('URL'), $alink->f('label'), $alink->f('commento') ); } $str = join("\n",$li); } $tpl->set_var('LINKLIST', $str); $tpl->parse('mfo', 'page'); $tpl->p('mfo'); pageEnd(); ?>