2 /************************************************************************
3 * MXChange v0.2.1 Start: 08/29/2003 *
4 * =============== Last change: 11/11/2004 *
6 * -------------------------------------------------------------------- *
7 * File : install-inc.php *
8 * -------------------------------------------------------------------- *
9 * Short description : Functions for installation procedure *
10 * -------------------------------------------------------------------- *
11 * Kurzbeschreibung : Funktionen fuer die Installationsroutine *
12 * -------------------------------------------------------------------- *
15 * $Tag:: 0.2.1-FINAL $ *
17 * Needs to be in all Files and every File needs "svn propset *
18 * svn:keywords Date Revision" (autoprobset!) at least!!!!!! *
19 * -------------------------------------------------------------------- *
20 * @TODO Rewrite all constants in this include file *
21 * -------------------------------------------------------------------- *
22 * Copyright (c) 2003 - 2008 by Roland Haeder *
23 * For more information visit: http://www.mxchange.org *
25 * This program is free software; you can redistribute it and/or modify *
26 * it under the terms of the GNU General Public License as published by *
27 * the Free Software Foundation; either version 2 of the License, or *
28 * (at your option) any later version. *
30 * This program is distributed in the hope that it will be useful, *
31 * but WITHOUT ANY WARRANTY; without even the implied warranty of *
32 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *
33 * GNU General Public License for more details. *
35 * You should have received a copy of the GNU General Public License *
36 * along with this program; if not, write to the Free Software *
37 * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, *
39 ************************************************************************/
41 /************************************************************************
42 * YOU MAY ALSO WANT TO REMOVE THIS FILE AFTER INSTALLTION! *
43 ************************************************************************/
45 // Some security stuff...
46 if (!defined('__SECURITY')) {
47 $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), '/inc') + 4) . '/security.php';
53 if ((REQUEST_ISSET_POST(('mysql'))) && (is_array(REQUEST_POST('mysql')))) $mysql = REQUEST_POST('mysql');
55 // Check if both passwords from SMTP are matching
56 if ((REQUEST_ISSET_GET('page') && (REQUEST_GET('page') == 5))) {
57 // Okay, we have to check it
58 if (REQUEST_ISSET_POST(('smtp_user')) && (!REQUEST_ISSET_POST(('smtp_host')))) {
60 OUTPUT_HTML(getMessage('INSTALL_SMTP_HOSTNAME_EMPTY')."<br />");
61 REQUEST_SET_GET('page', 3);
64 if ((!REQUEST_ISSET_POST(('smtp_pass1'))) && (REQUEST_ISSET_POST(('smtp_pass2')))) {
66 OUTPUT_HTML(getMessage('INSTALL_SMTP_PASS1_EMPTY')."<br />");
67 REQUEST_SET_GET('page', 3);
70 if ((REQUEST_ISSET_POST(('smtp_pass1'))) && (!REQUEST_ISSET_POST(('smtp_pass2')))) {
71 // Password repeat is empty
72 OUTPUT_HTML(getMessage('INSTALL_SMTP_PASS2_EMPTY')."<br />");
73 REQUEST_SET_GET('page', 3);
76 if (REQUEST_POST('smtp_pass1') != REQUEST_POST('smtp_pass1')) {
77 // Passwords are not matching
78 OUTPUT_HTML(getMessage('INSTALL_SMTP_PASS_MISMATCH')."<br />");
79 REQUEST_SET_GET('page', 3);
83 // Is MXChange installed or no admin registered so far?
84 if ((!isInstalled()) || (!isAdminRegistered())) {
85 // Set URL for FORM actions
86 define('__BURL_ACTION', constant('URL'));
88 // Output page for entered value
89 switch (REQUEST_GET('page')) {
90 case 'welcome': // Welcome to the installation!
91 LOAD_TEMPLATE('install_welcome');
94 case '1': // Server path, base URL
96 LOAD_TEMPLATE('install_page1');
99 case '2': // MySQL data (alone!)
100 if (empty($mysql['dbase'])) $mysql['dbase'] = 'your_database';
101 if (empty($mysql['login'])) $mysql['login'] = 'your_login';
102 if (empty($mysql['host'])) $mysql['host'] = 'localhost';
103 if (empty($mysql['prefix'])) $mysql['prefix'] = 'mxchange';
104 if (empty($mysql['type'])) $mysql['type'] = 'MyISAM';
105 if (getTotalFatalErrors() > 0) {
106 OUTPUT_HTML("<span class=\"install_fatal\">");
107 foreach (getFatalArray() as $key => $err) {
108 OUTPUT_HTML(" <strong>·</strong> {--FATAL_NO--}".($key + 1).": ".$err."<br />");
110 OUTPUT_HTML("</span><br />");
112 define('__MYSQL_HOST' , $mysql['host']);
113 define('__MYSQL_DBASE' , $mysql['dbase']);
114 define('__MYSQL_PREFIX', $mysql['prefix']);
115 define('__TABLE_TYPE' , $mysql['type']);
116 define('__MYSQL_LOGIN' , $mysql['login']);
117 define('__SPATH_VALUE' , REQUEST_POST('spath'));
118 define('__BURL_VALUE' , REQUEST_POST('burl'));
119 define('__TITLE_VALUE' , REQUEST_POST('title'));
120 define('__SLOGAN_VALUE', REQUEST_POST('slogan'));
121 define('__EMAIL_VALUE' , REQUEST_POST('email'));
124 LOAD_TEMPLATE('install_page2');
129 define('__SPATH_VALUE' , REQUEST_POST('spath'));
130 define('__BURL_VALUE' , REQUEST_POST('burl'));
131 define('__TITLE_VALUE' , REQUEST_POST('title'));
132 define('__SLOGAN_VALUE', REQUEST_POST('slogan'));
133 define('__EMAIL_VALUE' , REQUEST_POST('email'));
135 // Use default SMTP data
136 $smtpHost = getConfig('SMTP_HOSTNAME');
137 $smtpUser = getConfig('SMTP_USER');
138 $smtpPass1 = getConfig('SMTP_PASSWORD');
139 $smtpPass2 = getConfig('SMTP_PASSWORD');
141 // Overwrite it with the data from sent (failed) form
142 if (REQUEST_ISSET_POST(('smtp_host'))) $smtpHost = REQUEST_POST('smtp_host');
143 if (REQUEST_ISSET_POST(('smtp_user'))) $smtpUser = REQUEST_POST('smtp_user');
144 if (REQUEST_ISSET_POST(('smtp_pass'))) {
145 $smtpPass1 = REQUEST_POST('smtp_pass');
146 $smtpPass2 = REQUEST_POST('smtp_pass');
150 define('__MYSQL_HOST' , $mysql['host']);
151 define('__MYSQL_DBASE' , $mysql['dbase']);
152 define('__MYSQL_PREFIX', $mysql['prefix']);
153 define('__TABLE_TYPE' , $mysql['type']);
154 define('__MYSQL_LOGIN' , $mysql['login']);
155 define('__MYSQL_PASS1' , $mysql['pass1']);
156 define('__MYSQL_PASS2' , $mysql['pass2']);
158 // Set constants for SMTP data
159 define('__SMTP_HOST' , $smtpHost);
160 define('__SMTP_USER' , $smtpUser);
161 define('__SMTP_PASS1', $smtpPass1);
162 define('__SMTP_PASS2', $smtpPass2);
165 LOAD_TEMPLATE('install_page3');
168 case '5': // Misc settings
170 define('__SPATH_VALUE' , REQUEST_POST('spath'));
171 define('__BURL_VALUE' , REQUEST_POST('burl'));
172 define('__TITLE_VALUE' , REQUEST_POST('title'));
173 define('__SLOGAN_VALUE', REQUEST_POST('slogan'));
174 define('__EMAIL_VALUE' , REQUEST_POST('email'));
177 define('__MYSQL_HOST' , $mysql['host']);
178 define('__MYSQL_DBASE' , $mysql['dbase']);
179 define('__MYSQL_PREFIX', $mysql['prefix']);
180 define('__TABLE_TYPE' , $mysql['type']);
181 define('__MYSQL_LOGIN' , $mysql['login']);
184 define('__SMTP_HOST', REQUEST_POST('smtp_host'));
185 define('__SMTP_USER', REQUEST_POST('smtp_user'));
186 define('__SMTP_PASS', REQUEST_POST('smtp_pass1'));
187 OUTPUT_HTML("<form action=\"{!__BURL_ACTION!}/install.php?page=finalize\" method=\"POST\" target=\"_self\">
188 <table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" class=\"install_main\">
190 <td colspan=\"2\" align=\"center\">
191 <div class=\"install\">{--HEADER_TEXT_PAGE5--}</strong>
194 <tr><td colspan=\"2\" height=\"21\" class=\"seperator\"> </td></tr>
196 <td colspan=\"2\"><span class=\"install_text\">
200 <tr><td colspan=\"2\" height=\"21\" class=\"seperator\"> </td></tr>
202 <td class=\"install\" align=\"right\">{--LANG_OUTPUT_MODE--}: </td>
204 <select name=\"omode\" size=\"1\" class=\"install_select\">
205 <option value=\"render\">{--MODE_RENDER--}</option>
206 <option value=\"direct\">{--MODE_DIRECT--}</option>
210 <tr><td colspan=\"2\" height=\"10\" class=\"seperator\"> </td></tr>
212 <td class=\"install\" align=\"right\">{--WARN_NO_PASSWORD--}: </td>
214 <select name=\"warn_no_pass\" size=\"1\" class=\"install_select\">
215 <option value=\"Y\">{--YES--}</option>
216 <option value=\"N\">{--NO--}</option>
220 <tr><td colspan=\"2\" height=\"10\" class=\"seperator\"> </td></tr>
222 <td class=\"install\" align=\"right\">{--LANG_WRITE_FOOTER--}: </td>
224 <select name=\"wfooter\" size=\"1\" class=\"install_select\">
225 <option value=\"Y\">{--YES--}</option>
226 <option value=\"N\">{--NO--}</option>
230 <tr><td colspan=\"2\" height=\"10\" class=\"seperator\"> </td></tr>
232 <td class=\"install\" align=\"right\">{--INSTALL_ENABLE_BACKLINK--}: </td>
234 <select name=\"blink\" size=\"1\" class=\"install_select\">
235 <option value=\"Y\">{--YES--}</option>
236 <option value=\"N\">{--NO--}</option>
240 <tr><td colspan=\"2\" height=\"21\" class=\"seperator\"> </td></tr>
242 <td colspan=\"2\" align=\"center\">");
243 foreach ($mysql as $key => $value) {
244 OUTPUT_HTML(" <input type=\"hidden\" name=\"mysql[".$key."]\" value=\"".$value."\" />");
246 OUTPUT_HTML(" <input type=\"hidden\" name=\"spath\" value=\"{!__SPATH_VALUE!}\" />
247 <input type=\"hidden\" name=\"burl\" value=\"{!__BURL_VALUE!}\" />
248 <input type=\"hidden\" name=\"title\" value=\"{!__TITLE_VALUE!}\" />
249 <input type=\"hidden\" name=\"slogan\" value=\"{!__SLOGAN_VALUE!}\" />
250 <input type=\"hidden\" name=\"email\" value=\"{!__EMAIL_VALUE!}\" />
251 <input type=\"hidden\" name=\"smtp_host\" value=\"{!__SMTP_HOST!}\" />
252 <input type=\"hidden\" name=\"smtp_user\" value=\"{!__SMTP_USER!}\" />
253 <input type=\"hidden\" name=\"smtp_pass\" value=\"{!__SMTP_PASS!}\" />
254 <input type=\"submit\" class=\"admin_submit submit\" name=\"finalize\" value=\"{--NEXT_PAGE--}\" class=\"install_submit\" />
257 <tr><td colspan=\"2\" height=\"21\" class=\"seperator\"> </td></tr>
262 case 'finalize': // Write captured data to files
263 if ((REQUEST_ISSET_POST('finalize')) && (!isInstalled())) {
264 // You have submitted data then we have to reset the SQLs
267 // Connect to MySQL server
268 SQL_CONNECT($mysql['host'], $mysql['login'], $mysql['pass1'], __FILE__, __LINE__);
269 if (SQL_IS_LINK_UP()) {
270 // Seems to work, also right database?
271 if (SQL_SELECT_DB($mysql['dbase'], __FILE__, __LINE__) === true) {
272 // Automatically run install.sql
273 if ((!isFileReadable(REQUEST_POST('spath') . 'install/tables.sql')) || (!isFileReadable(REQUEST_POST('spath') . 'install/menu-'.getLanguage().'.sql'))) {
274 // Installation area not found!
275 addFatalMessage(__FILE__, __LINE__, getMessage('INSTALL_MISSING_DUMPS'));
278 if (getTotalFatalErrors() == 0) {
279 // Both exists so import them
280 foreach (array('tables', 'menu-'.getLanguage()) as $dump) {
281 // Should be save here because file_exists() is there but we check it again. :)
282 $FQFN = REQUEST_POST('spath') . 'install/' . $dump . '.sql';
284 // Is the file readable?
285 if (isFileReadable($FQFN)) {
287 $fileContent = readFromFile($FQFN, true);
289 // Replace the {!prefix/type!} with actual one
290 foreach (array('prefix', 'type') as $replace) {
291 while (strpos($fileContent, '{!' . $replace . '!}') !== false) {
292 $fileContent = str_replace('{!' . $replace . '!}', $mysql[$replace], $fileContent);
296 // Split it up against ";\n" and merge it into existing SQLs
297 MERGE_SQLS(explode(";\n", $fileContent));
300 debug_report_bug(sprintf("SQL dump %s is not readable!", $dump));
304 // Are some SQLs found?
305 if (COUNT_SQLS() == 0) {
307 addFatalMessage(__FILE__, __LINE__, getMessage('INSTALL_SQL_IMPORT_FAILED'));
311 // Now run all queries through and try to keep out empty or comment queries
312 runFilterChain('run_sqls');
314 // Copy the config template and verify it
315 copyFileVerified(REQUEST_POST('spath') . 'inc/config-local.php.dist', REQUEST_POST('spath') . 'inc/cache/config-local.php', 0644);
317 // Ok, all done. So we can write the config data to the php files
318 if (REQUEST_POST('spath') != constant('PATH')) changeDataInFile(REQUEST_POST('spath') . 'inc/cache/config-local.php', "SERVER-PATH", "define('PATH', \"", "\");", REQUEST_POST('spath'), 0);
319 if (REQUEST_POST('burl') != constant('URL')) changeDataInFile(REQUEST_POST('spath') . 'inc/cache/config-local.php', "HOST-URL", "define('URL', \"", "\");", REQUEST_POST('burl'), 0);
320 changeDataInFile(REQUEST_POST('spath') . 'inc/cache/config-local.php', "MAIN-TITLE", "define('MAIN_TITLE', \"", "\");", REQUEST_POST('title'), 0);
321 changeDataInFile(REQUEST_POST('spath') . 'inc/cache/config-local.php', "SLOGAN", "define('SLOGAN', \"", "\");", REQUEST_POST('slogan'), 0);
322 changeDataInFile(REQUEST_POST('spath') . 'inc/cache/config-local.php', "WEBMASTER", "define('WEBMASTER', \"", "\");", REQUEST_POST('email'), 0);
323 changeDataInFile(REQUEST_POST('spath') . 'inc/cache/config-local.php', "NULLPASS-WARNING", "setConfigEntry('WARN_NO_PASS', \"", "\");", REQUEST_POST('warn_no_pass'), 0);
324 changeDataInFile(REQUEST_POST('spath') . 'inc/cache/config-local.php', "WRITE-FOOTER", "setConfigEntry('WRITE_FOOTER', \"", "\");", REQUEST_POST('wfooter'), 0);
325 changeDataInFile(REQUEST_POST('spath') . 'inc/cache/config-local.php', "BACKLINK", "setConfigEntry('ENABLE_BACKLINK', \"", "\");", REQUEST_POST('blink'), 0);
326 // DEACTIVATED: changeDataInFile(REQUEST_POST('spath') . 'inc/cache/config-local.php', "OUTPUT-MODE", "define('OUTPUT_MODE', \"", "\");", REQUEST_POST('omode'), 0);
327 changeDataInFile(REQUEST_POST('spath') . 'inc/cache/config-local.php', "MYSQL-HOST", " 'host' => \"", "\",", $mysql['host'], 0);
328 changeDataInFile(REQUEST_POST('spath') . 'inc/cache/config-local.php', "MYSQL-DBASE", " 'dbase' => \"", "\",", $mysql['dbase'], 0);
329 changeDataInFile(REQUEST_POST('spath') . 'inc/cache/config-local.php', "MYSQL-LOGIN", " 'login' => \"", "\",", $mysql['login'], 0);
330 changeDataInFile(REQUEST_POST('spath') . 'inc/cache/config-local.php', "MYSQL-PASSWORD", " 'password' => \"", "\",", $mysql['pass1'], 0);
331 changeDataInFile(REQUEST_POST('spath') . 'inc/cache/config-local.php', "MYSQL-PREFIX", "setConfigEntry('_MYSQL_PREFIX', \"", "\");", $mysql['prefix'], 0);
332 changeDataInFile(REQUEST_POST('spath') . 'inc/cache/config-local.php', "TABLE-TYPE", "setConfigEntry('_TABLE_TYPE', \"", "\");", $mysql['type'], 0);
333 changeDataInFile(REQUEST_POST('spath') . 'inc/cache/config-local.php', "SMTP-HOSTNAME", "setConfigEntry('SMTP_HOSTNAME', \"", "\");", REQUEST_POST('smtp_host'), 0);
334 changeDataInFile(REQUEST_POST('spath') . 'inc/cache/config-local.php', "SMTP-USER", "setConfigEntry('SMTP_USER', \"", "\");", REQUEST_POST('smtp_user'), 0);
335 changeDataInFile(REQUEST_POST('spath') . 'inc/cache/config-local.php', "SMTP-PASSWORD", "setConfigEntry('SMTP_PASSWORD', \"", "\");", REQUEST_POST('smtp_pass1'), 0);
337 // Generate a long site key
338 $siteKey = generatePassword(50);
341 changeDataInFile(REQUEST_POST('spath') . 'inc/cache/config-local.php', "SITE-KEY", "setConfigEntry('SITE_KEY', \"", "\");", $siteKey, 0);
343 // Script is now installed
344 changeDataInFile(REQUEST_POST('spath') . 'inc/cache/config-local.php', "INSTALLED", "setConfigEntry('MXCHANGE_INSTALLED', \"", "\");", 'Y', 0);
349 if (getTotalFatalErrors() > 0) {
351 foreach (getFatalArray() as $value) {
352 $OUT .= " <li>" . $value . "</li>\n";
354 define('__FATAL_ERROR_LI', $OUT);
356 foreach ($mysql as $key => $value) {
357 $OUT .= " <input type=\"hidden\" name=\"mysql[" . $key . "]\" value=\"" . $value . "\" />\n";
359 define('__MYSQL_DATA' , $OUT);
360 define('__SPATH_VALUE' , REQUEST_POST('spath'));
361 define('__BURL_VALUE' , REQUEST_POST('burl'));
362 define('__TITLE_VALUE' , REQUEST_POST('title'));
363 define('__SMTP_HOST' , REQUEST_POST('smtp_host'));
364 define('__SMTP_USER' , REQUEST_POST('smtp_user'));
365 define('__SMTP_PASS' , REQUEST_POST('smtp_pass1'));
368 LOAD_TEMPLATE('install_fatal_errors');
370 // Installation is done!
371 redirectToUrl('install.php?page=finished');
374 // Something goes wrong during installation! :-(
375 addFatalMessage(__FILE__, __LINE__, getMessage('INSTALL_FINALIZER_FAILED'));
376 loadInclude('inc/fatal_errors.php');
382 // Load template that we are finished
383 LOAD_TEMPLATE('install_finished');
386 redirectToUrl('install.php');
391 DEBUG_LOG(__FILE__, __LINE__, sprintf("Wrong page %s detected", REQUEST_GET('page')));
392 OUTPUT_HTML(" <div class=\"install_error\">{--WRONG_PAGE--}</div>");
396 // Already installed!
397 addFatalMessage(__FILE__, __LINE__, getMessage('ALREADY_INSTALLED'));