<?php
if($sessionIDX){
	$mIdx = $sessionIDX;
	$EN_NMAE = $_SESSION[S_NAME];
	$qry = Get_dbres("select * from user as a join user_profiles as b on a.id=b.user_id where a.id = '$mIdx'");
	$row = mysql_fetch_array($qry);
	$created = substr($row[created],0,10);
	$email = $row[email];
	$nickName = $row[nickname];
	$kana_name = $row[kana_name1];
	$hanja_name = $row[hanja_name1];
	$en_name = $row[en_name1];

	$birthday = $row[birthday];
	$birthday	= explode("-","$birthday");
	$zip= $row[zip];
	$point_total = $row[m_point];
	if($zip) $zip ="(".$zip.")";
	$juso= $row[juso];
	$tel = $row[tel];
	if(!$tel) $tel = "<span class='font_red'>未登録</span>";
	if($row[m_img_chk]=="Y")
	{
	 $m_img_chk =  "公開";
	 $m_img_big = "<img src='/files/uprofile/".$row[m_img]."' width='100%' >";
	 $m_img = "/files/uprofile/".$row[m_img];
	}
	else
	{
	 $m_img_chk =  "非公開";
	 $m_img_big = "<img src='../images/sub/myp_profile_img.png'>";
	 $m_img = "../images/sub/icon_emoticon_bg.png";
	}
	$m_color = get_db("select color from user_color where no='$row[m_color]'");
	if(!$m_color) $m_color="#26D181";
	if($row[auth_code] >= 10)
	{
	$class_name = "正会員";
	$class_number = "<li class='padding_b_40'>会員番号 : $row[member_code] </li>";

		/*FP 메달 시작*/
		//정회원 총인원
		$total_member = Get_db("select count(*) from user where auth_code=10 and activated=1 and m_point !=0");
		// 자신의 점수보다 높은 사람들을 카운트
		$result_rank = Get_db("select count(*) as cnt from user where m_point > (SELECT m_point FROM user where id = '$mIdx') and auth_code=10 and activated=1");
		if($result_rank != 0) 		$persent =round(($result_rank / $total_member) *100); //% 구하는공식
		else $persent=100;

		if($persent < 5){
			$MY_LEVEL_IMG = "<img src='../images/sub/icon_ranking4.png'/>";
			$MY_LEVEL = "$MY_LEVEL_IMG <span class='color_rank_legend font_size_16'>Legend</span>";
		}elseif($persent < 15){
			$MY_LEVEL_IMG = "<img src='../images/sub/icon_ranking5.png'/>";
			$MY_LEVEL = "$MY_LEVEL_IMG <span class='color_rank_gold font_size_16'>Gold</span>";
		}elseif($persent < 30){
			$MY_LEVEL_IMG = "<img src='../images/sub/icon_ranking6.png'/>";
			$MY_LEVEL = "$MY_LEVEL_IMG <span class='color_rank_silver font_size_16'>Sliver</span>";
		}elseif($persent < 50){
			$MY_LEVEL_IMG = "<img src='../images/sub/icon_ranking7.png'/>";
			$MY_LEVEL = "$MY_LEVEL_IMG <span class='color_rank_bronze font_size_16'>Bronze</span>";
		}else{
			$MY_LEVEL_IMG = "<img src='../images/sub/icon_ranking7.png'/>";
			$MY_LEVEL = "$MY_LEVEL_IMG <span class='color_rank_bronze font_size_16'>Bronze</span>";
		}

		if($persent == 100) $result_rank = "-- "; //결과값출력
		else $result_rank = number_format($result_rank+1); //결과값출력
		/*FP 메달 끝*/
	}else{
	$class_name = "一般会員";
	$class_number = "";
	}



}else{
  LoginCheck();
}
//답글달면 알려주기.
$QnANum=get_db("SELECT count(*) FROM board_qna where user_no = '$sessionIDX' and is_delete ='N' AND original_no ='1' AND modify_date >='$today' ORDER BY is_notice asc,no desc");
if($QnANum != 0) $QnACOUNT ="<span class='font_red'>$QnANum</span>";
$STORENUM=get_db("SELECT count(*) FROM shop_order where mbruid = '1' and orderstep='2' AND d_bank >='$today' "); // 입금완료되면 알려주기

if($STORENUM != 0) $STORECOUNT ="<span class='font_red'>$STORENUM</span>";
			$MYPAGE_LEFT = "
			<div class='myp_left'>
				<div id='tob_bar_ls1'>
					<div class='myp_left_profile_area' style='background-color: $m_color ;overflow: hidden; position: relative; '>
					$m_img_big
					</div>
				<div class='myp_left_infor'>
					<ul>
					 <li class='padding_b_40 font_bold'>$MY_LEVEL_IMG $nickName  様</li>
					 <!--<li class='padding_b_40'>ニックネーム : $nickName 様 </li>-->

					 <li class='padding_b_40'>会員レベル : $class_name </li>
					 $class_number
					 <li class='padding_b_40'>入会日 : $created </li>
					 <li class='padding_b_40'>保有 FP : $point_total FP </li>
					</ul>
				 </div>
				</div>
		 </div>
		 ";

		 //XIA_CODE 페이지 오픈 시간
     //$XIA_dateTime = "20190219190000";
		 $XIA_dateTime = "20190219180000";
		 if($row[auth_code] >= 10 && $date['totime'] >=$XIA_dateTime){
			//	$add_menu = "<a href='$URL_MYPAGE_EV'><li class='$MENU_CLASS6'>XIAファンクラブ先行</li></a>";
		 }
			//MYPAGE MENU =======================================================
			$MYPAGE_MENU = "<ul>
																				<a href='$URL_MYPAGE'><li class='$MENU_CLASS1'>会員情報</li></a>
																				<a href='$URL_MYPAGE_QNA'><li class='$MENU_CLASS2'>Q&A $QnACOUNT</li></a>
																				<a href='$URL_MYPAGE_STO'><li class='$MENU_CLASS3'>STORE $STORECOUNT</li></a>
																				<a href='$URL_MYPAGE_FT'><li class='$MENU_CLASS4'>FP </li></a>
																				<a href='$URL_MYPAGE_BK'><li class='$MENU_CLASS5'>書き込み</li></a>
																				$add_menu
																			</ul>";

			$MYP_SUBMENU ="<ul>
																			<a href='$URL_MYPAGE_BK'><li class='$SUB_CLASS1'>書き込み</li></a>
																			<a href='$URL_MYPAGE_BK2'><li class='$SUB_CLASS2'>コメント</li></a>
																			<a href='$URL_MYPAGE_BK3'><li class='$SUB_CLASS3'>いいね</li></a>
																		</ul>";
?>