<?php 

if(!strlen($pathtoroot))
{
  $path=dirname(realpath($_SERVER['SCRIPT_FILENAME']));
  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 */
    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(!strlen($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:inlink_inport";
//Set Environment Variable
$envar = "env=" . BuildEnv();

$formaction = $adminURL."/import/import.php?".$envar;
$sec = $objSections->GetSection($section);
$objCatToolBar = new clsToolBar();
$formaction = "import.php?".$envar;

//check if the previous input is correct
if( $_POST["Action"]=="checkconn")
{
    $objSession->SetVariable("import_inlink_sql_type",$_POST["inlink_sql_type"]);
    $objSession->SetVariable("import_inlink_server",$_POST["inlink_server"]);
    $objSession->SetVariable("import_inlink_db",$_POST["inlink_db"]);
    $objSession->SetVariable("import_inlink_user",$_POST["inlink_user"]);
    $objSession->SetVariable("import_inlink_pass",$_POST["inlink_pass"]);

    $objSession->SetVariable("error_importing","");

    $inlink_sql_type=$objSession->GetVariable("import_inlink_sql_type");
    $inlink_server=$objSession->GetVariable("import_inlink_server");
    $inlink_db=$objSession->GetVariable("import_inlink_db");
    $inlink_user=$objSession->GetVariable("import_inlink_user");
    $inlink_pass=$objSession->GetVariable("import_inlink_pass");


   $linkconn = ADONewConnection($inlink_sql_type);

    if(!$linkconn->PConnect($inlink_server, $inlink_user, $inlink_pass, $inlink_db) || $inlink_server =="" || $inlink_db=="")
    {
   // echo "Database connection failed. DB Type: $sql_type, DB Server: $inlink_server, DB User: $inlink_user, DB Name: $inlink_db"; //fatal;
        $objSession->SetVariable("error_importing","Error: The connection to the DB failed please check your settings");
        header("Location:inlinkimport3.php?".$envar);
               //$linkconn->ErrorMsg();
   }
    unset($linkconn);
}
//if it is not then we redirect the user back to the page with a message of what went wrong.

if (true)
{
	
   if(true)
  {

    $MouseOver="swap('moveleft','toolbar/tool_prev_f2.gif');";
    $MouseOut="swap('moveleft', 'toolbar/tool_prev.gif');";
    $var="?env=".BuildEnv()."&en=$en_prev";
    $link=$adminURL."/import/inlinkimport3.php".$var;
    
    $objCatToolBar->Add("moveleft",admin_language("la_ToolTip_Previous")." ".admin_language("la_Text_Step"),$link,$MouseOver,$MouseOut,"","tool_prev.gif");
  }
  
  if(true)
  {
    $MouseOver="swap('moveright','toolbar/tool_next_f2.gif');";
    $MouseOut="swap('moveright', 'toolbar/tool_next.gif');";
    $var="?env=".BuildEnv()."&en=$en_next";
    $link=$adminURL."/import/inlinkimport4.php".$var;
    
    $onClick="if(document.inlinkimport4.user_admin.value=='' || document.inlinkimport4.user_regular.value=='' || document.inlinkimport4.init_cat.value=='' || document.inlinkimport4.link_image.value =='') alert('Please fill in all of the fields');  else import_submit('inlinkimport4','$formaction','');";
   
    $link="#";
    $objCatToolBar->Add("moveright",admin_language("la_ToolTip_Next")." ".admin_language("la_Text_Step"),$link,$MouseOver,$MouseOut,$onClick,"tool_next.gif");
  }
  
  $title = admin_language("la_performing_import")." - ".admin_language("la_Step")." 4";
  
  int_header($objCatToolBar,NULL,$title);
}
?>
         
<table width="100%" border="0" cellspacing="0" cellpadding="4" class="tableborder">
<form id="inlinkimport4" name="inlinkimport4" METHOD="POST" action="<?php echo $_SERVER["PHP_SELF"]."?".$envar; ?>">	
<?php int_subsection_title("Matching Fields - Intechnic In-Portal ");  ?>
                   <TR <?php echo int_table_color(); ?>> 
            <td width=\"60%\" valign=\"top\"><span class=\"text\"><?php echo admin_language("la_prompt_AdminId"); ?>    </span></td>
            <TD> 
                <b><?php echo $objSession->GetVariable("user_admin_names"); ?></b>
 		  	 	<INPUT TYPE="hidden" NAME="user_admin" size="15" class="text" value='<?php echo $objSession->GetVariable("user_admin_values"); ?>'>
 			 	<a href="#"><img src="../images/icon_users_sm.gif" style="cursor:hand" border="0" ONCLICK="OpenGroupSelector('<?php echo $envar; ?>&en=0&destform=inlinkimport4&destfield=grouplist1&Selector=radio');"></a>

               <INPUT TYPE="hidden" NAME="grouplist1">
	   	   
			 </TD>
          </TR>
          <TR <?php echo int_table_color(); ?>> 
            <td width=\"60%\" valign=\"top\"><span class=\"text\"><?php echo admin_language("la_prompt_RegUserId"); ?>    </span></td>
            <TD> 
              <b><?php echo $objSession->GetVariable("user_regular_names"); ?></b>
 		  	  <INPUT TYPE="hidden" NAME="user_regular" size="15" class="text" value='<?php echo $objSession->GetVariable("user_regular_values"); ?>'>
 		    <a href="#"><img src="../images/icon_users_sm.gif" style="cursor:hand" border="0" ONCLICK="OpenGroupSelector('<?php echo $envar; ?>&en=0&destform=inlinkimport4&destfield=grouplist2&Selector=radio');"></a>


              <INPUT TYPE="hidden" NAME="grouplist2">
			</TD>
          </TR>
          <TR <?php echo int_table_color(); ?>> 
            <td width=\"60%\" valign=\"top\"><span class=\"text\"><?php echo admin_language("la_prompt_InitImportCat"); ?>   
             <?php                         
                        $catid = $objSession->GetVariable("categoryid");
                        if($catid>0)
                        {
                            $c = $objCatList->GetItemByField("ResourceId",$catid);
                            $path = prompt_language($objConfig->Get("Root_Name")). "&gt;".$c->GetCachedNavBar();
                        }          
                        else
                            $path = prompt_language($objConfig->Get("Root_Name"));
             ?>
           </td>
            <TD > 
                 <B><?php echo $path; ?></B>
 				<INPUT TYPE="HIDDEN" NAME="init_cat" size="15" class="text" value='<?php echo $objSession->GetVariable("categoryid"); ?>'>
 		    	<a href="#"><img src="<?php echo $imagesURL; ?>/folder.gif" style="cursor:hand" border="0" ONCLICK="OpenCatSelector('<?php echo $envar; ?>&source=inlinkimport4&continue_sess=1&destform=inlinkimport4&destfield=categorylist&Selector=radio');"></a>


                <INPUT TYPE="hidden" NAME="categorylist">
 				
	   	    </TD>
          </TR>         
           <TR <?php echo int_table_color(); ?>> 
            <td width=\"60%\" valign=\"top\"><span class=\"text\"><?php echo admin_language("la_prompt_Import_ImageName"); ?></span></td>
            <TD > 
			  <INPUT type="text" name="link_image" class="text" size="30" value='<?php echo $objSession->GetVariable("link_image"); ?>'>
			</TD>
          </TR>
          <input TYPE="hidden" NAME="Action" VALUE="l_import_config">  
 <tr>
 <td>
 </td>
 </tr>
</FORM>
</TABLE>
<?php
int_footer();
?>