글등록현황 그래프 나타내기에서 코멘트 수 질문드립니다. 정보
글등록현황 그래프 나타내기에서 코멘트 수 질문드립니다.
본문
제로보드 사용하다 그누보드로 바꿀려고 홈페이지 꾸미고 있는 회원입니다..
다름이 아니라 까만도둑 님의 글등록현황 그래프로 폼나게보자 V2 (http://sir.co.kr/bbs/board.php?bo_table=g4_tiptech&wr_id=9&sca=&sfl=mb_id%2C1&stx=conquer&page=2)팁을 적용하려고 합니다.
소스는 아래와 같습니다.
아시는 분 답변 부탁드리겠습니다.
<?
$g4_path = "..";
include_once ("$g4_path/common.php");
include_once("$g4[path]/head.sub.php");
include_once("$g4[path]/_head2.php");
$g4_path = "..";
include_once ("$g4_path/common.php");
include_once("$g4[path]/head.sub.php");
include_once("$g4[path]/_head2.php");
$g4[title] = "$member[mb_name] 게시물등록 현황";
//$main_width = "98%";
?>
?>
<title><?=$g4[title]?> 게시물등록 현황</title>
<br>
<table width=100% align=center cellpadding=0 cellspacing=0 border=0 style="table-layout:fixed">
<tr>
<td>
<tr>
<td>
<?
//echo $user_id;
//echo $user_num;
// 그룹정보읽기
$dbqry="select from $g4[group_table] order by gr_id";
$dbqry="select from $g4[group_table] order by gr_id";
$rs=mysql_query($dbqry);
while($row=sql_fetch_array($rs)) {
$group_list[$row[gr_id]]=$row;
}
$gr_name='';
// 게시판 목록을 읽어서 메뉴로 만들어 버린다.
$dbqry="
SELECT * FROM $g4[board_table]
where bo_table<>'notice' and bo_table<>'qa' and bo_table<>'tion' and bo_table<>'pho' and bo_table<>'fdddfdbd' and bo_table<>'tretrgooin' and gr_id<>'etc' and gr_id<>'gr_11' and gr_id<>'gr_12' and gr_id<>'gr_03' and gr_id<>'gr_04' and gr_id<>'gr_05' and gr_id<>'gr_06' and gr_id<>'gr_07' and gr_id<>'gr_08' and gr_id<>'gr_09'
/*제외하고픈 게시판 테이블명 및 그룹명 설정 ORDER BY gr_id, bo_table, bo_subject */
ORDER BY gr_id, bo_table, bo_subject
";
$my_post_rs=sql_query($dbqry);
$total_board = mysql_num_rows($my_post_rs);
?>
<!-- 전체게시물 목록보이기 -->
<table width=100% cellpadding=0 cellspacing=0 border=0 style="table-layout:fixed">
<col width=></col><col width=70></col><col width=70></col><col width=70></col><col width=70></col><col width=70></col><col width=70></col><col width=30></col>
<tr><td height=30><font style='font-family:Verdana;font-size:12px;padding:4 0 4 10;color:ffffff;font-weight:bold;'>My Status - <font color="FFE311"><? if(!$member[mb_id]) { echo "비회원"; } ?><?=$member[mb_nick]?></font></font></td>
</tr>
<tr><td height="1" colspan="8" bgcolor="#48516D"></td></tr>
<tr><td height="1" colspan="8" bgcolor="#2A3143"></td></tr>
<tr bgColor=2a3143>
<td height="25" align="center" style='font-size:10px;color:ffffff;'>board</td>
<td height="25" align="center" style='font-size:10px;color:ffffff;'>total post</td>
<td height="25" align="center" style='font-size:10px;color:ffffff;'>my post</td>
<td height="25" align="center" style='font-size:10px;color:ffffff;'>%</td>
<td height="25" align="center" style='font-size:10px;color:ffffff;'>total reply</td>
<td height="25" align="center" style='font-size:10px;color:ffffff;'>total reply</td>
<td height="25" align="center" style='font-size:10px;color:ffffff;'>%</td>
<td height="25" align="center"></td>
</tr>
<tr><td height="1" colspan="8" bgcolor="#48516D"></td></tr>
<tr><td height="1" colspan="8" bgcolor="#2A3143"></td></tr>
$group_list[$row[gr_id]]=$row;
}
$gr_name='';
// 게시판 목록을 읽어서 메뉴로 만들어 버린다.
$dbqry="
SELECT * FROM $g4[board_table]
where bo_table<>'notice' and bo_table<>'qa' and bo_table<>'tion' and bo_table<>'pho' and bo_table<>'fdddfdbd' and bo_table<>'tretrgooin' and gr_id<>'etc' and gr_id<>'gr_11' and gr_id<>'gr_12' and gr_id<>'gr_03' and gr_id<>'gr_04' and gr_id<>'gr_05' and gr_id<>'gr_06' and gr_id<>'gr_07' and gr_id<>'gr_08' and gr_id<>'gr_09'
/*제외하고픈 게시판 테이블명 및 그룹명 설정 ORDER BY gr_id, bo_table, bo_subject */
ORDER BY gr_id, bo_table, bo_subject
";
$my_post_rs=sql_query($dbqry);
$total_board = mysql_num_rows($my_post_rs);
?>
<!-- 전체게시물 목록보이기 -->
<table width=100% cellpadding=0 cellspacing=0 border=0 style="table-layout:fixed">
<col width=></col><col width=70></col><col width=70></col><col width=70></col><col width=70></col><col width=70></col><col width=70></col><col width=30></col>
<tr><td height=30><font style='font-family:Verdana;font-size:12px;padding:4 0 4 10;color:ffffff;font-weight:bold;'>My Status - <font color="FFE311"><? if(!$member[mb_id]) { echo "비회원"; } ?><?=$member[mb_nick]?></font></font></td>
</tr>
<tr><td height="1" colspan="8" bgcolor="#48516D"></td></tr>
<tr><td height="1" colspan="8" bgcolor="#2A3143"></td></tr>
<tr bgColor=2a3143>
<td height="25" align="center" style='font-size:10px;color:ffffff;'>board</td>
<td height="25" align="center" style='font-size:10px;color:ffffff;'>total post</td>
<td height="25" align="center" style='font-size:10px;color:ffffff;'>my post</td>
<td height="25" align="center" style='font-size:10px;color:ffffff;'>%</td>
<td height="25" align="center" style='font-size:10px;color:ffffff;'>total reply</td>
<td height="25" align="center" style='font-size:10px;color:ffffff;'>total reply</td>
<td height="25" align="center" style='font-size:10px;color:ffffff;'>%</td>
<td height="25" align="center"></td>
</tr>
<tr><td height="1" colspan="8" bgcolor="#48516D"></td></tr>
<tr><td height="1" colspan="8" bgcolor="#2A3143"></td></tr>
<?
$all_my_post = 0;
$all_my_cmt = 0;
$all_my_post = 0;
$all_my_cmt = 0;
while($row=sql_fetch_array($my_post_rs)) {
$gul_su_qry="select * from g4_write_$row[bo_table] where wr_comment > '-1'";
$my_post_qry="select * from g4_write_$row[bo_table] where wr_comment > '-1' and mb_id = '$member[mb_id]'";
/*
$gul_su_qry="select * from $g4[write_table] where wr_comment = '0'";
$my_post_qry="select * from $g4[write_table] where wr_comment = '0' and mb_id = '$member[mb_id]'";
*/
$gul=sql_query($gul_su_qry);
$total_gul = mysql_num_rows($gul);
$my_all_gul = $my_all_gul+$total_gul;
$gul_su_qry="select * from g4_write_$row[bo_table] where wr_comment > '-1'";
$my_post_qry="select * from g4_write_$row[bo_table] where wr_comment > '-1' and mb_id = '$member[mb_id]'";
/*
$gul_su_qry="select * from $g4[write_table] where wr_comment = '0'";
$my_post_qry="select * from $g4[write_table] where wr_comment = '0' and mb_id = '$member[mb_id]'";
*/
$gul=sql_query($gul_su_qry);
$total_gul = mysql_num_rows($gul);
$my_all_gul = $my_all_gul+$total_gul;
$my_post=sql_query($my_post_qry);
$my_post = mysql_num_rows($my_post);
$all_my_post = $all_my_post+$my_post;
$my_post = mysql_num_rows($my_post);
$all_my_post = $all_my_post+$my_post;
//$my_post_per = ( $my_post / $total_gul )*100;
if ($my_post) {$my_post_per = ( $my_post / $total_gul )*100; }
$my_post_per = intval($my_post_per);
//$tot_my_post_per = ( $all_my_post / $my_all_gul )*100;
if ($all_my_post) {$tot_my_post_per = ( $all_my_post / $my_all_gul )*100;}
$tot_my_post_per = intval($tot_my_post_per);
if ($my_post) {$my_post_per = ( $my_post / $total_gul )*100; }
$my_post_per = intval($my_post_per);
//$tot_my_post_per = ( $all_my_post / $my_all_gul )*100;
if ($all_my_post) {$tot_my_post_per = ( $all_my_post / $my_all_gul )*100;}
$tot_my_post_per = intval($tot_my_post_per);
$cmt_su_qry="select * from g4_write_$row[bo_table]";
$my_cmt_qry="select * from g4_write_$row[bo_table] where wr_comment < '0' and mb_id = '$member[mb_id]'";
$my_cmt_qry="select * from g4_write_$row[bo_table] where wr_comment < '0' and mb_id = '$member[mb_id]'";
$cmt=sql_query($cmt_su_qry);
$total_cmt = mysql_num_rows($cmt) - mysql_num_rows($gul); //게시판코멘트수
$my_all_cmt = $my_all_cmt+$total_cmt; //내가쓴게시판코멘트수
$total_cmt = mysql_num_rows($cmt) - mysql_num_rows($gul); //게시판코멘트수
$my_all_cmt = $my_all_cmt+$total_cmt; //내가쓴게시판코멘트수
$my_cmt=sql_query($my_cmt_qry);
$my_cmt = mysql_num_rows($my_cmt); //전체게시판코멘트수
$all_my_cmt = $all_my_cmt+$my_cmt; //내가쓴전체게시판코멘트수
$my_cmt = mysql_num_rows($my_cmt); //전체게시판코멘트수
$all_my_cmt = $all_my_cmt+$my_cmt; //내가쓴전체게시판코멘트수
//echo $total_cmt." : ".$my_all_cmt." : ".$my_cmt." : ".$all_my_cmt." : ";
@$my_cmt_per = ( $my_cmt / $total_cmt )*100;
$my_cmt_per = intval($my_cmt_per);
@$tot_my_cmt_per = ( $all_my_cmt / $my_all_cmt )*100;
$tot_my_cmt_per = intval($tot_my_cmt_per);
?>
<!-- 전체게시물 목록보이기 -->
<tr>
<td height="25" style='font-size:12px;' align='center'><a href='../<?=$g4[bbs]?>/board.php?bo_table=<?=$row[bo_table]?>' onfocus=this.blur();><?=$row[bo_subject]?></a></td>
<td height="25" style='font-size:12px;' align='center'><font style='font-size:11px;color:ff6600;font-weight:bold;'><?=$total_gul?></font></td>
<td height="25" style='font-size:12px;' align='center'><font style='font-size:11px;color:ff6600;font-weight:bold;'><?=$my_post?></font></td>
<td height="25" style='font-size:12px;' align='center'><font style='font-size:11px;color:ff6600;font-weight:bold;'><?=$my_post_per?>%</font></td>
<td height="25" style='font-size:12px;' align='center'><font style='font-size:11px;color:ff6600;font-weight:bold;'><?=$total_cmt?></font></td>
<td height="25" style='font-size:12px;' align='center'><font style='font-size:11px;color:ff6600;font-weight:bold;'><?=$my_cmt?></font></td>
<td height="25" style='font-size:12px;' align='center'><font style='font-size:11px;color:ff6600;font-weight:bold;'><?=$my_cmt_per?>%</font></td>
<td height="25" align="center"></td>
</tr>
<tr><td height="1" colspan="8" bgcolor="#48516D"></td></tr>
<!-- 전체게시물 목록보이기 -->
<?
}
?>
<tr bgcolor=2a3143>
<td height="25" style='font-size:12px;font-weight;bold;' align='center'>전체현황</td>
<td height="25" style='font-size:12px;font-weight;bold;' align='center'><font style='font-size:12px;color:red;font-weight:bold;'><?=$my_all_gul?></font></td>
<td height="25" style='font-size:12px;font-weight;bold;' align='center'><font style='font-size:12px;color:red;font-weight:bold;'><?=$all_my_post?></font></td>
<td height="25" style='font-size:12px;font-weight;bold;' align='center'><font style='font-size:12px;color:red;font-weight:bold;'><?=$tot_my_post_per?>%</font></td>
<td height="25" style='font-size:12px;font-weight;bold;' align='center'><font style='font-size:12px;color:red;font-weight:bold;'><?=$my_all_cmt?></font></td>
<td height="25" style='font-size:12px;font-weight;bold;' align='center'><font style='font-size:12px;color:red;font-weight:bold;'><?=$all_my_cmt?></font></td>
<td height="25" style='font-size:12px;font-weight;bold;' align='center'><font style='font-size:12px;color:red;font-weight:bold;'><?=$tot_my_cmt_per?>%</font></td>
<td height="25" align="center"></td>
</tr>
<tr><td height="1" colspan="8" bgcolor="#48516D"></td></tr>
<tr><td height="1" colspan="8" bgcolor="#2A3143"></td></tr>
</table>
<tr>
<td height="25" style='font-size:12px;' align='center'><a href='../<?=$g4[bbs]?>/board.php?bo_table=<?=$row[bo_table]?>' onfocus=this.blur();><?=$row[bo_subject]?></a></td>
<td height="25" style='font-size:12px;' align='center'><font style='font-size:11px;color:ff6600;font-weight:bold;'><?=$total_gul?></font></td>
<td height="25" style='font-size:12px;' align='center'><font style='font-size:11px;color:ff6600;font-weight:bold;'><?=$my_post?></font></td>
<td height="25" style='font-size:12px;' align='center'><font style='font-size:11px;color:ff6600;font-weight:bold;'><?=$my_post_per?>%</font></td>
<td height="25" style='font-size:12px;' align='center'><font style='font-size:11px;color:ff6600;font-weight:bold;'><?=$total_cmt?></font></td>
<td height="25" style='font-size:12px;' align='center'><font style='font-size:11px;color:ff6600;font-weight:bold;'><?=$my_cmt?></font></td>
<td height="25" style='font-size:12px;' align='center'><font style='font-size:11px;color:ff6600;font-weight:bold;'><?=$my_cmt_per?>%</font></td>
<td height="25" align="center"></td>
</tr>
<tr><td height="1" colspan="8" bgcolor="#48516D"></td></tr>
<!-- 전체게시물 목록보이기 -->
<?
}
?>
<tr bgcolor=2a3143>
<td height="25" style='font-size:12px;font-weight;bold;' align='center'>전체현황</td>
<td height="25" style='font-size:12px;font-weight;bold;' align='center'><font style='font-size:12px;color:red;font-weight:bold;'><?=$my_all_gul?></font></td>
<td height="25" style='font-size:12px;font-weight;bold;' align='center'><font style='font-size:12px;color:red;font-weight:bold;'><?=$all_my_post?></font></td>
<td height="25" style='font-size:12px;font-weight;bold;' align='center'><font style='font-size:12px;color:red;font-weight:bold;'><?=$tot_my_post_per?>%</font></td>
<td height="25" style='font-size:12px;font-weight;bold;' align='center'><font style='font-size:12px;color:red;font-weight:bold;'><?=$my_all_cmt?></font></td>
<td height="25" style='font-size:12px;font-weight;bold;' align='center'><font style='font-size:12px;color:red;font-weight:bold;'><?=$all_my_cmt?></font></td>
<td height="25" style='font-size:12px;font-weight;bold;' align='center'><font style='font-size:12px;color:red;font-weight:bold;'><?=$tot_my_cmt_per?>%</font></td>
<td height="25" align="center"></td>
</tr>
<tr><td height="1" colspan="8" bgcolor="#48516D"></td></tr>
<tr><td height="1" colspan="8" bgcolor="#2A3143"></td></tr>
</table>
</td>
</tr>
</table>
</tr>
</table>
<br>
<?
include_once("$g4[path]/_tail2.php");
include_once("$g4[path]/tail.sub.php");
?>
<?
include_once("$g4[path]/_tail2.php");
include_once("$g4[path]/tail.sub.php");
?>
댓글 전체
답변이 늦었습니다.
해당 소스를 아래와 수정해 보세요.
97: $cmt_su_qry="select * from g4_write_$row[bo_table]";
=> $cmt_su_qry="select * from {$g4[write_prefix]}{$row[bo_table]} where wr_is_comment = '1'";
98: $my_cmt_qry="select * from g4_write_$row[bo_table] where wr_comment < '0' and mb_id = '$member[mb_id]'";
=> $my_cmt_qry="select * from {$g4[write_prefix]}{$row[bo_table]} where wr_is_comment = '1' and mb_id = '$member[mb_id]'";
103: $total_cmt = mysql_num_rows($cmt) - mysql_num_rows($gul); //게시판코멘트수
=> $total_cmt = mysql_num_rows($cmt); //게시판코멘트수
========================= 여기서 부터는 수정된 소스 전부 ============================
<?
$g4_path = "..";
include_once ("$g4_path/common.php");
$g4[title] = "$member[mb_name] 게시물등록 현황";
include_once("$g4[path]/head.php");
//$main_width = "98%";
?>
<title><?=$g4[title]?> 게시물등록 현황</title>
<br>
<table width=98% align=center cellpadding=0 cellspacing=0 border=0>
<tr>
<td>
<?
//echo $user_id;
//echo $user_num;
// 그룹정보읽기
$dbqry="select from $g4[group_table] order by gr_id";
$rs=mysql_query($dbqry);
while($row=sql_fetch_array($rs)) {
$group_list[$row[gr_id]]=$row;
}
$gr_name='';
// 게시판 목록을 읽어서 메뉴로 만들어 버린다.
$dbqry="
SELECT * FROM $g4[board_table]
where bo_table<>'chumo' and bo_table<>'test' and bo_table<>'work' and bo_table<>'pds' and bo_table<>'taste' and bo_table<>'mypage' and bo_table<>'ggggbada' and bo_table<>'fdddfdbd' and bo_table<>'tretrgooin' and gr_id<>'etc' and gr_id<>'gr_11' and gr_id<>'gr_12' and gr_id<>'gr_03' and gr_id<>'gr_04' and gr_id<>'gr_05' and gr_id<>'gr_06' and gr_id<>'gr_07' and gr_id<>'gr_08' and gr_id<>'gr_09'
/*제외하고픈 게시판 테이블명 및 그룹명 설정 ORDER BY gr_id, bo_table, bo_subject */
ORDER BY gr_id, bo_table, bo_subject
";
$my_post_rs=sql_query($dbqry);
$total_board = mysql_num_rows($my_post_rs);
?>
<table width=100% cellpadding=0 cellspacing=0 border=0>
<tr>
<td bgcolor="FFFFFF">
<!-- 전체게시물 목록보이기 -->
<table width=100% cellpadding=0 cellspacing=0 border=0>
<tr bgColor=000000>
<!--
<td colspan="2" height=40 align="left" style='font-family:Verdana;font-size:12px;padding:4 0 4 10;color:ffffff;font-weight:bold;'>
My Status - <FONT COLOR="FFE311"><? if(!$member[mb_id]) { echo "비회원"; } ?><?=$member[mb_name]?></FONT>
</td>
<td colspan="3" align="center" style='font-family:Verdana;font-size:12px;padding:4 0 4 10;color:ffffff;font-weight:bold;'>
글등록 현황</td>
<td colspan="3" align="center" style='font-family:Verdana;font-size:12px;padding:4 0 4 10;color:ffffff;font-weight:bold;'>
코멘트 현황</td>
<td colspan="2" align="right" style='padding:4 8 4 4;color:ffffff;'>
<a href="javascript:self.close()" style="font-family:Verdana;font-size:12px;color:FFFFFF;font-weight:bold;">닫기</a>
</td>-->
<td colspan="1" height=40 align="left" style='font-family:Verdana;font-size:12px;padding:4 0 4 10;color:ffffff;font-weight:bold;'>
My Status - <FONT COLOR="FFE311"><? if(!$member[mb_id]) { echo "비회원"; } ?><?=$member[mb_name]?></FONT>
</td>
<td colspan="4" align="center" style='font-family:Verdana;font-size:12px;padding:4 0 4 10;color:ffffff;font-weight:bold;'>
글등록 현황</td>
<td colspan="4" align="center" style='font-family:Verdana;font-size:12px;padding:4 0 4 10;color:ffffff;font-weight:bold;'>
코멘트 현황</td>
</tr>
<?
$all_my_post = 0;
$all_my_cmt = 0;
while($row=sql_fetch_array($my_post_rs)) {
$gul_su_qry="select * from g4_write_$row[bo_table] where wr_comment > '-1'";
$my_post_qry="select * from g4_write_$row[bo_table] where wr_comment > '-1' and mb_id = '$member[mb_id]'";
/*
$gul_su_qry="select * from $g4[write_table] where wr_comment = '0'";
$my_post_qry="select * from $g4[write_table] where wr_comment = '0' and mb_id = '$member[mb_id]'";
*/
$gul=sql_query($gul_su_qry);
$total_gul = mysql_num_rows($gul);
$my_all_gul = $my_all_gul+$total_gul;
$my_post=sql_query($my_post_qry);
$my_post = mysql_num_rows($my_post);
$all_my_post = $all_my_post+$my_post;
//$my_post_per = ( $my_post / $total_gul )*100;
if ($my_post) {$my_post_per = ( $my_post / $total_gul )*100; }
$my_post_per = intval($my_post_per);
//$tot_my_post_per = ( $all_my_post / $my_all_gul )*100;
if ($all_my_post) {$tot_my_post_per = ( $all_my_post / $my_all_gul )*100;}
$tot_my_post_per = intval($tot_my_post_per);
// $cmt_su_qry="select * from g4_write_$row[bo_table]";
$cmt_su_qry="select * from {$g4[write_prefix]}{$row[bo_table]} where wr_is_comment = '1'";
// $my_cmt_qry="select * from g4_write_$row[bo_table] where wr_comment < '0' and mb_id = '$member[mb_id]'";
$my_cmt_qry="select * from {$g4[write_prefix]}{$row[bo_table]} where wr_is_comment = '1' and mb_id = '$member[mb_id]'";
$cmt=sql_query($cmt_su_qry);
// $total_cmt = mysql_num_rows($cmt) - mysql_num_rows($gul); //게시판코멘트수
$total_cmt = mysql_num_rows($cmt); //게시판코멘트수
$my_all_cmt = $my_all_cmt+$total_cmt; //내가쓴게시판코멘트수
$my_cmt=sql_query($my_cmt_qry);
$my_cmt = mysql_num_rows($my_cmt); //전체게시판코멘트수
$all_my_cmt = $all_my_cmt+$my_cmt; //내가쓴전체게시판코멘트수
//echo $total_cmt." : ".$my_all_cmt." : ".$my_cmt." : ".$all_my_cmt." : ";
@$my_cmt_per = ( $my_cmt / $total_cmt )*100;
$my_cmt_per = intval($my_cmt_per);
@$tot_my_cmt_per = ( $all_my_cmt / $my_all_cmt )*100;
$tot_my_cmt_per = intval($tot_my_cmt_per);
?>
<!-- 전체게시물 목록보이기 -->
<tr>
<td align=left bgColor="" style='padding:2 0 0 4;font-family:;font-size:12px;'>
<a href='../<?=$g4[bbs]?>/board.php?bo_table=<?=$row[bo_table]?>' onfocus=this.blur();><B><?=$row[bo_subject]?></B></a>
</td>
<td align="right" style='font-family:tahoma,Verdana;color:000000;font-size:10px;font-weight:bold;padding:0 4 0 0;'>
<?=$total_gul?>
</td>
<td align="right" style='font-family:tahoma,Verdana;color:EF5900;font-size:10px;font-weight:bold;padding:0 4 0 0;'>
<?=$my_post?> <span style='font-family:tahoma,Verdana;font-size:9px;color:999999;font-weight:bold;'>post</span><br>
</td>
<td align="right" style='font-family:tahoma,Verdana;color:000000;font-size:10px;font-weight:bold;'>
<?=$my_post_per?>%
</td>
<td align="right" style='font-family:Verdana;font-size:;color:;padding:4;'>
<img src="<?=$g4[path]?>/image/piegraph/<?=$my_post_per?>.png" align="middle">
</td>
<td align="right" style='font-family:tahoma,Verdana;color:000000;font-size:10px;font-weight:bold;padding:0 4 0 0;'>
<?=$total_cmt?>
</td>
<td align="right" style='font-family:tahoma,Verdana;color:EF5900;font-size:10px;font-weight:bold;padding:0 4 0 0;'>
<?=$my_cmt?> <span style='font-family:tahoma,Verdana;font-size:9px;color:999999;font-weight:bold;'>comment</span>
</td>
<td align="right" style='font-family:tahoma,Verdana;color:000000;font-size:10px;font-weight:bold;'>
<?=$my_cmt_per?>%
</td>
<td align="right" style='font-family:Verdana;font-size:;color:;padding:4;'>
<img src="<?=$g4[path]?>/image/piegraph/<?=$my_cmt_per?>.png" align="middle">
</td>
</tr>
<!-- 전체게시물 목록보이기 -->
<tr><td colspan="9" bgColor=E9E9E9 height=1></td></tr>
<?
}
?>
<tr><td colspan="9" height="1" bgcolor=666666></td></tr>
<tr>
<td align="left" style='font-family:Verdana;font-size:12px;padding:4 0 4 4;color:000000;font-weight:;'>
<b>전체현황</b>
</td>
<td align="left" style='font-family:Verdana;font-size:12px;padding:4 0 4 4;color:000000;font-weight:;'>
<B><?=$my_all_gul?></B>
</td>
<td align="right" style='font-family:tahoma,Verdana;font-size:12px;padding:0 4 0 0;color:EF5900;font-weight:bold;'>
<?=$all_my_post?> <span style='font-family:tahoma,Verdana;font-size:9px;color:999999;font-weight:bold;'>post</span>
</td>
<td align="right" style='font-family:tahoma,Verdana;font-size:12px;padding:4 0 4 4;color:000000;font-weight:bold;'>
<?=$tot_my_post_per?>%
</td>
<td align="right" style='font-family:Verdana;font-size:10px;color:ffffff;font-weight:bold;padding:4;'>
<img src="<?=$g4[path]?>/image/piegraph/<?=$tot_my_post_per?>.png">
</td>
<td align="right" style='font-family:tahoma,Verdana;font-size:12px;padding:0 4 0 0;color:000000;font-weight:bold;'>
<?=$my_all_cmt?>
</td>
<td align="right" style='font-family:tahoma,Verdana;font-size:12px;padding:0 4 0 0;color:EF5900;font-weight:bold;'>
<?=$all_my_cmt?> <span style='font-family:tahoma,Verdana;font-size:9px;color:999999;font-weight:bold;'>comment</span>
</td>
<td align="right" style='font-family:tahoma,Verdana;font-size:12px;padding:4 0 4 4;color:000000;font-weight:bold;'>
<?=$tot_my_cmt_per?>%
</td>
<td align="right" style='font-family:Verdana;font-size:10px;color:ffffff;font-weight:bold;padding:4;'>
<img src="<?=$g4[path]?>/image/piegraph/<?=$tot_my_cmt_per?>.png">
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<br>
<?
include_once("$g4[path]/tail.php");
?>
=============================================================================
해당 소스를 아래와 수정해 보세요.
97: $cmt_su_qry="select * from g4_write_$row[bo_table]";
=> $cmt_su_qry="select * from {$g4[write_prefix]}{$row[bo_table]} where wr_is_comment = '1'";
98: $my_cmt_qry="select * from g4_write_$row[bo_table] where wr_comment < '0' and mb_id = '$member[mb_id]'";
=> $my_cmt_qry="select * from {$g4[write_prefix]}{$row[bo_table]} where wr_is_comment = '1' and mb_id = '$member[mb_id]'";
103: $total_cmt = mysql_num_rows($cmt) - mysql_num_rows($gul); //게시판코멘트수
=> $total_cmt = mysql_num_rows($cmt); //게시판코멘트수
========================= 여기서 부터는 수정된 소스 전부 ============================
<?
$g4_path = "..";
include_once ("$g4_path/common.php");
$g4[title] = "$member[mb_name] 게시물등록 현황";
include_once("$g4[path]/head.php");
//$main_width = "98%";
?>
<title><?=$g4[title]?> 게시물등록 현황</title>
<br>
<table width=98% align=center cellpadding=0 cellspacing=0 border=0>
<tr>
<td>
<?
//echo $user_id;
//echo $user_num;
// 그룹정보읽기
$dbqry="select from $g4[group_table] order by gr_id";
$rs=mysql_query($dbqry);
while($row=sql_fetch_array($rs)) {
$group_list[$row[gr_id]]=$row;
}
$gr_name='';
// 게시판 목록을 읽어서 메뉴로 만들어 버린다.
$dbqry="
SELECT * FROM $g4[board_table]
where bo_table<>'chumo' and bo_table<>'test' and bo_table<>'work' and bo_table<>'pds' and bo_table<>'taste' and bo_table<>'mypage' and bo_table<>'ggggbada' and bo_table<>'fdddfdbd' and bo_table<>'tretrgooin' and gr_id<>'etc' and gr_id<>'gr_11' and gr_id<>'gr_12' and gr_id<>'gr_03' and gr_id<>'gr_04' and gr_id<>'gr_05' and gr_id<>'gr_06' and gr_id<>'gr_07' and gr_id<>'gr_08' and gr_id<>'gr_09'
/*제외하고픈 게시판 테이블명 및 그룹명 설정 ORDER BY gr_id, bo_table, bo_subject */
ORDER BY gr_id, bo_table, bo_subject
";
$my_post_rs=sql_query($dbqry);
$total_board = mysql_num_rows($my_post_rs);
?>
<table width=100% cellpadding=0 cellspacing=0 border=0>
<tr>
<td bgcolor="FFFFFF">
<!-- 전체게시물 목록보이기 -->
<table width=100% cellpadding=0 cellspacing=0 border=0>
<tr bgColor=000000>
<!--
<td colspan="2" height=40 align="left" style='font-family:Verdana;font-size:12px;padding:4 0 4 10;color:ffffff;font-weight:bold;'>
My Status - <FONT COLOR="FFE311"><? if(!$member[mb_id]) { echo "비회원"; } ?><?=$member[mb_name]?></FONT>
</td>
<td colspan="3" align="center" style='font-family:Verdana;font-size:12px;padding:4 0 4 10;color:ffffff;font-weight:bold;'>
글등록 현황</td>
<td colspan="3" align="center" style='font-family:Verdana;font-size:12px;padding:4 0 4 10;color:ffffff;font-weight:bold;'>
코멘트 현황</td>
<td colspan="2" align="right" style='padding:4 8 4 4;color:ffffff;'>
<a href="javascript:self.close()" style="font-family:Verdana;font-size:12px;color:FFFFFF;font-weight:bold;">닫기</a>
</td>-->
<td colspan="1" height=40 align="left" style='font-family:Verdana;font-size:12px;padding:4 0 4 10;color:ffffff;font-weight:bold;'>
My Status - <FONT COLOR="FFE311"><? if(!$member[mb_id]) { echo "비회원"; } ?><?=$member[mb_name]?></FONT>
</td>
<td colspan="4" align="center" style='font-family:Verdana;font-size:12px;padding:4 0 4 10;color:ffffff;font-weight:bold;'>
글등록 현황</td>
<td colspan="4" align="center" style='font-family:Verdana;font-size:12px;padding:4 0 4 10;color:ffffff;font-weight:bold;'>
코멘트 현황</td>
</tr>
<?
$all_my_post = 0;
$all_my_cmt = 0;
while($row=sql_fetch_array($my_post_rs)) {
$gul_su_qry="select * from g4_write_$row[bo_table] where wr_comment > '-1'";
$my_post_qry="select * from g4_write_$row[bo_table] where wr_comment > '-1' and mb_id = '$member[mb_id]'";
/*
$gul_su_qry="select * from $g4[write_table] where wr_comment = '0'";
$my_post_qry="select * from $g4[write_table] where wr_comment = '0' and mb_id = '$member[mb_id]'";
*/
$gul=sql_query($gul_su_qry);
$total_gul = mysql_num_rows($gul);
$my_all_gul = $my_all_gul+$total_gul;
$my_post=sql_query($my_post_qry);
$my_post = mysql_num_rows($my_post);
$all_my_post = $all_my_post+$my_post;
//$my_post_per = ( $my_post / $total_gul )*100;
if ($my_post) {$my_post_per = ( $my_post / $total_gul )*100; }
$my_post_per = intval($my_post_per);
//$tot_my_post_per = ( $all_my_post / $my_all_gul )*100;
if ($all_my_post) {$tot_my_post_per = ( $all_my_post / $my_all_gul )*100;}
$tot_my_post_per = intval($tot_my_post_per);
// $cmt_su_qry="select * from g4_write_$row[bo_table]";
$cmt_su_qry="select * from {$g4[write_prefix]}{$row[bo_table]} where wr_is_comment = '1'";
// $my_cmt_qry="select * from g4_write_$row[bo_table] where wr_comment < '0' and mb_id = '$member[mb_id]'";
$my_cmt_qry="select * from {$g4[write_prefix]}{$row[bo_table]} where wr_is_comment = '1' and mb_id = '$member[mb_id]'";
$cmt=sql_query($cmt_su_qry);
// $total_cmt = mysql_num_rows($cmt) - mysql_num_rows($gul); //게시판코멘트수
$total_cmt = mysql_num_rows($cmt); //게시판코멘트수
$my_all_cmt = $my_all_cmt+$total_cmt; //내가쓴게시판코멘트수
$my_cmt=sql_query($my_cmt_qry);
$my_cmt = mysql_num_rows($my_cmt); //전체게시판코멘트수
$all_my_cmt = $all_my_cmt+$my_cmt; //내가쓴전체게시판코멘트수
//echo $total_cmt." : ".$my_all_cmt." : ".$my_cmt." : ".$all_my_cmt." : ";
@$my_cmt_per = ( $my_cmt / $total_cmt )*100;
$my_cmt_per = intval($my_cmt_per);
@$tot_my_cmt_per = ( $all_my_cmt / $my_all_cmt )*100;
$tot_my_cmt_per = intval($tot_my_cmt_per);
?>
<!-- 전체게시물 목록보이기 -->
<tr>
<td align=left bgColor="" style='padding:2 0 0 4;font-family:;font-size:12px;'>
<a href='../<?=$g4[bbs]?>/board.php?bo_table=<?=$row[bo_table]?>' onfocus=this.blur();><B><?=$row[bo_subject]?></B></a>
</td>
<td align="right" style='font-family:tahoma,Verdana;color:000000;font-size:10px;font-weight:bold;padding:0 4 0 0;'>
<?=$total_gul?>
</td>
<td align="right" style='font-family:tahoma,Verdana;color:EF5900;font-size:10px;font-weight:bold;padding:0 4 0 0;'>
<?=$my_post?> <span style='font-family:tahoma,Verdana;font-size:9px;color:999999;font-weight:bold;'>post</span><br>
</td>
<td align="right" style='font-family:tahoma,Verdana;color:000000;font-size:10px;font-weight:bold;'>
<?=$my_post_per?>%
</td>
<td align="right" style='font-family:Verdana;font-size:;color:;padding:4;'>
<img src="<?=$g4[path]?>/image/piegraph/<?=$my_post_per?>.png" align="middle">
</td>
<td align="right" style='font-family:tahoma,Verdana;color:000000;font-size:10px;font-weight:bold;padding:0 4 0 0;'>
<?=$total_cmt?>
</td>
<td align="right" style='font-family:tahoma,Verdana;color:EF5900;font-size:10px;font-weight:bold;padding:0 4 0 0;'>
<?=$my_cmt?> <span style='font-family:tahoma,Verdana;font-size:9px;color:999999;font-weight:bold;'>comment</span>
</td>
<td align="right" style='font-family:tahoma,Verdana;color:000000;font-size:10px;font-weight:bold;'>
<?=$my_cmt_per?>%
</td>
<td align="right" style='font-family:Verdana;font-size:;color:;padding:4;'>
<img src="<?=$g4[path]?>/image/piegraph/<?=$my_cmt_per?>.png" align="middle">
</td>
</tr>
<!-- 전체게시물 목록보이기 -->
<tr><td colspan="9" bgColor=E9E9E9 height=1></td></tr>
<?
}
?>
<tr><td colspan="9" height="1" bgcolor=666666></td></tr>
<tr>
<td align="left" style='font-family:Verdana;font-size:12px;padding:4 0 4 4;color:000000;font-weight:;'>
<b>전체현황</b>
</td>
<td align="left" style='font-family:Verdana;font-size:12px;padding:4 0 4 4;color:000000;font-weight:;'>
<B><?=$my_all_gul?></B>
</td>
<td align="right" style='font-family:tahoma,Verdana;font-size:12px;padding:0 4 0 0;color:EF5900;font-weight:bold;'>
<?=$all_my_post?> <span style='font-family:tahoma,Verdana;font-size:9px;color:999999;font-weight:bold;'>post</span>
</td>
<td align="right" style='font-family:tahoma,Verdana;font-size:12px;padding:4 0 4 4;color:000000;font-weight:bold;'>
<?=$tot_my_post_per?>%
</td>
<td align="right" style='font-family:Verdana;font-size:10px;color:ffffff;font-weight:bold;padding:4;'>
<img src="<?=$g4[path]?>/image/piegraph/<?=$tot_my_post_per?>.png">
</td>
<td align="right" style='font-family:tahoma,Verdana;font-size:12px;padding:0 4 0 0;color:000000;font-weight:bold;'>
<?=$my_all_cmt?>
</td>
<td align="right" style='font-family:tahoma,Verdana;font-size:12px;padding:0 4 0 0;color:EF5900;font-weight:bold;'>
<?=$all_my_cmt?> <span style='font-family:tahoma,Verdana;font-size:9px;color:999999;font-weight:bold;'>comment</span>
</td>
<td align="right" style='font-family:tahoma,Verdana;font-size:12px;padding:4 0 4 4;color:000000;font-weight:bold;'>
<?=$tot_my_cmt_per?>%
</td>
<td align="right" style='font-family:Verdana;font-size:10px;color:ffffff;font-weight:bold;padding:4;'>
<img src="<?=$g4[path]?>/image/piegraph/<?=$tot_my_cmt_per?>.png">
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<br>
<?
include_once("$g4[path]/tail.php");
?>
=============================================================================
코멘트 내용대로 수정하니 잘 되네요..
답변 감사드립니다...
답변 감사드립니다...