dbSelect($_ORD_ITEM_REVIEW,"count(orv_key)","where orv_isshow='Y'"); $sumObj = $_jeDB->getFetchRows($sumSel); $review_num = $sumObj[0]; # 베스트 후기 $search_ym = date("Ym",strtotime("-1 month")-86000); $search_m = substr($search_ym,4,2); $rvwSel = $_jeDB->j_dbSelect2($_ORD_ITEM_REVIEW,$_ORD_ITEM_REVIEW_ATTACH, "a.orv_mem_id,a.orv_ord_pt,a.orv_ord_cd,a.orv_star,a.orv_review,b.*", "on a.orv_key=b.ort_orv_key", "where orv_best='{$search_m}' and from_unixtime(orv_reg_date,'%Y%m')='{$search_ym}' and orv_isshow='Y' order by orv_key desc limit 1"); $rvwNum = intval($_jeDB->getRows()); if(intval($rvwNum) > 0) { $rvwObj = $_jeDB->getFetchAssoc($rvwSel); while(list($key,$val) = each($rvwObj)) ${$key} = $val; # 상품이미지 if($ort_file_name && $ort_file_path) { $itm_img = "/gimg/{$ort_file_path}/{$ort_file_name}"; } else { $_ORD_INFO = ($orv_ord_pt == "A") ? $_ORD_A_INFO : $_ORD_B_INFO; $ordSel = $_jeDB->dbSelect($_ORD_INFO,"item_img_folder,item_img_name,item_img_type","where ord_cd='{$orv_ord_cd}' limit 1"); $ordNum = intval($_jeDB->getRows()); if($ordNum) { $ordObj = $_jeDB->getFetchRows($ordSel); $itm_img_fd = $ordObj[0]; $itm_img_nm = $ordObj[1]; $itm_img_ex = $ordObj[2]; # 상품이미지 $best_itm_img = ""; if($itm_img_fd && $itm_img_ex && $itm_img_nm) { $best_itm_img = $_jeCFunc->getImgUrl($orv_ord_pt,"O",$itm_img_fd,$itm_img_nm,$itm_img_ex); } else { $best_itm_img = "/img/300_300_noim.gif"; } } else { $best_itm_img = "/img/300_300_noim.gif"; } } } */ ?>

재팬엔조이 실제 이용 후기

건

