iSharkFly-Open/sourceforge-ossez
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
main
sourceforge-ossez/oss/vtiger/trunk/install/ConfirmConfig.php
T
YuCheng Hu ddbe02ba45 添加到 trunk 
+YUCHENG HU+

git-svn-id: https://svn.code.sf.net/p/hawebs/svn@140 a2543c7e-f6e9-4f8a-8bff-1ffc34733512
2010-06-12 07:16:50 +00:00

390 lines
20 KiB
PHP
Raw Permalink Blame History

<?php
/*+**********************************************************************************
* The contents of this file are subject to the vtiger CRM Public License Version 1.0
* ("License"); You may not use this file except in compliance with the License
* The Original Code is: vtiger CRM Open Source
* The Initial Developer of the Original Code is vtiger.
* Portions created by vtiger are Copyright (C) vtiger.
* All Rights Reserved.
************************************************************************************/
require_once('modules/Utilities/Currencies.php');
require_once('include/logging.php');
$log =& LoggerManager::getLogger('PLATFORM');
if (isset($_REQUEST['db_hostname'])) $db_hostname= $_REQUEST['db_hostname'];
if (isset($_REQUEST['db_username'])) $db_username= $_REQUEST['db_username'];
if (isset($_REQUEST['db_password'])) $db_password= $_REQUEST['db_password'];
if (isset($_REQUEST['db_name'])) $db_name= $_REQUEST['db_name'];
if (isset($_REQUEST['db_drop_tables'])) $db_drop_tables = $_REQUEST['db_drop_tables'];
if (isset($_REQUEST['site_URL'])) $site_URL= $_REQUEST['site_URL'];
if (isset($_REQUEST['admin_email'])) $admin_email= $_REQUEST['admin_email'];
if (isset($_REQUEST['admin_password'])) $admin_password = $_REQUEST['admin_password'];
if (isset($_REQUEST['standarduser_email'])) $standarduser_email= $_REQUEST['standarduser_email'];
if (isset($_REQUEST['standarduser_password'])) $standarduser_password = $_REQUEST['standarduser_password'];
if (isset($_REQUEST['currency_name'])) $currency_name = $_REQUEST['currency_name'];
//if (isset($_REQUEST['currency_symbol'])) $currency_symbol = $_REQUEST['currency_symbol'];
//if (isset($_REQUEST['currency_code'])) $currency_code = $_REQUEST['currency_code'];
if (isset($_REQUEST['cache_dir'])) $cache_dir= $_REQUEST['cache_dir'];
if (isset($_REQUEST['mail_server'])) $mail_server= $_REQUEST['mail_server'];
if (isset($_REQUEST['mail_server_username'])) $mail_server_username= $_REQUEST['mail_server_username'];
if (isset($_REQUEST['mail_server_password'])) $mail_server_password= $_REQUEST['mail_server_password'];
if (isset($_REQUEST['root_directory'])) $root_directory = $_REQUEST['root_directory'];
if (isset($_REQUEST['ftpserver'])) $ftpserver= $_REQUEST['ftpserver'];
if (isset($_REQUEST['ftpuser'])) $ftpuser = $_REQUEST['ftpuser'];
if (isset($_REQUEST['ftppassword'])) $ftppassword= $_REQUEST['ftppassword'];
if (isset($_REQUEST['db_type'])) $db_type = $_REQUEST['db_type'];
if (isset($_REQUEST['check_createdb'])) $check_createdb = $_REQUEST['check_createdb'];
if (isset($_REQUEST['root_user'])) $root_user = $_REQUEST['root_user'];
if (isset($_REQUEST['root_password'])) $root_password = $_REQUEST['root_password'];
if (isset($_REQUEST['create_utf8_db'])) $create_utf8_db = 'true';
if(isset($currency_name)){
$currency_code = $currencies[$currency_name][0];
$currency_symbol = $currencies[$currency_name][1];
}
$db_type_status = false; // is there a db type?
$db_server_status = false; // does the db server connection exist?
$db_creation_failed = false; // did we try to create a database and fail?
$db_exist_status = false; // does the database exist?
$db_utf8_support = false; // does the database support utf8?
$vt_charset = ''; // set it based on the database charset support
$next = false; // allow installation to continue
require_once('include/DatabaseUtil.php');
//Checking for database connection parameters
if($db_type)
{
include_once('adodb/adodb.inc.php');
$conn = &NewADOConnection($db_type);
$db_type_status = true;
if(@$conn->Connect($db_hostname,$db_username,$db_password))
{
$db_server_status = true;
if($db_type=='mysql')
{
$mysql_conn = mysql_connect($db_hostname,$db_username,$db_password);
$version = explode('-',mysql_get_server_info($mysql_conn));
$mysql_server_version=$version[0];
mysql_close($mysql_conn);
}
if(isset($_REQUEST['check_createdb']) && $_REQUEST['check_createdb'] == 'on')
{
$root_user = $_REQUEST['root_user'];
$root_password = $_REQUEST['root_password'];
// drop the current database if it exists
$dropdb_conn = &NewADOConnection($db_type);
if(@$dropdb_conn->Connect($db_hostname, $root_user, $root_password, $db_name))
{
$query = "drop database ".$db_name;
$dropdb_conn->Execute($query);
$dropdb_conn->Close();
}
// create the new database
$db_creation_failed = true;
$createdb_conn = &NewADOConnection($db_type);
if(@$createdb_conn->Connect($db_hostname, $root_user, $root_password)) {
$query = "create database ".$db_name;
// TODO: MySQL version less than 4.1.2 does not suppot UTF-8, a check here is required for it.
if($create_utf8_db == 'true') {
if($db_type=='mysql')
$query .= " default character set utf8 default collate utf8_general_ci";
$db_utf8_support = true;
}
if($createdb_conn->Execute($query)) {
$db_creation_failed = false;
}
$createdb_conn->Close();
}
}
// test the connection to the database
if(@$conn->Connect($db_hostname, $db_username, $db_password, $db_name))
{
$db_exist_status = true;
if(!$db_utf8_support) {
// Check if the database that we are going to use supports UTF-8
$db_utf8_support = check_db_utf8_support($conn);
}
}
$conn->Close();
}
}
// Update vtiger charset to use
$vt_charset = ($db_utf8_support)? "UTF-8" : "ISO-8859-1";
$error_msg = '';
$error_msg_info = '';
if(!$db_type_status || !$db_server_status)
{
$error_msg = 'Unable to connect to database Server. Invalid mySQL Connection Parameters specified';
$error_msg_info = 'This may be due to the following reasons:<br>
- specified database user, password, hostname, database type, or port is invalid. <a href="http://www.vtiger.com/products/crm/help/5.1.0/vtiger_CRM_Database_Hostname.pdf" target="_blank">More Information</a><BR>
- specified database user does not have access to connect to the database server from the host';
}
elseif($db_type == 'mysql' && $mysql_server_version < '4.1')
{
$error_msg = 'MySQL version '.$mysql_server_version.' is not supported, kindly connect to MySQL 4.1.x or above';
}
elseif($db_creation_failed)
{
$error_msg = 'Unable to Create Database '.$db_name;
$error_msg_info = 'Message: The database User "'. $root_user .'" doesn\'t have permission to Create database. Try changing the Database settings';
}
elseif(!$db_exist_status)
{
$error_msg = 'The Database "'.$db_name.'" is not found.Try changing the Database settings';
}
else
{
$next = true;
}
// Write the necessary information to platform.log
require_once('include/logging.php');
$log =& LoggerManager::getLogger('PLATFORM');
$info_style_start = '<div class="center"><table border="0" cellpadding="3" width="600"><tr class="h"><td><h1 class="p">';
$info_style_end = '</h1></td></tr></table></div>';
require_once('vtigerversion.php');
// Log Vtiger Version
if($patch_version !='')
{
$log->info($info_style_start . "Vtiger Version: " . $vtiger_current_version . " Patch " . $patch_version . $info_style_end);
}
else
{
$log->info($info_style_start . "Vtiger Version: " . $vtiger_current_version . $info_style_end);
}
// Log Mysql Server Version
$log->info($info_style_start . "Mysql Server Version: " . $mysql_server_version . $info_style_end);
ob_start();
phpinfo();
$php_info = ob_get_contents();
ob_end_clean();
// Log php_info
$log->info($php_info);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>vtiger CRM 5 - Configuration Wizard - Confirm Settings</title>
<link href="include/install/install.css" rel="stylesheet" type="text/css">
</head>
<body class="small cwPageBg" topmargin="0" leftmargin="0" marginheight="0" marginwidth="0">
<br>
<!-- Table for cfgwiz starts -->
<table border=0 cellspacing=0 cellpadding=0 width=80% align=center>
<tr>
<td class="cwHeadBg" align=left><img src="include/install/images/configwizard.gif" alt="Configuration Wizard" hspace="20" title="Configuration Wizard"></td>
<td class="cwHeadBg1" align=right><img src="include/install/images/vtigercrm5.gif" alt="vtiger CRM 5" title="vtiger CRM 5"></td>
<td class="cwHeadBg1" width=2%></td>
</tr>
</table>
<table border=0 cellspacing=0 cellpadding=0 width=80% align=center>
<tr>
<td background="include/install/images/topInnerShadow.gif" align=left><img height="10" src="include/install/images/topInnerShadow.gif" ></td>
</tr>
</table>
<table border=0 cellspacing=0 cellpadding=2 width=80% align=center>
<tr>
<td class="small" bgcolor="#4572BE" align=center>
<!-- Master display -->
<table border=0 cellspacing=0 cellpadding=0 width=97%>
<tr>
<td width=80% valign=top class="cwContentDisplay" align=center>
<table border=0 cellspacing=0 cellpadding=10 width=100%>
<tr><td class=small align=left colspan=2><img src="include/install/images/confWizConfirmSettings.gif" alt="Confirm Configuration Settings" title="Confirm Configuration Settings"><br>
<hr noshade size=1></td></tr>
<?php if($error_msg) : ?>
<tr>
<td align=left class="small" colspan=2 width=50% style="padding-left:10px">
<div style="background-color:#ff0000;color:#ffffff;padding:5px">
<b><?php echo $error_msg ?></b>
</div>
<?php if($error_msg_info) : ?>
<p><?php echo $error_msg_info ?><p>
<?php endif; ?>
</td>
</tr>
<?php endif; ?>
<tr>
<td align=left class="small" width=50% style="padding-left:10px">
<table width="100%" cellpadding="0" border="0" align=center class="level3" cellspacing="1">
<tr>
<td colspan=2><strong>Database Configuration</strong><hr noshade size=1></td>
</tr>
<tr>
<td noWrap width="40%">Database Type</td>
<td align="left" nowrap> <font class="dataInput"><i><?php if (isset($db_type)) echo "$db_type"; ?></i></font></td>
</tr>
<tr>
<td noWrap width="40%">Database Name</td>
<td align="left" nowrap> <font class="dataInput"><i><?php if (isset($db_name)) echo "$db_name"; ?></i></font></td>
</tr>
<tr>
<td noWrap width="40%">Database UTF-8 Support</td>
<td align="left" nowrap> <font class="dataInput"><?php echo ($db_utf8_support)? "Enabled" : "<strong style='color:#DF0000';>Not Enabled</strong>" ?></font>&nbsp;<a href="http://www.vtiger.com/products/crm/help/5.1.0/vtiger_CRM_Database_UTF8Config.pdf" target="_blank">More Information</a></td>
</tr>
</table>
</td>
<td align=left class="small" width=50% style="padding-left:10px">
<table width="100%" cellpadding="0" border="0" align=center class="level3" cellspacing="1">
<tr>
<td colspan=2 ><strong>Site Configuration</strong><hr noshade size=1></td>
</tr>
<tr>
<td width="40%">URL</td>
<td align="left"> <i><?php if (isset($site_URL)) echo $site_URL; ?></i></td>
</tr>
<tr>
<td width="40%">Default Charset</td>
<td align="left"> <i><?php if (isset($vt_charset)) echo $vt_charset; ?></i></td>
</tr>
<tr>
<td width="40%">Currency</td>
<td align="left"> <i><?php if (isset($currency_name)) echo $currency_name."(".$currencies[$currency_name][1].")"; ?></i></td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan=2>
<table width="100%" cellpadding="0" border="0" align=center class="level3" cellspacing="1">
<tr>
<td colspan=3 ><strong>User Configuration</strong><hr noshade size=1></td>
</tr>
<tr>
<td width="40%">Username</td>
<td align="left" width="30%"> <i>admin</i></td>
<td align="left" width="30%"> <i>standarduser</i></td>
</tr>
<tr>
<td width="40%">Email</td>
<td align="left" width="30%"> <i><?php if (isset($admin_email)) echo $admin_email; ?></i></td>
<td align="left" width="30%"> <i><?php if (isset($standarduser_email)) echo $standarduser_email; ?></i></td>
</tr>
</table>
<br>
<table width="100%" cellpadding="5" border="0" class="small" >
<tr>
<td align="left" valign="bottom">
<form action="install.php" method="post" name="form" id="form">
<input type="hidden" name="file" value="SetInstallationConfig.php">
<input type="hidden" class="dataInput" name="db_type" value="<?php if (isset($db_type)) echo "$db_type"; ?>" />
<input type="hidden" class="dataInput" name="db_hostname" value="<?php if (isset($db_hostname)) echo "$db_hostname"; ?>" />
<input type="hidden" class="dataInput" name="db_username" value="<?php if (isset($db_username)) echo "$db_username"; ?>" />
<input type="hidden" class="dataInput" name="db_password" value="<?php if (isset($db_password)) echo "$db_password"; ?>" />
<input type="hidden" class="dataInput" name="db_name" value="<?php if (isset($db_name)) echo "$db_name"; ?>" />
<input type="hidden" class="dataInput" name="db_drop_tables" value="<?php if (isset($db_drop_tables)) echo "$db_drop_tables"; ?>" />
<input type="hidden" class="dataInput" name="site_URL" value="<?php if (isset($site_URL)) echo "$site_URL"; ?>" />
<input type="hidden" class="dataInput" name="root_directory" value="<?php if (isset($root_directory)) echo "$root_directory"; ?>" />
<input type="hidden" class="dataInput" name="admin_email" value="<?php if (isset($admin_email)) echo "$admin_email"; ?>" />
<input type="hidden" class="dataInput" name="admin_password" value="<?php if (isset($admin_password)) echo "$admin_password"; ?>" />
<input type="hidden" class="dataInput" name="standarduser_email" value="<?php if (isset($standarduser_email)) echo "$standarduser_email"; ?>" />
<input type="hidden" class="dataInput" name="standarduser_password" value="<?php if (isset($standarduser_password)) echo "$standarduser_password"; ?>" />
<input type="hidden" class="dataInput" name="currency_name" value="<?php if (isset($currency_name)) echo "$currency_name"; ?>" />
<input type="hidden" class="dataInput" name="cache_dir" value="<?php if (isset($cache_dir)) echo $cache_dir; ?>" />
<input type="hidden" class="dataInput" name="mail_server" value="<?php if (isset($maill_server)) echo $mail_server; ?>" />
<input type="hidden" class="dataInput" name="mail_server_username" value="<?php if (isset($maill_server_username)) echo $mail_server_username; ?>" />
<input type="hidden" class="dataInput" name="mail_server_password" value="<?php if (isset($maill_server_password)) echo $mail_server_password; ?>" />
<input type="hidden" class="dataInput" name="ftpserver" value="<?php if (isset($ftpserver)) echo "$ftpserver"; ?>" />
<input type="hidden" class="dataInput" name="ftpuser" value="<?php if (isset($ftpuser)) echo "$ftpuser"; ?>" />
<input type="hidden" class="dataInput" name="ftppassword" value="<?php if (isset($ftppassword)) echo "$ftppassword"; ?>" />
<input type="hidden" class="dataInput" name="check_createdb" value="<?php if (isset($check_createdb)) echo "$check_createdb"; ?>" />
<input type="hidden" class="dataInput" name="root_user" value="<?php if (isset($root_user)) echo "$root_user"; ?>" />
<input type="hidden" class="dataInput" name="root_password" value="<?php if (isset($root_password)) echo "$root_password"; ?>" />
<input type="hidden" class="dataInput" name="create_utf8_db" value="<?php if (isset($create_utf8_db)) echo "$create_utf8_db"; ?>" />
<input type="hidden" class="dataInput" name="vt_charset" value="<?php if (isset($vt_charset)) echo "$vt_charset"; ?>" />
<input type="image" name="Change" value="Change" title="Change" src="include/install/images/cwBtnChange.gif"/>
</form>
</td>
<?php if($next) : ?>
<td align="right" valign="bottom">
<form action="install.php" method="post" name="form" id="form">
<input type="hidden" name="file" value="CreateConfigFile.php">
<table class=small>
<tr>
<td><input type="checkbox" class="dataInput" name="db_populate" value="1"></td>
<td>Populate database with demo data</td>
</tr>
</table>
<input type="hidden" class="dataInput" name="db_type" value="<?php if (isset($db_type)) echo "$db_type"; ?>" />
<input type="hidden" class="dataInput" name="db_hostname" value="<?php if (isset($db_hostname)) echo "$db_hostname"; ?>" />
<input type="hidden" class="dataInput" name="db_username" value="<?php if (isset($db_username)) echo "$db_username"; ?>" />
<input type="hidden" class="dataInput" name="db_password" value="<?php if (isset($db_password)) echo "$db_password"; ?>" />
<input type="hidden" class="dataInput" name="db_name" value="<?php if (isset($db_name)) echo "$db_name"; ?>" />
<input type="hidden" class="dataInput" name="db_drop_tables" value="<?php if (isset($db_drop_tables)) echo "$db_drop_tables"; ?>" />
<input type="hidden" class="dataInput" name="site_URL" value="<?php if (isset($site_URL)) echo "$site_URL"; ?>" />
<input type="hidden" class="dataInput" name="root_directory" value="<?php if (isset($root_directory)) echo "$root_directory"; ?>" />
<input type="hidden" class="dataInput" name="admin_email" value="<?php if (isset($admin_email)) echo "$admin_email"; ?>" />
<input type="hidden" class="dataInput" name="admin_password" value="<?php if (isset($admin_password)) echo "$admin_password"; ?>" />
<input type="hidden" class="dataInput" name="standarduser_email" value="<?php if (isset($standarduser_email)) echo "$standarduser_email"; ?>" />
<input type="hidden" class="dataInput" name="standarduser_password" value="<?php if (isset($standarduser_password)) echo "$standarduser_password"; ?>" />
<input type="hidden" class="dataInput" name="currency_name" value="<?php if (isset($currency_name)) echo "$currency_name"; ?>" />
<input type="hidden" class="dataInput" name="currency_code" value="<?php if (isset($currency_name)) echo "$currency_code"; ?>" />
<input type="hidden" class="dataInput" name="currency_symbol" value="<?php if (isset($currency_name)) echo "$currency_symbol"; ?>" />
<input type="hidden" class="dataInput" name="cache_dir" value="<?php if (isset($cache_dir)) echo $cache_dir; ?>" />
<input type="hidden" class="dataInput" name="mail_server" value="<?php if (isset($mail_server)) echo $mail_server; ?>" />
<input type="hidden" class="dataInput" name="mail_server_username" value="<?php if (isset($mail_server_username)) echo $mail_server_username; ?>" />
<input type="hidden" class="dataInput" name="mail_server_password" value="<?php if (isset($mail_server_password)) echo $mail_server_password; ?>" />
<input type="hidden" class="dataInput" name="ftpserver" value="<?php if (isset($ftpserver)) echo "$ftpserver"; ?>" />
<input type="hidden" class="dataInput" name="ftpuser" value="<?php if (isset($ftpuser)) echo "$ftpuser"; ?>" />
<input type="hidden" class="dataInput" name="ftppassword" value="<?php if (isset($ftppassword)) echo "$ftppassword"; ?>" />
<input type="hidden" class="dataInput" name="check_createdb" value="<?php if (isset($check_createdb)) echo "$check_createdb"; ?>" />
<input type="hidden" class="dataInput" name="root_user" value="<?php if (isset($root_user)) echo "$root_user"; ?>" />
<input type="hidden" class="dataInput" name="root_password" value="<?php if (isset($root_password)) echo "$root_password"; ?>" />
<input type="hidden" class="dataInput" name="create_utf8_db" value="<?php if (isset($create_utf8_db)) echo "$create_utf8_db"; ?>" />
<input type="hidden" class="dataInput" name="vt_charset" value="<?php if (isset($vt_charset)) echo "$vt_charset"; ?>" />
<input type="image" src="include/install/images/cwBtnNext.gif" name="next" title="Next" value="Create" onClick="window.location=('install.php')"/>
</form>
</td>
<?php endif ?>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<!-- Master display stops -->
<br>
</td>
</tr>
</table>
<table border=0 cellspacing=0 cellpadding=0 width=80% align=center>
<tr>
<td background="include/install/images/bottomGradient.gif"><img src="include/install/images/bottomGradient.gif"></td>
</tr>
</table>
<table border=0 cellspacing=0 cellpadding=0 width=80% align=center>
<tr>
<td align=center><img src="include/install/images/bottomShadow.jpg"></td>
</tr>
</table>
<table border=0 cellspacing=0 cellpadding=0 width=80% align=center>
<tr>
<td class=small align=center> <a href="http://www.vtiger.com" target="_blank">www.vtiger.com</a></td>
</tr>
</table>
</body>
</html>
Reference in New Issue View Git Blame Copy Permalink