comparison recomplete.php @ 11:065d48346fff

support mediatomb db update (testing)

10:152b146bd276

	$rrec = new DBRecord( TBL_PREFIX.RESERVE_TBL, "id" , $reserve_id );
	
	if( file_exists( INSTALL_PATH . SPOOL . "/". $rrec->path ) ) {
		// 予約完了
		$rrec->complete = '1';
	}
	else {
		// 予約失敗
		$rrec->delete();
	}

11:065d48346fff

	$rrec = new DBRecord( TBL_PREFIX.RESERVE_TBL, "id" , $reserve_id );
	
	if( file_exists( INSTALL_PATH . SPOOL . "/". $rrec->path ) ) {
		// 予約完了
		$rrec->complete = '1';
		if( MEDIATOMB_UPDATE) {
			$dbh = mysql_connect( DB_HOST, DB_USER, DB_PASS );
			if( $dbh !== false ) {
				$sqlstr = "use ".DB_NAME;
				mysql_query( $sqlstr );
				// 別にやらなくてもいいが
				$sqlstr = "set NAME utf8";
				mysql_query( $sqlstr );
				$sqlstr = "update mt_cds_object set metadata='dc:description=".$rrec->description."' where dc_title='".$rrec->path."'";
				mysql_query( $sqlstr );
				$sqlstr = "update mt_cds_object set dc_title='".$rrec->title."' where dc_title='".$rrec->path."'";
				mysql_query( $sqlstr );
			}
		}	
	}
	else {
		// 予約失敗
		$rrec->delete();
	}