Mercurial > epgrec.yaz
annotate recomplete.php @ 32:01a8fdc0cebb
testing: Web base setting page.
author | Sushi-k <epgrec@park.mda.or.jp> |
---|---|
date | Mon, 27 Jul 2009 18:48:51 +0900 |
parents | a34f2ff49097 |
children | e5f9aa34d06f |
rev | line source |
---|---|
1 | 1 #!/usr/bin/php |
2 <?php | |
3 include_once( "config.php" ); | |
4 include_once( INSTALL_PATH . "/DBRecord.class.php" ); | |
5 | |
6 $reserve_id = $argv[1]; | |
7 | |
8 try{ | |
9 $rrec = new DBRecord( TBL_PREFIX.RESERVE_TBL, "id" , $reserve_id ); | |
10 | |
11 if( file_exists( INSTALL_PATH . SPOOL . "/". $rrec->path ) ) { | |
12 // 予約完了 | |
13 $rrec->complete = '1'; | |
22
95629ba1f043
modified: recomplete.php
yoneda <yoneda@debian.localnet.mda.or.jp>
parents:
21
diff
changeset
|
14 if( defined("MEDIATOMB_UPDATE") ) { |
16
cf19005e65d1
added: mysql_real_escape_string
Sushi-k <epgrec@park.mda.or.jp>
parents:
13
diff
changeset
|
15 if( MEDIATOMB_UPDATE ) { |
21 | 16 // ちょっと待った方が確実っぽい |
17 @exec("sync"); | |
22
95629ba1f043
modified: recomplete.php
yoneda <yoneda@debian.localnet.mda.or.jp>
parents:
21
diff
changeset
|
18 sleep(15); |
16
cf19005e65d1
added: mysql_real_escape_string
Sushi-k <epgrec@park.mda.or.jp>
parents:
13
diff
changeset
|
19 $dbh = mysql_connect( DB_HOST, DB_USER, DB_PASS ); |
cf19005e65d1
added: mysql_real_escape_string
Sushi-k <epgrec@park.mda.or.jp>
parents:
13
diff
changeset
|
20 if( $dbh !== false ) { |
cf19005e65d1
added: mysql_real_escape_string
Sushi-k <epgrec@park.mda.or.jp>
parents:
13
diff
changeset
|
21 $sqlstr = "use ".DB_NAME; |
cf19005e65d1
added: mysql_real_escape_string
Sushi-k <epgrec@park.mda.or.jp>
parents:
13
diff
changeset
|
22 mysql_query( $sqlstr ); |
cf19005e65d1
added: mysql_real_escape_string
Sushi-k <epgrec@park.mda.or.jp>
parents:
13
diff
changeset
|
23 // 別にやらなくてもいいが |
cf19005e65d1
added: mysql_real_escape_string
Sushi-k <epgrec@park.mda.or.jp>
parents:
13
diff
changeset
|
24 $sqlstr = "set NAME utf8"; |
cf19005e65d1
added: mysql_real_escape_string
Sushi-k <epgrec@park.mda.or.jp>
parents:
13
diff
changeset
|
25 mysql_query( $sqlstr ); |
27
a34f2ff49097
add: editable title & description
yoneda <epgrec@park.mda.or.jp>
parents:
22
diff
changeset
|
26 $sqlstr = "update mt_cds_object set metadata='dc:description=".mysql_real_escape_string($rrec->description)."&epgrec:id=".$reserve_id."' where dc_title='".$rrec->path."'"; |
16
cf19005e65d1
added: mysql_real_escape_string
Sushi-k <epgrec@park.mda.or.jp>
parents:
13
diff
changeset
|
27 mysql_query( $sqlstr ); |
cf19005e65d1
added: mysql_real_escape_string
Sushi-k <epgrec@park.mda.or.jp>
parents:
13
diff
changeset
|
28 $sqlstr = "update mt_cds_object set dc_title='".mysql_real_escape_string($rrec->title)."(".date("Y/m/d").")' where dc_title='".$rrec->path."'"; |
cf19005e65d1
added: mysql_real_escape_string
Sushi-k <epgrec@park.mda.or.jp>
parents:
13
diff
changeset
|
29 mysql_query( $sqlstr ); |
cf19005e65d1
added: mysql_real_escape_string
Sushi-k <epgrec@park.mda.or.jp>
parents:
13
diff
changeset
|
30 } |
11
065d48346fff
support mediatomb db update (testing)
yoneda <yoneda@debian.localnet.mda.or.jp>
parents:
1
diff
changeset
|
31 } |
16
cf19005e65d1
added: mysql_real_escape_string
Sushi-k <epgrec@park.mda.or.jp>
parents:
13
diff
changeset
|
32 } |
1 | 33 } |
34 else { | |
35 // 予約失敗 | |
36 $rrec->delete(); | |
37 } | |
38 } | |
39 catch( exception $e ) { | |
40 exit( $e->getMessage() ); | |
41 } | |
42 | |
43 ?> |