게시판 관리 > 그누3 팁자료실

게시판 관리 정보

일반 게시판 관리

황토현 자기소개 아이디로 검색 회원게시물 (211.♡.♡.163)
2005.01.18 18:30:02
4,391

본문

게시판 수가 얼마 안될 때는 별 문제가 없었는데 게시판 수가 늘다 보니 필요하게 되서 적용해 보았습니다.
스샷을 보시면 아시겠지만 스샷1은 게시판에서 보여줄 글 목록수 별로 정렬시킨 것이고
스샷2는 해당 게시판의 총 게시물 수를 많은 수로 정렬한 것입니다.
게시물이 없는 게시판들을 정리할때 쉽게 정리 할 수 있겠지요.
중복이거나 다 아는 사실이라면 죄송하구요.

수정한 파일은 gnu/bbs/admin/boardlist.php 파일입니다.

가장 최근의 그누보드 파일을 기준으로 74라인 부터입니다.

// 수정전 시작

<table width=100% cellpadding=3 cellspacing=1>
<colgroup width=40>
<colgroup width=70>
<colgroup width=''>
<colgroup width=80>
<colgroup width=100>
<colgroup width=12>
<colgroup width=12>
<colgroup width=12>
<colgroup width=12>
<colgroup width=12>
<colgroup width=12>
<colgroup width=12>
<colgroup width=12>
<colgroup width=12>
<colgroup width=12>
<colgroup width=12>
<colgroup width=12>
<colgroup width=12>
<colgroup width=12>
<colgroup width=12>
<colgroup width=12>
<colgroup width=12>
<colgroup width=20>
<colgroup width=55>
<tr align=center class=th>
<td><?=subject_sort_link('gr_id')?>그룹ID</a></td>
<td><?=subject_sort_link('bo_table')?>TABLE</a></td>
<td><?=subject_sort_link('bo_subject')?>제목</a></td>
<td><?=subject_sort_link('bo_admin')?>게시판관리자</a></td>
<td><?=subject_sort_link('bo_skin')?>스킨폴더</a></td>
<td title='목록읽기권한'><?=subject_sort_link('bo_list_level')?>목</a></td>
<td title='글읽기권한'><?=subject_sort_link('bo_read_level')?>읽</a></td>
<td title='글쓰기권한'><?=subject_sort_link('bo_write_level')?>쓰</a></td>
<td title='답변글쓰기권한'><?=subject_sort_link('bo_reply_level')?>답</a></td>
<td title='코멘트쓰기권한'><?=subject_sort_link('bo_comment_level')?>코</a></td>
<td title='업로드권한'><?=subject_sort_link('bo_upload_level')?>업</a></td>
<td title='다운로드권한'><?=subject_sort_link('bo_download_level')?>다</a></td>
<td title='공지사항쓰기권한'><?=subject_sort_link('bo_notice_level')?>공</a></td>
<td title='HTML쓰기권한'><?=subject_sort_link('bo_html_level')?>H</a></td>
<td title='링크쓰기권한'><?=subject_sort_link('bo_link_level')?>링</a></td>
<td title='카테고리사용'><?=subject_sort_link('bo_use_category')?>카</a></td>
<td title='비밀글사용'><?=subject_sort_link('bo_use_secret')?>비</a></td>
<td title='추천사용'><?=subject_sort_link('bo_use_good')?>추</a></td>
<td title='비추천사용'><?=subject_sort_link('bo_use_nogood')?>비</a></td>
<td title='서명보이기사용'><?=subject_sort_link('bo_use_signature')?>서</a></td>
<td title='전체목록보이기사용'><?=subject_sort_link('bo_use_listview')?>전</a></td>
<td title='검색사용'><?=subject_sort_link('bo_use_search')?>검</a></td>
<td title='검색순서'><?=subject_sort_link('bo_order_search')?>순</a></td>
<td><input type=image src='bbs/admin/image/btn_make.gif' align=absmiddle onclick="location='<?="./?doc=bbs/admin/boardgroupselect.php"?>';"></td>
</tr>
</table>
<table width=100% cellpadding=3 cellspacing=1>
<?
for ($i=0; $row=mysql_fetch_array($result); $i++) {
$s_upd = "<a href='./?doc=bbs/admin/boardform.php&$qstr&w=u&bo_table=$row[bo_table]'><img src='bbs/admin/image/icon_edit.gif' border=0 alt='수정'></a>";
$s_del = "";
if ($is_admin == 'default') {
$s_del = "<a href=\"javascript:del('./?doc=bbs/admin/boarddelete.php&$qstr&bo_table=$row[bo_table]');\"><img src='bbs/admin/image/icon_del.gif' border=0 alt='삭제'></a>";
}

$list = $i%2;
echo "
<tr class='ht list$list' align=center>
<td width=40>$row[gr_id]</td>
<td width=70><a href='./?doc=bbs/gnuboard.php&bo_table=$row[bo_table]' class=tt>$row[bo_table]</a></td>
<td width='' style='word-break:break-all;'>$row[bo_subject]</td>
<td width=80>$row[bo_admin]</td>
<td width=100>$row[bo_skin]</td>
<td width=12>$row[bo_list_level]</td>
<td width=12>$row[bo_read_level]</td>
<td width=12>$row[bo_write_level]</td>
<td width=12>$row[bo_reply_level]</td>
<td width=12>$row[bo_comment_level]</td>
<td width=12>$row[bo_upload_level]</td>
<td width=12>$row[bo_download_level]</td>
<td width=12>$row[bo_notice_level]</td>
<td width=12>$row[bo_html_level]</td>
<td width=12>$row[bo_link_level]</td>
<td width=12>".get_yn($row[bo_use_category], 1)."</td>
<td width=12>".get_yn($row[bo_use_secret], 1)."</td>
<td width=12>".get_yn($row[bo_use_good], 1)."</td>
<td width=12>".get_yn($row[bo_use_nogood], 1)."</td>
<td width=12>".get_yn($row[bo_use_signature], 1)."</td>
<td width=12>".get_yn($row[bo_use_listview], 1)."</td>
<td width=12>".get_yn($row[bo_use_search], 1)."</td>
<td width=20>$row[bo_order_search]</td>
<td width=55>$s_upd  $s_del</td>
</tr>";

// 수정전 끝

//수정후 시작

<table width=100% cellpadding=3 cellspacing=1>
<colgroup width=40>
<colgroup width=70>
<colgroup width=60>
<colgroup width=40>
<colgroup width=40>
<colgroup width=12>
<colgroup width=12>
<colgroup width=12>
<colgroup width=12>
<colgroup width=12>
<colgroup width=12>
<colgroup width=12>
<colgroup width=12>
<colgroup width=12>
<colgroup width=12>
<colgroup width=12>
<colgroup width=12>
<colgroup width=12>
<colgroup width=12>
<colgroup width=12>
<colgroup width=12>
<colgroup width=12>
<colgroup width=12>
<colgroup width=20>
<colgroup width=20>
<colgroup width=45>
<tr align=center class=th>
<td><?=subject_sort_link('gr_id')?>그룹ID</a></td>
<td><?=subject_sort_link('bo_table')?>TABLE</a></td>
<td><?=subject_sort_link('bo_subject')?>제목</a></td>
<td><?=subject_sort_link('bo_admin')?>게시판관리자</a></td>
<td><?=subject_sort_link('bo_skin')?>스킨폴더</a></td>
<td title='목록읽기권한'><?=subject_sort_link('bo_list_level')?>목</a></td>
<td title='글읽기권한'><?=subject_sort_link('bo_read_level')?>읽</a></td>
<td title='글쓰기권한'><?=subject_sort_link('bo_write_level')?>쓰</a></td>
<td title='답변글쓰기권한'><?=subject_sort_link('bo_reply_level')?>답</a></td>
<td title='코멘트쓰기권한'><?=subject_sort_link('bo_comment_level')?>코</a></td>
<td title='업로드권한'><?=subject_sort_link('bo_upload_level')?>업</a></td>
<td title='다운로드권한'><?=subject_sort_link('bo_download_level')?>다</a></td>
<td title='공지사항쓰기권한'><?=subject_sort_link('bo_notice_level')?>공</a></td>
<td title='HTML쓰기권한'><?=subject_sort_link('bo_html_level')?>H</a></td>
<td title='링크쓰기권한'><?=subject_sort_link('bo_link_level')?>링</a></td>
<td title='카테고리사용'><?=subject_sort_link('bo_use_category')?>카</a></td>
<td title='비밀글사용'><?=subject_sort_link('bo_use_secret')?>비</a></td>
<td title='추천사용'><?=subject_sort_link('bo_use_good')?>추</a></td>
<td title='비추천사용'><?=subject_sort_link('bo_use_nogood')?>비</a></td>
<td title='서명보이기사용'><?=subject_sort_link('bo_use_signature')?>서</a></td>
<td title='전체목록보이기사용'><?=subject_sort_link('bo_use_listview')?>전</a></td>
<td title='검색사용'><?=subject_sort_link('bo_use_search')?>검</a></td>
<td title='검색순서'><?=subject_sort_link('bo_order_search')?>순</a></td>
<td title='목록수'><?=subject_sort_link('bo_page_rows')?>수</a></td>
<td title='게시물수'><?=subject_sort_link('bo_total_count')?>게</a></td>

<td><input type=image src='bbs/admin/image/btn_make.gif' align=absmiddle onclick="location='<?="./?doc=bbs/admin/boardgroupselect.php"?>';"></td>
</tr>
</table>
<table width=100% cellpadding=3 cellspacing=1>
<?
for ($i=0; $row=mysql_fetch_array($result); $i++) {
$s_upd = "<a href='./?doc=bbs/admin/boardform.php&$qstr&w=u&bo_table=$row[bo_table]'><img src='bbs/admin/image/icon_edit.gif' border=0 alt='수정'></a>";
$s_del = "";
if ($is_admin == 'default') {
$s_del = "<a href=\"javascript:del('./?doc=bbs/admin/boarddelete.php&$qstr&bo_table=$row[bo_table]');\"><img src='bbs/admin/image/icon_del.gif' border=0 alt='삭제'></a>";
}

$list = $i%2;
echo "
<tr class='ht list$list' align=center>
<td>$row[gr_id]</td>
<td><a href='./?doc=bbs/gnuboard.php&bo_table=$row[bo_table]' class=tt>$row[bo_table]</a></td>
<td style='word-break:break-all;'>$row[bo_subject]</td>
<td>$row[bo_admin]</td>
<td>$row[bo_skin]</td>
<td>$row[bo_list_level]</td>
<td>$row[bo_read_level]</td>
<td>$row[bo_write_level]</td>
<td>$row[bo_reply_level]</td>
<td>$row[bo_comment_level]</td>
<td>$row[bo_upload_level]</td>
<td>$row[bo_download_level]</td>
<td>$row[bo_notice_level]</td>
<td>$row[bo_html_level]</td>
<td>$row[bo_link_level]</td>
<td>".get_yn($row[bo_use_category], 1)."</td>
<td>".get_yn($row[bo_use_secret], 1)."</td>
<td>".get_yn($row[bo_use_good], 1)."</td>
<td>".get_yn($row[bo_use_nogood], 1)."</td>
<td>".get_yn($row[bo_use_signature], 1)."</td>
<td>".get_yn($row[bo_use_listview], 1)."</td>
<td>".get_yn($row[bo_use_search], 1)."</td>
<td>$row[bo_order_search]</td>
<td>$row[bo_page_rows]</td>
<td>$row[bo_total_count]</td>
<td>$s_upd  $s_del</td>
</tr>";

// 수정후 끝

댓글 전체

이정재 홈페이지 자기소개 아이디로 검색 회원게시물

홈페이지 자기소개 아이디로 검색 회원게시물

(61.♡.♡.124) 05.03.01 15:26:16

와우

그누3 팁자료실

본문

공유하기

댓글 전체