カテゴリクラスの値が異常です.

\n"); } // 親のユーザID if ( !isset($_REQUEST['f_puserid']) ){ $parent_userid = 0; }else{ $parent_userid = (int)$_REQUEST['f_puserid']; } // ユーザID if ( !isset($_REQUEST['f_userid']) ){ $author_userid = 0; }else{ $author_userid = (int)$_REQUEST['f_userid']; } // さかのぼる日付 if ( !isset($_REQUEST['f_days']) ){ $past_days = -10; }else{ $past_days = (int)$_REQUEST['f_days']; // if ( $past_days < 0 ){ // error("

さかのぼる日付の値が異常です.

\n"); // } } // さかのぼらない日付 if ( !isset($_REQUEST['f_dayn']) ){ $passing_days = 0; }else{ $passing_days = (int)$_REQUEST['f_dayn']; // if ( $passing_days < 0 ){ // error("

さかのぼらない日付の値が異常です.

\n"); // } } // 一度に表示する件数 $count_per_page = 10; if ( isset($_REQUEST['f_count']) && (int)$_REQUEST['f_count'] >= 0 ){ $count_per_page = (int)$_REQUEST['f_count']; } // 表示し始める件目 $skip_count = 0; //最初から if ( isset($_REQUEST['f_index']) && (int)$_REQUEST['f_index'] >= 0 ){ $skip_count = (int)$_REQUEST['f_index']; } // 詳細表示スイッチ if ( !isset($_REQUEST['f_nodtl']) ){ $detail_flag = 1; }else{ $detail_flag = 0; } // 呼び出されたURLをパラメータつきで $url_self_now = "$url_self?f_revid=$review_id"; if ( isset($_REQUEST['f_class']) ) $url_self_now .= "&f_class=$review_class_id"; if ( isset($_REQUEST['f_puserid']) ) $url_self_now .= "&f_puserid=$parent_userid"; if ( isset($_REQUEST['f_userid']) ) $url_self_now .= "&f_userid=$author_userid"; //************************************************** // // メイン // //************************************************** //****************************** // レビューの子の数を数える //****************************** $sql = << 0 ){ $sql .= "AND r.CreatedDate >= DATE_SUB(NOW(), INTERVAL $past_days DAY)" . "\n"; } // さかのぼらない日付条件 if ( $passing_days > 0 ){ $sql .= "AND r.CreatedDate < DATE_SUB(NOW(), INTERVAL $passing_days DAY)" . "\n"; } // 親のユーザID 条件 if ( isset($_REQUEST['f_puserid']) ){ $sql .= << 0 ){ $sql .= "LIMIT " . ((int)$skip_count) . ", " . ((int)$count_per_page) . "\n"; } $result = db_query($db, $sql); $childcount = array(); while ( ($row = mysqli_fetch_array($result)) ){ $childcount[(int)$row['ReviewID']] = (int)$row['ChildCount']; } mysqli_free_result($result); //****************************** // レビューを読み込む //****************************** $sql = << 0 ){ $sql .= "AND r.CreatedDate >= DATE_SUB(NOW(), INTERVAL $past_days DAY)" . "\n"; } // さかのぼらない日付条件 if ( $passing_days > 0 ){ $sql .= "AND r.CreatedDate < DATE_SUB(NOW(), INTERVAL $passing_days DAY)" . "\n"; } // 親のユーザID 条件 if ( isset($_REQUEST['f_puserid']) ){ $sql .= "AND p.UserID = $parent_userid" . "\n"; } // 本体のユーザID 条件 if ( isset($_REQUEST['f_userid']) ){ $sql .= "AND r.UserID = $author_userid" . "\n"; } // ゴミ箱は非表示 $sql .= "AND r.ParentReviewID <> 3404" . "\n"; $sql .= << 0 ){ $sql .= "LIMIT " . ((int)$skip_count) . ", " . ((int)$count_per_page) . "\n"; } $result = db_query($db, $sql); $num = mysqli_num_rows($result); //****************************** // 出力開始 //****************************** ob_start(); html_header("review", SCREEN_REVIEW); // 三段組の開始 print "
\n"; // 左の段組の開始 print "
\n"; // メニュー print "

Menu

