new.php 기반으로 list를 만들었는데요~ 채택완료

</p><p><?php</p><p>include_once('./_common.php');</p><p> </p><p>$g5['title'] = '님 게시물';  // 여기에 지금 리스트를 보여주고 있는 사용자의 wr_name값을 넣고 싶습니다. 접속자의 wr_name 값말구요 ㅠㅠ</p><p> </p><p>include_once('./_head.php');</p><p> </p><p>// 게시물 정보($write_row)를 출력하기 위하여 $list로 가공된 정보를 복사 및 가공</p><p>function get_article($write_row, $board, $skin_url, $subject_len=40)</p><p>{</p><p>    global $g5, $config;</p><p>    global $qstr, $page;</p><p> </p><p>    //$t = get_microtime();</p><p> </p><p>    // 배열전체를 복사</p><p>    $list = $write_row;</p><p>    unset($write_row);</p><p> </p><p>    $board_notice = array_map('trim', explode(',', $board['bo_notice']));</p><p>    $list['is_notice'] = in_array($list['wr_id'], $board_notice);</p><p> </p><p>    if ($subject_len)</p><p>        $list['subject'] = conv_subject($list['wr_subject'], $subject_len, '…');</p><p>    else</p><p>        $list['subject'] = conv_subject($list['wr_subject'], $board['bo_subject_len'], '…');</p><p> </p><p>    // 목록에서 내용 미리보기 사용한 게시판만 내용을 변환함 (속도 향상) : kkal3(커피)님께서 알려주셨습니다.</p><p>    if ($board['bo_use_list_content'])</p><p><span class="Apple-tab-span" style="white-space:pre">	</span>{</p><p><span class="Apple-tab-span" style="white-space:pre">		</span>$html = 0;</p><p><span class="Apple-tab-span" style="white-space:pre">		</span>if (strstr($list['wr_option'], 'html1'))</p><p><span class="Apple-tab-span" style="white-space:pre">			</span>$html = 1;</p><p><span class="Apple-tab-span" style="white-space:pre">		</span>else if (strstr($list['wr_option'], 'html2'))</p><p><span class="Apple-tab-span" style="white-space:pre">			</span>$html = 2;</p><p> </p><p>        $list['content'] = conv_content($list['wr_content'], $html);</p><p><span class="Apple-tab-span" style="white-space:pre">	</span>}</p><p> </p><p>    $list['comment_cnt'] = '';</p><p>    if ($list['wr_comment']) {</p><p><span class="Apple-tab-span" style="white-space:pre">		</span>$list['comment_cnt'] = "<span class=\"cnt_cmt txt_red\">"."(".$list['wr_comment'].")"."</span>";</p><p><span class="Apple-tab-span" style="white-space:pre">	</span>}</p><p>    // 당일인 경우 시간으로 표시함</p><p>    $list['datetime'] = substr($list['wr_datetime'],0,10);</p><p>    $list['datetime2'] = $list['wr_datetime'];</p><p>    if ($list['datetime'] == G5_TIME_YMD)</p><p>        $list['datetime2'] = substr($list['datetime2'],11,5);</p><p>    else</p><p>        $list['datetime2'] = substr($list['datetime2'],5,5);</p><p>    // 4.1</p><p>    $list['last'] = substr($list['wr_last'],0,10);</p><p>    $list['last2'] = $list['wr_last'];</p><p>    if ($list['last'] == G5_TIME_YMD)</p><p>        $list['last2'] = substr($list['last2'],11,5);</p><p>    else</p><p>        $list['last2'] = substr($list['last2'],5,5);</p><p> </p><p>    $list['wr_homepage'] = get_text($list['wr_homepage']);</p><p> </p><p>    $tmp_name = get_text(cut_str($list['wr_name'], $config['cf_cut_name'])); // 설정된 자리수 만큼만 이름 출력</p><p>    $tmp_name2 = cut_str($list['wr_name'], $config['cf_cut_name']); // 설정된 자리수 만큼만 이름 출력</p><p>    if ($board['bo_use_sideview'])</p><p>        $list['name'] = get_sideview($list['mb_id'], $tmp_name2, $list['wr_email'], $list['wr_homepage']);</p><p>    else</p><p>        $list['name'] = '<span class="'.($list['mb_id']?'sv_member':'sv_guest').'">'.$tmp_name.'</span>';</p><p> </p><p>    $reply = $list['wr_reply'];</p><p> </p><p>    $list['reply'] = strlen($reply)*10;</p><p> </p><p>    $list['icon_reply'] = '';</p><p>    if ($list['reply'])</p><p>        $list['icon_reply'] = '<img src="'.$skin_url.'/img/icon_reply.gif" style="margin-left:'.$list['reply'].'px;" alt="답변글">';</p><p> </p><p>    $list['icon_link'] = '';</p><p>    if ($list['wr_link1'] || $list['wr_link2'])</p><p>        $list['icon_link'] = '<img src="'.$skin_url.'/img/icon_link.gif" alt="관련링크">';</p><p> </p><p>    // 분류명 링크</p><p>    $list['ca_name_href'] = G5_BBS_URL.'/board.php?bo_table='.$board['bo_table'].'&amp;sca='.urlencode($list['ca_name']);</p><p> </p><p>    $list['href'] = G5_BBS_URL.'/board.php?bo_table='.$board['bo_table'].'&amp;wr_id='.$list['wr_id'].$qstr;</p><p>    $list['comment_href'] = $list['href'];</p><p> </p><p>    $list['icon_new'] = '';</p><p>    if ($board['bo_new'] && $list['wr_datetime'] >= date("Y-m-d H:i:s", G5_SERVER_TIME - ($board['bo_new'] * 3600)))</p><p>        $list['icon_new'] = '<img src="'.$skin_url.'/img/icon_new.gif" alt="새글">';</p><p> </p><p>    $list['icon_hot'] = '';</p><p>    if ($board['bo_hot'] && $list['wr_hit'] >= $board['bo_hot'])</p><p>        $list['icon_hot'] = '<img src="'.$skin_url.'/img/icon_hot.gif" alt="인기글">';</p><p> </p><p>    $list['icon_secret'] = '';</p><p>    if (strstr($list['wr_option'], 'secret'))</p><p>        $list['icon_secret'] = '<img src="'.$skin_url.'/img/icon_secret.gif" alt="비밀글">';</p><p> </p><p>    // 링크</p><p>    for ($i=1; $i<=G5_LINK_COUNT; $i++) {</p><p>        $list['link'][$i] = set_http(get_text($list["wr_link{$i}"]));</p><p>        $list['link_href'][$i] = G5_BBS_URL.'/link.php?bo_table='.$board['bo_table'].'&amp;wr_id='.$list['wr_id'].'&amp;no='.$i.$qstr;</p><p>        $list['link_hit'][$i] = (int)$list["wr_link{$i}_hit"];</p><p>    }</p><p> </p><p>    // 가변 파일</p><p>    if ($board['bo_use_list_file'] || ($list['wr_file'] && $subject_len == 255) /* view 인 경우 */) {</p><p>        $list['file'] = get_file($board['bo_table'], $list['wr_id']);</p><p>    } else {</p><p>        $list['file']['count'] = $list['wr_file'];</p><p>    }</p><p> </p><p>    if ($list['file']['count'])</p><p>        $list['icon_file'] = '<img src="'.$skin_url.'/img/icon_file.gif" alt="첨부파일">';</p><p> </p><p>    return $list;</p><p>}</p><p> </p><p>$list = array();</p><p>$sql = " select * from {$g5['board_table']} ";</p><p>$result1 = sql_query($sql);</p><p> </p><p>for ($i=0; $row1 = sql_fetch_array($result1); $i++) {</p><p><span class="Apple-tab-span" style="white-space:pre">	</span>$board = $row1;</p><p><span class="Apple-tab-span" style="white-space:pre">	</span>$bo_subject = get_text($board['bo_subject']);</p><p><span class="Apple-tab-span" style="white-space:pre">	</span>$tmp_write_table = $g5['write_prefix'] . $row1['bo_table']; // 게시판 테이블 전체이름</p><p><span class="Apple-tab-span" style="white-space:pre">	</span></p><p><span class="Apple-tab-span" style="white-space:pre">	</span>if($i == 0)</p><p><span class="Apple-tab-span" style="white-space:pre">	</span>{</p><p><span class="Apple-tab-span" style="white-space:pre">		</span>$sql = "(select * from {$tmp_write_table}, (select bo_table, bo_subject, gr_id from {$g5['board_table']} where bo_table = '".$board['bo_table']."' ) as temp where mb_id = '$mb_id'";</p><p><span class="Apple-tab-span" style="white-space:pre">	</span>}</p><p><span class="Apple-tab-span" style="white-space:pre">	</span>else</p><p><span class="Apple-tab-span" style="white-space:pre">	</span>{</p><p><span class="Apple-tab-span" style="white-space:pre">		</span>$sql .= " union select * from {$tmp_write_table}, (select bo_table, bo_subject, gr_id from {$g5['board_table']} where bo_table = '".$board['bo_table']."' ) as temp where mb_id = '$mb_id'";</p><p><span class="Apple-tab-span" style="white-space:pre">	</span>}</p><p><span class="Apple-tab-span" style="white-space:pre">	</span></p><p> </p><p>/*</p><p><span class="Apple-tab-span" style="white-space:pre">	</span>if($i == 0)</p><p><span class="Apple-tab-span" style="white-space:pre">	</span>{</p><p><span class="Apple-tab-span" style="white-space:pre">		</span>$sql = " select * from {$tmp_write_table}, (select b.bo_subject as subject g.gr_subject as gsubject from {$g5['board_table']} as b left join {$g5['group_table']} as g on b.gr_id = g.gr_id where bo_table = '".$board['bo_table']."' ) where mb_id = 'admin'";</p><p><span class="Apple-tab-span" style="white-space:pre">	</span>}</p><p><span class="Apple-tab-span" style="white-space:pre">	</span>else</p><p><span class="Apple-tab-span" style="white-space:pre">	</span>{</p><p><span class="Apple-tab-span" style="white-space:pre">		</span>$sql .= " union select * from {$tmp_write_table}, (select b.bo_subject as subject g.gr_subject as gsubject from {$g5['board_table']} as b left join {$g5['group_table']} as g on b.gr_id = g.gr_id where bo_table = '".$board['bo_table']."' )  where mb_id = 'admin'";</p><p><span class="Apple-tab-span" style="white-space:pre">	</span>}*/</p><p>}</p><p>$sql .= ") as temp2 left join g5_group as gr on temp2.gr_id = gr.gr_id order by wr_datetime DESC";</p><p> </p><p>$query1 = " select count(*) as cnt from ".$sql;</p><p> </p><p>$link = $g5['connect_db'];</p><p> </p><p>$result3 = @mysqli_query($link, $query1);</p><p> </p><p>$row5 = @mysqli_fetch_assoc($result3);</p><p> </p><p>$rows = G5_IS_MOBILE ? $config['cf_mobile_page_rows'] : $config['cf_new_rows'];</p><p> </p><p>$total_count = $row5['cnt'];</p><p> </p><p>$total_page  = ceil($total_count / $rows);  // 전체 페이지 계산</p><p>if ($page < 1) $page = 1; // 페이지가 없으면 첫 페이지 (1 페이지)</p><p>$from_record = ($page - 1) * $rows; // 시작 열을 구함</p><p> </p><p>$query2 = " select * from ".$sql." LIMIT {$from_record}, {$rows}";</p><p> </p><p>$result2 = @mysqli_query($link, $query2);</p><p> </p><p>for ($ii=0; $row2 = sql_fetch_array($result2); $ii++) {</p><p><span class="Apple-tab-span" style="white-space:pre">	</span>$list[$ii] = get_article($row2, $board, $latest_skin_url, $subject_len);</p><p><span class="Apple-tab-span" style="white-space:pre">	</span>$tmp_write_table = $g5['write_prefix'].$row2['bo_table'];</p><p> </p><p><span class="Apple-tab-span" style="white-space:pre">	</span>if ($row2['wr_id'] == $row2['wr_parent']) {</p><p> </p><p>        // 원글</p><p>        $comment = "";</p><p>        $comment_link = "";</p><p>        $row3 = sql_fetch(" select * from {$tmp_write_table} where wr_id = '{$row2['wr_id']}' ");</p><p>        $list[$ii] = $row3;</p><p> </p><p>        $name = get_sideview($row3['mb_id'], get_text(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 == G5_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>        // 코멘트</p><p>        $comment = '<span>[댓글]</span>';</p><p>        $comment_link = '#c_'.$row2['wr_id'];</p><p>        $row3 = sql_fetch(" select * from {$tmp_write_table} where wr_id = '{$row2['wr_parent']}' ");</p><p>        $row4 = sql_fetch(" select mb_id, wr_name, wr_email, wr_homepage, wr_datetime from {$tmp_write_table} where wr_id = '{$row2['wr_id']}' ");</p><p>        $list[$ii] = $row3;</p><p>        $list[$ii]['wr_id'] = $row2['wr_id'];</p><p>        $list[$ii]['mb_id'] = $row4['mb_id'];</p><p>        $list[$ii]['wr_name'] = $row4['wr_name'];</p><p>        $list[$ii]['wr_email'] = $row4['wr_email'];</p><p>        $list[$ii]['wr_homepage'] = $row4['wr_homepage'];</p><p> </p><p>        $name = get_sideview($row4['mb_id'], get_text(cut_str($row4['wr_name'], $config['cf_cut_name'])), $row4['wr_email'], $row4['wr_homepage']);</p><p>        // 당일인 경우 시간으로 표시함</p><p>        $datetime = substr($row4['wr_datetime'],0,10);</p><p>        $datetime2 = $row4['wr_datetime'];</p><p>        if ($datetime == G5_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>    }</p><p> </p><p>    $list[$ii]['gr_id'] = $row2['gr_id'];</p><p>    $list[$ii]['bo_table'] = $row2['bo_table'];</p><p>    $list[$ii]['name'] = $name;</p><p>    $list[$ii]['comment'] = $comment;</p><p>    $list[$ii]['href'] = './board.php?bo_table='.$row2['bo_table'].'&amp;wr_id='.$row3['wr_id'].$comment_link;</p><p>    $list[$ii]['datetime'] = $datetime;</p><p>    $list[$ii]['datetime2'] = $datetime2;</p><p> </p><p>    $list[$ii]['gr_subject'] = $row2['gr_subject'];</p><p>    $list[$ii]['bo_subject'] = ((G5_IS_MOBILE && $row2['bo_mobile_subject']) ? $row2['bo_mobile_subject'] : $row2['bo_subject']);</p><p>    $list[$ii]['wr_subject'] = $row3['wr_subject'];</p><p>}</p><p> </p><p>$write_pages = get_paging(G5_IS_MOBILE ? $config['cf_mobile_pages'] : $config['cf_write_pages'], $page, $total_page, "?gr_id=$gr_id&amp;view=$view&amp;mb_id=$mb_id&amp;page=");</p><p> </p><p>include_once($new_skin_path.'/article_member.skin.php');</p><p> </p><p>include_once('./_tail.php');</p><p>?></p><p>