is_admin != 'on')
{
die("
".$app_strings['LBL_PERMISSION']." ".$app_strings['LBL_GO_BACK'].".");
}
//To get the Current installed MySQL path
include("connection.php");
$vtiger_home = $_ENV["VTIGER_HOME"];
$mysqldir = $mysql_dir;
if(is_file($mysqldir."/bin/mysqldump"))
{
$installed_mysql_path = $mysqldir."/bin/mysqldump";
$getmysqlpath = 0;
}
elseif(is_file($vtiger_home."/mysql/bin/mysqldump"))
{
$installed_mysql_path = $vtiger_home."/mysql/bin/mysqldump";
$getmysqlpath = 0;
}
elseif(substr($_ENV["OS"],0,3) == "Win")
{
if(is_file($vtiger_home.'\mysql\bin\mysql.exe'))
{
$installed_mysql_path = $vtiger_home.'\mysql\bin\mysqldump.exe';
@session_unregister('set_server_mysql_path');
$_SESSION['set_server_mysql_path'] = $vtiger_home.'\mysql\bin';
$getmysqlpath = 0;
}
else
{
$getmysqlpath = 1;
}
}
else
{
$getmysqlpath = 1;
if($_REQUEST['migration_option'] == 'alter_db_details')
$showmysqlpath = 'none';
else
$showmysqlpath = 'block';
}
require_once('Smarty_setup.php');
global $app_strings,$app_list_strings,$mod_strings,$theme,$currentModule;
$smarty = new vtigerCRM_Smarty();
$theme_path="themes/".$theme."/";
$image_path=$theme_path."images/";
$smarty->assign("MOD", $mod_strings);
$smarty->assign("APP", $app_strings);
$smarty->assign("MODULE","Migration");
$smarty->assign("THEME", $theme);
$smarty->assign("IMAGE_PATH", $image_path);
$smarty->assign("DB_DETAILS_CHECKED", 'checked');
$smarty->assign("SHOW_DB_DETAILS", 'block');
//Based on this $getmysqlpath variable we should get the mysql path from the user
$smarty->assign("GET_MYSQL_PATH",$getmysqlpath);
$smarty->assign("SHOW_MYSQL_PATH",$showmysqlpath);
//this is to set the entered values when we could not proceed the migration and return to step1
if($_REQUEST['migration_option'] != '')
{
if($_REQUEST['migration_option'] == 'db_details')
{
if($_REQUEST['old_host_name'] != '')
$smarty->assign("OLD_HOST_NAME", $_REQUEST['old_host_name']);
if($_REQUEST['old_port_no'] != '')
$smarty->assign("OLD_PORT_NO", $_REQUEST['old_port_no']);
if($_REQUEST['old_mysql_username'] != '')
$smarty->assign("OLD_MYSQL_USERNAME", $_REQUEST['old_mysql_username']);
if($_REQUEST['old_mysql_password'] != '')
$smarty->assign("OLD_MYSQL_PASSWORD", $_REQUEST['old_mysql_password']);
if($_REQUEST['old_dbname'] != '')
$smarty->assign("OLD_DBNAME", $_REQUEST['old_dbname']);
if($_REQUEST['server_mysql_path'] != '')
$smarty->assign("SERVER_MYSQL_PATH", $_REQUEST['server_mysql_path']);
}
elseif($_REQUEST['migration_option'] == 'dump_details')
{
$smarty->assign("DUMP_DETAILS_CHECKED", 'checked');
$smarty->assign("DB_DETAILS_CHECKED", '');
$smarty->assign("SHOW_DUMP_DETAILS", 'block');
$smarty->assign("SHOW_DB_DETAILS", 'none');
}
else
{
if($_REQUEST['alter_old_host_name'] != '')
$smarty->assign("ALTER_OLD_HOST_NAME", $_REQUEST['alter_old_host_name']);
if($_REQUEST['alter_old_port_no'] != '')
$smarty->assign("ALTER_OLD_PORT_NO", $_REQUEST['alter_old_port_no']);
if($_REQUEST['alter_old_mysql_username'] != '')
$smarty->assign("ALTER_OLD_MYSQL_USERNAME", $_REQUEST['alter_old_mysql_username']);
if($_REQUEST['alter_old_mysql_password'] != '')
$smarty->assign("ALTER_OLD_MYSQL_PASSWORD", $_REQUEST['alter_old_mysql_password']);
if($_REQUEST['alter_old_dbname'] != '')
$smarty->assign("ALTER_OLD_DBNAME", $_REQUEST['alter_old_dbname']);
if($_REQUEST['server_mysql_path'] != '')
$smarty->assign("SERVER_MYSQL_PATH", $_REQUEST['server_mysql_path']);
$smarty->assign("DB_DETAILS_CHECKED", '');
$smarty->assign("DUMP_DETAILS_CHECKED", '');
$smarty->assign("ALTER_DB_DETAILS_CHECKED", 'checked');
$smarty->assign("SHOW_DB_DETAILS", 'none');
$smarty->assign("SHOW_DUMP_DETAILS", 'none');
$smarty->assign("SHOW_ALTER_DB_DETAILS", 'block');
}
}
$smarty->display("MigrationStep1.tpl");
?>