<?php
//include "general2.php";
include "connect.php";


function Checklogin( $musername,$domain,$pass)
{
 $cnt ="";
 include "connect.php";
  $query ="select * from userlogin where username='". $musername ."' and binary pass ='".$pass."' and domain='".$domain."'";
//echo $query;

//exit();

if(!$result= mysqli_query($con,$query))
{
     echo "-4";
     mysqli_close($con);
    die();
}

$cnt= "";
while($row = mysqli_fetch_array($result))
{
	//$cnt = $row['balairtime'];
	$cnt="yes";
}

mysqli_close($con);
return $cnt;
}			



function getQuery( $transID,$tableIndex)
{
 include "connect.php";
 $cnt ="";

 $query ="select status from $tableIndex where transID='". $transID ."'";
//echo $query;
if(!$result= mysqli_query($con,$query))
{
  //echo mysqli_error($con);
  return "Database error please try again";
   mysqli_close($con);
   exit();
}
$response ="";
$cnt= "User balance cannot be retrived";
while($row = mysqli_fetch_array($result))
{
	$response = $row['status'];
        //echo "nosa";
	//echo $response;
}

return $response;
}			



//&&&&&&&&&&&&&&&&&&&&&&&
//&&&&&&&&&&&&&&&&&&&&&&&



 $username = $_GET["username"];
 $pass = $_GET["pass"];
 $transID=$_GET["transid"];   
 //$phonenumber= $_GET["receiver"];   
 //$mess= $_GET["mess"];  

//$transID= "201912190165560";
//$username="franck";
//$pass ="lovefranck";
 
 if ( ($username =="") || ($pass =="") || ($transID =="")){
   echo "-1";  
   die();
 }

 $mtype ="0";
 $domain = "247sms.com"; 
 
 $response = Checklogin( $username,$domain,$pass);
 if($response != "yes" )
 {
    echo "-3";
    die();
 }
 
// $cnt = count(explode(",", $phonenumber));
 
 
 //echo $transID;
 //echo $username."\n";
// echo $sender."\n";
// echo $phonenumber."\n";
// echo $mess."\n";
 //exit;
 $response = getQuery( $transID,"messagesent");
 
if ($response != "")  
 echo $response;
else{

      $response = getQuery( $transID,"messagesentbackup");
      if($response !="")
         echo $response;
      else
         echo "Record Not Found";
}
 
?>