미채택 완료

메인인덱스에 이벤트 노출비노출 선택 하기

46784901d295f9dfc676da49e1954267_1457227355_2258.PNG
제가 앞에 카테고리별로 히트외할인상품 리스트를 선택해서 노출비노출을 시도했는데요 그걸 참고해서 이벤트역시 만들어봤는데요 노출과 비노출은 먹히는데 이벤트의 아이디를 설정에서 간단하게 입력하려고 해봤는데 아레퍼럼 에러만 나는군요 방법을 잘모르겠내요...ㅠㅠ 어느부분을 수정해야할까요..ㅠㅠ

1054 : Unknown column 'de_type11_list_ev_id' in 'field list'

error file : /adm/shop_admin/configformupdate.php

46784901d295f9dfc676da49e1954267_1457227673_8726.PNG
이벤트 아이디를 입력해야하는데...

adm/shop_admin/configform.php파일의 

Copy
<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

Copy
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']}',

이렇게 했거든요 이벤트아이디 부분을  어떻게 수정해야 정상적으로 인식을 할까요..?  ㅠㅠ알려주세요

이런 에러화면이 나옵니다  ㅠㅠ


46784901d295f9dfc676da49e1954267_1457229227_4857.PNG

|

답변을 작성하려면 로그인이 필요합니다.