<?php
include "general.php";
include 'sendmailclient.php';





function getAdminEmail($domain,$flag)
{
 include "connect.php";

 $cnt8 ="";
 

  $query=  "select ".$flag." from admindetails where   domain='".$domain."'";
  //echo $query;
if(!$result= mysqli_query($con,$query))
{
  //echo mysqli_error($con);
  echo "Database error please try again";
   mysqli_close($con);
   return $cnt8;
  
}


while($row = mysqli_fetch_array($result))
{
     
	 $cnt8 = $row['0'];
	//echo "nosa";
}

if ($cnt8==NULL)
   $cnt8 ="";
mysqli_close($con);
return $cnt8;


}			






function rand_string( $length ) {
		$chars = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789";	
		
		$size = strlen( $chars );
		for( $i = 0; $i < $length; $i++ ) {
			$str .= $chars[ rand( 0, $size - 1 ) ];
		}
		
		return $str;
	}
	
	

function getUsername( $musername,$domain)
{
 $cnt ="";
 $con=mysqli_connect("127.0.0.1","smsEngine","guEnaR28T","smartsmsrouter");
 // Check connection
 if (mysqli_connect_errno())
   {
    echo mysqli_error($con);
   //echo "-1";
   die();
   }
 $query ="select * from userlogin where username='". $musername ."' and domain='".$domain."'";
//echo $query;
if(!$result= mysqli_query($con,$query))
{
  //echo mysqli_error($con);
  echo "Database error please try again";
   mysqli_close($con);
   exit();
}

$cnt= "";
while($row = mysqli_fetch_array($result))
{
	//$cnt = $row['balairtime'];
	$cnt="yes";
}

//echo $cnt;
mysqli_close($con);
return $cnt;
}			



function getPhone( $phonenumber,$domain)
{
 $cnt ="";
 $con=mysqli_connect("127.0.0.1","smsEngine","guEnaR28T","smartsmsrouter");
 // Check connection
 if (mysqli_connect_errno())
   {
    echo mysqli_error($con);
   //echo "-1";
   die();
   }
 $query ="select * from userlogin where phonenumber='". $phonenumber ."' and domain='".$domain."'";
//echo $query;
if(!$result= mysqli_query($con,$query))
{
  //echo mysqli_error($con);
  echo "Database error please try again";
   mysqli_close($con);
   exit();
}

$cnt= "";
while($row = mysqli_fetch_array($result))
{
	//$cnt = $row['balairtime'];
	$cnt="yes";
}

//echo $cnt;
mysqli_close($con);
return $cnt;
}			





function getEmail( $memail,$domain)
{
 $cnt ="";
 $con=mysqli_connect("127.0.0.1","smsEngine","guEnaR28T","smartsmsrouter");
 // Check connection
 if (mysqli_connect_errno())
   {
    echo mysqli_error($con);
   //echo "-1";
   die();
   }
 $query ="select * from userlogin where email='". $memail ."' and domain='". $domain."'";
//echo $query;
if(!$result= mysqli_query($con,$query))
{
  //echo mysqli_error($con);
  echo "Database error please try again";
   mysqli_close($con);
   exit();
}

$cnt= "";
while($row = mysqli_fetch_array($result))
{
	//$cnt = $row['balairtime'];
	$cnt="yes";
}

//echo $cnt;
mysqli_close($con);
return $cnt;
}			


 function regverify( $username,$email,$phonenumber,$domain)
{


$email=removePosion($email);


$query= "update userlogin set mlock ='0',email='". $email ."', phonenumber='". $phonenumber."' where username='". $username ."' and domain='".$domain."'";

//echo $query;
//exit();
 $cnt ="";
 $con=mysqli_connect("127.0.0.1","smsEngine","guEnaR28T","smartsmsrouter");
 // Check connection
 if (mysqli_connect_errno())
   {
    echo mysqli_error($con);
   return "-1";
   die();
   }
   
if(!$result= mysqli_query($con,$query))
{
  //echo mysqli_error($con);
  echo "Database error please try again";
   mysqli_close($con);
   return "-1";
  
}
else
{
 $cnt= "0";
 mysqli_close($con);
 return $cnt; 
}


}


function regsmsaccount( $username,$accounttype,$domain)
{

$username=removePosion($username);
if ($accounttype =="naira")
  {
     $query="insert into smsaccount (username,balnaira,domain) values ('".$username."','10.00','".$domain."')";
  }
  

if ($accounttype =="dollars")
  {
     $query="insert into smsaccount (username,baldollar,domain) values ('".$username."','0.10','".$domain."')";
  }
  

if ($accounttype =="euro")
  {
     $query="insert into smsaccount (username,baleuro,domain) values ('".$username."','0.10','".$domain."')";
  }
  
 

 $cnt ="";
 $con=mysqli_connect("127.0.0.1","smsEngine","guEnaR28T","smartsmsrouter");
 // Check connection
 if (mysqli_connect_errno())
   {
    echo mysqli_error($con);
   //echo "-1";
   die();
   }
if(!$result= mysqli_query($con,$query))
{
   mysqli_close($con);
   return "-1";
  
}
else
{
 $cnt= "0";
 mysqli_close($con);
 return $cnt; 
}

}


