게시판 글 엑셀 엑셀 업데이트 시 게시판수 카운터 조정 채택완료

<?phpinclude_once('./_common.php');// 상품이 많을 경우 대비 설정변경set_time_limit ( 0 );ini_set('memory_limit', '128M');function only_number($n){    return preg_replace('/[^0-9]/', '', $n);}if($_FILES['excelfile']['tmp_name']) {    $file = $_FILES['excelfile']['tmp_name'];    include_once(G5_LIB_PATH.'/Excel/reader.php');    $data = new Spreadsheet_Excel_Reader();    // Set output Encoding.    $data->setOutputEncoding('UTF-8');    /***    * if you want you can change 'iconv' to mb_convert_encoding:    * $data->setUTFEncoder('mb');    *    **/    /***    * By default rows & cols indeces start with 1    * For change initial index use:    * $data->setRowColOffset(0);    *    **/    /***    *  Some function for formatting output.    * $data->setDefaultFormat('%.2f');    * setDefaultFormat - set format for columns with unknown formatting    *    * $data->setColumnFormat(4, '%.3f');    * setColumnFormat - set format for column (apply only to number fields)    *    **/    $data->read($file);    /*     $data->sheets[0]['numRows'] - count rows     $data->sheets[0]['numCols'] - count columns     $data->sheets[0]['cells'][$i][$j] - data from $i-row $j-column     $data->sheets[0]['cellsInfo'][$i][$j] - extended info about cell        $data->sheets[0]['cellsInfo'][$i][$j]['type'] = "date" | "number" | "unknown"            if 'type' == "unknown" - use 'raw' value, because  cell contain value with format '0.00';        $data->sheets[0]['cellsInfo'][$i][$j]['raw'] = value if cell without format        $data->sheets[0]['cellsInfo'][$i][$j]['colspan']        $data->sheets[0]['cellsInfo'][$i][$j]['rowspan']    */    error_reporting(E_ALL ^ E_NOTICE);    $dup_it_id = array();    $fail_it_id = array();    $dup_count = 0;    $total_count = 0;    $fail_count = 0;    $succ_count = 0;    for ($i = 2; $i <= $data->sheets[0]['numRows']; $i++) {        $total_count++;        $j = 1;        $wr_name            = addslashes($data->sheets[0]['cells'][$i][$j++]);        $wr_3               = addslashes($data->sheets[0]['cells'][$i][$j++]);        $wr_2               = addslashes($data->sheets[0]['cells'][$i][$j++]);        $wr_22             = strip_tags(trim($wr_2));        $wrry_id = explode('-',$wr_22);        $mb_id  = $wrry_id[0].$wrry_id[1].$wrry_id[2];        if( !$wr_2 || !$wr_name) {            $fail_count++;            continue;        }        // it_id 중복체크        $sql2 = " select count(*) as cnt from {$g5['g5_write_insubasefree']} where mb_id = '$mb_id' ";        $row2 = sql_fetch($sql2);        if($row2['cnt']) {            $fail_it_id[] = $mb_id;            $dup_it_id[] = $mb_id;            $dup_count++;            $fail_count++;            continue;        }        $write_table = 'g5_write_insubasefree';        $wr_subject = '무료실비보상신청합니다.';        $wr_num = get_next_num($write_table);        $wr_reply = '';        $wr_1 = '무료실비보상상품';        $sql = " insert into $write_table                    set wr_num = '$wr_num',                         wr_reply = '$wr_reply',                         wr_comment = 0,                         ca_name = '$ca_name',                         wr_option = '$html,$secret,$mail',                         wr_subject = '$wr_subject',                         wr_content = '$wr_content',                         wr_link1 = '$wr_link1',                         wr_link2 = '$wr_link2',                         wr_link1_hit = 0,                         wr_link2_hit = 0,                         wr_hit = 0,                         wr_good = 0,                         wr_nogood = 0,                         mb_id = '$mb_id',                         wr_password = '$wr_password',                         wr_name = '$wr_name',                         wr_email = '$wr_email',                         wr_homepage = '$wr_homepage',                         wr_datetime = '".G5_TIME_YMDHIS."',                         wr_last = '".G5_TIME_YMDHIS."',                         wr_ip = '{$_SERVER['REMOTE_ADDR']}',                         wr_1 = '$wr_1',                         wr_2 = '$wr_2',                         wr_3 = '$wr_3',                         wr_4 = '$wr_4',                         wr_5 = '$wr_5',                         wr_6 = '$wr_6',                         wr_7 = '$wr_7',                         wr_8 = '$wr_8',                         wr_9 = '$wr_9',                         wr_10 = '{$member['mb_id']}',                         wr_11 = '$wr_11',                         wr_12 = '$wr_12',                         wr_13 = '$wr_13',                         wr_14 = '$wr_14' ";        sql_query($sql);        $wr_id = mysql_insert_id();        $insuno = date(ymd).'-03-'.$wr_id;        // 보험번호 생성 UPDATE        sql_query(" update $write_table set wr_15 = '$insuno' where wr_id = '$wr_id' ");        // 부모 아이디에 UPDATE        sql_query(" update $write_table set wr_parent = '$wr_id' where wr_id = '$wr_id' ");        // 새글 INSERT        sql_query(" insert into {$g5['board_new_table']} ( bo_table, wr_id, wr_parent, bn_datetime, mb_id ) values ( '{$bo_table}', '{$wr_id}', '{$wr_id}', '".G5_TIME_YMDHIS."', '{$member['mb_id']}' ) ");        // 게시글 1 증가        sql_query("update {$g5['board_table']} set bo_count_write = bo_count_write + 1 where bo_table = '{$bo_table}'");        // // 회원 등록        // $mb_password = '0000';        // $mb_level = '2';        // $member_table = 'g5_member';        // $mb_datetime = '".G5_TIME_YMDHIS."';        // $sql = " INSERT INTO {$member_table}        //              SET mb_id = '$wr_id2',        //                  mb_password = '".sql_password($mb_password)."',        //                  mb_name = '$wr_name',        //                  mb_nick = '$wr_name',        //                  mb_nick_date = '$mb_nick_date',        //                  mb_email = '$wr_email',        //                  mb_homepage = '$mb_homepage',        //                  mb_level = '$mb_level',        //                  mb_sex = '$mb_sex',        //                  mb_birth = '$mb_birth',        //                  mb_tel = '$mb_tel',        //                  mb_hp = '$wr_2',        //                  mb_certify = '$mb_certify',        //                  mb_adult = '$mb_adult',        //                  mb_dupinfo = '$mb_dupinfo',        //                  mb_zip1 = '$mb_zip1',        //                  mb_zip2 = '$mb_zip2',        //                  mb_addr1 = '$mb_addr1',        //                  mb_addr2 = '$mb_addr2',        //                  mb_addr3 = '$mb_addr3',        //                  mb_addr_jibeon = '$mb_addr_jibeon',        //                  mb_signature = '$mb_signature',        //                  mb_recommend = '$mb_recommend',        //                  mb_point = '$mb_point',        //                  mb_today_login = '$mb_today_login',        //                  mb_login_ip = '$mb_login_ip',        //                  mb_datetime = '".G5_TIME_YMDHIS."',        //                  mb_ip = '{$_SERVER['REMOTE_ADDR']}',        //                  mb_leave_date = '$mb_leave_date',        //                  mb_intercept_date = '$mb_intercept_date',        //                  mb_email_certify = '$mb_email_certify',        //                  mb_memo = '$mb_memo',        //                  mb_lost_certify = '$mb_lost_certify',        //                  mb_mailling = '$mb_mailling',        //                  mb_sms = '$mb_sms',        //                  mb_open = '$mb_open',        //                  mb_open_date = '$mb_open_date',        //                  mb_profile = '$mb_profile',        //                  mb_memo_call = '$mb_memo_call',        //                  mb_1 = '$mb_1',        //                  mb_2 = '$mb_2',        //                  mb_3 = '$mb_3',        //                  mb_4 = '$mb_4',        //                  mb_5 = '$mb_5',        //                  mb_6 = '$mb_6',        //                  mb_7 = '$mb_7',        //                  mb_8 = '$mb_8',        //                  mb_9 = '$mb_9',        //                  mb_10 = '$mb_10' ";        // sql_query($sql);        // // 정산된 포인트 넣기        // if ($mb_point > 0) {        //     //$expire = preg_replace('/[^0-9]/', '', 365);        //     $expire = '';        //     insert_point($mb_id, $mb_point, '정산된 포인트', '@passive', $mb_id, '리뉴얼', $expire);        // }        $succ_count++;    }}$g5['title'] = '무료보험 엑셀일괄등록 결과';include_once('./admin.head.php');?><div class="new_win">    <h1><?php echo $g5['title']; ?></h1>    <div class="local_desc01 local_desc">        <p>무료보험등록을 완료했습니다.</p>    </div>    <dl id="excelfile_result">        <dt>총무료보험수</dt>        <dd><?php echo number_format($total_count); ?></dd>        <dt>완료건수</dt>        <dd><?php echo number_format($succ_count); ?></dd>        <dt>실패건수</dt>        <dd><?php echo number_format($fail_count); ?></dd>        <?php if($fail_count > 0) { ?>        <dt>실패무료보험아이디</dt>        <dd><?php echo implode(', ', $fail_it_id); ?></dd>        <?php } ?>        <?php if($dup_count > 0) { ?>        <dt>중복무료보험아이디</dt>        <dd><?php echo implode(', ', $dup_it_id); ?></dd>        <?php } ?>    </dl>    <!-- <div class="btn_win01 btn_win">        <button type="button" onclick="window.close();">창닫기</button>    </div> --></div><?phpinclude_once('./admin.tail.php');?>