Mercurial > epgrec.yaz
annotate install/step3.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 | |
children | a935b4789aff |
rev | line source |
---|---|
32
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
1 <?php |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
2 include_once("../config.php"); |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
3 include_once("../Smarty/Smarty.class.php"); |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
4 include_once("../DBRecord.class.php"); |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
5 include_once("../Settings.class.php"); |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
6 include_once("../reclib.php" ); |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
7 |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
8 $settings = Settings::factory(); |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
9 $settings->post(); // いったん保存する |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
10 $settings->save(); |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
11 |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
12 // データベース接続チェック |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
13 $dbh = @mysql_connect( $settings->db_host, $settings->db_user, $settings->db_pass ); |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
14 if( $dbh == false ) { |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
15 jdialog( "MySQLに接続できません。ホスト名/ユーザー名/パスワードを再チェックしてください", "step2.php" ); |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
16 exit(); |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
17 } |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
18 |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
19 $sqlstr = "use ".$settings->db_name; |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
20 $res = @mysql_query( $sqlstr ); |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
21 if( $res == false ) { |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
22 jdialog( "データベース名が異なるようです", "step2.php" ); |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
23 exit(); |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
24 } |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
25 |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
26 // DBテーブルの作成 |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
27 |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
28 try { |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
29 $rec = new DBRecord( $settings->tbl_prefix . RESERVE_TBL ); |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
30 $rec->createTable( RESERVE_STRUCT ); |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
31 |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
32 $rec = new DBRecord( $settings->tbl_prefix . PROGRAM_TBL ); |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
33 $rec->createTable( PROGRAM_STRUCT ); |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
34 |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
35 $rec = new DBRecord( $settings->tbl_prefix . CHANNEL_TBL ); |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
36 $rec->createTable( CHANNEL_STRUCT ); |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
37 |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
38 $rec = new DBRecord( $settings->tbl_prefix . CATEGORY_TBL ); |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
39 $rec->createTable( CATEGORY_STRUCT ); |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
40 |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
41 $rec = new DBRecord( $settings->tbl_prefix . KEYWORD_TBL ); |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
42 $rec->createTable( KEYWORD_STRUCT ); |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
43 } |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
44 catch( Exception $e ) { |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
45 jdialog("テーブルの作成に失敗しました。データベースに権限がない等の理由が考えられます。", "step2.php" ); |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
46 exit(); |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
47 } |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
48 |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
49 $smarty = new Smarty(); |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
50 $smarty->template_dir = "../templates/"; |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
51 $smarty->compile_dir = "../templates_c/"; |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
52 $smarty->cache_dir = "../cache/"; |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
53 |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
54 $smarty->assign( "settings", $settings ); |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
55 $smarty->assign( "install_path", INSTALL_PATH ); |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
56 $smarty->assign( "post_to", "step4.php" ); |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
57 $smarty->assign( "sitetitle", "インストールステップ3" ); |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
58 |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
59 $smarty->display("envSetting.html"); |
01a8fdc0cebb
testing: Web base setting page.
Sushi-k <epgrec@park.mda.or.jp>
parents:
diff
changeset
|
60 ?> |