source: temp/trunk/html/install/index.php @ 5934

Revision 5934, 17.1 KB checked in by kakinaka, 20 years ago (diff)

* empty log message *
  • Property svn:eol-style set to native
  • Property svn:keywords set to Author Date Id Revision
Line 
1<?php
2/*
3 * Copyright(c) 2000-2006 LOCKON CO.,LTD. All Rights Reserved.
4 *
5 * http://www.lockon.co.jp/
6 */
7require_once("../require.php");
8$INSTALL_DIR = realpath(dirname( __FILE__));
9
10class LC_Page {
11    function LC_Page() {
12        $this->arrDB_TYPE = array(
13            'pgsql' => 'PostgreSQL',
14            'mysql' => 'mySQL' 
15        );
16    }
17}
18
19$objPage = new LC_Page();
20
21// ¥Æ¥ó¥×¥ì¡¼¥È¥³¥ó¥Ñ¥¤¥ë¥Ç¥£¥ì¥¯¥È¥ê¤Î½ñ¹þ¤ß¸¢¸Â¥Á¥§¥Ã¥¯
22$temp_dir = $INSTALL_DIR . '/temp';
23$mode = lfGetFileMode($temp_dir);
24
25if($mode != '777') {
26    sfErrorHeader($temp_dir . "¤Ë¥æ¡¼¥¶½ñ¹þ¤ß¸¢¸Â(777)¤òÉÕÍ¿¤·¤Æ²¼¤µ¤¤¡£", true);
27    exit;
28}
29
30$objView = new SC_InstallView($INSTALL_DIR . '/templates', $INSTALL_DIR . '/temp');
31
32// ¥Ñ¥é¥á¡¼¥¿´ÉÍý¥¯¥é¥¹
33$objWebParam = new SC_FormParam();
34$objDBParam = new SC_FormParam();
35// ¥Ñ¥é¥á¡¼¥¿¾ðÊó¤Î½é´ü²½
36$objWebParam = lfInitWebParam($objWebParam);
37$objDBParam = lfInitDBParam($objDBParam);
38
39if ($_POST['db_type'] == 'pgsql') {
40    $port = "";
41}else{
42    $port = ":".$_POST['db_port'];
43}
44
45//¥Õ¥©¡¼¥àÇÛÎó¤Î¼èÆÀ
46$objWebParam->setParam($_POST);
47$objDBParam->setParam($_POST);
48
49switch($_POST['mode']) {
50// ¤è¤¦¤³¤½
51case 'welcome':
52    $objPage = lfDispStep0($objPage);
53    break;
54// ¥¢¥¯¥»¥¹¸¢¸Â¤Î¥Á¥§¥Ã¥¯
55case 'step0':
56    $objPage = lfDispStep0_1($objPage);
57    break; 
58// ¥Õ¥¡¥¤¥ë¤Î¥³¥Ô¡¼
59case 'step0_1':
60    $objPage = lfDispStep1($objPage);
61    break; 
62// WEB¥µ¥¤¥È¤ÎÀßÄê
63case 'step1':
64    //ÆþÎÏÃͤΥ¨¥é¡¼¥Á¥§¥Ã¥¯
65    $objPage->arrErr = lfCheckWEBError($objWebParam);
66    if(count($objPage->arrErr) == 0) {
67        $objPage = lfDispStep2($objPage);
68    } else {
69        $objPage = lfDispStep1($objPage);
70    }
71    break;
72// ¥Ç¡¼¥¿¥Ù¡¼¥¹¤ÎÀßÄê
73case 'step2':
74    //ÆþÎÏÃͤΥ¨¥é¡¼¥Á¥§¥Ã¥¯
75    $objPage->arrErr = lfCheckDBError($objDBParam);
76    if(count($objPage->arrErr) == 0) {
77        $objPage = lfDispStep3($objPage);
78    } else {
79        $objPage = lfDispStep2($objPage);
80    }
81    break;
82// ¥Æ¡¼¥Ö¥ë¤ÎºîÀ®
83case 'step3':
84    // ÆþÎϥǡ¼¥¿¤òÅϤ¹¡£
85    $arrRet =  $objDBParam->getHashArray();
86   
87    $skip = $_POST["db_skip"];
88
89    // ¥¹¥­¥Ã¥×¤¹¤ë¾ì¹ç¤Ë¤Ï´°Î»²èÌ̤ØÁ«°Ü
90    if ($skip == "on") {
91        // ÀßÄê¥Õ¥¡¥¤¥ë¤ÎÀ¸À®
92        lfMakeConfigFile();
93        $objPage = lfDispComplete($objPage);
94        break;
95    }
96   
97    // ¥Æ¡¼¥Ö¥ë¤ÎºîÀ®
98    $objPage->arrErr = lfExecuteSQL("./create_table_".$arrRet['db_type'].".sql", $arrRet['db_user'], $arrRet['db_password'], $arrRet['db_server'], $arrRet['db_name'], $arrRet['db_type'], $arrRet['db_port']);
99    if(count($objPage->arrErr) == 0) {
100        $objPage->tpl_message.="¡û¡§¥Æ¡¼¥Ö¥ë¤ÎºîÀ®¤ËÀ®¸ù¤·¤Þ¤·¤¿¡£<br>";
101    } else {
102        $objPage->tpl_message.="¡ß¡§¥Æ¡¼¥Ö¥ë¤ÎºîÀ®¤Ë¼ºÇÔ¤·¤Þ¤·¤¿¡£<br>";       
103    }
104
105    // ¥Ó¥å¡¼¤ÎºîÀ®
106    if(count($objPage->arrErr) == 0 and $arrRet['db_type'] == 'pgsql') {
107        // ¥Ó¥å¡¼¤ÎºîÀ®
108        $objPage->arrErr = lfExecuteSQL("./create_view.sql", $arrRet['db_user'], $arrRet['db_password'], $arrRet['db_server'], $arrRet['db_name'], $arrRet['db_type'], $arrRet['db_port']);
109        if(count($objPage->arrErr) == 0) {
110            $objPage->tpl_message.="¡û¡§¥Ó¥å¡¼¤ÎºîÀ®¤ËÀ®¸ù¤·¤Þ¤·¤¿¡£<br>";
111        } else {
112            $objPage->tpl_message.="¡ß¡§¥Ó¥å¡¼¤ÎºîÀ®¤Ë¼ºÇÔ¤·¤Þ¤·¤¿¡£<br>";     
113        }
114    }   
115   
116    // ½é´ü¥Ç¡¼¥¿¤ÎºîÀ®
117    if(count($objPage->arrErr) == 0) {
118        $objPage->arrErr = lfExecuteSQL("./insert_data.sql", $arrRet['db_user'], $arrRet['db_password'], $arrRet['db_server'], $arrRet['db_name'], $arrRet['db_type'], $arrRet['db_port']);
119        if(count($objPage->arrErr) == 0) {
120            $objPage->tpl_message.="¡û¡§½é´ü¥Ç¡¼¥¿¤ÎºîÀ®¤ËÀ®¸ù¤·¤Þ¤·¤¿¡£<br>";
121        } else {
122            $objPage->tpl_message.="¡ß¡§½é´ü¥Ç¡¼¥¿¤ÎºîÀ®¤Ë¼ºÇÔ¤·¤Þ¤·¤¿¡£<br>";     
123        }
124    }   
125   
126    // ¥«¥é¥à¥³¥á¥ó¥È¤Î½ñ¹þ¤ß
127    if(count($objPage->arrErr) == 0) {
128        $objPage->arrErr = lfExecuteSQL("./column_comment.sql", $arrRet['db_user'], $arrRet['db_password'], $arrRet['db_server'], $arrRet['db_name'], $arrRet['db_type'], $arrRet['db_port']);
129        if(count($objPage->arrErr) == 0) {
130            $objPage->tpl_message.="¡û¡§¥«¥é¥à¥³¥á¥ó¥È¤Î½ñ¹þ¤ß¤ËÀ®¸ù¤·¤Þ¤·¤¿¡£<br>";
131        } else {
132            $objPage->tpl_message.="¡ß¡§¥«¥é¥à¥³¥á¥ó¥È¤Î½ñ¹þ¤ß¤Ë¼ºÇÔ¤·¤Þ¤·¤¿¡£<br>";       
133        }
134    }   
135   
136    // ¥Æ¡¼¥Ö¥ë¥³¥á¥ó¥È¤Î½ñ¹þ¤ß
137    if(count($objPage->arrErr) == 0) {
138        $objPage->arrErr = lfExecuteSQL("./table_comment.sql", $arrRet['db_user'], $arrRet['db_password'], $arrRet['db_server'], $arrRet['db_name'], $arrRet['db_type'], $arrRet['db_port']);
139        if(count($objPage->arrErr) == 0) {
140            $objPage->tpl_message.="¡û¡§¥Æ¡¼¥Ö¥ë¥³¥á¥ó¥È¤Î½ñ¹þ¤ß¤ËÀ®¸ù¤·¤Þ¤·¤¿¡£<br>";
141        } else {
142            $objPage->tpl_message.="¡ß¡§¥Æ¡¼¥Ö¥ë¥³¥á¥ó¥È¤Î½ñ¹þ¤ß¤Ë¼ºÇÔ¤·¤Þ¤·¤¿¡£<br>";     
143        }
144    }
145
146
147    if(count($objPage->arrErr) == 0) {
148        // ÀßÄê¥Õ¥¡¥¤¥ë¤ÎÀ¸À®
149        lfMakeConfigFile();
150        $objPage = lfDispStep3($objPage);
151        $objPage->tpl_mode = 'complete';
152    } else {
153        $objPage = lfDispStep3($objPage);
154    }
155    break;
156// ¥Æ¡¼¥Ö¥ëÎàºï½ü
157case 'drop':
158    // ÆþÎϥǡ¼¥¿¤òÅϤ¹¡£
159    $arrRet =  $objDBParam->getHashArray();
160   
161    if ($arrRet['db_type'] == 'pgsql'){
162        // ¥Ó¥å¡¼¤Îºï½ü
163        $objPage->arrErr = lfExecuteSQL("./drop_view.sql", $arrRet['db_user'], $arrRet['db_password'], $arrRet['db_server'], $arrRet['db_name'], $arrRet['db_type'], $arrRet['db_port'], false);
164        if(count($objPage->arrErr) == 0) {
165            $objPage->tpl_message.="¡û¡§¥Ó¥å¡¼¤Îºï½ü¤ËÀ®¸ù¤·¤Þ¤·¤¿¡£<br>";
166        } else {
167            $objPage->tpl_message.="¡ß¡§¥Ó¥å¡¼¤Îºï½ü¤Ë¼ºÇÔ¤·¤Þ¤·¤¿¡£<br>";     
168        }
169    }
170
171
172    // ¥Æ¡¼¥Ö¥ë¤Îºï½ü
173    if(count($objPage->arrErr) == 0) {
174        $objPage->arrErr = lfExecuteSQL("./drop_table.sql", $arrRet['db_user'], $arrRet['db_password'], $arrRet['db_server'], $arrRet['db_name'], $arrRet['db_type'], $arrRet['db_port'], false);
175        if(count($objPage->arrErr) == 0) {
176            $objPage->tpl_message.="¡û¡§¥Æ¡¼¥Ö¥ë¤Îºï½ü¤ËÀ®¸ù¤·¤Þ¤·¤¿¡£<br>";
177        } else {
178            $objPage->tpl_message.="¡ß¡§¥Æ¡¼¥Ö¥ë¤Îºï½ü¤Ë¼ºÇÔ¤·¤Þ¤·¤¿¡£<br>";       
179        }
180    }
181    $objPage = lfDispStep3($objPage);
182    break;
183// ´°Î»²èÌÌ
184case 'complete':
185
186    // ¥·¥ç¥Ã¥×¥Þ¥¹¥¿¾ðÊó¤Î½ñ¤­¹þ¤ß
187    $arrRet =  $objDBParam->getHashArray();
188   
189    $dsn = $arrRet['db_type']."://".$arrRet['db_user'].":".$arrRet['db_password']."@".$arrRet['db_server'].$port."/".$arrRet['db_name'];
190    $sqlval['shop_name'] = $objWebParam->getValue('shop_name');
191    $sqlval['email01'] = $objWebParam->getValue('admin_mail');
192    $sqlval['email02'] = $objWebParam->getValue('admin_mail');
193    $sqlval['email03'] = $objWebParam->getValue('admin_mail');
194    $sqlval['email04'] = $objWebParam->getValue('admin_mail');
195    $sqlval['email05'] = $objWebParam->getValue('admin_mail');
196    $sqlval['top_tpl'] = "default1";
197    $sqlval['product_tpl'] = "default1";
198    $sqlval['detail_tpl'] = "default1";
199    $sqlval['mypage_tpl'] = "default1";
200    $objQuery = new SC_Query($dsn);
201    $cnt = $objQuery->count("dtb_baseinfo");
202    if($cnt > 0) {
203        $objQuery->update("dtb_baseinfo", $sqlval);
204    } else {       
205        $objQuery->insert("dtb_baseinfo", $sqlval);     
206    }
207    global $GLOBAL_ERR;
208    $GLOBAL_ERR = "";
209    $objPage = lfDispComplete($objPage);
210    break;
211case 'return_step0':
212    $objPage = lfDispStep0($objPage);
213    break; 
214case 'return_step1':
215    $objPage = lfDispStep1($objPage);
216    break;
217case 'return_step2':
218    $objPage = lfDispStep2($objPage);
219    break;
220case 'return_welcome':
221default:
222    $objPage = lfDispWelcome($objPage);
223    break;
224}
225
226//¥Õ¥©¡¼¥àÍѤΥѥé¥á¡¼¥¿¤òÊÖ¤¹
227$objPage->arrForm = $objWebParam->getFormParamList();
228$objPage->arrForm = array_merge($objPage->arrForm, $objDBParam->getFormParamList());
229
230// SiteInfo¤òÆɤ߹þ¤Þ¤Ê¤¤
231$objView->assignobj($objPage);
232$objView->display('install_frame.tpl');
233//-----------------------------------------------------------------------------------------------------------------------------------
234// ¤è¤¦¤³¤½²èÌ̤Îɽ¼¨
235function lfDispWelcome($objPage) {
236    global $objWebParam;
237    global $objDBParam;
238    // hidden¤ËÆþÎÏÃͤòÊÝ»ý
239    $objPage->arrHidden = $objWebParam->getHashArray();
240    // hidden¤ËÆþÎÏÃͤòÊÝ»ý
241    $objPage->arrHidden = array_merge($objPage->arrHidden, $objDBParam->getHashArray());
242    $objPage->arrHidden['db_skip'] = $_POST['db_skip'];
243    $objPage->tpl_mainpage = 'welcome.tpl';
244    $objPage->tpl_mode = 'welcome';
245    return $objPage;
246}
247
248// STEP0²èÌ̤Îɽ¼¨(¥Õ¥¡¥¤¥ë¸¢¸Â¥Á¥§¥Ã¥¯)
249function lfDispStep0($objPage) {
250    global $objWebParam;
251    global $objDBParam;
252    // hidden¤ËÆþÎÏÃͤòÊÝ»ý
253    $objPage->arrHidden = $objWebParam->getHashArray();
254    // hidden¤ËÆþÎÏÃͤòÊÝ»ý
255    $objPage->arrHidden = array_merge($objPage->arrHidden, $objDBParam->getHashArray());
256    $objPage->arrHidden['db_skip'] = $_POST['db_skip'];
257    $objPage->tpl_mainpage = 'step0.tpl';
258    $objPage->tpl_mode = 'step0';
259   
260    // ¥×¥í¥°¥é¥à¤Ç½ñ¹þ¤ß¤µ¤ì¤ë¥Õ¥¡¥¤¥ë¡¦¥Ç¥£¥ì¥¯¥È¥ê
261    $arrWriteFile = array(
262        "data/install.inc",
263        "html/user_data",
264        "html/upload",
265        "data/Smarty/templates_c",     
266        "data/update",
267        "data/logs",
268    );
269   
270    $mess = "";
271    $err_file = false;
272    foreach($arrWriteFile as $val) {
273        $path = "../../" . $val;       
274        if(file_exists($path)) {
275            $mode = lfGetFileMode("../../" . $val);
276           
277            // ¥Ç¥£¥ì¥¯¥È¥ê¤Î¾ì¹ç
278            if(is_dir($path)) {
279                if($mode == "777") {
280                    $mess.= ">> ¡û¡§$val($mode) ¤ÏÌäÂꤢ¤ê¤Þ¤»¤ó¡£<br>";                   
281                } else {
282                    $mess.= ">> ¡ß¡§$val($mode) ¤Ë¥æ¡¼¥¶½ñ¹þ¤ß¸¢¸Â(777)¤òÉÕÍ¿¤·¤Æ²¼¤µ¤¤¡£<br>";
283                    $err_file = true;                                       
284                }
285            } else {
286                if($mode == "666") {
287                    $mess.= ">> ¡û¡§$val($mode) ¤ÏÌäÂꤢ¤ê¤Þ¤»¤ó¡£<br>";                   
288                } else {
289                    $mess.= ">> ¡ß¡§$val($mode) ¤Ë¥æ¡¼¥¶½ñ¹þ¤ß¸¢¸Â(666)¤òÉÕÍ¿¤·¤Æ²¼¤µ¤¤¡£<br>";
290                    $err_file = true;                           
291                }
292            }   
293           
294        } else {
295            $mess.= ">> ¡ß¡§$val ¤¬¸«¤Ä¤«¤ê¤Þ¤»¤ó¡£<br>";
296            $err_file = true;
297        }
298    }
299   
300    // ¸¢¸Â¥¨¥é¡¼Åù¤¬È¯À¸¤·¤Æ¤¤¤Ê¤¤¾ì¹ç
301    if(!$err_file) {
302        $path = "../../data/Smarty/templates_c/admin";
303        if(!file_exists($path)) {
304            mkdir($path);
305        }
306        $path = "../../html/upload/save_image";
307        if(!file_exists($path)) {
308            mkdir($path);
309        }
310        $path = "../../html/upload/temp_image";
311        if(!file_exists($path)) {
312            mkdir($path);
313        }
314        $path = "../../html/upload/graph_image";
315        if(!file_exists($path)) {
316            mkdir($path);
317        }
318        $path = "../../html/upload/csv";
319        if(!file_exists($path)) {
320            mkdir($path);
321        }
322    }
323   
324    $objPage->mess = $mess;
325    $objPage->err_file = $err_file;
326
327    return $objPage;
328}
329
330
331// STEP0_1²èÌ̤Îɽ¼¨(¥Õ¥¡¥¤¥ë¤Î¥³¥Ô¡¼)
332function lfDispStep0_1($objPage) {
333    global $objWebParam;
334    global $objDBParam;
335    // hidden¤ËÆþÎÏÃͤòÊÝ»ý
336    $objPage->arrHidden = $objWebParam->getHashArray();
337    // hidden¤ËÆþÎÏÃͤòÊÝ»ý
338    $objPage->arrHidden = array_merge($objPage->arrHidden, $objDBParam->getHashArray());
339    $objPage->arrHidden['db_skip'] = $_POST['db_skip'];
340    $objPage->tpl_mainpage = 'step0_1.tpl';
341    $objPage->tpl_mode = 'step0_1';
342    // ¥Õ¥¡¥¤¥ë¥³¥Ô¡¼
343    $objPage->copy_mess = sfCopyDir("./user_data/", "../../html/user_data/", $objPage->copy_mess);
344    $objPage->copy_mess = sfCopyDir("./save_image/", "../../html/upload/save_image/", $objPage->copy_mess);
345    return $objPage;
346}
347
348function lfGetFileMode($path) {
349    $mode = substr(sprintf('%o', fileperms($path)), -3);
350    return $mode;
351}
352
353// STEP1²èÌ̤Îɽ¼¨
354function lfDispStep1($objPage) {
355    global $objDBParam;
356    // hidden¤ËÆþÎÏÃͤòÊÝ»ý
357    $objPage->arrHidden = $objDBParam->getHashArray();
358    $objPage->arrHidden['db_skip'] = $_POST['db_skip'];
359    $objPage->tpl_mainpage = 'step1.tpl';
360    $objPage->tpl_mode = 'step1';
361    return $objPage;
362}
363
364// STEP2²èÌ̤Îɽ¼¨
365function lfDispStep2($objPage) {
366    global $objWebParam;
367    global $objDBParam;
368    // hidden¤ËÆþÎÏÃͤòÊÝ»ý
369    $objPage->arrHidden = $objWebParam->getHashArray();
370    $objPage->arrHidden['db_skip'] = $_POST['db_skip'];
371    $objPage->tpl_mainpage = 'step2.tpl';
372    $objPage->tpl_mode = 'step2';
373    return $objPage;
374}
375
376// STEP3²èÌ̤Îɽ¼¨
377function lfDispStep3($objPage) {
378    global $objWebParam;
379    global $objDBParam;
380    // hidden¤ËÆþÎÏÃͤòÊÝ»ý
381    $objPage->arrHidden = $objWebParam->getHashArray();
382    // hidden¤ËÆþÎÏÃͤòÊÝ»ý
383    $objPage->arrHidden = array_merge($objPage->arrHidden, $objDBParam->getHashArray());
384    $objPage->tpl_db_skip = $_POST['db_skip'];
385    $objPage->tpl_mainpage = 'step3.tpl';
386    $objPage->tpl_mode = 'step3';
387    return $objPage;
388}
389
390// ´°Î»²èÌ̤Îɽ¼¨
391function lfDispComplete($objPage) {
392    global $objWebParam;
393    global $objDBParam;
394    // hidden¤ËÆþÎÏÃͤòÊÝ»ý
395    $objPage->arrHidden = $objWebParam->getHashArray();
396    // hidden¤ËÆþÎÏÃͤòÊÝ»ý
397    $objPage->arrHidden = array_merge($objPage->arrHidden, $objDBParam->getHashArray());
398    $objPage->arrHidden['db_skip'] = $_POST['db_skip'];
399    $objPage->tpl_mainpage = 'complete.tpl';
400    $objPage->tpl_mode = 'complete';
401    return $objPage;
402}
403
404// WEB¥Ñ¥é¥á¡¼¥¿¾ðÊó¤Î½é´ü²½
405function lfInitWebParam($objWebParam) {
406   
407    $install_dir = realpath(dirname( __FILE__) . "/../../") . "/";
408    $normal_url = "http://" . $_SERVER['HTTP_HOST'] . "/";
409    $secure_url = "http://" . $_SERVER['HTTP_HOST'] . "/";
410    $domain = ereg_replace("^[a-zA-Z0-9_~=&\?\/-]+\.", "", $_SERVER['HTTP_HOST']);
411    $objWebParam->addParam("Ź̾", "shop_name", MTEXT_LEN, "", array("EXIST_CHECK","MAX_LENGTH_CHECK"));
412    $objWebParam->addParam("´ÉÍý¼Ô¥á¡¼¥ë¥¢¥É¥ì¥¹", "admin_mail", MTEXT_LEN, "", array("EXIST_CHECK","EMAIL_CHECK","EMAIL_CHAR_CHECK","MAX_LENGTH_CHECK"));
413    $objWebParam->addParam("¥¤¥ó¥¹¥È¡¼¥ë¥Ç¥£¥ì¥¯¥È¥ê", "install_dir", MTEXT_LEN, "", array("EXIST_CHECK","MAX_LENGTH_CHECK"), $install_dir);
414    $objWebParam->addParam("URL(Ä̾ï)", "normal_url", MTEXT_LEN, "", array("EXIST_CHECK","URL_CHECK","MAX_LENGTH_CHECK"), $normal_url);
415    $objWebParam->addParam("URL(¥»¥­¥å¥¢)", "secure_url", MTEXT_LEN, "", array("EXIST_CHECK","URL_CHECK","MAX_LENGTH_CHECK"), $secure_url);
416    $objWebParam->addParam("¥É¥á¥¤¥ó", "domain", MTEXT_LEN, "", array("EXIST_CHECK","MAX_LENGTH_CHECK"), $domain); 
417
418    return $objWebParam;
419}
420
421// DB¥Ñ¥é¥á¡¼¥¿¾ðÊó¤Î½é´ü²½
422function lfInitDBParam($objDBParam) {
423   
424    $db_server = "127.0.0.1";
425    $db_port = "3306";
426    $db_name = "eccube_db";
427    $db_user = "eccube_db_user";
428   
429    $objDBParam->addParam("DB¤Î¼ïÎà", "db_type", INT_LEN, "", array("EXIST_CHECK","MAX_LENGTH_CHECK"));
430    $objDBParam->addParam("DB¥µ¡¼¥Ð", "db_server", MTEXT_LEN, "", array("EXIST_CHECK","MAX_LENGTH_CHECK"), $db_server);
431    $objDBParam->addParam("DB¥Ý¡¼¥È", "db_port", INT_LEN, "", array("MAX_LENGTH_CHECK"), $db_port);
432    $objDBParam->addParam("DB̾", "db_name", MTEXT_LEN, "", array("EXIST_CHECK","MAX_LENGTH_CHECK"), $db_name);
433    $objDBParam->addParam("DB¥æ¡¼¥¶", "db_user", MTEXT_LEN, "", array("EXIST_CHECK","MAX_LENGTH_CHECK"), $db_user);
434    $objDBParam->addParam("DB¥Ñ¥¹¥ï¡¼¥É", "db_password", MTEXT_LEN, "", array("EXIST_CHECK","MAX_LENGTH_CHECK"));   
435
436    return $objDBParam;
437}
438
439// ÆþÎÏÆâÍƤΥÁ¥§¥Ã¥¯
440function lfCheckWebError($objFormParam) {
441    // ÆþÎϥǡ¼¥¿¤òÅϤ¹¡£
442    $arrRet =  $objFormParam->getHashArray();
443    $objErr = new SC_CheckError($arrRet);
444    $objErr->arrErr = $objFormParam->checkError();
445    return $objErr->arrErr;
446}
447
448// ÆþÎÏÆâÍƤΥÁ¥§¥Ã¥¯
449function lfCheckDBError($objFormParam) {
450    global $port;
451    // ÆþÎϥǡ¼¥¿¤òÅϤ¹¡£
452    $arrRet =  $objFormParam->getHashArray();
453   
454    $objErr = new SC_CheckError($arrRet);
455    $objErr->arrErr = $objFormParam->checkError();
456   
457    if(count($objErr->arrErr) == 0) {
458        // Àܳ³Îǧ
459        $dsn = $arrRet['db_type']."://".$arrRet['db_user'].":".$arrRet['db_password']."@".$arrRet['db_server'].$port."/".$arrRet['db_name'];
460        // Debug¥â¡¼¥É»ØÄê
461        $options['debug'] = 3;
462        $objDB = DB::connect($dsn, $options);
463        // Àܳ¥¨¥é¡¼
464        if(PEAR::isError($objDB)) {
465            $objErr->arrErr['all'] = ">> " . $objDB->message . "<br>";
466            // ¥¨¥é¡¼Ê¸¤ò¼èÆÀ¤¹¤ë
467            ereg("\[(.*)\]", $objDB->userinfo, $arrKey);
468            $objErr->arrErr['all'].= $arrKey[0] . "<br>";
469            gfPrintLog($objDB->userinfo, "./temp/install.log");
470        }
471    }
472    return $objErr->arrErr;
473}
474
475// SQLʸ¤Î¼Â¹Ô
476function lfExecuteSQL($filepath, $db_user, $db_password, $db_server, $db_name, $db_type, $db_port, $disp_err = true) {
477    global $port;
478    $arrErr = array();
479
480    if(!file_exists($filepath)) {
481        $arrErr['all'] = ">> ¥¹¥¯¥ê¥×¥È¥Õ¥¡¥¤¥ë¤¬¸«¤Ä¤«¤ê¤Þ¤»¤ó";
482    } else {
483        if($fp = fopen($filepath,"r")) {
484            $sql = fread($fp, filesize($filepath));
485            fclose($fp);
486        }
487
488        $dsn = $db_type."://".$db_user.":".$db_password."@".$db_server.$port."/".$db_name;
489       
490        $objDB = DB::connect($dsn);
491        // Àܳ¥¨¥é¡¼
492        if(!PEAR::isError($objDB)) {
493            // ²þ¹Ô¡¢¥¿¥Ö¤ò1¥¹¥Ú¡¼¥¹¤ËÊÑ´¹
494            $sql = preg_replace("/[\r\n\t]/"," ",$sql);
495            $sql_split = split(";",$sql);
496            foreach($sql_split as $key => $val){
497                if (trim($val) != "") {
498                    $ret = $objDB->query($val);
499                    if(PEAR::isError($ret) and $disp_err) {
500                        $arrErr['all'] = ">> " . $ret->message . "<br>";
501                        // ¥¨¥é¡¼Ê¸¤ò¼èÆÀ¤¹¤ë
502                        ereg("\[(.*)\]", $ret->userinfo, $arrKey);
503                        $arrErr['all'].= $arrKey[0] . "<br>";
504                        $objPage->update_mess.=">> ¥Æ¡¼¥Ö¥ë¹½À®¤ÎÊѹ¹¤Ë¼ºÇÔ¤·¤Þ¤·¤¿¡£<br>";
505                        gfPrintLog($ret->userinfo, "./temp/install.log");
506                    }
507                }
508            }
509           
510        } else {
511            $arrErr['all'] = ">> " . $objDB->message;
512            gfPrintLog($objDB->userinfo, "./temp/install.log");
513        }
514    }
515    return $arrErr;
516}
517
518// ÀßÄê¥Õ¥¡¥¤¥ë¤ÎºîÀ®
519function lfMakeConfigFile() {
520    global $objWebParam;
521    global $objDBParam;
522    global $port;
523   
524    $filepath = $objWebParam->getValue('install_dir') . "/data/install.inc";
525    $domain = $objWebParam->getValue('domain');
526    if(!ereg("^\.", $domain)) {
527        $domain = "." . $domain;
528    }
529   
530    $root_dir = $objWebParam->getValue('install_dir');
531    if (!ereg("/$", $root_dir)) {
532        $root_dir = $root_dir . "/";
533    }
534   
535    $config_data =
536    "<?php\n".
537    "    define ('ECCUBE_INSTALL', 'ON');\n" .
538    "    define ('ROOT_DIR', '" . $root_dir . "');\n" .
539    "    define ('SITE_URL', '" . $objWebParam->getValue('normal_url') . "');\n" .
540    "    define ('SSL_URL', '" . $objWebParam->getValue('secure_url') . "');\n" .
541    "    define ('DOMAIN_NAME', '" . $domain . "');\n" .
542    "    define ('DB_TYPE', '" . $objDBParam->getValue('db_type') . "');\n" .
543    "    define ('DB_USER', '" . $objDBParam->getValue('db_user') . "');\n" .
544    "    define ('DB_PASSWORD', '" . $objDBParam->getValue('db_password') . "');\n" .
545    "    define ('DB_SERVER', '" . $objDBParam->getValue('db_server') . "');\n" .
546    "    define ('DB_NAME', '" . $objDBParam->getValue('db_name') . "');\n" .
547    "    define ('DB_PORT', '" . $port . "');\n" .
548    "?>";
549   
550    if($fp = fopen($filepath,"w")) {
551        fwrite($fp, $config_data);
552        fclose($fp);
553    }
554}
555
556?>
Note: See TracBrowser for help on using the repository browser.