<?php

require_once("phpmailer/class.phpmailer.php");
require_once("phpmailer/class.smtp.php");
date_default_timezone_set('Africa/Lagos'); 
$cmd =isset($_POST['cmd']) ? $_POST['cmd'] : '';;

function standingEng( $position,$teamname, $play, $won,$drawn,$loss,$gd,$pts,$league)
{                 

 $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="update standingEng set team ='".$teamname."',p='". $play ."',w='". $won ."',d='". $drawn ."',l='". $loss ."',gd='". $gd ."',pts='". $pts ."',league='". $league ."' where sn=".$position;


  
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;
}

}			





function standingEngTigo( $position,$teamname, $play, $won,$drawn,$loss,$gd,$pts,$league)
{                 

 $cnt ="";
 $con=mysqli_connect("68.169.61.69","smsEngine2","guEnaR28T","smartsmsrouter");
 ///Check connection
 if (mysqli_connect_errno())
   {
   // echo mysqli_error($con);
   //echo "-1";
   die();
   }
   
   
   


 $query="update standingEng set team ='".$teamname."',p='". $play ."',w='". $won ."',d='". $drawn ."',l='". $loss ."',gd='". $gd ."',pts='". $pts ."',league='". $league ."' where sn=".$position;


  
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;
}

}			










function standingSpa( $position,$teamname, $play, $won,$drawn,$loss,$gd,$pts,$league)
{                 

 $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="update standingSpa set team ='".$teamname."',p='". $play ."',w='". $won ."',d='". $drawn ."',l='". $loss ."',gd='". $gd ."',pts='". $pts ."',league='". $league ."' where sn=".$position;



  
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;
}

}			



function standingSpaTigo( $position,$teamname, $play, $won,$drawn,$loss,$gd,$pts,$league)
{                 

 $cnt ="";
 $con=mysqli_connect("68.169.61.69","smsEngine2","guEnaR28T","smartsmsrouter");
 ///Check connection
 if (mysqli_connect_errno())
   {
   // echo mysqli_error($con);
   //echo "-1";
   die();
   }
   
   
   


 $query="update standingSpa set team ='".$teamname."',p='". $play ."',w='". $won ."',d='". $drawn ."',l='". $loss ."',gd='". $gd ."',pts='". $pts ."',league='". $league ."' where sn=".$position;



  
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;
}

}			




function standingfrance( $position,$teamname, $play, $won,$drawn,$loss,$gd,$pts,$league)
{                 

 $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="update standingfrance set team ='".$teamname."',p='". $play ."',w='". $won ."',d='". $drawn ."',l='". $loss ."',gd='". $gd ."',pts='". $pts ."',league='". $league ."' where sn=".$position;



  
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;
}

}			



function standingfranceTigo( $position,$teamname, $play, $won,$drawn,$loss,$gd,$pts,$league)
{                 

 $cnt ="";
 $con=mysqli_connect("68.169.61.69","smsEngine2","guEnaR28T","smartsmsrouter");
 ///Check connection
 if (mysqli_connect_errno())
   {
   // echo mysqli_error($con);
   //echo "-1";
   die();
   }
   
   
   


 $query="update standingfrance set team ='".$teamname."',p='". $play ."',w='". $won ."',d='". $drawn ."',l='". $loss ."',gd='". $gd ."',pts='". $pts ."',league='". $league ."' where sn=".$position;



  
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;
}

}			



function sendSMS( $username, $transid, $domain,$teamhost,$sender,$league,$teamvisitor,$score,$matchstatus,$matchtime,$matchid,$player)
{                 

 $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 messagesentgoalsalert(league,transid,provider,teamhost,senderId,status,domain,dateused,teamvistor,score,matchtime,matchstatus,matchid,player) values ('".$league."','".$transid."','".$username."','".$teamhost. "','". $sender. "','0','". $domain. "','".  date('Y-m-d H:i:s')."','".$teamvisitor."','".$score."','".$matchtime."','".$matchstatus."','".$matchid."','".$player."')";
  
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;
}

}			




function sendSMSadnol( $username, $transid, $domain,$teamhost,$sender,$league,$teamvisitor,$score,$matchstatus,$matchtime,$matchid,$player)
{                 

 $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 messagesentgoalsalertadnol(league,transid,provider,teamhost,senderId,status,domain,dateused,teamvistor,score,matchtime,matchstatus,matchid,player) values ('".$league."','".$transid."','".$username."','".$teamhost. "','". $sender. "','0','". $domain. "','".  date('Y-m-d H:i:s')."','".$teamvisitor."','".$score."','".$matchtime."','".$matchstatus."','".$matchid."','".$player."')";
  
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;
}

}			






