메인인덱스에 이벤트 노출비노출 선택 하기
본문
제가 앞에 카테고리별로 히트외할인상품 리스트를 선택해서 노출비노출을 시도했는데요 그걸 참고해서 이벤트역시 만들어봤는데요 노출과 비노출은 먹히는데 이벤트의 아이디를 설정에서 간단하게 입력하려고 해봤는데 아레퍼럼 에러만 나는군요 방법을 잘모르겠내요...ㅠㅠ 어느부분을 수정해야할까요..ㅠㅠ
1054 : Unknown column 'de_type11_list_ev_id' in 'field list'
error file : /adm/shop_admin/configformupdate.php
adm/shop_admin/configform.php파일의
<section id="anc_scf_index">
<h2 class="h2_frm">쇼핑몰 초기화면</h2>
<?php echo $pg_anchor; ?>
<div class="local_desc02 local_desc">
<p>
상품관리에서 선택한 상품의 타입대로 쇼핑몰 초기화면에 출력합니다. (상품 타입 히트/추천/최신/인기/할인)<br>
각 타입별로 선택된 상품이 없으면 쇼핑몰 초기화면에 출력하지 않습니다.
</p>
</div>
<div class="tbl_frm01 tbl_wrap">
<table>
<caption>쇼핑몰 초기화면 설정</caption>
<colgroup>
<col class="grid_4">
<col>
</colgroup>
<tbody>
<tr>
<th scope="row">이벤트 상품출력</th>
<td>
<label for="de_type11_list_use">출력</label>
<input type="checkbox" name="de_type11_list_use" value="1" id="de_type11_list_use" <?php echo $default['de_type11_list_use']?"checked":""; ?>>
<label for="de_type11_list_ev_id">이벤트아이디</label>
<input type="text" name="de_type11_list_ev_id" value="<?php echo $default["de_type11_list_ev_id"]; ?>" id="<?php echo $row['ev_id']; ?>" class="frm_input" size="10">
<label for="de_type11_list_skin">스킨</label>
<select name="de_type11_list_skin" id="de_type11_list_skin">
<?php echo get_list_skin_options("main.50.skin.php", G5_SHOP_SKIN_PATH, $default['de_type11_list_skin']); ?>
</select>
<label for="de_type11_list_mod">1줄당 이미지 수</label>
<input type="text" name="de_type11_list_mod" value="<?php echo $default['de_type11_list_mod']; ?>" id="de_type11_list_mod" class="frm_input" size="3">
<label for="de_type11_list_row">출력할 줄 수</label>
<input type="text" name="de_type11_list_row" value="<?php echo $default['de_type11_list_row']; ?>" id="de_type11_list_row" class="frm_input" size="3">
<label for="de_type11_img_width">이미지 폭</label>
<input type="text" name="de_type11_img_width" value="<?php echo $default['de_type11_img_width']; ?>" id="de_type11_img_width" class="frm_input" size="3">
<label for="de_type11_img_height">이미지 높이</label>
<input type="text" name="de_type11_img_height" value="<?php echo $default['de_type11_img_height']; ?>" id="de_type11_img_height" class="frm_input" size="3">
</td>
</tr>
<tr>
<th scope="row">히트상품출력</th>
<td>
<label for="de_type1_list_use">출력</label>
<input type="checkbox" name="de_type1_list_use" value="1" id="de_type1_list_use" <?php echo $default['de_type1_list_use']?"checked":""; ?>>
<label for="de_type1_list_skin">스킨</label>
<select name="de_type1_list_skin" id="de_type1_list_skin">
<?php echo get_list_skin_options("^main.[0-9]+\.skin\.php", G5_SHOP_SKIN_PATH, $default['de_type1_list_skin']); ?>
</select>
<label for="de_type1_list_mod">1줄당 이미지 수</label>
<input type="text" name="de_type1_list_mod" value="<?php echo $default['de_type1_list_mod']; ?>" id="de_type1_list_mod" class="frm_input" size="3">
<label for="de_type1_list_row">출력할 줄 수</label>
<input type="text" name="de_type1_list_row" value="<?php echo $default['de_type1_list_row']; ?>" id="de_type1_list_row" class="frm_input" size="3">
<label for="de_type1_img_width">이미지 폭</label>
<input type="text" name="de_type1_img_width" value="<?php echo $default['de_type1_img_width']; ?>" id="de_type1_img_width" class="frm_input" size="3">
<label for="de_type1_img_height">이미지 높이</label>
<input type="text" name="de_type1_img_height" value="<?php echo $default['de_type1_img_height']; ?>" id="de_type1_img_height" class="frm_input" size="3">
</td>
</tr>
<tr>
<th scope="row">추천상품출력</th>
<td>
<label for="de_type2_list_use">출력</label>
<input type="checkbox" name="de_type2_list_use" value="1" id="de_type2_list_use" <?php echo $default['de_type2_list_use']?"checked":""; ?>>
<label for="de_type2_list_skin">스킨</label>
<select name="de_type2_list_skin" id="de_type2_list_skin">
<?php echo get_list_skin_options("^main.[0-9]+\.skin\.php", G5_SHOP_SKIN_PATH, $default['de_type2_list_skin']); ?>
</select>
<label for="de_type2_list_mod">1줄당 이미지 수</label>
<input type="text" name="de_type2_list_mod" value="<?php echo $default['de_type2_list_mod']; ?>" id="de_type2_list_mod" class="frm_input" size="3">
<label for="de_type2_list_row">출력할 줄 수</label>
<input type="text" name="de_type2_list_row" value="<?php echo $default['de_type2_list_row']; ?>" id="de_type2_list_row" class="frm_input" size="3">
<label for="de_type2_img_width">이미지 폭</label>
<input type="text" name="de_type2_img_width" value="<?php echo $default['de_type2_img_width']; ?>" id="de_type2_img_width" class="frm_input" size="3">
<label for="de_type2_img_height">이미지 높이</label>
<input type="text" name="de_type2_img_height" value="<?php echo $default['de_type2_img_height']; ?>" id="de_type2_img_height" class="frm_input" size="3">
</td>
</tr>
<tr>
<th scope="row">최신상품출력</th>
<td>
<label for="de_type3_list_use">출력</label>
<input type="checkbox" name="de_type3_list_use" value="1" id="de_type3_list_use" <?php echo $default['de_type3_list_use']?"checked":""; ?>>
<label for="de_type3_list_skin">스킨</label>
<select name="de_type3_list_skin" id="de_type3_list_skin">
<?php echo get_list_skin_options("^main.[0-9]+\.skin\.php", G5_SHOP_SKIN_PATH, $default['de_type3_list_skin']); ?>
</select>
<label for="de_type3_list_mod">1줄당 이미지 수</label>
<input type="text" name="de_type3_list_mod" value="<?php echo $default['de_type3_list_mod']; ?>" id="de_type3_list_mod" class="frm_input" size="3">
<label for="de_type3_list_row">출력할 줄 수</label>
<input type="text" name="de_type3_list_row" value="<?php echo $default['de_type3_list_row']; ?>" id="de_type3_list_row" class="frm_input" size="3">
<label for="de_type3_img_width">이미지 폭</label>
<input type="text" name="de_type3_img_width" value="<?php echo $default['de_type3_img_width']; ?>" id="de_type3_img_width" class="frm_input" size="3">
<label for="de_type3_img_height">이미지 높이</label>
<input type="text" name="de_type3_img_height" value="<?php echo $default['de_type3_img_height']; ?>" id="de_type3_img_height" class="frm_input" size="3">
</td>
</tr>
<tr>
<th scope="row">인기상품출력</th>
<td>
<label for="de_type4_list_use">출력</label>
<input type="checkbox" name="de_type4_list_use" value="1" id="de_type4_list_use" <?php echo $default['de_type4_list_use']?"checked":""; ?>>
<label for="de_type4_list_skin">스킨</label>
<select name="de_type4_list_skin" id="de_type4_list_skin">
<?php echo get_list_skin_options("^main.[0-9]+\.skin\.php", G5_SHOP_SKIN_PATH, $default['de_type4_list_skin']); ?>
</select>
<label for="de_type4_list_mod">1줄당 이미지 수</label>
<input type="text" name="de_type4_list_mod" value="<?php echo $default['de_type4_list_mod']; ?>" id="de_type4_list_mod" class="frm_input" size="3">
<label for="de_type4_list_row">출력할 줄 수</label>
<input type="text" name="de_type4_list_row" value="<?php echo $default['de_type4_list_row']; ?>" id="de_type4_list_row" class="frm_input" size="3">
<label for="de_type4_img_width">이미지 폭</label>
<input type="text" name="de_type4_img_width" value="<?php echo $default['de_type4_img_width']; ?>" id="de_type4_img_width" class="frm_input" size="3">
<label for="de_type4_img_height">이미지 높이</label>
<input type="text" name="de_type4_img_height" value="<?php echo $default['de_type4_img_height']; ?>" id="de_type4_img_height" class="frm_input" size="3">
</td>
</tr>
<tr>
<th scope="row">할인상품출력</th>
<td>
<label for="de_type5_list_use">출력</label>
<input type="checkbox" name="de_type5_list_use" value="1" id="de_type5_list_use" <?php echo $default['de_type5_list_use']?"checked":""; ?>>
<label for="de_type5_list_skin">스킨</label>
<select name="de_type5_list_skin" id="de_type5_list_skin">
<?php echo get_list_skin_options("^main.[0-9]+\.skin\.php", G5_SHOP_SKIN_PATH, $default['de_type5_list_skin']); ?>
</select>
<label for="de_type5_list_mod">1줄당 이미지 수</label>
<input type="text" name="de_type5_list_mod" value="<?php echo $default['de_type5_list_mod']; ?>" id="de_type5_list_mod" class="frm_input" size="3">
<label for="de_type5_list_row">출력할 줄 수</label>
<input type="text" name="de_type5_list_row" value="<?php echo $default['de_type5_list_row']; ?>" id="de_type5_list_row" class="frm_input" size="3">
<label for="de_type5_img_width">이미지 폭</label>
<input type="text" name="de_type5_img_width" value="<?php echo $default['de_type5_img_width']; ?>" id="de_type5_img_width" class="frm_input" size="3">
<label for="de_type5_img_height">이미지 높이</label>
<input type="text" name="de_type5_img_height" value="<?php echo $default['de_type5_img_height']; ?>" id="de_type5_img_height" class="frm_input" size="3">
</td>
</tr>
</tbody>
</table>
</div>
</section>
<?php echo preg_replace('#</div>$#i', '<button type="button" class="shop_pc_index">테마설정 가져오기</button></div>', $frm_submit); ?>
!-->
그리고adm/shop_admin/configformupdate.php
de_type1_list_use = '{$_POST['de_type1_list_use']}',
de_type1_list_skin = '{$_POST['de_type1_list_skin']}',
de_type1_list_mod = '{$_POST['de_type1_list_mod']}',
de_type1_list_row = '{$_POST['de_type1_list_row']}',
de_type1_img_width = '{$_POST['de_type1_img_width']}',
de_type1_img_height = '{$_POST['de_type1_img_height']}',
de_type2_list_use = '{$_POST['de_type2_list_use']}',
de_type2_list_skin = '{$_POST['de_type2_list_skin']}',
de_type2_list_mod = '{$_POST['de_type2_list_mod']}',
de_type2_list_row = '{$_POST['de_type2_list_row']}',
de_type2_img_width = '{$_POST['de_type2_img_width']}',
de_type2_img_height = '{$_POST['de_type2_img_height']}',
de_type3_list_use = '{$_POST['de_type3_list_use']}',
de_type3_list_skin = '{$_POST['de_type3_list_skin']}',
de_type3_list_mod = '{$_POST['de_type3_list_mod']}',
de_type3_list_row = '{$_POST['de_type3_list_row']}',
de_type3_img_width = '{$_POST['de_type3_img_width']}',
de_type3_img_height = '{$_POST['de_type3_img_height']}',
de_type4_list_use = '{$_POST['de_type4_list_use']}',
de_type4_list_skin = '{$_POST['de_type4_list_skin']}',
de_type4_list_mod = '{$_POST['de_type4_list_mod']}',
de_type4_list_row = '{$_POST['de_type4_list_row']}',
de_type4_img_width = '{$_POST['de_type4_img_width']}',
de_type4_img_height = '{$_POST['de_type4_img_height']}',
de_type5_list_use = '{$_POST['de_type5_list_use']}',
de_type5_list_skin = '{$_POST['de_type5_list_skin']}',
de_type5_list_mod = '{$_POST['de_type5_list_mod']}',
de_type5_list_row = '{$_POST['de_type5_list_row']}',
de_type5_img_width = '{$_POST['de_type5_img_width']}',
de_type5_img_height = '{$_POST['de_type5_img_height']}',
de_type6_list_use = '{$_POST['de_type6_list_use']}',
de_type6_list_skin = '{$_POST['de_type6_list_skin']}',
de_type6_list_mod = '{$_POST['de_type6_list_mod']}',
de_type6_list_row = '{$_POST['de_type6_list_row']}',
de_type6_img_width = '{$_POST['de_type6_img_width']}',
de_type6_img_height = '{$_POST['de_type6_img_height']}',
de_type7_list_use = '{$_POST['de_type7_list_use']}',
de_type7_list_skin = '{$_POST['de_type7_list_skin']}',
de_type7_list_mod = '{$_POST['de_type7_list_mod']}',
de_type7_list_row = '{$_POST['de_type7_list_row']}',
de_type7_img_width = '{$_POST['de_type7_img_width']}',
de_type7_img_height = '{$_POST['de_type7_img_height']}',
de_type8_list_use = '{$_POST['de_type8_list_use']}',
de_type8_list_skin = '{$_POST['de_type8_list_skin']}',
de_type8_list_mod = '{$_POST['de_type8_list_mod']}',
de_type8_list_row = '{$_POST['de_type8_list_row']}',
de_type8_img_width = '{$_POST['de_type8_img_width']}',
de_type8_img_height = '{$_POST['de_type8_img_height']}',
de_type9_list_use = '{$_POST['de_type9_list_use']}',
de_type9_list_skin = '{$_POST['de_type9_list_skin']}',
de_type9_list_mod = '{$_POST['de_type9_list_mod']}',
de_type9_list_row = '{$_POST['de_type9_list_row']}',
de_type9_img_width = '{$_POST['de_type9_img_width']}',
de_type9_img_height = '{$_POST['de_type9_img_height']}',
de_type10_list_use = '{$_POST['de_type10_list_use']}',
de_type10_list_skin = '{$_POST['de_type10_list_skin']}',
de_type10_list_mod = '{$_POST['de_type10_list_mod']}',
de_type10_list_row = '{$_POST['de_type10_list_row']}',
de_type10_img_width = '{$_POST['de_type10_img_width']}',
de_type10_img_height = '{$_POST['de_type10_img_height']}',
de_type11_list_ev_id = '{$_POST['de_type11_list_ev_id']}',
de_type11_list_use = '{$_POST['de_type11_list_use']}',
de_type11_list_skin = '{$_POST['de_type11_list_skin']}',
de_type11_list_mod = '{$_POST['de_type11_list_mod']}',
de_type11_list_row = '{$_POST['de_type11_list_row']}',
de_type11_img_width = '{$_POST['de_type11_img_width']}',
de_type11_img_height = '{$_POST['de_type11_img_height']}',
de_mobile_type1_list_use = '{$_POST['de_mobile_type1_list_use']}',
de_mobile_type1_list_skin = '{$_POST['de_mobile_type1_list_skin']}',
de_mobile_type1_list_mod = '{$_POST['de_mobile_type1_list_mod']}',
!-->
이렇게 했거든요 이벤트아이디 부분을 어떻게 수정해야 정상적으로 인식을 할까요..? ㅠㅠ알려주세요
이런 에러화면이 나옵니다 ㅠㅠ
답변을 작성하시기 전에 로그인 해주세요.