j_dbSelect2($_ORD_ITEM_REVIEW,$_ORD_ITEM_REVIEW_ATTACH, "a.orv_mem_id,a.orv_ord_pt,a.orv_ord_cd,a.orv_star,a.orv_review,b.*", "on a.orv_key=b.ort_orv_key","where a.orv_isshow='Y' and a.orv_view='Y' order by a.orv_reg_date desc limit 5"); $rvwNum = intval($_jeDB->getRows()); if(intval($rvwNum) > 0) { for($r=0;$r<$rvwNum;$r++) { $rvwObj = $_jeDB->getFetchAssoc($rvwSel); while(list($key,$val) = each($rvwObj)) ${$key} = $val; # 상품이미지 if($ort_file_name && $ort_file_path) { $itm_img = "/gimg/{$ort_file_path}/{$ort_file_name}"; } else { $_ORD_INFO = ($orv_ord_pt == "A") ? $_ORD_A_INFO : $_ORD_B_INFO; $ordSel = $_jeDB->dbSelect($_ORD_INFO,"item_img_folder,item_img_name,item_img_type","where ord_cd='{$orv_ord_cd}' limit 1"); $ordNum = intval($_jeDB->getRows()); if($ordNum) { $ordObj = $_jeDB->getFetchRows($ordSel); $itm_img_fd = $ordObj[0]; $itm_img_nm = $ordObj[1]; $itm_img_ex = $ordObj[2]; # 상품이미지 $itm_img = ""; if($itm_img_fd && $itm_img_ex && $itm_img_nm) { $itm_img = $_jeCFunc->getImgUrl($orv_ord_pt,"O",$itm_img_fd,$itm_img_nm,$itm_img_ex); } else { $itm_img = "/img/300_300_noim.gif"; } } else { $itm_img = "/img/300_300_noim.gif"; } } # 상세URL $orv_detail_url = "/community/index.html?hpd=com_reviews"; # 상품정보 echo "

"; } } */ ?>

dbSelect($_MEM_INFO,"mem_grd_cd,mem_name,mem_gender,mem_pk_ecash,mem_pk_mileage","where mem_cd='{$_JE_MCD_}' and mem_id='{$_JE_MID_}'"); $memNum = intval($_jeDB->getRows()); if($memNum > 0) { $memObj = $_jeDB->getFetchAssoc($memSel); while(list($key,$val) = each($memObj)) ${$key} = $val; $mem_grd_str = $_jeCFunc->getMemGradeStr($mem_grd_cd); $mem_name = $_jeCFunc->getCnvtStr($mem_name); $mem_gender_str = ($mem_gender == "M") ? "m" : "f"; $mem_pk_ecash_str = number_format(intval($mem_pk_ecash)); $mem_pk_mileage_str = number_format(intval($mem_pk_mileage)); # 쿠폰갯수 호출 $mcpSel = $_jeDB->dbSelect($_MEM_POCKET_COUPON,"count(mp_key)","where mp_mem_cd='{$_JE_MCD_}' and mp_cp_exp_date > {$_DT_TIMES} and mp_use_date <= 0"); $mcpObj = $_jeDB->getFetchRows($mcpSel); $mem_pk_coupon_str = number_format(intval($mcpObj[0])); } ?>

님

()

로그아웃

캐시

|

적립

|

쿠폰

|

|

|

재팬엔조이를 더 안전하고 유익하게 이용하세요

아이디·비밀번호찾기

회원가입

dbSelect($_GV_EXCHANGE_RATE,"er_jp_jenjoy,er_cn_jenjoy,er_us_jenjoy","where er_isuse='Y' order by er_key desc limit 1"); $exrNum = intval($_jeDB->getRows()); if($exrNum) { $exrObj = $_jeDB->getFetchAssoc($exrSel); while(list($key,$val) = each($exrObj)) ${$key} = $val; $er_jp_jenjoy = number_format($er_jp_jenjoy * 0.01,1); $er_us_jenjoy = number_format($er_us_jenjoy * 0.01,1); $er_cn_jenjoy = number_format($er_cn_jenjoy * 0.01,1); } ?>

1JPY = 원

1USD = 원

dbSelect($_BD_NOTICE,"bd_key,bd_a_subject","order by bd_hot desc,bd_key desc limit 5"); $bbsNum = intval($_jeDB->getRows()); if($bbsNum) { for($b=0;$b<$bbsNum;$b++) { $bbsObj = $_jeDB->getFetchAssoc($bbsSel); while(list($key,$val) = each($bbsObj)) ${$key} = $val; $bd_a_subject = stripslashes(urldecode($bd_a_subject)); $bd_a_subject_str = ($bd_a_subject) ? $_jeCFunc->cut_str2($bd_a_subject,30,". . .") : "제목없음"; echo "

{$bd_a_subject_str}

"; } } ?>

일본 레트로게임 레어 아이템!

재팬엔조이 팝업 스토어 레트로게임!

dbSelect($_VW_MALL_PROD,"*","where prd_isuse='Y' order by rand() limit 8"); $popNum = intval($_jeDB->getRows()); if($popNum) { for($i=0;$i<$popNum; $i++) { $popObj = $_jeDB->getFetchAssoc($popSel); while(list($key, $val) = each($popObj)) ${$key} = trim(stripslashes(urldecode($val))); $iml_icd = $prd_cd; $iml_title = $prd_title; $item_pri_buy = $_jeCFunc->getNumberFormat($prd_sel_pr); $item_pri_buy_str = ""; if($item_pri_buy) { $item_pri_buy_str = "{$item_pri_buy} 원"; } # 이미지 if($prd_img_fd && $prd_img_nm) { $prd_img = $_jeCFunc->getPrdImgUrl("O", $prd_img_fd, $prd_img_nm); $iml_img_url = "/common/imgsrc.html?img=".urlencode($prd_img); } $getDetailUrl = "/item/mall/index.html?itemst=JPGG&itemcd={$iml_icd}"; echo "