Mercurial > epgrec.yaz

comparison mediatomb.php @ 28:9238c1d9e060

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
modified: mediatomb.php
author yoneda <epgrec@park.mda.or.jp>
date Sun, 26 Jul 2009 18:07:39 +0900
parents cf19005e65d1
children e5f9aa34d06f
comparison
equal deleted inserted replaced
27:a34f2ff49097 28:9238c1d9e060
17 $sqlstr = "set NAME utf8"; 17 $sqlstr = "set NAME utf8";
18 mysql_query( $sqlstr ); 18 mysql_query( $sqlstr );
19 19
20 foreach( $recs as $rec ) { 20 foreach( $recs as $rec ) {
21 $title = mysql_real_escape_string($rec->title)."(".date("Y/m/d", toTimestamp($rec->starttime)).")"; 21 $title = mysql_real_escape_string($rec->title)."(".date("Y/m/d", toTimestamp($rec->starttime)).")";
22 $sqlstr = "update mt_cds_object set metadata='dc:description=".mysql_real_escape_string($rec->description)."' where dc_title='".$rec->path."'"; 22 $sqlstr = "update mt_cds_object set metadata='dc:description=".mysql_real_escape_string($rec->description)."&epgrec:id=".$rec->id."' where dc_title='".$rec->path."'";
23 mysql_query( $sqlstr ); 23 mysql_query( $sqlstr );
24 $sqlstr = "update mt_cds_object set dc_title='".$title."' where dc_title='".$rec->path."'"; 24 $sqlstr = "update mt_cds_object set dc_title='".$title."' where dc_title='".$rec->path."'";
25 mysql_query( $sqlstr ); 25 mysql_query( $sqlstr );
26 } 26 }
27 } 27 }