<?php
header("Content-Type: text/html; charset=utf-8");
date_default_timezone_set('PRC');
require_once __DIR__ . '/configure.php';

$username = $_GET['username'];
$password = $_GET['password'];

if(isset($username)) {
	$db = new Connect;
	$data = $db->prepare("select id, hyid from vpnuser where vuser='".$username."' and vpass = '".$password."'");
	$data->execute();
	$row = $data->fetch(PDO::FETCH_ASSOC);

	if (empty($row)){
		echo json_encode([
			"status" => 401,
			"message" => "User doesn't exist!",
		]);
		return;
	} else{
		$servers = array();
		$server_sql = $db->prepare("select id, ipname, country, ip, config, port, protocol, hyid, is_auto  from vpnlinek where su=1 and is_auto != 2 and hyid <= '".$row['hyid']."' and protocol IN ('IKEV2', 'PPTP', 'L2TP', 'OpenVPN', 'SSTP', 'V2RAY') ORDER BY sx ASC");
		$server_sql->execute();

		$i = 0;
		while($outputData = $server_sql->fetch(PDO::FETCH_ASSOC)){
			$servers["status"]= 200;
			$servers["message"]= "Data Found";
			$servers["data"][$i] = $outputData;
			$i++;
		}
		if(empty($servers))
		{
			$servers["status"]= "200";
			$servers["message"]= "No server";
			$servers["data"]= [];
		}
		echo json_encode($servers);
	}
} else {
	echo json_encode([
		"status" => 401,
		"message" => "User id are required!",
	]);
	return;
}
?>