";
$HTML[] = "
";
output_html($HTML);
spacer(5);
include_once('bbs.u.form.php');
// -----------------------------------------------------------------------// おしらせの表示
$tid = fcn_sql_sa('select id from '._TABLE_NOT_.' '
. "where app_id="._APP_ID_." and type='nau' and status='alive' "
. 'order by id desc limit 1');
if(!empty($tid)) include_once('bbs.u.notice.php');
// -----------------------------------------------------------------------------
// ■ ログ出力
// -----------------------------------------------------------------------------
// -----------------------------------------------------------------------// SQL
$sql_log = 'select '
. 'count('._TABLE_L_.'.id) as num_sum,'
. _TABLE_L_ . '.id,'
. _TABLE_L_ . '.log_id,'
. _TABLE_L_ . '.icon_id as l_icon_id,'
. _TABLE_L_ . '.date_c,'
. _TABLE_L_ . '.name,'
. _TABLE_L_ . '.mail,'
. _TABLE_L_ . '.subject,'
. _TABLE_L_ . '.message,'
. _TABLE_L_ . '.url,'
. _TABLE_L_ . '.type,'
. _TABLE_L_ . '.status,'
. _TABLE_I_ . '.id as i_icon_id,'
. _TABLE_I_ . '.iconname,'
. _TABLE_I_ . '.filename '
. 'from ' . _TABLE_L_.','._TABLE_I_.' '
. 'where ' . _TABLE_L_.'.icon_id='._TABLE_I_.'.id '
. 'and ' . _TABLE_L_.".type='log' "
. 'and ' . _TABLE_L_.".status='alive' "
. 'and ' . _TABLE_I_.".status='alive' "
. 'group by '._TABLE_L_.'.log_id '
. 'order by '._TABLE_L_.'.log_id desc';
if($LOG['num_page_now']==0){
$sql_log .= ' limit '.$LOG['num_log_per_page'];
}else{
$sql_log .= ' limit '.$LOG['num_page_now'] * $LOG['num_log_per_page'].','.$LOG['num_log_per_page'];
}
// ■■ DEBUG
//if(_SITE_TEST_ =='On') test($LOG); test($sql_log); spacer(10);
// -----------------------------------------------------------------------// ログ出力
$Rslt = fcn_sql_exec($con,$sql_log);
$rows = mysql_num_rows($Rslt);
if($rows ==0){
// ---------------------------------------------------------------------// 書き込みが0の場合
spacer(20);
$HTML[] = '
';
$HTML[] = '';
$HTML[] = '';
$HTML[] = '';
$HTML[] = '';
$HTML[] = ' | ';
$HTML[] = 'まだ書き込みがありません。
| ';
$HTML[] = ' | ';
$HTML[] = ' ';
$HTML[] = ' ';
$HTML[] = ' | ';
$HTML[] = '
';
$HTML[] = '
';
output_html($HTML);
}else{
// ---------------------------------------------------------------------// ログ表示
include('bbs.u.navi.php');
spacer(10);
while ($Rec = mysql_fetch_array($Rslt)){
include('bbs.u.log.php');
spacer(10);
}
include('bbs.u.navi.php');
}
print '