<?

function exeNotify() {
    require "../config.php";
    require 'vendor/autoload.php';
    
    MercadoPago\SDK::setAccessToken(ACCESS_TOKEN_MP); //ENV_ACCESS_TOKEN
    
	$merchant_order = null;

	switch($_GET["topic"]) {
		case "payment":
			$payment = MercadoPago\Payment::find_by_id($_GET["id"]);
			// Get the payment and the corresponding merchant_order reported by the IPN.
			$merchant_order = MercadoPago\MerchantOrder::find_by_id($payment->order->id);
			break;
		case "merchant_order":
			$merchant_order = MercadoPago\MerchantOrder::find_by_id($_GET["id"]);
			break;
	}
	
	if ($payment->status == "approved") {
	    $con = mysqli_connect(HOST,USER,PASSWORD,DATABASE);
        if ($con) {
            mysqli_set_charset($con,'utf8');

            $query = mysqli_query($con,'SELECT * FROM users WHERE email="'.$_GET['email'].'"');
            if ($query && mysqli_num_rows($query) > 0) {
                $data = mysqli_fetch_assoc($query);
                $new_date = date('Y-m-d', strtotime("+".$_GET['days']." days",strtotime($data['renew_date'])));
                $query = mysqli_query($con,"UPDATE users SET renew_date='$new_date', amount_star=".$_GET['amount_star']." WHERE email='".$_GET['email']."'");
                if (isset($_GET['access_point']) && $_GET['access_point'] == 1) {
                    $con_p = mysqli_connect(HOST,USER,PASSWORD,POINT_DATABASE);
                    if ($con_p) {
                        mysqli_set_charset($con_p,"utf8");
                        $query = mysqli_query($con_p,"SELECT * FROM users WHERE email='{$_GET['email']}'");
                        if ($query && mysqli_num_rows($query) > 0) {
                            $data = mysqli_fetch_assoc($query);
                            $new_date = date('Y-m-d', strtotime("+".$_GET['days']." days",strtotime($data['renew_date'])));
                            $query = mysqli_query($con_p,"UPDATE users SET renew_date='$new_date', amount_star={$_GET['amount_star']} WHERE email='{$_GET['email']}'");
                        }
                    }
                    mysqli_close($con_p);
                }
            }
        }
	}
}

if (isset($_POST)) {
    exeNotify();
}

?>