1 | <?php |
---|
2 | /* |
---|
3 | * Copyright(c) 2000-2007 LOCKON CO.,LTD. All Rights Reserved. |
---|
4 | * |
---|
5 | * http://www.lockon.co.jp/ |
---|
6 | */ |
---|
7 | require_once("../require.php"); |
---|
8 | $INSTALL_DIR = realpath(dirname( __FILE__)); |
---|
9 | require_once("../../data/module/Request.php"); |
---|
10 | |
---|
11 | define("INSTALL_LOG", "./temp/install.log"); |
---|
12 | |
---|
13 | class LC_Page { |
---|
14 | function LC_Page() { |
---|
15 | $this->arrDB_TYPE = array( |
---|
16 | 'pgsql' => 'PostgreSQL', |
---|
17 | 'mysql' => 'MySQL' |
---|
18 | ); |
---|
19 | $this->arrDB_PORT = array( |
---|
20 | 'pgsql' => '', |
---|
21 | 'mysql' => '' |
---|
22 | ); |
---|
23 | } |
---|
24 | } |
---|
25 | |
---|
26 | $objPage = new LC_Page(); |
---|
27 | |
---|
28 | // ¥Æ¥ó¥×¥ì¡¼¥È¥³¥ó¥Ñ¥¤¥ë¥Ç¥£¥ì¥¯¥È¥ê¤Î½ñ¹þ¤ß¸¢¸Â¥Á¥§¥Ã¥¯ |
---|
29 | $temp_dir = $INSTALL_DIR . '/temp'; |
---|
30 | $mode = lfGetFileMode($temp_dir); |
---|
31 | |
---|
32 | if($mode != '777') { |
---|
33 | sfErrorHeader($temp_dir . "¤Ë¥æ¡¼¥¶½ñ¹þ¤ß¸¢¸Â(777)¤òÉÕÍ¿¤·¤Æ²¼¤µ¤¤¡£", true); |
---|
34 | exit; |
---|
35 | } |
---|
36 | |
---|
37 | $objView = new SC_InstallView($INSTALL_DIR . '/templates', $INSTALL_DIR . '/temp'); |
---|
38 | |
---|
39 | // ¥Ñ¥é¥á¡¼¥¿´ÉÍý¥¯¥é¥¹ |
---|
40 | $objWebParam = new SC_FormParam(); |
---|
41 | $objDBParam = new SC_FormParam(); |
---|
42 | // ¥Ñ¥é¥á¡¼¥¿¾ðÊó¤Î½é´ü²½ |
---|
43 | $objWebParam = lfInitWebParam($objWebParam); |
---|
44 | $objDBParam = lfInitDBParam($objDBParam); |
---|
45 | |
---|
46 | //¥Õ¥©¡¼¥àÇÛÎó¤Î¼èÆÀ |
---|
47 | $objWebParam->setParam($_POST); |
---|
48 | $objDBParam->setParam($_POST); |
---|
49 | |
---|
50 | switch($_POST['mode']) { |
---|
51 | // ¤è¤¦¤³¤½ |
---|
52 | case 'welcome': |
---|
53 | //$objPage = lfDispAgreement($objPage); |
---|
54 | $objPage = lfDispStep0($objPage); |
---|
55 | //$objPage->tpl_onload .= "fnChangeVisible('agreement_yes', 'next');"; |
---|
56 | break; |
---|
57 | |
---|
58 | /* ¸½ºßÊÝαÃæ |
---|
59 | |
---|
60 | // »ÈÍѵöÂú·ÀÌó½ñ¤ÎƱ°Õ |
---|
61 | case 'agreement': |
---|
62 | $objPage = lfDispStep0($objPage); |
---|
63 | break; |
---|
64 | */ |
---|
65 | |
---|
66 | // ¥¢¥¯¥»¥¹¸¢¸Â¤Î¥Á¥§¥Ã¥¯ |
---|
67 | case 'step0': |
---|
68 | $objPage = lfDispStep0_1($objPage); |
---|
69 | break; |
---|
70 | // ¥Õ¥¡¥¤¥ë¤Î¥³¥Ô¡¼ |
---|
71 | case 'step0_1': |
---|
72 | $objPage = lfDispStep1($objPage); |
---|
73 | break; |
---|
74 | // WEB¥µ¥¤¥È¤ÎÀßÄê |
---|
75 | case 'step1': |
---|
76 | //ÆþÎÏÃͤΥ¨¥é¡¼¥Á¥§¥Ã¥¯ |
---|
77 | $objPage->arrErr = lfCheckWEBError($objWebParam); |
---|
78 | if(count($objPage->arrErr) == 0) { |
---|
79 | $objPage = lfDispStep2($objPage); |
---|
80 | } else { |
---|
81 | $objPage = lfDispStep1($objPage); |
---|
82 | } |
---|
83 | break; |
---|
84 | // ¥Ç¡¼¥¿¥Ù¡¼¥¹¤ÎÀßÄê |
---|
85 | case 'step2': |
---|
86 | //ÆþÎÏÃͤΥ¨¥é¡¼¥Á¥§¥Ã¥¯ |
---|
87 | $objPage->arrErr = lfCheckDBError($objDBParam); |
---|
88 | if(count($objPage->arrErr) == 0) { |
---|
89 | $objPage = lfDispStep3($objPage); |
---|
90 | } else { |
---|
91 | $objPage = lfDispStep2($objPage); |
---|
92 | } |
---|
93 | break; |
---|
94 | // ¥Æ¡¼¥Ö¥ë¤ÎºîÀ® |
---|
95 | case 'step3': |
---|
96 | // ÆþÎϥǡ¼¥¿¤òÅϤ¹¡£ |
---|
97 | $arrRet = $objDBParam->getHashArray(); |
---|
98 | $dsn = $arrRet['db_type']."://".$arrRet['db_user'].":".$arrRet['db_password']."@".$arrRet['db_server'].":".$arrRet['db_port']."/".$arrRet['db_name']; |
---|
99 | |
---|
100 | /* |
---|
101 | lfAddTable¤Ï¡¢¥Ð¡¼¥¸¥ç¥ó¥¢¥Ã¥×Åù¤ÇÄɲåơ¼¥Ö¥ë¤¬È¯À¸¤·¤¿¾ì¹ç¤Ë¼Â¹Ô¤¹¤ë¡£ |
---|
102 | ¡Ê£Ä£Â¹½À®¤Î²¼°Ì¸ß´¹¤Î¤¿¤á¥¹¥¥Ã¥×»þ¤â¶¯À©¡Ë |
---|
103 | */ |
---|
104 | // ¥Æ¡¼¥Ö¥ë¤¬Â¸ºß¤·¤Ê¤¤¾ì¹ç¤ËÄɲ䵤ì¤ë¡£ |
---|
105 | $objPage->arrErr = lfAddTable("dtb_session", $dsn); // ¥»¥Ã¥·¥ç¥ó´ÉÍý¥Æ¡¼¥Ö¥ë |
---|
106 | $objPage->arrErr = lfAddTable("dtb_module", $dsn); // ¥â¥¸¥å¡¼¥ë´ÉÍý¥Æ¡¼¥Ö¥ë |
---|
107 | $objPage->arrErr = lfAddTable("dtb_campaign_order", $dsn); // ¥¥ã¥ó¥Ú¡¼¥ó¼õÃí¥Æ¡¼¥Ö¥ë |
---|
108 | // ¥Æ¡¼¥Ö¥ë¤¬Â¸ºß¤·¤Ê¤¤¾ì¹ç¤ËÄɲ䵤ì¤ë¡£ |
---|
109 | $objPage->arrErr = lfAddTable("dtb_mobile_kara_mail", $dsn); // ¶õ¥á¡¼¥ë´ÉÍý¥Æ¡¼¥Ö¥ë |
---|
110 | // ¥Æ¡¼¥Ö¥ë¤¬Â¸ºß¤·¤Ê¤¤¾ì¹ç¤ËÄɲ䵤ì¤ë¡£ |
---|
111 | $objPage->arrErr = lfAddTable("dtb_mobile_ext_session_id", $dsn); // ¥»¥Ã¥·¥ç¥óID´ÉÍý¥Æ¡¼¥Ö¥ë |
---|
112 | |
---|
113 | // ¥«¥é¥à¤òÄɲà |
---|
114 | lfAddColumn($dsn); |
---|
115 | |
---|
116 | // ¥Ç¡¼¥¿¤òÄɲà |
---|
117 | lfAddData($dsn); |
---|
118 | |
---|
119 | if(count($objPage->arrErr) == 0) { |
---|
120 | // ¥¹¥¥Ã¥×¤¹¤ë¾ì¹ç¤Ë¤Ï¼¡²èÌ̤ØÁ«°Ü |
---|
121 | $skip = $_POST["db_skip"]; |
---|
122 | if ($skip == "on") { |
---|
123 | // ÀßÄê¥Õ¥¡¥¤¥ë¤ÎÀ¸À® |
---|
124 | lfMakeConfigFile(); |
---|
125 | $objPage = lfDispComplete($objPage); |
---|
126 | //$objPage = lfDispStep4($objPage); |
---|
127 | break; |
---|
128 | } |
---|
129 | } |
---|
130 | |
---|
131 | // ¥Æ¡¼¥Ö¥ë¤ÎºîÀ® |
---|
132 | $objPage->arrErr = lfExecuteSQL("./sql/create_table_".$arrRet['db_type'].".sql", $dsn); |
---|
133 | if(count($objPage->arrErr) == 0) { |
---|
134 | $objPage->tpl_message.="¡û¡§¥Æ¡¼¥Ö¥ë¤ÎºîÀ®¤ËÀ®¸ù¤·¤Þ¤·¤¿¡£<br>"; |
---|
135 | } else { |
---|
136 | $objPage->tpl_message.="¡ß¡§¥Æ¡¼¥Ö¥ë¤ÎºîÀ®¤Ë¼ºÇÔ¤·¤Þ¤·¤¿¡£<br>"; |
---|
137 | } |
---|
138 | |
---|
139 | // ¥Ó¥å¡¼¤ÎºîÀ® |
---|
140 | if(count($objPage->arrErr) == 0 and $arrRet['db_type'] == 'pgsql') { |
---|
141 | // ¥Ó¥å¡¼¤ÎºîÀ® |
---|
142 | $objPage->arrErr = lfExecuteSQL("./sql/create_view.sql", $dsn); |
---|
143 | if(count($objPage->arrErr) == 0) { |
---|
144 | $objPage->tpl_message.="¡û¡§¥Ó¥å¡¼¤ÎºîÀ®¤ËÀ®¸ù¤·¤Þ¤·¤¿¡£<br>"; |
---|
145 | } else { |
---|
146 | $objPage->tpl_message.="¡ß¡§¥Ó¥å¡¼¤ÎºîÀ®¤Ë¼ºÇÔ¤·¤Þ¤·¤¿¡£<br>"; |
---|
147 | } |
---|
148 | } |
---|
149 | |
---|
150 | // ½é´ü¥Ç¡¼¥¿¤ÎºîÀ® |
---|
151 | if(count($objPage->arrErr) == 0) { |
---|
152 | $objPage->arrErr = lfExecuteSQL("./sql/insert_data.sql", $dsn); |
---|
153 | |
---|
154 | if(count($objPage->arrErr) == 0) { |
---|
155 | $objPage->tpl_message.="¡û¡§½é´ü¥Ç¡¼¥¿¤ÎºîÀ®¤ËÀ®¸ù¤·¤Þ¤·¤¿¡£<br>"; |
---|
156 | } else { |
---|
157 | $objPage->tpl_message.="¡ß¡§½é´ü¥Ç¡¼¥¿¤ÎºîÀ®¤Ë¼ºÇÔ¤·¤Þ¤·¤¿¡£<br>"; |
---|
158 | } |
---|
159 | } |
---|
160 | |
---|
161 | // ¥«¥é¥à¥³¥á¥ó¥È¤Î½ñ¹þ¤ß |
---|
162 | if(count($objPage->arrErr) == 0) { |
---|
163 | $objPage->arrErr = lfExecuteSQL("./sql/column_comment.sql", $dsn); |
---|
164 | if(count($objPage->arrErr) == 0) { |
---|
165 | $objPage->tpl_message.="¡û¡§¥«¥é¥à¥³¥á¥ó¥È¤Î½ñ¹þ¤ß¤ËÀ®¸ù¤·¤Þ¤·¤¿¡£<br>"; |
---|
166 | } else { |
---|
167 | $objPage->tpl_message.="¡ß¡§¥«¥é¥à¥³¥á¥ó¥È¤Î½ñ¹þ¤ß¤Ë¼ºÇÔ¤·¤Þ¤·¤¿¡£<br>"; |
---|
168 | } |
---|
169 | } |
---|
170 | |
---|
171 | // ¥Æ¡¼¥Ö¥ë¥³¥á¥ó¥È¤Î½ñ¹þ¤ß |
---|
172 | if(count($objPage->arrErr) == 0) { |
---|
173 | $objPage->arrErr = lfExecuteSQL("./sql/table_comment.sql", $dsn); |
---|
174 | if(count($objPage->arrErr) == 0) { |
---|
175 | $objPage->tpl_message.="¡û¡§¥Æ¡¼¥Ö¥ë¥³¥á¥ó¥È¤Î½ñ¹þ¤ß¤ËÀ®¸ù¤·¤Þ¤·¤¿¡£<br>"; |
---|
176 | } else { |
---|
177 | $objPage->tpl_message.="¡ß¡§¥Æ¡¼¥Ö¥ë¥³¥á¥ó¥È¤Î½ñ¹þ¤ß¤Ë¼ºÇÔ¤·¤Þ¤·¤¿¡£<br>"; |
---|
178 | } |
---|
179 | } |
---|
180 | |
---|
181 | if(count($objPage->arrErr) == 0) { |
---|
182 | // ÀßÄê¥Õ¥¡¥¤¥ë¤ÎÀ¸À® |
---|
183 | lfMakeConfigFile(); |
---|
184 | $objPage = lfDispStep3($objPage); |
---|
185 | $objPage->tpl_mode = 'step4'; |
---|
186 | } else { |
---|
187 | $objPage = lfDispStep3($objPage); |
---|
188 | } |
---|
189 | break; |
---|
190 | case 'step4': |
---|
191 | $objPage = lfDispStep4($objPage); |
---|
192 | break; |
---|
193 | |
---|
194 | // ¥Æ¡¼¥Ö¥ëÎàºï½ü |
---|
195 | case 'drop': |
---|
196 | // ÆþÎϥǡ¼¥¿¤òÅϤ¹¡£ |
---|
197 | $arrRet = $objDBParam->getHashArray(); |
---|
198 | $dsn = $arrRet['db_type']."://".$arrRet['db_user'].":".$arrRet['db_password']."@".$arrRet['db_server'].":".$arrRet['db_port']."/".$arrRet['db_name']; |
---|
199 | |
---|
200 | // Äɲåơ¼¥Ö¥ë¤¬¤¢¤ì¤Ðºï½ü¤¹¤ë¡£ |
---|
201 | lfDropTable("dtb_module", $dsn); |
---|
202 | lfDropTable("dtb_session", $dsn); |
---|
203 | lfDropTable("dtb_campaign_order", $dsn); |
---|
204 | lfDropTable("dtb_mobile_ext_session_id", $dsn); |
---|
205 | lfDropTable("dtb_mobile_kara_mail", $dsn); |
---|
206 | |
---|
207 | if ($arrRet['db_type'] == 'pgsql'){ |
---|
208 | // ¥Ó¥å¡¼¤Îºï½ü |
---|
209 | $objPage->arrErr = lfExecuteSQL("./sql/drop_view.sql", $dsn, false); |
---|
210 | if(count($objPage->arrErr) == 0) { |
---|
211 | $objPage->tpl_message.="¡û¡§¥Ó¥å¡¼¤Îºï½ü¤ËÀ®¸ù¤·¤Þ¤·¤¿¡£<br>"; |
---|
212 | } else { |
---|
213 | $objPage->tpl_message.="¡ß¡§¥Ó¥å¡¼¤Îºï½ü¤Ë¼ºÇÔ¤·¤Þ¤·¤¿¡£<br>"; |
---|
214 | } |
---|
215 | } |
---|
216 | |
---|
217 | // ¥Æ¡¼¥Ö¥ë¤Îºï½ü |
---|
218 | if(count($objPage->arrErr) == 0) { |
---|
219 | $objPage->arrErr = lfExecuteSQL("./sql/drop_table.sql", $dsn, false); |
---|
220 | if(count($objPage->arrErr) == 0) { |
---|
221 | $objPage->tpl_message.="¡û¡§¥Æ¡¼¥Ö¥ë¤Îºï½ü¤ËÀ®¸ù¤·¤Þ¤·¤¿¡£<br>"; |
---|
222 | } else { |
---|
223 | $objPage->tpl_message.="¡ß¡§¥Æ¡¼¥Ö¥ë¤Îºï½ü¤Ë¼ºÇÔ¤·¤Þ¤·¤¿¡£<br>"; |
---|
224 | } |
---|
225 | } |
---|
226 | $objPage = lfDispStep3($objPage); |
---|
227 | break; |
---|
228 | // ´°Î»²èÌÌ |
---|
229 | case 'complete': |
---|
230 | // ¥·¥ç¥Ã¥×¥Þ¥¹¥¿¾ðÊó¤Î½ñ¤¹þ¤ß |
---|
231 | $arrRet = $objDBParam->getHashArray(); |
---|
232 | |
---|
233 | $dsn = $arrRet['db_type']."://".$arrRet['db_user'].":".$arrRet['db_password']."@".$arrRet['db_server'].":".$arrRet['db_port']."/".$arrRet['db_name']; |
---|
234 | $sqlval['shop_name'] = $objWebParam->getValue('shop_name'); |
---|
235 | $sqlval['email01'] = $objWebParam->getValue('admin_mail'); |
---|
236 | $sqlval['email02'] = $objWebParam->getValue('admin_mail'); |
---|
237 | $sqlval['email03'] = $objWebParam->getValue('admin_mail'); |
---|
238 | $sqlval['email04'] = $objWebParam->getValue('admin_mail'); |
---|
239 | $sqlval['email05'] = $objWebParam->getValue('admin_mail'); |
---|
240 | $sqlval['top_tpl'] = "default1"; |
---|
241 | $sqlval['product_tpl'] = "default1"; |
---|
242 | $sqlval['detail_tpl'] = "default1"; |
---|
243 | $sqlval['mypage_tpl'] = "default1"; |
---|
244 | $objQuery = new SC_Query($dsn); |
---|
245 | $cnt = $objQuery->count("dtb_baseinfo"); |
---|
246 | if($cnt > 0) { |
---|
247 | $objQuery->update("dtb_baseinfo", $sqlval); |
---|
248 | } else { |
---|
249 | $objQuery->insert("dtb_baseinfo", $sqlval); |
---|
250 | } |
---|
251 | |
---|
252 | // ´ÉÍý¼ÔÅÐÏ¿ |
---|
253 | $login_id = $objWebParam->getValue('login_id'); |
---|
254 | $login_pass = sha1($objWebParam->getValue('login_pass') . ":" . AUTH_MAGIC); |
---|
255 | |
---|
256 | $sql = "DELETE FROM dtb_member WHERE login_id = ?"; |
---|
257 | $objQuery->query($sql, array($login_id)); |
---|
258 | |
---|
259 | $sql = "INSERT INTO dtb_member (name, login_id, password, creator_id, authority, work, del_flg, rank, create_date, update_date) |
---|
260 | VALUES ('´ÉÍý¼Ô',?,?,0,0,1,0,1, now(), now());"; |
---|
261 | |
---|
262 | $objQuery->query($sql, array($login_id, $login_pass)); |
---|
263 | |
---|
264 | global $GLOBAL_ERR; |
---|
265 | $GLOBAL_ERR = ""; |
---|
266 | $objPage = lfDispComplete($objPage); |
---|
267 | |
---|
268 | // ¥µ¥¤¥È¾ðÊó¤òÁ÷¿® |
---|
269 | $req = new HTTP_Request("http://www.ec-cube.net/mall/use_site.php"); |
---|
270 | $req->setMethod(HTTP_REQUEST_METHOD_POST); |
---|
271 | |
---|
272 | $arrSendData = array(); |
---|
273 | foreach($_POST as $key => $val){ |
---|
274 | if (ereg("^senddata_*", $key)){ |
---|
275 | $arrSendDataTmp = array(str_replace("senddata_", "", $key) => $val); |
---|
276 | $arrSendData = array_merge($arrSendData, $arrSendDataTmp); |
---|
277 | } |
---|
278 | } |
---|
279 | |
---|
280 | $req->addPostDataArray($arrSendData); |
---|
281 | |
---|
282 | if (!PEAR::isError($req->sendRequest())) { |
---|
283 | $response1 = $req->getResponseBody(); |
---|
284 | } else { |
---|
285 | $response1 = ""; |
---|
286 | } |
---|
287 | $req->clearPostData(); |
---|
288 | |
---|
289 | break; |
---|
290 | case 'return_step0': |
---|
291 | $objPage = lfDispStep0($objPage); |
---|
292 | break; |
---|
293 | case 'return_step1': |
---|
294 | $objPage = lfDispStep1($objPage); |
---|
295 | break; |
---|
296 | case 'return_step2': |
---|
297 | $objPage = lfDispStep2($objPage); |
---|
298 | break; |
---|
299 | case 'return_step3': |
---|
300 | $objPage = lfDispStep3($objPage); |
---|
301 | break; |
---|
302 | case 'return_agreement': |
---|
303 | $objPage = lfDispAgreement($objPage); |
---|
304 | $objPage->tpl_onload .= "fnChangeVisible('agreement_yes', 'next');"; |
---|
305 | break; |
---|
306 | case 'return_welcome': |
---|
307 | default: |
---|
308 | $objPage = lfDispWelcome($objPage); |
---|
309 | break; |
---|
310 | } |
---|
311 | |
---|
312 | //¥Õ¥©¡¼¥àÍѤΥѥé¥á¡¼¥¿¤òÊÖ¤¹ |
---|
313 | $objPage->arrForm = $objWebParam->getFormParamList(); |
---|
314 | $objPage->arrForm = array_merge($objPage->arrForm, $objDBParam->getFormParamList()); |
---|
315 | |
---|
316 | // SiteInfo¤òÆɤ߹þ¤Þ¤Ê¤¤ |
---|
317 | $objView->assignobj($objPage); |
---|
318 | $objView->display('install_frame.tpl'); |
---|
319 | //----------------------------------------------------------------------------------------------------------------------------------- |
---|
320 | // ¤è¤¦¤³¤½²èÌ̤Îɽ¼¨ |
---|
321 | function lfDispWelcome($objPage) { |
---|
322 | global $objWebParam; |
---|
323 | global $objDBParam; |
---|
324 | // hidden¤ËÆþÎÏÃͤòÊÝ»ý |
---|
325 | $objPage->arrHidden = $objWebParam->getHashArray(); |
---|
326 | // hidden¤ËÆþÎÏÃͤòÊÝ»ý |
---|
327 | $objPage->arrHidden = array_merge($objPage->arrHidden, $objDBParam->getHashArray()); |
---|
328 | $objPage->arrHidden['db_skip'] = $_POST['db_skip']; |
---|
329 | $objPage->arrHidden['agreement'] = $_POST['agreement']; |
---|
330 | $objPage->tpl_mainpage = 'welcome.tpl'; |
---|
331 | $objPage->tpl_mode = 'welcome'; |
---|
332 | return $objPage; |
---|
333 | } |
---|
334 | |
---|
335 | // »ÈÍѵöÂú·ÀÌó½ñ¤Îɽ¼¨ |
---|
336 | function lfDispAgreement($objPage) { |
---|
337 | global $objWebParam; |
---|
338 | global $objDBParam; |
---|
339 | // hidden¤ËÆþÎÏÃͤòÊÝ»ý |
---|
340 | $objPage->arrHidden = $objWebParam->getHashArray(); |
---|
341 | // hidden¤ËÆþÎÏÃͤòÊÝ»ý |
---|
342 | $objPage->arrHidden = array_merge($objPage->arrHidden, $objDBParam->getHashArray()); |
---|
343 | $objPage->arrHidden['db_skip'] = $_POST['db_skip']; |
---|
344 | $objPage->arrHidden['agreement'] = $_POST['agreement']; |
---|
345 | $objPage->tpl_mainpage = 'agreement.tpl'; |
---|
346 | $objPage->tpl_mode = 'agreement'; |
---|
347 | return $objPage; |
---|
348 | } |
---|
349 | |
---|
350 | // STEP0²èÌ̤Îɽ¼¨(¥Õ¥¡¥¤¥ë¸¢¸Â¥Á¥§¥Ã¥¯) |
---|
351 | function lfDispStep0($objPage) { |
---|
352 | global $objWebParam; |
---|
353 | global $objDBParam; |
---|
354 | // hidden¤ËÆþÎÏÃͤòÊÝ»ý |
---|
355 | $objPage->arrHidden = $objWebParam->getHashArray(); |
---|
356 | // hidden¤ËÆþÎÏÃͤòÊÝ»ý |
---|
357 | $objPage->arrHidden = array_merge($objPage->arrHidden, $objDBParam->getHashArray()); |
---|
358 | $objPage->arrHidden['db_skip'] = $_POST['db_skip']; |
---|
359 | $objPage->arrHidden['agreement'] = $_POST['agreement']; |
---|
360 | $objPage->tpl_mainpage = 'step0.tpl'; |
---|
361 | $objPage->tpl_mode = 'step0'; |
---|
362 | |
---|
363 | // ¥×¥í¥°¥é¥à¤Ç½ñ¹þ¤ß¤µ¤ì¤ë¥Õ¥¡¥¤¥ë¡¦¥Ç¥£¥ì¥¯¥È¥ê |
---|
364 | $arrWriteFile = array( |
---|
365 | "../../data/install.inc", |
---|
366 | "../user_data", |
---|
367 | "../cp", |
---|
368 | "../upload", |
---|
369 | "../mobile/converted_images", |
---|
370 | "../../data/Smarty/templates_c", |
---|
371 | "../../data/downloads", |
---|
372 | "../../data/logs" |
---|
373 | ); |
---|
374 | |
---|
375 | $mess = ""; |
---|
376 | $err_file = false; |
---|
377 | foreach($arrWriteFile as $val) { |
---|
378 | if(file_exists($val)) { |
---|
379 | $mode = lfGetFileMode($val); |
---|
380 | $real_path = realpath($val); |
---|
381 | |
---|
382 | // ¥Ç¥£¥ì¥¯¥È¥ê¤Î¾ì¹ç |
---|
383 | if(is_dir($val)) { |
---|
384 | if($mode == "777") { |
---|
385 | $mess.= ">> ¡û¡§$real_path($mode) <br>¥¢¥¯¥»¥¹¸¢¸Â¤ÏÀµ¾ï¤Ç¤¹¡£<br>"; |
---|
386 | } else { |
---|
387 | $mess.= ">> ¡ß¡§$real_path($mode) <br>¥æ¡¼¥¶½ñ¹þ¤ß¸¢¸Â(777)¤òÉÕÍ¿¤·¤Æ²¼¤µ¤¤¡£<br>"; |
---|
388 | $err_file = true; |
---|
389 | } |
---|
390 | } else { |
---|
391 | if($mode == "666") { |
---|
392 | $mess.= ">> ¡û¡§$real_path($mode) <br>¥¢¥¯¥»¥¹¸¢¸Â¤ÏÀµ¾ï¤Ç¤¹¡£<br>"; |
---|
393 | } else { |
---|
394 | $mess.= ">> ¡ß¡§$real_path($mode) <br>¥æ¡¼¥¶½ñ¹þ¤ß¸¢¸Â(666)¤òÉÕÍ¿¤·¤Æ²¼¤µ¤¤¡£<br>"; |
---|
395 | $err_file = true; |
---|
396 | } |
---|
397 | } |
---|
398 | } else { |
---|
399 | $mess.= ">> ¡ß¡§$val ¤¬¸«¤Ä¤«¤ê¤Þ¤»¤ó¡£<br>"; |
---|
400 | $err_file = true; |
---|
401 | } |
---|
402 | } |
---|
403 | |
---|
404 | // ¸¢¸Â¥¨¥é¡¼Åù¤¬È¯À¸¤·¤Æ¤¤¤Ê¤¤¾ì¹ç |
---|
405 | if(!$err_file) { |
---|
406 | $path = "../../data/Smarty/templates_c/admin"; |
---|
407 | if(!file_exists($path)) { |
---|
408 | mkdir($path); |
---|
409 | } |
---|
410 | $path = "../upload/temp_template"; |
---|
411 | if(!file_exists($path)) { |
---|
412 | mkdir($path); |
---|
413 | } |
---|
414 | $path = "../upload/save_image"; |
---|
415 | if(!file_exists($path)) { |
---|
416 | mkdir($path); |
---|
417 | } |
---|
418 | $path = "../upload/temp_image"; |
---|
419 | if(!file_exists($path)) { |
---|
420 | mkdir($path); |
---|
421 | } |
---|
422 | $path = "../upload/graph_image"; |
---|
423 | if(!file_exists($path)) { |
---|
424 | mkdir($path); |
---|
425 | } |
---|
426 | $path = "../upload/csv"; |
---|
427 | if(!file_exists($path)) { |
---|
428 | mkdir($path); |
---|
429 | } |
---|
430 | $path = "../../data/downloads/module"; |
---|
431 | if(!file_exists($path)) { |
---|
432 | mkdir($path); |
---|
433 | } |
---|
434 | $path = "../../data/downloads/update"; |
---|
435 | if(!file_exists($path)) { |
---|
436 | mkdir($path); |
---|
437 | } |
---|
438 | } |
---|
439 | |
---|
440 | $objPage->mess = $mess; |
---|
441 | $objPage->err_file = $err_file; |
---|
442 | |
---|
443 | return $objPage; |
---|
444 | } |
---|
445 | |
---|
446 | // STEP0_1²èÌ̤Îɽ¼¨(¥Õ¥¡¥¤¥ë¤Î¥³¥Ô¡¼) |
---|
447 | function lfDispStep0_1($objPage) { |
---|
448 | global $objWebParam; |
---|
449 | global $objDBParam; |
---|
450 | // hidden¤ËÆþÎÏÃͤòÊÝ»ý |
---|
451 | $objPage->arrHidden = $objWebParam->getHashArray(); |
---|
452 | // hidden¤ËÆþÎÏÃͤòÊÝ»ý |
---|
453 | $objPage->arrHidden = array_merge($objPage->arrHidden, $objDBParam->getHashArray()); |
---|
454 | $objPage->arrHidden['db_skip'] = $_POST['db_skip']; |
---|
455 | $objPage->arrHidden['agreement'] = $_POST['agreement']; |
---|
456 | $objPage->tpl_mainpage = 'step0_1.tpl'; |
---|
457 | $objPage->tpl_mode = 'step0_1'; |
---|
458 | // ¥Õ¥¡¥¤¥ë¥³¥Ô¡¼ |
---|
459 | $objPage->copy_mess = sfCopyDir("./user_data/", "../user_data/", $objPage->copy_mess); |
---|
460 | $objPage->copy_mess = sfCopyDir("./save_image/", "../upload/save_image/", $objPage->copy_mess); |
---|
461 | return $objPage; |
---|
462 | } |
---|
463 | |
---|
464 | // STEP0_2²èÌ̤Îɽ¼¨(¥Õ¥¡¥¤¥ë¤Î¥³¥Ô¡¼) |
---|
465 | function lfDispStep0_2($objPage) { |
---|
466 | global $objWebParam; |
---|
467 | global $objDBParam; |
---|
468 | // hidden¤ËÆþÎÏÃͤòÊÝ»ý |
---|
469 | $objPage->arrHidden = $objWebParam->getHashArray(); |
---|
470 | // hidden¤ËÆþÎÏÃͤòÊÝ»ý |
---|
471 | $objPage->arrHidden = array_merge($objPage->arrHidden, $objDBParam->getHashArray()); |
---|
472 | $objPage->arrHidden['db_skip'] = $_POST['db_skip']; |
---|
473 | $objPage->arrHidden['agreement'] = $_POST['agreement']; |
---|
474 | $objPage->tpl_mainpage = 'step0_1.tpl'; |
---|
475 | $objPage->tpl_mode = 'step0_1'; |
---|
476 | // ¥Õ¥¡¥¤¥ë¥³¥Ô¡¼ |
---|
477 | $objPage->copy_mess = sfCopyDir("./user_data/", "../user_data/", $objPage->copy_mess); |
---|
478 | $objPage->copy_mess = sfCopyDir("./save_image/", "../upload/save_image/", $objPage->copy_mess); |
---|
479 | return $objPage; |
---|
480 | } |
---|
481 | |
---|
482 | function lfGetFileMode($path) { |
---|
483 | $mode = substr(sprintf('%o', fileperms($path)), -3); |
---|
484 | return $mode; |
---|
485 | } |
---|
486 | |
---|
487 | // STEP1²èÌ̤Îɽ¼¨ |
---|
488 | function lfDispStep1($objPage) { |
---|
489 | global $objDBParam; |
---|
490 | // hidden¤ËÆþÎÏÃͤòÊÝ»ý |
---|
491 | $objPage->arrHidden = $objDBParam->getHashArray(); |
---|
492 | $objPage->arrHidden['db_skip'] = $_POST['db_skip']; |
---|
493 | $objPage->arrHidden['agreement'] = $_POST['agreement']; |
---|
494 | $objPage->tpl_mainpage = 'step1.tpl'; |
---|
495 | $objPage->tpl_mode = 'step1'; |
---|
496 | return $objPage; |
---|
497 | } |
---|
498 | |
---|
499 | // STEP2²èÌ̤Îɽ¼¨ |
---|
500 | function lfDispStep2($objPage) { |
---|
501 | global $objWebParam; |
---|
502 | global $objDBParam; |
---|
503 | // hidden¤ËÆþÎÏÃͤòÊÝ»ý |
---|
504 | $objPage->arrHidden = $objWebParam->getHashArray(); |
---|
505 | $objPage->arrHidden['db_skip'] = $_POST['db_skip']; |
---|
506 | $objPage->arrHidden['agreement'] = $_POST['agreement']; |
---|
507 | $objPage->tpl_mainpage = 'step2.tpl'; |
---|
508 | $objPage->tpl_mode = 'step2'; |
---|
509 | return $objPage; |
---|
510 | } |
---|
511 | |
---|
512 | // STEP3²èÌ̤Îɽ¼¨ |
---|
513 | function lfDispStep3($objPage) { |
---|
514 | global $objWebParam; |
---|
515 | global $objDBParam; |
---|
516 | // hidden¤ËÆþÎÏÃͤòÊÝ»ý |
---|
517 | $objPage->arrHidden = $objWebParam->getHashArray(); |
---|
518 | // hidden¤ËÆþÎÏÃͤòÊÝ»ý |
---|
519 | $objPage->arrHidden = array_merge($objPage->arrHidden, $objDBParam->getHashArray()); |
---|
520 | $objPage->arrHidden['agreement'] = $_POST['agreement']; |
---|
521 | $objPage->tpl_db_skip = $_POST['db_skip']; |
---|
522 | $objPage->tpl_mainpage = 'step3.tpl'; |
---|
523 | $objPage->tpl_mode = 'step3'; |
---|
524 | return $objPage; |
---|
525 | } |
---|
526 | |
---|
527 | // STEP4²èÌ̤Îɽ¼¨ |
---|
528 | function lfDispStep4($objPage) { |
---|
529 | global $objWebParam; |
---|
530 | global $objDBParam; |
---|
531 | // hidden¤ËÆþÎÏÃͤòÊÝ»ý |
---|
532 | $objPage->arrHidden = $objWebParam->getHashArray(); |
---|
533 | $objPage->arrHidden = array_merge($objPage->arrHidden, $objDBParam->getHashArray()); |
---|
534 | // hidden¤ËÆþÎÏÃͤòÊÝ»ý |
---|
535 | $objPage->arrHidden['agreement'] = $_POST['agreement']; |
---|
536 | |
---|
537 | $normal_url = $objWebParam->getValue('normal_url'); |
---|
538 | // ¸ìÈø¤Ë'/'¤ò¤Ä¤±¤ë |
---|
539 | if (!ereg("/$", $normal_url)) $normal_url = $normal_url . "/"; |
---|
540 | |
---|
541 | $arrDbParam = $objDBParam->getHashArray(); |
---|
542 | $dsn = $arrDbParam['db_type']."://".$arrDbParam['db_user'].":".$arrDbParam['db_password']."@".$arrDbParam['db_server'].":".$arrDbParam['db_port']."/".$arrDbParam['db_name']; |
---|
543 | |
---|
544 | $objPage->tpl_site_url = $normal_url; |
---|
545 | $objPage->tpl_shop_name = $objWebParam->getValue('shop_name'); |
---|
546 | $objPage->tpl_cube_ver = ECCUBE_VERSION; |
---|
547 | $objPage->tpl_php_ver = phpversion(); |
---|
548 | $objPage->tpl_db_ver = sfGetDBVersion($dsn); |
---|
549 | $objPage->tpl_db_skip = $_POST['db_skip']; |
---|
550 | $objPage->tpl_mainpage = 'step4.tpl'; |
---|
551 | $objPage->tpl_mode = 'complete'; |
---|
552 | return $objPage; |
---|
553 | } |
---|
554 | |
---|
555 | // ´°Î»²èÌ̤Îɽ¼¨ |
---|
556 | function lfDispComplete($objPage) { |
---|
557 | global $objWebParam; |
---|
558 | global $objDBParam; |
---|
559 | // hidden¤ËÆþÎÏÃͤòÊÝ»ý |
---|
560 | $objPage->arrHidden = $objWebParam->getHashArray(); |
---|
561 | // hidden¤ËÆþÎÏÃͤòÊÝ»ý |
---|
562 | $objPage->arrHidden = array_merge($objPage->arrHidden, $objDBParam->getHashArray()); |
---|
563 | $objPage->arrHidden['db_skip'] = $_POST['db_skip']; |
---|
564 | $objPage->tpl_mainpage = 'complete.tpl'; |
---|
565 | $objPage->tpl_mode = 'complete'; |
---|
566 | |
---|
567 | $secure_url = $objWebParam->getValue('secure_url'); |
---|
568 | // ¸ìÈø¤Ë'/'¤ò¤Ä¤±¤ë |
---|
569 | if (!ereg("/$", $secure_url)) { |
---|
570 | $secure_url = $secure_url . "/"; |
---|
571 | } |
---|
572 | $objPage->tpl_sslurl = $secure_url; |
---|
573 | return $objPage; |
---|
574 | } |
---|
575 | |
---|
576 | // WEB¥Ñ¥é¥á¡¼¥¿¾ðÊó¤Î½é´ü²½ |
---|
577 | function lfInitWebParam($objWebParam) { |
---|
578 | |
---|
579 | if(defined('HTML_PATH')) { |
---|
580 | $install_dir = HTML_PATH; |
---|
581 | } else { |
---|
582 | $install_dir = realpath(dirname( __FILE__) . "/../") . "/"; |
---|
583 | } |
---|
584 | |
---|
585 | if(defined('SITE_URL')) { |
---|
586 | $normal_url = SITE_URL; |
---|
587 | } else { |
---|
588 | $dir = ereg_replace("install/.*$", "", $_SERVER['REQUEST_URI']); |
---|
589 | $normal_url = "http://" . $_SERVER['HTTP_HOST'] . $dir; |
---|
590 | } |
---|
591 | |
---|
592 | if(defined('SSL_URL')) { |
---|
593 | $secure_url = SSL_URL; |
---|
594 | } else { |
---|
595 | $dir = ereg_replace("install/.*$", "", $_SERVER['REQUEST_URI']); |
---|
596 | $secure_url = "http://" . $_SERVER['HTTP_HOST'] . $dir; |
---|
597 | } |
---|
598 | |
---|
599 | // Ź̾¡¢´ÉÍý¼Ô¥á¡¼¥ë¥¢¥É¥ì¥¹¤ò¼èÆÀ¤¹¤ë¡£(ºÆ¥¤¥ó¥¹¥È¡¼¥ë»þ) |
---|
600 | if(defined('DEFAULT_DSN')) { |
---|
601 | $ret = sfTabaleExists("dtb_baseinfo", DEFAULT_DSN); |
---|
602 | if($ret) { |
---|
603 | $objQuery = new SC_Query(); |
---|
604 | $arrRet = $objQuery->select("shop_name, email01", "dtb_baseinfo"); |
---|
605 | $shop_name = $arrRet[0]['shop_name']; |
---|
606 | $admin_mail = $arrRet[0]['email01']; |
---|
607 | } |
---|
608 | } |
---|
609 | |
---|
610 | $objWebParam->addParam("Ź̾", "shop_name", MTEXT_LEN, "", array("EXIST_CHECK","MAX_LENGTH_CHECK"), $shop_name); |
---|
611 | $objWebParam->addParam("´ÉÍý¼Ô¡§¥á¡¼¥ë¥¢¥É¥ì¥¹", "admin_mail", MTEXT_LEN, "", array("EXIST_CHECK","EMAIL_CHECK","EMAIL_CHAR_CHECK","MAX_LENGTH_CHECK"), $admin_mail); |
---|
612 | $objWebParam->addParam("´ÉÍý¼Ô¡§¥í¥°¥¤¥óID", "login_id", MTEXT_LEN, "", array("EXIST_CHECK","EXIST_CHECK", "ALNUM_CHECK")); |
---|
613 | $objWebParam->addParam("´ÉÍý¼Ô¡§¥Ñ¥¹¥ï¡¼¥É", "login_pass", MTEXT_LEN, "", array("EXIST_CHECK","EXIST_CHECK", "ALNUM_CHECK")); |
---|
614 | $objWebParam->addParam("¥¤¥ó¥¹¥È¡¼¥ë¥Ç¥£¥ì¥¯¥È¥ê", "install_dir", MTEXT_LEN, "", array("EXIST_CHECK","MAX_LENGTH_CHECK"), $install_dir); |
---|
615 | $objWebParam->addParam("URL(Ä̾ï)", "normal_url", MTEXT_LEN, "", array("EXIST_CHECK","URL_CHECK","MAX_LENGTH_CHECK"), $normal_url); |
---|
616 | $objWebParam->addParam("URL(¥»¥¥å¥¢)", "secure_url", MTEXT_LEN, "", array("EXIST_CHECK","URL_CHECK","MAX_LENGTH_CHECK"), $secure_url); |
---|
617 | $objWebParam->addParam("¥É¥á¥¤¥ó", "domain", MTEXT_LEN, "", array("MAX_LENGTH_CHECK")); |
---|
618 | |
---|
619 | return $objWebParam; |
---|
620 | } |
---|
621 | |
---|
622 | // DB¥Ñ¥é¥á¡¼¥¿¾ðÊó¤Î½é´ü²½ |
---|
623 | function lfInitDBParam($objDBParam) { |
---|
624 | |
---|
625 | if(defined('DB_SERVER')) { |
---|
626 | $db_server = DB_SERVER; |
---|
627 | } else { |
---|
628 | $db_server = "127.0.0.1"; |
---|
629 | } |
---|
630 | |
---|
631 | if(defined('DB_TYPE')) { |
---|
632 | $db_type = DB_TYPE; |
---|
633 | } else { |
---|
634 | $db_type = ""; |
---|
635 | } |
---|
636 | |
---|
637 | if(defined('DB_PORT')) { |
---|
638 | $db_port = DB_PORT; |
---|
639 | } else { |
---|
640 | $db_port = ""; |
---|
641 | } |
---|
642 | |
---|
643 | if(defined('DB_NAME')) { |
---|
644 | $db_name = DB_NAME; |
---|
645 | } else { |
---|
646 | $db_name = "eccube_db"; |
---|
647 | } |
---|
648 | |
---|
649 | if(defined('DB_USER')) { |
---|
650 | $db_user = DB_USER; |
---|
651 | } else { |
---|
652 | $db_user = "eccube_db_user"; |
---|
653 | } |
---|
654 | |
---|
655 | $objDBParam->addParam("DB¤Î¼ïÎà", "db_type", INT_LEN, "", array("EXIST_CHECK","MAX_LENGTH_CHECK"), $db_type); |
---|
656 | $objDBParam->addParam("DB¥µ¡¼¥Ð", "db_server", MTEXT_LEN, "", array("EXIST_CHECK","MAX_LENGTH_CHECK"), $db_server); |
---|
657 | $objDBParam->addParam("DB¥Ý¡¼¥È", "db_port", INT_LEN, "", array("MAX_LENGTH_CHECK"), $db_port); |
---|
658 | $objDBParam->addParam("DB̾", "db_name", MTEXT_LEN, "", array("EXIST_CHECK","MAX_LENGTH_CHECK"), $db_name); |
---|
659 | $objDBParam->addParam("DB¥æ¡¼¥¶", "db_user", MTEXT_LEN, "", array("EXIST_CHECK","MAX_LENGTH_CHECK"), $db_user); |
---|
660 | $objDBParam->addParam("DB¥Ñ¥¹¥ï¡¼¥É", "db_password", MTEXT_LEN, "", array("EXIST_CHECK","MAX_LENGTH_CHECK")); |
---|
661 | |
---|
662 | return $objDBParam; |
---|
663 | } |
---|
664 | |
---|
665 | // ÆþÎÏÆâÍƤΥÁ¥§¥Ã¥¯ |
---|
666 | function lfCheckWebError($objFormParam) { |
---|
667 | // ÆþÎϥǡ¼¥¿¤òÅϤ¹¡£ |
---|
668 | $arrRet = $objFormParam->getHashArray(); |
---|
669 | $objErr = new SC_CheckError($arrRet); |
---|
670 | $objErr->arrErr = $objFormParam->checkError(); |
---|
671 | |
---|
672 | // ¥Ç¥£¥ì¥¯¥È¥ê̾¤Î¤ß¼èÆÀ¤¹¤ë |
---|
673 | $normal_dir = ereg_replace("^https?://[a-zA-Z0-9_~=&\?\.\-]+", "", $arrRet['normal_url']); |
---|
674 | $secure_dir = ereg_replace("^https?://[a-zA-Z0-9_~=&\?\.\-]+", "", $arrRet['secure_url']); |
---|
675 | |
---|
676 | if($normal_dir != $secure_dir) { |
---|
677 | $objErr->arrErr['normal_url'] = "URL¤Ë°Û¤Ê¤ë³¬Áؤò»ØÄꤹ¤ë¤³¤È¤Ï¤Ç¤¤Þ¤»¤ó¡£"; |
---|
678 | $objErr->arrErr['secure_url'] = "URL¤Ë°Û¤Ê¤ë³¬Áؤò»ØÄꤹ¤ë¤³¤È¤Ï¤Ç¤¤Þ¤»¤ó¡£"; |
---|
679 | } |
---|
680 | |
---|
681 | // ¥í¥°¥¤¥óID¥Á¥§¥Ã¥¯ |
---|
682 | $objErr->doFunc(array("´ÉÍý¼Ô¡§¥í¥°¥¤¥óID",'login_id',ID_MIN_LEN , ID_MAX_LEN) ,array("NUM_RANGE_CHECK")); |
---|
683 | |
---|
684 | // ¥Ñ¥¹¥ï¡¼¥É¤Î¥Á¥§¥Ã¥¯ |
---|
685 | $objErr->doFunc( array("´ÉÍý¼Ô¡§¥Ñ¥¹¥ï¡¼¥É",'login_pass',4 ,15 ) ,array( "NUM_RANGE_CHECK" ) ); |
---|
686 | |
---|
687 | return $objErr->arrErr; |
---|
688 | } |
---|
689 | |
---|
690 | // ÆþÎÏÆâÍƤΥÁ¥§¥Ã¥¯ |
---|
691 | function lfCheckDBError($objFormParam) { |
---|
692 | global $objPage; |
---|
693 | |
---|
694 | // ÆþÎϥǡ¼¥¿¤òÅϤ¹¡£ |
---|
695 | $arrRet = $objFormParam->getHashArray(); |
---|
696 | |
---|
697 | $objErr = new SC_CheckError($arrRet); |
---|
698 | $objErr->arrErr = $objFormParam->checkError(); |
---|
699 | |
---|
700 | if(count($objErr->arrErr) == 0) { |
---|
701 | // Àܳ³Îǧ |
---|
702 | $dsn = $arrRet['db_type']."://".$arrRet['db_user'].":".$arrRet['db_password']."@".$arrRet['db_server'].":".$arrRet['db_port']."/".$arrRet['db_name']; |
---|
703 | // Debug¥â¡¼¥É»ØÄê |
---|
704 | $options['debug'] = PEAR_DB_DEBUG; |
---|
705 | $objDB = DB::connect($dsn, $options); |
---|
706 | // ÀܳÀ®¸ù |
---|
707 | if(!PEAR::isError($objDB)) { |
---|
708 | // ¥Ç¡¼¥¿¥Ù¡¼¥¹¥Ð¡¼¥¸¥ç¥ó¾ðÊó¤Î¼èÆÀ |
---|
709 | $objPage->tpl_db_version = sfGetDBVersion($dsn); |
---|
710 | } else { |
---|
711 | $objErr->arrErr['all'] = ">> " . $objDB->message . "<br>"; |
---|
712 | // ¥¨¥é¡¼Ê¸¤ò¼èÆÀ¤¹¤ë |
---|
713 | ereg("\[(.*)\]", $objDB->userinfo, $arrKey); |
---|
714 | $objErr->arrErr['all'].= $arrKey[0] . "<br>"; |
---|
715 | gfPrintLog($objDB->userinfo, INSTALL_LOG); |
---|
716 | } |
---|
717 | } |
---|
718 | return $objErr->arrErr; |
---|
719 | } |
---|
720 | |
---|
721 | // SQLʸ¤Î¼Â¹Ô |
---|
722 | function lfExecuteSQL($filepath, $dsn, $disp_err = true) { |
---|
723 | $arrErr = array(); |
---|
724 | |
---|
725 | if(!file_exists($filepath)) { |
---|
726 | $arrErr['all'] = ">> ¥¹¥¯¥ê¥×¥È¥Õ¥¡¥¤¥ë¤¬¸«¤Ä¤«¤ê¤Þ¤»¤ó"; |
---|
727 | } else { |
---|
728 | if($fp = fopen($filepath,"r")) { |
---|
729 | $sql = fread($fp, filesize($filepath)); |
---|
730 | fclose($fp); |
---|
731 | } |
---|
732 | // Debug¥â¡¼¥É»ØÄê |
---|
733 | $options['debug'] = PEAR_DB_DEBUG; |
---|
734 | $objDB = DB::connect($dsn, $options); |
---|
735 | // Àܳ¥¨¥é¡¼ |
---|
736 | if(!PEAR::isError($objDB)) { |
---|
737 | // ²þ¹Ô¡¢¥¿¥Ö¤ò1¥¹¥Ú¡¼¥¹¤ËÊÑ´¹ |
---|
738 | $sql = preg_replace("/[\r\n\t]/"," ",$sql); |
---|
739 | $sql_split = split(";",$sql); |
---|
740 | foreach($sql_split as $key => $val){ |
---|
741 | if (trim($val) != "") { |
---|
742 | $ret = $objDB->query($val); |
---|
743 | if(PEAR::isError($ret) && $disp_err) { |
---|
744 | $arrErr['all'] = ">> " . $ret->message . "<br>"; |
---|
745 | // ¥¨¥é¡¼Ê¸¤ò¼èÆÀ¤¹¤ë |
---|
746 | ereg("\[(.*)\]", $ret->userinfo, $arrKey); |
---|
747 | $arrErr['all'].= $arrKey[0] . "<br>"; |
---|
748 | $objPage->update_mess.=">> ¥Æ¡¼¥Ö¥ë¹½À®¤ÎÊѹ¹¤Ë¼ºÇÔ¤·¤Þ¤·¤¿¡£<br>"; |
---|
749 | gfPrintLog($ret->userinfo, INSTALL_LOG); |
---|
750 | } |
---|
751 | } |
---|
752 | } |
---|
753 | } else { |
---|
754 | $arrErr['all'] = ">> " . $objDB->message; |
---|
755 | gfPrintLog($objDB->userinfo, INSTALL_LOG); |
---|
756 | } |
---|
757 | } |
---|
758 | return $arrErr; |
---|
759 | } |
---|
760 | |
---|
761 | // ÀßÄê¥Õ¥¡¥¤¥ë¤ÎºîÀ® |
---|
762 | function lfMakeConfigFile() { |
---|
763 | global $objWebParam; |
---|
764 | global $objDBParam; |
---|
765 | |
---|
766 | $root_dir = $objWebParam->getValue('install_dir'); |
---|
767 | // ¸ìÈø¤Ë'/'¤ò¤Ä¤±¤ë |
---|
768 | if (!ereg("/$", $root_dir)) { |
---|
769 | $root_dir = $root_dir . "/"; |
---|
770 | } |
---|
771 | |
---|
772 | $normal_url = $objWebParam->getValue('normal_url'); |
---|
773 | // ¸ìÈø¤Ë'/'¤ò¤Ä¤±¤ë |
---|
774 | if (!ereg("/$", $normal_url)) { |
---|
775 | $normal_url = $normal_url . "/"; |
---|
776 | } |
---|
777 | |
---|
778 | $secure_url = $objWebParam->getValue('secure_url'); |
---|
779 | // ¸ìÈø¤Ë'/'¤ò¤Ä¤±¤ë |
---|
780 | if (!ereg("/$", $secure_url)) { |
---|
781 | $secure_url = $secure_url . "/"; |
---|
782 | } |
---|
783 | |
---|
784 | // ¥Ç¥£¥ì¥¯¥È¥ê¤Î¼èÆÀ |
---|
785 | $url_dir = ereg_replace("^https?://[a-zA-Z0-9_~=&\?\.\-]+", "", $normal_url); |
---|
786 | |
---|
787 | $data_path = $root_dir . "../data/"; |
---|
788 | $filepath = $data_path . "install.inc"; |
---|
789 | |
---|
790 | $config_data = |
---|
791 | "<?php\n". |
---|
792 | " define ('ECCUBE_INSTALL', 'ON');\n" . |
---|
793 | " define ('HTML_PATH', '" . $root_dir . "');\n" . |
---|
794 | " define ('SITE_URL', '" . $normal_url . "');\n" . |
---|
795 | " define ('SSL_URL', '" . $secure_url . "');\n" . |
---|
796 | " define ('URL_DIR', '" . $url_dir . "');\n" . |
---|
797 | " define ('DOMAIN_NAME', '" . $objWebParam->getValue('domain') . "');\n" . |
---|
798 | " define ('DB_TYPE', '" . $objDBParam->getValue('db_type') . "');\n" . |
---|
799 | " define ('DB_USER', '" . $objDBParam->getValue('db_user') . "');\n" . |
---|
800 | " define ('DB_PASSWORD', '" . $objDBParam->getValue('db_password') . "');\n" . |
---|
801 | " define ('DB_SERVER', '" . $objDBParam->getValue('db_server') . "');\n" . |
---|
802 | " define ('DB_NAME', '" . $objDBParam->getValue('db_name') . "');\n" . |
---|
803 | " define ('DB_PORT', '" . $objDBParam->getValue('db_port') . "');\n" . |
---|
804 | " define ('DATA_PATH', '".$data_path."');\n" . |
---|
805 | " define ('MOBILE_HTML_PATH', HTML_PATH . 'mobile/');\n" . |
---|
806 | " define ('MOBILE_SITE_URL', SITE_URL . 'mobile/');\n" . |
---|
807 | " define ('MOBILE_SSL_URL', SSL_URL . 'mobile/');\n" . |
---|
808 | " define ('MOBILE_URL_DIR', URL_DIR . 'mobile/'); \n" . |
---|
809 | "?>"; |
---|
810 | |
---|
811 | if($fp = fopen($filepath,"w")) { |
---|
812 | fwrite($fp, $config_data); |
---|
813 | fclose($fp); |
---|
814 | } |
---|
815 | /* install_mobile.inc¤Ï»ÈÍѤ·¤Ê¤¤ÍѤËÊѹ¹ |
---|
816 | |
---|
817 | // ¥â¥Ð¥¤¥ëÈǤÎÀßÄê¥Õ¥¡¥¤¥ë install_mobile.inc ¤òºîÀ®¤¹¤ë¡£ |
---|
818 | $filepath = $data_path . "install_mobile.inc"; |
---|
819 | |
---|
820 | $config_data = |
---|
821 | "<?php\n". |
---|
822 | " define ('ECCUBE_INSTALL', 'ON');\n" . |
---|
823 | " define ('HTML_PATH', '" . $root_dir . "mobile/');\n" . |
---|
824 | " define ('PC_HTML_PATH', '" . $root_dir . "');\n" . |
---|
825 | " define ('SITE_URL', '" . $normal_url . "mobile/');\n" . |
---|
826 | " define ('PC_SITE_URL', '" . $normal_url . "');\n" . |
---|
827 | " define ('SSL_URL', '" . $secure_url . "mobile/');\n" . |
---|
828 | " define ('PC_SSL_URL', '" . $secure_url . "');\n" . |
---|
829 | " define ('URL_DIR', '" . $url_dir . "mobile/');\n" . |
---|
830 | " define ('PC_URL_DIR', '" . $url_dir . "');\n" . |
---|
831 | " define ('DOMAIN_NAME', '" . $objWebParam->getValue('domain') . "');\n" . |
---|
832 | " define ('DB_TYPE', '" . $objDBParam->getValue('db_type') . "');\n" . |
---|
833 | " define ('DB_USER', '" . $objDBParam->getValue('db_user') . "');\n" . |
---|
834 | " define ('DB_PASSWORD', '" . $objDBParam->getValue('db_password') . "');\n" . |
---|
835 | " define ('DB_SERVER', '" . $objDBParam->getValue('db_server') . "');\n" . |
---|
836 | " define ('DB_NAME', '" . $objDBParam->getValue('db_name') . "');\n" . |
---|
837 | " define ('DB_PORT', '" . $objDBParam->getValue('db_port') . "');\n" . |
---|
838 | " define ('DATA_PATH', '".$data_path."');\n" . |
---|
839 | "?>"; |
---|
840 | |
---|
841 | if($fp = fopen($filepath,"w")) { |
---|
842 | fwrite($fp, $config_data); |
---|
843 | fclose($fp); |
---|
844 | } |
---|
845 | */ |
---|
846 | } |
---|
847 | |
---|
848 | // ¥Æ¡¼¥Ö¥ë¤ÎÄɲáʴû¤Ë¥Æ¡¼¥Ö¥ë¤¬Â¸ºß¤¹¤ë¾ì¹ç¤ÏºîÀ®¤·¤Ê¤¤¡Ë |
---|
849 | function lfAddTable($table_name, $dsn) { |
---|
850 | $arrErr = array(); |
---|
851 | if(!sfTabaleExists($table_name, $dsn)) { |
---|
852 | list($db_type) = split(":", $dsn); |
---|
853 | $sql_path = "./sql/add/". $table_name . "_" .$db_type .".sql"; |
---|
854 | $arrErr = lfExecuteSQL($sql_path, $dsn); |
---|
855 | } |
---|
856 | return $arrErr; |
---|
857 | } |
---|
858 | |
---|
859 | // ¥Æ¡¼¥Ö¥ë¤Îºï½ü¡Ê´û¤Ë¥Æ¡¼¥Ö¥ë¤¬Â¸ºß¤¹¤ë¾ì¹ç¤Î¤ßºï½ü¤¹¤ë¡Ë |
---|
860 | function lfDropTable($table_name, $dsn) { |
---|
861 | $arrErr = array(); |
---|
862 | if(sfTabaleExists($table_name, $dsn)) { |
---|
863 | // Debug¥â¡¼¥É»ØÄê |
---|
864 | $options['debug'] = PEAR_DB_DEBUG; |
---|
865 | $objDB = DB::connect($dsn, $options); |
---|
866 | // ÀܳÀ®¸ù |
---|
867 | if(!PEAR::isError($objDB)) { |
---|
868 | $objDB->query("DROP TABLE " . $table_name); |
---|
869 | } else { |
---|
870 | $arrErr['all'] = ">> " . $objDB->message . "<br>"; |
---|
871 | // ¥¨¥é¡¼Ê¸¤ò¼èÆÀ¤¹¤ë |
---|
872 | ereg("\[(.*)\]", $objDB->userinfo, $arrKey); |
---|
873 | $arrErr['all'].= $arrKey[0] . "<br>"; |
---|
874 | gfPrintLog($objDB->userinfo, INSTALL_LOG); |
---|
875 | } |
---|
876 | } |
---|
877 | return $arrErr; |
---|
878 | } |
---|
879 | |
---|
880 | // ¥«¥é¥à¤ÎÄɲáʴû¤Ë¥«¥é¥à¤¬Â¸ºß¤¹¤ë¾ì¹ç¤ÏºîÀ®¤·¤Ê¤¤¡Ë |
---|
881 | function lfAddColumn($dsn) { |
---|
882 | global $objDBParam; |
---|
883 | |
---|
884 | // ¼õÃí¥Æ¡¼¥Ö¥ë |
---|
885 | sfColumnExists("dtb_order", "memo01", "text", $dsn, true); |
---|
886 | sfColumnExists("dtb_order", "memo02", "text", $dsn, true); |
---|
887 | sfColumnExists("dtb_order", "memo03", "text", $dsn, true); |
---|
888 | sfColumnExists("dtb_order", "memo04", "text", $dsn, true); |
---|
889 | sfColumnExists("dtb_order", "memo05", "text", $dsn, true); |
---|
890 | sfColumnExists("dtb_order", "memo06", "text", $dsn, true); |
---|
891 | sfColumnExists("dtb_order", "memo07", "text", $dsn, true); |
---|
892 | sfColumnExists("dtb_order", "memo08", "text", $dsn, true); |
---|
893 | sfColumnExists("dtb_order", "memo09", "text", $dsn, true); |
---|
894 | sfColumnExists("dtb_order", "memo10", "text", $dsn, true); |
---|
895 | sfColumnExists("dtb_order", "campaign_id", "int4", $dsn, true); |
---|
896 | |
---|
897 | // ¼õÃí°ì»þ¥Æ¡¼¥Ö¥ë |
---|
898 | sfColumnExists("dtb_order_temp", "order_id", "text", $dsn, true); |
---|
899 | sfColumnExists("dtb_order_temp", "memo01", "text", $dsn, true); |
---|
900 | sfColumnExists("dtb_order_temp", "memo02", "text", $dsn, true); |
---|
901 | sfColumnExists("dtb_order_temp", "memo03", "text", $dsn, true); |
---|
902 | sfColumnExists("dtb_order_temp", "memo04", "text", $dsn, true); |
---|
903 | sfColumnExists("dtb_order_temp", "memo05", "text", $dsn, true); |
---|
904 | sfColumnExists("dtb_order_temp", "memo06", "text", $dsn, true); |
---|
905 | sfColumnExists("dtb_order_temp", "memo07", "text", $dsn, true); |
---|
906 | sfColumnExists("dtb_order_temp", "memo08", "text", $dsn, true); |
---|
907 | sfColumnExists("dtb_order_temp", "memo09", "text", $dsn, true); |
---|
908 | sfColumnExists("dtb_order_temp", "memo10", "text", $dsn, true); |
---|
909 | |
---|
910 | // »Ùʧ¾ðÊó¥Æ¡¼¥Ö¥ë |
---|
911 | sfColumnExists("dtb_payment", "charge_flg", "int2 default 1", $dsn, true); |
---|
912 | sfColumnExists("dtb_payment", "rule_min", "numeric", $dsn, true); |
---|
913 | sfColumnExists("dtb_payment", "upper_rule_max", "numeric", $dsn, true); |
---|
914 | sfColumnExists("dtb_payment", "module_id", "int4", $dsn, true); |
---|
915 | sfColumnExists("dtb_payment", "module_path", "text", $dsn, true); |
---|
916 | sfColumnExists("dtb_payment", "memo01", "text", $dsn, true); |
---|
917 | sfColumnExists("dtb_payment", "memo02", "text", $dsn, true); |
---|
918 | sfColumnExists("dtb_payment", "memo03", "text", $dsn, true); |
---|
919 | sfColumnExists("dtb_payment", "memo04", "text", $dsn, true); |
---|
920 | sfColumnExists("dtb_payment", "memo05", "text", $dsn, true); |
---|
921 | sfColumnExists("dtb_payment", "memo06", "text", $dsn, true); |
---|
922 | sfColumnExists("dtb_payment", "memo07", "text", $dsn, true); |
---|
923 | sfColumnExists("dtb_payment", "memo08", "text", $dsn, true); |
---|
924 | sfColumnExists("dtb_payment", "memo09", "text", $dsn, true); |
---|
925 | sfColumnExists("dtb_payment", "memo10", "text", $dsn, true); |
---|
926 | |
---|
927 | // ¥¥ã¥ó¥Ú¡¼¥ó¥Æ¡¼¥Ö¥ë |
---|
928 | sfColumnExists("dtb_campaign", "directory_name", "text NOT NULL", $dsn, true); |
---|
929 | sfColumnExists("dtb_campaign", "limit_count", "int4 NOT NULL DEFAULT 0", $dsn, true); |
---|
930 | sfColumnExists("dtb_campaign", "total_count", "int4 NOT NULL DEFAULT 0", $dsn, true); |
---|
931 | sfColumnExists("dtb_campaign", "orverlapping_flg", "int2 NOT NULL DEFAULT 0", $dsn, true); |
---|
932 | sfColumnExists("dtb_campaign", "cart_flg", "int2 NOT NULL DEFAULT 0", $dsn, true); |
---|
933 | sfColumnExists("dtb_campaign", "deliv_free_flg", "int2 NOT NULL DEFAULT 0", $dsn, true); |
---|
934 | |
---|
935 | // ¸ÜµÒ |
---|
936 | sfColumnExists("dtb_customer", "mailmaga_flg", "int2", $dsn, true); |
---|
937 | if (!sfColumnExists("dtb_customer", "mobile_phone_id", "text", $dsn, true)) { |
---|
938 | // ¥¤¥ó¥Ç¥Ã¥¯¥¹¤ÎÄɲà |
---|
939 | sfIndexExists("dtb_customer", "mobile_phone_id", "dtb_customer_mobile_phone_id_key", 64, $dsn, true); |
---|
940 | } |
---|
941 | |
---|
942 | // ¸ÜµÒ¥á¡¼¥ë |
---|
943 | if ($objDBParam->getValue('db_type') == 'mysql') { |
---|
944 | sfColumnExists("dtb_customer_mail", "secret_key", "varchar(50) unique", $dsn, true); |
---|
945 | } else { |
---|
946 | sfColumnExists("dtb_customer_mail", "secret_key", "text unique", $dsn, true); |
---|
947 | } |
---|
948 | } |
---|
949 | |
---|
950 | // ¥Ç¡¼¥¿¤ÎÄɲáʴû¤Ë¥Ç¡¼¥¿¤¬Â¸ºß¤¹¤ë¾ì¹ç¤ÏºîÀ®¤·¤Ê¤¤¡Ë |
---|
951 | function lfAddData($dsn) { |
---|
952 | // CSV¥Æ¡¼¥Ö¥ë |
---|
953 | if(sfTabaleExists('dtb_csv', $dsn)) { |
---|
954 | lfInsertCSVData(1,'category_id','¥«¥Æ¥´¥êID',53,'now()','now()'); |
---|
955 | lfInsertCSVData(4,'order_id','ÃíʸID',1,'now()','now()'); |
---|
956 | lfInsertCSVData(4,'campaign_id','¥¥ã¥ó¥Ú¡¼¥óID',2,'now()','now()'); |
---|
957 | lfInsertCSVData(4,'customer_id','¸ÜµÒID',3,'now()','now()'); |
---|
958 | lfInsertCSVData(4,'message','Í×˾Åù',4,'now()','now()'); |
---|
959 | lfInsertCSVData(4,'order_name01','¸ÜµÒ̾1',5,'now()','now()'); |
---|
960 | lfInsertCSVData(4,'order_name02','¸ÜµÒ̾2',6,'now()','now()'); |
---|
961 | lfInsertCSVData(4,'order_kana01','¸ÜµÒ̾¥«¥Ê1',7,'now()','now()'); |
---|
962 | lfInsertCSVData(4,'order_kana02','¸ÜµÒ̾¥«¥Ê2',8,'now()','now()'); |
---|
963 | lfInsertCSVData(4,'order_email','¥á¡¼¥ë¥¢¥É¥ì¥¹',9,'now()','now()'); |
---|
964 | lfInsertCSVData(4,'order_tel01','ÅÅÏÃÈÖ¹æ1',10,'now()','now()'); |
---|
965 | lfInsertCSVData(4,'order_tel02','ÅÅÏÃÈÖ¹æ2',11,'now()','now()'); |
---|
966 | lfInsertCSVData(4,'order_tel03','ÅÅÏÃÈÖ¹æ3',12,'now()','now()'); |
---|
967 | lfInsertCSVData(4,'order_fax01','FAX1',13,'now()','now()'); |
---|
968 | lfInsertCSVData(4,'order_fax02','FAX2',14,'now()','now()'); |
---|
969 | lfInsertCSVData(4,'order_fax03','FAX3',15,'now()','now()'); |
---|
970 | lfInsertCSVData(4,'order_zip01','͹ÊØÈÖ¹æ1',16,'now()','now()'); |
---|
971 | lfInsertCSVData(4,'order_zip02','͹ÊØÈÖ¹æ2',17,'now()','now()'); |
---|
972 | lfInsertCSVData(4,'order_pref','ÅÔÆ»Éܸ©',18,'now()','now()'); |
---|
973 | lfInsertCSVData(4,'order_addr01','½»½ê1',19,'now()','now()'); |
---|
974 | lfInsertCSVData(4,'order_addr02','½»½ê2',20,'now()','now()'); |
---|
975 | lfInsertCSVData(4,'order_sex','ÀÊÌ',21,'now()','now()'); |
---|
976 | lfInsertCSVData(4,'order_birth','À¸Ç¯·îÆü',22,'now()','now()'); |
---|
977 | lfInsertCSVData(4,'order_job','¿¦¼ï',23,'now()','now()'); |
---|
978 | lfInsertCSVData(4,'deliv_name01','ÇÛÁ÷Àè̾Á°',24,'now()','now()'); |
---|
979 | lfInsertCSVData(4,'deliv_name02','ÇÛÁ÷Àè̾Á°',25,'now()','now()'); |
---|
980 | lfInsertCSVData(4,'deliv_kana01','ÇÛÁ÷À襫¥Ê',26,'now()','now()'); |
---|
981 | lfInsertCSVData(4,'deliv_kana02','ÇÛÁ÷À襫¥Ê',27,'now()','now()'); |
---|
982 | lfInsertCSVData(4,'deliv_tel01','ÅÅÏÃÈÖ¹æ1',28,'now()','now()'); |
---|
983 | lfInsertCSVData(4,'deliv_tel02','ÅÅÏÃÈÖ¹æ2',29,'now()','now()'); |
---|
984 | lfInsertCSVData(4,'deliv_tel03','ÅÅÏÃÈÖ¹æ3',30,'now()','now()'); |
---|
985 | lfInsertCSVData(4,'deliv_fax01','FAX1',31,'now()','now()'); |
---|
986 | lfInsertCSVData(4,'deliv_fax02','FAX2',32,'now()','now()'); |
---|
987 | lfInsertCSVData(4,'deliv_fax03','FAX3',33,'now()','now()'); |
---|
988 | lfInsertCSVData(4,'deliv_zip01','͹ÊØÈÖ¹æ1',34,'now()','now()'); |
---|
989 | lfInsertCSVData(4,'deliv_zip02','͹ÊØÈÖ¹æ2',35,'now()','now()'); |
---|
990 | lfInsertCSVData(4,'deliv_pref','ÅÔÆ»Éܸ©',36,'now()','now()'); |
---|
991 | lfInsertCSVData(4,'deliv_addr01','½»½ê1',37,'now()','now()'); |
---|
992 | lfInsertCSVData(4,'deliv_addr02','½»½ê2',38,'now()','now()'); |
---|
993 | lfInsertCSVData(4,'payment_total','¤ª»Ùʧ¤¤¹ç·×',39,'now()','now()'); |
---|
994 | } |
---|
995 | } |
---|
996 | |
---|
997 | // CSV¥Æ¡¼¥Ö¥ë¤Ø¤Î¥Ç¡¼¥¿¤ÎÄɲà |
---|
998 | function lfInsertCSVData($csv_id,$col,$disp_name,$rank,$create_date,$update_date) { |
---|
999 | $sql = "insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date) values($csv_id,'$col','$disp_name',$rank,$create_date,$update_date);"; |
---|
1000 | sfDataExists("dtb_csv", "csv_id = ? AND col = ?", array($csv_id, $col), $dsn = "", $sql, true); |
---|
1001 | } |
---|
1002 | ?> |
---|