;;;;$str=ereg_replace("-","/",$str);
;;;;$str=substr($str,5,strlen($str)-8);
;;;;return $str;
}
function reAnum($sid){ //羆莱絞计
;;;;$DROOT=getenv('DOCUMENT_ROOT');
;;;;include("sql.php3");
;;;;$db=mysql_connect($sql['host'], $sql['user'] , $sql['passwd']);;;
;;;;$qsql="SELECT id from bbs_docs where sid='$sid'"
;;;;$rs=mysql_db_query($sql['db'],$qsql);
;;;;return mysql_num_rows($rs);
}
function pagebar($pages) {
;;;;global $pgno;
;;;;//global $pages;
;;;;global $PHP_SELF;
;;;;global $aid;
;;;;global $OPEN_LIST;
;;;;echo "<TABLE width=85% border=0 cellPadding=0 cellSpacing=1 align=center bgcolor='#6CA6CD' class='num'>"
;;;;echo "<tr><td>"
;;;;if($pgno!=0) {
$pu=$pgno-1;
echo "<a href=$PHP_SELF?aid=$aid&pgno=$pu>[]</a>";;
;;;;};;;;;
;;;;if($pgno<$pages) {
$pd=$pgno+1;
echo "<a href=$PHP_SELF?aid=$aid&pgno=$pd>[]</a>";;
;;;;};;;;;
;;;;for($i=0;$i<=$pages;$i++) {
if($pgno==$i) {
;;;;echo "<b>"
;;;;echo "[".($i+1)."]"
;;;;echo "</b>";;;;;;
} else {
;;;;echo "<a href=$PHP_SELF?aid=$aid&pgno=$i>"
;;;;echo "[".($i+1)."]"
;;;;echo "</a>";;;;;;
}
;;;;}
;;;;echo "</td>"
;;;;echo "<TD align=right>"
echo "<a href=$PHP_SELF?proc=view&aid=$aid>"
echo "[祇ゅ彻]"
echo "</a>"
;;;;//echo "</TD>"
;;;;//echo "<TD align=right>"
;;;;if($OPEN_LIST) {
echo "<a href=$PHP_SELF?proc=colloff&aid=$aid&pgno=$pgno>"
echo "[ぃ甶秨杠肈]"
echo "</a>"
;;;;}else {
echo "<a href=$PHP_SELF?proc=collon&aid=$aid&&pgno=$pgno>"
echo "[甶秨杠肈]"
echo "</a>"
;;;;}
;;;;echo "</TD>";;
;;;;echo "</tr></table>";;;;;;
;;;;;
}
//===============================================================================
function openlist($sid) {
;;;;global $aid;
;;;;global $PHP_SELF;
;;;;;
;;;;$DROOT=getenv('DOCUMENT_ROOT');
;;;;include("sql.php3");
;;;;$db=mysql_connect($sql['host'], $sql['user'] , $sql['passwd']);;;
;;;;$qsql="SELECT * from bbs_docs where sid='$sid' order by wdate"
;;;;$rs=mysql_db_query($sql['db'],$qsql);
;;;;//if(mysql_num_rows($rs)==0) return;
;;;;//echo;;mysql_num_rows($rs);
;;;;while($row=mysql_fetch_array($rs)) {
$id=$row['id'];
;;;;$banner=$row['banner'];
;;;;$poster=$row['poster'];
;;;;$views=$row['views'];
;;;;$wdate=sdatetime($row['wdate']);
;;;;;
;;;;echo "<tr bgcolor='#F0F0F0'>"
echo "<td>"
;;;;echo "<a href=$PHP_SELF?proc=view&aid=$aid&sid=$sid&rid=$id>"
;;;;echo " <font color=#836FFF>$banner</font>"
;;;;echo "</a>"
;;;;//echo "banner is $banner"
echo "</td>"
echo "<td>"
;;;;echo $poster;
echo "</td>"
echo "<td class='num'>"
;;;;echo " "
echo "</td>"
echo "<td class='num'>"
;;;;echo $views;
echo "</td>"
echo "<td class='num'>"
;;;;echo $wdate;
echo "</td>"
;;;;;
;;;;echo "</tr>"
;;;;}
;;;;;
}
//========================================================================
function area() {
;;;;global $PHP_SELF;
;;;;global $aid,$sid,$pgno;
;;;;global $OPEN_LIST;
;;;;$showitems=20;
;;;;$DROOT=getenv('DOCUMENT_ROOT');
;;;;include("sql.php3");
;;;;$db=mysql_connect($sql['host'], $sql['user'] , $sql['passwd']);;;
;;;;//============================================================
;;;;if(!$aid) {
;;$qsql="SELECT id from bbs_area"
;;$rs=mysql_db_query($sql['db'],$qsql);
;;$row=mysql_fetch_array($rs);
;;$aid=$row['id']
}
;;;;if(!$sid) {
$qsql="SELECT id from bbs_subj where aid=$aid order by wdate DESC"
$rs=mysql_db_query($sql['db'],$qsql);
$row=mysql_fetch_array($rs);
$sid=$row['id'];;;;;;
;;;;};;;;;
;;;;;
;;;;if(!$pgno) {//礚﹚计
//$pgno=0;;;
$items=0;
$qsql="SELECT id from bbs_subj where aid=$aid order by wdate DESC"
$rs=mysql_db_query($sql['db'],$qsql);
while($row=mysql_fetch_array($rs)){
;;;;$id=$row['id'];;;;;;
;;;;if($id==$sid) break;
;;;;$items++;
}
$pgno=(INT)($items/$showitems);;
;;;;}
;;;;;
;;;;//============================================================
;;;;$qsql="SELECT * from bbs_area where id=$aid "
;;;;$rs=mysql_db_query($sql['db'],$qsql);
;;;;$row=mysql_fetch_array($rs);
;;;;$banner=$row['banner'];
;;;;$body=$row['body'];
;;;;$master=$row['master'];
;;;;echo "<center><font color=GREEN size=5><b>$banner</b></font></center>"
;;;;;
;;;;echo "<FORM;;name=mtab;;ENCTYPE=multipart/form-data METHOD=POST ACTION=$PHP_SELF?proc=search>"
;;;;echo "<TABLE width=85% border=0 cellPadding=0 cellSpacing=1 align=center class='tablefont'>"
;;;;;;echo "<tr><td>"
;;;
;;;;;;echo "<input type='hidden' name=aid value='$aid'>";;;;;;
;;;;;;echo "穓碝ゅ彻:"
;;;;;;echo "<INPUT TYPE='TEXT' NAME='key' size=25 class='tablefont'>"
;;;;;;echo "<INPUT TYPE='Submit'value='琩高' class='tablefont'>"
;;;
;;;;;;echo "</td></tr>"
;;;;echo "</table>";;;
;;;;echo "</FORM>";;;
;;;;;
;;;;$qsql="SELECT * from bbs_subj where aid=$aid order by wdate DESC"
;;;;$rs=mysql_db_query($sql['db'],$qsql);
;;;;$all=mysql_num_rows($rs);;;//how rows
;;;;$pages=(INT)($all/$showitems); // how pages
;;;;$pgcount=$pgno*$showitems;
;;;;if($pgcount > $all) {;;
$pgno=$pages-1; // Page point over all pages
$pgcount=$pgno*$showitems;
;;;;;}
;;;;mysql_data_seek($rs, $pgcount);
;;;;$cnt=0;
;;;;pagebar($pages);
;;;;echo "<TABLE width=85% border=0 cellPadding=0 cellSpacing=1 align=center bgcolor='#6CA6CD'>"
;;;;;;echo "<tr><td>"
;;;;;;echo "<TABLE width=100% cellPadding=1 cellSpacing=1 bgcolor=white class='tablefont'>"
echo "<tr bgcolor=#F1E1FF>"
;;;;echo "<th >夹肈</th>"
;;;;echo "<th>祇癬</th>"
;;;;echo "<th width=30>莱</th>"
;;;;echo "<th width=30></th>"
;;;;echo "<th width=70>ら戳</th>"
echo "</tr>"
while($row=mysql_fetch_array($rs)) {
;;;;if(++$cnt > $showitems) break;
;;;;$id=$row['id'];
;;;;$banner=$row['banner'];
;;;;$poster=$row['poster'];
;;;;$views=$row['views'];
;;;;$wdate=sdatetime($row['wdate']);
;;;;$docs=reAnum($id);
;;;;echo "<tr bgcolor='#F0F8FF'>"
echo "<td>"
;;;;echo "<a href=$PHP_SELF?proc=view&aid=$aid&sid=$id&rid=$id>"
if($sid==$id) echo "<font color=red>〈$banner</font>"
else echo $banner;
;;;;echo "</a>"
echo "</td>"
echo "<td>"
;;;;echo $poster;
echo "</td>"
echo "<td class='num'>"
;;;;echo $docs;
echo "</td>"
echo "<td class='num'>"
;;;;echo $views;
echo "</td>"
echo "<td class='num'>"
;;;;echo $wdate;
echo "</td>"
;;;;echo "</tr>"
;;;;if($OPEN_LIST) openlist($id);
}
;;;;;;echo "</td></tr></table>"
;;;;echo"</td></tr></table>"
;;;;;
;;;;pagebar($pages);
}
待续........;
标签：
