annotate README.ja @ 118:db185340a981

utf8 collate try1
author Yoshiki Yazawa <yaz@honeyplanet.jp>
date Sun, 14 Mar 2010 20:16:04 +0900
parents 322bba0d33e5
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
81
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
1 epgrecは日本のデジタル放送用録画システムです。
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
2
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
3 ●改造のための情報
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
4
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
5  ファイルが増えてきたので整理をかねてメモを記しておきます。
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
6
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
7 ■DBRecordクラス
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
8
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
9  epgrecは簡易O/Rマッピングを行うDBRecordクラスを足回りとして利用しています。
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
10
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
11 ・オブジェクトの作成
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
12 $record = new DBRecord( PROGRAM_TBL|CATEGORY_TBL|CHANNEL_TBL|KEYWORD_TBL|RESERVE_TBL
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
13 [,フィールド名 ,検索語句]
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
14 );
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
15
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
16  DBレコードに関連づけられたDBRecordオブジェクトを生成します。フィールド名と検索語句を指定すると、DBテーブルを検索して最初にヒットしたレコードと関連づけられたオブジェクトを返します。フィールド名と検索語句を省略すると新規レコードを作成して、そのオブジェクトを返します。
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
17
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
18 ・レコードの読み書き
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
19  プロパティに対するリード/ライトの形でレコードの読み書きを行います。
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
20
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
21 $record->フィールド名 = "foobar"; //書き込み
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
22 echo $record->フィールド名; // 読み出し
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
23
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
24 ・一括読みだし
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
25 $arr = $record->fetch_array("フィールド名", "検索語句"[,options] );
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
26
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
27  検索語句がヒットしたレコードを配列に読み出します。
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
28
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
29 ・レコードの削除
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
30 $record->delete();
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
31
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
32 ・静的メソッド
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
33 $arr = createRecords( PROGRAM_TBL|CATEGORY_TBL|CHANNEL_TBL|KEYWORD_TBL|RESERVE_TBL
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
34 [,options] );
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
35  テーブルの全レコードをDBRecordオブジェクト配列として返します(低速)。optionsにSELECT文のWHERE節を追加して絞り込むことが出来ます。optionsは"WHERE ..."と記述してください。
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
36
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
37 ■ファイル群
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
38
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
39 DBRecord.class.php
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
40  DBRecordクラス
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
41
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
42 Keyword.class.php
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
43  キーワードレコードクラス(親:DBRecord)
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
44
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
45 Reservation.class.php
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
46  予約クラス。静的メソッドsimple()、静的メソッドcustom()。
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
47
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
48 Settings.class.php
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
49  設定の読み出し/保存を行うクラス(親:SimpleXML)
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
50
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
51 cancelReservation.php
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
52  JavaScriptから呼ばれる予約取り消し
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
53
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
54 changeReservation.php
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
55  JavaScriptから呼ばれる予約内容の更新
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
56
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
57 channelInfo.php
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
58  チャンネル情報を返す(JavaScriptから呼ばれる)
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
59
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
60 channelSetSID.php
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
61  チャンネルに対応するSIDを更新する(JavaScriptから呼ばれる)
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
62
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
63 config.php.sample
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
64  config.phpのサンプルファイル
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
65
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
66 customReservation.php
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
67  詳細予約実行(JavaScriptから呼ばれる)
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
68
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
69 deleteKeyword.php
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
70  キーワードの削除実行(keywordTable.phpから呼ばれる)
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
71
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
72 envSetting.php
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
73  環境設定
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
74
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
75 getepg.php
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
76  EPG取得スクリプト
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
77
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
78 index.php
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
79  トップページ(番組表)
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
80
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
81 keywordTable.php
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
82  キーワードの管理ページ
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
83
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
84 mediatomb.php
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
85  mediatombのDB更新スクリプト
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
86
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
87 postsettings.php
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
88  設定の更新(設定ページから呼ばれる)
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
89
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
90 programTable.php
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
91  番組検索ページ
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
92
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
93 reclib.php
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
94  雑多ライブラリ
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
95
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
96 recomplete.php
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
97  録画終了フラグを立てるスクリプト
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
98
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
99 recordedTable.php
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
100  録画済み一覧ページ
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
101
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
102 reservationTable.php
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
103  予約一覧ページ
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
104
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
105 reservationform.php
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
106  詳細予約のフォームを返す(JavaScriptから呼ばれる)
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
107
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
108 sendstream.php
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
109  録画中に視聴するためのストリーミングを流すスクリプト(未完成)
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
110
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
111 simpleReservation.php
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
112  簡易予約実行(JavaScriptから呼ばれる)
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
113
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
114 systemSetting.php
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
115  システム設定ページ
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
116
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
117 upgrade_to_201002.php
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
118  2010年2月版へのアップデートスクリプト
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
119
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
120 viewer.php
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
121  ASFヘッダを送るスクリプト
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
122
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
123 templates/envSetting.html
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
124  環境設定ページSmartyテンプレート
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
125
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
126 templates/index.html
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
127  トップページSmartyテンプレート
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
128
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
129 templates/keywordTable.html
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
130  キーワード一覧ページSmartyテンプレート
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
131
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
132 templates/programTable.html
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
133  番組検索ページSmartyテンプレート
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
134
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
135 templates/recordedTable.html
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
136  録画済み一覧ページSmartyテンプレート
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
137
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
138 templates/reservationTable.html
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
139  予約一覧ページページSmartyテンプレート
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
140
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
141 templates/reservationform.html
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
142  詳細予約フォームのSmartyテンプレート
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
143
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
144 templates/systemSetting.html
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
145  システム設定ページSmartyテンプレート
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
146
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
147 install/grscan.php
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
148  インストール:地上デジタルチャンネルスキャン(grscanが存在するときのみ)
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
149
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
150 install/step1.php
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
151  インストール:ステップ1
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
152
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
153 install/step2.php
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
154  インストール:ステップ2
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
155
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
156 install/step3.php
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
157  インストール:ステップ3
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
158
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
159 install/step4.php
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
160  インストール:ステップ4
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
161
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
162 install/step5.php
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
163  インストール:ステップ5
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
164
322bba0d33e5 add a README
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff changeset
165