- OUTPUT_HTML("</span><br />");
- }
- define('__MYSQL_HOST' , $mysql['host']);
- define('__MYSQL_DBASE' , $mysql['dbase']);
- define('__MYSQL_PREFIX', $mysql['prefix']);
- define('__TABLE_TYPE' , $mysql['type']);
- define('__MYSQL_LOGIN' , $mysql['login']);
- define('__SPATH_VALUE' , REQUEST_POST('spath'));
- define('__BURL_VALUE' , REQUEST_POST('burl'));
- define('__TITLE_VALUE' , REQUEST_POST('title'));
- define('__SLOGAN_VALUE', REQUEST_POST('slogan'));
- define('__EMAIL_VALUE' , REQUEST_POST('email'));
-
- // Load template
- LOAD_TEMPLATE('install_page2');
- break;
-
- case '3':
- // Set more values
- define('__SPATH_VALUE' , REQUEST_POST('spath'));
- define('__BURL_VALUE' , REQUEST_POST('burl'));
- define('__TITLE_VALUE' , REQUEST_POST('title'));
- define('__SLOGAN_VALUE', REQUEST_POST('slogan'));
- define('__EMAIL_VALUE' , REQUEST_POST('email'));
-
- // Use default SMTP data
- $smtpHost = getConfig('SMTP_HOSTNAME');
- $smtpUser = getConfig('SMTP_USER');
- $smtpPass1 = getConfig('SMTP_PASSWORD');
- $smtpPass2 = getConfig('SMTP_PASSWORD');
-
- // Overwrite it with the data from sent (failed) form
- if (REQUEST_ISSET_POST(('smtp_host'))) $smtpHost = REQUEST_POST('smtp_host');
- if (REQUEST_ISSET_POST(('smtp_user'))) $smtpUser = REQUEST_POST('smtp_user');
- if (REQUEST_ISSET_POST(('smtp_pass'))) {
- $smtpPass1 = REQUEST_POST('smtp_pass');
- $smtpPass2 = REQUEST_POST('smtp_pass');
- } // END - if
-
- // MySQL settings
- define('__MYSQL_HOST' , $mysql['host']);
- define('__MYSQL_DBASE' , $mysql['dbase']);
- define('__MYSQL_PREFIX', $mysql['prefix']);
- define('__TABLE_TYPE' , $mysql['type']);
- define('__MYSQL_LOGIN' , $mysql['login']);
- define('__MYSQL_PASS1' , $mysql['pass1']);
- define('__MYSQL_PASS2' , $mysql['pass2']);
-
- // Set constants for SMTP data
- define('__SMTP_HOST' , $smtpHost);
- define('__SMTP_USER' , $smtpUser);
- define('__SMTP_PASS1', $smtpPass1);
- define('__SMTP_PASS2', $smtpPass2);
-
- // Load template
- LOAD_TEMPLATE('install_page3');
- break;
-
- case '5': // Misc settings
- // General settings
- define('__SPATH_VALUE' , REQUEST_POST('spath'));
- define('__BURL_VALUE' , REQUEST_POST('burl'));
- define('__TITLE_VALUE' , REQUEST_POST('title'));
- define('__SLOGAN_VALUE', REQUEST_POST('slogan'));
- define('__EMAIL_VALUE' , REQUEST_POST('email'));
-
- // MySQL settings
- define('__MYSQL_HOST' , $mysql['host']);
- define('__MYSQL_DBASE' , $mysql['dbase']);
- define('__MYSQL_PREFIX', $mysql['prefix']);
- define('__TABLE_TYPE' , $mysql['type']);
- define('__MYSQL_LOGIN' , $mysql['login']);
-
- // SMTP settings
- define('__SMTP_HOST', REQUEST_POST('smtp_host'));
- define('__SMTP_USER', REQUEST_POST('smtp_user'));
- define('__SMTP_PASS', REQUEST_POST('smtp_pass1'));
- OUTPUT_HTML("<form action=\"{!__BURL_ACTION!}/install.php?page=finalize\" method=\"POST\" target=\"_self\">
-<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" class=\"install_main\">
-<tr>
- <td colspan=\"2\" align=\"center\">
- <div class=\"install\">{--HEADER_TEXT_PAGE5--}</strong>
- </td>
-</tr>
-<tr><td colspan=\"2\" height=\"21\" class=\"seperator\"> </td></tr>
-<tr>
- <td colspan=\"2\"><span class=\"install_text\">
- {--TEXT_PAGE_5--}
- </span></td>
-</tr>
-<tr><td colspan=\"2\" height=\"21\" class=\"seperator\"> </td></tr>
-<tr>
- <td class=\"install\" align=\"right\">{--LANG_OUTPUT_MODE--}: </td>
- <td>
- <select name=\"omode\" size=\"1\" class=\"install_select\">
- <option value=\"render\">{--MODE_RENDER--}</option>
- <option value=\"direct\">{--MODE_DIRECT--}</option>
- </select>
- </td>
-</tr>
-<tr><td colspan=\"2\" height=\"10\" class=\"seperator\"> </td></tr>
-<tr>
- <td class=\"install\" align=\"right\">{--WARN_NO_PASSWORD--}: </td>
- <td>
- <select name=\"warn_no_pass\" size=\"1\" class=\"install_select\">
- <option value=\"Y\">{--YES--}</option>
- <option value=\"N\">{--NO--}</option>
- </select>
- </td>
-</tr>
-<tr><td colspan=\"2\" height=\"10\" class=\"seperator\"> </td></tr>
-<tr>
- <td class=\"install\" align=\"right\">{--LANG_WRITE_FOOTER--}: </td>
- <td>
- <select name=\"wfooter\" size=\"1\" class=\"install_select\">
- <option value=\"Y\">{--YES--}</option>
- <option value=\"N\">{--NO--}</option>
- </select>
- </td>
-</tr>
-<tr><td colspan=\"2\" height=\"10\" class=\"seperator\"> </td></tr>
-<tr>
- <td class=\"install\" align=\"right\">{--INSTALL_ENABLE_BACKLINK--}: </td>
- <td>
- <select name=\"blink\" size=\"1\" class=\"install_select\">
- <option value=\"Y\">{--YES--}</option>
- <option value=\"N\">{--NO--}</option>
- </select>
- </td>
-</tr>
-<tr><td colspan=\"2\" height=\"21\" class=\"seperator\"> </td></tr>
-<tr>
- <td colspan=\"2\" align=\"center\">");
- foreach ($mysql as $key => $value) {
- OUTPUT_HTML(" <input type=\"hidden\" name=\"mysql[".$key."]\" value=\"".$value."\" />");
- }
- OUTPUT_HTML(" <input type=\"hidden\" name=\"spath\" value=\"{!__SPATH_VALUE!}\" />
- <input type=\"hidden\" name=\"burl\" value=\"{!__BURL_VALUE!}\" />
- <input type=\"hidden\" name=\"title\" value=\"{!__TITLE_VALUE!}\" />
- <input type=\"hidden\" name=\"slogan\" value=\"{!__SLOGAN_VALUE!}\" />
- <input type=\"hidden\" name=\"email\" value=\"{!__EMAIL_VALUE!}\" />
- <input type=\"hidden\" name=\"smtp_host\" value=\"{!__SMTP_HOST!}\" />
- <input type=\"hidden\" name=\"smtp_user\" value=\"{!__SMTP_USER!}\" />
- <input type=\"hidden\" name=\"smtp_pass\" value=\"{!__SMTP_PASS!}\" />
- <input type=\"submit\" class=\"admin_submit submit\" name=\"finalize\" value=\"{--NEXT_PAGE--}\" class=\"install_submit\" />
- </td>
-</tr>
-<tr><td colspan=\"2\" height=\"21\" class=\"seperator\"> </td></tr>
-</table>
-</form>");
- break;
-
- case 'finalize': // Write captured data to files
- if ((REQUEST_ISSET_POST(('finalize'))) && (!isInstalled())) {
- // You have submitted data then we have to reset the SQLs
- INIT_SQLS();
-
- // Connect to MySQL server
- SQL_CONNECT($mysql['host'], $mysql['login'], $mysql['pass1'], __FILE__, __LINE__);
- if (SQL_IS_LINK_UP()) {
- // Seems to work, also right database?
- if (SQL_SELECT_DB($mysql['dbase'], __FILE__, __LINE__) === true) {
- // Automatically run install.sql
- if ((isFileReadable(REQUEST_POST('spath') . 'install/tables.sql')) && (isFileReadable(REQUEST_POST('spath') . 'install/menu-'.getLanguage().'.sql'))) {
- // Both exists so import them
- foreach (array('tables', 'menu-'.getLanguage()) as $dump) {
- // Should be save here because file_exists() is there but we check it again. :)
- $FQFN = REQUEST_POST('spath') . 'install/' . $dump . '.sql';
-
- // Is the file readable?
- if (isFileReadable($FQFN)) {
- // Read the file
- $fileContent = readFromFile($FQFN, true);
-
- // Replace the {!prefix/type!} with actual one
- foreach (array('prefix', 'type') as $replace) {
- while (strpos($fileContent, '{!' . $replace . '!}') !== false) {
- $fileContent = str_replace('{!' . $replace . '!}', $mysql[$replace], $fileContent);
- } // END - while
- } // END - foreach
-
- // Split it up against ";\n" and merge it into existing SQLs
- MERGE_SQLS(explode(";\n", $fileContent));
- } else {
- // Not readable!
- debug_report_bug(sprintf("SQL dump %s is not readable!", $dump));
- }
- } // END - foreach
-
- // Are some SQLs found?
- if (COUNT_SQLS() == 0) {
- // Abort here
- addFatalMessage(__FILE__, __LINE__, getMessage('INSTALL_SQL_IMPORT_FAILED'));
- return;