<?include "$DOCUMENT_ROOT/conf/conf_dir.php";?>

<meta http-equiv='Content-Type' content='text/html; charset=UTF-8' />

<?
/*
echo"id : $sessionIDX <Br>";
echo"id : $sessionID <Br>";
echo"goodname : $goodname <Br>";
echo"price : $price";
*/
if($sessionIDX && $goodname && $price){
	$orderstep =1; //1 : 경매대기,2 : 경매당첨,6 : 경매취소
	$res = Get_dbres("select username,email from user where id = '$sessionIDX'");
	$row	= mysql_fetch_array($res);
	$username = mb_convert_kana($row[username], "rs", "utf-8");

	$resub = Get_dbres("select * from user_profiles where user_id = '$sessionIDX'");
	$rows	= mysql_fetch_array($resub);
	$tel = mb_convert_kana($rows[tel], "a", "utf-8");
	$o_zip =  mb_convert_kana($rows[zip1], "a", "utf-8")."-".mb_convert_kana($rows[zip2], "a", "utf-8");
	$juso	= $rows[juso];
	
	

	$query = "INSERT INTO `jyjsite`.`AUCTION_EVENT` 
	(`no`, `orderstep`, `goodsuid`, `price`, `mbruid`, `member_id`, `o_name`, `o_email`, `o_tel`, `o_zip`, `o_addr`,`d_regis`) 
	VALUES 
	(NULL, '$orderstep', '$goodname', '$price', '$sessionIDX', '$sessionID', '$username', '$row[email]', '$tel', '$o_zip', '$juso', now());";
	
	$result = mysql_query($query,$db_con);

	echo "<script>alert('入力した金額に正常参加できました。');parent.location.href='/event/event2.html';</script>";
}else{
	echo "<script>alert('情報が正しくありません。もう一度入力お願いします。');parent.location.href='/event/event2.html';</script>";
}
?>