\n"; print "
  • 全カテゴリへ\n"; print "
  • 評者の集計\n"; print "
    \n"; print "
  • 新着リスト\n"; print "
  • 新着コメント\n"; if ( $user_id > 0 ){ print "
    \n"; print "
  • あなたへの
    新着コメント    \n"; } print "
    \n"; print "
  • 評を書く
    \n"; print "
    \n"; if ( $user_id > 0 ){ print "ログイン
    しています
    ユーザ情報
    ユーザ情報の変更"; print "
    \n"; print "\n"; print "
    \n"; }else{ print "ログイン
    していません
    登録\n"; } // 左の段組の終了 print "
    • \n"; // 段組の区切り線 //print "\n"; // 中央の段組の開始 print "
    \n"; //------------------------------ // 中央の段組 //------------------------------ print "

    \n"; // $url_suffix = ''; if ( isset($_REQUEST['f_class']) ) $url_suffix .= "&f_class=$review_class_id"; if ( isset($_REQUEST['f_puserid']) ) $url_suffix .= "&f_puserid=$parent_userid"; if ( isset($_REQUEST['f_userid']) ) $url_suffix .= "&f_userid=$author_userid"; // 前週 if ( $past_days >= 0 ){ $days = $past_days + 7; $dayn = $passing_days + 7; $url = $url_self . "?f_days=$days&f_dayn=$dayn" . $url_suffix; print " 前週"; } // 次週 if ( $passing_days > 0 ){ $days = $past_days - 7; $dayn = $passing_days - 7; if ( $dayn <= 0 ) $dayn = 0; $url = $url_self . "?f_days=$days&f_dayn=$dayn" . $url_suffix; if ( $dayn <= 0 ){ print " 最新週\n"; }else{ print " 次週\n"; $url = $url_self . "?f_days=7&f_dayn=0" . $url_suffix; print " 最新週"; } } else { if ( $past_days >= 0 ){ print " 最新週"; } else { $url = $url_self . "?f_days=7&f_dayn=0" . $url_suffix; print " 最新週"; } } // 前のn件 if ( $past_days < 0){ $url = $url_self . "?f_count=$count_per_page&f_index=" . ($skip_count + $count_per_page) . $url_suffix; print " | 前の${count_per_page}件"; } // 次のn件 if ( $past_days < 0 && $skip_count - $count_per_page >= 0 ){ $url = $url_self . "?f_count=$count_per_page&f_index=" . ($skip_count - $count_per_page) . $url_suffix; print " | 次の${count_per_page}件"; } // 最新10件 if ( $past_days < 0 && $skip_count == 0 ){ print " | 最新" . $count_per_page . "件"; } else { $url = $url_self . "?f_count=10" . $url_suffix; print " | 最新10件"; } // 子のリスト if ( $user_id > 0 && $review_id > 0 ){ $url_self_now_quoted = quote_html_param($url_self_now); print "

    \n"; print "\n"; print "\n"; } $lastdate_prev = ''; while ( ($row = mysqli_fetch_array($result)) ){ $child_title = $row['Title']; $child_revid = (int)$row['ReviewID']; $child_revclsid = (int)$row['ReviewClassID']; $child_creator = $row['Creator']; $child_author = $row['Author']; $child_score = (float)$row['Score']; $child_access_level = (int)$row['AccessLevel']; $child_userid = (int)$row['UserID']; $child_lastdate = $row['LastDate']; $child_message = (isset($row['Message']) ? $row['Message'] : ""); $child_parent_title = $row['ParentTitle']; $child_parent_revid = (int)$row['ParentReviewID']; $child_parent_revclsid = (int)$row['ParentReviewClassID']; $child_title_quoted = quote_html($child_title); $child_author_quoted = quote_html($child_author); $child_lastdate_quoted = quote_html($child_lastdate); if ( isset($row['Message']) && $child_message != '' ){ $child_message = mb_ereg_replace("\n.*$", '', $child_message); $child_message_quoted = quote_html($child_message); $child_message_quoted = url_replace($child_message_quoted); //$child_message_quoted = mb_ereg_replace("(s?https?://[-_.!~*'()a-zA-Z0-9;/?:@&=+$,%#]+)(.)", "\"\\1\"\\2", $child_message_quoted); }else{ $child_message_quoted = ''; } if ( $child_lastdate != $lastdate_prev ){ if ( $lastdate_prev != '' ){ print "\n"; } $lastdate_prev = $child_lastdate; print "

    $child_lastdate_quoted

    \n"; print "
      \n"; } // 移動用 $checkbox_quoted = '
    • '; if ( $user_id > 0 && $review_id > 0 && ($user_id == $child_userid || $access_level >= $child_access_level + 20) ){ if ( $child_revclsid == REVIEW_CLASS_CATEGORY || $child_revclsid == REVIEW_CLASS_ARTICLE || $child_revclsid == REVIEW_CLASS_COMMENT || $child_revclsid == REVIEW_CLASS_TRACKBACK || $child_revclsid == REVIEW_CLASS_IMAGE){ $checkbox_quoted = ""; } } print ""; { print "$checkbox_quoted$child_title_quoted"; // それ以外の項目 if ( $child_creator != '' ){ $child_creator_quoted = " " . quote_html($child_creator) . ""; }else{ $child_creator_quoted = ''; } print $child_creator_quoted; print "
      "; // 書いた人 print "評者："; if ( $child_userid != '' ){ $url_self_now_quoted = htmlentities(urlencode($url_self_now)); print ""; } print $child_author_quoted; if ( $child_userid > 0 ) print ""; print ""; // 評価 print " 評価："; if ( $child_score != 9999 ){ if ( isset($eval_val[$child_score]) ){ if ( isset($eval_val_img[$child_score]) ){ print " " . $eval_val[$child_score] . "(${child_score}点)"; }else{ print $eval_val[$child_score] . "(${child_score}点)"; } }else{ print "${child_score}点"; } }else{ print "-"; } // if ( $child_parent_title != '' ){ if ( $child_parent_revclsid == REVIEW_CLASS_CATEGORY ){ print " 分類：" . quote_html($child_parent_title) . ""; }else{ print " 分類：" . quote_html($child_parent_title) . ""; } } // コメント件数 if ( $child_revclsid != REVIEW_CLASS_CATEGORY && isset($childcount['$child_revid']) && $childcount['$child_revid'] > 0 ){ $cnt = $childcount['$child_revid']; print " コメント数：${cnt}件"; } } print "      \n"; if ( $child_message != '' ){ print "
      $child_message_quoted
      \n"; } } if ( $lastdate_prev != '' ){ print "\n"; } if ( $user_id > 0 && $review_id > 0 ){ print "\n"; print "\n"; print "\n"; print "
      • \n"; } mysqli_free_result($result); // 中央の段組の終了 print "
    \n"; //****************************** // 出力終了 //****************************** // 三段組の終了 print "
    \n"; html_footer(); ob_end_flush(); //****************************** // データベース切断 //****************************** db_disconnect($db); ?>