<?php


if ($_SERVER['REQUEST_METHOD'] == 'OPTIONS') {
    header('Access-Control-Allow-Origin : *');
    header('Access-Control-Allow-Methods : POST, GET, OPTIONS, PUT, DELETE');
    header('Access-Control-Allow-Headers : *');
    exit;
}



header("Access-Control-Allow-Origin: *");
header("Access-Control-Allow-Headers: Content-Type, origin");
//echo "success";



include "general.php";
include "connect.php";

$userUID =$_GET["userUID"];
$sn =$_GET["sn"];
$gender =$_GET["gender"];
date_default_timezone_set('africa/lagos');


if (($userUID !="") && ($gender != "")){

    //get the total records
    $query ="select sn,count(*) as tot from penpalprofile where gender ='$gender'";
    $response = getQuery2($query);
    $splitResponse = explode(",", $response);
    $totalRecord = $splitResponse[1];

    $cnt=1;

    //get the last search
     //get the total records
     $query ="select sn,last_sn from penpalprofile where uid ='$userUID'";
     $response = getQuery2($query);
     $splitResponse = explode(",", $response);
     $sn = $splitResponse[1];

do {
  
        $query ="select sn,uid from penpalprofile where uid !='$userUID' and gender ='$gender'and sn >$sn order by sn asc limit 1";
        $response = getQuery2($query);
        
        if($response !="#"){
            $splitResponse = explode(",", $response);
            $nextSN = $splitResponse[0];
            $frdUID = $splitResponse[1];
        
            //check if uid is in the friendlist
            $query ="select uid,fuid from penpalfriendlist where uid='$userUID' and fuid='$frdUID'";
            $queryFriend = getQuery2($query);
            if($queryFriend=="#"){
                echo $frdUID; 
               //update last_sn 
               updateQuery("update penpalprofile set last_sn ='$nextSN' where uid ='$userUID'");

               //insert to friendlist
               //updateQuery("insert into penpalfriendlist(uid,fuid) values('$userUID','$frdUID')");

                //store $sn for next;
                exit();
            }else{
    
              $sn++;
              $cnt++;
            }//
        
        }else{
            //check if sn is last record 

            $query ="select sn,uid from penpalprofile order by sn desc limit 1";
            //echo $query;
            $response = getQuery2($query);
            $splitResponse = explode(",", $response);
            $nextSN = $splitResponse[0];
            if($nextSN < $sn){
                $sn++;
                $cnt++;
            }else{
                $sn=0;
                $cnt++;
            }
            
        }
    
} while ($cnt <= $totalRecord);
echo "#";
}

?>