<?php
include "../phppsycorps/common_db.inc";
include "../phppsycorps/servlist.inc";
require("./nusoap.php");
error_reporting(0);

$server= new soap_server;
$server->register('valid8');
$server->register('pro_type');
$server->service($HTTP_RAW_POST_DATA);

function valid8($xProid, $x_mcrypt_64, $xPropassword_e, $xProprov)
{
global $mcrypt_key;

if($xProprov=="BC"){$servProdb="service_providers";}
else if($xProprov=="AB"){$servProdb="service_providers_ab";}
else if($xProprov=="SK"){$servProdb="service_providers_sk";}
else if($xProprov=="MB"){$servProdb="service_providers_mb";}
else if($xProprov=="ON"){$servProdb="service_providers_on";}
else if($xProprov=="QC"){$servProdb="service_providers_qc";}
else if($xProprov=="NS"){$servProdb="service_providers_ns";}
else if($xProprov=="NB"){$servProdb="service_providers_nb";}
else if($xProprov=="PE"){$servProdb="service_providers_pe";}
else if($xProprov=="NL"){$servProdb="service_providers_nl";}
else if($xProprov=="YK"){$servProdb="service_providers_yk";}
else if($xProprov=="NW"){$servProdb="service_providers_nw";}
else if($xProprov=="NV"){$servProdb="service_providers_nv";}

  $link_id = db_connect();
  
$mcrypt_module = mcrypt_module_open('rijndael-256', '', 'cbc', '');
  $x_mcrypt_iv=base64_decode($x_mcrypt_64);
  mcrypt_generic_init($mcrypt_module, $mcrypt_key, $x_mcrypt_iv);
$xPropassword=mdecrypt_generic($mcrypt_module, base64_decode($xPropassword_e));
$xPropassword=rtrim($xPropassword, "\0");

  $query = "SELECT Pro_id FROM $servProdb WHERE Pro_id = '$xProid' AND userPropassword = password('$xPropassword') AND Proprov='$xProprov'";
  $result = mysql_query($query);
  if(!mysql_num_rows($result)) return new soap_fault('','','There was no result found');
  else 
  {
   $query_data = mysql_fetch_row($result);
   return $query_data[0] ; 
  }   
}
function pro_type($xProid, $xProprov)
{
if($xProprov=="BC"){$servProdb="service_providers";}
else if($xProprov=="AB"){$servProdb="service_providers_ab";}
else if($xProprov=="SK"){$servProdb="service_providers_sk";}
else if($xProprov=="MB"){$servProdb="service_providers_mb";}
else if($xProprov=="ON"){$servProdb="service_providers_on";}
else if($xProprov=="QC"){$servProdb="service_providers_qc";}
else if($xProprov=="NS"){$servProdb="service_providers_ns";}
else if($xProprov=="NB"){$servProdb="service_providers_nb";}
else if($xProprov=="PE"){$servProdb="service_providers_pe";}
else if($xProprov=="NL"){$servProdb="service_providers_nl";}
else if($xProprov=="YK"){$servProdb="service_providers_yk";}
else if($xProprov=="NW"){$servProdb="service_providers_nw";}
else if($xProprov=="NV"){$servProdb="service_providers_nv";}
$link_id = db_connect();
if(!$link_id) die(sql_error());

$query="SELECT Pro_type
              FROM $servProdb WHERE Pro_id = '$xProid'";
 $result_id=mysql_query($query);
if(!mysql_num_rows($result_id)) return new soap_fault('','','No pro type found');
else {
         $gottenPro=mysql_fetch_row($result_id);
         $Pro_type=$gottenPro[0];
         return $Pro_type;
         }
}
?>