분류 오류 채택완료
골뱅이123
4년 전
조회 3,434
안녕하세요 기존 g5_ 테이블명일때는 잘됫는데 pointplus_ 테이블명 바꾸니 이러한 증상이 뜹니다.
어디 고쳐야할까요 ㅠㅠ
</p>
<p><?php</p>
<p>$sub_menu = '400200';</p>
<p>include_once('./_common.php');</p>
<p> </p>
<p>auth_check($auth[$sub_menu], "r");</p>
<p> </p>
<p>$g5['title'] = '분류관리';</p>
<p>include_once (G5_ADMIN_PATH.'/admin.head.php');</p>
<p> </p>
<p>$where = " where ";</p>
<p>$sql_search = "";</p>
<p>if ($stx != "") {</p>
<p> if ($sfl != "") {</p>
<p> $sql_search .= " $where $sfl like '$stx' ";</p>
<p> $where = " and ";</p>
<p> }</p>
<p> if ($save_stx && ($save_stx != $stx))</p>
<p> $page = 1;</p>
<p>}</p>
<p> </p>
<p>$sql_common = " from {$g5['g5_shop_category_table']} ";</p>
<p>if ($is_admin != 'super')</p>
<p> $sql_search .= " $where ca_mb_id = '{$member['mb_id']}' ";</p>
<p>$sql_common .= $sql_search;</p>
<p>
</p>
<p>// 테이블의 전체 레코드수만 얻음</p>
<p>$sql = " select count(*) as cnt " . $sql_common;</p>
<p>$row = sql_fetch($sql);</p>
<p>$total_count = $row['cnt'];</p>
<p> </p>
<p>$rows = $config['cf_page_rows'];</p>
<p>$total_page = ceil($total_count / $rows); // 전체 페이지 계산</p>
<p>if ($page < 1) { $page = 1; } // 페이지가 없으면 첫 페이지 (1 페이지)</p>
<p>$from_record = ($page - 1) * $rows; // 시작 열을 구함</p>
<p> </p>
<p>if (!$sst)</p>
<p>{</p>
<p> $sst = "ca_id";</p>
<p> $sod = "asc";</p>
<p>}</p>
<p>$sql_order = "order by $sst $sod";</p>
<p> </p>
<p>// 출력할 레코드를 얻음</p>
<p>$sql = " select *</p>
<p> $sql_common</p>
<p> $sql_order</p>
<p> limit $from_record, $rows ";</p>
<p>$result = sql_query($sql);</p>
<p> </p>
<p>$listall = '<a href="'.$_SERVER['SCRIPT_NAME'].'" class="ov_listall">전체목록</a>';</p>
<p>?></p>
<p> </p>
<p><div class="local_ov01 local_ov"></p>
<p> <?php echo $listall; ?></p>
<p> <span class="btn_ov01"><span class="ov_txt">생성된 분류 수</span><span class="ov_num"> <?php echo number_format($total_count); ?>개</span></span></p>
<p></div></p>
<p> </p>
<p><?php //카테고리 선택 시작 ?></p>
<p><style></p>
<p>.comcose_acs {width:174px; height:400px; padding:.5em;color:#222;}</p>
<p></style></p>
<p><?php $he_size = '15'; ?></p>
<p> </p>
<p><div style="padding:0 0 10px 20px;"></p>
<p> </p>
<p><?php //1차 카테고리 ?></p>
<p><select class="comcose_acs" size="<?php echo $he_size ?>" name="ca_id1" onChange="comcose_acs(this)"></p>
<p><option style="color:#ff3100;font-weight:bold;" value="" >1차 카테고리</option></p>
<p><option>--------------------------------</option></p>
<p> </p>
<p><?php </p>
<p>$sql_ca_id1="SELECT ca_id, ca_name FROM g5_shop_category where length(ca_id) = '2' order by ca_id ";</p>
<p>$result_ca_id1 = sql_query($sql_ca_id1);</p>
<p>for($i=0; $row_ca_id1 = sql_fetch_array($result_ca_id1); $i++){</p>
<p>?></p>
<p> </p>
<p><option value=<?php echo $row_ca_id1[ca_id]; ?> <?php if($row_ca_id1[ca_id] == substr($stx, 0, 2)) echo 'selected'?>><?php echo $row_ca_id1[ca_name]; ?></option></p>
<p> </p>
<p><?php } ?></p>
<p> </p>
<p></select></p>
<p> </p>
<p><?php //2차 카테고리 ?></p>
<p><select class="comcose_acs" size="<?php echo $he_size ?>" name="ca_id2" onChange="comcose_acs(this)"> </p>
<p><option style="color:#ff3100;font-weight:bold;" value="<?php echo substr($stx, 0, 2); ?>" >2차 카테고리</option></p>
<p><option>--------------------------------</option></p>
<p> </p>
<p><?php </p>
<p>$sql_ca_id2="SELECT ca_id, ca_name FROM g5_shop_category where length(ca_id) = '4' and substring(ca_id,1,2) = substring('$stx',1,2) order by ca_id ";</p>
<p>$result_ca_id2 = sql_query($sql_ca_id2);</p>
<p>for($i=0; $row_ca_id2 = sql_fetch_array($result_ca_id2); $i++){</p>
<p>?></p>
<p> </p>
<p><option value=<?php echo $row_ca_id2[ca_id]; ?> <?php if($row_ca_id2[ca_id] == substr($stx, 0, 4)) echo 'selected'?>><?php echo $row_ca_id2[ca_name]; ?></option></p>
<p> </p>
<p><?php } ?></p>
<p> </p>
<p></select></p>
<p> </p>
<p><?php //3차 카테고리 ?></p>
<p><select class="comcose_acs" size="<?php echo $he_size ?>" name="ca_id3" onChange="comcose_acs(this)"> </p>
<p><option style="color:#ff3100;font-weight:bold;" value="<?php echo substr($stx, 0, 4); ?>" >3차 카테고리</option></p>
<p><option>--------------------------------</option> </p>
<p> </p>
<p><?php </p>
<p>$sql_ca_id3="SELECT ca_id, ca_name FROM g5_shop_category where length(ca_id) = '6' and substring(ca_id,1,4) = substring('$stx',1,4) order by ca_id ";</p>
<p>$result_ca_id3 = sql_query($sql_ca_id3);</p>
<p>for($i=0; $row_ca_id3 = sql_fetch_array($result_ca_id3); $i++){</p>
<p>?></p>
<p> </p>
<p><option value=<?php echo $row_ca_id3[ca_id]; ?> <?php if($row_ca_id3[ca_id] == substr($stx, 0, 6)) echo 'selected'?>><?php echo $row_ca_id3[ca_name]; ?></option></p>
<p> </p>
<p><?php } ?></p>
<p> </p>
<p></select></p>
<p> </p>
<p><?php //4차 카테고리 ?></p>
<p><select class="comcose_acs" size="<?php echo $he_size ?>" name="ca_id4" onChange="comcose_acs(this)"> </p>
<p><option style="color:#ff3100;font-weight:bold;" value="<?php echo substr($stx, 0, 6); ?>" >4차 카테고리</option></p>
<p><option>--------------------------------</option></p>
<p> </p>
<p><?php </p>
<p>$sql_ca_id4="SELECT ca_id, ca_name FROM g5_shop_category where length(ca_id) = '8' and substring(ca_id,1,6) = substring('$stx',1,6) order by ca_id ";</p>
<p>$result_ca_id4 = sql_query($sql_ca_id4);</p>
<p>for($i=0; $row_ca_id4 = sql_fetch_array($result_ca_id4); $i++){</p>
<p>?></p>
<p> </p>
<p><option value=<?php echo $row_ca_id4[ca_id]; ?> <?php if($row_ca_id4[ca_id] == substr($stx, 0, 8)) echo 'selected'?>><?php echo $row_ca_id4[ca_name]; ?></option></p>
<p> </p>
<p><?php } ?></p>
<p> </p>
<p></select></p>
<p> </p>
<p><?php //5차 카테고리 ?></p>
<p><select class="comcose_acs" size="<?php echo $he_size ?>" name="ca_id5" onChange="comcose_acs(this)"> </p>
<p><option style="color:#ff3100;font-weight:bold;" value="<?php echo substr($stx, 0, 8); ?>" >5차 카테고리</option></p>
<p><option>--------------------------------</option></p>
<p> </p>
<p><?php </p>
<p>$sql_ca_id5="SELECT ca_id, ca_name FROM g5_shop_category where length(ca_id) = '10' and substring(ca_id,1,8) = substring('$stx',1,8) order by ca_id ";</p>
<p>$result_ca_id5 = sql_query($sql_ca_id5);</p>
<p>for($i=0; $row_ca_id5 = sql_fetch_array($result_ca_id5); $i++){</p>
<p>?></p>
<p> </p>
<p><option value=<?php echo $row_ca_id5[ca_id]; ?> <?php if($row_ca_id5[ca_id] == substr($stx, 0, 10)) echo 'selected'?>><?php echo $row_ca_id5[ca_name]; ?></option></p>
<p> </p>
<p><?php } ?></p>
<p> </p>
<p></select></p>
<p> </p>
<p><?php //6차 카테고리 ?></p>
<p><select class="comcose_acs" size="<?php echo $he_size ?>" name="ca_id6" onChange="comcose_acs(this)"> </p>
<p><option style="color:#ff3100;font-weight:bold;" value="<?php echo substr($stx, 0, 10); ?>" >6차 카테고리</option></p>
<p><option>--------------------------------</option></p>
<p> </p>
<p><?php </p>
<p>$sql_ca_id6="SELECT ca_id, ca_name FROM g5_shop_category where length(ca_id) = '12' and substring(ca_id,1,10) = substring('$stx',1,10) order by ca_id ";</p>
<p>$result_ca_id6 = sql_query($sql_ca_id6);</p>
<p>for($i=0; $row_ca_id6 = sql_fetch_array($result_ca_id6); $i++){</p>
<p>?></p>
<p> </p>
<p><option value=<?php echo $row_ca_id6[ca_id]; ?> <?php if($row_ca_id6[ca_id] == substr($stx, 0, 12)) echo 'selected'?>><?php echo $row_ca_id6[ca_name]; ?></option></p>
<p> </p>
<p><?php } ?></p>
<p> </p>
<p></select></p>
<p> </p>
<p><script type="text/javascript"></p>
<p>function comcose_acs(sel_ca){ </p>
<p>sel_ca= sel_ca.options[sel_ca.selectedIndex].value; </p>
<p>location.replace("categorylist.php?&sfl=ca_id&stx="+sel_ca);</p>
<p>}</p>
<p></script></p>
<p> </p>
<p></div></p>
<p><?php //카테고리 선택 끝 ?></p>
<p>
</p>
<p><form name="flist" class="local_sch01 local_sch"></p>
<p><input type="hidden" name="page" value="<?php echo $page; ?>"></p>
<p><input type="hidden" name="save_stx" value="<?php echo $stx; ?>"></p>
<p> </p>
<p><label for="sfl" class="sound_only">검색대상</label></p>
<p><select name="sfl" id="sfl"></p>
<p> <option value="ca_name"<?php echo get_selected($_GET['sfl'], "ca_name", true); ?>>분류명</option></p>
<p> <option value="ca_id"<?php echo get_selected($_GET['sfl'], "ca_id", true); ?>>분류코드</option></p>
<p> <option value="ca_mb_id"<?php echo get_selected($_GET['sfl'], "ca_mb_id", true); ?>>회원아이디</option></p>
<p></select></p>
<p> </p>
<p><label for="stx" class="sound_only">검색어<strong class="sound_only"> 필수</strong></label></p>
<p><input type="text" name="stx" value="<?php echo $stx; ?>" id="stx" required class="required frm_input"></p>
<p><input type="submit" value="검색" class="btn_submit"></p>
<p> </p>
<p></form></p>
<p> </p>
<p><form name="fcategorylist" method="post" action="./categorylistupdate.php" autocomplete="off"></p>
<p><input type="hidden" name="sst" value="<?php echo $sst; ?>"></p>
<p><input type="hidden" name="sod" value="<?php echo $sod; ?>"></p>
<p><input type="hidden" name="sfl" value="<?php echo $sfl; ?>"></p>
<p><input type="hidden" name="stx" value="<?php echo $stx; ?>"></p>
<p><input type="hidden" name="page" value="<?php echo $page; ?>"></p>
<p> </p>
<p><div id="sct" class="tbl_head01 tbl_wrap"></p>
<p> <table></p>
<p> <caption><?php echo $g5['title']; ?> 목록</caption></p>
<p> <thead></p>
<p> <tr></p>
<p> <th scope="col" rowspan="2"><?php echo subject_sort_link("ca_id"); ?>분류코드</a></th></p>
<p> <th scope="col" id="sct_cate"><?php echo subject_sort_link("ca_name"); ?>분류명</a></th></p>
<p> <th scope="col" id="sct_amount">상품수</th></p>
<p> <th scope="col" id="sct_hpcert">본인인증</th></p>
<p> <th scope="col" id="sct_imgw">이미지 폭</th></p>
<p> <th scope="col" id="sct_imgcol">1행이미지수</th></p>
<p> <th scope="col" id="sct_mobileimg">모바일
1행이미지수</th></p>
<p> <th scope="col" id="sct_pcskin">PC스킨지정</th></p>
<p> <th scope="col" rowspan="2">관리</th></p>
<p> </tr></p>
<p> <tr></p>
<p> <th scope="col" id="sct_admin"><?php echo subject_sort_link("ca_mb_id"); ?>관리회원아이디</a></th></p>
<p> <th scope="col" id="sct_sell"><?php echo subject_sort_link("ca_use"); ?>판매가능</a></th></p>
<p> <th scope="col" id="sct_adultcert">성인인증</th></p>
<p> <th scope="col" id="sct_imgh">이미지 높이</th></p>
<p> <th scope="col" id="sct_imgrow">이미지 행수</th></p>
<p> <th scope="col" id="sct_mobilerow">모바일
이미지 행수</th></p>
<p> <th scope="col" id="sct_mskin">모바일스킨지정</th></p>
<p> </tr></p>
<p> </thead></p>
<p> <tbody></p>
<p> <?php</p>
<p> for ($i=0; $row=sql_fetch_array($result); $i++)</p>
<p> {</p>
<p> $level = strlen($row['ca_id']) / 2 - 1;</p>
<p> $p_ca_name = '';</p>
<p> </p>
<p> if ($level > 0) {</p>
<p> $class = 'class="name_lbl"'; // 2단 이상 분류의 label 에 스타일 부여 - 지운아빠 2013-04-02</p>
<p> // 상위단계의 분류명</p>
<p> $p_ca_id = substr($row['ca_id'], 0, $level*2);</p>
<p> $sql = " select ca_name from {$g5['g5_shop_category_table']} where ca_id = '$p_ca_id' ";</p>
<p> $temp = sql_fetch($sql);</p>
<p> $p_ca_name = $temp['ca_name'].'의하위';</p>
<p> } else {</p>
<p> $class = '';</p>
<p> }</p>
<p> </p>
<p> $s_level = '<div><label for="ca_name_'.$i.'" '.$class.'><span class="sound_only">'.$p_ca_name.''.($level+1).'단 분류</span></label></div>';</p>
<p> $s_level_input_size = 25 - $level *2; // 하위 분류일 수록 입력칸 넓이 작아짐 - 지운아빠 2013-04-02</p>
<p> </p>
<p> if ($level+2 < 6) $s_add = '<a href="./categoryform.php?ca_id='.$row['ca_id'].'&'.$qstr.'" class="btn btn_03">추가</a> '; // 분류는 5단계까지만 가능</p>
<p> else $s_add = '';</p>
<p> $s_upd = '<a href="./categoryform.php?w=u&ca_id='.$row['ca_id'].'&'.$qstr.'" class="btn btn_02"><span class="sound_only">'.get_text($row['ca_name']).' </span>수정</a> ';</p>
<p> </p>
<p> if ($is_admin == 'super')</p>
<p> $s_del = '<a href="./categoryformupdate.php?w=d&ca_id='.$row['ca_id'].'&'.$qstr.'" onclick="return delete_confirm(this);" class="btn btn_02"><span class="sound_only">'.get_text($row['ca_name']).' </span>삭제</a> ';</p>
<p> </p>
<p> // 해당 분류에 속한 상품의 수</p>
<p> $sql1 = " select COUNT(*) as cnt from {$g5['g5_shop_item_table']}</p>
<p> where ca_id = '{$row['ca_id']}'</p>
<p> or ca_id2 = '{$row['ca_id']}'</p>
<p> or ca_id3 = '{$row['ca_id']}' ";</p>
<p> $row1 = sql_fetch($sql1);</p>
<p> </p>
<p> // 스킨 Path</p>
<p> if(!$row['ca_skin_dir'])</p>
<p> $g5_shop_skin_path = G5_SHOP_SKIN_PATH;</p>
<p> else {</p>
<p> if(preg_match('#^theme/(.+)$#', $row['ca_skin_dir'], $match))</p>
<p> $g5_shop_skin_path = G5_THEME_PATH.'/'.G5_SKIN_DIR.'/shop/'.$match[1];</p>
<p> else</p>
<p> $g5_shop_skin_path = G5_PATH.'/'.G5_SKIN_DIR.'/shop/'.$row['ca_skin_dir'];</p>
<p> }</p>
<p> </p>
<p> if(!$row['ca_mobile_skin_dir'])</p>
<p> $g5_mshop_skin_path = G5_MSHOP_SKIN_PATH;</p>
<p> else {</p>
<p> if(preg_match('#^theme/(.+)$#', $row['ca_mobile_skin_dir'], $match))</p>
<p> $g5_mshop_skin_path = G5_THEME_MOBILE_PATH.'/'.G5_SKIN_DIR.'/shop/'.$match[1];</p>
<p> else</p>
<p> $g5_mshop_skin_path = G5_MOBILE_PATH.'/'.G5_SKIN_DIR.'/shop/'.$row['ca_mobile_skin_dir'];</p>
<p> }</p>
<p> </p>
<p> $bg = 'bg'.($i%2);</p>
<p> ?></p>
<p> <tr class="<?php echo $bg; ?>"></p>
<p> <td class="td_code" rowspan="2"></p>
<p> <input type="hidden" name="ca_id[<?php echo $i; ?>]" value="<?php echo $row['ca_id']; ?>"></p>
<p> <a href="<?php echo G5_SHOP_URL; ?>/list.php?ca_id=<?php echo $row['ca_id']; ?>"><?php echo $row['ca_id']; ?></a></p>
<p> </td></p>
<p> <td headers="sct_cate" class="sct_name<?php echo $level; ?>"><?php echo $s_level; ?> <input type="text" name="ca_name[<?php echo $i; ?>]" value="<?php echo get_text($row['ca_name']); ?>" id="ca_name_<?php echo $i; ?>" required class="tbl_input full_input required"></td></p>
<p> <td headers="sct_amount" class="td_amount"><a href="./itemlist.php?sca=<?php echo $row['ca_id']; ?>"><?php echo $row1['cnt']; ?></a></td></p>
<p> <td headers="sct_hpcert" class="td_possible"></p>
<p> <input type="checkbox" name="ca_cert_use[<?php echo $i; ?>]" value="1" id="ca_cert_use_yes<?php echo $i; ?>" <?php if($row['ca_cert_use']) echo 'checked="checked"'; ?>></p>
<p> <label for="ca_cert_use_yes<?php echo $i; ?>">사용</label></p>
<p> </td></p>
<p> <td headers="sct_imgw"></p>
<p> <label for="ca_out_width<?php echo $i; ?>" class="sound_only">출력이미지 폭</label></p>
<p> <input type="text" name="ca_img_width[<?php echo $i; ?>]" value="<?php echo get_text($row['ca_img_width']); ?>" id="ca_out_width<?php echo $i; ?>" required class="required tbl_input" size="3" > <span class="sound_only">픽셀</span></p>
<p> </td></p>
<p> </p>
<p> <td headers="sct_imgcol"></p>
<p> <label for="ca_lineimg_num<?php echo $i; ?>" class="sound_only">1줄당 이미지 수</label></p>
<p> <input type="text" name="ca_list_mod[<?php echo $i; ?>]" size="3" value="<?php echo $row['ca_list_mod']; ?>" id="ca_lineimg_num<?php echo $i; ?>" required class="required tbl_input"> <span class="sound_only">개</span></p>
<p> </td></p>
<p> <td headers="sct_mobileimg"></p>
<p> <label for="ca_mobileimg_num<?php echo $i; ?>" class="sound_only">모바일 1줄당 이미지 수</label></p>
<p> <input type="text" name="ca_mobile_list_mod[<?php echo $i; ?>]" size="3" value="<?php echo $row['ca_mobile_list_mod']; ?>" id="ca_mobileimg_num<?php echo $i; ?>" required class="required tbl_input"> <span class="sound_only">개</span></p>
<p> </td></p>
<p> <td headers="sct_pcskin" class="sct_pcskin"></p>
<p> <label for="ca_skin_dir<?php echo $i; ?>" class="sound_only">PC스킨폴더</label></p>
<p> <?php echo get_skin_select('shop', 'ca_skin_dir'.$i, 'ca_skin_dir['.$i.']', $row['ca_skin_dir'], 'class="skin_dir"'); ?></p>
<p> <label for="ca_skin<?php echo $i; ?>" class="sound_only">PC스킨파일</label></p>
<p> <select id="ca_skin<?php echo $i; ?>" name="ca_skin[<?php echo $i; ?>]" required class="required"></p>
<p> <?php echo get_list_skin_options("^list.[0-9]+\.skin\.php", $g5_shop_skin_path, $row['ca_skin']); ?></p>
<p> </select></p>
<p> </td></p>
<p> <td class="td_mng td_mng_s" rowspan="2"></p>
<p> <?php echo $s_add; ?></p>
<p> <?php echo $s_vie; ?></p>
<p> <?php echo $s_upd; ?></p>
<p> <?php echo $s_del; ?></p>
<p> </td></p>
<p> </tr></p>
<p> <tr class="<?php echo $bg; ?>"></p>
<p> <td headers="sct_admin"></p>
<p> <?php if ($is_admin == 'super') {?></p>
<p> <label for="ca_mb_id<?php echo $i; ?>" class="sound_only">관리회원아이디</label></p>
<p> <input type="text" name="ca_mb_id[<?php echo $i; ?>]" value="<?php echo $row['ca_mb_id']; ?>" id="ca_mb_id<?php echo $i; ?>" class="tbl_input full_input" size="15" maxlength="20"></p>
<p> <?php } else { ?></p>
<p> <input type="hidden" name="ca_mb_id[<?php echo $i; ?>]" value="<?php echo $row['ca_mb_id']; ?>"></p>
<p> <?php echo $row['ca_mb_id']; ?></p>
<p> <?php } ?></p>
<p> </td></p>
<p> <td headers="sct_sell" class="td_possible"></p>
<p> <input type="checkbox" name="ca_use[<?php echo $i; ?>]" value="1" id="ca_use<?php echo $i; ?>" <?php echo ($row['ca_use'] ? "checked" : ""); ?>></p>
<p> <label for="ca_use<?php echo $i; ?>">판매</label></p>
<p> </td></p>
<p> </p>
<p> <td headers="sct_adultcert" class="td_possible"></p>
<p> <input type="checkbox" name="ca_adult_use[<?php echo $i; ?>]" value="1" id="ca_adult_use_yes<?php echo $i; ?>" <?php if($row['ca_adult_use']) echo 'checked="checked"'; ?>></p>
<p> <label for="ca_adult_use_yes<?php echo $i; ?>">사용</label></p>
<p> </td></p>
<p> <td headers="sct_imgh"></p>
<p> <label for="ca_img_height<?php echo $i; ?>" class="sound_only">출력이미지 높이</label></p>
<p> <input type="text" name="ca_img_height[<?php echo $i; ?>]" value="<?php echo $row['ca_img_height']; ?>" id="ca_img_height<?php echo $i; ?>" required class="required tbl_input" size="3" > <span class="sound_only">픽셀</span></p>
<p> </td></p>
<p> <td headers="sct_imgrow"></p>
<p> <label for="ca_imgline_num<?php echo $i; ?>" class="sound_only">이미지 줄 수</label></p>
<p> <input type="text" name="ca_list_row[<?php echo $i; ?>]" value='<?php echo $row['ca_list_row']; ?>' id="ca_imgline_num<?php echo $i; ?>" required class="required tbl_input" size="3"> <span class="sound_only">줄</span></p>
<p> </td></p>
<p> <td headers="sct_mobilerow"></p>
<p> <label for="ca_mobileimg_row<?php echo $i; ?>" class="sound_only">모바일 이미지 줄 수</label></p>
<p> <input type="text" name="ca_mobile_list_row[<?php echo $i; ?>]" value='<?php echo $row['ca_mobile_list_row']; ?>' id="ca_mobileimg_row<?php echo $i; ?>" required class="required tbl_input" size="3"></p>
<p> </td></p>
<p> <td headers="sct_mskin" class="sct_mskin"></p>
<p> <label for="ca_mobile_skin_dir<?php echo $i; ?>" class="sound_only">모바일스킨폴더</label></p>
<p> <?php echo get_mobile_skin_select('shop', 'ca_mobile_skin_dir'.$i, 'ca_mobile_skin_dir['.$i.']', $row['ca_mobile_skin_dir'], 'class="skin_dir"'); ?></p>
<p> <label for="ca_mobile_skin<?php echo $i; ?>" class="sound_only">모바일스킨파일</label></p>
<p> <select id="ca_mobile_skin<?php echo $i; ?>" name="ca_mobile_skin[<?php echo $i; ?>]" required class="required"></p>
<p> <?php echo get_list_skin_options("^list.[0-9]+\.skin\.php", $g5_mshop_skin_path, $row['ca_mobile_skin']); ?></p>
<p> </select></p>
<p> </td></p>
<p> </tr></p>
<p> <?php }</p>
<p> if ($i == 0) echo "<tr><td colspan=\"9\" class=\"empty_table\">자료가 한 건도 없습니다.</td></tr>\n";</p>
<p> ?></p>
<p> </tbody></p>
<p> </table></p>
<p></div></p>
<p> </p>
<p><div class="btn_fixed_top"></p>
<p> <input type="submit" value="일괄수정" class="btn_02 btn"></p>
<p> </p>
<p> <?php if ($is_admin == 'super') {?></p>
<p> <a href="./categoryform.php" id="cate_add" class="btn btn_01">분류 추가</a></p>
<p> <?php } ?></p>
<p></div></p>
<p> </p>
<p></form></p>
<p> </p>
<p><?php echo get_paging(G5_IS_MOBILE ? $config['cf_mobile_pages'] : $config['cf_write_pages'], $page, $total_page, "{$_SERVER['SCRIPT_NAME']}?$qstr&page="); ?></p>
<p> </p>
<p><script></p>
<p>$(function() {</p>
<p> $("select.skin_dir").on("change", function() {</p>
<p> var type = "";</p>
<p> var dir = $(this).val();</p>
<p> if(!dir)</p>
<p> return false;</p>
<p> </p>
<p> var id = $(this).attr("id");</p>
<p> var $sel = $(this).siblings("select");</p>
<p> var sval = $sel.find("option:selected").val();</p>
<p> </p>
<p> if(id.search("mobile") > -1)</p>
<p> type = "mobile";</p>
<p> </p>
<p> $sel.load(</p>
<p> "./ajax.skinfile.php",</p>
<p> { dir : dir, type : type, sval: sval }</p>
<p> );</p>
<p> });</p>
<p>});</p>
<p></script></p>
<p> </p>
<p><?php</p>
<p>include_once (G5_ADMIN_PATH.'/admin.tail.php');</p>
<p>?></p>
<p>
댓글을 작성하려면 로그인이 필요합니다.
답변 2개
채택된 답변
+20 포인트
4년 전
/data/dbconfig.php 파일에 가보시면
define('G5_TABLE_PREFIX', 'g5_'); </pre> <p>부분 g5_ 을 pointplus_ 로 변경하시면 됩니다
그리고 소스상 g5_ 돼 있는 부분도 같이 변경해야 됩니다
로그인 후 평가할 수 있습니다
댓글을 작성하려면 로그인이 필요합니다.
답변을 작성하려면 로그인이 필요합니다.
로그인