Mercurial > epgrec.yaz

comparison changeReservation.php @ 142:481e789605e3

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
mod: EPGの更新と同時に予約情報を更新するように変更、ログビューアの追加
author epgrec@park.mda.or.jp <yoneda@recorder.localnet.mda.or.jp>
date Sun, 21 Mar 2010 16:42:58 +0900
parents f8f6e0d3acaf
children
comparison
equal deleted inserted replaced
136:6754b6aa50cf 142:481e789605e3
25 try { 25 try {
26 $rec = new DBRecord(RESERVE_TBL, "id", $reserve_id ); 26 $rec = new DBRecord(RESERVE_TBL, "id", $reserve_id );
27 27
28 if( isset( $_POST['title'] ) ) { 28 if( isset( $_POST['title'] ) ) {
29 $rec->title = trim( $_POST['title'] ); 29 $rec->title = trim( $_POST['title'] );
30 $rec->dirty = 1;
30 if( ($dbh !== false) && ($rec->complete == 1) ) { 31 if( ($dbh !== false) && ($rec->complete == 1) ) {
31 $title = trim( mysql_real_escape_string($_POST['title'])); 32 $title = trim( mysql_real_escape_string($_POST['title']));
32 $title .= "(".date("Y/m/d", toTimestamp($rec->starttime)).")"; 33 $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 $sqlstr = "update mt_cds_object set dc_title='".$title."' where metadata regexp 'epgrec:id=".$reserve_id."$'";
34 @mysql_query( $sqlstr ); 35 @mysql_query( $sqlstr );
35 } 36 }
36 } 37 }
37 38
38 if( isset( $_POST['description'] ) ) { 39 if( isset( $_POST['description'] ) ) {
39 $rec->description = trim( $_POST['description'] ); 40 $rec->description = trim( $_POST['description'] );
41 $rec->dirty = 1;
40 if( ($dbh !== false) && ($rec->complete == 1) ) { 42 if( ($dbh !== false) && ($rec->complete == 1) ) {
41 $desc = "dc:description=".trim( mysql_real_escape_string($_POST['description'])); 43 $desc = "dc:description=".trim( mysql_real_escape_string($_POST['description']));
42 $desc .= "&epgrec:id=".$reserve_id; 44 $desc .= "&epgrec:id=".$reserve_id;
43 $sqlstr = "update mt_cds_object set metadata='".$desc."' where metadata regexp 'epgrec:id=".$reserve_id."$'"; 45 $sqlstr = "update mt_cds_object set metadata='".$desc."' where metadata regexp 'epgrec:id=".$reserve_id."$'";
44 @mysql_query( $sqlstr ); 46 @mysql_query( $sqlstr );