changeReservation.php

   1 <?php
   2 include_once('config.php');
   3 include_once(INSTALL_PATH."/DBRecord.class.php");
   4 include_once(INSTALL_PATH."/reclib.php");
   5 include_once(INSTALL_PATH."/Settings.class.php");
   6
   7 $settings = Settings::factory();
   8
   9 if( !isset( $_POST['reserve_id'] ) ) {
  10         exit("Error: IDが指定されていません" );
  11 }
  12 $reserve_id = $_POST['reserve_id'];
  13
  14 $dbh = false;
  15 if( $settings->mediatomb_update == 1 ) {
  16         $dbh = @mysql_connect( $settings->db_host, $settings->db_user, $settings->db_pass );
  17         if( $dbh !== false ) {
  18                 $sqlstr = "use ".$settings->db_name;
  19                 @mysql_query( $sqlstr );
  20                 $sqlstr = "set NAME utf8";
  21                 @mysql_query( $sqlstr );
  22         }
  23 }
  24
  25 try {
  26         $rec = new DBRecord(RESERVE_TBL, "id", $reserve_id );
  27
  28         if( isset( $_POST['title'] ) ) {
  29                 $rec->title = trim( $_POST['title'] );
  30                 if( ($dbh !== false) && ($rec->complete == 1) ) {
  31                         $title = trim( mysql_real_escape_string($_POST['title']));
  32                         $title .= "(".date("Y/m/d", toTimestamp($rec->starttime)).")";
  33                         $sqlstr = "update mt_cds_object set dc_title='".$title."' where metadata regexp 'epgrec:id=".$reserve_id."$'";
  34                         @mysql_query( $sqlstr );
  35                 }
  36         }
  37
  38         if( isset( $_POST['description'] ) ) {
  39                 $rec->description = trim( $_POST['description'] );
  40                 if( ($dbh !== false) && ($rec->complete == 1) ) {
  41                         $desc = "dc:description=".trim( mysql_real_escape_string($_POST['description']));
  42                         $desc .= "&epgrec:id=".$reserve_id;
  43                         $sqlstr = "update mt_cds_object set metadata='".$desc."' where metadata regexp 'epgrec:id=".$reserve_id."$'";
  44                         @mysql_query( $sqlstr );
  45                 }
  46         }
  47 }
  48 catch( Exception $e ) {
  49         exit("Error: ". $e->getMessage());
  50 }
  51
  52 exit("complete");
  53
  54 ?>