질문좀드리겠습니다. 채택완료
Stx필드값을 3개를 사용하고싶은데요
예: Stx Stx1 Stx2
검색은 다동일하게 되는데 필드값만 3개로 보여주고싶은거인데요
search.php 부분에서 수정을 해야한다고 하는데 구체적으로 어떻게 해야하는지 알려주시면 감사하겠습니다 ㅠㅠ;
search.php 부분입니다
</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">
</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"><?php</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">include_once('./_common.php');</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">
</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">$g5['title'] = '전체검색 결과';</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">include_once('./_head.php');</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">
</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">$search_table = Array();</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">$table_index = 0;</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">$write_pages = "";</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">$text_stx = "";</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">$srows = 0;</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">
</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">$stx = strip_tags($stx);</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">//$stx = preg_replace('/[[:punct:]]/u', '', $stx); // 특수문자 제거</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">$stx = get_search_string($stx); // 특수문자 제거</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">if ($stx) {</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $stx = preg_replace('/\//', '\/', trim($stx));</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $sop = strtolower($sop);</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> if (!$sop || !($sop == 'and' || $sop == 'or')) $sop = 'and'; // 연산자 and , or</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $srows = isset($_GET['srows']) ? (int)preg_replace('#[^0-9]#', '', $_GET['srows']) : 10;</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> if (!$srows) $srows = 10; // 한페이지에 출력하는 검색 행수</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">
</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $g5_search['tables'] = Array();</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $g5_search['read_level'] = Array();</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $sql = " select gr_id, bo_table, bo_read_level from {$g5['board_table']} where bo_use_search = 1 and bo_list_level <= '{$member['mb_level']}' ";</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> if ($gr_id)</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $sql .= " and gr_id = '{$gr_id}' ";</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $onetable = isset($onetable) ? $onetable : "";</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> if ($onetable) // 하나의 게시판만 검색한다면</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $sql .= " and bo_table = '{$onetable}' ";</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $sql .= " order by bo_order, gr_id, bo_table ";</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $result = sql_query($sql);</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> for ($i=0; $row=sql_fetch_array($result); $i++)</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> {</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> if ($is_admin != 'super')</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> {</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> // 그룹접근 사용에 대한 검색 차단</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $sql2 = " select gr_use_access, gr_admin from {$g5['group_table']} where gr_id = '{$row['gr_id']}' ";</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $row2 = sql_fetch($sql2);</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> // 그룹접근을 사용한다면</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> if ($row2['gr_use_access']) {</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> // 그룹관리자가 있으며 현재 회원이 그룹관리자라면 통과</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> if ($row2['gr_admin'] && $row2['gr_admin'] == $member['mb_id']) {</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> ;</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> } else {</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $sql3 = " select count(*) as cnt from {$g5['group_member_table']} where gr_id = '{$row['gr_id']}' and mb_id = '{$member['mb_id']}' and mb_id <> '' ";</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $row3 = sql_fetch($sql3);</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> if (!$row3['cnt'])</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> continue;</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> }</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> }</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> }</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $g5_search['tables'][] = $row['bo_table'];</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $g5_search['read_level'][] = $row['bo_read_level'];</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> }</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">
</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $search_query = 'sfl='.urlencode($sfl).'&stx='.urlencode($stx).'&sop='.$sop;</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">
</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">
</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $text_stx = get_text(stripslashes($stx));</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">
</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $op1 = '';</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">
</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> // 검색어를 구분자로 나눈다. 여기서는 공백</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $s = explode(' ', strip_tags($stx));</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">
</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> // 검색필드를 구분자로 나눈다. 여기서는 +</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $field = explode('||', trim($sfl));</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">
</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $str = '(';</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> for ($i=0; $i<count($s); $i++) {</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> if (trim($s[$i]) == '') continue;</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">
</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $search_str = $s[$i];</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">
</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> // 인기검색어</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> insert_popular($field, $search_str);</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">
</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $str .= $op1;</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $str .= "(";</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">
</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $op2 = '';</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> // 필드의 수만큼 다중 필드 검색 가능 (필드1+필드2...)</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> for ($k=0; $k<count($field); $k++) {</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $str .= $op2;</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> switch ($field[$k]) {</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> case 'mb_id' :</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> case 'wr_name' :</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $str .= "$field[$k] = '$s[$i]'";</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> break;</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> case 'wr_subject' :</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> case 'wr_content' :</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> if (preg_match("/[a-zA-Z]/", $search_str))</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $str .= "INSTR(LOWER({$field[$k]}), LOWER('{$search_str}'))";</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> else</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $str .= "INSTR({$field[$k]}, '{$search_str}')";</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> break;</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> default :</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $str .= "1=0"; // 항상 거짓</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> break;</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> }</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $op2 = " or ";</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> }</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $str .= ")";</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">
</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $op1 = " {$sop} ";</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> }</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $str .= ")";</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">
</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $sql_search = $str;</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">
</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $str_board_list = "";</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $board_count = 0;</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">
</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $time1 = get_microtime();</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">
</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $total_count = 0;</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> for ($i=0; $i<count($g5_search['tables']); $i++) {</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $tmp_write_table = $g5['write_prefix'] . $g5_search['tables'][$i];</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">
</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $sql = " select wr_id from {$tmp_write_table} where {$sql_search} ";</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $result = sql_query($sql, false);</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $row['cnt'] = @sql_num_rows($result);</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">
</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $total_count += $row['cnt'];</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> if ($row['cnt']) {</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $board_count++;</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $search_table[] = $g5_search['tables'][$i];</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $read_level[] = $g5_search['read_level'][$i];</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $search_table_count[] = $total_count;</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">
</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $sql2 = " select bo_subject, bo_mobile_subject from {$g5['board_table']} where bo_table = '{$g5_search['tables'][$i]}' ";</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $row2 = sql_fetch($sql2);</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $sch_class = "";</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $sch_all = "";</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> if ($onetable == $g5_search['tables'][$i]) $sch_class = "class=sch_on";</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> else $sch_all = "class=sch_on";</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $str_board_list .= '<li><a href="'.$_SERVER['SCRIPT_NAME'].'?'.$search_query.'&gr_id='.$gr_id.'&onetable='.$g5_search['tables'][$i].'" '.$sch_class.'><strong>'.((G5_IS_MOBILE && $row2['bo_mobile_subject']) ? $row2['bo_mobile_subject'] : $row2['bo_subject']).'</strong><span class="cnt_cmt">'.$row['cnt'].'</span></a></li>';</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> }</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> }</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">
</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $rows = $srows;</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $total_page = ceil($total_count / $rows); // 전체 페이지 계산</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> if ($page < 1) { $page = 1; } // 페이지가 없으면 첫 페이지 (1 페이지)</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $from_record = ($page - 1) * $rows; // 시작 열을 구함</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">
</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> for ($i=0; $i<count($search_table); $i++) {</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> if ($from_record < $search_table_count[$i]) {</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $table_index = $i;</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $from_record = $from_record - $search_table_count[$i-1];</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> break;</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> }</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> }</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">
</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $bo_subject = array();</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $list = array();</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">
</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $k=0;</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> for ($idx=$table_index; $idx<count($search_table); $idx++) {</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $sql = " select bo_subject, bo_mobile_subject from {$g5['board_table']} where bo_table = '{$search_table[$idx]}' ";</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $row = sql_fetch($sql);</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $bo_subject[$idx] = ((G5_IS_MOBILE && $row['bo_mobile_subject']) ? $row['bo_mobile_subject'] : $row['bo_subject']);</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">
</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $tmp_write_table = $g5['write_prefix'] . $search_table[$idx];</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">
</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $sql = " select * from {$tmp_write_table} where {$sql_search} order by wr_id desc limit {$from_record}, {$rows} ";</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $result = sql_query($sql);</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> for ($i=0; $row=sql_fetch_array($result); $i++) {</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> // 검색어까지 링크되면 게시판 부하가 일어남</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $list[$idx][$i] = $row;</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $list[$idx][$i]['href'] = './board.php?bo_table='.$search_table[$idx].'&wr_id='.$row['wr_parent'];</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">
</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> if ($row['wr_is_comment'])</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> {</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $sql2 = " select wr_subject, wr_option from {$tmp_write_table} where wr_id = '{$row['wr_parent']}' ";</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $row2 = sql_fetch($sql2);</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> //$row['wr_subject'] = $row2['wr_subject'];</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $row['wr_subject'] = get_text($row2['wr_subject']);</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> }</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">
</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> // 비밀글은 검색 불가</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> if (strstr($row['wr_option'].$row2['wr_option'], 'secret'))</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $row['wr_content'] = '[비밀글 입니다.]';</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">
</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $subject = get_text($row['wr_subject']);</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> if (strstr($sfl, 'wr_subject'))</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $subject = search_font($stx, $subject);</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">
</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> if ($read_level[$idx] <= $member['mb_level'])</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> {</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> //$content = cut_str(get_text(strip_tags($row['wr_content'])), 300, "…");</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $content = strip_tags($row['wr_content']);</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $content = get_text($content, 1);</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $content = strip_tags($content);</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $content = str_replace(' ', '', $content);</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $content = cut_str($content, 300, "…");</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">
</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> if (strstr($sfl, 'wr_content'))</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $content = search_font($stx, $content);</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> }</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> else</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $content = '';</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">
</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $list[$idx][$i]['subject'] = $subject;</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $list[$idx][$i]['content'] = $content;</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $list[$idx][$i]['name'] = get_sideview($row['mb_id'], get_text(cut_str($row['wr_name'], $config['cf_cut_name'])), $row['wr_email'], $row['wr_homepage']);</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">
</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $k++;</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> if ($k >= $rows)</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> break;</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> }</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> sql_free_result($result);</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">
</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> if ($k >= $rows)</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> break;</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">
</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $from_record = 0;</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> }</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">
</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $write_pages = get_paging(G5_IS_MOBILE ? $config['cf_mobile_pages'] : $config['cf_write_pages'], $page, $total_page, $_SERVER['SCRIPT_NAME'].'?'.$search_query.'&gr_id='.$gr_id.'&srows='.$srows.'&onetable='.$onetable.'&page=');</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">}</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">
</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">$group_select = '<label for="gr_id" class="sound_only">게시판 그룹선택</label><select name="gr_id" id="gr_id" class="select"><option value="">전체 분류';</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">$sql = " select gr_id, gr_subject from {$g5['group_table']} order by gr_id ";</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">$result = sql_query($sql);</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">for ($i=0; $row=sql_fetch_array($result); $i++)</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;"> $group_select .= "<option value=\"".$row['gr_id']."\"".get_selected($_GET['gr_id'], $row['gr_id']).">".$row['gr_subject']."</option>";</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">$group_select .= '</select>';</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">
</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">if (!$sfl) $sfl = 'wr_subject';</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">if (!$sop) $sop = 'or';</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">
</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">include_once($search_skin_path.'/search.skin.php');</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">
</span></font></p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">include_once('./_tail.php');</span></font></p><p> </p><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">?></span></font></p><div>
</div><p><font color="#505050" face="돋움, Dotum, sans-serif"><span style="font-size: 14.004px;">
답변 1개
답변을 작성하려면 로그인이 필요합니다.
로그인