PageRenderTime 46ms CodeModel.GetById 20ms RepoModel.GetById 0ms app.codeStats 0ms

/installation/modules/configuration.php

http://acp3.googlecode.com/
PHP | 237 lines | 212 code | 19 blank | 6 comment | 60 complexity | 27cfddf9832730f9052e61614dfced22 MD5 | raw file
Possible License(s): MPL-2.0-no-copyleft-exception, LGPL-2.1, GPL-2.0 
    

  1. <?php
    2. 

  2. if (defined('IN_INSTALL') === false)
    3. 

  3. 	exit;
    4. 

  4. 

  5. if (isset($_POST['submit'])) {
    6. 

  6. 	$config_path = ACP3_ROOT . 'includes/config.php';
    7. 

  7. 	$db = new ACP3_DB();
    8. 

  8. 

  9. 	if (empty($_POST['db_host']))
    10. 

  10. 		$errors[] = $lang->t('installation', 'type_in_db_host');
    11. 

  11. 	if (empty($_POST['db_user']))
    12. 

  12. 		$errors[] = $lang->t('installation', 'type_in_db_username');
    13. 

  13. 	if (empty($_POST['db_name']))
    14. 

  14. 		$errors[] = $lang->t('installation', 'type_in_db_name');
    15. 

  15. 	if (!empty($_POST['db_host']) && !empty($_POST['db_user']) && !empty($_POST['db_name']) &&
    16. 

  16. 		$db->connect($_POST['db_host'], $_POST['db_name'], $_POST['db_user'], $_POST['db_password']) !== true)
    17. 

  17. 		$errors[] = $lang->t('installation', 'db_connection_failed');
    18. 

  18. 	if (empty($_POST['user_name']))
    19. 

  19. 		$errors[] = $lang->t('installation', 'type_in_user_name');
    20. 

  20. 	if ((empty($_POST['user_pwd']) || empty($_POST['user_pwd_wdh'])) ||
    21. 

  21. 		(!empty($_POST['user_pwd']) && !empty($_POST['user_pwd_wdh']) && $_POST['user_pwd'] != $_POST['user_pwd_wdh']))
    22. 

  22. 		$errors[] = $lang->t('installation', 'type_in_pwd');
    23. 

  23. 	if (ACP3_Validate::email($_POST['mail']) === false)
    24. 

  24. 		$errors[] = $lang->t('common', 'wrong_email_format');
    25. 

  25. 	if (ACP3_Validate::isNumber($_POST['entries']) === false)
    26. 

  26. 		$errors[] = $lang->t('common', 'select_records_per_page');
    27. 

  27. 	if (ACP3_Validate::isNumber($_POST['flood']) === false)
    28. 

  28. 		$errors[] = $lang->t('system', 'type_in_flood_barrier');
    29. 

  29. 	if (empty($_POST['date_format_long']) || empty($_POST['date_format_short']))
    30. 

  30. 		$errors[] = $lang->t('system', 'type_in_date_format');
    31. 

  31. 	if (ACP3_Validate::timeZone($_POST['date_time_zone']) === false)
    32. 

  32. 		$errors[] = $lang->t('common', 'select_time_zone');
    33. 

  33. 	if (is_file($config_path) === false || is_writable($config_path) === false)
    34. 

  34. 		$errors[] = $lang->t('installation', 'wrong_chmod_for_config_file');
    35. 

  35. 

  36. 	if (isset($errors)) {
    37. 

  37. 		$tpl->assign('errors', $errors);
    38. 

  38. 		$tpl->assign('error_msg', $tpl->fetch('error_box.tpl'));
    39. 

  39. 	} else {
    40. 

  40. 		// Systemkonfiguration erstellen
    41. 

  41. 		$config = array(
    42. 

  42. 			'cache_images' => true,
    43. 

  43. 			'cache_minify' => 3600,
    44. 

  44. 			'date_format_long' => $_POST['date_format_long'],
    45. 

  45. 			'date_format_short' => $_POST['date_format_short'],
    46. 

  46. 			'date_time_zone' => $_POST['date_time_zone'],
    47. 

  47. 			'db_host' => $_POST['db_host'],
    48. 

  48. 			'db_name' => $_POST['db_name'],
    49. 

  49. 			'db_pre' => $_POST['db_pre'],
    50. 

  50. 			'db_password' => $_POST['db_password'],
    51. 

  51. 			'db_user' => $_POST['db_user'],
    52. 

  52. 			'db_version' => 21,
    53. 

  53. 			'design' => 'acp3',
    54. 

  54. 			'entries' => $_POST['entries'],
    55. 

  55. 			'flood' => $_POST['flood'],
    56. 

  56. 			'homepage' => 'news/list/',
    57. 

  57. 			'lang' => LANG,
    58. 

  58. 			'mailer_smtp_auth' => false,
    59. 

  59. 			'mailer_smtp_host' => '',
    60. 

  60. 			'mailer_smtp_password' => '',
    61. 

  61. 			'mailer_smtp_port' => 25,
    62. 

  62. 			'mailer_smtp_security' => '',
    63. 

  63. 			'mailer_smtp_user' => '',
    64. 

  64. 			'mailer_type' => 'mail',
    65. 

  65. 			'maintenance_mode' => false,
    66. 

  66. 			'maintenance_message' => $lang->t('installation', 'offline_message'),
    67. 

  67. 			'seo_aliases' => true,
    68. 

  68. 			'seo_meta_description' => '',
    69. 

  69. 			'seo_meta_keywords' => '',
    70. 

  70. 			'seo_mod_rewrite' => false,
    71. 

  71. 			'seo_robots' => 1,
    72. 

  72. 			'seo_title' => !empty($_POST['seo_title']) ? $_POST['seo_title'] : 'ACP3',
    73. 

  73. 			'version' => CONFIG_VERSION,
    74. 

  74. 			'wysiwyg' => 'ckeditor'
    75. 

  75. 		);
    76. 

  76. 

  77. 		// Daten in die config.php schreiben und diese laden
    78. 

  78. 		writeConfigFile($config);
    79. 

  79. 

  80. 		$db = new ACP3_DB();
    81. 

  81. 		$db->connect($_POST['db_host'], $_POST['db_name'], $_POST['db_user'], $_POST['db_password'], $_POST['db_pre']);
    82. 

  82. 

  83. 		$sql_file = file_get_contents(ACP3_ROOT . 'installation/modules/install.sql');
    84. 

  84. 		$sql_file = str_replace(array("\r\n", "\r"), "\n", $sql_file);
    85. 

  85. 		$sql_file = str_replace('{engine}', 'ENGINE=MyISAM CHARACTER SET `utf8` COLLATE `utf8_general_ci`', $sql_file);
    86. 

  86. 

  87. 		$sql_file_arr = explode(";\n", $sql_file);
    88. 

  88. 		$salt = salt(12);
    89. 

  89. 		$current_date = gmdate('U');
    90. 

  90. 

  91. 		$other_arr = array(
    92. 

  92. 			1 => 'INSERT INTO `{pre}users` VALUES (\'\', 1, \'' . $db->escape($_POST['user_name']) . '\', \'' . generateSaltedPassword($salt, $_POST['user_pwd']) . ':' . $salt . '\', \'0\', \':1\', \'1:1\', \':1\', \'1\', \'' . $_POST['mail'] . ':1\', \':1\', \':1\', \':1\', \':1\', \'' . $db->escape($_POST['date_format_long']) . '\', \'' . $db->escape($_POST['date_format_short']) . '\', \'' . $_POST['date_time_zone'] . '\', \'' . $_POST['date_dst'] .'\', \'' . LANG . '\', \'' . $_POST['entries'] . '\', \'\')',
    93. 

  93. 			2 => 'INSERT INTO `{pre}news` VALUES (\'\', \'' . $current_date . '\', \'' . $current_date . '\', \'' . $lang->t('installation', 'news_headline') . '\', \'' . $lang->t('installation', 'news_text') . '\', \'1\', \'1\', \'1\', \'\', \'\', \'\', \'\')',
    94. 

  94. 			3 => 'INSERT INTO `{pre}menu_items` VALUES (\'\', 1, 1, 1, 0, 1, 2, 1, \'' . $lang->t('installation', 'pages_news') . '\', \'news\', 1), (\'\', 1, 1, 2, 0, 3, 4, 1, \'' . $lang->t('installation', 'pages_files') . '\', \'files\', 1), (\'\', 1, 1, 3, 0, 5, 6, 1, \'' . $lang->t('installation', 'pages_gallery') . '\', \'gallery\', 1), (\'\', 1, 1, 4, 0, 7, 8, 1, \'' . $lang->t('installation', 'pages_guestbook') . '\', \'guestbook\', 1), (\'\', 1, 1, 5, 0, 9, 10, 1, \'' . $lang->t('installation', 'pages_polls') . '\', \'polls\', 1), (\'\', 1, 1, 6, 0, 11, 12, 1, \'' . $lang->t('installation', 'pages_search') . '\', \'search\', 1), (\'\', 1, 2, 7, 0, 13, 14, 1, \'' . $lang->t('installation', 'pages_contact') . '\', \'contact\', 1), (\'\', 2, 2, 8, 0, 15, 16, 1, \'' . $lang->t('installation', 'pages_imprint') . '\', \'contact/imprint/\', 1)',
    95. 

  95. 			4 => 'INSERT INTO `{pre}menu_items_blocks` (`id`, `index_name`, `title`) VALUES (1, \'main\', \'' . $lang->t('installation', 'pages_main') . '\'), (2, \'sidebar\', \'' . $lang->t('installation', 'pages_sidebar') . '\')',
    96. 

  96. 			5 => 'INSERT INTO `{pre}seo` VALUES (\'news/details/id_1/\', \'' . $lang->t('installation', 'news_headline_alias') . '\', \'\', \'\', \'1\')',
    97. 

  97. 			6 => 'INSERT INTO `{pre}seo` VALUES (\'contact/imprint/\', \'' . $lang->t('installation', 'pages_imprint_alias') . '\', \'\', \'\', \'1\')',
    98. 

  98. 		);
    99. 

  99. 		$queries = array_merge($sql_file_arr, $other_arr);
    100. 

  100. 

  101. 		$data = NULL;
    102. 

  102. 		$i = 0;
    103. 

  103. 		foreach ($queries as $query) {
    104. 

  104. 			if (!empty($query)) {
    105. 

  105. 				$query.= ';';
    106. 

  106. 				$data[$i]['query'] = htmlentities($query, ENT_QUOTES, 'UTF-8');
    107. 

  107. 				$bool = $db->query($query, 3);
    108. 

  108. 				$data[$i]['color'] = $bool !== false ? '090' : 'f00';
    109. 

  109. 				$data[$i]['result'] = $bool !== false ? $lang->t('system', 'query_successfully_executed') : $lang->t('system', 'query_failed');
    110. 

  110. 				++$i;
    111. 

  111. 				if ($bool === false) {
    112. 

  112. 					$tpl->assign('install_error', true);
    113. 

  113. 					break;
    114. 

  114. 				}
    115. 

  115. 			}
    116. 

  116. 		}
    117. 

  117. 		$tpl->assign('sql_queries', $data);
    118. 

  118. 

  119. 		$special_resources = array(
    120. 

  120. 			'comments' => array(
    121. 

  121. 				'create' => 2,
    122. 

  122. 			),
    123. 

  123. 			'gallery' => array(
    124. 

  124. 				'add_picture' => 4,
    125. 

  125. 			),
    126. 

  126. 			'guestbook' => array(
    127. 

  127. 				'create' => 2,
    128. 

  128. 			),
    129. 

  129. 			'newsletter' => array(
    130. 

  130. 				'compose' => 4,
    131. 

  131. 				'create' => 2,
    132. 

  132. 				'adm_activate' => 3,
    133. 

  133. 				'sent' => 4,
    134. 

  134. 			),
    135. 

  135. 			'system' => array(
    136. 

  136. 				'configuration' => 7,
    137. 

  137. 				'designs' => 7,
    138. 

  138. 				'extensions' => 7,
    139. 

  139. 				'languages' => 7,
    140. 

  140. 				'maintenance' => 7,
    141. 

  141. 				'modules' => 7,
    142. 

  142. 				'sql_export' => 7,
    143. 

  143. 				'sql_import' => 7,
    144. 

  144. 				'sql_optimisation' => 7,
    145. 

  145. 				'update_check' => 3,
    146. 

  146. 			),
    147. 

  147. 			'users' => array(
    148. 

  148. 				'edit_profile' => 1,
    149. 

  149. 				'edit_settings' => 1,
    150. 

  150. 			),
    151. 

  151. 		);
    152. 

  152. 

  153. 		// Moduldaten in die ACL schreiben
    154. 

  154. 		$modules = scandir(MODULES_DIR);
    155. 

  155. 		foreach ($modules as $row) {
    156. 

  156. 			if ($row !== '.' && $row !== '..' && is_dir(MODULES_DIR . $row . '/') === true) {
    157. 

  157. 				$module = scandir(MODULES_DIR . $row . '/');
    158. 

  158. 				$mod_id = $db->select('id', 'modules', 'name = \'' . $row . '\'');
    159. 

  159. 				if (is_file(MODULES_DIR . $row . '/extensions/search.php') === true)
    160. 

  160. 					$db->insert('acl_resources', array('id' => '', 'module_id' => $mod_id[0]['id'], 'page' => 'extensions/search', 'params' => '', 'privilege_id' => 1));
    161. 

  161. 				if (is_file(MODULES_DIR . $row . '/extensions/feeds.php') === true)
    162. 

  162. 					$db->insert('acl_resources', array('id' => '', 'module_id' => $mod_id[0]['id'], 'page' => 'extensions/feeds', 'params' => '', 'privilege_id' => 1));
    163. 

  163. 

  164. 				foreach ($module as $file) {
    165. 

  165. 					if ($file !== '.' && $file !== '..' && is_file(MODULES_DIR . $row . '/' . $file) === true && strpos($file, '.php') !== false) {
    166. 

  166. 						$file = substr($file, 0, -4);
    167. 

  167. 						if (isset($special_resources[$row][$file])) {
    168. 

  168. 							$privilege_id = $special_resources[$row][$file];
    169. 

  169. 						} else {
    170. 

  170. 							$privilege_id = 1;
    171. 

  171. 							if (strpos($file, 'adm_list') === 0)
    172. 

  172. 								$privilege_id = 3;
    173. 

  173. 							if (strpos($file, 'create') === 0 || strpos($file, 'order') === 0)
    174. 

  174. 								$privilege_id = 4;
    175. 

  175. 							if (strpos($file, 'edit') === 0)
    176. 

  176. 								$privilege_id = 5;
    177. 

  177. 							if (strpos($file, 'delete') === 0)
    178. 

  178. 								$privilege_id = 6;
    179. 

  179. 							if (strpos($file, 'settings') === 0)
    180. 

  180. 								$privilege_id = 7;
    181. 

  181. 						}
    182. 

  182. 						$db->insert('acl_resources', array('id' => '', 'module_id' => $mod_id[0]['id'], 'page' => $file, 'params' => '', 'privilege_id' => $privilege_id));
    183. 

  183. 					}
    184. 

  184. 				}
    185. 

  185. 			}
    186. 

  186. 		}
    187. 

  187. 

  188. 		$roles = $db->select('id', 'acl_roles');
    189. 

  189. 		$modules = $db->select('id', 'modules');
    190. 

  190. 		$privileges = $db->select('id', 'acl_privileges');
    191. 

  191. 

  192. 		foreach ($roles as $role) {
    193. 

  193. 			foreach ($modules as $module) {
    194. 

  194. 				foreach ($privileges as $privilege) {
    195. 

  195. 					$permission = 0;
    196. 

  196. 					if ($role['id'] == 1 && ($privilege['id'] == 1 || $privilege['id'] == 2))
    197. 

  197. 						$permission = 1;
    198. 

  198. 					if ($role['id'] > 1 && $role['id'] < 4)
    199. 

  199. 						$permission = 2;
    200. 

  200. 					if ($role['id'] == 3 && $privilege['id'] == 3)
    201. 

  201. 						$permission = 1;
    202. 

  202. 					if ($role['id'] == 4)
    203. 

  203. 						$permission = 1;
    204. 

  204. 

  205. 					$db->insert('acl_rules', array('id' => '', 'role_id' => $role['id'], 'module_id' => $module['id'], 'privilege_id' => $privilege['id'], 'permission' => $permission));
    206. 

  206. 				}
    207. 

  207. 			}
    208. 

  208. 		}
    209. 

  209. 

  210. 		// Modulkonfigurationsdateien schreiben
    211. 

  211. 		ACP3_Config::module('contact', array('mail' => $_POST['mail'], 'disclaimer' => $db->escape($lang->t('installation', 'disclaimer'), 2)));
    212. 

  212. 		ACP3_Config::module('newsletter', array('mail' => $_POST['mail'], 'mailsig' => $db->escape($lang->t('installation', 'sincerely') . "\n\n" . $lang->t('installation', 'newsletter_mailsig'))));
    213. 

  213. 	}
    214. 

  214. }
    215. 

  215. if (isset($_POST['submit']) === false || isset($errors) === true && is_array($errors) === true) {
    216. 

  216. 	// Eintr?ge pro Seite
    217. 

  217. 	$tpl->assign('entries', recordsPerPage(20));
    218. 

  218. 

  219. 	// Zeitzonen
    220. 

  220. 	$tpl->assign('time_zones', getTimeZones(date_default_timezone_get()));
    221. 

  221. 

  222. 	$defaults = array(
    223. 

  223. 		'db_host' => 'localhost',
    224. 

  224. 		'db_pre' => 'acp3_',
    225. 

  225. 		'db_user' => '',
    226. 

  226. 		'db_name' => '',
    227. 

  227. 		'user_name' => 'admin',
    228. 

  228. 		'mail' => '',
    229. 

  229. 		'flood' => '30',
    230. 

  230. 		'date_format_long' => 'd.m.y, H:i',
    231. 

  231. 		'date_format_short' => 'd.m.y',
    232. 

  232. 		'seo_title' => 'ACP3',
    233. 

  233. 	);
    234. 

  234. 

  235. 	$tpl->assign('form', isset($_POST['submit']) ? $_POST : $defaults);
    236. 

  236. }
    237. 

  237. $content = $tpl->fetch('configuration.tpl');
    238.