검색 행수를 가로3개씩 뿌려지게 하고 싶은데여..ㅜㅜ > 그누4 질문답변

그누4 질문답변

그누보드4 관련 질문은 QA 로 이전됩니다. QA 그누보드4 바로가기
기존 게시물은 열람만 가능합니다.

검색 행수를 가로3개씩 뿌려지게 하고 싶은데여..ㅜㅜ 정보

검색 행수를 가로3개씩 뿌려지게 하고 싶은데여..ㅜㅜ

본문

아래소스는 search.php파일의 소스입니다.
여기에서 $srows = 5; // 한페이지에 출력하는 검색 행수를 가로3씩 뿌려지게 하고 싶습니다.
고수님들 제발 도와주세여..ㅠㅠ
 
<!--------------------search.php source start
<?
include_once("./_common.php");
//if (!$stx) alert("검색어가 없습니다.");
$g4[title] = "검색 : " . $stx;
include_once("./_head.php");
if ($stx)
{
    //$stx = trim($stx);
    $stx = preg_replace("/\//", "\/", trim($stx));
    $sop = strtolower($sop);
    if (!$sop || !($sop == "and" || $sop == "or")) $sop = "and"; // 연산자 and , or
    if (!$srows) $srows = 5; // 한페이지에 출력하는 검색 행수
    unset($g4_search[tables]);
    unset($g4_search[read_level]);
    $sql = " select gr_id, bo_table, bo_read_level
               from $g4[board_table]
              where bo_use_search = '1'
                and bo_list_level <= '$member[mb_level]' ";
    //            and bo_read_level <= '$member[mb_level]' ";
    if ($gr_id)
        $sql .= " and gr_id = '$gr_id' ";
    if ($onetable) // 하나의 게시판만 검색한다면
        $sql .= " and bo_table = '$onetable' ";
    $sql .= " order by bo_order_search, gr_id, bo_table ";
    $result = sql_query($sql);
    for ($i=0; $row=sql_fetch_array($result); $i++)
    {
        if ($is_admin != "super")
        {
            // 그룹접근 사용에 대한 검색 차단
            $sql2 = " select gr_use_access, gr_admin from $g4[group_table] where gr_id = '$row[gr_id]' ";
            $row2 = sql_fetch($sql2);
            // 그룹접근을 사용한다면
            if ($row2[gr_use_access])
            {
                // 그룹관리자가 있으며 현재 회원이 그룹관리자라면 통과
                if ($row2[gr_admin] && $row2[gr_admin] == $member[mb_id])
                    ;
                else
                {
                    $sql3 = " select count(*) as cnt from $g4[group_member_table]
                               where gr_id = '$row[gr_id]'
                                 and mb_id = '$member[mb_id]'
                                 and mb_id <> '' ";
                    $row3 = sql_fetch($sql3);
                    if (!$row3[cnt])
                        continue;
                }
            }
        }
        $g4_search[tables][] = $row[bo_table];
        $g4_search[read_level][] = $row[bo_read_level];
    }
    $search_query = "sfl=".urlencode($sfl)."&stx=".urlencode($stx)."&sop=$sop";

    $text_stx = get_text(stripslashes($stx));
    $op1 = "";
    // 검색어를 구분자로 나눈다. 여기서는 공백
    $s = explode(" ", $stx);
    // 검색필드를 구분자로 나눈다. 여기서는 +
    $field = explode("||", trim($sfl));
    $str = "(";
    for ($i=0; $i<count($s); $i++)
    {
        //$search_str = strtolower($s[$i]);
        $search_str = $s[$i];
        $str .= $op1;
        $str .= "(";
       
        $op2 = "";
        for ($k=0; $k<count($field); $k++) // 필드의 수만큼 다중 필드 검색 가능 (필드1+필드2...)
        {
            $str .= $op2;
            switch ($field[$k])
            {
                case "mb_id" :
                case "mb_name" :
                    $str .= "$field[$k] = '$s[$i]'";
                    break;
                default :
                    if (preg_match("/[a-zA-Z]/", $search_str))
                        $str .= "INSTR(LOWER($field[$k]), LOWER('$search_str'))";
                    else
                        $str .= "INSTR($field[$k], '$search_str')";
                    break;
            }
            $op2 = " or ";
        }
        $str .= ")";
        $op1 = " $sop ";
        // 인기검색어
        $sql = " insert into $g4[popular_table]
                    set pp_word = '$search_str',
                        pp_date = '$g4[time_ymd]',
                        pp_ip = '$_SERVER[REMOTE_ADDR]' ";
        sql_query($sql, FALSE);
    }
    $str .= ")";
    //$sql_search = $str . " and wr_option not like '%secret%' "; // 비밀글은 제외
    $sql_search = $str;
    $str_board_list = "";
    $board_count = 0;
    $time1 = get_microtime();
    $total_count = 0;
    for ($i=0; $i<count($g4_search[tables]); $i++)
    {
        $tmp_write_table   = $g4[write_prefix] . $g4_search[tables][$i];
       
        $sql = " select wr_id from $tmp_write_table where $sql_search ";
        $result = sql_query($sql, false);
        $row[cnt] = @mysql_num_rows($result);
        //$sql = " select count(*) as cnt from $tmp_write_table where $sql_search ";
        //$row = sql_fetch($sql);
        $total_count += $row[cnt];
        if ($row[cnt])
        {
            $board_count++;
            $search_table[] = $g4_search[tables][$i];
            $read_level[]   = $g4_search[read_level][$i];
            $search_table_count[] = $total_count;
            $sql2 = " select bo_subject from $g4[board_table] where bo_table = '{$g4_search[tables][$i]}' ";
            $row2 = sql_fetch($sql2);
            $str_board_list .= "<li><a href='$_SERVER[PHP_SELF]?$search_query&gr_id=$gr_id&onetable={$g4_search[tables][$i]}'>$row2[bo_subject]</a> ($row[cnt])";
        }
    }
    $rows = $srows;
    $total_page  = ceil($total_count / $rows);  // 전체 페이지 계산
    if ($page == "") { $page = 1; } // 페이지가 없으면 첫 페이지 (1 페이지)
    $from_record = ($page - 1) * $rows; // 시작 열을 구함
    for ($i=0; $i<count($search_table); $i++)
    {
        if ($from_record < $search_table_count[$i])
        {
            $table_index = $i;
            $from_record = $from_record - $search_table_count[$i-1];
            break;
        }
    }
    $bo_subject = array();
    $list = array();
    $k=0;
    for ($idx=$table_index; $idx<count($search_table); $idx++)
    {
        $sql = " select bo_subject from $g4[board_table] where bo_table = '$search_table[$idx]' ";
        $row = sql_fetch($sql);
        $bo_subject[$idx] = $row[bo_subject];
        $tmp_write_table = $g4[write_prefix] . $search_table[$idx];
        $sql = " select * from $tmp_write_table where $sql_search order by wr_id desc limit $from_record, $rows ";
        $result = sql_query($sql);
        for ($i=0; $row=sql_fetch_array($result); $i++)
        {
            // 검색어까지 링크되면 게시판 부하가 일어남
            $list[$idx][$i] = $row;
            $list[$idx][$i][href] = "./board.php?bo_table=$search_table[$idx]&wr_id=$row[wr_parent]";
            if ($row[wr_is_comment])
            {
                $link .= "#c{$row[wr_id]}";
                $sql2 = " select wr_subject, wr_option from $tmp_write_table where wr_id = '$row[wr_parent]' ";
                $row2 = sql_fetch($sql2);
                //$row[wr_subject] = $row2[wr_subject];
                $row[wr_subject] = get_text($row2[wr_subject]);
            }
            // 비밀글은 검색 불가
            if (strstr($row[wr_option].$row2[wr_option], "secret"))
                $row[wr_content] = "[비밀글 입니다.]";
            $subject = $row[wr_subject];
            if (strstr($sfl, "wr_subject"))
                $subject = search_font($stx, $subject);
            if ($read_level[$idx] <= $member[mb_level])
            {
                $content = cut_str(get_text($row[wr_content]),300,"…");
                if (strstr($sfl, "wr_content"))
                    $content = search_font($stx, $content);
            }
            else
                $content = '';
            $list[$idx][$i][subject] = $subject;
            $list[$idx][$i][content] = $content;
            $list[$idx][$i][wr_id]  = $row[wr_id]; //이미지용 이거 추가
            $list[$idx][$i][name] = get_sideview($row[mb_id], cut_str($row[wr_name], $config[cf_cut_name]), $row[wr_email], $row[wr_homepage]);
           
            $k++;
            if ($k >= $rows)
                break;
        }
        sql_free_result($result);
       
        if ($k >= $rows)
            break;
        $from_record = 0;
    }
    $write_pages = get_paging($config[cf_write_pages], $page, $total_page, "$_SERVER[PHP_SELF]?$search_query&gr_id=$gr_id&srows=$srows&onetable=$onetable&page=");
    echo "<script language=\"javascript\" src=\"$g4[path]/js/sideview.js\"></script>";
}
$group_select = "<select id='gr_id' name='gr_id' class=select><option value=''>전체 분류";
$sql = " select gr_id, gr_subject from $g4[group_table] order by gr_id ";
$result = sql_query($sql);
for ($i=0; $row=sql_fetch_array($result); $i++)
    $group_select .= "<option value='$row[gr_id]'>$row[gr_subject]";
