Mercurial > epgrec.yaz
annotate mediatomb.php @ 12:c4cb171f9453
new file: mediatomb.php
author | yoneda <yoneda@debian.localnet.mda.or.jp> |
---|---|
date | Mon, 13 Jul 2009 23:47:19 +0900 |
parents | |
children | b0fc647167f5 |
rev | line source |
---|---|
12
c4cb171f9453
new file: mediatomb.php
yoneda <yoneda@debian.localnet.mda.or.jp>
parents:
diff
changeset
|
1 #!/usr/bin/php |
c4cb171f9453
new file: mediatomb.php
yoneda <yoneda@debian.localnet.mda.or.jp>
parents:
diff
changeset
|
2 <?php |
c4cb171f9453
new file: mediatomb.php
yoneda <yoneda@debian.localnet.mda.or.jp>
parents:
diff
changeset
|
3 |
c4cb171f9453
new file: mediatomb.php
yoneda <yoneda@debian.localnet.mda.or.jp>
parents:
diff
changeset
|
4 include_once('config.php'); |
c4cb171f9453
new file: mediatomb.php
yoneda <yoneda@debian.localnet.mda.or.jp>
parents:
diff
changeset
|
5 include_once(INSTALL_PATH.'/DBRecord.class.php'); |
c4cb171f9453
new file: mediatomb.php
yoneda <yoneda@debian.localnet.mda.or.jp>
parents:
diff
changeset
|
6 |
c4cb171f9453
new file: mediatomb.php
yoneda <yoneda@debian.localnet.mda.or.jp>
parents:
diff
changeset
|
7 try { |
c4cb171f9453
new file: mediatomb.php
yoneda <yoneda@debian.localnet.mda.or.jp>
parents:
diff
changeset
|
8 |
c4cb171f9453
new file: mediatomb.php
yoneda <yoneda@debian.localnet.mda.or.jp>
parents:
diff
changeset
|
9 $recs = DBRecord::createRecords(TBL_PREFIX.RESERVE_TBL ); |
c4cb171f9453
new file: mediatomb.php
yoneda <yoneda@debian.localnet.mda.or.jp>
parents:
diff
changeset
|
10 |
c4cb171f9453
new file: mediatomb.php
yoneda <yoneda@debian.localnet.mda.or.jp>
parents:
diff
changeset
|
11 // DB接続 |
c4cb171f9453
new file: mediatomb.php
yoneda <yoneda@debian.localnet.mda.or.jp>
parents:
diff
changeset
|
12 $dbh = mysql_connect( DB_HOST, DB_USER, DB_PASS ); |
c4cb171f9453
new file: mediatomb.php
yoneda <yoneda@debian.localnet.mda.or.jp>
parents:
diff
changeset
|
13 if( $dbh === false ) exit( "mysql connection fail" ); |
c4cb171f9453
new file: mediatomb.php
yoneda <yoneda@debian.localnet.mda.or.jp>
parents:
diff
changeset
|
14 $sqlstr = "use ".DB_NAME; |
c4cb171f9453
new file: mediatomb.php
yoneda <yoneda@debian.localnet.mda.or.jp>
parents:
diff
changeset
|
15 mysql_query( $sqlstr ); |
c4cb171f9453
new file: mediatomb.php
yoneda <yoneda@debian.localnet.mda.or.jp>
parents:
diff
changeset
|
16 $sqlstr = "set NAME utf8"; |
c4cb171f9453
new file: mediatomb.php
yoneda <yoneda@debian.localnet.mda.or.jp>
parents:
diff
changeset
|
17 mysql_query( $sqlstr ); |
c4cb171f9453
new file: mediatomb.php
yoneda <yoneda@debian.localnet.mda.or.jp>
parents:
diff
changeset
|
18 |
c4cb171f9453
new file: mediatomb.php
yoneda <yoneda@debian.localnet.mda.or.jp>
parents:
diff
changeset
|
19 foreach( $recs as $rec ) { |
c4cb171f9453
new file: mediatomb.php
yoneda <yoneda@debian.localnet.mda.or.jp>
parents:
diff
changeset
|
20 $sqlstr = "update mt_cds_object set metadata='dc:description=".$rec->description."' where dc_title='".$rec->path."'"; |
c4cb171f9453
new file: mediatomb.php
yoneda <yoneda@debian.localnet.mda.or.jp>
parents:
diff
changeset
|
21 mysql_query( $sqlstr ); |
c4cb171f9453
new file: mediatomb.php
yoneda <yoneda@debian.localnet.mda.or.jp>
parents:
diff
changeset
|
22 $sqlstr = "update mt_cds_object set dc_title='".$rec->title."' where dc_title='".$rec->path."'"; |
c4cb171f9453
new file: mediatomb.php
yoneda <yoneda@debian.localnet.mda.or.jp>
parents:
diff
changeset
|
23 mysql_query( $sqlstr ); |
c4cb171f9453
new file: mediatomb.php
yoneda <yoneda@debian.localnet.mda.or.jp>
parents:
diff
changeset
|
24 } |
c4cb171f9453
new file: mediatomb.php
yoneda <yoneda@debian.localnet.mda.or.jp>
parents:
diff
changeset
|
25 } |
c4cb171f9453
new file: mediatomb.php
yoneda <yoneda@debian.localnet.mda.or.jp>
parents:
diff
changeset
|
26 catch( Exception $e ) { |
c4cb171f9453
new file: mediatomb.php
yoneda <yoneda@debian.localnet.mda.or.jp>
parents:
diff
changeset
|
27 exit( $e->getMessage() ); |
c4cb171f9453
new file: mediatomb.php
yoneda <yoneda@debian.localnet.mda.or.jp>
parents:
diff
changeset
|
28 } |
c4cb171f9453
new file: mediatomb.php
yoneda <yoneda@debian.localnet.mda.or.jp>
parents:
diff
changeset
|
29 ?> |