<?php
 session_start();
 $domain ="PenpalAfrica.com";
 $sender ="Penpal";
 $mfrom ="no-reply@PenpalAfrica.com";
$mfromname="PenpalAfrica";
$gate = "2";
function getQuery1( $query)
{

 $cnt ="#";

       $con=mysqli_connect("127.0.0.1","smsEngine","guEnaR28T","smartsmsrouter");
       ///Check connection
 if (mysqli_connect_errno())
 {
         // //echo mysqli_error($con);
         echo "-1";
         return '#';
         die();
 }
 if(!$result= mysqli_query($con,$query))
 {
       mysqli_close($con);
     return "#";
 }
 else
 {
   while($row = mysqli_fetch_array($result))
   {
     $cnt = $row[0];

   }
   mysqli_close($con);
   return $cnt;
 }
}//getQuery1



function getQuery2( $query)
{

 $cnt ="#";

       $con=mysqli_connect("127.0.0.1","smsEngine","guEnaR28T","smartsmsrouter");
       ///Check connection
 if (mysqli_connect_errno())
 {
         // //echo mysqli_error($con);
         echo "-1";
         //return '#';
         die();
 }
 if(!$result= mysqli_query($con,$query))
 {
       mysqli_close($con);
     return "#";
 }
 else
 {
   while($row = mysqli_fetch_array($result))
   {
     $cnt = $row[0].",".$row[1];

   }
   mysqli_close($con);
   return $cnt;
 }
}//getQuery2








function updateQuery( $query)
{

   $cnt ="1";
   $con=mysqli_connect("127.0.0.1","smsEngine","guEnaR28T","smartsmsrouter");
   ///Check connection
   if (mysqli_connect_errno())
      {
       
      return '-1';
      die();
   }



	if(!$result= mysqli_query($con,$query))
	{
  	  $cnt= mysqli_error($con);
   	  mysqli_close($con);
   	  $cnt ="-1";
    
	}
	else
	{
		
	  $cnt= "0";
	  mysqli_close($con);

	}
  return $cnt;
}//updateQuery








  function generateTransID()
   {
      $today = date("Ymd");
      $rand = strtoupper(substr(uniqid(sha1(time())),0,6));
      $unique = $today . $_SESSION['subtransid'] . $rand;
      return $unique;
}

function removePosion($mstr)
{
      $mstring = str_replace("'","^",$mstr);
      return $mstring;
}

 function sendSMS( $username,$phonenumber, $transid, $domain,$mess,$sender,$mtype)
{
 include "connect.php";
if ($mtype =="1"){
    $username="system";
}
$mess= removePosion($mess);
 $sender= removePosion($sender);
 $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);
   return "-1";

}
else
{
$cnt= "0";
mysqli_close($con);
return $cnt;
}

}



?>