$ONENEWS['q'] = mysql_query('
SELECT DISTINCT t.id, t.rname, t.xzab, t.xtxt, t.xphoto, DATE_FORMAT(t.xdate, \'%d.%m.%Y\') AS fxdate
FROM '.DB_PRE.'news t, '.DB_PRE.'news_links tl
WHERE t.id>0 AND t.xparent=0 AND t.xhistory=0 AND t.xshow=0 AND t.xl_4_4 IN (5) AND t.id=tl.tid AND tl.xl_15_0 IN ('.$EVENT['id'].')
ORDER BY t.xdate DESC, t.xorder DESC, t.id DESC
');
print '
';
while ( $ONENEWS['r'] = mysql_fetch_assoc( $ONENEWS['q'] ) ) {
$ONENEWS['_ximg']['a'] = array();
if( $ONENEWS['r']['xphoto'] != '' ) {
$ONENEWS['_ximg']['a'][] = array(
'text' => '',
'_xhref' => $ONENEWS['r']['xphoto'],
'_xhref_p' => $ONENEWS['r']['xphoto'],
);
}
# изображения
$ONENEWS['_ximg']['q'] = mysql_query('
SELECT *
FROM '.DB_PRE.'ximg
WHERE xtable=13 AND xstring=\''.$ONENEWS['r']['id'].'\' AND pok=0
ORDER BY sta DESC, por
');
while ( $ONENEWS['_ximg']['r'] = mysql_fetch_assoc($ONENEWS['_ximg']['q']) ) {
$ONENEWS['_ximg']['a'][] = array(
'text' => $ONENEWS['_ximg']['r']['text'],
'_xhref' => XIMG.'news/'.$ONENEWS['_ximg']['r']['id'].'-m.'.$CONFIG['imgtypes'][$ONENEWS['_ximg']['r']['tip']],
'_xhref_p' => XIMG.'news/p/'.$ONENEWS['_ximg']['r']['id'].'-100.'.$CONFIG['imgtypes'][$ONENEWS['_ximg']['r']['tip']],
);
} mysql_free_result($ONENEWS['_ximg']['q']);
if ( count($ONENEWS['_ximg']['a']) > 0 ) {
$ONENEWS['_ximg']['size'] = getimagesize( $_SERVER['DOCUMENT_ROOT'].$ONENEWS['_ximg']['a'][0]['_xhref'] );
if ( $ONENEWS['_ximg']['size'][0] > 360 ) {
$ONENEWS['_ximg']['size'][0] = 360;
}
$ONENEWS['_ximg']['t'] = '
';
unset($ONENEWS['_ximg']['a'][0]);
if ( $ONENEWS['_ximg']['a'][1] ) {
foreach ( $ONENEWS['_ximg']['a'] as $ONENEWS['_ximg']['_k'] => $ONENEWS['_ximg']['_v'] ) {
$ONENEWS['_ximg']['t'] .= '
';
}
}
$ONENEWS['_ximg']['t'] .= '
|
';
}
# изображения
print '
'.$ONENEWS['r']['rname'].'
'.$ONENEWS['r']['fxdate'].'
'.$ONENEWS['_ximg']['t'].'
'.$ONENEWS['r']['xzab'].'
'.$ONENEWS['r']['xtxt'].'
|
|
';
} mysql_free_result( $ONENEWS['q'] );
print '
';
$CONFIG['base_url_len'] = strlen(FM_BASEURL);
$OUTPUT['q'] = mysql_query('
SELECT DISTINCT l.xl_15_0, c.xl_4_1209, t.id, t.xfile, t.xoldicon, c.rname, DATE_FORMAT(c.xdate, \'%d.%m.%y\') AS fxdate, DATE_FORMAT(c.xdateend, \'%d.%m.%y\') AS fxdateend, bg.rname AS bgrname
FROM '.DB_PRE.'photos t, '.DB_PRE.'photos_links l, '.DB_PRE.'calendar c, '.DB_PRE.'books bg
WHERE t.id>0 AND t.xparent=0 AND t.xhistory=0 AND t.xshow=0
AND t.id=l.tid AND l.xshow=0 AND l.xl_15_0 NOT IN (2880)
AND l.xl_15_0=c.id AND c.xparent=0 AND c.xhistory=0 AND c.xshow=0 AND c.xl_4_1183 IN (3031)
AND l.xl_15_0 IN ('.$EVENT['id'].')
AND c.xl_4_39=bg.id AND bg.xhistory=0 AND bg.xshow=0
ORDER BY c.xdate DESC, c.xdateend DESC, c.id DESC
');
if ( mysql_num_rows($OUTPUT['q']) > 0 ) {
$OUTPUT['s'] = '';
while ( $OUTPUT['r'] = mysql_fetch_assoc($OUTPUT['q']) ) {
if ( $OUTPUT['r']['fxdate'] != $OUTPUT['r']['fxdateend'] && $OUTPUT['r']['fxdateend'] != '00.00.00' ) {
$OUTPUT['r']['fxdate'] = $OUTPUT['r']['fxdate'].'-'.$OUTPUT['r']['fxdateend'];
}
if ( $OUTPUT['r']['xl_4_1209'] == 1210 ) {
$OUTPUT['r']['rname'] = '
'.$OUTPUT['r']['rname'].'';
}
if ( $OUTPUT['r']['xoldicon'] != '' ) {
$OUTPUT['r']['_xfile'] = $OUTPUT['r']['xoldicon'];
} else {
$OUTPUT['r']['_xfile'] = substr_replace($OUTPUT['r']['xfile'], FM_BASEURL.'_thumbs/', 0, $CONFIG['base_url_len']);
}
$OUTPUT['r']['_size'] = getimagesize($_SERVER['DOCUMENT_ROOT'].'/'.$OUTPUT['r']['_xfile']);
$OUTPUT['r']['_size']['_p'] = round((100-$OUTPUT['r']['_size'][1])/2);
$OUTPUT['a'][$OUTPUT['r']['xl_15_0']]['n'] = $OUTPUT['r']['rname'].' '.$OUTPUT['r']['fxdate'].', '.$OUTPUT['r']['bgrname'];
$OUTPUT['a'][$OUTPUT['r']['xl_15_0']]['a'] .= '
';
}
} mysql_free_result($OUTPUT['q']);
$OUTPUT['s'] = '';
foreach( $OUTPUT['a'] as $val ) {
$OUTPUT['s'] .= '
Фотогалерея
'.$val['a'].'
';
}
print $OUTPUT['s'];
?>
include 'i_page_bottom.htm';
?>