<?php
$path = $_SERVER['DOCUMENT_ROOT'];
include_once $path . '/connect_db.php';

$sql = "SELECT `adid`, `url` FROM `ads` WHERE `date` = '' AND `url` != ''  ORDER BY `adid` LIMIT 1";
echo "Select sql: ".$sql."<br>";
$res_ads = $connect->query($sql);
// $res_ads = $connect->query("SELECT `adid`, `url` FROM `ads` WHERE `date` = '' AND `url` != '' ORDER BY RAND() LIMIT 1");

if ($res_ads->num_rows > 0) {
	$row = $res_ads->fetch_array(MYSQLI_ASSOC);
	$adid = $row['adid'];
	$url = $row['url'];

	$curl = curl_init();

	curl_setopt_array($curl, [
		CURLOPT_URL => "https://zozor54-whois-lookup-v1.p.rapidapi.com/?domain=$url&format=json",
		CURLOPT_RETURNTRANSFER => true,
		CURLOPT_FOLLOWLOCATION => true,
		CURLOPT_ENCODING => "",
		CURLOPT_MAXREDIRS => 10,
		CURLOPT_TIMEOUT => 30,
		CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
		CURLOPT_CUSTOMREQUEST => "GET",
		CURLOPT_HTTPHEADER => [
			"X-RapidAPI-Host: zozor54-whois-lookup-v1.p.rapidapi.com",
			"X-RapidAPI-Key: 8a6851c9c1mshab5807841fb7c40p102705jsn9f17ab591e41"
		],
	]);

	$response = curl_exec($curl);
	$err = curl_error($curl);
	//echo $response;
	curl_close($curl);

	if ($err) {
		echo "cURL Error #:" . $err;
	} else {
		$res = json_decode($response,true);
		// echo "<pre>";
		// print_r($res);

		$created = date('Y', strtotime($res['created']));
		//echo $created;
		if (!empty($created)) {
			$connect->query("UPDATE `ads` SET `date` = '$created' WHERE `adid` = '$adid'") || die("ERROR: ".$connect->error);
			echo "<b>`$url`</b> scraped done and date inserted. <b>ID: $adid</b>";
		}else{
			$connect->query("UPDATE `ads` SET `date` = '1' WHERE `adid` = '$adid'") || die("ERROR: ".$connect->error);
			echo "<b>`$url`</b> this domain is not registered and in db set to 1 <b>ID: $adid</b>";
		}
		echo ' <meta http-equiv="refresh" content="3">';
	}
}else{
	echo "No ads left to get who is data";
	echo '<script>window.location.href = "/staff/validation/3.plural_check.php";</script>';
}

?>