<?php include("config.php"); ?>
<?php
if (isset($_GET['code'])) {
    $res = [];
    $school_code = $_GET['code'];
    if ($school_code != "" && $school_code != "0") {
        $sel_school = mysqli_query($con, "SELECT * FROM schools WHERE is_active=1 AND school_code='$school_code'");
        $expiry_date = "";
        $custom_db = '';
        $custom_db_user = '';
        $custom_db_pwd = '';
        while ($rows = mysqli_fetch_array($sel_school)) {
            $expiry_date = $rows['expiry_date'];
            $custom_db = $rows['db'];
            $custom_db_user = $rows['db_user'];
            $custom_db_pwd = $rows['db_pwd'];
        }
        if ($custom_db != "" || $custom_db_user != "" || $custom_db_pwd != "") {
            if ($expiry_date != "") {
                if ((strtotime($expiry_date)) >= (time())) {
                    $res['status'] = 1;
                    $res['message'] = "Database connection established.";
                } else {
                    $expiry_date1 = Date('d-m-Y', strtotime($expiry_date));
                    $res['status'] = 0;
                    $res['message'] = "Your software has been expired on $expiry_date1. please contact to administrator.";
                }
            } else {
                $res['status'] = 0;
                $res['message'] = "Date is not valid please contact to administrator.";
            }
        } else {
                $res['status'] = 0;
                $res['message'] = "Invalid school code please contact to administrator.";
        }
    } else {
        $res['status'] = 0;
        $res['message'] = "School Code is required.";
    }
}
else {
    $res['status'] = 0;
    $res['message'] = "School Code is required.";
}
echo json_encode($res);
?>