function gainEXP($email,$gain){
    global $con;
    $query = "select * from t1_members where email='$email' limit 1";
    $result = mysqli_query ($con, $query);
    $rows = mysqli_fetch_array($result);
    //print_r2($rows);
    //echo $rows['exp'];    
    $Exp = 0;
    $MaxExp = 0;
    $Remain = 0;
    $Exp = (double)$rows['exp'];
    $MaxExp = (double)$rows['maxExp'];
    $Remain = (double)$rows['remain'];
    $Exp += (double)$gain;
    
    if($Exp >= $MaxExp){
        $Remain = $Exp - $MaxExp;  //remain 1레벨 총량
        LevelUp($email,$Remain);
    }
    
    $sql = "update t1_members set exp='$Exp', maxExp='$MaxExp', remain='$Remain' where email='$email'";
    //alert($sql);
    
    $row = mysqli_query($con,$sql);
    //mysqli_error();
    //die( "mysqli connect error : " . mysqli_error() );
}

function LevelUp($email, $remainingEXP){
    global $con;
    //alert($remainingEXP);
    $query = "select * from t1_members where email='$email' limit 1";
    $result = mysqli_query ($con,$query);
    $rows = mysqli_fetch_array($result);
    $Exp = 0;
    $MaxExp = 0;
    $Remain = 0;
    $Level = 0;
    
    $Exp = (double)$rows['exp'];
    $MaxExp = (double)$rows['maxExp'];
    $Remain = (double)$rows['remain'];
    $Level = (double)$rows['level'];
    if($Level===0){
        $Level=1;
    }    
    $Exp += (double)$remainingEXP;
    $Level++;
    $MaxExp = (double)(125 * $MaxExp)/100;
    $sql = "update t1_members set level ='$Level', exp='$Exp', maxExp='$MaxExp', remain='$Remain' where email='$email'";
    $row = mysqli_query($con, $sql);    
    gainEXP($email,0);
    //die( "mysqli connect error : " . mysqli_error() );
}