3 $script_path = dirname( __FILE__ );
5 include_once( $script_path . '/config.php');
6 include_once(INSTALL_PATH.'/DBRecord.class.php');
7 include_once(INSTALL_PATH.'/reclib.php');
8 include_once(INSTALL_PATH.'/Settings.class.php');
10 $settings = Settings::factory();
14 $recs = DBRecord::createRecords(RESERVE_TBL );
17 $dbh = mysql_connect( $settings->db_host, $settings->db_user, $settings->db_pass );
18 if( $dbh === false ) exit( "mysql connection fail" );
19 $sqlstr = "use ".$settings->db_name;
20 mysql_query( $sqlstr );
21 $sqlstr = "set NAME utf8";
22 mysql_query( $sqlstr );
24 foreach( $recs as $rec ) {
25 $title = mysql_real_escape_string($rec->title)."(".date("Y/m/d", toTimestamp($rec->starttime)).")";
26 $sqlstr = "update mt_cds_object set metadata='dc:description=".mysql_real_escape_string($rec->description)."&epgrec:id=".$rec->id."' where dc_title='".$rec->path."'";
27 mysql_query( $sqlstr );
28 $sqlstr = "update mt_cds_object set dc_title='".$title."' where dc_title='".$rec->path."'";
29 mysql_query( $sqlstr );
32 catch( Exception $e ) {
33 exit( $e->getMessage() );