<?include "$DOCUMENT_ROOT/conf/conf_dir.php";?>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<?
if($idx){
		//회원신청 insert 구문
		$resultU = Get_dbres("SELECT userid,cash_chk,kana_name1 from user where id='$idx'");
		$rowU = mysql_fetch_array($resultU);

		$resultP = Get_dbres("SELECT hanja_name1,en_name1 from user_profiles where user_id='$idx'");
		$rowP = mysql_fetch_array($resultP);
		$chkflag = Get_db("SELECT id from user_cash where user_id = $idx and flag='A'");
		$id = trim($rowU[userid]);
		$id  = strtolower($id);
		if(!$chkflag){

            $query = "INSERT INTO user_cash
                        (user_id,userid,jcname,ccname,ecname,reg_date,flag)
                    VALUES
                        ('$idx','$id','$rowU[kana_name1]','$rowP[hanja_name1]','$rowP[en_name1]',now(),'A')";

            $result = mysql_query($query,$db_con);

                  //입금번호 넣기
                  if($rowU[cash_chk] == 0){
                    //신규일때 신규 입금번호 만듬
                    $chkcashNum = Get_dbres("SELECT id,reg_date from user_cash where user_id = $idx and flag='A'");
                    $rows = mysql_fetch_array($chkcashNum);

                    $loss_date = substr($rows[reg_date],2,10);
                    $loss_date = str_replace("-","",$loss_date);
                    $CHK_NUM = "YC".$loss_date.$rows[id];
                  }else{
                    //연장일때 번호같게함.
                    $cash_no = Get_db("SELECT cash_no from user_cash where user_id = $idx and id='$rowU[cash_chk]'");
                    $CHK_NUM = $cash_no;

                  }

            $queryupok = "update user_cash set cash_no = '$CHK_NUM' where user_id = $idx and flag='A'";
            $queryupok_result = mysql_query($queryupok,$db_con);

		}
}

$pathURL="./mypage.php";

?>
<script>
//alert("保存しました.");
location.href = "<?=$pathURL?>";
</script>