include "_conf.html";
$countsql = "select count(uid) from $tablename where Ncode = '$Ncode' and notice != 'y'";
$sql = "select * from $tablename where Ncode = '$Ncode' and notice != 'y'";
if($keyword) {
$countsql.=" and $keyfield like '%$keyword%'";
$sql.=" and $keyfield like '%$keyword%'";
}
$p_val = "Ncode=$Ncode";
$rs_count = @mysql_query($countsql);
$rscount = @mysql_fetch_row($rs_count);
$totcount = $rscount[0];
$block_size = 10;
$reply_indent = 5;
$notify_new_article = 3; //new ¾ÆÀÌÄÜÃâ·Â
$time_limit = $notify_new_article*60*60*24;
page_var();
if($totcount > 0) {
$sql .= " order by fid desc, thread asc limit $first, $page_size";
$result = @mysql_query($sql);
$i = 0;
while($row = @mysql_fetch_array($result)) {
$viewno = $totcount - ($i+(($page-1)*$page_size)); //ÃÖ±Ù ¿Ã¶ó¿Â °Ô½Ã¹° °¡»ó¹øÈ£
if($viewno%2==0) $trbg = "ffffff";
else $trbg = $tr_color;
$signdate = date("y-m-d",$row[signdate]);
$list .= "
$viewno |
";
$spacer = strlen($row[thread])-1;
if($spacer > $reply_indent) $spacer = $reply_indent;
for($j = 0; $j < $spacer; $j++) {
$list .=" ";
}
if($spacer) $list.="¦± ";
$subject = $row[subject];
if($keyword) $subject = str_replace("$keyword","$keyword",$subject);
if($row[open]=="n") $list.="".text_cut($subject,70)."";
else $list.="".text_cut($subject,70)."";
$comsql = @mysql_query("select count(*) from redcomment where Ncode = '$Ncode' and uid = '$row[uid]'");
if(@mysql_num_rows($comsql) > 0) {
$commentcount = @mysql_result($comsql,0,0);
if($commentcount > 0) $list.=" [".$commentcount."]";
}
$date_diff = time() - $row[signdate];
if($date_diff < $time_limit) $list.=" ";
if($row[open]=="n") $list.=" ";
if($row[userfile]) $list.=" ";
$list.=" | ";
$list.="$row[name] | ";
$list.="$signdate | ";
$list.="$row[ref] | ";
$list.="
";
$list.=" |
";
$i++;
} // while end
} else $list.="µî·ÏµÈ °Ô½Ã¹°ÀÌ ¾ø½À´Ï´Ù. |
";
include "_headtop.html";
?>
height=25>
|
Á¦¸ñ |
±Û¾´ÀÌ |
³¯Â¥ |
Á¶È¸ |
$sql = @mysql_query("select * from $tablename where Ncode = '$Ncode' and thread = 'A' and notice = 'y'");
while($row = @mysql_fetch_array($sql)) {
$signdate = date("y-m-d",$row[signdate]);
echo"";
echo" | ";
echo"".$row[subject]."";
echo" | ";
echo"".$row[name]." | ";
echo"".$signdate." | ";
echo"".$row[ref]." | ";
echo"
";
echo" |
";
}
?>
=$list?>
$page_val = "$PHP_SELF?$p_val";
page_view();
?>
|
|
1) {?>
|
}?>