<?php
include "general.php";
include "connect.php";


// Read the JSON file 
$json = file_get_contents("penpalasia.json");


$json_data = json_decode($json, true);
$cnt=0;
foreach ($json_data as $key1 => $value1) {

  foreach($value1 as $elem)  {


   

   $age= $elem['age'];
   $reg_date = date('Y/m/d', strtotime("-$age years"));
  //print_r( substr($reg_date,0,10));
  $timestamp= $elem['registered_at']/1000;
  $tempDate = date("Y-m-d H:i:s", $timestamp);
//  echo $tempDate;
  
   $name=$elem['userName'];
   $birthDate=$reg_date;
   $country= $elem['country'];
   $dateCreated=  $tempDate;
   $email= $elem['email'];
   $emailverified= "false";
   $gender=$elem['gender'];
   if($gender=="M"){
    $genderSearch="F";
   }{
    $genderSearch="M";
   }
   
   $lastSeen= $dateCreated;
   $location= $elem['location'];
   $location= str_replace("'","^",$location);
   $phonenumber= $elem['phone'];
   $photoUpload= "false";
   $photo_url1= $elem['photo'];
   $profileMessage= $elem['profileMessage'];
   $profileMessage=str_replace("'","^",$profileMessage);
   if(strlen($profileMessage)> 200){
       $profileMessage= substr($profileMessage,1,200);
   }
   $userToken ="web";
   $userType="1";
   $domain= "penpalasia.com";

   date_default_timezone_set('africa/lagos');



	$query ="insert into penpal (name,phonenumber,email,status,country,location,gender,birthDate,photo_url1,profileMessage,emailverified,lastSeen,photoUpload,userToken,userType,dateCreated,migrated,domain) VALUES ('$name','$phonenumber','$email','1','$country','$location','$gender','$birthDate','$photo_url1','$profileMessage','$emailverified','$lastSeen','$photoUpload','$userToken','$userType','$dateCreated','1','$domain')";

    //echo $query;
	$queryresponse = updateQuery($query);
      //  echo $queryresponse;
        $cnt++;
        echo "$cnt $name $email  $queryresponse ****done***\n";
        sleep(2);
   
   //echo $elem;
}
}
 //$last_error = json_last_error_msg();
   //if(strtolower($last_error) != "No Error") {
 //     echo "ERROR: " . $last_error; die; 
 // }

?>