Файл: qa-include/qa-install.php
Строк: 444
<?php
/*
Question2Answer (c) Gideon Greenspan
http://www.question2answer.org/
File: qa-include/qa-install.php
Version: See define()s at top of qa-include/qa-base.php
Description: User interface for installing, upgrading and fixing the database
This program is free software; you can redistribute it and/or
modify it under the terms of the GNU General Public License
as published by the Free Software Foundation; either version 2
of the License, or (at your option) any later version.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
More about this license: http://www.question2answer.org/license.php
*/
if (!defined('QA_VERSION')) { // don't allow this page to be requested directly from browser
header('Location: ../');
exit;
}
require_once QA_INCLUDE_DIR.'qa-db-install.php';
qa_report_process_stage('init_install');
// Output start of HTML early, so we can see a nicely-formatted list of database queries when upgrading
?>
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-type" CONTENT="text/html; charset=utf-8">
<STYLE type="text/css">
body,input {font-size:16px; font-family:Verdana, Arial, Helvetica, sans-serif;}
body {text-align:center; width:640px; margin:64px auto;}
table {margin: 16px auto;}
</STYLE>
</HEAD>
<BODY>
<?php
// Define database failure handler for install process, if not defined already (file could be included more than once)
if (!function_exists('qa_install_db_fail_handler')) {
function qa_install_db_fail_handler($type, $errno=null, $error=null, $query=null)
/*
Handler function for database failures during the installation process
*/
{
global $pass_failure_from_install;
$pass_failure_type=$type;
$pass_failure_errno=$errno;
$pass_failure_error=$error;
$pass_failure_query=$query;
$pass_failure_from_install=true;
require QA_INCLUDE_DIR.'qa-install.php';
qa_exit('error');
}
}
$success='';
$errorhtml='';
$suggest='';
$buttons=array();
$fields=array();
$fielderrors=array();
$hidden=array();
if (isset($pass_failure_type)) { // this page was requested due to query failure, via the fail handler
switch ($pass_failure_type) {
case 'connect':
$errorhtml.='Could not establish database connection. Please check the username, password and hostname in the config file, and if necessary set up the appropriate MySQL user and privileges.';
break;
case 'select':
$errorhtml.='Could not switch to the Question2Answer database. Please check the database name in the config file, and if necessary create the database in MySQL and grant appropriate user privileges.';
break;
case 'query':
global $pass_failure_from_install;
if (@$pass_failure_from_install)
$errorhtml.="Question2Answer was unable to perform the installation query below. Please check the user in the config file has CREATE and ALTER permissions:nn";
else
$errorhtml.="Question2Answer query failed:nn";
$errorhtml.=qa_html($pass_failure_query."nnError ".$pass_failure_errno.": ".$pass_failure_error."nn");
break;
}
} else { // this page was requested by user GET/POST, so handle any incoming clicks on buttons
qa_db_connect('qa_install_db_fail_handler');
if (qa_clicked('create')) {
qa_db_install_tables();
if (QA_FINAL_EXTERNAL_USERS) {
if (defined('QA_FINAL_WORDPRESS_INTEGRATE_PATH')) {
require_once QA_INCLUDE_DIR.'qa-db-admin.php';
require_once QA_INCLUDE_DIR.'qa-app-format.php';
qa_db_page_move(qa_db_page_create(get_option('blogname'), QA_PAGE_FLAGS_EXTERNAL, get_option('home'), null, null, null), 'O', 1);
// create link back to WordPress home page
$success.='Your Question2Answer database has been created and integrated with your WordPress site.';
} else
$success.='Your Question2Answer database has been created for external user identity management. Please read the online documentation to complete integration.';
} else
$success.='Your Question2Answer database has been created.';
}
if (qa_clicked('nonuser')) {
qa_db_install_tables();
$success.='The additional Question2Answer database tables have been created.';
}
if (qa_clicked('upgrade')) {
qa_db_upgrade_tables();
$success.='Your Question2Answer database has been updated.';
}
if (qa_clicked('repair')) {
qa_db_install_tables();
$success.='The Question2Answer database tables have been repaired.';
}
if (qa_clicked('module')) {
$moduletype=qa_post_text('moduletype');
$modulename=qa_post_text('modulename');
$module=qa_load_module($moduletype, $modulename);
$queries=$module->init_queries(qa_db_list_tables_lc());
if (!empty($queries)) {
if (!is_array($queries))
$queries=array($queries);
foreach ($queries as $query)
qa_db_upgrade_query($query);
}
$success.='The '.$modulename.' '.$moduletype.' module has completed database initialization.';
}
if (qa_clicked('super')) {
require_once QA_INCLUDE_DIR.'qa-db-users.php';
require_once QA_INCLUDE_DIR.'qa-app-users-edit.php';
$inemail=qa_post_text('email');
$inpassword=qa_post_text('password');
$inhandle=qa_post_text('handle');
$fielderrors=array_merge(
qa_handle_email_filter($inhandle, $inemail),
qa_password_validate($inpassword)
);
if (empty($fielderrors)) {
require_once QA_INCLUDE_DIR.'qa-app-users.php';
$userid=qa_create_new_user($inemail, $inpassword, $inhandle, QA_USER_LEVEL_SUPER);
qa_set_logged_in_user($userid, $inhandle);
qa_set_option('feedback_email', $inemail);
$success.="Congratulations - Your Question2Answer site is ready to go!nnYou are logged in as the super administrator and can start changing settings.nnThank you for installing Question2Answer.";
}
}
}
if (is_resource(qa_db_connection(false)) && !@$pass_failure_from_install) {
$check=qa_db_check_tables(); // see where the database is at
switch ($check) {
case 'none':
if (@$pass_failure_errno==1146) // don't show error if we're in installation process
$errorhtml='';
$errorhtml.='Welcome to Question2Answer. It's time to set up your database!';
if (QA_FINAL_EXTERNAL_USERS) {
if (defined('QA_FINAL_WORDPRESS_INTEGRATE_PATH'))
$errorhtml.="nnWhen you click below, your Question2Answer site will be set up to integrate with the users of your WordPress site <A HREF="".qa_html(get_option('home'))."" TARGET="_blank">".qa_html(get_option('blogname'))."</A>. Please consult the online documentation for more information.";
else
$errorhtml.="nnWhen you click below, your Question2Answer site will be set up to integrate with your existing user database and management. Users will be referenced with database column type ".qa_html(qa_get_mysql_user_column_type()).". Please consult the online documentation for more information.";
$buttons=array('create' => 'Create Database');
} else {
$errorhtml.="nnWhen you click below, your Question2Answer database will be set up to manage user identities and logins internally.nnIf you want to offer a single sign-on for an existing user base or website, please consult the online documentation before proceeding.";
$buttons=array('create' => 'Create Database including User Management');
}
break;
case 'old-version':
if (!@$pass_failure_from_install)
$errorhtml=''; // don't show error if we need to upgrade
$errorhtml.='Your Question2Answer database needs to be upgraded for this version of the software.'; // don't show error before this
$buttons=array('upgrade' => 'Upgrade Database');
break;
case 'non-users-missing':
$errorhtml='This Question2Answer site is sharing its users with another Q2A site, but it needs some additional database tables for its own content. Please click below to create them.';
$buttons=array('nonuser' => 'Create Tables');
break;
case 'table-missing':
$errorhtml.='One or more tables are missing from your Question2Answer database.';
$buttons=array('repair' => 'Repair Database');
break;
case 'column-missing':
$errorhtml.='One or more Question2Answer database tables are missing a column.';
$buttons=array('repair' => 'Repair Database');
break;
default:
require_once QA_INCLUDE_DIR.'qa-db-admin.php';
if ( (!QA_FINAL_EXTERNAL_USERS) && (qa_db_count_users()==0) ) {
$errorhtml.="There are currently no users in the Question2Answer database.nnPlease enter your details below to create the super administrator:";
$fields=array('handle' => 'Username:', 'password' => 'Password:', 'email' => 'Email address:');
$buttons=array('super' => 'Create Super Administrator');
} else {
$tables=qa_db_list_tables_lc();
$moduletypes=qa_list_module_types();
foreach ($moduletypes as $moduletype) {
$modules=qa_load_modules_with($moduletype, 'init_queries');
foreach ($modules as $modulename => $module) {
$queries=$module->init_queries($tables);
if (!empty($queries)) { // also allows single query to be returned
$errorhtml=strtr(qa_lang_html('admin/module_x_database_init'), array(
'^1' => qa_html($modulename),
'^2' => qa_html($moduletype),
'^3' => '',
'^4' => '',
));
$buttons=array('module' => 'Initialize Database');
$hidden['moduletype']=$moduletype;
$hidden['modulename']=$modulename;
break;
}
}
}
}
break;
}
}
if (empty($errorhtml)) {
if (empty($success))
$success='Your Question2Answer database has been checked with no problems.';
$suggest='<A HREF="'.qa_path_html('admin', null, null, QA_URL_FORMAT_SAFEST).'">Go to admin center</A>';
}
?>
<FORM METHOD="POST" ACTION="<?php echo qa_path_html('install', null, null, QA_URL_FORMAT_SAFEST)?>">
<?php
if (strlen($success))
echo '<P><FONT COLOR="#006600">'.nl2br(qa_html($success)).'</FONT></P>'; // green
if (strlen($errorhtml))
echo '<P><FONT COLOR="#990000">'.nl2br($errorhtml).'</FONT></P>'; // red
if (strlen($suggest))
echo '<P>'.$suggest.'</P>';
// Very simple general form display logic (we don't use theme since it depends on tons of DB options)
if (count($fields)) {
echo '<TABLE>';
foreach ($fields as $name => $prompt) {
echo '<TR><TD>'.qa_html($prompt).'</TD><TD><INPUT TYPE="text" SIZE="24" NAME="'.qa_html($name).'" VALUE="'.qa_html(@${'in'.$name}).'"></TD>';
if (isset($fielderrors[$name]))
echo '<TD><FONT COLOR="#990000"><SMALL>'.qa_html($fielderrors[$name]).'</SMALL></FONT></TD>';
echo '</TR>';
}
echo '</TABLE>';
}
foreach ($buttons as $name => $value)
echo '<INPUT TYPE="submit" NAME="'.qa_html($name).'" VALUE="'.qa_html($value).'">';
foreach ($hidden as $name => $value)
echo '<INPUT TYPE="hidden" NAME="'.qa_html($name).'" VALUE="'.qa_html($value).'">';
qa_db_disconnect();
?>
</FORM>
</BODY>
</HTML>