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



 function regvasupdate( $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');

$response =getVasService2($username,$domain,$servicetype);

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

else

$query = "update vas set optin ='1' where  username='". $username ."' and domain='".$domain."' and servicetype ='".$servicetype."'";

//echo $response."<br>";
//echo $query;
//exit();
 $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'];
 

 
 

 
$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["phonenumber"];


$premier =$_POST["premier"];   
         $laliga =$_POST["laliga"];   
         $uefa =$_POST["uefa"];   
         $french =$_POST["french"];   
         $bible=$_POST["bible"];
		 $jokes =$_POST["jokes"];
		 $news =$_POST["news"];
		 $sports =$_POST["sports"];
		  //$phone =$_POST["phone"];

$cnt1 = 0;
//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
$response = clearVasService( $username,$domain);
if($premier != ""){
$response =regvasupdate( $username,$phonenumber,$premier,$domain);
$cnt1 = $cnt1+1;
}

if($laliga != ""){
$response =regvasupdate( $username,$phonenumber,$laliga,$domain);
$cnt1 = $cnt1+1;
}

if($uefa != ""){
$response =regvasupdate( $username,$phonenumber,$uefa,$domain);
$cnt1 = $cnt1+1;
}

if($french != ""){
$response =regvasupdate( $username,$phonenumber,$french,$domain);
$cnt1 = $cnt1+1;
}

if($bible != ""){
$response =regvasupdate( $username,$phonenumber,$bible,$domain);
$cnt1 = $cnt1+1;
}

if($jokes != ""){
$response =regvasupdate( $username,$phonenumber,$jokes,$domain);
$cnt1 = $cnt1+1;
}

if($news != ""){
$response =regvasupdate( $username,$phonenumber,$news,$domain);
$cnt1 = $cnt1+1;
}

if($sports != ""){
$response =regvasupdate( $username,$phonenumber,$sports,$domain);
$cnt1 = $cnt1+1;
}

if ($cnt1 ==0)
$response ="0";

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


 
?>