function sendSMSTigo( $username, $transid, $domain,$teamhost,$sender,$league,$teamvisitor,$score,$matchstatus,$matchtime,$matchid,$player)
{                 

 $cnt ="";
 $con=mysqli_connect("68.169.61.69","smsEngine2","guEnaR28T","smartsmsrouter");
 ///Check connection
 if (mysqli_connect_errno())
   {
   // echo mysqli_error($con);
   //echo "-1";
   die();
   }
   
 $query="insert messagesentgoalsalertTigo(league,transid,provider,teamhost,senderId,status,domain,dateused,teamvistor,score,matchtime,matchstatus,matchid,player) values ('".$league."','".$transid."','".$username."','".$teamhost. "','". $sender. "','0','". $domain. "','".  date('Y-m-d H:i:s')."','".$teamvisitor."','".$score."','".$matchtime."','".$matchstatus."','".$matchid."','".$player."')";
  
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;
}

}			




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


function generateTransID2()
{                 

 $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="select sn from serialnumber";
  
if(!$result= mysqli_query($con,$query))
{
  //echo mysqli_error($con);
  //echo "Database error please try again";
   mysqli_close($con);
   return "-10";
   die();
}

if(mysqli_num_rows($result) > 0 )
{
  while($row = mysqli_fetch_assoc( $result )) {
	
	$cnt = $row['sn'];
	return $cnt;
  } 

}

mysqli_close($con);

}			



function updategenerateTransID2($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="update serialnumber set sn =".$cnt;
  //echo $query;
if(!$result= mysqli_query($con,$query))
{
  //echo mysqli_error($con);
  //echo "Database error please try again";
   mysqli_close($con);
   die();
}

mysqli_close($con);

}			



//function removeAccents($str)
//{
  //$a = array('�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', 'A', 'a', 'A', 'a', 'A', 'a', 'C', 'c', 'C', 'c', 'C', 'c', 'C', 'c', 'D', 'd', '�', 'd', 'E', 'e', 'E', 'e', 'E', 'e', 'E', 'e', 'E', 'e', 'G', 'g', 'G', 'g', 'G', 'g', 'G', 'g', 'H', 'h', 'H', 'h', 'I', 'i', 'I', 'i', 'I', 'i', 'I', 'i', 'I', 'i', '?', '?', 'J', 'j', 'K', 'k', 'L', 'l', 'L', 'l', 'L', 'l', '?', '?', 'L', 'l', 'N', 'n', 'N', 'n', 'N', 'n', '?', 'O', 'o', 'O', 'o', 'O', 'o', '�', '�', 'R', 'r', 'R', 'r', 'R', 'r', 'S', 's', 'S', 's', 'S', 's', '�', '�', 'T', 't', 'T', 't', 'T', 't', 'U', 'u', 'U', 'u', 'U', 'u', 'U', 'u', 'U', 'u', 'U', 'u', 'W', 'w', 'Y', 'y', '�', 'Z', 'z', 'Z', 'z', '�', '�', '?', '�', 'O', 'o', 'U', 'u', 'A', 'a', 'I', 'i', 'O', 'o', 'U', 'u', 'U', 'u', 'U', 'u', 'U', 'u', 'U', 'u', '?', '?', '?', '?', '?', '?');
  //$b = array('A', 'A', 'A', 'A', 'A', 'A', 'AE', 'C', 'E', 'E', 'E', 'E', 'I', 'I', 'I', 'I', 'D', 'N', 'O', 'O', 'O', 'O', 'O', 'O', 'U', 'U', 'U', 'U', 'Y', 's', 'a', 'a', 'a', 'a', 'a', 'a', 'ae', 'c', 'e', 'e', 'e', 'e', 'i', 'i', 'i', 'i', 'n', 'o', 'o', 'o', 'o', 'o', 'o', 'u', 'u', 'u', 'u', 'y', 'y', 'A', 'a', 'A', 'a', 'A', 'a', 'C', 'c', 'C', 'c', 'C', 'c', 'C', 'c', 'D', 'd', 'D', 'd', 'E', 'e', 'E', 'e', 'E', 'e', 'E', 'e', 'E', 'e', 'G', 'g', 'G', 'g', 'G', 'g', 'G', 'g', 'H', 'h', 'H', 'h', 'I', 'i', 'I', 'i', 'I', 'i', 'I', 'i', 'I', 'i', 'IJ', 'ij', 'J', 'j', 'K', 'k', 'L', 'l', 'L', 'l', 'L', 'l', 'L', 'l', 'l', 'l', 'N', 'n', 'N', 'n', 'N', 'n', 'n', 'O', 'o', 'O', 'o', 'O', 'o', 'OE', 'oe', 'R', 'r', 'R', 'r', 'R', 'r', 'S', 's', 'S', 's', 'S', 's', 'S', 's', 'T', 't', 'T', 't', 'T', 't', 'U', 'u', 'U', 'u', 'U', 'u', 'U', 'u', 'U', 'u', 'U', 'u', 'W', 'w', 'Y', 'y', 'Y', 'Z', 'z', 'Z', 'z', 'Z', 'z', 's', 'f', 'O', 'o', 'U', 'u', 'A', 'a', 'I', 'i', 'O', 'o', 'U', 'u', 'U', 'u', 'U', 'u', 'U', 'u', 'U', 'u', 'A', 'a', 'AE', 'ae', 'O', 'o');
  //return str_replace($a, $b, $str);
