레벨업 함수인데요 레벨이 1증가도 안하고 랜덤으로 증가하구요 채택완료

</p>

<p> </p>

<p>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);</p>

<p>    //print_r2($rows);

    //echo $rows['exp'];    

    $Exp = 0;

    $MaxExp = 0;

    $Remain = 0;</p>

<p>    $Exp = (double)$rows['exp'];

    $MaxExp = (double)$rows['maxExp'];

    $Remain = (double)$rows['remain'];</p>

<p>    $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() );

}</p>

<p>

function LevelUp($email, $remainingEXP){

    global $con;

    //alert($remainingEXP);</p>

<p>    $query = "select * from t1_members where email='$email' limit 1";

    $result = mysqli_query ($con,$query);

    $rows = mysqli_fetch_array($result);</p>

<p>    $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;

    }    </p>

<p>    $Exp += (double)$remainingEXP;

    $Level++;

    $MaxExp = (double)(125 * $MaxExp)/100;</p>

<p>    $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() );

}</p>

<p> </p>

<p> </p>

<p>