<?php
include "connect.php";
function getURL( $id)
{
 include "connect.php";
   
 $query="select URL from links where id='". $id. "';";
  
 //echo $query; 
// $query ="select * from userlogin where email='". $memail ."' and domain='". $domain."'";
//echo $query;
$URL= "#";
if(!$result= mysqli_query($con,$query))
{
  //echo mysqli_error($con);
  echo "Database error please try again";
   mysqli_close($con);
   return $URL;
  
}
else
{



while($row = mysqli_fetch_array($result))
{
	$URL = $row['URL'];
	//$cnt="yes";
}
mysqli_close($con);
return $URL;
}
}

	
	
  $id =$_GET["id"];
  $id2 =$_GET["id2"];
  $response = getURL($id);
  //echo $response;
  //exit(1);
  
  if ($response !="#")
  
  {
  
  
      $query ="INSERT INTO linkscounter (id,cnt)  VALUES ('". $id."',1)";
      if(!$result= mysqli_query($con,$query))
        {
         //echo mysqli_error($con);
              header('Location: error.php?err=2');
              mysqli_close($con);
              die();
         }
		 
	   if ($id2 != "")
	     {
          
		     
			 $query ="update linksdetails set status ='1' where id= '$id' and id2 ='$1d' ";
             if(!$result= mysqli_query($con,$query))
              {
                //echo mysqli_error($con);
                  header('Location: error.php?err=3');
                  mysqli_close($con);
                 die();
         }
		 
		 
		 }
         mysqli_close($con);
       header('Location: '.$response);
	   exit();
  }else
      {
	   mysqli_close($con);
     header('Location: errorredirecting.php?err=1');
	 exit();
  }
  


  

?>