<?php
include("include/config.php");
$do=mysqli_real_escape_string($con,$_POST['do']);
$response="";
switch($do){
    case "username_check":
        $sponsor_username=mysqli_real_escape_string($con,$_POST['sponsor_username']);
        $optionsQ=mysqli_query($con,"select first_name,last_name from member where username='$sponsor_username'");
        $optionsN=mysqli_num_rows($optionsQ);
        if($optionsN>0){
            $optionsR=mysqli_fetch_array($optionsQ);
            $response=$optionsR['first_name']." ".$optionsR['last_name'];
        }else{
            $response="invalid";
        }
    break;
    case "username_repeat":
        $username=mysqli_real_escape_string($con,$_POST['username']);
        $optionsQ=mysqli_query($con,"select id from member where username='$username'");
        $optionsN=mysqli_num_rows($optionsQ);
        if($optionsN>0){
            $response="invalid";
        }else{
            $response="valid";
        }
    break;
    case "pin_validate":
        $pin=mysqli_real_escape_string($con,$_POST['pin']);
        $optionsQ=mysqli_query($con,"select pin from pin where pin='$pin' username=''");
        $optionsN=mysqli_num_rows($optionsQ);
        if($optionsN>0){
            $response="valid";
        }else{
            $response="invalid";
        }
    break;
    case "leg_validate":
        $leg=mysqli_real_escape_string($con,$_POST['leg']);
        $sponsor_username=mysqli_real_escape_string($con,$_POST['sponsor_username']);
        $optionsQ=mysqli_query($con,"select id from member where position='$leg' AND sponsor_username='$sponsor_username'");
        $optionsN=mysqli_num_rows($optionsQ);
        if($optionsN>0){
            $response="invalid";
        }else{
            $response="valid";
        }
    break;
}
echo json_encode($response);
?>