delegatewithmysql

<?php

// Database connection.
mysql_connect("localhost", "root", "admin");
mysql_select_db("drupaltheme");


$resultFindMode = mysql_query("SELECT mode_id FROM {freeway_mode} where sr_id = 1");

while ($recordUsPw = mysql_fetch_object($resultFindMode ))
         {
            $modeValueUsPw = $recordUsPw->mode_id;
         }

    if ($modeValueUsPw == '1'){
    $globalResult = mysql_query("SELECT freeway_global_username,freeway_global_password FROM {freeway_global_user} where sr_id = 1");

     while ($recordUsPwGl  = mysql_fetch_object($globalResult)){
     $fusername = $recordUsPwGl->freeway_global_username;
     $fpassword = $recordUsPwGl->freeway_global_password;

        }

        }




$arrayTarLang = array();
$myid = trim($_GET['name']);

$LoginClient = new SoapClient("https://freeway.demo.lionbridge.com/vojo/FreewayAuth.asmx?wsdl", array("trace"=>1));
$ServicesLink = new SoapClient("https://freeway.demo.lionbridge.com/vojo/Service.asmx?wsdl", array("trace"=>1));
/*
  $splitArr = array();
  $filename = "./translate/tempFile.txt";
  if (file_exists($filename)){
  $getCr = file_get_contents($filename);
  $splitArr = explode("-#", $getCr);
  $fusername = $splitArr[0];
  $fpassword = $splitArr[1];
  }
  unlink($filename);

*/
    //$fusername = 'testuser' ;
    //$fpassword = 'testpassword';


      try{
      $arrResponse = $LoginClient->Logon(array ('Username'=>$fusername,'Password'=>$fpassword));
      $ticket = ($arrResponse->LogonResult);
      $getTarLang = $ServicesLink->GetTargetLanguages (array('Ticket'=>$ticket,'SourceLanguageID'=>$myid));

        foreach($getTarLang->GetTargetLanguagesResult->Languages->Language as $languageT)
            {
                $arrayTarLang[$languageT->ID] = $languageT->Description."_".$languageT->ID;
            }
      }
      catch (SoapFault $exception){
          return $exception;
          }


 print json_encode($arrayTarLang);

?>