//}



function removeAccents($str)
{
  $a = array('á','ó','é','�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', '�', 'A', 'a', 'A', 'a', 'A', 'a', 'C', 'c', 'C', 'c', 'C', 'c', 'C', 'c', 'D', 'd', '�', 'd', 'E', 'e', 'E', 'e', 'E', 'e', 'E', 'e', 'E', 'e', 'G', 'g', 'G', 'g', 'G', 'g', 'G', 'g', 'H', 'h', 'H', 'h', 'I', 'i', 'I', 'i', 'I', 'i', 'I', 'i', 'I', 'i', '?', '?', 'J', 'j', 'K', 'k', 'L', 'l', 'L', 'l', 'L', 'l', '?', '?', 'L', 'l', 'N', 'n', 'N', 'n', 'N', 'n', '?', 'O', 'o', 'O', 'o', 'O', 'o', '�', '�', 'R', 'r', 'R', 'r', 'R', 'r', 'S', 's', 'S', 's', 'S', 's', '�', '�', 'T', 't', 'T', 't', 'T', 't', 'U', 'u', 'U', 'u', 'U', 'u', 'U', 'u', 'U', 'u', 'U', 'u', 'W', 'w', 'Y', 'y', '�', 'Z', 'z', 'Z', 'z', '�', '�', '?', '�', 'O', 'o', 'U', 'u', 'A', 'a', 'I', 'i', 'O', 'o', 'U', 'u', 'U', 'u', 'U', 'u', 'U', 'u', 'U', 'u', '?', '?', '?', '?', '?', '?');
  $b = array('a','o','e','A', 'A', 'A', 'A', 'A', 'A', 'AE', 'C', 'E', 'E', 'E', 'E', 'I', 'I', 'I', 'I', 'D', 'N', 'O', 'O', 'O', 'O', 'O', 'O', 'U', 'U', 'U', 'U', 'Y', 's', 'a', 'a', 'a', 'a', 'a', 'a', 'ae', 'c', 'e', 'e', 'e', 'e', 'i', 'i', 'i', 'i', 'n', 'o', 'o', 'o', 'o', 'o', 'o', 'u', 'u', 'u', 'u', 'y', 'y', 'A', 'a', 'A', 'a', 'A', 'a', 'C', 'c', 'C', 'c', 'C', 'c', 'C', 'c', 'D', 'd', 'D', 'd', 'E', 'e', 'E', 'e', 'E', 'e', 'E', 'e', 'E', 'e', 'G', 'g', 'G', 'g', 'G', 'g', 'G', 'g', 'H', 'h', 'H', 'h', 'I', 'i', 'I', 'i', 'I', 'i', 'I', 'i', 'I', 'i', 'IJ', 'ij', 'J', 'j', 'K', 'k', 'L', 'l', 'L', 'l', 'L', 'l', 'L', 'l', 'l', 'l', 'N', 'n', 'N', 'n', 'N', 'n', 'n', 'O', 'o', 'O', 'o', 'O', 'o', 'OE', 'oe', 'R', 'r', 'R', 'r', 'R', 'r', 'S', 's', 'S', 's', 'S', 's', 'S', 's', 'T', 't', 'T', 't', 'T', 't', 'U', 'u', 'U', 'u', 'U', 'u', 'U', 'u', 'U', 'u', 'U', 'u', 'W', 'w', 'Y', 'y', 'Y', 'Z', 'z', 'Z', 'z', 'Z', 'z', 's', 'f', 'O', 'o', 'U', 'u', 'A', 'a', 'I', 'i', 'O', 'o', 'U', 'u', 'U', 'u', 'U', 'u', 'U', 'u', 'U', 'u', 'A', 'a', 'AE', 'ae', 'O', 'o');
  return str_replace($a, $b, $str);
}


//$args =isset($_POST['args']) ? $_POST['args'] : '';
//$args =isset($_POST['args']) ? $_POST['args'] : '';

//$mess = "http://api.goalapi.com/v2/56ea7522380f82bd8463bec5669622c5/23/Luts?luts=1423656000";
//$response =file_get_contents($mess);

 //$mess = "http://api.goalapi.com/v2/56ea7522380f82bd8463bec5669622c5/23/Updates";
  //$response =file_get_contents($mess);
 // $result = json_decode($response, true);
  //var_dump($result);
 //echo  $result['status']['data']['matches'];
 // echo  $result['data']['matches'];
 //  echo  ['matches'];
  //exit();
  
if ($cmd =="ping"){
$arr = array('status' => 'ok');

 echo json_encode($arr);

}

