페이지뷰.. 소스 문의 채택완료

안녕하세요..(--)(__)
아래 소스는 사이트맵 소스입니다..
이중.. 페이지뷰 소스만 따로 뽑을려고하니.. 잘 안되네요...
예>게시판명 오늘등록글(1)/전체글(3158)/총열람수(44,041)
위 소스만 뽑을려고 하고든여.. 다른소스는 필요없어서여..
혹시 가능할까요? 몇칠째.. 이리저리 소스 지우고 해봐도 잘 안되네요...
 
 
Copy
<?include_once("./_common.php");
$g4[title] = "사이트맵";
include_once("$g4[path]/_head.php");
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가
$row_my=array();   $sql2 = "select gr_id,bo_table,bo_subject from $g4[board_table] where bo_table !='datatest' order by gr_id,bo_table";   $result2 = sql_query($sql2);     for($mi=0; $row2=sql_fetch_array($result2); $mi++){       $tmp_write_table ="";    $tmp_write_table = $g4[write_prefix] . $row2[bo_table];    $sql3 = "select * from $tmp_write_table where wr_is_comment = 0 order by wr_id";   //원글만      $result3 = sql_query($sql3);    $old_res_cnt=$res_cnt; $tmp_res_cnt="";       $tmp_res_cnt=mysql_num_rows($result3); //게시판별 구한수    $res_cnt=$old_res_cnt+$tmp_res_cnt;    $old_wr_hit=$res_wr_hit;     $res_wr_hit="";       $tmp_wr_hit=@mysql_result(@mysql_query("select sum(wr_hit) from $tmp_write_table"),0,0);               $res_wr_hit=$old_wr_hit+$tmp_wr_hit;    $res_wr_hit1=number_format($res_wr_hit);   }//for  
$time = date("Y-m-d"); $target1 = "1";$target = "0";//지정일(지정일 이후에 등록된 글만 추출하기 위함(by nasca)    $duration = date("Y-m-d", $g4[server_time] - ($target * 86400));    $duration1 = date("Y-m-d", $g4[server_time] + ($target1 * 86400));$sql = " select count(bn_id) as cnt from $g4[board_new_table]              where bn_datetime between '$duration' and '$duration1'              order by bn_datetime "; $row = sql_fetch($sql); 
$width= "97%";?>
<table width='678' cellpadding='0' cellspacing='0' border='0'> <tr>  <td><img src='<?=$g4['path']?>/img/out_bco01.gif' width='7' height='6'></td>  <td background='<?=$g4['path']?>/img/out_bbg01.gif'></td>  <td><img src='<?=$g4['path']?>/img/out_bco02.gif' width='6' height='6'></td> </tr> <tr><td background='<?=$g4['path']?>/img/out_bbg02.gif' ></td>  <td>   <table width='665' cellpadding='0' cellspacing='0' border='0'>    <tr>     <td>      <table width='97%' cellpadding='0' cellspacing='0' border='0' align='center'>       <tr>        <td height='20' align='right' valign='bottom'><a href='<?=$g4['path'];?>/'><img src='<?=$g4['path']?>/img/icon_home.gif' width='38' height='15' align='absmiddle' border='0'></a> ><?=$g4['title']?></td>       </tr>       <tr>        <td align='left'><img src='<?=$g4['path']?>/img/sitemap.gif'></td>       </tr>       <tr><td height='20'></td></tr>      </table>     </td>    </tr>   </table>  
ㆍ<span class='' style='#666666;'> 게시판명 <font color=red> 오늘등록글(<?=$row[cnt]?>)</font>/전체글(<?=$res_cnt?>)/<font color=blue>총열람수(<?=$res_wr_hit1?>)</font></span><table width="<?=$width?>" height="380" cellpadding=0 cellspacing=0 align="center" border="0"><tr><td bgcolor="#CCCCCC" height="1"></td></tr><tr><td height="20"></td></tr><tr><td valign="top">
<table width="100%" cellpadding="0" cellspacing="0" border="0" ><tr><? $cells = 0; 
switch(true) { case $member[mb_level] <= 4 : // 정회원 5 미만일때  $except="'member','content'"; // 제외 그룹  break; case $member[mb_level] <= 5 : // 정회원일때  $except="'content'"; // 제외그룹  break; default:  $except="''";}
$sql = " select  gr_id, gr_subject from $g4[group_table] where gr_id not in ($except) order by gr_subject desc ";$rst1 = sql_query($sql);
while ($row=sql_fetch_array($rst1)) {
 if($cells%3==0) echo "</tr><tr>";
 echo "<td width='33%' valign='top' align='center'>"; echo "<table width='179' height='100%' cellpadding='0' cellspacing='0' border='0'>"; echo "<tr><td background='$g4[path]/img/sitemap_bg1.gif' width='179' height='42' style='padding-left:22px;'><img src='$g4[path]/img/38.gif' align='absmiddle'>&nbsp;&nbsp;<strong>$row[gr_subject]</strong></td></tr></table><table width='190' height='100%' cellpadding='0' cellspacing='0' border='0'>"; // 그룹명 출력
 $sql2 = " select bo_8, bo_table, bo_subject,bo_count_write from $g4[board_table] where gr_id = '$row[gr_id]' order by bo_order_search "; $rst2 = sql_query($sql2); $cells++; while ($row2=sql_fetch_array($rst2)) {  $time = date("Y-m-d");     $target1 = "1";    $target = "0";//지정일(지정일 이후에 등록된 글만 추출하기 위함(by nasca)    $duration = date("Y-m-d", $g4[server_time] - ($target * 86400));    $duration1 = date("Y-m-d", $g4[server_time] + ($target1 * 86400));    $sql3 = " select count(*) as cnt from $g4[write_prefix]$row2[bo_table] where wr_datetime between '$duration' and '$duration1'  ";                   $row3 = sql_fetch($sql3);   $tmp_wr_hit=@mysql_result(@mysql_query("select sum(wr_hit) from $g4[write_prefix]$row2[bo_table]"),0,0);  if ($row3[cnt] > 0)   $new = "<span class='' style='color:#666666;'>(<font color=red>$row3[cnt]</font>/$row2[bo_count_write]/<font color=blue>$tmp_wr_hit</font>) <img src='$g4[path]/img/icon_new.gif'> </span>&nbsp;"; // new 아이콘  else   $new = "<span class='' style='#666666;'>(<font color=red>$row3[cnt]</font>/$row2[bo_count_write]/<font color=blue>$tmp_wr_hit</font>) </span>"; //new 아이콘 없음 echo "<tr><td style='padding-left:0px; height:26px;'>ㆍ<a href='$g4[bbs_path]/board.php?bo_table=$row2[bo_table]'>$row2[bo_subject]</a>$new <br /></td>"; echo "<tr><td height='1' bgcolor='#E9E9E9'></td></tr>"; } echo "<tr><td height='20'></td></tr></table>"; echo "</td>";}?></tr></table> </td></tr><tr><td height="10"></td><tr><tr><td bgcolor="#E9E9E9" height="1"></td></tr><tr><td height="10"></td><tr></table>
  </td>  <td background="<?=$g4['path']?>/img/out_bbg03.gif"></td> </tr> <tr>  <td><img src="<?=$g4['path']?>/img/out_bco03.gif" width="7" height="6"></td>  <td background="<?=$g4['path']?>/img/out_bbg04.gif"></td>  <td><img src="<?=$g4['path']?>/img/out_bco04.gif" width="6" height="6"></td> </tr></table>
<?include_once("$g4[path]/_tail.php"); ?>

답변 1개

채택된 답변
+20 포인트
Copy
<?php
include_once("./_common.php");
$row_my=array();  $sql2 = "select gr_id,bo_table,bo_subject from $g4[board_table] where bo_table !='datatest' order by gr_id,bo_table";  $result2 = sql_query($sql2);  for($mi=0; $row2=sql_fetch_array($result2); $mi++){  $tmp_write_table ="";  $tmp_write_table = $g4[write_prefix] . $row2[bo_table];  $sql3 = "select * from $tmp_write_table where wr_is_comment = 0 order by wr_id"; //원글만  $result3 = sql_query($sql3);  $old_res_cnt=$res_cnt; $tmp_res_cnt="";  $tmp_res_cnt=mysql_num_rows($result3); //게시판별 구한수  $res_cnt=$old_res_cnt+$tmp_res_cnt;  $old_wr_hit=$res_wr_hit; $res_wr_hit="";  $tmp_wr_hit=@mysql_result(@mysql_query("select sum(wr_hit) from $tmp_write_table"),0,0);  $res_wr_hit=$old_wr_hit+$tmp_wr_hit;  $res_wr_hit1=number_format($res_wr_hit);  }//for 
$target1 = "1";$target = "0";//지정일(지정일 이후에 등록된 글만 추출하기 위함(by nasca) $duration = date("Y-m-d", $g4[server_time] - ($target * 86400)); $duration1 = date("Y-m-d", $g4[server_time] + ($target1 * 86400));$sql = " select count(bn_id) as cnt from $g4[board_new_table] where bn_datetime between '$duration' and '$duration1' order by bn_datetime "; 
?>
오늘등록글(<?=$row[cnt]?>)
전체글(<?=$res_cnt?>)총열람수(<?=$res_wr_hit1?>)
로그인 후 평가할 수 있습니다

댓글을 작성하려면 로그인이 필요합니다.

답변을 작성하려면 로그인이 필요합니다.

로그인
🐛 버그신고