게시판 글 엑셀 엑셀 업데이트 시 게시판수 카운터 조정 채택완료
지로쿨
10년 전
조회 5,184
게시판에
영카트에서 사용한 상품올리기 가져다가
수정 해서 진행 했는데요 잘 올라 가는데요
게시판 글 전체 카운터는 변동이 안되더라구요
조언 부탁드립니다.
게시판 관리 > 게시판 카운터 조정을 해야되는되요
자동으로 올릴대 처리 할 수 있는 방법은 없는지요?
아래는 소스입니다.
</p><?php<div>
</div><div>include_once('./_common.php');</div><div>
</div><div>// 상품이 많을 경우 대비 설정변경</div><div>set_time_limit ( 0 );</div><div>ini_set('memory_limit', '128M');</div><div>
</div><div>
</div><div>
</div><div>function only_number($n)</div><div>{</div><div> return preg_replace('/[^0-9]/', '', $n);</div><div>}</div><div>
</div><div>if($_FILES['excelfile']['tmp_name']) {</div><div> $file = $_FILES['excelfile']['tmp_name'];</div><div>
</div><div> include_once(G5_LIB_PATH.'/Excel/reader.php');</div><div>
</div><div> $data = new Spreadsheet_Excel_Reader();</div><div>
</div><div> // Set output Encoding.</div><div> $data->setOutputEncoding('UTF-8');</div><div>
</div><div> /***</div><div> * if you want you can change 'iconv' to mb_convert_encoding:</div><div> * $data->setUTFEncoder('mb');</div><div> *</div><div> **/</div><div>
</div><div> /***</div><div> * By default rows & cols indeces start with 1</div><div> * For change initial index use:</div><div> * $data->setRowColOffset(0);</div><div> *</div><div> **/</div><div>
</div><div>
</div><div>
</div><div> /***</div><div> * Some function for formatting output.</div><div> * $data->setDefaultFormat('%.2f');</div><div> * setDefaultFormat - set format for columns with unknown formatting</div><div> *</div><div> * $data->setColumnFormat(4, '%.3f');</div><div> * setColumnFormat - set format for column (apply only to number fields)</div><div> *</div><div> **/</div><div>
</div><div> $data->read($file);</div><div>
</div><div>
</div><div> /*</div><div>
</div><div>
</div><div> $data->sheets[0]['numRows'] - count rows</div><div> $data->sheets[0]['numCols'] - count columns</div><div> $data->sheets[0]['cells'][$i][$j] - data from $i-row $j-column</div><div>
</div><div> $data->sheets[0]['cellsInfo'][$i][$j] - extended info about cell</div><div>
</div><div> $data->sheets[0]['cellsInfo'][$i][$j]['type'] = "date" | "number" | "unknown"</div><div> if 'type' == "unknown" - use 'raw' value, because cell contain value with format '0.00';</div><div> $data->sheets[0]['cellsInfo'][$i][$j]['raw'] = value if cell without format</div><div> $data->sheets[0]['cellsInfo'][$i][$j]['colspan']</div><div> $data->sheets[0]['cellsInfo'][$i][$j]['rowspan']</div><div> */</div><div>
</div><div> error_reporting(E_ALL ^ E_NOTICE);</div><div>
</div><div> $dup_it_id = array();</div><div> $fail_it_id = array();</div><div> $dup_count = 0;</div><div> $total_count = 0;</div><div> $fail_count = 0;</div><div> $succ_count = 0;</div><div>
</div><div> for ($i = 2; $i <= $data->sheets[0]['numRows']; $i++) {</div><div> $total_count++;</div><div>
</div><div>
</div><div>
</div><div> $j = 1;</div><div>
</div><div>
</div><div> $wr_name = addslashes($data->sheets[0]['cells'][$i][$j++]);</div><div> $wr_3 = addslashes($data->sheets[0]['cells'][$i][$j++]);</div><div> $wr_2 = addslashes($data->sheets[0]['cells'][$i][$j++]);</div><div> $wr_22 = strip_tags(trim($wr_2));</div><div>
</div><div> $wrry_id = explode('-',$wr_22);</div><div> $mb_id = $wrry_id[0].$wrry_id[1].$wrry_id[2];</div><div>
</div><div>
</div><div>
</div><div>
</div><div> if( !$wr_2 || !$wr_name) {</div><div> $fail_count++;</div><div> continue;</div><div> }</div><div>
</div><div>
</div><div> // it_id 중복체크</div><div> $sql2 = " select count(*) as cnt from {$g5['g5_write_insubasefree']} where mb_id = '$mb_id' ";</div><div> $row2 = sql_fetch($sql2);</div><div> if($row2['cnt']) {</div><div> $fail_it_id[] = $mb_id;</div><div> $dup_it_id[] = $mb_id;</div><div> $dup_count++;</div><div> $fail_count++;</div><div> continue;</div><div> }</div><div>
</div><div> $write_table = 'g5_write_insubasefree';</div><div>
</div><div>
</div><div>
</div><div>
</div><div>
</div><div>
</div><div>
</div><div>
</div><div>
</div><div>
</div><div>
</div><div>
</div><div>
</div><div>
</div><div> $wr_subject = '무료실비보상신청합니다.';</div><div>
</div><div> $wr_num = get_next_num($write_table);</div><div> $wr_reply = '';</div><div> $wr_1 = '무료실비보상상품';</div><div>
</div><div>
</div><div> $sql = " insert into $write_table</div><div> set wr_num = '$wr_num',</div><div> wr_reply = '$wr_reply',</div><div> wr_comment = 0,</div><div> ca_name = '$ca_name',</div><div> wr_option = '$html,$secret,$mail',</div><div> wr_subject = '$wr_subject',</div><div> wr_content = '$wr_content',</div><div> wr_link1 = '$wr_link1',</div><div> wr_link2 = '$wr_link2',</div><div> wr_link1_hit = 0,</div><div> wr_link2_hit = 0,</div><div> wr_hit = 0,</div><div> wr_good = 0,</div><div> wr_nogood = 0,</div><div> mb_id = '$mb_id',</div><div> wr_password = '$wr_password',</div><div> wr_name = '$wr_name',</div><div> wr_email = '$wr_email',</div><div> wr_homepage = '$wr_homepage',</div><div> wr_datetime = '".G5_TIME_YMDHIS."',</div><div> wr_last = '".G5_TIME_YMDHIS."',</div><div> wr_ip = '{$_SERVER['REMOTE_ADDR']}',</div><div> wr_1 = '$wr_1',</div><div> wr_2 = '$wr_2',</div><div> wr_3 = '$wr_3',</div><div> wr_4 = '$wr_4',</div><div> wr_5 = '$wr_5',</div><div> wr_6 = '$wr_6',</div><div> wr_7 = '$wr_7',</div><div> wr_8 = '$wr_8',</div><div> wr_9 = '$wr_9',</div><div> wr_10 = '{$member['mb_id']}',</div><div> wr_11 = '$wr_11',</div><div> wr_12 = '$wr_12',</div><div> wr_13 = '$wr_13',</div><div> wr_14 = '$wr_14' ";</div><div>
</div><div>
</div><div> sql_query($sql);</div><div>
</div><div> $wr_id = mysql_insert_id();</div><div>
</div><div> $insuno = date(ymd).'-03-'.$wr_id;</div><div>
</div><div> // 보험번호 생성 UPDATE</div><div> sql_query(" update $write_table set wr_15 = '$insuno' where wr_id = '$wr_id' ");</div><div>
</div><div> // 부모 아이디에 UPDATE</div><div> sql_query(" update $write_table set wr_parent = '$wr_id' where wr_id = '$wr_id' ");</div><div>
</div><div> // 새글 INSERT</div><div> 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']}' ) ");</div><div>
</div><div> // 게시글 1 증가</div><div> sql_query("update {$g5['board_table']} set bo_count_write = bo_count_write + 1 where bo_table = '{$bo_table}'");</div><div>
</div><div>
</div><div> // // 회원 등록</div><div>
</div><div> // $mb_password = '0000';</div><div> // $mb_level = '2';</div><div> // $member_table = 'g5_member';</div><div> // $mb_datetime = '".G5_TIME_YMDHIS."';</div><div>
</div><div> // $sql = " INSERT INTO {$member_table}</div><div> // SET mb_id = '$wr_id2',</div><div> // mb_password = '".sql_password($mb_password)."',</div><div> // mb_name = '$wr_name',</div><div> // mb_nick = '$wr_name',</div><div> // mb_nick_date = '$mb_nick_date',</div><div> // mb_email = '$wr_email',</div><div> // mb_homepage = '$mb_homepage',</div><div> // mb_level = '$mb_level',</div><div> // mb_sex = '$mb_sex',</div><div> // mb_birth = '$mb_birth',</div><div> // mb_tel = '$mb_tel',</div><div> // mb_hp = '$wr_2',</div><div> // mb_certify = '$mb_certify',</div><div> // mb_adult = '$mb_adult',</div><div> // mb_dupinfo = '$mb_dupinfo',</div><div> // mb_zip1 = '$mb_zip1',</div><div> // mb_zip2 = '$mb_zip2',</div><div> // mb_addr1 = '$mb_addr1',</div><div> // mb_addr2 = '$mb_addr2',</div><div> // mb_addr3 = '$mb_addr3',</div><div> // mb_addr_jibeon = '$mb_addr_jibeon',</div><div> // mb_signature = '$mb_signature',</div><div> // mb_recommend = '$mb_recommend',</div><div> // mb_point = '$mb_point',</div><div> // mb_today_login = '$mb_today_login',</div><div> // mb_login_ip = '$mb_login_ip',</div><div> // mb_datetime = '".G5_TIME_YMDHIS."',</div><div> // mb_ip = '{$_SERVER['REMOTE_ADDR']}',</div><div> // mb_leave_date = '$mb_leave_date',</div><div> // mb_intercept_date = '$mb_intercept_date',</div><div> // mb_email_certify = '$mb_email_certify',</div><div> // mb_memo = '$mb_memo',</div><div> // mb_lost_certify = '$mb_lost_certify',</div><div> // mb_mailling = '$mb_mailling',</div><div> // mb_sms = '$mb_sms',</div><div> // mb_open = '$mb_open',</div><div> // mb_open_date = '$mb_open_date',</div><div> // mb_profile = '$mb_profile',</div><div> // mb_memo_call = '$mb_memo_call',</div><div> // mb_1 = '$mb_1',</div><div> // mb_2 = '$mb_2',</div><div> // mb_3 = '$mb_3',</div><div> // mb_4 = '$mb_4',</div><div> // mb_5 = '$mb_5',</div><div> // mb_6 = '$mb_6',</div><div> // mb_7 = '$mb_7',</div><div> // mb_8 = '$mb_8',</div><div> // mb_9 = '$mb_9',</div><div> // mb_10 = '$mb_10' ";</div><div> // sql_query($sql);</div><div>
</div><div>
</div><div> // // 정산된 포인트 넣기</div><div> // if ($mb_point > 0) {</div><div> // //$expire = preg_replace('/[^0-9]/', '', 365);</div><div> // $expire = '';</div><div> // insert_point($mb_id, $mb_point, '정산된 포인트', '@passive', $mb_id, '리뉴얼', $expire);</div><div> // }</div><div>
</div><div>
</div><div> $succ_count++;</div><div> }</div><div>}</div><div>
</div><div>$g5['title'] = '무료보험 엑셀일괄등록 결과';</div><div>include_once('./admin.head.php');</div><div>?></div><div>
</div><div><div class="new_win"></div><div> <h1><?php echo $g5['title']; ?></h1></div><div>
</div><div> <div class="local_desc01 local_desc"></div><div> <p>무료보험등록을 완료했습니다.</p></div><div> </div></div><div>
</div><div> <dl id="excelfile_result"></div><div> <dt>총무료보험수</dt></div><div> <dd><?php echo number_format($total_count); ?></dd></div><div> <dt>완료건수</dt></div><div> <dd><?php echo number_format($succ_count); ?></dd></div><div> <dt>실패건수</dt></div><div> <dd><?php echo number_format($fail_count); ?></dd></div><div> <?php if($fail_count > 0) { ?></div><div> <dt>실패무료보험아이디</dt></div><div> <dd><?php echo implode(', ', $fail_it_id); ?></dd></div><div> <?php } ?></div><div> <?php if($dup_count > 0) { ?></div><div>
</div><div> <dt>중복무료보험아이디</dt></div><div> <dd><?php echo implode(', ', $dup_it_id); ?></dd></div><div> <?php } ?></div><div> </dl></div><div>
</div><div> <!-- <div class="btn_win01 btn_win"></div><div> <button type="button" onclick="window.close();">창닫기</button></div><div> </div> --></div><div>
</div><div></div></div><div>
</div><div><?php</div><div>include_once('./admin.tail.php');</div>?><p>
댓글을 작성하려면 로그인이 필요합니다.
답변 1개
채택된 답변
+20 포인트
10년 전
"// 게시글 1 증가" 부분의 쿼리 내용을
"// 보험번호 생성 UPDATE" 부분의 쿼리 내용 이전으로 옮겨보세요.
만약 그래도 안 된다면, 아래와 같이 "// // 회원 등록" 주석글 이전에
아래의 코드를 추가해보세요.
</p><p>$row = sql_fetch(" select count(*) as cnt from {$write_table} where wr_is_comment = 0 "); </p><p>sql_query(" update {$g5['board_table']} set bo_count_write = '{$row['cnt']}' where bo_table = '{$bo_table}' ");</p><p> </p><p><font face="Courier New">// // 회원 등록</font></p><p>
로그인 후 평가할 수 있습니다
댓글을 작성하려면 로그인이 필요합니다.
답변을 작성하려면 로그인이 필요합니다.
로그인