$group_select .= "</select>";
if (!$sfl) $sfl = "wr_subject";
if (!$sop) $sop = "or";
$search_skin_path = "$g4[path]/skin/search/$config[cf_search_skin]";
include_once("$search_skin_path/search.skin.php");
include_once("./_tail.php");
?>
search.php source start//--------------------->

댓글 전체

스킨 디렉토리에서 정의를 하는걸 깜박..여기에서 어케 수정해야 하지요?
<?
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가
?>

<table align=center width=95% cellpadding=2 cellspacing=0>
<form name=fsearch method=get action="javascript:fsearch_submit(document.fsearch);">
<input type="hidden" name="srows" value="<?=$srows?>">
<tr>
    <td align=center>
        <?=$group_select?>
        <script language="JavaScript">document.getElementById("gr_id").value = "<?=$gr_id?>";</script>

        <select name=sfl class=select>
        <option value="wr_subject||wr_content||wr_1||wr_2||wr_3||wr_4||wr_5||wr_6||wr_7||wr_8||wr_9||wr_10">통합검색</option>
        <option value="wr_3">촬영날짜</option>
        <option value="wr_4">촬영기자</option>
        <option value="wr_5">사진DB 고유시리얼</option>
        <option value="wr_subject||wr_content">제목+내용</option>
        <option value="wr_subject">제목</option>
        <option value="wr_content">내용</option>
        <option value="mb_id">회원아이디</option>
        <option value="wr_name">이름</option>
        </select>

        <input type=text name=stx maxlength=20 required itemname="검색어" value='<?=$text_stx?>'>

        <input type=submit value=" 검 색 ">

        <script language="javascript">
        document.fsearch.sfl.value = "<?=$sfl?>";

        function fsearch_submit(f)
        {
            /*
            // 검색에 많은 부하가 걸리는 경우 이 주석을 제거하세요.
            var cnt = 0;
            for (var i=0; i<f.stx.value.length; i++)
            {
                if (f.stx.value.charAt(i) == ' ')
                    cnt++;
            }

            if (cnt > 1)
            {
                alert("빠른 검색을 위하여 검색어에 공백은 한개만 입력할 수 있습니다.");
                f.stx.select();
                f.stx.focus();
                return;
            }
            */
           
            f.action = "";
            f.submit();
        }
        </script>
    </td>
