$time_limit=60*60*72*$notify_new_article;
if($keyQuery_Check) {
$query="SELECT uid, subject, comment, video_code, file_name1,signdate,postdate FROM osirase WHERE (language='K' OR language='A') AND dis_area LIKE '%E$%' AND display_chk='1' ".$keyfield_qry ." ORDER BY postdate DESC";
} else {
$query="SELECT uid, subject, comment, video_code, file_name1,signdate,postdate FROM osirase WHERE (language='K' OR language='A') AND dis_area LIKE '%E$%' AND display_chk='1' ORDER BY postdate DESC";
}
$result=mysqli_query($db,$query);
if(!$result) {
echo("QUERY_ERROR");
exit;
}
$toggle_bin=0;
$article_num=$total_record - $num_per_page*($page-1);
for($i=$first; $i<=$last; $i++) {
$my_uid=mysql_result($result, $i, 0);
$my_subject=mysql_result($result, $i, 1);
$my_comment=mysql_result($result, $i, 2);
$my_video_code=mysql_result($result, $i, 3);
$my_file_name=mysql_result($result, $i, 4);
$my_signdate=mysql_result($result, $i, 5);
$my_postdate=mysql_result($result, $i, 6);
$savedir="../upload_files/osirase";
$my_subject=stripslashes($my_subject);
$my_comment=stripslashes($my_comment);
$my_subject=htmlspecialchars($my_subject);
if ( mb_strlen($my_subject) >= 30){
$my_subject = mb_substr($my_subject,0,30);
$my_subject = $my_subject . "...";
}
if ( mb_strlen($my_comment) >= 200){
$my_comment = mb_substr($my_comment,0,200);
$my_comment = $my_comment . "...";
}
if(strcmp($keyfield, "subject")===0 && $key) {
$my_subject=preg_replace("/$key/", "
$key", $my_subject);
}
if(strcmp($keyfield, "comment")===0 && $key) {
$my_comment=preg_replace("/$key/", "
$key", $my_comment);
}
if(strcmp($keyfield1, "comment")===0 && $key) {
$my_comment=preg_replace("/$key/", "
$key", $my_comment);
}
if($my_file_name){
$my_comment .= "
";
}
if($my_video_code){
$my_comment .= "
";
}
$date_diff = time() - $my_postdate;
$my_signdate_list=date("y-m-d", $my_signdate);
$my_postdate_list=date("y-m-d", $my_postdate);
if(is_null($my_postdate)) { $my_postdate_list = $my_signdate_list;}
if (($i % 2) == 0){//evenの場合
echo("
");
}
if ($toggle_bin == 0){
echo("
");
$toggle_bin=1;
}else{
echo("
");
$toggle_bin=0;
}
//2列Start
echo("
");
$full_filename=explode(".", $my_file_name);
$extension= strtoupper($full_filename[sizeof($full_filename)-1]);
if($extension=="JPG" || $extension=="JPEG" || $extension=="GIF" || $extension=="BMP" || $extension=="PNG"){
echo("

");
}
echo("
$my_comment($my_postdate_list)
");
if($number == $my_uid) {
echo("
");
} else {
if($date_diff < $time_limit) {
echo("

");
}
}
echo("
"); //2列End
if (($i % 2) == 1){//oddの場合
echo("
");
}else{//final oddで終わる場合
if($i==$last){
echo("
");
}
}
$article_num--;
}
?>