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






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

$email =$_POST["email"];
$domain =$_POST["domain"];
$gender =$_POST["gender"];
date_default_timezone_set('africa/lagos');


if (($email !="") && ($gender != "")){
    $lastSearchID = "";
   //get user's last search 

    $query ="select lastsearchID from penpallastsearch where email = '$email' and gender ='$gender' and domain ='$domain'";
    $resSearch = getQuery1($query);
    if ($resSearch =="#"){

              //get the total records
    		$query ="select sn from penpal where gender ='$gender' and domain ='$domain' order by sn  desc limit 1";
    		$totalRecord = getQuery1($query);
                $lastSearchID = $totalRecord;
 
    }else{
       if (($resSearch-1) > 0){
       $lastSearchID = $resSearch-1;
       }else{
          $query ="select sn from penpal where gender ='$gender' and domain ='$domain' order by sn  desc limit 1";
    		$totalRecord = getQuery1($query);
                $lastSearchID = $totalRecord;
       }

    }


    
    
do {
  
        //$query ="select sn,uid from penpalprofile where uid !='$email' and gender ='$gender'and sn >$sn order by sn asc limit 1";    

        $query = "select sn, email from penpal where email  != '$email' and gender ='$gender' and sn <= $lastSearchID and domain ='$domain' and deleteaccount='0' and deleteaccount='0' order by sn desc limit 1";
       
        $response = getQuery2($query);
        
        if($response !="#"){
            $splitResponse = explode(",", $response);
            $nextSN = $splitResponse[0];
            $frdEmail = $splitResponse[1];
        
            //check if email is in the friendlist
            $query ="select email_f from penpalFriends where email_u='$email' and email_f='$frdEmail' and domain ='$domain'";
            $queryFriend = getQuery2($query);
            if($queryFriend=="#"){
                echo $frdEmail; 
               //update 
               //updateQuery("update penpalprofile set last_sn ='$nextSN' where uid ='$email'");
              // $query=  "select lastsearchID from penpallastsearch where email = '$email' and gender ='$gender'
              if ($resSearch=="#"){
                 //echo "james";
                $query ="Insert into penpallastsearch( email,gender, lastsearchID,domain) values ('$email','$gender','$nextSN','$domain')";   
	      }else{
                //echo "nosa";
		$query = "update penpallastsearch set lastsearchID ='$nextSN' where email = '$email' and gender ='$gender' and domain ='$domain'";
		}
	    $updateResponse = updateQuery($query);
                
                exit();
            }else{
             
              $lastSearchID--;
              
            }//
        
        }else{
            //no record found  . Move record to last point
             $query ="select sn from penpal where gender ='$gender' and domain ='$domain' and deleteaccount='0' order by sn  desc limit 1";
    		$totalRecord = getQuery1($query);
                $lastSearchID = $totalRecord;

            //echo "#";
            //exit();
        }
    
} while ( $lastSearchID >= 1);
echo "#";

}

?>