//$cmd ="acknowledge";
if ($cmd =="acknowledge"){
$arr = array('status' => 'ok');

 echo json_encode($arr);
 
 //start of update
 
 
$now = time();


// doing it instead of `Ids` API call (http://api.goalapi.com/v2/----/--/Ids)
$idsJson = file_get_contents("http://api.goalapi.com/v2/56ea7522380f82bd8463bec5669622c5/23/Ids");
$idsResponseArray = json_decode($idsJson, true);
$idsArray = array();
if (isset($idsResponseArray['data'])) {
	$idsArray = $idsResponseArray['data']; // now we have array of ids
}

// doing it instead of `Updates` API call (http://api.goalapi.com/v2/----/--/Updates)
$dataJson = file_get_contents("http://api.goalapi.com/v2/56ea7522380f82bd8463bec5669622c5/23/Updates");
$dataResponseArray = json_decode($dataJson, true);
$dataArray = array();
if (isset($dataResponseArray['data'])) {
	$dataArray = $dataResponseArray['data']; //now we have array of data
}
$mydata ="";
$mydata2 ="";
$mydata3 ="";
$mydata4 ="";

$matches = array();
if (isset($dataArray['matches']) && is_array($dataArray['matches'])) { //extracting matches from data array
	foreach ($dataArray['matches'] as $item) {
		$match = array(
			'match_id' => $item['i'],
			'published' => !$item['h'],
			'league_id' => $item['l'],
			'teams' => array(
				'hosts' => array(
					'id' => $item['t'][0]
				),
				'visitors' =>  array(
					'id' => $item['t'][1]
				)
			),
			'status' => $item['s']['s'],
			'begintime' => $item['b'], //match begin moment timestamp
			'details' => array(), //match details like season, matchday number, etc...
			'score' => '0-0',
			'events' => array(), //list of events happened in match
			'current' => array(), //current state of match, period, minute, etc...
			'luts' => $item['z'],//last update timestamp
			'crc' => md5(json_encode($item)) //match checksum for any case, to check if data was updated for example
		);



		//populating teams names
		
		$hostsTeamId = $match['teams']['hosts']['id'];
		
		if (isset($idsArray[$hostsTeamId])) {
			$match['teams']['hosts']['names'] = $idsArray[$hostsTeamId];
			//echo $match['league_id'];
			if ($match['league_id'] =="eng_pl"){
			$matchideng = $match['match_id'];
			$teamhosteng=  $match['teams']['hosts']['names'][0];
			$mydata = $teamhosteng;
			}
			if ($match['league_id'] =="spa_ll"){
			$matchidspa = $match['match_id'];
			$teamhostspa=  $match['teams']['hosts']['names'][0];
			$mydata2 = $teamhostspa;
			}
			if ($match['league_id'] =="ucl"){
			$matchiduefa = $match['match_id'];
			$teamhostuefa=  $match['teams']['hosts']['names'][0];
			$mydata3 = $teamhostuefa;
			}
			
			if ($match['league_id'] =="fra_l1"){
			$matchidfrance = $match['match_id'];
			$teamhostfrance=  $match['teams']['hosts']['names'][0];
			$mydata4 = $teamhostfrance;
			}
			
		}

		


		if (isset($item['e'])) {
			$events = array();
			if (is_array($item['e'])) {
				foreach ($item['e'] as $e) {
					if (!isset($e['e']) || !isset($e['p']) || !isset($e['t'])) {
						continue;
					}
					$event = array();
					switch ($e['e']) {
						case 'g':
						    //$response = tracegoal("goals trigger " .$e['p']);
							$event['type'] = 'goal';
							
							   if ($match['league_id'] =="eng_pl"){
					             $playereng = $e['p'];
			              
			                     }
			                   if ($match['league_id'] =="spa_ll"){
			                     $playerspa = $e['p'];
			                     }
		                        if ($match['league_id'] =="ucl"){
			                     $playeruefa = $e['p'];
			                    }
								
								if ($match['league_id'] =="fra_l1"){
			                     $playerfrance = $e['p'];
			                    }
								
							break;
						case 'og':
							$event['type'] = 'own_goal';
							if ($match['league_id'] =="eng_pl"){
					             $playereng = $e['p'];
			              
			                     }
			                   if ($match['league_id'] =="spa_ll"){
			                     $playerspa = $e['p'];
			                     }
		                        if ($match['league_id'] =="ucl"){
			                     $playeruefa = $e['p'];
			                    }
								
								if ($match['league_id'] =="fra_l1"){
			                     $playerfrance = $e['p'];
			                    }
								
							break;
						case 'pg':
							$event['type'] = 'penalty_goal';
							if ($match['league_id'] =="eng_pl"){
					             $playereng = $e['p'];
			              
			                     }
			                   if ($match['league_id'] =="spa_ll"){
			                     $playerspa = $e['p'];
			                     }
		                        if ($match['league_id'] =="ucl"){
			                     $playeruefa = $e['p'];
			                    }
							    if ($match['league_id'] =="fra_l1"){
			                     $playerfrance = $e['p'];
			                    }
							break;
						case 'yc':
							$event['type'] = 'yellow_card';
							break;
						case 'yrc':
							$event['type'] = 'yellow_red_card';
							break;
						case 'rc':
							$event['type'] = 'red_card';
							
							break;
						default:
							continue;
					}
					switch (intval($e['t'])) {
						case 0:
							$event['team'] = 'hosts';
							break;
						case 1:
							$event['team'] = 'visitors';
							break;
					}
					
					

					if (isset($e['m'])) {
						$event['minute'] = $e['m'];
					}
					if (isset($e['s'])) {
						$event['score'] = implode('-', $e['s']);
					}
					$events[] = $event;
				}
			}
			$match['events'] = $events;
		}
		if (isset($item['s']['c'])) {
			$match['score'] = implode('-', $item['s']['c']);
			// $str1= "&nbsp;";
			
			 
		    if ($match['league_id'] =="eng_pl"){
			    $scoreeng= $match['score'];
			}
			if ($match['league_id'] =="spa_ll"){
			     $scorespa= $match['score'];
			}
			if ($match['league_id'] =="ucl"){
			     $scoreuefa= $match['score'];
			}
			
			if ($match['league_id'] =="fra_l1"){
			     $scorefrance = $match['score'];
			  }
		}
        
		
		
		$visitorsTeamId = $match['teams']['visitors']['id'];
		if (isset($idsArray[$visitorsTeamId])) {
			$match['teams']['visitors']['names'] = $idsArray[$visitorsTeamId];
			//print_r ($match['teams']['visitors']['names']);
			   //$str1= "&nbsp;";
		      // print_r($str1);
			
			
			 if ($match['league_id'] =="eng_pl"){
			    $teamvisitoreng = $match['teams']['visitors']['names'][0];
			}
			if ($match['league_id'] =="spa_ll"){
			    $teamvisitorspa = $match['teams']['visitors']['names'][0];
			}
			if ($match['league_id'] =="ucl"){
			      $teamvisitoruefa = $match['teams']['visitors']['names'][0];
			}
			
			if ($match['league_id'] =="fra_l1"){
			      $teamvisitorfrance = $match['teams']['visitors']['names'][0];
			}
		}
		
		
		$current = array();
		if (isset($item['s']['s'])) {
			$current['period'] = $item['s']['s']; // online, finished , not started/
          //  $str1= "&nbsp;";
		//print_r($str1);
			
			 if ($match['league_id'] =="eng_pl"){
			   $matchstatuseng=  $current['period'];
			}
			if ($match['league_id'] =="spa_ll"){
			    $matchstatusspa=  $current['period'];
			}
			if ($match['league_id'] =="ucl"){
			   $matchstatusuefa=  $current['period'];
			}
			if ($match['league_id'] =="fra_l1"){
			      $matchstatusfrance =  $current['period'];
			}
			
			//red card
			
           
			
		}
		
		
		
		
		$current = array();
		if (isset($item['s']['o'])) {
			$current['period'] = $item['s']['o']; //1T, 2T, HT, ET, PS(penalty shootout)
             //$str1= "&nbsp;";
		    // print_r($str1);
			 if ($match['league_id'] =="eng_pl"){
			   $matchstatuseng=  $current['period'];
			}
			if ($match['league_id'] =="spa_ll"){
			    $matchstatusspa=  $current['period'];
			}
			if ($match['league_id'] =="ucl"){
			   $matchstatusuefa=  $current['period'];
			}
			if ($match['league_id'] =="fra_l1"){
			      $matchstatusfrance =  $current['period'];
			}

                        if ($redcardeng =="1"){
			   $matchstatuseng=  "Red Card";
			}
			if  ($redcardspa =="1"){
			    $matchstatusspa=  "Red Card";
			}
			if ($redcarduefa =="1"){
			   $matchstatusuefa=  "Red Card";
			}
			if ($redcardfrance =="1"){
			      $matchstatusfrance =  "Red Card";
			}

			
			if (isset($item['s']['b'])) {
				$current['current_preiod_begintime'] = $item['s']['b']; //is necessary to calculate current minute inside period
			}
			if (isset($current['period']) && in_array($current['period'], array('1T', '2T')) && $current['current_preiod_begintime'] > 0) {
				$minute = intval(($now - $current['current_preiod_begintime']) / 60);
				$injuredMinutes = $minute - 45;
				$minute = min($minute, 45);
				if ('2T' == $current['period']) {
					$minute += 45;
				}
				if ($injuredMinutes > 0) {
					$minute .= "+";
				}
				$match['minute'] = $minute;
				$str1= "&nbsp;";
		       // print_r($str1);
				
				
	        if ($match['league_id'] =="eng_pl"){
			  $matchtimeeng =  $match['minute'];
			}
			if ($match['league_id'] =="spa_ll"){
			 $matchtimespa =  $match['minute'];
			}
			
			if ($match['league_id'] =="ucl"){
			  $matchtimeuefa =  $match['minute'];
			}
			
			if ($match['league_id'] =="fra_l1"){
			  $matchtimefrance =  $match['minute'];
			}
			}
		}
		if (sizeof($current)) {
			$match['current'] = $current;
		}
		
		
		$matchDetails = array();
		if (isset($item['f']['s'])) {
			$matchDetails['season'] = $item['f']['s'];
		}
		if (isset($item['f']['t'])) {
			$matchDetails['round'] = $item['f']['t'];
		}
		if (isset($item['f']['u'])) {
			$matchDetails['playoff_stage'] = $item['f']['u'];
		}
		if (isset($item['f']['g'])) {
			$matchDetails['group'] = $item['f']['g'];
		}
		if (isset($item['f']['f'])) {
			$matchDetails['matchday_number'] = $item['f']['f'];
		}
		$match['details'] = $matchDetails;
		$matches[] = $match;
		
		//send to database
		
		$teamhosteng=removeAccents($teamhosteng);
        $teamhostspa=removeAccents($teamhostspa);
		$teamhostuefa=removeAccents($teamhostuefa);
		$teamhostfrance=removeAccents($teamhostfrance);
		
		$teamvisitoreng=removeAccents($teamvisitoreng);
        $teamvisitorspa=removeAccents($teamvisitorspa);
		$teamvisitoruefa=removeAccents($teamvisitoruefa);
		$teamvisitorfrance=removeAccents($teamvisitorfrance);
		
		$playereng=removeAccents($playereng);
        $playerspa=removeAccents($playerspa);
		$playeruefa=removeAccents($playeruefa);
		$playerfrance=removeAccents($playerfrance);
		
		
		$matchstatuseng = str_replace("online","Live",$matchstatuseng);
        $matchstatuseng = str_replace("finished","Full Time",$matchstatuseng);
        $matchstatuseng = str_replace("HT","Half Time",$matchstatuseng);
        $matchstatuseng = str_replace("2T","2nd Half",$matchstatuseng);
        $matchstatuseng = str_replace("1T","1st Half",$matchstatuseng);
		$matchstatuseng = str_replace("ET","Extra Time",$matchstatuseng);
		$matchstatuseng = str_replace("PS","Penalty Shootout",$matchstatuseng); 
        $matchstatuseng = str_replace("'","^",$matchstatuseng);
          
        $matchstatusspa = str_replace("online","Live",$matchstatusspa);
        $matchstatusspa = str_replace("finished","Full Time",$matchstatusspa);
        $matchstatusspa = str_replace("HT","Half Time",$matchstatusspa);
        $matchstatusspa = str_replace("2T","2nd Half",$matchstatusspa);
        $matchstatusspa = str_replace("1T","1st Half",$matchstatusspa);
		$matchstatusspa = str_replace("ET","Extra Time",$matchstatusspa); 
		$matchstatusspa = str_replace("PS","Penalty Shootout",$matchstatusspa); 
        $matchstatusspa = str_replace("'","^",$matchstatusspa);
       

        $matchstatusuefa = str_replace("online","Live", $matchstatusuefa);
        $matchstatusuefa = str_replace("finished","Full Time", $matchstatusuefa);
        $matchstatusuefa= str_replace("HT","Half Time", $matchstatusuefa);
        $matchstatusuefa = str_replace("2T","2nd Half", $matchstatusuefa);
        $matchstatusuefa = str_replace("1T","1st Half", $matchstatusuefa);
		$matchstatusuefa = str_replace("ET","Extra Time",$matchstatusuefa); 
		$matchstatusuefa = str_replace("PS","Penalty Shootout",$matchstatusuefa); 
        $matchstatusuefa = str_replace("'","^",$matchstatusuefa);
		
		
		$matchstatusfrance = str_replace("online","Live",$matchstatusfrance);
        $matchstatusfrance = str_replace("finished","Full Time",$matchstatusfrance);
        $matchstatusfrance = str_replace("HT","Half Time",$matchstatusfrance);
        $matchstatusfrance = str_replace("2T","2nd Half",$matchstatusfrance);
        $matchstatusfrance = str_replace("1T","1st Half",$matchstatusfrance);
		$matchstatusfrance = str_replace("ET","Extra Time",$matchstatusfrance);
		$matchstatusfrance = str_replace("PS","Penalty Shootout",$matchstatusfrance); 
        $matchstatusfrance = str_replace("'","^",$matchstatusfrance);
		
		
		$domain ="goalsalert.com";
        $sender ="GoalsAlert";
        
        $mtype ="0";
        $username = "system";
 
//$response = sendSMS( $username, $transid, $domain,$mydata,$sender,"1");

if (strlen($mydata) > 0){
    $transID= generateTransID( $matchideng);
	$response = sendSMS( $username, $transID, $domain,$teamhosteng,$sender,"1",$teamvisitoreng,$scoreeng,$matchstatuseng,$matchtimeeng,$matchideng,$playereng);

	$transID= generateTransID2();
    $transID = $transID+1;

	$response = sendSMSadnol( $username, $transID, $domain,$teamhosteng,$sender,"1",$teamvisitoreng,$scoreeng,$matchstatuseng,$matchtimeeng,$matchideng,$playereng);
    $response = sendSMSTigo( $username, $transID, $domain,$teamhosteng,$sender,"1",$teamvisitoreng,$scoreeng,$matchstatuseng,$matchtimeeng,$matchideng,$playereng);

   }
   
   

if (strlen($mydata2) > 0){
     $transID= generateTransID( $matchidspa);
	$response = sendSMS( $username, $transID, $domain,$teamhostspa,$sender,"2",$teamvisitorspa,$scorespa,$matchstatusspa,$matchtimespa,$matchidspa,$playerspa);
	$transID= generateTransID2();
    $transID = $transID+1;
		$response = sendSMSadnol( $username, $transID, $domain,$teamhostspa,$sender,"2",$teamvisitorspa,$scorespa,$matchstatusspa,$matchtimespa,$matchidspa,$playerspa);
	$response = sendSMSTigo( $username, $transID, $domain,$teamhostspa,$sender,"2",$teamvisitorspa,$scorespa,$matchstatusspa,$matchtimespa,$matchidspa,$playerspa);

   }
if (strlen($mydata3) > 0){
     $transID= generateTransID( $matchiduefa);
	$response = sendSMS( $username, $transID, $domain,$teamhostuefa,$sender,"3",$teamvisitoruefa,$scoreuefa,$matchstatusuefa,$matchtimeuefa,$matchiduefa,$playeruefa);
	$transID= generateTransID2();
    $transID = $transID+1;
	
		$response = sendSMSTigo( $username, $transID, $domain,$teamhostuefa,$sender,"3",$teamvisitoruefa,$scoreuefa,$matchstatusuefa,$matchtimeuefa,$matchiduefa,$playeruefa);
	$response = sendSMSTigo( $username, $transID, $domain,$teamhostuefa,$sender,"3",$teamvisitoruefa,$scoreuefa,$matchstatusuefa,$matchtimeuefa,$matchiduefa,$playeruefa);

   }

if (strlen($mydata4) > 0){
      $transID= generateTransID( $matchidfrance);
	$response = sendSMS( $username, $transID, $domain,$teamhostfrance,$sender,"4",$teamvisitorfrance,$scorefrance,$matchstatusfrance,$matchtimefrance,$matchidfrance,$playerfrance);
	
	$transID= generateTransID2();
$transID = $transID+1;
	$response = sendSMSadnol( $username, $transID, $domain,$teamhostfrance,$sender,"4",$teamvisitorfrance,$scorefrance,$matchstatusfrance,$matchtimefrance,$matchidfrance,$playerfrance);
	$response = sendSMSTigo( $username, $transID, $domain,$teamhostfrance,$sender,"4",$teamvisitorfrance,$scorefrance,$matchstatusfrance,$matchtimefrance,$matchidfrance,$playerfrance);
   }


updategenerateTransID2($transID);


$mydata = "";
$mydata2 = "";
$mydata3 = "";
$mydata4 = "";

$teamhostuefa ="";
$teamvisitoruefa="";
$scoreuefa ="";
$matchstatusuefa= "";
$matchtimeuefa="";
$matchiduefa="";

$teamhosteng ="";
$teamvisitoreng="";
$scoreeng ="";
$matchstatuseng= "";
$matchtimeeng="";
$matchideng="";

$teamhostspa ="";
$teamvisitorspa="";
$scorespa ="";
$matchstatusspa= "";
$matchtimespa="";
$matchidspa="";

$teamhostfrance ="";
$teamvisitorfrance="";
$scorefrance ="";
$matchstatusfrance= "";
$matchtimefrance="";
$matchidfrance="";



$playereng = "";
$playerspa = "";
$playeruefa ="";
$playerfrance ="";

$redcardeng ="";
$redcardspa ="";
$redcarduefa ="";
$redcardfrance ="";

			                  

//$response = tracegoal("blank player" .$playereng . " ". $playerspa. " ". $playeruefa);

	}
}



//$mydata = str_replace("Everton","EVE",$mydata);
//$mydata = str_replace("Leicester","LEI",$mydata);
//$mydata = str_replace("Tottenham","TOT",$mydata);
//$mydata = str_replace("West Ham","WHU",$mydata);
//$mydata = str_replace("Man. City","MCI",$mydata);
//$mydata = str_replace("Newcastle Utd","NEW",$mydata);
//$mydata = str_replace("Hull City","HUL",$mydata);
//$mydata = str_replace("QPR","QPR",$mydata);
//$mydata = str_replace("Aston Villa","AVL",$mydata);
//$mydata = str_replace("Stoke City","STK",$mydata);
//$mydata = str_replace("Chelsea","CHE",$mydata);
//$mydata = str_replace("Burnley","BUR",$mydata);
//$mydata = str_replace("Crystal Palace","CRY",$mydata);
//$mydata = str_replace("Arsenal","ARS",$mydata);
//$mydata = str_replace("Sunderland","SUN",$mydata);
//$mydata = str_replace("West Bromwich","WBA",$mydata);
//$mydata = str_replace("Swansea","SWA",$mydata);
//$mydata = str_replace("Man. United","MUN",$mydata);
//$mydata = str_replace("Southampton FC","SOU",$mydata);
//$mydata = str_replace("Liverpool","LIV",$mydata);



//print_r($mydata);
}


