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 (ereg(basename(__FILE__), $_SERVER['PHP_SELF']))
41 $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";
46 function install_WriteData ($file, $comment, $prefix, $suffix, $DATA, $sneak=0) {
47 $done = false; $sneak++;
48 if (file_exists($file)) {
49 $search = "CFG: ".$comment;
51 $fp = @fopen($file, 'r') or OUTPUT_HTML("<STRONG>READ:</STRONG> ".$file."<br />");
52 if (is_resource($fp)) {
53 $fp_tmp = @fopen($tmp, 'w') or OUTPUT_HTML("<STRONG>WRITE:</STRONG> ".$tmp."<br />");
54 if (is_resource($fp_tmp)) {
56 $line = fgets ($fp, 10240);
57 if (strpos($line, $search) > -1) $next = 0;
59 if ($next == $sneak) {
61 $line = $prefix.$DATA.$suffix."\n";
66 fputs($fp_tmp, $line);
69 // Finished writing tmp file
73 // Close source directory
76 if (($done) && (is_writeable($file))) {
77 // Copy back tmp file and delete tmp :-)
81 OUTPUT_HTML("<STRONG>TMP:</STRONG> UNDONE!");
85 OUTPUT_HTML("<STRONG>404:</STRONG> ".$file."<br />");
91 if (isset($_POST['mysql']) && is_array($_POST['mysql'])) $mysql = $_POST['mysql'];
93 if (URL != "http://your-server.com") {
94 // Already installed???
96 } elseif ($burl == "") {
98 $burl = "http://".$SERVER_NAME.$_SERVER['PHP_SELF'];
99 $burl = substr($burl, 0, strpos($burl, "install.php"));
102 // Check if both passwords from SMTP are matching
103 if ((isset($_GET['page']) && ($_GET['page'] == 5))) {
104 // Okay, we have to check it
105 if (!empty($_POST['smtp_user']) && (empty($_POST['smtp_host']))) {
107 OUTPUT_HTML(INSTALL_SMTP_HOSTNAME_EMPTY."<br />");
110 if ((empty($_POST['smtp_pass1'])) && (!empty($_POST['smtp_pass2']))) {
112 OUTPUT_HTML(INSTALL_SMTP_PASS1_EMPTY."<br />");
115 if ((!empty($_POST['smtp_pass1'])) && (empty($_POST['smtp_pass2']))) {
116 // Password repeat is empty
117 OUTPUT_HTML(INSTALL_SMTP_PASS2_EMPTY."<br />");
120 if ($_POST['smtp_pass1'] != $_POST['smtp_pass1']) {
121 // Passwords are not matching
122 OUTPUT_HTML(INSTALL_SMTP_PASS_MISMATCH."<br />");
127 // Is MXChange installed or no admin registered so far?
128 if ((!mxchange_installed) || (!admin_registered))
130 // Set URL for FORM actions
131 define('__BURL_ACTION', $burl);
133 // Output page for entered value
134 switch ($_GET['page'])
136 case "welcome": // Welcome to the installation!
137 LOAD_TEMPLATE("install_welcome");
140 case "1": // Server path, base URL
141 define('__PATH_LEN' , strlen(PATH));
142 define('__BURL_LEN' , strlen($burl));
143 define('__TITLE_LEN' , strlen(MAIN_TITLE));
144 define('__SLOGAN_LEN' , strlen(SLOGAN));
145 define('__WEBMASTER_LEN', (strlen(WEBMASTER) * 3));
148 LOAD_TEMPLATE("install_page1");
151 case "2": // MySQL data (alone!)
152 if (empty($mysql['dbase'])) $mysql['dbase'] = "your_database";
153 if (empty($mysql['login'])) $mysql['login'] = "your_login";
154 if (empty($mysql['host'])) $mysql['host'] = "localhost";
155 if (empty($mysql['prefix'])) $mysql['prefix'] = "mxchange_";
156 if ((sizeof($FATAL) > 0) || (!empty($FATAL[0]))) {
157 OUTPUT_HTML("<SPAN class=\"install_fatal\">");
158 foreach ($FATAL as $key=>$err) {
159 OUTPUT_HTML(" <STRONG>·</STRONG> ".FATAL_NO.($key + 1).": ".$err."<br />");
161 OUTPUT_HTML("</SPAN><br />");
163 define('__MYSQL_HOST' , $mysql['host']);
164 define('__MYSQL_DBASE' , $mysql['dbase']);
165 define('__MYSQL_PREFIX', $mysql['prefix']);
166 define('__MYSQL_LOGIN' , $mysql['login']);
167 define('__SPATH_VALUE' , $_POST['spath']);
168 define('__BURL_VALUE' , $_POST['burl']);
169 define('__TITLE_VALUE' , $_POST['title']);
170 define('__SLOGAN_VALUE', $_POST['slogan']);
171 define('__EMAIL_VALUE' , $_POST['email']);
174 LOAD_TEMPLATE("install_page2");
179 define('__SPATH_VALUE' , $_POST['spath']);
180 define('__BURL_VALUE' , $_POST['burl']);
181 define('__TITLE_VALUE' , $_POST['title']);
182 define('__SLOGAN_VALUE' , $_POST['slogan']);
183 define('__EMAIL_VALUE' , $_POST['email']);
185 // Use default SMTP data
186 $smtpHost = SMTP_HOSTNAME;
187 $smtpUser = SMTP_USER;
188 $smtpPass1 = SMTP_PASSWORD;
189 $smtpPass2 = SMTP_PASSWORD;
191 // Overwrite it with the data from sent (failed) form
192 if (!empty($_POST['smtp_host'])) $smtpHost = $_POST['smtp_host'];
193 if (!empty($_POST['smtp_user'])) $smtpUser = $_POST['smtp_user'];
196 define('__MYSQL_HOST' , $mysql['host']);
197 define('__MYSQL_DBASE' , $mysql['dbase']);
198 define('__MYSQL_PREFIX' , $mysql['prefix']);
199 define('__MYSQL_LOGIN' , $mysql['login']);
200 define('__MYSQL_PASS1' , $mysql['pass1']);
201 define('__MYSQL_PASS2' , $mysql['pass2']);
203 // Set constants for SMTP data
204 define('__SMTP_HOST' , $smtpHost);
205 define('__SMTP_USER' , $smtpUser);
206 define('__SMTP_PASS1' , $smtpPass1);
207 define('__SMTP_PASS2' , $smtpPass2);
210 LOAD_TEMPLATE("install_page3");
213 case "5": // Misc settings
215 define('__SPATH_VALUE' , $_POST['spath']);
216 define('__BURL_VALUE' , $_POST['burl']);
217 define('__TITLE_VALUE' , $_POST['title']);
218 define('__SLOGAN_VALUE' , $_POST['slogan']);
219 define('__EMAIL_VALUE' , $_POST['email']);
222 define('__MYSQL_HOST' , $mysql['host']);
223 define('__MYSQL_DBASE' , $mysql['dbase']);
224 define('__MYSQL_PREFIX' , $mysql['prefix']);
225 define('__MYSQL_LOGIN' , $mysql['login']);
228 define('__SMTP_HOST' , $_POST['smtp_host']);
229 define('__SMTP_USER' , $_POST['smtp_user']);
230 define('__SMTP_PASS' , $_POST['smtp_pass1']);
231 OUTPUT_HTML("<FORM action=\"".__BURL_ACTION."/install.php?page=finalize\" method=\"POST\" target=\"_self\">
232 <TABLE border=\"0\" cellspacing=\"0\" cellpadding=\"0\" class=\"install_content\">
234 <TD colspan=\"2\" align=\"center\">
235 <STRONG class=\"install\">".HEADER_TEXT_PAGE5."</STRONG>
238 <TR><TD colspan=\"2\" height=\"21\" class=\"seperator\"> </TD></TR>
240 <TD colspan=\"2\"><SPAN class=\"install_intro\">
244 <TR><TD colspan=\"2\" height=\"21\" class=\"seperator\"> </TD></TR>
246 <TD class=\"install\" align=\"right\">".LANG_OUTPUT_MODE.": </TD>
248 <SELECT name=\"omode\" size=\"1\" class=\"install_select\">
249 <OPTION value=\"render\"");
250 if (OUTPUT_MODE == "render") OUTPUT_HTML(" selected=\"selected\"");
251 OUTPUT_HTML(">".MODE_RENDER."</OPTION>
252 <OPTION value=\"direct\"");
253 if (OUTPUT_MODE == "direct") OUTPUT_HTML(" selected=\"selected\"");
254 OUTPUT_HTML(">".MODE_DIRECT."</OPTION>
258 <TR><TD colspan=\"2\" height=\"10\" class=\"seperator\"> </TD></TR>
260 <TD class=\"install\" align=\"right\">".WARN_NO_PASSWORD.": </TD>
262 <SELECT name=\"warn_no_pass\" size=\"1\" class=\"install_select\">
263 <OPTION value=\"true\"");
264 if (warn_no_pass) OUTPUT_HTML(" selected=\"selected\"");
265 OUTPUT_HTML(">".YES."</OPTION>
266 <OPTION value=\"false\"");
267 if (!warn_no_pass) OUTPUT_HTML(" selected=\"selected\"");
268 OUTPUT_HTML(">".NO."</OPTION>
272 <TR><TD colspan=\"2\" height=\"10\" class=\"seperator\"> </TD></TR>
274 <TD class=\"install\" align=\"right\">".LANG_WRITE_FOOTER.": </TD>
276 <SELECT name=\"wfooter\" size=\"1\" class=\"install_select\">
277 <OPTION value=\"true\"");
278 if (WRITE_FOOTER) OUTPUT_HTML(" selected=\"selected\"");
279 OUTPUT_HTML(">".YES."</OPTION>
280 <OPTION value=\"false\"");
281 if (!WRITE_FOOTER) OUTPUT_HTML(" selected=\"selected\"");
282 OUTPUT_HTML(">".NO."</OPTION>
286 <TR><TD colspan=\"2\" height=\"10\" class=\"seperator\"> </TD></TR>
288 <TD class=\"install\" align=\"right\">".INSTALL_ENABLE_BACKLINK.": </TD>
290 <SELECT name=\"blink\" size=\"1\" class=\"install_select\">
291 <OPTION value=\"true\"");
292 if (ENABLE_BACKLINK) OUTPUT_HTML(" selected=\"selected\"");
293 OUTPUT_HTML(">".YES."</OPTION>
294 <OPTION value=\"false\"");
295 if (!ENABLE_BACKLINK) OUTPUT_HTML(" selected=\"selected\"");
296 OUTPUT_HTML(">".NO."</OPTION>
300 <TR><TD colspan=\"2\" height=\"21\" class=\"seperator\"> </TD></TR>
302 <TD colspan=\"2\" align=\"center\">");
303 foreach ($mysql as $key=>$value) {
304 OUTPUT_HTML(" <INPUT type=\"hidden\" name=\"mysql[".$key."]\" value=\"".$value."\">");
306 OUTPUT_HTML(" <INPUT type=\"hidden\" name=\"spath\" value=\"".__SPATH_VALUE."\">
307 <INPUT type=\"hidden\" name=\"burl\" value=\"".__BURL_VALUE."\">
308 <INPUT type=\"hidden\" name=\"title\" value=\"".__TITLE_VALUE."\">
309 <INPUT type=\"hidden\" name=\"slogan\" value=\"".__SLOGAN_VALUE."\">
310 <INPUT type=\"hidden\" name=\"email\" value=\"".__EMAIL_VALUE."\">
311 <INPUT type=\"hidden\" name=\"smtp_host\" value=\"".__SMTP_HOST."\">
312 <INPUT type=\"hidden\" name=\"smtp_user\" value=\"".__SMTP_USER."\">
313 <INPUT type=\"hidden\" name=\"smtp_pass\" value=\"".__SMTP_PASS."\">
314 <INPUT type=\"submit\" class=\"admin_submit submit\" name=\"finalize\" value=\"".NEXT_PAGE."\" class=\"install_submit\">
317 <TR><TD colspan=\"2\" height=\"21\" class=\"seperator\"> </TD></TR>
322 case "finalize": // Write captured data to files
323 if ((!empty($_POST['finalize'])) && (!mxchange_installed)) {
324 // You have submitted data then we have to reset the fatal messages
325 $FATAL = array(); $SQLs = array();
327 // Connect to MySQL server
328 $link = SQL_CONNECT($mysql['host'], $mysql['login'], $mysql['pass1'], __FILE__, __LINE__);
330 // Seems to work, also right database?
331 $db = SQL_SELECT_DB($mysql['dbase'], $link, __FILE__, __LINE__);
333 // Automatically run install.sql
334 if ((file_exists($_POST['spath']."install/tables.sql")) && (file_exists($_POST['spath']."install/menu-".GET_LANGUAGE().".sql"))) {
335 // Both exists so import them
336 foreach (array("tables.sql", "menu-".GET_LANGUAGE().".sql") as $dump) {
337 // Should be save here because file_exists() is there but we check it again. :)
338 $file = secureString($_POST['spath']) . "install/" . $dump;
339 if ((file_exists($file)) && (is_readable($file))) {
341 $sql = implode("", file($file));
343 // Remove some unwanted chars
344 $sql = str_replace("\r", "", $sql);
345 $sql = str_replace("\n\n", "\n", $sql);
347 // And split it up against ;\n ...
348 $SQLs = array_merge($SQLs, explode(";\n", $sql));
352 // Are some SQLs found?
353 if (count($SQLs) == 0) {
355 ADD_FATAL(INSTALL_SQL_IMPORT_FAILED);
359 // Now run all queries through and try to keep out empty or comment queries
360 foreach ($SQLs as $sql) {
364 // Is this query not empty and not a comment?
365 if ((!empty($sql)) && (substr($sql, 0, 2) != "--") && (substr($sql, 0, 1) != "#")) {
367 SQL_QUERY($sql, __FILE__, __LINE__);
371 // Ok, all done. So we can write the config data to the php files
372 if ($_POST['spath'] != PATH) install_WriteData($_POST['spath']."inc/config.php", "SERVER-PATH", "define ('PATH', \"", "\");", $_POST['spath'], 0);
373 if ($_POST['burl'] != URL) install_WriteData($_POST['spath']."inc/config.php", "HOST-URL", "define ('URL', \"", "\");", $_POST['burl'], 0);
374 install_WriteData($_POST['spath']."inc/config.php", "MAIN_TITLE", "define ('MAIN_TITLE', \"", "\");", $_POST['title'], 0);
375 install_WriteData($_POST['spath']."inc/config.php", "SLOGAN", "define ('SLOGAN', \"", "\");", $_POST['slogan'], 0);
376 install_WriteData($_POST['spath']."inc/config.php", "WEBMASTER", "define ('WEBMASTER', \"", "\");", $_POST['email'], 0);
377 install_WriteData($_POST['spath']."inc/config.php", "NULLPASS-WARNING", "define ('warn_no_pass', ", ");", $_POST['warn_no_pass'], 0);
378 install_WriteData($_POST['spath']."inc/config.php", "WRITE-FOOTER", "define ('WRITE_FOOTER', ", ");", $_POST['wfooter'], 0);
379 install_WriteData($_POST['spath']."inc/config.php", "BACKLINK", "define ('ENABLE_BACKLINK', ", ");", $_POST['blink'], 0);
380 // install_WriteData($_POST['spath']."inc/config.php", "OUTPUT-MODE", "define ('OUTPUT_MODE', \"", "\");", $_POST['omode'], 0);
381 install_WriteData($_POST['spath']."inc/config.php", "MYSQL-HOST", " 'host' => \"", "\",", $mysql['host'], 0);
382 install_WriteData($_POST['spath']."inc/config.php", "MYSQL-DBASE", " 'dbase' => \"", "\",", $mysql['dbase'], 0);
383 install_WriteData($_POST['spath']."inc/config.php", "MYSQL-LOGIN", " 'login' => \"", "\",", $mysql['login'], 0);
384 install_WriteData($_POST['spath']."inc/config.php", "MYSQL-PASSWORD", " 'password' => \"", "\",", $mysql['pass1'], 0);
385 install_WriteData($_POST['spath']."inc/config.php", "MYSQL-PREFIX", "define ('_MYSQL_PREFIX', \"", "\");", $mysql['prefix'], 0);
386 install_WriteData($_POST['spath']."inc/config.php", "SMTP-HOSTNAME", "define ('SMTP_HOSTNAME', \"", "\");", $_POST['smtp_host'], 0);
387 install_WriteData($_POST['spath']."inc/config.php", "SMTP-USER", "define ('SMTP_USER', \"", "\");", $_POST['smtp_user'], 0);
388 install_WriteData($_POST['spath']."inc/config.php", "SMTP-PASSWORD", "define ('SMTP_PASSWORD', \"", "\");", $_POST['smtp_pass'], 0);
389 install_WriteData($_POST['spath']."inc/config.php", "INSTALLED", "define ('mxchange_installed', ", ");", "true", 0);
392 SQL_CLOSE($link, __FILE__, __LINE__);
396 // Installation area not found!
397 ADD_FATAL(INSTALL_MISSING_DUMPS);
401 if ((sizeof($FATAL) > 0) || ($FATAL[0] != ""))
404 foreach ($FATAL as $value)
406 $OUT .= " <LI>".$value."</LI>\n";
408 define('__FATAL_ERROR_LI', $OUT);
410 foreach ($mysql as $key=>$value)
412 $OUT .= " <INPUT type=\"hidden\" name=\"mysql[".$key."]\" value=\"".$value."\">\n";
414 define('__MYSQL_DATA' , $OUT);
415 define('__SPATH_VALUE' , $_POST['spath']);
416 define('__BURL_VALUE' , $_POST['burl']);
417 define('__TITLE_VALUE' , $_POST['title']);
418 define('__SMTP_HOST' , $_POST['smtp_host']);
419 define('__SMTP_USER' , $_POST['smtp_user']);
420 define('__SMTP_PASS' , $_POST['smtp_pass']);
422 OUTPUT_HTML("<FORM action=\"".__BURL_ACTION."/install.php?page=2\" method=\"POST\">
423 <TABLE border=\"0\" cellspacing=\"0\" cellpadding=\"0\" class=\"install_content\">
425 <TD align=\"center\">
426 <STRONG class=\"install\">".HEADER_MYSQL_ERRORS."</STRONG>
429 <TR><TD colspan=\"2\" height=\"21\" class=\"seperator\"> </TD></TR>
431 <TD><SPAN class=\"install_intro\">
432 ".TEXT_MYSQL_ERRORS."
436 <TD align=\"center\"><STRONG>
441 <INPUT type=\"hidden\" name=\"spath\" value=\"".__SPATH_VALUE."\">
442 <INPUT type=\"hidden\" name=\"burl\" value=\"".__BURL_VALUE."\">
443 <INPUT type=\"hidden\" name=\"title\" value=\"".__TITLE_VALUE."\">
444 <INPUT type=\"submit\" class=\"admin_submit\" name=\"ok\" value=\"".RETURN_MYSQL_PAGE."\">
452 // Installation is done!
453 $URL = $burl."/install.php?page=finalize";
457 elseif (mxchange_installed)
459 // Redirection after writing data... :-)
460 LOAD_TEMPLATE("install_finished");
464 // Something goes wrong during installation! :-(
465 ADD_FATAL(INSTALL_FINALIZER_FAILED);
466 include ("inc/fatal_errors.php");
471 OUTPUT_HTML(" <STRONG class=\"install_error\">".WRONG_PAGE."</STRONG>");
477 ADD_FATAL(ALREADY_INSTALLED);