diff changeReservation.php @ 37:e5f9aa34d06f

change: modify all script for web base setting

--- a/changeReservation.php	Mon Jul 27 22:27:54 2009 +0900
+++ b/changeReservation.php	Tue Jul 28 00:00:04 2009 +0900
@@ -2,6 +2,9 @@
 include_once('config.php');
 include_once(INSTALL_PATH."/DBRecord.class.php");
 include_once(INSTALL_PATH."/reclib.php");
+include_once(INSTALL_PATH."/Settings.class.php");
+
+$settings = Settings::factory();
 
 if( !isset( $_POST['reserve_id'] ) ) {
 	exit("Error: IDが指定されていません" );
@@ -9,20 +12,18 @@
 $reserve_id = $_POST['reserve_id'];
 
 $dbh = false;
-if( defined("MEDIATOMB_UPDATE") ) {
-	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 );
-		}
+if( $settings->mediatomb_update ) {
+	$dbh = @mysql_connect( $settings->db_host, $settings->db_user, $settings->db_pass );
+	if( $dbh !== false ) {
+		$sqlstr = "use ".$settings->db_name;
+		@mysql_query( $sqlstr );
+		$sqlstr = "set NAME utf8";
+		@mysql_query( $sqlstr );
 	}
 }
 
 try {
-	$rec = new DBRecord(TBL_PREFIX.RESERVE_TBL, "id", $reserve_id );
+	$rec = new DBRecord(RESERVE_TBL, "id", $reserve_id );
 	
 	if( isset( $_POST['title'] ) ) {
 		$rec->title = trim( $_POST['title'] );
@@ -30,7 +31,7 @@
 			$title = trim( mysql_real_escape_string($_POST['title']));
 			$title .= "(".date("Y/m/d", toTimestamp($rec->starttime)).")";
 			$sqlstr = "update mt_cds_object set dc_title='".$title."' where metadata regexp 'epgrec:id=".$reserve_id."$'";
-			mysql_query( $sqlstr );
+			@mysql_query( $sqlstr );
 		}
 	}