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

Revision 5898, 17.0 KB checked in by kakinaka, 20 years ago (diff)

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