|
|
";
}
else {
$orderby_sql = " order by id1 desc " ;
$query_sql =" select max(results.id1) as maxid1, min(results.id1) as minid1 from " ;
$query_sql .=" ( select t2.* , rownum rownumber from ";
$query_sql .=" ( select distinct id1 from bbs_posts t ".$where_sql.$orderby_sql." ) t2 ) results ";
$query_sql .=" where results.rownumber between " .(($page-1)*$RowsPerPage+1)." and ".( $page*$RowsPerPage );
$hstrSql= OCIParse($oraconn,$query_sql);
$hret = ociexecute($hstrSql);
ocifetch($hstrSql);
$maxid1= ociresult($hstrSql,"MAXID1");
$minid1= ociresult($hstrSql,"MINID1");
OCIFreeStatement($hstrSql);
$query_sql = " select id, id1, length(ltrim(id2)) as id2l, title, contentsize as len,
author, authorid, nviewed, to_char(postat,'yyyy-mm-dd hh24:mi:ss') postat , vote from bbs_posts $where_sql
and id1<=$maxid1 and id1>=$minid1 order by id1 desc, id2 ";
?>
|
|
";
}
echo " ";
$hstrSql= OCIParse($oraconn,$query_sql);
$hret = ociexecute($hstrSql);
while( ocifetch($hstrSql)) {
$title = OCIresult($hstrSql,"TITLE");
$author = OCIresult($hstrSql,"AUTHOR");
$id = OCIresult($hstrSql,"ID");
$id2l = OCIresult($hstrSql,"ID2L");
$id2s = "";
if(($digest!=1)||(!strlen($search_val)>0)) {
for( $i=0; $i<$id2l; $i++ ) $id2s = $id2s." ";
} /* end of (...)*/
if($usermode==1)
$newsubject="";
else $newsubject="";
$postat = OCIresult($hstrSql,"POSTAT");
$date_time_string = $postat ;
$dt_elements = explode(" " ,$date_time_string);
$date_elements = explode("-" ,$dt_elements[0]);
$time_elements = explode(":" ,$dt_elements[1]);
$postat = mktime ($time_elements [0], $time_elements[1], $time_elements[2], $date_elements[1], $date_elements[2], $date_elements[0]);
$nviewed = OCIresult($hstrSql,"NVIEWED") ;
$lens = OCIresult($hstrSql,"LEN") ;
$lens = ( $lens==0 ? "0" : "$lens" );
if( ((time()-$postat)/3600/24) < 1) {
$newfont="☆";
}
else {
$newfont="·";
}
$postat = date("n月j日G:i:s",$postat);
echo "
|
$newsubject$id2s$newfont$title |
<$lens 字节> |
$author |
$postat |
[点数:$nviewed] |
" ;
} /*end of while(....)*/
echo " ";
OCIFreeStatement($hstrSql);
if($usermode==1)
echo "
";
?>
|
|
|
";
if($digest>0) { ?>
如果您的文章被推荐累计积分达到30，将会成为精品文章；
精彩文章还有可能被管理员直接推荐为精品文章呢！所以，一定要努力呦！
|
|