</tr>
<tr>
    <td align=center>
        연산자 &nbsp;
        <input type="radio" name="sop" value="or" <?=($sop == "or") ? "checked" : "";?>>OR &nbsp;
        <input type="radio" name="sop" value="and" <?=($sop == "and") ? "checked" : "";?>>AND
    </td>
</tr>
</form>
</table>
<p>


<table align=center width=100% cellpadding=2 cellspacing=0>
<tr>
    <td style='word-break:break-all;' valign='top'>
<table cellpadding=0 cellspacing=0>
        <tr>         
          <td colspan=3>
<nobr>
        <?
        if ($stx)
        {
            echo "<ul type=circle><li><b>검색된 게시판 리스트</b> (<b>{$board_count}</b>개의 게시판, <b>".number_format($total_count)."</b>개의 게시글, <b>".number_format($page)."/".number_format($total_page)."</b> 페이지)</ul>";
            if ($board_count)
            {
                echo "<ul><ul type=square style='line-height:130%;'>";
                if ($onetable)
                    echo "<li><a href='?$search_query&gr_id=$gr_id'>전체게시판 검색</a>";
                echo $str_board_list;
                echo "</ul></ul>";
            }
            else
            {
                echo "<ul style='line-height:130%;'><li>검색된 자료가 하나도 없습니다.</ul>";
            }
        }
        ?>


        <?
        $k=0;
        for ($idx=$table_index, $k=0; $idx<count($search_table) && $k<$rows; $idx++)
        {
            echo "<ul type=circle><li><b><a href='./board.php?bo_table={$search_table[$idx]}&{$search_query}'>{$bo_subject[$idx]}</u></a>에서의 검색결과</b></ul>";
            $comment_href = "";
            for ($i=0; $i<count($list[$idx]) && $k<$rows; $i++, $k++)
            {
                echo "<ul type=square><li style='line-height:130%;'>";
                if ($list[$idx][$i][wr_is_comment])
                {
                    echo "<font color=999999>[코멘트]</font> ";
                    $comment_href = "#c_".$list[$idx][$i][wr_id];
                }
                echo"<span style='font-size:11pt;'><b>";
                echo $list[$idx][$i][subject];
                echo"</b></span>";               
                echo "</a> [<a href='{$list[$idx][$i][href]}{$comment_href}' target=_blank>새창</a>]";
                echo "<br>";
                echo "<br>";
                echo "<font color='#ED2453'><b>사진DB 고유시리얼</b></font> : {$list[$idx][$i][wr_5]}";
                echo "<br>";
                echo "<font color='#ED2453'><b>촬영날짜</b></font> : {$list[$idx][$i][wr_3]}";               
                echo "<br>";
                echo "<a href='{$list[$idx][$i][href]}{$comment_href}'>";
                //이미지 출력 시작
                $img=$list[$idx][$i][wr_id];
                $roo = sql_fetch(" select bf_file from $g4[board_file_table] where bo_table = '$search_table[$idx]' and wr_id = '$img' and bf_no = '0' ");

if (preg_match("/\.($config[cf_image_extension])$/i", $roo[bf_file]))
                $imgser = "<img src='$g4[path]/data/file/$search_table[$idx]/$roo[bf_file]'  width=130 border=0>";
                // 여기 까지 추가
                echo "<a href='{$list[$idx][$i][href]}{$comment_href}'>";
              echo $imgser;                  // 요거두  추가
                //이미지 출력 끝               
               
                //echo $list[$idx][$i][content];
                echo "<br><font color=#999999>{$list[$idx][$i][wr_datetime]}</font><br>";
                echo "사진DB 작성자 :";               
                echo $list[$idx][$i][name];
                echo "</ul>";
                ?>
   
    </nobr><? } ?></td>
      </td>
      </tr>
  <tr>
    <td><? }?></td>
  </tr>
        </table></td>
  </tr>


 <tr><td><p align=center><?=$write_pages?></td></tr></table>
전체 66,554 |RSS
그누4 질문답변 내용 검색

회원로그인

(주)에스아이알소프트 / 대표:홍석명 / (06211) 서울특별시 강남구 역삼동 707-34 한신인터밸리24 서관 1404호 / E-Mail: admin@sir.kr
사업자등록번호: 217-81-36347 / 통신판매업신고번호:2014-서울강남-02098호 / 개인정보보호책임자:김민섭(minsup@sir.kr)
© SIRSOFT