내가 쓴글 불러온 게시물 옆에 댓글 표시 채택완료

</p><p><?</p><p>include_once("./_common.php");</p><p> </p><p>$g4[title] = "최근 게시물"; </p><p>include_once("./_head.php"); </p><p> </p><p>$mb_id = $_GET['mb_id']; </p><p>if(!$mb_id){ </p><p>$mb_id = $_POST['mb_id']; </p><p>if(!$mb_id){ </p><p>$mb_id = $member[mb_id]; </p><p>} </p><p>} </p><p> </p><p>$gr_id = "";</p><p>if(!$view){$view = "";}</p><p> </p><p>$sql_common = " from $g4[board_new_table] a, $g4[board_table] b, $g4[group_table] c </p><p>               where a.bo_table = b.bo_table and b.gr_id = c.gr_id and b.bo_use_search = '1' ";</p><p>if ($gr_id)</p><p>    $sql_common .= " and b.gr_id = '$gr_id' ";</p><p>if ($view == "w")</p><p>    $sql_common .= " and a.wr_id = a.wr_parent ";</p><p>else if ($view == "c")</p><p>    $sql_common .= " and a.wr_id <> a.wr_parent ";</p><p>if ($mb_id)</p><p>    $sql_common .= " and a.mb_id = '$mb_id' ";</p><p>$sql_order = " order by a.bn_id desc ";</p><p> </p><p>$sql = " select count(*) as cnt $sql_common ";</p><p>$row = sql_fetch($sql);</p><p>$total_count = $row[cnt];</p><p> </p><p>$rows = $config[cf_new_rows];</p><p>$total_page  = ceil($total_count / $rows);  // 전체 페이지 계산</p><p>if (!$page) $page = 1; // 페이지가 없으면 첫 페이지 (1 페이지)</p><p>$from_record = ($page - 1) * $rows; // 시작 열을 구함</p><p> </p><p>$group_select = "<select name=gr_id id=gr_id onchange='select_change();'><option value=''>전체그룹";</p><p>$sql = " select gr_id, gr_subject from $g4[group_table] order by gr_id ";</p><p>$result = sql_query($sql);</p><p>for ($i=0; $row=sql_fetch_array($result); $i++) </p><p>{</p><p>    $group_select .= "<option value='$row[gr_id]'>$row[gr_subject]";</p><p>}</p><p>$group_select .= "</select>";</p><p> </p><p> </p><p>$list = array();</p><p>$sql = " select a.*, b.bo_subject, c.gr_subject, c.gr_id</p><p>          $sql_common</p><p>          $sql_order</p><p>          limit $from_record, $rows ";</p><p>$result = sql_query($sql);</p><p>for ($i=0; $row=sql_fetch_array($result); $i++) </p><p>{</p><p>    $tmp_write_table = $g4[write_prefix] . $row[bo_table];</p><p> </p><p>    if ($row[wr_id] == $row[wr_parent]) // 원글</p><p>    {</p><p>        $comment = "";</p><p>        $comment_link = "";</p><p>        $row2 = sql_fetch(" select * from $tmp_write_table where wr_id = '$row[wr_id]' ");</p><p>        $list[$i] = $row2;</p><p> </p><p>        $name = get_sideview($row2[mb_id], cut_str($row2[wr_name], $config[cf_cut_name]), $row2[wr_email], $row2[wr_homepage]);</p><p>        // 당일인 경우 시간으로 표시함</p><p>        $datetime = substr($row2[wr_datetime],0,10);</p><p>        $datetime2 = $row2[wr_datetime];</p><p>        if ($datetime == $g4[time_ymd])</p><p>            $datetime2 = substr($datetime2,11,5);</p><p>        else</p><p>            $datetime2 = substr($datetime2,5,5);</p><p> </p><p>    }</p><p>    else // 코멘트</p><p>    {</p><p>        $comment = "[코] ";</p><p>        $comment_link = "#c_{$row[wr_id]}";</p><p>        $row2 = sql_fetch(" select * from $tmp_write_table where wr_id = '$row[wr_parent]' ");</p><p>        $row3 = sql_fetch(" select mb_id, wr_name, wr_email, wr_homepage, wr_datetime from $tmp_write_table where wr_id = '$row[wr_id]' ");</p><p>        $list[$i] = $row2;</p><p>        $list[$i][mb_id] = $row3[mb_id];</p><p>        $list[$i][wr_name] = $row3[wr_name];</p><p>        $list[$i][wr_email] = $row3[wr_email];</p><p>        $list[$i][wr_homepage] = $row3[wr_homepage];</p><p> </p><p>        $name = get_sideview($row3[mb_id], cut_str($row3[wr_name], $config[cf_cut_name]), $row3[wr_email], $row3[wr_homepage]);</p><p>        // 당일인 경우 시간으로 표시함</p><p>        $datetime = substr($row3[wr_datetime],0,10);</p><p>        $datetime2 = $row3[wr_datetime];</p><p>        if ($datetime == $g4[time_ymd])</p><p>            $datetime2 = substr($datetime2,11,5);</p><p>        else</p><p>            $datetime2 = substr($datetime2,5,5);</p><p>    }</p><p> </p><p>    $list[$i][gr_id] = $row[gr_id];</p><p>    $list[$i][bo_table] = $row[bo_table];</p><p>    $list[$i][name] = $name;</p><p>    $list[$i][comment] = $comment;</p><p>    $list[$i][href] = "./board.php?bo_table=$row[bo_table]&wr_id=$row2[wr_id]{$comment_link}";</p><p>    $list[$i][datetime] = $datetime;</p><p>    $list[$i][datetime2] = $datetime2;</p><p> </p><p>    $list[$i][gr_subject] = $row[gr_subject];</p><p>    $list[$i][bo_subject] = $row[bo_subject];</p><p>    $list[$i][wr_subject] = $row2[wr_subject];</p><p>}</p><p> </p><p>$write_pages = get_paging($config[cf_write_pages], $page, $total_page, "{$PHP_SELF}?view=$view&page=");</p><p> </p><p>$new_skin_path = "$g4[path]/skin/new/$config[cf_new_skin]";</p><p> </p><p>echo "<script type=\"text/javascript\" src=\"$g4[path]/js/sideview.js\"></script>\n";</p><p> </p><p>?></p><p><style></p><p>.board_top { clear:both; }</p><p> </p><p>.board_list { clear:both; width:100%; table-layout:fixed; margin:5px 0 0 0; }</p><p>.board_list th { font-weight:bold; font-size:12px; } </p><p>.board_list th { background:url(/img/title_bg.gif) repeat-x; } </p><p>.board_list th { white-space:nowrap; height:34px; overflow:hidden; text-align:center; } </p><p>.board_list th { border-top:1px solid #ddd; border-bottom:1px solid #ddd; } </p><p> </p><p>.board_list tr.bg0 { background-color:#fafafa; } </p><p>.board_list tr.bg1 { background-color:#ffffff; } </p><p> </p><p>.board_list td { padding:.5em; }</p><p>.board_list td { border-bottom:1px solid #ddd; } </p><p>.board_list td.num { color:#999999; text-align:center; }</p><p>.board_list td.checkbox { text-align:center; }</p><p>.board_list td.subject { overflow:hidden; }</p><p>.board_list td.name { padding:0 0 0 10px; }</p><p>.board_list td.datetime { font:normal 11px tahoma; color:#BABABA; text-align:center; }</p><p>.board_list td.hit { font:normal 11px tahoma; color:#BABABA; text-align:center; }</p><p>.board_list td.good { font:normal 11px tahoma; color:#BABABA; text-align:center; }</p><p>.board_list td.nogood { font:normal 11px tahoma; color:#BABABA; text-align:center; }</p><p> </p><p>.board_list .notice { font-weight:normal; }</p><p>.board_list .current { font:bold 11px tahoma; color:#E15916; }</p><p>.board_list .comment { font-family:Tahoma; font-size:10px; color:#EE5A00; }</p><p> </p><p>.board_button { clear:both; margin:10px 0 0 0; }</p><p> </p><p>.board_page { clear:both; text-align:center; margin:3px 0 0 0; }</p><p>.board_page a:link { color:#777; }</p><p> </p><p>.board_search { text-align:center; margin:10px 0 0 0; }</p><p>.board_search .stx { height:21px; border:1px solid #9A9A9A; border-right:1px solid #D8D8D8; border-bottom:1px solid #D8D8D8; }</p><p></style></p><p> </p><p><form name=fnew method=get style="margin:0px;"></p><p><table width="100%" border="0" cellspacing="0" cellpadding="0"></p><p><tr></p><p>    <td height=30></p><p>        <!--<?=$group_select?>--></p><p>        <select id=view name=view onchange="select_change()"></p><p>            <option value=''>전체게시물</p><p>            <option value='w'>원글만</p><p>            <option value='c'>코멘트만</p><p>        </select></p><p><span class="Apple-tab-span" style="white-space:pre">		</span><!--</p><p>         <b>회원아이디 : </b></p><p>        <input type=text class=ed id='mb_id' name='mb_id' value='<?=$mb_id?>'></p><p>        <input type=submit value='검색'></p><p><span class="Apple-tab-span" style="white-space:pre">		</span>--></p><p>        <script type="text/javascript"></p><p>        function select_change()</p><p>        {</p><p>            document.fnew.submit();</p><p>        }</p><p>        document.getElementById("gr_id").value = "<?=$gr_id?>";</p><p>        document.getElementById("view").value = "<?=$view?>";</p><p>        </script></p><p><span class="Apple-tab-span" style="white-space:pre">		</span></p><p>    </td></p><p></tr></p><p></table></p><p></form></p><p> </p><p> </p><p><span class="Apple-tab-span" style="white-space:pre">				</span><!-- board_list--></p><p>    <table cellspacing="0" cellpadding="0" class="board_list"></p><p><tr> </p><p>    <td width="4" height="33" bgcolor="#7BB2D6"><img src="<?=$new_skin_path?>/img/list_top_01.gif" width="4" height="33"></td></p><p>    <td width="100" align="center" bgcolor="#7BB2D6" height="30"><font class=n_title1><strong>그룹</strong></font></td></p><p>    <td width="5" align="center" valign="middle" bgcolor="#7BB2D6"><img src="<?=$new_skin_path?>/img/list_top_02.gif" width="5" height="33"></td></p><p>    <td width="5" align="center" valign="middle" bgcolor="#EEEEEE"><img src="<?=$new_skin_path?>/img/list_top_03.gif" width="5" height="33"></td></p><p>    <td width="100" align="center" bgcolor="#EEEEEE"><font class=n_title2><strong>게시판</strong></font></td></p><p>    <td width="" align="center" bgcolor="#EEEEEE"><font class=n_title2><strong>제목</strong></font></td></p><p>    <td width="120" align="center" bgcolor="#EEEEEE"><font class=n_title2><strong>이름</strong></font></td></p><p>    <td width="60" align="center" bgcolor="#EEEEEE"><font class=n_title2><strong>일시</strong></font></td></p><p>    <td width="4" bgcolor="#EEEEEE"><img src="<?=$new_skin_path?>/img/list_top_04.gif" width="4" height="33"></td></p><p></tr></p><p> </p><p><span class="Apple-tab-span" style="white-space:pre">					</span><?</p><p>for ($i=0; $i<count($list); $i++) </p><p>{</p><p>    $gr_subject = $list[$i][gr_subject];</p><p>    $bo_subject = $list[$i][bo_subject];</p><p>    $wr_subject = get_text($list[$i][wr_subject]);</p><p>    $bo_name = $list[$i][wr_name ];</p><p> </p><p> </p><p>    echo <<<HEREDOC</p><p><tr> </p><p><span class="Apple-tab-span" style="white-space:pre">	</span> <td align="center" height="30" colspan=3><a href='./new.php?gr_id={$list[$i][gr_id]}'>{$gr_subject}</a></td></p><p>    <td align="center" colspan=2><a href='./bbs/board.php?bo_table={$list[$i][bo_table]}'>{$bo_subject}</a></td></p><p>    <td width=""> <a href='/bbs/{$list[$i][href]}'>{$list[$i][comment]}{$wr_subject}</p><p> </p><p> </p><p><span class="Apple-tab-span" style="white-space:pre">	</span></p><p><span class="Apple-tab-span" style="white-space:pre">	</span></a></td></p><p><span class="Apple-tab-span" style="white-space:pre">	</span><td align="center">{$list[$i][name]}</td></p><p><span class="Apple-tab-span" style="white-space:pre">	</span><td align="center" colspan=2>{$list[$i][datetime2]}</td></p><p> </p><p> </p><p> </p><p> </p><p> </p><p> </p><p> </p><p> </p><p><span class="Apple-tab-span" style="white-space:pre">	</span></tr></p><p>HEREDOC;</p><p>}</p><p>?></p><p> </p><p><? if ($i == 0) { ?></p><p><tr><td colspan="3" height=50 align=center>게시물이 없습니다.</td></tr></p><p><? } ?></p><p> </p><p><span class="Apple-tab-span" style="white-space:pre">				</span></table></p><p><span class="Apple-tab-span" style="white-space: pre;">				</span><?=$write_pages?> </p><p>