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 * -------------------------------------------------------------------- *
14 * -------------------------------------------------------------------- *
15 * Copyright (c) 2003 - 2008 by Roland Haeder *
16 * For more information visit: http://www.mxchange.org *
18 * This program is free software; you can redistribute it and/or modify *
19 * it under the terms of the GNU General Public License as published by *
20 * the Free Software Foundation; either version 2 of the License, or *
21 * (at your option) any later version. *
23 * This program is distributed in the hope that it will be useful, *
24 * but WITHOUT ANY WARRANTY; without even the implied warranty of *
25 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *
26 * GNU General Public License for more details. *
28 * You should have received a copy of the GNU General Public License *
29 * along with this program; if not, write to the Free Software *
30 * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, *
32 ************************************************************************/
34 /************************************************************************
35 * YOU MAY ALSO WANT TO REMOVE THIS FILE AFTER INSTALLTION! *
36 ************************************************************************/
38 // Some security stuff...
39 if (!defined('__SECURITY')) {
40 $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";
44 // Load sql_patches here
45 LOAD_EXTENSION("sql_patches");
49 if ((REQUEST_ISSET_POST(('mysql'))) && (is_array(REQUEST_POST('mysql')))) $mysql = REQUEST_POST('mysql');
51 // Check if both passwords from SMTP are matching
52 if ((REQUEST_ISSET_GET(('page')) && (REQUEST_GET('page') == 5))) {
53 // Okay, we have to check it
54 if (REQUEST_ISSET_POST(('smtp_user')) && (!REQUEST_ISSET_POST(('smtp_host')))) {
56 OUTPUT_HTML(getMessage('INSTALL_SMTP_HOSTNAME_EMPTY')."<br />");
57 REQUEST_SET_GET('page', 3);
60 if ((!REQUEST_ISSET_POST(('smtp_pass1'))) && (REQUEST_ISSET_POST(('smtp_pass2')))) {
62 OUTPUT_HTML(getMessage('INSTALL_SMTP_PASS1_EMPTY')."<br />");
63 REQUEST_SET_GET('page', 3);
66 if ((REQUEST_ISSET_POST(('smtp_pass1'))) && (!REQUEST_ISSET_POST(('smtp_pass2')))) {
67 // Password repeat is empty
68 OUTPUT_HTML(getMessage('INSTALL_SMTP_PASS2_EMPTY')."<br />");
69 REQUEST_SET_GET('page', 3);
72 if (REQUEST_POST('smtp_pass1') != REQUEST_POST('smtp_pass1')) {
73 // Passwords are not matching
74 OUTPUT_HTML(getMessage('INSTALL_SMTP_PASS_MISMATCH')."<br />");
75 REQUEST_SET_GET('page', 3);
79 // Is MXChange installed or no admin registered so far?
80 if ((!isInstalled()) || (!isAdminRegistered()))
82 // Set URL for FORM actions
83 define('__BURL_ACTION', constant('URL'));
85 // Output page for entered value
86 switch (REQUEST_GET('page'))
88 case "welcome": // Welcome to the installation!
89 LOAD_TEMPLATE("install_welcome");
92 case "1": // Server path, base URL
93 // @Profi-Concept: Hab meine Meinung doch geaendert! :-)
95 LOAD_TEMPLATE("install_page1");
98 case "2": // MySQL data (alone!)
99 if (empty($mysql['dbase'])) $mysql['dbase'] = "your_database";
100 if (empty($mysql['login'])) $mysql['login'] = "your_login";
101 if (empty($mysql['host'])) $mysql['host'] = "localhost";
102 if (empty($mysql['prefix'])) $mysql['prefix'] = "mxchange_";
103 if (empty($mysql['type'])) $mysql['type'] = "MyISAM";
104 if (getTotalFatalErrors() > 0) {
105 OUTPUT_HTML("<span class=\"install_fatal\">");
106 foreach (getFatalArray() as $key => $err) {
107 OUTPUT_HTML(" <strong>·</strong> {--FATAL_NO--}".($key + 1).": ".$err."<br />");
109 OUTPUT_HTML("</span><br />");
111 define('__MYSQL_HOST' , $mysql['host']);
112 define('__MYSQL_DBASE' , $mysql['dbase']);
113 define('__MYSQL_PREFIX', $mysql['prefix']);
114 define('__TABLE_TYPE' , $mysql['type']);
115 define('__MYSQL_LOGIN' , $mysql['login']);
116 define('__SPATH_VALUE' , REQUEST_POST('spath'));
117 define('__BURL_VALUE' , REQUEST_POST('burl'));
118 define('__TITLE_VALUE' , REQUEST_POST('title'));
119 define('__SLOGAN_VALUE', REQUEST_POST('slogan'));
120 define('__EMAIL_VALUE' , REQUEST_POST('email'));
123 LOAD_TEMPLATE("install_page2");
128 define('__SPATH_VALUE' , REQUEST_POST('spath'));
129 define('__BURL_VALUE' , REQUEST_POST('burl'));
130 define('__TITLE_VALUE' , REQUEST_POST('title'));
131 define('__SLOGAN_VALUE' , REQUEST_POST('slogan'));
132 define('__EMAIL_VALUE' , REQUEST_POST('email'));
134 // Use default SMTP data
135 $smtpHost = constant('SMTP_HOSTNAME');
136 $smtpUser = constant('SMTP_USER');
137 $smtpPass1 = constant('SMTP_PASSWORD');
138 $smtpPass2 = constant('SMTP_PASSWORD');
140 // Overwrite it with the data from sent (failed) form
141 if (REQUEST_ISSET_POST(('smtp_host'))) $smtpHost = REQUEST_POST('smtp_host');
142 if (REQUEST_ISSET_POST(('smtp_user'))) $smtpUser = REQUEST_POST('smtp_user');
145 define('__MYSQL_HOST' , $mysql['host']);
146 define('__MYSQL_DBASE' , $mysql['dbase']);
147 define('__MYSQL_PREFIX' , $mysql['prefix']);
148 define('__TABLE_TYPE' , $mysql['type']);
149 define('__MYSQL_LOGIN' , $mysql['login']);
150 define('__MYSQL_PASS1' , $mysql['pass1']);
151 define('__MYSQL_PASS2' , $mysql['pass2']);
153 // Set constants for SMTP data
154 define('__SMTP_HOST' , $smtpHost);
155 define('__SMTP_USER' , $smtpUser);
156 define('__SMTP_PASS1' , $smtpPass1);
157 define('__SMTP_PASS2' , $smtpPass2);
160 LOAD_TEMPLATE("install_page3");
163 case "5": // Misc settings
165 define('__SPATH_VALUE' , REQUEST_POST('spath'));
166 define('__BURL_VALUE' , REQUEST_POST('burl'));
167 define('__TITLE_VALUE' , REQUEST_POST('title'));
168 define('__SLOGAN_VALUE' , REQUEST_POST('slogan'));
169 define('__EMAIL_VALUE' , REQUEST_POST('email'));
172 define('__MYSQL_HOST' , $mysql['host']);
173 define('__MYSQL_DBASE' , $mysql['dbase']);
174 define('__MYSQL_PREFIX' , $mysql['prefix']);
175 define('__TABLE_TYPE' , $mysql['type']);
176 define('__MYSQL_LOGIN' , $mysql['login']);
179 define('__SMTP_HOST' , REQUEST_POST('smtp_host'));
180 define('__SMTP_USER' , REQUEST_POST('smtp_user'));
181 define('__SMTP_PASS' , REQUEST_POST('smtp_pass1'));
182 OUTPUT_HTML("<form action=\"{!__BURL_ACTION!}/install.php?page=finalize\" method=\"POST\" target=\"_self\">
183 <table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" class=\"install_content\">
185 <td colspan=\"2\" align=\"center\">
186 <div class=\"install\">{--HEADER_TEXT_PAGE5--}</strong>
189 <tr><td colspan=\"2\" height=\"21\" class=\"seperator\"> </td></tr>
191 <td colspan=\"2\"><span class=\"install_intro\">
195 <tr><td colspan=\"2\" height=\"21\" class=\"seperator\"> </td></tr>
197 <td class=\"install\" align=\"right\">{--LANG_OUTPUT_MODE--}: </td>
199 <select name=\"omode\" size=\"1\" class=\"install_select\">
200 <option value=\"render\"");
201 if (constant('OUTPUT_MODE') == "render") OUTPUT_HTML(" selected=\"selected\"");
202 OUTPUT_HTML(">{--MODE_RENDER--}</option>
203 <option value=\"direct\"");
204 if (constant('OUTPUT_MODE') == "direct") OUTPUT_HTML(" selected=\"selected\"");
205 OUTPUT_HTML(">{--MODE_DIRECT--}</option>
209 <tr><td colspan=\"2\" height=\"10\" class=\"seperator\"> </td></tr>
211 <td class=\"install\" align=\"right\">{--WARN_NO_PASSWORD--}: </td>
213 <select name=\"warn_no_pass\" size=\"1\" class=\"install_select\">
214 <option value=\"true\"");
215 if (isBooleanConstantAndTrue('warn_no_pass')) OUTPUT_HTML(" selected=\"selected\"");
216 OUTPUT_HTML(">{--YES--}</option>
217 <option value=\"false\"");
218 if (!isBooleanConstantAndTrue('warn_no_pass')) OUTPUT_HTML(" selected=\"selected\"");
219 OUTPUT_HTML(">{--NO--}</option>
223 <tr><td colspan=\"2\" height=\"10\" class=\"seperator\"> </td></tr>
225 <td class=\"install\" align=\"right\">{--LANG_WRITE_FOOTER--}: </td>
227 <select name=\"wfooter\" size=\"1\" class=\"install_select\">
228 <option value=\"true\"");
229 if (isBooleanConstantAndTrue('WRITE_FOOTER')) OUTPUT_HTML(" selected=\"selected\"");
230 OUTPUT_HTML(">{--YES--}</option>
231 <option value=\"false\"");
232 if (!isBooleanConstantAndTrue('WRITE_FOOTER')) OUTPUT_HTML(" selected=\"selected\"");
233 OUTPUT_HTML(">{--NO--}</option>
237 <tr><td colspan=\"2\" height=\"10\" class=\"seperator\"> </td></tr>
239 <td class=\"install\" align=\"right\">{--INSTALL_ENABLE_BACKLINK--}: </td>
241 <select name=\"blink\" size=\"1\" class=\"install_select\">
242 <option value=\"true\"");
243 if (isBooleanConstantAndTrue('ENABLE_BACKLINK')) OUTPUT_HTML(" selected=\"selected\"");
244 OUTPUT_HTML(">{--YES--}</option>
245 <option value=\"false\"");
246 if (!isBooleanConstantAndTrue('ENABLE_BACKLINK')) OUTPUT_HTML(" selected=\"selected\"");
247 OUTPUT_HTML(">{--NO--}</option>
251 <tr><td colspan=\"2\" height=\"21\" class=\"seperator\"> </td></tr>
253 <td colspan=\"2\" align=\"center\">");
254 foreach ($mysql as $key => $value) {
255 OUTPUT_HTML(" <input type=\"hidden\" name=\"mysql[".$key."]\" value=\"".$value."\" />");
257 OUTPUT_HTML(" <input type=\"hidden\" name=\"spath\" value=\"{!__SPATH_VALUE!}\" />
258 <input type=\"hidden\" name=\"burl\" value=\"{!__BURL_VALUE!}\" />
259 <input type=\"hidden\" name=\"title\" value=\"{!__TITLE_VALUE!}\" />
260 <input type=\"hidden\" name=\"slogan\" value=\"{!__SLOGAN_VALUE!}\" />
261 <input type=\"hidden\" name=\"email\" value=\"{!__EMAIL_VALUE!}\" />
262 <input type=\"hidden\" name=\"smtp_host\" value=\"{!__SMTP_HOST!}\" />
263 <input type=\"hidden\" name=\"smtp_user\" value=\"{!__SMTP_USER!}\" />
264 <input type=\"hidden\" name=\"smtp_pass\" value=\"{!__SMTP_PASS!}\" />
265 <input type=\"submit\" class=\"admin_submit submit\" name=\"finalize\" value=\"{--NEXT_PAGE--}\" class=\"install_submit\" />
268 <tr><td colspan=\"2\" height=\"21\" class=\"seperator\"> </td></tr>
273 case "finalize": // Write captured data to files
274 if ((REQUEST_ISSET_POST(('finalize'))) && (!isInstalled())) {
275 // You have submitted data then we have to reset the SQLs
278 // Connect to MySQL server
279 SQL_CONNECT($mysql['host'], $mysql['login'], $mysql['pass1'], __FILE__, __LINE__);
280 if (SQL_IS_LINK_UP()) {
281 // Seems to work, also right database?
282 if (SQL_SELECT_DB($mysql['dbase'], __FILE__, __LINE__) === true) {
283 // Automatically run install.sql
284 if ((FILE_READABLE(REQUEST_POST('spath')."install/tables.sql")) && (FILE_READABLE(REQUEST_POST('spath')."install/menu-".GET_LANGUAGE().".sql"))) {
285 // Both exists so import them
286 foreach (array("tables", "menu-".GET_LANGUAGE()) as $dump) {
287 // Should be save here because file_exists() is there but we check it again. :)
288 $FQFN = REQUEST_POST('spath') . "install/" . $dump . ".sql";
289 if (FILE_READABLE($FQFN)) {
291 $fileContent = READ_FILE($FQFN, true);
293 // Replace the {!prefix!} with actual one
294 while (strpos($fileContent, "{!prefix!}") !== false) {
295 $fileContent = str_replace("{!prefix!}", $mysql['prefix'], $fileContent);
298 // Replace the {!type!} with actual one
299 while (strpos($fileContent, "{!type!}") !== false) {
300 $fileContent = str_replace("{!type!}", $mysql['type'], $fileContent);
303 // And split it up against ;\n ...
304 SET_SQLS(merge_array(GET_SQLS(), explode(";\n", $fileContent)));
307 debug_report_bug(sprintf("SQL dump %s is not readable!", $dump));
311 // Are some SQLs found?
312 if (COUNT_SQLS() == 0) {
314 addFatalMessage(__FILE__, __LINE__, getMessage('INSTALL_SQL_IMPORT_FAILED'));
318 // Now run all queries through and try to keep out empty or comment queries
319 runFilterChain('run_sqls');
321 // Ok, all done. So we can write the config data to the php files
322 if (REQUEST_POST('spath') != constant('PATH')) changeDataInFile(REQUEST_POST('spath')."inc/config.php", "SERVER-PATH", "define('PATH', \"", "\");", REQUEST_POST('spath'), 0);
323 if (REQUEST_POST('burl') != constant('URL')) changeDataInFile(REQUEST_POST('spath')."inc/config.php", "HOST-URL", "define('URL', \"", "\");", REQUEST_POST('burl'), 0);
324 changeDataInFile(REQUEST_POST('spath')."inc/config.php", "MAIN_TITLE", "define('MAIN_TITLE', \"", "\");", REQUEST_POST('title'), 0);
325 changeDataInFile(REQUEST_POST('spath')."inc/config.php", "SLOGAN", "define('SLOGAN', \"", "\");", REQUEST_POST('slogan'), 0);
326 changeDataInFile(REQUEST_POST('spath')."inc/config.php", "WEBMASTER", "define('WEBMASTER', \"", "\");", REQUEST_POST('email'), 0);
327 changeDataInFile(REQUEST_POST('spath')."inc/config.php", "NULLPASS-WARNING", "define('warn_no_pass', ", ");", REQUEST_POST('warn_no_pass'), 0);
328 changeDataInFile(REQUEST_POST('spath')."inc/config.php", "WRITE-FOOTER", "define('WRITE_FOOTER', ", ");", REQUEST_POST('wfooter'), 0);
329 changeDataInFile(REQUEST_POST('spath')."inc/config.php", "BACKLINK", "define('ENABLE_BACKLINK', ", ");", REQUEST_POST('blink'), 0);
330 // DEACTIVATED: changeDataInFile(REQUEST_POST('spath')."inc/config.php", "OUTPUT-MODE", "define('OUTPUT_MODE', \"", "\");", REQUEST_POST('omode'), 0);
331 changeDataInFile(REQUEST_POST('spath')."inc/config.php", "MYSQL-HOST", " 'host' => \"", "\",", $mysql['host'], 0);
332 changeDataInFile(REQUEST_POST('spath')."inc/config.php", "MYSQL-DBASE", " 'dbase' => \"", "\",", $mysql['dbase'], 0);
333 changeDataInFile(REQUEST_POST('spath')."inc/config.php", "MYSQL-LOGIN", " 'login' => \"", "\",", $mysql['login'], 0);
334 changeDataInFile(REQUEST_POST('spath')."inc/config.php", "MYSQL-PASSWORD", " 'password' => \"", "\",", $mysql['pass1'], 0);
335 changeDataInFile(REQUEST_POST('spath')."inc/config.php", "MYSQL-PREFIX", "define('_MYSQL_PREFIX', \"", "\");", $mysql['prefix'], 0);
336 changeDataInFile(REQUEST_POST('spath')."inc/config.php", "TABLE-TYPE", "define('_TABLE_TYPE', \"", "\");", $mysql['type'], 0);
337 changeDataInFile(REQUEST_POST('spath')."inc/config.php", "SMTP-HOSTNAME", "define('SMTP_HOSTNAME', \"", "\");", REQUEST_POST('smtp_host'), 0);
338 changeDataInFile(REQUEST_POST('spath')."inc/config.php", "SMTP-USER", "define('SMTP_USER', \"", "\");", REQUEST_POST('smtp_user'), 0);
339 changeDataInFile(REQUEST_POST('spath')."inc/config.php", "SMTP-PASSWORD", "define('SMTP_PASSWORD', \"", "\");", REQUEST_POST('smtp_pass1'), 0);
340 changeDataInFile(REQUEST_POST('spath')."inc/config.php", "INSTALLED", "define('mxchange_installed', ", ");", "true", 0);
342 // Installation area not found!
343 addFatalMessage(__FILE__, __LINE__, getMessage('INSTALL_MISSING_DUMPS'));
348 if (getTotalFatalErrors() > 0) {
350 foreach (getFatalArray() as $value) {
351 $OUT .= " <li>".$value."</li>\n";
353 define('__FATAL_ERROR_LI', $OUT);
355 foreach ($mysql as $key => $value) {
356 $OUT .= " <input type=\"hidden\" name=\"mysql[".$key."]\" value=\"".$value."\">\n";
358 define('__MYSQL_DATA' , $OUT);
359 define('__SPATH_VALUE' , REQUEST_POST('spath'));
360 define('__BURL_VALUE' , REQUEST_POST('burl'));
361 define('__TITLE_VALUE' , REQUEST_POST('title'));
362 define('__SMTP_HOST' , REQUEST_POST('smtp_host'));
363 define('__SMTP_USER' , REQUEST_POST('smtp_user'));
364 define('__SMTP_PASS' , REQUEST_POST('smtp_pass1'));
367 LOAD_TEMPLATE("install_fatal_errors");
369 // Installation is done!
370 LOAD_URL("install.php?page=finalize");
372 } elseif (isInstalled()) {
373 // Redirection after writing data... :-)
374 LOAD_TEMPLATE("install_finished");
376 // Something goes wrong during installation! :-(
377 addFatalMessage(__FILE__, __LINE__, getMessage('INSTALL_FINALIZER_FAILED'));
378 LOAD_INC("inc/fatal_errors.php");
383 DEBUG_LOG(__FILE__, __LINE__, sprintf("Wrong page %s detected", REQUEST_GET('page')));
384 OUTPUT_HTML(" <div class=\"install_error\">{--WRONG_PAGE--}</strong>");
388 // Already installed!
389 addFatalMessage(__FILE__, __LINE__, getMessage('ALREADY_INSTALLED'));