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'] = '
'.$ONENEWS['_ximg']['a'][0]['text'].'
'; 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']['a'][$ONENEWS['_ximg']['_k']]['text'].'
'; } } $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']; ?>