<?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 reguserlogin( $username,$pass,$phonenumber,$pin,$domain,$email,$country,$state,$fullname,$address,$referrer,$birthday,$birthmonth,$birthyear,$smscode,$emailcode)
{

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


$query= "insert into  userlogin (username,pass,clientip,phonenumber,mlock,pin,domain,email,fullname,activationcode,referrer,address,country,state,league,vas) values ('". $username ."','". $pass."','".$clientip."','".$phonenumber."','0',"."password('".$pin."')".",'".$domain."','".$email."','".$fullname."','".$activationcode."','".$referrer."','".$address."','".$country."','".$state."','1','1')";
 //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."','3.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."')";
  }
  
 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.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."')";
  }
  

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'] ;   
$address =$_SESSION['address'] ;   
$fullname =$_SESSION['fullname'] ;        
$birthday =$_SESSION['birthday'] ;   
$birthmonth =$_SESSION['birthmonth'] ;   
$birthyear = $_SESSION['birthyear'] ;  
$state = $_SESSION['state'] ;   
$country = $_SESSION['country'] ;   
$referrer = $_SESSION['referrer'];   


//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

$response =reguserlogin( $username,$pass,$phonenumber,$pin,$domain,$email,$country,$state,$fullname,$address,$referrer,$birthday,$birthmonth,$birthyear,$smscode,$emailcode);

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

$accounttype = $_SESSION['accounttype'];
//$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();
}

//send sms client

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

if ($accounttype =="naira")
{
 $mess ="Dear ". $username ." Welcome to :   ". $domain . ". Your registration is completed. And N3.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();
}


 
?>