<?php 

if( !(isset($pathtoroot) && $pathtoroot) )
{
  $path=dirname(realpath(__FILE__));
  if(strlen($path))
  {
    /* determine the OS type for path parsing */
    $pos = strpos($path,":");
    if ($pos === false)
    {
      $gOS_TYPE="unix";
      $pathchar = "/";
    }
    else
    {
      $gOS_TYPE="win";
      $pathchar="\\";
    }
    $p = $path.$pathchar;
    /*Start looking for the root flag file */
    if( !isset($pathtoroot) ) $pathtoroot = '';
    while(!strlen($pathtoroot) && strlen($p))
    {
      $sub = substr($p,strlen($pathchar)*-1);
      if($sub==$pathchar)
      {
        $filename = $p."root.flg";
      }
      else
        $filename = $p.$pathchar."root.flg";
      if(file_exists($filename))
      {
        $pathtoroot = $p;
      }
      else
      {
        $parent = realpath($p.$pathchar."..".$pathchar);
	if($parent!=$p)
	{
	  $p = $parent;
	}
	else
	  $p = "";
      }
    }
    if( !(isset($pathtoroot) && $pathtoroot) )
      $pathtoroot = ".".$pathchar;
  }
  else
  {
    $pathtoroot = ".".$pathchar;
  }
}

$sub = substr($pathtoroot,strlen($pathchar)*-1);
if($sub!=$pathchar)
{
  $pathtoroot = $pathtoroot.$pathchar;
}
//echo $pathtoroot;
//echo $pathtoroot;
require_once($pathtoroot."kernel/startup.php");
$rootURL="http://".ThisDomain().$objConfig->Get("Site_Path");

$admin = $objConfig->Get("AdminDirectory");
if(!strlen($admin))
    $admin = "admin";

$localURL=$rootURL."kernel/";
$adminURL=$rootURL.$admin;
$imagesURL = $adminURL."/images";

//admin only util
$pathtolocal = $pathtoroot."kernel/";
require_once ($pathtoroot.$admin."/include/elements.php");
require_once ($pathtoroot."kernel/admin/include/navmenu.php");
require_once ($pathtolocal."admin/include/navmenu.php");
require_once($pathtoroot.$admin."/toolbar.php");
	//Set Section
	$section = "in-portal:main_import";

	//Set Environment Variable
	$envar = "env=" . BuildEnv();
	$var = "?env=".BuildEnv();
	
	
	if(	isset($_POST['import_id']) ) $objSession->SetVariable('ImportScriptID', $_POST['import_id']);
	$import_script = GetImportScript( $objSession->GetVariable('ImportScriptID') );
	
	
 	$sec = $objSections->GetSection($section);
 	$objCatToolBar = new clsToolBar();
  
	// Previous Button
	$MouseOver = "swap('moveleft','toolbar/tool_prev_f2.gif');";
    $MouseOut = "swap('moveleft', 'toolbar/tool_prev.gif');";
    $link = $adminURL."/import/step2.php".$var;
    $objCatToolBar->Add("moveleft",admin_language("la_ToolTip_Previous")." ".admin_language("la_Text_Step"),$link,$MouseOver,$MouseOut,"","tool_prev.gif");
 
	// Next Button  
    $MouseOver = "swap('moveright','toolbar/tool_next_f2.gif');";
    $MouseOut = "swap('moveright', 'toolbar/tool_next.gif');";
    $link2 = $adminURL."/import/step4.php".$var;
    $onClick = "document.import_form.submit();";
    $objCatToolBar->Add("moveright",admin_language("la_ToolTip_Next")." ".admin_language("la_Text_Step"),'#',$MouseOver,$MouseOut,$onClick,"tool_next.gif");
  
  	// Header
  	$title = admin_language("la_performing_import")." - ".admin_language("la_Step")." 3";
  	int_header($objCatToolBar,NULL,$title);
?>
         
<form name="import_form" METHOD="POST" action='<?php echo $adminURL."/import/step4.php".$var ; ?>' >	
<input type="hidden" name="Action" value="checkconn"> 	
<table width="100%" border="0" cellspacing="0" cellpadding="4" class="tableborder">
	<?php int_subsection_title(admin_language("la_prompt_DatabaseSettings").' - '.$import_script['label']); ?>
	<tr <?php echo int_table_color(); ?>> 
		<td width="60%" valign="top"><span class="text"><?php echo $import_script['field_prefix'].' '.admin_language("la_prompt_SqlType"); ?></span></td>
		<td> 
			<select name="db_sql_type" style="width: 197px;">
				<option value="mysql" selected>MySQL</option>
			</select>
		</td>
	</tr>
	<tr <?php echo int_table_color(); ?>> 
		<td width="60%" valign="top"><span class="text"><?php echo $import_script['field_prefix'].' '.admin_language("la_prompt_Server"); ?></span></td>
		<td> 
			<input type="text" name="db_server" class="text" size="30" value="<?php echo $objSession->GetVariable("import_server"); ?>">
		</td>
	</tr>
	<tr <?php echo int_table_color(); ?>> 
		<td width="60%" valign="top"><span class="text"><?php echo $import_script['field_prefix'].' '.admin_language("la_prompt_DbName"); ?></span></td>
		<td> 
			<input type="text" name="db_db" class="text" size="30" value="<?php echo $objSession->GetVariable("import_db"); ?>">
		</td>
	</tr>
	<tr <?php echo int_table_color(); ?>> 
		<td width="60%" valign="top"><span class="text"><?php echo $import_script['field_prefix'].' '.admin_language("la_prompt_DbUsername"); ?></span></td>
		<td> 
			<input type="text" name="db_user" class="text" size="30" value="<?php echo $objSession->GetVariable("import_user"); ?>">
		</td>
	</tr>
	<tr <?php echo int_table_color(); ?>> 
		<td width="60%" valign="top"><span class="text"><?php echo $import_script['field_prefix'].' '.admin_language("la_prompt_DbPass"); ?></span></td>
		<td> 
			<input type="password" name="db_pass" class="text" size="30" value="<?php echo $objSession->GetVariable("import_pass"); ?>">
		</td>
	</tr>
 	<tr>
 		<td colspan="2"><span class="error"><?php echo $objSession->GetVariable("error_importing"); ?></span></td>
 	</tr>
</table>
</form>
<?php
int_footer();
?>