$standings = array();
if (isset($dataArray['standings']) && is_array($dataArray['standings'])) { //extracting standings from data array
	foreach ($dataArray['standings'] as $table) {
		$roundId = $table['r'];
		$leagueId = $table['l'];
		foreach ($table['t'] as $row) {
			$detailsArr = array(
				'round' => $roundId
			);
			if (sizeof($row) > 9 && isset($row[9]['g'])) {
				$detailsArr['group'] = $row[9]['g'];
				
			}
			$team = array(
				'id' => $row[1]
				
			);
            
			
			if (isset($idsArray[$team['id']])) {
				$team['names'] = $idsArray[$team['id']];
				//echo $team['names'][0]."<br>"; //= $idsArray[$team['id']];
			}

          //  echo $leagueId;
		//	echo $row[1];
			//echo $row[3];
			// echo $row[6];
			//echo $team['names']['id'];
			$standings = array(
				'league_id' => $leagueId,
				'details' => $detailsArr,
				'position' => $row[0],
				'team' => $team,
				'points' => $row[2],
				'matches' => array(
					'played' => $row[3],
					'won' => $row[4],
					'drawn' => $row[5],
					'lost' => $row[6]
				),
				'goals' => array(
					'scored' => $row[7],
					'conceded' => $row[8]
				)
				
			);
			//echo $standings['league_id'];
			

			if ($standings['league_id'] == "eng_pl")
                {
				  
				  $gd = $standings['goals']['scored'] -  $standings['goals']['conceded'];
				
				  $teamname =     $standings['team']['names'][0];
				  $teamname       =removeAccents($teamname);
				  $play =         $standings['matches']['played'];
				  $won =          $standings['matches']['won'] ;
				  $drawn =        $standings['matches']['drawn'];
				  $loss =         $standings['matches']['lost'];
                  $pts =          $standings['points'] ; 
				  $position =     $standings['position'] ; 
				  $response = standingEng( $position,$teamname, $play, $won,$drawn,$loss,$gd,$pts,'1');
				  $response = standingEngTigo( $position,$teamname, $play, $won,$drawn,$loss,$gd,$pts,'1');
				  	
					
					
				
				  //echo $standings[];
				  //echo $team[0];
                  //echo  $roundId;
                 }	 
			
			//echo "<br><br>";			
			
			if ($standings['league_id'] =="spa_ll")
                {
				    $gd = $standings['goals']['scored'] -  $standings['goals']['conceded'];
				
				  $teamname = $standings['team']['names'][0];
				  $teamname       =removeAccents($teamname);
				  $play =     $standings['matches']['played'];
				  $won =      $standings['matches']['won'] ;
				  $drawn =    $standings['matches']['drawn'];
				  $loss =     $standings['matches']['lost'];
                  $pts =      $standings['points'] ; 
				  $position =     $standings['position'] ; 
				  $response = standingSpa( $position,$teamname, $play, $won,$drawn,$loss,$gd,$pts,'2');
				  $response = standingSpaTigo( $position,$teamname, $play, $won,$drawn,$loss,$gd,$pts,'2');
                 }
			
			
			if ($standings['league_id'] =="fra_l1")
                {
				    $gd = $standings['goals']['scored'] -  $standings['goals']['conceded'];
				
				  $teamname = $standings['team']['names'][0];
				  $teamname       =removeAccents($teamname);
				  $play =     $standings['matches']['played'];
				  $won =      $standings['matches']['won'] ;
				  $drawn =    $standings['matches']['drawn'];
				  $loss =     $standings['matches']['lost'];
                  $pts =      $standings['points'] ; 
				  $position =     $standings['position'] ; 
				  $response = standingfrance( $position,$teamname, $play, $won,$drawn,$loss,$gd,$pts,'4');
				  $response = standingfranceTigo( $position,$teamname, $play, $won,$drawn,$loss,$gd,$pts,'4');
                 }
			 
		}

	}
}


?>