#!/usr/local/bin/perl
$script = "event.html";
require './lib/jcode.pl';
require './lib/teikei.pl';
require './lib/dbsetup.pl';
use Time::Local;
# 1ページの表示件数
$pageView = 3;
# NEWアイコン
$newicon = '
';
# NEWアイコン表示する秒数(259200 = 72時間)
$newicon_time = 259200;
&decode;
$page = $in{'page'};
#----------------#
# 書込Cookie準備 #
#----------------#
#$|=1;
#print "Content-Type: text/html\n\n";
$setcook1 = &setCookie("ID", $COOKIE{ID});
$center .= '
|
東京エリアはこちら
最新記事:$tokyo_date
|
京浜エリアはこちら
最新記事:$keihin_date
|
|
大阪・阪神エリアはこちら
最新記事:$osaka_date
|

';
}elsif ($in{'area'} eq 'keihin'){
$imgdir = 'images2/event/photo2';
$areatext = '京浜';
$link = "東京エリア>
';
}elsif ($in{'area'} eq 'osaka'){
$imgdir = 'images2/event/photo3';
$areatext = '大阪・阪神';
$link = "東京エリア>
';
}
# 日時のフォーマット
@week = ('日','月','火','水','木','金','土');
# ページ送り
&DBConnect;
@res = @lines = ();
$sth = $db->prepare("SELECT DISTINCT year*10000+mon*100+day AS GaP FROM event_$in{'area'} ORDER BY GaP DESC,id ASC limit 0, 50");
if(!$sth->execute){ &error ("接続失敗2"); }
while(@res = $sth->fetchrow) {
push(@lines,$res[0]);
}
&DBDisconnect;
$allkiji = $#lines + 1;
# 総ページ数
$uc = ($allkiji % $pageView);
if ($uc == 0){
$user_cnt = int($allkiji / $pageView);
}else{
$user_cnt = int(($allkiji / $pageView) + 1);
}
$page_now = $in{'page'};
$last_page = $user_cnt;
# 前後に表示する数
$VNo = 2;
$page2 = $pageView;
$pager .= "| 全$user_cnt頁中 / $page_now頁目表\示 "; if ($in{'page'} eq "") { $in{'page'} = 1; } $start = $in{'page'} - $VNo; if ($start < 1) { $start = 1; } elsif ($start == 1) { ; } elsif ($start > 2) { $pager .= "[ 1 ] .."; } else { $pager .= "[ 1 ]"; } $end = $in{'page'} + $VNo; if ($end >= $last_page) { $end = $last_page; } elsif ($end < $last_page - 1) { $last_link = " .. [ $last_page ]\n"; } else{ $last_link = " [ $last_page ]\n"; } $n = $vp = $fl = 0; foreach $vp ($start .. $end) { $ffv = ($vp - 1) * $page2; if ($vp == $in{'page'}) { $n = 1; $page_now = $vp; if ($vp == 1){ $pager .= "[ $vp ] "; }elsif($vp == 2){ $Back_link = "[ 前の$pageView件 "; if ($end == 3){ $pager .= " $vp "; } else{ $pager .= " $vp |"; } }elsif($last_page == $vp){ $Back_link = "[ 前の$pageView件 "; $pager .= " [ $vp ]"; }else{ $Back_link = "[ 前の$pageView件 "; $pager .= "| $vp "; } }elsif ($vp == 1) { $pager .= "[ 1 ]"; }else{ if ($n) { $n = 0; $Next_link = " 次の$pageView件 ]"; $next = $vp; } else { $next = $vp; } if (($start > 1) && ($start == $vp) || ($fl == 0) && !($last_page == $vp)){ $pager .= " $next "; $fl++; }elsif ($last_page == $vp){ $pager .= " [ $next ]"; }else{ $pager .= "| $next "; } } } $pager .= " $last_link | "; $pager .= ""; # 次の何件 if ($last_page >= 2){ if (($Back_link ne "") && ($Next_link)){ $pager .= "$Back_link | $Next_link "; } elsif($Back_link eq ""){ $pager .= "[ $Next_link"; } elsif($Next_link eq ""){ $pager .= "$Back_link ]"; } } $pager .= " | "; $pager .= "
| $cateimg |
イベントリポート
$areatextエリアリスト |
$link |
| $year_d $mon_d/$day_d($week[$wday]) |
$newicon_view |
$res[6] |
$res[5] |
';
}elsif ($in{'area'} eq 'keihin'){
$imgdir = 'images2/event/photo2';
$areatext = '京浜';
$cateimg = '
';
}elsif ($in{'area'} eq 'osaka'){
$imgdir = 'images2/event/photo3';
$areatext = '大阪・阪神';
$cateimg = '
';
}elsif ($in{'area'} eq 'sapporo'){
$imgdir = 'images2/event/photo4';
$areatext = '札幌・道央';
$cateimg = '
';
}
&DBConnect;
@res = @lines = ();
$sth = $db->prepare("select * from event_$in{'area'} where time = $in{'q'}");
if(!$sth->execute){ &error ("接続失敗2"); }
while(@res = $sth->fetchrow) {
foreach(@res){
jcode::convert(\$_, 'sjis');
}
push(@lines,"$res[0]<>$res[1]<>$res[2]<>$res[3]<>$res[4]<>$res[5]<>$res[6]<>$res[7]<>$res[8]<>$res[9]<>$res[10]<>$res[11]<>$res[12]<>$res[13]<>$res[14]<>$res[15]<>$res[16]<>$res[17]<>$res[18]<>$res[19]<>$res[20]<>$res[21]<>$res[22]<>$res[23]<>$res[24]<>$res[25]<>$res[26]<>$res[27]<>$res[28]<>$res[29]<>$res[30]<>$res[31]<>$res[32]<>$res[33]<>$res[34]<>$res[35]<>");
}
&DBDisconnect;
$photo_view1 = $photo_view2 = $photo_view3 = $photo_view4 = "";
($t,$year,$mon,$day,$week,$eve_tit,$hall_name,$P1,$P1_count,$P2,$P2_count,$P3,$P3_count,$S1,$S1_count,$S2,$S2_count,$S3,$S3_count,$PG_comment,$photo1,$w1,$h1,$photo2,$w2,$h2,$photo3,$w3,$h3,$photo4,$w4,$h4,$vid,$koukan_P,$koukan_S,$PGqueen) = split(/<>/, $lines[0]);
if ($photo1 ne ""){
$photo_view1 = "| $year $mon/$day($week) | $hall_name |
$justwait"; }else{ if (($P1 ne "") & ($S1 ne "")){ $center .= "
\n";
}
if ($P1 ne ""){
$center .= '
| \n";
$center .= "\n";
}
if ($S1 ne ""){
$center .= '
| ||||||||||||||||||||||||||