<?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";	
		$str="";
		$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 reguserlogin( $username,$pass,$phonenumber,$domain,$email,$fullname,$companyname,$emailcode,$pkey)
{

$clientip =  getMyIP();
$activationcode = $emailcode;
//$clientbirthday = $birthyear."/".$birthmonth."/".$birthmonth;
$username=removePosion($username);
//$address=removePosion($address);
$pass=removePosion($pass);
$companyname ==removePosion($companyname);
$fullname=removePosion($fullname);


$query= "insert into  userlogin (username,pass,clientip,phonenumber,mlock,domain,email,fullname,activationcode,companyname,zipcode,pkey) 
values ('". $username ."','". $pass."','".$clientip."','".$phonenumber."','2','".$domain."','".$email."','".$fullname."','".$activationcode."','".$companyname."','".$pkey."',"."password('".$pkey."')".")";
 //echo $query;
  //die();
 $cnt ="";
 $con=mysqli_connect("127.0.0.1","smsEngine","guEnaR28T","smartsmsrouter");
 // Check connection
 if (mysqli_connect_errno())
   {
    echo mysqli_error($con);
    return "-1";
   //echo "-1";
   //die();
   }
   
// $query="insert messagesentsingle(transid,username,phonenumber,message,sender,status,domain,dateused) values ('".$transid."','".$username."','".$phonenumber. "','". $mess. "','". $sender. "','0','". $domain. "','".  date('Y-m-d H:i:s')."')";
  
  
// $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);
   die();
   return "-1";
  
}
else
{
 $cnt= "0";
 mysqli_close($con);
 return $cnt; 
}


}


function servicestats($username,$bulksms,$robotcall,$automation,$personal,$others,$domain)
{


//$clientbirthday = $birthyear."/".$birthmonth."/".$birthmonth;

if ($bulksms=="") 
   $bulksms =="0";
if ($automation=="")
    $automation="0";
if ($robotcall=="")
    $robotcall=="0";
if ($personal =="")
    $personal ="0";
if ($others=="")
    $others="0";


$query= "insert into  servicestatistics (username,bulksms,automation,robotcall,personal,others,domain) 
values ('$username','$bulksms','$automation','$robotcall','$personal','$others','$domain')";
 //echo $query;
  //die();
 $cnt ="";
 $con=mysqli_connect("127.0.0.1","smsEngine","guEnaR28T","smartsmsrouter");
 // Check connection
 if (mysqli_connect_errno())
   {
    echo mysqli_error($con);
    return "-1";
   //echo "-1";
   //die();
   }
   
// $query="insert messagesentsingle(transid,username,phonenumber,message,sender,status,domain,dateused) values ('".$transid."','".$username."','".$phonenumber. "','". $mess. "','". $sender. "','0','". $domain. "','".  date('Y-m-d H:i:s')."')";
  
  
// $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);
   die();
   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.15','".$domain."')";
  }
  
 if ($accounttype =="rwf")
  {
     $query="insert into smsaccount (username,baldollar,domain) values ('".$username."','50.00','".$domain."')";
  }

//echo $query;

 $cnt ="";
 $con=mysqli_connect("127.0.0.1","smsEngine","guEnaR28T","smartsmsrouter");
 // Check connection
 if (mysqli_connect_errno())
   {
    echo mysqli_error($con);
     return "-1";
   //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.co.uk');

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."')";
  }
  

if ($accounttype =="rwf")
  {
     $query="insert into smsprofile (username,subprofile,rateprofile,domain) values ('".$username."','3','12','".$domain."')";
  }
 
//echo $query;
 $cnt ="";
 $con=mysqli_connect("127.0.0.1","smsEngine","guEnaR28T","smartsmsrouter");
 // Check connection
 if (mysqli_connect_errno())
   {
    echo mysqli_error($con);
     return "-1";
   //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'); 

 echo $_SESSION['accounttype'];
 
 if ($_SESSION['accounttype'] == "" ){
 
  header('Location: register.php?err=50');
   die();
 }

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

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


$bulksms =$_SESSION['bulksms'];
$robotcall=$_SESSION['robotcall'];
$automation= $_SESSION['automation'];
$personal= $_SESSION['personal'];
$others=$_SESSION['others'];


//check if username already exists
$response =getUsername($username,$domain);
if ($response=="yes")
{
     header('Location: registerform.php?err=10');
   die();
}


//check if email already exists
$response =getEmail($email,$domain);
if ($response=="yes")
{
     header('Location: registerform.php?err=11');
   die();
}



//check if phonenumber already exists
$response =getPhone($phonenumber,$domain);
if ($response=="yes")
{
     header('Location: registerform.php?err=12');
   die();
}

//register susbcriber to database
$pkey = $_SESSION['pkey'];
$response =reguserlogin($username,$pass,$phonenumber,$domain,$email,$fullname,$companyname,$emailcode,$pkey);

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


//$accounttype = "euro" ;

$response= regsmsaccount( $username,$accounttype,$domain);

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

$response= regsmsprofile( $username,$accounttype,$domain);

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

//service statistics

$response = servicestats($username,$bulksms,$robotcall,$automation,$personal,$others,$domain);



//send sms client

$transID= generateTransID();
if ($accounttype =="euro")
{
$mess ="Dear ". $username ." Welcome to :   ". $domain . ". Your registration is completed. And 0.15 Euro credited to your account to test our service.";
}

if ($accounttype =="naira")
{
 $mess ="Dear ". $username ." Welcome to :   ". $domain . ". Your registration is completed. And N10.00 credited to your account to test our service.";
}

if ($accounttype =="dollars")
{
$mess ="Dear ". $username ." Welcome to :   ". $domain . ". Your registration is completed. And 0.10 dollar credited to your account to test our service.";
}

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

if ($response=="0" )
{ 

$mysub = "Registration Completed - " . $domain;
$myMessage ="Dear <b>". $username. "</b>,<br><br>";
$myMessage .= "Your registration is completed. You provided us the following information:<br><br>"; 
$myMessage .= "Email  : <b>" . $email . "</b><br>";
$myMessage .= "Phonenumber  : <b>" . $phonenumber . "</b><br>";
$myMessage .= "Fullname  : <b>" . $fullname . "</b><br>";
//$myMessage .= "Address  : <b>" . $address . "</b><br><br>";
$myMessage .= "Thanks for your interest in our service. " . "<br>";
$myMessage .= "<b>Support " . $domain."</b>";

$$myMessage2 ="Dear ". $username. ",\n\n";
$myMessage2 .= "Your registration is completed. You provided us the following information:\n\n"; 
$myMessage2 .= "Email  : " . $email . "\n";
$myMessage2 .= "Phonenumber  : " . $phonenumber . "\n";
$myMessage2 .= "Fullname  : " . $fullname . "\n";
//$myMessage2 .= "Address  : " . $address . "\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);

 
  header('Location: login.php?err=0');
  die();
}
else
{
   header('Location: registerfinal.php?err=1');
   die();
}


 
?>