function sdatetime（$str）{
$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）;
}
待续........
易网时代-编程资源站