페이지뷰.. 소스 문의 채택완료
안녕하세요..(--)(__)
아래 소스는 사이트맵 소스입니다..
이중.. 페이지뷰 소스만 따로 뽑을려고하니.. 잘 안되네요...
예>게시판명 오늘등록글(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'> <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> "; // 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 포인트
불량학생™
11년 전
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?>)
로그인 후 평가할 수 있습니다
댓글을 작성하려면 로그인이 필요합니다.
답변을 작성하려면 로그인이 필요합니다.
로그인