@recentarticle.txt

php写的论坛,代码精简到极点 请相看说明文件。是从英文翻译过来的：）

<!--***************************************************************************************

			n@board 3 It is the recent article abstraction source.
			Change according to your establishment and use.


****************************************************************************************-->




<?
//////////////////////////////DB connecting part. Record your mysql establishment.
//////////////////////////////This paragraph records once on the sauce top portion.

$connect_host=	"localhost";	// Type Your Mysql-Database host's URL (Mostly it's "localhost".)
$connect_id=	"";		// Type Your Mysql-Database ID
$connect_pass=	"";		// Type Your Mysql-Database Password
$connect_db=	"";		// Type Your Mysql-Database Name

$connect=@mysql_connect($connect_host,$connect_id,$connect_pass);@mysql_select_db($connect_db,$connect);

////////////////////////////////////function
function cuting($str,$max){ 
$count = strlen($str); 
if($count >= $max) { 
for ($pos=$max;$pos>0 && ord($str[$pos-1])>=127;$pos--); 
if (($max-$pos)%2 == 0) 
$str = substr($str, 0, $max) . "..."; 
else 
$str = substr($str, 0, $max+1) . "..."; 
return $str;
} 
else { 
$str = "$str"; 
return $str;
} 
}
//////////////////////////////DB connecting part. Record your mysql establishment.
//////////////////////////////This paragraph records once on the sauce top portion.
?>





<table border=1 width=400 cellpadding=1 cellspacing=0>
<?
//////////////////////////////There is the recent article output part. Record board name to bring.
//////////////////////////////When board to bring is a several num, change board name of this paragraph 
//////////////////////////////record several times.

$bd=	"";			//board name
$limit=	"10";			//num to bring
$date=	"[m-d]";		//Form date to mark (Y:4 indecated year, y:2 indecated year, m:month, d:date, H:hour, i:monute, s:sec)
$skin=	"skin/navyism";		//skin directory
$length=40;			//subject length


$today=date('[m-d]');
$result=@mysql_query("select * from na3_board_$bd order by no desc limit $limit",$connect);
while($data=@mysql_fetch_array($result)){
if($data[step]){$re="<img src=$skin/mark_re.gif border=0> ";}else{$re="";}
$data[date]=date($date,$data[date]);
$data[title]=cuting($data[title],$length);
$data[title]=stripslashes($data[title]);
$data[name]=stripslashes($data[name]);

//////////////////////////////new mark setting
if($today==$data[date]){$mark="<img src=$skin/mark_new.gif border=0 align=absmiddle>";}
else{$mark="<img src=$skin/mark_old.gif border=0 align=absmiddle>";}
if($data[abs]==-2147483648){$mark="<img src=$skin/mark_notice.gif border=0 align=absmiddle>";}

//////////////////////////////count comment
$com=mysql_fetch_array(mysql_query("select count(*) from na3_comment_$bd where no=$data[no]",$connect));
$com=$com["count(*)"];if(!$com){$com="";}else{$com="<font size=1>[$com]</font>";}

//////////////////////////////If mark category name, remove // front of lower line.
//$category=mysql_fetch_array(mysql_query("select * from na3_cat_$bd where no='$data[cat]'",$connect));$data[cat_name]=$category[name];

//////////////////////////////There is output part.
echo"
<tr>
<td>$data[date]</td>
<td>$mark $re <a href=memo.php?bd=$bd&no=$data[no]>$data[title]</a> $com</td>
<td>$data[name]</td>
</tr>
";
}
?>
</table>




<!--***************************************************************************************

				Recently article output item explanation

$data[id]		 : article writer's ID (In case of member, indication)
$data[name]		 : article writer's name 
$data[memo]		 : article 
$data[home] 		 : article writer's homepage address
$data[mail]		 : article writer's email address
$data[title]		 : article title
$data[date]		 : written date (UNIX timestemp type)
$data[hit]		 : hit num
$data[ip]		 : article writer's IP
$data[cat_name]		 : category name (Necessity that is established)
$data[step]		 : If is reply writing, output number not to be 0
$data[secret]		 : If is secret writing, output number 1
$data[attach_name]	 : Appending file name (position : File/appended file folder/appending file name)
$data[attach_dir]	 : Appended file folder
$data[attach_size]	 : Appended file size
$data[attach_hit]	 : Appended file down load number
$data[attach2_name]	 : Appending file2 name (position : File/appended file2 folder /appending file name)
$data[attach2_dir]	 : Appended file2 folder 
$data[attach2_size]	 : Appended file2 size
$data[attach2_hit]	 : Appended file2 down load number
$data[link]		 : link address
$data[link_hit]		 : link address hit num
$data[link2]		 : link 2 address
$data[link2_hit]	 : link 2 address hit num
$data[vote]		 : Number of recommendation

****************************************************************************************-->