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



 function regvas( $username,$phonenumber,$servicetype,$domain)
{
//insert into vas ( username,phonenumber,servicetype,optin,domain,dateused) values ('brianambutsi','254722174924','4','1','247sms.com','2016/10/22 00:00:00');

$query= "insert into  vas (username,phonenumber,servicetype,optin,domain,dateused) values ('". $username ."','". $phonenumber."','".$servicetype."','1','".$domain."','".date('Y-m-d H:i:s')."')";


 $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="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);
  //exit();
   return "-1";
  
}
else
{
 $cnt= "0";
 mysqli_close($con);
 return $cnt; 
}


}


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


date_default_timezone_set('Africa/Lagos'); 

 //echo $_SESSION['accounttype'];
 
 if ($_SESSION['check'] == "" ){
 
  header('Location: vas.php?err=3');
   die();
 }

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

   
 $smscode =$_POST["smscode"];   
 
 
 
 if ($_SESSION['smscode'] != $smscode ){
 
  header('Location: vasfinal.php?err=2');
   die();
 }
 
$username= $_SESSION['username'] ;   
$premier = $_SESSION["premier"];   
$laliga = $_SESSION["laliga"];   
$uefa = $_SESSION["uefa"];   
$french =$_SESSION["french"];   
$bible = $_SESSION["bible"];
$jokes = $_SESSION["jokes"];
$news = $_SESSION["news"];
$sports = $_SESSION["sports"];
$phonenumber = $_SESSION["phone"];
//check if username already exists
$response =getUsernamevas($username,$domain);
if ($response=="yes")
{
     header('Location: vas.php?err=5');
   die();
}





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

//register susbcriber to database
if($premier != "")
$response =regvas( $username,$phonenumber,$premier,$domain);
if($laliga != "")
$response =regvas( $username,$phonenumber,$laliga,$domain);
if($uefa != "")
$response =regvas( $username,$phonenumber,$uefa,$domain);
if($french != "")
$response =regvas( $username,$phonenumber,$french,$domain);
if($bible != "")
$response =regvas( $username,$phonenumber,$bible,$domain);
if($jokes != "")
$response =regvas( $username,$phonenumber,$jokes,$domain);
if($news != "")
$response =regvas( $username,$phonenumber,$news,$domain);
if($sports != "")
$response =regvas( $username,$phonenumber,$sports,$domain);



if( $response =="0"){
  $_SESSION['check']= "";
  header('Location: vas.php?err=0');
  die();
  
}
else
{
   $_SESSION['check']= "";
   header('Location: vas.php?err=7');
   die();
   
}


 
?>