<?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
 {
	$goalalert=array();
	$cnt =0;
   while($row = mysqli_fetch_array($result))
   {
       
       if ($row[5]=="1"){
         $leagueName= "Premiership";	
        }
  

	 if ($row[5]=="2"){
         $leagueName= "LA LIGA";	
        }
	
	 if ($row[5]=="3"){
         $leagueName= "UEFA Champions";	
        }
	
	 if ($row[5]=="4"){
         $leagueName= "France Ligue 1";	
        }
	
 	if ($row[5]=="5"){
         $leagueName= "UEFA Europa";	
        }
	
	$goalalert[$cnt] = array("teamhost"=>$row[0], "teamvisitor"=>$row[1], "score"=>$row[2],"matchtime"=>$row[3],"matchstatus"=>$row[4],"league"=>$leagueName);
        $cnt++;

	
   }
   echo json_encode($goalalert);

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






function standingEng( $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
 {
	$goalalert=array();
	$cnt =0;
   while($row = mysqli_fetch_array($result))
   {
       
	
	$goalalert[$cnt] = array("SN"=>$row[0],"team"=>$row[1], "P"=>$row[2], "W"=>$row[3],"D"=>$row[4],"L"=>$row[5],"GD"=>$row[6], 
        "PTS"=>$row[7],"P1"=>$row[8],"P2"=>$row[9],"P3"=>$row[10],"P4"=>$row[11],"P5"=>$row[12]);
        $cnt++;

	

   }
   echo json_encode($goalalert);

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


function updateQuery( $query)
{

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



	if(!$result= mysqli_query($con,$query))
	{
  	  echo mysqli_error($con);
  	  //echo "Database error please try again";
   	  mysqli_close($con);
   	  return "-1";
    //echo "james";
	}
	else
	{
		//echo "nosaMary".$query;
	  $cnt= "0";
	  mysqli_close($con);

	}
  return $cnt;
}//updateQuery








  function generateTransID()
   {
      $today = date("Ymd");
      $rand = strtoupper(substr(uniqid(sha1(time())),0,4));
      $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;
}

}



?>