카운터가 항상 보이게 할려면 어떻게..다른질문 연재에서... > 그누3질답

관리자 홈페이지 자기소개 아이디로 검색 회원게시물

(211.♡.♡.211) 03.10.24 12:26:24

감사합니다 아주 잘 됩니다.^^

(220.♡.♡.201) 03.10.24 12:17:23

$ca_name = get_category_name($cfg[write_table_prefix].$value[table], $value[ca_id]);
이렇게 수정해 보세요.

(211.♡.♡.211) 03.10.24 12:14:01

소스 전체....(수정본)

<?
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가

define("_DOCTYPE_", "DESIGN");

$html_title = "선장/점주 연락처 및 출항지";
?>

<table width=100% cellpadding=0 cellspacing=0>
<tr><td height=1 background='./bbs/line.gif'></td></tr>
<tr class='subject subjectbg ht'><td colspan=2> 선장/점주 연락처</td></tr>
<tr><td height=1 background='./bbs/line.gif'></td></tr>
<?
$max_i = 30; // 출력갯수
$wtime = date("Y-m-d H:i:s", time()-86400*14);
$arr_series = array("s_connects", "s_connects");
for ($i=0; $i<count($arr_series); $i++) {
$sql = " select ca_id, wr_id, wr_subject, wr_datetime, wr_commentcnt from $cfg[write_table_prefix]{$arr_series[$i]} where wr_comment = 0 and wr_datetime > '$wtime'";
$result = sql_query($sql);
while ($row=mysql_fetch_array($result)) {
$aseries[$row[wr_datetime].$arr_series[$i]][table] = $arr_series[$i];
$aseries[$row[wr_datetime].$arr_series[$i]][datetime] = $row[wr_datetime];
$aseries[$row[wr_datetime].$arr_series[$i]][id] = $row[wr_id];
$aseries[$row[wr_datetime].$arr_series[$i]][subject] = $row[wr_subject];
$aseries[$row[wr_datetime].$arr_series[$i]][cnt] = $row[wr_commentcnt];
$aseries[$row[wr_datetime].$arr_series[$i]][ca_id] = $row[ca_id];
}
}

@krsort($aseries);
$xtime = date("Y-m-d H:i:s", time()-86400*3);
$i=0;
foreach ($aseries as $key=>$value) {
if ($i++ >= $max_i) break;
$subject = conv_subject($value[subject], 60,"…");
$new = "";
if ($value[datetime] > $xtime) {
$new = "<img src='$latest_skin/icon_new.gif' align=absmiddle> ";
}
$cnt = "";
if ($value[cnt]) {
$cnt = " ($value[cnt])";
}
$ca_name = get_category_name($value[table], $value[ca_id]);
echo "<tr><td height=22> [$ca_name] $new<a href='./?doc=$cfg[bbs_dir]/gnuboard.php&bo_table=$value[table]&wr_id=$value[id]'>$subject$cnt</a></td></tr>";
}
?>
</table>

소스 전체....(수정본)