function regsmsprofile( $username,$accounttype,$domain)
{

$username=removePosion($username);

//insert into smsprofile (username,subprofile,rateprofile,domain) values ('system','1','1','247sms.com');

if ($accounttype =="naira")
  {
     $query="insert into smsprofile (username,subprofile,rateprofile,domain) values ('".$username."','1','1','".$domain."')";
  }
  

if ($accounttype =="dollars")
  {
     $query="insert into smsprofile (username,subprofile,rateprofile,domain) values ('".$username."','3','8','".$domain."')";
  }
  

if ($accounttype =="euro")
  {
    $query="insert into smsprofile (username,subprofile,rateprofile,domain) values ('".$username."','2','5','".$domain."')";
  }
  
 

 $cnt ="";
 $con=mysqli_connect("127.0.0.1","smsEngine","guEnaR28T","smartsmsrouter");
 // Check connection
 if (mysqli_connect_errno())
   {
    echo mysqli_error($con);
   //echo "-1";
   die();
   }
if(!$result= mysqli_query($con,$query))
{
   mysqli_close($con);
   return "-1";
  
}
else
{
 $cnt= "0";
 mysqli_close($con);
 return $cnt; 
}

}


//**************************
//**************************
// end of function


date_default_timezone_set('Africa/Lagos'); 

if ($_SESSION['verify1'] == "" ){
 
  header('Location: login.php?err=18');
   die();
 }
 

if ($_SESSION['emailcode'] == "" ){
 
  header('Location: verifyfinal.php?err=4');
   die();
 }
 
 if ($_SESSION['smscode'] == "" ){
 
  header('Location: verifyfinal.php?err=4');
   die();
 }
 
 

 $emailcode =$_POST["emailcode"];   
 $smscode =$_POST["smscode"];   
 //$pin =$_POST["pin"];   
 
 if ($_SESSION['emailcode'] != $emailcode ){
 
  header('Location: verifyfinal.php?err=3');
   die();
 }
 
 if ($_SESSION['smscode'] != $smscode ){
 
  header('Location: verifyfinal.php?err=2');
   die();
 }
 
$username= $_SESSION['username'] ;   
$email =$_SESSION['email'] ;   
$phonenumber= $_SESSION['phone'] ;   


//update the subscriber records

$response =regverify( $username,$email,$phonenumber,$domain);

if ($response=="-1")
{
     header('Location: verifyfinal.php?err=1');
   die();
}


//send sms client

$transID= generateTransID();
$mess ="Dear ". $username .", <br>The verification of your email and phonenumber is completed. Thanks for your interest in our service.";

$mtype ="1";
$response = sendSMS( $username,$phonenumber, $transID, $domain,$mess,$sender,$mtype);

if ($response=="0" )
{ 

$mysub = "Verification Completed - " . $domain;
$myMessage ="Dear <b>". $username. "</b>,<br><br>";
$myMessage .= "The verification of Email & Phonenumber Completed successfully. <br><br>"; 
$myMessage .= "Email  : <b>" . $email . "</b><br>";
$myMessage .= "Phonenumber  : <b>" . $phonenumber . "</b><br><br>";
$myMessage .= "Thanks for your interest in our service. " . "<br>";
$myMessage .= "<b>Support " . $domain."</b>";

$$myMessage2 ="Dear ". $username. ",\n\n";
$myMessage2 .= "The verification of Email & Phonenumber Completed successfully.\n\n"; 
$myMessage2 .= "Email  : " . $email . "\n";
$myMessage2 .= "Phonenumber  : " . $phonenumber . "\n\n";
$myMessage2 .= "Thanks for your interest in our service. " . "\n";
$myMessage2 .= "Support " . $domain."";


$mymail = sendmailtoclient($email,$myMessage,$myMmessage2,$mysub,$mfrom,$mfromname);
$email1 = getAdminEmail($domain,"email1");
$email2 = getAdminEmail($domain,"email2");

if ($email1 !="")
$mymail = sendmailtoclient($email1,$myMessage,$myMmessage2,$mysub,$mfrom,$mfromname);

if ($email2 !="")
$mymail = sendmailtoclient($email2,$myMessage,$myMmessage2,$mysub,$mfrom,$mfromname);

         //$_SESSION['clientlogin'] =$rand;
		
		
		//$_SESSION['loginuser'] ="yes";
        header('Location: login.php?err=19');
		die();
}
else
{
   header('Location: verifyfinal.php?err=1');
   die();
}


 
?>