<?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 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 plainmotorsinvestors 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 plainmotorsinvestors 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($fullname,$password,$phonenumber,$domain,$email,$referrer)
{

$clientip =  getMyIP();


$query= "insert into  plainmotorsinvestors (fullname,password,clientip,phonenumber,domain,email,referrer) values ('". $fullname ."',"."password('".$password."')".",'".$clientip."','".$phonenumber."','".$domain."','".$email."','".$referrer."')";
 //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; 
}


}




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


date_default_timezone_set('Africa/Lagos'); 

 echo $_SESSION['accounttype'];
 
 if ($_SESSION['accounttype'] == "" ){
 
  header('Location: register.php?err=14');
   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"];   
 
 
 if ($_SESSION['emailcode'] != $emailcode ){
 
  header('Location: registerfinal.php?err=3');
   die();
 }
 
 if ($_SESSION['smscode'] != $smscode ){
 
  header('Location: registerfinal.php?err=2');
   die();
 }


 echo $_SESSION['fullname'] ; 
 
$fullname= $_SESSION['fullname'] ;   
$password = $_SESSION['password'] ;   
$email =$_SESSION['email'] ;   
$phonenumber= $_SESSION['phonenumber'] ;   
$referrer = $_SESSION['referrer'];   
//$referrer=removePosion($referrer);
//$fullname=removePosion($fullname);

//echo $fullname;
//die();



//check if email already exists
$response =getEmail($email,$domain);
if ($response=="yes")
{
     header('Location: newuser.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( $fullname,$password,$phonenumber,$domain,$email,$referrer);



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

$transID= generateTransID();

//echo $transID;

//die();
 $mess ="Dear ". $fullname ." Welcome to Plain Motors Crowd Investment Program.  Your registration is completed. Login to the platform and make your first investment.";

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


$mysub = "Registration Completed - Plain Motors";
$myMessage ="Dear <b>". $fullname. "</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 .= "Thanks for your interest in our service. " . "<br>";
$myMessage .= "<b>Support Team <br> Plain Motors Limited</b>";


$$myMessage2 ="Dear ". $fullname. ",\n\n";
$myMessage2 .= "Your registration is completed. You provided us the following information:\n\n"; 
$myMessage2 .= "Email  : " . $email . "\n";
$myMessage2 .= "Phonenumber  : " . $phonenumber . "\n";
$myMessage2 .= "Thanks for your interest in our service. " . "\n";
$myMessage2 .= "Support Team <br> Plain Motors Limited";
$mymail = sendmailtoclient($email,$myMessage,$myMessage2,$mysub,$mfrom,$mfromname);
$email1 = "investors@plainmotors.com.ng";
$mymail = sendmailtoclient($email1,$myMessage,$myMessage2,$mysub,$mfrom,$mfromname);
header('Location: login.php?err=0');
?>