&lt;? 
if (!defined(&#034;_GNUBOARD_&#034;)) exit; // 개별 페이지 접근 불가

define(&#034;_DOCTYPE_&#034;, &#034;DESIGN&#034;);

$html_title = &#034;선장/점주 연락처 및 출항지&#034;; 
?&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  &lt;!-- 여러개의 테이블에서 출력하기 --&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  &lt;table width=100% cellpadding=0 cellspacing=0&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  &lt;tr&gt;&lt;td height=1 background=&#039;./bbs/line.gif&#039;&gt;&lt;/td&gt;&lt;/tr&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  &lt;tr class=&#039;subject subjectbg ht&#039;&gt;&lt;td colspan=2&gt; 선장/점주 연락처&lt;/td&gt;&lt;/tr&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  &lt;tr&gt;&lt;td height=1 background=&#039;./bbs/line.gif&#039;&gt;&lt;/td&gt;&lt;/tr&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  &lt;? 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  $max_i = 30; // 출력갯수 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  $wtime = date(&#034;Y-m-d H:i:s&#034;, time()-86400*14); 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  $arr_series = array(&#034;s_connects&#034;, &#034;s_connects&#034;);
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  for ($i=0; $i&lt;count($arr_series); $i++) { 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  $sql = &#034; select ca_id, wr_id, wr_subject, wr_datetime, wr_commentcnt from $cfg[write_table_prefix]{$arr_series[$i]} where wr_comment = 0 and wr_datetime &gt; &#039;$wtime&#039;&#034;; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  $result = sql_query($sql); 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  while ($row=mysql_fetch_array($result)) { 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  $aseries[$row[wr_datetime].$arr_series[$i]][table]&nbsp; &nbsp; = $arr_series[$i]; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  $aseries[$row[wr_datetime].$arr_series[$i]][datetime] = $row[wr_datetime]; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  $aseries[$row[wr_datetime].$arr_series[$i]][id]&nbsp; &nbsp; &nbsp;  = $row[wr_id]; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  $aseries[$row[wr_datetime].$arr_series[$i]][subject]&nbsp; = $row[wr_subject]; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  $aseries[$row[wr_datetime].$arr_series[$i]][cnt]&nbsp; &nbsp; &nbsp; = $row[wr_commentcnt]; 
		&nbsp; &nbsp; &nbsp;  $aseries[$row[wr_datetime].$arr_series[$i]][ca_id]&nbsp; &nbsp; = $row[ca_id];
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  } 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  }

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  @krsort($aseries); 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  $xtime = date(&#034;Y-m-d H:i:s&#034;, time()-86400*3); 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  $i=0; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  foreach ($aseries as $key=&gt;$value) { 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  if ($i++ &gt;= $max_i) break; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  $subject = conv_subject($value[subject], 60,&#034;…&#034;); 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  $new = &#034;&#034;; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  if ($value[datetime] &gt; $xtime) { 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  $new = &#034;&lt;img src=&#039;$latest_skin/icon_new.gif&#039; align=absmiddle&gt; &#034;; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  } 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  $cnt = &#034;&#034;; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  if ($value[cnt]) { 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  $cnt = &#034; ($value[cnt])&#034;; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  } 
		&nbsp;  $ca_name = get_category_name($value[table], $value[ca_id]);
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  echo &#034;&lt;tr&gt;&lt;td height=22&gt; [$ca_name] $new&lt;a href=&#039;./?doc=$cfg[bbs_dir]/gnuboard.php&bo_table=$value[table]&wr_id=$value[id]&#039;&gt;$subject$cnt&lt;/a&gt;&lt;/td&gt;&lt;/tr&gt;&#034;; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  } 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  ?&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  &lt;/table&gt;

(211.♡.♡.211) 03.10.24 12:11:55

이런 애러가 뜨네요
select ca_name from s_connects_cat where ca_id = '6'
1146 : Table 'xxxxx.s_connects_cat' doesn't exist
ㅡ,.ㅡ

까만도둑 홈페이지 자기소개 아이디로 검색 회원게시물

(211.♡.♡.211) 03.10.24 11:48:50

언제나 빠른 답변 감사합니다.^^

까만도둑 홈페이지 자기소개 아이디로 검색 회원게시물

(61.♡.♡.146) 03.10.24 11:46:53

제가 올린 질문을 해결해야겠기에.........
어쩔 수 없었습니다.
또다시 오늘은 본업을 접어야 될지도.....

얼른 아래 질문 갈켜주세요. ^^

Z 이름으로 검색 (61.♡.♡.80) 03.10.24 11:41:54

도둑님 낮에는 안나타 나기로 하시구선.. 어쩐 일이십니까!

관리자 홈페이지 자기소개 아이디로 검색 회원게시물

(61.♡.♡.146) 03.10.24 11:38:37

카운트는 bbs/count.cfg.php 파일을 손 보시면 됩니다.