nce/nc_query_readcnt_list2_db.php

   1 <?php
   2 /*
   3  nce (ntch cloud environment.)
   4  name: nc_update_readcnt_db.php
   5  author: Akira Ohta (akohta001.gmail.com)
   6  date: 2013-apr-21th
   7  description:
   8  License: GPLv3
   9  */
  10 include_once "account.php";
  11 include_once "preference.php";
  12 include_once "database.php";
  13 include_once "log.php";
  14 include_once "http_util.php";
  15 include_once "error_code.php";
  16
  17 $user_id = $_POST['user'];
  18 $hashed_passwd = $_POST['hashed_passwd'];
  19 $board_name = $_POST['board_name'];
  20 $aes_enable = $_POST['aes_enable'];
  21
  22 //--- authorization ---
  23 $user = chk_passwd( $user_id, $hashed_passwd);
  24 if(FALSE === $user){
  25         echo $ERROR_MSG;
  26         exit;
  27 }
  28
  29 //--- parameter check start ---
  30 if(!chk_param($board_name)){
  31         echo ERROR303;
  32         exit;
  33 }
  34
  35 if(isset($aes_enable) && $aes_enable==1){
  36         $extra_filter = "record_type > 3 and record_type < 7";
  37 }else{
  38         $extra_filter = "record_type > 0 and record_type < 4";
  39 }
  40 //--- parameter check end ---
  41
  42 $table_name = TABLE_PREFIX."tbl{$user->home_dir}";
  43 $query1 = <<< QUERY1
  44 select res_number, record_type, dat_name, last_update from $table_name
  45     where board_name='{$board_name}' and {$extra_filter}
  46 QUERY1;
  47
  48 try{
  49         $db->open();
  50         //echo $query1."\n";
  51         $result = $db->execute($query1);
  52
  53         if(!$result){
  54                 echo ERROR503;
  55                 exit;
  56         }
  57         $db->close();
  58 }catch(Exception $e){
  59         $error = __FILE__."(".__LINE__.
  60                 ") An error occured during query.";
  61         nc_logging($error, $e);
  62         echo ERROR500;
  63         exit;
  64 }
  65
  66 echo SUCCESS100;
  67 //echo $query1."\n";
  68 //print_r($result);
  69 for($i = 0; $i < $result->num_rows; $i++){
  70         $row = $result->fetch_assoc();
  71         echo $row['dat_name'].",".$row['res_number'].",".$row['record_type'].",".$row['last_update']."\n";
  72 }
  73
  74 ?>