$g4_path = ".."; include_once ("$g4_path/common.php"); include_once("$g4[path]/head.sub.php"); include_once("$g4[path]/head.php"); $g4[title] = "$my_id ´ÔÀÇ °Ô½Ã¹°(ÄÚ¸àÆ®Æ÷ÇÔ) µî·ÏÇöȲ"; $main_width = "98%"; ?> $my_id = $member[mb_name]; if(!$member[mb_id]) { $my_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<>'tretr' 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); ?>
| =$my_id?> ´ÔÀÇ °Ô½Ã¹°(ÄÚ¸àÆ®Æ÷ÇÔ) µî·ÏÇöȲ | ÃÑ post | µî·ÏÇÑ post | ¹éºÐÀ² | ±×·¡ÇÁ | $all_my_post = 0; $mb_num="$mb[mb_num]"; while($row=sql_fetch_array($my_post_rs)) { $i++; //Å×À̺í¼ö //ÄÚ¸àÆ®Æ÷ÇÔ $gul_su_qry="select * from g4_write_$row[bo_table]"; $my_post_qry="select * from g4_write_$row[bo_table] where mb_id = '$member[mb_id]'"; //ÄÚ¸àÆ®¹ÌÆ÷ÇÔ /*$gul_su_qry="SELECT * FROM gb_write_$row[bo_table] where wr_comment = '0'"; $my_post_qry="SELECT * FROM gb_write_$row[bo_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); ?>|
| =$row[bo_subject]?> |
=$total_gul?> post |
=$my_post?> post
|
=$my_post_per?>% |
|
|
| ÃÑ =$i?> °³ÀÇ °Ô½ÃÆÇ | =$my_all_gul?> post | =$all_my_post?> post | =$tot_my_post_per?>% |
|
|