게시판펼 포인트 설정현황 뽑아보기 정보
게시판펼 포인트 설정현황 뽑아보기
관련링크
본문
관리자 화면에서 추출;;;
<?
include_once("./_common.php");
$g4[title] = "게시판별 포인트 현황";
include_once("./_head.php");
if (!$member[mb_id]) {
$msg = "비회원은 접근할 권한이 없습니다.\\n\\n회원이시라면 로그인 후 이용해 보십시오.";
if ($cwin)
alert_close($msg);
else
alert($msg, "./login.php?wr_id=$wr_id{$qstr}&url=".urlencode("./"));
}
$sql_common = " from $g4[board_table] a ";
$sql_search = " where (1) ";
if ($is_admin != "super") {
$sql_common .= " , $g4[group_table] b ";
$sql_search .= " and (a.gr_id = b.gr_id and b.gr_admin = '$member[mb_id]') ";
}
if ($stx) {
$sql_search .= " and ( ";
switch ($sfl) {
case "bo_table" :
$sql_search .= " ($sfl like '$stx%') ";
break;
case "a.gr_id" :
$sql_search .= " ($sfl = '$stx') ";
break;
default :
$sql_search .= " ($sfl like '%$stx%') ";
break;
}
$sql_search .= " ) ";
}
if (!$sst) {
$sst = "a.gr_id, a.bo_table";
$sod = "asc";
}
$sql_order = " order by $sst $sod ";
$sql = " select count(*) as cnt
$sql_common
$sql_search
$sql_order ";
$row = sql_fetch($sql);
$total_count = $row[cnt];
$rows = $config[cf_page_rows];
$total_page = ceil($total_count / $rows); // 전체 페이지 계산
if ($page == "") { $page = 1; } // 페이지가 없으면 첫 페이지 (1 페이지)
$from_record = ($page - 1) * $rows; // 시작 열을 구함
$sql = " select *
$sql_common
$sql_search
$sql_order ";
$result = sql_query($sql);
$listall = "<a href='$_SERVER[PHP_SELF]'>처음</a>";
$colspan = 5;
$bs=subject_sort_link("bo_subject");
$rs=subject_sort_link("bo_read_point");
$ws=subject_sort_link("bo_write_point");
$cs=subject_sort_link("bo_comment_point");
$ds=subject_sort_link("bo_download_point");
?>
<table width=100% cellpadding=5 cellspacing=1 bgcolor="#cccccc">
<tr><td colspan='<?=$colspan?>' class='line1'></td></tr>
<tr class='bgcol1 bold col1 ht center' bgcolor="#f5f5f5">
<td style='font-size:12px;font-weight:bold;text-align:justify'><?=$bs?>제목</a></td>
<td title="글읽기 포인트" style='color:#ff00dd;font-size:12px;font-weight:bold;text-align:justify'><?=$rs?>읽기포인트</a></td>
<td title="글쓰기 포인트" style='color:#ff00dd;font-size:12px;font-weight:bold;text-align:justify'><?=$ws?>쓰기포인트</a></td>
<td title="코멘트쓰기 포인트" style='color:#ff00dd;font-size:12px;font-weight:bold;text-align:justify'><?=$cs?>코멘트포인트</a></td>
<td title="다운로드 포인트" style='color:#ff00dd;font-size:12px;font-weight:bold;text-align:justify'><?=$ds?>다운포인트</a></td>
</tr>
<tr><td colspan='<?=$colspan?>' class='line2'></td></tr>
<?
for ($i=0; $row=sql_fetch_array($result); $i++) {
$r_point=number_format($row[bo_read_point]);
$w_point=number_format($row[bo_write_point]);
$c_point=number_format($row[bo_comment_point]);
$d_point=number_format($row[bo_download_point]);
$list = $i % 2;
echo "<tr class='list$list col1 ht center' bgcolor='#ffffff'>";
echo "<td align=left height=25 style='font-size:12px;font-weight:bold;text-align:justify'><img src=http://phil114.com/img/board_top_list_icon.gif> [$row[bo_subject]]</td>";
echo "<td title='읽기 포인트' style='font-size:12px;font-weight:bold;text-align:justify'>$r_point</td>";
echo "<td title='쓰기 포인트' style='font-size:12px;font-weight:bold;text-align:justify'>$w_point</td>";
echo "<td title='속글쓰기 포인트' style='font-size:12px;font-weight:bold;text-align:justify'>$c_point</td>";
echo "<td title='다운로드 포인트' style='font-size:12px;font-weight:bold;text-align:justify'>$d_point</td>";
echo "</tr>";
if($i>9&&$i%10==0){
echo"<tr class='bgcol1 bold col1 ht center' bgcolor='#f5f5f5'>";
echo"<td style='color:#ff00dd;font-size:12px;font-weight:bold;text-align:justify'>";
echo $bs ;
echo"제목</a></td>";
echo"<td title='글읽기 포인트'style='color:#ff00dd;font-size:12px;font-weight:bold;text-align:justify'>";
echo $rs;
echo"읽기포인트</a></td>";
echo"<td title='글쓰기 포인트' style='color:#ff00dd;font-size:12px;font-weight:bold;text-align:justify'>";
echo"$ws ";
echo"쓰기포인트</a></td>";
echo"<td title='코멘트쓰기 포인트' style='color:#ff00dd;font-size:12px;font-weight:bold;text-align:justify'>";
echo"$cs ";
echo"코멘트포인트</a></td>";
echo"<td title='다운로드 포인트' style='color:#ff00dd;font-size:12px;font-weight:bold;text-align:justify'>";
echo"$ds ";
echo"다운포인트</a></td>";
echo"</tr>";
}
}
echo "<tr><td colspan='$colspan' class='line2'></td></tr>";
echo "</table>";
include_once("./_tail.php");
?>
1
댓글 6개
각 게시판정보에 링크를 할 수 없을까요? 확인하고 게시판정보로 다시 들어가야 해서....
넘 편하겠네요..감사합니다.
