/install/controller/install/step_3.php

https://gitlab.com/shapcy/opencart · PHP · 303 lines · 243 code · 60 blank · 0 comment · 58 complexity · e21c3886fb53c0a04e2d2aca1943df26 MD5 · raw file 

    

  1. <?php
    2. 

  2. class ControllerInstallStep3 extends Controller {
    3. 

  3. 	private $error = array();
    4. 

  4. 

  5. 	public function index() {
    6. 

  6. 		$this->language->load('install/step_3');
    7. 

  7. 		
    8. 

  8. 		if (($this->request->server['REQUEST_METHOD'] == 'POST') && $this->validate()) {
    9. 

  9. 			$this->load->model('install/install');
    10. 

  10. 

  11. 			$this->model_install_install->database($this->request->post);
    12. 

  12. 

  13. 			$output  = '<?php' . "\n";
    14. 

  14. 			$output .= '// HTTP' . "\n";
    15. 

  15. 			$output .= 'define(\'HTTP_SERVER\', \'' . HTTP_OPENCART . '\');' . "\n\n";
    16. 

  16. 

  17. 			$output .= '// HTTPS' . "\n";
    18. 

  18. 			$output .= 'define(\'HTTPS_SERVER\', \'' . HTTP_OPENCART . '\');' . "\n\n";
    19. 

  19. 

  20. 			$output .= '// DIR' . "\n";
    21. 

  21. 			$output .= 'define(\'DIR_APPLICATION\', \'' . DIR_OPENCART . 'catalog/\');' . "\n";
    22. 

  22. 			$output .= 'define(\'DIR_SYSTEM\', \'' . DIR_OPENCART . 'system/\');' . "\n";
    23. 

  23. 			$output .= 'define(\'DIR_IMAGE\', \'' . DIR_OPENCART . 'image/\');' . "\n";			
    24. 

  24. 			$output .= 'define(\'DIR_LANGUAGE\', \'' . DIR_OPENCART . 'catalog/language/\');' . "\n";
    25. 

  25. 			$output .= 'define(\'DIR_TEMPLATE\', \'' . DIR_OPENCART . 'catalog/view/theme/\');' . "\n";
    26. 

  26. 			$output .= 'define(\'DIR_CONFIG\', \'' . DIR_OPENCART . 'system/config/\');' . "\n";
    27. 

  27. 			$output .= 'define(\'DIR_CACHE\', \'' . DIR_OPENCART . 'system/storage/cache/\');' . "\n";
    28. 

  28. 			$output .= 'define(\'DIR_DOWNLOAD\', \'' . DIR_OPENCART . 'system/storage/download/\');' . "\n";
    29. 

  29. 			$output .= 'define(\'DIR_LOGS\', \'' . DIR_OPENCART . 'system/storage/logs/\');' . "\n";
    30. 

  30. 			$output .= 'define(\'DIR_MODIFICATION\', \'' . DIR_OPENCART . 'system/storage/modification/\');' . "\n";
    31. 

  31. 			$output .= 'define(\'DIR_UPLOAD\', \'' . DIR_OPENCART . 'system/storage/upload/\');' . "\n\n";
    32. 

  32. 

  33. 			$output .= '// DB' . "\n";
    34. 

  34. 			$output .= 'define(\'DB_DRIVER\', \'' . addslashes($this->request->post['db_driver']) . '\');' . "\n";
    35. 

  35. 			$output .= 'define(\'DB_HOSTNAME\', \'' . addslashes($this->request->post['db_hostname']) . '\');' . "\n";
    36. 

  36. 			$output .= 'define(\'DB_USERNAME\', \'' . addslashes($this->request->post['db_username']) . '\');' . "\n";
    37. 

  37. 			$output .= 'define(\'DB_PASSWORD\', \'' . addslashes(html_entity_decode($this->request->post['db_password'], ENT_QUOTES, 'UTF-8')) . '\');' . "\n";
    38. 

  38. 			$output .= 'define(\'DB_DATABASE\', \'' . addslashes($this->request->post['db_database']) . '\');' . "\n";
    39. 

  39. 			$output .= 'define(\'DB_PORT\', \'' . addslashes($this->request->post['db_port']) . '\');' . "\n";
    40. 

  40. 			$output .= 'define(\'DB_PREFIX\', \'' . addslashes($this->request->post['db_prefix']) . '\');' . "\n";
    41. 

  41. 

  42. 			$file = fopen(DIR_OPENCART . 'config.php', 'w');
    43. 

  43. 

  44. 			fwrite($file, $output);
    45. 

  45. 

  46. 			fclose($file);
    47. 

  47. 

  48. 			$output  = '<?php' . "\n";
    49. 

  49. 			$output .= '// HTTP' . "\n";
    50. 

  50. 			$output .= 'define(\'HTTP_SERVER\', \'' . HTTP_OPENCART . 'admin/\');' . "\n";
    51. 

  51. 			$output .= 'define(\'HTTP_CATALOG\', \'' . HTTP_OPENCART . '\');' . "\n\n";
    52. 

  52. 

  53. 			$output .= '// HTTPS' . "\n";
    54. 

  54. 			$output .= 'define(\'HTTPS_SERVER\', \'' . HTTP_OPENCART . 'admin/\');' . "\n";
    55. 

  55. 			$output .= 'define(\'HTTPS_CATALOG\', \'' . HTTP_OPENCART . '\');' . "\n\n";
    56. 

  56. 

  57. 			$output .= '// DIR' . "\n";
    58. 

  58. 			$output .= 'define(\'DIR_APPLICATION\', \'' . DIR_OPENCART . 'admin/\');' . "\n";
    59. 

  59. 			$output .= 'define(\'DIR_SYSTEM\', \'' . DIR_OPENCART . 'system/\');' . "\n";
    60. 

  60. 			$output .= 'define(\'DIR_IMAGE\', \'' . DIR_OPENCART . 'image/\');' . "\n";			
    61. 

  61. 			$output .= 'define(\'DIR_LANGUAGE\', \'' . DIR_OPENCART . 'admin/language/\');' . "\n";
    62. 

  62. 			$output .= 'define(\'DIR_TEMPLATE\', \'' . DIR_OPENCART . 'admin/view/template/\');' . "\n";
    63. 

  63. 			$output .= 'define(\'DIR_CONFIG\', \'' . DIR_OPENCART . 'system/config/\');' . "\n";
    64. 

  64. 			$output .= 'define(\'DIR_CACHE\', \'' . DIR_OPENCART . 'system/storage/cache/\');' . "\n";
    65. 

  65. 			$output .= 'define(\'DIR_DOWNLOAD\', \'' . DIR_OPENCART . 'system/storage/download/\');' . "\n";
    66. 

  66. 			$output .= 'define(\'DIR_LOGS\', \'' . DIR_OPENCART . 'system/storage/logs/\');' . "\n";
    67. 

  67. 			$output .= 'define(\'DIR_MODIFICATION\', \'' . DIR_OPENCART . 'system/storage/modification/\');' . "\n";
    68. 

  68. 			$output .= 'define(\'DIR_UPLOAD\', \'' . DIR_OPENCART . 'system/storage/upload/\');' . "\n";
    69. 

  69. 			$output .= 'define(\'DIR_CATALOG\', \'' . DIR_OPENCART . 'catalog/\');' . "\n\n";
    70. 

  70. 

  71. 			$output .= '// DB' . "\n";
    72. 

  72. 			$output .= 'define(\'DB_DRIVER\', \'' . addslashes($this->request->post['db_driver']) . '\');' . "\n";
    73. 

  73. 			$output .= 'define(\'DB_HOSTNAME\', \'' . addslashes($this->request->post['db_hostname']) . '\');' . "\n";
    74. 

  74. 			$output .= 'define(\'DB_USERNAME\', \'' . addslashes($this->request->post['db_username']) . '\');' . "\n";
    75. 

  75. 			$output .= 'define(\'DB_PASSWORD\', \'' . addslashes(html_entity_decode($this->request->post['db_password'], ENT_QUOTES, 'UTF-8')) . '\');' . "\n";
    76. 

  76. 			$output .= 'define(\'DB_DATABASE\', \'' . addslashes($this->request->post['db_database']) . '\');' . "\n";
    77. 

  77. 			$output .= 'define(\'DB_PORT\', \'' . addslashes($this->request->post['db_port']) . '\');' . "\n";
    78. 

  78. 			$output .= 'define(\'DB_PREFIX\', \'' . addslashes($this->request->post['db_prefix']) . '\');' . "\n";
    79. 

  79. 

  80. 			$file = fopen(DIR_OPENCART . 'admin/config.php', 'w');
    81. 

  81. 

  82. 			fwrite($file, $output);
    83. 

  83. 

  84. 			fclose($file);
    85. 

  85. 

  86. 			$this->response->redirect($this->url->link('install/step_4'));
    87. 

  87. 		}
    88. 

  88. 

  89. 		$this->document->setTitle($this->language->get('heading_title'));
    90. 

  90. 

  91. 		$data['heading_title'] = $this->language->get('heading_title');
    92. 

  92. 		
    93. 

  93. 		$data['text_step_3'] = $this->language->get('text_step_3');
    94. 

  94. 		$data['text_db_connection'] = $this->language->get('text_db_connection');
    95. 

  95. 		$data['text_db_administration'] = $this->language->get('text_db_administration');
    96. 

  96. 		$data['text_mysqli'] = $this->language->get('text_mysqli');
    97. 

  97. 		$data['text_mpdo'] = $this->language->get('text_mpdo');
    98. 

  98. 		$data['text_pgsql'] = $this->language->get('text_pgsql');
    99. 

  99. 

  100. 		$data['entry_db_driver'] = $this->language->get('entry_db_driver');
    101. 

  101. 		$data['entry_db_hostname'] = $this->language->get('entry_db_hostname');
    102. 

  102. 		$data['entry_db_username'] = $this->language->get('entry_db_username');
    103. 

  103. 		$data['entry_db_password'] = $this->language->get('entry_db_password');
    104. 

  104. 		$data['entry_db_database'] = $this->language->get('entry_db_database');
    105. 

  105. 		$data['entry_db_port'] = $this->language->get('entry_db_port');
    106. 

  106. 		$data['entry_db_prefix'] = $this->language->get('entry_db_prefix');
    107. 

  107. 		$data['entry_username'] = $this->language->get('entry_username');
    108. 

  108. 		$data['entry_password'] = $this->language->get('entry_password');
    109. 

  109. 		$data['entry_email'] = $this->language->get('entry_email');
    110. 

  110. 

  111. 		$data['button_continue'] = $this->language->get('button_continue');
    112. 

  112. 		$data['button_back'] = $this->language->get('button_back');
    113. 

  113. 

  114. 		if (isset($this->error['warning'])) {
    115. 

  115. 			$data['error_warning'] = $this->error['warning'];
    116. 

  116. 		} else {
    117. 

  117. 			$data['error_warning'] = '';
    118. 

  118. 		}
    119. 

  119. 

  120. 		if (isset($this->error['db_hostname'])) {
    121. 

  121. 			$data['error_db_hostname'] = $this->error['db_hostname'];
    122. 

  122. 		} else {
    123. 

  123. 			$data['error_db_hostname'] = '';
    124. 

  124. 		}
    125. 

  125. 

  126. 		if (isset($this->error['db_username'])) {
    127. 

  127. 			$data['error_db_username'] = $this->error['db_username'];
    128. 

  128. 		} else {
    129. 

  129. 			$data['error_db_username'] = '';
    130. 

  130. 		}
    131. 

  131. 

  132. 		if (isset($this->error['db_database'])) {
    133. 

  133. 			$data['error_db_database'] = $this->error['db_database'];
    134. 

  134. 		} else {
    135. 

  135. 			$data['error_db_database'] = '';
    136. 

  136. 		}
    137. 

  137. 		
    138. 

  138. 		if (isset($this->error['db_port'])) {
    139. 

  139. 			$data['error_db_port'] = $this->error['db_port'];
    140. 

  140. 		} else {
    141. 

  141. 			$data['error_db_port'] = '';
    142. 

  142. 		}
    143. 

  143. 		
    144. 

  144. 		if (isset($this->error['db_prefix'])) {
    145. 

  145. 			$data['error_db_prefix'] = $this->error['db_prefix'];
    146. 

  146. 		} else {
    147. 

  147. 			$data['error_db_prefix'] = '';
    148. 

  148. 		}
    149. 

  149. 

  150. 		if (isset($this->error['username'])) {
    151. 

  151. 			$data['error_username'] = $this->error['username'];
    152. 

  152. 		} else {
    153. 

  153. 			$data['error_username'] = '';
    154. 

  154. 		}
    155. 

  155. 

  156. 		if (isset($this->error['password'])) {
    157. 

  157. 			$data['error_password'] = $this->error['password'];
    158. 

  158. 		} else {
    159. 

  159. 			$data['error_password'] = '';
    160. 

  160. 		}
    161. 

  161. 

  162. 		if (isset($this->error['email'])) {
    163. 

  163. 			$data['error_email'] = $this->error['email'];
    164. 

  164. 		} else {
    165. 

  165. 			$data['error_email'] = '';
    166. 

  166. 		}
    167. 

  167. 

  168. 		$data['action'] = $this->url->link('install/step_3');
    169. 

  169. 

  170. 		if (isset($this->request->post['db_driver'])) {
    171. 

  171. 			$data['db_driver'] = $this->request->post['db_driver'];
    172. 

  172. 		} else {
    173. 

  173. 			$data['db_driver'] = '';
    174. 

  174. 		}
    175. 

  175. 

  176. 		if (isset($this->request->post['db_hostname'])) {
    177. 

  177. 			$data['db_hostname'] = $this->request->post['db_hostname'];
    178. 

  178. 		} else {
    179. 

  179. 			$data['db_hostname'] = 'localhost';
    180. 

  180. 		}
    181. 

  181. 

  182. 		if (isset($this->request->post['db_username'])) {
    183. 

  183. 			$data['db_username'] = $this->request->post['db_username'];
    184. 

  184. 		} else {
    185. 

  185. 			$data['db_username'] = 'root';
    186. 

  186. 		}
    187. 

  187. 

  188. 		if (isset($this->request->post['db_password'])) {
    189. 

  189. 			$data['db_password'] = $this->request->post['db_password'];
    190. 

  190. 		} else {
    191. 

  191. 			$data['db_password'] = '';
    192. 

  192. 		}
    193. 

  193. 

  194. 		if (isset($this->request->post['db_database'])) {
    195. 

  195. 			$data['db_database'] = $this->request->post['db_database'];
    196. 

  196. 		} else {
    197. 

  197. 			$data['db_database'] = '';
    198. 

  198. 		}
    199. 

  199. 		
    200. 

  200. 		if (isset($this->request->post['db_port'])) {
    201. 

  201. 			$data['db_port'] = $this->request->post['db_port'];
    202. 

  202. 		} else {
    203. 

  203. 			$data['db_port'] = 3306;
    204. 

  204. 		}
    205. 

  205. 		
    206. 

  206. 		if (isset($this->request->post['db_prefix'])) {
    207. 

  207. 			$data['db_prefix'] = $this->request->post['db_prefix'];
    208. 

  208. 		} else {
    209. 

  209. 			$data['db_prefix'] = 'oc_';
    210. 

  210. 		}
    211. 

  211. 

  212. 		if (isset($this->request->post['username'])) {
    213. 

  213. 			$data['username'] = $this->request->post['username'];
    214. 

  214. 		} else {
    215. 

  215. 			$data['username'] = 'admin';
    216. 

  216. 		}
    217. 

  217. 

  218. 		if (isset($this->request->post['password'])) {
    219. 

  219. 			$data['password'] = $this->request->post['password'];
    220. 

  220. 		} else {
    221. 

  221. 			$data['password'] = '';
    222. 

  222. 		}
    223. 

  223. 

  224. 		if (isset($this->request->post['email'])) {
    225. 

  225. 			$data['email'] = $this->request->post['email'];
    226. 

  226. 		} else {
    227. 

  227. 			$data['email'] = '';
    228. 

  228. 		}
    229. 

  229. 

  230. 		$data['mysqli'] = extension_loaded('mysqli');
    231. 

  231. 		$data['mysql'] = extension_loaded('mysql');
    232. 

  232. 		$data['pdo'] = extension_loaded('pdo');
    233. 

  233. 		$data['pgsql'] = extension_loaded('pgsql');
    234. 

  234. 

  235. 		$data['back'] = $this->url->link('install/step_2');
    236. 

  236. 

  237. 		$data['footer'] = $this->load->controller('common/footer');
    238. 

  238. 		$data['header'] = $this->load->controller('common/header');
    239. 

  239. 		$data['column_left'] = $this->load->controller('common/column_left');
    240. 

  240. 

  241. 		$this->response->setOutput($this->load->view('install/step_3', $data));
    242. 

  242. 	}
    243. 

  243. 

  244. 	private function validate() {
    245. 

  245. 		if (!$this->request->post['db_hostname']) {
    246. 

  246. 			$this->error['db_hostname'] = $this->language->get('error_db_hostname');
    247. 

  247. 		}
    248. 

  248. 

  249. 		if (!$this->request->post['db_username']) {
    250. 

  250. 			$this->error['db_username'] = $this->language->get('error_db_username');
    251. 

  251. 		}
    252. 

  252. 

  253. 		if (!$this->request->post['db_database']) {
    254. 

  254. 			$this->error['db_database'] = $this->language->get('error_db_database');
    255. 

  255. 		}
    256. 

  256. 

  257. 		if (!$this->request->post['db_port']) {
    258. 

  258. 			$this->error['db_port'] = $this->language->get('error_db_port');
    259. 

  259. 		}		
    260. 

  260. 

  261. 		if ($this->request->post['db_prefix'] && preg_match('/[^a-z0-9_]/', $this->request->post['db_prefix'])) {
    262. 

  262. 			$this->error['db_prefix'] = $this->language->get('error_db_prefix');
    263. 

  263. 		}
    264. 

  264. 

  265. 		if ($this->request->post['db_driver'] == 'mysqli') {
    266. 

  266. 			$mysql = @new MySQLi($this->request->post['db_hostname'], $this->request->post['db_username'], html_entity_decode($this->request->post['db_password'], ENT_QUOTES, 'UTF-8'), $this->request->post['db_database'], $this->request->post['db_port']);
    267. 

  267. 

  268. 			if ($mysql->connect_error) {
    269. 

  269. 				$this->error['warning'] = $mysql->connect_error;
    270. 

  270. 			} else {
    271. 

  271. 				$mysql->close();
    272. 

  272. 			}
    273. 

  273. 		} elseif ($this->request->post['db_driver'] == 'mpdo') {
    274. 

  274. 			try {
    275. 

  275. 				new \DB\mPDO($this->request->post['db_hostname'], $this->request->post['db_username'], $this->request->post['db_password'], $this->request->post['db_database'], $this->request->post['db_port']);
    276. 

  276. 			} catch(Exception $e) {
    277. 

  277. 				$this->error['warning'] = $e->getMessage();
    278. 

  278. 			}
    279. 

  279. 		}			
    280. 

  280. 		
    281. 

  281. 		if (!$this->request->post['username']) {
    282. 

  282. 			$this->error['username'] = $this->language->get('error_username');
    283. 

  283. 		}
    284. 

  284. 

  285. 		if (!$this->request->post['password']) {
    286. 

  286. 			$this->error['password'] = $this->language->get('error_password');
    287. 

  287. 		}
    288. 

  288. 

  289. 		if ((utf8_strlen($this->request->post['email']) > 96) || !filter_var($this->request->post['email'], FILTER_VALIDATE_EMAIL)) {
    290. 

  290. 			$this->error['email'] = $this->language->get('error_email');
    291. 

  291. 		}
    292. 

  292. 

  293. 		if (!is_writable(DIR_OPENCART . 'config.php')) {
    294. 

  294. 			$this->error['warning'] = $this->language->get('error_config') . DIR_OPENCART . 'config.php!';
    295. 

  295. 		}
    296. 

  296. 

  297. 		if (!is_writable(DIR_OPENCART . 'admin/config.php')) {
    298. 

  298. 			$this->error['warning'] = $this->language->get('error_config') . DIR_OPENCART . 'admin/config.php!';
    299. 

  299. 		}
    300. 

  300. 

  301. 		return !$this->error;
    302. 

  302. 	}
    303. 

  303. }
    304.